ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Florida" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922793 | 922793 | 2021-01-12 | Florida | Puerto Rico | 72054 | 646 | |
919548 | 919548 | 2021-01-11 | Florida | Puerto Rico | 72054 | 642 | |
916303 | 916303 | 2021-01-10 | Florida | Puerto Rico | 72054 | 642 | |
913058 | 913058 | 2021-01-09 | Florida | Puerto Rico | 72054 | 642 | |
909813 | 909813 | 2021-01-08 | Florida | Puerto Rico | 72054 | 640 | |
906568 | 906568 | 2021-01-07 | Florida | Puerto Rico | 72054 | 634 | |
903322 | 903322 | 2021-01-06 | Florida | Puerto Rico | 72054 | 634 | |
900077 | 900077 | 2021-01-05 | Florida | Puerto Rico | 72054 | 634 | |
896832 | 896832 | 2021-01-04 | Florida | Puerto Rico | 72054 | 634 | |
893586 | 893586 | 2021-01-03 | Florida | Puerto Rico | 72054 | 634 | |
890340 | 890340 | 2021-01-02 | Florida | Puerto Rico | 72054 | 634 | |
887093 | 887093 | 2021-01-01 | Florida | Puerto Rico | 72054 | 631 | |
883848 | 883848 | 2020-12-31 | Florida | Puerto Rico | 72054 | 625 | |
880603 | 880603 | 2020-12-30 | Florida | Puerto Rico | 72054 | 625 | |
877358 | 877358 | 2020-12-29 | Florida | Puerto Rico | 72054 | 625 | |
874113 | 874113 | 2020-12-28 | Florida | Puerto Rico | 72054 | 624 | |
870868 | 870868 | 2020-12-27 | Florida | Puerto Rico | 72054 | 624 | |
867623 | 867623 | 2020-12-26 | Florida | Puerto Rico | 72054 | 622 | |
864378 | 864378 | 2020-12-25 | Florida | Puerto Rico | 72054 | 621 | |
861133 | 861133 | 2020-12-24 | Florida | Puerto Rico | 72054 | 620 | |
857888 | 857888 | 2020-12-23 | Florida | Puerto Rico | 72054 | 620 | |
854643 | 854643 | 2020-12-22 | Florida | Puerto Rico | 72054 | 620 | |
851398 | 851398 | 2020-12-21 | Florida | Puerto Rico | 72054 | 612 | |
848153 | 848153 | 2020-12-20 | Florida | Puerto Rico | 72054 | 611 | |
844908 | 844908 | 2020-12-19 | Florida | Puerto Rico | 72054 | 609 | |
841662 | 841662 | 2020-12-18 | Florida | Puerto Rico | 72054 | 603 | |
838417 | 838417 | 2020-12-17 | Florida | Puerto Rico | 72054 | 580 | |
835171 | 835171 | 2020-12-16 | Florida | Puerto Rico | 72054 | 555 | |
831925 | 831925 | 2020-12-15 | Florida | Puerto Rico | 72054 | 553 | |
828678 | 828678 | 2020-12-14 | Florida | Puerto Rico | 72054 | 551 | |
825432 | 825432 | 2020-12-13 | Florida | Puerto Rico | 72054 | 551 | |
822185 | 822185 | 2020-12-12 | Florida | Puerto Rico | 72054 | 546 | |
818939 | 818939 | 2020-12-11 | Florida | Puerto Rico | 72054 | 544 | |
815693 | 815693 | 2020-12-10 | Florida | Puerto Rico | 72054 | 534 | |
812447 | 812447 | 2020-12-09 | Florida | Puerto Rico | 72054 | 534 | |
809203 | 809203 | 2020-12-08 | Florida | Puerto Rico | 72054 | 533 | |
805958 | 805958 | 2020-12-07 | Florida | Puerto Rico | 72054 | 533 | |
802713 | 802713 | 2020-12-06 | Florida | Puerto Rico | 72054 | 527 | |
799468 | 799468 | 2020-12-05 | Florida | Puerto Rico | 72054 | 524 | |
796223 | 796223 | 2020-12-04 | Florida | Puerto Rico | 72054 | 520 | |
792978 | 792978 | 2020-12-03 | Florida | Puerto Rico | 72054 | 520 | |
789733 | 789733 | 2020-12-02 | Florida | Puerto Rico | 72054 | 519 | |
786488 | 786488 | 2020-12-01 | Florida | Puerto Rico | 72054 | 518 | |
783244 | 783244 | 2020-11-30 | Florida | Puerto Rico | 72054 | 513 | |
779999 | 779999 | 2020-11-29 | Florida | Puerto Rico | 72054 | 511 | |
776753 | 776753 | 2020-11-28 | Florida | Puerto Rico | 72054 | 510 | |
773508 | 773508 | 2020-11-27 | Florida | Puerto Rico | 72054 | 507 | |
770263 | 770263 | 2020-11-26 | Florida | Puerto Rico | 72054 | 495 | |
767017 | 767017 | 2020-11-25 | Florida | Puerto Rico | 72054 | 493 | |
763772 | 763772 | 2020-11-24 | Florida | Puerto Rico | 72054 | 493 | |
760527 | 760527 | 2020-11-23 | Florida | Puerto Rico | 72054 | 492 | |
757282 | 757282 | 2020-11-22 | Florida | Puerto Rico | 72054 | 488 | |
754035 | 754035 | 2020-11-21 | Florida | Puerto Rico | 72054 | 480 | |
750789 | 750789 | 2020-11-20 | Florida | Puerto Rico | 72054 | 475 | |
747543 | 747543 | 2020-11-19 | Florida | Puerto Rico | 72054 | 467 | |
744297 | 744297 | 2020-11-18 | Florida | Puerto Rico | 72054 | 466 | |
741050 | 741050 | 2020-11-17 | Florida | Puerto Rico | 72054 | 454 | |
737804 | 737804 | 2020-11-16 | Florida | Puerto Rico | 72054 | 448 | |
734560 | 734560 | 2020-11-15 | Florida | Puerto Rico | 72054 | 445 | |
731314 | 731314 | 2020-11-14 | Florida | Puerto Rico | 72054 | 442 | |
728070 | 728070 | 2020-11-13 | Florida | Puerto Rico | 72054 | 436 | |
724826 | 724826 | 2020-11-12 | Florida | Puerto Rico | 72054 | 431 | |
721583 | 721583 | 2020-11-11 | Florida | Puerto Rico | 72054 | 428 | |
718340 | 718340 | 2020-11-10 | Florida | Puerto Rico | 72054 | 428 | |
715097 | 715097 | 2020-11-09 | Florida | Puerto Rico | 72054 | 427 | |
711853 | 711853 | 2020-11-08 | Florida | Puerto Rico | 72054 | 422 | |
708609 | 708609 | 2020-11-07 | Florida | Puerto Rico | 72054 | 418 | |
705366 | 705366 | 2020-11-06 | Florida | Puerto Rico | 72054 | 418 | |
702123 | 702123 | 2020-11-05 | Florida | Puerto Rico | 72054 | 410 | |
698879 | 698879 | 2020-11-04 | Florida | Puerto Rico | 72054 | 410 | |
695636 | 695636 | 2020-11-03 | Florida | Puerto Rico | 72054 | 410 | |
692394 | 692394 | 2020-11-02 | Florida | Puerto Rico | 72054 | 407 | |
689150 | 689150 | 2020-11-01 | Florida | Puerto Rico | 72054 | 401 | |
685905 | 685905 | 2020-10-31 | Florida | Puerto Rico | 72054 | 398 | |
682662 | 682662 | 2020-10-30 | Florida | Puerto Rico | 72054 | 398 | |
679419 | 679419 | 2020-10-29 | Florida | Puerto Rico | 72054 | 394 | |
676176 | 676176 | 2020-10-28 | Florida | Puerto Rico | 72054 | 387 | |
672933 | 672933 | 2020-10-27 | Florida | Puerto Rico | 72054 | 387 | |
669691 | 669691 | 2020-10-26 | Florida | Puerto Rico | 72054 | 386 | |
666447 | 666447 | 2020-10-25 | Florida | Puerto Rico | 72054 | 382 | |
663202 | 663202 | 2020-10-24 | Florida | Puerto Rico | 72054 | 372 | |
659958 | 659958 | 2020-10-23 | Florida | Puerto Rico | 72054 | 372 | |
656714 | 656714 | 2020-10-22 | Florida | Puerto Rico | 72054 | 370 | |
653469 | 653469 | 2020-10-21 | Florida | Puerto Rico | 72054 | 370 | |
650224 | 650224 | 2020-10-20 | Florida | Puerto Rico | 72054 | 370 | |
646980 | 646980 | 2020-10-19 | Florida | Puerto Rico | 72054 | 370 | |
643734 | 643734 | 2020-10-18 | Florida | Puerto Rico | 72054 | 366 | |
640486 | 640486 | 2020-10-17 | Florida | Puerto Rico | 72054 | 366 | |
637240 | 637240 | 2020-10-16 | Florida | Puerto Rico | 72054 | 366 | |
633994 | 633994 | 2020-10-15 | Florida | Puerto Rico | 72054 | 366 | |
630749 | 630749 | 2020-10-14 | Florida | Puerto Rico | 72054 | 366 | |
627505 | 627505 | 2020-10-13 | Florida | Puerto Rico | 72054 | 356 | |
624263 | 624263 | 2020-10-12 | Florida | Puerto Rico | 72054 | 356 | |
621020 | 621020 | 2020-10-11 | Florida | Puerto Rico | 72054 | 356 | |
617777 | 617777 | 2020-10-10 | Florida | Puerto Rico | 72054 | 353 | |
614535 | 614535 | 2020-10-09 | Florida | Puerto Rico | 72054 | 350 | |
611294 | 611294 | 2020-10-08 | Florida | Puerto Rico | 72054 | 350 | |
608052 | 608052 | 2020-10-07 | Florida | Puerto Rico | 72054 | 347 | |
604809 | 604809 | 2020-10-06 | Florida | Puerto Rico | 72054 | 347 | |
601567 | 601567 | 2020-10-05 | Florida | Puerto Rico | 72054 | 338 |
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);