Dataset: OpenAddresses - U.S. Northeast

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

36.41 MB
1015947 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

121.53 MB
3507168 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

22.45 MB
616284 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

21.25 MB
584517 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

212.66 MB
2949447 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

211.57 MB
5247963 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

306 MB
8769436 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.02 MB
407780 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.03 MB
327465 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
);