Sample
## contractor_9_city contractor_6_type contractor_14_address street_name
## 1 <NA> <NA> <NA> ABERDEEN
## 2 <NA> <NA> <NA> ADA
## 3 <NA> <NA> <NA> ADDISON
## 4 <NA> <NA> <NA> ALTGELD
## 5 <NA> <NA> <NA> ARCHER
## 6 <NA> <NA> <NA> CATHERINE
## contractor_12_phone contractor_10_zipcode contractor_5_phone
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_1_address contractor_5_city :sid _pin10
## 1 <NA> <NA> 1 <NA>
## 2 <NA> <NA> 2 <NA>
## 3 <NA> <NA> 3 <NA>
## 4 <NA> <NA> 4 <NA>
## 5 <NA> <NA> 5 <NA>
## 6 <NA> <NA> 6 12-11-102-122-1009
## contractor_4_zipcode contractor_9_address longitude contractor_7_address
## 1 <NA> <NA> -87.65472 <NA>
## 2 <NA> <NA> -87.66217 <NA>
## 3 <NA> <NA> -87.64488 <NA>
## 4 <NA> <NA> -87.70966 <NA>
## 5 <NA> <NA> -87.69846 <NA>
## 6 <NA> <NA> -87.84534 <NA>
## contractor_1_city latitude contractor_2_name contractor_6_state
## 1 <NA> 41.88920 <NA> <NA>
## 2 <NA> 41.91257 <NA> <NA>
## 3 <NA> 41.94828 <NA> <NA>
## 4 <NA> 41.92640 <NA> <NA>
## 5 <NA> 41.81749 <NA> <NA>
## 6 <NA> 41.97669 <NA> <NA>
## contractor_14_zipcode _permit_type :position
## 1 <NA> PERMIT - ELEVATOR EQUIPMENT 1
## 2 <NA> PERMIT - ELEVATOR EQUIPMENT 2
## 3 <NA> PERMIT - ELEVATOR EQUIPMENT 3
## 4 <NA> PERMIT - ELEVATOR EQUIPMENT 4
## 5 <NA> PERMIT - ELEVATOR EQUIPMENT 5
## 6 <NA> PERMIT - ELEVATOR EQUIPMENT 6
## contractor_15_state contractor_6_name contractor_3_zipcode
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_13_zipcode contractor_15_city contractor_7_name
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_1_zipcode contractor_6_address :meta street_direction
## 1 <NA> <NA> {\n} N
## 2 <NA> <NA> {\n} N
## 3 <NA> <NA> {\n} W
## 4 <NA> <NA> {\n} W
## 5 <NA> <NA> {\n} S
## 6 <NA> <NA> {\n} W
## contractor_8_name contractor_2_state contractor_9_phone
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_14_city contractor_15_name contractor_14_phone
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_10_name contractor_15_phone contractor_14_type
## 1 <NA> NA <NA>
## 2 <NA> NA <NA>
## 3 <NA> NA <NA>
## 4 <NA> NA <NA>
## 5 <NA> NA <NA>
## 6 <NA> NA <NA>
## contractor_2_zipcode contractor_3_address work_description
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_3_city contractor_9_name contractor_7_state _estimated_cost
## 1 <NA> <NA> <NA> 0
## 2 <NA> <NA> <NA> 0
## 3 <NA> <NA> <NA> 0
## 4 <NA> <NA> <NA> 0
## 5 <NA> <NA> <NA> 0
## 6 <NA> <NA> <NA> 0
## contractor_7_phone _amount_waived contractor_12_city contractor_8_state
## 1 <NA> 0 <NA> <NA>
## 2 <NA> 0 <NA> <NA>
## 3 <NA> 0 <NA> <NA>
## 4 <NA> 0 <NA> <NA>
## 5 <NA> 0 <NA> <NA>
## 6 <NA> 0 <NA> <NA>
## contractor_4_name contractor_5_type _total_permit_fee contractor_2_city
## 1 <NA> <NA> 52.5 <NA>
## 2 <NA> <NA> 52.5 <NA>
## 3 <NA> <NA> 105.0 <NA>
## 4 <NA> <NA> 52.5 <NA>
## 5 <NA> <NA> 52.5 <NA>
## 6 <NA> <NA> 52.5 <NA>
## contractor_13_phone contractor_10_address contractor_13_address
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_14_state contractor_8_type
## 1 <NA> <NA>
## 2 <NA> <NA>
## 3 <NA> <NA>
## 4 <NA> <NA>
## 5 <NA> <NA>
## 6 <NA> <NA>
## :id contractor_14_name
## 1 B24640A5-8BD2-44D7-AFA7-63CE2C9A5A41 <NA>
## 2 9C48F88F-7A4D-4D11-8919-98802DDCA33E <NA>
## 3 4669B294-18EE-41FD-82E8-959627D3568A <NA>
## 4 3949CC33-71C5-4ECF-A5F9-975288E40AFF <NA>
## 5 8A7E515E-E89A-444B-A1BD-E8B2564554B8 <NA>
## 6 E7B5768D-7C91-4E25-89A5-0DC925BC1997 <NA>
## contractor_8_zipcode contractor_15_zipcode contractor_3_name
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_6_zipcode contractor_6_city contractor_11_zipcode
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_10_city contractor_2_type contractor_12_zipcode
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_10_type contractor_13_type :updated_at contractor_12_name
## 1 <NA> <NA> 1436247532 <NA>
## 2 <NA> <NA> 1436247532 <NA>
## 3 <NA> <NA> 1436247532 <NA>
## 4 <NA> <NA> 1436247532 <NA>
## 5 <NA> <NA> 1436247532 <NA>
## 6 <NA> <NA> 1436247532 <NA>
## contractor_13_name contractor_12_address :created_meta
## 1 <NA> <NA> 902270
## 2 <NA> <NA> 902270
## 3 <NA> <NA> 902270
## 4 <NA> <NA> 902270
## 5 <NA> <NA> 902270
## 6 <NA> <NA> 902270
## contractor_4_state contractor_5_zipcode contractor_12_state
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_5_state contractor_8_city contractor_9_zipcode
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_7_city contractor_4_city contractor_2_phone
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_11_type contractor_8_address contractor_2_address
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_9_state contractor_9_type contractor_7_zipcode
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_1_type contractor_11_state contractor_4_type
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_11_city contractor_4_phone contractor_13_city
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## contractor_5_name _amount_paid :created_at _issue_date
## 1 <NA> 52.5 1436247532 <NA>
## 2 <NA> 52.5 1436247532 <NA>
## 3 <NA> 105.0 1436247532 <NA>
## 4 <NA> 52.5 1436247532 <NA>
## 5 <NA> 52.5 1436247532 <NA>
## 6 <NA> 52.5 1436247532 <NA>
## contractor_13_state contractor_1_phone contractor_3_state
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 <NA> <NA> <NA>
## _pin9 _pin8 contractor_5_address
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 12-11-102-122-1008 12-11-102-122-1007 <NA>
## contractor_12_type _pin1 _pin3
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> 19-01-129-005-0000 <NA>
## 6 <NA> 12-11-102-121-0000 12-11-102-122-1002
## _pin2 _pin5 id _pin7
## 1 <NA> <NA> 911610 <NA>
## 2 <NA> <NA> 911617 <NA>
## 3 <NA> <NA> 911654 <NA>
## 4 <NA> <NA> 911698 <NA>
## 5 <NA> <NA> 911713 <NA>
## 6 12-11-102-122-1001 12-11-102-122-1004 911722 12-11-102-122-1006
## _pin6 contractor_1_state contractor_3_phone street_number
## 1 <NA> <NA> <NA> 406
## 2 <NA> <NA> <NA> 1664
## 3 <NA> <NA> <NA> 536
## 4 <NA> <NA> <NA> 3255
## 5 <NA> <NA> <NA> 4177
## 6 12-11-102-122-1005 <NA> <NA> 8735
## _pin4 contractor_10_phone contractor_7_type
## 1 <NA> <NA> <NA>
## 2 <NA> <NA> <NA>
## 3 <NA> <NA> <NA>
## 4 <NA> <NA> <NA>
## 5 <NA> <NA> <NA>
## 6 12-11-102-122-1003 <NA> <NA>
## contractor_15_address permit_ contractor_15_type contractor_11_name
## 1 <NA> EV000008 <NA> <NA>
## 2 <NA> EV000015 <NA> <NA>
## 3 <NA> EV000074 <NA> <NA>
## 4 <NA> EV000113 <NA> <NA>
## 5 <NA> EV000128 <NA> <NA>
## 6 <NA> EV016366 <NA> <NA>
## contractor_1_name contractor_8_phone :updated_meta contractor_4_address
## 1 <NA> <NA> 902270 <NA>
## 2 <NA> <NA> 902270 <NA>
## 3 <NA> <NA> 902270 <NA>
## 4 <NA> <NA> 902270 <NA>
## 5 <NA> <NA> 902270 <NA>
## 6 <NA> <NA> 902270 <NA>
## _suffix contractor_10_state contractor_11_phone contractor_11_address
## 1 ST <NA> <NA> <NA>
## 2 ST <NA> <NA> <NA>
## 3 ST <NA> <NA> <NA>
## 4 ST <NA> <NA> <NA>
## 5 AVE <NA> <NA> <NA>
## 6 AVE <NA> <NA> <NA>
## contractor_3_type contractor_6_phone location.latitude
## 1 <NA> <NA> 41.88920
## 2 <NA> <NA> 41.91257
## 3 <NA> <NA> 41.94828
## 4 <NA> <NA> 41.92640
## 5 <NA> <NA> 41.81749
## 6 <NA> <NA> 41.97669
## location.needs_recoding location.human_address location.machine_address
## 1 FALSE <NA> NA
## 2 FALSE <NA> NA
## 3 FALSE <NA> NA
## 4 FALSE <NA> NA
## 5 FALSE <NA> NA
## 6 FALSE <NA> NA
## location.longitude
## 1 -87.65472
## 2 -87.66217
## 3 -87.64488
## 4 -87.70966
## 5 -87.69846
## 6 -87.84534
Variables
The following variables are all NA: contractor_15_phone
, location.machine_address
The following variables are duplicates:
contractor_9_city
Distribution of top 50 variables
Frequency table of top 100 variables
street_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_10_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_5_phone
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_1_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_5_city
Distribution of top 50 variables
Frequency table of top 100 variables
_pin10 ##
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_4_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_9_address
Distribution of top 50 variables
Frequency table of top 100 variables
longitude
Summary statistics
Min. |
-87.91 |
1st Qu. |
-87.71 |
Median |
-87.66 |
Mean |
-87.67 |
3rd Qu. |
-87.63 |
Max. |
-87.52 |
NA’s |
1228.00 |
contractor_7_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_1_city
Distribution of top 50 variables
Frequency table of top 100 variables
latitude
Summary statistics
Min. |
41.64 |
1st Qu. |
41.80 |
Median |
41.89 |
Mean |
41.87 |
3rd Qu. |
41.93 |
Max. |
42.02 |
NA’s |
1228.00 |
contractor_2_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_6_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_3_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_7_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_1_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_6_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_8_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_2_state
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_9_phone
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_10_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_2_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_3_address
Distribution of top 50 variables
Frequency table of top 100 variables
work_description
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_3_city
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_9_name
Distribution of top 50 variables
Frequency table of top 100 variables
_estimated_cost ##
Summary statistics
Min. |
-1000 |
1st Qu. |
450 |
Median |
3500 |
Mean |
225500 |
3rd Qu. |
18000 |
Max. |
10000000000 |
NA’s |
449 |
contractor_7_phone
Distribution of top 50 variables
Frequency table of top 100 variables
_amount_waived ##
Summary statistics
Min. |
0.01 |
1st Qu. |
75.00 |
Median |
200.00 |
Mean |
8243.00 |
3rd Qu. |
1069.00 |
Max. |
41200000.00 |
contractor_4_name
Distribution of top 50 variables
Frequency table of top 100 variables
_total_permit_fee ##
Summary statistics
Min. |
0.01 |
1st Qu. |
50.00 |
Median |
175.00 |
Mean |
895.70 |
3rd Qu. |
350.00 |
Max. |
41200000.00 |
contractor_2_city
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_10_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_8_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_3_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_6_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_6_city
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_11_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_10_city
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_12_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_12_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_4_state
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_5_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_8_city
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_9_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_7_city
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_4_city
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_2_phone
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_8_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_2_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_7_zipcode
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_11_city
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_4_phone
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_5_name
Distribution of top 50 variables
Frequency table of top 100 variables
_amount_paid ##
Summary statistics
Min. |
0.01 |
1st Qu. |
50.00 |
Median |
174.90 |
Mean |
630.40 |
3rd Qu. |
335.00 |
Max. |
799700.00 |
_issue_date ##
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_1_phone
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_3_state
Distribution of top 50 variables
Frequency table of top 100 variables
_pin9 ##
Distribution of top 50 variables
Frequency table of top 100 variables
_pin8 ##
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_5_address
Distribution of top 50 variables
Frequency table of top 100 variables
_pin1 ##
Distribution of top 50 variables
Frequency table of top 100 variables
_pin3 ##
Distribution of top 50 variables
Frequency table of top 100 variables
_pin2 ##
Distribution of top 50 variables
Frequency table of top 100 variables
_pin5 ##
Distribution of top 50 variables
Frequency table of top 100 variables
id
Summary statistics
Min. |
911600 |
1st Qu. |
1901000 |
Median |
2218000 |
Mean |
2196000 |
3rd Qu. |
2488000 |
Max. |
2720000 |
_pin7 ##
Distribution of top 50 variables
Frequency table of top 100 variables
_pin6 ##
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_1_state
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_3_phone
Distribution of top 50 variables
Frequency table of top 100 variables
street_number
Summary statistics
Min. |
1 |
1st Qu. |
1001 |
Median |
2735 |
Mean |
3485 |
3rd Qu. |
5401 |
Max. |
111600 |
_pin4 ##
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_10_phone
Distribution of top 50 variables
Frequency table of top 100 variables
permit_
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_11_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_1_name
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_8_phone
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_4_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_11_address
Distribution of top 50 variables
Frequency table of top 100 variables
contractor_6_phone
Distribution of top 50 variables
Frequency table of top 100 variables
location.latitude
Summary statistics
Min. |
41.64 |
1st Qu. |
41.80 |
Median |
41.89 |
Mean |
41.87 |
3rd Qu. |
41.93 |
Max. |
42.02 |
NA’s |
1228.00 |
location.longitude
Summary statistics
Min. |
-87.91 |
1st Qu. |
-87.71 |
Median |
-87.66 |
Mean |
-87.67 |
3rd Qu. |
-87.63 |
Max. |
-87.52 |
NA’s |
1228.00 |