ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 8392 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500077 | 2500077 | 2022-05-13 | Pickens | Georgia | 13227 | 8392 | 167 |
2496819 | 2496819 | 2022-05-12 | Pickens | Georgia | 13227 | 8392 | 167 |
2493561 | 2493561 | 2022-05-11 | Pickens | Georgia | 13227 | 8392 | 167 |
2487687 | 2487687 | 2022-05-09 | Evangeline | Louisiana | 22039 | 8392 | 159 |
2463132 | 2463132 | 2022-05-01 | Bee | Texas | 48025 | 8392 | 153 |
2415983 | 2415983 | 2022-04-17 | Marshall | Kentucky | 21157 | 8392 | 102 |
2412727 | 2412727 | 2022-04-16 | Marshall | Kentucky | 21157 | 8392 | 102 |
2409471 | 2409471 | 2022-04-15 | Marshall | Kentucky | 21157 | 8392 | 102 |
2406215 | 2406215 | 2022-04-14 | Marshall | Kentucky | 21157 | 8392 | 102 |
2402959 | 2402959 | 2022-04-13 | Marshall | Kentucky | 21157 | 8392 | 102 |
2399705 | 2399705 | 2022-04-12 | Marshall | Kentucky | 21157 | 8392 | 102 |
2395394 | 2395394 | 2022-04-11 | Dallas | Alabama | 1047 | 8392 | 242 |
2396449 | 2396449 | 2022-04-11 | Marshall | Kentucky | 21157 | 8392 | 102 |
2392138 | 2392138 | 2022-04-10 | Dallas | Alabama | 1047 | 8392 | 242 |
2388882 | 2388882 | 2022-04-09 | Dallas | Alabama | 1047 | 8392 | 242 |
2385627 | 2385627 | 2022-04-08 | Dallas | Alabama | 1047 | 8392 | 242 |
2370412 | 2370412 | 2022-04-03 | Marshall | Kentucky | 21157 | 8392 | 101 |
2367159 | 2367159 | 2022-04-02 | Marshall | Kentucky | 21157 | 8392 | 101 |
2363906 | 2363906 | 2022-04-01 | Marshall | Kentucky | 21157 | 8392 | 101 |
2360652 | 2360652 | 2022-03-31 | Marshall | Kentucky | 21157 | 8392 | 101 |
2357398 | 2357398 | 2022-03-30 | Marshall | Kentucky | 21157 | 8392 | 101 |
2354145 | 2354145 | 2022-03-29 | Marshall | Kentucky | 21157 | 8392 | 101 |
2350893 | 2350893 | 2022-03-28 | Marshall | Kentucky | 21157 | 8392 | 101 |
2271350 | 2271350 | 2022-03-03 | Titus | Texas | 48449 | 8392 | 125 |
2237853 | 2237853 | 2022-02-21 | Greene | New York | 36039 | 8392 | 118 |
2169481 | 2169481 | 2022-01-31 | Unknown | New Hampshire | 8392 | 24 | |
2114239 | 2114239 | 2022-01-14 | Columbia | New York | 36021 | 8392 | 127 |
2026882 | 2026882 | 2021-12-18 | Bedford | Pennsylvania | 42009 | 8392 | 212 |
1894753 | 1894753 | 2021-11-08 | Mississippi | Arkansas | 5093 | 8392 | 143 |
1881570 | 1881570 | 2021-11-03 | Waupaca | Wisconsin | 55135 | 8392 | 187 |
1853337 | 1853337 | 2021-10-26 | Saline | Kansas | 20169 | 8392 | 178 |
1850088 | 1850088 | 2021-10-25 | Saline | Kansas | 20169 | 8392 | 178 |
1778797 | 1778797 | 2021-10-03 | St. Mary | Louisiana | 22101 | 8392 | 209 |
1775547 | 1775547 | 2021-10-02 | St. Mary | Louisiana | 22101 | 8392 | 209 |
1772297 | 1772297 | 2021-10-01 | St. Mary | Louisiana | 22101 | 8392 | 209 |
1741673 | 1741673 | 2021-09-21 | Rockingham | Virginia | 51165 | 8392 | 127 |
1717441 | 1717441 | 2021-09-14 | Joplin | Missouri | 8392 | 141 | |
1714193 | 1714193 | 2021-09-13 | Joplin | Missouri | 8392 | 141 | |
1628005 | 1628005 | 2021-08-17 | Cowlitz | Washington | 53015 | 8392 | 107 |
1425610 | 1425610 | 2021-06-16 | Surry | North Carolina | 37171 | 8392 | 170 |
1290315 | 1290315 | 2021-05-05 | Roanoke city | Virginia | 51770 | 8392 | 190 |
1241437 | 1241437 | 2021-04-20 | Victoria | Texas | 48469 | 8392 | 199 |
1188686 | 1188686 | 2021-04-04 | Columbiana | Ohio | 39029 | 8392 | 222 |
1185439 | 1185439 | 2021-04-03 | Columbiana | Ohio | 39029 | 8392 | 222 |
1131856 | 1131856 | 2021-03-18 | Fayette | Georgia | 13113 | 8392 | 152 |
1125298 | 1125298 | 2021-03-16 | Sumter | Florida | 12119 | 8392 | 242 |
1056833 | 1056833 | 2021-02-23 | Matanuska-Susitna Borough | Alaska | 2170 | 8392 | 33 |
970291 | 970291 | 2021-01-27 | Terrebonne | Louisiana | 22109 | 8392 | 174 |
917743 | 917743 | 2021-01-11 | Unknown | Guam | 8392 | 125 | |
916061 | 916061 | 2021-01-10 | Miami | Ohio | 39109 | 8392 | 73 |
748405 | 748405 | 2020-11-19 | Washington | Wisconsin | 55131 | 8392 | 66 |
565499 | 565499 | 2020-09-24 | Guilford | North Carolina | 37081 | 8392 | 179 |
328367 | 328367 | 2020-07-13 | Yuma | Arizona | 4027 | 8392 | 154 |
151937 | 151937 | 2020-05-17 | Marion | Indiana | 18097 | 8392 | 512 |
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);