ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where cases = 4207 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 12
- Mississippi 12
- Virginia 11
- Illinois 10
- Indiana 10
- Tennessee 10
- Missouri 6
- Ohio 6
- Texas 6
- California 5
- Iowa 5
- Wisconsin 5
- Alabama 3
- Idaho 3
- Minnesota 3
- New York 3
- Pennsylvania 3
- Puerto Rico 3
- South Dakota 3
- Louisiana 2
- Oregon 2
- South Carolina 2
- Utah 2
- West Virginia 2
- Alaska 1
- Florida 1
- Georgia 1
- Michigan 1
- Nebraska 1
- New Hampshire 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417927 | 2417927 | 2022-04-17 | Nottoway | Virginia | 51135 | 4207 | 89 |
2414671 | 2414671 | 2022-04-16 | Nottoway | Virginia | 51135 | 4207 | 89 |
2411415 | 2411415 | 2022-04-15 | Nottoway | Virginia | 51135 | 4207 | 89 |
2380503 | 2380503 | 2022-04-06 | Wadena | Minnesota | 27159 | 4207 | 54 |
2359093 | 2359093 | 2022-03-30 | Lavaca | Texas | 48285 | 4207 | 118 |
2345724 | 2345724 | 2022-03-26 | Yauco | Puerto Rico | 72153 | 4207 | |
2329950 | 2329950 | 2022-03-21 | Unknown | Utah | 4207 | 79 | |
2302077 | 2302077 | 2022-03-13 | Jackson | Kentucky | 21109 | 4207 | 71 |
2302448 | 2302448 | 2022-03-13 | Clarke | Mississippi | 28023 | 4207 | 106 |
2304189 | 2304189 | 2022-03-13 | Crawford | Wisconsin | 55023 | 4207 | 28 |
2298825 | 2298825 | 2022-03-12 | Jackson | Kentucky | 21109 | 4207 | 71 |
2299196 | 2299196 | 2022-03-12 | Clarke | Mississippi | 28023 | 4207 | 106 |
2300937 | 2300937 | 2022-03-12 | Crawford | Wisconsin | 55023 | 4207 | 28 |
2295573 | 2295573 | 2022-03-11 | Jackson | Kentucky | 21109 | 4207 | 71 |
2295944 | 2295944 | 2022-03-11 | Clarke | Mississippi | 28023 | 4207 | 106 |
2297685 | 2297685 | 2022-03-11 | Crawford | Wisconsin | 55023 | 4207 | 28 |
2292321 | 2292321 | 2022-03-10 | Jackson | Kentucky | 21109 | 4207 | 71 |
2292692 | 2292692 | 2022-03-10 | Clarke | Mississippi | 28023 | 4207 | 106 |
2294171 | 2294171 | 2022-03-10 | Unknown | Utah | 4207 | 81 | |
2294433 | 2294433 | 2022-03-10 | Crawford | Wisconsin | 55023 | 4207 | 28 |
2289069 | 2289069 | 2022-03-09 | Jackson | Kentucky | 21109 | 4207 | 71 |
2289440 | 2289440 | 2022-03-09 | Clarke | Mississippi | 28023 | 4207 | 106 |
2285818 | 2285818 | 2022-03-08 | Jackson | Kentucky | 21109 | 4207 | 71 |
2286189 | 2286189 | 2022-03-08 | Clarke | Mississippi | 28023 | 4207 | 106 |
2286520 | 2286520 | 2022-03-08 | Unknown | Nebraska | 4207 | 477 | |
2282566 | 2282566 | 2022-03-07 | Jackson | Kentucky | 21109 | 4207 | 71 |
2260325 | 2260325 | 2022-02-28 | Pike | Missouri | 29163 | 4207 | 57 |
2254653 | 2254653 | 2022-02-26 | Yabucoa | Puerto Rico | 72151 | 4207 | |
2251402 | 2251402 | 2022-02-25 | Yabucoa | Puerto Rico | 72151 | 4207 | |
2233850 | 2233850 | 2022-02-20 | Union | Kentucky | 21225 | 4207 | 54 |
2230599 | 2230599 | 2022-02-19 | Union | Kentucky | 21225 | 4207 | 54 |
2227348 | 2227348 | 2022-02-18 | Union | Kentucky | 21225 | 4207 | 54 |
2199462 | 2199462 | 2022-02-09 | Hughes | South Dakota | 46065 | 4207 | 57 |
2143229 | 2143229 | 2022-01-23 | New Madrid | Missouri | 29143 | 4207 | 71 |
2130942 | 2130942 | 2022-01-19 | Juniata | Pennsylvania | 42067 | 4207 | 156 |
2103406 | 2103406 | 2022-01-11 | Starke | Indiana | 18149 | 4207 | 88 |
2087538 | 2087538 | 2022-01-06 | St. James | Louisiana | 22093 | 4207 | 71 |
2075938 | 2075938 | 2022-01-02 | Johnson | Tennessee | 47091 | 4207 | 63 |
2072687 | 2072687 | 2022-01-01 | Johnson | Tennessee | 47091 | 4207 | 63 |
2069436 | 2069436 | 2021-12-31 | Johnson | Tennessee | 47091 | 4207 | 63 |
2066185 | 2066185 | 2021-12-30 | Johnson | Tennessee | 47091 | 4207 | 63 |
2062778 | 2062778 | 2021-12-29 | Abbeville | South Carolina | 45001 | 4207 | 54 |
2017480 | 2017480 | 2021-12-15 | Wayne | Tennessee | 47181 | 4207 | 42 |
1997454 | 1997454 | 2021-12-09 | Hocking | Ohio | 39073 | 4207 | 93 |
1989515 | 1989515 | 2021-12-07 | McDonough | Illinois | 17109 | 4207 | 79 |
1944910 | 1944910 | 2021-11-23 | Miller | Missouri | 29131 | 4207 | 98 |
1946463 | 1946463 | 2021-11-23 | Jackson | West Virginia | 54035 | 4207 | 90 |
1915523 | 1915523 | 2021-11-14 | Coahoma | Mississippi | 28027 | 4207 | 109 |
1912273 | 1912273 | 2021-11-13 | Coahoma | Mississippi | 28027 | 4207 | 109 |
1909023 | 1909023 | 2021-11-12 | Coahoma | Mississippi | 28027 | 4207 | 109 |
1891929 | 1891929 | 2021-11-07 | Jefferson | Idaho | 16051 | 4207 | 45 |
1888679 | 1888679 | 2021-11-06 | Jefferson | Idaho | 16051 | 4207 | 45 |
1877387 | 1877387 | 2021-11-02 | Elk | Pennsylvania | 42047 | 4207 | 59 |
1861402 | 1861402 | 2021-10-28 | DeKalb | Tennessee | 47041 | 4207 | 72 |
1854444 | 1854444 | 2021-10-26 | Gallia | Ohio | 39053 | 4207 | 68 |
1851201 | 1851201 | 2021-10-25 | Hardin | Ohio | 39065 | 4207 | 80 |
1836692 | 1836692 | 2021-10-21 | Jerome | Idaho | 16053 | 4207 | 48 |
1835593 | 1835593 | 2021-10-20 | Hockley | Texas | 48219 | 4207 | 130 |
1830325 | 1830325 | 2021-10-19 | Clay | Indiana | 18021 | 4207 | 61 |
1830948 | 1830948 | 2021-10-19 | Cass | Minnesota | 27021 | 4207 | 42 |
1821948 | 1821948 | 2021-10-16 | Fayette | Ohio | 39047 | 4207 | 60 |
1788000 | 1788000 | 2021-10-06 | Fayette | Illinois | 17051 | 4207 | 62 |
1787113 | 1787113 | 2021-10-05 | Isle of Wight | Virginia | 51093 | 4207 | 82 |
1774254 | 1774254 | 2021-10-01 | Mingo | West Virginia | 54059 | 4207 | 65 |
1768559 | 1768559 | 2021-09-30 | Saline | Illinois | 17165 | 4207 | 84 |
1700680 | 1700680 | 2021-09-09 | Clark | Kentucky | 21049 | 4207 | 32 |
1677614 | 1677614 | 2021-09-02 | Adams | Indiana | 18001 | 4207 | 64 |
1672314 | 1672314 | 2021-08-31 | Warren | New York | 36113 | 4207 | 72 |
1640039 | 1640039 | 2021-08-21 | Logan | Ohio | 39091 | 4207 | 79 |
1625709 | 1625709 | 2021-08-17 | Putnam | Indiana | 18133 | 4207 | 64 |
1602981 | 1602981 | 2021-08-10 | Steuben | Indiana | 18151 | 4207 | 64 |
1578537 | 1578537 | 2021-08-02 | Wayne | Pennsylvania | 42127 | 4207 | 84 |
1555477 | 1555477 | 2021-07-26 | Yadkin | North Carolina | 37197 | 4207 | 55 |
1542724 | 1542724 | 2021-07-22 | Douglas | Oregon | 41019 | 4207 | 87 |
1515662 | 1515662 | 2021-07-14 | Natchitoches | Louisiana | 22069 | 4207 | 95 |
1511323 | 1511323 | 2021-07-13 | Tallapoosa | Alabama | 1123 | 4207 | 156 |
1512722 | 1512722 | 2021-07-13 | Monroe | Mississippi | 28095 | 4207 | 137 |
1512747 | 1512747 | 2021-07-13 | Union | Mississippi | 28145 | 4207 | 79 |
1512839 | 1512839 | 2021-07-13 | Phelps | Missouri | 29161 | 4207 | 136 |
1508076 | 1508076 | 2021-07-12 | Tallapoosa | Alabama | 1123 | 4207 | 156 |
1497563 | 1497563 | 2021-07-08 | Campbell | Tennessee | 47013 | 4207 | 62 |
1492820 | 1492820 | 2021-07-07 | Franklin | Kentucky | 21073 | 4207 | 56 |
1468671 | 1468671 | 2021-06-29 | Waller | Texas | 48473 | 4207 | 51 |
1465426 | 1465426 | 2021-06-28 | Waller | Texas | 48473 | 4207 | 51 |
1436846 | 1436846 | 2021-06-20 | Tuolumne | California | 6109 | 4207 | 71 |
1433599 | 1433599 | 2021-06-19 | Tuolumne | California | 6109 | 4207 | 71 |
1430353 | 1430353 | 2021-06-18 | Tuolumne | California | 6109 | 4207 | 71 |
1427108 | 1427108 | 2021-06-17 | Tuolumne | California | 6109 | 4207 | 71 |
1337488 | 1337488 | 2021-05-20 | Butler | Missouri | 29023 | 4207 | 48 |
1338840 | 1338840 | 2021-05-20 | Waller | Texas | 48473 | 4207 | 49 |
1335317 | 1335317 | 2021-05-19 | Marshall | Tennessee | 47117 | 4207 | 58 |
1330802 | 1330802 | 2021-05-18 | Sanilac | Michigan | 26151 | 4207 | 112 |
1328823 | 1328823 | 2021-05-17 | Marshall | Tennessee | 47117 | 4207 | 58 |
1314725 | 1314725 | 2021-05-13 | Pontotoc | Mississippi | 28115 | 4207 | 72 |
1312473 | 1312473 | 2021-05-12 | Brookings | South Dakota | 46011 | 4207 | 37 |
1305980 | 1305980 | 2021-05-10 | Brookings | South Dakota | 46011 | 4207 | 37 |
1268520 | 1268520 | 2021-04-29 | DeKalb | Indiana | 18033 | 4207 | 87 |
1239294 | 1239294 | 2021-04-20 | Clinton | Indiana | 18023 | 4207 | 58 |
1225618 | 1225618 | 2021-04-16 | Franklin | Alabama | 1059 | 4207 | 82 |
1225923 | 1225923 | 2021-04-16 | DeSoto | Florida | 12027 | 4207 | 89 |
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);