ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where cases = 4403 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 13
- Illinois 11
- Tennessee 9
- Florida 7
- Ohio 7
- Mississippi 6
- California 5
- North Carolina 5
- Kentucky 4
- Louisiana 4
- Minnesota 4
- South Carolina 4
- Alabama 3
- Indiana 3
- Missouri 3
- North Dakota 3
- Texas 3
- Arkansas 2
- Colorado 2
- New York 2
- Pennsylvania 2
- Virginia 2
- Arizona 1
- Georgia 1
- Nevada 1
- New Jersey 1
- Oregon 1
- Vermont 1
- Washington 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444907 | 2444907 | 2022-04-26 | White | Illinois | 17193 | 4403 | 59 |
2428627 | 2428627 | 2022-04-21 | White | Illinois | 17193 | 4403 | 59 |
2425371 | 2425371 | 2022-04-20 | White | Illinois | 17193 | 4403 | 59 |
2422115 | 2422115 | 2022-04-19 | White | Illinois | 17193 | 4403 | 59 |
2418859 | 2418859 | 2022-04-18 | White | Illinois | 17193 | 4403 | 59 |
2415603 | 2415603 | 2022-04-17 | White | Illinois | 17193 | 4403 | 59 |
2412347 | 2412347 | 2022-04-16 | White | Illinois | 17193 | 4403 | 59 |
2409091 | 2409091 | 2022-04-15 | White | Illinois | 17193 | 4403 | 59 |
2402580 | 2402580 | 2022-04-13 | White | Illinois | 17193 | 4403 | 59 |
2223016 | 2223016 | 2022-02-17 | Henry | Alabama | 1067 | 4403 | 69 |
2177648 | 2177648 | 2022-02-03 | Inyo | California | 6027 | 4403 | 51 |
2178706 | 2178706 | 2022-02-03 | Cheboygan | Michigan | 26031 | 4403 | 89 |
2175454 | 2175454 | 2022-02-02 | Cheboygan | Michigan | 26031 | 4403 | 89 |
2172948 | 2172948 | 2022-02-01 | Yancey | North Carolina | 37199 | 4403 | 45 |
2125582 | 2125582 | 2022-01-18 | Del Norte | California | 6015 | 4403 | 43 |
2114427 | 2114427 | 2022-01-14 | Rolette | North Dakota | 38079 | 4403 | 36 |
2061964 | 2061964 | 2021-12-29 | Stone | Missouri | 29209 | 4403 | 100 |
2063102 | 2063102 | 2021-12-29 | Hutchinson | Texas | 48233 | 4403 | 108 |
2008031 | 2008031 | 2021-12-12 | Windsor | Vermont | 50027 | 4403 | 35 |
1987699 | 1987699 | 2021-12-06 | Henry | Ohio | 39069 | 4403 | 80 |
1973766 | 1973766 | 2021-12-02 | Richland | Louisiana | 22083 | 4403 | 80 |
1959718 | 1959718 | 2021-11-28 | Carroll | Arkansas | 5015 | 4403 | 75 |
1898520 | 1898520 | 2021-11-09 | Perry | Illinois | 17145 | 4403 | 85 |
1899029 | 1899029 | 2021-11-09 | West Baton Rouge | Louisiana | 22121 | 4403 | 77 |
1896691 | 1896691 | 2021-11-08 | Hardin | Ohio | 39065 | 4403 | 91 |
1875782 | 1875782 | 2021-11-02 | Saline | Illinois | 17165 | 4403 | 86 |
1826804 | 1826804 | 2021-10-18 | Emanuel | Georgia | 13107 | 4403 | 120 |
1827858 | 1827858 | 2021-10-18 | Yazoo | Mississippi | 28163 | 4403 | 86 |
1805096 | 1805096 | 2021-10-11 | Simpson | Mississippi | 28127 | 4403 | 116 |
1805466 | 1805466 | 2021-10-11 | Allegany | New York | 36003 | 4403 | 94 |
1785168 | 1785168 | 2021-10-05 | Grayson | Kentucky | 21085 | 4403 | 76 |
1782643 | 1782643 | 2021-10-04 | Douglas | Nevada | 32005 | 4403 | 50 |
1760698 | 1760698 | 2021-09-27 | Hickman | Tennessee | 47081 | 4403 | 65 |
1745525 | 1745525 | 2021-09-23 | Washington | Florida | 12133 | 4403 | 59 |
1746551 | 1746551 | 2021-09-23 | Adams | Mississippi | 28001 | 4403 | 116 |
1742276 | 1742276 | 2021-09-22 | Washington | Florida | 12133 | 4403 | 59 |
1739027 | 1739027 | 2021-09-21 | Washington | Florida | 12133 | 4403 | 59 |
1740612 | 1740612 | 2021-09-21 | Pasquotank | North Carolina | 37139 | 4403 | 93 |
1735778 | 1735778 | 2021-09-20 | Washington | Florida | 12133 | 4403 | 59 |
1732528 | 1732528 | 2021-09-19 | Washington | Florida | 12133 | 4403 | 59 |
1729278 | 1729278 | 2021-09-18 | Washington | Florida | 12133 | 4403 | 59 |
1726028 | 1726028 | 2021-09-17 | Washington | Florida | 12133 | 4403 | 58 |
1713769 | 1713769 | 2021-09-13 | Allen | Louisiana | 22003 | 4403 | 102 |
1691225 | 1691225 | 2021-09-06 | Sanilac | Michigan | 26151 | 4403 | 127 |
1687975 | 1687975 | 2021-09-05 | Sanilac | Michigan | 26151 | 4403 | 127 |
1684725 | 1684725 | 2021-09-04 | Sanilac | Michigan | 26151 | 4403 | 127 |
1681474 | 1681474 | 2021-09-03 | Sanilac | Michigan | 26151 | 4403 | 127 |
1679358 | 1679358 | 2021-09-02 | Marion | South Carolina | 45067 | 4403 | 114 |
1666026 | 1666026 | 2021-08-29 | Logan | Ohio | 39091 | 4403 | 79 |
1580895 | 1580895 | 2021-08-03 | Hancock | Mississippi | 28045 | 4403 | 88 |
1579342 | 1579342 | 2021-08-02 | Ohio | West Virginia | 54069 | 4403 | 87 |
1533328 | 1533328 | 2021-07-19 | Marshall | Tennessee | 47117 | 4403 | 63 |
1486560 | 1486560 | 2021-07-05 | Hillsdale | Michigan | 26059 | 4403 | 93 |
1483314 | 1483314 | 2021-07-04 | Hillsdale | Michigan | 26059 | 4403 | 93 |
1480068 | 1480068 | 2021-07-03 | Hillsdale | Michigan | 26059 | 4403 | 93 |
1476821 | 1476821 | 2021-07-02 | Hillsdale | Michigan | 26059 | 4403 | 93 |
1471635 | 1471635 | 2021-06-30 | Lincoln | Tennessee | 47103 | 4403 | 67 |
1468390 | 1468390 | 2021-06-29 | Lincoln | Tennessee | 47103 | 4403 | 67 |
1452165 | 1452165 | 2021-06-24 | Lincoln | Tennessee | 47103 | 4403 | 67 |
1447697 | 1447697 | 2021-06-23 | Isanti | Minnesota | 27059 | 4403 | 64 |
1444452 | 1444452 | 2021-06-22 | Isanti | Minnesota | 27059 | 4403 | 64 |
1414598 | 1414598 | 2021-06-13 | Clinton | Indiana | 18023 | 4403 | 60 |
1411353 | 1411353 | 2021-06-12 | Clinton | Indiana | 18023 | 4403 | 60 |
1398928 | 1398928 | 2021-06-08 | Hillsdale | Michigan | 26059 | 4403 | 92 |
1383860 | 1383860 | 2021-06-03 | Dillon | South Carolina | 45033 | 4403 | 85 |
1380614 | 1380614 | 2021-06-02 | Dillon | South Carolina | 45033 | 4403 | 85 |
1362112 | 1362112 | 2021-05-28 | Miller | Arkansas | 5091 | 4403 | 38 |
1356643 | 1356643 | 2021-05-26 | Washington | Louisiana | 22117 | 4403 | 132 |
1339238 | 1339238 | 2021-05-21 | Chilton | Alabama | 1021 | 4403 | 114 |
1334222 | 1334222 | 2021-05-19 | Warren | Mississippi | 28149 | 4403 | 121 |
1334681 | 1334681 | 2021-05-19 | Haywood | North Carolina | 37087 | 4403 | 96 |
1268856 | 1268856 | 2021-04-29 | Hopkins | Kentucky | 21107 | 4403 | 146 |
1244582 | 1244582 | 2021-04-21 | Kerr | Texas | 48265 | 4403 | 86 |
1212148 | 1212148 | 2021-04-11 | Nacogdoches | Texas | 48347 | 4403 | 165 |
1187987 | 1187987 | 2021-04-04 | Mower | Minnesota | 27099 | 4403 | 32 |
1184740 | 1184740 | 2021-04-03 | Mower | Minnesota | 27099 | 4403 | 32 |
1143060 | 1143060 | 2021-03-21 | Beaufort | North Carolina | 37013 | 4403 | 87 |
1143742 | 1143742 | 2021-03-21 | Obion | Tennessee | 47131 | 4403 | 95 |
1139813 | 1139813 | 2021-03-20 | Beaufort | North Carolina | 37013 | 4403 | 87 |
1140495 | 1140495 | 2021-03-20 | Obion | Tennessee | 47131 | 4403 | 95 |
1140953 | 1140953 | 2021-03-20 | Washington | Virginia | 51191 | 4403 | 100 |
1137249 | 1137249 | 2021-03-19 | Obion | Tennessee | 47131 | 4403 | 95 |
1129214 | 1129214 | 2021-03-17 | Henderson | Kentucky | 21101 | 4403 | 62 |
1108637 | 1108637 | 2021-03-10 | Pierce | Wisconsin | 55093 | 4403 | 39 |
1103462 | 1103462 | 2021-03-09 | Grand Traverse | Michigan | 26055 | 4403 | 71 |
1100216 | 1100216 | 2021-03-08 | Grand Traverse | Michigan | 26055 | 4403 | 71 |
1078673 | 1078673 | 2021-03-01 | Newberry | South Carolina | 45071 | 4403 | 92 |
1067954 | 1067954 | 2021-02-26 | Oktibbeha | Mississippi | 28105 | 4403 | 91 |
1068621 | 1068621 | 2021-02-26 | Shelby | Ohio | 39149 | 4403 | 68 |
1066327 | 1066327 | 2021-02-25 | Skagit | Washington | 53057 | 4403 | 61 |
1036088 | 1036088 | 2021-02-16 | Williams | North Dakota | 38105 | 4403 | 36 |
1026357 | 1026357 | 2021-02-13 | Athens | Ohio | 39009 | 4403 | 30 |
1011551 | 1011551 | 2021-02-09 | Tehama | California | 6103 | 4403 | 47 |
996891 | 996891 | 2021-02-04 | Salem | New Jersey | 34033 | 4403 | 150 |
987620 | 987620 | 2021-02-01 | Carbon | Pennsylvania | 42025 | 4403 | 124 |
983990 | 983990 | 2021-01-31 | St. Lawrence | New York | 36089 | 4403 | 67 |
984165 | 984165 | 2021-01-31 | Belmont | Ohio | 39013 | 4403 | 48 |
980457 | 980457 | 2021-01-30 | Taney | Missouri | 29213 | 4403 | 68 |
927196 | 927196 | 2021-01-14 | Garfield | Colorado | 8045 | 4403 | 35 |
914168 | 914168 | 2021-01-10 | San Benito | California | 6069 | 4403 | 36 |
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);