ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,233 rows where deaths = 3 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Harrison 104
- Williams 88
- Auglaize 73
- Champaign 62
- Unknown 60
- Logan 55
- Carroll 53
- Vinton 49
- Van Wert 43
- Highland 42
- Holmes 36
- Ashland 35
- Union 35
- Brown 34
- Guernsey 31
- Madison 31
- Erie 29
- Defiance 28
- Shelby 26
- Fairfield 18
- Clermont 16
- Huron 16
- Muskingum 16
- Ross 16
- Hancock 15
- Seneca 15
- Delaware 14
- Perry 14
- Richland 14
- Jefferson 13
- …
state 1
- Ohio · 1,233 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1555616 | 1555616 | 2021-07-26 | Unknown | Ohio | 0 | 3 | |
1552369 | 1552369 | 2021-07-25 | Unknown | Ohio | 0 | 3 | |
1549122 | 1549122 | 2021-07-24 | Unknown | Ohio | 0 | 3 | |
1545875 | 1545875 | 2021-07-23 | Unknown | Ohio | 0 | 3 | |
1542628 | 1542628 | 2021-07-22 | Unknown | Ohio | 0 | 3 | |
1539380 | 1539380 | 2021-07-21 | Unknown | Ohio | 0 | 3 | |
1536133 | 1536133 | 2021-07-20 | Unknown | Ohio | 0 | 3 | |
1532885 | 1532885 | 2021-07-19 | Unknown | Ohio | 0 | 3 | |
1529638 | 1529638 | 2021-07-18 | Unknown | Ohio | 0 | 3 | |
1526391 | 1526391 | 2021-07-17 | Unknown | Ohio | 0 | 3 | |
1523144 | 1523144 | 2021-07-16 | Unknown | Ohio | 0 | 3 | |
1519896 | 1519896 | 2021-07-15 | Unknown | Ohio | 0 | 3 | |
1516648 | 1516648 | 2021-07-14 | Unknown | Ohio | 0 | 3 | |
1513401 | 1513401 | 2021-07-13 | Unknown | Ohio | 0 | 3 | |
1510155 | 1510155 | 2021-07-12 | Unknown | Ohio | 0 | 3 | |
1506908 | 1506908 | 2021-07-11 | Unknown | Ohio | 0 | 3 | |
1503662 | 1503662 | 2021-07-10 | Unknown | Ohio | 0 | 3 | |
1500416 | 1500416 | 2021-07-09 | Unknown | Ohio | 0 | 3 | |
1497170 | 1497170 | 2021-07-08 | Unknown | Ohio | 0 | 3 | |
1493923 | 1493923 | 2021-07-07 | Unknown | Ohio | 0 | 3 | |
1490676 | 1490676 | 2021-07-06 | Unknown | Ohio | 0 | 3 | |
1487429 | 1487429 | 2021-07-05 | Unknown | Ohio | 0 | 3 | |
1484182 | 1484182 | 2021-07-04 | Unknown | Ohio | 0 | 3 | |
1480936 | 1480936 | 2021-07-03 | Unknown | Ohio | 0 | 3 | |
1477689 | 1477689 | 2021-07-02 | Unknown | Ohio | 0 | 3 | |
1474443 | 1474443 | 2021-07-01 | Unknown | Ohio | 0 | 3 | |
1471197 | 1471197 | 2021-06-30 | Unknown | Ohio | 0 | 3 | |
1467952 | 1467952 | 2021-06-29 | Unknown | Ohio | 0 | 3 | |
1464707 | 1464707 | 2021-06-28 | Unknown | Ohio | 0 | 3 | |
1461462 | 1461462 | 2021-06-27 | Unknown | Ohio | 0 | 3 | |
1458217 | 1458217 | 2021-06-26 | Unknown | Ohio | 0 | 3 | |
1454972 | 1454972 | 2021-06-25 | Unknown | Ohio | 0 | 3 | |
1451727 | 1451727 | 2021-06-24 | Unknown | Ohio | 0 | 3 | |
1448481 | 1448481 | 2021-06-23 | Unknown | Ohio | 0 | 3 | |
1445236 | 1445236 | 2021-06-22 | Unknown | Ohio | 0 | 3 | |
1441991 | 1441991 | 2021-06-21 | Unknown | Ohio | 0 | 3 | |
1438746 | 1438746 | 2021-06-20 | Unknown | Ohio | 0 | 3 | |
1435499 | 1435499 | 2021-06-19 | Unknown | Ohio | 0 | 3 | |
1432252 | 1432252 | 2021-06-18 | Unknown | Ohio | 0 | 3 | |
1429006 | 1429006 | 2021-06-17 | Unknown | Ohio | 0 | 3 | |
1425761 | 1425761 | 2021-06-16 | Unknown | Ohio | 0 | 3 | |
1422514 | 1422514 | 2021-06-15 | Unknown | Ohio | 0 | 3 | |
1419268 | 1419268 | 2021-06-14 | Unknown | Ohio | 0 | 3 | |
1416023 | 1416023 | 2021-06-13 | Unknown | Ohio | 0 | 3 | |
1412777 | 1412777 | 2021-06-12 | Unknown | Ohio | 0 | 3 | |
1409532 | 1409532 | 2021-06-11 | Unknown | Ohio | 0 | 3 | |
1406287 | 1406287 | 2021-06-10 | Unknown | Ohio | 0 | 3 | |
1403041 | 1403041 | 2021-06-09 | Unknown | Ohio | 0 | 3 | |
1399796 | 1399796 | 2021-06-08 | Unknown | Ohio | 0 | 3 | |
1396551 | 1396551 | 2021-06-07 | Unknown | Ohio | 0 | 3 | |
1393304 | 1393304 | 2021-06-06 | Unknown | Ohio | 0 | 3 | |
1390059 | 1390059 | 2021-06-05 | Unknown | Ohio | 0 | 3 | |
1386814 | 1386814 | 2021-06-04 | Unknown | Ohio | 0 | 3 | |
1383569 | 1383569 | 2021-06-03 | Unknown | Ohio | 0 | 3 | |
1380323 | 1380323 | 2021-06-02 | Unknown | Ohio | 0 | 3 | |
1377078 | 1377078 | 2021-06-01 | Unknown | Ohio | 0 | 3 | |
1373832 | 1373832 | 2021-05-31 | Unknown | Ohio | 0 | 3 | |
1370587 | 1370587 | 2021-05-30 | Unknown | Ohio | 0 | 3 | |
1367341 | 1367341 | 2021-05-29 | Unknown | Ohio | 0 | 3 | |
1364095 | 1364095 | 2021-05-28 | Unknown | Ohio | 0 | 3 | |
903059 | 903059 | 2021-01-06 | Harrison | Ohio | 39067 | 755 | 3 |
899814 | 899814 | 2021-01-05 | Harrison | Ohio | 39067 | 729 | 3 |
896569 | 896569 | 2021-01-04 | Harrison | Ohio | 39067 | 719 | 3 |
893323 | 893323 | 2021-01-03 | Harrison | Ohio | 39067 | 714 | 3 |
890077 | 890077 | 2021-01-02 | Harrison | Ohio | 39067 | 704 | 3 |
886830 | 886830 | 2021-01-01 | Harrison | Ohio | 39067 | 692 | 3 |
883585 | 883585 | 2020-12-31 | Harrison | Ohio | 39067 | 692 | 3 |
880340 | 880340 | 2020-12-30 | Harrison | Ohio | 39067 | 675 | 3 |
877095 | 877095 | 2020-12-29 | Harrison | Ohio | 39067 | 649 | 3 |
873850 | 873850 | 2020-12-28 | Harrison | Ohio | 39067 | 639 | 3 |
870605 | 870605 | 2020-12-27 | Harrison | Ohio | 39067 | 634 | 3 |
870630 | 870630 | 2020-12-27 | Morrow | Ohio | 39117 | 1710 | 3 |
867360 | 867360 | 2020-12-26 | Harrison | Ohio | 39067 | 623 | 3 |
864115 | 864115 | 2020-12-25 | Harrison | Ohio | 39067 | 609 | 3 |
860870 | 860870 | 2020-12-24 | Harrison | Ohio | 39067 | 609 | 3 |
857625 | 857625 | 2020-12-23 | Harrison | Ohio | 39067 | 596 | 3 |
854380 | 854380 | 2020-12-22 | Harrison | Ohio | 39067 | 592 | 3 |
851135 | 851135 | 2020-12-21 | Harrison | Ohio | 39067 | 572 | 3 |
847890 | 847890 | 2020-12-20 | Harrison | Ohio | 39067 | 561 | 3 |
844645 | 844645 | 2020-12-19 | Harrison | Ohio | 39067 | 550 | 3 |
841399 | 841399 | 2020-12-18 | Harrison | Ohio | 39067 | 534 | 3 |
838154 | 838154 | 2020-12-17 | Harrison | Ohio | 39067 | 506 | 3 |
834908 | 834908 | 2020-12-16 | Harrison | Ohio | 39067 | 474 | 3 |
831662 | 831662 | 2020-12-15 | Harrison | Ohio | 39067 | 468 | 3 |
828415 | 828415 | 2020-12-14 | Harrison | Ohio | 39067 | 455 | 3 |
825169 | 825169 | 2020-12-13 | Harrison | Ohio | 39067 | 448 | 3 |
821922 | 821922 | 2020-12-12 | Harrison | Ohio | 39067 | 439 | 3 |
818676 | 818676 | 2020-12-11 | Harrison | Ohio | 39067 | 418 | 3 |
815430 | 815430 | 2020-12-10 | Harrison | Ohio | 39067 | 404 | 3 |
812184 | 812184 | 2020-12-09 | Harrison | Ohio | 39067 | 384 | 3 |
808940 | 808940 | 2020-12-08 | Harrison | Ohio | 39067 | 373 | 3 |
805695 | 805695 | 2020-12-07 | Harrison | Ohio | 39067 | 352 | 3 |
802450 | 802450 | 2020-12-06 | Harrison | Ohio | 39067 | 339 | 3 |
799205 | 799205 | 2020-12-05 | Harrison | Ohio | 39067 | 333 | 3 |
799237 | 799237 | 2020-12-05 | Pike | Ohio | 39131 | 995 | 3 |
795960 | 795960 | 2020-12-04 | Harrison | Ohio | 39067 | 314 | 3 |
795992 | 795992 | 2020-12-04 | Pike | Ohio | 39131 | 965 | 3 |
792715 | 792715 | 2020-12-03 | Harrison | Ohio | 39067 | 305 | 3 |
789470 | 789470 | 2020-12-02 | Harrison | Ohio | 39067 | 291 | 3 |
786225 | 786225 | 2020-12-01 | Harrison | Ohio | 39067 | 279 | 3 |
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);