ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where county = "Union" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635574 | 635574 | 2020-10-16 | Union | Illinois | 17181 | 713 | 25 |
632328 | 632328 | 2020-10-15 | Union | Illinois | 17181 | 695 | 25 |
629084 | 629084 | 2020-10-14 | Union | Illinois | 17181 | 683 | 25 |
625841 | 625841 | 2020-10-13 | Union | Illinois | 17181 | 668 | 25 |
622599 | 622599 | 2020-10-12 | Union | Illinois | 17181 | 659 | 25 |
619355 | 619355 | 2020-10-11 | Union | Illinois | 17181 | 657 | 25 |
616113 | 616113 | 2020-10-10 | Union | Illinois | 17181 | 642 | 25 |
612872 | 612872 | 2020-10-09 | Union | Illinois | 17181 | 618 | 24 |
609630 | 609630 | 2020-10-08 | Union | Illinois | 17181 | 607 | 24 |
606387 | 606387 | 2020-10-07 | Union | Illinois | 17181 | 597 | 24 |
603145 | 603145 | 2020-10-06 | Union | Illinois | 17181 | 585 | 24 |
599902 | 599902 | 2020-10-05 | Union | Illinois | 17181 | 554 | 24 |
596660 | 596660 | 2020-10-04 | Union | Illinois | 17181 | 548 | 24 |
593418 | 593418 | 2020-10-03 | Union | Illinois | 17181 | 535 | 24 |
590177 | 590177 | 2020-10-02 | Union | Illinois | 17181 | 534 | 24 |
586936 | 586936 | 2020-10-01 | Union | Illinois | 17181 | 530 | 24 |
583696 | 583696 | 2020-09-30 | Union | Illinois | 17181 | 524 | 24 |
580457 | 580457 | 2020-09-29 | Union | Illinois | 17181 | 520 | 24 |
577216 | 577216 | 2020-09-28 | Union | Illinois | 17181 | 515 | 24 |
573974 | 573974 | 2020-09-27 | Union | Illinois | 17181 | 515 | 24 |
570731 | 570731 | 2020-09-26 | Union | Illinois | 17181 | 514 | 24 |
567489 | 567489 | 2020-09-25 | Union | Illinois | 17181 | 514 | 24 |
564249 | 564249 | 2020-09-24 | Union | Illinois | 17181 | 507 | 24 |
561009 | 561009 | 2020-09-23 | Union | Illinois | 17181 | 507 | 24 |
557773 | 557773 | 2020-09-22 | Union | Illinois | 17181 | 497 | 24 |
554536 | 554536 | 2020-09-21 | Union | Illinois | 17181 | 496 | 24 |
551297 | 551297 | 2020-09-20 | Union | Illinois | 17181 | 496 | 24 |
548058 | 548058 | 2020-09-19 | Union | Illinois | 17181 | 495 | 24 |
544820 | 544820 | 2020-09-18 | Union | Illinois | 17181 | 493 | 24 |
541584 | 541584 | 2020-09-17 | Union | Illinois | 17181 | 486 | 24 |
538347 | 538347 | 2020-09-16 | Union | Illinois | 17181 | 476 | 24 |
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 |
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);