ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
144 rows where cases = 3602 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 20
- Georgia 12
- Kentucky 9
- Missouri 9
- Virginia 8
- Indiana 7
- Oklahoma 7
- Ohio 6
- South Carolina 6
- Wyoming 5
- Arkansas 4
- North Carolina 4
- Tennessee 4
- Connecticut 3
- Illinois 3
- Kansas 3
- Nebraska 3
- Wisconsin 3
- Alabama 2
- California 2
- Louisiana 2
- Maryland 2
- Mississippi 2
- New York 2
- Pennsylvania 2
- Puerto Rico 2
- West Virginia 2
- Florida 1
- Michigan 1
- Minnesota 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452427 | 2452427 | 2022-04-28 | Gage | Nebraska | 31067 | 3602 | 44 |
2449171 | 2449171 | 2022-04-27 | Gage | Nebraska | 31067 | 3602 | 44 |
2445914 | 2445914 | 2022-04-26 | Gage | Nebraska | 31067 | 3602 | 44 |
2420801 | 2420801 | 2022-04-18 | Bandera | Texas | 48019 | 3602 | 77 |
2417545 | 2417545 | 2022-04-17 | Bandera | Texas | 48019 | 3602 | 77 |
2414289 | 2414289 | 2022-04-16 | Bandera | Texas | 48019 | 3602 | 77 |
2411033 | 2411033 | 2022-04-15 | Bandera | Texas | 48019 | 3602 | 77 |
2407777 | 2407777 | 2022-04-14 | Bandera | Texas | 48019 | 3602 | 77 |
2404521 | 2404521 | 2022-04-13 | Bandera | Texas | 48019 | 3602 | 76 |
2401266 | 2401266 | 2022-04-12 | Bandera | Texas | 48019 | 3602 | 76 |
2398011 | 2398011 | 2022-04-11 | Bandera | Texas | 48019 | 3602 | 76 |
2324836 | 2324836 | 2022-03-20 | Green | Kentucky | 21087 | 3602 | 40 |
2321582 | 2321582 | 2022-03-19 | Green | Kentucky | 21087 | 3602 | 40 |
2318328 | 2318328 | 2022-03-18 | Green | Kentucky | 21087 | 3602 | 40 |
2315075 | 2315075 | 2022-03-17 | Green | Kentucky | 21087 | 3602 | 40 |
2311822 | 2311822 | 2022-03-16 | Green | Kentucky | 21087 | 3602 | 40 |
2308569 | 2308569 | 2022-03-15 | Green | Kentucky | 21087 | 3602 | 40 |
2305318 | 2305318 | 2022-03-14 | Green | Kentucky | 21087 | 3602 | 40 |
2292825 | 2292825 | 2022-03-10 | Macon | Missouri | 29121 | 3602 | 52 |
2294501 | 2294501 | 2022-03-10 | Goshen | Wyoming | 56015 | 3602 | 56 |
2271687 | 2271687 | 2022-03-03 | Lafayette | Wisconsin | 55065 | 3602 | 22 |
2266430 | 2266430 | 2022-03-02 | West Carroll | Louisiana | 22123 | 3602 | 60 |
2241301 | 2241301 | 2022-02-22 | Unknown | Northern Mariana Islands | 3602 | 4 | |
2222726 | 2222726 | 2022-02-16 | King William | Virginia | 51101 | 3602 | 31 |
2199737 | 2199737 | 2022-02-09 | Leon | Texas | 48289 | 3602 | 81 |
2172469 | 2172469 | 2022-02-01 | Dallas | Missouri | 29059 | 3602 | 65 |
2154824 | 2154824 | 2022-01-27 | Madison | Arkansas | 5087 | 3602 | 47 |
2145522 | 2145522 | 2022-01-24 | Carroll | Illinois | 17015 | 3602 | 45 |
2106017 | 2106017 | 2022-01-12 | Hempstead | Arkansas | 5057 | 3602 | 51 |
2099488 | 2099488 | 2022-01-10 | Ashley | Arkansas | 5003 | 3602 | 56 |
2097088 | 2097088 | 2022-01-09 | Neosho | Kansas | 20133 | 3602 | 55 |
2093836 | 2093836 | 2022-01-08 | Neosho | Kansas | 20133 | 3602 | 55 |
2090584 | 2090584 | 2022-01-07 | Neosho | Kansas | 20133 | 3602 | 55 |
2079051 | 2079051 | 2022-01-03 | Fairfield | South Carolina | 45039 | 3602 | 95 |
2074885 | 2074885 | 2022-01-02 | Clinton | Missouri | 29049 | 3602 | 100 |
2075800 | 2075800 | 2022-01-02 | Fairfield | South Carolina | 45039 | 3602 | 95 |
2071634 | 2071634 | 2022-01-01 | Clinton | Missouri | 29049 | 3602 | 100 |
2072549 | 2072549 | 2022-01-01 | Fairfield | South Carolina | 45039 | 3602 | 95 |
2068383 | 2068383 | 2021-12-31 | Clinton | Missouri | 29049 | 3602 | 100 |
2069298 | 2069298 | 2021-12-31 | Fairfield | South Carolina | 45039 | 3602 | 95 |
2065132 | 2065132 | 2021-12-30 | Clinton | Missouri | 29049 | 3602 | 100 |
2016688 | 2016688 | 2021-12-15 | Lincoln | New Mexico | 35027 | 3602 | 43 |
2014787 | 2014787 | 2021-12-14 | Green Lake | Wisconsin | 55047 | 3602 | 44 |
1963385 | 1963385 | 2021-11-29 | Union | Georgia | 13291 | 3602 | 129 |
1910227 | 1910227 | 2021-11-12 | Austin | Texas | 48015 | 3602 | 56 |
1875526 | 1875526 | 2021-11-02 | Cook | Georgia | 13075 | 3602 | 62 |
1846292 | 1846292 | 2021-10-24 | Dodge | Georgia | 13091 | 3602 | 125 |
1847382 | 1847382 | 2021-10-24 | Crawford | Missouri | 29055 | 3602 | 57 |
1843042 | 1843042 | 2021-10-23 | Dodge | Georgia | 13091 | 3602 | 125 |
1844132 | 1844132 | 2021-10-23 | Crawford | Missouri | 29055 | 3602 | 57 |
1844929 | 1844929 | 2021-10-23 | Susquehanna | Pennsylvania | 42115 | 3602 | 66 |
1839792 | 1839792 | 2021-10-22 | Dodge | Georgia | 13091 | 3602 | 125 |
1836543 | 1836543 | 2021-10-21 | Dodge | Georgia | 13091 | 3602 | 123 |
1787370 | 1787370 | 2021-10-05 | Uinta | Wyoming | 56041 | 3602 | 26 |
1768067 | 1768067 | 2021-09-30 | Calaveras | California | 6009 | 3602 | 72 |
1748164 | 1748164 | 2021-09-23 | Pulaski | Virginia | 51155 | 3602 | 75 |
1741427 | 1741427 | 2021-09-21 | Milam | Texas | 48331 | 3602 | 69 |
1720606 | 1720606 | 2021-09-15 | Newton | Mississippi | 28101 | 3602 | 73 |
1700369 | 1700369 | 2021-09-09 | Clay | Indiana | 18021 | 3602 | 54 |
1697490 | 1697490 | 2021-09-08 | Mercer | Kentucky | 21167 | 3602 | 57 |
1693676 | 1693676 | 2021-09-07 | Sumter | Georgia | 13261 | 3602 | 111 |
1672339 | 1672339 | 2021-08-31 | Cherokee | North Carolina | 37039 | 3602 | 45 |
1667610 | 1667610 | 2021-08-30 | Emanuel | Georgia | 13107 | 3602 | 86 |
1669626 | 1669626 | 2021-08-30 | Union | South Carolina | 45087 | 3602 | 84 |
1650829 | 1650829 | 2021-08-24 | Wayne | West Virginia | 54099 | 3602 | 48 |
1644425 | 1644425 | 2021-08-22 | Sheridan | Wyoming | 56033 | 3602 | 33 |
1641175 | 1641175 | 2021-08-21 | Sheridan | Wyoming | 56033 | 3602 | 33 |
1637925 | 1637925 | 2021-08-20 | Sheridan | Wyoming | 56033 | 3602 | 33 |
1631841 | 1631841 | 2021-08-19 | Butts | Georgia | 13035 | 3602 | 91 |
1625057 | 1625057 | 2021-08-17 | Carroll | Arkansas | 5015 | 3602 | 52 |
1613999 | 1613999 | 2021-08-13 | Stutsman | North Dakota | 38093 | 3602 | 82 |
1606223 | 1606223 | 2021-08-11 | Ripley | Indiana | 18137 | 3602 | 72 |
1600368 | 1600368 | 2021-08-09 | Adams | Mississippi | 28001 | 3602 | 90 |
1461417 | 1461417 | 2021-06-27 | Highland | Ohio | 39071 | 3602 | 66 |
1458172 | 1458172 | 2021-06-26 | Highland | Ohio | 39071 | 3602 | 66 |
1454927 | 1454927 | 2021-06-25 | Highland | Ohio | 39071 | 3602 | 66 |
1451682 | 1451682 | 2021-06-24 | Highland | Ohio | 39071 | 3602 | 66 |
1448436 | 1448436 | 2021-06-23 | Highland | Ohio | 39071 | 3602 | 66 |
1425870 | 1425870 | 2021-06-16 | Malheur | Oregon | 41045 | 3602 | 63 |
1423228 | 1423228 | 2021-06-15 | Uvalde | Texas | 48463 | 3602 | 73 |
1419982 | 1419982 | 2021-06-14 | Uvalde | Texas | 48463 | 3602 | 73 |
1416737 | 1416737 | 2021-06-13 | Uvalde | Texas | 48463 | 3602 | 73 |
1413491 | 1413491 | 2021-06-12 | Uvalde | Texas | 48463 | 3602 | 73 |
1410246 | 1410246 | 2021-06-11 | Uvalde | Texas | 48463 | 3602 | 73 |
1407001 | 1407001 | 2021-06-10 | Uvalde | Texas | 48463 | 3602 | 73 |
1400926 | 1400926 | 2021-06-09 | Dallas | Alabama | 1047 | 3602 | 154 |
1403755 | 1403755 | 2021-06-09 | Uvalde | Texas | 48463 | 3602 | 73 |
1400510 | 1400510 | 2021-06-08 | Uvalde | Texas | 48463 | 3602 | 73 |
1385463 | 1385463 | 2021-06-04 | Wabash | Indiana | 18169 | 3602 | 82 |
1364979 | 1364979 | 2021-05-28 | Prince George | Virginia | 51149 | 3602 | 30 |
1337879 | 1337879 | 2021-05-20 | Warren | New York | 36113 | 3602 | 57 |
1328193 | 1328193 | 2021-05-17 | Jackson | North Carolina | 37099 | 3602 | 56 |
1321358 | 1321358 | 2021-05-15 | Webster | Missouri | 29225 | 3602 | 54 |
1313796 | 1313796 | 2021-05-13 | Wayne | Georgia | 13305 | 3602 | 88 |
1314480 | 1314480 | 2021-05-13 | Worcester | Maryland | 24047 | 3602 | 99 |
1314621 | 1314621 | 2021-05-13 | Lyon | Minnesota | 27083 | 3602 | 51 |
1307806 | 1307806 | 2021-05-11 | Greenup | Kentucky | 21089 | 3602 | 59 |
1309161 | 1309161 | 2021-05-11 | Trujillo Alto | Puerto Rico | 72139 | 3602 | |
1305915 | 1305915 | 2021-05-10 | Trujillo Alto | Puerto Rico | 72139 | 3602 | |
1301495 | 1301495 | 2021-05-09 | Worcester | Maryland | 24047 | 3602 | 98 |
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);