ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
86 rows where cases = 5823 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Florida 14
- Tennessee 11
- South Carolina 10
- Georgia 6
- Texas 6
- Indiana 5
- Virginia 4
- Wisconsin 4
- North Carolina 3
- Arizona 2
- Arkansas 2
- Iowa 2
- Kansas 2
- Minnesota 2
- Ohio 2
- Alabama 1
- California 1
- Louisiana 1
- Maine 1
- Maryland 1
- Michigan 1
- Missouri 1
- New Hampshire 1
- Pennsylvania 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492230 | 2492230 | 2022-05-10 | Barnwell | South Carolina | 45011 | 5823 | 103 |
2488972 | 2488972 | 2022-05-09 | Barnwell | South Carolina | 45011 | 5823 | 103 |
2485715 | 2485715 | 2022-05-08 | Barnwell | South Carolina | 45011 | 5823 | 103 |
2482457 | 2482457 | 2022-05-07 | Barnwell | South Carolina | 45011 | 5823 | 103 |
2479199 | 2479199 | 2022-05-06 | Barnwell | South Carolina | 45011 | 5823 | 103 |
2475941 | 2475941 | 2022-05-05 | Barnwell | South Carolina | 45011 | 5823 | 103 |
2472684 | 2472684 | 2022-05-04 | Barnwell | South Carolina | 45011 | 5823 | 103 |
2469428 | 2469428 | 2022-05-03 | Barnwell | South Carolina | 45011 | 5823 | 103 |
2382710 | 2382710 | 2022-04-07 | Madison | Florida | 12079 | 5823 | 96 |
2379455 | 2379455 | 2022-04-06 | Madison | Florida | 12079 | 5823 | 96 |
2376201 | 2376201 | 2022-04-05 | Madison | Florida | 12079 | 5823 | 96 |
2372949 | 2372949 | 2022-04-04 | Madison | Florida | 12079 | 5823 | 96 |
2369696 | 2369696 | 2022-04-03 | Madison | Florida | 12079 | 5823 | 96 |
2366443 | 2366443 | 2022-04-02 | Madison | Florida | 12079 | 5823 | 96 |
2363190 | 2363190 | 2022-04-01 | Madison | Florida | 12079 | 5823 | 96 |
2359936 | 2359936 | 2022-03-31 | Madison | Florida | 12079 | 5823 | 96 |
2356682 | 2356682 | 2022-03-30 | Madison | Florida | 12079 | 5823 | 96 |
2353429 | 2353429 | 2022-03-29 | Madison | Florida | 12079 | 5823 | 94 |
2355612 | 2355612 | 2022-03-29 | Chester | Tennessee | 47023 | 5823 | 96 |
2350177 | 2350177 | 2022-03-28 | Madison | Florida | 12079 | 5823 | 94 |
2352359 | 2352359 | 2022-03-28 | Chester | Tennessee | 47023 | 5823 | 96 |
2346924 | 2346924 | 2022-03-27 | Madison | Florida | 12079 | 5823 | 94 |
2349107 | 2349107 | 2022-03-27 | Chester | Tennessee | 47023 | 5823 | 96 |
2343671 | 2343671 | 2022-03-26 | Madison | Florida | 12079 | 5823 | 94 |
2345854 | 2345854 | 2022-03-26 | Chester | Tennessee | 47023 | 5823 | 96 |
2340418 | 2340418 | 2022-03-25 | Madison | Florida | 12079 | 5823 | 94 |
2342601 | 2342601 | 2022-03-25 | Chester | Tennessee | 47023 | 5823 | 96 |
2339348 | 2339348 | 2022-03-24 | Chester | Tennessee | 47023 | 5823 | 96 |
2336094 | 2336094 | 2022-03-23 | Chester | Tennessee | 47023 | 5823 | 96 |
2327808 | 2327808 | 2022-03-21 | Owen | Indiana | 18119 | 5823 | 117 |
2324555 | 2324555 | 2022-03-20 | Owen | Indiana | 18119 | 5823 | 117 |
2321301 | 2321301 | 2022-03-19 | Owen | Indiana | 18119 | 5823 | 117 |
2318047 | 2318047 | 2022-03-18 | Owen | Indiana | 18119 | 5823 | 117 |
2313965 | 2313965 | 2022-03-16 | Kewaunee | Wisconsin | 55061 | 5823 | 58 |
2310712 | 2310712 | 2022-03-15 | Kewaunee | Wisconsin | 55061 | 5823 | 57 |
2307459 | 2307459 | 2022-03-14 | Kewaunee | Wisconsin | 55061 | 5823 | 57 |
2218926 | 2218926 | 2022-02-15 | Jasper | South Carolina | 45053 | 5823 | 90 |
2129161 | 2129161 | 2022-01-19 | Sumter | Georgia | 13261 | 5823 | 145 |
2099859 | 2099859 | 2022-01-10 | Lumpkin | Georgia | 13187 | 5823 | 111 |
2087354 | 2087354 | 2022-01-06 | Seward | Kansas | 20175 | 5823 | 56 |
2084102 | 2084102 | 2022-01-05 | Seward | Kansas | 20175 | 5823 | 56 |
2080032 | 2080032 | 2022-01-04 | Poinsett | Arkansas | 5111 | 5823 | 106 |
2018611 | 2018611 | 2021-12-16 | Pickens | Georgia | 13227 | 5823 | 123 |
1993291 | 1993291 | 2021-12-08 | Aroostook | Maine | 23003 | 5823 | 89 |
1929081 | 1929081 | 2021-11-18 | Scotland | North Carolina | 37165 | 5823 | 109 |
1919912 | 1919912 | 2021-11-15 | Henderson | Tennessee | 47077 | 5823 | 103 |
1912456 | 1912456 | 2021-11-13 | Webster | Missouri | 29225 | 5823 | 94 |
1881777 | 1881777 | 2021-11-04 | Union | Arkansas | 5139 | 5823 | 140 |
1882393 | 1882393 | 2021-11-04 | Whitley | Indiana | 18183 | 5823 | 57 |
1834260 | 1834260 | 2021-10-20 | Steele | Minnesota | 27147 | 5823 | 25 |
1779741 | 1779741 | 2021-10-03 | Mercer | Ohio | 39107 | 5823 | 91 |
1699395 | 1699395 | 2021-09-08 | James City | Virginia | 51095 | 5823 | 80 |
1692854 | 1692854 | 2021-09-06 | Campbell | Virginia | 51031 | 5823 | 116 |
1676929 | 1676929 | 2021-09-02 | Covington | Alabama | 1039 | 5823 | 149 |
1674057 | 1674057 | 2021-09-01 | Baldwin | Georgia | 13009 | 5823 | 147 |
1672480 | 1672480 | 2021-08-31 | Athens | Ohio | 39009 | 5823 | 60 |
1618544 | 1618544 | 2021-08-15 | Graham | Arizona | 4009 | 5823 | 89 |
1465493 | 1465493 | 2021-06-28 | Albemarle | Virginia | 51003 | 5823 | 85 |
1462248 | 1462248 | 2021-06-27 | Albemarle | Virginia | 51003 | 5823 | 85 |
1398544 | 1398544 | 2021-06-08 | Warren | Iowa | 19181 | 5823 | 90 |
1395297 | 1395297 | 2021-06-07 | Warren | Iowa | 19181 | 5823 | 90 |
1380812 | 1380812 | 2021-06-02 | Atascosa | Texas | 48013 | 5823 | 150 |
1358549 | 1358549 | 2021-05-26 | Skagit | Washington | 53057 | 5823 | 73 |
1354498 | 1354498 | 2021-05-25 | Columbia | Pennsylvania | 42037 | 5823 | 133 |
1327489 | 1327489 | 2021-05-17 | Barry | Michigan | 26015 | 5823 | 65 |
1306677 | 1306677 | 2021-05-10 | Columbia | Wisconsin | 55021 | 5823 | 69 |
1303031 | 1303031 | 2021-05-09 | Lamar | Texas | 48277 | 5823 | 155 |
1299784 | 1299784 | 2021-05-08 | Lamar | Texas | 48277 | 5823 | 155 |
1296537 | 1296537 | 2021-05-07 | Lamar | Texas | 48277 | 5823 | 155 |
1293291 | 1293291 | 2021-05-06 | Lamar | Texas | 48277 | 5823 | 155 |
1289871 | 1289871 | 2021-05-05 | Monroe | Tennessee | 47123 | 5823 | 95 |
1290045 | 1290045 | 2021-05-05 | Lamar | Texas | 48277 | 5823 | 155 |
1263266 | 1263266 | 2021-04-27 | Lenoir | North Carolina | 37107 | 5823 | 112 |
1236542 | 1236542 | 2021-04-19 | Cecil | Maryland | 24015 | 5823 | 128 |
1200950 | 1200950 | 2021-04-08 | Crow Wing | Minnesota | 27035 | 5823 | 86 |
1133990 | 1133990 | 2021-03-18 | Loudon | Tennessee | 47105 | 5823 | 68 |
1125329 | 1125329 | 2021-03-16 | Catoosa | Georgia | 13047 | 5823 | 66 |
1127487 | 1127487 | 2021-03-16 | Jefferson | Tennessee | 47089 | 5823 | 121 |
1118644 | 1118644 | 2021-03-14 | San Benito | California | 6069 | 5823 | 61 |
1036031 | 1036031 | 2021-02-16 | Wilkes | North Carolina | 37193 | 5823 | 97 |
1000771 | 1000771 | 2021-02-05 | Kershaw | South Carolina | 45055 | 5823 | 102 |
986466 | 986466 | 2021-02-01 | Acadia | Louisiana | 22001 | 5823 | 177 |
928714 | 928714 | 2021-01-14 | Merrimack | New Hampshire | 33013 | 5823 | 85 |
907338 | 907338 | 2021-01-07 | Monongalia | West Virginia | 54061 | 5823 | 44 |
888450 | 888450 | 2021-01-02 | Jackson | Georgia | 13157 | 5823 | 74 |
797209 | 797209 | 2020-12-05 | Apache | Arizona | 4001 | 5823 | 200 |
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);