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)

Me

@kaggle.openaddresses_openaddresses_us_northeast.me

22.45 MB
616284 rows
11 columns

lon LON	lat LAT	number NUMBER	street STREET	unit UNIT	city CITY	district DISTRICT	region REGION	postcode POSTCODE	hash HASH
-69.795552	44.6529994	1026	E Pond Rd	nan	Smithfield	Somerset	ME	4978	5eedeb78f3e8881a
-69.7956709	44.6533947	1031	E Pond Rd	nan	Smithfield	Somerset	ME	4978	885b9056f0cec4c8
-69.7957544	44.6535067	1033	E Pond Rd	nan	Smithfield	Somerset	ME	4978	c045a31ca66debb1
-69.7961408	44.6540936	1043	E Pond Rd	nan	Smithfield	Somerset	ME	4978	7273ac69f27aaa40
-69.7973522	44.6559802	1075	E Pond Rd	nan	Smithfield	Somerset	ME	4978	991d44f1b0f2a7e7
-69.7980209	44.6569118	1091	E Pond Rd	nan	Smithfield	Somerset	ME	4978	2efed39aefe4e102
-69.8007994	44.659476	1125	E Pond Rd	nan	Smithfield	Somerset	ME	4978	d3314891dc1e00c4
-69.8015434	44.6599164	1131	E Pond Rd	nan	Smithfield	Somerset	ME	4978	d66816021799fb6d
-69.8022213	44.6601367	1140	E Pond Rd	nan	Smithfield	Somerset	ME	4978	7e5ab6565a72a0ee
-69.8024326	44.6603738	1143	E Pond Rd	nan	Smithfield	Somerset	ME	4978	d5706689f2634ae8


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