Meta

Sample

##   :created_at postdir  stno :position suffix          city   zip
## 1  1451971455      NA  6209  43969527     RD      BETHESDA 20817
## 2  1451971455      NA  6221  43969528     LA     ROCKVILLE 20852
## 3  1451971455      NA  4001  43969529     ST         OLNEY 20832
## 4  1451971455      NA 10310  43969530     LA    GERMANTOWN 20876
## 5  1451971455      NA 13811  43969531     DR     ROCKVILLE 20853
## 6  1451971455      NA  2952  43969532     RD SILVER SPRING 20904
##   :created_meta state         finaleddate  status
## 1        498050    MD                <NA>  Issued
## 2        498050    MD 2001-10-30T01:10:00 Finaled
## 3        498050    MD                <NA>  Issued
## 4        498050    MD 2000-02-04T07:02:00 Finaled
## 5        498050    MD 2000-03-30T03:03:00 Finaled
## 6        498050    MD                <NA>  Issued
##                     description buildingarea         stname permitno
## 1                          <NA>          288       STONEHAM   208669
## 2 REVISION TO PERMIT #998060250          400         TILDEN   208671
## 3       TWO-CAR ATTACHED GARAGE          664 CHARLEY FOREST   208687
## 4                PORCH AND DECK          534     BUCKMEADOW   208693
## 5                          <NA>           NA        DOWLAIS   208698
## 6  CARPORT CONVERSION TO GARAGE          276     GRACEFIELD   208701
##               applicationtype :updated_meta                usecode
## 1 BUILDING RESIDENTIAL PERMIT        498050 SINGLE FAMILY DWELLING
## 2 BUILDING RESIDENTIAL PERMIT        498050 SINGLE FAMILY DWELLING
## 3 BUILDING RESIDENTIAL PERMIT        498050 SINGLE FAMILY DWELLING
## 4 BUILDING RESIDENTIAL PERMIT        498050 SINGLE FAMILY DWELLING
## 5 BUILDING RESIDENTIAL PERMIT        498050                   DECK
## 6 BUILDING RESIDENTIAL PERMIT        498050 SINGLE FAMILY DWELLING
##       :sid           addeddate          issueddate :updated_at
## 1 43969527 2000-01-03T07:01:38 2000-01-03T08:01:00  1451972111
## 2 43969528 2000-01-03T07:01:15 2000-01-03T09:01:48  1451972263
## 3 43969529 2000-01-03T10:01:03 2000-01-04T03:01:00  1451972309
## 4 43969530 2000-01-03T10:01:54 2000-01-03T12:01:00  1451972641
## 5 43969531 2000-01-03T11:01:55 2000-01-03T12:01:00  1451972206
## 6 43969532 2000-01-03T11:01:55 2000-01-03T12:01:03  1451971455
##                                    :id :meta predir declaredvaluation
## 1 01612308-8CB1-4E94-B33A-331EA2F0DA8C    NA   <NA>             25000
## 2 421D2B19-5F4E-4B19-9157-17381FD58DDE    NA   <NA>             56000
## 3 56BBF8F7-0990-42A4-85AE-F2A008654262    NA   <NA>             20000
## 4 EDE853B8-8E7A-4056-ABC8-00BD16D6CE16    NA   <NA>             11500
## 5 29E02711-1424-453E-A003-95E9883BD32F    NA   <NA>                NA
## 6 794EEED0-160E-4685-9242-5AD686E90C80    NA   <NA>              5000
##           worktype location.latitude location.needs_recoding
## 1              ADD          39.01646                   FALSE
## 2 BUILD FOUNDATION          39.04365                   FALSE
## 3              ADD          39.16844                   FALSE
## 4              ADD          39.24072                   FALSE
## 5        CONSTRUCT          39.08240                   FALSE
## 6            ALTER                NA                    TRUE
##                                                                location.human_address
## 1         {"address":"6209 STONEHAM RD","city":"BETHESDA","state":"MD","zip":"20817"}
## 2          {"address":"6221 TILDEN LA","city":"ROCKVILLE","state":"MD","zip":"20852"}
## 3      {"address":"4001 CHARLEY FOREST ST","city":"OLNEY","state":"MD","zip":"20832"}
## 4    {"address":"10310 BUCKMEADOW LA","city":"GERMANTOWN","state":"MD","zip":"20876"}
## 5        {"address":"13811 DOWLAIS DR","city":"ROCKVILLE","state":"MD","zip":"20853"}
## 6 {"address":"2952 GRACEFIELD RD SILVER SPRING","city":"MD","state":"","zip":"20904"}
##   location.machine_address location.longitude
## 1                       NA          -77.12541
## 2                       NA          -77.12862
## 3                       NA          -77.07909
## 4                       NA          -77.21595
## 5                       NA          -77.10021
## 6                       NA                 NA

Missing Values

Variables

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

The following variables are duplicates:

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