ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Okaloosa" and state = "Florida" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
689 | 689 | 2020-03-07 | Okaloosa | Florida | 12091 | 1 | 0 |
785 | 785 | 2020-03-08 | Okaloosa | Florida | 12091 | 1 | 0 |
902 | 902 | 2020-03-09 | Okaloosa | Florida | 12091 | 1 | 0 |
1040 | 1040 | 2020-03-10 | Okaloosa | Florida | 12091 | 1 | 0 |
1210 | 1210 | 2020-03-11 | Okaloosa | Florida | 12091 | 1 | 0 |
1421 | 1421 | 2020-03-12 | Okaloosa | Florida | 12091 | 1 | 0 |
1687 | 1687 | 2020-03-13 | Okaloosa | Florida | 12091 | 1 | 0 |
2009 | 2009 | 2020-03-14 | Okaloosa | Florida | 12091 | 1 | 0 |
2393 | 2393 | 2020-03-15 | Okaloosa | Florida | 12091 | 1 | 0 |
2830 | 2830 | 2020-03-16 | Okaloosa | Florida | 12091 | 1 | 0 |
3314 | 3314 | 2020-03-17 | Okaloosa | Florida | 12091 | 2 | 0 |
3872 | 3872 | 2020-03-18 | Okaloosa | Florida | 12091 | 3 | 0 |
4541 | 4541 | 2020-03-19 | Okaloosa | Florida | 12091 | 5 | 0 |
5321 | 5321 | 2020-03-20 | Okaloosa | Florida | 12091 | 7 | 0 |
6251 | 6251 | 2020-03-21 | Okaloosa | Florida | 12091 | 12 | 0 |
7291 | 7291 | 2020-03-22 | Okaloosa | Florida | 12091 | 13 | 0 |
8437 | 8437 | 2020-03-23 | Okaloosa | Florida | 12091 | 13 | 0 |
9682 | 9682 | 2020-03-24 | Okaloosa | Florida | 12091 | 13 | 0 |
11057 | 11057 | 2020-03-25 | Okaloosa | Florida | 12091 | 18 | 0 |
12605 | 12605 | 2020-03-26 | Okaloosa | Florida | 12091 | 21 | 0 |
14275 | 14275 | 2020-03-27 | Okaloosa | Florida | 12091 | 25 | 0 |
16060 | 16060 | 2020-03-28 | Okaloosa | Florida | 12091 | 31 | 0 |
17953 | 17953 | 2020-03-29 | Okaloosa | Florida | 12091 | 31 | 0 |
19934 | 19934 | 2020-03-30 | Okaloosa | Florida | 12091 | 35 | 1 |
22012 | 22012 | 2020-03-31 | Okaloosa | Florida | 12091 | 39 | 1 |
24174 | 24174 | 2020-04-01 | Okaloosa | Florida | 12091 | 44 | 1 |
26404 | 26404 | 2020-04-02 | Okaloosa | Florida | 12091 | 50 | 1 |
28707 | 28707 | 2020-04-03 | Okaloosa | Florida | 12091 | 53 | 1 |
31067 | 31067 | 2020-04-04 | Okaloosa | Florida | 12091 | 58 | 1 |
33473 | 33473 | 2020-04-05 | Okaloosa | Florida | 12091 | 61 | 1 |
35919 | 35919 | 2020-04-06 | Okaloosa | Florida | 12091 | 64 | 1 |
38410 | 38410 | 2020-04-07 | Okaloosa | Florida | 12091 | 69 | 1 |
40954 | 40954 | 2020-04-08 | Okaloosa | Florida | 12091 | 77 | 1 |
43528 | 43528 | 2020-04-09 | Okaloosa | Florida | 12091 | 82 | 1 |
46130 | 46130 | 2020-04-10 | Okaloosa | Florida | 12091 | 84 | 1 |
48760 | 48760 | 2020-04-11 | Okaloosa | Florida | 12091 | 90 | 1 |
51421 | 51421 | 2020-04-12 | Okaloosa | Florida | 12091 | 100 | 1 |
54101 | 54101 | 2020-04-13 | Okaloosa | Florida | 12091 | 102 | 1 |
56793 | 56793 | 2020-04-14 | Okaloosa | Florida | 12091 | 103 | 1 |
59501 | 59501 | 2020-04-15 | Okaloosa | Florida | 12091 | 107 | 1 |
62220 | 62220 | 2020-04-16 | Okaloosa | Florida | 12091 | 116 | 1 |
64953 | 64953 | 2020-04-17 | Okaloosa | Florida | 12091 | 123 | 1 |
67701 | 67701 | 2020-04-18 | Okaloosa | Florida | 12091 | 126 | 1 |
70463 | 70463 | 2020-04-19 | Okaloosa | Florida | 12091 | 130 | 3 |
73232 | 73232 | 2020-04-20 | Okaloosa | Florida | 12091 | 130 | 3 |
76008 | 76008 | 2020-04-21 | Okaloosa | Florida | 12091 | 133 | 3 |
78792 | 78792 | 2020-04-22 | Okaloosa | Florida | 12091 | 134 | 3 |
81586 | 81586 | 2020-04-23 | Okaloosa | Florida | 12091 | 140 | 3 |
84386 | 84386 | 2020-04-24 | Okaloosa | Florida | 12091 | 144 | 3 |
87194 | 87194 | 2020-04-25 | Okaloosa | Florida | 12091 | 148 | 3 |
90011 | 90011 | 2020-04-26 | Okaloosa | Florida | 12091 | 148 | 3 |
92829 | 92829 | 2020-04-27 | Okaloosa | Florida | 12091 | 148 | 3 |
95661 | 95661 | 2020-04-28 | Okaloosa | Florida | 12091 | 151 | 3 |
98506 | 98506 | 2020-04-29 | Okaloosa | Florida | 12091 | 152 | 3 |
101356 | 101356 | 2020-04-30 | Okaloosa | Florida | 12091 | 153 | 4 |
104211 | 104211 | 2020-05-01 | Okaloosa | Florida | 12091 | 155 | 4 |
107076 | 107076 | 2020-05-02 | Okaloosa | Florida | 12091 | 157 | 5 |
109945 | 109945 | 2020-05-03 | Okaloosa | Florida | 12091 | 159 | 5 |
112820 | 112820 | 2020-05-04 | Okaloosa | Florida | 12091 | 159 | 5 |
115703 | 115703 | 2020-05-05 | Okaloosa | Florida | 12091 | 160 | 5 |
118663 | 118663 | 2020-05-06 | Okaloosa | Florida | 12091 | 161 | 5 |
121632 | 121632 | 2020-05-07 | Okaloosa | Florida | 12091 | 162 | 5 |
124611 | 124611 | 2020-05-08 | Okaloosa | Florida | 12091 | 164 | 5 |
127598 | 127598 | 2020-05-09 | Okaloosa | Florida | 12091 | 167 | 5 |
130589 | 130589 | 2020-05-10 | Okaloosa | Florida | 12091 | 168 | 5 |
133580 | 133580 | 2020-05-11 | Okaloosa | Florida | 12091 | 168 | 5 |
136569 | 136569 | 2020-05-12 | Okaloosa | Florida | 12091 | 168 | 5 |
139560 | 139560 | 2020-05-13 | Okaloosa | Florida | 12091 | 169 | 5 |
142556 | 142556 | 2020-05-14 | Okaloosa | Florida | 12091 | 171 | 5 |
145556 | 145556 | 2020-05-15 | Okaloosa | Florida | 12091 | 173 | 5 |
148559 | 148559 | 2020-05-16 | Okaloosa | Florida | 12091 | 176 | 5 |
151568 | 151568 | 2020-05-17 | Okaloosa | Florida | 12091 | 176 | 5 |
154580 | 154580 | 2020-05-18 | Okaloosa | Florida | 12091 | 177 | 5 |
157596 | 157596 | 2020-05-19 | Okaloosa | Florida | 12091 | 179 | 5 |
160622 | 160622 | 2020-05-20 | Okaloosa | Florida | 12091 | 183 | 5 |
163650 | 163650 | 2020-05-21 | Okaloosa | Florida | 12091 | 183 | 6 |
166683 | 166683 | 2020-05-22 | Okaloosa | Florida | 12091 | 184 | 6 |
169720 | 169720 | 2020-05-23 | Okaloosa | Florida | 12091 | 191 | 6 |
172761 | 172761 | 2020-05-24 | Okaloosa | Florida | 12091 | 192 | 6 |
175804 | 175804 | 2020-05-25 | Okaloosa | Florida | 12091 | 192 | 6 |
178848 | 178848 | 2020-05-26 | Okaloosa | Florida | 12091 | 193 | 6 |
181892 | 181892 | 2020-05-27 | Okaloosa | Florida | 12091 | 197 | 6 |
184946 | 184946 | 2020-05-28 | Okaloosa | Florida | 12091 | 198 | 6 |
188002 | 188002 | 2020-05-29 | Okaloosa | Florida | 12091 | 206 | 6 |
191067 | 191067 | 2020-05-30 | Okaloosa | Florida | 12091 | 211 | 6 |
194134 | 194134 | 2020-05-31 | Okaloosa | Florida | 12091 | 222 | 6 |
197204 | 197204 | 2020-06-01 | Okaloosa | Florida | 12091 | 231 | 6 |
200277 | 200277 | 2020-06-02 | Okaloosa | Florida | 12091 | 234 | 6 |
203353 | 203353 | 2020-06-03 | Okaloosa | Florida | 12091 | 235 | 6 |
206433 | 206433 | 2020-06-04 | Okaloosa | Florida | 12091 | 240 | 6 |
209514 | 209514 | 2020-06-05 | Okaloosa | Florida | 12091 | 249 | 6 |
212599 | 212599 | 2020-06-06 | Okaloosa | Florida | 12091 | 252 | 6 |
215686 | 215686 | 2020-06-07 | Okaloosa | Florida | 12091 | 261 | 6 |
218777 | 218777 | 2020-06-08 | Okaloosa | Florida | 12091 | 270 | 6 |
221872 | 221872 | 2020-06-09 | Okaloosa | Florida | 12091 | 273 | 6 |
224967 | 224967 | 2020-06-10 | Okaloosa | Florida | 12091 | 286 | 6 |
228069 | 228069 | 2020-06-11 | Okaloosa | Florida | 12091 | 293 | 6 |
231172 | 231172 | 2020-06-12 | Okaloosa | Florida | 12091 | 311 | 6 |
234278 | 234278 | 2020-06-13 | Okaloosa | Florida | 12091 | 314 | 6 |
237385 | 237385 | 2020-06-14 | Okaloosa | Florida | 12091 | 331 | 6 |
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);