Meta

property value
dataset name 1970-1979 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/1970-1979-Building-Permit-Listing/akhc-zaz6
dataset key akhc-zaz6
number of records 49409
number of variables 29

Sample

##   permit_value :created_at number month prefix year
## 1          500  1362413809    616     7      E 1970
## 2          400  1362413809   1041     5      E 1970
## 3         3000  1362413809    214    12      E 1971
## 4          600  1362413809    400     1      E 1973
## 5          700  1362413809    405     4      E 1971
## 6          400  1362413809    409     4      E 1971
##   dwelling_units_gained_or_lost :position suffix :updated_at :created_meta
## 1                             0         1     ST  1362413809        701271
## 2                             1         2     ST  1362413809        701271
## 3                             0         3     ST  1362413809        701271
## 4                             0         4     ST  1362413809        701271
## 5                             0         5     ST  1362413809        701271
## 6                             0         6     ST  1362413809        701271
##           res_non fraction how_far_north                            type
## 1 Non-Residential       NA       1072727 Additions, Alterations, Repairs
## 2     Residential       NA       1073092                      Demolition
## 3 Non-Residential       NA       1072101 Additions, Alterations, Repairs
## 4 Non-Residential       NA       1071995                      Demolition
## 5 Non-Residential       NA       1071901                      Demolition
## 6 Non-Residential       NA       1071905                      Demolition
##           sf_mf :updated_meta :sid day name how_far_east
## 1            NA        701271    1   1    1      2766374
## 2 Single Family        701271    2   1    1      2768343
## 3            NA        701271    3   1    3      2765973
## 4            NA        701271    4   1    3      2766074
## 5            NA        701271    5   1    3      2766112
## 6            NA        701271    6   1    3      2766125
##                                    :id :meta permit_number
## 1 3F409595-D136-4275-8F7A-89D89F6BF04C  {\n}         26424
## 2 A9A05B9C-6C8D-4852-B1CC-A810FCB81999  {\n}         23531
## 3 A95935C7-01B7-45D9-98FF-98757350A546  {\n}         56087
## 4 CA4AB585-7959-4E1F-8572-2D974A600193  {\n}         79778
## 5 6286036D-93C8-415C-9446-2D62117D90BF  {\n}         41714
## 6 AC709E00-7986-4045-9658-644A0345473D  {\n}         41715
##   location_1.latitude location_1.needs_recoding
## 1                  NA                      TRUE
## 2                  NA                      TRUE
## 3                  NA                      TRUE
## 4                  NA                      TRUE
## 5                  NA                      TRUE
## 6                  NA                      TRUE
##                                  location_1.human_address
## 1  {"address":"616 E 1 ST","city":"","state":"","zip":""}
## 2 {"address":"1041 E 1 ST","city":"","state":"","zip":""}
## 3  {"address":"214 E 3 ST","city":"","state":"","zip":""}
## 4  {"address":"400 E 3 ST","city":"","state":"","zip":""}
## 5  {"address":"405 E 3 ST","city":"","state":"","zip":""}
## 6  {"address":"409 E 3 ST","city":"","state":"","zip":""}
##   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: fraction, location_1.latitude, location_1.machine_address, location_1.longitude

The following variables are duplicates:

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

permit_value

Distribution

Summary statistics

statistic value
Min. 1
1st Qu. 600
Median 2000
Mean 24260
3rd Qu. 12500
Max. 21680000

number

Distribution

Summary statistics

statistic value
Min. 0
1st Qu. 1826
Median 3819
Mean 4384
3rd Qu. 6144
Max. 16320
NA’s 6

month

Distribution

Frequency table

prefix

Distribution

Frequency table

year

Distribution

Frequency table

dwelling_units_gained_or_lost

Distribution

Frequency table

suffix

Distribution

Frequency table

res_non

Distribution

Frequency table

how_far_north

Distribution

Summary statistics

statistic value
Min. 976500
1st Qu. 1038000
Median 1055000
Mean 1057000
3rd Qu. 1069000
Max. 1160000

type

Distribution

Frequency table

sf_mf

Distribution

Frequency table

day

Distribution

Frequency table

name

Distribution

Summary statistics

statistic value
Min. 1.00
1st Qu. 35.00
Median 58.00
Mean 59.35
3rd Qu. 82.00
Max. 147.00
NA’s 44884.00

how_far_east

Distribution

Summary statistics

statistic value
Min. 2722000
1st Qu. 2765000
Median 2772000
Mean 2773000
3rd Qu. 2779000
Max. 2821000

permit_number

Distribution

Summary statistics

statistic value
Min. 0
1st Qu. 22750
Median 46340
Mean 48230
3rd Qu. 72190
Max. 100000

location_1.human_address

Distribution of top 50 variables

Frequency table of top 100 variables