Sample
## historicdistrict code :created_at pin unpaidfees
## 1 <NA> EMER 1415829015 <NA> 50
## 2 <NA> NEWC 1415829015 <NA> -2300
## 3 <NA> DEMO 1415829015 <NA> 0
## 4 <NA> EMER 1415829015 <NA> 0
## 5 <NA> ERPR 1415829015 <NA> 0
## 6 <NA> NEWC 1415829015 <NA> 0
## contractors heattype nextstatusdate baths owner
## 1 <NA> <NA> <NA> 0.0 <NA>
## 2 <NA> <NA> <NA> 0.0 <NA>
## 3 <NA> <NA> <NA> 0.0 <NA>
## 4 <NA> <NA> <NA> 0.0 <NA>
## 5 Cls Electric LLC <NA> <NA> 0.0 <NA>
## 6 Michael Hattaway, Michael Hattaway <NA> <NA> 0.0 <NA>
## councildist issuedate :position beds filingdate
## 1 <NA> 2013-12-23T00:00:00 3 0 2006-01-11T00:00:00
## 2 <NA> 2013-08-26T00:00:00 4 0 2006-01-28T00:00:00
## 3 <NA> 2013-03-12T00:00:00 5 0 2006-09-02T00:00:00
## 4 <NA> 2014-02-05T00:00:00 6 0 2007-04-17T00:00:00
## 5 <NA> 2013-04-09T00:00:00 7 0 2007-05-19T00:00:00
## 6 <NA> 2012-07-31T00:00:00 8 0 2008-05-18T00:00:00
## :updated_at projectname :created_meta constrval currentstatusdate
## 1 1415829896 <NA> 394413 10000 2014-01-07T00:00:00
## 2 1415829896 <NA> 394413 306000 2013-08-26T00:00:00
## 3 1415829896 <NA> 394413 3000 2013-03-12T00:00:00
## 4 1449726813 <NA> 394413 45000 2014-02-05T00:00:00
## 5 1415829896 <NA> 394413 0 2013-04-09T00:00:00
## 6 1415829896 <NA> 394413 38000 2013-02-25T00:00:00
## bldgarea nextstatus type division
## 1 0 <NA> Emergency Permit SP
## 2 4969 <NA> New Construction SP
## 3 0 <NA> Demolition SP
## 4 0 <NA> Emergency Permit SP
## 5 0 <NA> Electrical Repair / Replacement / Addition SP
## 6 0 <NA> New Construction SP
## totalinspections
## 1 2
## 2 9
## 3 1
## 4 0
## 5 0
## 6 6
## description
## 1 Work Descripton: HURRICANE DAMAGE REPAIR - SHEETROCK,ELECTRICAL,MECHANICAL,CABINETS,DOORS (2929-29 A Leonidas st).\r\n\r\nHistorical Import Type: Permits Residential Single (One-Family Unit) Emergency Permit\r\nUser: EBROWN\r\nTracking: \r\nStatus: Permit Issuance Active\r\nStatus Date: 12/12/2005 12:00:00 AM\r\n\r\nOwner: Ruby C Morgan\r\nOwner Address: 2929 Leonidas St, New Orleans, LA\r\nOwner Phone: 8665696\r\nOwner Edited By: 12/12/2005 by EBROWN
## 2 Work Descripton: CONSTRUCT NEW 2-STORY SINGLE FAMILY HOUSE\r\n\r\nHistorical Import Type: Permits Residential Single (One-Family Unit) New\r\nUser: EHORAN\r\nTracking: \r\nStatus: Permit Issuance Active\r\nStatus Date: 5/1/2006 12:00:00 AM\r\n\r\nOwner: Joe Bridges J\r\nOwner Address: 107 Finland Pl, New Orleans, LA 70131\r\nOwner Edited By: 12/29/2005 by EHORAN
## 3 Work Descripton: DEMOLISH TO GRADE; HAUL AWAY DEBRIS WITHIN 72 HOURS OF DEMOLITION. APPROVED BY HOUSING CONSERVATION DISTRICT REVIEW COMMITTEE MEETING TO BE HELD ON MONDAY, AUGUST 28, 2006.\r\n\r\nHistorical Import Type: Permits Residential Single (One-Family Unit) Demolition\r\nUser: FEMA1\r\nTracking: \r\nStatus: Certificate Issued No Meter\r\nStatus Date: 10/31/2007 12:00:00 AM\r\n\r\nOwner: Hoa V Nguyen\r\nOwner Address: 208 N Jeff Davis Pkwy, New Orleans, LA\r\nOwner Edited By: 8/3/2006 by FEMA1
## 4 Work Descripton: Hurricane damage to single family dwelling\r\n\r\nHistorical Import Type: Permits Residential Single (One-Family Unit) Emergency Permit\r\nUser: LFRANCOIS\r\nTracking: \r\nStatus: Permit Issuance Active\r\nStatus Date: 4/17/2007 12:00:00 AM\r\n\r\nOwner: Alcide R Lavigne\r\nOwner Address: 4818 Bayou Bend Ct, Alexander, LA 71303\r\nOwner Phone: 3184876000\r\nOwner Edited By: 4/17/2007 by LFRANCOIS
## 5 Work Descripton: VACANCY\r\n\r\nHistorical Import Type: Permits Electrical Residential Repair-Replacement-Addition\r\nUser: DMFOLEY\r\nTracking: \r\nStatus: Permit Issuance Active\r\nStatus Date: 4/19/2007 12:00:00 AM\r\n\r\nOwner: Tracie L Therence\r\nOwner Address: 4534 Cardenas Dr, New Orlean, LA 701270000\r\nOwner Edited By: 4/19/2007 by DMFOLEY
## 6 Work Descripton: New construction of single family dwelling as per plans.\r\nNote: This permit is to complete the construction and raising of structure to meet the BFE. Work was started prior to obtaining a Building Permit.\r\n\r\nHistorical Import Type: Permits Residential Single (One-Family Unit) New\r\nUser: LFRANCOIS\r\nTracking: \r\nStatus: Permit Issuance Active\r\nStatus Date: 6/12/2008 12:00:00 AM\r\n\r\nOwner: Linda Y BlazioOwner Address: 3424 Toledano St, New Orleans, LAOwner Phone: 5049208745Owner Edited By: 5/30/2008 by RMAXWELL
## leadagency basementar zoning daysissued
## 1 City of New Orleans 0 <NA> 15
## 2 City of New Orleans 0 <NA> 0
## 3 City of New Orleans 0 <NA> 0
## 4 City of New Orleans 0 <NA> 672
## 5 City of New Orleans 0 <NA> 0
## 6 City of New Orleans 0 RD-2 209
## currentstatus opencomments bondamount landuseshort
## 1 Certificate of Occupancy 0 0.0 RSF2
## 2 Permit Issuance - Active 2 0.0 RSFD
## 3 Certificate of Completion 0 0.0 RSFD
## 4 Permit Issued 0 0.0 RSFD
## 5 Permit Finaled 0 0.0 UNK
## 6 Certificate of Occupancy 0 0.0 RSFD
## address :updated_meta :sid daysopen subdivision exitreason
## 1 2929 Leonidas St 394413 3 2918 <NA> Finaled
## 2 107 Finland Pl 394413 4 2767 <NA> Finaled
## 3 208 N Jefferson Davis 394413 5 2383 <NA> Finaled
## 4 4105 Rayne Dr 394413 6 3158 <NA> Finaled
## 5 4534 Cardenas Dr 394413 7 2152 <NA> Finaled
## 6 3424 Toledano St 394413 8 1744 <NA> Finaled
## applicant totalfees isclosed :id
## 1 Ruby Morgan 150 true D9AC1441-056D-4CA7-A5B0-D141BE932FC2
## 2 Joe Bridges J -414 true 02A98FA1-F01E-4997-BC10-8DAFDB46AF00
## 3 <NA> 90 true 6D7FEAFA-A804-4C7C-9B0E-E358DA2F3E16
## 4 Alcide Lavigne 275 true F42DF51A-DEA7-4203-8457-781F8A43C1CB
## 5 <NA> 30 true 1C87B621-9B1A-41BD-87BF-C03017DB4F81
## 6 Michael Hattaway 290 true 74A867A0-C481-4DAD-AD19-B8FCB248BE03
## :meta m_s numstring landuse secondfloo location_1.latitude
## 1 NA M 05BLD-05127 Two-Family 0 29.96339
## 2 NA M 05BLD-06907 Single Family 0 29.92493
## 3 NA M 06BLD-05598 Single Family 0 29.97090
## 4 NA M 07BLD-03925 Single Family 0 29.99943
## 5 NA M 07ELC-11986 Unknown 0 30.02034
## 6 NA M 08BLD-02867 Single Family 0 29.94637
## location_1.needs_recoding location_1.human_address
## 1 FALSE NA
## 2 FALSE NA
## 3 FALSE NA
## 4 FALSE NA
## 5 FALSE NA
## 6 FALSE NA
## location_1.machine_address location_1.longitude
## 1 NA -90.12028
## 2 NA -89.99118
## 3 NA -90.09267
## 4 NA -90.07200
## 5 NA -89.96549
## 6 NA -90.09886
Variables
The following variables are all NA: :meta
, location_1.human_address
, location_1.machine_address
The following variables are duplicates:
:position
, :sid
:created_meta
, :updated_meta
basementar
, secondfloo
pin
Distribution of top 50 variables
Frequency table of top 100 variables
unpaidfees
Summary statistics
Min. |
-637500.0000 |
1st Qu. |
0.0000 |
Median |
0.0000 |
Mean |
-0.2625 |
3rd Qu. |
0.0000 |
Max. |
25790.0000 |
contractors
Distribution of top 50 variables
Frequency table of top 100 variables
nextstatusdate
Distribution of top 50 variables
Frequency table of top 100 variables
owner
Distribution of top 50 variables
Frequency table of top 100 variables
issuedate
Distribution of top 50 variables
Frequency table of top 100 variables
filingdate
Distribution of top 50 variables
Frequency table of top 100 variables
constrval
Summary statistics
Min. |
-5000 |
1st Qu. |
0 |
Median |
0 |
Mean |
52260 |
3rd Qu. |
7377 |
Max. |
70600000 |
currentstatusdate
Distribution of top 50 variables
Frequency table of top 100 variables
bldgarea
Summary statistics
Min. |
-1.0 |
1st Qu. |
0.0 |
Median |
0.0 |
Mean |
129.6 |
3rd Qu. |
0.0 |
Max. |
970000.0 |
description
Distribution of top 50 variables
Frequency table of top 100 variables
zoning
Distribution of top 50 variables
Frequency table of top 100 variables
daysissued
Summary statistics
Min. |
0.0 |
1st Qu. |
92.0 |
Median |
416.0 |
Mean |
522.1 |
3rd Qu. |
896.0 |
Max. |
1464.0 |
address
Distribution of top 50 variables
Frequency table of top 100 variables
daysopen
Summary statistics
Min. |
0.0 |
1st Qu. |
112.0 |
Median |
448.0 |
Mean |
544.2 |
3rd Qu. |
923.0 |
Max. |
3158.0 |
subdivision
Distribution of top 50 variables
Frequency table of top 100 variables
applicant
Distribution of top 50 variables
Frequency table of top 100 variables
totalfees
Summary statistics
Min. |
-634400.0 |
1st Qu. |
40.0 |
Median |
85.0 |
Mean |
342.3 |
3rd Qu. |
170.0 |
Max. |
423600.0 |
numstring
Distribution of top 50 variables
Frequency table of top 100 variables
location_1.latitude
Summary statistics
Min. |
28.10 |
1st Qu. |
29.95 |
Median |
29.97 |
Mean |
29.96 |
3rd Qu. |
30.01 |
Max. |
38.61 |
location_1.longitude
Summary statistics
Min. |
-101.50 |
1st Qu. |
-90.10 |
Median |
-90.07 |
Mean |
-90.14 |
3rd Qu. |
-90.03 |
Max. |
-89.74 |