places
Data license: CDLA permissive v2
5 rows where phones contains "+16507268297"
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_04526853E8AD5D682B0D4503D91D4728 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Mac Dutra Park", "local"]}]]} | {"main": "park", "alternate": ["public_plaza", "attractions_and_activities"]} | 0.988727331161499 | ["http://www.half-moon-bay.ca.us/index.php?option=com_content&v%e2%80%a6"] | ["https://www.facebook.com/306053786083416"] | ["+16507268297"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1922", "504 Main St", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "306053786083416"]}] | {"minx": -122.429692, "maxx": -122.429692, "miny": 37.463527, "maxy": 37.463527} | <Binary: 21 bytes> | place | 37.463527 | -122.429692 | |
| tmp_23925303DEF7B973493B573DA8B9DB0B | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Ted Adcock Community Center", "local"]}]]} | {"main": "community_center", "alternate": ["community_services_non_profits", "sports_and_recreation_venue"]} | 0.9918118715286255 | ["http://www.recconnect.net/"] | ["https://www.facebook.com/197343660303238"] | ["+16507268297"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1719", "535 Kelly St", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "197343660303238"]}] | {"minx": -122.4321879, "maxx": -122.4321879, "miny": 37.4646737, "maxy": 37.4646737} | <Binary: 21 bytes> | place | 37.4646737 | -122.4321879 | |
| tmp_AAB2B42EA1DDF437170E3CE1312B2EAF | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["City of Half Moon Bay - Recreation & Community Services", "local"]}]]} | {"main": "public_and_government_association", "alternate": ["sports_and_recreation_venue", "structure_and_geography"]} | 0.7872281074523926 | ["https://www.half-moon-bay.ca.us/223/recreation-services"] | ["https://www.facebook.com/1770545653236861"] | ["+16507268297"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019", "535 Kelly Ave", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "1770545653236861"]}] | {"minx": -122.43223, "maxx": -122.43223, "miny": 37.4646, "maxy": 37.4646} | <Binary: 21 bytes> | place | 37.4646 | -122.43223 | |
| tmp_B98BF6CDE371BCA0DC5FD6BE10E947C1 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Kehoe Park", "local"]}]]} | {"main": "park", "alternate": null} | 0.7992369532585144 | ["http://www.half-moon-bay.ca.us/index.php?option=com_content&view=article&id=87&itemid=106"] | ["https://www.facebook.com/245598479461301"] | ["+16507268297"] | {"names": null, "wikidata": null} | [{"key": ["postcode", "freeform", "country"], "value": ["94019", "St Joseph Ave", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "245598479461301"]}] | {"minx": -122.442079, "maxx": -122.442079, "miny": 37.477307, "maxy": 37.477307} | <Binary: 21 bytes> | place | 37.477307 | -122.442079 | |
| tmp_FFAFFF12A7105C0B4BF4CEA3FCD422CE | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Blufftop Coastal Park", "local"]}]]} | {"main": "park", "alternate": ["active_life", "landmark_and_historical_building"]} | 0.9906779527664185 | ["http://www.trails.com/tcatalog_trail.aspx?trailid=hgs401-037"] | ["https://www.facebook.com/1022173911160287"] | ["+16507268297"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-2024", "152 Poplar St", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "1022173911160287"]}] | {"minx": -122.440927, "maxx": -122.440927, "miny": 37.455597, "maxy": 37.455597} | <Binary: 21 bytes> | place | 37.455597 | -122.440927 |
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);