ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Rock Island" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386615 | 386615 | 2020-07-31 | Rock Island | Illinois | 17161 | 1575 | 31 |
383397 | 383397 | 2020-07-30 | Rock Island | Illinois | 17161 | 1550 | 30 |
380180 | 380180 | 2020-07-29 | Rock Island | Illinois | 17161 | 1501 | 30 |
376963 | 376963 | 2020-07-28 | Rock Island | Illinois | 17161 | 1491 | 30 |
373748 | 373748 | 2020-07-27 | Rock Island | Illinois | 17161 | 1480 | 30 |
370536 | 370536 | 2020-07-26 | Rock Island | Illinois | 17161 | 1472 | 30 |
367326 | 367326 | 2020-07-25 | Rock Island | Illinois | 17161 | 1460 | 30 |
364119 | 364119 | 2020-07-24 | Rock Island | Illinois | 17161 | 1451 | 30 |
360912 | 360912 | 2020-07-23 | Rock Island | Illinois | 17161 | 1429 | 30 |
357707 | 357707 | 2020-07-22 | Rock Island | Illinois | 17161 | 1397 | 30 |
354505 | 354505 | 2020-07-21 | Rock Island | Illinois | 17161 | 1373 | 30 |
351303 | 351303 | 2020-07-20 | Rock Island | Illinois | 17161 | 1359 | 30 |
348103 | 348103 | 2020-07-19 | Rock Island | Illinois | 17161 | 1357 | 30 |
344902 | 344902 | 2020-07-18 | Rock Island | Illinois | 17161 | 1337 | 30 |
341702 | 341702 | 2020-07-17 | Rock Island | Illinois | 17161 | 1315 | 30 |
338506 | 338506 | 2020-07-16 | Rock Island | Illinois | 17161 | 1285 | 30 |
335310 | 335310 | 2020-07-15 | Rock Island | Illinois | 17161 | 1265 | 30 |
332117 | 332117 | 2020-07-14 | Rock Island | Illinois | 17161 | 1248 | 30 |
328930 | 328930 | 2020-07-13 | Rock Island | Illinois | 17161 | 1234 | 30 |
325744 | 325744 | 2020-07-12 | Rock Island | Illinois | 17161 | 1214 | 30 |
322563 | 322563 | 2020-07-11 | Rock Island | Illinois | 17161 | 1195 | 30 |
319384 | 319384 | 2020-07-10 | Rock Island | Illinois | 17161 | 1163 | 30 |
316211 | 316211 | 2020-07-09 | Rock Island | Illinois | 17161 | 1139 | 30 |
313037 | 313037 | 2020-07-08 | Rock Island | Illinois | 17161 | 1122 | 30 |
309867 | 309867 | 2020-07-07 | Rock Island | Illinois | 17161 | 1097 | 30 |
306699 | 306699 | 2020-07-06 | Rock Island | Illinois | 17161 | 1086 | 30 |
303534 | 303534 | 2020-07-05 | Rock Island | Illinois | 17161 | 1064 | 29 |
300370 | 300370 | 2020-07-04 | Rock Island | Illinois | 17161 | 1043 | 29 |
297208 | 297208 | 2020-07-03 | Rock Island | Illinois | 17161 | 1019 | 29 |
294051 | 294051 | 2020-07-02 | Rock Island | Illinois | 17161 | 995 | 29 |
290897 | 290897 | 2020-07-01 | Rock Island | Illinois | 17161 | 975 | 29 |
287747 | 287747 | 2020-06-30 | Rock Island | Illinois | 17161 | 947 | 29 |
284598 | 284598 | 2020-06-29 | Rock Island | Illinois | 17161 | 935 | 29 |
281453 | 281453 | 2020-06-28 | Rock Island | Illinois | 17161 | 924 | 28 |
278305 | 278305 | 2020-06-27 | Rock Island | Illinois | 17161 | 913 | 28 |
275157 | 275157 | 2020-06-26 | Rock Island | Illinois | 17161 | 861 | 28 |
272015 | 272015 | 2020-06-25 | Rock Island | Illinois | 17161 | 841 | 28 |
268878 | 268878 | 2020-06-24 | Rock Island | Illinois | 17161 | 833 | 28 |
265748 | 265748 | 2020-06-23 | Rock Island | Illinois | 17161 | 822 | 28 |
262620 | 262620 | 2020-06-22 | Rock Island | Illinois | 17161 | 812 | 28 |
259493 | 259493 | 2020-06-21 | Rock Island | Illinois | 17161 | 807 | 28 |
256367 | 256367 | 2020-06-20 | Rock Island | Illinois | 17161 | 796 | 28 |
253247 | 253247 | 2020-06-19 | Rock Island | Illinois | 17161 | 793 | 28 |
250132 | 250132 | 2020-06-18 | Rock Island | Illinois | 17161 | 791 | 28 |
247020 | 247020 | 2020-06-17 | Rock Island | Illinois | 17161 | 786 | 28 |
243907 | 243907 | 2020-06-16 | Rock Island | Illinois | 17161 | 783 | 28 |
240796 | 240796 | 2020-06-15 | Rock Island | Illinois | 17161 | 782 | 28 |
237688 | 237688 | 2020-06-14 | Rock Island | Illinois | 17161 | 779 | 28 |
234581 | 234581 | 2020-06-13 | Rock Island | Illinois | 17161 | 778 | 28 |
231475 | 231475 | 2020-06-12 | Rock Island | Illinois | 17161 | 770 | 28 |
228372 | 228372 | 2020-06-11 | Rock Island | Illinois | 17161 | 763 | 28 |
225270 | 225270 | 2020-06-10 | Rock Island | Illinois | 17161 | 753 | 28 |
222175 | 222175 | 2020-06-09 | Rock Island | Illinois | 17161 | 746 | 28 |
219080 | 219080 | 2020-06-08 | Rock Island | Illinois | 17161 | 746 | 28 |
215989 | 215989 | 2020-06-07 | Rock Island | Illinois | 17161 | 742 | 28 |
212902 | 212902 | 2020-06-06 | Rock Island | Illinois | 17161 | 739 | 28 |
209817 | 209817 | 2020-06-05 | Rock Island | Illinois | 17161 | 731 | 28 |
206736 | 206736 | 2020-06-04 | Rock Island | Illinois | 17161 | 725 | 28 |
203656 | 203656 | 2020-06-03 | Rock Island | Illinois | 17161 | 722 | 27 |
200580 | 200580 | 2020-06-02 | Rock Island | Illinois | 17161 | 717 | 27 |
197507 | 197507 | 2020-06-01 | Rock Island | Illinois | 17161 | 700 | 27 |
194437 | 194437 | 2020-05-31 | Rock Island | Illinois | 17161 | 698 | 27 |
191370 | 191370 | 2020-05-30 | Rock Island | Illinois | 17161 | 695 | 27 |
188305 | 188305 | 2020-05-29 | Rock Island | Illinois | 17161 | 691 | 27 |
185247 | 185247 | 2020-05-28 | Rock Island | Illinois | 17161 | 686 | 26 |
182193 | 182193 | 2020-05-27 | Rock Island | Illinois | 17161 | 686 | 26 |
179149 | 179149 | 2020-05-26 | Rock Island | Illinois | 17161 | 684 | 26 |
176105 | 176105 | 2020-05-25 | Rock Island | Illinois | 17161 | 680 | 25 |
173061 | 173061 | 2020-05-24 | Rock Island | Illinois | 17161 | 675 | 25 |
170020 | 170020 | 2020-05-23 | Rock Island | Illinois | 17161 | 671 | 25 |
166983 | 166983 | 2020-05-22 | Rock Island | Illinois | 17161 | 665 | 25 |
163950 | 163950 | 2020-05-21 | Rock Island | Illinois | 17161 | 652 | 25 |
160922 | 160922 | 2020-05-20 | Rock Island | Illinois | 17161 | 600 | 21 |
157896 | 157896 | 2020-05-19 | Rock Island | Illinois | 17161 | 594 | 21 |
154880 | 154880 | 2020-05-18 | Rock Island | Illinois | 17161 | 590 | 18 |
151868 | 151868 | 2020-05-17 | Rock Island | Illinois | 17161 | 577 | 18 |
148859 | 148859 | 2020-05-16 | Rock Island | Illinois | 17161 | 570 | 18 |
145855 | 145855 | 2020-05-15 | Rock Island | Illinois | 17161 | 563 | 18 |
142855 | 142855 | 2020-05-14 | Rock Island | Illinois | 17161 | 543 | 17 |
139859 | 139859 | 2020-05-13 | Rock Island | Illinois | 17161 | 538 | 17 |
136867 | 136867 | 2020-05-12 | Rock Island | Illinois | 17161 | 530 | 17 |
133878 | 133878 | 2020-05-11 | Rock Island | Illinois | 17161 | 517 | 16 |
130887 | 130887 | 2020-05-10 | Rock Island | Illinois | 17161 | 515 | 16 |
127896 | 127896 | 2020-05-09 | Rock Island | Illinois | 17161 | 507 | 16 |
124909 | 124909 | 2020-05-08 | Rock Island | Illinois | 17161 | 498 | 15 |
121929 | 121929 | 2020-05-07 | Rock Island | Illinois | 17161 | 477 | 15 |
118959 | 118959 | 2020-05-06 | Rock Island | Illinois | 17161 | 465 | 14 |
115999 | 115999 | 2020-05-05 | Rock Island | Illinois | 17161 | 454 | 12 |
113116 | 113116 | 2020-05-04 | Rock Island | Illinois | 17161 | 452 | 9 |
110241 | 110241 | 2020-05-03 | Rock Island | Illinois | 17161 | 436 | 9 |
107371 | 107371 | 2020-05-02 | Rock Island | Illinois | 17161 | 412 | 9 |
104506 | 104506 | 2020-05-01 | Rock Island | Illinois | 17161 | 389 | 9 |
101650 | 101650 | 2020-04-30 | Rock Island | Illinois | 17161 | 377 | 9 |
98799 | 98799 | 2020-04-29 | Rock Island | Illinois | 17161 | 369 | 9 |
95955 | 95955 | 2020-04-28 | Rock Island | Illinois | 17161 | 342 | 9 |
93123 | 93123 | 2020-04-27 | Rock Island | Illinois | 17161 | 323 | 8 |
90304 | 90304 | 2020-04-26 | Rock Island | Illinois | 17161 | 304 | 7 |
87488 | 87488 | 2020-04-25 | Rock Island | Illinois | 17161 | 293 | 6 |
84678 | 84678 | 2020-04-24 | Rock Island | Illinois | 17161 | 270 | 6 |
81878 | 81878 | 2020-04-23 | Rock Island | Illinois | 17161 | 247 | 6 |
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);