ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where cases = 3366 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 16
- Georgia 12
- Missouri 12
- Wisconsin 12
- Iowa 9
- Louisiana 9
- Mississippi 9
- Virginia 8
- Kentucky 7
- Minnesota 7
- Michigan 6
- North Carolina 6
- Texas 6
- Kansas 5
- New York 5
- Pennsylvania 5
- Alabama 4
- Illinois 3
- South Carolina 3
- West Virginia 3
- Arkansas 2
- Massachusetts 2
- New Mexico 2
- Ohio 2
- Oregon 2
- Puerto Rico 2
- Tennessee 2
- Alaska 1
- Colorado 1
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497854 | 2497854 | 2022-05-12 | Gasconade | Missouri | 29073 | 3366 | 102 |
2494596 | 2494596 | 2022-05-11 | Gasconade | Missouri | 29073 | 3366 | 102 |
2491338 | 2491338 | 2022-05-10 | Gasconade | Missouri | 29073 | 3366 | 102 |
2488080 | 2488080 | 2022-05-09 | Gasconade | Missouri | 29073 | 3366 | 102 |
2483717 | 2483717 | 2022-05-08 | Dade | Georgia | 13083 | 3366 | 29 |
2484823 | 2484823 | 2022-05-08 | Gasconade | Missouri | 29073 | 3366 | 102 |
2480459 | 2480459 | 2022-05-07 | Dade | Georgia | 13083 | 3366 | 29 |
2481565 | 2481565 | 2022-05-07 | Gasconade | Missouri | 29073 | 3366 | 102 |
2477201 | 2477201 | 2022-05-06 | Dade | Georgia | 13083 | 3366 | 29 |
2478307 | 2478307 | 2022-05-06 | Gasconade | Missouri | 29073 | 3366 | 102 |
2473943 | 2473943 | 2022-05-05 | Dade | Georgia | 13083 | 3366 | 29 |
2470686 | 2470686 | 2022-05-04 | Dade | Georgia | 13083 | 3366 | 29 |
2465986 | 2465986 | 2022-05-02 | Curry | Oregon | 41015 | 3366 | 54 |
2424113 | 2424113 | 2022-04-19 | Duval | Texas | 48131 | 3366 | 70 |
2357453 | 2357453 | 2022-03-30 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2354200 | 2354200 | 2022-03-29 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2350948 | 2350948 | 2022-03-28 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2347695 | 2347695 | 2022-03-27 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2344442 | 2344442 | 2022-03-26 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2341189 | 2341189 | 2022-03-25 | Caldwell | Louisiana | 22021 | 3366 | 54 |
2328610 | 2328610 | 2022-03-21 | Mississippi | Missouri | 29133 | 3366 | 56 |
2269527 | 2269527 | 2022-03-03 | Clinton | Kentucky | 21053 | 3366 | 43 |
2230738 | 2230738 | 2022-02-19 | Benzie | Michigan | 26019 | 3366 | 64 |
2227487 | 2227487 | 2022-02-18 | Benzie | Michigan | 26019 | 3366 | 64 |
2224236 | 2224236 | 2022-02-17 | Benzie | Michigan | 26019 | 3366 | 64 |
2220964 | 2220964 | 2022-02-16 | Dukes | Massachusetts | 25007 | 3366 | 0 |
2220985 | 2220985 | 2022-02-16 | Benzie | Michigan | 26019 | 3366 | 64 |
2216751 | 2216751 | 2022-02-15 | Grand | Colorado | 8049 | 3366 | 23 |
2214252 | 2214252 | 2022-02-14 | Carroll | Kentucky | 21041 | 3366 | 40 |
2215653 | 2215653 | 2022-02-14 | Bamberg | South Carolina | 45009 | 3366 | 70 |
2213190 | 2213190 | 2022-02-13 | Rusk | Wisconsin | 55107 | 3366 | 47 |
2209937 | 2209937 | 2022-02-12 | Rusk | Wisconsin | 55107 | 3366 | 47 |
2206684 | 2206684 | 2022-02-11 | Rusk | Wisconsin | 55107 | 3366 | 47 |
2172334 | 2172334 | 2022-02-01 | Renville | Minnesota | 27129 | 3366 | 53 |
2148860 | 2148860 | 2022-01-25 | Wabash | Illinois | 17185 | 3366 | 22 |
2146041 | 2146041 | 2022-01-24 | Bienville | Louisiana | 22013 | 3366 | 102 |
2121512 | 2121512 | 2022-01-16 | Andrews | Texas | 48003 | 3366 | 67 |
2110535 | 2110535 | 2022-01-13 | Unknown | Minnesota | 3366 | 140 | |
2094397 | 2094397 | 2022-01-08 | Cooper | Missouri | 29053 | 3366 | 63 |
2039112 | 2039112 | 2021-12-22 | Andrew | Missouri | 29003 | 3366 | 41 |
2035758 | 2035758 | 2021-12-21 | Roseau | Minnesota | 27135 | 3366 | 34 |
2027535 | 2027535 | 2021-12-18 | Windham | Vermont | 50025 | 3366 | 29 |
1997792 | 1997792 | 2021-12-09 | Fairfield | South Carolina | 45039 | 3366 | 93 |
1994026 | 1994026 | 2021-12-08 | Caswell | North Carolina | 37033 | 3366 | 39 |
1953147 | 1953147 | 2021-11-26 | Monroe | Alabama | 1099 | 3366 | 66 |
1949896 | 1949896 | 2021-11-25 | Monroe | Alabama | 1099 | 3366 | 66 |
1943312 | 1943312 | 2021-11-22 | Vernon | Wisconsin | 55123 | 3366 | 67 |
1928512 | 1928512 | 2021-11-18 | Attala | Mississippi | 28007 | 3366 | 90 |
1905075 | 1905075 | 2021-11-11 | Fulton | Indiana | 18049 | 3366 | 69 |
1876411 | 1876411 | 2021-11-02 | Otsego | Michigan | 26137 | 3366 | 58 |
1857051 | 1857051 | 2021-10-27 | Jasper | Mississippi | 28061 | 3366 | 65 |
1849834 | 1849834 | 2021-10-25 | Fountain | Indiana | 18045 | 3366 | 62 |
1848902 | 1848902 | 2021-10-24 | Staunton city | Virginia | 51790 | 3366 | 81 |
1849037 | 1849037 | 2021-10-24 | Jackson | Wisconsin | 55053 | 3366 | 31 |
1845652 | 1845652 | 2021-10-23 | Staunton city | Virginia | 51790 | 3366 | 81 |
1845787 | 1845787 | 2021-10-23 | Jackson | Wisconsin | 55053 | 3366 | 31 |
1842402 | 1842402 | 2021-10-22 | Staunton city | Virginia | 51790 | 3366 | 81 |
1842537 | 1842537 | 2021-10-22 | Jackson | Wisconsin | 55053 | 3366 | 31 |
1839114 | 1839114 | 2021-10-21 | Mecklenburg | Virginia | 51117 | 3366 | 81 |
1829734 | 1829734 | 2021-10-19 | Columbia | Arkansas | 5027 | 3366 | 72 |
1830612 | 1830612 | 2021-10-19 | Adair | Kentucky | 21001 | 3366 | 76 |
1823889 | 1823889 | 2021-10-17 | Spencer | Indiana | 18147 | 3366 | 42 |
1820640 | 1820640 | 2021-10-16 | Spencer | Indiana | 18147 | 3366 | 42 |
1817391 | 1817391 | 2021-10-15 | Spencer | Indiana | 18147 | 3366 | 42 |
1792978 | 1792978 | 2021-10-07 | Dorado | Puerto Rico | 72051 | 3366 | |
1784926 | 1784926 | 2021-10-05 | Benton | Iowa | 19011 | 3366 | 56 |
1781677 | 1781677 | 2021-10-04 | Benton | Iowa | 19011 | 3366 | 56 |
1778427 | 1778427 | 2021-10-03 | Benton | Iowa | 19011 | 3366 | 56 |
1775177 | 1775177 | 2021-10-02 | Benton | Iowa | 19011 | 3366 | 56 |
1771927 | 1771927 | 2021-10-01 | Benton | Iowa | 19011 | 3366 | 56 |
1768678 | 1768678 | 2021-09-30 | Benton | Iowa | 19011 | 3366 | 56 |
1765429 | 1765429 | 2021-09-29 | Benton | Iowa | 19011 | 3366 | 56 |
1767167 | 1767167 | 2021-09-29 | Chester | Tennessee | 47023 | 3366 | 66 |
1760839 | 1760839 | 2021-09-27 | Gillespie | Texas | 48171 | 3366 | 72 |
1757647 | 1757647 | 2021-09-26 | Lampasas | Texas | 48281 | 3366 | 54 |
1754399 | 1754399 | 2021-09-25 | Lampasas | Texas | 48281 | 3366 | 54 |
1745730 | 1745730 | 2021-09-23 | Payette | Idaho | 16075 | 3366 | 48 |
1743054 | 1743054 | 2021-09-22 | St. James | Louisiana | 22093 | 3366 | 65 |
1745033 | 1745033 | 2021-09-22 | Upshur | West Virginia | 54097 | 3366 | 47 |
1723976 | 1723976 | 2021-09-16 | Randolph | Missouri | 29175 | 3366 | 35 |
1713081 | 1713081 | 2021-09-13 | Dodge | Georgia | 13091 | 3366 | 114 |
1698827 | 1698827 | 2021-09-08 | Barnwell | South Carolina | 45011 | 3366 | 66 |
1632860 | 1632860 | 2021-08-19 | Coahoma | Mississippi | 28027 | 3366 | 86 |
1629273 | 1629273 | 2021-08-18 | Montgomery | Kentucky | 21173 | 3366 | 32 |
1624742 | 1624742 | 2021-08-16 | Warren | Virginia | 51187 | 3366 | 64 |
1591504 | 1591504 | 2021-08-06 | Jefferson | Pennsylvania | 42065 | 3366 | 99 |
1588255 | 1588255 | 2021-08-05 | Jefferson | Pennsylvania | 42065 | 3366 | 99 |
1558197 | 1558197 | 2021-07-27 | Scott | Mississippi | 28123 | 3366 | 76 |
1553409 | 1553409 | 2021-07-25 | Juneau | Wisconsin | 55057 | 3366 | 31 |
1550162 | 1550162 | 2021-07-24 | Juneau | Wisconsin | 55057 | 3366 | 31 |
1546915 | 1546915 | 2021-07-23 | Juneau | Wisconsin | 55057 | 3366 | 31 |
1543668 | 1543668 | 2021-07-22 | Juneau | Wisconsin | 55057 | 3366 | 31 |
1537405 | 1537405 | 2021-07-21 | Poinsett | Arkansas | 5111 | 3366 | 80 |
1540420 | 1540420 | 2021-07-21 | Juneau | Wisconsin | 55057 | 3366 | 31 |
1528880 | 1528880 | 2021-07-18 | Pine | Minnesota | 27115 | 3366 | 23 |
1525633 | 1525633 | 2021-07-17 | Pine | Minnesota | 27115 | 3366 | 23 |
1522386 | 1522386 | 2021-07-16 | Pine | Minnesota | 27115 | 3366 | 23 |
1508808 | 1508808 | 2021-07-12 | White | Indiana | 18181 | 3366 | 55 |
1497322 | 1497322 | 2021-07-08 | Greene | Pennsylvania | 42059 | 3366 | 42 |
1497782 | 1497782 | 2021-07-08 | Kendall | Texas | 48259 | 3366 | 72 |
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);