ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Clay" and state = "Illinois" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
57021 | 57021 | 2020-04-14 | Clay | Illinois | 17025 | 1 | 0 |
59728 | 59728 | 2020-04-15 | Clay | Illinois | 17025 | 1 | 0 |
62449 | 62449 | 2020-04-16 | Clay | Illinois | 17025 | 1 | 0 |
65181 | 65181 | 2020-04-17 | Clay | Illinois | 17025 | 1 | 0 |
67929 | 67929 | 2020-04-18 | Clay | Illinois | 17025 | 1 | 0 |
70691 | 70691 | 2020-04-19 | Clay | Illinois | 17025 | 1 | 0 |
73461 | 73461 | 2020-04-20 | Clay | Illinois | 17025 | 1 | 0 |
76237 | 76237 | 2020-04-21 | Clay | Illinois | 17025 | 1 | 0 |
79021 | 79021 | 2020-04-22 | Clay | Illinois | 17025 | 2 | 0 |
81814 | 81814 | 2020-04-23 | Clay | Illinois | 17025 | 2 | 0 |
84614 | 84614 | 2020-04-24 | Clay | Illinois | 17025 | 2 | 0 |
87424 | 87424 | 2020-04-25 | Clay | Illinois | 17025 | 2 | 0 |
90240 | 90240 | 2020-04-26 | Clay | Illinois | 17025 | 2 | 0 |
93059 | 93059 | 2020-04-27 | Clay | Illinois | 17025 | 2 | 0 |
95891 | 95891 | 2020-04-28 | Clay | Illinois | 17025 | 2 | 0 |
98735 | 98735 | 2020-04-29 | Clay | Illinois | 17025 | 2 | 0 |
101586 | 101586 | 2020-04-30 | Clay | Illinois | 17025 | 2 | 0 |
104442 | 104442 | 2020-05-01 | Clay | Illinois | 17025 | 2 | 0 |
107307 | 107307 | 2020-05-02 | Clay | Illinois | 17025 | 2 | 0 |
110177 | 110177 | 2020-05-03 | Clay | Illinois | 17025 | 2 | 0 |
113052 | 113052 | 2020-05-04 | Clay | Illinois | 17025 | 2 | 0 |
115935 | 115935 | 2020-05-05 | Clay | Illinois | 17025 | 2 | 0 |
118895 | 118895 | 2020-05-06 | Clay | Illinois | 17025 | 2 | 0 |
121865 | 121865 | 2020-05-07 | Clay | Illinois | 17025 | 2 | 0 |
124844 | 124844 | 2020-05-08 | Clay | Illinois | 17025 | 2 | 0 |
127831 | 127831 | 2020-05-09 | Clay | Illinois | 17025 | 2 | 0 |
130822 | 130822 | 2020-05-10 | Clay | Illinois | 17025 | 2 | 0 |
133813 | 133813 | 2020-05-11 | Clay | Illinois | 17025 | 2 | 0 |
136802 | 136802 | 2020-05-12 | Clay | Illinois | 17025 | 2 | 0 |
139793 | 139793 | 2020-05-13 | Clay | Illinois | 17025 | 2 | 0 |
142789 | 142789 | 2020-05-14 | Clay | Illinois | 17025 | 2 | 0 |
145789 | 145789 | 2020-05-15 | Clay | Illinois | 17025 | 2 | 0 |
148792 | 148792 | 2020-05-16 | Clay | Illinois | 17025 | 2 | 0 |
151801 | 151801 | 2020-05-17 | Clay | Illinois | 17025 | 2 | 0 |
154813 | 154813 | 2020-05-18 | Clay | Illinois | 17025 | 2 | 0 |
157829 | 157829 | 2020-05-19 | Clay | Illinois | 17025 | 3 | 0 |
160855 | 160855 | 2020-05-20 | Clay | Illinois | 17025 | 2 | 0 |
163883 | 163883 | 2020-05-21 | Clay | Illinois | 17025 | 2 | 0 |
166916 | 166916 | 2020-05-22 | Clay | Illinois | 17025 | 2 | 0 |
169953 | 169953 | 2020-05-23 | Clay | Illinois | 17025 | 2 | 0 |
172994 | 172994 | 2020-05-24 | Clay | Illinois | 17025 | 2 | 0 |
176038 | 176038 | 2020-05-25 | Clay | Illinois | 17025 | 2 | 0 |
179082 | 179082 | 2020-05-26 | Clay | Illinois | 17025 | 2 | 0 |
182126 | 182126 | 2020-05-27 | Clay | Illinois | 17025 | 2 | 0 |
185180 | 185180 | 2020-05-28 | Clay | Illinois | 17025 | 2 | 0 |
188237 | 188237 | 2020-05-29 | Clay | Illinois | 17025 | 2 | 0 |
191302 | 191302 | 2020-05-30 | Clay | Illinois | 17025 | 2 | 0 |
194369 | 194369 | 2020-05-31 | Clay | Illinois | 17025 | 2 | 0 |
197439 | 197439 | 2020-06-01 | Clay | Illinois | 17025 | 2 | 0 |
200512 | 200512 | 2020-06-02 | Clay | Illinois | 17025 | 2 | 0 |
203588 | 203588 | 2020-06-03 | Clay | Illinois | 17025 | 2 | 0 |
206668 | 206668 | 2020-06-04 | Clay | Illinois | 17025 | 2 | 0 |
209749 | 209749 | 2020-06-05 | Clay | Illinois | 17025 | 2 | 0 |
212834 | 212834 | 2020-06-06 | Clay | Illinois | 17025 | 2 | 0 |
215921 | 215921 | 2020-06-07 | Clay | Illinois | 17025 | 2 | 0 |
219012 | 219012 | 2020-06-08 | Clay | Illinois | 17025 | 2 | 0 |
222107 | 222107 | 2020-06-09 | Clay | Illinois | 17025 | 2 | 0 |
225202 | 225202 | 2020-06-10 | Clay | Illinois | 17025 | 2 | 0 |
228304 | 228304 | 2020-06-11 | Clay | Illinois | 17025 | 2 | 0 |
231407 | 231407 | 2020-06-12 | Clay | Illinois | 17025 | 2 | 0 |
234513 | 234513 | 2020-06-13 | Clay | Illinois | 17025 | 2 | 0 |
237620 | 237620 | 2020-06-14 | Clay | Illinois | 17025 | 2 | 0 |
240728 | 240728 | 2020-06-15 | Clay | Illinois | 17025 | 2 | 0 |
243839 | 243839 | 2020-06-16 | Clay | Illinois | 17025 | 2 | 0 |
246952 | 246952 | 2020-06-17 | Clay | Illinois | 17025 | 2 | 0 |
250064 | 250064 | 2020-06-18 | Clay | Illinois | 17025 | 3 | 0 |
253179 | 253179 | 2020-06-19 | Clay | Illinois | 17025 | 2 | 0 |
256299 | 256299 | 2020-06-20 | Clay | Illinois | 17025 | 2 | 0 |
259425 | 259425 | 2020-06-21 | Clay | Illinois | 17025 | 2 | 0 |
262552 | 262552 | 2020-06-22 | Clay | Illinois | 17025 | 2 | 0 |
265680 | 265680 | 2020-06-23 | Clay | Illinois | 17025 | 2 | 0 |
268810 | 268810 | 2020-06-24 | Clay | Illinois | 17025 | 2 | 0 |
271947 | 271947 | 2020-06-25 | Clay | Illinois | 17025 | 2 | 0 |
275089 | 275089 | 2020-06-26 | Clay | Illinois | 17025 | 2 | 0 |
278237 | 278237 | 2020-06-27 | Clay | Illinois | 17025 | 2 | 0 |
281385 | 281385 | 2020-06-28 | Clay | Illinois | 17025 | 2 | 0 |
284530 | 284530 | 2020-06-29 | Clay | Illinois | 17025 | 2 | 0 |
287679 | 287679 | 2020-06-30 | Clay | Illinois | 17025 | 2 | 0 |
290829 | 290829 | 2020-07-01 | Clay | Illinois | 17025 | 2 | 0 |
293983 | 293983 | 2020-07-02 | Clay | Illinois | 17025 | 2 | 0 |
297140 | 297140 | 2020-07-03 | Clay | Illinois | 17025 | 2 | 0 |
300302 | 300302 | 2020-07-04 | Clay | Illinois | 17025 | 2 | 0 |
303466 | 303466 | 2020-07-05 | Clay | Illinois | 17025 | 2 | 0 |
306631 | 306631 | 2020-07-06 | Clay | Illinois | 17025 | 2 | 0 |
309799 | 309799 | 2020-07-07 | Clay | Illinois | 17025 | 2 | 0 |
312969 | 312969 | 2020-07-08 | Clay | Illinois | 17025 | 2 | 0 |
316143 | 316143 | 2020-07-09 | Clay | Illinois | 17025 | 2 | 0 |
319316 | 319316 | 2020-07-10 | Clay | Illinois | 17025 | 2 | 0 |
322495 | 322495 | 2020-07-11 | Clay | Illinois | 17025 | 5 | 0 |
325676 | 325676 | 2020-07-12 | Clay | Illinois | 17025 | 5 | 0 |
328862 | 328862 | 2020-07-13 | Clay | Illinois | 17025 | 8 | 0 |
332049 | 332049 | 2020-07-14 | Clay | Illinois | 17025 | 8 | 0 |
335242 | 335242 | 2020-07-15 | Clay | Illinois | 17025 | 8 | 0 |
338438 | 338438 | 2020-07-16 | Clay | Illinois | 17025 | 8 | 0 |
341634 | 341634 | 2020-07-17 | Clay | Illinois | 17025 | 8 | 0 |
344834 | 344834 | 2020-07-18 | Clay | Illinois | 17025 | 8 | 0 |
348035 | 348035 | 2020-07-19 | Clay | Illinois | 17025 | 8 | 0 |
351235 | 351235 | 2020-07-20 | Clay | Illinois | 17025 | 8 | 0 |
354437 | 354437 | 2020-07-21 | Clay | Illinois | 17025 | 9 | 0 |
357639 | 357639 | 2020-07-22 | Clay | Illinois | 17025 | 9 | 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);