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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386305 | 386305 | 2020-07-31 | Okaloosa | Florida | 12091 | 2764 | 28 |
383087 | 383087 | 2020-07-30 | Okaloosa | Florida | 12091 | 2703 | 24 |
379870 | 379870 | 2020-07-29 | Okaloosa | Florida | 12091 | 2576 | 22 |
376653 | 376653 | 2020-07-28 | Okaloosa | Florida | 12091 | 2481 | 20 |
373439 | 373439 | 2020-07-27 | Okaloosa | Florida | 12091 | 2410 | 20 |
370227 | 370227 | 2020-07-26 | Okaloosa | Florida | 12091 | 2367 | 20 |
367017 | 367017 | 2020-07-25 | Okaloosa | Florida | 12091 | 2274 | 20 |
363810 | 363810 | 2020-07-24 | Okaloosa | Florida | 12091 | 2201 | 16 |
360603 | 360603 | 2020-07-23 | Okaloosa | Florida | 12091 | 2133 | 16 |
357398 | 357398 | 2020-07-22 | Okaloosa | Florida | 12091 | 2103 | 16 |
354195 | 354195 | 2020-07-21 | Okaloosa | Florida | 12091 | 2061 | 16 |
350993 | 350993 | 2020-07-20 | Okaloosa | Florida | 12091 | 1972 | 15 |
347792 | 347792 | 2020-07-19 | Okaloosa | Florida | 12091 | 1812 | 15 |
344592 | 344592 | 2020-07-18 | Okaloosa | Florida | 12091 | 1752 | 12 |
341393 | 341393 | 2020-07-17 | Okaloosa | Florida | 12091 | 1697 | 12 |
338196 | 338196 | 2020-07-16 | Okaloosa | Florida | 12091 | 1622 | 12 |
335001 | 335001 | 2020-07-15 | Okaloosa | Florida | 12091 | 1531 | 10 |
331808 | 331808 | 2020-07-14 | Okaloosa | Florida | 12091 | 1444 | 10 |
328621 | 328621 | 2020-07-13 | Okaloosa | Florida | 12091 | 1384 | 10 |
325435 | 325435 | 2020-07-12 | Okaloosa | Florida | 12091 | 1284 | 10 |
322254 | 322254 | 2020-07-11 | Okaloosa | Florida | 12091 | 1129 | 10 |
319075 | 319075 | 2020-07-10 | Okaloosa | Florida | 12091 | 1082 | 10 |
315902 | 315902 | 2020-07-09 | Okaloosa | Florida | 12091 | 1014 | 10 |
312727 | 312727 | 2020-07-08 | Okaloosa | Florida | 12091 | 968 | 9 |
309557 | 309557 | 2020-07-07 | Okaloosa | Florida | 12091 | 937 | 9 |
306389 | 306389 | 2020-07-06 | Okaloosa | Florida | 12091 | 916 | 8 |
303225 | 303225 | 2020-07-05 | Okaloosa | Florida | 12091 | 905 | 8 |
300061 | 300061 | 2020-07-04 | Okaloosa | Florida | 12091 | 879 | 8 |
296899 | 296899 | 2020-07-03 | Okaloosa | Florida | 12091 | 819 | 8 |
293743 | 293743 | 2020-07-02 | Okaloosa | Florida | 12091 | 769 | 8 |
290589 | 290589 | 2020-07-01 | Okaloosa | Florida | 12091 | 703 | 7 |
287438 | 287438 | 2020-06-30 | Okaloosa | Florida | 12091 | 665 | 6 |
284292 | 284292 | 2020-06-29 | Okaloosa | Florida | 12091 | 635 | 6 |
281146 | 281146 | 2020-06-28 | Okaloosa | Florida | 12091 | 600 | 6 |
277999 | 277999 | 2020-06-27 | Okaloosa | Florida | 12091 | 562 | 6 |
274851 | 274851 | 2020-06-26 | Okaloosa | Florida | 12091 | 540 | 6 |
271711 | 271711 | 2020-06-25 | Okaloosa | Florida | 12091 | 499 | 6 |
268575 | 268575 | 2020-06-24 | Okaloosa | Florida | 12091 | 456 | 6 |
265445 | 265445 | 2020-06-23 | Okaloosa | Florida | 12091 | 435 | 6 |
262317 | 262317 | 2020-06-22 | Okaloosa | Florida | 12091 | 420 | 6 |
259190 | 259190 | 2020-06-21 | Okaloosa | Florida | 12091 | 399 | 6 |
256063 | 256063 | 2020-06-20 | Okaloosa | Florida | 12091 | 397 | 6 |
252944 | 252944 | 2020-06-19 | Okaloosa | Florida | 12091 | 390 | 6 |
249829 | 249829 | 2020-06-18 | Okaloosa | Florida | 12091 | 365 | 6 |
246717 | 246717 | 2020-06-17 | Okaloosa | Florida | 12091 | 350 | 6 |
243604 | 243604 | 2020-06-16 | Okaloosa | Florida | 12091 | 343 | 6 |
240493 | 240493 | 2020-06-15 | Okaloosa | Florida | 12091 | 336 | 6 |
237385 | 237385 | 2020-06-14 | Okaloosa | Florida | 12091 | 331 | 6 |
234278 | 234278 | 2020-06-13 | Okaloosa | Florida | 12091 | 314 | 6 |
231172 | 231172 | 2020-06-12 | Okaloosa | Florida | 12091 | 311 | 6 |
228069 | 228069 | 2020-06-11 | Okaloosa | Florida | 12091 | 293 | 6 |
224967 | 224967 | 2020-06-10 | Okaloosa | Florida | 12091 | 286 | 6 |
221872 | 221872 | 2020-06-09 | Okaloosa | Florida | 12091 | 273 | 6 |
218777 | 218777 | 2020-06-08 | Okaloosa | Florida | 12091 | 270 | 6 |
215686 | 215686 | 2020-06-07 | Okaloosa | Florida | 12091 | 261 | 6 |
212599 | 212599 | 2020-06-06 | Okaloosa | Florida | 12091 | 252 | 6 |
209514 | 209514 | 2020-06-05 | Okaloosa | Florida | 12091 | 249 | 6 |
206433 | 206433 | 2020-06-04 | Okaloosa | Florida | 12091 | 240 | 6 |
203353 | 203353 | 2020-06-03 | Okaloosa | Florida | 12091 | 235 | 6 |
200277 | 200277 | 2020-06-02 | Okaloosa | Florida | 12091 | 234 | 6 |
197204 | 197204 | 2020-06-01 | Okaloosa | Florida | 12091 | 231 | 6 |
194134 | 194134 | 2020-05-31 | Okaloosa | Florida | 12091 | 222 | 6 |
191067 | 191067 | 2020-05-30 | Okaloosa | Florida | 12091 | 211 | 6 |
188002 | 188002 | 2020-05-29 | Okaloosa | Florida | 12091 | 206 | 6 |
184946 | 184946 | 2020-05-28 | Okaloosa | Florida | 12091 | 198 | 6 |
181892 | 181892 | 2020-05-27 | Okaloosa | Florida | 12091 | 197 | 6 |
178848 | 178848 | 2020-05-26 | Okaloosa | Florida | 12091 | 193 | 6 |
175804 | 175804 | 2020-05-25 | Okaloosa | Florida | 12091 | 192 | 6 |
172761 | 172761 | 2020-05-24 | Okaloosa | Florida | 12091 | 192 | 6 |
169720 | 169720 | 2020-05-23 | Okaloosa | Florida | 12091 | 191 | 6 |
166683 | 166683 | 2020-05-22 | Okaloosa | Florida | 12091 | 184 | 6 |
163650 | 163650 | 2020-05-21 | Okaloosa | Florida | 12091 | 183 | 6 |
160622 | 160622 | 2020-05-20 | Okaloosa | Florida | 12091 | 183 | 5 |
157596 | 157596 | 2020-05-19 | Okaloosa | Florida | 12091 | 179 | 5 |
154580 | 154580 | 2020-05-18 | Okaloosa | Florida | 12091 | 177 | 5 |
151568 | 151568 | 2020-05-17 | Okaloosa | Florida | 12091 | 176 | 5 |
148559 | 148559 | 2020-05-16 | Okaloosa | Florida | 12091 | 176 | 5 |
145556 | 145556 | 2020-05-15 | Okaloosa | Florida | 12091 | 173 | 5 |
142556 | 142556 | 2020-05-14 | Okaloosa | Florida | 12091 | 171 | 5 |
139560 | 139560 | 2020-05-13 | Okaloosa | Florida | 12091 | 169 | 5 |
136569 | 136569 | 2020-05-12 | Okaloosa | Florida | 12091 | 168 | 5 |
133580 | 133580 | 2020-05-11 | Okaloosa | Florida | 12091 | 168 | 5 |
130589 | 130589 | 2020-05-10 | Okaloosa | Florida | 12091 | 168 | 5 |
127598 | 127598 | 2020-05-09 | Okaloosa | Florida | 12091 | 167 | 5 |
124611 | 124611 | 2020-05-08 | Okaloosa | Florida | 12091 | 164 | 5 |
121632 | 121632 | 2020-05-07 | Okaloosa | Florida | 12091 | 162 | 5 |
118663 | 118663 | 2020-05-06 | Okaloosa | Florida | 12091 | 161 | 5 |
115703 | 115703 | 2020-05-05 | Okaloosa | Florida | 12091 | 160 | 5 |
112820 | 112820 | 2020-05-04 | Okaloosa | Florida | 12091 | 159 | 5 |
109945 | 109945 | 2020-05-03 | Okaloosa | Florida | 12091 | 159 | 5 |
107076 | 107076 | 2020-05-02 | Okaloosa | Florida | 12091 | 157 | 5 |
104211 | 104211 | 2020-05-01 | Okaloosa | Florida | 12091 | 155 | 4 |
101356 | 101356 | 2020-04-30 | Okaloosa | Florida | 12091 | 153 | 4 |
98506 | 98506 | 2020-04-29 | Okaloosa | Florida | 12091 | 152 | 3 |
95661 | 95661 | 2020-04-28 | Okaloosa | Florida | 12091 | 151 | 3 |
92829 | 92829 | 2020-04-27 | Okaloosa | Florida | 12091 | 148 | 3 |
90011 | 90011 | 2020-04-26 | Okaloosa | Florida | 12091 | 148 | 3 |
87194 | 87194 | 2020-04-25 | Okaloosa | Florida | 12091 | 148 | 3 |
84386 | 84386 | 2020-04-24 | Okaloosa | Florida | 12091 | 144 | 3 |
81586 | 81586 | 2020-04-23 | Okaloosa | Florida | 12091 | 140 | 3 |
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);