Sample
## council_district permit_value :created_at school_district number month
## 1 NA 0 1362414516 NA 5201 3
## 2 NA 2200 1362414516 NA 2737 4
## 3 NA 10000 1362414516 NA 2737 4
## 4 NA 21402 1362414516 NA 2737 2
## 5 NA 10000 1362414516 NA 1100 4
## 6 NA 4000 1362414516 NA 1100 11
## county prefix owner_name year dwelling_units_gained_or_lost :position
## 1 NA E NA 1991 1 1
## 2 NA NE NA 1990 0 2
## 3 NA NE NA 1990 0 3
## 4 NA NE NA 1994 0 4
## 5 NA NW NA 1992 0 5
## 6 NA NW NA 1993 0 6
## suffix pin :updated_at :created_meta res_non fraction
## 1 ST NA 1362414516 701271 Residential NA
## 2 ST NA 1362414516 701271 Non-Residential NA
## 3 ST NA 1362414516 701271 Non-Residential NA
## 4 ST NA 1362414516 701271 Non-Residential NA
## 5 ST NA 1362414516 701271 Residential NA
## 6 ST NA 1362414516 701271 Residential NA
## structure_class how_far_north type
## 1 NA 1043511 Demolition
## 2 NA 1100459 Additions, Alterations, Repairs
## 3 NA 1100459 Additions, Alterations, Repairs
## 4 NA 1100459 Additions, Alterations, Repairs
## 5 NA 1103037 Additions, Alterations, Repairs
## 6 NA 1103037 Additions, Alterations, Repairs
## sf_mf project_description parcel applicant_representative
## 1 Single Family NA NA NA
## 2 NA NA NA NA
## 3 NA NA NA NA
## 4 NA NA NA NA
## 5 NA NA NA NA
## 6 NA NA NA NA
## :updated_meta :sid day applicant_name legal_description
## 1 701271 1 14 NA NA
## 2 701271 2 12 NA NA
## 3 701271 3 27 NA NA
## 4 701271 4 17 NA NA
## 5 701271 5 17 NA NA
## 6 701271 6 2 NA NA
## class_description subdivision name how_far_east
## 1 NA NA 51 2781803
## 2 NA NA 52ND 2775809
## 3 NA NA 52ND 2775809
## 4 NA NA 52ND 2775809
## 5 NA NA 56TH 2761551
## 6 NA NA 56TH 2761551
## :id :meta permit_number
## 1 39FE28B7-018A-4F91-9DEB-331320E504C1 {\n} 9112266
## 2 FF6F353B-3722-463D-9397-6827A02412B7 {\n} 9013776
## 3 6A8A9868-E357-4617-8E01-BFB7522F3D95 {\n} 9014423
## 4 EE0522A3-164E-47DB-A95D-94979FD49889 {\n} 9411715
## 5 CE000CC1-7B3A-45BD-B5A7-4B5D960AD329 {\n} 9213998
## 6 F5D432C5-C65F-4D32-B8DC-2B846A11C522 {\n} 9321410
## location_2.latitude location_2.needs_recoding
## 1 NA TRUE
## 2 NA TRUE
## 3 NA TRUE
## 4 NA TRUE
## 5 NA TRUE
## 6 NA TRUE
## location_2.human_address location_2.machine_address
## 1 {"address":"","city":"","state":"","zip":""} NA
## 2 {"address":"","city":"","state":"","zip":""} NA
## 3 {"address":"","city":"","state":"","zip":""} NA
## 4 {"address":"","city":"","state":"","zip":""} NA
## 5 {"address":"","city":"","state":"","zip":""} NA
## 6 {"address":"","city":"","state":"","zip":""} NA
## location_2.longitude location_1.latitude location_1.needs_recoding
## 1 NA NA TRUE
## 2 NA NA TRUE
## 3 NA NA TRUE
## 4 NA NA TRUE
## 5 NA NA TRUE
## 6 NA NA TRUE
## location_1.human_address
## 1 {"address":"5201 E 51 ST","city":"","state":"","zip":""}
## 2 {"address":"2737 NE 52ND ST","city":"","state":"","zip":""}
## 3 {"address":"2737 NE 52ND ST","city":"","state":"","zip":""}
## 4 {"address":"2737 NE 52ND ST","city":"","state":"","zip":""}
## 5 {"address":"1100 NW 56TH ST","city":"","state":"","zip":""}
## 6 {"address":"1100 NW 56TH 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: council_district, school_district, county, owner_name, pin, fraction, structure_class, project_description, parcel, applicant_representative, applicant_name, legal_description, class_description, subdivision, location_2.latitude, location_2.machine_address, location_2.longitude, location_1.latitude, location_1.machine_address, location_1.longitude
The following variables are duplicates:
:position, :sid:created_at, :updated_at:created_meta, :updated_metalocation_2.needs_recoding, location_1.needs_recoding
permit_value
Summary statistics
| Min. |
25 |
| 1st Qu. |
6000 |
| Median |
37000 |
| Mean |
118100 |
| 3rd Qu. |
87700 |
| Max. |
47890000 |
| NA’s |
1 |
number
Summary statistics
| Min. |
0 |
| 1st Qu. |
1816 |
| Median |
4414 |
| Mean |
4882 |
| 3rd Qu. |
7504 |
| Max. |
16400 |
dwelling_units_gained_or_lost
how_far_north
Summary statistics
| Min. |
971900 |
| 1st Qu. |
1045000 |
| Median |
1065000 |
| Mean |
1073000 |
| 3rd Qu. |
1113000 |
| Max. |
1161000 |
name
Distribution of top 50 variables
Frequency table of top 100 variables
how_far_east
Summary statistics
| Min. |
2721000 |
| 1st Qu. |
2762000 |
| Median |
2769000 |
| Mean |
2770000 |
| 3rd Qu. |
2779000 |
| Max. |
2821000 |
permit_number
Summary statistics
| Min. |
9010000 |
| 1st Qu. |
9221000 |
| Median |
9518000 |
| Mean |
23200000 |
| 3rd Qu. |
9809000 |
| Max. |
200000000 |
location_1.human_address
Distribution of top 50 variables
Frequency table of top 100 variables