ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
278 rows where cases = 2161 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 38
- Iowa 17
- Texas 16
- Kentucky 15
- Missouri 14
- Indiana 11
- Virginia 11
- Mississippi 10
- Louisiana 9
- Minnesota 9
- North Carolina 9
- Wisconsin 9
- Georgia 8
- Illinois 8
- Tennessee 8
- California 7
- Montana 7
- Alabama 6
- Kansas 6
- Arkansas 5
- Alaska 4
- Colorado 4
- Maryland 4
- Nebraska 4
- Ohio 4
- Puerto Rico 4
- South Carolina 4
- Connecticut 3
- New Mexico 3
- Pennsylvania 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475050 | 2475050 | 2022-05-05 | Gentry | Missouri | 29075 | 2161 | 31 |
2471616 | 2471616 | 2022-05-04 | Jackson | Minnesota | 27063 | 2161 | 17 |
2452438 | 2452438 | 2022-04-28 | Holt | Nebraska | 31089 | 2161 | 20 |
2449182 | 2449182 | 2022-04-27 | Holt | Nebraska | 31089 | 2161 | 20 |
2450484 | 2450484 | 2022-04-27 | Northampton | Virginia | 51131 | 2161 | 64 |
2442296 | 2442296 | 2022-04-25 | Clearwater | Minnesota | 27029 | 2161 | 30 |
2443972 | 2443972 | 2022-04-25 | Northampton | Virginia | 51131 | 2161 | 63 |
2430297 | 2430297 | 2022-04-21 | Guayanilla | Puerto Rico | 72059 | 2161 | |
2424052 | 2424052 | 2022-04-19 | Archer | Texas | 48009 | 2161 | 28 |
2339822 | 2339822 | 2022-03-24 | Northumberland | Virginia | 51133 | 2161 | 44 |
2315573 | 2315573 | 2022-03-17 | Howard | Missouri | 29089 | 2161 | 25 |
2301776 | 2301776 | 2022-03-13 | Martin | Indiana | 18101 | 2161 | 25 |
2298524 | 2298524 | 2022-03-12 | Martin | Indiana | 18101 | 2161 | 25 |
2295272 | 2295272 | 2022-03-11 | Martin | Indiana | 18101 | 2161 | 25 |
2291771 | 2291771 | 2022-03-10 | Pulaski | Georgia | 13235 | 2161 | 72 |
2292020 | 2292020 | 2022-03-10 | Martin | Indiana | 18101 | 2161 | 25 |
2288528 | 2288528 | 2022-03-09 | Seminole | Georgia | 13253 | 2161 | 28 |
2286330 | 2286330 | 2022-03-08 | Monroe | Missouri | 29137 | 2161 | 40 |
2269539 | 2269539 | 2022-03-03 | Gallatin | Kentucky | 21077 | 2161 | 45 |
2266696 | 2266696 | 2022-03-02 | Kemper | Mississippi | 28069 | 2161 | 47 |
2263445 | 2263445 | 2022-03-01 | Kemper | Mississippi | 28069 | 2161 | 47 |
2259378 | 2259378 | 2022-02-28 | Hamilton | Illinois | 17065 | 2161 | 32 |
2240663 | 2240663 | 2022-02-22 | Choctaw | Mississippi | 28019 | 2161 | 31 |
2189497 | 2189497 | 2022-02-06 | Forest | Pennsylvania | 42053 | 2161 | 34 |
2175820 | 2175820 | 2022-02-02 | Dawson | Montana | 30021 | 2161 | 53 |
2149559 | 2149559 | 2022-01-25 | Rock | Minnesota | 27133 | 2161 | 32 |
2149995 | 2149995 | 2022-01-25 | Los Alamos | New Mexico | 35028 | 2161 | 12 |
2141046 | 2141046 | 2022-01-22 | Blanco | Texas | 48031 | 2161 | 29 |
2134397 | 2134397 | 2022-01-20 | Lake | South Dakota | 46079 | 2161 | 26 |
2130148 | 2130148 | 2022-01-19 | Bollinger | Missouri | 29017 | 2161 | 35 |
2122344 | 2122344 | 2022-01-17 | Mariposa | California | 6043 | 2161 | 18 |
2119092 | 2119092 | 2022-01-16 | Mariposa | California | 6043 | 2161 | 18 |
2115840 | 2115840 | 2022-01-15 | Mariposa | California | 6043 | 2161 | 18 |
2112589 | 2112589 | 2022-01-14 | Mariposa | California | 6043 | 2161 | 18 |
2113936 | 2113936 | 2022-01-14 | Lewis | Missouri | 29111 | 2161 | 31 |
2089232 | 2089232 | 2022-01-06 | Ward | Texas | 48475 | 2161 | 37 |
2054528 | 2054528 | 2021-12-27 | Menard | Illinois | 17129 | 2161 | 19 |
2021001 | 2021001 | 2021-12-16 | Juab | Utah | 49023 | 2161 | 20 |
2018017 | 2018017 | 2021-12-15 | Bayfield | Wisconsin | 55007 | 2161 | 30 |
2014092 | 2014092 | 2021-12-14 | Dewey | South Dakota | 46041 | 2161 | 34 |
1958472 | 1958472 | 2021-11-27 | Noble | Ohio | 39121 | 2161 | 47 |
1955221 | 1955221 | 2021-11-26 | Noble | Ohio | 39121 | 2161 | 47 |
1919954 | 1919954 | 2021-11-15 | Stewart | Tennessee | 47161 | 2161 | 35 |
1916704 | 1916704 | 2021-11-14 | Stewart | Tennessee | 47161 | 2161 | 35 |
1913454 | 1913454 | 2021-11-13 | Stewart | Tennessee | 47161 | 2161 | 35 |
1910204 | 1910204 | 2021-11-12 | Stewart | Tennessee | 47161 | 2161 | 35 |
1887978 | 1887978 | 2021-11-05 | Morgan | West Virginia | 54065 | 2161 | 46 |
1879384 | 1879384 | 2021-11-03 | Fleming | Kentucky | 21069 | 2161 | 34 |
1869262 | 1869262 | 2021-10-31 | Mason | Illinois | 17125 | 2161 | 54 |
1866013 | 1866013 | 2021-10-30 | Mason | Illinois | 17125 | 2161 | 54 |
1862764 | 1862764 | 2021-10-29 | Mason | Illinois | 17125 | 2161 | 54 |
1864794 | 1864794 | 2021-10-29 | Eastland | Texas | 48133 | 2161 | 77 |
1860486 | 1860486 | 2021-10-28 | Glacier | Montana | 30035 | 2161 | 53 |
1851696 | 1851696 | 2021-10-25 | Meigs | Tennessee | 47121 | 2161 | 28 |
1847974 | 1847974 | 2021-10-24 | Monroe | Ohio | 39111 | 2161 | 54 |
1848446 | 1848446 | 2021-10-24 | Meigs | Tennessee | 47121 | 2161 | 28 |
1845196 | 1845196 | 2021-10-23 | Meigs | Tennessee | 47121 | 2161 | 28 |
1841946 | 1841946 | 2021-10-22 | Meigs | Tennessee | 47121 | 2161 | 28 |
1836752 | 1836752 | 2021-10-21 | Jo Daviess | Illinois | 17085 | 2161 | 32 |
1838779 | 1838779 | 2021-10-21 | Comanche | Texas | 48093 | 2161 | 64 |
1833358 | 1833358 | 2021-10-20 | Oglethorpe | Georgia | 13221 | 2161 | 38 |
1832829 | 1832829 | 2021-10-19 | Washburn | Wisconsin | 55129 | 2161 | 27 |
1826272 | 1826272 | 2021-10-17 | Burnett | Wisconsin | 55013 | 2161 | 30 |
1818972 | 1818972 | 2021-10-15 | Fajardo | Puerto Rico | 72053 | 2161 | |
1814061 | 1814061 | 2021-10-14 | Wabash | Illinois | 17185 | 2161 | 22 |
1806428 | 1806428 | 2021-10-11 | Pecos | Texas | 48371 | 2161 | 45 |
1803178 | 1803178 | 2021-10-10 | Pecos | Texas | 48371 | 2161 | 45 |
1796680 | 1796680 | 2021-10-08 | Pecos | Texas | 48371 | 2161 | 45 |
1789428 | 1789428 | 2021-10-06 | Walsh | North Dakota | 38099 | 2161 | 28 |
1779016 | 1779016 | 2021-10-03 | Redwood | Minnesota | 27127 | 2161 | 43 |
1775766 | 1775766 | 2021-10-02 | Redwood | Minnesota | 27127 | 2161 | 43 |
1772516 | 1772516 | 2021-10-01 | Redwood | Minnesota | 27127 | 2161 | 43 |
1741570 | 1741570 | 2021-09-21 | Appomattox | Virginia | 51011 | 2161 | 32 |
1738598 | 1738598 | 2021-09-20 | Sawyer | Wisconsin | 55113 | 2161 | 29 |
1724233 | 1724233 | 2021-09-16 | Taos | New Mexico | 35055 | 2161 | 58 |
1690174 | 1690174 | 2021-09-06 | Elbert | Colorado | 8039 | 2161 | 17 |
1680298 | 1680298 | 2021-09-03 | Howard | Arkansas | 5061 | 2161 | 28 |
1663996 | 1663996 | 2021-08-29 | Juneau City and Borough | Alaska | 2110 | 2161 | 3 |
1666294 | 1666294 | 2021-08-29 | Las Piedras | Puerto Rico | 72085 | 2161 | |
1666366 | 1666366 | 2021-08-29 | Lee | South Carolina | 45061 | 2161 | 66 |
1660748 | 1660748 | 2021-08-28 | Juneau City and Borough | Alaska | 2110 | 2161 | 3 |
1663118 | 1663118 | 2021-08-28 | Lee | South Carolina | 45061 | 2161 | 66 |
1657500 | 1657500 | 2021-08-27 | Juneau City and Borough | Alaska | 2110 | 2161 | 3 |
1659870 | 1659870 | 2021-08-27 | Lee | South Carolina | 45061 | 2161 | 66 |
1656003 | 1656003 | 2021-08-26 | Lincoln | New Mexico | 35027 | 2161 | 20 |
1652562 | 1652562 | 2021-08-25 | Hill | Montana | 30041 | 2161 | 47 |
1634210 | 1634210 | 2021-08-19 | Madison | Texas | 48313 | 2161 | 32 |
1621702 | 1621702 | 2021-08-16 | Cherokee | Alabama | 1019 | 2161 | 49 |
1623085 | 1623085 | 2021-08-16 | Roseau | Minnesota | 27135 | 2161 | 21 |
1603986 | 1603986 | 2021-08-10 | Coos | New Hampshire | 33007 | 2161 | 45 |
1599003 | 1599003 | 2021-08-09 | Monroe | Alabama | 1099 | 2161 | 42 |
1600737 | 1600737 | 2021-08-09 | Coos | New Hampshire | 33007 | 2161 | 45 |
1585833 | 1585833 | 2021-08-04 | Mason | West Virginia | 54053 | 2161 | 38 |
1566594 | 1566594 | 2021-07-30 | Cross | Arkansas | 5037 | 2161 | 53 |
1568052 | 1568052 | 2021-07-30 | Ray | Missouri | 29177 | 2161 | 35 |
1564352 | 1564352 | 2021-07-29 | Concordia | Louisiana | 22029 | 2161 | 62 |
1561019 | 1561019 | 2021-07-28 | Hart | Kentucky | 21099 | 2161 | 54 |
1551310 | 1551310 | 2021-07-25 | Meade | Kentucky | 21163 | 2161 | 26 |
1551864 | 1551864 | 2021-07-25 | Lake | Montana | 30047 | 2161 | 38 |
1553405 | 1553405 | 2021-07-25 | Iowa | Wisconsin | 55049 | 2161 | 14 |
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);