ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
204 rows where cases = 2684 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 18
- Virginia 16
- Illinois 15
- Mississippi 14
- Georgia 13
- Missouri 13
- Kansas 10
- Puerto Rico 10
- Texas 9
- Iowa 8
- Tennessee 7
- Colorado 6
- Louisiana 6
- Pennsylvania 5
- Wisconsin 5
- Arkansas 4
- Idaho 4
- Nebraska 4
- North Carolina 4
- Ohio 4
- Indiana 3
- Minnesota 3
- Oregon 3
- South Carolina 3
- Alabama 2
- Florida 2
- Utah 2
- Washington 2
- Arizona 1
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488882 | 2488882 | 2022-05-09 | Adjuntas | Puerto Rico | 72001 | 2684 | |
2488937 | 2488937 | 2022-05-09 | Patillas | Puerto Rico | 72109 | 2684 | |
2483927 | 2483927 | 2022-05-08 | Jasper | Illinois | 17079 | 2684 | 32 |
2480669 | 2480669 | 2022-05-07 | Jasper | Illinois | 17079 | 2684 | 32 |
2477411 | 2477411 | 2022-05-06 | Jasper | Illinois | 17079 | 2684 | 32 |
2474153 | 2474153 | 2022-05-05 | Jasper | Illinois | 17079 | 2684 | 32 |
2451624 | 2451624 | 2022-04-28 | Brown | Kansas | 20013 | 2684 | 46 |
2448368 | 2448368 | 2022-04-27 | Brown | Kansas | 20013 | 2684 | 46 |
2445112 | 2445112 | 2022-04-26 | Brown | Kansas | 20013 | 2684 | 46 |
2441856 | 2441856 | 2022-04-25 | Brown | Kansas | 20013 | 2684 | 46 |
2438600 | 2438600 | 2022-04-24 | Brown | Kansas | 20013 | 2684 | 46 |
2435344 | 2435344 | 2022-04-23 | Brown | Kansas | 20013 | 2684 | 46 |
2432088 | 2432088 | 2022-04-22 | Brown | Kansas | 20013 | 2684 | 46 |
2348154 | 2348154 | 2022-03-27 | Ripley | Missouri | 29181 | 2684 | 61 |
2344901 | 2344901 | 2022-03-26 | Ripley | Missouri | 29181 | 2684 | 61 |
2341648 | 2341648 | 2022-03-25 | Ripley | Missouri | 29181 | 2684 | 61 |
2327179 | 2327179 | 2022-03-21 | Fulton | Arkansas | 5049 | 2684 | 88 |
2304033 | 2304033 | 2022-03-13 | Nelson | Virginia | 51125 | 2684 | 32 |
2300781 | 2300781 | 2022-03-12 | Nelson | Virginia | 51125 | 2684 | 32 |
2297529 | 2297529 | 2022-03-11 | Nelson | Virginia | 51125 | 2684 | 32 |
2294277 | 2294277 | 2022-03-10 | Nelson | Virginia | 51125 | 2684 | 32 |
2291025 | 2291025 | 2022-03-09 | Nelson | Virginia | 51125 | 2684 | 32 |
2278855 | 2278855 | 2022-03-06 | Teton | Idaho | 16081 | 2684 | 8 |
2275602 | 2275602 | 2022-03-05 | Teton | Idaho | 16081 | 2684 | 8 |
2272349 | 2272349 | 2022-03-04 | Teton | Idaho | 16081 | 2684 | 8 |
2236285 | 2236285 | 2022-02-21 | Rio Grande | Colorado | 8105 | 2684 | 44 |
2193456 | 2193456 | 2022-02-07 | Lexington city | Virginia | 51678 | 2684 | 39 |
2176852 | 2176852 | 2022-02-02 | Callahan | Texas | 48059 | 2684 | 64 |
2127730 | 2127730 | 2022-01-18 | Barceloneta | Puerto Rico | 72017 | 2684 | |
2124478 | 2124478 | 2022-01-17 | Barceloneta | Puerto Rico | 72017 | 2684 | |
2111388 | 2111388 | 2022-01-13 | Tillamook | Oregon | 41057 | 2684 | 54 |
2111932 | 2111932 | 2022-01-13 | Nolan | Texas | 48353 | 2684 | 85 |
2097161 | 2097161 | 2022-01-09 | Fleming | Kentucky | 21069 | 2684 | 44 |
2097237 | 2097237 | 2022-01-09 | Trigg | Kentucky | 21221 | 2684 | 31 |
2093909 | 2093909 | 2022-01-08 | Fleming | Kentucky | 21069 | 2684 | 44 |
2093985 | 2093985 | 2022-01-08 | Trigg | Kentucky | 21221 | 2684 | 31 |
2090657 | 2090657 | 2022-01-07 | Fleming | Kentucky | 21069 | 2684 | 44 |
2090733 | 2090733 | 2022-01-07 | Trigg | Kentucky | 21221 | 2684 | 31 |
2080941 | 2080941 | 2022-01-04 | Magoffin | Kentucky | 21153 | 2684 | 35 |
2054646 | 2054646 | 2021-12-27 | Tipton | Indiana | 18159 | 2684 | 71 |
2034756 | 2034756 | 2021-12-21 | Bacon | Georgia | 13005 | 2684 | 64 |
2036334 | 2036334 | 2021-12-21 | Northampton | North Carolina | 37131 | 2684 | 66 |
2011369 | 2011369 | 2021-12-13 | New Kent | Virginia | 51127 | 2684 | 27 |
1995863 | 1995863 | 2021-12-09 | Rabun | Georgia | 13241 | 2684 | 76 |
1993217 | 1993217 | 2021-12-08 | Union | Kentucky | 21225 | 2684 | 43 |
1983254 | 1983254 | 2021-12-05 | Bourbon | Kansas | 20011 | 2684 | 44 |
1980004 | 1980004 | 2021-12-04 | Bourbon | Kansas | 20011 | 2684 | 44 |
1976006 | 1976006 | 2021-12-03 | Madison | Arkansas | 5087 | 2684 | 40 |
1976754 | 1976754 | 2021-12-03 | Bourbon | Kansas | 20011 | 2684 | 44 |
1977410 | 1977410 | 2021-12-03 | Livingston | Missouri | 29117 | 2684 | 79 |
1974160 | 1974160 | 2021-12-02 | Livingston | Missouri | 29117 | 2684 | 79 |
1970745 | 1970745 | 2021-12-01 | Renville | Minnesota | 27129 | 2684 | 51 |
1965808 | 1965808 | 2021-11-29 | Colonial Heights city | Virginia | 51570 | 2684 | 69 |
1921694 | 1921694 | 2021-11-16 | Powell | Kentucky | 21197 | 2684 | 23 |
1918824 | 1918824 | 2021-11-15 | Smith | Mississippi | 28129 | 2684 | 52 |
1904960 | 1904960 | 2021-11-11 | Clay | Illinois | 17025 | 2684 | 59 |
1905825 | 1905825 | 2021-11-11 | Smith | Mississippi | 28129 | 2684 | 52 |
1901710 | 1901710 | 2021-11-10 | Clay | Illinois | 17025 | 2684 | 59 |
1902576 | 1902576 | 2021-11-10 | Smith | Mississippi | 28129 | 2684 | 52 |
1899326 | 1899326 | 2021-11-09 | Smith | Mississippi | 28129 | 2684 | 52 |
1896076 | 1896076 | 2021-11-08 | Smith | Mississippi | 28129 | 2684 | 52 |
1891970 | 1891970 | 2021-11-07 | Edgar | Illinois | 17045 | 2684 | 70 |
1888720 | 1888720 | 2021-11-06 | Edgar | Illinois | 17045 | 2684 | 70 |
1885470 | 1885470 | 2021-11-05 | Edgar | Illinois | 17045 | 2684 | 70 |
1879404 | 1879404 | 2021-11-03 | Jackson | Kentucky | 21109 | 2684 | 50 |
1855895 | 1855895 | 2021-10-27 | Otero | Colorado | 8089 | 2684 | 81 |
1852827 | 1852827 | 2021-10-26 | Jefferson | Georgia | 13163 | 2684 | 86 |
1846123 | 1846123 | 2021-10-24 | Elbert | Colorado | 8039 | 2684 | 23 |
1842873 | 1842873 | 2021-10-23 | Elbert | Colorado | 8039 | 2684 | 23 |
1839623 | 1839623 | 2021-10-22 | Elbert | Colorado | 8039 | 2684 | 23 |
1834696 | 1834696 | 2021-10-20 | Roosevelt | New Mexico | 35041 | 2684 | 68 |
1823017 | 1823017 | 2021-10-16 | Adams | Wisconsin | 55001 | 2684 | 33 |
1819768 | 1819768 | 2021-10-15 | Adams | Wisconsin | 55001 | 2684 | 33 |
1816519 | 1816519 | 2021-10-14 | Adams | Wisconsin | 55001 | 2684 | 33 |
1805579 | 1805579 | 2021-10-11 | Madison | North Carolina | 37115 | 2684 | 56 |
1786829 | 1786829 | 2021-10-05 | Freestone | Texas | 48161 | 2684 | 64 |
1761043 | 1761043 | 2021-09-27 | Franklin | Vermont | 50011 | 2684 | 43 |
1751213 | 1751213 | 2021-09-24 | San Jacinto | Texas | 48407 | 2684 | 62 |
1702268 | 1702268 | 2021-09-09 | Unicoi | Tennessee | 47171 | 2684 | 56 |
1696217 | 1696217 | 2021-09-07 | Adams | Washington | 53001 | 2684 | 25 |
1644939 | 1644939 | 2021-08-23 | Putnam | Georgia | 13237 | 2684 | 64 |
1632476 | 1632476 | 2021-08-19 | Grayson | Kentucky | 21085 | 2684 | 59 |
1633778 | 1633778 | 2021-08-19 | Canovanas | Puerto Rico | 72029 | 2684 | |
1622383 | 1622383 | 2021-08-16 | Union | Illinois | 17181 | 2684 | 46 |
1624341 | 1624341 | 2021-08-16 | Burleson | Texas | 48051 | 2684 | 48 |
1606520 | 1606520 | 2021-08-11 | Lincoln | Kentucky | 21137 | 2684 | 61 |
1607815 | 1607815 | 2021-08-11 | Gurabo | Puerto Rico | 72063 | 2684 | |
1594848 | 1594848 | 2021-08-07 | Rio Grande | Puerto Rico | 72119 | 2684 | |
1575383 | 1575383 | 2021-08-01 | Barnwell | South Carolina | 45011 | 2684 | 58 |
1572035 | 1572035 | 2021-07-31 | Susquehanna | Pennsylvania | 42115 | 2684 | 62 |
1572135 | 1572135 | 2021-07-31 | Barnwell | South Carolina | 45011 | 2684 | 58 |
1568787 | 1568787 | 2021-07-30 | Susquehanna | Pennsylvania | 42115 | 2684 | 62 |
1568887 | 1568887 | 2021-07-30 | Barnwell | South Carolina | 45011 | 2684 | 58 |
1551909 | 1551909 | 2021-07-25 | Cass | Nebraska | 31025 | 2684 | 17 |
1553166 | 1553166 | 2021-07-25 | Botetourt | Virginia | 51023 | 2684 | 38 |
1548662 | 1548662 | 2021-07-24 | Cass | Nebraska | 31025 | 2684 | 17 |
1549919 | 1549919 | 2021-07-24 | Botetourt | Virginia | 51023 | 2684 | 38 |
1545415 | 1545415 | 2021-07-23 | Cass | Nebraska | 31025 | 2684 | 17 |
1546672 | 1546672 | 2021-07-23 | Botetourt | Virginia | 51023 | 2684 | 38 |
1541570 | 1541570 | 2021-07-22 | Mercer | Kentucky | 21167 | 2684 | 54 |
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);