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)

Ct

@kaggle.openaddresses_openaddresses_us_northeast.ct

36.41 MB
1015947 rows
11 columns

lon LON	lat LAT	number NUMBER	street STREET	unit UNIT	city CITY	region REGION	postcode POSTCODE	hash HASH
-72.7277847	41.5692709	1111	Country Club Rd	nan	Middletown	Middlesex	6457	c3554d1f5dd0a126
-72.7738706	41.6332836	51	Parish Dr	nan	Berlin	Hartford	6037	d2592706fe88a3c4
-72.8102478	41.5992734	90	Stockings Brook Rd	nan	Berlin	Hartford	6037	e74d61e038da7814
-72.7450054	41.5991937	99	Lamentation Dr	nan	Berlin	Hartford	6037	9efa26677bccc077
-72.7406975	41.5992867	207	Lamentation Dr	nan	Berlin	Hartford	6037	4a55dec4cccf5e78
-72.7482723	41.5993596	152	Spruce Brook Rd	nan	Berlin	Hartford	6037	0968b41bf2129882
-72.778901	41.5977891	1461	Kensington Rd	nan	Berlin	Hartford	6037	2788b8e73e5b791b
-72.8088667	41.599351	77	Stockings Brook Rd	nan	Berlin	Hartford	6037	3e5d1a6b19aa9c2e
-72.7478548	41.5993683	164	Spruce Brook Rd	nan	Berlin	Hartford	6037	7416c3eaaa1eee56
-72.7865292	41.5992137	66	Cross Creek Dr	nan	Berlin	Hartford	6037	3ea90d099489ea7d


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