ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "McHenry" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386597 | 386597 | 2020-07-31 | McHenry | Illinois | 17111 | 2934 | 114 |
383379 | 383379 | 2020-07-30 | McHenry | Illinois | 17111 | 2898 | 113 |
380162 | 380162 | 2020-07-29 | McHenry | Illinois | 17111 | 2835 | 113 |
376945 | 376945 | 2020-07-28 | McHenry | Illinois | 17111 | 2797 | 113 |
373730 | 373730 | 2020-07-27 | McHenry | Illinois | 17111 | 2759 | 113 |
370518 | 370518 | 2020-07-26 | McHenry | Illinois | 17111 | 2694 | 111 |
367308 | 367308 | 2020-07-25 | McHenry | Illinois | 17111 | 2681 | 111 |
364101 | 364101 | 2020-07-24 | McHenry | Illinois | 17111 | 2681 | 111 |
360894 | 360894 | 2020-07-23 | McHenry | Illinois | 17111 | 2654 | 111 |
357689 | 357689 | 2020-07-22 | McHenry | Illinois | 17111 | 2608 | 110 |
354487 | 354487 | 2020-07-21 | McHenry | Illinois | 17111 | 2565 | 109 |
351285 | 351285 | 2020-07-20 | McHenry | Illinois | 17111 | 2538 | 108 |
348085 | 348085 | 2020-07-19 | McHenry | Illinois | 17111 | 2463 | 107 |
344884 | 344884 | 2020-07-18 | McHenry | Illinois | 17111 | 2446 | 107 |
341684 | 341684 | 2020-07-17 | McHenry | Illinois | 17111 | 2418 | 106 |
338488 | 338488 | 2020-07-16 | McHenry | Illinois | 17111 | 2418 | 105 |
335292 | 335292 | 2020-07-15 | McHenry | Illinois | 17111 | 2418 | 105 |
332099 | 332099 | 2020-07-14 | McHenry | Illinois | 17111 | 2381 | 105 |
328912 | 328912 | 2020-07-13 | McHenry | Illinois | 17111 | 2361 | 103 |
325726 | 325726 | 2020-07-12 | McHenry | Illinois | 17111 | 2303 | 103 |
322545 | 322545 | 2020-07-11 | McHenry | Illinois | 17111 | 2303 | 103 |
319366 | 319366 | 2020-07-10 | McHenry | Illinois | 17111 | 2296 | 103 |
316193 | 316193 | 2020-07-09 | McHenry | Illinois | 17111 | 2274 | 103 |
313019 | 313019 | 2020-07-08 | McHenry | Illinois | 17111 | 2246 | 103 |
309849 | 309849 | 2020-07-07 | McHenry | Illinois | 17111 | 2211 | 100 |
306681 | 306681 | 2020-07-06 | McHenry | Illinois | 17111 | 2196 | 99 |
303516 | 303516 | 2020-07-05 | McHenry | Illinois | 17111 | 2115 | 97 |
300352 | 300352 | 2020-07-04 | McHenry | Illinois | 17111 | 2103 | 97 |
297190 | 297190 | 2020-07-03 | McHenry | Illinois | 17111 | 2088 | 97 |
294033 | 294033 | 2020-07-02 | McHenry | Illinois | 17111 | 2074 | 97 |
290879 | 290879 | 2020-07-01 | McHenry | Illinois | 17111 | 2061 | 97 |
287729 | 287729 | 2020-06-30 | McHenry | Illinois | 17111 | 2032 | 97 |
284580 | 284580 | 2020-06-29 | McHenry | Illinois | 17111 | 2010 | 97 |
281435 | 281435 | 2020-06-28 | McHenry | Illinois | 17111 | 1999 | 97 |
278287 | 278287 | 2020-06-27 | McHenry | Illinois | 17111 | 1991 | 97 |
275139 | 275139 | 2020-06-26 | McHenry | Illinois | 17111 | 1975 | 96 |
271997 | 271997 | 2020-06-25 | McHenry | Illinois | 17111 | 1949 | 95 |
268860 | 268860 | 2020-06-24 | McHenry | Illinois | 17111 | 1937 | 93 |
265730 | 265730 | 2020-06-23 | McHenry | Illinois | 17111 | 1922 | 92 |
262602 | 262602 | 2020-06-22 | McHenry | Illinois | 17111 | 1921 | 91 |
259475 | 259475 | 2020-06-21 | McHenry | Illinois | 17111 | 1911 | 91 |
256349 | 256349 | 2020-06-20 | McHenry | Illinois | 17111 | 1898 | 91 |
253229 | 253229 | 2020-06-19 | McHenry | Illinois | 17111 | 1891 | 89 |
250114 | 250114 | 2020-06-18 | McHenry | Illinois | 17111 | 1884 | 89 |
247002 | 247002 | 2020-06-17 | McHenry | Illinois | 17111 | 1872 | 88 |
243889 | 243889 | 2020-06-16 | McHenry | Illinois | 17111 | 1864 | 86 |
240778 | 240778 | 2020-06-15 | McHenry | Illinois | 17111 | 1856 | 85 |
237670 | 237670 | 2020-06-14 | McHenry | Illinois | 17111 | 1849 | 85 |
234563 | 234563 | 2020-06-13 | McHenry | Illinois | 17111 | 1829 | 85 |
231457 | 231457 | 2020-06-12 | McHenry | Illinois | 17111 | 1810 | 85 |
228354 | 228354 | 2020-06-11 | McHenry | Illinois | 17111 | 1788 | 84 |
225252 | 225252 | 2020-06-10 | McHenry | Illinois | 17111 | 1776 | 84 |
222157 | 222157 | 2020-06-09 | McHenry | Illinois | 17111 | 1752 | 84 |
219062 | 219062 | 2020-06-08 | McHenry | Illinois | 17111 | 1744 | 83 |
215971 | 215971 | 2020-06-07 | McHenry | Illinois | 17111 | 1724 | 83 |
212884 | 212884 | 2020-06-06 | McHenry | Illinois | 17111 | 1718 | 83 |
209799 | 209799 | 2020-06-05 | McHenry | Illinois | 17111 | 1692 | 82 |
206718 | 206718 | 2020-06-04 | McHenry | Illinois | 17111 | 1672 | 78 |
203638 | 203638 | 2020-06-03 | McHenry | Illinois | 17111 | 1659 | 78 |
200562 | 200562 | 2020-06-02 | McHenry | Illinois | 17111 | 1636 | 74 |
197489 | 197489 | 2020-06-01 | McHenry | Illinois | 17111 | 1608 | 73 |
194419 | 194419 | 2020-05-31 | McHenry | Illinois | 17111 | 1566 | 73 |
191352 | 191352 | 2020-05-30 | McHenry | Illinois | 17111 | 1566 | 73 |
188287 | 188287 | 2020-05-29 | McHenry | Illinois | 17111 | 1514 | 71 |
185229 | 185229 | 2020-05-28 | McHenry | Illinois | 17111 | 1488 | 70 |
182175 | 182175 | 2020-05-27 | McHenry | Illinois | 17111 | 1475 | 69 |
179131 | 179131 | 2020-05-26 | McHenry | Illinois | 17111 | 1452 | 68 |
176087 | 176087 | 2020-05-25 | McHenry | Illinois | 17111 | 1427 | 67 |
173043 | 173043 | 2020-05-24 | McHenry | Illinois | 17111 | 1399 | 67 |
170002 | 170002 | 2020-05-23 | McHenry | Illinois | 17111 | 1360 | 67 |
166965 | 166965 | 2020-05-22 | McHenry | Illinois | 17111 | 1323 | 67 |
163932 | 163932 | 2020-05-21 | McHenry | Illinois | 17111 | 1282 | 67 |
160904 | 160904 | 2020-05-20 | McHenry | Illinois | 17111 | 1255 | 66 |
157878 | 157878 | 2020-05-19 | McHenry | Illinois | 17111 | 1224 | 64 |
154862 | 154862 | 2020-05-18 | McHenry | Illinois | 17111 | 1209 | 62 |
151850 | 151850 | 2020-05-17 | McHenry | Illinois | 17111 | 1179 | 62 |
148841 | 148841 | 2020-05-16 | McHenry | Illinois | 17111 | 1156 | 62 |
145838 | 145838 | 2020-05-15 | McHenry | Illinois | 17111 | 1123 | 62 |
142838 | 142838 | 2020-05-14 | McHenry | Illinois | 17111 | 1083 | 57 |
139842 | 139842 | 2020-05-13 | McHenry | Illinois | 17111 | 1049 | 56 |
136850 | 136850 | 2020-05-12 | McHenry | Illinois | 17111 | 1026 | 55 |
133861 | 133861 | 2020-05-11 | McHenry | Illinois | 17111 | 958 | 52 |
130870 | 130870 | 2020-05-10 | McHenry | Illinois | 17111 | 945 | 51 |
127879 | 127879 | 2020-05-09 | McHenry | Illinois | 17111 | 936 | 52 |
124892 | 124892 | 2020-05-08 | McHenry | Illinois | 17111 | 897 | 48 |
121913 | 121913 | 2020-05-07 | McHenry | Illinois | 17111 | 857 | 44 |
118943 | 118943 | 2020-05-06 | McHenry | Illinois | 17111 | 814 | 42 |
115983 | 115983 | 2020-05-05 | McHenry | Illinois | 17111 | 802 | 40 |
113100 | 113100 | 2020-05-04 | McHenry | Illinois | 17111 | 790 | 38 |
110225 | 110225 | 2020-05-03 | McHenry | Illinois | 17111 | 738 | 37 |
107355 | 107355 | 2020-05-02 | McHenry | Illinois | 17111 | 693 | 38 |
104490 | 104490 | 2020-05-01 | McHenry | Illinois | 17111 | 666 | 37 |
101634 | 101634 | 2020-04-30 | McHenry | Illinois | 17111 | 621 | 34 |
98783 | 98783 | 2020-04-29 | McHenry | Illinois | 17111 | 588 | 33 |
95939 | 95939 | 2020-04-28 | McHenry | Illinois | 17111 | 552 | 31 |
93107 | 93107 | 2020-04-27 | McHenry | Illinois | 17111 | 538 | 28 |
90288 | 90288 | 2020-04-26 | McHenry | Illinois | 17111 | 513 | 28 |
87472 | 87472 | 2020-04-25 | McHenry | Illinois | 17111 | 502 | 28 |
84662 | 84662 | 2020-04-24 | McHenry | Illinois | 17111 | 459 | 27 |
81862 | 81862 | 2020-04-23 | McHenry | Illinois | 17111 | 419 | 26 |
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);