ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-08-27" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
473674 | 473674 | 2020-08-27 | Adams | Indiana | 18001 | 178 | 3 |
473675 | 473675 | 2020-08-27 | Allen | Indiana | 18003 | 4852 | 187 |
473676 | 473676 | 2020-08-27 | Bartholomew | Indiana | 18005 | 1051 | 58 |
473677 | 473677 | 2020-08-27 | Benton | Indiana | 18007 | 78 | 0 |
473678 | 473678 | 2020-08-27 | Blackford | Indiana | 18009 | 76 | 2 |
473679 | 473679 | 2020-08-27 | Boone | Indiana | 18011 | 833 | 49 |
473680 | 473680 | 2020-08-27 | Brown | Indiana | 18013 | 86 | 2 |
473681 | 473681 | 2020-08-27 | Carroll | Indiana | 18015 | 250 | 12 |
473682 | 473682 | 2020-08-27 | Cass | Indiana | 18017 | 1857 | 10 |
473683 | 473683 | 2020-08-27 | Clark | Indiana | 18019 | 1692 | 58 |
473684 | 473684 | 2020-08-27 | Clay | Indiana | 18021 | 214 | 5 |
473685 | 473685 | 2020-08-27 | Clinton | Indiana | 18023 | 537 | 9 |
473686 | 473686 | 2020-08-27 | Crawford | Indiana | 18025 | 58 | 1 |
473687 | 473687 | 2020-08-27 | Daviess | Indiana | 18027 | 445 | 25 |
473688 | 473688 | 2020-08-27 | DeKalb | Indiana | 18033 | 311 | 5 |
473689 | 473689 | 2020-08-27 | Dearborn | Indiana | 18029 | 571 | 30 |
473690 | 473690 | 2020-08-27 | Decatur | Indiana | 18031 | 414 | 37 |
473691 | 473691 | 2020-08-27 | Delaware | Indiana | 18035 | 975 | 56 |
473692 | 473692 | 2020-08-27 | Dubois | Indiana | 18037 | 819 | 17 |
473693 | 473693 | 2020-08-27 | Elkhart | Indiana | 18039 | 5576 | 101 |
473694 | 473694 | 2020-08-27 | Fayette | Indiana | 18041 | 397 | 8 |
473695 | 473695 | 2020-08-27 | Floyd | Indiana | 18043 | 1031 | 57 |
473696 | 473696 | 2020-08-27 | Fountain | Indiana | 18045 | 89 | 2 |
473697 | 473697 | 2020-08-27 | Franklin | Indiana | 18047 | 280 | 25 |
473698 | 473698 | 2020-08-27 | Fulton | Indiana | 18049 | 203 | 2 |
473699 | 473699 | 2020-08-27 | Gibson | Indiana | 18051 | 307 | 4 |
473700 | 473700 | 2020-08-27 | Grant | Indiana | 18053 | 918 | 33 |
473701 | 473701 | 2020-08-27 | Greene | Indiana | 18055 | 361 | 38 |
473702 | 473702 | 2020-08-27 | Hamilton | Indiana | 18057 | 3723 | 116 |
473703 | 473703 | 2020-08-27 | Hancock | Indiana | 18059 | 806 | 44 |
473704 | 473704 | 2020-08-27 | Harrison | Indiana | 18061 | 466 | 26 |
473705 | 473705 | 2020-08-27 | Hendricks | Indiana | 18063 | 2269 | 128 |
473706 | 473706 | 2020-08-27 | Henry | Indiana | 18065 | 585 | 21 |
473707 | 473707 | 2020-08-27 | Howard | Indiana | 18067 | 1052 | 64 |
473708 | 473708 | 2020-08-27 | Huntington | Indiana | 18069 | 158 | 3 |
473709 | 473709 | 2020-08-27 | Jackson | Indiana | 18071 | 685 | 9 |
473710 | 473710 | 2020-08-27 | Jasper | Indiana | 18073 | 310 | 2 |
473711 | 473711 | 2020-08-27 | Jay | Indiana | 18075 | 128 | 0 |
473712 | 473712 | 2020-08-27 | Jefferson | Indiana | 18077 | 204 | 3 |
473713 | 473713 | 2020-08-27 | Jennings | Indiana | 18079 | 264 | 14 |
473714 | 473714 | 2020-08-27 | Johnson | Indiana | 18081 | 2029 | 128 |
473715 | 473715 | 2020-08-27 | Knox | Indiana | 18083 | 312 | 3 |
473716 | 473716 | 2020-08-27 | Kosciusko | Indiana | 18085 | 1028 | 18 |
473717 | 473717 | 2020-08-27 | LaGrange | Indiana | 18087 | 593 | 11 |
473718 | 473718 | 2020-08-27 | LaPorte | Indiana | 18091 | 1144 | 31 |
473719 | 473719 | 2020-08-27 | Lake | Indiana | 18089 | 8932 | 311 |
473720 | 473720 | 2020-08-27 | Lawrence | Indiana | 18093 | 442 | 29 |
473721 | 473721 | 2020-08-27 | Madison | Indiana | 18095 | 1261 | 79 |
473722 | 473722 | 2020-08-27 | Marion | Indiana | 18097 | 18141 | 797 |
473723 | 473723 | 2020-08-27 | Marshall | Indiana | 18099 | 871 | 23 |
473724 | 473724 | 2020-08-27 | Martin | Indiana | 18101 | 94 | 0 |
473725 | 473725 | 2020-08-27 | Miami | Indiana | 18103 | 313 | 2 |
473726 | 473726 | 2020-08-27 | Monroe | Indiana | 18105 | 1013 | 40 |
473727 | 473727 | 2020-08-27 | Montgomery | Indiana | 18107 | 395 | 22 |
473728 | 473728 | 2020-08-27 | Morgan | Indiana | 18109 | 581 | 38 |
473729 | 473729 | 2020-08-27 | Newton | Indiana | 18111 | 138 | 11 |
473730 | 473730 | 2020-08-27 | Noble | Indiana | 18113 | 791 | 31 |
473731 | 473731 | 2020-08-27 | Ohio | Indiana | 18115 | 71 | 7 |
473732 | 473732 | 2020-08-27 | Orange | Indiana | 18117 | 232 | 26 |
473733 | 473733 | 2020-08-27 | Owen | Indiana | 18119 | 136 | 2 |
473734 | 473734 | 2020-08-27 | Parke | Indiana | 18121 | 81 | 2 |
473735 | 473735 | 2020-08-27 | Perry | Indiana | 18123 | 208 | 14 |
473736 | 473736 | 2020-08-27 | Pike | Indiana | 18125 | 88 | 1 |
473737 | 473737 | 2020-08-27 | Porter | Indiana | 18127 | 1653 | 43 |
473738 | 473738 | 2020-08-27 | Posey | Indiana | 18129 | 206 | 0 |
473739 | 473739 | 2020-08-27 | Pulaski | Indiana | 18131 | 95 | 1 |
473740 | 473740 | 2020-08-27 | Putnam | Indiana | 18133 | 424 | 8 |
473741 | 473741 | 2020-08-27 | Randolph | Indiana | 18135 | 189 | 7 |
473742 | 473742 | 2020-08-27 | Ripley | Indiana | 18137 | 241 | 8 |
473743 | 473743 | 2020-08-27 | Rush | Indiana | 18139 | 168 | 4 |
473744 | 473744 | 2020-08-27 | Scott | Indiana | 18143 | 312 | 12 |
473745 | 473745 | 2020-08-27 | Shelby | Indiana | 18145 | 1051 | 36 |
473746 | 473746 | 2020-08-27 | Spencer | Indiana | 18147 | 153 | 3 |
473747 | 473747 | 2020-08-27 | St. Joseph | Indiana | 18141 | 4939 | 95 |
473748 | 473748 | 2020-08-27 | Starke | Indiana | 18149 | 201 | 8 |
473749 | 473749 | 2020-08-27 | Steuben | Indiana | 18151 | 254 | 3 |
473750 | 473750 | 2020-08-27 | Sullivan | Indiana | 18153 | 279 | 7 |
473751 | 473751 | 2020-08-27 | Switzerland | Indiana | 18155 | 65 | 0 |
473752 | 473752 | 2020-08-27 | Tippecanoe | Indiana | 18157 | 1518 | 14 |
473753 | 473753 | 2020-08-27 | Tipton | Indiana | 18159 | 179 | 21 |
473754 | 473754 | 2020-08-27 | Union | Indiana | 18161 | 82 | 0 |
473755 | 473755 | 2020-08-27 | Vanderburgh | Indiana | 18163 | 2455 | 18 |
473756 | 473756 | 2020-08-27 | Vermillion | Indiana | 18165 | 85 | 0 |
473757 | 473757 | 2020-08-27 | Vigo | Indiana | 18167 | 1136 | 16 |
473758 | 473758 | 2020-08-27 | Wabash | Indiana | 18169 | 204 | 5 |
473759 | 473759 | 2020-08-27 | Warren | Indiana | 18171 | 37 | 1 |
473760 | 473760 | 2020-08-27 | Warrick | Indiana | 18173 | 734 | 33 |
473761 | 473761 | 2020-08-27 | Washington | Indiana | 18175 | 205 | 1 |
473762 | 473762 | 2020-08-27 | Wayne | Indiana | 18177 | 855 | 10 |
473763 | 473763 | 2020-08-27 | Wells | Indiana | 18179 | 218 | 2 |
473764 | 473764 | 2020-08-27 | White | Indiana | 18181 | 425 | 12 |
473765 | 473765 | 2020-08-27 | Whitley | Indiana | 18183 | 200 | 6 |
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);