ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Washington" and fips = 44009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1088374 | 1088374 | 2021-03-04 | Washington | Rhode Island | 44009 | 7867 | 160 |
1085129 | 1085129 | 2021-03-03 | Washington | Rhode Island | 44009 | 7867 | 160 |
1081883 | 1081883 | 2021-03-02 | Washington | Rhode Island | 44009 | 7625 | 154 |
1078637 | 1078637 | 2021-03-01 | Washington | Rhode Island | 44009 | 7625 | 154 |
1075392 | 1075392 | 2021-02-28 | Washington | Rhode Island | 44009 | 7625 | 154 |
1072146 | 1072146 | 2021-02-27 | Washington | Rhode Island | 44009 | 7625 | 154 |
1068900 | 1068900 | 2021-02-26 | Washington | Rhode Island | 44009 | 7625 | 154 |
1065655 | 1065655 | 2021-02-25 | Washington | Rhode Island | 44009 | 7625 | 154 |
1062410 | 1062410 | 2021-02-24 | Washington | Rhode Island | 44009 | 7625 | 154 |
1059165 | 1059165 | 2021-02-23 | Washington | Rhode Island | 44009 | 7345 | 145 |
1055919 | 1055919 | 2021-02-22 | Washington | Rhode Island | 44009 | 7345 | 145 |
1052673 | 1052673 | 2021-02-21 | Washington | Rhode Island | 44009 | 7345 | 145 |
1049426 | 1049426 | 2021-02-20 | Washington | Rhode Island | 44009 | 7345 | 145 |
1046179 | 1046179 | 2021-02-19 | Washington | Rhode Island | 44009 | 7345 | 145 |
1042934 | 1042934 | 2021-02-18 | Washington | Rhode Island | 44009 | 7345 | 145 |
1039689 | 1039689 | 2021-02-17 | Washington | Rhode Island | 44009 | 7345 | 145 |
1036444 | 1036444 | 2021-02-16 | Washington | Rhode Island | 44009 | 7042 | 138 |
1033199 | 1033199 | 2021-02-15 | Washington | Rhode Island | 44009 | 7042 | 138 |
1029953 | 1029953 | 2021-02-14 | Washington | Rhode Island | 44009 | 7042 | 138 |
1026706 | 1026706 | 2021-02-13 | Washington | Rhode Island | 44009 | 7042 | 138 |
1023461 | 1023461 | 2021-02-12 | Washington | Rhode Island | 44009 | 7042 | 138 |
1020216 | 1020216 | 2021-02-11 | Washington | Rhode Island | 44009 | 7042 | 138 |
1016971 | 1016971 | 2021-02-10 | Washington | Rhode Island | 44009 | 7042 | 138 |
1013726 | 1013726 | 2021-02-09 | Washington | Rhode Island | 44009 | 6765 | 137 |
1010481 | 1010481 | 2021-02-08 | Washington | Rhode Island | 44009 | 6765 | 137 |
1007235 | 1007235 | 2021-02-07 | Washington | Rhode Island | 44009 | 6765 | 137 |
1003989 | 1003989 | 2021-02-06 | Washington | Rhode Island | 44009 | 6765 | 137 |
1000743 | 1000743 | 2021-02-05 | Washington | Rhode Island | 44009 | 6765 | 137 |
997497 | 997497 | 2021-02-04 | Washington | Rhode Island | 44009 | 6765 | 137 |
994251 | 994251 | 2021-02-03 | Washington | Rhode Island | 44009 | 6765 | 137 |
991005 | 991005 | 2021-02-02 | Washington | Rhode Island | 44009 | 6298 | 133 |
987759 | 987759 | 2021-02-01 | Washington | Rhode Island | 44009 | 6298 | 133 |
984512 | 984512 | 2021-01-31 | Washington | Rhode Island | 44009 | 6298 | 133 |
981265 | 981265 | 2021-01-30 | Washington | Rhode Island | 44009 | 6298 | 133 |
978019 | 978019 | 2021-01-29 | Washington | Rhode Island | 44009 | 6298 | 133 |
974774 | 974774 | 2021-01-28 | Washington | Rhode Island | 44009 | 6298 | 133 |
971529 | 971529 | 2021-01-27 | Washington | Rhode Island | 44009 | 6298 | 133 |
968284 | 968284 | 2021-01-26 | Washington | Rhode Island | 44009 | 5887 | 132 |
965040 | 965040 | 2021-01-25 | Washington | Rhode Island | 44009 | 5887 | 132 |
961795 | 961795 | 2021-01-24 | Washington | Rhode Island | 44009 | 5887 | 132 |
958550 | 958550 | 2021-01-23 | Washington | Rhode Island | 44009 | 5887 | 132 |
955304 | 955304 | 2021-01-22 | Washington | Rhode Island | 44009 | 5887 | 132 |
952059 | 952059 | 2021-01-21 | Washington | Rhode Island | 44009 | 5887 | 132 |
948814 | 948814 | 2021-01-20 | Washington | Rhode Island | 44009 | 5887 | 132 |
945568 | 945568 | 2021-01-19 | Washington | Rhode Island | 44009 | 5521 | 125 |
942321 | 942321 | 2021-01-18 | Washington | Rhode Island | 44009 | 5521 | 125 |
939076 | 939076 | 2021-01-17 | Washington | Rhode Island | 44009 | 5521 | 125 |
935831 | 935831 | 2021-01-16 | Washington | Rhode Island | 44009 | 5521 | 125 |
932586 | 932586 | 2021-01-15 | Washington | Rhode Island | 44009 | 5521 | 125 |
929341 | 929341 | 2021-01-14 | Washington | Rhode Island | 44009 | 5521 | 125 |
926096 | 926096 | 2021-01-13 | Washington | Rhode Island | 44009 | 5521 | 125 |
922850 | 922850 | 2021-01-12 | Washington | Rhode Island | 44009 | 4994 | 121 |
919605 | 919605 | 2021-01-11 | Washington | Rhode Island | 44009 | 4994 | 121 |
916360 | 916360 | 2021-01-10 | Washington | Rhode Island | 44009 | 4994 | 121 |
913115 | 913115 | 2021-01-09 | Washington | Rhode Island | 44009 | 4994 | 121 |
909870 | 909870 | 2021-01-08 | Washington | Rhode Island | 44009 | 4994 | 121 |
906625 | 906625 | 2021-01-07 | Washington | Rhode Island | 44009 | 4994 | 121 |
903379 | 903379 | 2021-01-06 | Washington | Rhode Island | 44009 | 4994 | 121 |
900134 | 900134 | 2021-01-05 | Washington | Rhode Island | 44009 | 4482 | 113 |
896889 | 896889 | 2021-01-04 | Washington | Rhode Island | 44009 | 4482 | 113 |
893643 | 893643 | 2021-01-03 | Washington | Rhode Island | 44009 | 4482 | 113 |
890397 | 890397 | 2021-01-02 | Washington | Rhode Island | 44009 | 4482 | 113 |
887150 | 887150 | 2021-01-01 | Washington | Rhode Island | 44009 | 4482 | 113 |
883905 | 883905 | 2020-12-31 | Washington | Rhode Island | 44009 | 4482 | 113 |
880660 | 880660 | 2020-12-30 | Washington | Rhode Island | 44009 | 4482 | 113 |
877415 | 877415 | 2020-12-29 | Washington | Rhode Island | 44009 | 4135 | 106 |
874170 | 874170 | 2020-12-28 | Washington | Rhode Island | 44009 | 4135 | 106 |
870925 | 870925 | 2020-12-27 | Washington | Rhode Island | 44009 | 4135 | 106 |
867680 | 867680 | 2020-12-26 | Washington | Rhode Island | 44009 | 4135 | 106 |
864435 | 864435 | 2020-12-25 | Washington | Rhode Island | 44009 | 4135 | 106 |
861190 | 861190 | 2020-12-24 | Washington | Rhode Island | 44009 | 4135 | 106 |
857945 | 857945 | 2020-12-23 | Washington | Rhode Island | 44009 | 4135 | 106 |
854700 | 854700 | 2020-12-22 | Washington | Rhode Island | 44009 | 3713 | 101 |
851455 | 851455 | 2020-12-21 | Washington | Rhode Island | 44009 | 3713 | 101 |
848210 | 848210 | 2020-12-20 | Washington | Rhode Island | 44009 | 3713 | 101 |
844965 | 844965 | 2020-12-19 | Washington | Rhode Island | 44009 | 3713 | 101 |
841719 | 841719 | 2020-12-18 | Washington | Rhode Island | 44009 | 3713 | 101 |
838474 | 838474 | 2020-12-17 | Washington | Rhode Island | 44009 | 3713 | 101 |
835228 | 835228 | 2020-12-16 | Washington | Rhode Island | 44009 | 3713 | 101 |
831982 | 831982 | 2020-12-15 | Washington | Rhode Island | 44009 | 3144 | 95 |
828735 | 828735 | 2020-12-14 | Washington | Rhode Island | 44009 | 3144 | 95 |
825489 | 825489 | 2020-12-13 | Washington | Rhode Island | 44009 | 3144 | 95 |
822242 | 822242 | 2020-12-12 | Washington | Rhode Island | 44009 | 3144 | 95 |
818996 | 818996 | 2020-12-11 | Washington | Rhode Island | 44009 | 3144 | 95 |
815750 | 815750 | 2020-12-10 | Washington | Rhode Island | 44009 | 3144 | 95 |
812504 | 812504 | 2020-12-09 | Washington | Rhode Island | 44009 | 3144 | 95 |
809260 | 809260 | 2020-12-08 | Washington | Rhode Island | 44009 | 2641 | 90 |
806015 | 806015 | 2020-12-07 | Washington | Rhode Island | 44009 | 2641 | 90 |
802770 | 802770 | 2020-12-06 | Washington | Rhode Island | 44009 | 2641 | 90 |
799525 | 799525 | 2020-12-05 | Washington | Rhode Island | 44009 | 2641 | 90 |
796280 | 796280 | 2020-12-04 | Washington | Rhode Island | 44009 | 2641 | 90 |
793035 | 793035 | 2020-12-03 | Washington | Rhode Island | 44009 | 2641 | 90 |
789790 | 789790 | 2020-12-02 | Washington | Rhode Island | 44009 | 2641 | 90 |
786545 | 786545 | 2020-12-01 | Washington | Rhode Island | 44009 | 2223 | 83 |
783301 | 783301 | 2020-11-30 | Washington | Rhode Island | 44009 | 2223 | 83 |
780056 | 780056 | 2020-11-29 | Washington | Rhode Island | 44009 | 2223 | 83 |
776810 | 776810 | 2020-11-28 | Washington | Rhode Island | 44009 | 2223 | 83 |
773565 | 773565 | 2020-11-27 | Washington | Rhode Island | 44009 | 2223 | 83 |
770320 | 770320 | 2020-11-26 | Washington | Rhode Island | 44009 | 2223 | 83 |
767074 | 767074 | 2020-11-25 | Washington | Rhode Island | 44009 | 2223 | 83 |
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);