ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where deaths = 59 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2376194 | 2376194 | 2022-04-05 | Jefferson | Florida | 12065 | 3930 | 59 |
2376195 | 2376195 | 2022-04-05 | Lafayette | Florida | 12067 | 2776 | 59 |
2372942 | 2372942 | 2022-04-04 | Jefferson | Florida | 12065 | 3930 | 59 |
2372943 | 2372943 | 2022-04-04 | Lafayette | Florida | 12067 | 2776 | 59 |
2369689 | 2369689 | 2022-04-03 | Jefferson | Florida | 12065 | 3930 | 59 |
2369690 | 2369690 | 2022-04-03 | Lafayette | Florida | 12067 | 2776 | 59 |
2366436 | 2366436 | 2022-04-02 | Jefferson | Florida | 12065 | 3930 | 59 |
2366437 | 2366437 | 2022-04-02 | Lafayette | Florida | 12067 | 2776 | 59 |
2363183 | 2363183 | 2022-04-01 | Jefferson | Florida | 12065 | 3930 | 59 |
2363184 | 2363184 | 2022-04-01 | Lafayette | Florida | 12067 | 2776 | 59 |
2359929 | 2359929 | 2022-03-31 | Jefferson | Florida | 12065 | 3930 | 59 |
2359930 | 2359930 | 2022-03-31 | Lafayette | Florida | 12067 | 2776 | 59 |
2356675 | 2356675 | 2022-03-30 | Jefferson | Florida | 12065 | 3930 | 59 |
2356676 | 2356676 | 2022-03-30 | Lafayette | Florida | 12067 | 2776 | 59 |
1989194 | 1989194 | 2021-12-07 | Gilchrist | Florida | 12041 | 3184 | 59 |
1989213 | 1989213 | 2021-12-07 | Madison | Florida | 12079 | 3654 | 59 |
1985944 | 1985944 | 2021-12-06 | Gilchrist | Florida | 12041 | 3184 | 59 |
1985963 | 1985963 | 2021-12-06 | Madison | Florida | 12079 | 3654 | 59 |
1982694 | 1982694 | 2021-12-05 | Gilchrist | Florida | 12041 | 3184 | 59 |
1982713 | 1982713 | 2021-12-05 | Madison | Florida | 12079 | 3654 | 59 |
1979444 | 1979444 | 2021-12-04 | Gilchrist | Florida | 12041 | 3184 | 59 |
1979463 | 1979463 | 2021-12-04 | Madison | Florida | 12079 | 3654 | 59 |
1976194 | 1976194 | 2021-12-03 | Gilchrist | Florida | 12041 | 3184 | 59 |
1976213 | 1976213 | 2021-12-03 | Madison | Florida | 12079 | 3654 | 59 |
1972945 | 1972945 | 2021-12-02 | Gilchrist | Florida | 12041 | 3179 | 59 |
1972964 | 1972964 | 2021-12-02 | Madison | Florida | 12079 | 3644 | 59 |
1969695 | 1969695 | 2021-12-01 | Gilchrist | Florida | 12041 | 3179 | 59 |
1969714 | 1969714 | 2021-12-01 | Madison | Florida | 12079 | 3644 | 59 |
1966445 | 1966445 | 2021-11-30 | Gilchrist | Florida | 12041 | 3179 | 59 |
1966464 | 1966464 | 2021-11-30 | Madison | Florida | 12079 | 3644 | 59 |
1963193 | 1963193 | 2021-11-29 | Gilchrist | Florida | 12041 | 3175 | 59 |
1963212 | 1963212 | 2021-11-29 | Madison | Florida | 12079 | 3633 | 59 |
1959942 | 1959942 | 2021-11-28 | Gilchrist | Florida | 12041 | 3175 | 59 |
1959961 | 1959961 | 2021-11-28 | Madison | Florida | 12079 | 3633 | 59 |
1956691 | 1956691 | 2021-11-27 | Gilchrist | Florida | 12041 | 3175 | 59 |
1956710 | 1956710 | 2021-11-27 | Madison | Florida | 12079 | 3633 | 59 |
1953440 | 1953440 | 2021-11-26 | Gilchrist | Florida | 12041 | 3175 | 59 |
1953459 | 1953459 | 2021-11-26 | Madison | Florida | 12079 | 3633 | 59 |
1950189 | 1950189 | 2021-11-25 | Gilchrist | Florida | 12041 | 3175 | 59 |
1950208 | 1950208 | 2021-11-25 | Madison | Florida | 12079 | 3633 | 59 |
1946938 | 1946938 | 2021-11-24 | Gilchrist | Florida | 12041 | 3175 | 59 |
1946957 | 1946957 | 2021-11-24 | Madison | Florida | 12079 | 3633 | 59 |
1943687 | 1943687 | 2021-11-23 | Gilchrist | Florida | 12041 | 3175 | 59 |
1943706 | 1943706 | 2021-11-23 | Madison | Florida | 12079 | 3633 | 59 |
1940437 | 1940437 | 2021-11-22 | Gilchrist | Florida | 12041 | 3175 | 59 |
1940456 | 1940456 | 2021-11-22 | Madison | Florida | 12079 | 3633 | 59 |
1937187 | 1937187 | 2021-11-21 | Gilchrist | Florida | 12041 | 3175 | 59 |
1937206 | 1937206 | 2021-11-21 | Madison | Florida | 12079 | 3633 | 59 |
1933937 | 1933937 | 2021-11-20 | Gilchrist | Florida | 12041 | 3175 | 59 |
1933956 | 1933956 | 2021-11-20 | Madison | Florida | 12079 | 3633 | 59 |
1930704 | 1930704 | 2021-11-19 | Madison | Florida | 12079 | 3633 | 59 |
1927454 | 1927454 | 2021-11-18 | Madison | Florida | 12079 | 3603 | 59 |
1924204 | 1924204 | 2021-11-17 | Madison | Florida | 12079 | 3603 | 59 |
1920955 | 1920955 | 2021-11-16 | Madison | Florida | 12079 | 3603 | 59 |
1917705 | 1917705 | 2021-11-15 | Madison | Florida | 12079 | 3603 | 59 |
1823454 | 1823454 | 2021-10-17 | Gilchrist | Florida | 12041 | 3127 | 59 |
1820205 | 1820205 | 2021-10-16 | Gilchrist | Florida | 12041 | 3127 | 59 |
1816956 | 1816956 | 2021-10-15 | Gilchrist | Florida | 12041 | 3127 | 59 |
1813708 | 1813708 | 2021-10-14 | Gilchrist | Florida | 12041 | 3111 | 59 |
1810459 | 1810459 | 2021-10-13 | Gilchrist | Florida | 12041 | 3111 | 59 |
1807210 | 1807210 | 2021-10-12 | Gilchrist | Florida | 12041 | 3111 | 59 |
1803959 | 1803959 | 2021-10-11 | Gilchrist | Florida | 12041 | 3111 | 59 |
1800710 | 1800710 | 2021-10-10 | Gilchrist | Florida | 12041 | 3111 | 59 |
1797461 | 1797461 | 2021-10-09 | Gilchrist | Florida | 12041 | 3111 | 59 |
1794212 | 1794212 | 2021-10-08 | Gilchrist | Florida | 12041 | 3111 | 59 |
1790964 | 1790964 | 2021-10-07 | Gilchrist | Florida | 12041 | 3092 | 59 |
1787715 | 1787715 | 2021-10-06 | Gilchrist | Florida | 12041 | 3092 | 59 |
1784466 | 1784466 | 2021-10-05 | Gilchrist | Florida | 12041 | 3092 | 59 |
1781217 | 1781217 | 2021-10-04 | Gilchrist | Florida | 12041 | 3092 | 59 |
1777967 | 1777967 | 2021-10-03 | Gilchrist | Florida | 12041 | 3092 | 59 |
1774719 | 1774719 | 2021-10-02 | Gulf | Florida | 12045 | 2947 | 59 |
1771469 | 1771469 | 2021-10-01 | Gulf | Florida | 12045 | 2947 | 59 |
1768220 | 1768220 | 2021-09-30 | Gulf | Florida | 12045 | 2931 | 59 |
1764971 | 1764971 | 2021-09-29 | Gulf | Florida | 12045 | 2931 | 59 |
1761722 | 1761722 | 2021-09-28 | Gulf | Florida | 12045 | 2931 | 59 |
1758474 | 1758474 | 2021-09-27 | Gulf | Florida | 12045 | 2931 | 59 |
1755226 | 1755226 | 2021-09-26 | Gulf | Florida | 12045 | 2931 | 59 |
1751978 | 1751978 | 2021-09-25 | Gulf | Florida | 12045 | 2931 | 59 |
1748736 | 1748736 | 2021-09-24 | Holmes | Florida | 12059 | 3721 | 59 |
1748775 | 1748775 | 2021-09-24 | Washington | Florida | 12133 | 4458 | 59 |
1745486 | 1745486 | 2021-09-23 | Holmes | Florida | 12059 | 3668 | 59 |
1745525 | 1745525 | 2021-09-23 | Washington | Florida | 12133 | 4403 | 59 |
1742237 | 1742237 | 2021-09-22 | Holmes | Florida | 12059 | 3668 | 59 |
1742276 | 1742276 | 2021-09-22 | Washington | Florida | 12133 | 4403 | 59 |
1738988 | 1738988 | 2021-09-21 | Holmes | Florida | 12059 | 3668 | 59 |
1739027 | 1739027 | 2021-09-21 | Washington | Florida | 12133 | 4403 | 59 |
1735739 | 1735739 | 2021-09-20 | Holmes | Florida | 12059 | 3668 | 59 |
1735778 | 1735778 | 2021-09-20 | Washington | Florida | 12133 | 4403 | 59 |
1732489 | 1732489 | 2021-09-19 | Holmes | Florida | 12059 | 3668 | 59 |
1732528 | 1732528 | 2021-09-19 | Washington | Florida | 12133 | 4403 | 59 |
1729239 | 1729239 | 2021-09-18 | Holmes | Florida | 12059 | 3668 | 59 |
1729278 | 1729278 | 2021-09-18 | Washington | Florida | 12133 | 4403 | 59 |
1164204 | 1164204 | 2021-03-28 | Baker | Florida | 12003 | 3352 | 59 |
1160956 | 1160956 | 2021-03-27 | Baker | Florida | 12003 | 3350 | 59 |
1157708 | 1157708 | 2021-03-26 | Baker | Florida | 12003 | 3348 | 59 |
1154461 | 1154461 | 2021-03-25 | Baker | Florida | 12003 | 3347 | 59 |
1151214 | 1151214 | 2021-03-24 | Baker | Florida | 12003 | 3344 | 59 |
1147967 | 1147967 | 2021-03-23 | Baker | Florida | 12003 | 3340 | 59 |
1144720 | 1144720 | 2021-03-22 | Baker | Florida | 12003 | 3338 | 59 |
1141473 | 1141473 | 2021-03-21 | Baker | Florida | 12003 | 3335 | 59 |
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);