ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where county = "Effingham", deaths = 3 and state = "Illinois" 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 |
---|---|---|---|---|---|---|---|
651737 | 651737 | 2020-10-21 | Effingham | Illinois | 17049 | 1103 | 3 |
648493 | 648493 | 2020-10-20 | Effingham | Illinois | 17049 | 1095 | 3 |
645248 | 645248 | 2020-10-19 | Effingham | Illinois | 17049 | 1090 | 3 |
642001 | 642001 | 2020-10-18 | Effingham | Illinois | 17049 | 1070 | 3 |
638754 | 638754 | 2020-10-17 | Effingham | Illinois | 17049 | 1057 | 3 |
635508 | 635508 | 2020-10-16 | Effingham | Illinois | 17049 | 1044 | 3 |
632262 | 632262 | 2020-10-15 | Effingham | Illinois | 17049 | 1028 | 3 |
629018 | 629018 | 2020-10-14 | Effingham | Illinois | 17049 | 1014 | 3 |
625775 | 625775 | 2020-10-13 | Effingham | Illinois | 17049 | 995 | 3 |
622533 | 622533 | 2020-10-12 | Effingham | Illinois | 17049 | 987 | 3 |
619289 | 619289 | 2020-10-11 | Effingham | Illinois | 17049 | 975 | 3 |
616047 | 616047 | 2020-10-10 | Effingham | Illinois | 17049 | 970 | 3 |
612806 | 612806 | 2020-10-09 | Effingham | Illinois | 17049 | 962 | 3 |
609564 | 609564 | 2020-10-08 | Effingham | Illinois | 17049 | 950 | 3 |
606321 | 606321 | 2020-10-07 | Effingham | Illinois | 17049 | 941 | 3 |
603079 | 603079 | 2020-10-06 | Effingham | Illinois | 17049 | 930 | 3 |
599836 | 599836 | 2020-10-05 | Effingham | Illinois | 17049 | 924 | 3 |
596594 | 596594 | 2020-10-04 | Effingham | Illinois | 17049 | 918 | 3 |
593352 | 593352 | 2020-10-03 | Effingham | Illinois | 17049 | 915 | 3 |
590111 | 590111 | 2020-10-02 | Effingham | Illinois | 17049 | 906 | 3 |
586870 | 586870 | 2020-10-01 | Effingham | Illinois | 17049 | 896 | 3 |
583630 | 583630 | 2020-09-30 | Effingham | Illinois | 17049 | 883 | 3 |
570665 | 570665 | 2020-09-26 | Effingham | Illinois | 17049 | 865 | 3 |
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);