listings

Directory of all local listings (services, people, shops, etc).

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: tags (array)

id ▼ name category_id description phone address latitude longitude geohash tags created_at updated_at verified
1 Iqbal Services 1 electrician-first handyperson who can do a lot of odd-jobs like drilling, plumbing,electrical work etc. +919880990907         ["electrician","plumber","handyman","drilling"]     1
2 Shanti Animals 2 quiet dog that sits next to the cobbler, very friendly     13.003084385772276 77.61653899972441 tdr1ypn7 ["dog","street dog","animal","stray"]     1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE listings (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  category_id INTEGER REFERENCES categories(id),
  description TEXT,
  phone TEXT,
  address TEXT,
  latitude REAL,
  longitude REAL,
  geohash TEXT,
  tags TEXT, -- JSON array of tags
  created_at TEXT DEFAULT CURRENT_TIMESTAMP,
  updated_at TEXT DEFAULT CURRENT_TIMESTAMP,
  verified BOOLEAN DEFAULT 0
);