ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where date = "2021-06-01" 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 |
---|---|---|---|---|---|---|---|
1375642 | 1375642 | 2021-06-01 | Adams | Indiana | 18001 | 3509 | 56 |
1375643 | 1375643 | 2021-06-01 | Allen | Indiana | 18003 | 41478 | 706 |
1375644 | 1375644 | 2021-06-01 | Bartholomew | Indiana | 18005 | 8157 | 161 |
1375645 | 1375645 | 2021-06-01 | Benton | Indiana | 18007 | 1000 | 14 |
1375646 | 1375646 | 2021-06-01 | Blackford | Indiana | 18009 | 1366 | 32 |
1375647 | 1375647 | 2021-06-01 | Boone | Indiana | 18011 | 6878 | 107 |
1375648 | 1375648 | 2021-06-01 | Brown | Indiana | 18013 | 1032 | 42 |
1375649 | 1375649 | 2021-06-01 | Carroll | Indiana | 18015 | 1930 | 22 |
1375650 | 1375650 | 2021-06-01 | Cass | Indiana | 18017 | 5959 | 110 |
1375651 | 1375651 | 2021-06-01 | Clark | Indiana | 18019 | 13157 | 201 |
1375652 | 1375652 | 2021-06-01 | Clay | Indiana | 18021 | 2635 | 47 |
1375653 | 1375653 | 2021-06-01 | Clinton | Indiana | 18023 | 4347 | 58 |
1375654 | 1375654 | 2021-06-01 | Crawford | Indiana | 18025 | 1022 | 17 |
1375655 | 1375655 | 2021-06-01 | Daviess | Indiana | 18027 | 3006 | 101 |
1375656 | 1375656 | 2021-06-01 | DeKalb | Indiana | 18033 | 4364 | 88 |
1375657 | 1375657 | 2021-06-01 | Dearborn | Indiana | 18029 | 5881 | 81 |
1375658 | 1375658 | 2021-06-01 | Decatur | Indiana | 18031 | 2943 | 96 |
1375659 | 1375659 | 2021-06-01 | Delaware | Indiana | 18035 | 10910 | 196 |
1375660 | 1375660 | 2021-06-01 | Dubois | Indiana | 18037 | 6196 | 118 |
1375661 | 1375661 | 2021-06-01 | Elkhart | Indiana | 18039 | 29304 | 467 |
1375662 | 1375662 | 2021-06-01 | Fayette | Indiana | 18041 | 2975 | 65 |
1375663 | 1375663 | 2021-06-01 | Floyd | Indiana | 18043 | 7744 | 184 |
1375664 | 1375664 | 2021-06-01 | Fountain | Indiana | 18045 | 2166 | 48 |
1375665 | 1375665 | 2021-06-01 | Franklin | Indiana | 18047 | 1717 | 36 |
1375666 | 1375666 | 2021-06-01 | Fulton | Indiana | 18049 | 1983 | 41 |
1375667 | 1375667 | 2021-06-01 | Gibson | Indiana | 18051 | 4426 | 95 |
1375668 | 1375668 | 2021-06-01 | Grant | Indiana | 18053 | 7599 | 183 |
1375669 | 1375669 | 2021-06-01 | Greene | Indiana | 18055 | 2849 | 89 |
1375670 | 1375670 | 2021-06-01 | Hamilton | Indiana | 18057 | 36241 | 432 |
1375671 | 1375671 | 2021-06-01 | Hancock | Indiana | 18059 | 8487 | 146 |
1375672 | 1375672 | 2021-06-01 | Harrison | Indiana | 18061 | 4389 | 75 |
1375673 | 1375673 | 2021-06-01 | Hendricks | Indiana | 18063 | 17557 | 337 |
1375674 | 1375674 | 2021-06-01 | Henry | Indiana | 18065 | 5872 | 108 |
1375675 | 1375675 | 2021-06-01 | Howard | Indiana | 18067 | 10189 | 228 |
1375676 | 1375676 | 2021-06-01 | Huntington | Indiana | 18069 | 4009 | 82 |
1375677 | 1375677 | 2021-06-01 | Jackson | Indiana | 18071 | 5071 | 75 |
1375678 | 1375678 | 2021-06-01 | Jasper | Indiana | 18073 | 3817 | 54 |
1375679 | 1375679 | 2021-06-01 | Jay | Indiana | 18075 | 2008 | 34 |
1375680 | 1375680 | 2021-06-01 | Jefferson | Indiana | 18077 | 3341 | 83 |
1375681 | 1375681 | 2021-06-01 | Jennings | Indiana | 18079 | 2343 | 51 |
1375682 | 1375682 | 2021-06-01 | Johnson | Indiana | 18081 | 18304 | 398 |
1375683 | 1375683 | 2021-06-01 | Knox | Indiana | 18083 | 3749 | 90 |
1375684 | 1375684 | 2021-06-01 | Kosciusko | Indiana | 18085 | 9592 | 122 |
1375685 | 1375685 | 2021-06-01 | LaGrange | Indiana | 18087 | 2725 | 74 |
1375686 | 1375686 | 2021-06-01 | LaPorte | Indiana | 18091 | 12313 | 221 |
1375687 | 1375687 | 2021-06-01 | Lake | Indiana | 18089 | 55101 | 1039 |
1375688 | 1375688 | 2021-06-01 | Lawrence | Indiana | 18093 | 4689 | 124 |
1375689 | 1375689 | 2021-06-01 | Madison | Indiana | 18095 | 12946 | 361 |
1375690 | 1375690 | 2021-06-01 | Marion | Indiana | 18097 | 102174 | 1830 |
1375691 | 1375691 | 2021-06-01 | Marshall | Indiana | 18099 | 6188 | 118 |
1375692 | 1375692 | 2021-06-01 | Martin | Indiana | 18101 | 911 | 15 |
1375693 | 1375693 | 2021-06-01 | Miami | Indiana | 18103 | 3893 | 69 |
1375694 | 1375694 | 2021-06-01 | Monroe | Indiana | 18105 | 12076 | 174 |
1375695 | 1375695 | 2021-06-01 | Montgomery | Indiana | 18107 | 4294 | 91 |
1375696 | 1375696 | 2021-06-01 | Morgan | Indiana | 18109 | 6705 | 145 |
1375697 | 1375697 | 2021-06-01 | Newton | Indiana | 18111 | 1114 | 37 |
1375698 | 1375698 | 2021-06-01 | Noble | Indiana | 18113 | 5750 | 88 |
1375699 | 1375699 | 2021-06-01 | Ohio | Indiana | 18115 | 577 | 11 |
1375700 | 1375700 | 2021-06-01 | Orange | Indiana | 18117 | 1878 | 57 |
1375701 | 1375701 | 2021-06-01 | Owen | Indiana | 18119 | 2087 | 58 |
1375702 | 1375702 | 2021-06-01 | Parke | Indiana | 18121 | 1494 | 16 |
1375703 | 1375703 | 2021-06-01 | Perry | Indiana | 18123 | 1871 | 38 |
1375704 | 1375704 | 2021-06-01 | Pike | Indiana | 18125 | 1368 | 34 |
1375705 | 1375705 | 2021-06-01 | Porter | Indiana | 18127 | 19230 | 333 |
1375706 | 1375706 | 2021-06-01 | Posey | Indiana | 18129 | 2727 | 34 |
1375707 | 1375707 | 2021-06-01 | Pulaski | Indiana | 18131 | 1190 | 46 |
1375708 | 1375708 | 2021-06-01 | Putnam | Indiana | 18133 | 3701 | 60 |
1375709 | 1375709 | 2021-06-01 | Randolph | Indiana | 18135 | 2478 | 83 |
1375710 | 1375710 | 2021-06-01 | Ripley | Indiana | 18137 | 3443 | 70 |
1375711 | 1375711 | 2021-06-01 | Rush | Indiana | 18139 | 1820 | 26 |
1375712 | 1375712 | 2021-06-01 | Scott | Indiana | 18143 | 2691 | 57 |
1375713 | 1375713 | 2021-06-01 | Shelby | Indiana | 18145 | 5972 | 107 |
1375714 | 1375714 | 2021-06-01 | Spencer | Indiana | 18147 | 2338 | 31 |
1375715 | 1375715 | 2021-06-01 | St. Joseph | Indiana | 18141 | 36811 | 576 |
1375716 | 1375716 | 2021-06-01 | Starke | Indiana | 18149 | 2255 | 57 |
1375717 | 1375717 | 2021-06-01 | Steuben | Indiana | 18151 | 3958 | 61 |
1375718 | 1375718 | 2021-06-01 | Sullivan | Indiana | 18153 | 2134 | 42 |
1375719 | 1375719 | 2021-06-01 | Switzerland | Indiana | 18155 | 804 | 8 |
1375720 | 1375720 | 2021-06-01 | Tippecanoe | Indiana | 18157 | 22701 | 227 |
1375721 | 1375721 | 2021-06-01 | Tipton | Indiana | 18159 | 1658 | 48 |
1375722 | 1375722 | 2021-06-01 | Union | Indiana | 18161 | 755 | 11 |
1375723 | 1375723 | 2021-06-01 | Vanderburgh | Indiana | 18163 | 22491 | 403 |
1375724 | 1375724 | 2021-06-01 | Vermillion | Indiana | 18165 | 1722 | 44 |
1375725 | 1375725 | 2021-06-01 | Vigo | Indiana | 18167 | 12569 | 257 |
1375726 | 1375726 | 2021-06-01 | Wabash | Indiana | 18169 | 3594 | 82 |
1375727 | 1375727 | 2021-06-01 | Warren | Indiana | 18171 | 832 | 16 |
1375728 | 1375728 | 2021-06-01 | Warrick | Indiana | 18173 | 7828 | 158 |
1375729 | 1375729 | 2021-06-01 | Washington | Indiana | 18175 | 2438 | 33 |
1375730 | 1375730 | 2021-06-01 | Wayne | Indiana | 18177 | 7506 | 205 |
1375731 | 1375731 | 2021-06-01 | Wells | Indiana | 18179 | 2966 | 83 |
1375732 | 1375732 | 2021-06-01 | White | Indiana | 18181 | 3246 | 54 |
1375733 | 1375733 | 2021-06-01 | Whitley | Indiana | 18183 | 4035 | 40 |
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);