Bedbug Reporting

City of New York

@usgov.city_of_new_york_bedbug_reporting

Table List

1 table(22.8 MB)

Table 1

@usgov.city_of_new_york_bedbug_reporting.table_1

22.8 MB
557858 rows
21 columns

building_id Building ID	registration_id Registration ID	borough Borough	house_number House Number	street_name Street Name	postcode Postcode	n__of_dwelling_units # Of Dwelling Units	filing_date Filing Date	filing_period_start_date Filing Period Start Date	filling_period_end_date Filling Period End Date	latitude Latitude	longitude Longitude	community_board Community Board	council_district Council District	n_2010_census_tract 2010 Census Tract	bin BIN	bbl BBL	nta NTA
344156	306009	BROOKLYN	161	NEWEL STREET	11222	6	Tue Feb 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	40.72768	-73.94903	1	33	573	3065755	3026230011	Greenpoint
733380	500790	STATEN ISLAND	300	EDGEWATER STREET	10305	11	Fri Feb 16 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	40.615778	-74.0633	1	49	6	5042152	5028290070	Rosebank-Shore Acres-Park Hill
355173	322333	BROOKLYN	121	PRESIDENT STREET	11231	4	Fri Apr 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	40.68341	-74.002174	6	39	51	3004456	3003420036	Carroll Gardens-Cobble Hill-Gowanus-Red Hook
924358	346557	BROOKLYN	232	7 AVENUE	11215	6	Tue Dec 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Oct 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	40.670005	-73.978995	6	39	155	3320092	3009830045	Park Slope
926795	429380	QUEENS	66-08	GRAND CENTRAL PARKWAY	11375	9	Thu Apr 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	40.731691	-73.843398	6	24	747	4432143	4021860075	Forest Hills
358122	357464	BROOKLYN	389	PUTNAM AVENUE	11216	3	Mon Jul 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	40.684545	-73.945667	3	36	267	3051701	3018240063	Bedford-Stuyvesant (West)
705843	403865	QUEENS	861	WOODWARD AVENUE	11385	4	Wed May 05 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	40.702903	-73.902286	5	30	585	4083378	4034830034	Ridgewood
877716	379778	BROOKLYN	912	MOTHER GASTON BOULEVARD	11212	3	Thu Jul 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Oct 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	40.656147	-73.903403	16	42	922	3388522	3036390049	Brownsville
233155	302281	BROOKLYN	45	DIAMOND STREET	11222	6	Thu Feb 07 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Nov 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	40.724204	-73.946068	1	33	571	3066934	3026840018	Greenpoint
29583	611270	MANHATTAN	269	WEST 4 STREET	10014	2	Fri Dec 20 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Oct 31 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	40.735736	-74.003388	2	3	73	1010901	1006130002	West Village


CREATE TABLE table_1 (
  "building_id" BIGINT,
  "registration_id" BIGINT,
  "borough" VARCHAR,
  "house_number" VARCHAR,
  "street_name" VARCHAR,
  "postcode" BIGINT,
  "n__of_dwelling_units" DOUBLE,
  "infested_dwelling_unit_count" DOUBLE,
  "eradicated_unit_count" DOUBLE,
  "re_infested_dwelling_unit_count" DOUBLE,
  "filing_date" TIMESTAMP,
  "filing_period_start_date" TIMESTAMP,
  "filling_period_end_date" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "n_2010_census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);