Meta

Sample

##   :created_at :updated_at             description :created_meta
## 1  1358449329  1358450606         TESTING - FOUND        700326
## 2  1358449328  1358450828                    test        700326
## 3  1358449241  1358450056      testing electrical        700326
## 4  1358449328  1358449474        testing waterser        700326
## 5  1358449292  1358449837 New1... Testing in PROD        700326
## 6  1358449328  1358450552        WATERSER testing        700326
##   ownerfullname      permitno                                  :id :meta
## 1          <NA>   SFD20081000 B95DE9D4-AA88-4048-A85B-176DDDA980A9  {\n}
## 2          <NA>   SFD20081002 DEF4493E-0664-40C1-8279-13964A374363  {\n}
## 3          <NA> ELECT20081003 694A4A01-BC98-4F57-BD19-40E7995F30CD  {\n}
## 4          <NA>   SFD20081001 0E6CEF8B-5177-4151-877D-CB2D0B47FAC1  {\n}
## 5          <NA>  PLUM20081000 4ADC040A-6E0B-42BD-B6F9-C840C3F6BF7C  {\n}
## 6          <NA>   SFD20081005 B06254EB-A71C-46CB-92D0-B41B4A0E580E  {\n}
##             pin contractorfullname :updated_meta          dateissued  :sid
## 1 11-19-480-026               <NA>        700326 2008-10-07T00:00:00 29568
## 2 12-02-352-011        Martin, Tim        700326 2008-10-08T00:00:00 29484
## 3 12-20-301-014               <NA>        700326 2008-10-08T00:00:00    26
## 4 11-23-177-002               <NA>        700326 2008-10-08T00:00:00 29093
## 5 11-28-252-003      Holder, Randy        700326 2008-10-08T00:00:00 16171
## 6 12-20-301-018               <NA>        700326 2008-10-09T00:00:00 29261
##   valuation :position                contractordba
## 1      7000     29568                         <NA>
## 2         0     29484                          ATS
## 3      1000        26                         <NA>
## 4       500     29093                         <NA>
## 5         0     16171 Design Plumbing & Piping Inc
## 6         0     29261                         <NA>
##   propertyaddress.latitude propertyaddress.needs_recoding
## 1                 42.26681                          FALSE
## 2                 42.31477                          FALSE
## 3                 42.27174                          FALSE
## 4                 42.27638                          FALSE
## 5                 42.26221                          FALSE
## 6                 42.27160                          FALSE
##                                                propertyaddress.human_address
## 1 {"address":"625 VINCENT AVE","city":"ROCKFORD","state":"IL","zip":"61102"}
## 2   {"address":"3698 LAURA LN","city":"ROCKFORD","state":"IL","zip":"61114"}
## 3   {"address":"516 LAUREL DR","city":"ROCKFORD","state":"IL","zip":"61107"}
## 4   {"address":"320 LOCUST ST","city":"ROCKFORD","state":"IL","zip":"61103"}
## 5  {"address":"1924 LOOMIS ST","city":"ROCKFORD","state":"IL","zip":"61102"}
## 6   {"address":"420 LAUREL DR","city":"ROCKFORD","state":"IL","zip":"61107"}
##   propertyaddress.machine_address propertyaddress.longitude
## 1                              NA                 -89.15889
## 2                              NA                 -88.97575
## 3                              NA                 -89.03726
## 4                              NA                 -89.09170
## 5                              NA                 -89.12375
## 6                              NA                 -89.03818

Missing Values

Variables

The following variables are all NA: propertyaddress.machine_address

The following variables are duplicates:

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