ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 12031 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920774 | 920774 | 2021-01-12 | Duval | Florida | 12031 | 71854 | 783 |
917529 | 917529 | 2021-01-11 | Duval | Florida | 12031 | 70905 | 781 |
914284 | 914284 | 2021-01-10 | Duval | Florida | 12031 | 70524 | 775 |
911039 | 911039 | 2021-01-09 | Duval | Florida | 12031 | 69773 | 772 |
907794 | 907794 | 2021-01-08 | Duval | Florida | 12031 | 68971 | 769 |
904548 | 904548 | 2021-01-07 | Duval | Florida | 12031 | 67938 | 767 |
901303 | 901303 | 2021-01-06 | Duval | Florida | 12031 | 66647 | 760 |
898058 | 898058 | 2021-01-05 | Duval | Florida | 12031 | 65556 | 755 |
894813 | 894813 | 2021-01-04 | Duval | Florida | 12031 | 64225 | 753 |
891566 | 891566 | 2021-01-03 | Duval | Florida | 12031 | 63743 | 741 |
888319 | 888319 | 2021-01-02 | Duval | Florida | 12031 | 62888 | 739 |
885074 | 885074 | 2021-01-01 | Duval | Florida | 12031 | 61321 | 725 |
881829 | 881829 | 2020-12-31 | Duval | Florida | 12031 | 61321 | 725 |
878584 | 878584 | 2020-12-30 | Duval | Florida | 12031 | 60324 | 725 |
875339 | 875339 | 2020-12-29 | Duval | Florida | 12031 | 59515 | 724 |
872094 | 872094 | 2020-12-28 | Duval | Florida | 12031 | 58491 | 722 |
868849 | 868849 | 2020-12-27 | Duval | Florida | 12031 | 58296 | 717 |
865604 | 865604 | 2020-12-26 | Duval | Florida | 12031 | 57999 | 716 |
862359 | 862359 | 2020-12-25 | Duval | Florida | 12031 | 57050 | 711 |
859114 | 859114 | 2020-12-24 | Duval | Florida | 12031 | 57050 | 711 |
855869 | 855869 | 2020-12-23 | Duval | Florida | 12031 | 56229 | 711 |
852624 | 852624 | 2020-12-22 | Duval | Florida | 12031 | 55553 | 706 |
849379 | 849379 | 2020-12-21 | Duval | Florida | 12031 | 54956 | 699 |
846134 | 846134 | 2020-12-20 | Duval | Florida | 12031 | 54359 | 696 |
842888 | 842888 | 2020-12-19 | Duval | Florida | 12031 | 53885 | 692 |
839643 | 839643 | 2020-12-18 | Duval | Florida | 12031 | 53275 | 692 |
836398 | 836398 | 2020-12-17 | Duval | Florida | 12031 | 52674 | 692 |
833152 | 833152 | 2020-12-16 | Duval | Florida | 12031 | 51936 | 692 |
829905 | 829905 | 2020-12-15 | Duval | Florida | 12031 | 51112 | 685 |
826659 | 826659 | 2020-12-14 | Duval | Florida | 12031 | 50646 | 685 |
823412 | 823412 | 2020-12-13 | Duval | Florida | 12031 | 50230 | 683 |
820166 | 820166 | 2020-12-12 | Duval | Florida | 12031 | 49697 | 678 |
816920 | 816920 | 2020-12-11 | Duval | Florida | 12031 | 49320 | 676 |
813674 | 813674 | 2020-12-10 | Duval | Florida | 12031 | 48732 | 664 |
810430 | 810430 | 2020-12-09 | Duval | Florida | 12031 | 48250 | 661 |
807185 | 807185 | 2020-12-08 | Duval | Florida | 12031 | 47818 | 658 |
803940 | 803940 | 2020-12-07 | Duval | Florida | 12031 | 47418 | 656 |
800695 | 800695 | 2020-12-06 | Duval | Florida | 12031 | 47036 | 650 |
797450 | 797450 | 2020-12-05 | Duval | Florida | 12031 | 46606 | 637 |
794205 | 794205 | 2020-12-04 | Duval | Florida | 12031 | 46112 | 635 |
790960 | 790960 | 2020-12-03 | Duval | Florida | 12031 | 45575 | 634 |
787715 | 787715 | 2020-12-02 | Duval | Florida | 12031 | 44969 | 634 |
784471 | 784471 | 2020-12-01 | Duval | Florida | 12031 | 44450 | 626 |
781226 | 781226 | 2020-11-30 | Duval | Florida | 12031 | 43978 | 604 |
777980 | 777980 | 2020-11-29 | Duval | Florida | 12031 | 43599 | 599 |
774735 | 774735 | 2020-11-28 | Duval | Florida | 12031 | 43241 | 591 |
771490 | 771490 | 2020-11-27 | Duval | Florida | 12031 | 42974 | 586 |
768245 | 768245 | 2020-11-26 | Duval | Florida | 12031 | 41937 | 579 |
764999 | 764999 | 2020-11-25 | Duval | Florida | 12031 | 41937 | 579 |
761754 | 761754 | 2020-11-24 | Duval | Florida | 12031 | 41415 | 570 |
758509 | 758509 | 2020-11-23 | Duval | Florida | 12031 | 40898 | 569 |
755262 | 755262 | 2020-11-22 | Duval | Florida | 12031 | 40584 | 565 |
752016 | 752016 | 2020-11-21 | Duval | Florida | 12031 | 40369 | 564 |
748770 | 748770 | 2020-11-20 | Duval | Florida | 12031 | 39998 | 564 |
745524 | 745524 | 2020-11-19 | Duval | Florida | 12031 | 39745 | 564 |
742277 | 742277 | 2020-11-18 | Duval | Florida | 12031 | 39305 | 563 |
739030 | 739030 | 2020-11-17 | Duval | Florida | 12031 | 39052 | 557 |
735786 | 735786 | 2020-11-16 | Duval | Florida | 12031 | 38677 | 555 |
732540 | 732540 | 2020-11-15 | Duval | Florida | 12031 | 38569 | 553 |
729295 | 729295 | 2020-11-14 | Duval | Florida | 12031 | 37998 | 549 |
726052 | 726052 | 2020-11-13 | Duval | Florida | 12031 | 37864 | 549 |
722809 | 722809 | 2020-11-12 | Duval | Florida | 12031 | 37657 | 547 |
719566 | 719566 | 2020-11-11 | Duval | Florida | 12031 | 37494 | 544 |
716323 | 716323 | 2020-11-10 | Duval | Florida | 12031 | 37032 | 537 |
713079 | 713079 | 2020-11-09 | Duval | Florida | 12031 | 36847 | 536 |
709835 | 709835 | 2020-11-08 | Duval | Florida | 12031 | 36716 | 534 |
706591 | 706591 | 2020-11-07 | Duval | Florida | 12031 | 36520 | 534 |
703348 | 703348 | 2020-11-06 | Duval | Florida | 12031 | 36438 | 534 |
700105 | 700105 | 2020-11-05 | Duval | Florida | 12031 | 36282 | 532 |
696861 | 696861 | 2020-11-04 | Duval | Florida | 12031 | 36081 | 532 |
693619 | 693619 | 2020-11-03 | Duval | Florida | 12031 | 35956 | 531 |
690376 | 690376 | 2020-11-02 | Duval | Florida | 12031 | 35806 | 525 |
687131 | 687131 | 2020-11-01 | Duval | Florida | 12031 | 35429 | 523 |
683887 | 683887 | 2020-10-31 | Duval | Florida | 12031 | 35256 | 523 |
680644 | 680644 | 2020-10-30 | Duval | Florida | 12031 | 35171 | 516 |
677401 | 677401 | 2020-10-29 | Duval | Florida | 12031 | 34963 | 515 |
674158 | 674158 | 2020-10-28 | Duval | Florida | 12031 | 34727 | 515 |
670916 | 670916 | 2020-10-27 | Duval | Florida | 12031 | 34619 | 515 |
667673 | 667673 | 2020-10-26 | Duval | Florida | 12031 | 34462 | 513 |
664428 | 664428 | 2020-10-25 | Duval | Florida | 12031 | 34260 | 513 |
661184 | 661184 | 2020-10-24 | Duval | Florida | 12031 | 34177 | 513 |
657940 | 657940 | 2020-10-23 | Duval | Florida | 12031 | 33946 | 512 |
654695 | 654695 | 2020-10-22 | Duval | Florida | 12031 | 33676 | 512 |
651450 | 651450 | 2020-10-21 | Duval | Florida | 12031 | 33260 | 512 |
648206 | 648206 | 2020-10-20 | Duval | Florida | 12031 | 33132 | 512 |
644961 | 644961 | 2020-10-19 | Duval | Florida | 12031 | 32951 | 511 |
641713 | 641713 | 2020-10-18 | Duval | Florida | 12031 | 32887 | 508 |
638466 | 638466 | 2020-10-17 | Duval | Florida | 12031 | 32772 | 505 |
635221 | 635221 | 2020-10-16 | Duval | Florida | 12031 | 32625 | 505 |
631975 | 631975 | 2020-10-15 | Duval | Florida | 12031 | 32489 | 500 |
628731 | 628731 | 2020-10-14 | Duval | Florida | 12031 | 32311 | 494 |
625488 | 625488 | 2020-10-13 | Duval | Florida | 12031 | 32138 | 491 |
622245 | 622245 | 2020-10-12 | Duval | Florida | 12031 | 32027 | 487 |
619002 | 619002 | 2020-10-11 | Duval | Florida | 12031 | 31956 | 483 |
615760 | 615760 | 2020-10-10 | Duval | Florida | 12031 | 31669 | 474 |
612519 | 612519 | 2020-10-09 | Duval | Florida | 12031 | 31669 | 474 |
609277 | 609277 | 2020-10-08 | Duval | Florida | 12031 | 31500 | 471 |
606034 | 606034 | 2020-10-07 | Duval | Florida | 12031 | 31383 | 452 |
602792 | 602792 | 2020-10-06 | Duval | Florida | 12031 | 31195 | 438 |
599549 | 599549 | 2020-10-05 | Duval | Florida | 12031 | 31056 | 432 |
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);