places
Data license: CDLA permissive v2
8 rows where phones contains "+16507268819"
This data as json, CSV (advanced)
Suggested facets: websites, addresses, bbox, geometry, latitude, longitude, 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_024BF99678A49B3899FF0F24A157D2DE | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Half Moon Bay State Beach", "local"]}]]} | {"main": "park", "alternate": ["sports_and_recreation_venue", "attractions_and_activities"]} | 0.9917265176773071 | ["http://www.parks.ca.gov/halfmoonbaysb"] | ["https://www.facebook.com/1678857285661477"] | ["+16507268819"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1627", "95 Kelly Ave", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "1678857285661477"]}, {"key": ["dataset", "property", "recordid"], "value": ["meta", "/properties/existence", "524707667549772"]}] | {"minx": -122.4462822, "maxx": -122.4462822, "miny": 37.4670663, "maxy": 37.4670663} | <Binary: 21 bytes> | place | 37.4670663 | -122.4462822 | |
| tmp_0B293DB9DF3316A02FEF3BC150A619DB | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Half Moon Bay Beach", "local"]}]]} | {"main": "beach", "alternate": ["attractions_and_activities", "surfing"]} | 0.8044376969337463 | ["http://www.parks.ca.gov/?page_id=531"] | ["https://www.facebook.com/1318107061578574"] | ["+16507268819"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "freeform", "country"], "value": ["94019", "Coastal Trail", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "1318107061578574"]}] | {"minx": -122.4540957, "maxx": -122.4540957, "miny": 37.4856123, "maxy": 37.4856123} | <Binary: 21 bytes> | place | 37.4856123 | -122.4540957 | |
| tmp_0EC3B863772EEE83E7104851605DB1B8 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Roosevelt Beach", "local"]}]]} | {"main": "beach", "alternate": ["active_life"]} | 0.9334242343902588 | ["http://www.parks.ca.gov/?page_id=531"] | ["https://www.facebook.com/156887317658476"] | ["+16507268819"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "freeform", "country"], "value": ["94019", "Roosevelt Ave", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "156887317658476"]}] | {"minx": -122.454897, "maxx": -122.454897, "miny": 37.488642, "maxy": 37.488642} | <Binary: 21 bytes> | place | 37.488642 | -122.454897 | |
| tmp_26903BF054F9359596670671AC2AFF1F | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Francis Beach", "local"]}]]} | {"main": "beach", "alternate": ["skate_park", "campground"]} | 0.986514151096344 | ["http://www.parks.ca.gov/?page_id=531"] | ["https://www.facebook.com/1465356693696319"] | ["+16507268819"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1627", "95 Kelly Ave", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "1465356693696319"]}, {"key": ["dataset", "property", "recordid"], "value": ["meta", "/properties/existence", "1910272109217591"]}] | {"minx": -122.444221, "maxx": -122.444221, "miny": 37.46516, "maxy": 37.46516} | <Binary: 21 bytes> | place | 37.46516 | -122.444221 | |
| tmp_4A649CEC73CD2E8FE6ADCBF4D03D6ACE | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["McNee Ranch State Park", "local"]}]]} | {"main": "skate_park", "alternate": ["park", "active_life"]} | 0.9628632664680481 | ["http://www.parks.ca.gov/?page_id=532"] | ["https://www.facebook.com/126964667350101"] | ["+16507268819"] | {"names": null, "wikidata": null} | [{"key": ["locality", "region", "country"], "value": ["Montara", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "126964667350101"]}] | {"minx": -122.5116593, "maxx": -122.5116593, "miny": 37.5583748, "maxy": 37.5583748} | <Binary: 21 bytes> | place | 37.5583748 | -122.5116593 | |
| tmp_67E1C70AE2DDA33348D8C0EAA7B838F8 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Bean Hollow State Beach", "local"]}]]} | {"main": "beach", "alternate": ["skate_park", "structure_and_geography"]} | 0.9748650789260864 | ["http://www.parks.ca.gov/?page_id=527"] | ["https://www.facebook.com/122544631166272"] | ["+16507268819"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "country"], "value": ["94019", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "122544631166272"]}] | {"minx": -122.432697, "maxx": -122.432697, "miny": 37.468459, "maxy": 37.468459} | <Binary: 21 bytes> | place | 37.468459 | -122.432697 | |
| tmp_6D48F7D64D09A2CBBB3573BDAD9E30DC | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["City of Half Moon Bay State Parks", "local"]}]]} | {"main": "skate_park", "alternate": ["park", "beach"]} | 0.8198742270469666 | ["http://www.parks.ca.gov/?page_id=531"] | ["https://www.facebook.com/154243084611857"] | ["+16507268819"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1627", "95 Kelly Ave", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "154243084611857"]}] | {"minx": -122.444221, "maxx": -122.444221, "miny": 37.46516, "maxy": 37.46516} | <Binary: 21 bytes> | place | 37.46516 | -122.444221 | |
| tmp_7112591055F4CF3F7553D6CE1F7935B8 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Montara Beach", "local"]}]]} | {"main": "mountain", "alternate": ["travel"]} | 0.7375837564468384 | ["http://www.parks.ca.gov/?page_id=532"] | ["https://www.facebook.com/359950044040950"] | ["+16507268819"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "country"], "value": ["94038", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "359950044040950"]}] | {"minx": -122.515918, "maxx": -122.515918, "miny": 37.541382, "maxy": 37.541382} | <Binary: 21 bytes> | place | 37.541382 | -122.515918 |
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);