ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 20 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
268562 | 268562 | 2020-06-24 | Lafayette | Florida | 12067 | 20 | 0 |
265432 | 265432 | 2020-06-23 | Lafayette | Florida | 12067 | 20 | 0 |
262304 | 262304 | 2020-06-22 | Lafayette | Florida | 12067 | 20 | 0 |
228043 | 228043 | 2020-06-11 | Gilchrist | Florida | 12041 | 20 | 0 |
215660 | 215660 | 2020-06-07 | Gilchrist | Florida | 12041 | 20 | 0 |
191083 | 191083 | 2020-05-30 | Taylor | Florida | 12123 | 20 | 0 |
175779 | 175779 | 2020-05-25 | Glades | Florida | 12043 | 20 | 1 |
172736 | 172736 | 2020-05-24 | Glades | Florida | 12043 | 20 | 1 |
169695 | 169695 | 2020-05-23 | Glades | Florida | 12043 | 20 | 1 |
148576 | 148576 | 2020-05-16 | Union | Florida | 12125 | 20 | 0 |
133571 | 133571 | 2020-05-11 | Levy | Florida | 12075 | 20 | 0 |
130580 | 130580 | 2020-05-10 | Levy | Florida | 12075 | 20 | 0 |
127589 | 127589 | 2020-05-09 | Levy | Florida | 12075 | 20 | 0 |
124602 | 124602 | 2020-05-08 | Levy | Florida | 12075 | 20 | 0 |
121623 | 121623 | 2020-05-07 | Levy | Florida | 12075 | 20 | 0 |
118654 | 118654 | 2020-05-06 | Levy | Florida | 12075 | 20 | 0 |
115694 | 115694 | 2020-05-05 | Levy | Florida | 12075 | 20 | 0 |
112811 | 112811 | 2020-05-04 | Levy | Florida | 12075 | 20 | 0 |
101312 | 101312 | 2020-04-30 | Baker | Florida | 12003 | 20 | 3 |
98462 | 98462 | 2020-04-29 | Baker | Florida | 12003 | 20 | 3 |
95617 | 95617 | 2020-04-28 | Baker | Florida | 12003 | 20 | 3 |
92785 | 92785 | 2020-04-27 | Baker | Florida | 12003 | 20 | 3 |
89967 | 89967 | 2020-04-26 | Baker | Florida | 12003 | 20 | 3 |
87150 | 87150 | 2020-04-25 | Baker | Florida | 12003 | 20 | 3 |
87214 | 87214 | 2020-04-25 | Wakulla | Florida | 12129 | 20 | 1 |
84342 | 84342 | 2020-04-24 | Baker | Florida | 12003 | 20 | 3 |
84405 | 84405 | 2020-04-24 | Wakulla | Florida | 12129 | 20 | 1 |
67694 | 67694 | 2020-04-18 | Madison | Florida | 12079 | 20 | 0 |
51388 | 51388 | 2020-04-12 | DeSoto | Florida | 12027 | 20 | 3 |
51400 | 51400 | 2020-04-12 | Hendry | Florida | 12051 | 20 | 0 |
48727 | 48727 | 2020-04-11 | DeSoto | Florida | 12027 | 20 | 3 |
46097 | 46097 | 2020-04-10 | DeSoto | Florida | 12027 | 20 | 3 |
43487 | 43487 | 2020-04-09 | Bradford | Florida | 12007 | 20 | 0 |
43496 | 43496 | 2020-04-09 | DeSoto | Florida | 12027 | 20 | 3 |
38418 | 38418 | 2020-04-07 | Putnam | Florida | 12107 | 20 | 1 |
19906 | 19906 | 2020-03-30 | Charlotte | Florida | 12015 | 20 | 0 |
17938 | 17938 | 2020-03-29 | Hernando | Florida | 12053 | 20 | 0 |
17941 | 17941 | 2020-03-29 | Indian River | Florida | 12061 | 20 | 0 |
14248 | 14248 | 2020-03-27 | Brevard | Florida | 12009 | 20 | 0 |
12583 | 12583 | 2020-03-26 | Clay | Florida | 12019 | 20 | 4 |
12588 | 12588 | 2020-03-26 | Escambia | Florida | 12033 | 20 | 0 |
12611 | 12611 | 2020-03-26 | Polk | Florida | 12105 | 20 | 0 |
4531 | 4531 | 2020-03-19 | Hillsborough | Florida | 12057 | 20 | 0 |
3875 | 3875 | 2020-03-18 | Palm Beach | Florida | 12099 | 20 | 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);