ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where county = "Lincoln", deaths = 2 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
745019 | 745019 | 2020-11-18 | Lincoln | Washington | 53043 | 122 | 2 |
741772 | 741772 | 2020-11-17 | Lincoln | Washington | 53043 | 122 | 2 |
735281 | 735281 | 2020-11-15 | Lincoln | Washington | 53043 | 105 | 2 |
732035 | 732035 | 2020-11-14 | Lincoln | Washington | 53043 | 100 | 2 |
728790 | 728790 | 2020-11-13 | Lincoln | Washington | 53043 | 93 | 2 |
725547 | 725547 | 2020-11-12 | Lincoln | Washington | 53043 | 88 | 2 |
722304 | 722304 | 2020-11-11 | Lincoln | Washington | 53043 | 88 | 2 |
719061 | 719061 | 2020-11-10 | Lincoln | Washington | 53043 | 88 | 2 |
715818 | 715818 | 2020-11-09 | Lincoln | Washington | 53043 | 85 | 2 |
712574 | 712574 | 2020-11-08 | Lincoln | Washington | 53043 | 85 | 2 |
709330 | 709330 | 2020-11-07 | Lincoln | Washington | 53043 | 85 | 2 |
706086 | 706086 | 2020-11-06 | Lincoln | Washington | 53043 | 84 | 2 |
702843 | 702843 | 2020-11-05 | Lincoln | Washington | 53043 | 83 | 2 |
699600 | 699600 | 2020-11-04 | Lincoln | Washington | 53043 | 83 | 2 |
696356 | 696356 | 2020-11-03 | Lincoln | Washington | 53043 | 82 | 2 |
693114 | 693114 | 2020-11-02 | Lincoln | Washington | 53043 | 81 | 2 |
689870 | 689870 | 2020-11-01 | Lincoln | Washington | 53043 | 81 | 2 |
686625 | 686625 | 2020-10-31 | Lincoln | Washington | 53043 | 81 | 2 |
683382 | 683382 | 2020-10-30 | Lincoln | Washington | 53043 | 80 | 2 |
680139 | 680139 | 2020-10-29 | Lincoln | Washington | 53043 | 79 | 2 |
676896 | 676896 | 2020-10-28 | Lincoln | Washington | 53043 | 77 | 2 |
673653 | 673653 | 2020-10-27 | Lincoln | Washington | 53043 | 76 | 2 |
670411 | 670411 | 2020-10-26 | Lincoln | Washington | 53043 | 76 | 2 |
667168 | 667168 | 2020-10-25 | Lincoln | Washington | 53043 | 76 | 2 |
663923 | 663923 | 2020-10-24 | Lincoln | Washington | 53043 | 76 | 2 |
660679 | 660679 | 2020-10-23 | Lincoln | Washington | 53043 | 75 | 2 |
657435 | 657435 | 2020-10-22 | Lincoln | Washington | 53043 | 73 | 2 |
654190 | 654190 | 2020-10-21 | Lincoln | Washington | 53043 | 69 | 2 |
650945 | 650945 | 2020-10-20 | Lincoln | Washington | 53043 | 66 | 2 |
647701 | 647701 | 2020-10-19 | Lincoln | Washington | 53043 | 65 | 2 |
644455 | 644455 | 2020-10-18 | Lincoln | Washington | 53043 | 64 | 2 |
641207 | 641207 | 2020-10-17 | Lincoln | Washington | 53043 | 64 | 2 |
637960 | 637960 | 2020-10-16 | Lincoln | Washington | 53043 | 64 | 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);