ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
392 rows where deaths = 9 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Santa Rosa 61
- Walton 48
- Jefferson 38
- Highlands 23
- Hardee 22
- Indian River 18
- Hamilton 17
- Wakulla 15
- Levy 13
- Pasco 12
- Martin 11
- Gilchrist 10
- Bradford 9
- Calhoun 9
- Brevard 8
- Holmes 8
- Washington 7
- Clay 6
- Dixie 5
- Duval 5
- Sumter 5
- Charlotte 3
- Citrus 3
- Gadsden 3
- Glades 3
- Suwannee 3
- Bay 2
- Franklin 2
- Liberty 2
- Okaloosa 2
- …
state 1
- Florida · 392 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
956476 | 956476 | 2021-01-23 | Franklin | Florida | 12037 | 1172 | 9 |
953231 | 953231 | 2021-01-22 | Franklin | Florida | 12037 | 1164 | 9 |
771496 | 771496 | 2020-11-27 | Glades | Florida | 12043 | 664 | 9 |
768251 | 768251 | 2020-11-26 | Glades | Florida | 12043 | 657 | 9 |
765005 | 765005 | 2020-11-25 | Glades | Florida | 12043 | 657 | 9 |
690393 | 690393 | 2020-11-02 | Jefferson | Florida | 12065 | 682 | 9 |
687148 | 687148 | 2020-11-01 | Jefferson | Florida | 12065 | 682 | 9 |
683904 | 683904 | 2020-10-31 | Jefferson | Florida | 12065 | 680 | 9 |
680661 | 680661 | 2020-10-30 | Jefferson | Florida | 12065 | 677 | 9 |
677418 | 677418 | 2020-10-29 | Jefferson | Florida | 12065 | 672 | 9 |
674175 | 674175 | 2020-10-28 | Jefferson | Florida | 12065 | 665 | 9 |
670924 | 670924 | 2020-10-27 | Hamilton | Florida | 12047 | 901 | 9 |
670933 | 670933 | 2020-10-27 | Jefferson | Florida | 12065 | 665 | 9 |
667681 | 667681 | 2020-10-26 | Hamilton | Florida | 12047 | 901 | 9 |
667690 | 667690 | 2020-10-26 | Jefferson | Florida | 12065 | 661 | 9 |
664436 | 664436 | 2020-10-25 | Hamilton | Florida | 12047 | 901 | 9 |
664445 | 664445 | 2020-10-25 | Jefferson | Florida | 12065 | 659 | 9 |
661192 | 661192 | 2020-10-24 | Hamilton | Florida | 12047 | 901 | 9 |
661201 | 661201 | 2020-10-24 | Jefferson | Florida | 12065 | 658 | 9 |
657948 | 657948 | 2020-10-23 | Hamilton | Florida | 12047 | 899 | 9 |
657957 | 657957 | 2020-10-23 | Jefferson | Florida | 12065 | 650 | 9 |
654703 | 654703 | 2020-10-22 | Hamilton | Florida | 12047 | 894 | 9 |
654712 | 654712 | 2020-10-22 | Jefferson | Florida | 12065 | 640 | 9 |
651458 | 651458 | 2020-10-21 | Hamilton | Florida | 12047 | 890 | 9 |
651467 | 651467 | 2020-10-21 | Jefferson | Florida | 12065 | 633 | 9 |
648214 | 648214 | 2020-10-20 | Hamilton | Florida | 12047 | 891 | 9 |
648223 | 648223 | 2020-10-20 | Jefferson | Florida | 12065 | 631 | 9 |
644969 | 644969 | 2020-10-19 | Hamilton | Florida | 12047 | 889 | 9 |
644978 | 644978 | 2020-10-19 | Jefferson | Florida | 12065 | 626 | 9 |
641721 | 641721 | 2020-10-18 | Hamilton | Florida | 12047 | 889 | 9 |
641730 | 641730 | 2020-10-18 | Jefferson | Florida | 12065 | 625 | 9 |
638474 | 638474 | 2020-10-17 | Hamilton | Florida | 12047 | 890 | 9 |
638483 | 638483 | 2020-10-17 | Jefferson | Florida | 12065 | 620 | 9 |
635229 | 635229 | 2020-10-16 | Hamilton | Florida | 12047 | 888 | 9 |
635238 | 635238 | 2020-10-16 | Jefferson | Florida | 12065 | 611 | 9 |
631983 | 631983 | 2020-10-15 | Hamilton | Florida | 12047 | 888 | 9 |
631992 | 631992 | 2020-10-15 | Jefferson | Florida | 12065 | 608 | 9 |
628739 | 628739 | 2020-10-14 | Hamilton | Florida | 12047 | 889 | 9 |
628748 | 628748 | 2020-10-14 | Jefferson | Florida | 12065 | 603 | 9 |
625496 | 625496 | 2020-10-13 | Hamilton | Florida | 12047 | 887 | 9 |
625505 | 625505 | 2020-10-13 | Jefferson | Florida | 12065 | 602 | 9 |
622253 | 622253 | 2020-10-12 | Hamilton | Florida | 12047 | 885 | 9 |
622262 | 622262 | 2020-10-12 | Jefferson | Florida | 12065 | 601 | 9 |
619010 | 619010 | 2020-10-11 | Hamilton | Florida | 12047 | 885 | 9 |
619019 | 619019 | 2020-10-11 | Jefferson | Florida | 12065 | 601 | 9 |
615774 | 615774 | 2020-10-10 | Holmes | Florida | 12059 | 784 | 9 |
615777 | 615777 | 2020-10-10 | Jefferson | Florida | 12065 | 586 | 9 |
615783 | 615783 | 2020-10-10 | Liberty | Florida | 12077 | 520 | 9 |
612533 | 612533 | 2020-10-09 | Holmes | Florida | 12059 | 784 | 9 |
612536 | 612536 | 2020-10-09 | Jefferson | Florida | 12065 | 586 | 9 |
612542 | 612542 | 2020-10-09 | Liberty | Florida | 12077 | 520 | 9 |
609266 | 609266 | 2020-10-08 | Bradford | Florida | 12007 | 1163 | 9 |
609291 | 609291 | 2020-10-08 | Holmes | Florida | 12059 | 781 | 9 |
609294 | 609294 | 2020-10-08 | Jefferson | Florida | 12065 | 576 | 9 |
606023 | 606023 | 2020-10-07 | Bradford | Florida | 12007 | 1157 | 9 |
606048 | 606048 | 2020-10-07 | Holmes | Florida | 12059 | 774 | 9 |
606051 | 606051 | 2020-10-07 | Jefferson | Florida | 12065 | 570 | 9 |
602781 | 602781 | 2020-10-06 | Bradford | Florida | 12007 | 1153 | 9 |
602806 | 602806 | 2020-10-06 | Holmes | Florida | 12059 | 771 | 9 |
602809 | 602809 | 2020-10-06 | Jefferson | Florida | 12065 | 569 | 9 |
599538 | 599538 | 2020-10-05 | Bradford | Florida | 12007 | 1151 | 9 |
599563 | 599563 | 2020-10-05 | Holmes | Florida | 12059 | 769 | 9 |
599566 | 599566 | 2020-10-05 | Jefferson | Florida | 12065 | 569 | 9 |
596295 | 596295 | 2020-10-04 | Bradford | Florida | 12007 | 1151 | 9 |
596305 | 596305 | 2020-10-04 | Dixie | Florida | 12029 | 835 | 9 |
596320 | 596320 | 2020-10-04 | Holmes | Florida | 12059 | 768 | 9 |
596323 | 596323 | 2020-10-04 | Jefferson | Florida | 12065 | 568 | 9 |
593053 | 593053 | 2020-10-03 | Bradford | Florida | 12007 | 1148 | 9 |
593063 | 593063 | 2020-10-03 | Dixie | Florida | 12029 | 834 | 9 |
593078 | 593078 | 2020-10-03 | Holmes | Florida | 12059 | 766 | 9 |
593081 | 593081 | 2020-10-03 | Jefferson | Florida | 12065 | 567 | 9 |
589813 | 589813 | 2020-10-02 | Bradford | Florida | 12007 | 1138 | 9 |
589823 | 589823 | 2020-10-02 | Dixie | Florida | 12029 | 834 | 9 |
589841 | 589841 | 2020-10-02 | Jefferson | Florida | 12065 | 566 | 9 |
586572 | 586572 | 2020-10-01 | Bradford | Florida | 12007 | 1135 | 9 |
586582 | 586582 | 2020-10-01 | Dixie | Florida | 12029 | 835 | 9 |
586600 | 586600 | 2020-10-01 | Jefferson | Florida | 12065 | 562 | 9 |
583332 | 583332 | 2020-09-30 | Bradford | Florida | 12007 | 1129 | 9 |
583342 | 583342 | 2020-09-30 | Dixie | Florida | 12029 | 835 | 9 |
583360 | 583360 | 2020-09-30 | Jefferson | Florida | 12065 | 560 | 9 |
583365 | 583365 | 2020-09-30 | Levy | Florida | 12075 | 1044 | 9 |
580121 | 580121 | 2020-09-29 | Jefferson | Florida | 12065 | 563 | 9 |
580126 | 580126 | 2020-09-29 | Levy | Florida | 12075 | 1040 | 9 |
576880 | 576880 | 2020-09-28 | Jefferson | Florida | 12065 | 562 | 9 |
576885 | 576885 | 2020-09-28 | Levy | Florida | 12075 | 1037 | 9 |
573637 | 573637 | 2020-09-27 | Jefferson | Florida | 12065 | 557 | 9 |
573642 | 573642 | 2020-09-27 | Levy | Florida | 12075 | 1035 | 9 |
570395 | 570395 | 2020-09-26 | Jefferson | Florida | 12065 | 555 | 9 |
570400 | 570400 | 2020-09-26 | Levy | Florida | 12075 | 1033 | 9 |
567158 | 567158 | 2020-09-25 | Levy | Florida | 12075 | 1022 | 9 |
563918 | 563918 | 2020-09-24 | Levy | Florida | 12075 | 1017 | 9 |
563947 | 563947 | 2020-09-24 | Wakulla | Florida | 12129 | 1106 | 9 |
560678 | 560678 | 2020-09-23 | Levy | Florida | 12075 | 1012 | 9 |
560707 | 560707 | 2020-09-23 | Wakulla | Florida | 12129 | 1106 | 9 |
557442 | 557442 | 2020-09-22 | Levy | Florida | 12075 | 1009 | 9 |
557471 | 557471 | 2020-09-22 | Wakulla | Florida | 12129 | 1103 | 9 |
554205 | 554205 | 2020-09-21 | Levy | Florida | 12075 | 1006 | 9 |
554234 | 554234 | 2020-09-21 | Wakulla | Florida | 12129 | 1098 | 9 |
550966 | 550966 | 2020-09-20 | Levy | Florida | 12075 | 1004 | 9 |
550995 | 550995 | 2020-09-20 | Wakulla | Florida | 12129 | 1086 | 9 |
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);