Meta

Sample

##   :created_at             permittype      file closedate
## 1  1451988130 Residential - Existing 16-000050      <NA>
## 2  1451988130 Residential - Existing 16-000059      <NA>
## 3  1451988130        Dumpster Permit 16-000044      <NA>
## 4  1451988130 Residential - Existing 16-000037      <NA>
## 5  1451988130 Residential - Existing 16-000038      <NA>
## 6  1451988130        Dumpster Permit 16-000039      <NA>
##      applicantaddress           issuedate :position :updated_at
## 1 346 Somerville Ave. 2016-01-04T00:00:00    857798  1451988130
## 2    110 Maple Street 2016-01-04T00:00:00    857799  1451988130
## 3        7 oakwood st 2016-01-04T00:00:00    857797  1451988130
## 4         24 Cross St 2016-01-04T00:00:00    857794  1451988130
## 5         24 Cross St 2016-01-04T00:00:00    857795  1451988130
## 6   44 Hunting Street 2016-01-04T00:00:00    857796  1451988130
##                                       projectname :created_meta
## 1           UNDERGROUND SANITARY PIPE REPLACEMENT        393811
## 2 Replace boiler with new high efficiency boiler.        393811
## 3                       dumpster permit on street        393811
## 4                         Renovation of 3-family.        393811
## 5                          Renovation of 3-family        393811
## 6                              Dumpster on street        393811
##       applicationdate latitude status permitamount  applicantcitystzip
## 1 2016-01-04T00:00:00 42.39199 Issued           60 Somerville MA 02143
## 2 2016-01-04T00:00:00 42.38659 Issued           60       Stow MA 01775
## 3 2016-01-04T00:00:00 42.39308 Issued          100     boston ma 02124
## 4 2016-01-04T00:00:00 42.38679 Issued          360 Somerville MA 02145
## 5 2016-01-04T00:00:00 42.38679 Issued          120 Somerville MA 02145
## 6 2016-01-04T00:00:00 42.37408 Issued          100 Somerville Ma 02143
##            address :updated_meta   :sid
## 1 275 HIGHLAND AVE        393811 857798
## 2     3 LINCOLN ST        393811 857799
## 3     21 SEWALL ST        393811 857797
## 4   18 EVERETT AVE        393811 857794
## 5   18 EVERETT AVE        393811 857795
## 6    44 HUNTING ST        393811 857796
##                                    applicant longitude
## 1 J. J. Sullivan Plumbing & Heating Co., INC -71.11146
## 2                               Lombardo P+H -71.08088
## 3                        valentine carpentry -71.09137
## 4            Pavidis Plumbing & Heating Inc. -71.08844
## 5            Pavidis Plumbing & Heating Inc. -71.08844
## 6                                Jaime  Lima -71.09066
##                                    :id :meta      expirationdate
## 1 A157A3AE-DFED-4F7E-AC14-23447D82FC42    NA 2016-07-04T00:00:00
## 2 B3171350-CEA5-4B4A-90CD-3E3E217D2162    NA 2016-07-04T00:00:00
## 3 1AFB9456-7965-4FBB-9835-DD499C29AD5C    NA                <NA>
## 4 21BF346E-1B5A-4CDB-899F-BB5113F7BA76    NA 2016-07-04T00:00:00
## 5 12E3DE88-129A-479E-AEB2-0C9989B44DA4    NA 2016-07-04T00:00:00
## 6 EE245BA7-EF24-4934-B6F7-A644C5446436    NA                <NA>
##        permit amountpaid
## 1  P16-000004         60
## 2  G16-000005         60
## 3 DP16-000002        100
## 4  P16-000002        360
## 5  G16-000002        120
## 6 DP16-000001        100

Missing Values

Variables

The following variables are all NA: :meta

The following variables are duplicates:

• :position, :sid
• :created_meta, :updated_meta
• :created_at, :updated_at