ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 4 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1748771 | 1748771 | 2021-09-24 | Unknown | Florida | 4 | 2340 | |
271683 | 271683 | 2020-06-25 | Franklin | Florida | 12037 | 4 | 0 |
268547 | 268547 | 2020-06-24 | Franklin | Florida | 12037 | 4 | 0 |
265417 | 265417 | 2020-06-23 | Franklin | Florida | 12037 | 4 | 0 |
262289 | 262289 | 2020-06-22 | Franklin | Florida | 12037 | 4 | 0 |
101373 | 101373 | 2020-04-30 | Union | Florida | 12125 | 4 | 0 |
98480 | 98480 | 2020-04-29 | Gilchrist | Florida | 12041 | 4 | 0 |
98523 | 98523 | 2020-04-29 | Union | Florida | 12125 | 4 | 0 |
95635 | 95635 | 2020-04-28 | Gilchrist | Florida | 12041 | 4 | 0 |
95678 | 95678 | 2020-04-28 | Union | Florida | 12125 | 4 | 0 |
95679 | 95679 | 2020-04-28 | Unknown | Florida | 4 | 0 | |
92803 | 92803 | 2020-04-27 | Gilchrist | Florida | 12041 | 4 | 0 |
92846 | 92846 | 2020-04-27 | Union | Florida | 12125 | 4 | 0 |
89985 | 89985 | 2020-04-26 | Gilchrist | Florida | 12041 | 4 | 0 |
90028 | 90028 | 2020-04-26 | Union | Florida | 12125 | 4 | 0 |
87168 | 87168 | 2020-04-25 | Gilchrist | Florida | 12041 | 4 | 0 |
87211 | 87211 | 2020-04-25 | Union | Florida | 12125 | 4 | 0 |
84360 | 84360 | 2020-04-24 | Gilchrist | Florida | 12041 | 4 | 0 |
84403 | 84403 | 2020-04-24 | Union | Florida | 12125 | 4 | 0 |
81554 | 81554 | 2020-04-23 | Dixie | Florida | 12029 | 4 | 0 |
81560 | 81560 | 2020-04-23 | Gilchrist | Florida | 12041 | 4 | 0 |
78760 | 78760 | 2020-04-22 | Dixie | Florida | 12029 | 4 | 0 |
78766 | 78766 | 2020-04-22 | Gilchrist | Florida | 12041 | 4 | 0 |
78770 | 78770 | 2020-04-22 | Hardee | Florida | 12049 | 4 | 0 |
75976 | 75976 | 2020-04-21 | Dixie | Florida | 12029 | 4 | 0 |
75982 | 75982 | 2020-04-21 | Gilchrist | Florida | 12041 | 4 | 0 |
75985 | 75985 | 2020-04-21 | Hamilton | Florida | 12047 | 4 | 0 |
75986 | 75986 | 2020-04-21 | Hardee | Florida | 12049 | 4 | 0 |
76026 | 76026 | 2020-04-21 | Unknown | Florida | 4 | 0 | |
73200 | 73200 | 2020-04-20 | Dixie | Florida | 12029 | 4 | 0 |
73206 | 73206 | 2020-04-20 | Gilchrist | Florida | 12041 | 4 | 0 |
73210 | 73210 | 2020-04-20 | Hardee | Florida | 12049 | 4 | 0 |
70437 | 70437 | 2020-04-19 | Gilchrist | Florida | 12041 | 4 | 0 |
70441 | 70441 | 2020-04-19 | Hardee | Florida | 12049 | 4 | 0 |
67675 | 67675 | 2020-04-18 | Gilchrist | Florida | 12041 | 4 | 0 |
67679 | 67679 | 2020-04-18 | Hardee | Florida | 12049 | 4 | 0 |
64927 | 64927 | 2020-04-17 | Gilchrist | Florida | 12041 | 4 | 0 |
64931 | 64931 | 2020-04-17 | Hardee | Florida | 12049 | 4 | 0 |
64971 | 64971 | 2020-04-17 | Unknown | Florida | 4 | 0 | |
62194 | 62194 | 2020-04-16 | Gilchrist | Florida | 12041 | 4 | 0 |
62198 | 62198 | 2020-04-16 | Hardee | Florida | 12049 | 4 | 0 |
62203 | 62203 | 2020-04-16 | Holmes | Florida | 12059 | 4 | 0 |
59484 | 59484 | 2020-04-15 | Holmes | Florida | 12059 | 4 | 0 |
56776 | 56776 | 2020-04-14 | Holmes | Florida | 12059 | 4 | 0 |
54075 | 54075 | 2020-04-13 | Gilchrist | Florida | 12041 | 4 | 0 |
54123 | 54123 | 2020-04-13 | Washington | Florida | 12133 | 4 | 0 |
51395 | 51395 | 2020-04-12 | Gilchrist | Florida | 12041 | 4 | 0 |
51396 | 51396 | 2020-04-12 | Glades | Florida | 12043 | 4 | 1 |
51443 | 51443 | 2020-04-12 | Washington | Florida | 12133 | 4 | 0 |
48734 | 48734 | 2020-04-11 | Gilchrist | Florida | 12041 | 4 | 0 |
48735 | 48735 | 2020-04-11 | Glades | Florida | 12043 | 4 | 1 |
46104 | 46104 | 2020-04-10 | Gilchrist | Florida | 12041 | 4 | 0 |
46105 | 46105 | 2020-04-10 | Glades | Florida | 12043 | 4 | 1 |
43490 | 43490 | 2020-04-09 | Calhoun | Florida | 12013 | 4 | 0 |
43504 | 43504 | 2020-04-09 | Glades | Florida | 12043 | 4 | 1 |
40916 | 40916 | 2020-04-08 | Calhoun | Florida | 12013 | 4 | 0 |
40930 | 40930 | 2020-04-08 | Glades | Florida | 12043 | 4 | 1 |
40940 | 40940 | 2020-04-08 | Jackson | Florida | 12063 | 4 | 0 |
38387 | 38387 | 2020-04-07 | Glades | Florida | 12043 | 4 | 1 |
38397 | 38397 | 2020-04-07 | Jackson | Florida | 12063 | 4 | 0 |
38398 | 38398 | 2020-04-07 | Jefferson | Florida | 12065 | 4 | 0 |
35895 | 35895 | 2020-04-06 | Gadsden | Florida | 12039 | 4 | 0 |
35896 | 35896 | 2020-04-06 | Glades | Florida | 12043 | 4 | 1 |
35906 | 35906 | 2020-04-06 | Jackson | Florida | 12063 | 4 | 0 |
35911 | 35911 | 2020-04-06 | Levy | Florida | 12075 | 4 | 0 |
35920 | 35920 | 2020-04-06 | Okeechobee | Florida | 12093 | 4 | 0 |
33451 | 33451 | 2020-04-05 | Glades | Florida | 12043 | 4 | 1 |
33460 | 33460 | 2020-04-05 | Jackson | Florida | 12063 | 4 | 0 |
33465 | 33465 | 2020-04-05 | Levy | Florida | 12075 | 4 | 0 |
33490 | 33490 | 2020-04-05 | Unknown | Florida | 4 | 0 | |
31045 | 31045 | 2020-04-04 | Glades | Florida | 12043 | 4 | 1 |
31054 | 31054 | 2020-04-04 | Jackson | Florida | 12063 | 4 | 0 |
28679 | 28679 | 2020-04-03 | Columbia | Florida | 12023 | 4 | 0 |
28695 | 28695 | 2020-04-03 | Jackson | Florida | 12063 | 4 | 0 |
28700 | 28700 | 2020-04-03 | Madison | Florida | 12079 | 4 | 0 |
26377 | 26377 | 2020-04-02 | Columbia | Florida | 12023 | 4 | 0 |
26386 | 26386 | 2020-04-02 | Hendry | Florida | 12051 | 4 | 0 |
26392 | 26392 | 2020-04-02 | Jackson | Florida | 12063 | 4 | 0 |
24156 | 24156 | 2020-04-01 | Hendry | Florida | 12051 | 4 | 0 |
24162 | 24162 | 2020-04-01 | Jackson | Florida | 12063 | 4 | 0 |
21995 | 21995 | 2020-03-31 | Hendry | Florida | 12051 | 4 | 0 |
14246 | 14246 | 2020-03-27 | Bay | Florida | 12005 | 4 | 0 |
12581 | 12581 | 2020-03-26 | Charlotte | Florida | 12015 | 4 | 0 |
11038 | 11038 | 2020-03-25 | DeSoto | Florida | 12027 | 4 | 0 |
11056 | 11056 | 2020-03-25 | Nassau | Florida | 12089 | 4 | 0 |
9654 | 9654 | 2020-03-24 | Baker | Florida | 12003 | 4 | 0 |
9667 | 9667 | 2020-03-24 | Flagler | Florida | 12035 | 4 | 0 |
9669 | 9669 | 2020-03-24 | Highlands | Florida | 12055 | 4 | 0 |
9677 | 9677 | 2020-03-24 | Marion | Florida | 12083 | 4 | 0 |
9678 | 9678 | 2020-03-24 | Martin | Florida | 12085 | 4 | 0 |
8432 | 8432 | 2020-03-23 | Marion | Florida | 12083 | 4 | 0 |
8433 | 8433 | 2020-03-23 | Martin | Florida | 12085 | 4 | 0 |
8445 | 8445 | 2020-03-23 | Santa Rosa | Florida | 12113 | 4 | 1 |
7275 | 7275 | 2020-03-22 | Escambia | Florida | 12033 | 4 | 0 |
7284 | 7284 | 2020-03-22 | Leon | Florida | 12073 | 4 | 0 |
7307 | 7307 | 2020-03-22 | Walton | Florida | 12131 | 4 | 0 |
6244 | 6244 | 2020-03-21 | Leon | Florida | 12073 | 4 | 0 |
6264 | 6264 | 2020-03-21 | Sumter | Florida | 12119 | 4 | 0 |
6266 | 6266 | 2020-03-21 | Walton | Florida | 12131 | 4 | 0 |
5301 | 5301 | 2020-03-20 | Brevard | Florida | 12009 | 4 | 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);