ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
128 rows where cases = 4458 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 10
- Arkansas 8
- Florida 8
- Indiana 8
- Michigan 8
- Ohio 8
- Georgia 7
- Kentucky 7
- Virginia 7
- Alabama 6
- Louisiana 6
- California 5
- Illinois 5
- New York 3
- North Carolina 3
- Tennessee 3
- Wisconsin 3
- Colorado 2
- Minnesota 2
- Missouri 2
- North Dakota 2
- Texas 2
- Utah 2
- West Virginia 2
- Idaho 1
- Maryland 1
- New Jersey 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2379231 | 2379231 | 2022-04-06 | Grant | Arkansas | 5053 | 4458 | 61 |
2377134 | 2377134 | 2022-04-05 | Manistee | Michigan | 26101 | 4458 | 89 |
2373882 | 2373882 | 2022-04-04 | Manistee | Michigan | 26101 | 4458 | 89 |
2370629 | 2370629 | 2022-04-03 | Manistee | Michigan | 26101 | 4458 | 89 |
2367376 | 2367376 | 2022-04-02 | Manistee | Michigan | 26101 | 4458 | 89 |
2364123 | 2364123 | 2022-04-01 | Manistee | Michigan | 26101 | 4458 | 89 |
2350461 | 2350461 | 2022-03-28 | Johnson | Illinois | 17087 | 4458 | 46 |
2347208 | 2347208 | 2022-03-27 | Johnson | Illinois | 17087 | 4458 | 46 |
2343955 | 2343955 | 2022-03-26 | Johnson | Illinois | 17087 | 4458 | 46 |
2340702 | 2340702 | 2022-03-25 | Johnson | Illinois | 17087 | 4458 | 46 |
2328439 | 2328439 | 2022-03-21 | Roseau | Minnesota | 27135 | 4458 | 44 |
2308013 | 2308013 | 2022-03-15 | Meriwether | Georgia | 13199 | 4458 | 140 |
2304762 | 2304762 | 2022-03-14 | Meriwether | Georgia | 13199 | 4458 | 140 |
2301528 | 2301528 | 2022-03-13 | Putnam | Georgia | 13237 | 4458 | 101 |
2298276 | 2298276 | 2022-03-12 | Putnam | Georgia | 13237 | 4458 | 101 |
2295024 | 2295024 | 2022-03-11 | Putnam | Georgia | 13237 | 4458 | 101 |
2264379 | 2264379 | 2022-03-01 | Morovis | Puerto Rico | 72101 | 4458 | |
2245879 | 2245879 | 2022-02-24 | Hempstead | Arkansas | 5057 | 4458 | 55 |
2216681 | 2216681 | 2022-02-15 | Inyo | California | 6027 | 4458 | 52 |
2203233 | 2203233 | 2022-02-10 | New Kent | Virginia | 51127 | 4458 | 30 |
2198572 | 2198572 | 2022-02-09 | Texas | Missouri | 29215 | 4458 | 81 |
2174961 | 2174961 | 2022-02-02 | Perry | Indiana | 18123 | 4458 | 64 |
2164739 | 2164739 | 2022-01-30 | Teller | Colorado | 8119 | 4458 | 54 |
2158228 | 2158228 | 2022-01-28 | Teller | Colorado | 8119 | 4458 | 54 |
2131607 | 2131607 | 2022-01-19 | Dinwiddie | Virginia | 51053 | 4458 | 63 |
2097437 | 2097437 | 2022-01-09 | Otsego | Michigan | 26137 | 4458 | 84 |
2099238 | 2099238 | 2022-01-09 | Hampshire | West Virginia | 54027 | 4458 | 59 |
2094185 | 2094185 | 2022-01-08 | Otsego | Michigan | 26137 | 4458 | 84 |
2090933 | 2090933 | 2022-01-07 | Otsego | Michigan | 26137 | 4458 | 84 |
2091721 | 2091721 | 2022-01-07 | Holmes | Ohio | 39075 | 4458 | 157 |
2080369 | 2080369 | 2022-01-04 | Pierce | Georgia | 13229 | 4458 | 107 |
2080869 | 2080869 | 2022-01-04 | Allen | Kentucky | 21003 | 4458 | 83 |
2059659 | 2059659 | 2021-12-28 | DeKalb | Tennessee | 47041 | 4458 | 84 |
2060092 | 2060092 | 2021-12-28 | Halifax | Virginia | 51083 | 4458 | 126 |
2060295 | 2060295 | 2021-12-28 | Kewaunee | Wisconsin | 55061 | 4458 | 49 |
2052104 | 2052104 | 2021-12-26 | Wayne | Mississippi | 28153 | 4458 | 72 |
2048854 | 2048854 | 2021-12-25 | Wayne | Mississippi | 28153 | 4458 | 72 |
2045604 | 2045604 | 2021-12-24 | Wayne | Mississippi | 28153 | 4458 | 72 |
2042354 | 2042354 | 2021-12-23 | Wayne | Mississippi | 28153 | 4458 | 72 |
2039105 | 2039105 | 2021-12-22 | Wayne | Mississippi | 28153 | 4458 | 72 |
2034947 | 2034947 | 2021-12-21 | Jerome | Idaho | 16053 | 4458 | 56 |
2035855 | 2035855 | 2021-12-21 | Wayne | Mississippi | 28153 | 4458 | 72 |
1995237 | 1995237 | 2021-12-08 | Nicholas | West Virginia | 54067 | 4458 | 69 |
1990035 | 1990035 | 2021-12-07 | West Baton Rouge | Louisiana | 22121 | 4458 | 79 |
1951991 | 1951991 | 2021-11-25 | Van Wert | Ohio | 39161 | 4458 | 87 |
1948740 | 1948740 | 2021-11-24 | Van Wert | Ohio | 39161 | 4458 | 87 |
1927814 | 1927814 | 2021-11-18 | Decatur | Indiana | 18031 | 4458 | 114 |
1898289 | 1898289 | 2021-11-09 | Emanuel | Georgia | 13107 | 4458 | 133 |
1853835 | 1853835 | 2021-10-26 | Simpson | Mississippi | 28127 | 4458 | 116 |
1824276 | 1824276 | 2021-10-17 | Sabine | Louisiana | 22085 | 4458 | 86 |
1821027 | 1821027 | 2021-10-16 | Sabine | Louisiana | 22085 | 4458 | 86 |
1817778 | 1817778 | 2021-10-15 | Sabine | Louisiana | 22085 | 4458 | 86 |
1768266 | 1768266 | 2021-09-30 | Washington | Florida | 12133 | 4458 | 62 |
1769292 | 1769292 | 2021-09-30 | Adams | Mississippi | 28001 | 4458 | 117 |
1765017 | 1765017 | 2021-09-29 | Washington | Florida | 12133 | 4458 | 62 |
1761768 | 1761768 | 2021-09-28 | Washington | Florida | 12133 | 4458 | 62 |
1758520 | 1758520 | 2021-09-27 | Washington | Florida | 12133 | 4458 | 62 |
1755272 | 1755272 | 2021-09-26 | Washington | Florida | 12133 | 4458 | 62 |
1752024 | 1752024 | 2021-09-25 | Washington | Florida | 12133 | 4458 | 62 |
1748775 | 1748775 | 2021-09-24 | Washington | Florida | 12133 | 4458 | 59 |
1743216 | 1743216 | 2021-09-22 | Becker | Minnesota | 27005 | 4458 | 59 |
1732843 | 1732843 | 2021-09-19 | Adams | Indiana | 18001 | 4458 | 66 |
1729593 | 1729593 | 2021-09-18 | Adams | Indiana | 18001 | 4458 | 66 |
1726343 | 1726343 | 2021-09-17 | Adams | Indiana | 18001 | 4458 | 66 |
1723512 | 1723512 | 2021-09-16 | Allen | Louisiana | 22003 | 4458 | 103 |
1696429 | 1696429 | 2021-09-08 | Dallas | Alabama | 1047 | 4458 | 170 |
1690927 | 1690927 | 2021-09-06 | Calloway | Kentucky | 21035 | 4458 | 56 |
1687677 | 1687677 | 2021-09-05 | Calloway | Kentucky | 21035 | 4458 | 56 |
1684427 | 1684427 | 2021-09-04 | Calloway | Kentucky | 21035 | 4458 | 56 |
1681176 | 1681176 | 2021-09-03 | Calloway | Kentucky | 21035 | 4458 | 56 |
1679807 | 1679807 | 2021-09-02 | Sanpete | Utah | 49039 | 4458 | 25 |
1647861 | 1647861 | 2021-08-24 | Unknown | Arkansas | 4458 | 0 | |
1644186 | 1644186 | 2021-08-22 | Manassas city | Virginia | 51683 | 4458 | 49 |
1640936 | 1640936 | 2021-08-21 | Manassas city | Virginia | 51683 | 4458 | 49 |
1637686 | 1637686 | 2021-08-20 | Manassas city | Virginia | 51683 | 4458 | 49 |
1619651 | 1619651 | 2021-08-15 | Calvert | Maryland | 24009 | 4458 | 86 |
1563330 | 1563330 | 2021-07-29 | Baxter | Arkansas | 5005 | 4458 | 119 |
1562630 | 1562630 | 2021-07-28 | Cherokee | Texas | 48073 | 4458 | 148 |
1520187 | 1520187 | 2021-07-15 | Dillon | South Carolina | 45033 | 4458 | 85 |
1513369 | 1513369 | 2021-07-13 | Madison | Ohio | 39097 | 4458 | 66 |
1510123 | 1510123 | 2021-07-12 | Madison | Ohio | 39097 | 4458 | 66 |
1506876 | 1506876 | 2021-07-11 | Madison | Ohio | 39097 | 4458 | 66 |
1501099 | 1501099 | 2021-07-09 | Rusk | Texas | 48401 | 4458 | 109 |
1492540 | 1492540 | 2021-07-07 | Montgomery | Indiana | 18107 | 4458 | 93 |
1466528 | 1466528 | 2021-06-29 | Clinton | Indiana | 18023 | 4458 | 60 |
1459479 | 1459479 | 2021-06-27 | Miller | Arkansas | 5091 | 4458 | 38 |
1456234 | 1456234 | 2021-06-26 | Miller | Arkansas | 5091 | 4458 | 38 |
1452989 | 1452989 | 2021-06-25 | Miller | Arkansas | 5091 | 4458 | 38 |
1443826 | 1443826 | 2021-06-22 | Gibson | Indiana | 18051 | 4458 | 98 |
1404158 | 1404158 | 2021-06-10 | Chilton | Alabama | 1021 | 4458 | 116 |
1400913 | 1400913 | 2021-06-09 | Chilton | Alabama | 1021 | 4458 | 115 |
1397668 | 1397668 | 2021-06-08 | Chilton | Alabama | 1021 | 4458 | 115 |
1394421 | 1394421 | 2021-06-07 | Chilton | Alabama | 1021 | 4458 | 115 |
1344346 | 1344346 | 2021-05-22 | Livingston | New York | 36051 | 4458 | 59 |
1317506 | 1317506 | 2021-05-14 | Barren | Kentucky | 21009 | 4458 | 92 |
1315124 | 1315124 | 2021-05-13 | Madison | New York | 36053 | 4458 | 88 |
1297679 | 1297679 | 2021-05-08 | Marion | Illinois | 17121 | 4458 | 121 |
1276398 | 1276398 | 2021-05-01 | Knox | Ohio | 39083 | 4458 | 110 |
1227057 | 1227057 | 2021-04-16 | Panola | Mississippi | 28107 | 4458 | 103 |
1221045 | 1221045 | 2021-04-14 | Hoke | North Carolina | 37093 | 4458 | 55 |
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);