ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
841 rows where county = "Cook", fips = 17031 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281388 | 281388 | 2020-06-28 | Cook | Illinois | 17031 | 89755 | 4542 |
278240 | 278240 | 2020-06-27 | Cook | Illinois | 17031 | 89407 | 4536 |
275092 | 275092 | 2020-06-26 | Cook | Illinois | 17031 | 89068 | 4526 |
271950 | 271950 | 2020-06-25 | Cook | Illinois | 17031 | 88650 | 4500 |
268813 | 268813 | 2020-06-24 | Cook | Illinois | 17031 | 88138 | 4478 |
265683 | 265683 | 2020-06-23 | Cook | Illinois | 17031 | 87784 | 4439 |
262555 | 262555 | 2020-06-22 | Cook | Illinois | 17031 | 87424 | 4423 |
259428 | 259428 | 2020-06-21 | Cook | Illinois | 17031 | 87177 | 4404 |
256302 | 256302 | 2020-06-20 | Cook | Illinois | 17031 | 86885 | 4390 |
253182 | 253182 | 2020-06-19 | Cook | Illinois | 17031 | 86551 | 4363 |
250067 | 250067 | 2020-06-18 | Cook | Illinois | 17031 | 86179 | 4333 |
246955 | 246955 | 2020-06-17 | Cook | Illinois | 17031 | 85858 | 4304 |
243842 | 243842 | 2020-06-16 | Cook | Illinois | 17031 | 85538 | 4253 |
240731 | 240731 | 2020-06-15 | Cook | Illinois | 17031 | 85184 | 4206 |
237623 | 237623 | 2020-06-14 | Cook | Illinois | 17031 | 84906 | 4189 |
234516 | 234516 | 2020-06-13 | Cook | Illinois | 17031 | 84581 | 4173 |
231410 | 231410 | 2020-06-12 | Cook | Illinois | 17031 | 84249 | 4162 |
228307 | 228307 | 2020-06-11 | Cook | Illinois | 17031 | 83978 | 4111 |
225205 | 225205 | 2020-06-10 | Cook | Illinois | 17031 | 83585 | 4053 |
222110 | 222110 | 2020-06-09 | Cook | Illinois | 17031 | 83271 | 4010 |
219015 | 219015 | 2020-06-08 | Cook | Illinois | 17031 | 82819 | 3959 |
215924 | 215924 | 2020-06-07 | Cook | Illinois | 17031 | 82427 | 3944 |
212837 | 212837 | 2020-06-06 | Cook | Illinois | 17031 | 81924 | 3913 |
209752 | 209752 | 2020-06-05 | Cook | Illinois | 17031 | 81344 | 3880 |
206671 | 206671 | 2020-06-04 | Cook | Illinois | 17031 | 80713 | 3846 |
203591 | 203591 | 2020-06-03 | Cook | Illinois | 17031 | 80204 | 3780 |
200515 | 200515 | 2020-06-02 | Cook | Illinois | 17031 | 79673 | 3726 |
197442 | 197442 | 2020-06-01 | Cook | Illinois | 17031 | 78495 | 3658 |
194372 | 194372 | 2020-05-31 | Cook | Illinois | 17031 | 77925 | 3642 |
191305 | 191305 | 2020-05-30 | Cook | Illinois | 17031 | 77119 | 3603 |
188240 | 188240 | 2020-05-29 | Cook | Illinois | 17031 | 76266 | 3570 |
185183 | 185183 | 2020-05-28 | Cook | Illinois | 17031 | 75306 | 3519 |
182129 | 182129 | 2020-05-27 | Cook | Illinois | 17031 | 74521 | 3455 |
179085 | 179085 | 2020-05-26 | Cook | Illinois | 17031 | 73819 | 3354 |
176041 | 176041 | 2020-05-25 | Cook | Illinois | 17031 | 73097 | 3324 |
172997 | 172997 | 2020-05-24 | Cook | Illinois | 17031 | 72010 | 3304 |
169956 | 169956 | 2020-05-23 | Cook | Illinois | 17031 | 70417 | 3246 |
166919 | 166919 | 2020-05-22 | Cook | Illinois | 17031 | 68949 | 3187 |
163886 | 163886 | 2020-05-21 | Cook | Illinois | 17031 | 67551 | 3114 |
160858 | 160858 | 2020-05-20 | Cook | Illinois | 17031 | 66213 | 3074 |
157832 | 157832 | 2020-05-19 | Cook | Illinois | 17031 | 64691 | 2980 |
154816 | 154816 | 2020-05-18 | Cook | Illinois | 17031 | 63690 | 2889 |
151804 | 151804 | 2020-05-17 | Cook | Illinois | 17031 | 62218 | 2839 |
148795 | 148795 | 2020-05-16 | Cook | Illinois | 17031 | 61212 | 2814 |
145792 | 145792 | 2020-05-15 | Cook | Illinois | 17031 | 59905 | 2762 |
142792 | 142792 | 2020-05-14 | Cook | Illinois | 17031 | 58457 | 2675 |
139796 | 139796 | 2020-05-13 | Cook | Illinois | 17031 | 56406 | 2589 |
136805 | 136805 | 2020-05-12 | Cook | Illinois | 17031 | 55470 | 2449 |
133816 | 133816 | 2020-05-11 | Cook | Illinois | 17031 | 53381 | 2361 |
130825 | 130825 | 2020-05-10 | Cook | Illinois | 17031 | 52655 | 2317 |
127834 | 127834 | 2020-05-09 | Cook | Illinois | 17031 | 51674 | 2264 |
124847 | 124847 | 2020-05-08 | Cook | Illinois | 17031 | 50236 | 2197 |
121868 | 121868 | 2020-05-07 | Cook | Illinois | 17031 | 48341 | 2110 |
118898 | 118898 | 2020-05-06 | Cook | Illinois | 17031 | 46689 | 2004 |
115938 | 115938 | 2020-05-05 | Cook | Illinois | 17031 | 45223 | 1922 |
113055 | 113055 | 2020-05-04 | Cook | Illinois | 17031 | 43715 | 1802 |
110180 | 110180 | 2020-05-03 | Cook | Illinois | 17031 | 42324 | 1786 |
107310 | 107310 | 2020-05-02 | Cook | Illinois | 17031 | 40227 | 1743 |
104445 | 104445 | 2020-05-01 | Cook | Illinois | 17031 | 38668 | 1673 |
101589 | 101589 | 2020-04-30 | Cook | Illinois | 17031 | 36513 | 1607 |
98738 | 98738 | 2020-04-29 | Cook | Illinois | 17031 | 34880 | 1516 |
95894 | 95894 | 2020-04-28 | Cook | Illinois | 17031 | 33449 | 1457 |
93062 | 93062 | 2020-04-27 | Cook | Illinois | 17031 | 31953 | 1347 |
90243 | 90243 | 2020-04-26 | Cook | Illinois | 17031 | 30574 | 1313 |
87427 | 87427 | 2020-04-25 | Cook | Illinois | 17031 | 29058 | 1267 |
84617 | 84617 | 2020-04-24 | Cook | Illinois | 17031 | 27616 | 1220 |
81817 | 81817 | 2020-04-23 | Cook | Illinois | 17031 | 25811 | 1142 |
79024 | 79024 | 2020-04-22 | Cook | Illinois | 17031 | 24546 | 1072 |
76240 | 76240 | 2020-04-21 | Cook | Illinois | 17031 | 23181 | 1002 |
73464 | 73464 | 2020-04-20 | Cook | Illinois | 17031 | 22101 | 915 |
70694 | 70694 | 2020-04-19 | Cook | Illinois | 17031 | 21272 | 877 |
67932 | 67932 | 2020-04-18 | Cook | Illinois | 17031 | 20395 | 860 |
65184 | 65184 | 2020-04-17 | Cook | Illinois | 17031 | 19391 | 760 |
62452 | 62452 | 2020-04-16 | Cook | Illinois | 17031 | 18087 | 722 |
59731 | 59731 | 2020-04-15 | Cook | Illinois | 17031 | 17306 | 630 |
57024 | 57024 | 2020-04-14 | Cook | Illinois | 17031 | 16323 | 577 |
54331 | 54331 | 2020-04-13 | Cook | Illinois | 17031 | 15474 | 543 |
51651 | 51651 | 2020-04-12 | Cook | Illinois | 17031 | 14585 | 485 |
48989 | 48989 | 2020-04-11 | Cook | Illinois | 17031 | 13417 | 453 |
46358 | 46358 | 2020-04-10 | Cook | Illinois | 17031 | 12472 | 398 |
43756 | 43756 | 2020-04-09 | Cook | Illinois | 17031 | 11415 | 351 |
41182 | 41182 | 2020-04-08 | Cook | Illinois | 17031 | 10520 | 312 |
38638 | 38638 | 2020-04-07 | Cook | Illinois | 17031 | 9509 | 249 |
36143 | 36143 | 2020-04-06 | Cook | Illinois | 17031 | 8728 | 209 |
33692 | 33692 | 2020-04-05 | Cook | Illinois | 17031 | 8043 | 186 |
31283 | 31283 | 2020-04-04 | Cook | Illinois | 17031 | 7439 | 167 |
28921 | 28921 | 2020-04-03 | Cook | Illinois | 17031 | 6473 | 141 |
26614 | 26614 | 2020-04-02 | Cook | Illinois | 17031 | 5575 | 107 |
24381 | 24381 | 2020-04-01 | Cook | Illinois | 17031 | 5152 | 95 |
22213 | 22213 | 2020-03-31 | Cook | Illinois | 17031 | 4496 | 61 |
20122 | 20122 | 2020-03-30 | Cook | Illinois | 17031 | 3727 | 44 |
18121 | 18121 | 2020-03-29 | Cook | Illinois | 17031 | 3445 | 40 |
16222 | 16222 | 2020-03-28 | Cook | Illinois | 17031 | 2613 | 28 |
14428 | 14428 | 2020-03-27 | Cook | Illinois | 17031 | 2239 | 20 |
12752 | 12752 | 2020-03-26 | Cook | Illinois | 17031 | 1904 | 18 |
11197 | 11197 | 2020-03-25 | Cook | Illinois | 17031 | 1418 | 13 |
9807 | 9807 | 2020-03-24 | Cook | Illinois | 17031 | 1194 | 12 |
8544 | 8544 | 2020-03-23 | Cook | Illinois | 17031 | 922 | 9 |
7389 | 7389 | 2020-03-22 | Cook | Illinois | 17031 | 805 | 6 |
6339 | 6339 | 2020-03-21 | Cook | Illinois | 17031 | 548 | 4 |
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);