places
3 rows
This data as json, CSV (advanced)
Suggested facets: place_type, country_code, country
id ▼ | url | place_type | name | full_name | country_code | country | contained_within | bounding_box | attributes |
---|---|---|---|---|---|---|---|---|---|
5a110d312052166f | https://api.twitter.com/1.1/geo/id/5a110d312052166f.json | city | San Francisco | San Francisco, CA | US | United States | [] | {"type": "Polygon", "coordinates": [[[-122.514926, 37.708075], [-122.357031, 37.708075], [-122.357031, 37.833238], [-122.514926, 37.833238]]]} | {} |
8173485c72e78ca5 | https://api.twitter.com/1.1/geo/id/8173485c72e78ca5.json | city | Atlanta | Atlanta, GA | US | United States | [] | {"type": "Polygon", "coordinates": [[[-84.576827, 33.6475029], [-84.289385, 33.6475029], [-84.289385, 33.8868859], [-84.576827, 33.8868859]]]} | {} |
ee9d992aa12a6fa0 | https://api.twitter.com/1.1/geo/id/ee9d992aa12a6fa0.json | country | Republic of Mauritius | Republic of Mauritius | MU | Republic of Mauritius | [] | {"type": "Polygon", "coordinates": [[[57.3083535, -20.5254982], [57.8229151, -20.5254982], [57.8229151, -19.9355533], [57.3083535, -19.9355533]]]} | {} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [places] ( [id] TEXT PRIMARY KEY , [url] TEXT, [place_type] TEXT, [name] TEXT, [full_name] TEXT, [country_code] TEXT, [country] TEXT, [contained_within] TEXT, [bounding_box] TEXT, [attributes] TEXT);