ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
200 rows where deaths = 54 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2353413 | 2353413 | 2022-03-29 | Hamilton | Florida | 12047 | 3828 | 54 |
2350161 | 2350161 | 2022-03-28 | Hamilton | Florida | 12047 | 3828 | 54 |
2346908 | 2346908 | 2022-03-27 | Hamilton | Florida | 12047 | 3828 | 54 |
2343655 | 2343655 | 2022-03-26 | Hamilton | Florida | 12047 | 3828 | 54 |
2340402 | 2340402 | 2022-03-25 | Hamilton | Florida | 12047 | 3828 | 54 |
2337149 | 2337149 | 2022-03-24 | Hamilton | Florida | 12047 | 3821 | 54 |
2333895 | 2333895 | 2022-03-23 | Hamilton | Florida | 12047 | 3821 | 54 |
2330641 | 2330641 | 2022-03-22 | Hamilton | Florida | 12047 | 3821 | 54 |
2327389 | 2327389 | 2022-03-21 | Hamilton | Florida | 12047 | 3821 | 54 |
2324136 | 2324136 | 2022-03-20 | Hamilton | Florida | 12047 | 3821 | 54 |
2320882 | 2320882 | 2022-03-19 | Hamilton | Florida | 12047 | 3821 | 54 |
2317628 | 2317628 | 2022-03-18 | Hamilton | Florida | 12047 | 3821 | 54 |
2314375 | 2314375 | 2022-03-17 | Hamilton | Florida | 12047 | 3821 | 54 |
2311122 | 2311122 | 2022-03-16 | Hamilton | Florida | 12047 | 3821 | 54 |
1891707 | 1891707 | 2021-11-07 | Madison | Florida | 12079 | 3588 | 54 |
1888457 | 1888457 | 2021-11-06 | Madison | Florida | 12079 | 3588 | 54 |
1885207 | 1885207 | 2021-11-05 | Madison | Florida | 12079 | 3588 | 54 |
1881958 | 1881958 | 2021-11-04 | Madison | Florida | 12079 | 3583 | 54 |
1878709 | 1878709 | 2021-11-03 | Madison | Florida | 12079 | 3583 | 54 |
1875460 | 1875460 | 2021-11-02 | Madison | Florida | 12079 | 3583 | 54 |
1872211 | 1872211 | 2021-11-01 | Madison | Florida | 12079 | 3583 | 54 |
1868962 | 1868962 | 2021-10-31 | Madison | Florida | 12079 | 3583 | 54 |
1865713 | 1865713 | 2021-10-30 | Madison | Florida | 12079 | 3583 | 54 |
1862464 | 1862464 | 2021-10-29 | Madison | Florida | 12079 | 3583 | 54 |
1859215 | 1859215 | 2021-10-28 | Madison | Florida | 12079 | 3584 | 54 |
1855966 | 1855966 | 2021-10-27 | Madison | Florida | 12079 | 3584 | 54 |
1852717 | 1852717 | 2021-10-26 | Madison | Florida | 12079 | 3584 | 54 |
1849468 | 1849468 | 2021-10-25 | Madison | Florida | 12079 | 3584 | 54 |
1846218 | 1846218 | 2021-10-24 | Madison | Florida | 12079 | 3584 | 54 |
1842968 | 1842968 | 2021-10-23 | Madison | Florida | 12079 | 3584 | 54 |
1839718 | 1839718 | 2021-10-22 | Madison | Florida | 12079 | 3584 | 54 |
1836469 | 1836469 | 2021-10-21 | Madison | Florida | 12079 | 3572 | 54 |
1833220 | 1833220 | 2021-10-20 | Madison | Florida | 12079 | 3572 | 54 |
1829971 | 1829971 | 2021-10-19 | Madison | Florida | 12079 | 3572 | 54 |
1826722 | 1826722 | 2021-10-18 | Madison | Florida | 12079 | 3572 | 54 |
1823473 | 1823473 | 2021-10-17 | Madison | Florida | 12079 | 3572 | 54 |
1820224 | 1820224 | 2021-10-16 | Madison | Florida | 12079 | 3572 | 54 |
1816975 | 1816975 | 2021-10-15 | Madison | Florida | 12079 | 3572 | 54 |
1813727 | 1813727 | 2021-10-14 | Madison | Florida | 12079 | 3553 | 54 |
1810478 | 1810478 | 2021-10-13 | Madison | Florida | 12079 | 3553 | 54 |
1807229 | 1807229 | 2021-10-12 | Madison | Florida | 12079 | 3553 | 54 |
1803978 | 1803978 | 2021-10-11 | Madison | Florida | 12079 | 3553 | 54 |
1800729 | 1800729 | 2021-10-10 | Madison | Florida | 12079 | 3553 | 54 |
1797480 | 1797480 | 2021-10-09 | Madison | Florida | 12079 | 3553 | 54 |
1794231 | 1794231 | 2021-10-08 | Madison | Florida | 12079 | 3553 | 54 |
1790983 | 1790983 | 2021-10-07 | Madison | Florida | 12079 | 3531 | 54 |
1787734 | 1787734 | 2021-10-06 | Madison | Florida | 12079 | 3531 | 54 |
1784485 | 1784485 | 2021-10-05 | Madison | Florida | 12079 | 3531 | 54 |
1781236 | 1781236 | 2021-10-04 | Madison | Florida | 12079 | 3531 | 54 |
1777986 | 1777986 | 2021-10-03 | Madison | Florida | 12079 | 3531 | 54 |
1774717 | 1774717 | 2021-10-02 | Gilchrist | Florida | 12041 | 3092 | 54 |
1774736 | 1774736 | 2021-10-02 | Madison | Florida | 12079 | 3531 | 54 |
1771467 | 1771467 | 2021-10-01 | Gilchrist | Florida | 12041 | 3092 | 54 |
1771486 | 1771486 | 2021-10-01 | Madison | Florida | 12079 | 3531 | 54 |
1768218 | 1768218 | 2021-09-30 | Gilchrist | Florida | 12041 | 3051 | 54 |
1768237 | 1768237 | 2021-09-30 | Madison | Florida | 12079 | 3494 | 54 |
1764969 | 1764969 | 2021-09-29 | Gilchrist | Florida | 12041 | 3051 | 54 |
1764988 | 1764988 | 2021-09-29 | Madison | Florida | 12079 | 3494 | 54 |
1761720 | 1761720 | 2021-09-28 | Gilchrist | Florida | 12041 | 3051 | 54 |
1761739 | 1761739 | 2021-09-28 | Madison | Florida | 12079 | 3494 | 54 |
1758472 | 1758472 | 2021-09-27 | Gilchrist | Florida | 12041 | 3051 | 54 |
1758491 | 1758491 | 2021-09-27 | Madison | Florida | 12079 | 3494 | 54 |
1755224 | 1755224 | 2021-09-26 | Gilchrist | Florida | 12041 | 3051 | 54 |
1755243 | 1755243 | 2021-09-26 | Madison | Florida | 12079 | 3494 | 54 |
1751976 | 1751976 | 2021-09-25 | Gilchrist | Florida | 12041 | 3051 | 54 |
1751995 | 1751995 | 2021-09-25 | Madison | Florida | 12079 | 3494 | 54 |
1346083 | 1346083 | 2021-05-23 | Levy | Florida | 12075 | 3528 | 54 |
1342835 | 1342835 | 2021-05-22 | Levy | Florida | 12075 | 3527 | 54 |
1339587 | 1339587 | 2021-05-21 | Levy | Florida | 12075 | 3523 | 54 |
1336340 | 1336340 | 2021-05-20 | Levy | Florida | 12075 | 3513 | 54 |
1333093 | 1333093 | 2021-05-19 | Levy | Florida | 12075 | 3503 | 54 |
1329846 | 1329846 | 2021-05-18 | Levy | Florida | 12075 | 3500 | 54 |
1326599 | 1326599 | 2021-05-17 | Levy | Florida | 12075 | 3498 | 54 |
1323353 | 1323353 | 2021-05-16 | Levy | Florida | 12075 | 3490 | 54 |
1320107 | 1320107 | 2021-05-15 | Levy | Florida | 12075 | 3489 | 54 |
1316860 | 1316860 | 2021-05-14 | Levy | Florida | 12075 | 3487 | 54 |
1313613 | 1313613 | 2021-05-13 | Levy | Florida | 12075 | 3480 | 54 |
1310366 | 1310366 | 2021-05-12 | Levy | Florida | 12075 | 3465 | 54 |
1307120 | 1307120 | 2021-05-11 | Levy | Florida | 12075 | 3464 | 54 |
1303874 | 1303874 | 2021-05-10 | Levy | Florida | 12075 | 3461 | 54 |
1300627 | 1300627 | 2021-05-09 | Levy | Florida | 12075 | 3455 | 54 |
1297380 | 1297380 | 2021-05-08 | Levy | Florida | 12075 | 3452 | 54 |
1294134 | 1294134 | 2021-05-07 | Levy | Florida | 12075 | 3448 | 54 |
1290888 | 1290888 | 2021-05-06 | Levy | Florida | 12075 | 3441 | 54 |
1287642 | 1287642 | 2021-05-05 | Levy | Florida | 12075 | 3432 | 54 |
1284396 | 1284396 | 2021-05-04 | Levy | Florida | 12075 | 3429 | 54 |
1281149 | 1281149 | 2021-05-03 | Levy | Florida | 12075 | 3416 | 54 |
1277902 | 1277902 | 2021-05-02 | Levy | Florida | 12075 | 3412 | 54 |
1264943 | 1264943 | 2021-04-28 | Wakulla | Florida | 12129 | 3397 | 54 |
1261696 | 1261696 | 2021-04-27 | Wakulla | Florida | 12129 | 3394 | 54 |
1258449 | 1258449 | 2021-04-26 | Wakulla | Florida | 12129 | 3385 | 54 |
1255202 | 1255202 | 2021-04-25 | Wakulla | Florida | 12129 | 3381 | 54 |
1251955 | 1251955 | 2021-04-24 | Wakulla | Florida | 12129 | 3381 | 54 |
1248708 | 1248708 | 2021-04-23 | Wakulla | Florida | 12129 | 3377 | 54 |
1245461 | 1245461 | 2021-04-22 | Wakulla | Florida | 12129 | 3370 | 54 |
1242214 | 1242214 | 2021-04-21 | Wakulla | Florida | 12129 | 3363 | 54 |
1238967 | 1238967 | 2021-04-20 | Wakulla | Florida | 12129 | 3355 | 54 |
1235720 | 1235720 | 2021-04-19 | Wakulla | Florida | 12129 | 3348 | 54 |
1232473 | 1232473 | 2021-04-18 | Wakulla | Florida | 12129 | 3343 | 54 |
1229224 | 1229224 | 2021-04-17 | Wakulla | Florida | 12129 | 3337 | 54 |
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);