OpenAddresses - U.S. Northeast

Addresses and geo locations for the U.S. Northeast

@kaggle.openaddresses_openaddresses_us_northeast

Table List

9 tables(958.92 MB)

Ma

@kaggle.openaddresses_openaddresses_us_northeast.ma

121.53 MB
3507168 rows
11 columns

lon LON	lat LAT	number NUMBER	street STREET	unit UNIT	city CITY	district DISTRICT	region REGION	postcode POSTCODE	hash HASH
-72.8124291	41.9986032	1	MORT VINING ROAD	nan	SOUTHWICK	HAMPDEN	MA	1077.0	f94ed465692aeea6
-72.8150932	41.9987452	17	MORT VINING ROAD	nan	SOUTHWICK	HAMPDEN	MA	1077.0	95c5b426ea846a17
-72.8014959	42.0001584	2	MORT VINING ROAD	nan	SOUTHWICK	HAMPDEN	MA	1077.0	e36f377f69674818
-72.7971995	42.0004441	1	COLLEGE HIGHWAY	nan	SOUTHWICK	HAMPDEN	MA	1077.0	0827b67a17f2acb8
-72.7946623	42.0005446	4	COLLEGE HIGHWAY	nan	SOUTHWICK	HAMPDEN	MA	1077.0	4241f22871de9c26
-72.8160416	42.0003743	50	COOLEY ROAD	nan	GRANBY, CT	HAMPDEN	MA	1077.0	378f98938539c76a
-72.7939171	42.0010847	6	COLLEGE HIGHWAY	nan	SOUTHWICK	HAMPDEN	MA	1077.0	e26c75f80cef7e08
-72.7955756	42.0012803	15	COLLEGE HIGHWAY	nan	SOUTHWICK	HAMPDEN	MA	1077.0	704e670f1c96dcd5
-72.8085244	42.0013279	23	MORT VINING ROAD	nan	SOUTHWICK	HAMPDEN	MA	1077.0	20d769abbe2d7b6c
-72.8095919	42.0014816	25	MORT VINING ROAD	nan	SOUTHWICK	HAMPDEN	MA	1077.0	3062af7c52ef8fd0


CREATE TABLE ma (
  "lon" DOUBLE,
  "lat" DOUBLE,
  "number" VARCHAR,
  "street" VARCHAR,
  "unit" VARCHAR,
  "city" VARCHAR,
  "district" VARCHAR,
  "region" VARCHAR,
  "postcode" VARCHAR,
  "id" VARCHAR,
  "hash" VARCHAR
);