Additional Kiva Snapshot
Additional 3GB uncompressed snapshot from kiva
@kaggle.gaborfodor_additional_kiva_snapshot
Locations
@kaggle.gaborfodor_additional_kiva_snapshot.locations
- 3.34 MB
- 18365 rows
- 17 columns
address_componentsAddress Components | formatted_addressFormatted Address | geometry_bounds_northeast_latGeometry.bounds.northeast.lat | geometry_bounds_northeast_lngGeometry.bounds.northeast.lng | geometry_bounds_southwest_latGeometry.bounds.southwest.lat | geometry_bounds_southwest_lngGeometry.bounds.southwest.lng | geometry_location_latGeometry.location.lat | geometry_location_lngGeometry.location.lng | geometry_location_typeGeometry.location Type | geometry_viewport_northeast_latGeometry.viewport.northeast.lat | geometry_viewport_northeast_lngGeometry.viewport.northeast.lng | geometry_viewport_southwest_latGeometry.viewport.southwest.lat | geometry_viewport_southwest_lngGeometry.viewport.southwest.lng | location_nameLocation Name | partial_matchPartial Match | place_idPlace Id | typesTypes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| [{'long_name': 'Managua', 'short_name': 'Managua', 'types': ['locality', 'political']}, {'long_name': 'Managua Department', 'short_name': 'MN', 'types': ['administrative_area_level_1', 'political']}, {'long_name': 'Nicaragua', 'short_name': 'NI', 'types': ['country', 'political']}] | Managua, Nicaragua | 12.1753574 | -86.1250878 | 12.0199606 | -86.39183340000002 | 12.1149926 | -86.23617440000002 | APPROXIMATE | 12.1753574 | -86.1250878 | 12.0199606 | -86.39183340000002 | Managua, Nicaragua | nan | ChIJC4gH2Q1WcY8RakxPFKL0Xmw | ['locality', 'political'] |
| [{'long_name': 'Lahore', 'short_name': 'Lahore', 'types': ['locality', 'political']}, {'long_name': 'Lahore', 'short_name': 'Lahore', 'types': ['administrative_area_level_2', 'political']}, {'long_name': 'Punjab', 'short_name': 'Punjab', 'types': ['administrative_area_level_1', 'political']}, {'long… | Lahore, Pakistan | 31.69848649999999 | 74.5873967 | 31.2673942 | 74.1155387 | 31.5203696 | 74.35874729999998 | APPROXIMATE | 31.69848649999999 | 74.5873967 | 31.2673942 | 74.1155387 | Lahore, Pakistan | nan | ChIJ2QeB5YMEGTkRYiR-zGy-OsI | ['locality', 'political'] |
| [{'long_name': 'Kaduna', 'short_name': 'Kaduna', 'types': ['locality', 'political']}, {'long_name': 'Kaduna', 'short_name': 'KD', 'types': ['administrative_area_level_1', 'political']}, {'long_name': 'Nigeria', 'short_name': 'NG', 'types': ['country', 'political']}] | Kaduna, Nigeria | 10.6169963 | 7.508812000000002 | 10.3971566 | 7.349789099999999 | 10.5104642 | 7.4165053 | APPROXIMATE | 10.6169963 | 7.508812000000002 | 10.3971566 | 7.349789099999999 | Kaduna, Nigeria | nan | ChIJdRc3NFg1TRARdOG_mpeVAUg | ['locality', 'political'] |
| [{'long_name': 'Cusco', 'short_name': 'Cusco', 'types': ['locality', 'political']}, {'long_name': 'Cusco', 'short_name': 'Cusco', 'types': ['administrative_area_level_2', 'political']}, {'long_name': 'Cusco', 'short_name': 'Cusco', 'types': ['administrative_area_level_1', 'political']}, {'long_name'… | Cusco, Peru | -13.4973908 | -71.8533325 | -13.5626478 | -72.02516560000002 | -13.53195 | -71.96746259999998 | APPROXIMATE | -13.4973908 | -71.8533325 | -13.5626478 | -72.02516560000002 | Cusco, Peru | nan | ChIJMYRZJtjVbZERXTEYI8yWqSo | ['locality', 'political'] |
| [{'long_name': 'León', 'short_name': 'León', 'types': ['locality', 'political']}, {'long_name': 'León Department', 'short_name': 'León Department', 'types': ['administrative_area_level_1', 'political']}, {'long_name': 'Nicaragua', 'short_name': 'NI', 'types': ['country', 'political']}] | León, Nicaragua | 12.4609659 | -86.8434048 | 12.407026 | -86.92075290000002 | 12.4315534 | -86.87221459999998 | APPROXIMATE | 12.4609659 | -86.8434048 | 12.407026 | -86.92075290000002 | Leon, Nicaragua | nan | ChIJd3qPu5IfcY8RPDHqZG_AtTo | ['locality', 'political'] |
| [{'long_name': 'Dar es Salaam', 'short_name': 'DSM', 'types': ['locality', 'political']}, {'long_name': 'Kinondoni', 'short_name': 'Kinondoni', 'types': ['administrative_area_level_2', 'political']}, {'long_name': 'Dar es Salaam', 'short_name': 'Dar es Salaam', 'types': ['administrative_area_level_1… | Dar es Salaam, Tanzania | -6.588899099999999 | 39.48171129999999 | -6.9502833 | 39.0268707 | -6.792354 | 39.2083284 | APPROXIMATE | -6.588899099999999 | 39.48171129999999 | -6.9502833 | 39.0268707 | Dar es Salaam, Tanzania | nan | ChIJ8dabFq5LXBgR3aGGoCZrD5Q | ['locality', 'political'] |
| [{'long_name': 'La Paz', 'short_name': 'La Paz', 'types': ['locality', 'political']}, {'long_name': 'La Paz Department', 'short_name': 'La Paz Department', 'types': ['administrative_area_level_1', 'political']}, {'long_name': 'Bolivia', 'short_name': 'BO', 'types': ['country', 'political']}] | La Paz, Bolivia | -16.4245596 | -68.01129329999999 | -16.6168651 | -68.23686169999999 | -16.489689000000002 | -68.11929359999999 | APPROXIMATE | -16.4245596 | -68.01129329999999 | -16.6168651 | -68.23686169999999 | La Paz, Bolivia | nan | ChIJD6T1BArfXpERs4pFtHb821c | ['locality', 'political'] |
| [{'long_name': 'Kampala', 'short_name': 'Kampala', 'types': ['locality', 'political']}, {'long_name': 'Kampala', 'short_name': 'Kampala', 'types': ['administrative_area_level_2', 'political']}, {'long_name': 'Central Region', 'short_name': 'Central Region', 'types': ['administrative_area_level_1', '… | Kampala, Uganda | 0.413199 | 32.689279600000006 | 0.2128597 | 32.5089713 | 0.3475964 | 32.5825197 | APPROXIMATE | 0.413199 | 32.689279600000006 | 0.2128597 | 32.5089713 | Kampala, Uganda | nan | ChIJm7N0nQ-8fRcR7G9r2T2QOEU | ['locality', 'political'] |
| [{'long_name': 'Ayacucho', 'short_name': 'Ayacucho', 'types': ['locality', 'political']}, {'long_name': 'Huamanga', 'short_name': 'Huamanga', 'types': ['administrative_area_level_2', 'political']}, {'long_name': 'Ayacucho', 'short_name': 'Ayacucho', 'types': ['administrative_area_level_1', 'politica… | Ayacucho, Peru | -13.1192574 | -74.18004379999998 | -13.197473 | -74.24456440000002 | -13.1638737 | -74.22356409999998 | APPROXIMATE | -13.1192574 | -74.18004379999998 | -13.197473 | -74.24456440000002 | Ayacucho, Peru | nan | ChIJ6b6y9Yh9EpERbqFwOoTLs-k | ['locality', 'political'] |
| [{'long_name': 'Rawalpindi', 'short_name': 'RWP', 'types': ['locality', 'political']}, {'long_name': 'Rawalpindi', 'short_name': 'Rawalpindi', 'types': ['administrative_area_level_2', 'political']}, {'long_name': 'Punjab', 'short_name': 'Punjab', 'types': ['administrative_area_level_1', 'political']… | Rawalpindi, Pakistan | 33.6647041 | 73.15327839999998 | 33.4583251 | 72.8891345 | 33.565110700000005 | 73.0169135 | APPROXIMATE | 33.6647041 | 73.15327839999998 | 33.4583251 | 72.8891345 | Rawalpindi, Pakistan | nan | ChIJy5pBdImU3zgRD9MyFn41hAk | ['locality', 'political'] |
CREATE TABLE locations (
"address_components" VARCHAR,
"formatted_address" VARCHAR,
"geometry_bounds_northeast_lat" DOUBLE,
"geometry_bounds_northeast_lng" DOUBLE,
"geometry_bounds_southwest_lat" DOUBLE,
"geometry_bounds_southwest_lng" DOUBLE,
"geometry_location_lat" DOUBLE,
"geometry_location_lng" DOUBLE,
"geometry_location_type" VARCHAR,
"geometry_viewport_northeast_lat" DOUBLE,
"geometry_viewport_northeast_lng" DOUBLE,
"geometry_viewport_southwest_lat" DOUBLE,
"geometry_viewport_southwest_lng" DOUBLE,
"location_name" VARCHAR,
"partial_match" VARCHAR,
"place_id" VARCHAR,
"types" VARCHAR
);