ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 27 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
383502 | 383502 | 2020-07-30 | Vermillion | Indiana | 18165 | 27 | 0 |
300453 | 300453 | 2020-07-04 | Parke | Indiana | 18121 | 27 | 0 |
297291 | 297291 | 2020-07-03 | Parke | Indiana | 18121 | 27 | 0 |
294133 | 294133 | 2020-07-02 | Parke | Indiana | 18121 | 27 | 0 |
290979 | 290979 | 2020-07-01 | Parke | Indiana | 18121 | 27 | 0 |
290996 | 290996 | 2020-07-01 | Switzerland | Indiana | 18155 | 27 | 0 |
287829 | 287829 | 2020-06-30 | Parke | Indiana | 18121 | 27 | 0 |
284680 | 284680 | 2020-06-29 | Parke | Indiana | 18121 | 27 | 0 |
281497 | 281497 | 2020-06-28 | Fountain | Indiana | 18045 | 27 | 2 |
281535 | 281535 | 2020-06-28 | Parke | Indiana | 18121 | 27 | 0 |
278387 | 278387 | 2020-06-27 | Parke | Indiana | 18121 | 27 | 0 |
275239 | 275239 | 2020-06-26 | Parke | Indiana | 18121 | 27 | 0 |
272101 | 272101 | 2020-06-25 | Posey | Indiana | 18129 | 27 | 0 |
265795 | 265795 | 2020-06-23 | Gibson | Indiana | 18051 | 27 | 2 |
265850 | 265850 | 2020-06-23 | Union | Indiana | 18161 | 27 | 0 |
262667 | 262667 | 2020-06-22 | Gibson | Indiana | 18051 | 27 | 2 |
262722 | 262722 | 2020-06-22 | Union | Indiana | 18161 | 27 | 0 |
259540 | 259540 | 2020-06-21 | Gibson | Indiana | 18051 | 27 | 2 |
259587 | 259587 | 2020-06-21 | Spencer | Indiana | 18147 | 27 | 1 |
259595 | 259595 | 2020-06-21 | Union | Indiana | 18161 | 27 | 0 |
256461 | 256461 | 2020-06-20 | Spencer | Indiana | 18147 | 27 | 1 |
256469 | 256469 | 2020-06-20 | Union | Indiana | 18161 | 27 | 0 |
253341 | 253341 | 2020-06-19 | Spencer | Indiana | 18147 | 27 | 1 |
253349 | 253349 | 2020-06-19 | Union | Indiana | 18161 | 27 | 0 |
250234 | 250234 | 2020-06-18 | Union | Indiana | 18161 | 27 | 0 |
247122 | 247122 | 2020-06-17 | Union | Indiana | 18161 | 27 | 0 |
240818 | 240818 | 2020-06-15 | Adams | Indiana | 18001 | 27 | 1 |
219181 | 219181 | 2020-06-08 | Tipton | Indiana | 18159 | 27 | 2 |
216089 | 216089 | 2020-06-07 | Tipton | Indiana | 18159 | 27 | 2 |
213002 | 213002 | 2020-06-06 | Tipton | Indiana | 18159 | 27 | 2 |
209917 | 209917 | 2020-06-05 | Tipton | Indiana | 18159 | 27 | 2 |
206836 | 206836 | 2020-06-04 | Tipton | Indiana | 18159 | 27 | 2 |
203756 | 203756 | 2020-06-03 | Tipton | Indiana | 18159 | 27 | 2 |
197532 | 197532 | 2020-06-01 | Blackford | Indiana | 18009 | 27 | 2 |
191425 | 191425 | 2020-05-30 | Huntington | Indiana | 18069 | 27 | 2 |
188360 | 188360 | 2020-05-29 | Huntington | Indiana | 18069 | 27 | 2 |
185357 | 185357 | 2020-05-28 | Wells | Indiana | 18179 | 27 | 0 |
167018 | 167018 | 2020-05-22 | DeKalb | Indiana | 18033 | 27 | 2 |
163985 | 163985 | 2020-05-21 | DeKalb | Indiana | 18033 | 27 | 2 |
160957 | 160957 | 2020-05-20 | DeKalb | Indiana | 18033 | 27 | 2 |
157931 | 157931 | 2020-05-19 | DeKalb | Indiana | 18033 | 27 | 2 |
157976 | 157976 | 2020-05-19 | Owen | Indiana | 18119 | 27 | 1 |
158008 | 158008 | 2020-05-19 | Whitley | Indiana | 18183 | 27 | 2 |
154960 | 154960 | 2020-05-18 | Owen | Indiana | 18119 | 27 | 1 |
151903 | 151903 | 2020-05-17 | DeKalb | Indiana | 18033 | 27 | 2 |
151948 | 151948 | 2020-05-17 | Owen | Indiana | 18119 | 27 | 1 |
148939 | 148939 | 2020-05-16 | Owen | Indiana | 18119 | 27 | 1 |
145935 | 145935 | 2020-05-15 | Owen | Indiana | 18119 | 27 | 1 |
145950 | 145950 | 2020-05-15 | Starke | Indiana | 18149 | 27 | 2 |
142935 | 142935 | 2020-05-14 | Owen | Indiana | 18119 | 27 | 1 |
142967 | 142967 | 2020-05-14 | Whitley | Indiana | 18183 | 27 | 1 |
139939 | 139939 | 2020-05-13 | Owen | Indiana | 18119 | 27 | 1 |
136947 | 136947 | 2020-05-12 | Owen | Indiana | 18119 | 27 | 1 |
116039 | 116039 | 2020-05-05 | Dubois | Indiana | 18037 | 27 | 0 |
116088 | 116088 | 2020-05-05 | Randolph | Indiana | 18135 | 27 | 2 |
101696 | 101696 | 2020-04-30 | Fulton | Indiana | 18049 | 27 | 1 |
101710 | 101710 | 2020-04-30 | Jefferson | Indiana | 18077 | 27 | 0 |
98859 | 98859 | 2020-04-29 | Jefferson | Indiana | 18077 | 27 | 0 |
96015 | 96015 | 2020-04-28 | Jefferson | Indiana | 18077 | 27 | 0 |
93183 | 93183 | 2020-04-27 | Jefferson | Indiana | 18077 | 27 | 0 |
90375 | 90375 | 2020-04-26 | Marshall | Indiana | 18099 | 27 | 1 |
84711 | 84711 | 2020-04-24 | Clinton | Indiana | 18023 | 27 | 2 |
84769 | 84769 | 2020-04-24 | Rush | Indiana | 18139 | 27 | 1 |
81920 | 81920 | 2020-04-23 | Fayette | Indiana | 18041 | 27 | 4 |
79160 | 79160 | 2020-04-22 | Montgomery | Indiana | 18107 | 27 | 0 |
79177 | 79177 | 2020-04-22 | Scott | Indiana | 18143 | 27 | 2 |
76374 | 76374 | 2020-04-21 | Miami | Indiana | 18103 | 27 | 0 |
70863 | 70863 | 2020-04-19 | Wayne | Indiana | 18177 | 27 | 2 |
65277 | 65277 | 2020-04-17 | Daviess | Indiana | 18027 | 27 | 1 |
65351 | 65351 | 2020-04-17 | Washington | Indiana | 18175 | 27 | 0 |
62586 | 62586 | 2020-04-16 | Noble | Indiana | 18113 | 27 | 1 |
59896 | 59896 | 2020-04-15 | Washington | Indiana | 18175 | 27 | 0 |
54463 | 54463 | 2020-04-13 | Newton | Indiana | 18111 | 27 | 1 |
43852 | 43852 | 2020-04-09 | Grant | Indiana | 18053 | 27 | 3 |
41314 | 41314 | 2020-04-08 | Putnam | Indiana | 18133 | 27 | 1 |
26685 | 26685 | 2020-04-02 | Elkhart | Indiana | 18039 | 27 | 3 |
24486 | 24486 | 2020-04-01 | Porter | Indiana | 18127 | 27 | 0 |
20173 | 20173 | 2020-03-30 | Clark | Indiana | 18019 | 27 | 0 |
18162 | 18162 | 2020-03-29 | Allen | Indiana | 18003 | 27 | 2 |
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);