ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17085 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930816 | 930816 | 2021-01-15 | Jo Daviess | Illinois | 17085 | 1474 | 24 |
927571 | 927571 | 2021-01-14 | Jo Daviess | Illinois | 17085 | 1467 | 24 |
924325 | 924325 | 2021-01-13 | Jo Daviess | Illinois | 17085 | 1459 | 24 |
921080 | 921080 | 2021-01-12 | Jo Daviess | Illinois | 17085 | 1450 | 24 |
917835 | 917835 | 2021-01-11 | Jo Daviess | Illinois | 17085 | 1432 | 24 |
914590 | 914590 | 2021-01-10 | Jo Daviess | Illinois | 17085 | 1430 | 24 |
911345 | 911345 | 2021-01-09 | Jo Daviess | Illinois | 17085 | 1429 | 24 |
908100 | 908100 | 2021-01-08 | Jo Daviess | Illinois | 17085 | 1420 | 24 |
904854 | 904854 | 2021-01-07 | Jo Daviess | Illinois | 17085 | 1412 | 24 |
901609 | 901609 | 2021-01-06 | Jo Daviess | Illinois | 17085 | 1405 | 24 |
898364 | 898364 | 2021-01-05 | Jo Daviess | Illinois | 17085 | 1398 | 24 |
895119 | 895119 | 2021-01-04 | Jo Daviess | Illinois | 17085 | 1394 | 24 |
891872 | 891872 | 2021-01-03 | Jo Daviess | Illinois | 17085 | 1392 | 24 |
888625 | 888625 | 2021-01-02 | Jo Daviess | Illinois | 17085 | 1390 | 24 |
885380 | 885380 | 2021-01-01 | Jo Daviess | Illinois | 17085 | 1388 | 24 |
882135 | 882135 | 2020-12-31 | Jo Daviess | Illinois | 17085 | 1388 | 24 |
878890 | 878890 | 2020-12-30 | Jo Daviess | Illinois | 17085 | 1382 | 24 |
875645 | 875645 | 2020-12-29 | Jo Daviess | Illinois | 17085 | 1376 | 24 |
872400 | 872400 | 2020-12-28 | Jo Daviess | Illinois | 17085 | 1371 | 24 |
869155 | 869155 | 2020-12-27 | Jo Daviess | Illinois | 17085 | 1368 | 24 |
865910 | 865910 | 2020-12-26 | Jo Daviess | Illinois | 17085 | 1363 | 24 |
862665 | 862665 | 2020-12-25 | Jo Daviess | Illinois | 17085 | 1362 | 24 |
859420 | 859420 | 2020-12-24 | Jo Daviess | Illinois | 17085 | 1360 | 24 |
856175 | 856175 | 2020-12-23 | Jo Daviess | Illinois | 17085 | 1358 | 24 |
852930 | 852930 | 2020-12-22 | Jo Daviess | Illinois | 17085 | 1341 | 24 |
849685 | 849685 | 2020-12-21 | Jo Daviess | Illinois | 17085 | 1335 | 24 |
846440 | 846440 | 2020-12-20 | Jo Daviess | Illinois | 17085 | 1333 | 24 |
843194 | 843194 | 2020-12-19 | Jo Daviess | Illinois | 17085 | 1325 | 24 |
839949 | 839949 | 2020-12-18 | Jo Daviess | Illinois | 17085 | 1304 | 24 |
836704 | 836704 | 2020-12-17 | Jo Daviess | Illinois | 17085 | 1276 | 24 |
833458 | 833458 | 2020-12-16 | Jo Daviess | Illinois | 17085 | 1263 | 24 |
830211 | 830211 | 2020-12-15 | Jo Daviess | Illinois | 17085 | 1258 | 24 |
826965 | 826965 | 2020-12-14 | Jo Daviess | Illinois | 17085 | 1248 | 23 |
823718 | 823718 | 2020-12-13 | Jo Daviess | Illinois | 17085 | 1241 | 23 |
820472 | 820472 | 2020-12-12 | Jo Daviess | Illinois | 17085 | 1237 | 23 |
817226 | 817226 | 2020-12-11 | Jo Daviess | Illinois | 17085 | 1215 | 23 |
813980 | 813980 | 2020-12-10 | Jo Daviess | Illinois | 17085 | 1204 | 23 |
810735 | 810735 | 2020-12-09 | Jo Daviess | Illinois | 17085 | 1196 | 21 |
807490 | 807490 | 2020-12-08 | Jo Daviess | Illinois | 17085 | 1183 | 21 |
804245 | 804245 | 2020-12-07 | Jo Daviess | Illinois | 17085 | 1179 | 21 |
801000 | 801000 | 2020-12-06 | Jo Daviess | Illinois | 17085 | 1175 | 21 |
797755 | 797755 | 2020-12-05 | Jo Daviess | Illinois | 17085 | 1166 | 20 |
794510 | 794510 | 2020-12-04 | Jo Daviess | Illinois | 17085 | 1149 | 20 |
791265 | 791265 | 2020-12-03 | Jo Daviess | Illinois | 17085 | 1138 | 20 |
788020 | 788020 | 2020-12-02 | Jo Daviess | Illinois | 17085 | 1123 | 20 |
784776 | 784776 | 2020-12-01 | Jo Daviess | Illinois | 17085 | 1094 | 18 |
781531 | 781531 | 2020-11-30 | Jo Daviess | Illinois | 17085 | 1083 | 17 |
778285 | 778285 | 2020-11-29 | Jo Daviess | Illinois | 17085 | 1076 | 17 |
775040 | 775040 | 2020-11-28 | Jo Daviess | Illinois | 17085 | 1065 | 17 |
771795 | 771795 | 2020-11-27 | Jo Daviess | Illinois | 17085 | 1062 | 17 |
768550 | 768550 | 2020-11-26 | Jo Daviess | Illinois | 17085 | 1049 | 17 |
765304 | 765304 | 2020-11-25 | Jo Daviess | Illinois | 17085 | 1038 | 17 |
762059 | 762059 | 2020-11-24 | Jo Daviess | Illinois | 17085 | 1018 | 16 |
758814 | 758814 | 2020-11-23 | Jo Daviess | Illinois | 17085 | 1010 | 16 |
755567 | 755567 | 2020-11-22 | Jo Daviess | Illinois | 17085 | 989 | 16 |
752321 | 752321 | 2020-11-21 | Jo Daviess | Illinois | 17085 | 958 | 16 |
749075 | 749075 | 2020-11-20 | Jo Daviess | Illinois | 17085 | 949 | 15 |
745829 | 745829 | 2020-11-19 | Jo Daviess | Illinois | 17085 | 933 | 15 |
742582 | 742582 | 2020-11-18 | Jo Daviess | Illinois | 17085 | 920 | 14 |
739335 | 739335 | 2020-11-17 | Jo Daviess | Illinois | 17085 | 909 | 14 |
736091 | 736091 | 2020-11-16 | Jo Daviess | Illinois | 17085 | 899 | 12 |
732845 | 732845 | 2020-11-15 | Jo Daviess | Illinois | 17085 | 870 | 12 |
729600 | 729600 | 2020-11-14 | Jo Daviess | Illinois | 17085 | 858 | 12 |
726357 | 726357 | 2020-11-13 | Jo Daviess | Illinois | 17085 | 857 | 12 |
723114 | 723114 | 2020-11-12 | Jo Daviess | Illinois | 17085 | 823 | 11 |
719871 | 719871 | 2020-11-11 | Jo Daviess | Illinois | 17085 | 780 | 11 |
716628 | 716628 | 2020-11-10 | Jo Daviess | Illinois | 17085 | 757 | 11 |
713384 | 713384 | 2020-11-09 | Jo Daviess | Illinois | 17085 | 701 | 11 |
710140 | 710140 | 2020-11-08 | Jo Daviess | Illinois | 17085 | 689 | 11 |
706896 | 706896 | 2020-11-07 | Jo Daviess | Illinois | 17085 | 676 | 11 |
703653 | 703653 | 2020-11-06 | Jo Daviess | Illinois | 17085 | 649 | 11 |
700410 | 700410 | 2020-11-05 | Jo Daviess | Illinois | 17085 | 624 | 11 |
697166 | 697166 | 2020-11-04 | Jo Daviess | Illinois | 17085 | 617 | 10 |
693924 | 693924 | 2020-11-03 | Jo Daviess | Illinois | 17085 | 604 | 9 |
690681 | 690681 | 2020-11-02 | Jo Daviess | Illinois | 17085 | 606 | 9 |
687436 | 687436 | 2020-11-01 | Jo Daviess | Illinois | 17085 | 584 | 9 |
684192 | 684192 | 2020-10-31 | Jo Daviess | Illinois | 17085 | 556 | 9 |
680949 | 680949 | 2020-10-30 | Jo Daviess | Illinois | 17085 | 556 | 9 |
677706 | 677706 | 2020-10-29 | Jo Daviess | Illinois | 17085 | 547 | 9 |
674463 | 674463 | 2020-10-28 | Jo Daviess | Illinois | 17085 | 536 | 9 |
671221 | 671221 | 2020-10-27 | Jo Daviess | Illinois | 17085 | 518 | 9 |
667978 | 667978 | 2020-10-26 | Jo Daviess | Illinois | 17085 | 512 | 7 |
664734 | 664734 | 2020-10-25 | Jo Daviess | Illinois | 17085 | 498 | 7 |
661489 | 661489 | 2020-10-24 | Jo Daviess | Illinois | 17085 | 486 | 7 |
658245 | 658245 | 2020-10-23 | Jo Daviess | Illinois | 17085 | 472 | 7 |
655000 | 655000 | 2020-10-22 | Jo Daviess | Illinois | 17085 | 461 | 7 |
651755 | 651755 | 2020-10-21 | Jo Daviess | Illinois | 17085 | 446 | 7 |
648511 | 648511 | 2020-10-20 | Jo Daviess | Illinois | 17085 | 436 | 7 |
645266 | 645266 | 2020-10-19 | Jo Daviess | Illinois | 17085 | 427 | 5 |
642019 | 642019 | 2020-10-18 | Jo Daviess | Illinois | 17085 | 416 | 5 |
638772 | 638772 | 2020-10-17 | Jo Daviess | Illinois | 17085 | 401 | 5 |
635526 | 635526 | 2020-10-16 | Jo Daviess | Illinois | 17085 | 392 | 5 |
632280 | 632280 | 2020-10-15 | Jo Daviess | Illinois | 17085 | 381 | 3 |
629036 | 629036 | 2020-10-14 | Jo Daviess | Illinois | 17085 | 374 | 3 |
625793 | 625793 | 2020-10-13 | Jo Daviess | Illinois | 17085 | 369 | 2 |
622551 | 622551 | 2020-10-12 | Jo Daviess | Illinois | 17085 | 360 | 2 |
619307 | 619307 | 2020-10-11 | Jo Daviess | Illinois | 17085 | 357 | 2 |
616065 | 616065 | 2020-10-10 | Jo Daviess | Illinois | 17085 | 333 | 2 |
612824 | 612824 | 2020-10-09 | Jo Daviess | Illinois | 17085 | 326 | 2 |
609582 | 609582 | 2020-10-08 | Jo Daviess | Illinois | 17085 | 312 | 2 |
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);