ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Washington" and fips = 8121 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193414 | 1193414 | 2021-04-06 | Washington | Colorado | 8121 | 437 | 12 |
1190164 | 1190164 | 2021-04-05 | Washington | Colorado | 8121 | 437 | 12 |
1186917 | 1186917 | 2021-04-04 | Washington | Colorado | 8121 | 437 | 12 |
1183670 | 1183670 | 2021-04-03 | Washington | Colorado | 8121 | 436 | 12 |
1180423 | 1180423 | 2021-04-02 | Washington | Colorado | 8121 | 436 | 12 |
1177176 | 1177176 | 2021-04-01 | Washington | Colorado | 8121 | 436 | 12 |
1173929 | 1173929 | 2021-03-31 | Washington | Colorado | 8121 | 436 | 12 |
1170682 | 1170682 | 2021-03-30 | Washington | Colorado | 8121 | 436 | 12 |
1167434 | 1167434 | 2021-03-29 | Washington | Colorado | 8121 | 436 | 12 |
1164186 | 1164186 | 2021-03-28 | Washington | Colorado | 8121 | 435 | 12 |
1160938 | 1160938 | 2021-03-27 | Washington | Colorado | 8121 | 434 | 12 |
1157690 | 1157690 | 2021-03-26 | Washington | Colorado | 8121 | 433 | 12 |
1154443 | 1154443 | 2021-03-25 | Washington | Colorado | 8121 | 431 | 12 |
1151196 | 1151196 | 2021-03-24 | Washington | Colorado | 8121 | 431 | 12 |
1147949 | 1147949 | 2021-03-23 | Washington | Colorado | 8121 | 430 | 12 |
1144702 | 1144702 | 2021-03-22 | Washington | Colorado | 8121 | 429 | 12 |
1141455 | 1141455 | 2021-03-21 | Washington | Colorado | 8121 | 429 | 12 |
1138209 | 1138209 | 2021-03-20 | Washington | Colorado | 8121 | 428 | 12 |
1134963 | 1134963 | 2021-03-19 | Washington | Colorado | 8121 | 426 | 12 |
1131716 | 1131716 | 2021-03-18 | Washington | Colorado | 8121 | 425 | 12 |
1128468 | 1128468 | 2021-03-17 | Washington | Colorado | 8121 | 424 | 12 |
1125222 | 1125222 | 2021-03-16 | Washington | Colorado | 8121 | 421 | 12 |
1121976 | 1121976 | 2021-03-15 | Washington | Colorado | 8121 | 415 | 12 |
1118729 | 1118729 | 2021-03-14 | Washington | Colorado | 8121 | 415 | 12 |
1115482 | 1115482 | 2021-03-13 | Washington | Colorado | 8121 | 415 | 12 |
1112236 | 1112236 | 2021-03-12 | Washington | Colorado | 8121 | 415 | 12 |
1108990 | 1108990 | 2021-03-11 | Washington | Colorado | 8121 | 406 | 12 |
1105744 | 1105744 | 2021-03-10 | Washington | Colorado | 8121 | 403 | 12 |
1102498 | 1102498 | 2021-03-09 | Washington | Colorado | 8121 | 399 | 12 |
1099252 | 1099252 | 2021-03-08 | Washington | Colorado | 8121 | 398 | 12 |
1096004 | 1096004 | 2021-03-07 | Washington | Colorado | 8121 | 398 | 12 |
1092758 | 1092758 | 2021-03-06 | Washington | Colorado | 8121 | 398 | 12 |
1089512 | 1089512 | 2021-03-05 | Washington | Colorado | 8121 | 396 | 12 |
1086267 | 1086267 | 2021-03-04 | Washington | Colorado | 8121 | 392 | 12 |
1083021 | 1083021 | 2021-03-03 | Washington | Colorado | 8121 | 392 | 12 |
1079775 | 1079775 | 2021-03-02 | Washington | Colorado | 8121 | 389 | 12 |
1076530 | 1076530 | 2021-03-01 | Washington | Colorado | 8121 | 387 | 12 |
1073284 | 1073284 | 2021-02-28 | Washington | Colorado | 8121 | 380 | 12 |
1070038 | 1070038 | 2021-02-27 | Washington | Colorado | 8121 | 380 | 12 |
1066793 | 1066793 | 2021-02-26 | Washington | Colorado | 8121 | 379 | 12 |
1063548 | 1063548 | 2021-02-25 | Washington | Colorado | 8121 | 379 | 12 |
1060303 | 1060303 | 2021-02-24 | Washington | Colorado | 8121 | 378 | 12 |
1057057 | 1057057 | 2021-02-23 | Washington | Colorado | 8121 | 377 | 12 |
1053811 | 1053811 | 2021-02-22 | Washington | Colorado | 8121 | 378 | 12 |
1050564 | 1050564 | 2021-02-21 | Washington | Colorado | 8121 | 378 | 12 |
1047317 | 1047317 | 2021-02-20 | Washington | Colorado | 8121 | 377 | 12 |
1044072 | 1044072 | 2021-02-19 | Washington | Colorado | 8121 | 375 | 12 |
1040827 | 1040827 | 2021-02-18 | Washington | Colorado | 8121 | 374 | 12 |
1037582 | 1037582 | 2021-02-17 | Washington | Colorado | 8121 | 368 | 12 |
1034337 | 1034337 | 2021-02-16 | Washington | Colorado | 8121 | 369 | 12 |
1031091 | 1031091 | 2021-02-15 | Washington | Colorado | 8121 | 366 | 12 |
1027844 | 1027844 | 2021-02-14 | Washington | Colorado | 8121 | 367 | 12 |
1024599 | 1024599 | 2021-02-13 | Washington | Colorado | 8121 | 366 | 12 |
1021354 | 1021354 | 2021-02-12 | Washington | Colorado | 8121 | 365 | 12 |
1018109 | 1018109 | 2021-02-11 | Washington | Colorado | 8121 | 365 | 12 |
1014864 | 1014864 | 2021-02-10 | Washington | Colorado | 8121 | 365 | 12 |
1011619 | 1011619 | 2021-02-09 | Washington | Colorado | 8121 | 366 | 12 |
1008373 | 1008373 | 2021-02-08 | Washington | Colorado | 8121 | 367 | 12 |
1005127 | 1005127 | 2021-02-07 | Washington | Colorado | 8121 | 366 | 12 |
1001881 | 1001881 | 2021-02-06 | Washington | Colorado | 8121 | 365 | 12 |
998635 | 998635 | 2021-02-05 | Washington | Colorado | 8121 | 364 | 12 |
995389 | 995389 | 2021-02-04 | Washington | Colorado | 8121 | 364 | 12 |
992143 | 992143 | 2021-02-03 | Washington | Colorado | 8121 | 364 | 12 |
988897 | 988897 | 2021-02-02 | Washington | Colorado | 8121 | 363 | 12 |
985650 | 985650 | 2021-02-01 | Washington | Colorado | 8121 | 364 | 12 |
982403 | 982403 | 2021-01-31 | Washington | Colorado | 8121 | 365 | 12 |
979157 | 979157 | 2021-01-30 | Washington | Colorado | 8121 | 365 | 12 |
975912 | 975912 | 2021-01-29 | Washington | Colorado | 8121 | 365 | 12 |
972667 | 972667 | 2021-01-28 | Washington | Colorado | 8121 | 365 | 11 |
969422 | 969422 | 2021-01-27 | Washington | Colorado | 8121 | 363 | 11 |
966178 | 966178 | 2021-01-26 | Washington | Colorado | 8121 | 364 | 11 |
962933 | 962933 | 2021-01-25 | Washington | Colorado | 8121 | 364 | 11 |
959688 | 959688 | 2021-01-24 | Washington | Colorado | 8121 | 364 | 11 |
956442 | 956442 | 2021-01-23 | Washington | Colorado | 8121 | 363 | 11 |
953197 | 953197 | 2021-01-22 | Washington | Colorado | 8121 | 362 | 11 |
949952 | 949952 | 2021-01-21 | Washington | Colorado | 8121 | 364 | 11 |
946706 | 946706 | 2021-01-20 | Washington | Colorado | 8121 | 363 | 11 |
943459 | 943459 | 2021-01-19 | Washington | Colorado | 8121 | 360 | 11 |
940214 | 940214 | 2021-01-18 | Washington | Colorado | 8121 | 360 | 11 |
936969 | 936969 | 2021-01-17 | Washington | Colorado | 8121 | 359 | 11 |
933724 | 933724 | 2021-01-16 | Washington | Colorado | 8121 | 360 | 11 |
930479 | 930479 | 2021-01-15 | Washington | Colorado | 8121 | 357 | 11 |
927234 | 927234 | 2021-01-14 | Washington | Colorado | 8121 | 356 | 11 |
923988 | 923988 | 2021-01-13 | Washington | Colorado | 8121 | 356 | 11 |
920743 | 920743 | 2021-01-12 | Washington | Colorado | 8121 | 354 | 11 |
917498 | 917498 | 2021-01-11 | Washington | Colorado | 8121 | 352 | 11 |
914253 | 914253 | 2021-01-10 | Washington | Colorado | 8121 | 352 | 11 |
911008 | 911008 | 2021-01-09 | Washington | Colorado | 8121 | 351 | 11 |
907763 | 907763 | 2021-01-08 | Washington | Colorado | 8121 | 351 | 11 |
904517 | 904517 | 2021-01-07 | Washington | Colorado | 8121 | 350 | 11 |
901272 | 901272 | 2021-01-06 | Washington | Colorado | 8121 | 349 | 11 |
898027 | 898027 | 2021-01-05 | Washington | Colorado | 8121 | 349 | 11 |
894782 | 894782 | 2021-01-04 | Washington | Colorado | 8121 | 349 | 11 |
891535 | 891535 | 2021-01-03 | Washington | Colorado | 8121 | 349 | 11 |
888288 | 888288 | 2021-01-02 | Washington | Colorado | 8121 | 349 | 11 |
885043 | 885043 | 2021-01-01 | Washington | Colorado | 8121 | 347 | 11 |
881798 | 881798 | 2020-12-31 | Washington | Colorado | 8121 | 347 | 10 |
878553 | 878553 | 2020-12-30 | Washington | Colorado | 8121 | 346 | 10 |
875308 | 875308 | 2020-12-29 | Washington | Colorado | 8121 | 344 | 10 |
872063 | 872063 | 2020-12-28 | Washington | Colorado | 8121 | 341 | 10 |
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);