ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Boone" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281480 | 281480 | 2020-06-28 | Boone | Indiana | 18011 | 429 | 44 |
278332 | 278332 | 2020-06-27 | Boone | Indiana | 18011 | 427 | 44 |
275184 | 275184 | 2020-06-26 | Boone | Indiana | 18011 | 424 | 44 |
272042 | 272042 | 2020-06-25 | Boone | Indiana | 18011 | 420 | 44 |
268905 | 268905 | 2020-06-24 | Boone | Indiana | 18011 | 418 | 44 |
265775 | 265775 | 2020-06-23 | Boone | Indiana | 18011 | 414 | 44 |
262647 | 262647 | 2020-06-22 | Boone | Indiana | 18011 | 411 | 43 |
259520 | 259520 | 2020-06-21 | Boone | Indiana | 18011 | 408 | 43 |
256394 | 256394 | 2020-06-20 | Boone | Indiana | 18011 | 406 | 43 |
253274 | 253274 | 2020-06-19 | Boone | Indiana | 18011 | 399 | 42 |
250159 | 250159 | 2020-06-18 | Boone | Indiana | 18011 | 398 | 42 |
247047 | 247047 | 2020-06-17 | Boone | Indiana | 18011 | 401 | 42 |
243934 | 243934 | 2020-06-16 | Boone | Indiana | 18011 | 400 | 41 |
240823 | 240823 | 2020-06-15 | Boone | Indiana | 18011 | 404 | 41 |
237715 | 237715 | 2020-06-14 | Boone | Indiana | 18011 | 378 | 40 |
234608 | 234608 | 2020-06-13 | Boone | Indiana | 18011 | 376 | 40 |
231502 | 231502 | 2020-06-12 | Boone | Indiana | 18011 | 375 | 39 |
228399 | 228399 | 2020-06-11 | Boone | Indiana | 18011 | 365 | 39 |
225297 | 225297 | 2020-06-10 | Boone | Indiana | 18011 | 357 | 39 |
222202 | 222202 | 2020-06-09 | Boone | Indiana | 18011 | 355 | 39 |
219107 | 219107 | 2020-06-08 | Boone | Indiana | 18011 | 349 | 39 |
216015 | 216015 | 2020-06-07 | Boone | Indiana | 18011 | 348 | 39 |
212928 | 212928 | 2020-06-06 | Boone | Indiana | 18011 | 345 | 39 |
209843 | 209843 | 2020-06-05 | Boone | Indiana | 18011 | 341 | 39 |
206762 | 206762 | 2020-06-04 | Boone | Indiana | 18011 | 341 | 38 |
203682 | 203682 | 2020-06-03 | Boone | Indiana | 18011 | 335 | 38 |
200606 | 200606 | 2020-06-02 | Boone | Indiana | 18011 | 333 | 38 |
197533 | 197533 | 2020-06-01 | Boone | Indiana | 18011 | 332 | 38 |
194463 | 194463 | 2020-05-31 | Boone | Indiana | 18011 | 332 | 38 |
191396 | 191396 | 2020-05-30 | Boone | Indiana | 18011 | 333 | 38 |
188331 | 188331 | 2020-05-29 | Boone | Indiana | 18011 | 327 | 38 |
185273 | 185273 | 2020-05-28 | Boone | Indiana | 18011 | 324 | 38 |
182219 | 182219 | 2020-05-27 | Boone | Indiana | 18011 | 312 | 38 |
179175 | 179175 | 2020-05-26 | Boone | Indiana | 18011 | 307 | 38 |
176131 | 176131 | 2020-05-25 | Boone | Indiana | 18011 | 301 | 38 |
173087 | 173087 | 2020-05-24 | Boone | Indiana | 18011 | 300 | 38 |
170046 | 170046 | 2020-05-23 | Boone | Indiana | 18011 | 298 | 38 |
167009 | 167009 | 2020-05-22 | Boone | Indiana | 18011 | 297 | 38 |
163976 | 163976 | 2020-05-21 | Boone | Indiana | 18011 | 295 | 38 |
160948 | 160948 | 2020-05-20 | Boone | Indiana | 18011 | 282 | 37 |
157922 | 157922 | 2020-05-19 | Boone | Indiana | 18011 | 280 | 37 |
154906 | 154906 | 2020-05-18 | Boone | Indiana | 18011 | 278 | 36 |
151894 | 151894 | 2020-05-17 | Boone | Indiana | 18011 | 276 | 35 |
148885 | 148885 | 2020-05-16 | Boone | Indiana | 18011 | 274 | 35 |
145881 | 145881 | 2020-05-15 | Boone | Indiana | 18011 | 270 | 34 |
142881 | 142881 | 2020-05-14 | Boone | Indiana | 18011 | 267 | 34 |
139885 | 139885 | 2020-05-13 | Boone | Indiana | 18011 | 254 | 34 |
136893 | 136893 | 2020-05-12 | Boone | Indiana | 18011 | 254 | 34 |
133904 | 133904 | 2020-05-11 | Boone | Indiana | 18011 | 240 | 34 |
130914 | 130914 | 2020-05-10 | Boone | Indiana | 18011 | 237 | 34 |
127923 | 127923 | 2020-05-09 | Boone | Indiana | 18011 | 233 | 33 |
124936 | 124936 | 2020-05-08 | Boone | Indiana | 18011 | 228 | 30 |
121956 | 121956 | 2020-05-07 | Boone | Indiana | 18011 | 222 | 30 |
118986 | 118986 | 2020-05-06 | Boone | Indiana | 18011 | 217 | 29 |
116026 | 116026 | 2020-05-05 | Boone | Indiana | 18011 | 217 | 29 |
113143 | 113143 | 2020-05-04 | Boone | Indiana | 18011 | 204 | 27 |
110268 | 110268 | 2020-05-03 | Boone | Indiana | 18011 | 203 | 26 |
107398 | 107398 | 2020-05-02 | Boone | Indiana | 18011 | 203 | 26 |
104533 | 104533 | 2020-05-01 | Boone | Indiana | 18011 | 194 | 26 |
101677 | 101677 | 2020-04-30 | Boone | Indiana | 18011 | 194 | 23 |
98826 | 98826 | 2020-04-29 | Boone | Indiana | 18011 | 190 | 23 |
95982 | 95982 | 2020-04-28 | Boone | Indiana | 18011 | 189 | 23 |
93150 | 93150 | 2020-04-27 | Boone | Indiana | 18011 | 187 | 23 |
90331 | 90331 | 2020-04-26 | Boone | Indiana | 18011 | 186 | 23 |
87515 | 87515 | 2020-04-25 | Boone | Indiana | 18011 | 186 | 22 |
84705 | 84705 | 2020-04-24 | Boone | Indiana | 18011 | 181 | 22 |
81905 | 81905 | 2020-04-23 | Boone | Indiana | 18011 | 176 | 22 |
79112 | 79112 | 2020-04-22 | Boone | Indiana | 18011 | 169 | 21 |
76328 | 76328 | 2020-04-21 | Boone | Indiana | 18011 | 164 | 20 |
73551 | 73551 | 2020-04-20 | Boone | Indiana | 18011 | 157 | 11 |
70780 | 70780 | 2020-04-19 | Boone | Indiana | 18011 | 156 | 11 |
68018 | 68018 | 2020-04-18 | Boone | Indiana | 18011 | 154 | 11 |
65269 | 65269 | 2020-04-17 | Boone | Indiana | 18011 | 147 | 9 |
62535 | 62535 | 2020-04-16 | Boone | Indiana | 18011 | 137 | 6 |
59814 | 59814 | 2020-04-15 | Boone | Indiana | 18011 | 130 | 5 |
57106 | 57106 | 2020-04-14 | Boone | Indiana | 18011 | 126 | 4 |
54413 | 54413 | 2020-04-13 | Boone | Indiana | 18011 | 110 | 3 |
51732 | 51732 | 2020-04-12 | Boone | Indiana | 18011 | 110 | 3 |
49069 | 49069 | 2020-04-11 | Boone | Indiana | 18011 | 104 | 3 |
46435 | 46435 | 2020-04-10 | Boone | Indiana | 18011 | 91 | 3 |
43831 | 43831 | 2020-04-09 | Boone | Indiana | 18011 | 85 | 3 |
41255 | 41255 | 2020-04-08 | Boone | Indiana | 18011 | 77 | 3 |
38709 | 38709 | 2020-04-07 | Boone | Indiana | 18011 | 75 | 2 |
36211 | 36211 | 2020-04-06 | Boone | Indiana | 18011 | 65 | 2 |
33758 | 33758 | 2020-04-05 | Boone | Indiana | 18011 | 58 | 2 |
31348 | 31348 | 2020-04-04 | Boone | Indiana | 18011 | 50 | 0 |
28982 | 28982 | 2020-04-03 | Boone | Indiana | 18011 | 38 | 0 |
26672 | 26672 | 2020-04-02 | Boone | Indiana | 18011 | 32 | 0 |
24433 | 24433 | 2020-04-01 | Boone | Indiana | 18011 | 29 | 0 |
22263 | 22263 | 2020-03-31 | Boone | Indiana | 18011 | 22 | 0 |
20170 | 20170 | 2020-03-30 | Boone | Indiana | 18011 | 20 | 0 |
18164 | 18164 | 2020-03-29 | Boone | Indiana | 18011 | 13 | 0 |
16263 | 16263 | 2020-03-28 | Boone | Indiana | 18011 | 8 | 0 |
14466 | 14466 | 2020-03-27 | Boone | Indiana | 18011 | 7 | 0 |
12788 | 12788 | 2020-03-26 | Boone | Indiana | 18011 | 7 | 0 |
11232 | 11232 | 2020-03-25 | Boone | Indiana | 18011 | 4 | 0 |
9839 | 9839 | 2020-03-24 | Boone | Indiana | 18011 | 3 | 0 |
8575 | 8575 | 2020-03-23 | Boone | Indiana | 18011 | 3 | 0 |
7418 | 7418 | 2020-03-22 | Boone | Indiana | 18011 | 3 | 0 |
6364 | 6364 | 2020-03-21 | Boone | Indiana | 18011 | 2 | 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);