ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marion" and fips = 17121 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535078 | 535078 | 2020-09-15 | Marion | Illinois | 17121 | 441 | 0 |
531843 | 531843 | 2020-09-14 | Marion | Illinois | 17121 | 436 | 0 |
528606 | 528606 | 2020-09-13 | Marion | Illinois | 17121 | 427 | 0 |
525370 | 525370 | 2020-09-12 | Marion | Illinois | 17121 | 414 | 0 |
522134 | 522134 | 2020-09-11 | Marion | Illinois | 17121 | 403 | 0 |
518897 | 518897 | 2020-09-10 | Marion | Illinois | 17121 | 387 | 0 |
515662 | 515662 | 2020-09-09 | Marion | Illinois | 17121 | 375 | 0 |
512429 | 512429 | 2020-09-08 | Marion | Illinois | 17121 | 368 | 0 |
509196 | 509196 | 2020-09-07 | Marion | Illinois | 17121 | 365 | 0 |
505964 | 505964 | 2020-09-06 | Marion | Illinois | 17121 | 338 | 0 |
502730 | 502730 | 2020-09-05 | Marion | Illinois | 17121 | 332 | 0 |
499496 | 499496 | 2020-09-04 | Marion | Illinois | 17121 | 311 | 0 |
496263 | 496263 | 2020-09-03 | Marion | Illinois | 17121 | 293 | 0 |
493029 | 493029 | 2020-09-02 | Marion | Illinois | 17121 | 286 | 0 |
489796 | 489796 | 2020-09-01 | Marion | Illinois | 17121 | 278 | 0 |
486563 | 486563 | 2020-08-31 | Marion | Illinois | 17121 | 272 | 0 |
483328 | 483328 | 2020-08-30 | Marion | Illinois | 17121 | 266 | 0 |
480094 | 480094 | 2020-08-29 | Marion | Illinois | 17121 | 263 | 0 |
476861 | 476861 | 2020-08-28 | Marion | Illinois | 17121 | 262 | 0 |
473628 | 473628 | 2020-08-27 | Marion | Illinois | 17121 | 259 | 0 |
470396 | 470396 | 2020-08-26 | Marion | Illinois | 17121 | 249 | 0 |
467167 | 467167 | 2020-08-25 | Marion | Illinois | 17121 | 245 | 0 |
463938 | 463938 | 2020-08-24 | Marion | Illinois | 17121 | 234 | 0 |
460709 | 460709 | 2020-08-23 | Marion | Illinois | 17121 | 231 | 0 |
457482 | 457482 | 2020-08-22 | Marion | Illinois | 17121 | 221 | 0 |
454254 | 454254 | 2020-08-21 | Marion | Illinois | 17121 | 212 | 0 |
451026 | 451026 | 2020-08-20 | Marion | Illinois | 17121 | 209 | 0 |
447798 | 447798 | 2020-08-19 | Marion | Illinois | 17121 | 201 | 0 |
444571 | 444571 | 2020-08-18 | Marion | Illinois | 17121 | 196 | 0 |
441345 | 441345 | 2020-08-17 | Marion | Illinois | 17121 | 188 | 0 |
438119 | 438119 | 2020-08-16 | Marion | Illinois | 17121 | 182 | 0 |
434893 | 434893 | 2020-08-15 | Marion | Illinois | 17121 | 179 | 0 |
431668 | 431668 | 2020-08-14 | Marion | Illinois | 17121 | 172 | 0 |
428440 | 428440 | 2020-08-13 | Marion | Illinois | 17121 | 168 | 0 |
425216 | 425216 | 2020-08-12 | Marion | Illinois | 17121 | 169 | 0 |
421995 | 421995 | 2020-08-11 | Marion | Illinois | 17121 | 165 | 0 |
418772 | 418772 | 2020-08-10 | Marion | Illinois | 17121 | 161 | 0 |
415551 | 415551 | 2020-08-09 | Marion | Illinois | 17121 | 156 | 0 |
412331 | 412331 | 2020-08-08 | Marion | Illinois | 17121 | 156 | 0 |
409112 | 409112 | 2020-08-07 | Marion | Illinois | 17121 | 152 | 0 |
405892 | 405892 | 2020-08-06 | Marion | Illinois | 17121 | 153 | 0 |
402674 | 402674 | 2020-08-05 | Marion | Illinois | 17121 | 143 | 0 |
399458 | 399458 | 2020-08-04 | Marion | Illinois | 17121 | 140 | 0 |
396242 | 396242 | 2020-08-03 | Marion | Illinois | 17121 | 138 | 0 |
393026 | 393026 | 2020-08-02 | Marion | Illinois | 17121 | 136 | 0 |
389809 | 389809 | 2020-08-01 | Marion | Illinois | 17121 | 132 | 0 |
386592 | 386592 | 2020-07-31 | Marion | Illinois | 17121 | 130 | 0 |
383374 | 383374 | 2020-07-30 | Marion | Illinois | 17121 | 125 | 0 |
380157 | 380157 | 2020-07-29 | Marion | Illinois | 17121 | 122 | 0 |
376940 | 376940 | 2020-07-28 | Marion | Illinois | 17121 | 116 | 0 |
373725 | 373725 | 2020-07-27 | Marion | Illinois | 17121 | 116 | 0 |
370513 | 370513 | 2020-07-26 | Marion | Illinois | 17121 | 114 | 0 |
367303 | 367303 | 2020-07-25 | Marion | Illinois | 17121 | 113 | 0 |
364096 | 364096 | 2020-07-24 | Marion | Illinois | 17121 | 110 | 0 |
360889 | 360889 | 2020-07-23 | Marion | Illinois | 17121 | 107 | 0 |
357684 | 357684 | 2020-07-22 | Marion | Illinois | 17121 | 97 | 0 |
354482 | 354482 | 2020-07-21 | Marion | Illinois | 17121 | 96 | 0 |
351280 | 351280 | 2020-07-20 | Marion | Illinois | 17121 | 93 | 0 |
348080 | 348080 | 2020-07-19 | Marion | Illinois | 17121 | 89 | 0 |
344879 | 344879 | 2020-07-18 | Marion | Illinois | 17121 | 88 | 0 |
341679 | 341679 | 2020-07-17 | Marion | Illinois | 17121 | 87 | 0 |
338483 | 338483 | 2020-07-16 | Marion | Illinois | 17121 | 81 | 0 |
335287 | 335287 | 2020-07-15 | Marion | Illinois | 17121 | 81 | 0 |
332094 | 332094 | 2020-07-14 | Marion | Illinois | 17121 | 79 | 0 |
328907 | 328907 | 2020-07-13 | Marion | Illinois | 17121 | 79 | 0 |
325721 | 325721 | 2020-07-12 | Marion | Illinois | 17121 | 77 | 0 |
322540 | 322540 | 2020-07-11 | Marion | Illinois | 17121 | 77 | 0 |
319361 | 319361 | 2020-07-10 | Marion | Illinois | 17121 | 77 | 0 |
316188 | 316188 | 2020-07-09 | Marion | Illinois | 17121 | 77 | 0 |
313014 | 313014 | 2020-07-08 | Marion | Illinois | 17121 | 73 | 0 |
309844 | 309844 | 2020-07-07 | Marion | Illinois | 17121 | 70 | 0 |
306676 | 306676 | 2020-07-06 | Marion | Illinois | 17121 | 70 | 0 |
303511 | 303511 | 2020-07-05 | Marion | Illinois | 17121 | 69 | 0 |
300347 | 300347 | 2020-07-04 | Marion | Illinois | 17121 | 69 | 0 |
297185 | 297185 | 2020-07-03 | Marion | Illinois | 17121 | 68 | 0 |
294028 | 294028 | 2020-07-02 | Marion | Illinois | 17121 | 66 | 0 |
290874 | 290874 | 2020-07-01 | Marion | Illinois | 17121 | 66 | 0 |
287724 | 287724 | 2020-06-30 | Marion | Illinois | 17121 | 65 | 0 |
284575 | 284575 | 2020-06-29 | Marion | Illinois | 17121 | 65 | 0 |
281430 | 281430 | 2020-06-28 | Marion | Illinois | 17121 | 65 | 0 |
278282 | 278282 | 2020-06-27 | Marion | Illinois | 17121 | 65 | 0 |
275134 | 275134 | 2020-06-26 | Marion | Illinois | 17121 | 65 | 0 |
271992 | 271992 | 2020-06-25 | Marion | Illinois | 17121 | 65 | 0 |
268855 | 268855 | 2020-06-24 | Marion | Illinois | 17121 | 63 | 0 |
265725 | 265725 | 2020-06-23 | Marion | Illinois | 17121 | 62 | 0 |
262597 | 262597 | 2020-06-22 | Marion | Illinois | 17121 | 60 | 0 |
259470 | 259470 | 2020-06-21 | Marion | Illinois | 17121 | 60 | 0 |
256344 | 256344 | 2020-06-20 | Marion | Illinois | 17121 | 57 | 0 |
253224 | 253224 | 2020-06-19 | Marion | Illinois | 17121 | 57 | 0 |
250109 | 250109 | 2020-06-18 | Marion | Illinois | 17121 | 55 | 0 |
246997 | 246997 | 2020-06-17 | Marion | Illinois | 17121 | 55 | 0 |
243884 | 243884 | 2020-06-16 | Marion | Illinois | 17121 | 55 | 0 |
240773 | 240773 | 2020-06-15 | Marion | Illinois | 17121 | 55 | 0 |
237665 | 237665 | 2020-06-14 | Marion | Illinois | 17121 | 55 | 0 |
234558 | 234558 | 2020-06-13 | Marion | Illinois | 17121 | 55 | 0 |
231452 | 231452 | 2020-06-12 | Marion | Illinois | 17121 | 55 | 0 |
228349 | 228349 | 2020-06-11 | Marion | Illinois | 17121 | 55 | 0 |
225247 | 225247 | 2020-06-10 | Marion | Illinois | 17121 | 55 | 0 |
222152 | 222152 | 2020-06-09 | Marion | Illinois | 17121 | 55 | 0 |
219057 | 219057 | 2020-06-08 | Marion | Illinois | 17121 | 55 | 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);