ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where date = "2020-03-30" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
19900 | 19900 | 2020-03-30 | Alachua | Florida | 12001 | 80 | 0 |
19901 | 19901 | 2020-03-30 | Baker | Florida | 12003 | 8 | 0 |
19902 | 19902 | 2020-03-30 | Bay | Florida | 12005 | 6 | 0 |
19903 | 19903 | 2020-03-30 | Bradford | Florida | 12007 | 2 | 0 |
19904 | 19904 | 2020-03-30 | Brevard | Florida | 12009 | 32 | 0 |
19905 | 19905 | 2020-03-30 | Broward | Florida | 12011 | 1137 | 12 |
19906 | 19906 | 2020-03-30 | Charlotte | Florida | 12015 | 20 | 0 |
19907 | 19907 | 2020-03-30 | Citrus | Florida | 12017 | 17 | 2 |
19908 | 19908 | 2020-03-30 | Clay | Florida | 12019 | 34 | 5 |
19909 | 19909 | 2020-03-30 | Collier | Florida | 12021 | 127 | 1 |
19910 | 19910 | 2020-03-30 | Columbia | Florida | 12023 | 3 | 0 |
19911 | 19911 | 2020-03-30 | DeSoto | Florida | 12027 | 7 | 2 |
19912 | 19912 | 2020-03-30 | Duval | Florida | 12031 | 163 | 4 |
19913 | 19913 | 2020-03-30 | Escambia | Florida | 12033 | 81 | 0 |
19914 | 19914 | 2020-03-30 | Flagler | Florida | 12035 | 15 | 0 |
19915 | 19915 | 2020-03-30 | Gadsden | Florida | 12039 | 1 | 0 |
19916 | 19916 | 2020-03-30 | Glades | Florida | 12043 | 3 | 0 |
19917 | 19917 | 2020-03-30 | Hendry | Florida | 12051 | 3 | 0 |
19918 | 19918 | 2020-03-30 | Hernando | Florida | 12053 | 21 | 0 |
19919 | 19919 | 2020-03-30 | Highlands | Florida | 12055 | 14 | 1 |
19920 | 19920 | 2020-03-30 | Hillsborough | Florida | 12057 | 272 | 2 |
19921 | 19921 | 2020-03-30 | Holmes | Florida | 12059 | 1 | 0 |
19922 | 19922 | 2020-03-30 | Indian River | Florida | 12061 | 25 | 0 |
19923 | 19923 | 2020-03-30 | Jackson | Florida | 12063 | 2 | 0 |
19924 | 19924 | 2020-03-30 | Lake | Florida | 12069 | 50 | 0 |
19925 | 19925 | 2020-03-30 | Lee | Florida | 12071 | 170 | 6 |
19926 | 19926 | 2020-03-30 | Leon | Florida | 12073 | 21 | 0 |
19927 | 19927 | 2020-03-30 | Levy | Florida | 12075 | 2 | 0 |
19928 | 19928 | 2020-03-30 | Manatee | Florida | 12081 | 42 | 1 |
19929 | 19929 | 2020-03-30 | Marion | Florida | 12083 | 23 | 0 |
19930 | 19930 | 2020-03-30 | Martin | Florida | 12085 | 27 | 0 |
19931 | 19931 | 2020-03-30 | Miami-Dade | Florida | 12086 | 1700 | 4 |
19932 | 19932 | 2020-03-30 | Monroe | Florida | 12087 | 26 | 0 |
19933 | 19933 | 2020-03-30 | Nassau | Florida | 12089 | 7 | 0 |
19934 | 19934 | 2020-03-30 | Okaloosa | Florida | 12091 | 35 | 1 |
19935 | 19935 | 2020-03-30 | Orange | Florida | 12095 | 299 | 4 |
19936 | 19936 | 2020-03-30 | Osceola | Florida | 12097 | 94 | 1 |
19937 | 19937 | 2020-03-30 | Palm Beach | Florida | 12099 | 462 | 10 |
19938 | 19938 | 2020-03-30 | Pasco | Florida | 12101 | 38 | 2 |
19939 | 19939 | 2020-03-30 | Pinellas | Florida | 12103 | 129 | 5 |
19940 | 19940 | 2020-03-30 | Polk | Florida | 12105 | 63 | 0 |
19941 | 19941 | 2020-03-30 | Putnam | Florida | 12107 | 13 | 0 |
19942 | 19942 | 2020-03-30 | Santa Rosa | Florida | 12113 | 36 | 2 |
19943 | 19943 | 2020-03-30 | Sarasota | Florida | 12115 | 67 | 2 |
19944 | 19944 | 2020-03-30 | Seminole | Florida | 12117 | 88 | 0 |
19945 | 19945 | 2020-03-30 | St. Johns | Florida | 12109 | 61 | 2 |
19946 | 19946 | 2020-03-30 | St. Lucie | Florida | 12111 | 31 | 2 |
19947 | 19947 | 2020-03-30 | Sumter | Florida | 12119 | 47 | 0 |
19948 | 19948 | 2020-03-30 | Suwannee | Florida | 12121 | 3 | 0 |
19949 | 19949 | 2020-03-30 | Volusia | Florida | 12127 | 69 | 1 |
19950 | 19950 | 2020-03-30 | Wakulla | Florida | 12129 | 1 | 0 |
19951 | 19951 | 2020-03-30 | Walton | Florida | 12131 | 16 | 0 |
19952 | 19952 | 2020-03-30 | Washington | Florida | 12133 | 1 | 0 |
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);