ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Washington" and fips = 49053 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1196013 | 1196013 | 2021-04-06 | Washington | Utah | 49053 | 20600 | 204 |
1192765 | 1192765 | 2021-04-05 | Washington | Utah | 49053 | 20592 | 204 |
1189516 | 1189516 | 2021-04-04 | Washington | Utah | 49053 | 20592 | 204 |
1186269 | 1186269 | 2021-04-03 | Washington | Utah | 49053 | 20565 | 204 |
1183022 | 1183022 | 2021-04-02 | Washington | Utah | 49053 | 20565 | 204 |
1179775 | 1179775 | 2021-04-01 | Washington | Utah | 49053 | 20549 | 204 |
1176528 | 1176528 | 2021-03-31 | Washington | Utah | 49053 | 20522 | 204 |
1173281 | 1173281 | 2021-03-30 | Washington | Utah | 49053 | 20522 | 204 |
1170034 | 1170034 | 2021-03-29 | Washington | Utah | 49053 | 20504 | 204 |
1166786 | 1166786 | 2021-03-28 | Washington | Utah | 49053 | 20470 | 203 |
1163538 | 1163538 | 2021-03-27 | Washington | Utah | 49053 | 20470 | 203 |
1160289 | 1160289 | 2021-03-26 | Washington | Utah | 49053 | 20470 | 203 |
1157042 | 1157042 | 2021-03-25 | Washington | Utah | 49053 | 20459 | 203 |
1153795 | 1153795 | 2021-03-24 | Washington | Utah | 49053 | 20445 | 202 |
1150548 | 1150548 | 2021-03-23 | Washington | Utah | 49053 | 20427 | 199 |
1147301 | 1147301 | 2021-03-22 | Washington | Utah | 49053 | 20418 | 190 |
1144054 | 1144054 | 2021-03-21 | Washington | Utah | 49053 | 20418 | 190 |
1140807 | 1140807 | 2021-03-20 | Washington | Utah | 49053 | 20418 | 190 |
1137561 | 1137561 | 2021-03-19 | Washington | Utah | 49053 | 20418 | 190 |
1134315 | 1134315 | 2021-03-18 | Washington | Utah | 49053 | 20418 | 190 |
1131067 | 1131067 | 2021-03-17 | Washington | Utah | 49053 | 20418 | 190 |
1127820 | 1127820 | 2021-03-16 | Washington | Utah | 49053 | 20418 | 190 |
1124574 | 1124574 | 2021-03-15 | Washington | Utah | 49053 | 20418 | 190 |
1121328 | 1121328 | 2021-03-14 | Washington | Utah | 49053 | 20418 | 190 |
1118081 | 1118081 | 2021-03-13 | Washington | Utah | 49053 | 20418 | 190 |
1114834 | 1114834 | 2021-03-12 | Washington | Utah | 49053 | 20418 | 190 |
1111588 | 1111588 | 2021-03-11 | Washington | Utah | 49053 | 20368 | 185 |
1108342 | 1108342 | 2021-03-10 | Washington | Utah | 49053 | 20368 | 185 |
1105096 | 1105096 | 2021-03-09 | Washington | Utah | 49053 | 20304 | 185 |
1101850 | 1101850 | 2021-03-08 | Washington | Utah | 49053 | 20304 | 185 |
1098604 | 1098604 | 2021-03-07 | Washington | Utah | 49053 | 20189 | 184 |
1095356 | 1095356 | 2021-03-06 | Washington | Utah | 49053 | 20189 | 184 |
1092110 | 1092110 | 2021-03-05 | Washington | Utah | 49053 | 20189 | 184 |
1088864 | 1088864 | 2021-03-04 | Washington | Utah | 49053 | 20189 | 184 |
1085619 | 1085619 | 2021-03-03 | Washington | Utah | 49053 | 20189 | 184 |
1082373 | 1082373 | 2021-03-02 | Washington | Utah | 49053 | 20144 | 184 |
1079127 | 1079127 | 2021-03-01 | Washington | Utah | 49053 | 20144 | 183 |
1075882 | 1075882 | 2021-02-28 | Washington | Utah | 49053 | 20065 | 179 |
1072636 | 1072636 | 2021-02-27 | Washington | Utah | 49053 | 20065 | 179 |
1069390 | 1069390 | 2021-02-26 | Washington | Utah | 49053 | 20065 | 179 |
1066145 | 1066145 | 2021-02-25 | Washington | Utah | 49053 | 19984 | 178 |
1062900 | 1062900 | 2021-02-24 | Washington | Utah | 49053 | 19984 | 178 |
1059655 | 1059655 | 2021-02-23 | Washington | Utah | 49053 | 19898 | 176 |
1056409 | 1056409 | 2021-02-22 | Washington | Utah | 49053 | 19898 | 176 |
1053163 | 1053163 | 2021-02-21 | Washington | Utah | 49053 | 19801 | 176 |
1049916 | 1049916 | 2021-02-20 | Washington | Utah | 49053 | 19801 | 176 |
1046669 | 1046669 | 2021-02-19 | Washington | Utah | 49053 | 19801 | 176 |
1043424 | 1043424 | 2021-02-18 | Washington | Utah | 49053 | 19756 | 173 |
1040179 | 1040179 | 2021-02-17 | Washington | Utah | 49053 | 19700 | 173 |
1036934 | 1036934 | 2021-02-16 | Washington | Utah | 49053 | 19628 | 171 |
1033689 | 1033689 | 2021-02-15 | Washington | Utah | 49053 | 19542 | 170 |
1030443 | 1030443 | 2021-02-14 | Washington | Utah | 49053 | 19542 | 170 |
1027196 | 1027196 | 2021-02-13 | Washington | Utah | 49053 | 19542 | 170 |
1023951 | 1023951 | 2021-02-12 | Washington | Utah | 49053 | 19542 | 170 |
1020706 | 1020706 | 2021-02-11 | Washington | Utah | 49053 | 19437 | 170 |
1017461 | 1017461 | 2021-02-10 | Washington | Utah | 49053 | 19437 | 169 |
1014216 | 1014216 | 2021-02-09 | Washington | Utah | 49053 | 19341 | 169 |
1010971 | 1010971 | 2021-02-08 | Washington | Utah | 49053 | 19292 | 169 |
1007725 | 1007725 | 2021-02-07 | Washington | Utah | 49053 | 19129 | 168 |
1004479 | 1004479 | 2021-02-06 | Washington | Utah | 49053 | 19129 | 168 |
1001233 | 1001233 | 2021-02-05 | Washington | Utah | 49053 | 19129 | 168 |
997987 | 997987 | 2021-02-04 | Washington | Utah | 49053 | 18985 | 167 |
994741 | 994741 | 2021-02-03 | Washington | Utah | 49053 | 18985 | 166 |
991495 | 991495 | 2021-02-02 | Washington | Utah | 49053 | 18900 | 165 |
988249 | 988249 | 2021-02-01 | Washington | Utah | 49053 | 18884 | 163 |
985002 | 985002 | 2021-01-31 | Washington | Utah | 49053 | 18725 | 163 |
981755 | 981755 | 2021-01-30 | Washington | Utah | 49053 | 18725 | 163 |
978509 | 978509 | 2021-01-29 | Washington | Utah | 49053 | 18657 | 163 |
975264 | 975264 | 2021-01-28 | Washington | Utah | 49053 | 18547 | 162 |
972019 | 972019 | 2021-01-27 | Washington | Utah | 49053 | 18446 | 162 |
968774 | 968774 | 2021-01-26 | Washington | Utah | 49053 | 18314 | 160 |
965530 | 965530 | 2021-01-25 | Washington | Utah | 49053 | 18230 | 158 |
962285 | 962285 | 2021-01-24 | Washington | Utah | 49053 | 18066 | 156 |
959040 | 959040 | 2021-01-23 | Washington | Utah | 49053 | 18066 | 156 |
955794 | 955794 | 2021-01-22 | Washington | Utah | 49053 | 17795 | 155 |
952549 | 952549 | 2021-01-21 | Washington | Utah | 49053 | 17795 | 155 |
949304 | 949304 | 2021-01-20 | Washington | Utah | 49053 | 17644 | 152 |
946058 | 946058 | 2021-01-19 | Washington | Utah | 49053 | 17240 | 147 |
942811 | 942811 | 2021-01-18 | Washington | Utah | 49053 | 17240 | 147 |
939566 | 939566 | 2021-01-17 | Washington | Utah | 49053 | 17240 | 147 |
936321 | 936321 | 2021-01-16 | Washington | Utah | 49053 | 17240 | 147 |
933076 | 933076 | 2021-01-15 | Washington | Utah | 49053 | 17129 | 144 |
929831 | 929831 | 2021-01-14 | Washington | Utah | 49053 | 17000 | 143 |
926586 | 926586 | 2021-01-13 | Washington | Utah | 49053 | 16524 | 131 |
923340 | 923340 | 2021-01-12 | Washington | Utah | 49053 | 16524 | 131 |
920095 | 920095 | 2021-01-11 | Washington | Utah | 49053 | 16524 | 131 |
916850 | 916850 | 2021-01-10 | Washington | Utah | 49053 | 16184 | 129 |
913605 | 913605 | 2021-01-09 | Washington | Utah | 49053 | 16184 | 129 |
910360 | 910360 | 2021-01-08 | Washington | Utah | 49053 | 15973 | 129 |
907115 | 907115 | 2021-01-07 | Washington | Utah | 49053 | 15725 | 127 |
903869 | 903869 | 2021-01-06 | Washington | Utah | 49053 | 15521 | 124 |
900624 | 900624 | 2021-01-05 | Washington | Utah | 49053 | 15283 | 122 |
897379 | 897379 | 2021-01-04 | Washington | Utah | 49053 | 14990 | 119 |
894133 | 894133 | 2021-01-03 | Washington | Utah | 49053 | 14887 | 114 |
890887 | 890887 | 2021-01-02 | Washington | Utah | 49053 | 14887 | 114 |
887640 | 887640 | 2021-01-01 | Washington | Utah | 49053 | 14765 | 111 |
884395 | 884395 | 2020-12-31 | Washington | Utah | 49053 | 14765 | 111 |
881150 | 881150 | 2020-12-30 | Washington | Utah | 49053 | 14492 | 110 |
877905 | 877905 | 2020-12-29 | Washington | Utah | 49053 | 14268 | 109 |
874660 | 874660 | 2020-12-28 | Washington | Utah | 49053 | 14126 | 107 |
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);