ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where "date" is on date 2020-03-24 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10405 | 10405 | 2020-03-24 | Ashland | Ohio | 39005 | 1 | 0 |
10406 | 10406 | 2020-03-24 | Ashtabula | Ohio | 39007 | 3 | 0 |
10407 | 10407 | 2020-03-24 | Belmont | Ohio | 39013 | 2 | 0 |
10408 | 10408 | 2020-03-24 | Butler | Ohio | 39017 | 18 | 0 |
10409 | 10409 | 2020-03-24 | Carroll | Ohio | 39019 | 3 | 0 |
10410 | 10410 | 2020-03-24 | Champaign | Ohio | 39021 | 1 | 0 |
10411 | 10411 | 2020-03-24 | Clark | Ohio | 39023 | 2 | 0 |
10412 | 10412 | 2020-03-24 | Clermont | Ohio | 39025 | 5 | 0 |
10413 | 10413 | 2020-03-24 | Clinton | Ohio | 39027 | 1 | 0 |
10414 | 10414 | 2020-03-24 | Columbiana | Ohio | 39029 | 3 | 0 |
10415 | 10415 | 2020-03-24 | Coshocton | Ohio | 39031 | 3 | 0 |
10416 | 10416 | 2020-03-24 | Crawford | Ohio | 39033 | 1 | 0 |
10417 | 10417 | 2020-03-24 | Cuyahoga | Ohio | 39035 | 167 | 2 |
10418 | 10418 | 2020-03-24 | Darke | Ohio | 39037 | 1 | 0 |
10419 | 10419 | 2020-03-24 | Defiance | Ohio | 39039 | 2 | 0 |
10420 | 10420 | 2020-03-24 | Delaware | Ohio | 39041 | 11 | 0 |
10421 | 10421 | 2020-03-24 | Erie | Ohio | 39043 | 1 | 1 |
10422 | 10422 | 2020-03-24 | Fairfield | Ohio | 39045 | 2 | 0 |
10423 | 10423 | 2020-03-24 | Franklin | Ohio | 39049 | 75 | 2 |
10424 | 10424 | 2020-03-24 | Gallia | Ohio | 39053 | 1 | 1 |
10425 | 10425 | 2020-03-24 | Geauga | Ohio | 39055 | 5 | 0 |
10426 | 10426 | 2020-03-24 | Greene | Ohio | 39057 | 3 | 0 |
10427 | 10427 | 2020-03-24 | Hamilton | Ohio | 39061 | 38 | 0 |
10428 | 10428 | 2020-03-24 | Hancock | Ohio | 39063 | 1 | 0 |
10429 | 10429 | 2020-03-24 | Highland | Ohio | 39071 | 1 | 0 |
10430 | 10430 | 2020-03-24 | Huron | Ohio | 39077 | 2 | 0 |
10431 | 10431 | 2020-03-24 | Knox | Ohio | 39083 | 1 | 0 |
10432 | 10432 | 2020-03-24 | Lake | Ohio | 39085 | 11 | 0 |
10433 | 10433 | 2020-03-24 | Licking | Ohio | 39089 | 2 | 0 |
10434 | 10434 | 2020-03-24 | Logan | Ohio | 39091 | 2 | 0 |
10435 | 10435 | 2020-03-24 | Lorain | Ohio | 39093 | 30 | 0 |
10436 | 10436 | 2020-03-24 | Lucas | Ohio | 39095 | 11 | 1 |
10437 | 10437 | 2020-03-24 | Madison | Ohio | 39097 | 1 | 0 |
10438 | 10438 | 2020-03-24 | Mahoning | Ohio | 39099 | 28 | 0 |
10439 | 10439 | 2020-03-24 | Marion | Ohio | 39101 | 4 | 0 |
10440 | 10440 | 2020-03-24 | Medina | Ohio | 39103 | 15 | 0 |
10441 | 10441 | 2020-03-24 | Miami | Ohio | 39109 | 19 | 0 |
10442 | 10442 | 2020-03-24 | Montgomery | Ohio | 39113 | 10 | 0 |
10443 | 10443 | 2020-03-24 | Portage | Ohio | 39133 | 4 | 0 |
10444 | 10444 | 2020-03-24 | Richland | Ohio | 39139 | 4 | 0 |
10445 | 10445 | 2020-03-24 | Sandusky | Ohio | 39143 | 1 | 0 |
10446 | 10446 | 2020-03-24 | Stark | Ohio | 39151 | 13 | 1 |
10447 | 10447 | 2020-03-24 | Summit | Ohio | 39153 | 36 | 0 |
10448 | 10448 | 2020-03-24 | Trumbull | Ohio | 39155 | 4 | 0 |
10449 | 10449 | 2020-03-24 | Tuscarawas | Ohio | 39157 | 3 | 0 |
10450 | 10450 | 2020-03-24 | Union | Ohio | 39159 | 2 | 0 |
10451 | 10451 | 2020-03-24 | Warren | Ohio | 39165 | 7 | 0 |
10452 | 10452 | 2020-03-24 | Washington | Ohio | 39167 | 1 | 0 |
10453 | 10453 | 2020-03-24 | Wood | Ohio | 39173 | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);