ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
126 rows where cases = 4834 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 12
- Wisconsin 12
- Georgia 9
- Louisiana 9
- Tennessee 8
- Virginia 6
- New York 5
- North Carolina 5
- Ohio 5
- South Dakota 5
- Alaska 4
- Arkansas 4
- Colorado 4
- Minnesota 4
- Idaho 3
- Illinois 3
- Indiana 3
- Maryland 3
- Mississippi 3
- Missouri 3
- Pennsylvania 3
- California 2
- Puerto Rico 2
- West Virginia 2
- Alabama 1
- Iowa 1
- Michigan 1
- North Dakota 1
- Oklahoma 1
- Texas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493325 | 2493325 | 2022-05-11 | Elbert | Colorado | 8039 | 4834 | 40 |
2483415 | 2483415 | 2022-05-08 | Cross | Arkansas | 5037 | 4834 | 83 |
2480157 | 2480157 | 2022-05-07 | Cross | Arkansas | 5037 | 4834 | 83 |
2443317 | 2443317 | 2022-04-25 | Fajardo | Puerto Rico | 72053 | 4834 | |
2427893 | 2427893 | 2022-04-20 | Taylor | Wisconsin | 55119 | 4834 | 72 |
2382054 | 2382054 | 2022-04-06 | Colonial Heights city | Virginia | 51570 | 4834 | 96 |
2360349 | 2360349 | 2022-03-31 | Rush | Indiana | 18139 | 4834 | 58 |
2357095 | 2357095 | 2022-03-30 | Rush | Indiana | 18139 | 4834 | 58 |
2324266 | 2324266 | 2022-03-20 | Lamar | Georgia | 13171 | 4834 | 112 |
2324880 | 2324880 | 2022-03-20 | Morgan | Kentucky | 21175 | 4834 | 21 |
2321012 | 2321012 | 2022-03-19 | Lamar | Georgia | 13171 | 4834 | 112 |
2321626 | 2321626 | 2022-03-19 | Morgan | Kentucky | 21175 | 4834 | 21 |
2317758 | 2317758 | 2022-03-18 | Lamar | Georgia | 13171 | 4834 | 112 |
2318372 | 2318372 | 2022-03-18 | Morgan | Kentucky | 21175 | 4834 | 21 |
2315119 | 2315119 | 2022-03-17 | Morgan | Kentucky | 21175 | 4834 | 21 |
2311866 | 2311866 | 2022-03-16 | Morgan | Kentucky | 21175 | 4834 | 21 |
2308613 | 2308613 | 2022-03-15 | Morgan | Kentucky | 21175 | 4834 | 21 |
2310099 | 2310099 | 2022-03-15 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2305362 | 2305362 | 2022-03-14 | Morgan | Kentucky | 21175 | 4834 | 21 |
2306846 | 2306846 | 2022-03-14 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2307192 | 2307192 | 2022-03-14 | Orange | Vermont | 50017 | 4834 | 14 |
2303595 | 2303595 | 2022-03-13 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2300343 | 2300343 | 2022-03-12 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2297091 | 2297091 | 2022-03-11 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2293839 | 2293839 | 2022-03-10 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2290587 | 2290587 | 2022-03-09 | Humphreys | Tennessee | 47085 | 4834 | 69 |
2278335 | 2278335 | 2022-03-06 | Kodiak Island Borough | Alaska | 2150 | 4834 | 11 |
2275082 | 2275082 | 2022-03-05 | Kodiak Island Borough | Alaska | 2150 | 4834 | 11 |
2271829 | 2271829 | 2022-03-04 | Kodiak Island Borough | Alaska | 2150 | 4834 | 11 |
2247096 | 2247096 | 2022-02-24 | Hubbard | Minnesota | 27057 | 4834 | 56 |
2215120 | 2215120 | 2022-02-14 | Schoharie | New York | 36095 | 4834 | 34 |
2203622 | 2203622 | 2022-02-11 | Lincoln | Arkansas | 5079 | 4834 | 60 |
2143095 | 2143095 | 2022-01-23 | Grenada | Mississippi | 28043 | 4834 | 113 |
2139840 | 2139840 | 2022-01-22 | Grenada | Mississippi | 28043 | 4834 | 113 |
2136584 | 2136584 | 2022-01-21 | Grenada | Mississippi | 28043 | 4834 | 113 |
2116847 | 2116847 | 2022-01-15 | Garrett | Maryland | 24023 | 4834 | 102 |
2080010 | 2080010 | 2022-01-04 | Jackson | Arkansas | 5067 | 4834 | 47 |
2076392 | 2076392 | 2022-01-02 | Pulaski | Virginia | 51155 | 4834 | 105 |
2073141 | 2073141 | 2022-01-01 | Pulaski | Virginia | 51155 | 4834 | 105 |
2069890 | 2069890 | 2021-12-31 | Pulaski | Virginia | 51155 | 4834 | 105 |
2028985 | 2028985 | 2021-12-19 | Allen | Louisiana | 22003 | 4834 | 118 |
2025734 | 2025734 | 2021-12-18 | Allen | Louisiana | 22003 | 4834 | 118 |
2022483 | 2022483 | 2021-12-17 | Allen | Louisiana | 22003 | 4834 | 118 |
2019257 | 2019257 | 2021-12-16 | Jefferson Davis | Louisiana | 22053 | 4834 | 131 |
2021224 | 2021224 | 2021-12-16 | Hancock | West Virginia | 54029 | 4834 | 122 |
2006248 | 2006248 | 2021-12-12 | Franklin | Louisiana | 22041 | 4834 | 141 |
2002997 | 2002997 | 2021-12-11 | Franklin | Louisiana | 22041 | 4834 | 141 |
1999747 | 1999747 | 2021-12-10 | Franklin | Louisiana | 22041 | 4834 | 141 |
1995786 | 1995786 | 2021-12-09 | Dawson | Georgia | 13085 | 4834 | 77 |
1971448 | 1971448 | 2021-12-01 | Hardin | Ohio | 39065 | 4834 | 99 |
1966878 | 1966878 | 2021-11-30 | Scott | Indiana | 18143 | 4834 | 82 |
1964904 | 1964904 | 2021-11-29 | Stutsman | North Dakota | 38093 | 4834 | 92 |
1940529 | 1940529 | 2021-11-22 | Decatur | Georgia | 13087 | 4834 | 104 |
1941432 | 1941432 | 2021-11-22 | Cass | Minnesota | 27021 | 4834 | 51 |
1864004 | 1864004 | 2021-10-29 | Washington | New York | 36115 | 4834 | 69 |
1807537 | 1807537 | 2021-10-12 | Montgomery | Illinois | 17135 | 4834 | 85 |
1805514 | 1805514 | 2021-10-11 | Tioga | New York | 36107 | 4834 | 70 |
1801596 | 1801596 | 2021-10-10 | Worcester | Maryland | 24047 | 4834 | 114 |
1767748 | 1767748 | 2021-09-29 | Logan | West Virginia | 54045 | 4834 | 118 |
1762427 | 1762427 | 2021-09-28 | Harlan | Kentucky | 21095 | 4834 | 114 |
1735458 | 1735458 | 2021-09-20 | Bethel Census Area | Alaska | 2050 | 4834 | 23 |
1719329 | 1719329 | 2021-09-15 | Amador | California | 6005 | 4834 | 57 |
1692385 | 1692385 | 2021-09-06 | Codington | South Dakota | 46029 | 4834 | 82 |
1689136 | 1689136 | 2021-09-05 | Codington | South Dakota | 46029 | 4834 | 82 |
1685886 | 1685886 | 2021-09-04 | Codington | South Dakota | 46029 | 4834 | 82 |
1682635 | 1682635 | 2021-09-03 | Codington | South Dakota | 46029 | 4834 | 82 |
1630770 | 1630770 | 2021-08-18 | Marshall | Tennessee | 47117 | 4834 | 65 |
1545326 | 1545326 | 2021-07-23 | Scott | Missouri | 29201 | 4834 | 88 |
1518860 | 1518860 | 2021-07-15 | Shelby | Kentucky | 21211 | 4834 | 78 |
1515613 | 1515613 | 2021-07-14 | Shelby | Kentucky | 21211 | 4834 | 78 |
1495685 | 1495685 | 2021-07-08 | Macoupin | Illinois | 17117 | 4834 | 118 |
1472257 | 1472257 | 2021-06-30 | Polk | Wisconsin | 55095 | 4834 | 63 |
1465767 | 1465767 | 2021-06-28 | Polk | Wisconsin | 55095 | 4834 | 64 |
1462522 | 1462522 | 2021-06-27 | Polk | Wisconsin | 55095 | 4834 | 64 |
1459277 | 1459277 | 2021-06-26 | Polk | Wisconsin | 55095 | 4834 | 64 |
1456032 | 1456032 | 2021-06-25 | Polk | Wisconsin | 55095 | 4834 | 64 |
1452787 | 1452787 | 2021-06-24 | Polk | Wisconsin | 55095 | 4834 | 63 |
1449541 | 1449541 | 2021-06-23 | Polk | Wisconsin | 55095 | 4834 | 63 |
1443051 | 1443051 | 2021-06-21 | Polk | Wisconsin | 55095 | 4834 | 63 |
1439806 | 1439806 | 2021-06-20 | Polk | Wisconsin | 55095 | 4834 | 63 |
1436559 | 1436559 | 2021-06-19 | Polk | Wisconsin | 55095 | 4834 | 63 |
1433312 | 1433312 | 2021-06-18 | Polk | Wisconsin | 55095 | 4834 | 63 |
1424972 | 1424972 | 2021-06-16 | Goodhue | Minnesota | 27049 | 4834 | 74 |
1421724 | 1421724 | 2021-06-15 | Goodhue | Minnesota | 27049 | 4834 | 73 |
1402448 | 1402448 | 2021-06-09 | Johnson | Missouri | 29101 | 4834 | 57 |
1396265 | 1396265 | 2021-06-07 | Clinton | New York | 36019 | 4834 | 33 |
1351084 | 1351084 | 2021-05-24 | Mercer | Ohio | 39107 | 4834 | 85 |
1329739 | 1329739 | 2021-05-18 | Broomfield | Colorado | 8014 | 4834 | 75 |
1320799 | 1320799 | 2021-05-15 | Henderson | Kentucky | 21101 | 4834 | 75 |
1300830 | 1300830 | 2021-05-09 | Bingham | Idaho | 16011 | 4834 | 74 |
1297583 | 1297583 | 2021-05-08 | Bingham | Idaho | 16011 | 4834 | 74 |
1294337 | 1294337 | 2021-05-07 | Bingham | Idaho | 16011 | 4834 | 74 |
1293253 | 1293253 | 2021-05-06 | Harrison | Texas | 48203 | 4834 | 109 |
1258600 | 1258600 | 2021-04-26 | Ware | Georgia | 13299 | 4834 | 173 |
1260355 | 1260355 | 2021-04-26 | Huntingdon | Pennsylvania | 42061 | 4834 | 128 |
1226115 | 1226115 | 2021-04-16 | Tift | Georgia | 13277 | 4834 | 125 |
1216083 | 1216083 | 2021-04-13 | Tehama | California | 6103 | 4834 | 52 |
1211753 | 1211753 | 2021-04-11 | Unknown | Puerto Rico | 4834 | 2154 | |
1198277 | 1198277 | 2021-04-07 | Carteret | North Carolina | 37031 | 4834 | 45 |
1185228 | 1185228 | 2021-04-03 | Genesee | New York | 36037 | 4834 | 121 |
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);