About this Dataset

Snow Response Expenditures

This dataset contains information on the Town's expenditures related to snow preparation and removal from January 2010 to January 2016.

This data represents work orders, labor hours and material costs that were expended and dedicated to snow preparation and removal.

Labor hours include regular hours, overtime hours, and comp earned
Materials can include ice melt, food, propane, kerosene, padlocks, sprayers, salt, screenings, blades, etc.
Salt and screenings costs are included in materials cost when known. However, salt and screenings are replenished regularly resulting in expenditures that may not correspond with a particular weather event.

This dataset is an archive - it is not being updated.
Organization: Town of Cary, North Carolina
Last updated: 2020-11-12T13:15:11.204322
Tags: public-works, snow, weather

Tables

Table 1

@usgov.town_of_cary_north_carolina_snow_response_expenditures.table_1

6.02 kB
34 rows
6 columns

CREATE TABLE table_1 (
  "requestdate" TIMESTAMP,
  "fiscalyear" BIGINT,
  "laborhours" DOUBLE,
  "materialscost" DOUBLE,
  "salttons" DOUBLE,
  "screeningstons" DOUBLE
);