ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
166 rows where cases = 3412 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 15
- Georgia 14
- Kentucky 14
- Texas 14
- Mississippi 12
- Indiana 8
- Iowa 7
- Tennessee 7
- Washington 7
- Illinois 6
- Michigan 6
- New York 5
- Ohio 5
- Alabama 4
- Kansas 4
- Virginia 4
- Florida 3
- Minnesota 3
- Nebraska 3
- North Carolina 3
- Oregon 3
- South Carolina 3
- Idaho 2
- Missouri 2
- Puerto Rico 2
- Wisconsin 2
- California 1
- Colorado 1
- Guam 1
- Louisiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502272 | 2502272 | 2022-05-13 | Duval | Texas | 48131 | 3412 | 70 |
2491554 | 2491554 | 2022-05-10 | Seward | Nebraska | 31159 | 3412 | 42 |
2488296 | 2488296 | 2022-05-09 | Seward | Nebraska | 31159 | 3412 | 42 |
2443963 | 2443963 | 2022-04-25 | Martinsville city | Virginia | 51690 | 3412 | 122 |
2421809 | 2421809 | 2022-04-19 | Bacon | Georgia | 13005 | 3412 | 75 |
2418553 | 2418553 | 2022-04-18 | Bacon | Georgia | 13005 | 3412 | 75 |
2415297 | 2415297 | 2022-04-17 | Bacon | Georgia | 13005 | 3412 | 75 |
2412041 | 2412041 | 2022-04-16 | Bacon | Georgia | 13005 | 3412 | 75 |
2408785 | 2408785 | 2022-04-15 | Bacon | Georgia | 13005 | 3412 | 75 |
2352490 | 2352490 | 2022-03-28 | Comanche | Texas | 48093 | 3412 | 78 |
2349238 | 2349238 | 2022-03-27 | Comanche | Texas | 48093 | 3412 | 78 |
2345985 | 2345985 | 2022-03-26 | Comanche | Texas | 48093 | 3412 | 78 |
2304970 | 2304970 | 2022-03-14 | Washington | Illinois | 17189 | 3412 | 40 |
2285601 | 2285601 | 2022-03-08 | Harrison | Iowa | 19085 | 3412 | 93 |
2282349 | 2282349 | 2022-03-07 | Harrison | Iowa | 19085 | 3412 | 93 |
2279096 | 2279096 | 2022-03-06 | Harrison | Iowa | 19085 | 3412 | 93 |
2275843 | 2275843 | 2022-03-05 | Harrison | Iowa | 19085 | 3412 | 93 |
2272590 | 2272590 | 2022-03-04 | Harrison | Iowa | 19085 | 3412 | 93 |
2269338 | 2269338 | 2022-03-03 | Harrison | Iowa | 19085 | 3412 | 93 |
2269596 | 2269596 | 2022-03-03 | Pendleton | Kentucky | 21191 | 3412 | 34 |
2266085 | 2266085 | 2022-03-02 | Harrison | Iowa | 19085 | 3412 | 93 |
2246762 | 2246762 | 2022-02-24 | Carroll | Kentucky | 21041 | 3412 | 41 |
2243511 | 2243511 | 2022-02-23 | Carroll | Kentucky | 21041 | 3412 | 41 |
2233848 | 2233848 | 2022-02-20 | Trigg | Kentucky | 21221 | 3412 | 41 |
2234855 | 2234855 | 2022-02-20 | Monroe | Ohio | 39111 | 3412 | 73 |
2230597 | 2230597 | 2022-02-19 | Trigg | Kentucky | 21221 | 3412 | 41 |
2231604 | 2231604 | 2022-02-19 | Monroe | Ohio | 39111 | 3412 | 73 |
2226416 | 2226416 | 2022-02-18 | Van Buren | Arkansas | 5141 | 3412 | 55 |
2227346 | 2227346 | 2022-02-18 | Trigg | Kentucky | 21221 | 3412 | 41 |
2205811 | 2205811 | 2022-02-11 | Aibonito | Puerto Rico | 72009 | 3412 | |
2200612 | 2200612 | 2022-02-10 | Bacon | Georgia | 13005 | 3412 | 67 |
2191123 | 2191123 | 2022-02-07 | Menard | Illinois | 17129 | 3412 | 22 |
2167726 | 2167726 | 2022-01-31 | Lamar | Alabama | 1075 | 3412 | 60 |
2132365 | 2132365 | 2022-01-20 | Jeff Davis | Georgia | 13161 | 3412 | 64 |
2111814 | 2111814 | 2022-01-13 | DeWitt | Texas | 48123 | 3412 | 86 |
2107300 | 2107300 | 2022-01-12 | Calhoun | Mississippi | 28013 | 3412 | 52 |
2078009 | 2078009 | 2022-01-03 | Roseau | Minnesota | 27135 | 3412 | 37 |
2074621 | 2074621 | 2022-01-02 | Charlevoix | Michigan | 26029 | 3412 | 52 |
2071370 | 2071370 | 2022-01-01 | Charlevoix | Michigan | 26029 | 3412 | 52 |
2068119 | 2068119 | 2021-12-31 | Charlevoix | Michigan | 26029 | 3412 | 52 |
2064868 | 2064868 | 2021-12-30 | Charlevoix | Michigan | 26029 | 3412 | 52 |
2061618 | 2061618 | 2021-12-29 | Charlevoix | Michigan | 26029 | 3412 | 52 |
2056922 | 2056922 | 2021-12-27 | Adams | Washington | 53001 | 3412 | 34 |
2022550 | 2022550 | 2021-12-17 | Franklin | Maine | 23007 | 3412 | 40 |
2019080 | 2019080 | 2021-12-16 | Pottawatomie | Kansas | 20149 | 3412 | 47 |
2015830 | 2015830 | 2021-12-15 | Pottawatomie | Kansas | 20149 | 3412 | 47 |
1993206 | 1993206 | 2021-12-08 | Rockcastle | Kentucky | 21203 | 3412 | 43 |
1983798 | 1983798 | 2021-12-05 | Jasper | Mississippi | 28061 | 3412 | 66 |
1984710 | 1984710 | 2021-12-05 | Dorado | Puerto Rico | 72051 | 3412 | |
1980548 | 1980548 | 2021-12-04 | Jasper | Mississippi | 28061 | 3412 | 66 |
1977298 | 1977298 | 2021-12-03 | Jasper | Mississippi | 28061 | 3412 | 66 |
1974048 | 1974048 | 2021-12-02 | Jasper | Mississippi | 28061 | 3412 | 66 |
1937626 | 1937626 | 2021-11-21 | Sullivan | Indiana | 18153 | 3412 | 56 |
1934376 | 1934376 | 2021-11-20 | Sullivan | Indiana | 18153 | 3412 | 56 |
1931125 | 1931125 | 2021-11-19 | Sullivan | Indiana | 18153 | 3412 | 56 |
1906595 | 1906595 | 2021-11-11 | Lincoln | Oregon | 41041 | 3412 | 46 |
1903346 | 1903346 | 2021-11-10 | Lincoln | Oregon | 41041 | 3412 | 46 |
1875261 | 1875261 | 2021-11-02 | Ouachita | Arkansas | 5103 | 3412 | 85 |
1872012 | 1872012 | 2021-11-01 | Ouachita | Arkansas | 5103 | 3412 | 85 |
1849396 | 1849396 | 2021-10-25 | Morgan | Colorado | 8087 | 3412 | 99 |
1836582 | 1836582 | 2021-10-21 | Jones | Georgia | 13169 | 3412 | 89 |
1811200 | 1811200 | 2021-10-13 | Meade | Kentucky | 21163 | 3412 | 35 |
1788541 | 1788541 | 2021-10-06 | St. James | Louisiana | 22093 | 3412 | 70 |
1778417 | 1778417 | 2021-10-03 | Washington | Indiana | 18175 | 3412 | 47 |
1775167 | 1775167 | 2021-10-02 | Washington | Indiana | 18175 | 3412 | 47 |
1771917 | 1771917 | 2021-10-01 | Washington | Indiana | 18175 | 3412 | 47 |
1768276 | 1768276 | 2021-09-30 | Berrien | Georgia | 13019 | 3412 | 59 |
1766321 | 1766321 | 2021-09-29 | Dawson | Nebraska | 31047 | 3412 | 31 |
1767701 | 1767701 | 2021-09-29 | Island | Washington | 53029 | 3412 | 43 |
1767795 | 1767795 | 2021-09-29 | Door | Wisconsin | 55029 | 3412 | 38 |
1763341 | 1763341 | 2021-09-28 | Martin | North Carolina | 37117 | 3412 | 61 |
1713091 | 1713091 | 2021-09-13 | Fannin | Georgia | 13111 | 3412 | 85 |
1695723 | 1695723 | 2021-09-07 | Haywood | Tennessee | 47075 | 3412 | 66 |
1686834 | 1686834 | 2021-09-05 | Sevier | Arkansas | 5133 | 3412 | 31 |
1671096 | 1671096 | 2021-08-31 | Saline | Illinois | 17165 | 3412 | 76 |
1643870 | 1643870 | 2021-08-22 | Dimmit | Texas | 48127 | 3412 | 38 |
1640620 | 1640620 | 2021-08-21 | Dimmit | Texas | 48127 | 3412 | 38 |
1632530 | 1632530 | 2021-08-19 | Perry | Kentucky | 21193 | 3412 | 68 |
1634484 | 1634484 | 2021-08-19 | Warren | Virginia | 51187 | 3412 | 64 |
1621732 | 1621732 | 2021-08-16 | Lawrence | Alabama | 1079 | 3412 | 100 |
1619083 | 1619083 | 2021-08-15 | Iroquois | Illinois | 17075 | 3412 | 70 |
1615835 | 1615835 | 2021-08-14 | Iroquois | Illinois | 17075 | 3412 | 70 |
1612586 | 1612586 | 2021-08-13 | Iroquois | Illinois | 17075 | 3412 | 70 |
1603311 | 1603311 | 2021-08-10 | Taylor | Kentucky | 21217 | 3412 | 55 |
1535472 | 1535472 | 2021-07-20 | Sunflower | Mississippi | 28133 | 3412 | 93 |
1515072 | 1515072 | 2021-07-14 | Bonner | Idaho | 16017 | 3412 | 45 |
1506631 | 1506631 | 2021-07-11 | Greene | New York | 36039 | 3412 | 79 |
1503385 | 1503385 | 2021-07-10 | Greene | New York | 36039 | 3412 | 79 |
1445905 | 1445905 | 2021-06-22 | Polk | Texas | 48373 | 3412 | 120 |
1442660 | 1442660 | 2021-06-21 | Polk | Texas | 48373 | 3412 | 120 |
1439415 | 1439415 | 2021-06-20 | Polk | Texas | 48373 | 3412 | 120 |
1436168 | 1436168 | 2021-06-19 | Polk | Texas | 48373 | 3412 | 120 |
1432921 | 1432921 | 2021-06-18 | Polk | Texas | 48373 | 3412 | 120 |
1392647 | 1392647 | 2021-06-06 | Tate | Mississippi | 28137 | 3412 | 86 |
1389402 | 1389402 | 2021-06-05 | Tate | Mississippi | 28137 | 3412 | 86 |
1386157 | 1386157 | 2021-06-04 | Tate | Mississippi | 28137 | 3412 | 86 |
1367271 | 1367271 | 2021-05-29 | Champaign | Ohio | 39021 | 3412 | 58 |
1353798 | 1353798 | 2021-05-25 | Polk | Missouri | 29167 | 3412 | 40 |
1328093 | 1328093 | 2021-05-17 | Chenango | New York | 36017 | 3412 | 76 |
1314180 | 1314180 | 2021-05-13 | Geary | Kansas | 20061 | 3412 | 40 |
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);