ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Dubois" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8578 | 8578 | 2020-03-23 | Dubois | Indiana | 18037 | 1 | 0 |
9845 | 9845 | 2020-03-24 | Dubois | Indiana | 18037 | 1 | 0 |
11239 | 11239 | 2020-03-25 | Dubois | Indiana | 18037 | 1 | 0 |
12795 | 12795 | 2020-03-26 | Dubois | Indiana | 18037 | 1 | 0 |
14475 | 14475 | 2020-03-27 | Dubois | Indiana | 18037 | 1 | 0 |
16273 | 16273 | 2020-03-28 | Dubois | Indiana | 18037 | 1 | 0 |
18175 | 18175 | 2020-03-29 | Dubois | Indiana | 18037 | 2 | 0 |
20181 | 20181 | 2020-03-30 | Dubois | Indiana | 18037 | 2 | 0 |
22275 | 22275 | 2020-03-31 | Dubois | Indiana | 18037 | 3 | 0 |
24445 | 24445 | 2020-04-01 | Dubois | Indiana | 18037 | 3 | 0 |
26684 | 26684 | 2020-04-02 | Dubois | Indiana | 18037 | 3 | 0 |
28994 | 28994 | 2020-04-03 | Dubois | Indiana | 18037 | 3 | 0 |
31360 | 31360 | 2020-04-04 | Dubois | Indiana | 18037 | 4 | 0 |
33771 | 33771 | 2020-04-05 | Dubois | Indiana | 18037 | 6 | 0 |
36224 | 36224 | 2020-04-06 | Dubois | Indiana | 18037 | 7 | 0 |
38722 | 38722 | 2020-04-07 | Dubois | Indiana | 18037 | 7 | 0 |
41268 | 41268 | 2020-04-08 | Dubois | Indiana | 18037 | 9 | 0 |
43844 | 43844 | 2020-04-09 | Dubois | Indiana | 18037 | 10 | 0 |
46448 | 46448 | 2020-04-10 | Dubois | Indiana | 18037 | 10 | 0 |
49082 | 49082 | 2020-04-11 | Dubois | Indiana | 18037 | 11 | 0 |
51745 | 51745 | 2020-04-12 | Dubois | Indiana | 18037 | 13 | 0 |
54426 | 54426 | 2020-04-13 | Dubois | Indiana | 18037 | 13 | 0 |
57119 | 57119 | 2020-04-14 | Dubois | Indiana | 18037 | 13 | 0 |
59827 | 59827 | 2020-04-15 | Dubois | Indiana | 18037 | 14 | 0 |
62548 | 62548 | 2020-04-16 | Dubois | Indiana | 18037 | 14 | 0 |
65282 | 65282 | 2020-04-17 | Dubois | Indiana | 18037 | 14 | 0 |
68031 | 68031 | 2020-04-18 | Dubois | Indiana | 18037 | 14 | 0 |
70793 | 70793 | 2020-04-19 | Dubois | Indiana | 18037 | 16 | 0 |
73564 | 73564 | 2020-04-20 | Dubois | Indiana | 18037 | 16 | 0 |
76341 | 76341 | 2020-04-21 | Dubois | Indiana | 18037 | 16 | 0 |
79125 | 79125 | 2020-04-22 | Dubois | Indiana | 18037 | 16 | 0 |
81918 | 81918 | 2020-04-23 | Dubois | Indiana | 18037 | 16 | 0 |
84718 | 84718 | 2020-04-24 | Dubois | Indiana | 18037 | 17 | 0 |
87528 | 87528 | 2020-04-25 | Dubois | Indiana | 18037 | 17 | 0 |
90344 | 90344 | 2020-04-26 | Dubois | Indiana | 18037 | 17 | 0 |
93163 | 93163 | 2020-04-27 | Dubois | Indiana | 18037 | 18 | 0 |
95995 | 95995 | 2020-04-28 | Dubois | Indiana | 18037 | 19 | 0 |
98839 | 98839 | 2020-04-29 | Dubois | Indiana | 18037 | 21 | 0 |
101690 | 101690 | 2020-04-30 | Dubois | Indiana | 18037 | 23 | 0 |
104546 | 104546 | 2020-05-01 | Dubois | Indiana | 18037 | 23 | 0 |
107411 | 107411 | 2020-05-02 | Dubois | Indiana | 18037 | 24 | 0 |
110281 | 110281 | 2020-05-03 | Dubois | Indiana | 18037 | 25 | 0 |
113156 | 113156 | 2020-05-04 | Dubois | Indiana | 18037 | 25 | 0 |
116039 | 116039 | 2020-05-05 | Dubois | Indiana | 18037 | 27 | 0 |
118999 | 118999 | 2020-05-06 | Dubois | Indiana | 18037 | 30 | 0 |
121969 | 121969 | 2020-05-07 | Dubois | Indiana | 18037 | 35 | 0 |
124949 | 124949 | 2020-05-08 | Dubois | Indiana | 18037 | 38 | 0 |
127936 | 127936 | 2020-05-09 | Dubois | Indiana | 18037 | 42 | 0 |
130927 | 130927 | 2020-05-10 | Dubois | Indiana | 18037 | 45 | 0 |
133917 | 133917 | 2020-05-11 | Dubois | Indiana | 18037 | 46 | 0 |
136906 | 136906 | 2020-05-12 | Dubois | Indiana | 18037 | 59 | 1 |
139898 | 139898 | 2020-05-13 | Dubois | Indiana | 18037 | 66 | 2 |
142894 | 142894 | 2020-05-14 | Dubois | Indiana | 18037 | 69 | 2 |
145894 | 145894 | 2020-05-15 | Dubois | Indiana | 18037 | 70 | 2 |
148898 | 148898 | 2020-05-16 | Dubois | Indiana | 18037 | 85 | 2 |
151907 | 151907 | 2020-05-17 | Dubois | Indiana | 18037 | 115 | 2 |
154919 | 154919 | 2020-05-18 | Dubois | Indiana | 18037 | 161 | 2 |
157935 | 157935 | 2020-05-19 | Dubois | Indiana | 18037 | 162 | 2 |
160961 | 160961 | 2020-05-20 | Dubois | Indiana | 18037 | 162 | 2 |
163989 | 163989 | 2020-05-21 | Dubois | Indiana | 18037 | 168 | 2 |
167022 | 167022 | 2020-05-22 | Dubois | Indiana | 18037 | 171 | 2 |
170059 | 170059 | 2020-05-23 | Dubois | Indiana | 18037 | 171 | 2 |
173100 | 173100 | 2020-05-24 | Dubois | Indiana | 18037 | 178 | 2 |
176144 | 176144 | 2020-05-25 | Dubois | Indiana | 18037 | 182 | 2 |
179188 | 179188 | 2020-05-26 | Dubois | Indiana | 18037 | 185 | 2 |
182232 | 182232 | 2020-05-27 | Dubois | Indiana | 18037 | 185 | 2 |
185286 | 185286 | 2020-05-28 | Dubois | Indiana | 18037 | 190 | 3 |
188344 | 188344 | 2020-05-29 | Dubois | Indiana | 18037 | 192 | 3 |
191409 | 191409 | 2020-05-30 | Dubois | Indiana | 18037 | 199 | 3 |
194476 | 194476 | 2020-05-31 | Dubois | Indiana | 18037 | 199 | 3 |
197546 | 197546 | 2020-06-01 | Dubois | Indiana | 18037 | 199 | 3 |
200619 | 200619 | 2020-06-02 | Dubois | Indiana | 18037 | 202 | 3 |
203695 | 203695 | 2020-06-03 | Dubois | Indiana | 18037 | 205 | 3 |
206775 | 206775 | 2020-06-04 | Dubois | Indiana | 18037 | 209 | 3 |
209856 | 209856 | 2020-06-05 | Dubois | Indiana | 18037 | 211 | 3 |
212941 | 212941 | 2020-06-06 | Dubois | Indiana | 18037 | 216 | 3 |
216028 | 216028 | 2020-06-07 | Dubois | Indiana | 18037 | 228 | 4 |
219120 | 219120 | 2020-06-08 | Dubois | Indiana | 18037 | 230 | 4 |
222215 | 222215 | 2020-06-09 | Dubois | Indiana | 18037 | 231 | 4 |
225310 | 225310 | 2020-06-10 | Dubois | Indiana | 18037 | 231 | 4 |
228412 | 228412 | 2020-06-11 | Dubois | Indiana | 18037 | 233 | 4 |
231515 | 231515 | 2020-06-12 | Dubois | Indiana | 18037 | 236 | 4 |
234621 | 234621 | 2020-06-13 | Dubois | Indiana | 18037 | 238 | 4 |
237728 | 237728 | 2020-06-14 | Dubois | Indiana | 18037 | 240 | 4 |
240836 | 240836 | 2020-06-15 | Dubois | Indiana | 18037 | 241 | 4 |
243947 | 243947 | 2020-06-16 | Dubois | Indiana | 18037 | 242 | 5 |
247060 | 247060 | 2020-06-17 | Dubois | Indiana | 18037 | 243 | 5 |
250172 | 250172 | 2020-06-18 | Dubois | Indiana | 18037 | 246 | 5 |
253287 | 253287 | 2020-06-19 | Dubois | Indiana | 18037 | 249 | 6 |
256407 | 256407 | 2020-06-20 | Dubois | Indiana | 18037 | 249 | 6 |
259533 | 259533 | 2020-06-21 | Dubois | Indiana | 18037 | 251 | 6 |
262660 | 262660 | 2020-06-22 | Dubois | Indiana | 18037 | 252 | 6 |
265788 | 265788 | 2020-06-23 | Dubois | Indiana | 18037 | 251 | 6 |
268918 | 268918 | 2020-06-24 | Dubois | Indiana | 18037 | 255 | 6 |
272055 | 272055 | 2020-06-25 | Dubois | Indiana | 18037 | 255 | 6 |
275197 | 275197 | 2020-06-26 | Dubois | Indiana | 18037 | 255 | 6 |
278345 | 278345 | 2020-06-27 | Dubois | Indiana | 18037 | 256 | 6 |
281493 | 281493 | 2020-06-28 | Dubois | Indiana | 18037 | 258 | 6 |
284638 | 284638 | 2020-06-29 | Dubois | Indiana | 18037 | 258 | 6 |
287787 | 287787 | 2020-06-30 | Dubois | Indiana | 18037 | 259 | 6 |
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);