ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 12099 and state = "Florida" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
256067 | 256067 | 2020-06-20 | Palm Beach | Florida | 12099 | 10504 | 468 |
259194 | 259194 | 2020-06-21 | Palm Beach | Florida | 12099 | 10752 | 468 |
262321 | 262321 | 2020-06-22 | Palm Beach | Florida | 12099 | 10941 | 468 |
265449 | 265449 | 2020-06-23 | Palm Beach | Florida | 12099 | 11178 | 476 |
268579 | 268579 | 2020-06-24 | Palm Beach | Florida | 12099 | 11534 | 482 |
271715 | 271715 | 2020-06-25 | Palm Beach | Florida | 12099 | 11838 | 486 |
274855 | 274855 | 2020-06-26 | Palm Beach | Florida | 12099 | 12496 | 490 |
278003 | 278003 | 2020-06-27 | Palm Beach | Florida | 12099 | 12926 | 492 |
281150 | 281150 | 2020-06-28 | Palm Beach | Florida | 12099 | 13387 | 503 |
284296 | 284296 | 2020-06-29 | Palm Beach | Florida | 12099 | 13709 | 503 |
287442 | 287442 | 2020-06-30 | Palm Beach | Florida | 12099 | 14148 | 510 |
290593 | 290593 | 2020-07-01 | Palm Beach | Florida | 12099 | 14445 | 512 |
293747 | 293747 | 2020-07-02 | Palm Beach | Florida | 12099 | 14857 | 523 |
296903 | 296903 | 2020-07-03 | Palm Beach | Florida | 12099 | 15322 | 536 |
300065 | 300065 | 2020-07-04 | Palm Beach | Florida | 12099 | 16147 | 541 |
303229 | 303229 | 2020-07-05 | Palm Beach | Florida | 12099 | 16834 | 542 |
306393 | 306393 | 2020-07-06 | Palm Beach | Florida | 12099 | 17240 | 543 |
309561 | 309561 | 2020-07-07 | Palm Beach | Florida | 12099 | 17636 | 563 |
312731 | 312731 | 2020-07-08 | Palm Beach | Florida | 12099 | 18229 | 569 |
315906 | 315906 | 2020-07-09 | Palm Beach | Florida | 12099 | 18654 | 578 |
319079 | 319079 | 2020-07-10 | Palm Beach | Florida | 12099 | 19231 | 586 |
322258 | 322258 | 2020-07-11 | Palm Beach | Florida | 12099 | 19845 | 594 |
325439 | 325439 | 2020-07-12 | Palm Beach | Florida | 12099 | 21016 | 606 |
328625 | 328625 | 2020-07-13 | Palm Beach | Florida | 12099 | 21804 | 611 |
331812 | 331812 | 2020-07-14 | Palm Beach | Florida | 12099 | 22277 | 624 |
335005 | 335005 | 2020-07-15 | Palm Beach | Florida | 12099 | 22786 | 634 |
338200 | 338200 | 2020-07-16 | Palm Beach | Florida | 12099 | 23709 | 638 |
341397 | 341397 | 2020-07-17 | Palm Beach | Florida | 12099 | 24359 | 659 |
344596 | 344596 | 2020-07-18 | Palm Beach | Florida | 12099 | 25043 | 666 |
347796 | 347796 | 2020-07-19 | Palm Beach | Florida | 12099 | 25783 | 679 |
350997 | 350997 | 2020-07-20 | Palm Beach | Florida | 12099 | 26424 | 685 |
354199 | 354199 | 2020-07-21 | Palm Beach | Florida | 12099 | 26949 | 701 |
357402 | 357402 | 2020-07-22 | Palm Beach | Florida | 12099 | 27504 | 709 |
360607 | 360607 | 2020-07-23 | Palm Beach | Florida | 12099 | 28265 | 727 |
363814 | 363814 | 2020-07-24 | Palm Beach | Florida | 12099 | 29002 | 744 |
367021 | 367021 | 2020-07-25 | Palm Beach | Florida | 12099 | 29705 | 752 |
370231 | 370231 | 2020-07-26 | Palm Beach | Florida | 12099 | 30323 | 755 |
373443 | 373443 | 2020-07-27 | Palm Beach | Florida | 12099 | 30956 | 758 |
376657 | 376657 | 2020-07-28 | Palm Beach | Florida | 12099 | 31596 | 779 |
379874 | 379874 | 2020-07-29 | Palm Beach | Florida | 12099 | 32169 | 795 |
383091 | 383091 | 2020-07-30 | Palm Beach | Florida | 12099 | 32694 | 806 |
386309 | 386309 | 2020-07-31 | Palm Beach | Florida | 12099 | 33272 | 815 |
389526 | 389526 | 2020-08-01 | Palm Beach | Florida | 12099 | 33852 | 833 |
392743 | 392743 | 2020-08-02 | Palm Beach | Florida | 12099 | 34224 | 833 |
395959 | 395959 | 2020-08-03 | Palm Beach | Florida | 12099 | 34548 | 845 |
399175 | 399175 | 2020-08-04 | Palm Beach | Florida | 12099 | 34927 | 861 |
402391 | 402391 | 2020-08-05 | Palm Beach | Florida | 12099 | 35281 | 882 |
405609 | 405609 | 2020-08-06 | Palm Beach | Florida | 12099 | 35735 | 892 |
408829 | 408829 | 2020-08-07 | Palm Beach | Florida | 12099 | 36112 | 919 |
412048 | 412048 | 2020-08-08 | Palm Beach | Florida | 12099 | 36598 | 929 |
415268 | 415268 | 2020-08-09 | Palm Beach | Florida | 12099 | 37018 | 931 |
418489 | 418489 | 2020-08-10 | Palm Beach | Florida | 12099 | 37295 | 936 |
421710 | 421710 | 2020-08-11 | Palm Beach | Florida | 12099 | 37639 | 940 |
424931 | 424931 | 2020-08-12 | Palm Beach | Florida | 12099 | 37932 | 954 |
428155 | 428155 | 2020-08-13 | Palm Beach | Florida | 12099 | 38206 | 964 |
431383 | 431383 | 2020-08-14 | Palm Beach | Florida | 12099 | 38573 | 976 |
434608 | 434608 | 2020-08-15 | Palm Beach | Florida | 12099 | 38900 | 989 |
437834 | 437834 | 2020-08-16 | Palm Beach | Florida | 12099 | 39127 | 992 |
441060 | 441060 | 2020-08-17 | Palm Beach | Florida | 12099 | 39272 | 992 |
444286 | 444286 | 2020-08-18 | Palm Beach | Florida | 12099 | 39458 | 1006 |
447513 | 447513 | 2020-08-19 | Palm Beach | Florida | 12099 | 39660 | 1022 |
450741 | 450741 | 2020-08-20 | Palm Beach | Florida | 12099 | 39884 | 1039 |
453969 | 453969 | 2020-08-21 | Palm Beach | Florida | 12099 | 40155 | 1048 |
457197 | 457197 | 2020-08-22 | Palm Beach | Florida | 12099 | 40385 | 1059 |
460424 | 460424 | 2020-08-23 | Palm Beach | Florida | 12099 | 40568 | 1059 |
463653 | 463653 | 2020-08-24 | Palm Beach | Florida | 12099 | 40744 | 1061 |
466882 | 466882 | 2020-08-25 | Palm Beach | Florida | 12099 | 40851 | 1066 |
470111 | 470111 | 2020-08-26 | Palm Beach | Florida | 12099 | 41011 | 1078 |
473343 | 473343 | 2020-08-27 | Palm Beach | Florida | 12099 | 41193 | 1094 |
476576 | 476576 | 2020-08-28 | Palm Beach | Florida | 12099 | 41556 | 1099 |
479809 | 479809 | 2020-08-29 | Palm Beach | Florida | 12099 | 41728 | 1117 |
483043 | 483043 | 2020-08-30 | Palm Beach | Florida | 12099 | 41863 | 1117 |
486278 | 486278 | 2020-08-31 | Palm Beach | Florida | 12099 | 41963 | 1119 |
489511 | 489511 | 2020-09-01 | Palm Beach | Florida | 12099 | 42385 | 1128 |
492744 | 492744 | 2020-09-02 | Palm Beach | Florida | 12099 | 42516 | 1134 |
495978 | 495978 | 2020-09-03 | Palm Beach | Florida | 12099 | 42641 | 1150 |
499211 | 499211 | 2020-09-04 | Palm Beach | Florida | 12099 | 42760 | 1160 |
502445 | 502445 | 2020-09-05 | Palm Beach | Florida | 12099 | 42903 | 1162 |
505679 | 505679 | 2020-09-06 | Palm Beach | Florida | 12099 | 43065 | 1166 |
508911 | 508911 | 2020-09-07 | Palm Beach | Florida | 12099 | 43185 | 1168 |
512144 | 512144 | 2020-09-08 | Palm Beach | Florida | 12099 | 43307 | 1170 |
515377 | 515377 | 2020-09-09 | Palm Beach | Florida | 12099 | 43420 | 1178 |
518612 | 518612 | 2020-09-10 | Palm Beach | Florida | 12099 | 43530 | 1187 |
521849 | 521849 | 2020-09-11 | Palm Beach | Florida | 12099 | 43722 | 1193 |
525085 | 525085 | 2020-09-12 | Palm Beach | Florida | 12099 | 43871 | 1196 |
528321 | 528321 | 2020-09-13 | Palm Beach | Florida | 12099 | 44023 | 1196 |
531558 | 531558 | 2020-09-14 | Palm Beach | Florida | 12099 | 44137 | 1199 |
534793 | 534793 | 2020-09-15 | Palm Beach | Florida | 12099 | 44303 | 1216 |
538029 | 538029 | 2020-09-16 | Palm Beach | Florida | 12099 | 44457 | 1234 |
541266 | 541266 | 2020-09-17 | Palm Beach | Florida | 12099 | 44681 | 1254 |
544502 | 544502 | 2020-09-18 | Palm Beach | Florida | 12099 | 44904 | 1272 |
547740 | 547740 | 2020-09-19 | Palm Beach | Florida | 12099 | 45154 | 1277 |
550979 | 550979 | 2020-09-20 | Palm Beach | Florida | 12099 | 45327 | 1277 |
554218 | 554218 | 2020-09-21 | Palm Beach | Florida | 12099 | 45423 | 1277 |
557455 | 557455 | 2020-09-22 | Palm Beach | Florida | 12099 | 45600 | 1286 |
560691 | 560691 | 2020-09-23 | Palm Beach | Florida | 12099 | 45741 | 1308 |
563931 | 563931 | 2020-09-24 | Palm Beach | Florida | 12099 | 45864 | 1330 |
567171 | 567171 | 2020-09-25 | Palm Beach | Florida | 12099 | 46021 | 1337 |
570413 | 570413 | 2020-09-26 | Palm Beach | Florida | 12099 | 46181 | 1342 |
573655 | 573655 | 2020-09-27 | Palm Beach | Florida | 12099 | 46281 | 1342 |
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);