ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Tazewell" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386624 | 386624 | 2020-07-31 | Tazewell | Illinois | 17179 | 335 | 8 |
383406 | 383406 | 2020-07-30 | Tazewell | Illinois | 17179 | 322 | 8 |
380189 | 380189 | 2020-07-29 | Tazewell | Illinois | 17179 | 304 | 8 |
376972 | 376972 | 2020-07-28 | Tazewell | Illinois | 17179 | 290 | 8 |
373757 | 373757 | 2020-07-27 | Tazewell | Illinois | 17179 | 280 | 8 |
370545 | 370545 | 2020-07-26 | Tazewell | Illinois | 17179 | 274 | 8 |
367335 | 367335 | 2020-07-25 | Tazewell | Illinois | 17179 | 271 | 8 |
364128 | 364128 | 2020-07-24 | Tazewell | Illinois | 17179 | 260 | 8 |
360921 | 360921 | 2020-07-23 | Tazewell | Illinois | 17179 | 251 | 8 |
357716 | 357716 | 2020-07-22 | Tazewell | Illinois | 17179 | 243 | 8 |
354514 | 354514 | 2020-07-21 | Tazewell | Illinois | 17179 | 235 | 8 |
351312 | 351312 | 2020-07-20 | Tazewell | Illinois | 17179 | 226 | 8 |
348112 | 348112 | 2020-07-19 | Tazewell | Illinois | 17179 | 221 | 8 |
344911 | 344911 | 2020-07-18 | Tazewell | Illinois | 17179 | 216 | 8 |
341711 | 341711 | 2020-07-17 | Tazewell | Illinois | 17179 | 212 | 8 |
338515 | 338515 | 2020-07-16 | Tazewell | Illinois | 17179 | 204 | 8 |
335319 | 335319 | 2020-07-15 | Tazewell | Illinois | 17179 | 196 | 8 |
332126 | 332126 | 2020-07-14 | Tazewell | Illinois | 17179 | 191 | 8 |
328939 | 328939 | 2020-07-13 | Tazewell | Illinois | 17179 | 178 | 8 |
325753 | 325753 | 2020-07-12 | Tazewell | Illinois | 17179 | 175 | 8 |
322572 | 322572 | 2020-07-11 | Tazewell | Illinois | 17179 | 172 | 8 |
319393 | 319393 | 2020-07-10 | Tazewell | Illinois | 17179 | 167 | 8 |
316220 | 316220 | 2020-07-09 | Tazewell | Illinois | 17179 | 164 | 8 |
313046 | 313046 | 2020-07-08 | Tazewell | Illinois | 17179 | 158 | 8 |
309876 | 309876 | 2020-07-07 | Tazewell | Illinois | 17179 | 154 | 8 |
306708 | 306708 | 2020-07-06 | Tazewell | Illinois | 17179 | 152 | 8 |
303543 | 303543 | 2020-07-05 | Tazewell | Illinois | 17179 | 150 | 8 |
300379 | 300379 | 2020-07-04 | Tazewell | Illinois | 17179 | 149 | 8 |
297217 | 297217 | 2020-07-03 | Tazewell | Illinois | 17179 | 146 | 8 |
294059 | 294059 | 2020-07-02 | Tazewell | Illinois | 17179 | 141 | 8 |
290905 | 290905 | 2020-07-01 | Tazewell | Illinois | 17179 | 137 | 8 |
287755 | 287755 | 2020-06-30 | Tazewell | Illinois | 17179 | 127 | 8 |
284606 | 284606 | 2020-06-29 | Tazewell | Illinois | 17179 | 124 | 8 |
281461 | 281461 | 2020-06-28 | Tazewell | Illinois | 17179 | 120 | 7 |
278313 | 278313 | 2020-06-27 | Tazewell | Illinois | 17179 | 120 | 7 |
275165 | 275165 | 2020-06-26 | Tazewell | Illinois | 17179 | 120 | 7 |
272023 | 272023 | 2020-06-25 | Tazewell | Illinois | 17179 | 119 | 7 |
268886 | 268886 | 2020-06-24 | Tazewell | Illinois | 17179 | 115 | 7 |
265756 | 265756 | 2020-06-23 | Tazewell | Illinois | 17179 | 115 | 7 |
262628 | 262628 | 2020-06-22 | Tazewell | Illinois | 17179 | 113 | 7 |
259501 | 259501 | 2020-06-21 | Tazewell | Illinois | 17179 | 112 | 7 |
256375 | 256375 | 2020-06-20 | Tazewell | Illinois | 17179 | 111 | 7 |
253255 | 253255 | 2020-06-19 | Tazewell | Illinois | 17179 | 109 | 7 |
250140 | 250140 | 2020-06-18 | Tazewell | Illinois | 17179 | 104 | 7 |
247028 | 247028 | 2020-06-17 | Tazewell | Illinois | 17179 | 98 | 7 |
243915 | 243915 | 2020-06-16 | Tazewell | Illinois | 17179 | 95 | 6 |
240804 | 240804 | 2020-06-15 | Tazewell | Illinois | 17179 | 92 | 6 |
237696 | 237696 | 2020-06-14 | Tazewell | Illinois | 17179 | 91 | 6 |
234589 | 234589 | 2020-06-13 | Tazewell | Illinois | 17179 | 89 | 6 |
231483 | 231483 | 2020-06-12 | Tazewell | Illinois | 17179 | 86 | 6 |
228380 | 228380 | 2020-06-11 | Tazewell | Illinois | 17179 | 82 | 6 |
225278 | 225278 | 2020-06-10 | Tazewell | Illinois | 17179 | 82 | 6 |
222183 | 222183 | 2020-06-09 | Tazewell | Illinois | 17179 | 88 | 6 |
219088 | 219088 | 2020-06-08 | Tazewell | Illinois | 17179 | 81 | 6 |
215997 | 215997 | 2020-06-07 | Tazewell | Illinois | 17179 | 81 | 6 |
212910 | 212910 | 2020-06-06 | Tazewell | Illinois | 17179 | 81 | 6 |
209825 | 209825 | 2020-06-05 | Tazewell | Illinois | 17179 | 81 | 5 |
206744 | 206744 | 2020-06-04 | Tazewell | Illinois | 17179 | 79 | 5 |
203664 | 203664 | 2020-06-03 | Tazewell | Illinois | 17179 | 78 | 5 |
200588 | 200588 | 2020-06-02 | Tazewell | Illinois | 17179 | 75 | 5 |
197515 | 197515 | 2020-06-01 | Tazewell | Illinois | 17179 | 74 | 5 |
194445 | 194445 | 2020-05-31 | Tazewell | Illinois | 17179 | 74 | 5 |
191378 | 191378 | 2020-05-30 | Tazewell | Illinois | 17179 | 73 | 5 |
188313 | 188313 | 2020-05-29 | Tazewell | Illinois | 17179 | 71 | 4 |
185255 | 185255 | 2020-05-28 | Tazewell | Illinois | 17179 | 71 | 4 |
182201 | 182201 | 2020-05-27 | Tazewell | Illinois | 17179 | 69 | 4 |
179157 | 179157 | 2020-05-26 | Tazewell | Illinois | 17179 | 68 | 4 |
176113 | 176113 | 2020-05-25 | Tazewell | Illinois | 17179 | 67 | 4 |
173069 | 173069 | 2020-05-24 | Tazewell | Illinois | 17179 | 67 | 4 |
170028 | 170028 | 2020-05-23 | Tazewell | Illinois | 17179 | 67 | 4 |
166991 | 166991 | 2020-05-22 | Tazewell | Illinois | 17179 | 66 | 4 |
163958 | 163958 | 2020-05-21 | Tazewell | Illinois | 17179 | 65 | 4 |
160930 | 160930 | 2020-05-20 | Tazewell | Illinois | 17179 | 65 | 4 |
157904 | 157904 | 2020-05-19 | Tazewell | Illinois | 17179 | 64 | 4 |
154888 | 154888 | 2020-05-18 | Tazewell | Illinois | 17179 | 63 | 4 |
151876 | 151876 | 2020-05-17 | Tazewell | Illinois | 17179 | 63 | 4 |
148867 | 148867 | 2020-05-16 | Tazewell | Illinois | 17179 | 62 | 4 |
145863 | 145863 | 2020-05-15 | Tazewell | Illinois | 17179 | 62 | 4 |
142863 | 142863 | 2020-05-14 | Tazewell | Illinois | 17179 | 58 | 4 |
139867 | 139867 | 2020-05-13 | Tazewell | Illinois | 17179 | 59 | 4 |
136875 | 136875 | 2020-05-12 | Tazewell | Illinois | 17179 | 58 | 4 |
133886 | 133886 | 2020-05-11 | Tazewell | Illinois | 17179 | 59 | 4 |
130895 | 130895 | 2020-05-10 | Tazewell | Illinois | 17179 | 59 | 4 |
127904 | 127904 | 2020-05-09 | Tazewell | Illinois | 17179 | 59 | 4 |
124917 | 124917 | 2020-05-08 | Tazewell | Illinois | 17179 | 58 | 4 |
121937 | 121937 | 2020-05-07 | Tazewell | Illinois | 17179 | 54 | 3 |
118967 | 118967 | 2020-05-06 | Tazewell | Illinois | 17179 | 53 | 3 |
116007 | 116007 | 2020-05-05 | Tazewell | Illinois | 17179 | 48 | 3 |
113124 | 113124 | 2020-05-04 | Tazewell | Illinois | 17179 | 45 | 3 |
110249 | 110249 | 2020-05-03 | Tazewell | Illinois | 17179 | 47 | 3 |
107379 | 107379 | 2020-05-02 | Tazewell | Illinois | 17179 | 43 | 3 |
104514 | 104514 | 2020-05-01 | Tazewell | Illinois | 17179 | 41 | 3 |
101658 | 101658 | 2020-04-30 | Tazewell | Illinois | 17179 | 45 | 3 |
98807 | 98807 | 2020-04-29 | Tazewell | Illinois | 17179 | 40 | 3 |
95963 | 95963 | 2020-04-28 | Tazewell | Illinois | 17179 | 38 | 3 |
93131 | 93131 | 2020-04-27 | Tazewell | Illinois | 17179 | 37 | 3 |
90312 | 90312 | 2020-04-26 | Tazewell | Illinois | 17179 | 36 | 3 |
87496 | 87496 | 2020-04-25 | Tazewell | Illinois | 17179 | 36 | 3 |
84686 | 84686 | 2020-04-24 | Tazewell | Illinois | 17179 | 34 | 3 |
81886 | 81886 | 2020-04-23 | Tazewell | Illinois | 17179 | 30 | 3 |
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);