From a 77-row sample across 59 columns.
boroughboroughboroughboroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| bid_name | borough | service_area_linear_feet | full_time_staff | sanitation_workers_employed | public_safety_officers | part_time_staff | individual_businesses | bid_provides_supplemental | type_of_bid_sanitation | types_of_duties_assigned_to_sanitation_workers | days_per_week_sanitation |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 125th Street | MN | 10270 | 3 | 6 | 4 | 1 | 339 | true | Contracted | Street Sweeping and Bagging, Snow and Ice Removal, Graffiti Removal, Gum, Sticker, Posters, and Flyer Removal, Street Furniture Maintenance and Sanitization |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
bid_name | text | — | 0% | Bryant Park CorporationJerome Gun HillChinatown BID |
borough | categorical | — | 1% | MNBKBXof 5 |
service_area_linear_feet | integer | — | 0% | 545604670031420 |
full_time_staff | categorical | — | 0% | 123of 18 |
sanitation_workers_employed |
GET /api/datasets/hzd8-k2vv GET /api/datasets/hzd8-k2vv/quality GET /api/datasets/hzd8-k2vv/related GET /api/columns?dataset=hzd8-k2vv
borough| 6 |
| 161st Street | BX | 5520 | 2 | 2 | 0 | 0 | 98 | true | Contracted | Street Sweeping and Bagging, Power Washing, Snow and Ice Removal, Graffiti Removal, Gum, Sticker, Posters, and Flyer Removal, Street Furniture Maintenance and Sanitization, Event Set-Up and Breakdown (Including Open Streets) | 7 |
| 180th Street | QN | 8150 | 1 | 2 | 4 | 0 | 42 | true | Contracted | Graffiti Removal, Tracking illegal dumping, Removal of illegal dumping. | 1 |
| 34th Street Partnership Inc. | MN | 41110 | 59 | 70 | 36 | 12 | 0 | true | In-House | Street Sweeping and Bagging, Power Washing, Snow and Ice Removal, Graffiti Removal, Gum, Sticker, Posters, and Flyer Removal, Street Furniture Maintenance and Sanitization, Event Set-Up and Breakdown (Including Open Streets) | 7 |
| 82nd Street Partnership | QN | 3460 | 1 | 3 | 0 | 1 | 183 | true | Contracted | Street Sweeping and Bagging, Power Washing, Graffiti Removal, Gum, Sticker, Posters, and Flyer Removal, Street Furniture Maintenance and Sanitization, Horticultural Services & Plant Watering | 7 |
| 86th Street Bay Ridge | BK | 5930 | 0 | 3 | 0 | 2 | 166 | true | Contracted | Street Sweeping and Bagging, Power Washing, Snow and Ice Removal, Graffiti Removal, Street Furniture Maintenance and Sanitization | 7 |
| Atlantic Avenue | BK | 17170 | 2 | 4 | 0 | 1 | 336 | true | Contracted | Street Sweeping and Bagging, Power Washing, Snow and Ice Removal, Graffiti Removal, Gum, Sticker, Posters, and Flyer Removal, Event Set-Up and Breakdown (Including Open Streets) | 7 |
| Bay Ridge 5th Avenue BID | BK | 17210 | 2 | 4 | 0 | 0 | 350 | true | Contracted | Street Sweeping and Bagging, Tracking illegal dumping, Power Washing, Snow and Ice Removal, Graffiti Removal, Gum, Sticker, Posters, and Flyer Removal, Street Furniture Maintenance and Sanitization | 7 |
| Bayside Village | QN | 6690 | 1 | 1 | 0 | 1 | 325 | true | Contracted | Street Sweeping and Bagging, Snow and Ice Removal, Graffiti Removal, Gum, Sticker, Posters, and Flyer Removal, Street Furniture Maintenance and Sanitization, Event Set-Up and Breakdown (Including Open Streets) | 6 |
| Bed-Stuy Gateway | BK | 14310 | 1 | 9 | 1 | 3 | 379 | true | Contracted | Street Sweeping and Bagging, Tracking illegal dumping, Power Washing, Graffiti Removal, Gum, Sticker, Posters, and Flyer Removal, Street Furniture Maintenance and Sanitization, Event Set-Up and Breakdown (Including Open Streets), Snow and Ice Removal, Horticultural Services & Plant Watering, Recycling Collection and/or Sorting | 7 |
Showing 12 of 59 columns. All of them are listed below.
| float |
| — |
| 0% |
234 |
public_safety_officers | categorical | — | 0% | 024of 18 |
part_time_staff | categorical | — | 0% | 102of 17 |
individual_businesses | integer | — | 0% | 0250122 |
bid_provides_supplemental | boolean | — | 1% | Trueof 1 |
occupied_storefronts | integer | — | 3% | 600165187 |
type_of_bid_sanitation | categorical | — | 1% | ContractedIn-HouseBothof 3 |
vacant_storefronts | integer | — | 5% | 15249 |
total_storefronts | integer | — | 3% | 236250230 |
types_of_duties_assigned_to_sanitation_workers | text | — | 1% | Street Sweeping and Bagg…Street Sweeping and Bagg…Street Sweeping and Bagg… |
days_per_week_sanitation | categorical | — | 1% | 763of 5 |
hours_logged_by_sanitation | integer | — | 0% | 93628802496 |
incidents_of_graffiti_removed | integer | — | 0% | 03004 |
type_of_duties_assigned_to | text | — | 1% | Street Sweeping and Bagg…Street Sweeping and Bagg…Street Sweeping and Bagg… |
trash_bags_collected | integer | — | 0% | 45000012000 |
trash_and_recycling | integer | — | 1% | 80098 |
bid_provides_supplemental_1 | boolean | — | 1% | FalseTrueof 2 |
type_of_bid_public_safety | categorical | — | 1% | We do not provide public…ContractedIn-Houseof 4 |
type_of_duties_assigned_to_1 | text | — | 52% | Monitoring Security Came…Street Patrol/Ambassador…Street Patrol/Ambassador… |
hours_dedicated_to_public | integer | — | 49% | 020800576 |
interactions_with_public | integer | — | 49% | 01872015 |
planters_and_hanging_baskets | integer | — | 0% | 0412 |
tree_pits_and_tree_guards | integer | — | 0% | 012190 |
banners_maintained | integer | — | 0% | 03560 |
public_art_installations | categorical | — | 0% | 012of 10 |
bid_provides_supplemental_2 | text | — | 100% | — |
street_furniture_elements | integer | — | 0% | 0615 |
wayfinding_elements | integer | — | 0% | 054 |
lighting_elements | integer | — | 0% | 0115 |
other_infrastructure_elements | integer | — | 0% | 0112 |
public_spaces_maintained | categorical | — | 0% | 012of 16 |
bid_provides_seasonal_holiday | categorical | — | 1% | YesNoof 2 |
communication_channels_used | text | — | 1% | Print Advertising (banne…Print Advertising (banne…Print Advertising (banne… |
total_email_and_social_media | integer | — | 0% | 10000030002500 |
marketing_materials | text | — | 1% | Event-specific posters/f…District guides/Maps/Dir…Event-specific posters/f… |
total_marketing_materials | integer | — | 0% | 05000700 |
public_events_coordinated | integer | — | 0% | 407 |
estimated_attendees_to_public | integer | — | 0% | 100001500 |
assessment_revenue | integer | — | 0% | 500000.00300000.00240000.00 |
contracts | categorical | — | 79% | 700.006021.6410000.00of 16 |
program_service_revenue | float | — | 65% | 2700.003600.004114.00 |
contributions | float | — | 69% | 2000.002247.003000.00 |
fundraising_private_grants | float | — | 44% | 21000.0014000.0020000.00 |
shares_g_a | text | — | 79% | Yesof 1 |
government_grants | float | — | 43% | 75000.0095000.00125000.00 |
interest_income | float | — | 43% | 9614.008974.79885.00 |
misc_income | float | — | 69% | 74.981135.511225.00 |
total_revenue | float | — | 0% | 8477801.921700492.003332797.00 |
sanitation | float | — | 0% | 193160.895309899.0085774.00 |
public_safety | float | — | 53% | 4465119.002284222.8432310105.38 |
marketing_special_events | float | — | 0% | 0.0076921.70596519.00 |
streetscape_and_beautification | float | — | 0% | 0.0019000.00696288.00 |
other_program_expenses | float | — | 0% | 0.001038207.00500.00 |
g_a_salaries_and_payroll | float | — | 10% | 128907.0094248.0083205.52 |
g_a_outside_contractors | float | — | 9% | 40000.00213964.71116750.00 |
g_a_insurance | float | — | 3% | 11485.002625.0035516.00 |
g_a_rent_and_utilities | float | — | 13% | 62368.008897.00131188.00 |
g_a_supplies_and_equipment | float | — | 17% | 20266.0032608.0013819.90 |
g_a_miscellaneous_g_a | float | — | 16% | 4291.0010705.0083588.00 |
capital_improvements_and | categorical | — | 0% | 0.00648141.0076040.78of 13 |
total_expenses | float | — | 0% | 439800.0029550799.00668330.00 |