Building and Trades Permits 01012011 to Current updates nightly
This dataset has the following 17 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
PERMIT NUMBER | permit_number | text | 20050716-C000 20053854-C000 20060885-C000 20061804-C000 20062080-C000 view top 100 |
APPLY DATE | apply_date | calendar_date | 2011-09-01T00:00:00.000 2016-01-11T00:00:00.000 2011-11-08T00:00:00.000 2013-01-15T00:00:00.000 2014-12-17T00:00:00.000 view top 100 |
ISSUE DATE | issue_date | date | 2021-08-12T00:00:00.000Z 2011-09-30T00:00:00.000Z 2018-01-17T00:00:00.000Z 2021-10-01T00:00:00.000Z 2012-12-24T00:00:00.000Z view top 100 |
EXPIRE DATE | expire_date | date | 1899-12-31T00:00:00.000Z 2022-02-08T00:00:00.000Z 2017-04-17T00:00:00.000Z 2012-03-28T00:00:00.000Z 2017-02-27T00:00:00.000Z view top 100 |
VALUE | value | number | 1000 5000 2000 3000 10000 view top 100 |
WORK DESCRIPTION | work_description | text | REPLACE BOILER WITH GAS HIGH EFFIECIENCY CONDESATING BOILER. REPLACE BATHROOM EXHAUST FAN. ALL ELECTRICAL WORK BY ELECTRICAL CONTRACTOR- SEPARATE PERMIT INSTALLATION OF NEW TOILET, VANITY, T & S VALVE AND KITHEN SINK WITH FAUCET IN PLACE OF OLD FIXTURES. (REPLACEMENT ONLY) BASEMENT CO DETECTOR, BOILER, EXHAUST FAN, BATH LIGHTS. LOW VOLTAGE SECURITY Frame Around New AC Ductwork and Install Approximately 1 Sheet of 5/8” Drywall, Tape and Paint. Demo Water Damaged Drywall from Bathroom Ceiling and Replace with 5/8” Waterproof Drywall Approximately 1.5 Sheets, Tape and Paint. view top 100 |
WORK CLASS | work_class | text | Residential Commercial Alteration Reroof (1 and 2 Family) Tent view top 100 |
DIVISION | division | text | Building (L&I)/(DPW) - Residential, HCE CAO, HPA Building (L&I)/(DPW) - Commercial Building (L&I) - Alteration Reroof (1 and 2 Family) Building (L&I) - Tent view top 100 |
PARCELID | parcelid | text | 201269034 269353004 206533005 249554003 202416001 view top 100 |
STATUS | status | text | Issued Closed Expired Cancelled Issued - CAP view top 100 |
PERMIT TYPE | permit_type | text | Electrical Certificate of Approval Building (Residential) Mechanical Plumbing view top 100 |
ADDRESS | address | text | 690 ASYLUM AV 300 SUMMIT ST 80 SEYMOUR ST 151 FARMINGTON AV 114 WOODLAND ST view top 100 |
UNIT or SUITE | unit_or_suite | text | 1FL 2FL 1ST FL CNDASC 1 view top 100 |
GLOBAL ENTITY NAME | global_entity_name | text | TRAVELERS INDEMNITY CO HARTFORD HOSPITAL SHELDON OAK CENTRAL, INC. TRUSTEES OF TRINITY COLLEGE HOUSING AUTHORITY OF THE CITY OF HARTFORD view top 100 |
FIRST NAME | first_name | text | JOHN MICHELLE MICHAEL JOSE ABRAHAM view top 100 |
LAST NAME | last_name | text | WILLIAMS LANDRY N/A THOMPSON SMITH view top 100 |
geom | geom | location | view top 100 |