ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
320 rows where deaths = 15 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 |
---|---|---|---|---|---|---|---|
1128522 | 1128522 | 2021-03-17 | Liberty | Florida | 12077 | 1051 | 15 |
1125276 | 1125276 | 2021-03-16 | Liberty | Florida | 12077 | 1049 | 15 |
1122030 | 1122030 | 2021-03-15 | Liberty | Florida | 12077 | 1049 | 15 |
1118783 | 1118783 | 2021-03-14 | Liberty | Florida | 12077 | 1049 | 15 |
1115536 | 1115536 | 2021-03-13 | Liberty | Florida | 12077 | 1049 | 15 |
1112290 | 1112290 | 2021-03-12 | Liberty | Florida | 12077 | 1049 | 15 |
1109044 | 1109044 | 2021-03-11 | Liberty | Florida | 12077 | 1049 | 15 |
1105798 | 1105798 | 2021-03-10 | Liberty | Florida | 12077 | 1049 | 15 |
1102552 | 1102552 | 2021-03-09 | Liberty | Florida | 12077 | 1049 | 15 |
1089549 | 1089549 | 2021-03-05 | Glades | Florida | 12043 | 906 | 15 |
1086304 | 1086304 | 2021-03-04 | Glades | Florida | 12043 | 905 | 15 |
1083058 | 1083058 | 2021-03-03 | Glades | Florida | 12043 | 905 | 15 |
1079812 | 1079812 | 2021-03-02 | Glades | Florida | 12043 | 903 | 15 |
1079829 | 1079829 | 2021-03-02 | Liberty | Florida | 12077 | 1043 | 15 |
1076567 | 1076567 | 2021-03-01 | Glades | Florida | 12043 | 903 | 15 |
1076584 | 1076584 | 2021-03-01 | Liberty | Florida | 12077 | 1043 | 15 |
1073321 | 1073321 | 2021-02-28 | Glades | Florida | 12043 | 903 | 15 |
1073338 | 1073338 | 2021-02-28 | Liberty | Florida | 12077 | 1040 | 15 |
1070075 | 1070075 | 2021-02-27 | Glades | Florida | 12043 | 902 | 15 |
1070092 | 1070092 | 2021-02-27 | Liberty | Florida | 12077 | 1040 | 15 |
1066830 | 1066830 | 2021-02-26 | Glades | Florida | 12043 | 902 | 15 |
1066847 | 1066847 | 2021-02-26 | Liberty | Florida | 12077 | 1040 | 15 |
1063585 | 1063585 | 2021-02-25 | Glades | Florida | 12043 | 900 | 15 |
1063602 | 1063602 | 2021-02-25 | Liberty | Florida | 12077 | 1039 | 15 |
1060340 | 1060340 | 2021-02-24 | Glades | Florida | 12043 | 899 | 15 |
1060357 | 1060357 | 2021-02-24 | Liberty | Florida | 12077 | 1037 | 15 |
1057094 | 1057094 | 2021-02-23 | Glades | Florida | 12043 | 896 | 15 |
1057111 | 1057111 | 2021-02-23 | Liberty | Florida | 12077 | 1036 | 15 |
1053848 | 1053848 | 2021-02-22 | Glades | Florida | 12043 | 895 | 15 |
1053865 | 1053865 | 2021-02-22 | Liberty | Florida | 12077 | 1036 | 15 |
1050601 | 1050601 | 2021-02-21 | Glades | Florida | 12043 | 895 | 15 |
1047354 | 1047354 | 2021-02-20 | Glades | Florida | 12043 | 893 | 15 |
1044109 | 1044109 | 2021-02-19 | Glades | Florida | 12043 | 892 | 15 |
1040864 | 1040864 | 2021-02-18 | Glades | Florida | 12043 | 890 | 15 |
1037619 | 1037619 | 2021-02-17 | Glades | Florida | 12043 | 888 | 15 |
1034374 | 1034374 | 2021-02-16 | Glades | Florida | 12043 | 886 | 15 |
1031128 | 1031128 | 2021-02-15 | Glades | Florida | 12043 | 883 | 15 |
1027881 | 1027881 | 2021-02-14 | Glades | Florida | 12043 | 882 | 15 |
1024629 | 1024629 | 2021-02-13 | Dixie | Florida | 12029 | 1429 | 15 |
1021384 | 1021384 | 2021-02-12 | Dixie | Florida | 12029 | 1428 | 15 |
1018139 | 1018139 | 2021-02-11 | Dixie | Florida | 12029 | 1427 | 15 |
972706 | 972706 | 2021-01-28 | Hamilton | Florida | 12047 | 1485 | 15 |
969461 | 969461 | 2021-01-27 | Hamilton | Florida | 12047 | 1480 | 15 |
966217 | 966217 | 2021-01-26 | Hamilton | Florida | 12047 | 1475 | 15 |
962972 | 962972 | 2021-01-25 | Hamilton | Florida | 12047 | 1470 | 15 |
959727 | 959727 | 2021-01-24 | Hamilton | Florida | 12047 | 1469 | 15 |
956481 | 956481 | 2021-01-23 | Hamilton | Florida | 12047 | 1465 | 15 |
953236 | 953236 | 2021-01-22 | Hamilton | Florida | 12047 | 1460 | 15 |
949991 | 949991 | 2021-01-21 | Hamilton | Florida | 12047 | 1452 | 15 |
946745 | 946745 | 2021-01-20 | Hamilton | Florida | 12047 | 1441 | 15 |
943498 | 943498 | 2021-01-19 | Hamilton | Florida | 12047 | 1428 | 15 |
940253 | 940253 | 2021-01-18 | Hamilton | Florida | 12047 | 1424 | 15 |
937008 | 937008 | 2021-01-17 | Hamilton | Florida | 12047 | 1416 | 15 |
933763 | 933763 | 2021-01-16 | Hamilton | Florida | 12047 | 1412 | 15 |
930518 | 930518 | 2021-01-15 | Hamilton | Florida | 12047 | 1404 | 15 |
927273 | 927273 | 2021-01-14 | Hamilton | Florida | 12047 | 1389 | 15 |
924027 | 924027 | 2021-01-13 | Hamilton | Florida | 12047 | 1373 | 15 |
920782 | 920782 | 2021-01-12 | Hamilton | Florida | 12047 | 1367 | 15 |
917537 | 917537 | 2021-01-11 | Hamilton | Florida | 12047 | 1356 | 15 |
914292 | 914292 | 2021-01-10 | Hamilton | Florida | 12047 | 1355 | 15 |
911047 | 911047 | 2021-01-09 | Hamilton | Florida | 12047 | 1348 | 15 |
907802 | 907802 | 2021-01-08 | Hamilton | Florida | 12047 | 1339 | 15 |
904556 | 904556 | 2021-01-07 | Hamilton | Florida | 12047 | 1328 | 15 |
901311 | 901311 | 2021-01-06 | Hamilton | Florida | 12047 | 1320 | 15 |
898066 | 898066 | 2021-01-05 | Hamilton | Florida | 12047 | 1309 | 15 |
894821 | 894821 | 2021-01-04 | Hamilton | Florida | 12047 | 1305 | 15 |
891574 | 891574 | 2021-01-03 | Hamilton | Florida | 12047 | 1299 | 15 |
888327 | 888327 | 2021-01-02 | Hamilton | Florida | 12047 | 1293 | 15 |
885082 | 885082 | 2021-01-01 | Hamilton | Florida | 12047 | 1277 | 15 |
881837 | 881837 | 2020-12-31 | Hamilton | Florida | 12047 | 1277 | 15 |
878592 | 878592 | 2020-12-30 | Hamilton | Florida | 12047 | 1236 | 15 |
852641 | 852641 | 2020-12-22 | Jefferson | Florida | 12065 | 897 | 15 |
849396 | 849396 | 2020-12-21 | Jefferson | Florida | 12065 | 890 | 15 |
810452 | 810452 | 2020-12-09 | Levy | Florida | 12075 | 1524 | 15 |
807207 | 807207 | 2020-12-08 | Levy | Florida | 12075 | 1511 | 15 |
803962 | 803962 | 2020-12-07 | Levy | Florida | 12075 | 1505 | 15 |
794219 | 794219 | 2020-12-04 | Holmes | Florida | 12059 | 1233 | 15 |
794256 | 794256 | 2020-12-04 | Wakulla | Florida | 12129 | 1691 | 15 |
790974 | 790974 | 2020-12-03 | Holmes | Florida | 12059 | 1214 | 15 |
791011 | 791011 | 2020-12-03 | Wakulla | Florida | 12129 | 1683 | 15 |
787729 | 787729 | 2020-12-02 | Holmes | Florida | 12059 | 1199 | 15 |
787766 | 787766 | 2020-12-02 | Wakulla | Florida | 12129 | 1667 | 15 |
784485 | 784485 | 2020-12-01 | Holmes | Florida | 12059 | 1169 | 15 |
781240 | 781240 | 2020-11-30 | Holmes | Florida | 12059 | 1166 | 15 |
777994 | 777994 | 2020-11-29 | Holmes | Florida | 12059 | 1163 | 15 |
774749 | 774749 | 2020-11-28 | Holmes | Florida | 12059 | 1155 | 15 |
771504 | 771504 | 2020-11-27 | Holmes | Florida | 12059 | 1147 | 15 |
739019 | 739019 | 2020-11-17 | Bradford | Florida | 12007 | 1323 | 15 |
735775 | 735775 | 2020-11-16 | Bradford | Florida | 12007 | 1305 | 15 |
732529 | 732529 | 2020-11-15 | Bradford | Florida | 12007 | 1304 | 15 |
729284 | 729284 | 2020-11-14 | Bradford | Florida | 12007 | 1296 | 15 |
726041 | 726041 | 2020-11-13 | Bradford | Florida | 12007 | 1295 | 15 |
722798 | 722798 | 2020-11-12 | Bradford | Florida | 12007 | 1292 | 15 |
722816 | 722816 | 2020-11-12 | Gulf | Florida | 12045 | 1009 | 15 |
719555 | 719555 | 2020-11-11 | Bradford | Florida | 12007 | 1289 | 15 |
719573 | 719573 | 2020-11-11 | Gulf | Florida | 12045 | 997 | 15 |
716312 | 716312 | 2020-11-10 | Bradford | Florida | 12007 | 1279 | 15 |
716330 | 716330 | 2020-11-10 | Gulf | Florida | 12045 | 991 | 15 |
713068 | 713068 | 2020-11-09 | Bradford | Florida | 12007 | 1271 | 15 |
713086 | 713086 | 2020-11-09 | Gulf | Florida | 12045 | 992 | 15 |
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);