places
Data license: CDLA permissive v2
4 rows where phones contains "+16507127000"
This data as json, CSV (advanced)
Suggested facets: addresses, 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_264C4FEA888021680F49122CEA844B88 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["The Conservatory", "local"]}]]} | {"main": "lounge", "alternate": ["restaurant", "hotel_bar"]} | 0.9950664043426514 | ["http://www.ritzcarlton.com/en/properties/halfmoonbay/default.htm"] | ["https://www.facebook.com/1276233972415403"] | ["+16507127000"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-2376", "1 Miramontes Point Rd", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "1276233972415403"]}] | {"minx": -122.441679, "maxx": -122.441679, "miny": 37.433768, "maxy": 37.433768} | <Binary: 21 bytes> | place | 37.433768 | -122.441679 | |
| tmp_402BF46CEFE577D4DC510AA4985D754E | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Ocean Terrace", "local"]}]]} | {"main": "bar", "alternate": ["lounge", "seafood_restaurant"]} | 0.9894882440567017 | ["http://www.ritzcarlton.com/en/properties/halfmoonbay/dining/ocean_terrace/default.htm"] | ["https://www.facebook.com/791300661039384"] | ["+16507127000"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-2376", "1 Miramontes Point Rd", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "791300661039384"]}] | {"minx": -122.441506, "maxx": -122.441506, "miny": 37.433692, "maxy": 37.433692} | <Binary: 21 bytes> | place | 37.433692 | -122.441506 | |
| tmp_493F5949BDB9293142A3080E43A64F0A | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Ritz Carlton", "local"]}]]} | {"main": "hotel", "alternate": ["travel", "golf_course"]} | 0.7948299050331116 | ["http://www.ritzcarlton.com/"] | ["https://www.facebook.com/258668614146900"] | ["+16507127000"] | {"names": null, "wikidata": null} | [{"key": ["locality", "region", "country"], "value": ["El Granada", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "258668614146900"]}] | {"minx": -122.4755969, "maxx": -122.4755969, "miny": 37.502545, "maxy": 37.502545} | <Binary: 21 bytes> | place | 37.502545 | -122.4755969 | |
| tmp_B67F9CE276114886EF3BF1AAAC07442C | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Navio", "local"]}]]} | {"main": "restaurant", "alternate": ["bar"]} | 0.9541094899177551 | ["https://www.facebook.com/108865270557579"] | ["+16507127000"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-2376", "1 Miramontes Point Rd", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "108865270557579"]}] | {"minx": -122.4403365, "maxx": -122.4403365, "miny": 37.4348885, "maxy": 37.4348885} | <Binary: 21 bytes> | place | 37.4348885 | -122.4403365 |
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);