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)

Vt

@kaggle.openaddresses_openaddresses_us_northeast.vt

12.03 MB
327465 rows
11 columns

lon LON	lat LAT	number NUMBER	street STREET	city CITY	postcode POSTCODE	hash HASH
-72.2269743	44.4182701	1	JOES POND PEARL IS	CABOT	05647	ced338879b3a429e
-72.2243239	44.4190137	1	JOES POND PRIEST IS	CABOT	05647	12e57585a5ecb038
-73.2039855	43.6622276	50	RABBIT IS	CASTLETON	05743	9118e5aa591c07a2
-73.2118926	43.6464856	89	NESHOBE IS	CASTLETON	05743	7ce6ab7eb62c7017
-73.2112822	43.6464017	87	NESHOBE IS	CASTLETON	05743	d6795d10efaea2af
-73.2938094	44.2835325	9	GARDEN IS	CHARLOTTE		875ced6d0d2e7f32
-73.2935806	44.2833456	8	GARDEN IS	CHARLOTTE		9bbfef5ae8bfb712
-73.2938781	44.2828726	6	GARDEN IS	CHARLOTTE		4f0762c94382c802
-73.2938857	44.2821401	4	GARDEN IS	CHARLOTTE		e4004e5a85b1aa94
-73.2939239	44.2816252	2	GARDEN IS	CHARLOTTE		c7c9b6a007b041b3


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