ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Jefferson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947041 | 947041 | 2021-01-20 | Jefferson | Illinois | 17081 | 3470 | 104 |
943794 | 943794 | 2021-01-19 | Jefferson | Illinois | 17081 | 3435 | 104 |
940549 | 940549 | 2021-01-18 | Jefferson | Illinois | 17081 | 3421 | 104 |
937304 | 937304 | 2021-01-17 | Jefferson | Illinois | 17081 | 3409 | 104 |
934059 | 934059 | 2021-01-16 | Jefferson | Illinois | 17081 | 3392 | 104 |
930814 | 930814 | 2021-01-15 | Jefferson | Illinois | 17081 | 3356 | 102 |
927569 | 927569 | 2021-01-14 | Jefferson | Illinois | 17081 | 3329 | 100 |
924323 | 924323 | 2021-01-13 | Jefferson | Illinois | 17081 | 3303 | 99 |
921078 | 921078 | 2021-01-12 | Jefferson | Illinois | 17081 | 3258 | 97 |
917833 | 917833 | 2021-01-11 | Jefferson | Illinois | 17081 | 3243 | 96 |
914588 | 914588 | 2021-01-10 | Jefferson | Illinois | 17081 | 3209 | 95 |
911343 | 911343 | 2021-01-09 | Jefferson | Illinois | 17081 | 3167 | 95 |
908098 | 908098 | 2021-01-08 | Jefferson | Illinois | 17081 | 3140 | 94 |
904852 | 904852 | 2021-01-07 | Jefferson | Illinois | 17081 | 3094 | 93 |
901607 | 901607 | 2021-01-06 | Jefferson | Illinois | 17081 | 3072 | 90 |
898362 | 898362 | 2021-01-05 | Jefferson | Illinois | 17081 | 3036 | 87 |
895117 | 895117 | 2021-01-04 | Jefferson | Illinois | 17081 | 3008 | 87 |
891870 | 891870 | 2021-01-03 | Jefferson | Illinois | 17081 | 2995 | 87 |
888623 | 888623 | 2021-01-02 | Jefferson | Illinois | 17081 | 2977 | 86 |
885378 | 885378 | 2021-01-01 | Jefferson | Illinois | 17081 | 2926 | 82 |
882133 | 882133 | 2020-12-31 | Jefferson | Illinois | 17081 | 2926 | 82 |
878888 | 878888 | 2020-12-30 | Jefferson | Illinois | 17081 | 2899 | 80 |
875643 | 875643 | 2020-12-29 | Jefferson | Illinois | 17081 | 2873 | 79 |
872398 | 872398 | 2020-12-28 | Jefferson | Illinois | 17081 | 2850 | 76 |
869153 | 869153 | 2020-12-27 | Jefferson | Illinois | 17081 | 2826 | 74 |
865908 | 865908 | 2020-12-26 | Jefferson | Illinois | 17081 | 2802 | 74 |
862663 | 862663 | 2020-12-25 | Jefferson | Illinois | 17081 | 2796 | 73 |
859418 | 859418 | 2020-12-24 | Jefferson | Illinois | 17081 | 2764 | 73 |
856173 | 856173 | 2020-12-23 | Jefferson | Illinois | 17081 | 2732 | 73 |
852928 | 852928 | 2020-12-22 | Jefferson | Illinois | 17081 | 2684 | 72 |
849683 | 849683 | 2020-12-21 | Jefferson | Illinois | 17081 | 2656 | 72 |
846438 | 846438 | 2020-12-20 | Jefferson | Illinois | 17081 | 2629 | 72 |
843192 | 843192 | 2020-12-19 | Jefferson | Illinois | 17081 | 2590 | 72 |
839947 | 839947 | 2020-12-18 | Jefferson | Illinois | 17081 | 2555 | 72 |
836702 | 836702 | 2020-12-17 | Jefferson | Illinois | 17081 | 2517 | 69 |
833456 | 833456 | 2020-12-16 | Jefferson | Illinois | 17081 | 2465 | 69 |
830209 | 830209 | 2020-12-15 | Jefferson | Illinois | 17081 | 2429 | 66 |
826963 | 826963 | 2020-12-14 | Jefferson | Illinois | 17081 | 2375 | 66 |
823716 | 823716 | 2020-12-13 | Jefferson | Illinois | 17081 | 2368 | 66 |
820470 | 820470 | 2020-12-12 | Jefferson | Illinois | 17081 | 2348 | 66 |
817224 | 817224 | 2020-12-11 | Jefferson | Illinois | 17081 | 2312 | 66 |
813978 | 813978 | 2020-12-10 | Jefferson | Illinois | 17081 | 2267 | 65 |
810733 | 810733 | 2020-12-09 | Jefferson | Illinois | 17081 | 2230 | 65 |
807488 | 807488 | 2020-12-08 | Jefferson | Illinois | 17081 | 2187 | 63 |
804243 | 804243 | 2020-12-07 | Jefferson | Illinois | 17081 | 2150 | 63 |
800998 | 800998 | 2020-12-06 | Jefferson | Illinois | 17081 | 2122 | 63 |
797753 | 797753 | 2020-12-05 | Jefferson | Illinois | 17081 | 2095 | 63 |
794508 | 794508 | 2020-12-04 | Jefferson | Illinois | 17081 | 2063 | 63 |
791263 | 791263 | 2020-12-03 | Jefferson | Illinois | 17081 | 2026 | 63 |
788018 | 788018 | 2020-12-02 | Jefferson | Illinois | 17081 | 1991 | 62 |
784774 | 784774 | 2020-12-01 | Jefferson | Illinois | 17081 | 1941 | 59 |
781529 | 781529 | 2020-11-30 | Jefferson | Illinois | 17081 | 1908 | 59 |
778283 | 778283 | 2020-11-29 | Jefferson | Illinois | 17081 | 1878 | 59 |
775038 | 775038 | 2020-11-28 | Jefferson | Illinois | 17081 | 1851 | 59 |
771793 | 771793 | 2020-11-27 | Jefferson | Illinois | 17081 | 1831 | 59 |
768548 | 768548 | 2020-11-26 | Jefferson | Illinois | 17081 | 1809 | 59 |
765302 | 765302 | 2020-11-25 | Jefferson | Illinois | 17081 | 1754 | 59 |
762057 | 762057 | 2020-11-24 | Jefferson | Illinois | 17081 | 1708 | 59 |
758812 | 758812 | 2020-11-23 | Jefferson | Illinois | 17081 | 1685 | 58 |
755565 | 755565 | 2020-11-22 | Jefferson | Illinois | 17081 | 1673 | 58 |
752319 | 752319 | 2020-11-21 | Jefferson | Illinois | 17081 | 1619 | 57 |
749073 | 749073 | 2020-11-20 | Jefferson | Illinois | 17081 | 1590 | 57 |
745827 | 745827 | 2020-11-19 | Jefferson | Illinois | 17081 | 1562 | 57 |
742580 | 742580 | 2020-11-18 | Jefferson | Illinois | 17081 | 1530 | 57 |
739333 | 739333 | 2020-11-17 | Jefferson | Illinois | 17081 | 1501 | 57 |
736089 | 736089 | 2020-11-16 | Jefferson | Illinois | 17081 | 1463 | 56 |
732843 | 732843 | 2020-11-15 | Jefferson | Illinois | 17081 | 1433 | 56 |
729598 | 729598 | 2020-11-14 | Jefferson | Illinois | 17081 | 1405 | 56 |
726355 | 726355 | 2020-11-13 | Jefferson | Illinois | 17081 | 1370 | 56 |
723112 | 723112 | 2020-11-12 | Jefferson | Illinois | 17081 | 1339 | 56 |
719869 | 719869 | 2020-11-11 | Jefferson | Illinois | 17081 | 1322 | 56 |
716626 | 716626 | 2020-11-10 | Jefferson | Illinois | 17081 | 1277 | 55 |
713382 | 713382 | 2020-11-09 | Jefferson | Illinois | 17081 | 1239 | 55 |
710138 | 710138 | 2020-11-08 | Jefferson | Illinois | 17081 | 1215 | 55 |
706894 | 706894 | 2020-11-07 | Jefferson | Illinois | 17081 | 1177 | 55 |
703651 | 703651 | 2020-11-06 | Jefferson | Illinois | 17081 | 1150 | 52 |
700408 | 700408 | 2020-11-05 | Jefferson | Illinois | 17081 | 1092 | 52 |
697164 | 697164 | 2020-11-04 | Jefferson | Illinois | 17081 | 1052 | 52 |
693922 | 693922 | 2020-11-03 | Jefferson | Illinois | 17081 | 1036 | 52 |
690679 | 690679 | 2020-11-02 | Jefferson | Illinois | 17081 | 1024 | 52 |
687434 | 687434 | 2020-11-01 | Jefferson | Illinois | 17081 | 1017 | 52 |
684190 | 684190 | 2020-10-31 | Jefferson | Illinois | 17081 | 973 | 52 |
680947 | 680947 | 2020-10-30 | Jefferson | Illinois | 17081 | 973 | 52 |
677704 | 677704 | 2020-10-29 | Jefferson | Illinois | 17081 | 939 | 52 |
674461 | 674461 | 2020-10-28 | Jefferson | Illinois | 17081 | 920 | 52 |
671219 | 671219 | 2020-10-27 | Jefferson | Illinois | 17081 | 911 | 49 |
667976 | 667976 | 2020-10-26 | Jefferson | Illinois | 17081 | 907 | 48 |
664732 | 664732 | 2020-10-25 | Jefferson | Illinois | 17081 | 905 | 48 |
661487 | 661487 | 2020-10-24 | Jefferson | Illinois | 17081 | 893 | 48 |
658243 | 658243 | 2020-10-23 | Jefferson | Illinois | 17081 | 894 | 46 |
654998 | 654998 | 2020-10-22 | Jefferson | Illinois | 17081 | 888 | 45 |
651753 | 651753 | 2020-10-21 | Jefferson | Illinois | 17081 | 886 | 44 |
648509 | 648509 | 2020-10-20 | Jefferson | Illinois | 17081 | 867 | 44 |
645264 | 645264 | 2020-10-19 | Jefferson | Illinois | 17081 | 858 | 44 |
642017 | 642017 | 2020-10-18 | Jefferson | Illinois | 17081 | 852 | 44 |
638770 | 638770 | 2020-10-17 | Jefferson | Illinois | 17081 | 847 | 44 |
635524 | 635524 | 2020-10-16 | Jefferson | Illinois | 17081 | 840 | 43 |
632278 | 632278 | 2020-10-15 | Jefferson | Illinois | 17081 | 834 | 41 |
629034 | 629034 | 2020-10-14 | Jefferson | Illinois | 17081 | 804 | 40 |
625791 | 625791 | 2020-10-13 | Jefferson | Illinois | 17081 | 796 | 39 |
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);