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
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
Summary statistics
Min. |
1 |
1st Qu. |
600 |
Median |
2000 |
Mean |
24260 |
3rd Qu. |
12500 |
Max. |
21680000 |
number
Summary statistics
Min. |
0 |
1st Qu. |
1826 |
Median |
3819 |
Mean |
4384 |
3rd Qu. |
6144 |
Max. |
16320 |
NA’s |
6 |
dwelling_units_gained_or_lost
how_far_north
Summary statistics
Min. |
976500 |
1st Qu. |
1038000 |
Median |
1055000 |
Mean |
1057000 |
3rd Qu. |
1069000 |
Max. |
1160000 |
name
Summary statistics
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
Summary statistics
Min. |
2722000 |
1st Qu. |
2765000 |
Median |
2772000 |
Mean |
2773000 |
3rd Qu. |
2779000 |
Max. |
2821000 |
permit_number
Summary statistics
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