ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where cases = 2093 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 20
- Georgia 19
- Missouri 13
- Virginia 12
- Illinois 11
- Alabama 10
- Colorado 9
- Kentucky 9
- Ohio 9
- Texas 9
- Minnesota 6
- Tennessee 6
- Indiana 5
- Michigan 5
- Wisconsin 5
- California 4
- Idaho 4
- Iowa 4
- Louisiana 4
- Mississippi 4
- Montana 4
- North Carolina 4
- Utah 4
- Nevada 3
- North Dakota 3
- Oklahoma 3
- Pennsylvania 3
- Puerto Rico 3
- South Carolina 3
- South Dakota 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502001 | 2502001 | 2022-05-13 | Allendale | South Carolina | 45005 | 2093 | 24 |
2498743 | 2498743 | 2022-05-12 | Allendale | South Carolina | 45005 | 2093 | 24 |
2495485 | 2495485 | 2022-05-11 | Allendale | South Carolina | 45005 | 2093 | 24 |
2445968 | 2445968 | 2022-04-26 | Unknown | Nebraska | 2093 | 461 | |
2441004 | 2441004 | 2022-04-25 | Perry | Alabama | 1105 | 2093 | 46 |
2442325 | 2442325 | 2022-04-25 | Marshall | Minnesota | 27089 | 2093 | 23 |
2437748 | 2437748 | 2022-04-24 | Perry | Alabama | 1105 | 2093 | 46 |
2434492 | 2434492 | 2022-04-23 | Perry | Alabama | 1105 | 2093 | 46 |
2431236 | 2431236 | 2022-04-22 | Perry | Alabama | 1105 | 2093 | 46 |
2427980 | 2427980 | 2022-04-21 | Perry | Alabama | 1105 | 2093 | 46 |
2428719 | 2428719 | 2022-04-21 | Warren | Indiana | 18171 | 2093 | 30 |
2424724 | 2424724 | 2022-04-20 | Perry | Alabama | 1105 | 2093 | 46 |
2425463 | 2425463 | 2022-04-20 | Warren | Indiana | 18171 | 2093 | 30 |
2421468 | 2421468 | 2022-04-19 | Perry | Alabama | 1105 | 2093 | 46 |
2421276 | 2421276 | 2022-04-18 | Gilmer | West Virginia | 54021 | 2093 | 19 |
2307935 | 2307935 | 2022-03-15 | Candler | Georgia | 13043 | 2093 | 94 |
2304684 | 2304684 | 2022-03-14 | Candler | Georgia | 13043 | 2093 | 94 |
2294691 | 2294691 | 2022-03-11 | Searcy | Arkansas | 5129 | 2093 | 42 |
2291439 | 2291439 | 2022-03-10 | Searcy | Arkansas | 5129 | 2093 | 42 |
2266259 | 2266259 | 2022-03-02 | Bracken | Kentucky | 21023 | 2093 | 24 |
2245195 | 2245195 | 2022-02-23 | Franklin | Texas | 48159 | 2093 | 39 |
2245328 | 2245328 | 2022-02-23 | Somervell | Texas | 48425 | 2093 | 34 |
2242077 | 2242077 | 2022-02-22 | Somervell | Texas | 48425 | 2093 | 34 |
2237602 | 2237602 | 2022-02-21 | Beaverhead | Montana | 30001 | 2093 | 26 |
2234351 | 2234351 | 2022-02-20 | Beaverhead | Montana | 30001 | 2093 | 26 |
2231100 | 2231100 | 2022-02-19 | Beaverhead | Montana | 30001 | 2093 | 26 |
2227849 | 2227849 | 2022-02-18 | Beaverhead | Montana | 30001 | 2093 | 26 |
2217643 | 2217643 | 2022-02-15 | Red River | Louisiana | 22081 | 2093 | 51 |
2210496 | 2210496 | 2022-02-13 | Stewart | Georgia | 13259 | 2093 | 31 |
2207243 | 2207243 | 2022-02-12 | Stewart | Georgia | 13259 | 2093 | 31 |
2203990 | 2203990 | 2022-02-11 | Stewart | Georgia | 13259 | 2093 | 31 |
2198085 | 2198085 | 2022-02-09 | Wolfe | Kentucky | 21237 | 2093 | 18 |
2191999 | 2191999 | 2022-02-07 | Howard | Missouri | 29089 | 2093 | 22 |
2193233 | 2193233 | 2022-02-07 | Live Oak | Texas | 48297 | 2093 | 40 |
2188746 | 2188746 | 2022-02-06 | Howard | Missouri | 29089 | 2093 | 22 |
2164736 | 2164736 | 2022-01-30 | San Miguel | Colorado | 8113 | 2093 | 7 |
2165035 | 2165035 | 2022-01-30 | Washington | Idaho | 16087 | 2093 | 52 |
2161780 | 2161780 | 2022-01-29 | Washington | Idaho | 16087 | 2093 | 52 |
2158225 | 2158225 | 2022-01-28 | San Miguel | Colorado | 8113 | 2093 | 7 |
2155581 | 2155581 | 2022-01-27 | Cloud | Kansas | 20029 | 2093 | 34 |
2151890 | 2151890 | 2022-01-26 | Johnson | Georgia | 13167 | 2093 | 65 |
2152328 | 2152328 | 2022-01-26 | Cloud | Kansas | 20029 | 2093 | 34 |
2143195 | 2143195 | 2022-01-23 | Grundy | Missouri | 29079 | 2093 | 61 |
2131161 | 2131161 | 2022-01-19 | Roberts | South Dakota | 46109 | 2093 | 45 |
2121858 | 2121858 | 2022-01-16 | Franklin city | Virginia | 51620 | 2093 | 43 |
2118606 | 2118606 | 2022-01-15 | Franklin city | Virginia | 51620 | 2093 | 43 |
2115354 | 2115354 | 2022-01-14 | Franklin city | Virginia | 51620 | 2093 | 43 |
2099674 | 2099674 | 2022-01-10 | Rio Grande | Colorado | 8105 | 2093 | 40 |
2073479 | 2073479 | 2022-01-02 | Bradley | Arkansas | 5011 | 2093 | 43 |
2070231 | 2070231 | 2022-01-01 | Chicot | Arkansas | 5017 | 2093 | 48 |
2032606 | 2032606 | 2021-12-20 | Webster | Mississippi | 28155 | 2093 | 49 |
2020584 | 2020584 | 2021-12-16 | Charles Mix | South Dakota | 46023 | 2093 | 30 |
1997705 | 1997705 | 2021-12-09 | Cayey | Puerto Rico | 72035 | 2093 | |
1993948 | 1993948 | 2021-12-08 | Torrance | New Mexico | 35057 | 2093 | 25 |
1967125 | 1967125 | 2021-11-30 | Carroll | Kentucky | 21041 | 2093 | 31 |
1937126 | 1937126 | 2021-11-21 | Las Animas | Colorado | 8071 | 2093 | 27 |
1933876 | 1933876 | 2021-11-20 | Las Animas | Colorado | 8071 | 2093 | 27 |
1930624 | 1930624 | 2021-11-19 | Las Animas | Colorado | 8071 | 2093 | 27 |
1924552 | 1924552 | 2021-11-17 | Blackford | Indiana | 18009 | 2093 | 46 |
1914726 | 1914726 | 2021-11-14 | Greene | Illinois | 17061 | 2093 | 53 |
1911476 | 1911476 | 2021-11-13 | Greene | Illinois | 17061 | 2093 | 53 |
1908227 | 1908227 | 2021-11-12 | Greene | Illinois | 17061 | 2093 | 53 |
1899969 | 1899969 | 2021-11-09 | Noble | Ohio | 39121 | 2093 | 47 |
1900419 | 1900419 | 2021-11-09 | Jackson | Tennessee | 47087 | 2093 | 40 |
1897756 | 1897756 | 2021-11-08 | Buffalo | Wisconsin | 55011 | 2093 | 8 |
1894351 | 1894351 | 2021-11-07 | Martinsville city | Virginia | 51690 | 2093 | 91 |
1894366 | 1894366 | 2021-11-07 | Patrick | Virginia | 51141 | 2093 | 55 |
1891101 | 1891101 | 2021-11-06 | Martinsville city | Virginia | 51690 | 2093 | 91 |
1891116 | 1891116 | 2021-11-06 | Patrick | Virginia | 51141 | 2093 | 55 |
1887851 | 1887851 | 2021-11-05 | Martinsville city | Virginia | 51690 | 2093 | 91 |
1887866 | 1887866 | 2021-11-05 | Patrick | Virginia | 51141 | 2093 | 55 |
1849256 | 1849256 | 2021-10-25 | Lee | Arkansas | 5077 | 2093 | 48 |
1846006 | 1846006 | 2021-10-24 | Lee | Arkansas | 5077 | 2093 | 48 |
1832720 | 1832720 | 2021-10-19 | Grant | West Virginia | 54023 | 2093 | 32 |
1829253 | 1829253 | 2021-10-18 | Millard | Utah | 49027 | 2093 | 24 |
1826004 | 1826004 | 2021-10-17 | Millard | Utah | 49027 | 2093 | 24 |
1822755 | 1822755 | 2021-10-16 | Millard | Utah | 49027 | 2093 | 24 |
1819506 | 1819506 | 2021-10-15 | Millard | Utah | 49027 | 2093 | 24 |
1810387 | 1810387 | 2021-10-13 | Grand | Colorado | 8049 | 2093 | 10 |
1812158 | 1812158 | 2021-10-13 | Ramsey | North Dakota | 38071 | 2093 | 33 |
1807337 | 1807337 | 2021-10-12 | Jasper | Georgia | 13159 | 2093 | 57 |
1792075 | 1792075 | 2021-10-07 | Lawrence | Mississippi | 28077 | 2093 | 38 |
1769226 | 1769226 | 2021-09-30 | Fillmore | Minnesota | 27045 | 2093 | 11 |
1764388 | 1764388 | 2021-09-28 | New Kent | Virginia | 51127 | 2093 | 20 |
1757691 | 1757691 | 2021-09-26 | Pecos | Texas | 48371 | 2093 | 44 |
1732809 | 1732809 | 2021-09-19 | Moultrie | Illinois | 17139 | 2093 | 39 |
1729559 | 1729559 | 2021-09-18 | Moultrie | Illinois | 17139 | 2093 | 39 |
1726309 | 1726309 | 2021-09-17 | Moultrie | Illinois | 17139 | 2093 | 39 |
1675972 | 1675972 | 2021-09-01 | Montour | Pennsylvania | 42093 | 2093 | 67 |
1671940 | 1671940 | 2021-08-31 | Dallas | Missouri | 29059 | 2093 | 38 |
1667308 | 1667308 | 2021-08-30 | Howard | Arkansas | 5061 | 2093 | 28 |
1664061 | 1664061 | 2021-08-29 | Howard | Arkansas | 5061 | 2093 | 28 |
1655468 | 1655468 | 2021-08-26 | Manistee | Michigan | 26101 | 2093 | 28 |
1652221 | 1652221 | 2021-08-25 | Manistee | Michigan | 26101 | 2093 | 28 |
1648360 | 1648360 | 2021-08-24 | Richland | Illinois | 17159 | 2093 | 56 |
1644106 | 1644106 | 2021-08-22 | St. Croix | Virgin Islands | 78010 | 2093 | 17 |
1620515 | 1620515 | 2021-08-15 | Carroll | Ohio | 39019 | 2093 | 49 |
1546088 | 1546088 | 2021-07-23 | Corozal | Puerto Rico | 72047 | 2093 | |
1534480 | 1534480 | 2021-07-20 | Meriwether | Georgia | 13199 | 2093 | 91 |
1509159 | 1509159 | 2021-07-12 | Jackson | Louisiana | 22049 | 2093 | 52 |
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);