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-12-10 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
814040 | 814040 | 2020-12-10 | Adams | Indiana | 18001 | 2177 | 29 |
814041 | 814041 | 2020-12-10 | Allen | Indiana | 18003 | 22997 | 397 |
814042 | 814042 | 2020-12-10 | Bartholomew | Indiana | 18005 | 4339 | 74 |
814043 | 814043 | 2020-12-10 | Benton | Indiana | 18007 | 548 | 3 |
814044 | 814044 | 2020-12-10 | Blackford | Indiana | 18009 | 742 | 19 |
814045 | 814045 | 2020-12-10 | Boone | Indiana | 18011 | 3301 | 59 |
814046 | 814046 | 2020-12-10 | Brown | Indiana | 18013 | 493 | 8 |
814047 | 814047 | 2020-12-10 | Carroll | Indiana | 18015 | 961 | 14 |
814048 | 814048 | 2020-12-10 | Cass | Indiana | 18017 | 3511 | 35 |
814049 | 814049 | 2020-12-10 | Clark | Indiana | 18019 | 6501 | 99 |
814050 | 814050 | 2020-12-10 | Clay | Indiana | 18021 | 1546 | 27 |
814051 | 814051 | 2020-12-10 | Clinton | Indiana | 18023 | 2398 | 31 |
814052 | 814052 | 2020-12-10 | Crawford | Indiana | 18025 | 444 | 7 |
814053 | 814053 | 2020-12-10 | Daviess | Indiana | 18027 | 1940 | 60 |
814054 | 814054 | 2020-12-10 | DeKalb | Indiana | 18033 | 2379 | 41 |
814055 | 814055 | 2020-12-10 | Dearborn | Indiana | 18029 | 2922 | 39 |
814056 | 814056 | 2020-12-10 | Decatur | Indiana | 18031 | 1726 | 49 |
814057 | 814057 | 2020-12-10 | Delaware | Indiana | 18035 | 6209 | 119 |
814058 | 814058 | 2020-12-10 | Dubois | Indiana | 18037 | 3130 | 35 |
814059 | 814059 | 2020-12-10 | Elkhart | Indiana | 18039 | 20227 | 282 |
814060 | 814060 | 2020-12-10 | Fayette | Indiana | 18041 | 1945 | 42 |
814061 | 814061 | 2020-12-10 | Floyd | Indiana | 18043 | 4034 | 86 |
814062 | 814062 | 2020-12-10 | Fountain | Indiana | 18045 | 1150 | 12 |
814063 | 814063 | 2020-12-10 | Franklin | Indiana | 18047 | 938 | 29 |
814064 | 814064 | 2020-12-10 | Fulton | Indiana | 18049 | 1112 | 22 |
814065 | 814065 | 2020-12-10 | Gibson | Indiana | 18051 | 2458 | 42 |
814066 | 814066 | 2020-12-10 | Grant | Indiana | 18053 | 4229 | 64 |
814067 | 814067 | 2020-12-10 | Greene | Indiana | 18055 | 1456 | 57 |
814068 | 814068 | 2020-12-10 | Hamilton | Indiana | 18057 | 17940 | 216 |
814069 | 814069 | 2020-12-10 | Hancock | Indiana | 18059 | 3762 | 74 |
814070 | 814070 | 2020-12-10 | Harrison | Indiana | 18061 | 1942 | 30 |
814071 | 814071 | 2020-12-10 | Hendricks | Indiana | 18063 | 8438 | 192 |
814072 | 814072 | 2020-12-10 | Henry | Indiana | 18065 | 3183 | 43 |
814073 | 814073 | 2020-12-10 | Howard | Indiana | 18067 | 4996 | 91 |
814074 | 814074 | 2020-12-10 | Huntington | Indiana | 18069 | 1792 | 16 |
814075 | 814075 | 2020-12-10 | Jackson | Indiana | 18071 | 3031 | 42 |
814076 | 814076 | 2020-12-10 | Jasper | Indiana | 18073 | 1962 | 24 |
814077 | 814077 | 2020-12-10 | Jay | Indiana | 18075 | 1306 | 21 |
814078 | 814078 | 2020-12-10 | Jefferson | Indiana | 18077 | 1595 | 22 |
814079 | 814079 | 2020-12-10 | Jennings | Indiana | 18079 | 1300 | 25 |
814080 | 814080 | 2020-12-10 | Johnson | Indiana | 18081 | 9048 | 197 |
814081 | 814081 | 2020-12-10 | Knox | Indiana | 18083 | 2376 | 29 |
814082 | 814082 | 2020-12-10 | Kosciusko | Indiana | 18085 | 5698 | 57 |
814083 | 814083 | 2020-12-10 | LaGrange | Indiana | 18087 | 1754 | 40 |
814084 | 814084 | 2020-12-10 | LaPorte | Indiana | 18091 | 5824 | 113 |
814085 | 814085 | 2020-12-10 | Lake | Indiana | 18089 | 33560 | 536 |
814086 | 814086 | 2020-12-10 | Lawrence | Indiana | 18093 | 2378 | 57 |
814087 | 814087 | 2020-12-10 | Madison | Indiana | 18095 | 6781 | 149 |
814088 | 814088 | 2020-12-10 | Marion | Indiana | 18097 | 55399 | 997 |
814089 | 814089 | 2020-12-10 | Marshall | Indiana | 18099 | 3790 | 57 |
814090 | 814090 | 2020-12-10 | Martin | Indiana | 18101 | 450 | 8 |
814091 | 814091 | 2020-12-10 | Miami | Indiana | 18103 | 2170 | 22 |
814092 | 814092 | 2020-12-10 | Monroe | Indiana | 18105 | 6654 | 69 |
814093 | 814093 | 2020-12-10 | Montgomery | Indiana | 18107 | 2027 | 34 |
814094 | 814094 | 2020-12-10 | Morgan | Indiana | 18109 | 3133 | 56 |
814095 | 814095 | 2020-12-10 | Newton | Indiana | 18111 | 685 | 19 |
814096 | 814096 | 2020-12-10 | Noble | Indiana | 18113 | 3262 | 53 |
814097 | 814097 | 2020-12-10 | Ohio | Indiana | 18115 | 279 | 7 |
814098 | 814098 | 2020-12-10 | Orange | Indiana | 18117 | 895 | 30 |
814099 | 814099 | 2020-12-10 | Owen | Indiana | 18119 | 932 | 15 |
814100 | 814100 | 2020-12-10 | Parke | Indiana | 18121 | 923 | 7 |
814101 | 814101 | 2020-12-10 | Perry | Indiana | 18123 | 987 | 23 |
814102 | 814102 | 2020-12-10 | Pike | Indiana | 18125 | 665 | 21 |
814103 | 814103 | 2020-12-10 | Porter | Indiana | 18127 | 10323 | 116 |
814104 | 814104 | 2020-12-10 | Posey | Indiana | 18129 | 1507 | 22 |
814105 | 814105 | 2020-12-10 | Pulaski | Indiana | 18131 | 599 | 24 |
814106 | 814106 | 2020-12-10 | Putnam | Indiana | 18133 | 1763 | 33 |
814107 | 814107 | 2020-12-10 | Randolph | Indiana | 18135 | 1640 | 28 |
814108 | 814108 | 2020-12-10 | Ripley | Indiana | 18137 | 1927 | 28 |
814109 | 814109 | 2020-12-10 | Rush | Indiana | 18139 | 827 | 8 |
814110 | 814110 | 2020-12-10 | Scott | Indiana | 18143 | 1533 | 31 |
814111 | 814111 | 2020-12-10 | Shelby | Indiana | 18145 | 3298 | 74 |
814112 | 814112 | 2020-12-10 | Spencer | Indiana | 18147 | 1075 | 9 |
814113 | 814113 | 2020-12-10 | St. Joseph | Indiana | 18141 | 20847 | 292 |
814114 | 814114 | 2020-12-10 | Starke | Indiana | 18149 | 1235 | 30 |
814115 | 814115 | 2020-12-10 | Steuben | Indiana | 18151 | 1944 | 16 |
814116 | 814116 | 2020-12-10 | Sullivan | Indiana | 18153 | 1330 | 21 |
814117 | 814117 | 2020-12-10 | Switzerland | Indiana | 18155 | 346 | 5 |
814118 | 814118 | 2020-12-10 | Tippecanoe | Indiana | 18157 | 11638 | 43 |
814119 | 814119 | 2020-12-10 | Tipton | Indiana | 18159 | 786 | 32 |
814120 | 814120 | 2020-12-10 | Union | Indiana | 18161 | 361 | 2 |
814121 | 814121 | 2020-12-10 | Vanderburgh | Indiana | 18163 | 12121 | 153 |
814122 | 814122 | 2020-12-10 | Vermillion | Indiana | 18165 | 880 | 18 |
814123 | 814123 | 2020-12-10 | Vigo | Indiana | 18167 | 7592 | 125 |
814124 | 814124 | 2020-12-10 | Wabash | Indiana | 18169 | 2187 | 28 |
814125 | 814125 | 2020-12-10 | Warren | Indiana | 18171 | 352 | 6 |
814126 | 814126 | 2020-12-10 | Warrick | Indiana | 18173 | 4064 | 79 |
814127 | 814127 | 2020-12-10 | Washington | Indiana | 18175 | 1043 | 10 |
814128 | 814128 | 2020-12-10 | Wayne | Indiana | 18177 | 4543 | 114 |
814129 | 814129 | 2020-12-10 | Wells | Indiana | 18179 | 1639 | 42 |
814130 | 814130 | 2020-12-10 | White | Indiana | 18181 | 1751 | 24 |
814131 | 814131 | 2020-12-10 | Whitley | Indiana | 18183 | 1874 | 17 |
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);