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 2020-04-30 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
101672 | 101672 | 2020-04-30 | Adams | Indiana | 18001 | 7 | 1 |
101673 | 101673 | 2020-04-30 | Allen | Indiana | 18003 | 565 | 55 |
101674 | 101674 | 2020-04-30 | Bartholomew | Indiana | 18005 | 253 | 15 |
101675 | 101675 | 2020-04-30 | Benton | Indiana | 18007 | 8 | 0 |
101676 | 101676 | 2020-04-30 | Blackford | Indiana | 18009 | 8 | 1 |
101677 | 101677 | 2020-04-30 | Boone | Indiana | 18011 | 194 | 23 |
101678 | 101678 | 2020-04-30 | Brown | Indiana | 18013 | 15 | 1 |
101679 | 101679 | 2020-04-30 | Carroll | Indiana | 18015 | 22 | 1 |
101680 | 101680 | 2020-04-30 | Cass | Indiana | 18017 | 1166 | 3 |
101681 | 101681 | 2020-04-30 | Clark | Indiana | 18019 | 295 | 16 |
101682 | 101682 | 2020-04-30 | Clay | Indiana | 18021 | 20 | 1 |
101683 | 101683 | 2020-04-30 | Clinton | Indiana | 18023 | 39 | 2 |
101684 | 101684 | 2020-04-30 | Crawford | Indiana | 18025 | 19 | 1 |
101685 | 101685 | 2020-04-30 | Daviess | Indiana | 18027 | 49 | 13 |
101686 | 101686 | 2020-04-30 | DeKalb | Indiana | 18033 | 21 | 2 |
101687 | 101687 | 2020-04-30 | Dearborn | Indiana | 18029 | 104 | 6 |
101688 | 101688 | 2020-04-30 | Decatur | Indiana | 18031 | 206 | 31 |
101689 | 101689 | 2020-04-30 | Delaware | Indiana | 18035 | 176 | 15 |
101690 | 101690 | 2020-04-30 | Dubois | Indiana | 18037 | 23 | 0 |
101691 | 101691 | 2020-04-30 | Elkhart | Indiana | 18039 | 287 | 7 |
101692 | 101692 | 2020-04-30 | Fayette | Indiana | 18041 | 36 | 4 |
101693 | 101693 | 2020-04-30 | Floyd | Indiana | 18043 | 179 | 17 |
101694 | 101694 | 2020-04-30 | Fountain | Indiana | 18045 | 11 | 2 |
101695 | 101695 | 2020-04-30 | Franklin | Indiana | 18047 | 98 | 7 |
101696 | 101696 | 2020-04-30 | Fulton | Indiana | 18049 | 27 | 1 |
101697 | 101697 | 2020-04-30 | Gibson | Indiana | 18051 | 7 | 0 |
101698 | 101698 | 2020-04-30 | Grant | Indiana | 18053 | 140 | 12 |
101699 | 101699 | 2020-04-30 | Greene | Indiana | 18055 | 59 | 8 |
101700 | 101700 | 2020-04-30 | Hamilton | Indiana | 18057 | 762 | 64 |
101701 | 101701 | 2020-04-30 | Hancock | Indiana | 18059 | 220 | 11 |
101702 | 101702 | 2020-04-30 | Harrison | Indiana | 18061 | 130 | 9 |
101703 | 101703 | 2020-04-30 | Hendricks | Indiana | 18063 | 681 | 42 |
101704 | 101704 | 2020-04-30 | Henry | Indiana | 18065 | 40 | 1 |
101705 | 101705 | 2020-04-30 | Howard | Indiana | 18067 | 173 | 6 |
101706 | 101706 | 2020-04-30 | Huntington | Indiana | 18069 | 9 | 2 |
101707 | 101707 | 2020-04-30 | Jackson | Indiana | 18071 | 139 | 1 |
101708 | 101708 | 2020-04-30 | Jasper | Indiana | 18073 | 34 | 1 |
101709 | 101709 | 2020-04-30 | Jay | Indiana | 18075 | 16 | 0 |
101710 | 101710 | 2020-04-30 | Jefferson | Indiana | 18077 | 27 | 0 |
101711 | 101711 | 2020-04-30 | Jennings | Indiana | 18079 | 77 | 4 |
101712 | 101712 | 2020-04-30 | Johnson | Indiana | 18081 | 588 | 67 |
101713 | 101713 | 2020-04-30 | Knox | Indiana | 18083 | 20 | 0 |
101714 | 101714 | 2020-04-30 | Kosciusko | Indiana | 18085 | 35 | 2 |
101715 | 101715 | 2020-04-30 | LaGrange | Indiana | 18087 | 25 | 2 |
101716 | 101716 | 2020-04-30 | LaPorte | Indiana | 18091 | 218 | 5 |
101717 | 101717 | 2020-04-30 | Lake | Indiana | 18089 | 1866 | 90 |
101718 | 101718 | 2020-04-30 | Lawrence | Indiana | 18093 | 100 | 14 |
101719 | 101719 | 2020-04-30 | Madison | Indiana | 18095 | 428 | 56 |
101720 | 101720 | 2020-04-30 | Marion | Indiana | 18097 | 5576 | 353 |
101721 | 101721 | 2020-04-30 | Marshall | Indiana | 18099 | 29 | 1 |
101722 | 101722 | 2020-04-30 | Martin | Indiana | 18101 | 7 | 0 |
101723 | 101723 | 2020-04-30 | Miami | Indiana | 18103 | 105 | 0 |
101724 | 101724 | 2020-04-30 | Monroe | Indiana | 18105 | 123 | 8 |
101725 | 101725 | 2020-04-30 | Montgomery | Indiana | 18107 | 67 | 0 |
101726 | 101726 | 2020-04-30 | Morgan | Indiana | 18109 | 155 | 5 |
101727 | 101727 | 2020-04-30 | Newton | Indiana | 18111 | 48 | 7 |
101728 | 101728 | 2020-04-30 | Noble | Indiana | 18113 | 70 | 13 |
101729 | 101729 | 2020-04-30 | Ohio | Indiana | 18115 | 4 | 0 |
101730 | 101730 | 2020-04-30 | Orange | Indiana | 18117 | 76 | 9 |
101731 | 101731 | 2020-04-30 | Owen | Indiana | 18119 | 23 | 1 |
101732 | 101732 | 2020-04-30 | Parke | Indiana | 18121 | 12 | 0 |
101733 | 101733 | 2020-04-30 | Perry | Indiana | 18123 | 15 | 0 |
101734 | 101734 | 2020-04-30 | Pike | Indiana | 18125 | 1 | 0 |
101735 | 101735 | 2020-04-30 | Porter | Indiana | 18127 | 243 | 8 |
101736 | 101736 | 2020-04-30 | Posey | Indiana | 18129 | 11 | 0 |
101737 | 101737 | 2020-04-30 | Pulaski | Indiana | 18131 | 23 | 0 |
101738 | 101738 | 2020-04-30 | Putnam | Indiana | 18133 | 70 | 4 |
101739 | 101739 | 2020-04-30 | Randolph | Indiana | 18135 | 21 | 2 |
101740 | 101740 | 2020-04-30 | Ripley | Indiana | 18137 | 92 | 5 |
101741 | 101741 | 2020-04-30 | Rush | Indiana | 18139 | 37 | 1 |
101742 | 101742 | 2020-04-30 | Scott | Indiana | 18143 | 46 | 2 |
101743 | 101743 | 2020-04-30 | Shelby | Indiana | 18145 | 217 | 19 |
101744 | 101744 | 2020-04-30 | Spencer | Indiana | 18147 | 8 | 0 |
101745 | 101745 | 2020-04-30 | St. Joseph | Indiana | 18141 | 640 | 22 |
101746 | 101746 | 2020-04-30 | Starke | Indiana | 18149 | 17 | 1 |
101747 | 101747 | 2020-04-30 | Steuben | Indiana | 18151 | 23 | 1 |
101748 | 101748 | 2020-04-30 | Sullivan | Indiana | 18153 | 16 | 0 |
101749 | 101749 | 2020-04-30 | Switzerland | Indiana | 18155 | 16 | 0 |
101750 | 101750 | 2020-04-30 | Tippecanoe | Indiana | 18157 | 110 | 2 |
101751 | 101751 | 2020-04-30 | Tipton | Indiana | 18159 | 18 | 1 |
101752 | 101752 | 2020-04-30 | Union | Indiana | 18161 | 10 | 0 |
101753 | 101753 | 2020-04-30 | Vanderburgh | Indiana | 18163 | 135 | 1 |
101754 | 101754 | 2020-04-30 | Vermillion | Indiana | 18165 | 8 | 0 |
101755 | 101755 | 2020-04-30 | Vigo | Indiana | 18167 | 64 | 6 |
101756 | 101756 | 2020-04-30 | Wabash | Indiana | 18169 | 42 | 1 |
101757 | 101757 | 2020-04-30 | Warren | Indiana | 18171 | 11 | 1 |
101758 | 101758 | 2020-04-30 | Warrick | Indiana | 18173 | 96 | 14 |
101759 | 101759 | 2020-04-30 | Washington | Indiana | 18175 | 43 | 0 |
101760 | 101760 | 2020-04-30 | Wayne | Indiana | 18177 | 78 | 3 |
101761 | 101761 | 2020-04-30 | Wells | Indiana | 18179 | 5 | 0 |
101762 | 101762 | 2020-04-30 | White | Indiana | 18181 | 47 | 0 |
101763 | 101763 | 2020-04-30 | Whitley | Indiana | 18183 | 19 | 1 |
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);