ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where cases = 4025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 40
- Kentucky 12
- Mississippi 9
- Illinois 8
- Ohio 8
- Virginia 7
- Indiana 6
- Georgia 5
- Idaho 5
- Tennessee 5
- Louisiana 4
- Minnesota 4
- Iowa 3
- Michigan 3
- Pennsylvania 3
- Texas 3
- Alabama 2
- California 2
- Kansas 2
- Maryland 2
- Nebraska 2
- New Mexico 2
- North Carolina 2
- Oregon 2
- Wisconsin 2
- Arkansas 1
- Colorado 1
- Guam 1
- Puerto Rico 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471828 | 2471828 | 2022-05-04 | Morgan | Missouri | 29141 | 4025 | 109 |
2468572 | 2468572 | 2022-05-03 | Morgan | Missouri | 29141 | 4025 | 109 |
2465316 | 2465316 | 2022-05-02 | Morgan | Missouri | 29141 | 4025 | 109 |
2462061 | 2462061 | 2022-05-01 | Morgan | Missouri | 29141 | 4025 | 109 |
2458805 | 2458805 | 2022-04-30 | Morgan | Missouri | 29141 | 4025 | 109 |
2455549 | 2455549 | 2022-04-29 | Morgan | Missouri | 29141 | 4025 | 109 |
2452293 | 2452293 | 2022-04-28 | Morgan | Missouri | 29141 | 4025 | 109 |
2449037 | 2449037 | 2022-04-27 | Morgan | Missouri | 29141 | 4025 | 109 |
2445780 | 2445780 | 2022-04-26 | Morgan | Missouri | 29141 | 4025 | 109 |
2442525 | 2442525 | 2022-04-25 | Morgan | Missouri | 29141 | 4025 | 109 |
2439269 | 2439269 | 2022-04-24 | Morgan | Missouri | 29141 | 4025 | 109 |
2436013 | 2436013 | 2022-04-23 | Morgan | Missouri | 29141 | 4025 | 109 |
2432757 | 2432757 | 2022-04-22 | Morgan | Missouri | 29141 | 4025 | 109 |
2429501 | 2429501 | 2022-04-21 | Morgan | Missouri | 29141 | 4025 | 109 |
2426245 | 2426245 | 2022-04-20 | Morgan | Missouri | 29141 | 4025 | 109 |
2422989 | 2422989 | 2022-04-19 | Morgan | Missouri | 29141 | 4025 | 109 |
2424400 | 2424400 | 2022-04-19 | Goochland | Virginia | 51075 | 4025 | 52 |
2419732 | 2419732 | 2022-04-18 | Morgan | Missouri | 29141 | 4025 | 109 |
2416477 | 2416477 | 2022-04-17 | Morgan | Missouri | 29141 | 4025 | 109 |
2413221 | 2413221 | 2022-04-16 | Morgan | Missouri | 29141 | 4025 | 109 |
2409965 | 2409965 | 2022-04-15 | Morgan | Missouri | 29141 | 4025 | 109 |
2406709 | 2406709 | 2022-04-14 | Morgan | Missouri | 29141 | 4025 | 109 |
2403453 | 2403453 | 2022-04-13 | Morgan | Missouri | 29141 | 4025 | 109 |
2400198 | 2400198 | 2022-04-12 | Morgan | Missouri | 29141 | 4025 | 109 |
2396943 | 2396943 | 2022-04-11 | Morgan | Missouri | 29141 | 4025 | 109 |
2393688 | 2393688 | 2022-04-10 | Morgan | Missouri | 29141 | 4025 | 109 |
2390432 | 2390432 | 2022-04-09 | Morgan | Missouri | 29141 | 4025 | 109 |
2387176 | 2387176 | 2022-04-08 | Morgan | Missouri | 29141 | 4025 | 109 |
2383921 | 2383921 | 2022-04-07 | Morgan | Missouri | 29141 | 4025 | 109 |
2380666 | 2380666 | 2022-04-06 | Morgan | Missouri | 29141 | 4025 | 109 |
2377411 | 2377411 | 2022-04-05 | Morgan | Missouri | 29141 | 4025 | 109 |
2374158 | 2374158 | 2022-04-04 | Morgan | Missouri | 29141 | 4025 | 109 |
2369979 | 2369979 | 2022-04-03 | Jo Daviess | Illinois | 17085 | 4025 | 39 |
2370906 | 2370906 | 2022-04-03 | Morgan | Missouri | 29141 | 4025 | 109 |
2366726 | 2366726 | 2022-04-02 | Jo Daviess | Illinois | 17085 | 4025 | 39 |
2367653 | 2367653 | 2022-04-02 | Morgan | Missouri | 29141 | 4025 | 109 |
2363473 | 2363473 | 2022-04-01 | Jo Daviess | Illinois | 17085 | 4025 | 39 |
2364400 | 2364400 | 2022-04-01 | Morgan | Missouri | 29141 | 4025 | 109 |
2361146 | 2361146 | 2022-03-31 | Morgan | Missouri | 29141 | 4025 | 109 |
2357892 | 2357892 | 2022-03-30 | Morgan | Missouri | 29141 | 4025 | 109 |
2359305 | 2359305 | 2022-03-30 | Greene | Virginia | 51079 | 4025 | 61 |
2310506 | 2310506 | 2022-03-15 | Grayson | Virginia | 51077 | 4025 | 79 |
2287642 | 2287642 | 2022-03-08 | Zavala | Texas | 48507 | 4025 | 67 |
2284390 | 2284390 | 2022-03-07 | Zavala | Texas | 48507 | 4025 | 67 |
2266307 | 2266307 | 2022-03-02 | Knott | Kentucky | 21119 | 4025 | 57 |
2196617 | 2196617 | 2022-02-08 | Unknown | Utah | 4025 | 67 | |
2126744 | 2126744 | 2022-01-18 | Hubbard | Minnesota | 27057 | 4025 | 52 |
2090185 | 2090185 | 2022-01-07 | Blaine | Idaho | 16013 | 4025 | 27 |
2033707 | 2033707 | 2021-12-20 | Morgan | Tennessee | 47129 | 4025 | 52 |
1993786 | 1993786 | 2021-12-08 | Cass | Nebraska | 31025 | 4025 | 23 |
1981202 | 1981202 | 2021-12-04 | Holmes | Ohio | 39075 | 4025 | 141 |
1960704 | 1960704 | 2021-11-28 | Rowan | Kentucky | 21205 | 4025 | 37 |
1957453 | 1957453 | 2021-11-27 | Rowan | Kentucky | 21205 | 4025 | 37 |
1954202 | 1954202 | 2021-11-26 | Rowan | Kentucky | 21205 | 4025 | 37 |
1950951 | 1950951 | 2021-11-25 | Rowan | Kentucky | 21205 | 4025 | 37 |
1947700 | 1947700 | 2021-11-24 | Rowan | Kentucky | 21205 | 4025 | 37 |
1941254 | 1941254 | 2021-11-22 | Plaquemines | Louisiana | 22075 | 4025 | 40 |
1938004 | 1938004 | 2021-11-21 | Plaquemines | Louisiana | 22075 | 4025 | 40 |
1934754 | 1934754 | 2021-11-20 | Plaquemines | Louisiana | 22075 | 4025 | 40 |
1931503 | 1931503 | 2021-11-19 | Plaquemines | Louisiana | 22075 | 4025 | 40 |
1915315 | 1915315 | 2021-11-14 | Queen Anne's | Maryland | 24035 | 4025 | 73 |
1915421 | 1915421 | 2021-11-14 | Wexford | Michigan | 26165 | 4025 | 58 |
1912171 | 1912171 | 2021-11-13 | Wexford | Michigan | 26165 | 4025 | 58 |
1908921 | 1908921 | 2021-11-12 | Wexford | Michigan | 26165 | 4025 | 58 |
1827574 | 1827574 | 2021-10-18 | Dorchester | Maryland | 24019 | 4025 | 77 |
1798710 | 1798710 | 2021-10-09 | Saline | Missouri | 29195 | 4025 | 46 |
1785503 | 1785503 | 2021-10-05 | Nicollet | Minnesota | 27103 | 4025 | 49 |
1767235 | 1767235 | 2021-09-29 | Smith | Tennessee | 47159 | 4025 | 44 |
1738628 | 1738628 | 2021-09-20 | Park | Wyoming | 56029 | 4025 | 42 |
1733226 | 1733226 | 2021-09-19 | Montgomery | Kentucky | 21173 | 4025 | 37 |
1729976 | 1729976 | 2021-09-18 | Montgomery | Kentucky | 21173 | 4025 | 37 |
1726726 | 1726726 | 2021-09-17 | Montgomery | Kentucky | 21173 | 4025 | 37 |
1715695 | 1715695 | 2021-09-13 | Warren | Virginia | 51187 | 4025 | 65 |
1702831 | 1702831 | 2021-09-09 | Green | Wisconsin | 55045 | 4025 | 26 |
1690474 | 1690474 | 2021-09-06 | Bonner | Idaho | 16017 | 4025 | 49 |
1691392 | 1691392 | 2021-09-06 | Tate | Mississippi | 28137 | 4025 | 93 |
1687224 | 1687224 | 2021-09-05 | Bonner | Idaho | 16017 | 4025 | 49 |
1683974 | 1683974 | 2021-09-04 | Bonner | Idaho | 16017 | 4025 | 49 |
1680723 | 1680723 | 2021-09-03 | Bonner | Idaho | 16017 | 4025 | 49 |
1672022 | 1672022 | 2021-08-31 | Warren | Missouri | 29219 | 4025 | 39 |
1652404 | 1652404 | 2021-08-25 | Scott | Mississippi | 28123 | 4025 | 83 |
1648615 | 1648615 | 2021-08-24 | Harvey | Kansas | 20079 | 4025 | 74 |
1648691 | 1648691 | 2021-08-24 | Boyle | Kentucky | 21021 | 4025 | 80 |
1649066 | 1649066 | 2021-08-24 | Polk | Minnesota | 27119 | 4025 | 75 |
1645367 | 1645367 | 2021-08-23 | Harvey | Kansas | 20079 | 4025 | 74 |
1563957 | 1563957 | 2021-07-29 | Jasper | Indiana | 18073 | 4025 | 57 |
1564278 | 1564278 | 2021-07-29 | Knox | Kentucky | 21121 | 4025 | 47 |
1528151 | 1528151 | 2021-07-18 | Logan | Illinois | 17107 | 4025 | 77 |
1524904 | 1524904 | 2021-07-17 | Logan | Illinois | 17107 | 4025 | 77 |
1521656 | 1521656 | 2021-07-16 | Logan | Illinois | 17107 | 4025 | 77 |
1518408 | 1518408 | 2021-07-15 | Logan | Illinois | 17107 | 4025 | 77 |
1494019 | 1494019 | 2021-07-07 | Douglas | Oregon | 41019 | 4025 | 84 |
1486745 | 1486745 | 2021-07-05 | Lincoln | Mississippi | 28085 | 4025 | 113 |
1483499 | 1483499 | 2021-07-04 | Lincoln | Mississippi | 28085 | 4025 | 113 |
1480253 | 1480253 | 2021-07-03 | Lincoln | Mississippi | 28085 | 4025 | 113 |
1477006 | 1477006 | 2021-07-02 | Lincoln | Mississippi | 28085 | 4025 | 113 |
1462683 | 1462683 | 2021-06-28 | Boone | Arkansas | 5009 | 4025 | 80 |
1463347 | 1463347 | 2021-06-28 | Steuben | Indiana | 18151 | 4025 | 61 |
1455085 | 1455085 | 2021-06-25 | Polk | Oregon | 41053 | 4025 | 56 |
1445163 | 1445163 | 2021-06-22 | Brown | Ohio | 39015 | 4025 | 61 |
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);