ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where cases = 5802 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Louisiana 7
- Georgia 6
- Kansas 5
- Virginia 5
- Utah 4
- Illinois 3
- Indiana 3
- Missouri 3
- Nebraska 3
- Ohio 3
- Tennessee 3
- Texas 3
- Arkansas 2
- Colorado 2
- Iowa 2
- Michigan 2
- North Carolina 2
- Oklahoma 2
- Pennsylvania 2
- West Virginia 2
- Wisconsin 2
- Arizona 1
- California 1
- Florida 1
- Kentucky 1
- Mississippi 1
- New York 1
- Puerto Rico 1
- South Carolina 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472627 | 2472627 | 2022-05-04 | Hatillo | Puerto Rico | 72065 | 5802 | |
2275180 | 2275180 | 2022-03-05 | Sevier | Arkansas | 5133 | 5802 | 69 |
2256257 | 2256257 | 2022-02-27 | Owen | Indiana | 18119 | 5802 | 113 |
2253006 | 2253006 | 2022-02-26 | Owen | Indiana | 18119 | 5802 | 113 |
2249755 | 2249755 | 2022-02-25 | Owen | Indiana | 18119 | 5802 | 113 |
2165121 | 2165121 | 2022-01-30 | Shelby | Illinois | 17173 | 5802 | 67 |
2161866 | 2161866 | 2022-01-29 | Shelby | Illinois | 17173 | 5802 | 67 |
2158611 | 2158611 | 2022-01-28 | Shelby | Illinois | 17173 | 5802 | 67 |
2148682 | 2148682 | 2022-01-25 | Stephens | Georgia | 13257 | 5802 | 129 |
2059693 | 2059693 | 2021-12-28 | Macon | Tennessee | 47111 | 5802 | 118 |
2035972 | 2035972 | 2021-12-21 | Warren | Missouri | 29219 | 5802 | 75 |
2021162 | 2021162 | 2021-12-16 | Warren | Virginia | 51187 | 5802 | 101 |
1991913 | 1991913 | 2021-12-07 | York | Virginia | 51199 | 5802 | 83 |
1991977 | 1991977 | 2021-12-07 | Marshall | West Virginia | 54051 | 5802 | 124 |
1960552 | 1960552 | 2021-11-28 | Lyon | Kansas | 20111 | 5802 | 96 |
1957301 | 1957301 | 2021-11-27 | Lyon | Kansas | 20111 | 5802 | 96 |
1954050 | 1954050 | 2021-11-26 | Lyon | Kansas | 20111 | 5802 | 96 |
1950799 | 1950799 | 2021-11-25 | Lyon | Kansas | 20111 | 5802 | 96 |
1947548 | 1947548 | 2021-11-24 | Lyon | Kansas | 20111 | 5802 | 96 |
1905957 | 1905957 | 2021-11-11 | Webster | Missouri | 29225 | 5802 | 94 |
1902708 | 1902708 | 2021-11-10 | Webster | Missouri | 29225 | 5802 | 94 |
1860118 | 1860118 | 2021-10-28 | Delta | Michigan | 26041 | 5802 | 106 |
1856869 | 1856869 | 2021-10-27 | Delta | Michigan | 26041 | 5802 | 106 |
1846998 | 1846998 | 2021-10-24 | Evangeline | Louisiana | 22039 | 5802 | 140 |
1843748 | 1843748 | 2021-10-23 | Evangeline | Louisiana | 22039 | 5802 | 140 |
1840498 | 1840498 | 2021-10-22 | Evangeline | Louisiana | 22039 | 5802 | 140 |
1809976 | 1809976 | 2021-10-12 | Fayette | West Virginia | 54019 | 5802 | 112 |
1806523 | 1806523 | 2021-10-11 | Wasatch | Utah | 49051 | 5802 | 28 |
1802117 | 1802117 | 2021-10-10 | Scotts Bluff | Nebraska | 31157 | 5802 | 96 |
1803273 | 1803273 | 2021-10-10 | Wasatch | Utah | 49051 | 5802 | 28 |
1798868 | 1798868 | 2021-10-09 | Scotts Bluff | Nebraska | 31157 | 5802 | 96 |
1800024 | 1800024 | 2021-10-09 | Wasatch | Utah | 49051 | 5802 | 28 |
1795619 | 1795619 | 2021-10-08 | Scotts Bluff | Nebraska | 31157 | 5802 | 96 |
1796775 | 1796775 | 2021-10-08 | Wasatch | Utah | 49051 | 5802 | 28 |
1792493 | 1792493 | 2021-10-07 | Madison | New York | 36053 | 5802 | 98 |
1756009 | 1756009 | 2021-09-26 | Beauregard | Louisiana | 22011 | 5802 | 114 |
1752761 | 1752761 | 2021-09-25 | Beauregard | Louisiana | 22011 | 5802 | 114 |
1753902 | 1753902 | 2021-09-25 | Bedford | Pennsylvania | 42009 | 5802 | 150 |
1749512 | 1749512 | 2021-09-24 | Beauregard | Louisiana | 22011 | 5802 | 114 |
1738345 | 1738345 | 2021-09-20 | Culpeper | Virginia | 51047 | 5802 | 70 |
1696147 | 1696147 | 2021-09-07 | James City | Virginia | 51095 | 5802 | 78 |
1672560 | 1672560 | 2021-08-31 | Washington | Ohio | 39167 | 5802 | 111 |
1670239 | 1670239 | 2021-08-30 | Grays Harbor | Washington | 53027 | 5802 | 87 |
1641592 | 1641592 | 2021-08-22 | Camden | Georgia | 13039 | 5802 | 48 |
1638342 | 1638342 | 2021-08-21 | Camden | Georgia | 13039 | 5802 | 48 |
1635092 | 1635092 | 2021-08-20 | Camden | Georgia | 13039 | 5802 | 48 |
1606941 | 1606941 | 2021-08-11 | Washington | Mississippi | 28151 | 5802 | 140 |
1507418 | 1507418 | 2021-07-11 | Caldwell | Texas | 48055 | 5802 | 100 |
1504172 | 1504172 | 2021-07-10 | Caldwell | Texas | 48055 | 5802 | 100 |
1353104 | 1353104 | 2021-05-25 | Warren | Iowa | 19181 | 5802 | 90 |
1349858 | 1349858 | 2021-05-24 | Warren | Iowa | 19181 | 5802 | 90 |
1290797 | 1290797 | 2021-05-06 | Garfield | Colorado | 8045 | 5802 | 38 |
1248477 | 1248477 | 2021-04-23 | Mississippi | Arkansas | 5093 | 5802 | 107 |
1244390 | 1244390 | 2021-04-21 | Hawkins | Tennessee | 47073 | 5802 | 106 |
1235240 | 1235240 | 2021-04-18 | Barron | Wisconsin | 55005 | 5802 | 76 |
1109097 | 1109097 | 2021-03-11 | Catoosa | Georgia | 13047 | 5802 | 67 |
1098682 | 1098682 | 2021-03-07 | Harrisonburg city | Virginia | 51660 | 5802 | 92 |
1087062 | 1087062 | 2021-03-04 | Pulaski | Kentucky | 21199 | 5802 | 87 |
1085243 | 1085243 | 2021-03-03 | Bedford | Tennessee | 47003 | 5802 | 120 |
1052414 | 1052414 | 2021-02-21 | Bryan | Oklahoma | 40013 | 5802 | 54 |
1029627 | 1029627 | 2021-02-14 | Geauga | Ohio | 39055 | 5802 | 125 |
1000460 | 1000460 | 2021-02-05 | Ross | Ohio | 39141 | 5802 | 104 |
981474 | 981474 | 2021-01-30 | Anderson | Texas | 48001 | 5802 | 88 |
948385 | 948385 | 2021-01-20 | Rutherford | North Carolina | 37161 | 5802 | 155 |
929245 | 929245 | 2021-01-14 | Somerset | Pennsylvania | 42111 | 5802 | 125 |
922403 | 922403 | 2021-01-12 | Moore | North Carolina | 37125 | 5802 | 80 |
893440 | 893440 | 2021-01-03 | Pottawatomie | Oklahoma | 40125 | 5802 | 38 |
884951 | 884951 | 2021-01-01 | Napa | California | 6055 | 5802 | 29 |
823541 | 823541 | 2020-12-13 | Houston | Georgia | 13153 | 5802 | 113 |
719166 | 719166 | 2020-11-10 | La Crosse | Wisconsin | 55063 | 5802 | 27 |
640551 | 640551 | 2020-10-17 | Berkeley | South Carolina | 45015 | 5802 | 92 |
586351 | 586351 | 2020-10-01 | Navajo | Arizona | 4017 | 5802 | 236 |
547693 | 547693 | 2020-09-19 | Bay | Florida | 12005 | 5802 | 94 |
197101 | 197101 | 2020-06-01 | Denver | Colorado | 8031 | 5802 | 329 |
76703 | 76703 | 2020-04-21 | Jefferson | Louisiana | 22051 | 5802 | 288 |
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);