ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
187 rows where deaths = 27 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 |
---|---|---|---|---|---|---|---|
2285122 | 2285122 | 2022-03-08 | Liberty | Florida | 12077 | 2494 | 27 |
2281870 | 2281870 | 2022-03-07 | Liberty | Florida | 12077 | 2494 | 27 |
2278617 | 2278617 | 2022-03-06 | Liberty | Florida | 12077 | 2494 | 27 |
2275364 | 2275364 | 2022-03-05 | Liberty | Florida | 12077 | 2494 | 27 |
2272111 | 2272111 | 2022-03-04 | Liberty | Florida | 12077 | 2494 | 27 |
2268859 | 2268859 | 2022-03-03 | Liberty | Florida | 12077 | 2494 | 27 |
2265606 | 2265606 | 2022-03-02 | Liberty | Florida | 12077 | 2494 | 27 |
1865695 | 1865695 | 2021-10-30 | Glades | Florida | 12043 | 1445 | 27 |
1862446 | 1862446 | 2021-10-29 | Glades | Florida | 12043 | 1445 | 27 |
1859197 | 1859197 | 2021-10-28 | Glades | Florida | 12043 | 1434 | 27 |
1855948 | 1855948 | 2021-10-27 | Glades | Florida | 12043 | 1434 | 27 |
1852699 | 1852699 | 2021-10-26 | Glades | Florida | 12043 | 1434 | 27 |
1849450 | 1849450 | 2021-10-25 | Glades | Florida | 12043 | 1434 | 27 |
1320102 | 1320102 | 2021-05-15 | Jefferson | Florida | 12065 | 1497 | 27 |
1316855 | 1316855 | 2021-05-14 | Jefferson | Florida | 12065 | 1497 | 27 |
1313608 | 1313608 | 2021-05-13 | Jefferson | Florida | 12065 | 1496 | 27 |
1310361 | 1310361 | 2021-05-12 | Jefferson | Florida | 12065 | 1495 | 27 |
1307115 | 1307115 | 2021-05-11 | Jefferson | Florida | 12065 | 1494 | 27 |
1303869 | 1303869 | 2021-05-10 | Jefferson | Florida | 12065 | 1494 | 27 |
1300622 | 1300622 | 2021-05-09 | Jefferson | Florida | 12065 | 1492 | 27 |
1297375 | 1297375 | 2021-05-08 | Jefferson | Florida | 12065 | 1491 | 27 |
1294129 | 1294129 | 2021-05-07 | Jefferson | Florida | 12065 | 1491 | 27 |
1290883 | 1290883 | 2021-05-06 | Jefferson | Florida | 12065 | 1491 | 27 |
1287637 | 1287637 | 2021-05-05 | Jefferson | Florida | 12065 | 1490 | 27 |
1284391 | 1284391 | 2021-05-04 | Jefferson | Florida | 12065 | 1490 | 27 |
1281144 | 1281144 | 2021-05-03 | Jefferson | Florida | 12065 | 1490 | 27 |
1277897 | 1277897 | 2021-05-02 | Jefferson | Florida | 12065 | 1490 | 27 |
1274650 | 1274650 | 2021-05-01 | Jefferson | Florida | 12065 | 1485 | 27 |
1271403 | 1271403 | 2021-04-30 | Jefferson | Florida | 12065 | 1485 | 27 |
1268156 | 1268156 | 2021-04-29 | Jefferson | Florida | 12065 | 1480 | 27 |
1264909 | 1264909 | 2021-04-28 | Jefferson | Florida | 12065 | 1479 | 27 |
1261662 | 1261662 | 2021-04-27 | Jefferson | Florida | 12065 | 1478 | 27 |
1258415 | 1258415 | 2021-04-26 | Jefferson | Florida | 12065 | 1474 | 27 |
1255168 | 1255168 | 2021-04-25 | Jefferson | Florida | 12065 | 1473 | 27 |
1251921 | 1251921 | 2021-04-24 | Jefferson | Florida | 12065 | 1473 | 27 |
1248674 | 1248674 | 2021-04-23 | Jefferson | Florida | 12065 | 1471 | 27 |
1245427 | 1245427 | 2021-04-22 | Jefferson | Florida | 12065 | 1467 | 27 |
1242180 | 1242180 | 2021-04-21 | Jefferson | Florida | 12065 | 1463 | 27 |
1238933 | 1238933 | 2021-04-20 | Jefferson | Florida | 12065 | 1458 | 27 |
1235686 | 1235686 | 2021-04-19 | Jefferson | Florida | 12065 | 1455 | 27 |
1232439 | 1232439 | 2021-04-18 | Jefferson | Florida | 12065 | 1455 | 27 |
1229190 | 1229190 | 2021-04-17 | Jefferson | Florida | 12065 | 1453 | 27 |
1225942 | 1225942 | 2021-04-16 | Jefferson | Florida | 12065 | 1448 | 27 |
1222695 | 1222695 | 2021-04-15 | Jefferson | Florida | 12065 | 1445 | 27 |
1219447 | 1219447 | 2021-04-14 | Jefferson | Florida | 12065 | 1444 | 27 |
1216199 | 1216199 | 2021-04-13 | Jefferson | Florida | 12065 | 1442 | 27 |
1212952 | 1212952 | 2021-04-12 | Jefferson | Florida | 12065 | 1436 | 27 |
1209704 | 1209704 | 2021-04-11 | Jefferson | Florida | 12065 | 1436 | 27 |
1206455 | 1206455 | 2021-04-10 | Jefferson | Florida | 12065 | 1436 | 27 |
1203207 | 1203207 | 2021-04-09 | Jefferson | Florida | 12065 | 1434 | 27 |
1027897 | 1027897 | 2021-02-14 | Levy | Florida | 12075 | 2750 | 27 |
933760 | 933760 | 2021-01-16 | Gilchrist | Florida | 12041 | 1124 | 27 |
930515 | 930515 | 2021-01-15 | Gilchrist | Florida | 12041 | 1116 | 27 |
927270 | 927270 | 2021-01-14 | Gilchrist | Florida | 12041 | 1107 | 27 |
924024 | 924024 | 2021-01-13 | Gilchrist | Florida | 12041 | 1102 | 27 |
920779 | 920779 | 2021-01-12 | Gilchrist | Florida | 12041 | 1100 | 27 |
917534 | 917534 | 2021-01-11 | Gilchrist | Florida | 12041 | 1097 | 27 |
914289 | 914289 | 2021-01-10 | Gilchrist | Florida | 12041 | 1094 | 27 |
901350 | 901350 | 2021-01-06 | Taylor | Florida | 12123 | 2071 | 27 |
898105 | 898105 | 2021-01-05 | Taylor | Florida | 12123 | 2047 | 27 |
894860 | 894860 | 2021-01-04 | Taylor | Florida | 12123 | 2032 | 27 |
891573 | 891573 | 2021-01-03 | Gulf | Florida | 12045 | 1359 | 27 |
891580 | 891580 | 2021-01-03 | Holmes | Florida | 12059 | 1735 | 27 |
888326 | 888326 | 2021-01-02 | Gulf | Florida | 12045 | 1351 | 27 |
888333 | 888333 | 2021-01-02 | Holmes | Florida | 12059 | 1727 | 27 |
885081 | 885081 | 2021-01-01 | Gulf | Florida | 12045 | 1333 | 27 |
881836 | 881836 | 2020-12-31 | Gulf | Florida | 12045 | 1333 | 27 |
878591 | 878591 | 2020-12-30 | Gulf | Florida | 12045 | 1317 | 27 |
875346 | 875346 | 2020-12-29 | Gulf | Florida | 12045 | 1300 | 27 |
872101 | 872101 | 2020-12-28 | Gulf | Florida | 12045 | 1273 | 27 |
868841 | 868841 | 2020-12-27 | Calhoun | Florida | 12013 | 1159 | 27 |
868856 | 868856 | 2020-12-27 | Gulf | Florida | 12045 | 1268 | 27 |
865596 | 865596 | 2020-12-26 | Calhoun | Florida | 12013 | 1156 | 27 |
865611 | 865611 | 2020-12-26 | Gulf | Florida | 12045 | 1264 | 27 |
862351 | 862351 | 2020-12-25 | Calhoun | Florida | 12013 | 1151 | 27 |
862366 | 862366 | 2020-12-25 | Gulf | Florida | 12045 | 1253 | 27 |
859106 | 859106 | 2020-12-24 | Calhoun | Florida | 12013 | 1151 | 27 |
859121 | 859121 | 2020-12-24 | Gulf | Florida | 12045 | 1253 | 27 |
855876 | 855876 | 2020-12-23 | Gulf | Florida | 12045 | 1232 | 27 |
816973 | 816973 | 2020-12-11 | Washington | Florida | 12133 | 1635 | 27 |
813727 | 813727 | 2020-12-10 | Washington | Florida | 12133 | 1620 | 27 |
810483 | 810483 | 2020-12-09 | Washington | Florida | 12133 | 1610 | 27 |
807238 | 807238 | 2020-12-08 | Washington | Florida | 12133 | 1600 | 27 |
803964 | 803964 | 2020-12-07 | Madison | Florida | 12079 | 1332 | 27 |
803993 | 803993 | 2020-12-07 | Washington | Florida | 12133 | 1591 | 27 |
800719 | 800719 | 2020-12-06 | Madison | Florida | 12079 | 1324 | 27 |
800748 | 800748 | 2020-12-06 | Washington | Florida | 12133 | 1588 | 27 |
797474 | 797474 | 2020-12-05 | Madison | Florida | 12079 | 1319 | 27 |
797503 | 797503 | 2020-12-05 | Washington | Florida | 12133 | 1578 | 27 |
794229 | 794229 | 2020-12-04 | Madison | Florida | 12079 | 1308 | 27 |
794258 | 794258 | 2020-12-04 | Washington | Florida | 12133 | 1569 | 27 |
790984 | 790984 | 2020-12-03 | Madison | Florida | 12079 | 1296 | 27 |
791013 | 791013 | 2020-12-03 | Washington | Florida | 12133 | 1565 | 27 |
787739 | 787739 | 2020-12-02 | Madison | Florida | 12079 | 1276 | 27 |
784495 | 784495 | 2020-12-01 | Madison | Florida | 12079 | 1271 | 27 |
781250 | 781250 | 2020-11-30 | Madison | Florida | 12079 | 1267 | 27 |
781255 | 781255 | 2020-11-30 | Monroe | Florida | 12087 | 3381 | 27 |
778004 | 778004 | 2020-11-29 | Madison | Florida | 12079 | 1267 | 27 |
778009 | 778009 | 2020-11-29 | Monroe | Florida | 12087 | 3353 | 27 |
774759 | 774759 | 2020-11-28 | Madison | Florida | 12079 | 1258 | 27 |
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);