Meta

property	value
dataset name	Issued Permits(ALL TYPES)
data source	City of Boston
data level	City
description	Permits issued by Public Works, Transportation, Inspectional Services, and the Fire Department
permalink	https://data.cityofboston.gov/Permitting/Issued-Permits-ALL-TYPES-/2hre-tvqe
dataset key	2hre-tvqe
number of records	502579
number of variables	39

Sample

##   is_contractor :created_at applicant_state                      owner
## 1             N  1440447167              MA BUMC ENERGY MANAGER OFFICE
## 2             Y  1440447173              MA    Northeastern University
## 3             N  1440447175            <NA>                       <NA>
## 4             N  1440447176              MA            CHESTNUT HILL P
## 5             N  1440447177              MA              Unique Realty
## 6             N  1440447180              MA    BATTISTA  WILLIAM_&_Y L
##   permitnumber :position property_id applicationmethod        city
## 1      SF68532    461725      164797      OnlinePermit     Roxbury
## 2      PL57494    461728      155692      OnlinePermit      Boston
## 3    SMK125617    461731      233195    InPersonPermit East Boston
## 4       E97399    461733       31846    InPersonPermit    Brighton
## 5     SF245269    461735      133523    InPersonPermit      Boston
## 6     PL447958    461741       55152      OnlinePermit East Boston
##   :updated_at :created_meta state
## 1  1440447167        525314    MA
## 2  1440447173        525314    MA
## 3  1440447175        525314    MA
## 4  1440447176        525314    MA
## 5  1440447177        525314    MA
## 6  1440447180        525314    MA
##                                                                                                                                                                         comments
## 1 Construct walls to create lobby & office. replace ceilings  install new doors. Install new lights. Install new HVAC. Rework electrical as needed. Install new flooring. Paint.
## 2                                                                                                                          Add in water piping  fume hood  and new sink install.
## 3                                                                                                                                                                           <NA>
## 4                                                                                                                                                              remodel - unit #7
## 5                                                                                                                                                      replace fire alarm panel.
## 6                                                                                                                     Remodel of the first floor apartment bathroom and kitchen.
##           issued_date occupancytype               permittypedescr  status
## 1 2011-03-23T13:32:54         Mixed        Short Form Bldg Permit EXPIRED
## 2 2011-01-05T10:22:59          Comm               Plumbing Permit EXPIRED
## 3 2012-04-03T11:14:51         1Unit BFD – Smoke/CO Inspection and EXPIRED
## 4 2011-09-23T10:55:17        1-7FAM             Electrical Permit EXPIRED
## 5 2013-05-17T11:50:37         Multi        Short Form Bldg Permit EXPIRED
## 6 2015-02-18T09:54:35        1-3FAM               Plumbing Permit EXPIRED
##   sq_feet applicant_city total_fees                description
## 1  180099        Berkley        500 Renovations -Interior  NSC
## 2       0    NEWTONVILLE         45                   Plumbing
## 3       0           <NA>         50                       <NA>
## 4     580      Tyngsboro         42                 Electrical
## 5       0           Lynn         40                 Fire Alarm
## 6       0     Dorchester         45                   Plumbing
##     applicant_address                    address :updated_meta   :sid
## 1      27 Howland Rd.           75   E Newton ST        525314 461725
## 2                <NA>       360    Huntington AV        525314 461728
## 3                <NA>            84    Falcon ST        525314 461731
## 4       14 Derby Lane 324-326   Chestnut Hill AV        525314 461733
## 5    424 Essex Street          71    Symphony RD        525314 461735
## 6 866 Dorchester Ave.           42    Everett ST        525314 461741
##     zip     expiration_date             applicant  parcel_id
## 1 02118 2011-09-23T00:00:00    William MacDougall  801405000
## 2 02115 2011-07-05T00:00:00        DENNIS MAGUIRE  402236000
## 3 02128 2012-06-02T11:14:51           MIKE GREALY         NA
## 4 02135 2012-03-23T00:00:00          Brandon Beck 2102333000
## 5 02115 2013-11-17T00:00:00 Wayne Alarm Systems .  401554000
## 6 02128 2015-08-18T00:00:00       Alexander Baker  105294000
##                                    :id applicant_zip :meta
## 1 FFD8005B-3905-4358-A38E-E8F8FDEE4A0E         02779    NA
## 2 90BD0B2B-E522-46FB-B00E-2019B9FD12D2         02460    NA
## 3 972D5241-1C36-473E-89BF-1D13DC7D61E9          <NA>    NA
## 4 EA2BEBB2-7C20-4930-A838-376CFDE50C1D         01879    NA
## 5 06CA538D-8913-4A85-8467-95ED75791F05         01902    NA
## 6 CA47F414-7F5E-4412-8E47-2D0C1515D424         02125    NA
##   declared_valuation   worktype location.latitude location.needs_recoding
## 1              47340     INTREN          42.33664                   FALSE
## 2              12000   PLUMBING          42.34005                   FALSE
## 3                  0       <NA>          42.38214                   FALSE
## 4               2000 ELECTRICAL          42.33774                   FALSE
## 5               1800         FA          42.34328                   FALSE
## 6               3000   PLUMBING          42.36831                   FALSE
##                         location.human_address location.machine_address
## 1 {"address":"","city":"","state":"","zip":""}                       NA
## 2 {"address":"","city":"","state":"","zip":""}                       NA
## 3 {"address":"","city":"","state":"","zip":""}                       NA
## 4 {"address":"","city":"","state":"","zip":""}                       NA
## 5 {"address":"","city":"","state":"","zip":""}                       NA
## 6 {"address":"","city":"","state":"","zip":""}                       NA
##   location.longitude
## 1          -71.07156
## 2          -71.08889
## 3          -71.03593
## 4          -71.15260
## 5          -71.08951
## 6          -71.03618

Missing Values

Variables

The following variables are all NA: :meta, location.machine_address

The following variables are duplicates:

• :created_meta, :updated_meta
• :position, :sid