ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
211 rows where deaths = 43 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 |
---|---|---|---|---|---|---|---|
1774720 | 1774720 | 2021-10-02 | Hamilton | Florida | 12047 | 2671 | 43 |
1771470 | 1771470 | 2021-10-01 | Hamilton | Florida | 12047 | 2671 | 43 |
1768221 | 1768221 | 2021-09-30 | Hamilton | Florida | 12047 | 2644 | 43 |
1764972 | 1764972 | 2021-09-29 | Hamilton | Florida | 12047 | 2644 | 43 |
1761723 | 1761723 | 2021-09-28 | Hamilton | Florida | 12047 | 2644 | 43 |
1758475 | 1758475 | 2021-09-27 | Hamilton | Florida | 12047 | 2644 | 43 |
1755227 | 1755227 | 2021-09-26 | Hamilton | Florida | 12047 | 2644 | 43 |
1751979 | 1751979 | 2021-09-25 | Hamilton | Florida | 12047 | 2644 | 43 |
1313598 | 1313598 | 2021-05-13 | Gulf | Florida | 12045 | 1970 | 43 |
1310351 | 1310351 | 2021-05-12 | Gulf | Florida | 12045 | 1968 | 43 |
1307105 | 1307105 | 2021-05-11 | Gulf | Florida | 12045 | 1968 | 43 |
1303859 | 1303859 | 2021-05-10 | Gulf | Florida | 12045 | 1966 | 43 |
1297367 | 1297367 | 2021-05-08 | Hardee | Florida | 12049 | 3156 | 43 |
1294119 | 1294119 | 2021-05-07 | Gulf | Florida | 12045 | 1966 | 43 |
1294121 | 1294121 | 2021-05-07 | Hardee | Florida | 12049 | 3145 | 43 |
1290871 | 1290871 | 2021-05-06 | Gilchrist | Florida | 12041 | 1612 | 43 |
1290873 | 1290873 | 2021-05-06 | Gulf | Florida | 12045 | 1965 | 43 |
1290875 | 1290875 | 2021-05-06 | Hardee | Florida | 12049 | 3134 | 43 |
1287625 | 1287625 | 2021-05-05 | Gilchrist | Florida | 12041 | 1610 | 43 |
1287627 | 1287627 | 2021-05-05 | Gulf | Florida | 12045 | 1960 | 43 |
1287629 | 1287629 | 2021-05-05 | Hardee | Florida | 12049 | 3132 | 43 |
1284379 | 1284379 | 2021-05-04 | Gilchrist | Florida | 12041 | 1607 | 43 |
1284383 | 1284383 | 2021-05-04 | Hardee | Florida | 12049 | 3125 | 43 |
1281119 | 1281119 | 2021-05-03 | Calhoun | Florida | 12013 | 1688 | 43 |
1281132 | 1281132 | 2021-05-03 | Gilchrist | Florida | 12041 | 1605 | 43 |
1281136 | 1281136 | 2021-05-03 | Hardee | Florida | 12049 | 3123 | 43 |
1277872 | 1277872 | 2021-05-02 | Calhoun | Florida | 12013 | 1688 | 43 |
1277885 | 1277885 | 2021-05-02 | Gilchrist | Florida | 12041 | 1605 | 43 |
1277889 | 1277889 | 2021-05-02 | Hardee | Florida | 12049 | 3122 | 43 |
1274625 | 1274625 | 2021-05-01 | Calhoun | Florida | 12013 | 1688 | 43 |
1274638 | 1274638 | 2021-05-01 | Gilchrist | Florida | 12041 | 1604 | 43 |
1274642 | 1274642 | 2021-05-01 | Hardee | Florida | 12049 | 3117 | 43 |
1271378 | 1271378 | 2021-04-30 | Calhoun | Florida | 12013 | 1688 | 43 |
1271391 | 1271391 | 2021-04-30 | Gilchrist | Florida | 12041 | 1601 | 43 |
1268131 | 1268131 | 2021-04-29 | Calhoun | Florida | 12013 | 1688 | 43 |
1268144 | 1268144 | 2021-04-29 | Gilchrist | Florida | 12041 | 1599 | 43 |
1264884 | 1264884 | 2021-04-28 | Calhoun | Florida | 12013 | 1686 | 43 |
1264897 | 1264897 | 2021-04-28 | Gilchrist | Florida | 12041 | 1599 | 43 |
1261637 | 1261637 | 2021-04-27 | Calhoun | Florida | 12013 | 1686 | 43 |
1261650 | 1261650 | 2021-04-27 | Gilchrist | Florida | 12041 | 1592 | 43 |
1258390 | 1258390 | 2021-04-26 | Calhoun | Florida | 12013 | 1686 | 43 |
1258403 | 1258403 | 2021-04-26 | Gilchrist | Florida | 12041 | 1589 | 43 |
1258405 | 1258405 | 2021-04-26 | Gulf | Florida | 12045 | 1947 | 43 |
1255143 | 1255143 | 2021-04-25 | Calhoun | Florida | 12013 | 1686 | 43 |
1255156 | 1255156 | 2021-04-25 | Gilchrist | Florida | 12041 | 1588 | 43 |
1255158 | 1255158 | 2021-04-25 | Gulf | Florida | 12045 | 1947 | 43 |
1251896 | 1251896 | 2021-04-24 | Calhoun | Florida | 12013 | 1686 | 43 |
1251909 | 1251909 | 2021-04-24 | Gilchrist | Florida | 12041 | 1589 | 43 |
1251911 | 1251911 | 2021-04-24 | Gulf | Florida | 12045 | 1946 | 43 |
1248649 | 1248649 | 2021-04-23 | Calhoun | Florida | 12013 | 1682 | 43 |
1248662 | 1248662 | 2021-04-23 | Gilchrist | Florida | 12041 | 1588 | 43 |
1248664 | 1248664 | 2021-04-23 | Gulf | Florida | 12045 | 1945 | 43 |
1245402 | 1245402 | 2021-04-22 | Calhoun | Florida | 12013 | 1680 | 43 |
1245415 | 1245415 | 2021-04-22 | Gilchrist | Florida | 12041 | 1583 | 43 |
1245417 | 1245417 | 2021-04-22 | Gulf | Florida | 12045 | 1936 | 43 |
1242155 | 1242155 | 2021-04-21 | Calhoun | Florida | 12013 | 1676 | 43 |
1242168 | 1242168 | 2021-04-21 | Gilchrist | Florida | 12041 | 1577 | 43 |
1242170 | 1242170 | 2021-04-21 | Gulf | Florida | 12045 | 1934 | 43 |
1238908 | 1238908 | 2021-04-20 | Calhoun | Florida | 12013 | 1673 | 43 |
1238921 | 1238921 | 2021-04-20 | Gilchrist | Florida | 12041 | 1573 | 43 |
1235661 | 1235661 | 2021-04-19 | Calhoun | Florida | 12013 | 1673 | 43 |
1235674 | 1235674 | 2021-04-19 | Gilchrist | Florida | 12041 | 1568 | 43 |
1232414 | 1232414 | 2021-04-18 | Calhoun | Florida | 12013 | 1673 | 43 |
1232427 | 1232427 | 2021-04-18 | Gilchrist | Florida | 12041 | 1565 | 43 |
1229165 | 1229165 | 2021-04-17 | Calhoun | Florida | 12013 | 1671 | 43 |
1225917 | 1225917 | 2021-04-16 | Calhoun | Florida | 12013 | 1671 | 43 |
1222670 | 1222670 | 2021-04-15 | Calhoun | Florida | 12013 | 1668 | 43 |
1219422 | 1219422 | 2021-04-14 | Calhoun | Florida | 12013 | 1665 | 43 |
1216174 | 1216174 | 2021-04-13 | Calhoun | Florida | 12013 | 1665 | 43 |
1212927 | 1212927 | 2021-04-12 | Calhoun | Florida | 12013 | 1666 | 43 |
1209679 | 1209679 | 2021-04-11 | Calhoun | Florida | 12013 | 1666 | 43 |
1173982 | 1173982 | 2021-03-31 | Levy | Florida | 12075 | 3094 | 43 |
1170735 | 1170735 | 2021-03-30 | Levy | Florida | 12075 | 3083 | 43 |
1167487 | 1167487 | 2021-03-29 | Levy | Florida | 12075 | 3077 | 43 |
1164239 | 1164239 | 2021-03-28 | Levy | Florida | 12075 | 3070 | 43 |
1164241 | 1164241 | 2021-03-28 | Madison | Florida | 12079 | 2030 | 43 |
1160991 | 1160991 | 2021-03-27 | Levy | Florida | 12075 | 3067 | 43 |
1160993 | 1160993 | 2021-03-27 | Madison | Florida | 12079 | 2030 | 43 |
1157743 | 1157743 | 2021-03-26 | Levy | Florida | 12075 | 3058 | 43 |
1157745 | 1157745 | 2021-03-26 | Madison | Florida | 12079 | 2030 | 43 |
1154496 | 1154496 | 2021-03-25 | Levy | Florida | 12075 | 3053 | 43 |
1154498 | 1154498 | 2021-03-25 | Madison | Florida | 12079 | 2030 | 43 |
1151249 | 1151249 | 2021-03-24 | Levy | Florida | 12075 | 3051 | 43 |
1151251 | 1151251 | 2021-03-24 | Madison | Florida | 12079 | 2029 | 43 |
1148002 | 1148002 | 2021-03-23 | Levy | Florida | 12075 | 3042 | 43 |
1148004 | 1148004 | 2021-03-23 | Madison | Florida | 12079 | 2029 | 43 |
1144755 | 1144755 | 2021-03-22 | Levy | Florida | 12075 | 3039 | 43 |
1144757 | 1144757 | 2021-03-22 | Madison | Florida | 12079 | 2029 | 43 |
1141508 | 1141508 | 2021-03-21 | Levy | Florida | 12075 | 3037 | 43 |
1141510 | 1141510 | 2021-03-21 | Madison | Florida | 12079 | 2029 | 43 |
1138262 | 1138262 | 2021-03-20 | Levy | Florida | 12075 | 3034 | 43 |
1138264 | 1138264 | 2021-03-20 | Madison | Florida | 12079 | 2028 | 43 |
1138287 | 1138287 | 2021-03-20 | Taylor | Florida | 12123 | 2688 | 43 |
1135016 | 1135016 | 2021-03-19 | Levy | Florida | 12075 | 3029 | 43 |
1135018 | 1135018 | 2021-03-19 | Madison | Florida | 12079 | 2028 | 43 |
1135041 | 1135041 | 2021-03-19 | Taylor | Florida | 12123 | 2687 | 43 |
1131769 | 1131769 | 2021-03-18 | Levy | Florida | 12075 | 3027 | 43 |
1131771 | 1131771 | 2021-03-18 | Madison | Florida | 12079 | 2028 | 43 |
1131794 | 1131794 | 2021-03-18 | Taylor | Florida | 12123 | 2686 | 43 |
1128521 | 1128521 | 2021-03-17 | Levy | Florida | 12075 | 3018 | 43 |
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);