locations

Data license: CC-BY-4.0

18,996 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: dso

Next page

CREATE TABLE locations (
	id INTEGER NOT NULL, 
	mailing_address1 TEXT, mailing_address2 TEXT, mailing_city TEXT, mailing_state TEXT, mailing_zip TEXT, mailing_country TEXT, mailing_county TEXT, physical_county TEXT, dccid TEXT, created_at DATETIME, updated_at DATETIME, note TEXT, dso TEXT, dso_update TEXT, taggable_id INTEGER, physical_address1 TEXT, physical_address2 TEXT, physical_city TEXT, physical_state TEXT, physical_zip TEXT, physical_country TEXT, latitude FLOAT, longitude FLOAT, taggable_type TEXT, 
	PRIMARY KEY (id)
);
CREATE INDEX ix_locations_1d6d94da1e93927d ON locations (dccid);
CREATE INDEX ix_locations_0a6e8b1431918283 ON locations (taggable_id, taggable_type);