ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "White" and state = "Indiana" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
16333 | 16333 | 2020-03-28 | White | Indiana | 18181 | 1 | 0 |
18238 | 18238 | 2020-03-29 | White | Indiana | 18181 | 1 | 0 |
20244 | 20244 | 2020-03-30 | White | Indiana | 18181 | 2 | 0 |
22339 | 22339 | 2020-03-31 | White | Indiana | 18181 | 2 | 0 |
24511 | 24511 | 2020-04-01 | White | Indiana | 18181 | 2 | 0 |
26751 | 26751 | 2020-04-02 | White | Indiana | 18181 | 3 | 0 |
29062 | 29062 | 2020-04-03 | White | Indiana | 18181 | 3 | 0 |
31430 | 31430 | 2020-04-04 | White | Indiana | 18181 | 3 | 0 |
33841 | 33841 | 2020-04-05 | White | Indiana | 18181 | 3 | 0 |
36294 | 36294 | 2020-04-06 | White | Indiana | 18181 | 3 | 0 |
38792 | 38792 | 2020-04-07 | White | Indiana | 18181 | 3 | 0 |
41338 | 41338 | 2020-04-08 | White | Indiana | 18181 | 3 | 0 |
43914 | 43914 | 2020-04-09 | White | Indiana | 18181 | 3 | 0 |
46519 | 46519 | 2020-04-10 | White | Indiana | 18181 | 3 | 0 |
49153 | 49153 | 2020-04-11 | White | Indiana | 18181 | 3 | 0 |
51817 | 51817 | 2020-04-12 | White | Indiana | 18181 | 3 | 0 |
54498 | 54498 | 2020-04-13 | White | Indiana | 18181 | 4 | 0 |
57191 | 57191 | 2020-04-14 | White | Indiana | 18181 | 5 | 0 |
59899 | 59899 | 2020-04-15 | White | Indiana | 18181 | 5 | 0 |
62620 | 62620 | 2020-04-16 | White | Indiana | 18181 | 5 | 0 |
65354 | 65354 | 2020-04-17 | White | Indiana | 18181 | 6 | 0 |
68103 | 68103 | 2020-04-18 | White | Indiana | 18181 | 6 | 0 |
70865 | 70865 | 2020-04-19 | White | Indiana | 18181 | 7 | 0 |
73636 | 73636 | 2020-04-20 | White | Indiana | 18181 | 8 | 0 |
76413 | 76413 | 2020-04-21 | White | Indiana | 18181 | 8 | 0 |
79197 | 79197 | 2020-04-22 | White | Indiana | 18181 | 11 | 0 |
81990 | 81990 | 2020-04-23 | White | Indiana | 18181 | 12 | 0 |
84790 | 84790 | 2020-04-24 | White | Indiana | 18181 | 14 | 0 |
87600 | 87600 | 2020-04-25 | White | Indiana | 18181 | 18 | 0 |
90416 | 90416 | 2020-04-26 | White | Indiana | 18181 | 26 | 0 |
93235 | 93235 | 2020-04-27 | White | Indiana | 18181 | 34 | 0 |
96067 | 96067 | 2020-04-28 | White | Indiana | 18181 | 42 | 0 |
98911 | 98911 | 2020-04-29 | White | Indiana | 18181 | 43 | 0 |
101762 | 101762 | 2020-04-30 | White | Indiana | 18181 | 47 | 0 |
104618 | 104618 | 2020-05-01 | White | Indiana | 18181 | 51 | 0 |
107483 | 107483 | 2020-05-02 | White | Indiana | 18181 | 57 | 0 |
110353 | 110353 | 2020-05-03 | White | Indiana | 18181 | 82 | 0 |
113228 | 113228 | 2020-05-04 | White | Indiana | 18181 | 99 | 0 |
116111 | 116111 | 2020-05-05 | White | Indiana | 18181 | 100 | 0 |
119071 | 119071 | 2020-05-06 | White | Indiana | 18181 | 106 | 0 |
122041 | 122041 | 2020-05-07 | White | Indiana | 18181 | 130 | 1 |
125021 | 125021 | 2020-05-08 | White | Indiana | 18181 | 139 | 1 |
128008 | 128008 | 2020-05-09 | White | Indiana | 18181 | 145 | 1 |
130999 | 130999 | 2020-05-10 | White | Indiana | 18181 | 148 | 1 |
133989 | 133989 | 2020-05-11 | White | Indiana | 18181 | 152 | 1 |
136978 | 136978 | 2020-05-12 | White | Indiana | 18181 | 165 | 1 |
139970 | 139970 | 2020-05-13 | White | Indiana | 18181 | 165 | 2 |
142966 | 142966 | 2020-05-14 | White | Indiana | 18181 | 164 | 2 |
145966 | 145966 | 2020-05-15 | White | Indiana | 18181 | 164 | 3 |
148970 | 148970 | 2020-05-16 | White | Indiana | 18181 | 178 | 4 |
151979 | 151979 | 2020-05-17 | White | Indiana | 18181 | 179 | 4 |
154991 | 154991 | 2020-05-18 | White | Indiana | 18181 | 183 | 5 |
158007 | 158007 | 2020-05-19 | White | Indiana | 18181 | 186 | 5 |
161033 | 161033 | 2020-05-20 | White | Indiana | 18181 | 188 | 7 |
164061 | 164061 | 2020-05-21 | White | Indiana | 18181 | 201 | 7 |
167094 | 167094 | 2020-05-22 | White | Indiana | 18181 | 206 | 8 |
170131 | 170131 | 2020-05-23 | White | Indiana | 18181 | 212 | 8 |
173172 | 173172 | 2020-05-24 | White | Indiana | 18181 | 221 | 8 |
176216 | 176216 | 2020-05-25 | White | Indiana | 18181 | 226 | 8 |
179260 | 179260 | 2020-05-26 | White | Indiana | 18181 | 226 | 8 |
182304 | 182304 | 2020-05-27 | White | Indiana | 18181 | 228 | 8 |
185358 | 185358 | 2020-05-28 | White | Indiana | 18181 | 230 | 8 |
188416 | 188416 | 2020-05-29 | White | Indiana | 18181 | 231 | 8 |
191481 | 191481 | 2020-05-30 | White | Indiana | 18181 | 233 | 8 |
194548 | 194548 | 2020-05-31 | White | Indiana | 18181 | 235 | 8 |
197618 | 197618 | 2020-06-01 | White | Indiana | 18181 | 237 | 8 |
200691 | 200691 | 2020-06-02 | White | Indiana | 18181 | 238 | 9 |
203767 | 203767 | 2020-06-03 | White | Indiana | 18181 | 238 | 9 |
206847 | 206847 | 2020-06-04 | White | Indiana | 18181 | 238 | 9 |
209928 | 209928 | 2020-06-05 | White | Indiana | 18181 | 239 | 9 |
213013 | 213013 | 2020-06-06 | White | Indiana | 18181 | 243 | 9 |
216100 | 216100 | 2020-06-07 | White | Indiana | 18181 | 243 | 9 |
219192 | 219192 | 2020-06-08 | White | Indiana | 18181 | 243 | 9 |
222287 | 222287 | 2020-06-09 | White | Indiana | 18181 | 242 | 9 |
225382 | 225382 | 2020-06-10 | White | Indiana | 18181 | 242 | 9 |
228484 | 228484 | 2020-06-11 | White | Indiana | 18181 | 241 | 9 |
231587 | 231587 | 2020-06-12 | White | Indiana | 18181 | 240 | 9 |
234693 | 234693 | 2020-06-13 | White | Indiana | 18181 | 242 | 9 |
237800 | 237800 | 2020-06-14 | White | Indiana | 18181 | 242 | 10 |
240908 | 240908 | 2020-06-15 | White | Indiana | 18181 | 245 | 10 |
244019 | 244019 | 2020-06-16 | White | Indiana | 18181 | 242 | 10 |
247132 | 247132 | 2020-06-17 | White | Indiana | 18181 | 242 | 10 |
250244 | 250244 | 2020-06-18 | White | Indiana | 18181 | 242 | 10 |
253359 | 253359 | 2020-06-19 | White | Indiana | 18181 | 245 | 10 |
256479 | 256479 | 2020-06-20 | White | Indiana | 18181 | 246 | 10 |
259605 | 259605 | 2020-06-21 | White | Indiana | 18181 | 249 | 10 |
262732 | 262732 | 2020-06-22 | White | Indiana | 18181 | 249 | 10 |
265860 | 265860 | 2020-06-23 | White | Indiana | 18181 | 249 | 10 |
268990 | 268990 | 2020-06-24 | White | Indiana | 18181 | 249 | 10 |
272127 | 272127 | 2020-06-25 | White | Indiana | 18181 | 249 | 10 |
275269 | 275269 | 2020-06-26 | White | Indiana | 18181 | 256 | 10 |
278417 | 278417 | 2020-06-27 | White | Indiana | 18181 | 253 | 10 |
281565 | 281565 | 2020-06-28 | White | Indiana | 18181 | 255 | 10 |
284710 | 284710 | 2020-06-29 | White | Indiana | 18181 | 255 | 10 |
287859 | 287859 | 2020-06-30 | White | Indiana | 18181 | 257 | 10 |
291009 | 291009 | 2020-07-01 | White | Indiana | 18181 | 258 | 10 |
294163 | 294163 | 2020-07-02 | White | Indiana | 18181 | 259 | 10 |
297321 | 297321 | 2020-07-03 | White | Indiana | 18181 | 260 | 10 |
300483 | 300483 | 2020-07-04 | White | Indiana | 18181 | 260 | 10 |
303647 | 303647 | 2020-07-05 | White | Indiana | 18181 | 263 | 10 |
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);