Meta

property value
dataset name Multi Agency Permits
data source City of New York
data level City
description The Multi Agency Permits dataset contains the permits data from two different data sources/exchanges – DOB Jobs Permits and DOHMH Permits
permalink https://data.cityofnewyork.us/City-Government/Multi-Agency-Permits/xfyi-uyt5
dataset key xfyi-uyt5
number of records 4704390
number of variables 30

Sample

##   borough_block_lot :created_at dob_skilled_trades_lic_type         street
## 1        3079280038  1370997875                          OW EAST 52 STREET
## 2        3067560042  1370997875                        <NA> EAST 19 STREET
## 3        3067560042  1370997875                        <NA> EAST 19 STREET
## 4        3067560042  1370997875                          GC EAST 19 STREET
## 5        3067570042  1370997875                          GC   OCEAN AVENUE
## 6        3067570042  1370997875                          GC   OCEAN AVENUE
##   permit_subtype_description :position     city  borough :updated_at
## 1                       <NA>         1 BROOKLYN BROOKLYN  1370997875
## 2                       <NA>         2 BROOKLYN BROOKLYN  1370997875
## 3                       <NA>         3 BROOKLYN BROOKLYN  1370997875
## 4                       <NA>         4 BROOKLYN BROOKLYN  1370997875
## 5                      FENCE         5 BROOKLYN BROOKLYN  1370997875
## 6                       <NA>         6 BROOKLYN BROOKLYN  1370997875
##   permit_type_description :created_meta permit_status_date         source
## 1          EQUIPMENT WORK        435151         1999-06-03 DOB Job Permit
## 2          EQUIPMENT WORK        435151         1997-01-15 DOB Job Permit
## 3          EQUIPMENT WORK        435151         1996-03-25 DOB Job Permit
## 4          EQUIPMENT WORK        435151         1998-12-07 DOB Job Permit
## 5               EQUIPMENT        435151         2010-02-12 DOB Job Permit
## 6          EQUIPMENT WORK        435151         2010-02-12 DOB Job Permit
##   license_permit_holder_name permit_status_description
## 1                       <NA>             PERMIT ISSUED
## 2                       <NA>             PERMIT ISSUED
## 3                       <NA>             PERMIT ISSUED
## 4                       <NA>             PERMIT ISSUED
## 5                       <NA>             PERMIT ISSUED
## 6                       <NA>             PERMIT ISSUED
##   business_description permit_issuance_date building_id
## 1                 <NA>           1999-06-03     3222087
## 2                 <NA>           1997-01-15     3181570
## 3                 <NA>           1996-03-25     3181570
## 4                 <NA>           1998-12-07     3181570
## 5                 <NA>           2010-02-12     3181615
## 6                 <NA>           2010-02-12     3181615
##   license_permit_number zip_code permit_expiration_date
## 1           30043914901    11203             2000-06-02
## 2           30029595402    11230             1997-08-05
## 3           30029595401    11230             1996-08-05
## 4           30029595403    11230             1999-08-05
## 5           32010861901    11230             2010-04-25
## 6           32010861901    11230             2010-04-25
##   dob_skilled_trades_lic_num address :updated_meta :sid
## 1                       <NA>     753        435151    1
## 2                       <NA>    1488        435151    2
## 3                       <NA>    1488        435151    3
## 4                    0008164    1488        435151    4
## 5                    0600253    1954        435151    5
## 6                    0600253    1954        435151    6
##   license_permit_holder latitude_wgs84
## 1                  SAME      40.641806
## 2   A.T.A. CONSTRUCTION      40.613956
## 3   A.T.A. CONSTRUCTION      40.613956
## 4   A.T.A. CONSTRUCTION      40.613956
## 5       VAS & SONS CORP      40.614241
## 6       VAS & SONS CORP      40.614241
##                                    :id :meta longitude_wgs84
## 1 98161E97-47D1-41C0-AA1D-7F7FEE5B0DF9  {\n}       -73.92708
## 2 C5651B8B-4CF1-45CB-8101-E0F73A805A1D  {\n}      -73.955698
## 3 612C8708-BB5B-432A-8050-7C6B63E63BF2  {\n}      -73.955698
## 4 141B1585-0DBC-4D8C-946A-AED7C30A1CFB  {\n}      -73.955698
## 5 0BB44849-FEA3-4B0B-8FF9-C9BE2A86621D  {\n}      -73.954631
## 6 653FD03B-F164-4F27-AEC4-18059086E0E0  {\n}      -73.954631

Missing Values

Variables

The following variables are duplicates:

  • :position, :sid

borough_block_lot

Distribution of top 50 variables

Frequency table of top 100 variables

dob_skilled_trades_lic_type

Distribution of top 50 variables

Frequency table of top 100 variables

street

Distribution of top 50 variables

Frequency table of top 100 variables

permit_subtype_description

Distribution of top 50 variables

Frequency table of top 100 variables

city

Distribution of top 50 variables

Frequency table of top 100 variables

borough

Distribution of top 50 variables

Frequency table of top 100 variables

permit_type_description

Distribution of top 50 variables

Frequency table of top 100 variables

permit_status_date

Distribution of top 50 variables

Frequency table of top 100 variables

source

Distribution of top 50 variables

Frequency table of top 100 variables

license_permit_holder_name

Distribution of top 50 variables

Frequency table of top 100 variables

permit_status_description

Distribution of top 50 variables

Frequency table of top 100 variables

business_description

Distribution of top 50 variables

Frequency table of top 100 variables

permit_issuance_date

Distribution of top 50 variables

Frequency table of top 100 variables

building_id

Distribution of top 50 variables

Frequency table of top 100 variables

license_permit_number

Distribution of top 50 variables

Frequency table of top 100 variables

zip_code

Distribution of top 50 variables

Frequency table of top 100 variables

permit_expiration_date

Distribution of top 50 variables

Frequency table of top 100 variables

dob_skilled_trades_lic_num

Distribution of top 50 variables

Frequency table of top 100 variables

address

Distribution of top 50 variables

Frequency table of top 100 variables

license_permit_holder

Distribution of top 50 variables

Frequency table of top 100 variables

latitude_wgs84

Distribution of top 50 variables

Frequency table of top 100 variables

longitude_wgs84

Distribution of top 50 variables

Frequency table of top 100 variables