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)

Nj

@kaggle.openaddresses_openaddresses_us_northeast.nj

212.66 MB
2949447 rows
11 columns

lon LON	lat LAT	number NUMBER	street STREET	unit UNIT	city CITY	postcode POSTCODE	id ID	hash HASH
-74.5170669	39.430738	301	South Mill Road	nan	ABSECON	8201.0	{0E61823F-BE1E-4CF5-A39C-9034F9A950D8}	4d4b884abacc1664
-74.5175149	39.4306338	303	South Mill Road	nan	ABSECON	8201.0	{99A949BA-C7F7-400E-9526-7471A014D40A}	1f00839d32bf9fe2
-74.5127675	39.4394864	1008	Traymore Parkway	nan	ABSECON	8201.0	{07B72DDB-A71C-4954-A240-C7D2186B1A6C}	1a3c8a2a5b149812
-74.494882	39.4191247	236	East Absecon Boulevard	nan	ABSECON	8201.0	{1E06F2B8-D196-43C9-ACD2-E71DFEE93BE8}	725e5863b08a7c40
-74.50574	39.4290087	401	New Jersey Avenue	nan	ABSECON	8201.0	{A5AAC30C-9978-4B1B-9354-73C4FD636CC1}	714664295831eb0e
-74.5067969	39.4287248	433	White Horse Pike	nan	ABSECON	8201.0	{9D20E2DF-FD2B-48ED-9111-EEFA2CA1A67B}	2c3eac27b93abfb8
-74.5157026	39.4337222	935	Navajo Avenue	nan	ABSECON	8201.0	{F187813D-CEC9-4C94-8FDB-C384B2D33B99}	3d1321fbaadc744e
-74.5159192	39.4334879	933	Navajo Avenue	nan	ABSECON	8201.0	{57666B20-9BA8-45C9-A96D-E07F5A5C4BA6}	f69f58b1f77aeb8a
-74.5156474	39.4331877	931	Navajo Avenue	nan	ABSECON	8201.0	{F8836CC9-149D-483B-8448-79B3D7BA1CC7}	c4db1fd4f8095130
-74.5153226	39.4330805	929	Navajo Avenue	nan	ABSECON	8201.0	{1E89974B-9D37-4153-B928-067056C94398}	301d1dd58e937bbe


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