Meta

property	value
dataset name	2014 Building Permit Listing
data source	State of Missouri
data level	City
description	listing of building permits for new construction, demolition and additions/alterations/repairs and their characteristics
permalink	https://data.kcmo.org/Construction/2014-Building-Permit-Listing/qt6m-65bz
dataset key	qt6m-65bz
number of records	15538
number of variables	46

Sample

##   council_district permit_value :created_at school_district number month
## 1                6        40000  1441034349          BELTON  15608    11
## 2                6         4500  1441034349          BELTON  15608    11
## 3                6         9000  1441034349          BELTON  15608    12
## 4                1       185000  1441034349         LIBERTY   8048     6
## 5                1         7000  1441034349         LIBERTY   8048     7
## 6                1         6700  1441034349         LIBERTY   8048     7
##   county       property_description prefix              owner_name year
## 1   Cass           GENERAL BUILDING   <NA> BLUE RIVER BIBLE CHURCH 2014
## 2   Cass           GENERAL BUILDING   <NA> BLUE RIVER BIBLE CHURCH 2014
## 3   Cass           GENERAL BUILDING   <NA> BLUE RIVER BIBLE CHURCH 2014
## 4   Clay NEW SINGLE FAMILY DWELLING     NE                    #N/A 2014
## 5   Clay NEW SINGLE FAMILY DWELLING     NE                    #N/A 2014
## 6   Clay NEW SINGLE FAMILY DWELLING     NE                    #N/A 2014
##   dwelling_units_gained_or_lost :position suffix    pin :updated_at
## 1                             0         1     DR  75015  1441034349
## 2                             0         2     DR  75015  1441034349
## 3                             0         3     DR  75015  1441034349
## 4                             1         4     PL 256914  1441034349
## 5                             0         5     PL 256914  1441034349
## 6                             0         6     PL 256914  1441034349
##   :created_meta         res_non            location fraction
## 1        701271 Non-Residential 15608  FAIRCHILD DR     <NA>
## 2        701271 Non-Residential 15608  FAIRCHILD DR     <NA>
## 3        701271 Non-Residential 15608  FAIRCHILD DR     <NA>
## 4        701271     Residential    8048 NE 100TH PL     <NA>
## 5        701271     Residential    8048 NE 100TH PL     <NA>
## 6        701271     Residential    8048 NE 100TH PL     <NA>
##   structure_class suite                            type         sf_mf
## 1             437  <NA> Additions, Alterations, Repairs            NA
## 2             437  <NA> Additions, Alterations, Repairs            NA
## 3             437  <NA> Additions, Alterations, Repairs            NA
## 4             101  <NA>                New Construction Single Family
## 5             101  <NA>                New Construction Single Family
## 6             101  <NA>                New Construction Single Family
##                           project_description               parcel
## 1 BLUE RIVER BIBLE CHURCH, RESTROOMS ADDITION CA050203000000001002
## 2 BLUE RIVER BIBLE CHURCH, RESTROOMS ADDITION CA050203000000001002
## 3 BLUE RIVER BIBLE CHURCH, RESTROOMS ADDITION CA050203000000001002
## 4                               SINGLE FAMILY            T3400.200
## 5                               SINGLE FAMILY            T3400.200
## 6                               SINGLE FAMILY            T3400.200
##           applicant_representative how_far_north :updated_meta :sid day
## 1                     SMITH HARDEE      974016.2        701271    1   3
## 2                      BRAD HARDEE      974016.2        701271    2  26
## 3                      PAUL HARPER      974016.2        701271    3   8
## 4                   PERMIT SERVICE     1132167.0        701271    4  26
## 5             PERMIT SERVICE, INC.     1132167.5        701271    5  21
## 6 CLARK AND REDFORD ELECTRICAL LLC     1132167.5        701271    6  28
##                  applicant_name
## 1       BLUE RIVER BIBLE CHURCH
## 2          BRAD HARDEE ELECTRIC
## 3      PAUL HARPER PLUMBING LLC
## 4        ASPEN HOMEBUILDERS LLC
## 5 MILLER PLUMBING COMPANY, INC.
## 6           C-R ELECTRICAL, LLC
##                                                          legal_description
## 1 /PRT NE 1/4 NE 1/4 SEC 3 46 33DAF 2.58 AC M/L LY NWLY OF    FAIRCHILD DR
## 2 /PRT NE 1/4 NE 1/4 SEC 3 46 33DAF 2.58 AC M/L LY NWLY OF    FAIRCHILD DR
## 3 /PRT NE 1/4 NE 1/4 SEC 3 46 33DAF 2.58 AC M/L LY NWLY OF    FAIRCHILD DR
## 4                                                                     #N/A
## 5                                                                     #N/A
## 6                                                                     #N/A
##                             class_description
## 1 Existing - Nonresidntl Bldg-Addn-Alter-Conv
## 2 Existing - Nonresidntl Bldg-Addn-Alter-Conv
## 3 Existing - Nonresidntl Bldg-Addn-Alter-Conv
## 4                  New Single Family Dwelling
## 5                  New Single Family Dwelling
## 6                  New Single Family Dwelling
##                             subdivision      name how_far_east
## 1                                  <NA> FAIRCHILD      2775158
## 2                                  <NA> FAIRCHILD      2775158
## 3                                  <NA> FAIRCHILD      2775158
## 4 BENSON PLACE FIELDSTONE - FOURTH PLAT     100TH      2793792
## 5 BENSON PLACE FIELDSTONE - FOURTH PLAT     100TH      2793792
## 6 BENSON PLACE FIELDSTONE - FOURTH PLAT     100TH      2793792
##                                    :id
## 1 C132A9DC-79C0-4FAD-9AA6-23ED0FE64FFC
## 2 C876D492-7AFC-437A-8F8E-7A5A4BF2ECBC
## 3 6D20F6E0-3C1D-4A8C-BD09-178AEA394DFE
## 4 727C2364-D5B1-4C31-802A-F5353EA61564
## 5 7BD8F2E5-FAA0-4B96-9492-2EC3702537EE
## 6 8A05739B-DFDA-4E60-A7E2-06ED4D49AA8D
##                                                                     :meta
## 1 {\n  "invalidCells" : {\n    "30959387" : "15608  FAIRCHILD DR"\n  }\n}
## 2 {\n  "invalidCells" : {\n    "30959387" : "15608  FAIRCHILD DR"\n  }\n}
## 3 {\n  "invalidCells" : {\n    "30959387" : "15608  FAIRCHILD DR"\n  }\n}
## 4    {\n  "invalidCells" : {\n    "30959387" : "8048 NE 100TH PL"\n  }\n}
## 5    {\n  "invalidCells" : {\n    "30959387" : "8048 NE 100TH PL"\n  }\n}
## 6    {\n  "invalidCells" : {\n    "30959387" : "8048 NE 100TH PL"\n  }\n}
##   permit_number                   plan_area location_1.latitude
## 1     201519532 Martin City/Richards-Gebaur                <NA>
## 2     201520927 Martin City/Richards-Gebaur                <NA>
## 3     201521419 Martin City/Richards-Gebaur                <NA>
## 4     201512884          Shoal Creek Valley                <NA>
## 5     201514034          Shoal Creek Valley                <NA>
## 6     201514435          Shoal Creek Valley                <NA>
##   location_1.needs_recoding location_1.human_address
## 1                        NA                     <NA>
## 2                        NA                     <NA>
## 3                        NA                     <NA>
## 4                        NA                     <NA>
## 5                        NA                     <NA>
## 6                        NA                     <NA>
##   location_1.machine_address location_1.longitude
## 1                         NA                 <NA>
## 2                         NA                 <NA>
## 3                         NA                 <NA>
## 4                         NA                 <NA>
## 5                         NA                 <NA>
## 6                         NA                 <NA>

Missing Values

Variables

The following variables are all NA: location_1.machine_address

The following variables are duplicates:

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