ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2020-09-30" 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 |
---|---|---|---|---|---|---|---|
583709 | 583709 | 2020-09-30 | Adams | Indiana | 18001 | 284 | 4 |
583710 | 583710 | 2020-09-30 | Allen | Indiana | 18003 | 6440 | 216 |
583711 | 583711 | 2020-09-30 | Bartholomew | Indiana | 18005 | 1218 | 61 |
583712 | 583712 | 2020-09-30 | Benton | Indiana | 18007 | 87 | 0 |
583713 | 583713 | 2020-09-30 | Blackford | Indiana | 18009 | 132 | 3 |
583714 | 583714 | 2020-09-30 | Boone | Indiana | 18011 | 1023 | 49 |
583715 | 583715 | 2020-09-30 | Brown | Indiana | 18013 | 102 | 3 |
583716 | 583716 | 2020-09-30 | Carroll | Indiana | 18015 | 283 | 13 |
583717 | 583717 | 2020-09-30 | Cass | Indiana | 18017 | 1964 | 10 |
583718 | 583718 | 2020-09-30 | Clark | Indiana | 18019 | 2310 | 64 |
583719 | 583719 | 2020-09-30 | Clay | Indiana | 18021 | 315 | 5 |
583720 | 583720 | 2020-09-30 | Clinton | Indiana | 18023 | 648 | 18 |
583721 | 583721 | 2020-09-30 | Crawford | Indiana | 18025 | 112 | 1 |
583722 | 583722 | 2020-09-30 | Daviess | Indiana | 18027 | 686 | 31 |
583723 | 583723 | 2020-09-30 | DeKalb | Indiana | 18033 | 503 | 12 |
583724 | 583724 | 2020-09-30 | Dearborn | Indiana | 18029 | 686 | 30 |
583725 | 583725 | 2020-09-30 | Decatur | Indiana | 18031 | 490 | 42 |
583726 | 583726 | 2020-09-30 | Delaware | Indiana | 18035 | 2046 | 63 |
583727 | 583727 | 2020-09-30 | Dubois | Indiana | 18037 | 1021 | 19 |
583728 | 583728 | 2020-09-30 | Elkhart | Indiana | 18039 | 6849 | 116 |
583729 | 583729 | 2020-09-30 | Fayette | Indiana | 18041 | 537 | 14 |
583730 | 583730 | 2020-09-30 | Floyd | Indiana | 18043 | 1426 | 67 |
583731 | 583731 | 2020-09-30 | Fountain | Indiana | 18045 | 132 | 2 |
583732 | 583732 | 2020-09-30 | Franklin | Indiana | 18047 | 325 | 26 |
583733 | 583733 | 2020-09-30 | Fulton | Indiana | 18049 | 249 | 2 |
583734 | 583734 | 2020-09-30 | Gibson | Indiana | 18051 | 562 | 6 |
583735 | 583735 | 2020-09-30 | Grant | Indiana | 18053 | 1321 | 40 |
583736 | 583736 | 2020-09-30 | Greene | Indiana | 18055 | 437 | 39 |
583737 | 583737 | 2020-09-30 | Hamilton | Indiana | 18057 | 5029 | 119 |
583738 | 583738 | 2020-09-30 | Hancock | Indiana | 18059 | 966 | 46 |
583739 | 583739 | 2020-09-30 | Harrison | Indiana | 18061 | 604 | 26 |
583740 | 583740 | 2020-09-30 | Hendricks | Indiana | 18063 | 2823 | 142 |
583741 | 583741 | 2020-09-30 | Henry | Indiana | 18065 | 842 | 27 |
583742 | 583742 | 2020-09-30 | Howard | Indiana | 18067 | 1349 | 67 |
583743 | 583743 | 2020-09-30 | Huntington | Indiana | 18069 | 257 | 3 |
583744 | 583744 | 2020-09-30 | Jackson | Indiana | 18071 | 783 | 11 |
583745 | 583745 | 2020-09-30 | Jasper | Indiana | 18073 | 405 | 3 |
583746 | 583746 | 2020-09-30 | Jay | Indiana | 18075 | 199 | 1 |
583747 | 583747 | 2020-09-30 | Jefferson | Indiana | 18077 | 255 | 3 |
583748 | 583748 | 2020-09-30 | Jennings | Indiana | 18079 | 321 | 14 |
583749 | 583749 | 2020-09-30 | Johnson | Indiana | 18081 | 2422 | 135 |
583750 | 583750 | 2020-09-30 | Knox | Indiana | 18083 | 545 | 10 |
583751 | 583751 | 2020-09-30 | Kosciusko | Indiana | 18085 | 1321 | 19 |
583752 | 583752 | 2020-09-30 | LaGrange | Indiana | 18087 | 653 | 11 |
583753 | 583753 | 2020-09-30 | LaPorte | Indiana | 18091 | 1536 | 41 |
583754 | 583754 | 2020-09-30 | Lake | Indiana | 18089 | 10834 | 343 |
583755 | 583755 | 2020-09-30 | Lawrence | Indiana | 18093 | 532 | 31 |
583756 | 583756 | 2020-09-30 | Madison | Indiana | 18095 | 1751 | 86 |
583757 | 583757 | 2020-09-30 | Marion | Indiana | 18097 | 21843 | 821 |
583758 | 583758 | 2020-09-30 | Marshall | Indiana | 18099 | 1029 | 24 |
583759 | 583759 | 2020-09-30 | Martin | Indiana | 18101 | 170 | 0 |
583760 | 583760 | 2020-09-30 | Miami | Indiana | 18103 | 444 | 4 |
583761 | 583761 | 2020-09-30 | Monroe | Indiana | 18105 | 2713 | 41 |
583762 | 583762 | 2020-09-30 | Montgomery | Indiana | 18107 | 514 | 23 |
583763 | 583763 | 2020-09-30 | Morgan | Indiana | 18109 | 752 | 43 |
583764 | 583764 | 2020-09-30 | Newton | Indiana | 18111 | 176 | 12 |
583765 | 583765 | 2020-09-30 | Noble | Indiana | 18113 | 939 | 33 |
583766 | 583766 | 2020-09-30 | Ohio | Indiana | 18115 | 79 | 7 |
583767 | 583767 | 2020-09-30 | Orange | Indiana | 18117 | 291 | 26 |
583768 | 583768 | 2020-09-30 | Owen | Indiana | 18119 | 173 | 2 |
583769 | 583769 | 2020-09-30 | Parke | Indiana | 18121 | 117 | 2 |
583770 | 583770 | 2020-09-30 | Perry | Indiana | 18123 | 237 | 14 |
583771 | 583771 | 2020-09-30 | Pike | Indiana | 18125 | 177 | 1 |
583772 | 583772 | 2020-09-30 | Porter | Indiana | 18127 | 2244 | 49 |
583773 | 583773 | 2020-09-30 | Posey | Indiana | 18129 | 371 | 2 |
583774 | 583774 | 2020-09-30 | Pulaski | Indiana | 18131 | 116 | 1 |
583775 | 583775 | 2020-09-30 | Putnam | Indiana | 18133 | 597 | 11 |
583776 | 583776 | 2020-09-30 | Randolph | Indiana | 18135 | 267 | 8 |
583777 | 583777 | 2020-09-30 | Ripley | Indiana | 18137 | 310 | 8 |
583778 | 583778 | 2020-09-30 | Rush | Indiana | 18139 | 202 | 4 |
583779 | 583779 | 2020-09-30 | Scott | Indiana | 18143 | 402 | 13 |
583780 | 583780 | 2020-09-30 | Shelby | Indiana | 18145 | 1179 | 37 |
583781 | 583781 | 2020-09-30 | Spencer | Indiana | 18147 | 272 | 3 |
583782 | 583782 | 2020-09-30 | St. Joseph | Indiana | 18141 | 6782 | 122 |
583783 | 583783 | 2020-09-30 | Starke | Indiana | 18149 | 276 | 8 |
583784 | 583784 | 2020-09-30 | Steuben | Indiana | 18151 | 400 | 7 |
583785 | 583785 | 2020-09-30 | Sullivan | Indiana | 18153 | 343 | 12 |
583786 | 583786 | 2020-09-30 | Switzerland | Indiana | 18155 | 70 | 0 |
583787 | 583787 | 2020-09-30 | Tippecanoe | Indiana | 18157 | 2655 | 14 |
583788 | 583788 | 2020-09-30 | Tipton | Indiana | 18159 | 237 | 26 |
583789 | 583789 | 2020-09-30 | Union | Indiana | 18161 | 105 | 0 |
583790 | 583790 | 2020-09-30 | Vanderburgh | Indiana | 18163 | 3909 | 32 |
583791 | 583791 | 2020-09-30 | Vermillion | Indiana | 18165 | 134 | 0 |
583792 | 583792 | 2020-09-30 | Vigo | Indiana | 18167 | 1913 | 29 |
583793 | 583793 | 2020-09-30 | Wabash | Indiana | 18169 | 279 | 8 |
583794 | 583794 | 2020-09-30 | Warren | Indiana | 18171 | 42 | 1 |
583795 | 583795 | 2020-09-30 | Warrick | Indiana | 18173 | 1430 | 49 |
583796 | 583796 | 2020-09-30 | Washington | Indiana | 18175 | 270 | 2 |
583797 | 583797 | 2020-09-30 | Wayne | Indiana | 18177 | 1145 | 15 |
583798 | 583798 | 2020-09-30 | Wells | Indiana | 18179 | 290 | 4 |
583799 | 583799 | 2020-09-30 | White | Indiana | 18181 | 491 | 14 |
583800 | 583800 | 2020-09-30 | Whitley | Indiana | 18183 | 295 | 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);