ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79,502 rows where state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 17031 721
- 17089 675
- 17111 675
- 17097 674
- 17035 671
- 17043 671
- 17163 671
- 17167 671
- 17203 671
- 17027 670
- 17195 670
- 17201 670
- 17143 669
- 17197 669
- 17077 667
- 17091 667
- 17093 667
- 17099 667
- 17119 667
- 17189 667
- 17199 667
- 17001 665
- 17021 665
- 17113 665
- 17037 664
- 17019 663
- 17085 663
- 17105 663
- 17161 663
- 17177 663
- …
county >30
- Cook 721
- Kane 675
- McHenry 675
- Lake 674
- Cumberland 671
- DuPage 671
- Sangamon 671
- St. Clair 671
- Woodford 671
- Clinton 670
- Whiteside 670
- Winnebago 670
- Peoria 669
- Will 669
- Jackson 667
- Kankakee 667
- Kendall 667
- LaSalle 667
- Madison 667
- Washington 667
- Williamson 667
- Adams 665
- Christian 665
- McLean 665
- DeKalb 664
- Champaign 663
- Jo Daviess 663
- Livingston 663
- Rock Island 663
- Stephenson 663
- …
state 1
- Illinois · 67,142 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109731 | 2109731 | 2022-01-13 | Adams | Illinois | 17001 | 18513 | 210 |
2109732 | 2109732 | 2022-01-13 | Alexander | Illinois | 17003 | 982 | 13 |
2109733 | 2109733 | 2022-01-13 | Bond | Illinois | 17005 | 3549 | 34 |
2109734 | 2109734 | 2022-01-13 | Boone | Illinois | 17007 | 11255 | 107 |
2109735 | 2109735 | 2022-01-13 | Brown | Illinois | 17009 | 1380 | 19 |
2109736 | 2109736 | 2022-01-13 | Bureau | Illinois | 17011 | 6725 | 127 |
2109737 | 2109737 | 2022-01-13 | Calhoun | Illinois | 17013 | 1264 | 7 |
2109738 | 2109738 | 2022-01-13 | Carroll | Illinois | 17015 | 3316 | 43 |
2109739 | 2109739 | 2022-01-13 | Cass | Illinois | 17017 | 3748 | 41 |
2109740 | 2109740 | 2022-01-13 | Champaign | Illinois | 17019 | 48086 | 244 |
2109741 | 2109741 | 2022-01-13 | Christian | Illinois | 17021 | 8022 | 115 |
2109742 | 2109742 | 2022-01-13 | Clark | Illinois | 17023 | 3733 | 55 |
2109743 | 2109743 | 2022-01-13 | Clay | Illinois | 17025 | 3828 | 65 |
2109744 | 2109744 | 2022-01-13 | Clinton | Illinois | 17027 | 10035 | 117 |
2109745 | 2109745 | 2022-01-13 | Coles | Illinois | 17029 | 11942 | 149 |
2109746 | 2109746 | 2022-01-13 | Cook | Illinois | 17031 | 977558 | 13013 |
2109747 | 2109747 | 2022-01-13 | Crawford | Illinois | 17033 | 4365 | 53 |
2109748 | 2109748 | 2022-01-13 | Cumberland | Illinois | 17035 | 2651 | 43 |
2109749 | 2109749 | 2022-01-13 | De Witt | Illinois | 17039 | 3530 | 40 |
2109750 | 2109750 | 2022-01-13 | DeKalb | Illinois | 17037 | 18986 | 166 |
2109751 | 2109751 | 2022-01-13 | Douglas | Illinois | 17041 | 4909 | 49 |
2109752 | 2109752 | 2022-01-13 | DuPage | Illinois | 17043 | 172571 | 1585 |
2109753 | 2109753 | 2022-01-13 | Edgar | Illinois | 17045 | 3975 | 75 |
2109754 | 2109754 | 2022-01-13 | Edwards | Illinois | 17047 | 1394 | 24 |
2109755 | 2109755 | 2022-01-13 | Effingham | Illinois | 17049 | 8951 | 127 |
2109756 | 2109756 | 2022-01-13 | Fayette | Illinois | 17051 | 5737 | 81 |
2109757 | 2109757 | 2022-01-13 | Ford | Illinois | 17053 | 3680 | 70 |
2109758 | 2109758 | 2022-01-13 | Franklin | Illinois | 17055 | 9523 | 150 |
2109759 | 2109759 | 2022-01-13 | Fulton | Illinois | 17057 | 7910 | 109 |
2109760 | 2109760 | 2022-01-13 | Gallatin | Illinois | 17059 | 1016 | 11 |
2109761 | 2109761 | 2022-01-13 | Greene | Illinois | 17061 | 3054 | 53 |
2109762 | 2109762 | 2022-01-13 | Grundy | Illinois | 17063 | 11116 | 114 |
2109763 | 2109763 | 2022-01-13 | Hamilton | Illinois | 17065 | 1702 | 28 |
2109764 | 2109764 | 2022-01-13 | Hancock | Illinois | 17067 | 3598 | 50 |
2109765 | 2109765 | 2022-01-13 | Hardin | Illinois | 17069 | 844 | 18 |
2109766 | 2109766 | 2022-01-13 | Henderson | Illinois | 17071 | 960 | 24 |
2109767 | 2109767 | 2022-01-13 | Henry | Illinois | 17073 | 10209 | 128 |
2109768 | 2109768 | 2022-01-13 | Iroquois | Illinois | 17075 | 6126 | 95 |
2109769 | 2109769 | 2022-01-13 | Jackson | Illinois | 17077 | 11810 | 114 |
2109770 | 2109770 | 2022-01-13 | Jasper | Illinois | 17079 | 2176 | 26 |
2109771 | 2109771 | 2022-01-13 | Jefferson | Illinois | 17081 | 8530 | 155 |
2109772 | 2109772 | 2022-01-13 | Jersey | Illinois | 17083 | 5150 | 77 |
2109773 | 2109773 | 2022-01-13 | Jo Daviess | Illinois | 17085 | 3254 | 35 |
2109774 | 2109774 | 2022-01-13 | Johnson | Illinois | 17087 | 3025 | 43 |
2109775 | 2109775 | 2022-01-13 | Kane | Illinois | 17089 | 101893 | 1032 |
2109776 | 2109776 | 2022-01-13 | Kankakee | Illinois | 17091 | 25439 | 318 |
2109777 | 2109777 | 2022-01-13 | Kendall | Illinois | 17093 | 26023 | 139 |
2109778 | 2109778 | 2022-01-13 | Knox | Illinois | 17095 | 10649 | 218 |
2109779 | 2109779 | 2022-01-13 | LaSalle | Illinois | 17099 | 23569 | 390 |
2109780 | 2109780 | 2022-01-13 | Lake | Illinois | 17097 | 121134 | 1254 |
2109781 | 2109781 | 2022-01-13 | Lawrence | Illinois | 17101 | 4275 | 48 |
2109782 | 2109782 | 2022-01-13 | Lee | Illinois | 17103 | 7103 | 110 |
2109783 | 2109783 | 2022-01-13 | Livingston | Illinois | 17105 | 8712 | 129 |
2109784 | 2109784 | 2022-01-13 | Logan | Illinois | 17107 | 7624 | 91 |
2109785 | 2109785 | 2022-01-13 | Macon | Illinois | 17115 | 24446 | 299 |
2109786 | 2109786 | 2022-01-13 | Macoupin | Illinois | 17117 | 10183 | 154 |
2109787 | 2109787 | 2022-01-13 | Madison | Illinois | 17119 | 58730 | 750 |
2109788 | 2109788 | 2022-01-13 | Marion | Illinois | 17121 | 9657 | 180 |
2109789 | 2109789 | 2022-01-13 | Marshall | Illinois | 17123 | 2285 | 27 |
2109790 | 2109790 | 2022-01-13 | Mason | Illinois | 17125 | 3153 | 57 |
2109791 | 2109791 | 2022-01-13 | Massac | Illinois | 17127 | 2923 | 64 |
2109792 | 2109792 | 2022-01-13 | McDonough | Illinois | 17109 | 5397 | 86 |
2109793 | 2109793 | 2022-01-13 | McHenry | Illinois | 17111 | 55662 | 407 |
2109794 | 2109794 | 2022-01-13 | McLean | Illinois | 17113 | 39398 | 291 |
2109795 | 2109795 | 2022-01-13 | Menard | Illinois | 17129 | 2827 | 21 |
2109796 | 2109796 | 2022-01-13 | Mercer | Illinois | 17131 | 3222 | 38 |
2109797 | 2109797 | 2022-01-13 | Monroe | Illinois | 17133 | 7836 | 111 |
2109798 | 2109798 | 2022-01-13 | Montgomery | Illinois | 17135 | 7533 | 94 |
2109799 | 2109799 | 2022-01-13 | Morgan | Illinois | 17137 | 7329 | 126 |
2109800 | 2109800 | 2022-01-13 | Moultrie | Illinois | 17139 | 3367 | 48 |
2109801 | 2109801 | 2022-01-13 | Ogle | Illinois | 17141 | 11489 | 127 |
2109802 | 2109802 | 2022-01-13 | Peoria | Illinois | 17143 | 40275 | 486 |
2109803 | 2109803 | 2022-01-13 | Perry | Illinois | 17145 | 5501 | 96 |
2109804 | 2109804 | 2022-01-13 | Piatt | Illinois | 17147 | 3562 | 24 |
2109805 | 2109805 | 2022-01-13 | Pike | Illinois | 17149 | 4082 | 64 |
2109806 | 2109806 | 2022-01-13 | Pope | Illinois | 17151 | 769 | 7 |
2109807 | 2109807 | 2022-01-13 | Pulaski | Illinois | 17153 | 1358 | 15 |
2109808 | 2109808 | 2022-01-13 | Putnam | Illinois | 17155 | 918 | 8 |
2109809 | 2109809 | 2022-01-13 | Randolph | Illinois | 17157 | 7438 | 115 |
2109810 | 2109810 | 2022-01-13 | Richland | Illinois | 17159 | 3979 | 76 |
2109811 | 2109811 | 2022-01-13 | Rock Island | Illinois | 17161 | 27983 | 457 |
2109812 | 2109812 | 2022-01-13 | Saline | Illinois | 17165 | 5902 | 95 |
2109813 | 2109813 | 2022-01-13 | Sangamon | Illinois | 17167 | 43303 | 362 |
2109814 | 2109814 | 2022-01-13 | Schuyler | Illinois | 17169 | 1589 | 27 |
2109815 | 2109815 | 2022-01-13 | Scott | Illinois | 17171 | 1075 | 9 |
2109816 | 2109816 | 2022-01-13 | Shelby | Illinois | 17173 | 5031 | 63 |
2109817 | 2109817 | 2022-01-13 | St. Clair | Illinois | 17163 | 57808 | 700 |
2109818 | 2109818 | 2022-01-13 | Stark | Illinois | 17175 | 1182 | 30 |
2109819 | 2109819 | 2022-01-13 | Stephenson | Illinois | 17177 | 9473 | 153 |
2109820 | 2109820 | 2022-01-13 | Tazewell | Illinois | 17179 | 31161 | 435 |
2109821 | 2109821 | 2022-01-13 | Union | Illinois | 17181 | 4078 | 61 |
2109822 | 2109822 | 2022-01-13 | Unknown | Illinois | 0 | 1369 | |
2109823 | 2109823 | 2022-01-13 | Vermilion | Illinois | 17183 | 22635 | 264 |
2109824 | 2109824 | 2022-01-13 | Wabash | Illinois | 17185 | 2804 | 22 |
2109825 | 2109825 | 2022-01-13 | Warren | Illinois | 17187 | 3415 | 76 |
2109826 | 2109826 | 2022-01-13 | Washington | Illinois | 17189 | 2861 | 37 |
2109827 | 2109827 | 2022-01-13 | Wayne | Illinois | 17191 | 4012 | 70 |
2109828 | 2109828 | 2022-01-13 | White | Illinois | 17193 | 3504 | 45 |
2109829 | 2109829 | 2022-01-13 | Whiteside | Illinois | 17195 | 12388 | 245 |
2109830 | 2109830 | 2022-01-13 | Will | Illinois | 17197 | 140274 | 1370 |
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);