ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 4033 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 16
- Texas 14
- Ohio 13
- Tennessee 10
- Illinois 9
- Oklahoma 9
- Indiana 6
- Kansas 6
- Mississippi 6
- Pennsylvania 6
- Colorado 5
- Kentucky 5
- Virginia 5
- Alabama 4
- Georgia 4
- Minnesota 4
- Puerto Rico 4
- Wisconsin 4
- Iowa 3
- Arkansas 2
- Louisiana 2
- Michigan 2
- Oregon 2
- South Carolina 2
- Arizona 1
- California 1
- Maryland 1
- Missouri 1
- New Mexico 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489712 | 2489712 | 2022-05-09 | Burnett | Wisconsin | 55013 | 4033 | 43 |
2451387 | 2451387 | 2022-04-28 | Mercer | Illinois | 17131 | 4033 | 47 |
2415548 | 2415548 | 2022-04-17 | Jo Daviess | Illinois | 17085 | 4033 | 39 |
2412292 | 2412292 | 2022-04-16 | Jo Daviess | Illinois | 17085 | 4033 | 39 |
2409036 | 2409036 | 2022-04-15 | Jo Daviess | Illinois | 17085 | 4033 | 39 |
2382685 | 2382685 | 2022-04-07 | Dixie | Florida | 12029 | 4033 | 67 |
2379430 | 2379430 | 2022-04-06 | Dixie | Florida | 12029 | 4033 | 67 |
2376176 | 2376176 | 2022-04-05 | Dixie | Florida | 12029 | 4033 | 67 |
2372924 | 2372924 | 2022-04-04 | Dixie | Florida | 12029 | 4033 | 67 |
2369671 | 2369671 | 2022-04-03 | Dixie | Florida | 12029 | 4033 | 67 |
2366418 | 2366418 | 2022-04-02 | Dixie | Florida | 12029 | 4033 | 67 |
2363165 | 2363165 | 2022-04-01 | Dixie | Florida | 12029 | 4033 | 67 |
2359911 | 2359911 | 2022-03-31 | Dixie | Florida | 12029 | 4033 | 67 |
2356657 | 2356657 | 2022-03-30 | Dixie | Florida | 12029 | 4033 | 67 |
2353404 | 2353404 | 2022-03-29 | Dixie | Florida | 12029 | 4033 | 67 |
2350152 | 2350152 | 2022-03-28 | Dixie | Florida | 12029 | 4033 | 67 |
2346899 | 2346899 | 2022-03-27 | Dixie | Florida | 12029 | 4033 | 67 |
2343646 | 2343646 | 2022-03-26 | Dixie | Florida | 12029 | 4033 | 67 |
2340393 | 2340393 | 2022-03-25 | Dixie | Florida | 12029 | 4033 | 67 |
2336532 | 2336532 | 2022-03-23 | Grayson | Virginia | 51077 | 4033 | 79 |
2326673 | 2326673 | 2022-03-20 | Zavala | Texas | 48507 | 4033 | 68 |
2310503 | 2310503 | 2022-03-15 | Giles | Virginia | 51071 | 4033 | 46 |
2300120 | 2300120 | 2022-03-12 | Catano | Puerto Rico | 72033 | 4033 | |
2256164 | 2256164 | 2022-02-27 | Moultrie | Illinois | 17139 | 4033 | 51 |
2252913 | 2252913 | 2022-02-26 | Moultrie | Illinois | 17139 | 4033 | 51 |
2249662 | 2249662 | 2022-02-25 | Moultrie | Illinois | 17139 | 4033 | 51 |
2246527 | 2246527 | 2022-02-24 | Vermillion | Indiana | 18165 | 4033 | 72 |
2243276 | 2243276 | 2022-02-23 | Vermillion | Indiana | 18165 | 4033 | 72 |
2223104 | 2223104 | 2022-02-17 | Clay | Arkansas | 5021 | 4033 | 83 |
2206738 | 2206738 | 2022-02-12 | Clay | Alabama | 1027 | 4033 | 73 |
2177738 | 2177738 | 2022-02-03 | Otero | Colorado | 8089 | 4033 | 123 |
2178537 | 2178537 | 2022-02-03 | Morgan | Kentucky | 21175 | 4033 | 17 |
2178562 | 2178562 | 2022-02-03 | Union | Kentucky | 21225 | 4033 | 52 |
2122536 | 2122536 | 2022-01-17 | Berrien | Georgia | 13019 | 4033 | 72 |
2102681 | 2102681 | 2022-01-11 | Randolph | Alabama | 1111 | 4033 | 68 |
2105025 | 2105025 | 2022-01-11 | San Lorenzo | Puerto Rico | 72129 | 4033 | |
2098958 | 2098958 | 2022-01-09 | Scurry | Texas | 48415 | 4033 | 94 |
2075917 | 2075917 | 2022-01-02 | Fentress | Tennessee | 47049 | 4033 | 89 |
2072666 | 2072666 | 2022-01-01 | Fentress | Tennessee | 47049 | 4033 | 89 |
2069415 | 2069415 | 2021-12-31 | Fentress | Tennessee | 47049 | 4033 | 89 |
2066164 | 2066164 | 2021-12-30 | Fentress | Tennessee | 47049 | 4033 | 89 |
2061826 | 2061826 | 2021-12-29 | Newton | Mississippi | 28101 | 4033 | 84 |
2054323 | 2054323 | 2021-12-27 | Haralson | Georgia | 13143 | 4033 | 131 |
2009149 | 2009149 | 2021-12-13 | Washington | Indiana | 18175 | 4033 | 57 |
1984734 | 1984734 | 2021-12-05 | Mayaguez | Puerto Rico | 72097 | 4033 | |
1969802 | 1969802 | 2021-12-01 | Franklin | Georgia | 13119 | 4033 | 84 |
1966100 | 1966100 | 2021-11-29 | Uinta | Wyoming | 56041 | 4033 | 30 |
1924919 | 1924919 | 2021-11-17 | Marion | Kentucky | 21155 | 4033 | 49 |
1919441 | 1919441 | 2021-11-15 | Henry | Ohio | 39069 | 4033 | 73 |
1912448 | 1912448 | 2021-11-13 | Stone | Missouri | 29209 | 4033 | 86 |
1887963 | 1887963 | 2021-11-05 | Jackson | West Virginia | 54035 | 4033 | 87 |
1884342 | 1884342 | 2021-11-04 | Jasper | Texas | 48241 | 4033 | 155 |
1881093 | 1881093 | 2021-11-03 | Jasper | Texas | 48241 | 4033 | 155 |
1877844 | 1877844 | 2021-11-02 | Jasper | Texas | 48241 | 4033 | 154 |
1874595 | 1874595 | 2021-11-01 | Jasper | Texas | 48241 | 4033 | 154 |
1871346 | 1871346 | 2021-10-31 | Jasper | Texas | 48241 | 4033 | 154 |
1868097 | 1868097 | 2021-10-30 | Jasper | Texas | 48241 | 4033 | 154 |
1864848 | 1864848 | 2021-10-29 | Jasper | Texas | 48241 | 4033 | 154 |
1861599 | 1861599 | 2021-10-28 | Jasper | Texas | 48241 | 4033 | 154 |
1858350 | 1858350 | 2021-10-27 | Jasper | Texas | 48241 | 4033 | 153 |
1853630 | 1853630 | 2021-10-26 | Houghton | Michigan | 26061 | 4033 | 55 |
1850381 | 1850381 | 2021-10-25 | Houghton | Michigan | 26061 | 4033 | 55 |
1770156 | 1770156 | 2021-09-30 | Clarion | Pennsylvania | 42031 | 4033 | 105 |
1740931 | 1740931 | 2021-09-21 | Greene | Pennsylvania | 42059 | 4033 | 47 |
1736071 | 1736071 | 2021-09-20 | Saline | Illinois | 17165 | 4033 | 79 |
1717323 | 1717323 | 2021-09-14 | Covington | Mississippi | 28031 | 4033 | 91 |
1717374 | 1717374 | 2021-09-14 | Sunflower | Mississippi | 28133 | 4033 | 104 |
1699772 | 1699772 | 2021-09-09 | Carroll | Arkansas | 5015 | 4033 | 62 |
1702711 | 1702711 | 2021-09-09 | Wise | Virginia | 51195 | 4033 | 112 |
1679057 | 1679057 | 2021-09-02 | Williams | Ohio | 39171 | 4033 | 80 |
1654880 | 1654880 | 2021-08-26 | Adams | Indiana | 18001 | 4033 | 61 |
1639159 | 1639159 | 2021-08-21 | Worcester | Maryland | 24047 | 4033 | 108 |
1604277 | 1604277 | 2021-08-10 | Clinton | Ohio | 39027 | 4033 | 68 |
1604875 | 1604875 | 2021-08-10 | Cooke | Texas | 48097 | 4033 | 72 |
1598272 | 1598272 | 2021-08-08 | Henderson | Tennessee | 47077 | 4033 | 79 |
1595023 | 1595023 | 2021-08-07 | Henderson | Tennessee | 47077 | 4033 | 79 |
1591774 | 1591774 | 2021-08-06 | Henderson | Tennessee | 47077 | 4033 | 79 |
1585966 | 1585966 | 2021-08-05 | Chambers | Alabama | 1017 | 4033 | 125 |
1558919 | 1558919 | 2021-07-27 | McCurtain | Oklahoma | 40089 | 4033 | 94 |
1555672 | 1555672 | 2021-07-26 | McCurtain | Oklahoma | 40089 | 4033 | 94 |
1552425 | 1552425 | 2021-07-25 | McCurtain | Oklahoma | 40089 | 4033 | 94 |
1549178 | 1549178 | 2021-07-24 | McCurtain | Oklahoma | 40089 | 4033 | 94 |
1545931 | 1545931 | 2021-07-23 | McCurtain | Oklahoma | 40089 | 4033 | 94 |
1542684 | 1542684 | 2021-07-22 | McCurtain | Oklahoma | 40089 | 4033 | 94 |
1539436 | 1539436 | 2021-07-21 | McCurtain | Oklahoma | 40089 | 4033 | 94 |
1518667 | 1518667 | 2021-07-15 | Cowley | Kansas | 20035 | 4033 | 108 |
1515420 | 1515420 | 2021-07-14 | Cowley | Kansas | 20035 | 4033 | 108 |
1512174 | 1512174 | 2021-07-13 | Cowley | Kansas | 20035 | 4033 | 108 |
1508927 | 1508927 | 2021-07-12 | Cowley | Kansas | 20035 | 4033 | 108 |
1489315 | 1489315 | 2021-07-06 | Steuben | Indiana | 18151 | 4033 | 61 |
1490603 | 1490603 | 2021-07-06 | Brown | Ohio | 39015 | 4033 | 61 |
1487356 | 1487356 | 2021-07-05 | Brown | Ohio | 39015 | 4033 | 61 |
1484109 | 1484109 | 2021-07-04 | Brown | Ohio | 39015 | 4033 | 61 |
1480863 | 1480863 | 2021-07-03 | Brown | Ohio | 39015 | 4033 | 61 |
1477616 | 1477616 | 2021-07-02 | Brown | Ohio | 39015 | 4033 | 61 |
1474370 | 1474370 | 2021-07-01 | Brown | Ohio | 39015 | 4033 | 61 |
1464820 | 1464820 | 2021-06-28 | Polk | Oregon | 41053 | 4033 | 56 |
1461575 | 1461575 | 2021-06-27 | Polk | Oregon | 41053 | 4033 | 56 |
1448655 | 1448655 | 2021-06-23 | Pike | Pennsylvania | 42103 | 4033 | 54 |
1445410 | 1445410 | 2021-06-22 | Pike | Pennsylvania | 42103 | 4033 | 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);