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)

Ny

@kaggle.openaddresses_openaddresses_us_northeast.ny

211.57 MB
5247963 rows
11 columns

lon LON	lat LAT	number NUMBER	street STREET	unit UNIT	city CITY	district DISTRICT	region REGION	postcode POSTCODE	id ID	hash HASH
-78.8577564	42.0059943	519	Wolf Run Road	nan	Cold Spring	Cattaraugus	NY	14779	CATT004453	fb19be6063358080
-78.8774166	42.0060828	584	Wolf Run Road	nan	Cold Spring	Cattaraugus	NY	14779	CATT018221	39eff9e846a2a16c
-78.8770562	42.0219428	589	Wolf Run Road	nan	Cold Spring	Cattaraugus	NY	14779	CATT018222	af7096b2aa7ae559
-78.8768906	42.035149	557	Route 23	nan	Cold Spring	Cattaraugus	NY	14779	CATT003239	05b61b04e4cbf4ff
-78.915788	42.0272195	397	State Route 280	nan	South Valley	Cattaraugus	NY	14779	CATT015435	7b8a1f5790487ec6
-78.9166339	42.0192217	398	State Route 280	nan	South Valley	Cattaraugus	NY	14779	CATT015433	5047ef7ef070f112
-78.8972118	42.0230421	601	Quaker Run Road	nan	Cold Spring	Cattaraugus	NY	14779	CATT003248	3d8a95d95b091f10
-78.8970102	42.0062174	598	Browns	nan	Cold Spring	Cattaraugus	NY	14779	CATT004454	77cb33792d9f0603
-78.9165116	42.0063743	396	State Route 280	nan	South Valley	Cattaraugus	NY	14779	CATT014997	9c0e431d287bd513
-78.9292757	42.0169026	405	State Route 280	nan	South Valley	Cattaraugus	NY	14779	CATT014999	3fa88ac124fbc948


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