ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17161 and state = "Illinois" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
7405 | 7405 | 2020-03-22 | Rock Island | Illinois | 17161 | 1 | 0 |
8561 | 8561 | 2020-03-23 | Rock Island | Illinois | 17161 | 1 | 0 |
9825 | 9825 | 2020-03-24 | Rock Island | Illinois | 17161 | 1 | 0 |
11218 | 11218 | 2020-03-25 | Rock Island | Illinois | 17161 | 3 | 0 |
12774 | 12774 | 2020-03-26 | Rock Island | Illinois | 17161 | 4 | 0 |
14452 | 14452 | 2020-03-27 | Rock Island | Illinois | 17161 | 4 | 0 |
16248 | 16248 | 2020-03-28 | Rock Island | Illinois | 17161 | 4 | 0 |
18150 | 18150 | 2020-03-29 | Rock Island | Illinois | 17161 | 5 | 0 |
20154 | 20154 | 2020-03-30 | Rock Island | Illinois | 17161 | 8 | 0 |
22247 | 22247 | 2020-03-31 | Rock Island | Illinois | 17161 | 11 | 0 |
24416 | 24416 | 2020-04-01 | Rock Island | Illinois | 17161 | 17 | 0 |
26654 | 26654 | 2020-04-02 | Rock Island | Illinois | 17161 | 21 | 0 |
28964 | 28964 | 2020-04-03 | Rock Island | Illinois | 17161 | 24 | 0 |
31330 | 31330 | 2020-04-04 | Rock Island | Illinois | 17161 | 29 | 0 |
33740 | 33740 | 2020-04-05 | Rock Island | Illinois | 17161 | 40 | 0 |
36192 | 36192 | 2020-04-06 | Rock Island | Illinois | 17161 | 47 | 0 |
38689 | 38689 | 2020-04-07 | Rock Island | Illinois | 17161 | 54 | 1 |
41234 | 41234 | 2020-04-08 | Rock Island | Illinois | 17161 | 67 | 1 |
43809 | 43809 | 2020-04-09 | Rock Island | Illinois | 17161 | 73 | 3 |
46413 | 46413 | 2020-04-10 | Rock Island | Illinois | 17161 | 80 | 3 |
49046 | 49046 | 2020-04-11 | Rock Island | Illinois | 17161 | 84 | 3 |
51708 | 51708 | 2020-04-12 | Rock Island | Illinois | 17161 | 91 | 3 |
54389 | 54389 | 2020-04-13 | Rock Island | Illinois | 17161 | 105 | 3 |
57082 | 57082 | 2020-04-14 | Rock Island | Illinois | 17161 | 113 | 3 |
59789 | 59789 | 2020-04-15 | Rock Island | Illinois | 17161 | 138 | 4 |
62510 | 62510 | 2020-04-16 | Rock Island | Illinois | 17161 | 154 | 4 |
65243 | 65243 | 2020-04-17 | Rock Island | Illinois | 17161 | 167 | 4 |
67992 | 67992 | 2020-04-18 | Rock Island | Illinois | 17161 | 187 | 4 |
70754 | 70754 | 2020-04-19 | Rock Island | Illinois | 17161 | 188 | 4 |
73524 | 73524 | 2020-04-20 | Rock Island | Illinois | 17161 | 211 | 4 |
76301 | 76301 | 2020-04-21 | Rock Island | Illinois | 17161 | 217 | 5 |
79085 | 79085 | 2020-04-22 | Rock Island | Illinois | 17161 | 242 | 6 |
81878 | 81878 | 2020-04-23 | Rock Island | Illinois | 17161 | 247 | 6 |
84678 | 84678 | 2020-04-24 | Rock Island | Illinois | 17161 | 270 | 6 |
87488 | 87488 | 2020-04-25 | Rock Island | Illinois | 17161 | 293 | 6 |
90304 | 90304 | 2020-04-26 | Rock Island | Illinois | 17161 | 304 | 7 |
93123 | 93123 | 2020-04-27 | Rock Island | Illinois | 17161 | 323 | 8 |
95955 | 95955 | 2020-04-28 | Rock Island | Illinois | 17161 | 342 | 9 |
98799 | 98799 | 2020-04-29 | Rock Island | Illinois | 17161 | 369 | 9 |
101650 | 101650 | 2020-04-30 | Rock Island | Illinois | 17161 | 377 | 9 |
104506 | 104506 | 2020-05-01 | Rock Island | Illinois | 17161 | 389 | 9 |
107371 | 107371 | 2020-05-02 | Rock Island | Illinois | 17161 | 412 | 9 |
110241 | 110241 | 2020-05-03 | Rock Island | Illinois | 17161 | 436 | 9 |
113116 | 113116 | 2020-05-04 | Rock Island | Illinois | 17161 | 452 | 9 |
115999 | 115999 | 2020-05-05 | Rock Island | Illinois | 17161 | 454 | 12 |
118959 | 118959 | 2020-05-06 | Rock Island | Illinois | 17161 | 465 | 14 |
121929 | 121929 | 2020-05-07 | Rock Island | Illinois | 17161 | 477 | 15 |
124909 | 124909 | 2020-05-08 | Rock Island | Illinois | 17161 | 498 | 15 |
127896 | 127896 | 2020-05-09 | Rock Island | Illinois | 17161 | 507 | 16 |
130887 | 130887 | 2020-05-10 | Rock Island | Illinois | 17161 | 515 | 16 |
133878 | 133878 | 2020-05-11 | Rock Island | Illinois | 17161 | 517 | 16 |
136867 | 136867 | 2020-05-12 | Rock Island | Illinois | 17161 | 530 | 17 |
139859 | 139859 | 2020-05-13 | Rock Island | Illinois | 17161 | 538 | 17 |
142855 | 142855 | 2020-05-14 | Rock Island | Illinois | 17161 | 543 | 17 |
145855 | 145855 | 2020-05-15 | Rock Island | Illinois | 17161 | 563 | 18 |
148859 | 148859 | 2020-05-16 | Rock Island | Illinois | 17161 | 570 | 18 |
151868 | 151868 | 2020-05-17 | Rock Island | Illinois | 17161 | 577 | 18 |
154880 | 154880 | 2020-05-18 | Rock Island | Illinois | 17161 | 590 | 18 |
157896 | 157896 | 2020-05-19 | Rock Island | Illinois | 17161 | 594 | 21 |
160922 | 160922 | 2020-05-20 | Rock Island | Illinois | 17161 | 600 | 21 |
163950 | 163950 | 2020-05-21 | Rock Island | Illinois | 17161 | 652 | 25 |
166983 | 166983 | 2020-05-22 | Rock Island | Illinois | 17161 | 665 | 25 |
170020 | 170020 | 2020-05-23 | Rock Island | Illinois | 17161 | 671 | 25 |
173061 | 173061 | 2020-05-24 | Rock Island | Illinois | 17161 | 675 | 25 |
176105 | 176105 | 2020-05-25 | Rock Island | Illinois | 17161 | 680 | 25 |
179149 | 179149 | 2020-05-26 | Rock Island | Illinois | 17161 | 684 | 26 |
182193 | 182193 | 2020-05-27 | Rock Island | Illinois | 17161 | 686 | 26 |
185247 | 185247 | 2020-05-28 | Rock Island | Illinois | 17161 | 686 | 26 |
188305 | 188305 | 2020-05-29 | Rock Island | Illinois | 17161 | 691 | 27 |
191370 | 191370 | 2020-05-30 | Rock Island | Illinois | 17161 | 695 | 27 |
194437 | 194437 | 2020-05-31 | Rock Island | Illinois | 17161 | 698 | 27 |
197507 | 197507 | 2020-06-01 | Rock Island | Illinois | 17161 | 700 | 27 |
200580 | 200580 | 2020-06-02 | Rock Island | Illinois | 17161 | 717 | 27 |
203656 | 203656 | 2020-06-03 | Rock Island | Illinois | 17161 | 722 | 27 |
206736 | 206736 | 2020-06-04 | Rock Island | Illinois | 17161 | 725 | 28 |
209817 | 209817 | 2020-06-05 | Rock Island | Illinois | 17161 | 731 | 28 |
212902 | 212902 | 2020-06-06 | Rock Island | Illinois | 17161 | 739 | 28 |
215989 | 215989 | 2020-06-07 | Rock Island | Illinois | 17161 | 742 | 28 |
219080 | 219080 | 2020-06-08 | Rock Island | Illinois | 17161 | 746 | 28 |
222175 | 222175 | 2020-06-09 | Rock Island | Illinois | 17161 | 746 | 28 |
225270 | 225270 | 2020-06-10 | Rock Island | Illinois | 17161 | 753 | 28 |
228372 | 228372 | 2020-06-11 | Rock Island | Illinois | 17161 | 763 | 28 |
231475 | 231475 | 2020-06-12 | Rock Island | Illinois | 17161 | 770 | 28 |
234581 | 234581 | 2020-06-13 | Rock Island | Illinois | 17161 | 778 | 28 |
237688 | 237688 | 2020-06-14 | Rock Island | Illinois | 17161 | 779 | 28 |
240796 | 240796 | 2020-06-15 | Rock Island | Illinois | 17161 | 782 | 28 |
243907 | 243907 | 2020-06-16 | Rock Island | Illinois | 17161 | 783 | 28 |
247020 | 247020 | 2020-06-17 | Rock Island | Illinois | 17161 | 786 | 28 |
250132 | 250132 | 2020-06-18 | Rock Island | Illinois | 17161 | 791 | 28 |
253247 | 253247 | 2020-06-19 | Rock Island | Illinois | 17161 | 793 | 28 |
256367 | 256367 | 2020-06-20 | Rock Island | Illinois | 17161 | 796 | 28 |
259493 | 259493 | 2020-06-21 | Rock Island | Illinois | 17161 | 807 | 28 |
262620 | 262620 | 2020-06-22 | Rock Island | Illinois | 17161 | 812 | 28 |
265748 | 265748 | 2020-06-23 | Rock Island | Illinois | 17161 | 822 | 28 |
268878 | 268878 | 2020-06-24 | Rock Island | Illinois | 17161 | 833 | 28 |
272015 | 272015 | 2020-06-25 | Rock Island | Illinois | 17161 | 841 | 28 |
275157 | 275157 | 2020-06-26 | Rock Island | Illinois | 17161 | 861 | 28 |
278305 | 278305 | 2020-06-27 | Rock Island | Illinois | 17161 | 913 | 28 |
281453 | 281453 | 2020-06-28 | Rock Island | Illinois | 17161 | 924 | 28 |
284598 | 284598 | 2020-06-29 | Rock Island | Illinois | 17161 | 935 | 29 |
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);