ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 12091 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534789 | 534789 | 2020-09-15 | Okaloosa | Florida | 12091 | 4675 | 94 |
531554 | 531554 | 2020-09-14 | Okaloosa | Florida | 12091 | 4636 | 94 |
528317 | 528317 | 2020-09-13 | Okaloosa | Florida | 12091 | 4619 | 94 |
525081 | 525081 | 2020-09-12 | Okaloosa | Florida | 12091 | 4578 | 94 |
521845 | 521845 | 2020-09-11 | Okaloosa | Florida | 12091 | 4550 | 94 |
518608 | 518608 | 2020-09-10 | Okaloosa | Florida | 12091 | 4501 | 94 |
515373 | 515373 | 2020-09-09 | Okaloosa | Florida | 12091 | 4460 | 90 |
512140 | 512140 | 2020-09-08 | Okaloosa | Florida | 12091 | 4427 | 89 |
508907 | 508907 | 2020-09-07 | Okaloosa | Florida | 12091 | 4409 | 88 |
505675 | 505675 | 2020-09-06 | Okaloosa | Florida | 12091 | 4381 | 88 |
502441 | 502441 | 2020-09-05 | Okaloosa | Florida | 12091 | 4360 | 85 |
499207 | 499207 | 2020-09-04 | Okaloosa | Florida | 12091 | 4327 | 83 |
495974 | 495974 | 2020-09-03 | Okaloosa | Florida | 12091 | 4277 | 80 |
492740 | 492740 | 2020-09-02 | Okaloosa | Florida | 12091 | 4244 | 79 |
489507 | 489507 | 2020-09-01 | Okaloosa | Florida | 12091 | 4198 | 77 |
486274 | 486274 | 2020-08-31 | Okaloosa | Florida | 12091 | 4153 | 77 |
483039 | 483039 | 2020-08-30 | Okaloosa | Florida | 12091 | 4133 | 77 |
479805 | 479805 | 2020-08-29 | Okaloosa | Florida | 12091 | 4123 | 76 |
476572 | 476572 | 2020-08-28 | Okaloosa | Florida | 12091 | 4093 | 76 |
473339 | 473339 | 2020-08-27 | Okaloosa | Florida | 12091 | 4054 | 75 |
470107 | 470107 | 2020-08-26 | Okaloosa | Florida | 12091 | 4019 | 75 |
466878 | 466878 | 2020-08-25 | Okaloosa | Florida | 12091 | 3997 | 74 |
463649 | 463649 | 2020-08-24 | Okaloosa | Florida | 12091 | 3964 | 71 |
460420 | 460420 | 2020-08-23 | Okaloosa | Florida | 12091 | 3954 | 71 |
457193 | 457193 | 2020-08-22 | Okaloosa | Florida | 12091 | 3920 | 71 |
453965 | 453965 | 2020-08-21 | Okaloosa | Florida | 12091 | 3877 | 70 |
450737 | 450737 | 2020-08-20 | Okaloosa | Florida | 12091 | 3846 | 67 |
447509 | 447509 | 2020-08-19 | Okaloosa | Florida | 12091 | 3802 | 64 |
444282 | 444282 | 2020-08-18 | Okaloosa | Florida | 12091 | 3772 | 63 |
441056 | 441056 | 2020-08-17 | Okaloosa | Florida | 12091 | 3741 | 50 |
437830 | 437830 | 2020-08-16 | Okaloosa | Florida | 12091 | 3727 | 50 |
434604 | 434604 | 2020-08-15 | Okaloosa | Florida | 12091 | 3695 | 50 |
431379 | 431379 | 2020-08-14 | Okaloosa | Florida | 12091 | 3652 | 50 |
428151 | 428151 | 2020-08-13 | Okaloosa | Florida | 12091 | 3631 | 49 |
424927 | 424927 | 2020-08-12 | Okaloosa | Florida | 12091 | 3607 | 49 |
421706 | 421706 | 2020-08-11 | Okaloosa | Florida | 12091 | 3586 | 45 |
418485 | 418485 | 2020-08-10 | Okaloosa | Florida | 12091 | 3540 | 41 |
415264 | 415264 | 2020-08-09 | Okaloosa | Florida | 12091 | 3501 | 41 |
412044 | 412044 | 2020-08-08 | Okaloosa | Florida | 12091 | 3447 | 41 |
408825 | 408825 | 2020-08-07 | Okaloosa | Florida | 12091 | 3390 | 38 |
405605 | 405605 | 2020-08-06 | Okaloosa | Florida | 12091 | 3291 | 35 |
402387 | 402387 | 2020-08-05 | Okaloosa | Florida | 12091 | 3159 | 34 |
399171 | 399171 | 2020-08-04 | Okaloosa | Florida | 12091 | 3105 | 34 |
395955 | 395955 | 2020-08-03 | Okaloosa | Florida | 12091 | 3030 | 30 |
392739 | 392739 | 2020-08-02 | Okaloosa | Florida | 12091 | 2930 | 30 |
389522 | 389522 | 2020-08-01 | Okaloosa | Florida | 12091 | 2849 | 30 |
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 |
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);