ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Marshall" and fips = 18099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386687 | 386687 | 2020-07-31 | Marshall | Indiana | 18099 | 732 | 22 |
383469 | 383469 | 2020-07-30 | Marshall | Indiana | 18099 | 722 | 21 |
380252 | 380252 | 2020-07-29 | Marshall | Indiana | 18099 | 720 | 20 |
377035 | 377035 | 2020-07-28 | Marshall | Indiana | 18099 | 718 | 20 |
373820 | 373820 | 2020-07-27 | Marshall | Indiana | 18099 | 712 | 19 |
370608 | 370608 | 2020-07-26 | Marshall | Indiana | 18099 | 702 | 19 |
367398 | 367398 | 2020-07-25 | Marshall | Indiana | 18099 | 700 | 19 |
364191 | 364191 | 2020-07-24 | Marshall | Indiana | 18099 | 695 | 18 |
360984 | 360984 | 2020-07-23 | Marshall | Indiana | 18099 | 686 | 18 |
357779 | 357779 | 2020-07-22 | Marshall | Indiana | 18099 | 682 | 16 |
354577 | 354577 | 2020-07-21 | Marshall | Indiana | 18099 | 671 | 14 |
351375 | 351375 | 2020-07-20 | Marshall | Indiana | 18099 | 663 | 13 |
348175 | 348175 | 2020-07-19 | Marshall | Indiana | 18099 | 659 | 13 |
344974 | 344974 | 2020-07-18 | Marshall | Indiana | 18099 | 645 | 13 |
341774 | 341774 | 2020-07-17 | Marshall | Indiana | 18099 | 636 | 12 |
338578 | 338578 | 2020-07-16 | Marshall | Indiana | 18099 | 623 | 12 |
335382 | 335382 | 2020-07-15 | Marshall | Indiana | 18099 | 601 | 12 |
332189 | 332189 | 2020-07-14 | Marshall | Indiana | 18099 | 574 | 12 |
329002 | 329002 | 2020-07-13 | Marshall | Indiana | 18099 | 570 | 11 |
325816 | 325816 | 2020-07-12 | Marshall | Indiana | 18099 | 557 | 9 |
322635 | 322635 | 2020-07-11 | Marshall | Indiana | 18099 | 544 | 9 |
319456 | 319456 | 2020-07-10 | Marshall | Indiana | 18099 | 530 | 8 |
316283 | 316283 | 2020-07-09 | Marshall | Indiana | 18099 | 521 | 7 |
313109 | 313109 | 2020-07-08 | Marshall | Indiana | 18099 | 501 | 6 |
309939 | 309939 | 2020-07-07 | Marshall | Indiana | 18099 | 492 | 6 |
306771 | 306771 | 2020-07-06 | Marshall | Indiana | 18099 | 490 | 4 |
303606 | 303606 | 2020-07-05 | Marshall | Indiana | 18099 | 492 | 4 |
300442 | 300442 | 2020-07-04 | Marshall | Indiana | 18099 | 482 | 3 |
297280 | 297280 | 2020-07-03 | Marshall | Indiana | 18099 | 427 | 3 |
294122 | 294122 | 2020-07-02 | Marshall | Indiana | 18099 | 418 | 3 |
290968 | 290968 | 2020-07-01 | Marshall | Indiana | 18099 | 412 | 3 |
287818 | 287818 | 2020-06-30 | Marshall | Indiana | 18099 | 409 | 3 |
284669 | 284669 | 2020-06-29 | Marshall | Indiana | 18099 | 407 | 3 |
281524 | 281524 | 2020-06-28 | Marshall | Indiana | 18099 | 403 | 3 |
278376 | 278376 | 2020-06-27 | Marshall | Indiana | 18099 | 401 | 3 |
275228 | 275228 | 2020-06-26 | Marshall | Indiana | 18099 | 393 | 3 |
272086 | 272086 | 2020-06-25 | Marshall | Indiana | 18099 | 385 | 3 |
268949 | 268949 | 2020-06-24 | Marshall | Indiana | 18099 | 374 | 3 |
265819 | 265819 | 2020-06-23 | Marshall | Indiana | 18099 | 369 | 3 |
262691 | 262691 | 2020-06-22 | Marshall | Indiana | 18099 | 365 | 3 |
259564 | 259564 | 2020-06-21 | Marshall | Indiana | 18099 | 359 | 3 |
256438 | 256438 | 2020-06-20 | Marshall | Indiana | 18099 | 347 | 3 |
253318 | 253318 | 2020-06-19 | Marshall | Indiana | 18099 | 344 | 3 |
250203 | 250203 | 2020-06-18 | Marshall | Indiana | 18099 | 338 | 3 |
247091 | 247091 | 2020-06-17 | Marshall | Indiana | 18099 | 322 | 3 |
243978 | 243978 | 2020-06-16 | Marshall | Indiana | 18099 | 315 | 3 |
240867 | 240867 | 2020-06-15 | Marshall | Indiana | 18099 | 305 | 3 |
237759 | 237759 | 2020-06-14 | Marshall | Indiana | 18099 | 301 | 3 |
234652 | 234652 | 2020-06-13 | Marshall | Indiana | 18099 | 287 | 3 |
231546 | 231546 | 2020-06-12 | Marshall | Indiana | 18099 | 276 | 3 |
228443 | 228443 | 2020-06-11 | Marshall | Indiana | 18099 | 261 | 3 |
225341 | 225341 | 2020-06-10 | Marshall | Indiana | 18099 | 247 | 2 |
222246 | 222246 | 2020-06-09 | Marshall | Indiana | 18099 | 230 | 2 |
219151 | 219151 | 2020-06-08 | Marshall | Indiana | 18099 | 227 | 2 |
216059 | 216059 | 2020-06-07 | Marshall | Indiana | 18099 | 214 | 2 |
212972 | 212972 | 2020-06-06 | Marshall | Indiana | 18099 | 196 | 2 |
209887 | 209887 | 2020-06-05 | Marshall | Indiana | 18099 | 187 | 2 |
206806 | 206806 | 2020-06-04 | Marshall | Indiana | 18099 | 178 | 2 |
203726 | 203726 | 2020-06-03 | Marshall | Indiana | 18099 | 147 | 2 |
200650 | 200650 | 2020-06-02 | Marshall | Indiana | 18099 | 128 | 2 |
197577 | 197577 | 2020-06-01 | Marshall | Indiana | 18099 | 111 | 2 |
194507 | 194507 | 2020-05-31 | Marshall | Indiana | 18099 | 108 | 2 |
191440 | 191440 | 2020-05-30 | Marshall | Indiana | 18099 | 102 | 1 |
188375 | 188375 | 2020-05-29 | Marshall | Indiana | 18099 | 90 | 1 |
185317 | 185317 | 2020-05-28 | Marshall | Indiana | 18099 | 80 | 1 |
182263 | 182263 | 2020-05-27 | Marshall | Indiana | 18099 | 80 | 1 |
179219 | 179219 | 2020-05-26 | Marshall | Indiana | 18099 | 76 | 1 |
176175 | 176175 | 2020-05-25 | Marshall | Indiana | 18099 | 64 | 1 |
173131 | 173131 | 2020-05-24 | Marshall | Indiana | 18099 | 64 | 1 |
170090 | 170090 | 2020-05-23 | Marshall | Indiana | 18099 | 61 | 1 |
167053 | 167053 | 2020-05-22 | Marshall | Indiana | 18099 | 54 | 1 |
164020 | 164020 | 2020-05-21 | Marshall | Indiana | 18099 | 51 | 1 |
160992 | 160992 | 2020-05-20 | Marshall | Indiana | 18099 | 50 | 1 |
157966 | 157966 | 2020-05-19 | Marshall | Indiana | 18099 | 44 | 1 |
154950 | 154950 | 2020-05-18 | Marshall | Indiana | 18099 | 42 | 1 |
151938 | 151938 | 2020-05-17 | Marshall | Indiana | 18099 | 43 | 1 |
148929 | 148929 | 2020-05-16 | Marshall | Indiana | 18099 | 40 | 1 |
145925 | 145925 | 2020-05-15 | Marshall | Indiana | 18099 | 39 | 1 |
142925 | 142925 | 2020-05-14 | Marshall | Indiana | 18099 | 39 | 1 |
139929 | 139929 | 2020-05-13 | Marshall | Indiana | 18099 | 37 | 1 |
136937 | 136937 | 2020-05-12 | Marshall | Indiana | 18099 | 36 | 1 |
133948 | 133948 | 2020-05-11 | Marshall | Indiana | 18099 | 34 | 1 |
130958 | 130958 | 2020-05-10 | Marshall | Indiana | 18099 | 33 | 1 |
127967 | 127967 | 2020-05-09 | Marshall | Indiana | 18099 | 32 | 1 |
124980 | 124980 | 2020-05-08 | Marshall | Indiana | 18099 | 31 | 1 |
122000 | 122000 | 2020-05-07 | Marshall | Indiana | 18099 | 31 | 1 |
119030 | 119030 | 2020-05-06 | Marshall | Indiana | 18099 | 31 | 1 |
116070 | 116070 | 2020-05-05 | Marshall | Indiana | 18099 | 32 | 1 |
113187 | 113187 | 2020-05-04 | Marshall | Indiana | 18099 | 31 | 1 |
110312 | 110312 | 2020-05-03 | Marshall | Indiana | 18099 | 31 | 1 |
107442 | 107442 | 2020-05-02 | Marshall | Indiana | 18099 | 30 | 1 |
104577 | 104577 | 2020-05-01 | Marshall | Indiana | 18099 | 30 | 1 |
101721 | 101721 | 2020-04-30 | Marshall | Indiana | 18099 | 29 | 1 |
98870 | 98870 | 2020-04-29 | Marshall | Indiana | 18099 | 28 | 1 |
96026 | 96026 | 2020-04-28 | Marshall | Indiana | 18099 | 28 | 1 |
93194 | 93194 | 2020-04-27 | Marshall | Indiana | 18099 | 29 | 1 |
90375 | 90375 | 2020-04-26 | Marshall | Indiana | 18099 | 27 | 1 |
87559 | 87559 | 2020-04-25 | Marshall | Indiana | 18099 | 26 | 1 |
84749 | 84749 | 2020-04-24 | Marshall | Indiana | 18099 | 25 | 1 |
81949 | 81949 | 2020-04-23 | Marshall | Indiana | 18099 | 25 | 1 |
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);