ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Union", fips = 18161 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386718 | 386718 | 2020-07-31 | Union | Indiana | 18161 | 50 | 0 |
383500 | 383500 | 2020-07-30 | Union | Indiana | 18161 | 50 | 0 |
380283 | 380283 | 2020-07-29 | Union | Indiana | 18161 | 46 | 0 |
377066 | 377066 | 2020-07-28 | Union | Indiana | 18161 | 46 | 0 |
373851 | 373851 | 2020-07-27 | Union | Indiana | 18161 | 46 | 0 |
370639 | 370639 | 2020-07-26 | Union | Indiana | 18161 | 44 | 0 |
367429 | 367429 | 2020-07-25 | Union | Indiana | 18161 | 44 | 0 |
364222 | 364222 | 2020-07-24 | Union | Indiana | 18161 | 43 | 0 |
361015 | 361015 | 2020-07-23 | Union | Indiana | 18161 | 41 | 0 |
357810 | 357810 | 2020-07-22 | Union | Indiana | 18161 | 41 | 0 |
354608 | 354608 | 2020-07-21 | Union | Indiana | 18161 | 39 | 0 |
351406 | 351406 | 2020-07-20 | Union | Indiana | 18161 | 36 | 0 |
348206 | 348206 | 2020-07-19 | Union | Indiana | 18161 | 36 | 0 |
345005 | 345005 | 2020-07-18 | Union | Indiana | 18161 | 36 | 0 |
341805 | 341805 | 2020-07-17 | Union | Indiana | 18161 | 36 | 0 |
338609 | 338609 | 2020-07-16 | Union | Indiana | 18161 | 36 | 0 |
335413 | 335413 | 2020-07-15 | Union | Indiana | 18161 | 36 | 0 |
332220 | 332220 | 2020-07-14 | Union | Indiana | 18161 | 33 | 0 |
329033 | 329033 | 2020-07-13 | Union | Indiana | 18161 | 32 | 0 |
325847 | 325847 | 2020-07-12 | Union | Indiana | 18161 | 31 | 0 |
322666 | 322666 | 2020-07-11 | Union | Indiana | 18161 | 31 | 0 |
319487 | 319487 | 2020-07-10 | Union | Indiana | 18161 | 30 | 0 |
316314 | 316314 | 2020-07-09 | Union | Indiana | 18161 | 30 | 0 |
313140 | 313140 | 2020-07-08 | Union | Indiana | 18161 | 29 | 0 |
309970 | 309970 | 2020-07-07 | Union | Indiana | 18161 | 29 | 0 |
306802 | 306802 | 2020-07-06 | Union | Indiana | 18161 | 29 | 0 |
303637 | 303637 | 2020-07-05 | Union | Indiana | 18161 | 29 | 0 |
300473 | 300473 | 2020-07-04 | Union | Indiana | 18161 | 29 | 0 |
297311 | 297311 | 2020-07-03 | Union | Indiana | 18161 | 29 | 0 |
294153 | 294153 | 2020-07-02 | Union | Indiana | 18161 | 29 | 0 |
290999 | 290999 | 2020-07-01 | Union | Indiana | 18161 | 29 | 0 |
287849 | 287849 | 2020-06-30 | Union | Indiana | 18161 | 29 | 0 |
284700 | 284700 | 2020-06-29 | Union | Indiana | 18161 | 29 | 0 |
281555 | 281555 | 2020-06-28 | Union | Indiana | 18161 | 29 | 0 |
278407 | 278407 | 2020-06-27 | Union | Indiana | 18161 | 29 | 0 |
275259 | 275259 | 2020-06-26 | Union | Indiana | 18161 | 29 | 0 |
272117 | 272117 | 2020-06-25 | Union | Indiana | 18161 | 29 | 0 |
268980 | 268980 | 2020-06-24 | Union | Indiana | 18161 | 28 | 0 |
265850 | 265850 | 2020-06-23 | Union | Indiana | 18161 | 27 | 0 |
262722 | 262722 | 2020-06-22 | Union | Indiana | 18161 | 27 | 0 |
259595 | 259595 | 2020-06-21 | Union | Indiana | 18161 | 27 | 0 |
256469 | 256469 | 2020-06-20 | Union | Indiana | 18161 | 27 | 0 |
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 |
244009 | 244009 | 2020-06-16 | Union | Indiana | 18161 | 26 | 0 |
240898 | 240898 | 2020-06-15 | Union | Indiana | 18161 | 26 | 0 |
237790 | 237790 | 2020-06-14 | Union | Indiana | 18161 | 26 | 0 |
234683 | 234683 | 2020-06-13 | Union | Indiana | 18161 | 26 | 0 |
231577 | 231577 | 2020-06-12 | Union | Indiana | 18161 | 26 | 0 |
228474 | 228474 | 2020-06-11 | Union | Indiana | 18161 | 26 | 0 |
225372 | 225372 | 2020-06-10 | Union | Indiana | 18161 | 26 | 0 |
222277 | 222277 | 2020-06-09 | Union | Indiana | 18161 | 26 | 0 |
219182 | 219182 | 2020-06-08 | Union | Indiana | 18161 | 26 | 0 |
216090 | 216090 | 2020-06-07 | Union | Indiana | 18161 | 26 | 0 |
213003 | 213003 | 2020-06-06 | Union | Indiana | 18161 | 24 | 0 |
209918 | 209918 | 2020-06-05 | Union | Indiana | 18161 | 23 | 0 |
206837 | 206837 | 2020-06-04 | Union | Indiana | 18161 | 22 | 0 |
203757 | 203757 | 2020-06-03 | Union | Indiana | 18161 | 22 | 0 |
200681 | 200681 | 2020-06-02 | Union | Indiana | 18161 | 22 | 0 |
197608 | 197608 | 2020-06-01 | Union | Indiana | 18161 | 22 | 0 |
194538 | 194538 | 2020-05-31 | Union | Indiana | 18161 | 22 | 0 |
191471 | 191471 | 2020-05-30 | Union | Indiana | 18161 | 22 | 0 |
188406 | 188406 | 2020-05-29 | Union | Indiana | 18161 | 21 | 0 |
185348 | 185348 | 2020-05-28 | Union | Indiana | 18161 | 21 | 0 |
182294 | 182294 | 2020-05-27 | Union | Indiana | 18161 | 21 | 0 |
179250 | 179250 | 2020-05-26 | Union | Indiana | 18161 | 21 | 0 |
176206 | 176206 | 2020-05-25 | Union | Indiana | 18161 | 21 | 0 |
173162 | 173162 | 2020-05-24 | Union | Indiana | 18161 | 21 | 0 |
170121 | 170121 | 2020-05-23 | Union | Indiana | 18161 | 21 | 0 |
167084 | 167084 | 2020-05-22 | Union | Indiana | 18161 | 21 | 0 |
164051 | 164051 | 2020-05-21 | Union | Indiana | 18161 | 21 | 0 |
161023 | 161023 | 2020-05-20 | Union | Indiana | 18161 | 21 | 0 |
157997 | 157997 | 2020-05-19 | Union | Indiana | 18161 | 21 | 0 |
154981 | 154981 | 2020-05-18 | Union | Indiana | 18161 | 20 | 0 |
151969 | 151969 | 2020-05-17 | Union | Indiana | 18161 | 20 | 0 |
148960 | 148960 | 2020-05-16 | Union | Indiana | 18161 | 20 | 0 |
145956 | 145956 | 2020-05-15 | Union | Indiana | 18161 | 20 | 0 |
142956 | 142956 | 2020-05-14 | Union | Indiana | 18161 | 20 | 0 |
139960 | 139960 | 2020-05-13 | Union | Indiana | 18161 | 20 | 0 |
136968 | 136968 | 2020-05-12 | Union | Indiana | 18161 | 19 | 0 |
133979 | 133979 | 2020-05-11 | Union | Indiana | 18161 | 19 | 0 |
130989 | 130989 | 2020-05-10 | Union | Indiana | 18161 | 19 | 0 |
127998 | 127998 | 2020-05-09 | Union | Indiana | 18161 | 19 | 0 |
125011 | 125011 | 2020-05-08 | Union | Indiana | 18161 | 19 | 0 |
122031 | 122031 | 2020-05-07 | Union | Indiana | 18161 | 16 | 0 |
119061 | 119061 | 2020-05-06 | Union | Indiana | 18161 | 16 | 0 |
116101 | 116101 | 2020-05-05 | Union | Indiana | 18161 | 15 | 0 |
113218 | 113218 | 2020-05-04 | Union | Indiana | 18161 | 14 | 0 |
110343 | 110343 | 2020-05-03 | Union | Indiana | 18161 | 13 | 0 |
107473 | 107473 | 2020-05-02 | Union | Indiana | 18161 | 13 | 0 |
104608 | 104608 | 2020-05-01 | Union | Indiana | 18161 | 13 | 0 |
101752 | 101752 | 2020-04-30 | Union | Indiana | 18161 | 10 | 0 |
98901 | 98901 | 2020-04-29 | Union | Indiana | 18161 | 10 | 0 |
96057 | 96057 | 2020-04-28 | Union | Indiana | 18161 | 8 | 0 |
93225 | 93225 | 2020-04-27 | Union | Indiana | 18161 | 6 | 0 |
90406 | 90406 | 2020-04-26 | Union | Indiana | 18161 | 6 | 0 |
87590 | 87590 | 2020-04-25 | Union | Indiana | 18161 | 6 | 0 |
84780 | 84780 | 2020-04-24 | Union | Indiana | 18161 | 6 | 0 |
81980 | 81980 | 2020-04-23 | Union | Indiana | 18161 | 6 | 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);