Sample
## council_district permit_value :created_at school_district number month
## 1 6 125000 1362415085 Hickman Mills 8120 8
## 2 6 175000 1362415085 Hickman Mills 8121 8
## 3 6 125000 1362415085 Hickman Mills 8125 8
## 4 6 1000 1362415085 Hickman Mills 8126 10
## 5 6 500 1362415085 Hickman Mills 8126 7
## 6 6 200 1362415085 Hickman Mills 8126 7
## county prefix year dwelling_units_gained_or_lost :position suffix
## 1 Jackson E 2003 2 1 CT
## 2 Jackson E 2003 2 2 CT
## 3 Jackson E 2003 2 3 CT
## 4 Jackson E 2003 0 4 CT
## 5 Jackson E 2009 0 5 CT
## 6 Jackson E 2009 0 6 CT
## pin :updated_at :created_meta res_non fraction structure_class
## 1 70125 1362415085 701271 Residential <NA> 103
## 2 70121 1362415085 701271 Residential <NA> 103
## 3 70122 1362415085 701271 Residential <NA> 103
## 4 NA 1362415085 701271 Residential <NA> 97
## 5 221000 1362415085 701271 Residential <NA> 97
## 6 221000 1362415085 701271 Residential <NA> 97
## how_far_north type sf_mf
## 1 1010349 New Construction Multifamily
## 2 1010195 New Construction Multifamily
## 3 1010215 New Construction Multifamily
## 4 1010413 Additions, Alterations, Repairs NA
## 5 1010413 Additions, Alterations, Repairs NA
## 6 1010413 Additions, Alterations, Repairs NA
## project_description parcel applicant_representative
## 1 SINGLE FAMILY JA50910031000000000 TOMMY TURNER
## 2 DUPLEX M/P RW200410785 JA50910030600000000 TOMMY TURNER
## 3 SINGLE FAMILY JA50910030700000000 R. BRIAN HOFFMAN
## 4 SINGLE FAMILY <NA> <NA>
## 5 SINGLE FAMILY JA50910032100000000 <NA>
## 6 SINGLE FAMILY JA50910032100000000 GARY M CHRIST
## :updated_meta :sid day applicant_name
## 1 701271 1 28 R W CONSTRUCTION L L C
## 2 701271 2 28 R W CONSTRUCTION L L C
## 3 701271 3 28 R W CONSTRUCTION L L C
## 4 701271 4 7 SHERBAZ KHAN
## 5 701271 5 20 ASHRAFI SHAHANA
## 6 701271 6 20 ASHRAFI SHAHANA
## legal_description
## 1 <NA>
## 2 <NA>
## 3 9200 VALLEY GARDEN DR UNITY RIDGE & GARDENS PRT LOTS29 39 & 40 BEG IN S LI UNITY DR AT C/L GARDEN VALLEY DR SD PT BEING 25 FT W OF NW COR LOT23 SD ADD TH ALG S LI UNITY DREXT 159 FT TO E LI NOLAND RD TH SELY ALG SD E LI 336 FT TH ELY 363 FT TO
## 4 SEC-01 TWP-48 RNG-32...PT SE 1/4 & PT SW 1/4 SEC-06 TWP-48 RNG-31 DAF: BEG ON E LI SD SE 1/4 40' N OF SE COR SE 1/4 TH N 87 DEG W 25.17' TO W ROW LI LEES SUMMIT RD & TRU POB: TH CONT N 87 DEG W 311.13' TH N 10 DEG E 441.61' TH S 87 DEG E 309.89' TO W ROW
## 5 EMBASSY PARK 12TH LOT 23
## 6 SEC 18-47-33 NW1/4 NW1/4 MCGILLEY ADD PT LOT 1 DAF: BEG SW COR SD LOT 1 TH N 00 DEG 05 MIN 24 SEC E 99.42' TH S 89 DEG 51 MIN 35 SEC E 525.96' TH S 00 DEG 03 MIN 20 SEC W 129.13' TH B 86 DEG 37 MIN 40 SEC W 526.90' TO POB
## class_description subdivision name
## 1 NEW TWO-FAMILY DWELLING <NA> 100TH
## 2 NEW TWO-FAMILY DWELLING <NA> 100TH
## 3 NEW TWO-FAMILY DWELLING <NA> 100TH
## 4 EXISTING ONE OR TWO FAMILY RESIDENCE <NA> 100TH
## 5 Existing One Or Two Family Residence TRUMANS CORNER CUPBOARD 100TH
## 6 Existing One Or Two Family Residence TRUMANS CORNER CUPBOARD 100TH
## how_far_east :id
## 1 2790661 CF00DE6B-C0C7-4651-A36B-CD3FA04BD953
## 2 2790653 5E92674B-9568-44A8-AA4D-D1326A074071
## 3 2790702 98A0B615-DDD0-49B2-8127-CB6A2D5295CC
## 4 2790747 75CE94C6-C885-4D87-89D5-C4F86D9E8854
## 5 2790839 98E71945-DA0E-4815-A76D-26C716DFDED9
## 6 2790839 289185C9-BD0C-4522-828A-688DEC553D83
## :meta permit_number
## 1 {\n} 200418098
## 2 {\n} 200418095
## 3 {\n} 200418097
## 4 {\n "invalidCells" : {\n "8344301" : "E5027"\n }\n} 200420842
## 5 {\n} 201013348
## 6 {\n} 201013349
## 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":"8120 E 100TH CT","city":"","state":"","zip":""}
## 2 {"address":"8121 E 100TH CT","city":"","state":"","zip":""}
## 3 {"address":"8125 E 100TH CT","city":"","state":"","zip":""}
## 4 {"address":"8126 E 100TH CT","city":"","state":"","zip":""}
## 5 {"address":"8126 E 100TH CT","city":"","state":"","zip":""}
## 6 {"address":"8126 E 100TH CT","city":"","state":"","zip":""}
## location_1.machine_address location_1.longitude location_2.latitude
## 1 NA NA NA
## 2 NA NA NA
## 3 NA NA NA
## 4 NA NA NA
## 5 NA NA NA
## 6 NA NA NA
## location_2.needs_recoding
## 1 TRUE
## 2 TRUE
## 3 TRUE
## 4 TRUE
## 5 TRUE
## 6 TRUE
## location_2.human_address
## 1 {"address":"8120 E 100TH CT","city":"","state":"","zip":""}
## 2 {"address":"8121 E 100TH CT","city":"","state":"","zip":""}
## 3 {"address":"8125 E 100TH CT","city":"","state":"","zip":""}
## 4 {"address":"8126 E 100TH CT","city":"","state":"","zip":""}
## 5 {"address":"","city":"","state":"","zip":""}
## 6 {"address":"","city":"","state":"","zip":""}
## location_2.machine_address location_2.longitude
## 1 NA NA
## 2 NA NA
## 3 NA NA
## 4 NA NA
## 5 NA NA
## 6 NA NA
Variables
The following variables are all NA: location_1.latitude, location_1.machine_address, location_1.longitude, location_2.latitude, location_2.machine_address, location_2.longitude
The following variables are duplicates:
:created_at, :updated_atlocation_1.needs_recoding, location_2.needs_recoding:created_meta, :updated_meta:position, :sid
permit_value
Summary statistics
| Min. |
1 |
| 1st Qu. |
3888 |
| Median |
27000 |
| Mean |
157100 |
| 3rd Qu. |
123200 |
| Max. |
114700000 |
| NA’s |
3 |
number
Summary statistics
| Min. |
0 |
| 1st Qu. |
2112 |
| Median |
5102 |
| Mean |
5457 |
| 3rd Qu. |
8600 |
| Max. |
100000 |
dwelling_units_gained_or_lost
pin
Summary statistics
| Min. |
7 |
| 1st Qu. |
84800 |
| Median |
140800 |
| Mean |
142400 |
| 3rd Qu. |
217900 |
| Max. |
254100 |
| NA’s |
4780 |
how_far_north
Summary statistics
| Min. |
973000 |
| 1st Qu. |
1044000 |
| Median |
1068000 |
| Mean |
1078000 |
| 3rd Qu. |
1122000 |
| Max. |
1161000 |
project_description
Distribution of top 50 variables
Frequency table of top 100 variables
parcel
Distribution of top 50 variables
Frequency table of top 100 variables
applicant_representative
Distribution of top 50 variables
Frequency table of top 100 variables
applicant_name
Distribution of top 50 variables
Frequency table of top 100 variables
legal_description
Distribution of top 50 variables
Frequency table of top 100 variables
subdivision
Distribution of top 50 variables
Frequency table of top 100 variables
name
Distribution of top 50 variables
Frequency table of top 100 variables
how_far_east
Summary statistics
| Min. |
2717000 |
| 1st Qu. |
2763000 |
| Median |
2771000 |
| Mean |
2773000 |
| 3rd Qu. |
2784000 |
| Max. |
2821000 |
permit_number
Summary statistics
| Min. |
200000000 |
| 1st Qu. |
200300000 |
| Median |
200600000 |
| Mean |
200600000 |
| 3rd Qu. |
200900000 |
| Max. |
201000000 |
| NA’s |
1 |
location_1.human_address
Distribution of top 50 variables
Frequency table of top 100 variables
location_2.human_address
Distribution of top 50 variables
Frequency table of top 100 variables