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

About this Dataset

FY16 BID Trends Report Data

Business improvement district (BID) program/service output and expense data from FY16
Organization: City of New York
Last updated: 2020-11-10T17:00:37.091356
Tags: assessment, beautification, bid, business-improvement-district, fy16, marketing, public-safety, sanitation, special-assessment, streetscape, supplemental, trends-report

Tables

Table 1

@usgov.city_of_new_york_fy16_bid_trends_report_data.table_1

62.84 kB
72 rows
57 columns

CREATE TABLE table_1 (
  "bid_name" VARCHAR,
  "block_faces" DOUBLE,
  "full_time_staff" DOUBLE,
  "part_time_staff" DOUBLE,
  "ground_floor_storefront_businesses" BIGINT,
  "bid_provides_supplemental_sanitation_services" VARCHAR,
  "type_of_sanitation_services" VARCHAR,
  "types_of_duties_assigned_to_sanitation_workers" VARCHAR,
  "sanitation_workers_employed" 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" VARCHAR,
  "type_of_public_safety_services" VARCHAR,
  "duties_assigned_to_public_safety_personnel" VARCHAR,
  "public_safety_officers_employed" DOUBLE,
  "hours_logged_by_public_safety_officers" DOUBLE,
  "interactions_with_public_safety_officers" DOUBLE,
  "bid_provides_supplemental_streetscape_and_beautificati_a9c76e24" VARCHAR  -- BID Provides Supplemental Streetscape And Beautification Services,
  "public_spaces_maintained" DOUBLE,
  "planters_maintained" DOUBLE,
  "tree_pits_maintained" DOUBLE,
  "banners_maintained" DOUBLE,
  "pieces_of_street_furniture_maintained" DOUBLE,
  "public_art_installations_sponsored" DOUBLE,
  "bid_has_holiday_lighting_program" VARCHAR,
  "communication_channels_used" VARCHAR,
  "marketing_materials_distributed" BIGINT,
  "public_events_coordinated" BIGINT,
  "estimated_attendees_to_public_events_coordinated" BIGINT,
  "allocates_staff_salaries" VARCHAR,
  "assessment_revenue" DOUBLE,
  "contract_revenue" DOUBLE,
  "contributions" DOUBLE,
  "n__fundraising_and_special_event_revenue" DOUBLE  -- Fundraising And Special Event Revenue,
  "government_grants" DOUBLE,
  "program_service_revenue" DOUBLE,
  "interest_income" DOUBLE,
  "miscellaneous_income" DOUBLE,
  "total_support_and_revenue" DOUBLE,
  "sanitation_expenses" DOUBLE,
  "public_safety_expenses" DOUBLE,
  "marketing_and_special_event_expenses" BIGINT,
  "holiday_lighting_expenses" DOUBLE,
  "beautification_and_horticulture_expenses" DOUBLE,
  "streetscape_and_repairs_expenses" DOUBLE,
  "other_program_expenses" BIGINT,
  "salaries" DOUBLE,
  "outside_contractor_expenses" DOUBLE,
  "insurance_costs" DOUBLE,
  "rent_and_utilities" DOUBLE,
  "supplies_and_equipment_costs" DOUBLE,
  "other_expenses" DOUBLE,
  "capital_improvement_expenses" DOUBLE,
  "debt_service_expenses" DOUBLE,
  "total_expenses" BIGINT
);