places
Data license: CDLA permissive v2
2 rows where phones contains "+16507261520"
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_5D7D76D45BE40FE157C0E8DD67DF9C71 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["The Half Moon Bay Wine and Cheese Company", "local"]}]]} | {"main": "wine_bar", "alternate": ["winery", "liquor_store"]} | 0.9944080114364624 | ["http://www.hmbwineandcheese.com"] | ["https://www.facebook.com/188680641157486"] | ["+16507261520"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1749", "421 Main St", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "188680641157486"]}] | {"minx": -122.4289899, "maxx": -122.4289899, "miny": 37.4642321, "maxy": 37.4642321} | <Binary: 21 bytes> | place | 37.4642321 | -122.4289899 | |
| tmp_F5DFA82D3145ABA94BD1CEF130727AE7 | 2023-07-24T00:00:00.000 | 0 | {"key": ["common"], "value": [[{"key": ["value", "language"], "value": ["Half Moon Bay Skate Park", "local"]}]]} | {"main": "skate_park", "alternate": ["park", "arts_and_entertainment"]} | 0.81502765417099 | ["http://www.caliskatz.com/v4/skateparks/half_moon_bay_skatepark.asp"] | ["https://www.facebook.com/206418772722417"] | ["+16507261520"] | {"names": null, "wikidata": null} | [{"key": ["locality", "postcode", "freeform", "region", "country"], "value": ["Half Moon Bay", "94019-1922", "530 Main St", "CA", "US"]}] | [{"key": ["dataset", "property", "recordid"], "value": ["meta", "", "206418772722417"]}, {"key": ["dataset", "property", "recordid"], "value": ["meta", "/properties/existence", "204542576361102"]}] | {"minx": -122.429709, "maxx": -122.429709, "miny": 37.463074, "maxy": 37.463074} | <Binary: 21 bytes> | place | 37.463074 | -122.429709 |
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);