ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where cases = 5 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Glades 14
- Okeechobee 11
- Union 8
- Calhoun 7
- Unknown 7
- Washington 5
- Lafayette 4
- Dixie 3
- Gilchrist 3
- Hernando 3
- Palm Beach 3
- Taylor 3
- Baker 2
- Bradford 2
- Highlands 2
- Holmes 2
- Jackson 2
- Lee 2
- Marion 2
- Bay 1
- Brevard 1
- Broward 1
- Collier 1
- DeSoto 1
- Duval 1
- Gadsden 1
- Hamilton 1
- Hardee 1
- Hendry 1
- Indian River 1
- …
state 1
- Florida · 107 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2077000 | 2077000 | 2022-01-03 | Unknown | Florida | 5 | 162 | |
2073749 | 2073749 | 2022-01-02 | Unknown | Florida | 5 | 162 | |
2070498 | 2070498 | 2022-01-01 | Unknown | Florida | 5 | 162 | |
2067247 | 2067247 | 2021-12-31 | Unknown | Florida | 5 | 162 | |
1657810 | 1657810 | 2021-08-27 | Unknown | Florida | 5 | 7006 | |
1635068 | 1635068 | 2021-08-20 | Unknown | Florida | 5 | 5279 | |
160638 | 160638 | 2020-05-20 | Taylor | Florida | 12123 | 5 | 0 |
157612 | 157612 | 2020-05-19 | Taylor | Florida | 12123 | 5 | 0 |
154596 | 154596 | 2020-05-18 | Taylor | Florida | 12123 | 5 | 0 |
145543 | 145543 | 2020-05-15 | Lafayette | Florida | 12067 | 5 | 0 |
142543 | 142543 | 2020-05-14 | Lafayette | Florida | 12067 | 5 | 0 |
139547 | 139547 | 2020-05-13 | Lafayette | Florida | 12067 | 5 | 0 |
136556 | 136556 | 2020-05-12 | Lafayette | Florida | 12067 | 5 | 0 |
124628 | 124628 | 2020-05-08 | Union | Florida | 12125 | 5 | 0 |
121649 | 121649 | 2020-05-07 | Union | Florida | 12125 | 5 | 0 |
118680 | 118680 | 2020-05-06 | Union | Florida | 12125 | 5 | 0 |
115720 | 115720 | 2020-05-05 | Union | Florida | 12125 | 5 | 0 |
112837 | 112837 | 2020-05-04 | Union | Florida | 12125 | 5 | 0 |
109962 | 109962 | 2020-05-03 | Union | Florida | 12125 | 5 | 0 |
107050 | 107050 | 2020-05-02 | Gilchrist | Florida | 12041 | 5 | 0 |
107093 | 107093 | 2020-05-02 | Union | Florida | 12125 | 5 | 0 |
104185 | 104185 | 2020-05-01 | Gilchrist | Florida | 12041 | 5 | 0 |
104228 | 104228 | 2020-05-01 | Union | Florida | 12125 | 5 | 0 |
101330 | 101330 | 2020-04-30 | Gilchrist | Florida | 12041 | 5 | 0 |
95636 | 95636 | 2020-04-28 | Glades | Florida | 12043 | 5 | 1 |
92797 | 92797 | 2020-04-27 | Dixie | Florida | 12029 | 5 | 0 |
89979 | 89979 | 2020-04-26 | Dixie | Florida | 12029 | 5 | 0 |
87169 | 87169 | 2020-04-25 | Glades | Florida | 12043 | 5 | 1 |
84354 | 84354 | 2020-04-24 | Dixie | Florida | 12029 | 5 | 0 |
84361 | 84361 | 2020-04-24 | Glades | Florida | 12043 | 5 | 1 |
81561 | 81561 | 2020-04-23 | Glades | Florida | 12043 | 5 | 1 |
81564 | 81564 | 2020-04-23 | Hardee | Florida | 12049 | 5 | 0 |
78767 | 78767 | 2020-04-22 | Glades | Florida | 12043 | 5 | 1 |
78769 | 78769 | 2020-04-22 | Hamilton | Florida | 12047 | 5 | 0 |
75983 | 75983 | 2020-04-21 | Glades | Florida | 12043 | 5 | 1 |
73207 | 73207 | 2020-04-20 | Glades | Florida | 12043 | 5 | 1 |
70438 | 70438 | 2020-04-19 | Glades | Florida | 12043 | 5 | 1 |
67676 | 67676 | 2020-04-18 | Glades | Florida | 12043 | 5 | 1 |
67684 | 67684 | 2020-04-18 | Holmes | Florida | 12059 | 5 | 0 |
67723 | 67723 | 2020-04-18 | Washington | Florida | 12133 | 5 | 0 |
64928 | 64928 | 2020-04-17 | Glades | Florida | 12043 | 5 | 1 |
64936 | 64936 | 2020-04-17 | Holmes | Florida | 12059 | 5 | 0 |
64954 | 64954 | 2020-04-17 | Okeechobee | Florida | 12093 | 5 | 0 |
62181 | 62181 | 2020-04-16 | Calhoun | Florida | 12013 | 5 | 0 |
62195 | 62195 | 2020-04-16 | Glades | Florida | 12043 | 5 | 1 |
62221 | 62221 | 2020-04-16 | Okeechobee | Florida | 12093 | 5 | 0 |
62242 | 62242 | 2020-04-16 | Washington | Florida | 12133 | 5 | 0 |
59462 | 59462 | 2020-04-15 | Calhoun | Florida | 12013 | 5 | 0 |
59476 | 59476 | 2020-04-15 | Glades | Florida | 12043 | 5 | 1 |
59502 | 59502 | 2020-04-15 | Okeechobee | Florida | 12093 | 5 | 0 |
59522 | 59522 | 2020-04-15 | Washington | Florida | 12133 | 5 | 0 |
56754 | 56754 | 2020-04-14 | Calhoun | Florida | 12013 | 5 | 0 |
56768 | 56768 | 2020-04-14 | Glades | Florida | 12043 | 5 | 1 |
56794 | 56794 | 2020-04-14 | Okeechobee | Florida | 12093 | 5 | 0 |
56815 | 56815 | 2020-04-14 | Washington | Florida | 12133 | 5 | 0 |
54062 | 54062 | 2020-04-13 | Calhoun | Florida | 12013 | 5 | 0 |
54076 | 54076 | 2020-04-13 | Glades | Florida | 12043 | 5 | 1 |
54102 | 54102 | 2020-04-13 | Okeechobee | Florida | 12093 | 5 | 0 |
51382 | 51382 | 2020-04-12 | Calhoun | Florida | 12013 | 5 | 0 |
51422 | 51422 | 2020-04-12 | Okeechobee | Florida | 12093 | 5 | 0 |
48721 | 48721 | 2020-04-11 | Calhoun | Florida | 12013 | 5 | 0 |
48761 | 48761 | 2020-04-11 | Okeechobee | Florida | 12093 | 5 | 0 |
48782 | 48782 | 2020-04-11 | Washington | Florida | 12133 | 5 | 0 |
46091 | 46091 | 2020-04-10 | Calhoun | Florida | 12013 | 5 | 0 |
46115 | 46115 | 2020-04-10 | Jackson | Florida | 12063 | 5 | 0 |
46131 | 46131 | 2020-04-10 | Okeechobee | Florida | 12093 | 5 | 0 |
43514 | 43514 | 2020-04-09 | Jackson | Florida | 12063 | 5 | 0 |
43529 | 43529 | 2020-04-09 | Okeechobee | Florida | 12093 | 5 | 0 |
40955 | 40955 | 2020-04-08 | Okeechobee | Florida | 12093 | 5 | 0 |
38385 | 38385 | 2020-04-07 | Gadsden | Florida | 12039 | 5 | 0 |
38402 | 38402 | 2020-04-07 | Levy | Florida | 12075 | 5 | 0 |
38411 | 38411 | 2020-04-07 | Okeechobee | Florida | 12093 | 5 | 0 |
35936 | 35936 | 2020-04-06 | Unknown | Florida | 5 | 0 | |
31086 | 31086 | 2020-04-04 | Wakulla | Florida | 12129 | 5 | 0 |
28671 | 28671 | 2020-04-03 | Bradford | Florida | 12007 | 5 | 0 |
28689 | 28689 | 2020-04-03 | Hendry | Florida | 12051 | 5 | 0 |
26369 | 26369 | 2020-04-02 | Bradford | Florida | 12007 | 5 | 0 |
16030 | 16030 | 2020-03-28 | Bay | Florida | 12005 | 5 | 0 |
12576 | 12576 | 2020-03-26 | Baker | Florida | 12003 | 5 | 0 |
12586 | 12586 | 2020-03-26 | DeSoto | Florida | 12027 | 5 | 0 |
12592 | 12592 | 2020-03-26 | Highlands | Florida | 12055 | 5 | 1 |
12600 | 12600 | 2020-03-26 | Marion | Florida | 12083 | 5 | 0 |
12604 | 12604 | 2020-03-26 | Nassau | Florida | 12089 | 5 | 0 |
11028 | 11028 | 2020-03-25 | Baker | Florida | 12003 | 5 | 0 |
11044 | 11044 | 2020-03-25 | Highlands | Florida | 12055 | 5 | 0 |
11052 | 11052 | 2020-03-25 | Marion | Florida | 12083 | 5 | 0 |
11064 | 11064 | 2020-03-25 | Putnam | Florida | 12107 | 5 | 0 |
8423 | 8423 | 2020-03-23 | Hernando | Florida | 12053 | 5 | 0 |
8430 | 8430 | 2020-03-23 | Leon | Florida | 12073 | 5 | 0 |
8449 | 8449 | 2020-03-23 | St. Lucie | Florida | 12111 | 5 | 0 |
7277 | 7277 | 2020-03-22 | Hernando | Florida | 12053 | 5 | 0 |
7304 | 7304 | 2020-03-22 | Sumter | Florida | 12119 | 5 | 0 |
6229 | 6229 | 2020-03-21 | Brevard | Florida | 12009 | 5 | 0 |
6237 | 6237 | 2020-03-21 | Hernando | Florida | 12053 | 5 | 0 |
6240 | 6240 | 2020-03-21 | Indian River | Florida | 12061 | 5 | 0 |
4541 | 4541 | 2020-03-19 | Okaloosa | Florida | 12091 | 5 | 0 |
4545 | 4545 | 2020-03-19 | Pasco | Florida | 12101 | 5 | 0 |
2822 | 2822 | 2020-03-16 | Duval | Florida | 12031 | 5 | 0 |
2826 | 2826 | 2020-03-16 | Lee | Florida | 12071 | 5 | 2 |
2827 | 2827 | 2020-03-16 | Manatee | Florida | 12081 | 5 | 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);