ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where cases = 5920 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 11
- Iowa 7
- Oklahoma 7
- Tennessee 7
- Illinois 6
- Texas 6
- Puerto Rico 5
- Virginia 5
- Michigan 4
- Georgia 3
- Ohio 3
- Wisconsin 3
- Wyoming 3
- Alabama 2
- Arkansas 2
- Kansas 2
- Mississippi 2
- North Carolina 2
- Pennsylvania 2
- Alaska 1
- Colorado 1
- Florida 1
- Louisiana 1
- Maine 1
- Maryland 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- Oregon 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2414025 | 2414025 | 2022-04-16 | Juana Diaz | Puerto Rico | 72075 | 5920 | |
2410769 | 2410769 | 2022-04-15 | Juana Diaz | Puerto Rico | 72075 | 5920 | |
2407513 | 2407513 | 2022-04-14 | Juana Diaz | Puerto Rico | 72075 | 5920 | |
2381478 | 2381478 | 2022-04-06 | Manati | Puerto Rico | 72091 | 5920 | |
2320713 | 2320713 | 2022-03-19 | Sevier | Arkansas | 5133 | 5920 | 72 |
2311978 | 2311978 | 2022-03-16 | Waldo | Maine | 23027 | 5920 | 55 |
2292037 | 2292037 | 2022-03-10 | Randolph | Indiana | 18135 | 5920 | 143 |
2271717 | 2271717 | 2022-03-03 | Vernon | Wisconsin | 55123 | 5920 | 90 |
2236274 | 2236274 | 2022-02-21 | Montezuma | Colorado | 8083 | 5920 | 65 |
2221305 | 2221305 | 2022-02-16 | Nodaway | Missouri | 29147 | 5920 | 42 |
2202183 | 2202183 | 2022-02-10 | Martin | North Carolina | 37117 | 5920 | 83 |
2178135 | 2178135 | 2022-02-03 | Shelby | Illinois | 17173 | 5920 | 67 |
2174882 | 2174882 | 2022-02-02 | Shelby | Illinois | 17173 | 5920 | 67 |
2147944 | 2147944 | 2022-01-24 | Pulaski | Virginia | 51155 | 5920 | 109 |
2102301 | 2102301 | 2022-01-10 | St. Croix | Virgin Islands | 78010 | 5920 | 38 |
2092543 | 2092543 | 2022-01-07 | Washington | Vermont | 50023 | 5920 | 36 |
2079183 | 2079183 | 2022-01-03 | Henry | Tennessee | 47079 | 5920 | 117 |
2062925 | 2062925 | 2021-12-29 | Hardin | Tennessee | 47071 | 5920 | 110 |
2041365 | 2041365 | 2021-12-23 | Pickens | Georgia | 13227 | 5920 | 124 |
2031106 | 2031106 | 2021-12-19 | Sheridan | Wyoming | 56033 | 5920 | 60 |
2027855 | 2027855 | 2021-12-18 | Sheridan | Wyoming | 56033 | 5920 | 60 |
2024604 | 2024604 | 2021-12-17 | Sheridan | Wyoming | 56033 | 5920 | 60 |
2019254 | 2019254 | 2021-12-16 | Iberville | Louisiana | 22047 | 5920 | 129 |
2015527 | 2015527 | 2021-12-15 | Monroe | Illinois | 17133 | 5920 | 106 |
1994177 | 1994177 | 2021-12-08 | Champaign | Ohio | 39021 | 5920 | 87 |
1991438 | 1991438 | 2021-12-07 | Marion | Tennessee | 47115 | 5920 | 74 |
1965104 | 1965104 | 2021-11-29 | Malheur | Oregon | 41045 | 5920 | 86 |
1944134 | 1944134 | 2021-11-23 | Wabash | Indiana | 18169 | 5920 | 108 |
1941302 | 1941302 | 2021-11-22 | Calvert | Maryland | 24009 | 5920 | 101 |
1858924 | 1858924 | 2021-10-28 | Bethel Census Area | Alaska | 2050 | 5920 | 27 |
1806897 | 1806897 | 2021-10-12 | Franklin | Alabama | 1059 | 5920 | 104 |
1748001 | 1748001 | 2021-09-23 | Wharton | Texas | 48481 | 5920 | 154 |
1723124 | 1723124 | 2021-09-16 | Harrison | Indiana | 18061 | 5920 | 87 |
1717313 | 1717313 | 2021-09-14 | Bolivar | Mississippi | 28011 | 5920 | 143 |
1695369 | 1695369 | 2021-09-07 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1692121 | 1692121 | 2021-09-06 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1688872 | 1688872 | 2021-09-05 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1685622 | 1685622 | 2021-09-04 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1682371 | 1682371 | 2021-09-03 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1679121 | 1679121 | 2021-09-02 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1675873 | 1675873 | 2021-09-01 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1625587 | 1625587 | 2021-08-17 | Knox | Illinois | 17095 | 5920 | 188 |
1608473 | 1608473 | 2021-08-11 | Pittsylvania | Virginia | 51143 | 5920 | 86 |
1576824 | 1576824 | 2021-08-02 | Coles | Illinois | 17029 | 5920 | 103 |
1557609 | 1557609 | 2021-07-27 | Warren | Iowa | 19181 | 5920 | 92 |
1554362 | 1554362 | 2021-07-26 | Warren | Iowa | 19181 | 5920 | 92 |
1551115 | 1551115 | 2021-07-25 | Warren | Iowa | 19181 | 5920 | 92 |
1547868 | 1547868 | 2021-07-24 | Warren | Iowa | 19181 | 5920 | 92 |
1544621 | 1544621 | 2021-07-23 | Warren | Iowa | 19181 | 5920 | 92 |
1546016 | 1546016 | 2021-07-23 | Columbia | Pennsylvania | 42037 | 5920 | 136 |
1541373 | 1541373 | 2021-07-22 | Warren | Iowa | 19181 | 5920 | 92 |
1538126 | 1538126 | 2021-07-21 | Warren | Iowa | 19181 | 5920 | 92 |
1486025 | 1486025 | 2021-07-05 | Henry | Indiana | 18065 | 5920 | 113 |
1482779 | 1482779 | 2021-07-04 | Henry | Indiana | 18065 | 5920 | 113 |
1479532 | 1479532 | 2021-07-03 | Henry | Indiana | 18065 | 5920 | 113 |
1476286 | 1476286 | 2021-07-02 | Henry | Indiana | 18065 | 5920 | 113 |
1473040 | 1473040 | 2021-07-01 | Henry | Indiana | 18065 | 5920 | 113 |
1469794 | 1469794 | 2021-06-30 | Henry | Indiana | 18065 | 5920 | 113 |
1466549 | 1466549 | 2021-06-29 | Henry | Indiana | 18065 | 5920 | 113 |
1449138 | 1449138 | 2021-06-23 | Navarro | Texas | 48349 | 5920 | 154 |
1445893 | 1445893 | 2021-06-22 | Navarro | Texas | 48349 | 5920 | 154 |
1440009 | 1440009 | 2021-06-21 | Mississippi | Arkansas | 5093 | 5920 | 110 |
1443013 | 1443013 | 2021-06-21 | Columbia | Wisconsin | 55021 | 5920 | 71 |
1403663 | 1403663 | 2021-06-09 | Lamar | Texas | 48277 | 5920 | 156 |
1385968 | 1385968 | 2021-06-04 | Marquette | Michigan | 26103 | 5920 | 63 |
1382723 | 1382723 | 2021-06-03 | Marquette | Michigan | 26103 | 5920 | 63 |
1379477 | 1379477 | 2021-06-02 | Marquette | Michigan | 26103 | 5920 | 62 |
1374280 | 1374280 | 2021-05-31 | Monroe | Tennessee | 47123 | 5920 | 97 |
1371035 | 1371035 | 2021-05-30 | Monroe | Tennessee | 47123 | 5920 | 97 |
1367789 | 1367789 | 2021-05-29 | Monroe | Tennessee | 47123 | 5920 | 97 |
1364543 | 1364543 | 2021-05-28 | Monroe | Tennessee | 47123 | 5920 | 97 |
1308827 | 1308827 | 2021-05-11 | Belmont | Ohio | 39013 | 5920 | 167 |
1273372 | 1273372 | 2021-04-30 | Union | Pennsylvania | 42119 | 5920 | 86 |
1222315 | 1222315 | 2021-04-14 | Waupaca | Wisconsin | 55135 | 5920 | 161 |
1166224 | 1166224 | 2021-03-28 | Caguas | Puerto Rico | 72025 | 5920 | |
1154550 | 1154550 | 2021-03-25 | Catoosa | Georgia | 13047 | 5920 | 66 |
1121406 | 1121406 | 2021-03-14 | Harrisonburg city | Virginia | 51660 | 5920 | 94 |
1090657 | 1090657 | 2021-03-05 | Lamar | Mississippi | 28073 | 5920 | 81 |
1075111 | 1075111 | 2021-02-28 | Scioto | Ohio | 39145 | 5920 | 104 |
1008072 | 1008072 | 2021-02-08 | Blount | Alabama | 1009 | 5920 | 112 |
988406 | 988406 | 2021-02-01 | Chelan | Washington | 53007 | 5920 | 51 |
984997 | 984997 | 2021-01-31 | Tooele | Utah | 49045 | 5920 | 23 |
965624 | 965624 | 2021-01-25 | Lynchburg city | Virginia | 51680 | 5920 | 67 |
952676 | 952676 | 2021-01-21 | Roanoke | Virginia | 51161 | 5920 | 76 |
931449 | 931449 | 2021-01-15 | Ionia | Michigan | 26067 | 5920 | 61 |
911431 | 911431 | 2021-01-09 | Grant | Indiana | 18053 | 5920 | 113 |
902967 | 902967 | 2021-01-06 | Wilson | North Carolina | 37195 | 5920 | 109 |
874592 | 874592 | 2020-12-28 | Starr | Texas | 48427 | 5920 | 199 |
871347 | 871347 | 2020-12-27 | Starr | Texas | 48427 | 5920 | 199 |
840646 | 840646 | 2020-12-18 | Clay | Minnesota | 27027 | 5920 | 71 |
560815 | 560815 | 2020-09-23 | Muscogee | Georgia | 13215 | 5920 | 167 |
473970 | 473970 | 2020-08-27 | Wyandotte | Kansas | 20209 | 5920 | 113 |
470738 | 470738 | 2020-08-26 | Wyandotte | Kansas | 20209 | 5920 | 113 |
421719 | 421719 | 2020-08-11 | St. Lucie | Florida | 12111 | 5920 | 180 |
400576 | 400576 | 2020-08-04 | Burlington | New Jersey | 34005 | 5920 | 470 |
179113 | 179113 | 2020-05-26 | Kane | Illinois | 17089 | 5920 | 155 |
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);