ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
348 rows where deaths = 30 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1896741 | 1896741 | 2021-11-08 | Vinton | Ohio | 39163 | 1727 | 30 |
1893491 | 1893491 | 2021-11-07 | Vinton | Ohio | 39163 | 1720 | 30 |
1890241 | 1890241 | 2021-11-06 | Vinton | Ohio | 39163 | 1715 | 30 |
1886991 | 1886991 | 2021-11-05 | Vinton | Ohio | 39163 | 1711 | 30 |
1883741 | 1883741 | 2021-11-04 | Vinton | Ohio | 39163 | 1706 | 30 |
1880492 | 1880492 | 2021-11-03 | Vinton | Ohio | 39163 | 1705 | 30 |
1877243 | 1877243 | 2021-11-02 | Vinton | Ohio | 39163 | 1699 | 30 |
1792740 | 1792740 | 2021-10-07 | Morgan | Ohio | 39115 | 1811 | 30 |
1789491 | 1789491 | 2021-10-06 | Morgan | Ohio | 39115 | 1798 | 30 |
1786243 | 1786243 | 2021-10-05 | Morgan | Ohio | 39115 | 1781 | 30 |
1782994 | 1782994 | 2021-10-04 | Morgan | Ohio | 39115 | 1775 | 30 |
1779745 | 1779745 | 2021-10-03 | Morgan | Ohio | 39115 | 1772 | 30 |
1776495 | 1776495 | 2021-10-02 | Morgan | Ohio | 39115 | 1769 | 30 |
1773245 | 1773245 | 2021-10-01 | Morgan | Ohio | 39115 | 1759 | 30 |
1201732 | 1201732 | 2021-04-08 | Pike | Ohio | 39131 | 2294 | 30 |
1198483 | 1198483 | 2021-04-07 | Pike | Ohio | 39131 | 2292 | 30 |
1195234 | 1195234 | 2021-04-06 | Pike | Ohio | 39131 | 2287 | 30 |
1191986 | 1191986 | 2021-04-05 | Pike | Ohio | 39131 | 2281 | 30 |
1188737 | 1188737 | 2021-04-04 | Pike | Ohio | 39131 | 2269 | 30 |
1185490 | 1185490 | 2021-04-03 | Pike | Ohio | 39131 | 2269 | 30 |
1182243 | 1182243 | 2021-04-02 | Pike | Ohio | 39131 | 2266 | 30 |
1178996 | 1178996 | 2021-04-01 | Pike | Ohio | 39131 | 2265 | 30 |
1175749 | 1175749 | 2021-03-31 | Pike | Ohio | 39131 | 2259 | 30 |
1172502 | 1172502 | 2021-03-30 | Pike | Ohio | 39131 | 2252 | 30 |
1169255 | 1169255 | 2021-03-29 | Pike | Ohio | 39131 | 2247 | 30 |
1166007 | 1166007 | 2021-03-28 | Pike | Ohio | 39131 | 2243 | 30 |
1162759 | 1162759 | 2021-03-27 | Pike | Ohio | 39131 | 2243 | 30 |
1159510 | 1159510 | 2021-03-26 | Pike | Ohio | 39131 | 2237 | 30 |
1156263 | 1156263 | 2021-03-25 | Pike | Ohio | 39131 | 2231 | 30 |
1153016 | 1153016 | 2021-03-24 | Pike | Ohio | 39131 | 2227 | 30 |
1149769 | 1149769 | 2021-03-23 | Pike | Ohio | 39131 | 2222 | 30 |
1146522 | 1146522 | 2021-03-22 | Pike | Ohio | 39131 | 2218 | 30 |
1143275 | 1143275 | 2021-03-21 | Pike | Ohio | 39131 | 2216 | 30 |
1140028 | 1140028 | 2021-03-20 | Pike | Ohio | 39131 | 2215 | 30 |
1136782 | 1136782 | 2021-03-19 | Pike | Ohio | 39131 | 2210 | 30 |
1088073 | 1088073 | 2021-03-04 | Meigs | Ohio | 39105 | 1359 | 30 |
1088083 | 1088083 | 2021-03-04 | Paulding | Ohio | 39125 | 1605 | 30 |
1084828 | 1084828 | 2021-03-03 | Meigs | Ohio | 39105 | 1357 | 30 |
1084838 | 1084838 | 2021-03-03 | Paulding | Ohio | 39125 | 1605 | 30 |
1081582 | 1081582 | 2021-03-02 | Meigs | Ohio | 39105 | 1353 | 30 |
1081592 | 1081592 | 2021-03-02 | Paulding | Ohio | 39125 | 1602 | 30 |
1055570 | 1055570 | 2021-02-22 | Athens | Ohio | 39009 | 4550 | 30 |
1052324 | 1052324 | 2021-02-21 | Athens | Ohio | 39009 | 4536 | 30 |
1052353 | 1052353 | 2021-02-21 | Harrison | Ohio | 39067 | 987 | 30 |
1049077 | 1049077 | 2021-02-20 | Athens | Ohio | 39009 | 4527 | 30 |
1045826 | 1045826 | 2021-02-19 | Adams | Ohio | 39001 | 2118 | 30 |
1045830 | 1045830 | 2021-02-19 | Athens | Ohio | 39009 | 4505 | 30 |
1042585 | 1042585 | 2021-02-18 | Athens | Ohio | 39009 | 4480 | 30 |
1039340 | 1039340 | 2021-02-17 | Athens | Ohio | 39009 | 4467 | 30 |
1036095 | 1036095 | 2021-02-16 | Athens | Ohio | 39009 | 4452 | 30 |
1032850 | 1032850 | 2021-02-15 | Athens | Ohio | 39009 | 4438 | 30 |
1029604 | 1029604 | 2021-02-14 | Athens | Ohio | 39009 | 4414 | 30 |
1026357 | 1026357 | 2021-02-13 | Athens | Ohio | 39009 | 4403 | 30 |
1019870 | 1019870 | 2021-02-11 | Brown | Ohio | 39015 | 3574 | 30 |
1016666 | 1016666 | 2021-02-10 | Madison | Ohio | 39097 | 3794 | 30 |
1013421 | 1013421 | 2021-02-09 | Madison | Ohio | 39097 | 3782 | 30 |
1010176 | 1010176 | 2021-02-08 | Madison | Ohio | 39097 | 3768 | 30 |
1006905 | 1006905 | 2021-02-07 | Fayette | Ohio | 39047 | 2541 | 30 |
1006930 | 1006930 | 2021-02-07 | Madison | Ohio | 39097 | 3765 | 30 |
1003659 | 1003659 | 2021-02-06 | Fayette | Ohio | 39047 | 2537 | 30 |
1003684 | 1003684 | 2021-02-06 | Madison | Ohio | 39097 | 3760 | 30 |
1000413 | 1000413 | 2021-02-05 | Fayette | Ohio | 39047 | 2521 | 30 |
1000438 | 1000438 | 2021-02-05 | Madison | Ohio | 39097 | 3745 | 30 |
997167 | 997167 | 2021-02-04 | Fayette | Ohio | 39047 | 2514 | 30 |
997192 | 997192 | 2021-02-04 | Madison | Ohio | 39097 | 3728 | 30 |
993921 | 993921 | 2021-02-03 | Fayette | Ohio | 39047 | 2493 | 30 |
993946 | 993946 | 2021-02-03 | Madison | Ohio | 39097 | 3711 | 30 |
990675 | 990675 | 2021-02-02 | Fayette | Ohio | 39047 | 2478 | 30 |
990700 | 990700 | 2021-02-02 | Madison | Ohio | 39097 | 3701 | 30 |
987429 | 987429 | 2021-02-01 | Fayette | Ohio | 39047 | 2470 | 30 |
987454 | 987454 | 2021-02-01 | Madison | Ohio | 39097 | 3688 | 30 |
984182 | 984182 | 2021-01-31 | Fayette | Ohio | 39047 | 2467 | 30 |
984207 | 984207 | 2021-01-31 | Madison | Ohio | 39097 | 3673 | 30 |
980935 | 980935 | 2021-01-30 | Fayette | Ohio | 39047 | 2462 | 30 |
980960 | 980960 | 2021-01-30 | Madison | Ohio | 39097 | 3663 | 30 |
977689 | 977689 | 2021-01-29 | Fayette | Ohio | 39047 | 2454 | 30 |
977714 | 977714 | 2021-01-29 | Madison | Ohio | 39097 | 3658 | 30 |
974444 | 974444 | 2021-01-28 | Fayette | Ohio | 39047 | 2443 | 30 |
974469 | 974469 | 2021-01-28 | Madison | Ohio | 39097 | 3644 | 30 |
971199 | 971199 | 2021-01-27 | Fayette | Ohio | 39047 | 2421 | 30 |
971224 | 971224 | 2021-01-27 | Madison | Ohio | 39097 | 3624 | 30 |
971255 | 971255 | 2021-01-27 | Union | Ohio | 39159 | 4632 | 30 |
967954 | 967954 | 2021-01-26 | Fayette | Ohio | 39047 | 2410 | 30 |
967979 | 967979 | 2021-01-26 | Madison | Ohio | 39097 | 3599 | 30 |
968010 | 968010 | 2021-01-26 | Union | Ohio | 39159 | 4591 | 30 |
964710 | 964710 | 2021-01-25 | Fayette | Ohio | 39047 | 2395 | 30 |
961465 | 961465 | 2021-01-24 | Fayette | Ohio | 39047 | 2373 | 30 |
961499 | 961499 | 2021-01-24 | Morgan | Ohio | 39115 | 834 | 30 |
958220 | 958220 | 2021-01-23 | Fayette | Ohio | 39047 | 2365 | 30 |
958254 | 958254 | 2021-01-23 | Morgan | Ohio | 39115 | 831 | 30 |
954974 | 954974 | 2021-01-22 | Fayette | Ohio | 39047 | 2351 | 30 |
880346 | 880346 | 2020-12-30 | Jackson | Ohio | 39079 | 2111 | 30 |
877101 | 877101 | 2020-12-29 | Jackson | Ohio | 39079 | 2065 | 30 |
877149 | 877149 | 2020-12-29 | Wyandot | Ohio | 39175 | 1566 | 30 |
873856 | 873856 | 2020-12-28 | Jackson | Ohio | 39079 | 2060 | 30 |
873904 | 873904 | 2020-12-28 | Wyandot | Ohio | 39175 | 1553 | 30 |
870611 | 870611 | 2020-12-27 | Jackson | Ohio | 39079 | 2052 | 30 |
867366 | 867366 | 2020-12-26 | Jackson | Ohio | 39079 | 2029 | 30 |
867394 | 867394 | 2020-12-26 | Preble | Ohio | 39135 | 2595 | 30 |
864121 | 864121 | 2020-12-25 | Jackson | Ohio | 39079 | 1997 | 30 |
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);