ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Johnson" and state = "Illinois" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
54354 | 54354 | 2020-04-13 | Johnson | Illinois | 17087 | 1 | 0 |
57047 | 57047 | 2020-04-14 | Johnson | Illinois | 17087 | 1 | 0 |
59754 | 59754 | 2020-04-15 | Johnson | Illinois | 17087 | 2 | 0 |
62475 | 62475 | 2020-04-16 | Johnson | Illinois | 17087 | 2 | 0 |
65208 | 65208 | 2020-04-17 | Johnson | Illinois | 17087 | 2 | 0 |
67957 | 67957 | 2020-04-18 | Johnson | Illinois | 17087 | 2 | 0 |
70719 | 70719 | 2020-04-19 | Johnson | Illinois | 17087 | 2 | 0 |
73489 | 73489 | 2020-04-20 | Johnson | Illinois | 17087 | 2 | 0 |
76266 | 76266 | 2020-04-21 | Johnson | Illinois | 17087 | 2 | 0 |
79050 | 79050 | 2020-04-22 | Johnson | Illinois | 17087 | 3 | 0 |
81843 | 81843 | 2020-04-23 | Johnson | Illinois | 17087 | 3 | 0 |
84643 | 84643 | 2020-04-24 | Johnson | Illinois | 17087 | 3 | 0 |
87453 | 87453 | 2020-04-25 | Johnson | Illinois | 17087 | 3 | 0 |
90269 | 90269 | 2020-04-26 | Johnson | Illinois | 17087 | 4 | 0 |
93088 | 93088 | 2020-04-27 | Johnson | Illinois | 17087 | 4 | 0 |
95920 | 95920 | 2020-04-28 | Johnson | Illinois | 17087 | 4 | 0 |
98764 | 98764 | 2020-04-29 | Johnson | Illinois | 17087 | 4 | 0 |
101615 | 101615 | 2020-04-30 | Johnson | Illinois | 17087 | 4 | 0 |
104471 | 104471 | 2020-05-01 | Johnson | Illinois | 17087 | 4 | 0 |
107336 | 107336 | 2020-05-02 | Johnson | Illinois | 17087 | 4 | 0 |
110206 | 110206 | 2020-05-03 | Johnson | Illinois | 17087 | 4 | 0 |
113081 | 113081 | 2020-05-04 | Johnson | Illinois | 17087 | 4 | 0 |
115964 | 115964 | 2020-05-05 | Johnson | Illinois | 17087 | 4 | 0 |
118924 | 118924 | 2020-05-06 | Johnson | Illinois | 17087 | 4 | 0 |
121894 | 121894 | 2020-05-07 | Johnson | Illinois | 17087 | 4 | 0 |
124873 | 124873 | 2020-05-08 | Johnson | Illinois | 17087 | 4 | 0 |
127860 | 127860 | 2020-05-09 | Johnson | Illinois | 17087 | 4 | 0 |
130851 | 130851 | 2020-05-10 | Johnson | Illinois | 17087 | 4 | 0 |
133842 | 133842 | 2020-05-11 | Johnson | Illinois | 17087 | 4 | 0 |
136831 | 136831 | 2020-05-12 | Johnson | Illinois | 17087 | 4 | 0 |
139823 | 139823 | 2020-05-13 | Johnson | Illinois | 17087 | 6 | 0 |
142819 | 142819 | 2020-05-14 | Johnson | Illinois | 17087 | 6 | 0 |
145819 | 145819 | 2020-05-15 | Johnson | Illinois | 17087 | 7 | 0 |
148822 | 148822 | 2020-05-16 | Johnson | Illinois | 17087 | 7 | 0 |
151831 | 151831 | 2020-05-17 | Johnson | Illinois | 17087 | 7 | 0 |
154843 | 154843 | 2020-05-18 | Johnson | Illinois | 17087 | 7 | 0 |
157859 | 157859 | 2020-05-19 | Johnson | Illinois | 17087 | 7 | 0 |
160885 | 160885 | 2020-05-20 | Johnson | Illinois | 17087 | 7 | 0 |
163913 | 163913 | 2020-05-21 | Johnson | Illinois | 17087 | 7 | 0 |
166946 | 166946 | 2020-05-22 | Johnson | Illinois | 17087 | 7 | 0 |
169983 | 169983 | 2020-05-23 | Johnson | Illinois | 17087 | 7 | 0 |
173024 | 173024 | 2020-05-24 | Johnson | Illinois | 17087 | 7 | 0 |
176068 | 176068 | 2020-05-25 | Johnson | Illinois | 17087 | 7 | 0 |
179112 | 179112 | 2020-05-26 | Johnson | Illinois | 17087 | 7 | 0 |
182156 | 182156 | 2020-05-27 | Johnson | Illinois | 17087 | 7 | 0 |
185210 | 185210 | 2020-05-28 | Johnson | Illinois | 17087 | 7 | 0 |
188268 | 188268 | 2020-05-29 | Johnson | Illinois | 17087 | 7 | 0 |
191333 | 191333 | 2020-05-30 | Johnson | Illinois | 17087 | 8 | 0 |
194400 | 194400 | 2020-05-31 | Johnson | Illinois | 17087 | 8 | 0 |
197470 | 197470 | 2020-06-01 | Johnson | Illinois | 17087 | 9 | 0 |
200543 | 200543 | 2020-06-02 | Johnson | Illinois | 17087 | 9 | 0 |
203619 | 203619 | 2020-06-03 | Johnson | Illinois | 17087 | 10 | 0 |
206699 | 206699 | 2020-06-04 | Johnson | Illinois | 17087 | 11 | 0 |
209780 | 209780 | 2020-06-05 | Johnson | Illinois | 17087 | 11 | 0 |
212865 | 212865 | 2020-06-06 | Johnson | Illinois | 17087 | 12 | 0 |
215952 | 215952 | 2020-06-07 | Johnson | Illinois | 17087 | 12 | 0 |
219043 | 219043 | 2020-06-08 | Johnson | Illinois | 17087 | 12 | 0 |
222138 | 222138 | 2020-06-09 | Johnson | Illinois | 17087 | 13 | 0 |
225233 | 225233 | 2020-06-10 | Johnson | Illinois | 17087 | 13 | 0 |
228335 | 228335 | 2020-06-11 | Johnson | Illinois | 17087 | 14 | 0 |
231438 | 231438 | 2020-06-12 | Johnson | Illinois | 17087 | 14 | 0 |
234544 | 234544 | 2020-06-13 | Johnson | Illinois | 17087 | 19 | 0 |
237651 | 237651 | 2020-06-14 | Johnson | Illinois | 17087 | 19 | 0 |
240759 | 240759 | 2020-06-15 | Johnson | Illinois | 17087 | 19 | 0 |
243870 | 243870 | 2020-06-16 | Johnson | Illinois | 17087 | 19 | 0 |
246983 | 246983 | 2020-06-17 | Johnson | Illinois | 17087 | 20 | 0 |
250095 | 250095 | 2020-06-18 | Johnson | Illinois | 17087 | 20 | 0 |
253210 | 253210 | 2020-06-19 | Johnson | Illinois | 17087 | 20 | 0 |
256330 | 256330 | 2020-06-20 | Johnson | Illinois | 17087 | 20 | 0 |
259456 | 259456 | 2020-06-21 | Johnson | Illinois | 17087 | 20 | 0 |
262583 | 262583 | 2020-06-22 | Johnson | Illinois | 17087 | 20 | 0 |
265711 | 265711 | 2020-06-23 | Johnson | Illinois | 17087 | 20 | 0 |
268841 | 268841 | 2020-06-24 | Johnson | Illinois | 17087 | 20 | 0 |
271978 | 271978 | 2020-06-25 | Johnson | Illinois | 17087 | 20 | 0 |
275120 | 275120 | 2020-06-26 | Johnson | Illinois | 17087 | 20 | 0 |
278268 | 278268 | 2020-06-27 | Johnson | Illinois | 17087 | 20 | 0 |
281416 | 281416 | 2020-06-28 | Johnson | Illinois | 17087 | 20 | 0 |
284561 | 284561 | 2020-06-29 | Johnson | Illinois | 17087 | 20 | 0 |
287710 | 287710 | 2020-06-30 | Johnson | Illinois | 17087 | 20 | 0 |
290860 | 290860 | 2020-07-01 | Johnson | Illinois | 17087 | 20 | 0 |
294014 | 294014 | 2020-07-02 | Johnson | Illinois | 17087 | 21 | 0 |
297171 | 297171 | 2020-07-03 | Johnson | Illinois | 17087 | 21 | 0 |
300333 | 300333 | 2020-07-04 | Johnson | Illinois | 17087 | 21 | 0 |
303497 | 303497 | 2020-07-05 | Johnson | Illinois | 17087 | 21 | 0 |
306662 | 306662 | 2020-07-06 | Johnson | Illinois | 17087 | 20 | 0 |
309830 | 309830 | 2020-07-07 | Johnson | Illinois | 17087 | 20 | 0 |
313000 | 313000 | 2020-07-08 | Johnson | Illinois | 17087 | 21 | 0 |
316174 | 316174 | 2020-07-09 | Johnson | Illinois | 17087 | 23 | 0 |
319347 | 319347 | 2020-07-10 | Johnson | Illinois | 17087 | 24 | 0 |
322526 | 322526 | 2020-07-11 | Johnson | Illinois | 17087 | 27 | 0 |
325707 | 325707 | 2020-07-12 | Johnson | Illinois | 17087 | 26 | 0 |
328893 | 328893 | 2020-07-13 | Johnson | Illinois | 17087 | 28 | 0 |
332080 | 332080 | 2020-07-14 | Johnson | Illinois | 17087 | 28 | 0 |
335273 | 335273 | 2020-07-15 | Johnson | Illinois | 17087 | 29 | 0 |
338469 | 338469 | 2020-07-16 | Johnson | Illinois | 17087 | 36 | 0 |
341665 | 341665 | 2020-07-17 | Johnson | Illinois | 17087 | 37 | 0 |
344865 | 344865 | 2020-07-18 | Johnson | Illinois | 17087 | 36 | 0 |
348066 | 348066 | 2020-07-19 | Johnson | Illinois | 17087 | 38 | 0 |
351266 | 351266 | 2020-07-20 | Johnson | Illinois | 17087 | 42 | 0 |
354468 | 354468 | 2020-07-21 | Johnson | Illinois | 17087 | 42 | 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);