ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Jefferson" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386676 | 386676 | 2020-07-31 | Jefferson | Indiana | 18077 | 146 | 2 |
383458 | 383458 | 2020-07-30 | Jefferson | Indiana | 18077 | 146 | 2 |
380241 | 380241 | 2020-07-29 | Jefferson | Indiana | 18077 | 146 | 2 |
377024 | 377024 | 2020-07-28 | Jefferson | Indiana | 18077 | 146 | 2 |
373809 | 373809 | 2020-07-27 | Jefferson | Indiana | 18077 | 144 | 2 |
370597 | 370597 | 2020-07-26 | Jefferson | Indiana | 18077 | 143 | 2 |
367387 | 367387 | 2020-07-25 | Jefferson | Indiana | 18077 | 143 | 2 |
364180 | 364180 | 2020-07-24 | Jefferson | Indiana | 18077 | 139 | 2 |
360973 | 360973 | 2020-07-23 | Jefferson | Indiana | 18077 | 138 | 2 |
357768 | 357768 | 2020-07-22 | Jefferson | Indiana | 18077 | 137 | 2 |
354566 | 354566 | 2020-07-21 | Jefferson | Indiana | 18077 | 134 | 2 |
351364 | 351364 | 2020-07-20 | Jefferson | Indiana | 18077 | 126 | 2 |
348164 | 348164 | 2020-07-19 | Jefferson | Indiana | 18077 | 125 | 2 |
344963 | 344963 | 2020-07-18 | Jefferson | Indiana | 18077 | 123 | 2 |
341763 | 341763 | 2020-07-17 | Jefferson | Indiana | 18077 | 117 | 2 |
338567 | 338567 | 2020-07-16 | Jefferson | Indiana | 18077 | 112 | 2 |
335371 | 335371 | 2020-07-15 | Jefferson | Indiana | 18077 | 99 | 2 |
332178 | 332178 | 2020-07-14 | Jefferson | Indiana | 18077 | 94 | 2 |
328991 | 328991 | 2020-07-13 | Jefferson | Indiana | 18077 | 88 | 2 |
325805 | 325805 | 2020-07-12 | Jefferson | Indiana | 18077 | 88 | 2 |
322624 | 322624 | 2020-07-11 | Jefferson | Indiana | 18077 | 87 | 2 |
319445 | 319445 | 2020-07-10 | Jefferson | Indiana | 18077 | 79 | 2 |
316272 | 316272 | 2020-07-09 | Jefferson | Indiana | 18077 | 79 | 2 |
313098 | 313098 | 2020-07-08 | Jefferson | Indiana | 18077 | 77 | 2 |
309928 | 309928 | 2020-07-07 | Jefferson | Indiana | 18077 | 73 | 2 |
306760 | 306760 | 2020-07-06 | Jefferson | Indiana | 18077 | 73 | 2 |
303595 | 303595 | 2020-07-05 | Jefferson | Indiana | 18077 | 73 | 2 |
300431 | 300431 | 2020-07-04 | Jefferson | Indiana | 18077 | 73 | 2 |
297269 | 297269 | 2020-07-03 | Jefferson | Indiana | 18077 | 71 | 1 |
294111 | 294111 | 2020-07-02 | Jefferson | Indiana | 18077 | 67 | 1 |
290957 | 290957 | 2020-07-01 | Jefferson | Indiana | 18077 | 66 | 1 |
287807 | 287807 | 2020-06-30 | Jefferson | Indiana | 18077 | 65 | 1 |
284658 | 284658 | 2020-06-29 | Jefferson | Indiana | 18077 | 64 | 1 |
281513 | 281513 | 2020-06-28 | Jefferson | Indiana | 18077 | 64 | 1 |
278365 | 278365 | 2020-06-27 | Jefferson | Indiana | 18077 | 63 | 1 |
275217 | 275217 | 2020-06-26 | Jefferson | Indiana | 18077 | 59 | 1 |
272075 | 272075 | 2020-06-25 | Jefferson | Indiana | 18077 | 59 | 1 |
268938 | 268938 | 2020-06-24 | Jefferson | Indiana | 18077 | 59 | 1 |
265808 | 265808 | 2020-06-23 | Jefferson | Indiana | 18077 | 59 | 1 |
262680 | 262680 | 2020-06-22 | Jefferson | Indiana | 18077 | 57 | 1 |
259553 | 259553 | 2020-06-21 | Jefferson | Indiana | 18077 | 57 | 1 |
256427 | 256427 | 2020-06-20 | Jefferson | Indiana | 18077 | 57 | 1 |
253307 | 253307 | 2020-06-19 | Jefferson | Indiana | 18077 | 56 | 1 |
250192 | 250192 | 2020-06-18 | Jefferson | Indiana | 18077 | 56 | 1 |
247080 | 247080 | 2020-06-17 | Jefferson | Indiana | 18077 | 55 | 1 |
243967 | 243967 | 2020-06-16 | Jefferson | Indiana | 18077 | 54 | 1 |
240856 | 240856 | 2020-06-15 | Jefferson | Indiana | 18077 | 54 | 1 |
237748 | 237748 | 2020-06-14 | Jefferson | Indiana | 18077 | 54 | 1 |
234641 | 234641 | 2020-06-13 | Jefferson | Indiana | 18077 | 54 | 1 |
231535 | 231535 | 2020-06-12 | Jefferson | Indiana | 18077 | 53 | 1 |
228432 | 228432 | 2020-06-11 | Jefferson | Indiana | 18077 | 52 | 1 |
225330 | 225330 | 2020-06-10 | Jefferson | Indiana | 18077 | 52 | 1 |
222235 | 222235 | 2020-06-09 | Jefferson | Indiana | 18077 | 53 | 1 |
219140 | 219140 | 2020-06-08 | Jefferson | Indiana | 18077 | 52 | 1 |
216048 | 216048 | 2020-06-07 | Jefferson | Indiana | 18077 | 50 | 1 |
212961 | 212961 | 2020-06-06 | Jefferson | Indiana | 18077 | 50 | 1 |
209876 | 209876 | 2020-06-05 | Jefferson | Indiana | 18077 | 50 | 1 |
206795 | 206795 | 2020-06-04 | Jefferson | Indiana | 18077 | 50 | 1 |
203715 | 203715 | 2020-06-03 | Jefferson | Indiana | 18077 | 48 | 1 |
200639 | 200639 | 2020-06-02 | Jefferson | Indiana | 18077 | 47 | 1 |
197566 | 197566 | 2020-06-01 | Jefferson | Indiana | 18077 | 46 | 1 |
194496 | 194496 | 2020-05-31 | Jefferson | Indiana | 18077 | 46 | 1 |
191429 | 191429 | 2020-05-30 | Jefferson | Indiana | 18077 | 46 | 1 |
188364 | 188364 | 2020-05-29 | Jefferson | Indiana | 18077 | 44 | 1 |
185306 | 185306 | 2020-05-28 | Jefferson | Indiana | 18077 | 44 | 1 |
182252 | 182252 | 2020-05-27 | Jefferson | Indiana | 18077 | 43 | 1 |
179208 | 179208 | 2020-05-26 | Jefferson | Indiana | 18077 | 42 | 1 |
176164 | 176164 | 2020-05-25 | Jefferson | Indiana | 18077 | 42 | 1 |
173120 | 173120 | 2020-05-24 | Jefferson | Indiana | 18077 | 42 | 1 |
170079 | 170079 | 2020-05-23 | Jefferson | Indiana | 18077 | 42 | 1 |
167042 | 167042 | 2020-05-22 | Jefferson | Indiana | 18077 | 42 | 1 |
164009 | 164009 | 2020-05-21 | Jefferson | Indiana | 18077 | 42 | 1 |
160981 | 160981 | 2020-05-20 | Jefferson | Indiana | 18077 | 42 | 1 |
157955 | 157955 | 2020-05-19 | Jefferson | Indiana | 18077 | 41 | 1 |
154939 | 154939 | 2020-05-18 | Jefferson | Indiana | 18077 | 40 | 1 |
151927 | 151927 | 2020-05-17 | Jefferson | Indiana | 18077 | 36 | 1 |
148918 | 148918 | 2020-05-16 | Jefferson | Indiana | 18077 | 35 | 1 |
145914 | 145914 | 2020-05-15 | Jefferson | Indiana | 18077 | 36 | 1 |
142914 | 142914 | 2020-05-14 | Jefferson | Indiana | 18077 | 36 | 1 |
139918 | 139918 | 2020-05-13 | Jefferson | Indiana | 18077 | 36 | 0 |
136926 | 136926 | 2020-05-12 | Jefferson | Indiana | 18077 | 36 | 0 |
133937 | 133937 | 2020-05-11 | Jefferson | Indiana | 18077 | 36 | 0 |
130947 | 130947 | 2020-05-10 | Jefferson | Indiana | 18077 | 36 | 0 |
127956 | 127956 | 2020-05-09 | Jefferson | Indiana | 18077 | 35 | 0 |
124969 | 124969 | 2020-05-08 | Jefferson | Indiana | 18077 | 35 | 0 |
121989 | 121989 | 2020-05-07 | Jefferson | Indiana | 18077 | 33 | 0 |
119019 | 119019 | 2020-05-06 | Jefferson | Indiana | 18077 | 31 | 0 |
116059 | 116059 | 2020-05-05 | Jefferson | Indiana | 18077 | 31 | 0 |
113176 | 113176 | 2020-05-04 | Jefferson | Indiana | 18077 | 31 | 0 |
110301 | 110301 | 2020-05-03 | Jefferson | Indiana | 18077 | 31 | 0 |
107431 | 107431 | 2020-05-02 | Jefferson | Indiana | 18077 | 31 | 0 |
104566 | 104566 | 2020-05-01 | Jefferson | Indiana | 18077 | 30 | 0 |
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 |
90364 | 90364 | 2020-04-26 | Jefferson | Indiana | 18077 | 23 | 0 |
87548 | 87548 | 2020-04-25 | Jefferson | Indiana | 18077 | 23 | 0 |
84738 | 84738 | 2020-04-24 | Jefferson | Indiana | 18077 | 23 | 0 |
81938 | 81938 | 2020-04-23 | Jefferson | Indiana | 18077 | 23 | 0 |
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);