ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Union" and state = "Indiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- 2020-05-02 1
- 2020-05-03 1
- …
state 1
- Indiana · 770 ✖
fips 1
- 18161 770
county 1
- Union · 770 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
31419 | 31419 | 2020-04-04 | Union | Indiana | 18161 | 2 | 0 |
33830 | 33830 | 2020-04-05 | Union | Indiana | 18161 | 3 | 0 |
36284 | 36284 | 2020-04-06 | Union | Indiana | 18161 | 3 | 0 |
38782 | 38782 | 2020-04-07 | Union | Indiana | 18161 | 3 | 0 |
41328 | 41328 | 2020-04-08 | Union | Indiana | 18161 | 5 | 0 |
43904 | 43904 | 2020-04-09 | Union | Indiana | 18161 | 5 | 0 |
46509 | 46509 | 2020-04-10 | Union | Indiana | 18161 | 5 | 0 |
49143 | 49143 | 2020-04-11 | Union | Indiana | 18161 | 5 | 0 |
51807 | 51807 | 2020-04-12 | Union | Indiana | 18161 | 5 | 0 |
57181 | 57181 | 2020-04-14 | Union | Indiana | 18161 | 6 | 0 |
59889 | 59889 | 2020-04-15 | Union | Indiana | 18161 | 6 | 0 |
62610 | 62610 | 2020-04-16 | Union | Indiana | 18161 | 6 | 0 |
65344 | 65344 | 2020-04-17 | Union | Indiana | 18161 | 6 | 0 |
68093 | 68093 | 2020-04-18 | Union | Indiana | 18161 | 6 | 0 |
70855 | 70855 | 2020-04-19 | Union | Indiana | 18161 | 6 | 0 |
73626 | 73626 | 2020-04-20 | Union | Indiana | 18161 | 6 | 0 |
76403 | 76403 | 2020-04-21 | Union | Indiana | 18161 | 6 | 0 |
79187 | 79187 | 2020-04-22 | Union | Indiana | 18161 | 6 | 0 |
81980 | 81980 | 2020-04-23 | Union | Indiana | 18161 | 6 | 0 |
84780 | 84780 | 2020-04-24 | Union | Indiana | 18161 | 6 | 0 |
87590 | 87590 | 2020-04-25 | Union | Indiana | 18161 | 6 | 0 |
90406 | 90406 | 2020-04-26 | Union | Indiana | 18161 | 6 | 0 |
93225 | 93225 | 2020-04-27 | Union | Indiana | 18161 | 6 | 0 |
96057 | 96057 | 2020-04-28 | Union | Indiana | 18161 | 8 | 0 |
54488 | 54488 | 2020-04-13 | Union | Indiana | 18161 | 9 | 0 |
98901 | 98901 | 2020-04-29 | Union | Indiana | 18161 | 10 | 0 |
101752 | 101752 | 2020-04-30 | Union | Indiana | 18161 | 10 | 0 |
104608 | 104608 | 2020-05-01 | Union | Indiana | 18161 | 13 | 0 |
107473 | 107473 | 2020-05-02 | Union | Indiana | 18161 | 13 | 0 |
110343 | 110343 | 2020-05-03 | Union | Indiana | 18161 | 13 | 0 |
113218 | 113218 | 2020-05-04 | Union | Indiana | 18161 | 14 | 0 |
116101 | 116101 | 2020-05-05 | Union | Indiana | 18161 | 15 | 0 |
119061 | 119061 | 2020-05-06 | Union | Indiana | 18161 | 16 | 0 |
122031 | 122031 | 2020-05-07 | Union | Indiana | 18161 | 16 | 0 |
125011 | 125011 | 2020-05-08 | Union | Indiana | 18161 | 19 | 0 |
127998 | 127998 | 2020-05-09 | Union | Indiana | 18161 | 19 | 0 |
130989 | 130989 | 2020-05-10 | Union | Indiana | 18161 | 19 | 0 |
133979 | 133979 | 2020-05-11 | Union | Indiana | 18161 | 19 | 0 |
136968 | 136968 | 2020-05-12 | Union | Indiana | 18161 | 19 | 0 |
139960 | 139960 | 2020-05-13 | Union | Indiana | 18161 | 20 | 0 |
142956 | 142956 | 2020-05-14 | Union | Indiana | 18161 | 20 | 0 |
145956 | 145956 | 2020-05-15 | Union | Indiana | 18161 | 20 | 0 |
148960 | 148960 | 2020-05-16 | Union | Indiana | 18161 | 20 | 0 |
151969 | 151969 | 2020-05-17 | Union | Indiana | 18161 | 20 | 0 |
154981 | 154981 | 2020-05-18 | Union | Indiana | 18161 | 20 | 0 |
157997 | 157997 | 2020-05-19 | Union | Indiana | 18161 | 21 | 0 |
161023 | 161023 | 2020-05-20 | Union | Indiana | 18161 | 21 | 0 |
164051 | 164051 | 2020-05-21 | Union | Indiana | 18161 | 21 | 0 |
167084 | 167084 | 2020-05-22 | Union | Indiana | 18161 | 21 | 0 |
170121 | 170121 | 2020-05-23 | Union | Indiana | 18161 | 21 | 0 |
173162 | 173162 | 2020-05-24 | Union | Indiana | 18161 | 21 | 0 |
176206 | 176206 | 2020-05-25 | Union | Indiana | 18161 | 21 | 0 |
179250 | 179250 | 2020-05-26 | Union | Indiana | 18161 | 21 | 0 |
182294 | 182294 | 2020-05-27 | Union | Indiana | 18161 | 21 | 0 |
185348 | 185348 | 2020-05-28 | Union | Indiana | 18161 | 21 | 0 |
188406 | 188406 | 2020-05-29 | Union | Indiana | 18161 | 21 | 0 |
191471 | 191471 | 2020-05-30 | Union | Indiana | 18161 | 22 | 0 |
194538 | 194538 | 2020-05-31 | Union | Indiana | 18161 | 22 | 0 |
197608 | 197608 | 2020-06-01 | Union | Indiana | 18161 | 22 | 0 |
200681 | 200681 | 2020-06-02 | Union | Indiana | 18161 | 22 | 0 |
203757 | 203757 | 2020-06-03 | Union | Indiana | 18161 | 22 | 0 |
206837 | 206837 | 2020-06-04 | Union | Indiana | 18161 | 22 | 0 |
209918 | 209918 | 2020-06-05 | Union | Indiana | 18161 | 23 | 0 |
213003 | 213003 | 2020-06-06 | Union | Indiana | 18161 | 24 | 0 |
216090 | 216090 | 2020-06-07 | Union | Indiana | 18161 | 26 | 0 |
219182 | 219182 | 2020-06-08 | Union | Indiana | 18161 | 26 | 0 |
222277 | 222277 | 2020-06-09 | Union | Indiana | 18161 | 26 | 0 |
225372 | 225372 | 2020-06-10 | Union | Indiana | 18161 | 26 | 0 |
228474 | 228474 | 2020-06-11 | Union | Indiana | 18161 | 26 | 0 |
231577 | 231577 | 2020-06-12 | Union | Indiana | 18161 | 26 | 0 |
234683 | 234683 | 2020-06-13 | Union | Indiana | 18161 | 26 | 0 |
237790 | 237790 | 2020-06-14 | Union | Indiana | 18161 | 26 | 0 |
240898 | 240898 | 2020-06-15 | Union | Indiana | 18161 | 26 | 0 |
244009 | 244009 | 2020-06-16 | Union | Indiana | 18161 | 26 | 0 |
247122 | 247122 | 2020-06-17 | Union | Indiana | 18161 | 27 | 0 |
250234 | 250234 | 2020-06-18 | Union | Indiana | 18161 | 27 | 0 |
253349 | 253349 | 2020-06-19 | Union | Indiana | 18161 | 27 | 0 |
256469 | 256469 | 2020-06-20 | Union | Indiana | 18161 | 27 | 0 |
259595 | 259595 | 2020-06-21 | Union | Indiana | 18161 | 27 | 0 |
262722 | 262722 | 2020-06-22 | Union | Indiana | 18161 | 27 | 0 |
265850 | 265850 | 2020-06-23 | Union | Indiana | 18161 | 27 | 0 |
268980 | 268980 | 2020-06-24 | Union | Indiana | 18161 | 28 | 0 |
272117 | 272117 | 2020-06-25 | Union | Indiana | 18161 | 29 | 0 |
275259 | 275259 | 2020-06-26 | Union | Indiana | 18161 | 29 | 0 |
278407 | 278407 | 2020-06-27 | Union | Indiana | 18161 | 29 | 0 |
281555 | 281555 | 2020-06-28 | Union | Indiana | 18161 | 29 | 0 |
284700 | 284700 | 2020-06-29 | Union | Indiana | 18161 | 29 | 0 |
287849 | 287849 | 2020-06-30 | Union | Indiana | 18161 | 29 | 0 |
290999 | 290999 | 2020-07-01 | Union | Indiana | 18161 | 29 | 0 |
294153 | 294153 | 2020-07-02 | Union | Indiana | 18161 | 29 | 0 |
297311 | 297311 | 2020-07-03 | Union | Indiana | 18161 | 29 | 0 |
300473 | 300473 | 2020-07-04 | Union | Indiana | 18161 | 29 | 0 |
303637 | 303637 | 2020-07-05 | Union | Indiana | 18161 | 29 | 0 |
306802 | 306802 | 2020-07-06 | Union | Indiana | 18161 | 29 | 0 |
309970 | 309970 | 2020-07-07 | Union | Indiana | 18161 | 29 | 0 |
313140 | 313140 | 2020-07-08 | Union | Indiana | 18161 | 29 | 0 |
316314 | 316314 | 2020-07-09 | Union | Indiana | 18161 | 30 | 0 |
319487 | 319487 | 2020-07-10 | Union | Indiana | 18161 | 30 | 0 |
322666 | 322666 | 2020-07-11 | Union | Indiana | 18161 | 31 | 0 |
325847 | 325847 | 2020-07-12 | Union | Indiana | 18161 | 31 | 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);