About this Dataset

Historic Data On DC Buildings

Historical Data on the Buildings of Washington DC, collected over 15 years by Brian Kraft, with support from JMT Inc., for the DC Historic Preservation Office. Most of the data comes from the building permits issued by the city, especially from 1877 to 1949. Sources are named for all buildings and other sources include real estate maps, tax assessments, newspaper reports, and the DC Office of Tax and Revenue, mostly for buildings after 1949. Work on this data is ongoing but we feel that this will be a valuable and enjoyable research tool as it is.
Organization: District of Columbia
Last updated: 2024-04-30T18:38:10.192134
Tags: dc, district-of-columbia, historic-preservation-office, historical-buildings, hpo, office-of-planning, op, planning, washington-dc

Tables

Table 1

@usgov.district_of_columbia_historic_data_on_dc_buildings.table_1

9.64 MB
126,809 rows
49 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "fulladdress" VARCHAR,
  "buildingname" VARCHAR,
  "square" VARCHAR,
  "lot" VARCHAR,
  "date" VARCHAR,
  "mapyear" BIGINT,
  "permit_notes" VARCHAR,
  "notes" VARCHAR,
  "suffix" VARCHAR,
  "edittype" VARCHAR,
  "house_key" DOUBLE,
  "house_type" VARCHAR,
  "extant" DOUBLE,
  "updated" DOUBLE,
  "facade" VARCHAR,
  "flag" DOUBLE,
  "contributing" VARCHAR,
  "architectgroup" VARCHAR,
  "developer" VARCHAR,
  "quantity" DOUBLE,
  "rooms" DOUBLE,
  "width" DOUBLE,
  "depth" DOUBLE,
  "number_of_families" DOUBLE,
  "store" DOUBLE,
  "stories" DOUBLE,
  "permits_last_editor" VARCHAR,
  "permits_last_edit_date" VARCHAR,
  "razedflag" DOUBLE,
  "permitssource" VARCHAR,
  "permitnumber" VARCHAR,
  "owner" VARCHAR,
  "architect" VARCHAR,
  "builder" VARCHAR,
  "material" VARCHAR,
  "purpose" VARCHAR,
  "estimatedcost" DOUBLE,
  "microfilmroll" VARCHAR,
  "permittype" VARCHAR,
  "solidfilled" VARCHAR,
  "foundationmaterial" VARCHAR,
  "stonetype" VARCHAR,
  "rooftype" VARCHAR,
  "frontmaterial" VARCHAR,
  "roofmaterial" VARCHAR,
  "heat" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);