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)

Nh

@kaggle.openaddresses_openaddresses_us_northeast.nh

21.25 MB
584517 rows
11 columns

lon LON	lat LAT	number NUMBER	street STREET	city CITY	hash HASH
-72.0279116	43.6660189		CORNO ROAD	Canaan	ecfd48318c22f0fe
-72.0272715	43.6633558	38	WARBONNET ROAD	Canaan	626d04af3be00bcb
-72.0291803	43.6663705	142	CORNO ROAD	Canaan	45fac2388b973355
-72.0300421	43.6657005		CORNO ROAD	Canaan	3c745739c159f553
-72.0297217	43.6672215	151	CORNO ROAD	Canaan	01f5fbc04ad6e6c2
-72.0294038	43.6674086	153	CORNO ROAD	Canaan	535aa4795bd30661
-72.0299692	43.6669914	149	CORNO ROAD	Canaan	408074118dd29bac
-72.0302978	43.6666953	145	CORNO ROAD	Canaan	2957a67f67b2576d
-72.0306148	43.6664556	137	CORNO ROAD	Canaan	de5661b39b5c1a3d
-72.0309158	43.6662045	133	CORNO ROAD	Canaan	149e4186c728bb05


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