ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 9 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293715 | 293715 | 2020-07-02 | Franklin | Florida | 12037 | 9 | 0 |
240469 | 240469 | 2020-06-15 | Gulf | Florida | 12045 | 9 | 0 |
206420 | 206420 | 2020-06-04 | Lafayette | Florida | 12067 | 9 | 0 |
151543 | 151543 | 2020-05-17 | Glades | Florida | 12043 | 9 | 1 |
148534 | 148534 | 2020-05-16 | Glades | Florida | 12043 | 9 | 1 |
142531 | 142531 | 2020-05-14 | Glades | Florida | 12043 | 9 | 1 |
109913 | 109913 | 2020-05-03 | Dixie | Florida | 12029 | 9 | 0 |
107094 | 107094 | 2020-05-02 | Unknown | Florida | 9 | 0 | |
98489 | 98489 | 2020-04-29 | Holmes | Florida | 12059 | 9 | 0 |
95644 | 95644 | 2020-04-28 | Holmes | Florida | 12059 | 9 | 0 |
92812 | 92812 | 2020-04-27 | Holmes | Florida | 12059 | 9 | 0 |
89994 | 89994 | 2020-04-26 | Holmes | Florida | 12059 | 9 | 0 |
90012 | 90012 | 2020-04-26 | Okeechobee | Florida | 12093 | 9 | 0 |
87177 | 87177 | 2020-04-25 | Holmes | Florida | 12059 | 9 | 0 |
87195 | 87195 | 2020-04-25 | Okeechobee | Florida | 12093 | 9 | 0 |
84364 | 84364 | 2020-04-24 | Hardee | Florida | 12049 | 9 | 0 |
84369 | 84369 | 2020-04-24 | Holmes | Florida | 12059 | 9 | 0 |
84387 | 84387 | 2020-04-24 | Okeechobee | Florida | 12093 | 9 | 0 |
81569 | 81569 | 2020-04-23 | Holmes | Florida | 12059 | 9 | 0 |
81587 | 81587 | 2020-04-23 | Okeechobee | Florida | 12093 | 9 | 0 |
76030 | 76030 | 2020-04-21 | Washington | Florida | 12133 | 9 | 0 |
73217 | 73217 | 2020-04-20 | Jackson | Florida | 12063 | 9 | 0 |
64944 | 64944 | 2020-04-17 | Levy | Florida | 12075 | 9 | 0 |
62211 | 62211 | 2020-04-16 | Levy | Florida | 12075 | 9 | 0 |
59492 | 59492 | 2020-04-15 | Levy | Florida | 12075 | 9 | 0 |
48746 | 48746 | 2020-04-11 | Jefferson | Florida | 12065 | 9 | 0 |
46116 | 46116 | 2020-04-10 | Jefferson | Florida | 12065 | 9 | 0 |
43515 | 43515 | 2020-04-09 | Jefferson | Florida | 12065 | 9 | 0 |
38391 | 38391 | 2020-04-07 | Hendry | Florida | 12051 | 9 | 0 |
35880 | 35880 | 2020-04-06 | Bradford | Florida | 12007 | 9 | 0 |
35900 | 35900 | 2020-04-06 | Hendry | Florida | 12051 | 9 | 0 |
28680 | 28680 | 2020-04-03 | DeSoto | Florida | 12027 | 9 | 1 |
26421 | 26421 | 2020-04-02 | Unknown | Florida | 9 | 0 | |
24137 | 24137 | 2020-04-01 | Baker | Florida | 12003 | 9 | 0 |
21978 | 21978 | 2020-03-31 | Baker | Florida | 12003 | 9 | 0 |
14270 | 14270 | 2020-03-27 | Marion | Florida | 12083 | 9 | 0 |
12591 | 12591 | 2020-03-26 | Hernando | Florida | 12053 | 9 | 0 |
11034 | 11034 | 2020-03-25 | Citrus | Florida | 12017 | 9 | 1 |
11069 | 11069 | 2020-03-25 | St. Lucie | Florida | 12111 | 9 | 0 |
9657 | 9657 | 2020-03-24 | Brevard | Florida | 12009 | 9 | 0 |
9660 | 9660 | 2020-03-24 | Citrus | Florida | 12017 | 9 | 0 |
8415 | 8415 | 2020-03-23 | Citrus | Florida | 12017 | 9 | 0 |
8421 | 8421 | 2020-03-23 | Escambia | Florida | 12033 | 9 | 0 |
8428 | 8428 | 2020-03-23 | Lake | Florida | 12069 | 9 | 0 |
8453 | 8453 | 2020-03-23 | Walton | Florida | 12131 | 9 | 0 |
6262 | 6262 | 2020-03-21 | St. Johns | Florida | 12109 | 9 | 0 |
5327 | 5327 | 2020-03-20 | Polk | Florida | 12105 | 9 | 0 |
4537 | 4537 | 2020-03-19 | Manatee | Florida | 12081 | 9 | 1 |
4553 | 4553 | 2020-03-19 | Volusia | Florida | 12127 | 9 | 0 |
3884 | 3884 | 2020-03-18 | Volusia | Florida | 12127 | 9 | 0 |
3308 | 3308 | 2020-03-17 | Hillsborough | Florida | 12057 | 9 | 0 |
3325 | 3325 | 2020-03-17 | Volusia | Florida | 12127 | 9 | 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);