ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Washington" 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 |
---|---|---|---|---|---|---|---|
1195523 | 1195523 | 2021-04-06 | Washington | Rhode Island | 44009 | 9102 | 166 |
1192275 | 1192275 | 2021-04-05 | Washington | Rhode Island | 44009 | 9102 | 166 |
1189026 | 1189026 | 2021-04-04 | Washington | Rhode Island | 44009 | 9102 | 166 |
1185779 | 1185779 | 2021-04-03 | Washington | Rhode Island | 44009 | 9102 | 166 |
1182532 | 1182532 | 2021-04-02 | Washington | Rhode Island | 44009 | 9102 | 166 |
1179285 | 1179285 | 2021-04-01 | Washington | Rhode Island | 44009 | 9102 | 166 |
1176038 | 1176038 | 2021-03-31 | Washington | Rhode Island | 44009 | 9102 | 166 |
1172791 | 1172791 | 2021-03-30 | Washington | Rhode Island | 44009 | 8899 | 164 |
1169544 | 1169544 | 2021-03-29 | Washington | Rhode Island | 44009 | 8899 | 164 |
1166296 | 1166296 | 2021-03-28 | Washington | Rhode Island | 44009 | 8899 | 164 |
1163048 | 1163048 | 2021-03-27 | Washington | Rhode Island | 44009 | 8899 | 164 |
1159799 | 1159799 | 2021-03-26 | Washington | Rhode Island | 44009 | 8899 | 164 |
1156552 | 1156552 | 2021-03-25 | Washington | Rhode Island | 44009 | 8899 | 164 |
1153305 | 1153305 | 2021-03-24 | Washington | Rhode Island | 44009 | 8899 | 164 |
1150058 | 1150058 | 2021-03-23 | Washington | Rhode Island | 44009 | 8574 | 163 |
1146811 | 1146811 | 2021-03-22 | Washington | Rhode Island | 44009 | 8574 | 163 |
1143564 | 1143564 | 2021-03-21 | Washington | Rhode Island | 44009 | 8574 | 163 |
1140317 | 1140317 | 2021-03-20 | Washington | Rhode Island | 44009 | 8574 | 163 |
1137071 | 1137071 | 2021-03-19 | Washington | Rhode Island | 44009 | 8574 | 163 |
1133825 | 1133825 | 2021-03-18 | Washington | Rhode Island | 44009 | 8574 | 163 |
1130577 | 1130577 | 2021-03-17 | Washington | Rhode Island | 44009 | 8574 | 163 |
1127330 | 1127330 | 2021-03-16 | Washington | Rhode Island | 44009 | 8141 | 160 |
1124084 | 1124084 | 2021-03-15 | Washington | Rhode Island | 44009 | 8141 | 160 |
1120838 | 1120838 | 2021-03-14 | Washington | Rhode Island | 44009 | 8141 | 160 |
1117591 | 1117591 | 2021-03-13 | Washington | Rhode Island | 44009 | 8141 | 160 |
1114344 | 1114344 | 2021-03-12 | Washington | Rhode Island | 44009 | 8141 | 160 |
1111098 | 1111098 | 2021-03-11 | Washington | Rhode Island | 44009 | 8141 | 160 |
1107852 | 1107852 | 2021-03-10 | Washington | Rhode Island | 44009 | 8141 | 160 |
1104606 | 1104606 | 2021-03-09 | Washington | Rhode Island | 44009 | 7867 | 160 |
1101360 | 1101360 | 2021-03-08 | Washington | Rhode Island | 44009 | 7867 | 160 |
1098114 | 1098114 | 2021-03-07 | Washington | Rhode Island | 44009 | 7867 | 160 |
1094866 | 1094866 | 2021-03-06 | Washington | Rhode Island | 44009 | 7867 | 160 |
1091620 | 1091620 | 2021-03-05 | Washington | Rhode Island | 44009 | 7867 | 160 |
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 |
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);