Name: FY20 BID Trends Report Data
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

FY20 BID Trends Report Data

Business improvement district (BID) program/service output and expense data from FY20
Organization: City of New York
Last updated: 2021-08-07T16:35:03.525686
Tags: assessment, beautification, bid, business-improvement-district, fy20, marketing, public-safety, sanitation, special-assessment, streetscape, supplemental, trends-report

Tables

Table 1

@usgov.city_of_new_york_fy20_bid_trends_report_data.table_1

75.81 KB
76 rows
68 columns


CREATE TABLE table_1 (
  "bid_name" VARCHAR,
  "borough" VARCHAR,
  "service_area_linear_feet" BIGINT,
  "full_time_staff" BIGINT,
  "sanitation_staff_employed" DOUBLE,
  "public_safety_staff_employed" DOUBLE,
  "part_time_staff" DOUBLE,
  "individual_businesses_retail_restaurant_office_etc" VARCHAR,
  "occupied_storefronts" VARCHAR,
  "vacant_storefronts" VARCHAR,
  "total_storefronts" VARCHAR,
  "bid_provides_supplemental_sanitation_services" BOOLEAN,
  "type_of_sanitation_services" VARCHAR,
  "types_of_duties_assigned_to_sanitation_workers" VARCHAR,
  "days_per_week_of_sanitation_services" DOUBLE,
  "hours_logged_by_sanitation_workers" DOUBLE,
  "incidents_of_graffiti_removed" DOUBLE,
  "trash_bags_collected" DOUBLE,
  "trash_and_recycling_receptacles_serviced" DOUBLE,
  "bid_provides_supplemental_public_safety_services" BOOLEAN,
  "type_of_public_safety_services" VARCHAR,
  "duties_assigned_to_public_safety_personnel" VARCHAR,
  "hours_logged_by_public_safety_officers" DOUBLE,
  "interactions_with_public_safety_officers" DOUBLE,
  "bid_provides_supplemental_streetscape_and_beautificati_a9c76e24" BOOLEAN,
  "planters_and_hanging_baskets_maintained" DOUBLE,
  "tree_pits_maintained" DOUBLE,
  "banners_maintained" DOUBLE,
  "public_art_installations_sponsored" DOUBLE,
  "street_furniture_elements_maintained" DOUBLE,
  "wayfinding_elements_maintained" DOUBLE,
  "lighting_elements_maintained" DOUBLE,
  "other_infrastructure_elements_maintained" DOUBLE,
  "public_spaces_maintained" DOUBLE,
  "bid_has_holiday_lighting_program" VARCHAR,
  "communication_channels_used" VARCHAR,
  "email_distribution_list" VARCHAR,
  "social_media_followers" VARCHAR,
  "marketing_materials_distributed" DOUBLE,
  "public_events_coordinated" DOUBLE,
  "estimated_attendees_to_public_events_coordinated" DOUBLE,
  "face_coverings_distributed" DOUBLE,
  "hand_sanitizer_distributed" VARCHAR,
  "gloves_distributed" VARCHAR,
  "business_grant_or_loan_applications_assisted" VARCHAR,
  "allocates_staff_salaries" VARCHAR,
  "assessment_revenue" BIGINT,
  "contract_revenue" VARCHAR,
  "program_service_revenue" DOUBLE,
  "contributions" DOUBLE,
  "fundraising_and_special_event_revenue" DOUBLE,
  "government_grants" DOUBLE,
  "interest_income" DOUBLE,
  "miscellaneous_income" DOUBLE,
  "total_support_and_revenue" BIGINT,
  "sanitation_expenses" DOUBLE,
  "marketing_holiday_lighting_and_special_event_expenses" BIGINT,
  "public_safety_expenses" DOUBLE,
  "streetscape_beautification_expenses" DOUBLE,
  "other_program_expenses" DOUBLE,
  "capital_improvement_expenses" DOUBLE,
  "salaries" DOUBLE,
  "outside_contractor_expenses" DOUBLE,
  "insurance_costs" DOUBLE,
  "rent_and_utilities" DOUBLE,
  "supplies_and_equipment_costs" DOUBLE,
  "other_g_a_expenses" DOUBLE,
  "total_expenses" BIGINT
);