bloomington-in-gov/cob-employee-covid-cases-per-dept-per-day-tmwq-9djy
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 22 hours ago
Indexed 4 hours ago

COB Employee COVID Cases - per dept per day

Reports of City of Bloomington employees with positive COVID-19 viral test results by department since March 28, 2020. The dataset also includes results from the municipal corporations of the Bloomington Housing Authority, Bloomington Transit, and the City of Bloomington Utilities. Note that results listed as "City Hall" include results from multiple departments whose employees work only at City Hall. These include: Community and Family Resources, Controller, Economic and Sustainable Development, Housing and Neighborhood Development, Human Resources, Information and Technology Services, Mayor's Office, Parks administration, and Public Works administration.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bloomington-in-gov/cob-employee-covid-cases-per-dept-per-day-tmwq-9djy\".\"cob_employee_covid_cases_per_dept_per_day\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • cob_employee_covid_cases_per_dept_per_day