ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where county = "Jefferson", deaths = 2, fips = 53031 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1244900 | 1244900 | 2021-04-21 | Jefferson | Washington | 53031 | 380 | 2 |
1241653 | 1241653 | 2021-04-20 | Jefferson | Washington | 53031 | 378 | 2 |
1238406 | 1238406 | 2021-04-19 | Jefferson | Washington | 53031 | 373 | 2 |
1235159 | 1235159 | 2021-04-18 | Jefferson | Washington | 53031 | 371 | 2 |
1231911 | 1231911 | 2021-04-17 | Jefferson | Washington | 53031 | 371 | 2 |
1228663 | 1228663 | 2021-04-16 | Jefferson | Washington | 53031 | 364 | 2 |
1225415 | 1225415 | 2021-04-15 | Jefferson | Washington | 53031 | 364 | 2 |
1222168 | 1222168 | 2021-04-14 | Jefferson | Washington | 53031 | 364 | 2 |
1218920 | 1218920 | 2021-04-13 | Jefferson | Washington | 53031 | 363 | 2 |
1215672 | 1215672 | 2021-04-12 | Jefferson | Washington | 53031 | 362 | 2 |
1212425 | 1212425 | 2021-04-11 | Jefferson | Washington | 53031 | 360 | 2 |
1209176 | 1209176 | 2021-04-10 | Jefferson | Washington | 53031 | 360 | 2 |
1205928 | 1205928 | 2021-04-09 | Jefferson | Washington | 53031 | 359 | 2 |
1202680 | 1202680 | 2021-04-08 | Jefferson | Washington | 53031 | 357 | 2 |
1199432 | 1199432 | 2021-04-07 | Jefferson | Washington | 53031 | 356 | 2 |
1196183 | 1196183 | 2021-04-06 | Jefferson | Washington | 53031 | 353 | 2 |
1192935 | 1192935 | 2021-04-05 | Jefferson | Washington | 53031 | 353 | 2 |
1189685 | 1189685 | 2021-04-04 | Jefferson | Washington | 53031 | 351 | 2 |
1186438 | 1186438 | 2021-04-03 | Jefferson | Washington | 53031 | 351 | 2 |
1183191 | 1183191 | 2021-04-02 | Jefferson | Washington | 53031 | 348 | 2 |
1179944 | 1179944 | 2021-04-01 | Jefferson | Washington | 53031 | 348 | 2 |
1176697 | 1176697 | 2021-03-31 | Jefferson | Washington | 53031 | 347 | 2 |
1173450 | 1173450 | 2021-03-30 | Jefferson | Washington | 53031 | 346 | 2 |
1170203 | 1170203 | 2021-03-29 | Jefferson | Washington | 53031 | 345 | 2 |
1166955 | 1166955 | 2021-03-28 | Jefferson | Washington | 53031 | 349 | 2 |
1163707 | 1163707 | 2021-03-27 | Jefferson | Washington | 53031 | 349 | 2 |
1160459 | 1160459 | 2021-03-26 | Jefferson | Washington | 53031 | 345 | 2 |
1157211 | 1157211 | 2021-03-25 | Jefferson | Washington | 53031 | 345 | 2 |
1153964 | 1153964 | 2021-03-24 | Jefferson | Washington | 53031 | 345 | 2 |
1150717 | 1150717 | 2021-03-23 | Jefferson | Washington | 53031 | 345 | 2 |
1147470 | 1147470 | 2021-03-22 | Jefferson | Washington | 53031 | 344 | 2 |
1144223 | 1144223 | 2021-03-21 | Jefferson | Washington | 53031 | 343 | 2 |
1140976 | 1140976 | 2021-03-20 | Jefferson | Washington | 53031 | 343 | 2 |
1137730 | 1137730 | 2021-03-19 | Jefferson | Washington | 53031 | 342 | 2 |
1134484 | 1134484 | 2021-03-18 | Jefferson | Washington | 53031 | 339 | 2 |
1131236 | 1131236 | 2021-03-17 | Jefferson | Washington | 53031 | 338 | 2 |
1127989 | 1127989 | 2021-03-16 | Jefferson | Washington | 53031 | 338 | 2 |
1124743 | 1124743 | 2021-03-15 | Jefferson | Washington | 53031 | 337 | 2 |
1121497 | 1121497 | 2021-03-14 | Jefferson | Washington | 53031 | 338 | 2 |
1118250 | 1118250 | 2021-03-13 | Jefferson | Washington | 53031 | 338 | 2 |
1115003 | 1115003 | 2021-03-12 | Jefferson | Washington | 53031 | 338 | 2 |
1111757 | 1111757 | 2021-03-11 | Jefferson | Washington | 53031 | 338 | 2 |
1108511 | 1108511 | 2021-03-10 | Jefferson | Washington | 53031 | 338 | 2 |
1105265 | 1105265 | 2021-03-09 | Jefferson | Washington | 53031 | 338 | 2 |
1102019 | 1102019 | 2021-03-08 | Jefferson | Washington | 53031 | 338 | 2 |
1098773 | 1098773 | 2021-03-07 | Jefferson | Washington | 53031 | 338 | 2 |
1095525 | 1095525 | 2021-03-06 | Jefferson | Washington | 53031 | 338 | 2 |
1092279 | 1092279 | 2021-03-05 | Jefferson | Washington | 53031 | 338 | 2 |
1089033 | 1089033 | 2021-03-04 | Jefferson | Washington | 53031 | 338 | 2 |
1085788 | 1085788 | 2021-03-03 | Jefferson | Washington | 53031 | 337 | 2 |
1082542 | 1082542 | 2021-03-02 | Jefferson | Washington | 53031 | 337 | 2 |
1079296 | 1079296 | 2021-03-01 | Jefferson | Washington | 53031 | 337 | 2 |
1076051 | 1076051 | 2021-02-28 | Jefferson | Washington | 53031 | 337 | 2 |
1072805 | 1072805 | 2021-02-27 | Jefferson | Washington | 53031 | 337 | 2 |
1069559 | 1069559 | 2021-02-26 | Jefferson | Washington | 53031 | 337 | 2 |
1066314 | 1066314 | 2021-02-25 | Jefferson | Washington | 53031 | 335 | 2 |
1063069 | 1063069 | 2021-02-24 | Jefferson | Washington | 53031 | 335 | 2 |
1059824 | 1059824 | 2021-02-23 | Jefferson | Washington | 53031 | 333 | 2 |
1056578 | 1056578 | 2021-02-22 | Jefferson | Washington | 53031 | 333 | 2 |
1053332 | 1053332 | 2021-02-21 | Jefferson | Washington | 53031 | 333 | 2 |
1050085 | 1050085 | 2021-02-20 | Jefferson | Washington | 53031 | 333 | 2 |
1046838 | 1046838 | 2021-02-19 | Jefferson | Washington | 53031 | 331 | 2 |
1043593 | 1043593 | 2021-02-18 | Jefferson | Washington | 53031 | 331 | 2 |
1040348 | 1040348 | 2021-02-17 | Jefferson | Washington | 53031 | 331 | 2 |
1037103 | 1037103 | 2021-02-16 | Jefferson | Washington | 53031 | 329 | 2 |
1033858 | 1033858 | 2021-02-15 | Jefferson | Washington | 53031 | 329 | 2 |
1030612 | 1030612 | 2021-02-14 | Jefferson | Washington | 53031 | 329 | 2 |
1027365 | 1027365 | 2021-02-13 | Jefferson | Washington | 53031 | 329 | 2 |
1024120 | 1024120 | 2021-02-12 | Jefferson | Washington | 53031 | 328 | 2 |
1020875 | 1020875 | 2021-02-11 | Jefferson | Washington | 53031 | 325 | 2 |
1017630 | 1017630 | 2021-02-10 | Jefferson | Washington | 53031 | 325 | 2 |
1014385 | 1014385 | 2021-02-09 | Jefferson | Washington | 53031 | 325 | 2 |
1011140 | 1011140 | 2021-02-08 | Jefferson | Washington | 53031 | 325 | 2 |
1007894 | 1007894 | 2021-02-07 | Jefferson | Washington | 53031 | 317 | 2 |
1004648 | 1004648 | 2021-02-06 | Jefferson | Washington | 53031 | 317 | 2 |
1001402 | 1001402 | 2021-02-05 | Jefferson | Washington | 53031 | 316 | 2 |
998156 | 998156 | 2021-02-04 | Jefferson | Washington | 53031 | 312 | 2 |
994910 | 994910 | 2021-02-03 | Jefferson | Washington | 53031 | 309 | 2 |
991664 | 991664 | 2021-02-02 | Jefferson | Washington | 53031 | 309 | 2 |
988418 | 988418 | 2021-02-01 | Jefferson | Washington | 53031 | 308 | 2 |
985171 | 985171 | 2021-01-31 | Jefferson | Washington | 53031 | 292 | 2 |
981924 | 981924 | 2021-01-30 | Jefferson | Washington | 53031 | 292 | 2 |
978678 | 978678 | 2021-01-29 | Jefferson | Washington | 53031 | 291 | 2 |
975433 | 975433 | 2021-01-28 | Jefferson | Washington | 53031 | 290 | 2 |
972188 | 972188 | 2021-01-27 | Jefferson | Washington | 53031 | 286 | 2 |
968943 | 968943 | 2021-01-26 | Jefferson | Washington | 53031 | 284 | 2 |
965699 | 965699 | 2021-01-25 | Jefferson | Washington | 53031 | 281 | 2 |
962454 | 962454 | 2021-01-24 | Jefferson | Washington | 53031 | 281 | 2 |
959209 | 959209 | 2021-01-23 | Jefferson | Washington | 53031 | 281 | 2 |
955963 | 955963 | 2021-01-22 | Jefferson | Washington | 53031 | 279 | 2 |
952718 | 952718 | 2021-01-21 | Jefferson | Washington | 53031 | 277 | 2 |
949473 | 949473 | 2021-01-20 | Jefferson | Washington | 53031 | 276 | 2 |
946227 | 946227 | 2021-01-19 | Jefferson | Washington | 53031 | 273 | 2 |
942980 | 942980 | 2021-01-18 | Jefferson | Washington | 53031 | 273 | 2 |
939735 | 939735 | 2021-01-17 | Jefferson | Washington | 53031 | 273 | 2 |
936490 | 936490 | 2021-01-16 | Jefferson | Washington | 53031 | 267 | 2 |
933245 | 933245 | 2021-01-15 | Jefferson | Washington | 53031 | 267 | 2 |
930000 | 930000 | 2021-01-14 | Jefferson | Washington | 53031 | 261 | 2 |
926755 | 926755 | 2021-01-13 | Jefferson | Washington | 53031 | 259 | 2 |
923509 | 923509 | 2021-01-12 | Jefferson | Washington | 53031 | 258 | 2 |
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);