ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "Unknown" and state = "Rhode Island" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922849 | 922849 | 2021-01-12 | Unknown | Rhode Island | 16867 | 120 | |
919604 | 919604 | 2021-01-11 | Unknown | Rhode Island | 16081 | 97 | |
916359 | 916359 | 2021-01-10 | Unknown | Rhode Island | 13088 | 66 | |
913114 | 913114 | 2021-01-09 | Unknown | Rhode Island | 13088 | 66 | |
909869 | 909869 | 2021-01-08 | Unknown | Rhode Island | 13088 | 66 | |
906624 | 906624 | 2021-01-07 | Unknown | Rhode Island | 12065 | 60 | |
903378 | 903378 | 2021-01-06 | Unknown | Rhode Island | 10937 | 40 | |
900133 | 900133 | 2021-01-05 | Unknown | Rhode Island | 15525 | 153 | |
896888 | 896888 | 2021-01-04 | Unknown | Rhode Island | 14381 | 138 | |
893642 | 893642 | 2021-01-03 | Unknown | Rhode Island | 9622 | 60 | |
890396 | 890396 | 2021-01-02 | Unknown | Rhode Island | 9622 | 60 | |
887149 | 887149 | 2021-01-01 | Unknown | Rhode Island | 9622 | 60 | |
883904 | 883904 | 2020-12-31 | Unknown | Rhode Island | 9622 | 60 | |
880659 | 880659 | 2020-12-30 | Unknown | Rhode Island | 9622 | 60 | |
877414 | 877414 | 2020-12-29 | Unknown | Rhode Island | 13091 | 129 | |
874169 | 874169 | 2020-12-28 | Unknown | Rhode Island | 11904 | 111 | |
870924 | 870924 | 2020-12-27 | Unknown | Rhode Island | 8368 | 73 | |
867679 | 867679 | 2020-12-26 | Unknown | Rhode Island | 8368 | 73 | |
864434 | 864434 | 2020-12-25 | Unknown | Rhode Island | 8368 | 73 | |
861189 | 861189 | 2020-12-24 | Unknown | Rhode Island | 8368 | 73 | |
857944 | 857944 | 2020-12-23 | Unknown | Rhode Island | 8368 | 73 | |
854699 | 854699 | 2020-12-22 | Unknown | Rhode Island | 13386 | 162 | |
851454 | 851454 | 2020-12-21 | Unknown | Rhode Island | 12430 | 154 | |
848209 | 848209 | 2020-12-20 | Unknown | Rhode Island | 10011 | 109 | |
844964 | 844964 | 2020-12-19 | Unknown | Rhode Island | 10011 | 109 | |
841718 | 841718 | 2020-12-18 | Unknown | Rhode Island | 10011 | 109 | |
838473 | 838473 | 2020-12-17 | Unknown | Rhode Island | 9489 | 86 | |
835227 | 835227 | 2020-12-16 | Unknown | Rhode Island | 8408 | 74 | |
831981 | 831981 | 2020-12-15 | Unknown | Rhode Island | 15306 | 151 | |
828734 | 828734 | 2020-12-14 | Unknown | Rhode Island | 14140 | 136 | |
825488 | 825488 | 2020-12-13 | Unknown | Rhode Island | 10887 | 90 | |
822241 | 822241 | 2020-12-12 | Unknown | Rhode Island | 10887 | 90 | |
818995 | 818995 | 2020-12-11 | Unknown | Rhode Island | 10887 | 90 | |
815749 | 815749 | 2020-12-10 | Unknown | Rhode Island | 9316 | 79 | |
812503 | 812503 | 2020-12-09 | Unknown | Rhode Island | 8368 | 65 | |
809259 | 809259 | 2020-12-08 | Unknown | Rhode Island | 15362 | 124 | |
806014 | 806014 | 2020-12-07 | Unknown | Rhode Island | 14113 | 102 | |
802769 | 802769 | 2020-12-06 | Unknown | Rhode Island | 10432 | 67 | |
799524 | 799524 | 2020-12-05 | Unknown | Rhode Island | 10432 | 67 | |
796279 | 796279 | 2020-12-04 | Unknown | Rhode Island | 10432 | 67 | |
793034 | 793034 | 2020-12-03 | Unknown | Rhode Island | 9017 | 54 | |
789789 | 789789 | 2020-12-02 | Unknown | Rhode Island | 7300 | 45 | |
786544 | 786544 | 2020-12-01 | Unknown | Rhode Island | 12062 | 90 | |
783300 | 783300 | 2020-11-30 | Unknown | Rhode Island | 10879 | 83 | |
780055 | 780055 | 2020-11-29 | Unknown | Rhode Island | 8110 | 56 | |
776809 | 776809 | 2020-11-28 | Unknown | Rhode Island | 8110 | 56 | |
773564 | 773564 | 2020-11-27 | Unknown | Rhode Island | 8110 | 56 | |
770319 | 770319 | 2020-11-26 | Unknown | Rhode Island | 6473 | 45 | |
767073 | 767073 | 2020-11-25 | Unknown | Rhode Island | 6473 | 45 | |
763828 | 763828 | 2020-11-24 | Unknown | Rhode Island | 11779 | 69 | |
760583 | 760583 | 2020-11-23 | Unknown | Rhode Island | 10928 | 53 | |
757338 | 757338 | 2020-11-22 | Unknown | Rhode Island | 8356 | 38 | |
754091 | 754091 | 2020-11-21 | Unknown | Rhode Island | 8356 | 38 | |
750845 | 750845 | 2020-11-20 | Unknown | Rhode Island | 8356 | 38 | |
747599 | 747599 | 2020-11-19 | Unknown | Rhode Island | 7306 | 32 | |
744353 | 744353 | 2020-11-18 | Unknown | Rhode Island | 6266 | 28 | |
741106 | 741106 | 2020-11-17 | Unknown | Rhode Island | 9992 | 54 | |
737860 | 737860 | 2020-11-16 | Unknown | Rhode Island | 9387 | 46 | |
734616 | 734616 | 2020-11-15 | Unknown | Rhode Island | 6993 | 30 | |
731370 | 731370 | 2020-11-14 | Unknown | Rhode Island | 6993 | 30 | |
728126 | 728126 | 2020-11-13 | Unknown | Rhode Island | 6993 | 30 | |
724882 | 724882 | 2020-11-12 | Unknown | Rhode Island | 6228 | 26 | |
721639 | 721639 | 2020-11-11 | Unknown | Rhode Island | 5240 | 19 | |
718396 | 718396 | 2020-11-10 | Unknown | Rhode Island | 7685 | 38 | |
715153 | 715153 | 2020-11-09 | Unknown | Rhode Island | 6896 | 34 | |
711909 | 711909 | 2020-11-08 | Unknown | Rhode Island | 5267 | 25 | |
708665 | 708665 | 2020-11-07 | Unknown | Rhode Island | 5267 | 25 | |
705422 | 705422 | 2020-11-06 | Unknown | Rhode Island | 5267 | 25 | |
702179 | 702179 | 2020-11-05 | Unknown | Rhode Island | 4637 | 23 | |
698935 | 698935 | 2020-11-04 | Unknown | Rhode Island | 4009 | 15 | |
695692 | 695692 | 2020-11-03 | Unknown | Rhode Island | 6086 | 37 | |
692450 | 692450 | 2020-11-02 | Unknown | Rhode Island | 5663 | 35 | |
689206 | 689206 | 2020-11-01 | Unknown | Rhode Island | 4417 | 26 | |
685961 | 685961 | 2020-10-31 | Unknown | Rhode Island | 4417 | 26 | |
682718 | 682718 | 2020-10-30 | Unknown | Rhode Island | 4417 | 26 | |
679475 | 679475 | 2020-10-29 | Unknown | Rhode Island | 3855 | 20 | |
676232 | 676232 | 2020-10-28 | Unknown | Rhode Island | 3487 | 17 | |
672989 | 672989 | 2020-10-27 | Unknown | Rhode Island | 5251 | 40 | |
669747 | 669747 | 2020-10-26 | Unknown | Rhode Island | 4830 | 36 | |
666503 | 666503 | 2020-10-25 | Unknown | Rhode Island | 3924 | 29 | |
663258 | 663258 | 2020-10-24 | Unknown | Rhode Island | 3924 | 29 | |
660014 | 660014 | 2020-10-23 | Unknown | Rhode Island | 3924 | 29 | |
656770 | 656770 | 2020-10-22 | Unknown | Rhode Island | 3400 | 25 | |
653525 | 653525 | 2020-10-21 | Unknown | Rhode Island | 2929 | 21 | |
650280 | 650280 | 2020-10-20 | Unknown | Rhode Island | 3903 | 39 | |
647036 | 647036 | 2020-10-19 | Unknown | Rhode Island | 3601 | 34 | |
643790 | 643790 | 2020-10-18 | Unknown | Rhode Island | 2945 | 27 | |
640542 | 640542 | 2020-10-17 | Unknown | Rhode Island | 2945 | 27 | |
637296 | 637296 | 2020-10-16 | Unknown | Rhode Island | 2945 | 27 | |
634050 | 634050 | 2020-10-15 | Unknown | Rhode Island | 2692 | 24 | |
630805 | 630805 | 2020-10-14 | Unknown | Rhode Island | 2418 | 22 | |
627561 | 627561 | 2020-10-13 | Unknown | Rhode Island | 3376 | 26 | |
624319 | 624319 | 2020-10-12 | Unknown | Rhode Island | 2710 | 17 | |
621076 | 621076 | 2020-10-11 | Unknown | Rhode Island | 2710 | 17 | |
617833 | 617833 | 2020-10-10 | Unknown | Rhode Island | 2710 | 17 | |
614591 | 614591 | 2020-10-09 | Unknown | Rhode Island | 2710 | 17 | |
611350 | 611350 | 2020-10-08 | Unknown | Rhode Island | 2461 | 14 | |
608108 | 608108 | 2020-10-07 | Unknown | Rhode Island | 2192 | 13 | |
604865 | 604865 | 2020-10-06 | Unknown | Rhode Island | 2903 | 24 | |
601623 | 601623 | 2020-10-05 | Unknown | Rhode Island | 2726 | 20 |
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);