ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where cases = 3840 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 19
- Texas 11
- Iowa 7
- Minnesota 7
- Missouri 7
- Alabama 5
- Mississippi 5
- North Carolina 5
- Georgia 4
- Illinois 4
- Indiana 4
- California 3
- Nebraska 3
- Pennsylvania 3
- Arkansas 2
- Kansas 2
- Maine 2
- New York 2
- Ohio 2
- Colorado 1
- Kentucky 1
- Louisiana 1
- Michigan 1
- New Jersey 1
- New Mexico 1
- Puerto Rico 1
- South Carolina 1
- Virginia 1
- Washington 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475129 | 2475129 | 2022-05-05 | Wright | Missouri | 29229 | 3840 | 84 |
2348545 | 2348545 | 2022-03-27 | Polk | North Carolina | 37149 | 3840 | 54 |
2345292 | 2345292 | 2022-03-26 | Polk | North Carolina | 37149 | 3840 | 54 |
2342039 | 2342039 | 2022-03-25 | Polk | North Carolina | 37149 | 3840 | 54 |
2310820 | 2310820 | 2022-03-16 | Macon | Alabama | 1087 | 3840 | 81 |
2307567 | 2307567 | 2022-03-15 | Macon | Alabama | 1087 | 3840 | 81 |
2308406 | 2308406 | 2022-03-15 | Tama | Iowa | 19171 | 3840 | 88 |
2304316 | 2304316 | 2022-03-14 | Macon | Alabama | 1087 | 3840 | 81 |
2305155 | 2305155 | 2022-03-14 | Tama | Iowa | 19171 | 3840 | 88 |
2301903 | 2301903 | 2022-03-13 | Tama | Iowa | 19171 | 3840 | 88 |
2298651 | 2298651 | 2022-03-12 | Tama | Iowa | 19171 | 3840 | 88 |
2295399 | 2295399 | 2022-03-11 | Tama | Iowa | 19171 | 3840 | 88 |
2292147 | 2292147 | 2022-03-10 | Tama | Iowa | 19171 | 3840 | 88 |
2288056 | 2288056 | 2022-03-09 | Macon | Alabama | 1087 | 3840 | 78 |
2288895 | 2288895 | 2022-03-09 | Tama | Iowa | 19171 | 3840 | 88 |
2284804 | 2284804 | 2022-03-08 | Macon | Alabama | 1087 | 3840 | 78 |
2264770 | 2264770 | 2022-03-01 | Llano | Texas | 48299 | 3840 | 94 |
2261520 | 2261520 | 2022-02-28 | Llano | Texas | 48299 | 3840 | 94 |
2258269 | 2258269 | 2022-02-27 | Llano | Texas | 48299 | 3840 | 93 |
2219042 | 2219042 | 2022-02-15 | Grundy | Tennessee | 47061 | 3840 | 67 |
2215791 | 2215791 | 2022-02-14 | Grundy | Tennessee | 47061 | 3840 | 67 |
2212540 | 2212540 | 2022-02-13 | Grundy | Tennessee | 47061 | 3840 | 67 |
2209287 | 2209287 | 2022-02-12 | Grundy | Tennessee | 47061 | 3840 | 67 |
2206034 | 2206034 | 2022-02-11 | Grundy | Tennessee | 47061 | 3840 | 67 |
2201417 | 2201417 | 2022-02-10 | Sagadahoc | Maine | 23023 | 3840 | 25 |
2202781 | 2202781 | 2022-02-10 | Grundy | Tennessee | 47061 | 3840 | 67 |
2199527 | 2199527 | 2022-02-09 | Grundy | Tennessee | 47061 | 3840 | 67 |
2193697 | 2193697 | 2022-02-07 | Lincoln | Wyoming | 56023 | 3840 | 28 |
2177076 | 2177076 | 2022-02-02 | Zavala | Texas | 48507 | 3840 | 59 |
2141850 | 2141850 | 2022-01-23 | Colusa | California | 6011 | 3840 | 21 |
2142357 | 2142357 | 2022-01-23 | White | Illinois | 17193 | 3840 | 45 |
2138595 | 2138595 | 2022-01-22 | Colusa | California | 6011 | 3840 | 21 |
2139102 | 2139102 | 2022-01-22 | White | Illinois | 17193 | 3840 | 45 |
2135339 | 2135339 | 2022-01-21 | Colusa | California | 6011 | 3840 | 21 |
2135846 | 2135846 | 2022-01-21 | White | Illinois | 17193 | 3840 | 45 |
2124822 | 2124822 | 2022-01-17 | Deaf Smith | Texas | 48117 | 3840 | 102 |
2104073 | 2104073 | 2022-01-11 | Jasper | Mississippi | 28061 | 3840 | 66 |
2075662 | 2075662 | 2022-01-02 | Juniata | Pennsylvania | 42067 | 3840 | 148 |
2019111 | 2019111 | 2021-12-16 | Adair | Kentucky | 21001 | 3840 | 88 |
2016206 | 2016206 | 2021-12-15 | Dodge | Minnesota | 27039 | 3840 | 13 |
2011149 | 2011149 | 2021-12-13 | Milam | Texas | 48331 | 3840 | 91 |
1946883 | 1946883 | 2021-11-24 | Montezuma | Colorado | 8083 | 3840 | 47 |
1929668 | 1929668 | 2021-11-18 | Johnson | Tennessee | 47091 | 3840 | 52 |
1917466 | 1917466 | 2021-11-15 | Cleburne | Arkansas | 5023 | 3840 | 94 |
1914216 | 1914216 | 2021-11-14 | Cleburne | Arkansas | 5023 | 3840 | 94 |
1895970 | 1895970 | 2021-11-08 | Meeker | Minnesota | 27093 | 3840 | 55 |
1835185 | 1835185 | 2021-10-20 | Warren | Pennsylvania | 42123 | 3840 | 120 |
1826259 | 1826259 | 2021-10-17 | Upshur | West Virginia | 54097 | 3840 | 58 |
1767008 | 1767008 | 2021-09-29 | Mayaguez | Puerto Rico | 72097 | 3840 | |
1756266 | 1756266 | 2021-09-26 | Pine | Minnesota | 27115 | 3840 | 26 |
1753018 | 1753018 | 2021-09-25 | Pine | Minnesota | 27115 | 3840 | 26 |
1749770 | 1749770 | 2021-09-24 | Pine | Minnesota | 27115 | 3840 | 26 |
1740016 | 1740016 | 2021-09-21 | Nicollet | Minnesota | 27103 | 3840 | 47 |
1736182 | 1736182 | 2021-09-20 | Wells | Indiana | 18179 | 3840 | 85 |
1713285 | 1713285 | 2021-09-13 | Iroquois | Illinois | 17075 | 3840 | 72 |
1651414 | 1651414 | 2021-08-25 | Madison | Georgia | 13195 | 3840 | 57 |
1649828 | 1649828 | 2021-08-24 | Williams | Ohio | 39171 | 3840 | 79 |
1632847 | 1632847 | 2021-08-19 | Adams | Mississippi | 28001 | 3840 | 94 |
1633714 | 1633714 | 2021-08-19 | Clinton | Pennsylvania | 42035 | 3840 | 68 |
1624854 | 1624854 | 2021-08-16 | Clark | Wisconsin | 55019 | 3840 | 66 |
1619996 | 1619996 | 2021-08-15 | Lafayette | Missouri | 29107 | 3840 | 59 |
1592061 | 1592061 | 2021-08-06 | Upshur | Texas | 48459 | 3840 | 78 |
1583235 | 1583235 | 2021-08-04 | Toombs | Georgia | 13279 | 3840 | 121 |
1578831 | 1578831 | 2021-08-02 | White | Tennessee | 47185 | 3840 | 75 |
1536708 | 1536708 | 2021-07-20 | Grimes | Texas | 48185 | 3840 | 74 |
1515252 | 1515252 | 2021-07-14 | Knox | Indiana | 18083 | 3840 | 91 |
1496582 | 1496582 | 2021-07-08 | Lawrence | Missouri | 29109 | 3840 | 89 |
1470639 | 1470639 | 2021-06-30 | Polk | Missouri | 29167 | 3840 | 42 |
1461217 | 1461217 | 2021-06-27 | Tioga | New York | 36107 | 3840 | 63 |
1457972 | 1457972 | 2021-06-26 | Tioga | New York | 36107 | 3840 | 63 |
1403466 | 1403466 | 2021-06-09 | Henderson | Tennessee | 47077 | 3840 | 78 |
1400221 | 1400221 | 2021-06-08 | Henderson | Tennessee | 47077 | 3840 | 78 |
1396976 | 1396976 | 2021-06-07 | Henderson | Tennessee | 47077 | 3840 | 77 |
1393729 | 1393729 | 2021-06-06 | Henderson | Tennessee | 47077 | 3840 | 77 |
1390484 | 1390484 | 2021-06-05 | Henderson | Tennessee | 47077 | 3840 | 77 |
1387239 | 1387239 | 2021-06-04 | Henderson | Tennessee | 47077 | 3840 | 77 |
1383994 | 1383994 | 2021-06-03 | Henderson | Tennessee | 47077 | 3840 | 77 |
1380748 | 1380748 | 2021-06-02 | Henderson | Tennessee | 47077 | 3840 | 77 |
1324718 | 1324718 | 2021-05-16 | Lincoln | Nebraska | 31111 | 3840 | 59 |
1321472 | 1321472 | 2021-05-15 | Lincoln | Nebraska | 31111 | 3840 | 59 |
1318226 | 1318226 | 2021-05-14 | Lincoln | Nebraska | 31111 | 3840 | 59 |
1272312 | 1272312 | 2021-04-30 | Delta | Michigan | 26041 | 3840 | 88 |
1254348 | 1254348 | 2021-04-24 | Matagorda | Texas | 48321 | 3840 | 103 |
1214587 | 1214587 | 2021-04-12 | Stokes | North Carolina | 37169 | 3840 | 79 |
1214666 | 1214666 | 2021-04-12 | Brown | Ohio | 39015 | 3840 | 55 |
1168586 | 1168586 | 2021-03-29 | Lincoln | Mississippi | 28085 | 3840 | 106 |
1165338 | 1165338 | 2021-03-28 | Lincoln | Mississippi | 28085 | 3840 | 106 |
1084309 | 1084309 | 2021-03-03 | Scott | Missouri | 29201 | 3840 | 77 |
1061193 | 1061193 | 2021-02-24 | Penobscot | Maine | 23019 | 3840 | 82 |
1056042 | 1056042 | 2021-02-22 | Cheatham | Tennessee | 47021 | 3840 | 43 |
1051414 | 1051414 | 2021-02-21 | Natchitoches | Louisiana | 22069 | 3840 | 77 |
1048559 | 1048559 | 2021-02-20 | Johnson | Missouri | 29101 | 3840 | 43 |
999677 | 999677 | 2021-02-05 | Douglas | Minnesota | 27041 | 3840 | 67 |
993300 | 993300 | 2021-02-03 | Monroe | Mississippi | 28095 | 3840 | 118 |
973311 | 973311 | 2021-01-28 | Lyon | Kansas | 20111 | 3840 | 68 |
970066 | 970066 | 2021-01-27 | Lyon | Kansas | 20111 | 3840 | 68 |
889493 | 889493 | 2021-01-02 | Callaway | Missouri | 29027 | 3840 | 20 |
838609 | 838609 | 2020-12-17 | Dyer | Tennessee | 47045 | 3840 | 63 |
819673 | 819673 | 2020-12-11 | Thurston | Washington | 53067 | 3840 | 50 |
805447 | 805447 | 2020-12-07 | Valencia | New Mexico | 35061 | 3840 | 34 |
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);