ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2021-07-04 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1482644 | 1482644 | 2021-07-04 | Adams | Illinois | 17001 | 8840 | 156 |
1482645 | 1482645 | 2021-07-04 | Alexander | Illinois | 17003 | 476 | 11 |
1482646 | 1482646 | 2021-07-04 | Bond | Illinois | 17005 | 2091 | 30 |
1482647 | 1482647 | 2021-07-04 | Boone | Illinois | 17007 | 6850 | 91 |
1482648 | 1482648 | 2021-07-04 | Brown | Illinois | 17009 | 752 | 12 |
1482649 | 1482649 | 2021-07-04 | Bureau | Illinois | 17011 | 3794 | 98 |
1482650 | 1482650 | 2021-07-04 | Calhoun | Illinois | 17013 | 531 | 5 |
1482651 | 1482651 | 2021-07-04 | Carroll | Illinois | 17015 | 1788 | 38 |
1482652 | 1482652 | 2021-07-04 | Cass | Illinois | 17017 | 2050 | 36 |
1482653 | 1482653 | 2021-07-04 | Champaign | Illinois | 17019 | 21163 | 164 |
1482654 | 1482654 | 2021-07-04 | Christian | Illinois | 17021 | 3844 | 93 |
1482655 | 1482655 | 2021-07-04 | Clark | Illinois | 17023 | 1852 | 41 |
1482656 | 1482656 | 2021-07-04 | Clay | Illinois | 17025 | 1508 | 48 |
1482657 | 1482657 | 2021-07-04 | Clinton | Illinois | 17027 | 5798 | 100 |
1482658 | 1482658 | 2021-07-04 | Coles | Illinois | 17029 | 5779 | 103 |
1482659 | 1482659 | 2021-07-04 | Cook | Illinois | 17031 | 557173 | 11049 |
1482660 | 1482660 | 2021-07-04 | Crawford | Illinois | 17033 | 2145 | 41 |
1482661 | 1482661 | 2021-07-04 | Cumberland | Illinois | 17035 | 1304 | 31 |
1482662 | 1482662 | 2021-07-04 | De Witt | Illinois | 17039 | 1575 | 36 |
1482663 | 1482663 | 2021-07-04 | DeKalb | Illinois | 17037 | 10398 | 126 |
1482664 | 1482664 | 2021-07-04 | Douglas | Illinois | 17041 | 2610 | 42 |
1482665 | 1482665 | 2021-07-04 | DuPage | Illinois | 17043 | 92595 | 1405 |
1482666 | 1482666 | 2021-07-04 | Edgar | Illinois | 17045 | 1772 | 61 |
1482667 | 1482667 | 2021-07-04 | Edwards | Illinois | 17047 | 584 | 13 |
1482668 | 1482668 | 2021-07-04 | Effingham | Illinois | 17049 | 4774 | 85 |
1482669 | 1482669 | 2021-07-04 | Fayette | Illinois | 17051 | 3228 | 58 |
1482670 | 1482670 | 2021-07-04 | Ford | Illinois | 17053 | 1892 | 58 |
1482671 | 1482671 | 2021-07-04 | Franklin | Illinois | 17055 | 4555 | 90 |
1482672 | 1482672 | 2021-07-04 | Fulton | Illinois | 17057 | 4052 | 67 |
1482673 | 1482673 | 2021-07-04 | Gallatin | Illinois | 17059 | 470 | 5 |
1482674 | 1482674 | 2021-07-04 | Greene | Illinois | 17061 | 1457 | 47 |
1482675 | 1482675 | 2021-07-04 | Grundy | Illinois | 17063 | 5995 | 82 |
1482676 | 1482676 | 2021-07-04 | Hamilton | Illinois | 17065 | 847 | 19 |
1482677 | 1482677 | 2021-07-04 | Hancock | Illinois | 17067 | 1829 | 41 |
1482678 | 1482678 | 2021-07-04 | Hardin | Illinois | 17069 | 391 | 12 |
1482679 | 1482679 | 2021-07-04 | Henderson | Illinois | 17071 | 529 | 23 |
1482680 | 1482680 | 2021-07-04 | Henry | Illinois | 17073 | 5082 | 99 |
1482681 | 1482681 | 2021-07-04 | Iroquois | Illinois | 17075 | 3161 | 70 |
1482682 | 1482682 | 2021-07-04 | Jackson | Illinois | 17077 | 5123 | 76 |
1482683 | 1482683 | 2021-07-04 | Jasper | Illinois | 17079 | 1167 | 20 |
1482684 | 1482684 | 2021-07-04 | Jefferson | Illinois | 17081 | 4459 | 123 |
1482685 | 1482685 | 2021-07-04 | Jersey | Illinois | 17083 | 2725 | 71 |
1482686 | 1482686 | 2021-07-04 | Jo Daviess | Illinois | 17085 | 1830 | 27 |
1482687 | 1482687 | 2021-07-04 | Johnson | Illinois | 17087 | 1482 | 22 |
1482688 | 1482688 | 2021-07-04 | Kane | Illinois | 17089 | 59564 | 863 |
1482689 | 1482689 | 2021-07-04 | Kankakee | Illinois | 17091 | 14613 | 225 |
1482690 | 1482690 | 2021-07-04 | Kendall | Illinois | 17093 | 13912 | 108 |
1482691 | 1482691 | 2021-07-04 | Knox | Illinois | 17095 | 5666 | 187 |
1482692 | 1482692 | 2021-07-04 | LaSalle | Illinois | 17099 | 12802 | 307 |
1482693 | 1482693 | 2021-07-04 | Lake | Illinois | 17097 | 68466 | 1093 |
1482694 | 1482694 | 2021-07-04 | Lawrence | Illinois | 17101 | 2407 | 36 |
1482695 | 1482695 | 2021-07-04 | Lee | Illinois | 17103 | 4197 | 93 |
1482696 | 1482696 | 2021-07-04 | Livingston | Illinois | 17105 | 4908 | 104 |
1482697 | 1482697 | 2021-07-04 | Logan | Illinois | 17107 | 4009 | 77 |
1482698 | 1482698 | 2021-07-04 | Macon | Illinois | 17115 | 11018 | 222 |
1482699 | 1482699 | 2021-07-04 | Macoupin | Illinois | 17117 | 4812 | 118 |
1482700 | 1482700 | 2021-07-04 | Madison | Illinois | 17119 | 31180 | 605 |
1482701 | 1482701 | 2021-07-04 | Marion | Illinois | 17121 | 4546 | 123 |
1482702 | 1482702 | 2021-07-04 | Marshall | Illinois | 17123 | 1084 | 21 |
1482703 | 1482703 | 2021-07-04 | Mason | Illinois | 17125 | 1560 | 46 |
1482704 | 1482704 | 2021-07-04 | Massac | Illinois | 17127 | 1364 | 43 |
1482705 | 1482705 | 2021-07-04 | McDonough | Illinois | 17109 | 2954 | 63 |
1482706 | 1482706 | 2021-07-04 | McHenry | Illinois | 17111 | 29212 | 323 |
1482707 | 1482707 | 2021-07-04 | McLean | Illinois | 17113 | 18573 | 226 |
1482708 | 1482708 | 2021-07-04 | Menard | Illinois | 17129 | 1257 | 16 |
1482709 | 1482709 | 2021-07-04 | Mercer | Illinois | 17131 | 1500 | 34 |
1482710 | 1482710 | 2021-07-04 | Monroe | Illinois | 17133 | 4405 | 94 |
1482711 | 1482711 | 2021-07-04 | Montgomery | Illinois | 17135 | 3801 | 80 |
1482712 | 1482712 | 2021-07-04 | Morgan | Illinois | 17137 | 4076 | 105 |
1482713 | 1482713 | 2021-07-04 | Moultrie | Illinois | 17139 | 1637 | 36 |
1482714 | 1482714 | 2021-07-04 | Ogle | Illinois | 17141 | 6236 | 92 |
1482715 | 1482715 | 2021-07-04 | Peoria | Illinois | 17143 | 23588 | 369 |
1482716 | 1482716 | 2021-07-04 | Perry | Illinois | 17145 | 3204 | 69 |
1482717 | 1482717 | 2021-07-04 | Piatt | Illinois | 17147 | 1526 | 20 |
1482718 | 1482718 | 2021-07-04 | Pike | Illinois | 17149 | 1837 | 56 |
1482719 | 1482719 | 2021-07-04 | Pope | Illinois | 17151 | 332 | 4 |
1482720 | 1482720 | 2021-07-04 | Pulaski | Illinois | 17153 | 703 | 7 |
1482721 | 1482721 | 2021-07-04 | Putnam | Illinois | 17155 | 489 | 4 |
1482722 | 1482722 | 2021-07-04 | Randolph | Illinois | 17157 | 4175 | 93 |
1482723 | 1482723 | 2021-07-04 | Richland | Illinois | 17159 | 1769 | 49 |
1482724 | 1482724 | 2021-07-04 | Rock Island | Illinois | 17161 | 15260 | 372 |
1482725 | 1482725 | 2021-07-04 | Saline | Illinois | 17165 | 2613 | 73 |
1482726 | 1482726 | 2021-07-04 | Sangamon | Illinois | 17167 | 19165 | 281 |
1482727 | 1482727 | 2021-07-04 | Schuyler | Illinois | 17169 | 783 | 19 |
1482728 | 1482728 | 2021-07-04 | Scott | Illinois | 17171 | 492 | 1 |
1482729 | 1482729 | 2021-07-04 | Shelby | Illinois | 17173 | 2329 | 41 |
1482730 | 1482730 | 2021-07-04 | St. Clair | Illinois | 17163 | 31603 | 563 |
1482731 | 1482731 | 2021-07-04 | Stark | Illinois | 17175 | 648 | 24 |
1482732 | 1482732 | 2021-07-04 | Stephenson | Illinois | 17177 | 4842 | 105 |
1482733 | 1482733 | 2021-07-04 | Tazewell | Illinois | 17179 | 17257 | 340 |
1482734 | 1482734 | 2021-07-04 | Union | Illinois | 17181 | 2314 | 45 |
1482735 | 1482735 | 2021-07-04 | Unknown | Illinois | 0 | 429 | |
1482736 | 1482736 | 2021-07-04 | Vermilion | Illinois | 17183 | 10054 | 163 |
1482737 | 1482737 | 2021-07-04 | Wabash | Illinois | 17185 | 1380 | 15 |
1482738 | 1482738 | 2021-07-04 | Warren | Illinois | 17187 | 1848 | 52 |
1482739 | 1482739 | 2021-07-04 | Washington | Illinois | 17189 | 1651 | 31 |
1482740 | 1482740 | 2021-07-04 | Wayne | Illinois | 17191 | 1822 | 54 |
1482741 | 1482741 | 2021-07-04 | White | Illinois | 17193 | 1707 | 36 |
1482742 | 1482742 | 2021-07-04 | Whiteside | Illinois | 17195 | 7297 | 216 |
1482743 | 1482743 | 2021-07-04 | Will | Illinois | 17197 | 77081 | 1112 |
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);