ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-04-24" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
84700 | 84700 | 2020-04-24 | Adams | Indiana | 18001 | 7 | 1 |
84701 | 84701 | 2020-04-24 | Allen | Indiana | 18003 | 405 | 29 |
84702 | 84702 | 2020-04-24 | Bartholomew | Indiana | 18005 | 178 | 11 |
84703 | 84703 | 2020-04-24 | Benton | Indiana | 18007 | 5 | 0 |
84704 | 84704 | 2020-04-24 | Blackford | Indiana | 18009 | 7 | 1 |
84705 | 84705 | 2020-04-24 | Boone | Indiana | 18011 | 181 | 22 |
84706 | 84706 | 2020-04-24 | Brown | Indiana | 18013 | 15 | 1 |
84707 | 84707 | 2020-04-24 | Carroll | Indiana | 18015 | 8 | 1 |
84708 | 84708 | 2020-04-24 | Cass | Indiana | 18017 | 256 | 2 |
84709 | 84709 | 2020-04-24 | Clark | Indiana | 18019 | 209 | 13 |
84710 | 84710 | 2020-04-24 | Clay | Indiana | 18021 | 19 | 1 |
84711 | 84711 | 2020-04-24 | Clinton | Indiana | 18023 | 27 | 2 |
84712 | 84712 | 2020-04-24 | Crawford | Indiana | 18025 | 17 | 1 |
84713 | 84713 | 2020-04-24 | Daviess | Indiana | 18027 | 43 | 9 |
84714 | 84714 | 2020-04-24 | DeKalb | Indiana | 18033 | 15 | 2 |
84715 | 84715 | 2020-04-24 | Dearborn | Indiana | 18029 | 77 | 5 |
84716 | 84716 | 2020-04-24 | Decatur | Indiana | 18031 | 195 | 27 |
84717 | 84717 | 2020-04-24 | Delaware | Indiana | 18035 | 132 | 11 |
84718 | 84718 | 2020-04-24 | Dubois | Indiana | 18037 | 17 | 0 |
84719 | 84719 | 2020-04-24 | Elkhart | Indiana | 18039 | 211 | 4 |
84720 | 84720 | 2020-04-24 | Fayette | Indiana | 18041 | 28 | 4 |
84721 | 84721 | 2020-04-24 | Floyd | Indiana | 18043 | 163 | 11 |
84722 | 84722 | 2020-04-24 | Fountain | Indiana | 18045 | 9 | 2 |
84723 | 84723 | 2020-04-24 | Franklin | Indiana | 18047 | 92 | 7 |
84724 | 84724 | 2020-04-24 | Fulton | Indiana | 18049 | 7 | 0 |
84725 | 84725 | 2020-04-24 | Gibson | Indiana | 18051 | 6 | 0 |
84726 | 84726 | 2020-04-24 | Grant | Indiana | 18053 | 119 | 8 |
84727 | 84727 | 2020-04-24 | Greene | Indiana | 18055 | 46 | 5 |
84728 | 84728 | 2020-04-24 | Hamilton | Indiana | 18057 | 675 | 46 |
84729 | 84729 | 2020-04-24 | Hancock | Indiana | 18059 | 172 | 8 |
84730 | 84730 | 2020-04-24 | Harrison | Indiana | 18061 | 112 | 5 |
84731 | 84731 | 2020-04-24 | Hendricks | Indiana | 18063 | 594 | 34 |
84732 | 84732 | 2020-04-24 | Henry | Indiana | 18065 | 32 | 1 |
84733 | 84733 | 2020-04-24 | Howard | Indiana | 18067 | 82 | 5 |
84734 | 84734 | 2020-04-24 | Huntington | Indiana | 18069 | 6 | 2 |
84735 | 84735 | 2020-04-24 | Jackson | Indiana | 18071 | 102 | 0 |
84736 | 84736 | 2020-04-24 | Jasper | Indiana | 18073 | 35 | 1 |
84737 | 84737 | 2020-04-24 | Jay | Indiana | 18075 | 11 | 0 |
84738 | 84738 | 2020-04-24 | Jefferson | Indiana | 18077 | 23 | 0 |
84739 | 84739 | 2020-04-24 | Jennings | Indiana | 18079 | 70 | 3 |
84740 | 84740 | 2020-04-24 | Johnson | Indiana | 18081 | 516 | 53 |
84741 | 84741 | 2020-04-24 | Knox | Indiana | 18083 | 19 | 0 |
84742 | 84742 | 2020-04-24 | Kosciusko | Indiana | 18085 | 26 | 2 |
84743 | 84743 | 2020-04-24 | LaGrange | Indiana | 18087 | 19 | 1 |
84744 | 84744 | 2020-04-24 | LaPorte | Indiana | 18091 | 149 | 5 |
84745 | 84745 | 2020-04-24 | Lake | Indiana | 18089 | 1457 | 71 |
84746 | 84746 | 2020-04-24 | Lawrence | Indiana | 18093 | 88 | 10 |
84747 | 84747 | 2020-04-24 | Madison | Indiana | 18095 | 388 | 50 |
84748 | 84748 | 2020-04-24 | Marion | Indiana | 18097 | 4571 | 266 |
84749 | 84749 | 2020-04-24 | Marshall | Indiana | 18099 | 25 | 1 |
84750 | 84750 | 2020-04-24 | Martin | Indiana | 18101 | 7 | 0 |
84751 | 84751 | 2020-04-24 | Miami | Indiana | 18103 | 39 | 0 |
84752 | 84752 | 2020-04-24 | Monroe | Indiana | 18105 | 118 | 6 |
84753 | 84753 | 2020-04-24 | Montgomery | Indiana | 18107 | 29 | 0 |
84754 | 84754 | 2020-04-24 | Morgan | Indiana | 18109 | 129 | 5 |
84755 | 84755 | 2020-04-24 | Newton | Indiana | 18111 | 41 | 6 |
84756 | 84756 | 2020-04-24 | Noble | Indiana | 18113 | 52 | 5 |
84757 | 84757 | 2020-04-24 | Ohio | Indiana | 18115 | 3 | 0 |
84758 | 84758 | 2020-04-24 | Orange | Indiana | 18117 | 56 | 5 |
84759 | 84759 | 2020-04-24 | Owen | Indiana | 18119 | 22 | 1 |
84760 | 84760 | 2020-04-24 | Parke | Indiana | 18121 | 11 | 0 |
84761 | 84761 | 2020-04-24 | Perry | Indiana | 18123 | 11 | 0 |
84762 | 84762 | 2020-04-24 | Pike | Indiana | 18125 | 1 | 0 |
84763 | 84763 | 2020-04-24 | Porter | Indiana | 18127 | 208 | 6 |
84764 | 84764 | 2020-04-24 | Posey | Indiana | 18129 | 8 | 0 |
84765 | 84765 | 2020-04-24 | Pulaski | Indiana | 18131 | 7 | 0 |
84766 | 84766 | 2020-04-24 | Putnam | Indiana | 18133 | 57 | 4 |
84767 | 84767 | 2020-04-24 | Randolph | Indiana | 18135 | 14 | 2 |
84768 | 84768 | 2020-04-24 | Ripley | Indiana | 18137 | 87 | 5 |
84769 | 84769 | 2020-04-24 | Rush | Indiana | 18139 | 27 | 1 |
84770 | 84770 | 2020-04-24 | Scott | Indiana | 18143 | 33 | 2 |
84771 | 84771 | 2020-04-24 | Shelby | Indiana | 18145 | 162 | 13 |
84772 | 84772 | 2020-04-24 | Spencer | Indiana | 18147 | 8 | 0 |
84773 | 84773 | 2020-04-24 | St. Joseph | Indiana | 18141 | 521 | 16 |
84774 | 84774 | 2020-04-24 | Starke | Indiana | 18149 | 14 | 1 |
84775 | 84775 | 2020-04-24 | Steuben | Indiana | 18151 | 20 | 1 |
84776 | 84776 | 2020-04-24 | Sullivan | Indiana | 18153 | 12 | 0 |
84777 | 84777 | 2020-04-24 | Switzerland | Indiana | 18155 | 15 | 0 |
84778 | 84778 | 2020-04-24 | Tippecanoe | Indiana | 18157 | 64 | 2 |
84779 | 84779 | 2020-04-24 | Tipton | Indiana | 18159 | 17 | 1 |
84780 | 84780 | 2020-04-24 | Union | Indiana | 18161 | 6 | 0 |
84781 | 84781 | 2020-04-24 | Vanderburgh | Indiana | 18163 | 104 | 1 |
84782 | 84782 | 2020-04-24 | Vermillion | Indiana | 18165 | 7 | 0 |
84783 | 84783 | 2020-04-24 | Vigo | Indiana | 18167 | 63 | 6 |
84784 | 84784 | 2020-04-24 | Wabash | Indiana | 18169 | 12 | 1 |
84785 | 84785 | 2020-04-24 | Warren | Indiana | 18171 | 11 | 1 |
84786 | 84786 | 2020-04-24 | Warrick | Indiana | 18173 | 79 | 12 |
84787 | 84787 | 2020-04-24 | Washington | Indiana | 18175 | 36 | 0 |
84788 | 84788 | 2020-04-24 | Wayne | Indiana | 18177 | 36 | 3 |
84789 | 84789 | 2020-04-24 | Wells | Indiana | 18179 | 5 | 0 |
84790 | 84790 | 2020-04-24 | White | Indiana | 18181 | 14 | 0 |
84791 | 84791 | 2020-04-24 | Whitley | Indiana | 18183 | 16 | 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);