ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
301 rows where deaths = 10 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- DeSoto 28
- Wakulla 19
- Franklin 16
- Levy 16
- Lafayette 15
- Liberty 15
- Calhoun 14
- Marion 14
- Gilchrist 12
- Glades 11
- Hamilton 11
- Columbia 10
- Taylor 8
- Hardee 7
- Okaloosa 7
- Alachua 6
- Flagler 6
- Holmes 6
- Indian River 6
- Leon 6
- Lake 5
- Dixie 4
- Highlands 4
- Nassau 4
- Walton 4
- Escambia 3
- Gadsden 3
- Martin 3
- Santa Rosa 3
- Volusia 3
- …
state 1
- Florida · 301 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1008407 | 1008407 | 2021-02-08 | Franklin | Florida | 12037 | 1261 | 10 |
1005161 | 1005161 | 2021-02-07 | Franklin | Florida | 12037 | 1261 | 10 |
1001915 | 1001915 | 2021-02-06 | Franklin | Florida | 12037 | 1258 | 10 |
998669 | 998669 | 2021-02-05 | Franklin | Florida | 12037 | 1255 | 10 |
995423 | 995423 | 2021-02-04 | Franklin | Florida | 12037 | 1247 | 10 |
992177 | 992177 | 2021-02-03 | Franklin | Florida | 12037 | 1246 | 10 |
988931 | 988931 | 2021-02-02 | Franklin | Florida | 12037 | 1242 | 10 |
985684 | 985684 | 2021-02-01 | Franklin | Florida | 12037 | 1240 | 10 |
982437 | 982437 | 2021-01-31 | Franklin | Florida | 12037 | 1235 | 10 |
979191 | 979191 | 2021-01-30 | Franklin | Florida | 12037 | 1225 | 10 |
975946 | 975946 | 2021-01-29 | Franklin | Florida | 12037 | 1218 | 10 |
972701 | 972701 | 2021-01-28 | Franklin | Florida | 12037 | 1202 | 10 |
969456 | 969456 | 2021-01-27 | Franklin | Florida | 12037 | 1198 | 10 |
966212 | 966212 | 2021-01-26 | Franklin | Florida | 12037 | 1194 | 10 |
962967 | 962967 | 2021-01-25 | Franklin | Florida | 12037 | 1189 | 10 |
959722 | 959722 | 2021-01-24 | Franklin | Florida | 12037 | 1187 | 10 |
807191 | 807191 | 2020-12-08 | Glades | Florida | 12043 | 705 | 10 |
803946 | 803946 | 2020-12-07 | Glades | Florida | 12043 | 699 | 10 |
800701 | 800701 | 2020-12-06 | Glades | Florida | 12043 | 696 | 10 |
797456 | 797456 | 2020-12-05 | Glades | Florida | 12043 | 691 | 10 |
794211 | 794211 | 2020-12-04 | Glades | Florida | 12043 | 685 | 10 |
790966 | 790966 | 2020-12-03 | Glades | Florida | 12043 | 683 | 10 |
787721 | 787721 | 2020-12-02 | Glades | Florida | 12043 | 679 | 10 |
784477 | 784477 | 2020-12-01 | Glades | Florida | 12043 | 675 | 10 |
781232 | 781232 | 2020-11-30 | Glades | Florida | 12043 | 672 | 10 |
777986 | 777986 | 2020-11-29 | Glades | Florida | 12043 | 666 | 10 |
774741 | 774741 | 2020-11-28 | Glades | Florida | 12043 | 665 | 10 |
709843 | 709843 | 2020-11-08 | Hamilton | Florida | 12047 | 926 | 10 |
706599 | 706599 | 2020-11-07 | Hamilton | Florida | 12047 | 923 | 10 |
703356 | 703356 | 2020-11-06 | Hamilton | Florida | 12047 | 922 | 10 |
700113 | 700113 | 2020-11-05 | Hamilton | Florida | 12047 | 919 | 10 |
696869 | 696869 | 2020-11-04 | Hamilton | Florida | 12047 | 918 | 10 |
693627 | 693627 | 2020-11-03 | Hamilton | Florida | 12047 | 913 | 10 |
690384 | 690384 | 2020-11-02 | Hamilton | Florida | 12047 | 912 | 10 |
687139 | 687139 | 2020-11-01 | Hamilton | Florida | 12047 | 910 | 10 |
683895 | 683895 | 2020-10-31 | Hamilton | Florida | 12047 | 907 | 10 |
680652 | 680652 | 2020-10-30 | Hamilton | Florida | 12047 | 906 | 10 |
677409 | 677409 | 2020-10-29 | Hamilton | Florida | 12047 | 904 | 10 |
664451 | 664451 | 2020-10-25 | Liberty | Florida | 12077 | 532 | 10 |
661207 | 661207 | 2020-10-24 | Liberty | Florida | 12077 | 532 | 10 |
657963 | 657963 | 2020-10-23 | Liberty | Florida | 12077 | 532 | 10 |
654718 | 654718 | 2020-10-22 | Liberty | Florida | 12077 | 530 | 10 |
654746 | 654746 | 2020-10-22 | Wakulla | Florida | 12129 | 1283 | 10 |
651473 | 651473 | 2020-10-21 | Liberty | Florida | 12077 | 529 | 10 |
651501 | 651501 | 2020-10-21 | Wakulla | Florida | 12129 | 1267 | 10 |
648229 | 648229 | 2020-10-20 | Liberty | Florida | 12077 | 530 | 10 |
648257 | 648257 | 2020-10-20 | Wakulla | Florida | 12129 | 1259 | 10 |
644984 | 644984 | 2020-10-19 | Liberty | Florida | 12077 | 525 | 10 |
645012 | 645012 | 2020-10-19 | Wakulla | Florida | 12129 | 1252 | 10 |
641736 | 641736 | 2020-10-18 | Liberty | Florida | 12077 | 524 | 10 |
641764 | 641764 | 2020-10-18 | Wakulla | Florida | 12129 | 1246 | 10 |
638489 | 638489 | 2020-10-17 | Liberty | Florida | 12077 | 523 | 10 |
638517 | 638517 | 2020-10-17 | Wakulla | Florida | 12129 | 1243 | 10 |
635235 | 635235 | 2020-10-16 | Holmes | Florida | 12059 | 818 | 10 |
635243 | 635243 | 2020-10-16 | Levy | Florida | 12075 | 1096 | 10 |
635244 | 635244 | 2020-10-16 | Liberty | Florida | 12077 | 521 | 10 |
631989 | 631989 | 2020-10-15 | Holmes | Florida | 12059 | 812 | 10 |
631997 | 631997 | 2020-10-15 | Levy | Florida | 12075 | 1092 | 10 |
631998 | 631998 | 2020-10-15 | Liberty | Florida | 12077 | 520 | 10 |
628745 | 628745 | 2020-10-14 | Holmes | Florida | 12059 | 803 | 10 |
628753 | 628753 | 2020-10-14 | Levy | Florida | 12075 | 1089 | 10 |
628754 | 628754 | 2020-10-14 | Liberty | Florida | 12077 | 520 | 10 |
625502 | 625502 | 2020-10-13 | Holmes | Florida | 12059 | 799 | 10 |
625510 | 625510 | 2020-10-13 | Levy | Florida | 12075 | 1083 | 10 |
625511 | 625511 | 2020-10-13 | Liberty | Florida | 12077 | 520 | 10 |
622259 | 622259 | 2020-10-12 | Holmes | Florida | 12059 | 793 | 10 |
622267 | 622267 | 2020-10-12 | Levy | Florida | 12075 | 1079 | 10 |
622268 | 622268 | 2020-10-12 | Liberty | Florida | 12077 | 520 | 10 |
619016 | 619016 | 2020-10-11 | Holmes | Florida | 12059 | 790 | 10 |
619024 | 619024 | 2020-10-11 | Levy | Florida | 12075 | 1080 | 10 |
619025 | 619025 | 2020-10-11 | Liberty | Florida | 12077 | 520 | 10 |
615749 | 615749 | 2020-10-10 | Bradford | Florida | 12007 | 1166 | 10 |
615782 | 615782 | 2020-10-10 | Levy | Florida | 12075 | 1075 | 10 |
612508 | 612508 | 2020-10-09 | Bradford | Florida | 12007 | 1166 | 10 |
612541 | 612541 | 2020-10-09 | Levy | Florida | 12075 | 1075 | 10 |
609276 | 609276 | 2020-10-08 | Dixie | Florida | 12029 | 844 | 10 |
609299 | 609299 | 2020-10-08 | Levy | Florida | 12075 | 1072 | 10 |
606033 | 606033 | 2020-10-07 | Dixie | Florida | 12029 | 839 | 10 |
606056 | 606056 | 2020-10-07 | Levy | Florida | 12075 | 1063 | 10 |
606085 | 606085 | 2020-10-07 | Wakulla | Florida | 12129 | 1169 | 10 |
602791 | 602791 | 2020-10-06 | Dixie | Florida | 12029 | 839 | 10 |
602814 | 602814 | 2020-10-06 | Levy | Florida | 12075 | 1057 | 10 |
602843 | 602843 | 2020-10-06 | Wakulla | Florida | 12129 | 1165 | 10 |
599548 | 599548 | 2020-10-05 | Dixie | Florida | 12029 | 837 | 10 |
599571 | 599571 | 2020-10-05 | Levy | Florida | 12075 | 1055 | 10 |
599600 | 599600 | 2020-10-05 | Wakulla | Florida | 12129 | 1160 | 10 |
596328 | 596328 | 2020-10-04 | Levy | Florida | 12075 | 1055 | 10 |
596357 | 596357 | 2020-10-04 | Wakulla | Florida | 12129 | 1158 | 10 |
593086 | 593086 | 2020-10-03 | Levy | Florida | 12075 | 1051 | 10 |
593115 | 593115 | 2020-10-03 | Wakulla | Florida | 12129 | 1156 | 10 |
589846 | 589846 | 2020-10-02 | Levy | Florida | 12075 | 1047 | 10 |
589875 | 589875 | 2020-10-02 | Wakulla | Florida | 12129 | 1149 | 10 |
586605 | 586605 | 2020-10-01 | Levy | Florida | 12075 | 1046 | 10 |
586634 | 586634 | 2020-10-01 | Wakulla | Florida | 12129 | 1147 | 10 |
583394 | 583394 | 2020-09-30 | Wakulla | Florida | 12129 | 1142 | 10 |
580155 | 580155 | 2020-09-29 | Wakulla | Florida | 12129 | 1139 | 10 |
576914 | 576914 | 2020-09-28 | Wakulla | Florida | 12129 | 1126 | 10 |
573671 | 573671 | 2020-09-27 | Wakulla | Florida | 12129 | 1126 | 10 |
570429 | 570429 | 2020-09-26 | Wakulla | Florida | 12129 | 1122 | 10 |
567187 | 567187 | 2020-09-25 | Wakulla | Florida | 12129 | 1118 | 10 |
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);