ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

103 rows where date = "2022-01-05" and state = "Illinois" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Illinois · 103 ✖
Link rowid date ▲ county state fips cases deaths
2083720 2083720 2022-01-05 Adams Illinois 17001 16939 201
2083721 2083721 2022-01-05 Alexander Illinois 17003 915 13
2083722 2083722 2022-01-05 Bond Illinois 17005 3181 34
2083723 2083723 2022-01-05 Boone Illinois 17007 10374 105
2083724 2083724 2022-01-05 Brown Illinois 17009 1247 19
2083725 2083725 2022-01-05 Bureau Illinois 17011 6035 124
2083726 2083726 2022-01-05 Calhoun Illinois 17013 1073 7
2083727 2083727 2022-01-05 Carroll Illinois 17015 3086 43
2083728 2083728 2022-01-05 Cass Illinois 17017 3296 40
2083729 2083729 2022-01-05 Champaign Illinois 17019 41580 235
2083730 2083730 2022-01-05 Christian Illinois 17021 7051 110
2083731 2083731 2022-01-05 Clark Illinois 17023 3374 54
2083732 2083732 2022-01-05 Clay Illinois 17025 3518 64
2083733 2083733 2022-01-05 Clinton Illinois 17027 8840 117
2083734 2083734 2022-01-05 Coles Illinois 17029 10249 148
2083735 2083735 2022-01-05 Cook Illinois 17031 883180 12686
2083736 2083736 2022-01-05 Crawford Illinois 17033 3983 51
2083737 2083737 2022-01-05 Cumberland Illinois 17035 2418 42
2083738 2083738 2022-01-05 De Witt Illinois 17039 3118 39
2083739 2083739 2022-01-05 DeKalb Illinois 17037 17392 163
2083740 2083740 2022-01-05 Douglas Illinois 17041 4404 46
2083741 2083741 2022-01-05 DuPage Illinois 17043 153713 1542
2083742 2083742 2022-01-05 Edgar Illinois 17045 3600 74
2083743 2083743 2022-01-05 Edwards Illinois 17047 1301 23
2083744 2083744 2022-01-05 Effingham Illinois 17049 8217 124
2083745 2083745 2022-01-05 Fayette Illinois 17051 5339 76
2083746 2083746 2022-01-05 Ford Illinois 17053 3314 67
2083747 2083747 2022-01-05 Franklin Illinois 17055 8835 145
2083748 2083748 2022-01-05 Fulton Illinois 17057 7103 103
2083749 2083749 2022-01-05 Gallatin Illinois 17059 940 11
2083750 2083750 2022-01-05 Greene Illinois 17061 2704 53
2083751 2083751 2022-01-05 Grundy Illinois 17063 10302 107
2083752 2083752 2022-01-05 Hamilton Illinois 17065 1583 28
2083753 2083753 2022-01-05 Hancock Illinois 17067 3430 47
2083754 2083754 2022-01-05 Hardin Illinois 17069 790 17
2083755 2083755 2022-01-05 Henderson Illinois 17071 913 24
2083756 2083756 2022-01-05 Henry Illinois 17073 9145 124
2083757 2083757 2022-01-05 Iroquois Illinois 17075 5671 93
2083758 2083758 2022-01-05 Jackson Illinois 17077 10274 113
2083759 2083759 2022-01-05 Jasper Illinois 17079 2009 25
2083760 2083760 2022-01-05 Jefferson Illinois 17081 7829 152
2083761 2083761 2022-01-05 Jersey Illinois 17083 4561 76
2083762 2083762 2022-01-05 Jo Daviess Illinois 17085 3007 35
2083763 2083763 2022-01-05 Johnson Illinois 17087 2851 40
2083764 2083764 2022-01-05 Kane Illinois 17089 91844 1006
2083765 2083765 2022-01-05 Kankakee Illinois 17091 23676 305
2083766 2083766 2022-01-05 Kendall Illinois 17093 23429 136
2083767 2083767 2022-01-05 Knox Illinois 17095 9340 215
2083768 2083768 2022-01-05 LaSalle Illinois 17099 20374 380
2083769 2083769 2022-01-05 Lake Illinois 17097 107841 1227
2083770 2083770 2022-01-05 Lawrence Illinois 17101 3964 47
2083771 2083771 2022-01-05 Lee Illinois 17103 6240 108
2083772 2083772 2022-01-05 Livingston Illinois 17105 7665 127
2083773 2083773 2022-01-05 Logan Illinois 17107 6498 91
2083774 2083774 2022-01-05 Macon Illinois 17115 20954 289
2083775 2083775 2022-01-05 Macoupin Illinois 17117 8951 151
2083776 2083776 2022-01-05 Madison Illinois 17119 51465 729
2083777 2083777 2022-01-05 Marion Illinois 17121 8799 173
2083778 2083778 2022-01-05 Marshall Illinois 17123 2056 26
2083779 2083779 2022-01-05 Mason Illinois 17125 2819 55
2083780 2083780 2022-01-05 Massac Illinois 17127 2724 62
2083781 2083781 2022-01-05 McDonough Illinois 17109 4960 84
2083782 2083782 2022-01-05 McHenry Illinois 17111 49832 397
2083783 2083783 2022-01-05 McLean Illinois 17113 32943 282
2083784 2083784 2022-01-05 Menard Illinois 17129 2437 19
2083785 2083785 2022-01-05 Mercer Illinois 17131 2943 38
2083786 2083786 2022-01-05 Monroe Illinois 17133 6752 109
2083787 2083787 2022-01-05 Montgomery Illinois 17135 6502 94
2083788 2083788 2022-01-05 Morgan Illinois 17137 6359 125
2083789 2083789 2022-01-05 Moultrie Illinois 17139 3058 47
2083790 2083790 2022-01-05 Ogle Illinois 17141 10463 122
2083791 2083791 2022-01-05 Peoria Illinois 17143 36771 458
2083792 2083792 2022-01-05 Perry Illinois 17145 5095 93
2083793 2083793 2022-01-05 Piatt Illinois 17147 3141 22
2083794 2083794 2022-01-05 Pike Illinois 17149 3735 62
2083795 2083795 2022-01-05 Pope Illinois 17151 721 7
2083796 2083796 2022-01-05 Pulaski Illinois 17153 1240 15
2083797 2083797 2022-01-05 Putnam Illinois 17155 843 8
2083798 2083798 2022-01-05 Randolph Illinois 17157 6687 113
2083799 2083799 2022-01-05 Richland Illinois 17159 3588 76
2083800 2083800 2022-01-05 Rock Island Illinois 17161 25366 454
2083801 2083801 2022-01-05 Saline Illinois 17165 5237 93
2083802 2083802 2022-01-05 Sangamon Illinois 17167 36448 356
2083803 2083803 2022-01-05 Schuyler Illinois 17169 1377 26
2083804 2083804 2022-01-05 Scott Illinois 17171 957 9
2083805 2083805 2022-01-05 Shelby Illinois 17173 4585 61
2083806 2083806 2022-01-05 St. Clair Illinois 17163 51562 693
2083807 2083807 2022-01-05 Stark Illinois 17175 1051 30
2083808 2083808 2022-01-05 Stephenson Illinois 17177 8598 146
2083809 2083809 2022-01-05 Tazewell Illinois 17179 28428 422
2083810 2083810 2022-01-05 Union Illinois 17181 3759 58
2083811 2083811 2022-01-05 Unknown Illinois   0 1224
2083812 2083812 2022-01-05 Vermilion Illinois 17183 19992 262
2083813 2083813 2022-01-05 Wabash Illinois 17185 2526 22
2083814 2083814 2022-01-05 Warren Illinois 17187 3122 75
2083815 2083815 2022-01-05 Washington Illinois 17189 2596 37
2083816 2083816 2022-01-05 Wayne Illinois 17191 3701 68
2083817 2083817 2022-01-05 White Illinois 17193 3238 45
2083818 2083818 2022-01-05 Whiteside Illinois 17195 10979 238
2083819 2083819 2022-01-05 Will Illinois 17197 127147 1326

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);