Baselight

Certificate Of Occupancy

District of Columbia

@usgov.district_of_columbia_certificate_of_occupancy

Table 1
@usgov.district_of_columbia_certificate_of_occupancy.table_1

  • 9.67 MB
  • 74953 rows
  • 35 columns
x

X

y

Y

permit_number

PERMIT NUMBER

issue_date

ISSUE DATE

address

ADDRESS

ward

WARD

description_of_occupancy

DESCRIPTION OF OCCUPANCY

permission_granted_to

PERMISSION GRANTED TO

trading_as

TRADING AS

occupancy_load

OCCUPANCY LOAD

property_owner

PROPERTY OWNER

owner_address

OWNER ADDRESS

b_z_a_number

B Z A NUMBER

approved_building_code_use

APPROVED BUILDING CODE USE

approved_zoning_use

APPROVED ZONING USE

application_comments

APPLICATION COMMENTS

expiration_date

EXPIRATION DATE

mar_id

MAR ID

x_coordinate

X COORDINATE

y_coordinate

Y COORDINATE

latitude

LATITUDE

longitude

LONGITUDE

dcs_last_mod_dttm

DCS LAST MOD DTTM

floors_occupied

FLOORS OCCUPIED

zone

ZONE

ssl

SSL

approved_zoning_general_use

APPROVED ZONING GENERAL USE

occupied_sq_footage

OCCUPIED SQ FOOTAGE

approved_cofo

APPROVED COFO

occpnt_tot_num_of_dwell_units

OCCPNT TOT NUM OF DWELL UNITS

total_fee

TOTAL FEE

permitnumbers

PERMITNUMBERS

conditional_restriction

CONDITIONAL RESTRICTION

approved_build_code_use_other

APPROVED BUILD CODE USE OTHER

objectid

OBJECTID

-8574978.118584974707503.74365531CO0800255Tue Sep 09 2008 04:00:00 GMT+0000 (Coordinated Universal Time)1300 I ST NW, WASHINGTON, DCWard 2OFFICE SPACELEGAL PLACEMENTS INCORPORATEDLEGAL PLACEMENTS INCORPORATED1300 I ST NW, WASHINGTON, DCOFFICE - B240649397368.51137018.3438.90101435-77.03033676Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)7TH FLR.0250 00516147OWNERSHIP CHANGE80ACCELA59672196
-8576341.119723824708803.43292068CO0800260Thu Sep 11 2008 04:00:00 GMT+0000 (Coordinated Universal Time)11 DUPONT CIR NW, WASHINGTON, DCWard 2OFFICE SPACEBARNES RICHARDSON & COLBURNBARNES RICHARDSON & COLBURN11 DUPONT CIR NW, WASHINGTON, DCOFFICE - B225450396306.9138027.3338.9101002-77.0425808Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)PART OF 5TH FLR.0136 0035279043ACCELA59672197
-8576481.312590114707052.61768506CO0800264Tue Sep 16 2008 04:00:00 GMT+0000 (Coordinated Universal Time)600 19TH ST NW, WASHINGTON, DCWard 2ANCILLARY USE -CHILD DEVELOPMENT/EDUCATIONAL FOR 22 INFANTS/ 105 CHILDREN/29 STAFF ON PART OF 1ST/2ND FLOORS PER PUD (ZC#640) IN THE R-5-D DISTRICT ZONE.KNOWLEDGE LEARNING CORPORATIONKNOWLEDGE LEARNING CORPORATION600 19TH ST NW, WASHINGTON, DCOTHER (SPECIFY)241087396197.02136668.7138.89786081-77.04384017Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)1ST,2ND FLR.0121 082014760LOAD CHANGE127114ACCELA59672198
-8575063.160764944713165.59768854CO0800272Fri Sep 19 2008 04:00:00 GMT+0000 (Coordinated Universal Time)1354 TAYLOR ST NW, WASHINGTON, DCWard 4TWO FAMILY FLAT: 1 UNIT IN BASEMENT AND 1 UNIT ON 1ST/2ND FLOORS.SHELLY R. PARKERSHELLY R. PARKER1354 TAYLOR ST NW, WASHINGTON, DC 20011-5508TWO-FAMILY FLAT - R-3255348397303.74141411.0638.94058553-77.0311007Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)32823 00994708USE CHANGE76ACCELA59672199
-8571854.594267374706522.25479069CO0800408Fri Oct 17 2008 04:00:00 GMT+0000 (Coordinated Universal Time)318 3RD ST NE, WASHINGTON, DCWard 6ARTIST'S STUDIO 318 REAR 3RD STREET NE. WASHINGTON, DC. 20002CREATIVITY, INC.CREATIVITY, INC.CREATIVITY, INC.7704 TAUXEMONT RD, ALEXANDRIA, VA 22308-1055ARTISTS STUDIO - B39225399802.41136256.1838.89415246-77.00227767Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)1ST, 2ND.0756 00411500OWNERSHIP CHANGE76ACCELA59672200
-8577333.132364314710835.94119126CO0800416Tue Sep 30 2008 04:00:00 GMT+0000 (Coordinated Universal Time)2625 CONNECTICUT AVE NW, WASHINGTON, DCWard 3CHANGE OF OWNERSHIP RESTAURANT SEATING 32PERAK CORPORATIONIPOHPERAK CORPORATION3636 16TH STREET #B509, WASHINGTON, DC 20036-1808RESTAURANTS - A-2219098395534.89139604.7138.92430618-77.0514922Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)2ND2204 01301200OWNERSHIP CHANGE3276ACCELA59672201
-8575318.262294954709502.71208658CO0800418Fri Oct 03 2008 04:00:00 GMT+0000 (Coordinated Universal Time)1437 SWANN ST NW, WASHINGTON, DCWard 2TWO UNIT FLAT: ONE UNIT IN BASEMENT AND 1 UNIT ON 1ST AND 2ND FLOORS.EDWARD M SZROMEDWARD M SZROM1437 SWANN ST NW, WASHINGTON, DC 20009-3903TWO-FAMILY FLAT - R-3239999397104.03138569.5938.91498805-77.03339232Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)1ST-2ND W/BSMT.0206 00621500OWNERSHIP CHANGE276ACCELA59672202
-8569746.062119134706683.44149531CO0800423Tue Sep 30 2008 04:00:00 GMT+0000 (Coordinated Universal Time)409 15TH ST NE, WASHINGTON, DCWard 7RESTAURANT SEATING 10YEON KIMOLD COUNTRY DELIJI YONG LEE14002 FEMIE FIELD, LAUREL, MD 20707RESTAURANTS - A-227128401445.56136381.4138.89527974-76.98333641Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)1STR-5-B4544 01741200OWNERSHIP CHANGE1076ACCELA59672203
-8574150.047353564711452.43104394CO0800430Wed Oct 01 2008 04:00:00 GMT+0000 (Coordinated Universal Time)3013 GEORGIA AVE NW, WASHINGTON, DCWard 1PREPARED FOOD SHOP (NO SEATS)ROMBO, INC.BEAUTY DELYMANUEL C. SOLLOCO5920 GREENTREE RD, BETHESDA, MD 20817-3460DELI - B229484398014.53140081.9638.92861416-77.02289807Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)1STC-2-A3052 0116850USE CHANGE76ACCELA59672204
-8575208.84559864712685.79153081CO0900004Thu Oct 02 2008 04:00:00 GMT+0000 (Coordinated Universal Time)3703 14TH ST NW, WASHINGTON, DCWard 4ONE APARTMENT IN ON 3RD FLOOR OF AN MIXED USE BUILDING. LOT: 0011 SQUARE: 2826PEDRO TELLEZPEDRO TELLEZ12710 VEIRS MILL ROAD #2, ROCKVILLE, MD 20853APARTMENT HOUSES - R-2225232397190.15141038.9438.93723301-77.03240941Fri Apr 25 2025 09:00:44 GMT+0000 (Coordinated Universal Time)3RDC-2-A2826 00111200OWNERSHIP CHANGE476ACCELA59672205

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "permit_number" VARCHAR,
  "issue_date" TIMESTAMP,
  "address" VARCHAR,
  "ward" VARCHAR,
  "description_of_occupancy" VARCHAR,
  "permission_granted_to" VARCHAR,
  "trading_as" VARCHAR,
  "occupancy_load" VARCHAR,
  "property_owner" VARCHAR,
  "owner_address" VARCHAR,
  "b_z_a_number" VARCHAR,
  "approved_building_code_use" VARCHAR,
  "approved_zoning_use" VARCHAR,
  "application_comments" VARCHAR,
  "expiration_date" TIMESTAMP,
  "mar_id" BIGINT,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "dcs_last_mod_dttm" TIMESTAMP,
  "floors_occupied" VARCHAR,
  "zone" VARCHAR,
  "ssl" VARCHAR,
  "approved_zoning_general_use" VARCHAR,
  "occupied_sq_footage" DOUBLE,
  "approved_cofo" VARCHAR,
  "occpnt_tot_num_of_dwell_units" VARCHAR,
  "total_fee" BIGINT,
  "permitnumbers" VARCHAR,
  "conditional_restriction" VARCHAR,
  "approved_build_code_use_other" VARCHAR,
  "objectid" BIGINT
);

Share link

Anyone who has the link will be able to view this.