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

39,626 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 · 39,626 ✖
Link rowid date ▲ county state fips cases deaths
1842930 1842930 2021-10-23 Alachua Florida 12001 39360 521
1842931 1842931 2021-10-23 Baker Florida 12003 5970 117
1842932 1842932 2021-10-23 Bay Florida 12005 31688 673
1842933 1842933 2021-10-23 Bradford Florida 12007 5327 119
1842934 1842934 2021-10-23 Brevard Florida 12009 80429 1695
1842935 1842935 2021-10-23 Broward Florida 12011 355580 4698
1842936 1842936 2021-10-23 Calhoun Florida 12013 3004 62
1842937 1842937 2021-10-23 Charlotte Florida 12015 23134 669
1842938 1842938 2021-10-23 Citrus Florida 12017 20328 777
1842939 1842939 2021-10-23 Clay Florida 12019 33738 685
1842940 1842940 2021-10-23 Collier Florida 12021 56546 833
1842941 1842941 2021-10-23 Columbia Florida 12023 14843 308
1842942 1842942 2021-10-23 DeSoto Florida 12027 6871 132
1842943 1842943 2021-10-23 Dixie Florida 12029 2946 31
1842944 1842944 2021-10-23 Duval Florida 12031 164111 2732
1842945 1842945 2021-10-23 Escambia Florida 12033 53492 1049
1842946 1842946 2021-10-23 Flagler Florida 12035 14308 205
1842947 1842947 2021-10-23 Franklin Florida 12037 2222 45
1842948 1842948 2021-10-23 Gadsden Florida 12039 8618 116
1842949 1842949 2021-10-23 Gilchrist Florida 12041 3141 55
1842950 1842950 2021-10-23 Glades Florida 12043 1434 25
1842951 1842951 2021-10-23 Gulf Florida 12045 2967 64
1842952 1842952 2021-10-23 Hamilton Florida 12047 2726 47
1842953 1842953 2021-10-23 Hardee Florida 12049 6054 97
1842954 1842954 2021-10-23 Hendry Florida 12051 7947 110
1842955 1842955 2021-10-23 Hernando Florida 12053 28468 876
1842956 1842956 2021-10-23 Highlands Florida 12055 15882 537
1842957 1842957 2021-10-23 Hillsborough Florida 12057 240570 2906
1842958 1842958 2021-10-23 Holmes Florida 12059 3837 70
1842959 1842959 2021-10-23 Indian River Florida 12061 22085 538
1842960 1842960 2021-10-23 Jackson Florida 12063 10070 211
1842961 1842961 2021-10-23 Jefferson Florida 12065 2456 36
1842962 1842962 2021-10-23 Lafayette Florida 12067 2208 32
1842963 1842963 2021-10-23 Lake Florida 12069 54129 1181
1842964 1842964 2021-10-23 Lee Florida 12071 124415 1748
1842965 1842965 2021-10-23 Leon Florida 12073 50441 494
1842966 1842966 2021-10-23 Levy Florida 12075 6953 81
1842967 1842967 2021-10-23 Liberty Florida 12077 1823 19
1842968 1842968 2021-10-23 Madison Florida 12079 3584 54
1842969 1842969 2021-10-23 Manatee Florida 12081 64610 930
1842970 1842970 2021-10-23 Marion Florida 12083 56558 1709
1842971 1842971 2021-10-23 Martin Florida 12085 20060 500
1842972 1842972 2021-10-23 Miami-Dade Florida 12086 670019 8768
1842973 1842973 2021-10-23 Monroe Florida 12087 10445 91
1842974 1842974 2021-10-23 Nassau Florida 12089 14994 238
1842975 1842975 2021-10-23 Okaloosa Florida 12091 34287 542
1842976 1842976 2021-10-23 Okeechobee Florida 12093 7382 126
1842977 1842977 2021-10-23 Orange Florida 12095 227246 2124
1842978 1842978 2021-10-23 Osceola Florida 12097 71294 855
1842979 1842979 2021-10-23 Palm Beach Florida 12099 224195 4060
1842980 1842980 2021-10-23 Pasco Florida 12101 78907 1511
1842981 1842981 2021-10-23 Pinellas Florida 12103 133980 2625
1842982 1842982 2021-10-23 Polk Florida 12105 128010 2381
1842983 1842983 2021-10-23 Putnam Florida 12107 12751 317
1842984 1842984 2021-10-23 Santa Rosa Florida 12113 32310 512
1842985 1842985 2021-10-23 Sarasota Florida 12115 55072 1277
1842986 1842986 2021-10-23 Seminole Florida 12117 61835 833
1842987 1842987 2021-10-23 St. Johns Florida 12109 40496 455
1842988 1842988 2021-10-23 St. Lucie Florida 12111 47636 990
1842989 1842989 2021-10-23 Sumter Florida 12119 14451 451
1842990 1842990 2021-10-23 Suwannee Florida 12121 9175 163
1842991 1842991 2021-10-23 Taylor Florida 12123 4582 77
1842992 1842992 2021-10-23 Union Florida 12125 3057 96
1842993 1842993 2021-10-23 Unknown Florida   1 929
1842994 1842994 2021-10-23 Volusia Florida 12127 75256 1271
1842995 1842995 2021-10-23 Wakulla Florida 12129 6375 103
1842996 1842996 2021-10-23 Walton Florida 12131 11895 159
1842997 1842997 2021-10-23 Washington Florida 12133 4542 62
1839680 1839680 2021-10-22 Alachua Florida 12001 39360 521
1839681 1839681 2021-10-22 Baker Florida 12003 5970 117
1839682 1839682 2021-10-22 Bay Florida 12005 31688 673
1839683 1839683 2021-10-22 Bradford Florida 12007 5327 119
1839684 1839684 2021-10-22 Brevard Florida 12009 80429 1695
1839685 1839685 2021-10-22 Broward Florida 12011 355580 4698
1839686 1839686 2021-10-22 Calhoun Florida 12013 3004 62
1839687 1839687 2021-10-22 Charlotte Florida 12015 23134 669
1839688 1839688 2021-10-22 Citrus Florida 12017 20328 777
1839689 1839689 2021-10-22 Clay Florida 12019 33738 685
1839690 1839690 2021-10-22 Collier Florida 12021 56546 833
1839691 1839691 2021-10-22 Columbia Florida 12023 14843 308
1839692 1839692 2021-10-22 DeSoto Florida 12027 6871 132
1839693 1839693 2021-10-22 Dixie Florida 12029 2946 31
1839694 1839694 2021-10-22 Duval Florida 12031 164111 2732
1839695 1839695 2021-10-22 Escambia Florida 12033 53492 1049
1839696 1839696 2021-10-22 Flagler Florida 12035 14308 205
1839697 1839697 2021-10-22 Franklin Florida 12037 2222 45
1839698 1839698 2021-10-22 Gadsden Florida 12039 8618 116
1839699 1839699 2021-10-22 Gilchrist Florida 12041 3141 55
1839700 1839700 2021-10-22 Glades Florida 12043 1434 25
1839701 1839701 2021-10-22 Gulf Florida 12045 2967 64
1839702 1839702 2021-10-22 Hamilton Florida 12047 2726 47
1839703 1839703 2021-10-22 Hardee Florida 12049 6054 97
1839704 1839704 2021-10-22 Hendry Florida 12051 7947 110
1839705 1839705 2021-10-22 Hernando Florida 12053 28468 876
1839706 1839706 2021-10-22 Highlands Florida 12055 15882 537
1839707 1839707 2021-10-22 Hillsborough Florida 12057 240570 2906
1839708 1839708 2021-10-22 Holmes Florida 12059 3837 70
1839709 1839709 2021-10-22 Indian River Florida 12061 22085 538
1839710 1839710 2021-10-22 Jackson Florida 12063 10070 211
1839711 1839711 2021-10-22 Jefferson Florida 12065 2456 36

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