places
Data license: CDLA permissive v2
3 rows where phones contains "+16503558289"
This data as json, CSV (advanced)
Suggested facets: websites, 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_24DB6FF719CE8359D3BB5307124DD920 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Pillar Point Bluff trailhead & Jean Lauer Trail", "local"]}]]} | {"main": "park", "alternate": ["hiking_trail", "attractions_and_activities"]} | 0.9020835161209106 | ["http://parks.smcgov.org/pillar-point-bluff"] | ["https://www.facebook.com/419933561359608"] | ["+16503558289"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Moss Beach", "94038-9683", "840 Airport St", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "419933561359608"]}] | {"minx": -122.505347, "maxx": -122.505347, "miny": 37.51153, "maxy": 37.51153} | <Binary: 21 bytes> | place | 37.51153 | -122.505347 | |
| tmp_B6F6A41442683E61628B3AE30D72C80A | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Moss Beach Park", "local"]}]]} | {"main": "park", "alternate": ["active_life", "landmark_and_historical_building"]} | 0.9846582412719727 | ["http://parks.smcgov.org/moss-beach-park"] | ["https://www.facebook.com/137940396249430"] | ["+16503558289"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "freeform", "country"], "value": ["94038", "Virginia Avenue Etheldore St", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "137940396249430"]}] | {"minx": -122.51226, "maxx": -122.51226, "miny": 37.527971, "maxy": 37.527971} | <Binary: 21 bytes> | place | 37.527971 | -122.51226 | |
| tmp_FAE62C5F0499271C5FFBA1850BA861AC | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Pillar Point Access & Maverick's Trailhead", "local"]}]]} | {"main": "hiking_trail", "alternate": ["landmark_and_historical_building", "monument"]} | 0.8557753562927246 | ["http://parks.smcgov.org/pillar-point-bluff"] | ["https://www.facebook.com/297512790683194"] | ["+16503558289"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "freeform", "country"], "value": ["94019", "West Point Ave", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "297512790683194"]}] | {"minx": -122.496682, "maxx": -122.496682, "miny": 37.501622, "maxy": 37.501622} | <Binary: 21 bytes> | place | 37.501622 | -122.496682 |
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);