ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where fips = 17181 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535111 | 535111 | 2020-09-15 | Union | Illinois | 17181 | 476 | 24 |
531876 | 531876 | 2020-09-14 | Union | Illinois | 17181 | 473 | 24 |
528639 | 528639 | 2020-09-13 | Union | Illinois | 17181 | 471 | 24 |
525403 | 525403 | 2020-09-12 | Union | Illinois | 17181 | 464 | 24 |
522167 | 522167 | 2020-09-11 | Union | Illinois | 17181 | 460 | 24 |
518930 | 518930 | 2020-09-10 | Union | Illinois | 17181 | 455 | 24 |
515695 | 515695 | 2020-09-09 | Union | Illinois | 17181 | 451 | 24 |
512462 | 512462 | 2020-09-08 | Union | Illinois | 17181 | 451 | 24 |
509229 | 509229 | 2020-09-07 | Union | Illinois | 17181 | 451 | 24 |
505997 | 505997 | 2020-09-06 | Union | Illinois | 17181 | 446 | 24 |
502763 | 502763 | 2020-09-05 | Union | Illinois | 17181 | 446 | 24 |
499529 | 499529 | 2020-09-04 | Union | Illinois | 17181 | 442 | 24 |
496296 | 496296 | 2020-09-03 | Union | Illinois | 17181 | 438 | 24 |
493062 | 493062 | 2020-09-02 | Union | Illinois | 17181 | 435 | 24 |
489829 | 489829 | 2020-09-01 | Union | Illinois | 17181 | 432 | 24 |
486596 | 486596 | 2020-08-31 | Union | Illinois | 17181 | 426 | 24 |
483361 | 483361 | 2020-08-30 | Union | Illinois | 17181 | 424 | 24 |
480127 | 480127 | 2020-08-29 | Union | Illinois | 17181 | 422 | 24 |
476894 | 476894 | 2020-08-28 | Union | Illinois | 17181 | 414 | 24 |
473661 | 473661 | 2020-08-27 | Union | Illinois | 17181 | 414 | 23 |
470429 | 470429 | 2020-08-26 | Union | Illinois | 17181 | 409 | 23 |
467200 | 467200 | 2020-08-25 | Union | Illinois | 17181 | 402 | 23 |
463971 | 463971 | 2020-08-24 | Union | Illinois | 17181 | 400 | 23 |
460742 | 460742 | 2020-08-23 | Union | Illinois | 17181 | 393 | 23 |
457515 | 457515 | 2020-08-22 | Union | Illinois | 17181 | 391 | 23 |
454287 | 454287 | 2020-08-21 | Union | Illinois | 17181 | 387 | 23 |
451059 | 451059 | 2020-08-20 | Union | Illinois | 17181 | 382 | 23 |
447831 | 447831 | 2020-08-19 | Union | Illinois | 17181 | 375 | 23 |
444604 | 444604 | 2020-08-18 | Union | Illinois | 17181 | 368 | 23 |
441378 | 441378 | 2020-08-17 | Union | Illinois | 17181 | 363 | 23 |
438152 | 438152 | 2020-08-16 | Union | Illinois | 17181 | 361 | 23 |
434926 | 434926 | 2020-08-15 | Union | Illinois | 17181 | 344 | 23 |
431701 | 431701 | 2020-08-14 | Union | Illinois | 17181 | 339 | 23 |
428473 | 428473 | 2020-08-13 | Union | Illinois | 17181 | 337 | 23 |
425249 | 425249 | 2020-08-12 | Union | Illinois | 17181 | 330 | 23 |
422028 | 422028 | 2020-08-11 | Union | Illinois | 17181 | 327 | 23 |
418805 | 418805 | 2020-08-10 | Union | Illinois | 17181 | 324 | 23 |
415584 | 415584 | 2020-08-09 | Union | Illinois | 17181 | 321 | 23 |
412364 | 412364 | 2020-08-08 | Union | Illinois | 17181 | 321 | 23 |
409145 | 409145 | 2020-08-07 | Union | Illinois | 17181 | 318 | 23 |
405925 | 405925 | 2020-08-06 | Union | Illinois | 17181 | 309 | 23 |
402707 | 402707 | 2020-08-05 | Union | Illinois | 17181 | 306 | 22 |
399491 | 399491 | 2020-08-04 | Union | Illinois | 17181 | 305 | 21 |
396275 | 396275 | 2020-08-03 | Union | Illinois | 17181 | 303 | 21 |
393059 | 393059 | 2020-08-02 | Union | Illinois | 17181 | 303 | 21 |
389842 | 389842 | 2020-08-01 | Union | Illinois | 17181 | 296 | 21 |
386625 | 386625 | 2020-07-31 | Union | Illinois | 17181 | 276 | 21 |
383407 | 383407 | 2020-07-30 | Union | Illinois | 17181 | 276 | 21 |
380190 | 380190 | 2020-07-29 | Union | Illinois | 17181 | 275 | 21 |
376973 | 376973 | 2020-07-28 | Union | Illinois | 17181 | 273 | 21 |
373758 | 373758 | 2020-07-27 | Union | Illinois | 17181 | 273 | 21 |
370546 | 370546 | 2020-07-26 | Union | Illinois | 17181 | 269 | 21 |
367336 | 367336 | 2020-07-25 | Union | Illinois | 17181 | 266 | 21 |
364129 | 364129 | 2020-07-24 | Union | Illinois | 17181 | 262 | 21 |
360922 | 360922 | 2020-07-23 | Union | Illinois | 17181 | 256 | 21 |
357717 | 357717 | 2020-07-22 | Union | Illinois | 17181 | 255 | 21 |
354515 | 354515 | 2020-07-21 | Union | Illinois | 17181 | 241 | 21 |
351313 | 351313 | 2020-07-20 | Union | Illinois | 17181 | 237 | 21 |
348113 | 348113 | 2020-07-19 | Union | Illinois | 17181 | 231 | 21 |
344912 | 344912 | 2020-07-18 | Union | Illinois | 17181 | 229 | 21 |
341712 | 341712 | 2020-07-17 | Union | Illinois | 17181 | 222 | 21 |
338516 | 338516 | 2020-07-16 | Union | Illinois | 17181 | 217 | 21 |
335320 | 335320 | 2020-07-15 | Union | Illinois | 17181 | 215 | 19 |
332127 | 332127 | 2020-07-14 | Union | Illinois | 17181 | 214 | 19 |
328940 | 328940 | 2020-07-13 | Union | Illinois | 17181 | 212 | 19 |
325754 | 325754 | 2020-07-12 | Union | Illinois | 17181 | 212 | 19 |
322573 | 322573 | 2020-07-11 | Union | Illinois | 17181 | 205 | 19 |
319394 | 319394 | 2020-07-10 | Union | Illinois | 17181 | 202 | 19 |
316221 | 316221 | 2020-07-09 | Union | Illinois | 17181 | 196 | 19 |
313047 | 313047 | 2020-07-08 | Union | Illinois | 17181 | 195 | 19 |
309877 | 309877 | 2020-07-07 | Union | Illinois | 17181 | 195 | 19 |
306709 | 306709 | 2020-07-06 | Union | Illinois | 17181 | 196 | 19 |
303544 | 303544 | 2020-07-05 | Union | Illinois | 17181 | 195 | 19 |
300380 | 300380 | 2020-07-04 | Union | Illinois | 17181 | 194 | 19 |
297218 | 297218 | 2020-07-03 | Union | Illinois | 17181 | 193 | 19 |
294060 | 294060 | 2020-07-02 | Union | Illinois | 17181 | 193 | 19 |
290906 | 290906 | 2020-07-01 | Union | Illinois | 17181 | 191 | 19 |
287756 | 287756 | 2020-06-30 | Union | Illinois | 17181 | 188 | 19 |
284607 | 284607 | 2020-06-29 | Union | Illinois | 17181 | 184 | 19 |
281462 | 281462 | 2020-06-28 | Union | Illinois | 17181 | 184 | 19 |
278314 | 278314 | 2020-06-27 | Union | Illinois | 17181 | 183 | 19 |
275166 | 275166 | 2020-06-26 | Union | Illinois | 17181 | 183 | 18 |
272024 | 272024 | 2020-06-25 | Union | Illinois | 17181 | 181 | 18 |
268887 | 268887 | 2020-06-24 | Union | Illinois | 17181 | 182 | 18 |
265757 | 265757 | 2020-06-23 | Union | Illinois | 17181 | 182 | 18 |
262629 | 262629 | 2020-06-22 | Union | Illinois | 17181 | 182 | 18 |
259502 | 259502 | 2020-06-21 | Union | Illinois | 17181 | 182 | 18 |
256376 | 256376 | 2020-06-20 | Union | Illinois | 17181 | 182 | 18 |
253256 | 253256 | 2020-06-19 | Union | Illinois | 17181 | 183 | 18 |
250141 | 250141 | 2020-06-18 | Union | Illinois | 17181 | 174 | 18 |
247029 | 247029 | 2020-06-17 | Union | Illinois | 17181 | 174 | 18 |
243916 | 243916 | 2020-06-16 | Union | Illinois | 17181 | 174 | 17 |
240805 | 240805 | 2020-06-15 | Union | Illinois | 17181 | 174 | 17 |
237697 | 237697 | 2020-06-14 | Union | Illinois | 17181 | 174 | 17 |
234590 | 234590 | 2020-06-13 | Union | Illinois | 17181 | 172 | 17 |
231484 | 231484 | 2020-06-12 | Union | Illinois | 17181 | 172 | 17 |
228381 | 228381 | 2020-06-11 | Union | Illinois | 17181 | 172 | 15 |
225279 | 225279 | 2020-06-10 | Union | Illinois | 17181 | 172 | 15 |
222184 | 222184 | 2020-06-09 | Union | Illinois | 17181 | 170 | 14 |
219089 | 219089 | 2020-06-08 | Union | Illinois | 17181 | 170 | 14 |
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);