Meta

Sample

##   :created_at owner permitnumber         issued_date property_id sq_feet
## 1  1409069386  <NA>      U497392 2006-09-26T00:00:00      317194       0
## 2  1409069405  <NA>      U497392 2006-09-26T00:00:00      317194       0
## 3  1409069411  <NA>      ALT8484 2007-12-26T00:00:00          NA       0
## 4  1409069411  <NA>      ALT8484 2007-12-26T00:00:00          NA       0
## 5  1409069415  <NA>      ALT9460 2009-04-21T00:00:00      314216       0
## 6  1409069400  <NA>      ALT9460 2009-04-21T00:00:00      314216       0
##         city :position :updated_at :created_meta state
## 1 Dorchester    285811  1409069386        525314    MA
## 2 Dorchester    294256  1409069405        525314    MA
## 3     BOSTON    296735  1409069411        525314    MA
## 4     BOSTON    296643  1409069411        525314    MA
## 5     Boston    298671  1409069415        525314    MA
## 6     Boston    292205  1409069400        525314    MA
##                                                                                                                                                                                                                                                                                                      comments
## 1                                                                                                                                                                                                                                             Proposed Work: Two vehicle parking  Last Action: READY TO ISSUE
## 2                                                                                                                                                                                                                                             Proposed Work: Two vehicle parking  Last Action: READY TO ISSUE
## 3 Proposed Work: The work involved is a complete renovation of the existing Burnham building   from the fourth level of the basement to the first floor including repairs to the exterior (windows  masonry  and storefront)  installation of new mechanical  electrical  and pl  Last Action: READY TO ISSUE
## 4 Proposed Work: The work involved is a complete renovation of the existing Burnham building   from the fourth level of the basement to the first floor including repairs to the exterior (windows  masonry  and storefront)  installation of new mechanical  electrical  and pl  Last Action: READY TO ISSUE
## 5                                                                                                              Proposed Work: Altman Vilandrie - 37th floor\n\nTenant renovation includes demolition  drywall partition  ceiling tiles  flooring electrical  HVAC & finish work.  Last Action: READY TO ISSUE
## 6                                                                                                              Proposed Work: Altman Vilandrie - 37th floor\n\nTenant renovation includes demolition  drywall partition  ceiling tiles  flooring electrical  HVAC & finish work.  Last Action: READY TO ISSUE
##   occupancytype             permittypedescr  status total_fees
## 1        1-3FAM             Use of Premises EXPIRED          0
## 2        1-3FAM             Use of Premises EXPIRED          0
## 3          COMM Long Form/Alteration Permit EXPIRED          0
## 4          COMM Long Form/Alteration Permit EXPIRED          0
## 5          COMM Long Form/Alteration Permit EXPIRED          0
## 6          COMM Long Form/Alteration Permit EXPIRED          0
##                      description              address :updated_meta   :sid
## 1 From TimeMatters-PZ Conversion      93    Sydney ST        525314 285811
## 2 From TimeMatters-PZ Conversion      93    Sydney ST        525314 294256
## 3 From TimeMatters-PZ Conversion 384-426   WASHINGTON        525314 296735
## 4 From TimeMatters-PZ Conversion 384-426   WASHINGTON        525314 296643
## 5         Fast Track Application       53    State ST        525314 298671
## 6         Fast Track Application       53    State ST        525314 292205
##     zip     expiration_date                      applicant parcel_id
## 1 02125 2014-01-29T00:00:00                           <NA>        NA
## 2 02125 2014-01-29T00:00:00                  Edward Mourad        NA
## 3 02108 2014-01-15T00:00:00 Suffolk Construction Co.  Inc.        NA
## 4 02108 2014-01-15T00:00:00                           <NA>        NA
## 5 02109 2014-01-15T00:00:00            Structure Tone Inc.        NA
## 6 02109 2014-01-15T00:00:00               francesca DiRico        NA
##                                    :id :meta declared_valuation worktype
## 1 51BA2988-F87B-47F6-A3A6-7F01C6C5079A    NA                  0   CONVRT
## 2 E57C4957-854D-4AB0-8C04-D0C1EE7046C2    NA                  0   CONVRT
## 3 AB202514-652B-430C-8650-23E097FD34C1    NA                  0   CONVRT
## 4 5BD90812-3E32-4D04-940C-7869308D54B1    NA                  0   CONVRT
## 5 A0F5181A-05E2-4AD8-9B8B-7D10059AF98C    NA                  0   FSTTRK
## 6 502966EA-DC85-4A11-B370-ED453C31ABF2    NA                  0   FSTTRK
##   location.latitude location.needs_recoding location.human_address
## 1          42.31465                   FALSE                   <NA>
## 2          42.31465                   FALSE                   <NA>
## 3                NA                      NA                   <NA>
## 4                NA                      NA                   <NA>
## 5          42.35876                   FALSE                   <NA>
## 6          42.35876                   FALSE                   <NA>
##   location.machine_address location.longitude
## 1                       NA          -71.05243
## 2                       NA          -71.05243
## 3                       NA                 NA
## 4                       NA                 NA
## 5                       NA          -71.05620
## 6                       NA          -71.05620

Missing Values

Variables

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

The following variables are duplicates:

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