ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Jefferson" and state = "Illinois" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- 2020-05-04 1
- 2020-05-05 1
- …
state 1
- Illinois · 768 ✖
fips 1
- 17081 768
county 1
- Jefferson · 768 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
36160 | 36160 | 2020-04-06 | Jefferson | Illinois | 17081 | 1 | 0 |
38655 | 38655 | 2020-04-07 | Jefferson | Illinois | 17081 | 3 | 0 |
41200 | 41200 | 2020-04-08 | Jefferson | Illinois | 17081 | 3 | 0 |
43774 | 43774 | 2020-04-09 | Jefferson | Illinois | 17081 | 3 | 0 |
46378 | 46378 | 2020-04-10 | Jefferson | Illinois | 17081 | 5 | 0 |
49009 | 49009 | 2020-04-11 | Jefferson | Illinois | 17081 | 6 | 0 |
51671 | 51671 | 2020-04-12 | Jefferson | Illinois | 17081 | 7 | 0 |
54351 | 54351 | 2020-04-13 | Jefferson | Illinois | 17081 | 8 | 0 |
57044 | 57044 | 2020-04-14 | Jefferson | Illinois | 17081 | 8 | 0 |
59751 | 59751 | 2020-04-15 | Jefferson | Illinois | 17081 | 9 | 0 |
62472 | 62472 | 2020-04-16 | Jefferson | Illinois | 17081 | 10 | 0 |
65205 | 65205 | 2020-04-17 | Jefferson | Illinois | 17081 | 11 | 0 |
67954 | 67954 | 2020-04-18 | Jefferson | Illinois | 17081 | 12 | 0 |
70716 | 70716 | 2020-04-19 | Jefferson | Illinois | 17081 | 31 | 0 |
73486 | 73486 | 2020-04-20 | Jefferson | Illinois | 17081 | 32 | 0 |
76263 | 76263 | 2020-04-21 | Jefferson | Illinois | 17081 | 34 | 0 |
79047 | 79047 | 2020-04-22 | Jefferson | Illinois | 17081 | 75 | 1 |
81840 | 81840 | 2020-04-23 | Jefferson | Illinois | 17081 | 77 | 1 |
84640 | 84640 | 2020-04-24 | Jefferson | Illinois | 17081 | 80 | 2 |
87450 | 87450 | 2020-04-25 | Jefferson | Illinois | 17081 | 80 | 2 |
90266 | 90266 | 2020-04-26 | Jefferson | Illinois | 17081 | 83 | 5 |
93085 | 93085 | 2020-04-27 | Jefferson | Illinois | 17081 | 83 | 8 |
95917 | 95917 | 2020-04-28 | Jefferson | Illinois | 17081 | 81 | 9 |
98761 | 98761 | 2020-04-29 | Jefferson | Illinois | 17081 | 80 | 11 |
101612 | 101612 | 2020-04-30 | Jefferson | Illinois | 17081 | 83 | 12 |
104468 | 104468 | 2020-05-01 | Jefferson | Illinois | 17081 | 85 | 12 |
107333 | 107333 | 2020-05-02 | Jefferson | Illinois | 17081 | 84 | 14 |
110203 | 110203 | 2020-05-03 | Jefferson | Illinois | 17081 | 86 | 15 |
113078 | 113078 | 2020-05-04 | Jefferson | Illinois | 17081 | 87 | 15 |
115961 | 115961 | 2020-05-05 | Jefferson | Illinois | 17081 | 86 | 15 |
118921 | 118921 | 2020-05-06 | Jefferson | Illinois | 17081 | 86 | 15 |
121891 | 121891 | 2020-05-07 | Jefferson | Illinois | 17081 | 88 | 15 |
124870 | 124870 | 2020-05-08 | Jefferson | Illinois | 17081 | 89 | 15 |
127857 | 127857 | 2020-05-09 | Jefferson | Illinois | 17081 | 94 | 15 |
130848 | 130848 | 2020-05-10 | Jefferson | Illinois | 17081 | 97 | 15 |
133839 | 133839 | 2020-05-11 | Jefferson | Illinois | 17081 | 94 | 15 |
136828 | 136828 | 2020-05-12 | Jefferson | Illinois | 17081 | 95 | 15 |
139820 | 139820 | 2020-05-13 | Jefferson | Illinois | 17081 | 97 | 16 |
142816 | 142816 | 2020-05-14 | Jefferson | Illinois | 17081 | 98 | 17 |
145816 | 145816 | 2020-05-15 | Jefferson | Illinois | 17081 | 98 | 17 |
148819 | 148819 | 2020-05-16 | Jefferson | Illinois | 17081 | 98 | 17 |
151828 | 151828 | 2020-05-17 | Jefferson | Illinois | 17081 | 98 | 17 |
154840 | 154840 | 2020-05-18 | Jefferson | Illinois | 17081 | 99 | 17 |
157856 | 157856 | 2020-05-19 | Jefferson | Illinois | 17081 | 100 | 17 |
160882 | 160882 | 2020-05-20 | Jefferson | Illinois | 17081 | 100 | 17 |
163910 | 163910 | 2020-05-21 | Jefferson | Illinois | 17081 | 99 | 16 |
166943 | 166943 | 2020-05-22 | Jefferson | Illinois | 17081 | 99 | 16 |
169980 | 169980 | 2020-05-23 | Jefferson | Illinois | 17081 | 100 | 16 |
173021 | 173021 | 2020-05-24 | Jefferson | Illinois | 17081 | 101 | 16 |
176065 | 176065 | 2020-05-25 | Jefferson | Illinois | 17081 | 101 | 16 |
179109 | 179109 | 2020-05-26 | Jefferson | Illinois | 17081 | 101 | 16 |
182153 | 182153 | 2020-05-27 | Jefferson | Illinois | 17081 | 101 | 16 |
185207 | 185207 | 2020-05-28 | Jefferson | Illinois | 17081 | 101 | 16 |
188265 | 188265 | 2020-05-29 | Jefferson | Illinois | 17081 | 101 | 16 |
191330 | 191330 | 2020-05-30 | Jefferson | Illinois | 17081 | 101 | 16 |
194397 | 194397 | 2020-05-31 | Jefferson | Illinois | 17081 | 101 | 16 |
197467 | 197467 | 2020-06-01 | Jefferson | Illinois | 17081 | 101 | 16 |
200540 | 200540 | 2020-06-02 | Jefferson | Illinois | 17081 | 101 | 16 |
203616 | 203616 | 2020-06-03 | Jefferson | Illinois | 17081 | 101 | 16 |
206696 | 206696 | 2020-06-04 | Jefferson | Illinois | 17081 | 101 | 16 |
209777 | 209777 | 2020-06-05 | Jefferson | Illinois | 17081 | 101 | 16 |
212862 | 212862 | 2020-06-06 | Jefferson | Illinois | 17081 | 101 | 16 |
215949 | 215949 | 2020-06-07 | Jefferson | Illinois | 17081 | 101 | 16 |
219040 | 219040 | 2020-06-08 | Jefferson | Illinois | 17081 | 101 | 16 |
222135 | 222135 | 2020-06-09 | Jefferson | Illinois | 17081 | 101 | 16 |
225230 | 225230 | 2020-06-10 | Jefferson | Illinois | 17081 | 101 | 16 |
228332 | 228332 | 2020-06-11 | Jefferson | Illinois | 17081 | 101 | 16 |
231435 | 231435 | 2020-06-12 | Jefferson | Illinois | 17081 | 103 | 16 |
234541 | 234541 | 2020-06-13 | Jefferson | Illinois | 17081 | 103 | 16 |
237648 | 237648 | 2020-06-14 | Jefferson | Illinois | 17081 | 104 | 16 |
240756 | 240756 | 2020-06-15 | Jefferson | Illinois | 17081 | 104 | 16 |
243867 | 243867 | 2020-06-16 | Jefferson | Illinois | 17081 | 104 | 16 |
246980 | 246980 | 2020-06-17 | Jefferson | Illinois | 17081 | 104 | 16 |
250092 | 250092 | 2020-06-18 | Jefferson | Illinois | 17081 | 104 | 16 |
253207 | 253207 | 2020-06-19 | Jefferson | Illinois | 17081 | 104 | 16 |
256327 | 256327 | 2020-06-20 | Jefferson | Illinois | 17081 | 104 | 16 |
259453 | 259453 | 2020-06-21 | Jefferson | Illinois | 17081 | 104 | 16 |
262580 | 262580 | 2020-06-22 | Jefferson | Illinois | 17081 | 104 | 16 |
265708 | 265708 | 2020-06-23 | Jefferson | Illinois | 17081 | 104 | 17 |
268838 | 268838 | 2020-06-24 | Jefferson | Illinois | 17081 | 107 | 17 |
271975 | 271975 | 2020-06-25 | Jefferson | Illinois | 17081 | 105 | 17 |
275117 | 275117 | 2020-06-26 | Jefferson | Illinois | 17081 | 105 | 17 |
278265 | 278265 | 2020-06-27 | Jefferson | Illinois | 17081 | 106 | 17 |
281413 | 281413 | 2020-06-28 | Jefferson | Illinois | 17081 | 106 | 17 |
284558 | 284558 | 2020-06-29 | Jefferson | Illinois | 17081 | 107 | 17 |
287707 | 287707 | 2020-06-30 | Jefferson | Illinois | 17081 | 107 | 17 |
290857 | 290857 | 2020-07-01 | Jefferson | Illinois | 17081 | 107 | 17 |
294011 | 294011 | 2020-07-02 | Jefferson | Illinois | 17081 | 107 | 17 |
297168 | 297168 | 2020-07-03 | Jefferson | Illinois | 17081 | 106 | 17 |
300330 | 300330 | 2020-07-04 | Jefferson | Illinois | 17081 | 106 | 17 |
303494 | 303494 | 2020-07-05 | Jefferson | Illinois | 17081 | 107 | 17 |
306659 | 306659 | 2020-07-06 | Jefferson | Illinois | 17081 | 107 | 17 |
309827 | 309827 | 2020-07-07 | Jefferson | Illinois | 17081 | 107 | 17 |
312997 | 312997 | 2020-07-08 | Jefferson | Illinois | 17081 | 111 | 17 |
316171 | 316171 | 2020-07-09 | Jefferson | Illinois | 17081 | 113 | 17 |
319344 | 319344 | 2020-07-10 | Jefferson | Illinois | 17081 | 115 | 17 |
322523 | 322523 | 2020-07-11 | Jefferson | Illinois | 17081 | 114 | 17 |
325704 | 325704 | 2020-07-12 | Jefferson | Illinois | 17081 | 114 | 17 |
328890 | 328890 | 2020-07-13 | Jefferson | Illinois | 17081 | 115 | 17 |
332077 | 332077 | 2020-07-14 | Jefferson | Illinois | 17081 | 117 | 17 |
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);