ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 1, fips = 17175 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 |
---|---|---|---|---|---|---|---|
151874 | 151874 | 2020-05-17 | Stark | Illinois | 17175 | 1 | 0 |
148865 | 148865 | 2020-05-16 | Stark | Illinois | 17175 | 1 | 0 |
145861 | 145861 | 2020-05-15 | Stark | Illinois | 17175 | 1 | 0 |
142861 | 142861 | 2020-05-14 | Stark | Illinois | 17175 | 1 | 0 |
139865 | 139865 | 2020-05-13 | Stark | Illinois | 17175 | 1 | 0 |
136873 | 136873 | 2020-05-12 | Stark | Illinois | 17175 | 1 | 0 |
133884 | 133884 | 2020-05-11 | Stark | Illinois | 17175 | 1 | 0 |
130893 | 130893 | 2020-05-10 | Stark | Illinois | 17175 | 1 | 0 |
127902 | 127902 | 2020-05-09 | Stark | Illinois | 17175 | 1 | 0 |
124915 | 124915 | 2020-05-08 | Stark | Illinois | 17175 | 1 | 0 |
121935 | 121935 | 2020-05-07 | Stark | Illinois | 17175 | 1 | 0 |
118965 | 118965 | 2020-05-06 | Stark | Illinois | 17175 | 1 | 0 |
116005 | 116005 | 2020-05-05 | Stark | Illinois | 17175 | 1 | 0 |
113122 | 113122 | 2020-05-04 | Stark | Illinois | 17175 | 1 | 0 |
110247 | 110247 | 2020-05-03 | Stark | Illinois | 17175 | 1 | 0 |
107377 | 107377 | 2020-05-02 | Stark | Illinois | 17175 | 1 | 0 |
104512 | 104512 | 2020-05-01 | Stark | Illinois | 17175 | 1 | 0 |
101656 | 101656 | 2020-04-30 | Stark | Illinois | 17175 | 1 | 0 |
98805 | 98805 | 2020-04-29 | Stark | Illinois | 17175 | 1 | 0 |
95961 | 95961 | 2020-04-28 | Stark | Illinois | 17175 | 1 | 0 |
93129 | 93129 | 2020-04-27 | Stark | Illinois | 17175 | 1 | 0 |
90310 | 90310 | 2020-04-26 | Stark | Illinois | 17175 | 1 | 0 |
87494 | 87494 | 2020-04-25 | Stark | Illinois | 17175 | 1 | 0 |
84684 | 84684 | 2020-04-24 | Stark | Illinois | 17175 | 1 | 0 |
81884 | 81884 | 2020-04-23 | Stark | Illinois | 17175 | 1 | 0 |
79091 | 79091 | 2020-04-22 | Stark | Illinois | 17175 | 1 | 0 |
76307 | 76307 | 2020-04-21 | Stark | Illinois | 17175 | 1 | 0 |
73530 | 73530 | 2020-04-20 | Stark | Illinois | 17175 | 1 | 0 |
70760 | 70760 | 2020-04-19 | Stark | Illinois | 17175 | 1 | 0 |
67998 | 67998 | 2020-04-18 | Stark | Illinois | 17175 | 1 | 0 |
65249 | 65249 | 2020-04-17 | Stark | Illinois | 17175 | 1 | 0 |
62516 | 62516 | 2020-04-16 | Stark | Illinois | 17175 | 1 | 0 |
59795 | 59795 | 2020-04-15 | Stark | Illinois | 17175 | 1 | 0 |
57088 | 57088 | 2020-04-14 | Stark | Illinois | 17175 | 1 | 0 |
54395 | 54395 | 2020-04-13 | Stark | Illinois | 17175 | 1 | 0 |
51714 | 51714 | 2020-04-12 | Stark | Illinois | 17175 | 1 | 0 |
49052 | 49052 | 2020-04-11 | Stark | Illinois | 17175 | 1 | 0 |
46419 | 46419 | 2020-04-10 | Stark | Illinois | 17175 | 1 | 0 |
43815 | 43815 | 2020-04-09 | Stark | Illinois | 17175 | 1 | 0 |
41239 | 41239 | 2020-04-08 | Stark | Illinois | 17175 | 1 | 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);