places
Data license: CDLA permissive v2
2 rows where phones contains "+16507261476"
This data as json, CSV (advanced)
Suggested facets: updatetime (date), websites (array), socials (array), phones (array)
| id ▼ | updatetime | version | names | categories | confidence | websites | socials | emails | phones | brand | addresses | sources | bbox | geometry | type | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| tmp_039BEEF8F59786E1C7227BE30EDEA815 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Surf Factory", "local"]}]]} | {"main": "department_store", "alternate": ["fashion", "professional_services"]} | 0.9363334774971008 | ["http://hmbboardshop.com"] | ["https://www.facebook.com/1134810803293680"] | ["+16507261476"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-4043", "270 Capistrano Rd", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "1134810803293680"]}] | {"minx": -122.483796, "maxx": -122.483796, "miny": 37.5042833, "maxy": 37.5042833} | <Binary: 21 bytes> | place | 37.5042833 | -122.483796 | |
| tmp_4F3C6F19B09496FD54030D466EE9CC43 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Half Moon Bay Board Shop", "local"]}]]} | {"main": "active_life", "alternate": ["sporting_goods", "clothing_store"]} | 0.984826922416687 | ["http://mindtrix.com"] | ["https://www.facebook.com/494574043893416"] | ["+16507261476"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1348", "3032 Cabrillo Hwy N", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "494574043893416"]}] | {"minx": -122.453496, "maxx": -122.453496, "miny": 37.493029, "maxy": 37.493029} | <Binary: 21 bytes> | place | 37.493029 | -122.453496 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [places] ( [id] TEXT PRIMARY KEY, [updatetime] TEXT, [version] INTEGER, [names] TEXT, [categories] TEXT, [confidence] FLOAT, [websites] TEXT, [socials] TEXT, [emails] TEXT, [phones] TEXT, [brand] TEXT, [addresses] TEXT, [sources] TEXT, [bbox] TEXT, [geometry] BLOB, [type] TEXT , [latitude] FLOAT, [longitude] FLOAT);