ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
201 rows where deaths = 42 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 |
---|---|---|---|---|---|---|---|
1284381 | 1284381 | 2021-05-04 | Gulf | Florida | 12045 | 1960 | 42 |
1281134 | 1281134 | 2021-05-03 | Gulf | Florida | 12045 | 1958 | 42 |
1277887 | 1277887 | 2021-05-02 | Gulf | Florida | 12045 | 1956 | 42 |
1274640 | 1274640 | 2021-05-01 | Gulf | Florida | 12045 | 1954 | 42 |
1271393 | 1271393 | 2021-04-30 | Gulf | Florida | 12045 | 1954 | 42 |
1271395 | 1271395 | 2021-04-30 | Hardee | Florida | 12049 | 3111 | 42 |
1268146 | 1268146 | 2021-04-29 | Gulf | Florida | 12045 | 1951 | 42 |
1268148 | 1268148 | 2021-04-29 | Hardee | Florida | 12049 | 3102 | 42 |
1264899 | 1264899 | 2021-04-28 | Gulf | Florida | 12045 | 1950 | 42 |
1264901 | 1264901 | 2021-04-28 | Hardee | Florida | 12049 | 3097 | 42 |
1261652 | 1261652 | 2021-04-27 | Gulf | Florida | 12045 | 1949 | 42 |
1261654 | 1261654 | 2021-04-27 | Hardee | Florida | 12049 | 3083 | 42 |
1258407 | 1258407 | 2021-04-26 | Hardee | Florida | 12049 | 3080 | 42 |
1255160 | 1255160 | 2021-04-25 | Hardee | Florida | 12049 | 3071 | 42 |
1251913 | 1251913 | 2021-04-24 | Hardee | Florida | 12049 | 3063 | 42 |
1248666 | 1248666 | 2021-04-23 | Hardee | Florida | 12049 | 3051 | 42 |
1245419 | 1245419 | 2021-04-22 | Hardee | Florida | 12049 | 3043 | 42 |
1242172 | 1242172 | 2021-04-21 | Hardee | Florida | 12049 | 3032 | 42 |
1238923 | 1238923 | 2021-04-20 | Gulf | Florida | 12045 | 1931 | 42 |
1238925 | 1238925 | 2021-04-20 | Hardee | Florida | 12049 | 3029 | 42 |
1235676 | 1235676 | 2021-04-19 | Gulf | Florida | 12045 | 1930 | 42 |
1235678 | 1235678 | 2021-04-19 | Hardee | Florida | 12049 | 3020 | 42 |
1232429 | 1232429 | 2021-04-18 | Gulf | Florida | 12045 | 1928 | 42 |
1232431 | 1232431 | 2021-04-18 | Hardee | Florida | 12049 | 3015 | 42 |
1229178 | 1229178 | 2021-04-17 | Gilchrist | Florida | 12041 | 1560 | 42 |
1229180 | 1229180 | 2021-04-17 | Gulf | Florida | 12045 | 1928 | 42 |
1229182 | 1229182 | 2021-04-17 | Hardee | Florida | 12049 | 3007 | 42 |
1225932 | 1225932 | 2021-04-16 | Gulf | Florida | 12045 | 1928 | 42 |
1225934 | 1225934 | 2021-04-16 | Hardee | Florida | 12049 | 2995 | 42 |
1222685 | 1222685 | 2021-04-15 | Gulf | Florida | 12045 | 1927 | 42 |
1222687 | 1222687 | 2021-04-15 | Hardee | Florida | 12049 | 2986 | 42 |
1219437 | 1219437 | 2021-04-14 | Gulf | Florida | 12045 | 1926 | 42 |
1219439 | 1219439 | 2021-04-14 | Hardee | Florida | 12049 | 2980 | 42 |
1216189 | 1216189 | 2021-04-13 | Gulf | Florida | 12045 | 1925 | 42 |
1216191 | 1216191 | 2021-04-13 | Hardee | Florida | 12049 | 2977 | 42 |
1212942 | 1212942 | 2021-04-12 | Gulf | Florida | 12045 | 1925 | 42 |
1212944 | 1212944 | 2021-04-12 | Hardee | Florida | 12049 | 2970 | 42 |
1209694 | 1209694 | 2021-04-11 | Gulf | Florida | 12045 | 1925 | 42 |
1209696 | 1209696 | 2021-04-11 | Hardee | Florida | 12049 | 2969 | 42 |
1206445 | 1206445 | 2021-04-10 | Gulf | Florida | 12045 | 1924 | 42 |
1206447 | 1206447 | 2021-04-10 | Hardee | Florida | 12049 | 2962 | 42 |
1203197 | 1203197 | 2021-04-09 | Gulf | Florida | 12045 | 1924 | 42 |
1203199 | 1203199 | 2021-04-09 | Hardee | Florida | 12049 | 2955 | 42 |
1199934 | 1199934 | 2021-04-08 | Calhoun | Florida | 12013 | 1666 | 42 |
1199949 | 1199949 | 2021-04-08 | Gulf | Florida | 12045 | 1923 | 42 |
1196685 | 1196685 | 2021-04-07 | Calhoun | Florida | 12013 | 1663 | 42 |
1196700 | 1196700 | 2021-04-07 | Gulf | Florida | 12045 | 1922 | 42 |
1193437 | 1193437 | 2021-04-06 | Calhoun | Florida | 12013 | 1663 | 42 |
1193452 | 1193452 | 2021-04-06 | Gulf | Florida | 12045 | 1921 | 42 |
1190187 | 1190187 | 2021-04-05 | Calhoun | Florida | 12013 | 1663 | 42 |
1190202 | 1190202 | 2021-04-05 | Gulf | Florida | 12045 | 1919 | 42 |
1186940 | 1186940 | 2021-04-04 | Calhoun | Florida | 12013 | 1663 | 42 |
1186955 | 1186955 | 2021-04-04 | Gulf | Florida | 12045 | 1920 | 42 |
1183693 | 1183693 | 2021-04-03 | Calhoun | Florida | 12013 | 1662 | 42 |
1183708 | 1183708 | 2021-04-03 | Gulf | Florida | 12045 | 1920 | 42 |
1180446 | 1180446 | 2021-04-02 | Calhoun | Florida | 12013 | 1661 | 42 |
1180461 | 1180461 | 2021-04-02 | Gulf | Florida | 12045 | 1918 | 42 |
1177199 | 1177199 | 2021-04-01 | Calhoun | Florida | 12013 | 1660 | 42 |
1177214 | 1177214 | 2021-04-01 | Gulf | Florida | 12045 | 1917 | 42 |
1173952 | 1173952 | 2021-03-31 | Calhoun | Florida | 12013 | 1658 | 42 |
1173967 | 1173967 | 2021-03-31 | Gulf | Florida | 12045 | 1916 | 42 |
1170705 | 1170705 | 2021-03-30 | Calhoun | Florida | 12013 | 1656 | 42 |
1170720 | 1170720 | 2021-03-30 | Gulf | Florida | 12045 | 1914 | 42 |
1167457 | 1167457 | 2021-03-29 | Calhoun | Florida | 12013 | 1655 | 42 |
1164209 | 1164209 | 2021-03-28 | Calhoun | Florida | 12013 | 1655 | 42 |
1160961 | 1160961 | 2021-03-27 | Calhoun | Florida | 12013 | 1653 | 42 |
1157713 | 1157713 | 2021-03-26 | Calhoun | Florida | 12013 | 1653 | 42 |
1154466 | 1154466 | 2021-03-25 | Calhoun | Florida | 12013 | 1647 | 42 |
1151219 | 1151219 | 2021-03-24 | Calhoun | Florida | 12013 | 1647 | 42 |
1147972 | 1147972 | 2021-03-23 | Calhoun | Florida | 12013 | 1647 | 42 |
1144725 | 1144725 | 2021-03-22 | Calhoun | Florida | 12013 | 1647 | 42 |
1141478 | 1141478 | 2021-03-21 | Calhoun | Florida | 12013 | 1647 | 42 |
1138232 | 1138232 | 2021-03-20 | Calhoun | Florida | 12013 | 1647 | 42 |
1134986 | 1134986 | 2021-03-19 | Calhoun | Florida | 12013 | 1647 | 42 |
1131739 | 1131739 | 2021-03-18 | Calhoun | Florida | 12013 | 1645 | 42 |
1128491 | 1128491 | 2021-03-17 | Calhoun | Florida | 12013 | 1643 | 42 |
1125245 | 1125245 | 2021-03-16 | Calhoun | Florida | 12013 | 1643 | 42 |
1121999 | 1121999 | 2021-03-15 | Calhoun | Florida | 12013 | 1644 | 42 |
1118752 | 1118752 | 2021-03-14 | Calhoun | Florida | 12013 | 1642 | 42 |
1118807 | 1118807 | 2021-03-14 | Taylor | Florida | 12123 | 2678 | 42 |
1115505 | 1115505 | 2021-03-13 | Calhoun | Florida | 12013 | 1642 | 42 |
1115560 | 1115560 | 2021-03-13 | Taylor | Florida | 12123 | 2678 | 42 |
1112259 | 1112259 | 2021-03-12 | Calhoun | Florida | 12013 | 1642 | 42 |
1112314 | 1112314 | 2021-03-12 | Taylor | Florida | 12123 | 2676 | 42 |
1109013 | 1109013 | 2021-03-11 | Calhoun | Florida | 12013 | 1636 | 42 |
1109068 | 1109068 | 2021-03-11 | Taylor | Florida | 12123 | 2673 | 42 |
1105767 | 1105767 | 2021-03-10 | Calhoun | Florida | 12013 | 1631 | 42 |
1105822 | 1105822 | 2021-03-10 | Taylor | Florida | 12123 | 2666 | 42 |
1102521 | 1102521 | 2021-03-09 | Calhoun | Florida | 12013 | 1626 | 42 |
1102576 | 1102576 | 2021-03-09 | Taylor | Florida | 12123 | 2664 | 42 |
1099330 | 1099330 | 2021-03-08 | Taylor | Florida | 12123 | 2658 | 42 |
1096082 | 1096082 | 2021-03-07 | Taylor | Florida | 12123 | 2658 | 42 |
1092836 | 1092836 | 2021-03-06 | Taylor | Florida | 12123 | 2658 | 42 |
1089590 | 1089590 | 2021-03-05 | Taylor | Florida | 12123 | 2653 | 42 |
1086345 | 1086345 | 2021-03-04 | Taylor | Florida | 12123 | 2651 | 42 |
1083099 | 1083099 | 2021-03-03 | Taylor | Florida | 12123 | 2646 | 42 |
1079853 | 1079853 | 2021-03-02 | Taylor | Florida | 12123 | 2645 | 42 |
1076608 | 1076608 | 2021-03-01 | Taylor | Florida | 12123 | 2642 | 42 |
1073362 | 1073362 | 2021-02-28 | Taylor | Florida | 12123 | 2640 | 42 |
1070093 | 1070093 | 2021-02-27 | Madison | Florida | 12079 | 1988 | 42 |
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);