ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
148 rows where cases = 3824 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- Georgia 13
- Illinois 10
- Kansas 10
- Indiana 9
- Kentucky 9
- Florida 7
- Michigan 7
- Minnesota 6
- New Mexico 6
- New York 5
- Louisiana 4
- Missouri 4
- Tennessee 4
- Wisconsin 4
- Arkansas 3
- Iowa 3
- Maryland 3
- New Hampshire 3
- Pennsylvania 3
- Virginia 3
- Mississippi 2
- Nebraska 2
- North Carolina 2
- Puerto Rico 2
- California 1
- Hawaii 1
- Maine 1
- Montana 1
- Nevada 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475082 | 2475082 | 2022-05-05 | Moniteau | Missouri | 29135 | 3824 | 56 |
2315645 | 2315645 | 2022-03-17 | Wright | Missouri | 29229 | 3824 | 80 |
2312392 | 2312392 | 2022-03-16 | Wright | Missouri | 29229 | 3824 | 80 |
2259406 | 2259406 | 2022-02-28 | Massac | Illinois | 17127 | 3824 | 69 |
2240629 | 2240629 | 2022-02-22 | Redwood | Minnesota | 27127 | 3824 | 52 |
2233760 | 2233760 | 2022-02-20 | Casey | Kentucky | 21045 | 3824 | 66 |
2230509 | 2230509 | 2022-02-19 | Casey | Kentucky | 21045 | 3824 | 66 |
2227258 | 2227258 | 2022-02-18 | Casey | Kentucky | 21045 | 3824 | 66 |
2213626 | 2213626 | 2022-02-14 | Banks | Georgia | 13011 | 3824 | 78 |
2210448 | 2210448 | 2022-02-13 | Jeff Davis | Georgia | 13161 | 3824 | 66 |
2210944 | 2210944 | 2022-02-13 | Osage | Kansas | 20139 | 3824 | 43 |
2207195 | 2207195 | 2022-02-12 | Jeff Davis | Georgia | 13161 | 3824 | 66 |
2207691 | 2207691 | 2022-02-12 | Osage | Kansas | 20139 | 3824 | 43 |
2203942 | 2203942 | 2022-02-11 | Jeff Davis | Georgia | 13161 | 3824 | 66 |
2204438 | 2204438 | 2022-02-11 | Osage | Kansas | 20139 | 3824 | 43 |
2201185 | 2201185 | 2022-02-10 | Osage | Kansas | 20139 | 3824 | 43 |
2197931 | 2197931 | 2022-02-09 | Osage | Kansas | 20139 | 3824 | 43 |
2196049 | 2196049 | 2022-02-08 | Aguas Buenas | Puerto Rico | 72007 | 3824 | |
2190913 | 2190913 | 2022-02-07 | Greene | Georgia | 13133 | 3824 | 75 |
2187848 | 2187848 | 2022-02-06 | Jo Daviess | Illinois | 17085 | 3824 | 36 |
2184595 | 2184595 | 2022-02-05 | Jo Daviess | Illinois | 17085 | 3824 | 36 |
2181343 | 2181343 | 2022-02-04 | Jo Daviess | Illinois | 17085 | 3824 | 36 |
2177777 | 2177777 | 2022-02-03 | Calhoun | Florida | 12013 | 3824 | 85 |
2174524 | 2174524 | 2022-02-02 | Calhoun | Florida | 12013 | 3824 | 85 |
2171271 | 2171271 | 2022-02-01 | Calhoun | Florida | 12013 | 3824 | 85 |
2168018 | 2168018 | 2022-01-31 | Calhoun | Florida | 12013 | 3824 | 85 |
2164763 | 2164763 | 2022-01-30 | Calhoun | Florida | 12013 | 3824 | 85 |
2161508 | 2161508 | 2022-01-29 | Calhoun | Florida | 12013 | 3824 | 85 |
2158252 | 2158252 | 2022-01-28 | Calhoun | Florida | 12013 | 3824 | 85 |
2149781 | 2149781 | 2022-01-25 | Big Horn | Montana | 30003 | 3824 | 87 |
2132087 | 2132087 | 2022-01-20 | Colusa | California | 6011 | 3824 | 21 |
2131451 | 2131451 | 2022-01-19 | Panola | Texas | 48365 | 3824 | 113 |
2100822 | 2100822 | 2022-01-10 | Jasper | Mississippi | 28061 | 3824 | 66 |
2097384 | 2097384 | 2022-01-09 | Cheboygan | Michigan | 26031 | 3824 | 84 |
2094132 | 2094132 | 2022-01-08 | Cheboygan | Michigan | 26031 | 3824 | 84 |
2090880 | 2090880 | 2022-01-07 | Cheboygan | Michigan | 26031 | 3824 | 84 |
2084947 | 2084947 | 2022-01-05 | Lincoln | New Mexico | 35027 | 3824 | 47 |
2050762 | 2050762 | 2021-12-26 | Lincoln | Arkansas | 5079 | 3824 | 58 |
2051376 | 2051376 | 2021-12-26 | Owen | Indiana | 18119 | 3824 | 85 |
2047512 | 2047512 | 2021-12-25 | Lincoln | Arkansas | 5079 | 3824 | 58 |
2048126 | 2048126 | 2021-12-25 | Owen | Indiana | 18119 | 3824 | 85 |
2044876 | 2044876 | 2021-12-24 | Owen | Indiana | 18119 | 3824 | 85 |
2041627 | 2041627 | 2021-12-23 | Owen | Indiana | 18119 | 3824 | 85 |
2038377 | 2038377 | 2021-12-22 | Owen | Indiana | 18119 | 3824 | 85 |
2034770 | 2034770 | 2021-12-21 | Burke | Georgia | 13033 | 3824 | 86 |
2011047 | 2011047 | 2021-12-13 | Dimmit | Texas | 48127 | 3824 | 46 |
2007796 | 2007796 | 2021-12-12 | Dimmit | Texas | 48127 | 3824 | 46 |
2004545 | 2004545 | 2021-12-11 | Dimmit | Texas | 48127 | 3824 | 46 |
2001294 | 2001294 | 2021-12-10 | Dimmit | Texas | 48127 | 3824 | 46 |
1940630 | 1940630 | 2021-11-22 | Unknown | Georgia | 3824 | 10 | |
1914539 | 1914539 | 2021-11-14 | Fannin | Georgia | 13111 | 3824 | 108 |
1911289 | 1911289 | 2021-11-13 | Fannin | Georgia | 13111 | 3824 | 108 |
1908040 | 1908040 | 2021-11-12 | Fannin | Georgia | 13111 | 3824 | 108 |
1910336 | 1910336 | 2021-11-12 | Hutchinson | Texas | 48233 | 3824 | 93 |
1906136 | 1906136 | 2021-11-11 | Sullivan | New Hampshire | 33019 | 3824 | 37 |
1907087 | 1907087 | 2021-11-11 | Hutchinson | Texas | 48233 | 3824 | 93 |
1902887 | 1902887 | 2021-11-10 | Sullivan | New Hampshire | 33019 | 3824 | 37 |
1895057 | 1895057 | 2021-11-08 | Haralson | Georgia | 13143 | 3824 | 120 |
1876242 | 1876242 | 2021-11-02 | Grant | Louisiana | 22043 | 3824 | 77 |
1857371 | 1857371 | 2021-10-27 | Churchill | Nevada | 32001 | 3824 | 65 |
1857849 | 1857849 | 2021-10-27 | Jefferson | Oregon | 41031 | 3824 | 56 |
1854265 | 1854265 | 2021-10-26 | Anson | North Carolina | 37007 | 3824 | 79 |
1824188 | 1824188 | 2021-10-17 | Marion | Kentucky | 21155 | 3824 | 43 |
1820939 | 1820939 | 2021-10-16 | Marion | Kentucky | 21155 | 3824 | 43 |
1817690 | 1817690 | 2021-10-15 | Marion | Kentucky | 21155 | 3824 | 43 |
1814110 | 1814110 | 2021-10-14 | Jennings | Indiana | 18079 | 3824 | 62 |
1814526 | 1814526 | 2021-10-14 | Pointe Coupee | Louisiana | 22077 | 3824 | 83 |
1805448 | 1805448 | 2021-10-11 | Luna | New Mexico | 35029 | 3824 | 93 |
1802199 | 1802199 | 2021-10-10 | Luna | New Mexico | 35029 | 3824 | 93 |
1798950 | 1798950 | 2021-10-09 | Luna | New Mexico | 35029 | 3824 | 93 |
1795701 | 1795701 | 2021-10-08 | Luna | New Mexico | 35029 | 3824 | 93 |
1792452 | 1792452 | 2021-10-07 | Luna | New Mexico | 35029 | 3824 | 93 |
1776239 | 1776239 | 2021-10-02 | Franklin | New York | 36033 | 3824 | 17 |
1719861 | 1719861 | 2021-09-15 | Decatur | Indiana | 18031 | 3824 | 99 |
1716393 | 1716393 | 2021-09-14 | Peach | Georgia | 13225 | 3824 | 77 |
1717796 | 1717796 | 2021-09-14 | Wyoming | New York | 36121 | 3824 | 54 |
1692344 | 1692344 | 2021-09-06 | Edgefield | South Carolina | 45037 | 3824 | 46 |
1679670 | 1679670 | 2021-09-02 | Kleberg | Texas | 48273 | 3824 | 106 |
1655247 | 1655247 | 2021-08-26 | Logan | Kentucky | 21141 | 3824 | 76 |
1627220 | 1627220 | 2021-08-17 | Clinton | Pennsylvania | 42035 | 3824 | 68 |
1621012 | 1621012 | 2021-08-15 | Henry | Tennessee | 47079 | 3824 | 76 |
1617764 | 1617764 | 2021-08-14 | Henry | Tennessee | 47079 | 3824 | 76 |
1614516 | 1614516 | 2021-08-13 | Henry | Tennessee | 47079 | 3824 | 76 |
1596932 | 1596932 | 2021-08-08 | Worcester | Maryland | 24047 | 3824 | 106 |
1586893 | 1586893 | 2021-08-05 | Harvey | Kansas | 20079 | 3824 | 73 |
1583643 | 1583643 | 2021-08-04 | Harvey | Kansas | 20079 | 3824 | 73 |
1528103 | 1528103 | 2021-07-18 | Bureau | Illinois | 17011 | 3824 | 100 |
1524856 | 1524856 | 2021-07-17 | Bureau | Illinois | 17011 | 3824 | 100 |
1521608 | 1521608 | 2021-07-16 | Bureau | Illinois | 17011 | 3824 | 100 |
1516089 | 1516089 | 2021-07-14 | Pulaski | Missouri | 29169 | 3824 | 56 |
1513565 | 1513565 | 2021-07-13 | McKean | Pennsylvania | 42083 | 3824 | 72 |
1511258 | 1511258 | 2021-07-12 | Teton | Wyoming | 56039 | 3824 | 11 |
1490609 | 1490609 | 2021-07-06 | Clinton | Ohio | 39027 | 3824 | 66 |
1488004 | 1488004 | 2021-07-05 | Grimes | Texas | 48185 | 3824 | 74 |
1465762 | 1465762 | 2021-06-28 | Oneida | Wisconsin | 55085 | 3824 | 78 |
1462517 | 1462517 | 2021-06-27 | Oneida | Wisconsin | 55085 | 3824 | 78 |
1459272 | 1459272 | 2021-06-26 | Oneida | Wisconsin | 55085 | 3824 | 78 |
1456027 | 1456027 | 2021-06-25 | Oneida | Wisconsin | 55085 | 3824 | 78 |
1430963 | 1430963 | 2021-06-18 | Lee | Iowa | 19111 | 3824 | 56 |
1350407 | 1350407 | 2021-05-24 | Hancock | Mississippi | 28045 | 3824 | 87 |
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);