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)

Ri

@kaggle.openaddresses_openaddresses_us_northeast.ri

15.02 MB
407780 rows
11 columns

lon LON	lat LAT	number NUMBER	street STREET	city CITY	postcode POSTCODE	hash HASH
-71.5	-90	nan	nan	nan		eb0e7638a3ebce1d
-71.4854944	41.5444104	101	CARDINAL DR	NORTH KINGSTOWN	2852	70eb026221d73dde
-71.4959033	41.5984025	3666	QUAKER LN	NORTH KINGSTOWN	2852	3545aa17d2ccbdb4
-71.4856176	41.544182	93	CARDINAL DR	NORTH KINGSTOWN	2852	e5b080db8b912029
-71.4837467	41.5443842	21	WHITE BIRCH CT	NORTH KINGSTOWN	2852	d9192bf7a5657703
-71.4957684	41.5983873	3558	QUAKER LN	NORTH KINGSTOWN	2852	1e9a6cbaeba49019
-71.4386629	41.5525881	12	BATES AVE	NORTH KINGSTOWN	2852	794d93c2abbf0809
-71.4912891	41.5393005	47	INDIAN CORNER RD	NORTH KINGSTOWN	2874	d7b6885076b381f8
-71.4375077	41.5509134	77	BATES AVE	NORTH KINGSTOWN	2852	00fc382b9ed3ff51
-71.4539999	41.5685509	51	PHILLIPS ST	NORTH KINGSTOWN	2852	c135e94ae7cbb96c


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