ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where "date" is on date 2021-05-20 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1336685 | 1336685 | 2021-05-20 | Adams | Indiana | 18001 | 3497 | 56 |
1336686 | 1336686 | 2021-05-20 | Allen | Indiana | 18003 | 41152 | 704 |
1336687 | 1336687 | 2021-05-20 | Bartholomew | Indiana | 18005 | 8131 | 161 |
1336688 | 1336688 | 2021-05-20 | Benton | Indiana | 18007 | 991 | 14 |
1336689 | 1336689 | 2021-05-20 | Blackford | Indiana | 18009 | 1365 | 32 |
1336690 | 1336690 | 2021-05-20 | Boone | Indiana | 18011 | 6785 | 105 |
1336691 | 1336691 | 2021-05-20 | Brown | Indiana | 18013 | 1029 | 41 |
1336692 | 1336692 | 2021-05-20 | Carroll | Indiana | 18015 | 1914 | 22 |
1336693 | 1336693 | 2021-05-20 | Cass | Indiana | 18017 | 5901 | 108 |
1336694 | 1336694 | 2021-05-20 | Clark | Indiana | 18019 | 13081 | 201 |
1336695 | 1336695 | 2021-05-20 | Clay | Indiana | 18021 | 2616 | 47 |
1336696 | 1336696 | 2021-05-20 | Clinton | Indiana | 18023 | 4305 | 58 |
1336697 | 1336697 | 2021-05-20 | Crawford | Indiana | 18025 | 1015 | 16 |
1336698 | 1336698 | 2021-05-20 | Daviess | Indiana | 18027 | 2988 | 101 |
1336699 | 1336699 | 2021-05-20 | DeKalb | Indiana | 18033 | 4329 | 88 |
1336700 | 1336700 | 2021-05-20 | Dearborn | Indiana | 18029 | 5853 | 81 |
1336701 | 1336701 | 2021-05-20 | Decatur | Indiana | 18031 | 2922 | 96 |
1336702 | 1336702 | 2021-05-20 | Delaware | Indiana | 18035 | 10805 | 196 |
1336703 | 1336703 | 2021-05-20 | Dubois | Indiana | 18037 | 6174 | 118 |
1336704 | 1336704 | 2021-05-20 | Elkhart | Indiana | 18039 | 29043 | 459 |
1336705 | 1336705 | 2021-05-20 | Fayette | Indiana | 18041 | 2963 | 65 |
1336706 | 1336706 | 2021-05-20 | Floyd | Indiana | 18043 | 7708 | 183 |
1336707 | 1336707 | 2021-05-20 | Fountain | Indiana | 18045 | 2149 | 47 |
1336708 | 1336708 | 2021-05-20 | Franklin | Indiana | 18047 | 1705 | 36 |
1336709 | 1336709 | 2021-05-20 | Fulton | Indiana | 18049 | 1966 | 40 |
1336710 | 1336710 | 2021-05-20 | Gibson | Indiana | 18051 | 4395 | 95 |
1336711 | 1336711 | 2021-05-20 | Grant | Indiana | 18053 | 7534 | 181 |
1336712 | 1336712 | 2021-05-20 | Greene | Indiana | 18055 | 2821 | 89 |
1336713 | 1336713 | 2021-05-20 | Hamilton | Indiana | 18057 | 35970 | 428 |
1336714 | 1336714 | 2021-05-20 | Hancock | Indiana | 18059 | 8415 | 146 |
1336715 | 1336715 | 2021-05-20 | Harrison | Indiana | 18061 | 4376 | 75 |
1336716 | 1336716 | 2021-05-20 | Hendricks | Indiana | 18063 | 17425 | 336 |
1336717 | 1336717 | 2021-05-20 | Henry | Indiana | 18065 | 5819 | 107 |
1336718 | 1336718 | 2021-05-20 | Howard | Indiana | 18067 | 10056 | 224 |
1336719 | 1336719 | 2021-05-20 | Huntington | Indiana | 18069 | 3969 | 82 |
1336720 | 1336720 | 2021-05-20 | Jackson | Indiana | 18071 | 5049 | 74 |
1336721 | 1336721 | 2021-05-20 | Jasper | Indiana | 18073 | 3758 | 53 |
1336722 | 1336722 | 2021-05-20 | Jay | Indiana | 18075 | 1997 | 32 |
1336723 | 1336723 | 2021-05-20 | Jefferson | Indiana | 18077 | 3322 | 83 |
1336724 | 1336724 | 2021-05-20 | Jennings | Indiana | 18079 | 2320 | 51 |
1336725 | 1336725 | 2021-05-20 | Johnson | Indiana | 18081 | 18180 | 397 |
1336726 | 1336726 | 2021-05-20 | Knox | Indiana | 18083 | 3738 | 90 |
1336727 | 1336727 | 2021-05-20 | Kosciusko | Indiana | 18085 | 9519 | 121 |
1336728 | 1336728 | 2021-05-20 | LaGrange | Indiana | 18087 | 2704 | 72 |
1336729 | 1336729 | 2021-05-20 | LaPorte | Indiana | 18091 | 12159 | 218 |
1336730 | 1336730 | 2021-05-20 | Lake | Indiana | 18089 | 54531 | 1029 |
1336731 | 1336731 | 2021-05-20 | Lawrence | Indiana | 18093 | 4624 | 123 |
1336732 | 1336732 | 2021-05-20 | Madison | Indiana | 18095 | 12825 | 359 |
1336733 | 1336733 | 2021-05-20 | Marion | Indiana | 18097 | 101243 | 1817 |
1336734 | 1336734 | 2021-05-20 | Marshall | Indiana | 18099 | 6133 | 114 |
1336735 | 1336735 | 2021-05-20 | Martin | Indiana | 18101 | 898 | 15 |
1336736 | 1336736 | 2021-05-20 | Miami | Indiana | 18103 | 3861 | 69 |
1336737 | 1336737 | 2021-05-20 | Monroe | Indiana | 18105 | 11996 | 174 |
1336738 | 1336738 | 2021-05-20 | Montgomery | Indiana | 18107 | 4269 | 91 |
1336739 | 1336739 | 2021-05-20 | Morgan | Indiana | 18109 | 6642 | 145 |
1336740 | 1336740 | 2021-05-20 | Newton | Indiana | 18111 | 1098 | 37 |
1336741 | 1336741 | 2021-05-20 | Noble | Indiana | 18113 | 5692 | 87 |
1336742 | 1336742 | 2021-05-20 | Ohio | Indiana | 18115 | 574 | 11 |
1336743 | 1336743 | 2021-05-20 | Orange | Indiana | 18117 | 1863 | 57 |
1336744 | 1336744 | 2021-05-20 | Owen | Indiana | 18119 | 2048 | 58 |
1336745 | 1336745 | 2021-05-20 | Parke | Indiana | 18121 | 1482 | 16 |
1336746 | 1336746 | 2021-05-20 | Perry | Indiana | 18123 | 1858 | 38 |
1336747 | 1336747 | 2021-05-20 | Pike | Indiana | 18125 | 1359 | 34 |
1336748 | 1336748 | 2021-05-20 | Porter | Indiana | 18127 | 19026 | 325 |
1336749 | 1336749 | 2021-05-20 | Posey | Indiana | 18129 | 2723 | 34 |
1336750 | 1336750 | 2021-05-20 | Pulaski | Indiana | 18131 | 1178 | 46 |
1336751 | 1336751 | 2021-05-20 | Putnam | Indiana | 18133 | 3659 | 60 |
1336752 | 1336752 | 2021-05-20 | Randolph | Indiana | 18135 | 2466 | 82 |
1336753 | 1336753 | 2021-05-20 | Ripley | Indiana | 18137 | 3416 | 70 |
1336754 | 1336754 | 2021-05-20 | Rush | Indiana | 18139 | 1812 | 25 |
1336755 | 1336755 | 2021-05-20 | Scott | Indiana | 18143 | 2683 | 57 |
1336756 | 1336756 | 2021-05-20 | Shelby | Indiana | 18145 | 5943 | 106 |
1336757 | 1336757 | 2021-05-20 | Spencer | Indiana | 18147 | 2333 | 31 |
1336758 | 1336758 | 2021-05-20 | St. Joseph | Indiana | 18141 | 36480 | 572 |
1336759 | 1336759 | 2021-05-20 | Starke | Indiana | 18149 | 2203 | 57 |
1336760 | 1336760 | 2021-05-20 | Steuben | Indiana | 18151 | 3933 | 59 |
1336761 | 1336761 | 2021-05-20 | Sullivan | Indiana | 18153 | 2127 | 42 |
1336762 | 1336762 | 2021-05-20 | Switzerland | Indiana | 18155 | 795 | 8 |
1336763 | 1336763 | 2021-05-20 | Tippecanoe | Indiana | 18157 | 22540 | 222 |
1336764 | 1336764 | 2021-05-20 | Tipton | Indiana | 18159 | 1639 | 47 |
1336765 | 1336765 | 2021-05-20 | Union | Indiana | 18161 | 746 | 11 |
1336766 | 1336766 | 2021-05-20 | Vanderburgh | Indiana | 18163 | 22412 | 402 |
1336767 | 1336767 | 2021-05-20 | Vermillion | Indiana | 18165 | 1708 | 44 |
1336768 | 1336768 | 2021-05-20 | Vigo | Indiana | 18167 | 12530 | 255 |
1336769 | 1336769 | 2021-05-20 | Wabash | Indiana | 18169 | 3566 | 81 |
1336770 | 1336770 | 2021-05-20 | Warren | Indiana | 18171 | 828 | 16 |
1336771 | 1336771 | 2021-05-20 | Warrick | Indiana | 18173 | 7811 | 158 |
1336772 | 1336772 | 2021-05-20 | Washington | Indiana | 18175 | 2425 | 33 |
1336773 | 1336773 | 2021-05-20 | Wayne | Indiana | 18177 | 7471 | 203 |
1336774 | 1336774 | 2021-05-20 | Wells | Indiana | 18179 | 2953 | 83 |
1336775 | 1336775 | 2021-05-20 | White | Indiana | 18181 | 3189 | 54 |
1336776 | 1336776 | 2021-05-20 | Whitley | Indiana | 18183 | 4002 | 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);