ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where county = "Washington", deaths = 8 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1009064 | 1009064 | 2021-02-08 | Washington | Kansas | 20201 | 508 | 8 |
1005818 | 1005818 | 2021-02-07 | Washington | Kansas | 20201 | 503 | 8 |
1002572 | 1002572 | 2021-02-06 | Washington | Kansas | 20201 | 503 | 8 |
999326 | 999326 | 2021-02-05 | Washington | Kansas | 20201 | 503 | 8 |
996080 | 996080 | 2021-02-04 | Washington | Kansas | 20201 | 496 | 8 |
992834 | 992834 | 2021-02-03 | Washington | Kansas | 20201 | 496 | 8 |
989588 | 989588 | 2021-02-02 | Washington | Kansas | 20201 | 492 | 8 |
986341 | 986341 | 2021-02-01 | Washington | Kansas | 20201 | 492 | 8 |
983094 | 983094 | 2021-01-31 | Washington | Kansas | 20201 | 489 | 8 |
979848 | 979848 | 2021-01-30 | Washington | Kansas | 20201 | 489 | 8 |
976602 | 976602 | 2021-01-29 | Washington | Kansas | 20201 | 489 | 8 |
973357 | 973357 | 2021-01-28 | Washington | Kansas | 20201 | 485 | 8 |
970112 | 970112 | 2021-01-27 | Washington | Kansas | 20201 | 485 | 8 |
966868 | 966868 | 2021-01-26 | Washington | Kansas | 20201 | 481 | 8 |
963623 | 963623 | 2021-01-25 | Washington | Kansas | 20201 | 481 | 8 |
960378 | 960378 | 2021-01-24 | Washington | Kansas | 20201 | 481 | 8 |
957132 | 957132 | 2021-01-23 | Washington | Kansas | 20201 | 481 | 8 |
953887 | 953887 | 2021-01-22 | Washington | Kansas | 20201 | 481 | 8 |
950642 | 950642 | 2021-01-21 | Washington | Kansas | 20201 | 478 | 8 |
947396 | 947396 | 2021-01-20 | Washington | Kansas | 20201 | 478 | 8 |
944149 | 944149 | 2021-01-19 | Washington | Kansas | 20201 | 476 | 8 |
940904 | 940904 | 2021-01-18 | Washington | Kansas | 20201 | 476 | 8 |
937659 | 937659 | 2021-01-17 | Washington | Kansas | 20201 | 472 | 8 |
934414 | 934414 | 2021-01-16 | Washington | Kansas | 20201 | 472 | 8 |
931169 | 931169 | 2021-01-15 | Washington | Kansas | 20201 | 472 | 8 |
927924 | 927924 | 2021-01-14 | Washington | Kansas | 20201 | 463 | 8 |
924678 | 924678 | 2021-01-13 | Washington | Kansas | 20201 | 463 | 8 |
921433 | 921433 | 2021-01-12 | Washington | Kansas | 20201 | 457 | 8 |
918188 | 918188 | 2021-01-11 | Washington | Kansas | 20201 | 457 | 8 |
914943 | 914943 | 2021-01-10 | Washington | Kansas | 20201 | 451 | 8 |
911698 | 911698 | 2021-01-09 | Washington | Kansas | 20201 | 451 | 8 |
908453 | 908453 | 2021-01-08 | Washington | Kansas | 20201 | 451 | 8 |
905207 | 905207 | 2021-01-07 | Washington | Kansas | 20201 | 444 | 8 |
901962 | 901962 | 2021-01-06 | Washington | Kansas | 20201 | 444 | 8 |
898717 | 898717 | 2021-01-05 | Washington | Kansas | 20201 | 442 | 8 |
895472 | 895472 | 2021-01-04 | Washington | Kansas | 20201 | 442 | 8 |
892225 | 892225 | 2021-01-03 | Washington | Kansas | 20201 | 440 | 8 |
888979 | 888979 | 2021-01-02 | Washington | Kansas | 20201 | 440 | 8 |
885733 | 885733 | 2021-01-01 | Washington | Kansas | 20201 | 440 | 8 |
882488 | 882488 | 2020-12-31 | Washington | Kansas | 20201 | 436 | 8 |
879243 | 879243 | 2020-12-30 | Washington | Kansas | 20201 | 436 | 8 |
875998 | 875998 | 2020-12-29 | Washington | Kansas | 20201 | 403 | 8 |
872753 | 872753 | 2020-12-28 | Washington | Kansas | 20201 | 403 | 8 |
869508 | 869508 | 2020-12-27 | Washington | Kansas | 20201 | 395 | 8 |
866263 | 866263 | 2020-12-26 | Washington | Kansas | 20201 | 395 | 8 |
863018 | 863018 | 2020-12-25 | Washington | Kansas | 20201 | 395 | 8 |
859773 | 859773 | 2020-12-24 | Washington | Kansas | 20201 | 395 | 8 |
856528 | 856528 | 2020-12-23 | Washington | Kansas | 20201 | 395 | 8 |
853283 | 853283 | 2020-12-22 | Washington | Kansas | 20201 | 394 | 8 |
850038 | 850038 | 2020-12-21 | Washington | Kansas | 20201 | 394 | 8 |
846793 | 846793 | 2020-12-20 | Washington | Kansas | 20201 | 388 | 8 |
843547 | 843547 | 2020-12-19 | Washington | Kansas | 20201 | 388 | 8 |
840302 | 840302 | 2020-12-18 | Washington | Kansas | 20201 | 388 | 8 |
837057 | 837057 | 2020-12-17 | Washington | Kansas | 20201 | 375 | 8 |
833811 | 833811 | 2020-12-16 | Washington | Kansas | 20201 | 375 | 8 |
830564 | 830564 | 2020-12-15 | Washington | Kansas | 20201 | 366 | 8 |
827318 | 827318 | 2020-12-14 | Washington | Kansas | 20201 | 366 | 8 |
824071 | 824071 | 2020-12-13 | Washington | Kansas | 20201 | 366 | 8 |
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);