ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 71, county = "Jefferson" and fips = 53031 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 |
---|---|---|---|---|---|---|---|
592553 | 592553 | 2020-10-02 | Jefferson | Washington | 53031 | 71 | 0 |
589313 | 589313 | 2020-10-01 | Jefferson | Washington | 53031 | 71 | 0 |
586072 | 586072 | 2020-09-30 | Jefferson | Washington | 53031 | 71 | 0 |
582832 | 582832 | 2020-09-29 | Jefferson | Washington | 53031 | 71 | 0 |
579593 | 579593 | 2020-09-28 | Jefferson | Washington | 53031 | 71 | 0 |
576352 | 576352 | 2020-09-27 | Jefferson | Washington | 53031 | 71 | 0 |
573108 | 573108 | 2020-09-26 | Jefferson | Washington | 53031 | 71 | 0 |
569866 | 569866 | 2020-09-25 | Jefferson | Washington | 53031 | 71 | 0 |
566625 | 566625 | 2020-09-24 | Jefferson | Washington | 53031 | 71 | 0 |
563384 | 563384 | 2020-09-23 | Jefferson | Washington | 53031 | 71 | 0 |
560145 | 560145 | 2020-09-22 | Jefferson | Washington | 53031 | 71 | 0 |
556909 | 556909 | 2020-09-21 | Jefferson | Washington | 53031 | 71 | 0 |
553672 | 553672 | 2020-09-20 | Jefferson | Washington | 53031 | 71 | 0 |
550433 | 550433 | 2020-09-19 | Jefferson | Washington | 53031 | 71 | 0 |
543957 | 543957 | 2020-09-17 | Jefferson | Washington | 53031 | 71 | 0 |
540721 | 540721 | 2020-09-16 | Jefferson | Washington | 53031 | 71 | 0 |
537484 | 537484 | 2020-09-15 | Jefferson | Washington | 53031 | 71 | 0 |
534248 | 534248 | 2020-09-14 | Jefferson | Washington | 53031 | 71 | 0 |
531013 | 531013 | 2020-09-13 | Jefferson | Washington | 53031 | 71 | 0 |
527776 | 527776 | 2020-09-12 | Jefferson | Washington | 53031 | 71 | 0 |
514832 | 514832 | 2020-09-08 | Jefferson | Washington | 53031 | 71 | 0 |
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);