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

About this Dataset

FY17 BID Trends Report Data

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

Tables

Table 1

@usgov.city_of_new_york_fy17_bid_trends_report_data.table_1

67.61 KB
72 rows
63 columns


CREATE TABLE table_1 (
  "bid_name" VARCHAR,
  "borough" VARCHAR,
  "service_area_linear_feet" BIGINT,
  "full_time_staff" BIGINT,
  "sanitation_staff_employed" BIGINT,
  "public_safety_staff_employed" DOUBLE,
  "part_time_staff" DOUBLE,
  "ground_floor_storefront_businesses" BIGINT,
  "upper_level_storefront_businesses" DOUBLE,
  "ground_floor_vacant_storefronts" DOUBLE,
  "upper_level_vacant_storefronts" DOUBLE,
  "bid_provides_supplemental_sanitation_services" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "planters_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,
  "marketing_materials_distributed" BIGINT,
  "public_events_coordinated" BIGINT,
  "estimated_attendees_to_public_events_coordinated" BIGINT,
  "allocates_staff_salaries" VARCHAR,
  "assessment_revenue" BIGINT,
  "contract_revenue" VARCHAR,
  "contributions" VARCHAR,
  "fundraising_and_special_event_revenue" VARCHAR,
  "government_grants" VARCHAR,
  "program_service_revenue" VARCHAR,
  "interest_income" VARCHAR,
  "miscellaneous_income" VARCHAR,
  "total_support_and_revenue" BIGINT,
  "sanitation_expenses" DOUBLE,
  "public_safety_expenses" VARCHAR,
  "marketing_holiday_lighting_and_special_event_expenses" DOUBLE,
  "streetscape_beautification_expenses" VARCHAR,
  "other_program_expenses" VARCHAR,
  "capital_improvement_expenses" VARCHAR,
  "debt_service_expenses" VARCHAR,
  "salaries" VARCHAR,
  "outside_contractor_expenses" VARCHAR,
  "insurance_costs" DOUBLE,
  "rent_and_utilities" DOUBLE,
  "supplies_and_equipment_costs" DOUBLE,
  "other_g_a_expenses" VARCHAR,
  "total_expenses" BIGINT
);