ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Jackson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635522 | 635522 | 2020-10-16 | Jackson | Illinois | 17077 | 1410 | 25 |
632276 | 632276 | 2020-10-15 | Jackson | Illinois | 17077 | 1392 | 25 |
629032 | 629032 | 2020-10-14 | Jackson | Illinois | 17077 | 1367 | 24 |
625789 | 625789 | 2020-10-13 | Jackson | Illinois | 17077 | 1356 | 24 |
622547 | 622547 | 2020-10-12 | Jackson | Illinois | 17077 | 1354 | 24 |
619303 | 619303 | 2020-10-11 | Jackson | Illinois | 17077 | 1352 | 24 |
616061 | 616061 | 2020-10-10 | Jackson | Illinois | 17077 | 1345 | 24 |
612820 | 612820 | 2020-10-09 | Jackson | Illinois | 17077 | 1333 | 24 |
609578 | 609578 | 2020-10-08 | Jackson | Illinois | 17077 | 1327 | 24 |
606335 | 606335 | 2020-10-07 | Jackson | Illinois | 17077 | 1312 | 24 |
603093 | 603093 | 2020-10-06 | Jackson | Illinois | 17077 | 1302 | 24 |
599850 | 599850 | 2020-10-05 | Jackson | Illinois | 17077 | 1296 | 24 |
596608 | 596608 | 2020-10-04 | Jackson | Illinois | 17077 | 1296 | 24 |
593366 | 593366 | 2020-10-03 | Jackson | Illinois | 17077 | 1292 | 24 |
590125 | 590125 | 2020-10-02 | Jackson | Illinois | 17077 | 1290 | 24 |
586884 | 586884 | 2020-10-01 | Jackson | Illinois | 17077 | 1281 | 24 |
583644 | 583644 | 2020-09-30 | Jackson | Illinois | 17077 | 1276 | 25 |
580405 | 580405 | 2020-09-29 | Jackson | Illinois | 17077 | 1267 | 24 |
577164 | 577164 | 2020-09-28 | Jackson | Illinois | 17077 | 1262 | 24 |
573922 | 573922 | 2020-09-27 | Jackson | Illinois | 17077 | 1261 | 24 |
570679 | 570679 | 2020-09-26 | Jackson | Illinois | 17077 | 1259 | 24 |
567437 | 567437 | 2020-09-25 | Jackson | Illinois | 17077 | 1257 | 24 |
564197 | 564197 | 2020-09-24 | Jackson | Illinois | 17077 | 1250 | 24 |
560957 | 560957 | 2020-09-23 | Jackson | Illinois | 17077 | 1248 | 24 |
557721 | 557721 | 2020-09-22 | Jackson | Illinois | 17077 | 1242 | 24 |
554484 | 554484 | 2020-09-21 | Jackson | Illinois | 17077 | 1241 | 24 |
551245 | 551245 | 2020-09-20 | Jackson | Illinois | 17077 | 1236 | 24 |
548006 | 548006 | 2020-09-19 | Jackson | Illinois | 17077 | 1225 | 24 |
544768 | 544768 | 2020-09-18 | Jackson | Illinois | 17077 | 1220 | 24 |
541532 | 541532 | 2020-09-17 | Jackson | Illinois | 17077 | 1186 | 24 |
538295 | 538295 | 2020-09-16 | Jackson | Illinois | 17077 | 1174 | 24 |
535059 | 535059 | 2020-09-15 | Jackson | Illinois | 17077 | 1169 | 24 |
531824 | 531824 | 2020-09-14 | Jackson | Illinois | 17077 | 1159 | 24 |
528587 | 528587 | 2020-09-13 | Jackson | Illinois | 17077 | 1144 | 24 |
525351 | 525351 | 2020-09-12 | Jackson | Illinois | 17077 | 1135 | 24 |
522115 | 522115 | 2020-09-11 | Jackson | Illinois | 17077 | 1120 | 24 |
518878 | 518878 | 2020-09-10 | Jackson | Illinois | 17077 | 1103 | 25 |
515643 | 515643 | 2020-09-09 | Jackson | Illinois | 17077 | 1086 | 24 |
512410 | 512410 | 2020-09-08 | Jackson | Illinois | 17077 | 1072 | 23 |
509177 | 509177 | 2020-09-07 | Jackson | Illinois | 17077 | 1067 | 22 |
505945 | 505945 | 2020-09-06 | Jackson | Illinois | 17077 | 1061 | 22 |
502711 | 502711 | 2020-09-05 | Jackson | Illinois | 17077 | 1043 | 22 |
499477 | 499477 | 2020-09-04 | Jackson | Illinois | 17077 | 1021 | 22 |
496244 | 496244 | 2020-09-03 | Jackson | Illinois | 17077 | 984 | 22 |
493010 | 493010 | 2020-09-02 | Jackson | Illinois | 17077 | 973 | 22 |
489777 | 489777 | 2020-09-01 | Jackson | Illinois | 17077 | 951 | 22 |
486544 | 486544 | 2020-08-31 | Jackson | Illinois | 17077 | 929 | 21 |
483309 | 483309 | 2020-08-30 | Jackson | Illinois | 17077 | 915 | 21 |
480075 | 480075 | 2020-08-29 | Jackson | Illinois | 17077 | 909 | 21 |
476842 | 476842 | 2020-08-28 | Jackson | Illinois | 17077 | 895 | 20 |
473609 | 473609 | 2020-08-27 | Jackson | Illinois | 17077 | 892 | 20 |
470377 | 470377 | 2020-08-26 | Jackson | Illinois | 17077 | 877 | 20 |
467148 | 467148 | 2020-08-25 | Jackson | Illinois | 17077 | 862 | 20 |
463919 | 463919 | 2020-08-24 | Jackson | Illinois | 17077 | 851 | 20 |
460690 | 460690 | 2020-08-23 | Jackson | Illinois | 17077 | 835 | 20 |
457463 | 457463 | 2020-08-22 | Jackson | Illinois | 17077 | 828 | 20 |
454235 | 454235 | 2020-08-21 | Jackson | Illinois | 17077 | 824 | 20 |
451007 | 451007 | 2020-08-20 | Jackson | Illinois | 17077 | 814 | 20 |
447779 | 447779 | 2020-08-19 | Jackson | Illinois | 17077 | 807 | 20 |
444552 | 444552 | 2020-08-18 | Jackson | Illinois | 17077 | 796 | 20 |
441326 | 441326 | 2020-08-17 | Jackson | Illinois | 17077 | 778 | 20 |
438100 | 438100 | 2020-08-16 | Jackson | Illinois | 17077 | 772 | 20 |
434874 | 434874 | 2020-08-15 | Jackson | Illinois | 17077 | 760 | 20 |
431649 | 431649 | 2020-08-14 | Jackson | Illinois | 17077 | 755 | 20 |
428421 | 428421 | 2020-08-13 | Jackson | Illinois | 17077 | 743 | 20 |
425197 | 425197 | 2020-08-12 | Jackson | Illinois | 17077 | 740 | 20 |
421976 | 421976 | 2020-08-11 | Jackson | Illinois | 17077 | 731 | 20 |
418753 | 418753 | 2020-08-10 | Jackson | Illinois | 17077 | 722 | 19 |
415532 | 415532 | 2020-08-09 | Jackson | Illinois | 17077 | 717 | 19 |
412312 | 412312 | 2020-08-08 | Jackson | Illinois | 17077 | 708 | 19 |
409093 | 409093 | 2020-08-07 | Jackson | Illinois | 17077 | 695 | 19 |
405873 | 405873 | 2020-08-06 | Jackson | Illinois | 17077 | 685 | 19 |
402655 | 402655 | 2020-08-05 | Jackson | Illinois | 17077 | 676 | 19 |
399439 | 399439 | 2020-08-04 | Jackson | Illinois | 17077 | 658 | 19 |
396223 | 396223 | 2020-08-03 | Jackson | Illinois | 17077 | 650 | 19 |
393007 | 393007 | 2020-08-02 | Jackson | Illinois | 17077 | 644 | 19 |
389790 | 389790 | 2020-08-01 | Jackson | Illinois | 17077 | 631 | 19 |
386573 | 386573 | 2020-07-31 | Jackson | Illinois | 17077 | 616 | 19 |
383355 | 383355 | 2020-07-30 | Jackson | Illinois | 17077 | 591 | 19 |
380138 | 380138 | 2020-07-29 | Jackson | Illinois | 17077 | 572 | 19 |
376921 | 376921 | 2020-07-28 | Jackson | Illinois | 17077 | 556 | 19 |
373706 | 373706 | 2020-07-27 | Jackson | Illinois | 17077 | 544 | 19 |
370494 | 370494 | 2020-07-26 | Jackson | Illinois | 17077 | 530 | 19 |
367284 | 367284 | 2020-07-25 | Jackson | Illinois | 17077 | 487 | 19 |
364077 | 364077 | 2020-07-24 | Jackson | Illinois | 17077 | 463 | 19 |
360870 | 360870 | 2020-07-23 | Jackson | Illinois | 17077 | 450 | 19 |
357665 | 357665 | 2020-07-22 | Jackson | Illinois | 17077 | 434 | 19 |
354463 | 354463 | 2020-07-21 | Jackson | Illinois | 17077 | 420 | 19 |
351261 | 351261 | 2020-07-20 | Jackson | Illinois | 17077 | 420 | 19 |
348061 | 348061 | 2020-07-19 | Jackson | Illinois | 17077 | 400 | 19 |
344860 | 344860 | 2020-07-18 | Jackson | Illinois | 17077 | 389 | 19 |
341660 | 341660 | 2020-07-17 | Jackson | Illinois | 17077 | 381 | 19 |
338464 | 338464 | 2020-07-16 | Jackson | Illinois | 17077 | 373 | 19 |
335268 | 335268 | 2020-07-15 | Jackson | Illinois | 17077 | 366 | 19 |
332075 | 332075 | 2020-07-14 | Jackson | Illinois | 17077 | 359 | 19 |
328888 | 328888 | 2020-07-13 | Jackson | Illinois | 17077 | 357 | 19 |
325702 | 325702 | 2020-07-12 | Jackson | Illinois | 17077 | 356 | 19 |
322521 | 322521 | 2020-07-11 | Jackson | Illinois | 17077 | 351 | 19 |
319342 | 319342 | 2020-07-10 | Jackson | Illinois | 17077 | 347 | 19 |
316169 | 316169 | 2020-07-09 | Jackson | Illinois | 17077 | 345 | 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);