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)

Pa

@kaggle.openaddresses_openaddresses_us_northeast.pa

306 MB
8769436 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
-77.3767543	39.7199658	17	PERSIMMON TRL	nan	CARROLL VALLEY BORO	nan	nan	nan	nan	bc7a363cfbf6b36c
-77.3756743	39.7199927	14	SPRING WOOD TRL	nan	CARROLL VALLEY BORO	nan	nan	nan	nan	3c3d42c14dd78256
-77.3714841	39.7200474	45	MASON-DIXON TRL	nan	CARROLL VALLEY BORO	nan	nan	nan	nan	5ea9dccc067b75ed
-77.3560981	39.7200069	250	WAYNESBORO PIKE	nan	LIBERTY TWP	nan	nan	nan	nan	453b08e03a45432b
-77.4310436	39.7202457	794	HARBAUGH VALLEY RD	nan	LIBERTY TWP	nan	nan	nan	nan	4de6446588e963c3
-77.3776955	39.7201092	20	PERSIMMON TRL	nan	CARROLL VALLEY BORO	nan	nan	nan	nan	101be962678b822a
-77.378685	39.7201932	105	TOMS CREEK TRL	nan	CARROLL VALLEY BORO	nan	nan	nan	nan	f0dfc6e5d719a179
-77.3041608	39.7200414	4450	EMMITSBURG RD	nan	FREEDOM TWP	nan	nan	nan	nan	08ac565ce72d55f3
-77.3772558	39.72033	18	PERSIMMON TRL	nan	CARROLL VALLEY BORO	nan	nan	nan	nan	aa89eb364e5a0b70
-77.3491849	39.7202435	15	WAYNESBORO PIKE	nan	LIBERTY TWP	nan	nan	nan	nan	7750867f0d855da0


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