Baselight
Sign In

OpenAddresses - U.S. Northeast

Addresses and geo locations for the U.S. Northeast

@kaggle.openaddresses_openaddresses_us_northeast

Ma
@kaggle.openaddresses_openaddresses_us_northeast.ma

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

-72.812429141.99860321MORT VINING ROADnanSOUTHWICKHAMPDENMA1077.0f94ed465692aeea6
-72.815093241.998745217MORT VINING ROADnanSOUTHWICKHAMPDENMA1077.095c5b426ea846a17
-72.801495942.00015842MORT VINING ROADnanSOUTHWICKHAMPDENMA1077.0e36f377f69674818
-72.797199542.00044411COLLEGE HIGHWAYnanSOUTHWICKHAMPDENMA1077.00827b67a17f2acb8
-72.794662342.00054464COLLEGE HIGHWAYnanSOUTHWICKHAMPDENMA1077.04241f22871de9c26
-72.816041642.000374350COOLEY ROADnanGRANBY, CTHAMPDENMA1077.0378f98938539c76a
-72.793917142.00108476COLLEGE HIGHWAYnanSOUTHWICKHAMPDENMA1077.0e26c75f80cef7e08
-72.795575642.001280315COLLEGE HIGHWAYnanSOUTHWICKHAMPDENMA1077.0704e670f1c96dcd5
-72.808524442.001327923MORT VINING ROADnanSOUTHWICKHAMPDENMA1077.020d769abbe2d7b6c
-72.809591942.001481625MORT VINING ROADnanSOUTHWICKHAMPDENMA1077.03062af7c52ef8fd0

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