ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Calhoun" and state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
33686 | 33686 | 2020-04-05 | Calhoun | Illinois | 17013 | 1 | 0 |
36137 | 36137 | 2020-04-06 | Calhoun | Illinois | 17013 | 1 | 0 |
38631 | 38631 | 2020-04-07 | Calhoun | Illinois | 17013 | 1 | 0 |
41175 | 41175 | 2020-04-08 | Calhoun | Illinois | 17013 | 1 | 0 |
43749 | 43749 | 2020-04-09 | Calhoun | Illinois | 17013 | 1 | 0 |
46351 | 46351 | 2020-04-10 | Calhoun | Illinois | 17013 | 1 | 0 |
48982 | 48982 | 2020-04-11 | Calhoun | Illinois | 17013 | 1 | 0 |
51644 | 51644 | 2020-04-12 | Calhoun | Illinois | 17013 | 1 | 0 |
54324 | 54324 | 2020-04-13 | Calhoun | Illinois | 17013 | 1 | 0 |
57016 | 57016 | 2020-04-14 | Calhoun | Illinois | 17013 | 1 | 0 |
59723 | 59723 | 2020-04-15 | Calhoun | Illinois | 17013 | 1 | 0 |
62444 | 62444 | 2020-04-16 | Calhoun | Illinois | 17013 | 1 | 0 |
65176 | 65176 | 2020-04-17 | Calhoun | Illinois | 17013 | 1 | 0 |
67924 | 67924 | 2020-04-18 | Calhoun | Illinois | 17013 | 1 | 0 |
70686 | 70686 | 2020-04-19 | Calhoun | Illinois | 17013 | 1 | 0 |
73455 | 73455 | 2020-04-20 | Calhoun | Illinois | 17013 | 1 | 0 |
76231 | 76231 | 2020-04-21 | Calhoun | Illinois | 17013 | 1 | 0 |
79015 | 79015 | 2020-04-22 | Calhoun | Illinois | 17013 | 1 | 0 |
81808 | 81808 | 2020-04-23 | Calhoun | Illinois | 17013 | 1 | 0 |
84608 | 84608 | 2020-04-24 | Calhoun | Illinois | 17013 | 1 | 0 |
87418 | 87418 | 2020-04-25 | Calhoun | Illinois | 17013 | 1 | 0 |
90234 | 90234 | 2020-04-26 | Calhoun | Illinois | 17013 | 1 | 0 |
93053 | 93053 | 2020-04-27 | Calhoun | Illinois | 17013 | 1 | 0 |
95885 | 95885 | 2020-04-28 | Calhoun | Illinois | 17013 | 1 | 0 |
98729 | 98729 | 2020-04-29 | Calhoun | Illinois | 17013 | 1 | 0 |
101580 | 101580 | 2020-04-30 | Calhoun | Illinois | 17013 | 1 | 0 |
104436 | 104436 | 2020-05-01 | Calhoun | Illinois | 17013 | 1 | 0 |
107301 | 107301 | 2020-05-02 | Calhoun | Illinois | 17013 | 1 | 0 |
110171 | 110171 | 2020-05-03 | Calhoun | Illinois | 17013 | 1 | 0 |
113046 | 113046 | 2020-05-04 | Calhoun | Illinois | 17013 | 1 | 0 |
115929 | 115929 | 2020-05-05 | Calhoun | Illinois | 17013 | 1 | 0 |
118889 | 118889 | 2020-05-06 | Calhoun | Illinois | 17013 | 1 | 0 |
121859 | 121859 | 2020-05-07 | Calhoun | Illinois | 17013 | 1 | 0 |
124838 | 124838 | 2020-05-08 | Calhoun | Illinois | 17013 | 1 | 0 |
127825 | 127825 | 2020-05-09 | Calhoun | Illinois | 17013 | 1 | 0 |
130816 | 130816 | 2020-05-10 | Calhoun | Illinois | 17013 | 1 | 0 |
133807 | 133807 | 2020-05-11 | Calhoun | Illinois | 17013 | 1 | 0 |
136796 | 136796 | 2020-05-12 | Calhoun | Illinois | 17013 | 1 | 0 |
139787 | 139787 | 2020-05-13 | Calhoun | Illinois | 17013 | 1 | 0 |
142783 | 142783 | 2020-05-14 | Calhoun | Illinois | 17013 | 1 | 0 |
145783 | 145783 | 2020-05-15 | Calhoun | Illinois | 17013 | 1 | 0 |
148786 | 148786 | 2020-05-16 | Calhoun | Illinois | 17013 | 1 | 0 |
151795 | 151795 | 2020-05-17 | Calhoun | Illinois | 17013 | 1 | 0 |
154807 | 154807 | 2020-05-18 | Calhoun | Illinois | 17013 | 1 | 0 |
157823 | 157823 | 2020-05-19 | Calhoun | Illinois | 17013 | 1 | 0 |
160849 | 160849 | 2020-05-20 | Calhoun | Illinois | 17013 | 1 | 0 |
163877 | 163877 | 2020-05-21 | Calhoun | Illinois | 17013 | 1 | 0 |
166910 | 166910 | 2020-05-22 | Calhoun | Illinois | 17013 | 1 | 0 |
169947 | 169947 | 2020-05-23 | Calhoun | Illinois | 17013 | 1 | 0 |
172988 | 172988 | 2020-05-24 | Calhoun | Illinois | 17013 | 1 | 0 |
176032 | 176032 | 2020-05-25 | Calhoun | Illinois | 17013 | 1 | 0 |
179076 | 179076 | 2020-05-26 | Calhoun | Illinois | 17013 | 1 | 0 |
182120 | 182120 | 2020-05-27 | Calhoun | Illinois | 17013 | 1 | 0 |
185174 | 185174 | 2020-05-28 | Calhoun | Illinois | 17013 | 1 | 0 |
188231 | 188231 | 2020-05-29 | Calhoun | Illinois | 17013 | 1 | 0 |
191296 | 191296 | 2020-05-30 | Calhoun | Illinois | 17013 | 1 | 0 |
194363 | 194363 | 2020-05-31 | Calhoun | Illinois | 17013 | 1 | 0 |
197433 | 197433 | 2020-06-01 | Calhoun | Illinois | 17013 | 1 | 0 |
200506 | 200506 | 2020-06-02 | Calhoun | Illinois | 17013 | 1 | 0 |
203582 | 203582 | 2020-06-03 | Calhoun | Illinois | 17013 | 1 | 0 |
206662 | 206662 | 2020-06-04 | Calhoun | Illinois | 17013 | 1 | 0 |
209743 | 209743 | 2020-06-05 | Calhoun | Illinois | 17013 | 1 | 0 |
212828 | 212828 | 2020-06-06 | Calhoun | Illinois | 17013 | 1 | 0 |
215915 | 215915 | 2020-06-07 | Calhoun | Illinois | 17013 | 1 | 0 |
219006 | 219006 | 2020-06-08 | Calhoun | Illinois | 17013 | 1 | 0 |
222101 | 222101 | 2020-06-09 | Calhoun | Illinois | 17013 | 1 | 0 |
225196 | 225196 | 2020-06-10 | Calhoun | Illinois | 17013 | 1 | 0 |
228298 | 228298 | 2020-06-11 | Calhoun | Illinois | 17013 | 1 | 0 |
231401 | 231401 | 2020-06-12 | Calhoun | Illinois | 17013 | 1 | 0 |
234507 | 234507 | 2020-06-13 | Calhoun | Illinois | 17013 | 1 | 0 |
237614 | 237614 | 2020-06-14 | Calhoun | Illinois | 17013 | 1 | 0 |
240722 | 240722 | 2020-06-15 | Calhoun | Illinois | 17013 | 1 | 0 |
243833 | 243833 | 2020-06-16 | Calhoun | Illinois | 17013 | 1 | 0 |
246946 | 246946 | 2020-06-17 | Calhoun | Illinois | 17013 | 1 | 0 |
250058 | 250058 | 2020-06-18 | Calhoun | Illinois | 17013 | 1 | 0 |
253173 | 253173 | 2020-06-19 | Calhoun | Illinois | 17013 | 1 | 0 |
256293 | 256293 | 2020-06-20 | Calhoun | Illinois | 17013 | 1 | 0 |
259419 | 259419 | 2020-06-21 | Calhoun | Illinois | 17013 | 1 | 0 |
262546 | 262546 | 2020-06-22 | Calhoun | Illinois | 17013 | 1 | 0 |
265674 | 265674 | 2020-06-23 | Calhoun | Illinois | 17013 | 1 | 0 |
268804 | 268804 | 2020-06-24 | Calhoun | Illinois | 17013 | 1 | 0 |
271941 | 271941 | 2020-06-25 | Calhoun | Illinois | 17013 | 1 | 0 |
275083 | 275083 | 2020-06-26 | Calhoun | Illinois | 17013 | 1 | 0 |
278231 | 278231 | 2020-06-27 | Calhoun | Illinois | 17013 | 1 | 0 |
281379 | 281379 | 2020-06-28 | Calhoun | Illinois | 17013 | 1 | 0 |
284524 | 284524 | 2020-06-29 | Calhoun | Illinois | 17013 | 1 | 0 |
287673 | 287673 | 2020-06-30 | Calhoun | Illinois | 17013 | 1 | 0 |
290823 | 290823 | 2020-07-01 | Calhoun | Illinois | 17013 | 1 | 0 |
293977 | 293977 | 2020-07-02 | Calhoun | Illinois | 17013 | 1 | 0 |
297134 | 297134 | 2020-07-03 | Calhoun | Illinois | 17013 | 1 | 0 |
300296 | 300296 | 2020-07-04 | Calhoun | Illinois | 17013 | 1 | 0 |
303460 | 303460 | 2020-07-05 | Calhoun | Illinois | 17013 | 1 | 0 |
306625 | 306625 | 2020-07-06 | Calhoun | Illinois | 17013 | 1 | 0 |
309793 | 309793 | 2020-07-07 | Calhoun | Illinois | 17013 | 1 | 0 |
312963 | 312963 | 2020-07-08 | Calhoun | Illinois | 17013 | 1 | 0 |
316137 | 316137 | 2020-07-09 | Calhoun | Illinois | 17013 | 1 | 0 |
319310 | 319310 | 2020-07-10 | Calhoun | Illinois | 17013 | 1 | 0 |
322489 | 322489 | 2020-07-11 | Calhoun | Illinois | 17013 | 1 | 0 |
325670 | 325670 | 2020-07-12 | Calhoun | Illinois | 17013 | 1 | 0 |
328856 | 328856 | 2020-07-13 | Calhoun | Illinois | 17013 | 2 | 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);