places
Data license: CDLA permissive v2
3 rows where phones contains "+16507268270"
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_3E945078280FE81287A3D7CDDE42A6D5 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Half Moon Bay City Hall", "local"]}]]} | {"main": "jail_and_prison", "alternate": ["structure_and_geography"]} | 0.8628469109535217 | ["http://www.half-moon-bay.ca.us"] | ["https://www.facebook.com/342481465852498"] | ["+16507268270"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1921", "501 Main St", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "342481465852498"]}, {"key": ["dataset", "property", "recordid"], "value": ["meta", "/properties/existence", "518450238170894"]}] | {"minx": -122.429045, "maxx": -122.429045, "miny": 37.463464, "maxy": 37.463464} | <Binary: 21 bytes> | place | 37.463464 | -122.429045 | |
| tmp_6B609DAC1383E3112D8DDD7C085DC51A | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Half Moon Bay Coastal Trail", "local"]}]]} | {"main": "hiking_trail", "alternate": ["structure_and_geography", "park"]} | 0.9664920568466187 | ["http://www.traillink.com/trail/half-moon-bay-coastside-trail.aspx"] | ["https://www.facebook.com/834056060057995"] | ["+16507268270"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "freeform", "country"], "value": ["94019", "Miramontes Point", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "834056060057995"]}] | {"minx": -122.444159, "maxx": -122.444159, "miny": 37.465328, "maxy": 37.465328} | <Binary: 21 bytes> | place | 37.465328 | -122.444159 | |
| tmp_AF23CFBB79A5AE74BDB996A49C665F5D | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["John L Carter Memorial Park", "local"]}]]} | {"main": "park", "alternate": ["landmark_and_historical_building", "topic_concert_venue"]} | 0.9872204065322876 | ["http://half-moon-bay.ca.us/index.php?option=com_content&view=article&id=87&itemid=106"] | ["https://www.facebook.com/471415703026061"] | ["+16507268270"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "freeform", "country"], "value": ["94019", "John L Carter Memorial Park", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "471415703026061"]}] | {"minx": -122.427924, "maxx": -122.427924, "miny": 37.46589, "maxy": 37.46589} | <Binary: 21 bytes> | place | 37.46589 | -122.427924 |
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);