ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
249 rows where deaths = 22 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Dixie 24
- Jefferson 23
- Monroe 19
- Bradford 16
- Calhoun 14
- Levy 14
- DeSoto 12
- Walton 12
- Lafayette 11
- Hardee 9
- Suwannee 9
- Lake 6
- Hamilton 5
- Taylor 5
- Unknown 5
- Washington 5
- Hendry 4
- Highlands 4
- Holmes 4
- Santa Rosa 4
- Clay 3
- Indian River 3
- Nassau 3
- Okeechobee 3
- Orange 3
- St. Lucie 3
- Hernando 2
- Madison 2
- Martin 2
- Osceola 2
- …
state 1
- Florida · 249 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1881983 | 1881983 | 2021-11-04 | Unknown | Florida | 8735 | 22 | |
1878734 | 1878734 | 2021-11-03 | Unknown | Florida | 7166 | 22 | |
1875485 | 1875485 | 2021-11-02 | Unknown | Florida | 5362 | 22 | |
1872236 | 1872236 | 2021-11-01 | Unknown | Florida | 3362 | 22 | |
1868987 | 1868987 | 2021-10-31 | Unknown | Florida | 1668 | 22 | |
1196692 | 1196692 | 2021-04-07 | Dixie | Florida | 12029 | 1557 | 22 |
1193444 | 1193444 | 2021-04-06 | Dixie | Florida | 12029 | 1557 | 22 |
1190194 | 1190194 | 2021-04-05 | Dixie | Florida | 12029 | 1556 | 22 |
1186947 | 1186947 | 2021-04-04 | Dixie | Florida | 12029 | 1556 | 22 |
1183700 | 1183700 | 2021-04-03 | Dixie | Florida | 12029 | 1556 | 22 |
1180453 | 1180453 | 2021-04-02 | Dixie | Florida | 12029 | 1556 | 22 |
1177206 | 1177206 | 2021-04-01 | Dixie | Florida | 12029 | 1555 | 22 |
1173959 | 1173959 | 2021-03-31 | Dixie | Florida | 12029 | 1553 | 22 |
1170712 | 1170712 | 2021-03-30 | Dixie | Florida | 12029 | 1553 | 22 |
1141485 | 1141485 | 2021-03-21 | Dixie | Florida | 12029 | 1537 | 22 |
1138239 | 1138239 | 2021-03-20 | Dixie | Florida | 12029 | 1537 | 22 |
1134993 | 1134993 | 2021-03-19 | Dixie | Florida | 12029 | 1536 | 22 |
1131746 | 1131746 | 2021-03-18 | Dixie | Florida | 12029 | 1536 | 22 |
1128498 | 1128498 | 2021-03-17 | Dixie | Florida | 12029 | 1534 | 22 |
1125252 | 1125252 | 2021-03-16 | Dixie | Florida | 12029 | 1531 | 22 |
1122006 | 1122006 | 2021-03-15 | Dixie | Florida | 12029 | 1529 | 22 |
1118759 | 1118759 | 2021-03-14 | Dixie | Florida | 12029 | 1528 | 22 |
1115512 | 1115512 | 2021-03-13 | Dixie | Florida | 12029 | 1527 | 22 |
1112266 | 1112266 | 2021-03-12 | Dixie | Florida | 12029 | 1522 | 22 |
1109020 | 1109020 | 2021-03-11 | Dixie | Florida | 12029 | 1520 | 22 |
1105774 | 1105774 | 2021-03-10 | Dixie | Florida | 12029 | 1519 | 22 |
1102528 | 1102528 | 2021-03-09 | Dixie | Florida | 12029 | 1518 | 22 |
1099282 | 1099282 | 2021-03-08 | Dixie | Florida | 12029 | 1514 | 22 |
1099291 | 1099291 | 2021-03-08 | Hamilton | Florida | 12047 | 1572 | 22 |
1096034 | 1096034 | 2021-03-07 | Dixie | Florida | 12029 | 1513 | 22 |
1096043 | 1096043 | 2021-03-07 | Hamilton | Florida | 12047 | 1572 | 22 |
1092797 | 1092797 | 2021-03-06 | Hamilton | Florida | 12047 | 1572 | 22 |
1089551 | 1089551 | 2021-03-05 | Hamilton | Florida | 12047 | 1572 | 22 |
1086306 | 1086306 | 2021-03-04 | Hamilton | Florida | 12047 | 1571 | 22 |
1050612 | 1050612 | 2021-02-21 | Jefferson | Florida | 12065 | 1390 | 22 |
1047365 | 1047365 | 2021-02-20 | Jefferson | Florida | 12065 | 1390 | 22 |
1044120 | 1044120 | 2021-02-19 | Jefferson | Florida | 12065 | 1385 | 22 |
1040875 | 1040875 | 2021-02-18 | Jefferson | Florida | 12065 | 1380 | 22 |
1037630 | 1037630 | 2021-02-17 | Jefferson | Florida | 12065 | 1380 | 22 |
1034385 | 1034385 | 2021-02-16 | Jefferson | Florida | 12065 | 1378 | 22 |
1031139 | 1031139 | 2021-02-15 | Jefferson | Florida | 12065 | 1373 | 22 |
1027892 | 1027892 | 2021-02-14 | Jefferson | Florida | 12065 | 1372 | 22 |
1024647 | 1024647 | 2021-02-13 | Jefferson | Florida | 12065 | 1369 | 22 |
1021402 | 1021402 | 2021-02-12 | Jefferson | Florida | 12065 | 1365 | 22 |
1018157 | 1018157 | 2021-02-11 | Jefferson | Florida | 12065 | 1362 | 22 |
1014912 | 1014912 | 2021-02-10 | Jefferson | Florida | 12065 | 1351 | 22 |
1011667 | 1011667 | 2021-02-09 | Jefferson | Florida | 12065 | 1346 | 22 |
1008421 | 1008421 | 2021-02-08 | Jefferson | Florida | 12065 | 1341 | 22 |
1005175 | 1005175 | 2021-02-07 | Jefferson | Florida | 12065 | 1341 | 22 |
1001929 | 1001929 | 2021-02-06 | Jefferson | Florida | 12065 | 1334 | 22 |
998683 | 998683 | 2021-02-05 | Jefferson | Florida | 12065 | 1326 | 22 |
995437 | 995437 | 2021-02-04 | Jefferson | Florida | 12065 | 1321 | 22 |
992191 | 992191 | 2021-02-03 | Jefferson | Florida | 12065 | 1315 | 22 |
988945 | 988945 | 2021-02-02 | Jefferson | Florida | 12065 | 1307 | 22 |
985698 | 985698 | 2021-02-01 | Jefferson | Florida | 12065 | 1297 | 22 |
982451 | 982451 | 2021-01-31 | Jefferson | Florida | 12065 | 1296 | 22 |
979205 | 979205 | 2021-01-30 | Jefferson | Florida | 12065 | 1285 | 22 |
959728 | 959728 | 2021-01-24 | Hardee | Florida | 12049 | 2496 | 22 |
956482 | 956482 | 2021-01-23 | Hardee | Florida | 12049 | 2487 | 22 |
956495 | 956495 | 2021-01-23 | Levy | Florida | 12075 | 2432 | 22 |
953237 | 953237 | 2021-01-22 | Hardee | Florida | 12049 | 2472 | 22 |
953250 | 953250 | 2021-01-22 | Levy | Florida | 12075 | 2397 | 22 |
949992 | 949992 | 2021-01-21 | Hardee | Florida | 12049 | 2456 | 22 |
950005 | 950005 | 2021-01-21 | Levy | Florida | 12075 | 2375 | 22 |
946746 | 946746 | 2021-01-20 | Hardee | Florida | 12049 | 2442 | 22 |
946759 | 946759 | 2021-01-20 | Levy | Florida | 12075 | 2359 | 22 |
943499 | 943499 | 2021-01-19 | Hardee | Florida | 12049 | 2417 | 22 |
943512 | 943512 | 2021-01-19 | Levy | Florida | 12075 | 2350 | 22 |
940254 | 940254 | 2021-01-18 | Hardee | Florida | 12049 | 2410 | 22 |
940267 | 940267 | 2021-01-18 | Levy | Florida | 12075 | 2337 | 22 |
937009 | 937009 | 2021-01-17 | Hardee | Florida | 12049 | 2403 | 22 |
937022 | 937022 | 2021-01-17 | Levy | Florida | 12075 | 2329 | 22 |
933764 | 933764 | 2021-01-16 | Hardee | Florida | 12049 | 2387 | 22 |
933777 | 933777 | 2021-01-16 | Levy | Florida | 12075 | 2311 | 22 |
930532 | 930532 | 2021-01-15 | Levy | Florida | 12075 | 2288 | 22 |
927283 | 927283 | 2021-01-14 | Lafayette | Florida | 12067 | 1476 | 22 |
927287 | 927287 | 2021-01-14 | Levy | Florida | 12075 | 2248 | 22 |
924037 | 924037 | 2021-01-13 | Lafayette | Florida | 12067 | 1474 | 22 |
924041 | 924041 | 2021-01-13 | Levy | Florida | 12075 | 2219 | 22 |
920792 | 920792 | 2021-01-12 | Lafayette | Florida | 12067 | 1471 | 22 |
920796 | 920796 | 2021-01-12 | Levy | Florida | 12075 | 2188 | 22 |
917547 | 917547 | 2021-01-11 | Lafayette | Florida | 12067 | 1466 | 22 |
917551 | 917551 | 2021-01-11 | Levy | Florida | 12075 | 2165 | 22 |
914306 | 914306 | 2021-01-10 | Levy | Florida | 12075 | 2155 | 22 |
894831 | 894831 | 2021-01-04 | Lafayette | Florida | 12067 | 1437 | 22 |
891584 | 891584 | 2021-01-03 | Lafayette | Florida | 12067 | 1436 | 22 |
888337 | 888337 | 2021-01-02 | Lafayette | Florida | 12067 | 1434 | 22 |
885092 | 885092 | 2021-01-01 | Lafayette | Florida | 12067 | 1422 | 22 |
881847 | 881847 | 2020-12-31 | Lafayette | Florida | 12067 | 1422 | 22 |
878602 | 878602 | 2020-12-30 | Lafayette | Florida | 12067 | 1418 | 22 |
875357 | 875357 | 2020-12-29 | Lafayette | Florida | 12067 | 1418 | 22 |
875390 | 875390 | 2020-12-29 | Wakulla | Florida | 12129 | 2051 | 22 |
868854 | 868854 | 2020-12-27 | Gilchrist | Florida | 12041 | 977 | 22 |
865618 | 865618 | 2020-12-26 | Holmes | Florida | 12059 | 1583 | 22 |
862348 | 862348 | 2020-12-25 | Bradford | Florida | 12007 | 2056 | 22 |
862373 | 862373 | 2020-12-25 | Holmes | Florida | 12059 | 1568 | 22 |
859103 | 859103 | 2020-12-24 | Bradford | Florida | 12007 | 2056 | 22 |
859128 | 859128 | 2020-12-24 | Holmes | Florida | 12059 | 1568 | 22 |
855858 | 855858 | 2020-12-23 | Bradford | Florida | 12007 | 2027 | 22 |
855883 | 855883 | 2020-12-23 | Holmes | Florida | 12059 | 1518 | 22 |
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);