Name: OpenAddresses - U.S. Northeast
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

OpenAddresses - U.S. Northeast

Context

OpenAddresses's goal is to connect the digital and physical worlds by sharing geographic coordinates, street names, house numbers and postal codes.

Content

This dataset contains one datafile for each state in the U.S. Northeast region.

States included in this dataset:

Connecticut - ct.csv
Massachusetts - ma.csv
Maine - me.csv
New Hampshite - nh.csv
New Jersey - nj.csv
New York - ny.csv
Pennsylvania - pa.csv
Rhode Island - ri.csv
Vermont - vt.csv

Field descriptions:

LON - Longitude
LAT - Latitude
NUMBER - Street number
STREET - Street name
UNIT - Unit or apartment number
CITY - City name
DISTRICT - ?
REGION - ?
POSTCODE - Postcode or zipcode
ID - ?
HASH - ?

Acknowledgements

Data collected around 2017-07-25 by OpenAddresses (http://openaddresses.io).

Address data is essential infrastructure. Street names, house numbers and
postal codes, when combined with geographic coordinates, are the hub that
connects digital to physical places.

Data licenses can be found in LICENSE.txt.

Data source information can be found at
https://github.com/openaddresses/openaddresses/tree/9ea72b079aaff7d322349e4b812eb43eb94d6d93/sources

Inspiration

Use this dataset to create maps in conjunction with other datasets for crime or weather

Tables

Ct

@kaggle.openaddresses_openaddresses_us_northeast.ct

38.18 MB
1,015,947 rows
11 columns

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
);

Ma

@kaggle.openaddresses_openaddresses_us_northeast.ma

127.43 MB
3,507,168 rows
11 columns

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

Me

@kaggle.openaddresses_openaddresses_us_northeast.me

23.54 MB
616,284 rows
11 columns

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
);

Nh

@kaggle.openaddresses_openaddresses_us_northeast.nh

22.28 MB
584,517 rows
11 columns

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
);

Nj

@kaggle.openaddresses_openaddresses_us_northeast.nj

222.99 MB
2,949,447 rows
11 columns

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
);

Ny

@kaggle.openaddresses_openaddresses_us_northeast.ny

221.85 MB
5,247,963 rows
11 columns

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
);

Pa

@kaggle.openaddresses_openaddresses_us_northeast.pa

320.87 MB
8,769,436 rows
11 columns

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

Ri

@kaggle.openaddresses_openaddresses_us_northeast.ri

15.75 MB
407,780 rows
11 columns

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

Vt

@kaggle.openaddresses_openaddresses_us_northeast.vt

12.62 MB
327,465 rows
11 columns

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