listings

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

1 row where category_id = 1

✎ 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

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
);