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 |
## 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
The following variables are duplicates:
:position
, :sid