ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

23,374 rows where state = "Florida" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Florida · 23,374 ✖
Link rowid date ▲ county state fips cases deaths
1066810 1066810 2021-02-26 Alachua Florida 12001 22293 228
1066811 1066811 2021-02-26 Baker Florida 12003 3292 55
1066812 1066812 2021-02-26 Bay Florida 12005 18606 339
1066813 1066813 2021-02-26 Bradford Florida 12007 2845 52
1066814 1066814 2021-02-26 Brevard Florida 12009 33739 738
1066815 1066815 2021-02-26 Broward Florida 12011 193560 2369
1066816 1066816 2021-02-26 Calhoun Florida 12013 1607 40
1066817 1066817 2021-02-26 Charlotte Florida 12015 10642 359
1066818 1066818 2021-02-26 Citrus Florida 12017 9716 397
1066819 1066819 2021-02-26 Clay Florida 12019 16673 304
1066820 1066820 2021-02-26 Collier Florida 12021 30144 459
1066821 1066821 2021-02-26 Columbia Florida 12023 7655 155
1066822 1066822 2021-02-26 DeSoto Florida 12027 3769 73
1066823 1066823 2021-02-26 Dixie Florida 12029 1484 19
1066824 1066824 2021-02-26 Duval Florida 12031 88430 1139
1066825 1066825 2021-02-26 Escambia Florida 12033 33556 628
1066826 1066826 2021-02-26 Flagler Florida 12035 5898 89
1066827 1066827 2021-02-26 Franklin Florida 12037 1278 14
1066828 1066828 2021-02-26 Gadsden Florida 12039 5418 83
1066829 1066829 2021-02-26 Gilchrist Florida 12041 1397 33
1066830 1066830 2021-02-26 Glades Florida 12043 902 15
1066831 1066831 2021-02-26 Gulf Florida 12045 1860 39
1066832 1066832 2021-02-26 Hamilton Florida 12047 1566 21
1066833 1066833 2021-02-26 Hardee Florida 12049 2783 29
1066834 1066834 2021-02-26 Hendry Florida 12051 4289 72
1066835 1066835 2021-02-26 Hernando Florida 12053 11212 398
1066836 1066836 2021-02-26 Highlands Florida 12055 7206 299
1066837 1066837 2021-02-26 Hillsborough Florida 12057 110837 1484
1066838 1066838 2021-02-26 Holmes Florida 12059 2175 44
1066839 1066839 2021-02-26 Indian River Florida 12061 10967 261
1066840 1066840 2021-02-26 Jackson Florida 12063 5901 150
1066841 1066841 2021-02-26 Jefferson Florida 12065 1402 24
1066842 1066842 2021-02-26 Lafayette Florida 12067 1586 24
1066843 1066843 2021-02-26 Lake Florida 12069 24445 554
1066844 1066844 2021-02-26 Lee Florida 12071 57468 872
1066845 1066845 2021-02-26 Leon Florida 12073 29052 283
1066846 1066846 2021-02-26 Levy Florida 12075 2863 35
1066847 1066847 2021-02-26 Liberty Florida 12077 1040 15
1066848 1066848 2021-02-26 Madison Florida 12079 1986 42
1066849 1066849 2021-02-26 Manatee Florida 12081 31685 586
1066850 1066850 2021-02-26 Marion Florida 12083 27485 782
1066851 1066851 2021-02-26 Martin Florida 12085 10536 276
1066852 1066852 2021-02-26 Miami-Dade Florida 12086 408095 5396
1066853 1066853 2021-02-26 Monroe Florida 12087 5799 46
1066854 1066854 2021-02-26 Nassau Florida 12089 7701 112
1066855 1066855 2021-02-26 Okaloosa Florida 12091 18724 327
1066856 1066856 2021-02-26 Okeechobee Florida 12093 3548 75
1066857 1066857 2021-02-26 Orange Florida 12095 113647 1090
1066858 1066858 2021-02-26 Osceola Florida 12097 36607 441
1066859 1066859 2021-02-26 Palm Beach Florida 12099 119909 2454
1066860 1066860 2021-02-26 Pasco Florida 12101 33139 646
1066861 1066861 2021-02-26 Pinellas Florida 12103 66205 1438
1066862 1066862 2021-02-26 Polk Florida 12105 56759 1137
1066863 1066863 2021-02-26 Putnam Florida 12107 5828 126
1066864 1066864 2021-02-26 Santa Rosa Florida 12113 17020 257
1066865 1066865 2021-02-26 Sarasota Florida 12115 26882 730
1066866 1066866 2021-02-26 Seminole Florida 12117 27057 422
1066867 1066867 2021-02-26 St. Johns Florida 12109 20007 191
1066868 1066868 2021-02-26 St. Lucie Florida 12111 22015 544
1066869 1066869 2021-02-26 Sumter Florida 12119 7965 238
1066870 1066870 2021-02-26 Suwannee Florida 12121 5108 131
1066871 1066871 2021-02-26 Taylor Florida 12123 2632 41
1066872 1066872 2021-02-26 Union Florida 12125 1740 70
1066873 1066873 2021-02-26 Unknown Florida   3454 0
1066874 1066874 2021-02-26 Volusia Florida 12127 34338 654
1066875 1066875 2021-02-26 Wakulla Florida 12129 3153 51
1066876 1066876 2021-02-26 Walton Florida 12131 7017 81
1066877 1066877 2021-02-26 Washington Florida 12133 2618 47
1063565 1063565 2021-02-25 Alachua Florida 12001 22272 228
1063566 1063566 2021-02-25 Baker Florida 12003 3289 55
1063567 1063567 2021-02-25 Bay Florida 12005 18530 339
1063568 1063568 2021-02-25 Bradford Florida 12007 2843 52
1063569 1063569 2021-02-25 Brevard Florida 12009 33578 736
1063570 1063570 2021-02-25 Broward Florida 12011 192738 2365
1063571 1063571 2021-02-25 Calhoun Florida 12013 1607 40
1063572 1063572 2021-02-25 Charlotte Florida 12015 10622 359
1063573 1063573 2021-02-25 Citrus Florida 12017 9687 395
1063574 1063574 2021-02-25 Clay Florida 12019 16641 304
1063575 1063575 2021-02-25 Collier Florida 12021 30037 452
1063576 1063576 2021-02-25 Columbia Florida 12023 7649 155
1063577 1063577 2021-02-25 DeSoto Florida 12027 3747 73
1063578 1063578 2021-02-25 Dixie Florida 12029 1483 19
1063579 1063579 2021-02-25 Duval Florida 12031 88258 1139
1063580 1063580 2021-02-25 Escambia Florida 12033 33474 622
1063581 1063581 2021-02-25 Flagler Florida 12035 5877 89
1063582 1063582 2021-02-25 Franklin Florida 12037 1278 14
1063583 1063583 2021-02-25 Gadsden Florida 12039 5405 83
1063584 1063584 2021-02-25 Gilchrist Florida 12041 1394 33
1063585 1063585 2021-02-25 Glades Florida 12043 900 15
1063586 1063586 2021-02-25 Gulf Florida 12045 1860 37
1063587 1063587 2021-02-25 Hamilton Florida 12047 1564 21
1063588 1063588 2021-02-25 Hardee Florida 12049 2777 29
1063589 1063589 2021-02-25 Hendry Florida 12051 4279 72
1063590 1063590 2021-02-25 Hernando Florida 12053 11179 398
1063591 1063591 2021-02-25 Highlands Florida 12055 7189 298
1063592 1063592 2021-02-25 Hillsborough Florida 12057 110485 1484
1063593 1063593 2021-02-25 Holmes Florida 12059 2170 44
1063594 1063594 2021-02-25 Indian River Florida 12061 10925 260
1063595 1063595 2021-02-25 Jackson Florida 12063 5891 147
1063596 1063596 2021-02-25 Jefferson Florida 12065 1400 24

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);