ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where deaths = 34 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2216824 | 2216824 | 2022-02-15 | Glades | Florida | 12043 | 1949 | 34 |
2213573 | 2213573 | 2022-02-14 | Glades | Florida | 12043 | 1949 | 34 |
2210321 | 2210321 | 2022-02-13 | Glades | Florida | 12043 | 1949 | 34 |
2207068 | 2207068 | 2022-02-12 | Glades | Florida | 12043 | 1949 | 34 |
2203815 | 2203815 | 2022-02-11 | Glades | Florida | 12043 | 1949 | 34 |
2200562 | 2200562 | 2022-02-10 | Glades | Florida | 12043 | 1916 | 34 |
2197308 | 2197308 | 2022-02-09 | Glades | Florida | 12043 | 1916 | 34 |
2194054 | 2194054 | 2022-02-08 | Glades | Florida | 12043 | 1916 | 34 |
2190800 | 2190800 | 2022-02-07 | Glades | Florida | 12043 | 1916 | 34 |
2187547 | 2187547 | 2022-02-06 | Glades | Florida | 12043 | 1916 | 34 |
2184294 | 2184294 | 2022-02-05 | Glades | Florida | 12043 | 1916 | 34 |
2181042 | 2181042 | 2022-02-04 | Glades | Florida | 12043 | 1916 | 34 |
2177791 | 2177791 | 2022-02-03 | Glades | Florida | 12043 | 1871 | 34 |
2174538 | 2174538 | 2022-02-02 | Glades | Florida | 12043 | 1871 | 34 |
2171285 | 2171285 | 2022-02-01 | Glades | Florida | 12043 | 1871 | 34 |
2168032 | 2168032 | 2022-01-31 | Glades | Florida | 12043 | 1871 | 34 |
2164777 | 2164777 | 2022-01-30 | Glades | Florida | 12043 | 1871 | 34 |
2161522 | 2161522 | 2022-01-29 | Glades | Florida | 12043 | 1871 | 34 |
2158266 | 2158266 | 2022-01-28 | Glades | Florida | 12043 | 1871 | 34 |
2155013 | 2155013 | 2022-01-27 | Glades | Florida | 12043 | 1799 | 34 |
2151760 | 2151760 | 2022-01-26 | Glades | Florida | 12043 | 1799 | 34 |
2148508 | 2148508 | 2022-01-25 | Glades | Florida | 12043 | 1799 | 34 |
2145256 | 2145256 | 2022-01-24 | Glades | Florida | 12043 | 1799 | 34 |
2142001 | 2142001 | 2022-01-23 | Glades | Florida | 12043 | 1799 | 34 |
2138746 | 2138746 | 2022-01-22 | Glades | Florida | 12043 | 1799 | 34 |
2135490 | 2135490 | 2022-01-21 | Glades | Florida | 12043 | 1799 | 34 |
2132238 | 2132238 | 2022-01-20 | Glades | Florida | 12043 | 1689 | 34 |
2128985 | 2128985 | 2022-01-19 | Glades | Florida | 12043 | 1689 | 34 |
2125731 | 2125731 | 2022-01-18 | Glades | Florida | 12043 | 1689 | 34 |
2122479 | 2122479 | 2022-01-17 | Glades | Florida | 12043 | 1689 | 34 |
2119227 | 2119227 | 2022-01-16 | Glades | Florida | 12043 | 1689 | 34 |
2115975 | 2115975 | 2022-01-15 | Glades | Florida | 12043 | 1689 | 34 |
2112724 | 2112724 | 2022-01-14 | Glades | Florida | 12043 | 1689 | 34 |
2109472 | 2109472 | 2022-01-13 | Glades | Florida | 12043 | 1579 | 34 |
2106221 | 2106221 | 2022-01-12 | Glades | Florida | 12043 | 1579 | 34 |
2102970 | 2102970 | 2022-01-11 | Glades | Florida | 12043 | 1579 | 34 |
2099719 | 2099719 | 2022-01-10 | Glades | Florida | 12043 | 1579 | 34 |
2096468 | 2096468 | 2022-01-09 | Glades | Florida | 12043 | 1579 | 34 |
2093216 | 2093216 | 2022-01-08 | Glades | Florida | 12043 | 1579 | 34 |
2089964 | 2089964 | 2022-01-07 | Glades | Florida | 12043 | 1579 | 34 |
2086713 | 2086713 | 2022-01-06 | Glades | Florida | 12043 | 1504 | 34 |
2083461 | 2083461 | 2022-01-05 | Glades | Florida | 12043 | 1504 | 34 |
2080209 | 2080209 | 2022-01-04 | Glades | Florida | 12043 | 1504 | 34 |
2076957 | 2076957 | 2022-01-03 | Glades | Florida | 12043 | 1504 | 34 |
2073706 | 2073706 | 2022-01-02 | Glades | Florida | 12043 | 1504 | 34 |
2070455 | 2070455 | 2022-01-01 | Glades | Florida | 12043 | 1504 | 34 |
2067204 | 2067204 | 2021-12-31 | Glades | Florida | 12043 | 1504 | 34 |
2063953 | 2063953 | 2021-12-30 | Glades | Florida | 12043 | 1478 | 34 |
2060703 | 2060703 | 2021-12-29 | Glades | Florida | 12043 | 1478 | 34 |
2057454 | 2057454 | 2021-12-28 | Glades | Florida | 12043 | 1478 | 34 |
2054205 | 2054205 | 2021-12-27 | Glades | Florida | 12043 | 1478 | 34 |
2050955 | 2050955 | 2021-12-26 | Glades | Florida | 12043 | 1478 | 34 |
2047705 | 2047705 | 2021-12-25 | Glades | Florida | 12043 | 1478 | 34 |
2044455 | 2044455 | 2021-12-24 | Glades | Florida | 12043 | 1478 | 34 |
2041206 | 2041206 | 2021-12-23 | Glades | Florida | 12043 | 1462 | 34 |
2037956 | 2037956 | 2021-12-22 | Glades | Florida | 12043 | 1462 | 34 |
2034706 | 2034706 | 2021-12-21 | Glades | Florida | 12043 | 1462 | 34 |
2031456 | 2031456 | 2021-12-20 | Glades | Florida | 12043 | 1462 | 34 |
2028205 | 2028205 | 2021-12-19 | Glades | Florida | 12043 | 1462 | 34 |
2024954 | 2024954 | 2021-12-18 | Glades | Florida | 12043 | 1462 | 34 |
2021703 | 2021703 | 2021-12-17 | Glades | Florida | 12043 | 1462 | 34 |
2018452 | 2018452 | 2021-12-16 | Glades | Florida | 12043 | 1459 | 34 |
2015202 | 2015202 | 2021-12-15 | Glades | Florida | 12043 | 1459 | 34 |
2011951 | 2011951 | 2021-12-14 | Glades | Florida | 12043 | 1459 | 34 |
1930679 | 1930679 | 2021-11-19 | Dixie | Florida | 12029 | 2964 | 34 |
1927429 | 1927429 | 2021-11-18 | Dixie | Florida | 12029 | 2960 | 34 |
1924179 | 1924179 | 2021-11-17 | Dixie | Florida | 12029 | 2960 | 34 |
1920930 | 1920930 | 2021-11-16 | Dixie | Florida | 12029 | 2960 | 34 |
1917680 | 1917680 | 2021-11-15 | Dixie | Florida | 12029 | 2960 | 34 |
1914430 | 1914430 | 2021-11-14 | Dixie | Florida | 12029 | 2960 | 34 |
1911180 | 1911180 | 2021-11-13 | Dixie | Florida | 12029 | 2960 | 34 |
1907931 | 1907931 | 2021-11-12 | Dixie | Florida | 12029 | 2960 | 34 |
1904682 | 1904682 | 2021-11-11 | Dixie | Florida | 12029 | 2953 | 34 |
1901432 | 1901432 | 2021-11-10 | Dixie | Florida | 12029 | 2953 | 34 |
1898182 | 1898182 | 2021-11-09 | Dixie | Florida | 12029 | 2953 | 34 |
1894932 | 1894932 | 2021-11-08 | Dixie | Florida | 12029 | 2953 | 34 |
1748739 | 1748739 | 2021-09-24 | Jefferson | Florida | 12065 | 2400 | 34 |
1745489 | 1745489 | 2021-09-23 | Jefferson | Florida | 12065 | 2341 | 34 |
1742240 | 1742240 | 2021-09-22 | Jefferson | Florida | 12065 | 2341 | 34 |
1738991 | 1738991 | 2021-09-21 | Jefferson | Florida | 12065 | 2341 | 34 |
1735742 | 1735742 | 2021-09-20 | Jefferson | Florida | 12065 | 2341 | 34 |
1732492 | 1732492 | 2021-09-19 | Jefferson | Florida | 12065 | 2341 | 34 |
1729242 | 1729242 | 2021-09-18 | Jefferson | Florida | 12065 | 2341 | 34 |
1725992 | 1725992 | 2021-09-17 | Jefferson | Florida | 12065 | 2341 | 34 |
1722743 | 1722743 | 2021-09-16 | Jefferson | Florida | 12065 | 2279 | 34 |
1719494 | 1719494 | 2021-09-15 | Jefferson | Florida | 12065 | 2279 | 34 |
1716246 | 1716246 | 2021-09-14 | Jefferson | Florida | 12065 | 2279 | 34 |
1118769 | 1118769 | 2021-03-14 | Hardee | Florida | 12049 | 2855 | 34 |
1115522 | 1115522 | 2021-03-13 | Hardee | Florida | 12049 | 2853 | 34 |
1060356 | 1060356 | 2021-02-24 | Levy | Florida | 12075 | 2842 | 34 |
1057110 | 1057110 | 2021-02-23 | Levy | Florida | 12075 | 2832 | 34 |
1053864 | 1053864 | 2021-02-22 | Levy | Florida | 12075 | 2829 | 34 |
998673 | 998673 | 2021-02-05 | Gulf | Florida | 12045 | 1744 | 34 |
995427 | 995427 | 2021-02-04 | Gulf | Florida | 12045 | 1734 | 34 |
992181 | 992181 | 2021-02-03 | Gulf | Florida | 12045 | 1726 | 34 |
982481 | 982481 | 2021-01-31 | Taylor | Florida | 12123 | 2491 | 34 |
982487 | 982487 | 2021-01-31 | Washington | Florida | 12133 | 2462 | 34 |
979202 | 979202 | 2021-01-30 | Holmes | Florida | 12059 | 2072 | 34 |
979235 | 979235 | 2021-01-30 | Taylor | Florida | 12123 | 2484 | 34 |
975957 | 975957 | 2021-01-29 | Holmes | Florida | 12059 | 2057 | 34 |
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);