ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Mercer" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535086 | 535086 | 2020-09-15 | Mercer | Illinois | 17131 | 118 | 5 |
531851 | 531851 | 2020-09-14 | Mercer | Illinois | 17131 | 118 | 5 |
528614 | 528614 | 2020-09-13 | Mercer | Illinois | 17131 | 118 | 5 |
525378 | 525378 | 2020-09-12 | Mercer | Illinois | 17131 | 116 | 5 |
522142 | 522142 | 2020-09-11 | Mercer | Illinois | 17131 | 114 | 5 |
518905 | 518905 | 2020-09-10 | Mercer | Illinois | 17131 | 113 | 5 |
515670 | 515670 | 2020-09-09 | Mercer | Illinois | 17131 | 113 | 5 |
512437 | 512437 | 2020-09-08 | Mercer | Illinois | 17131 | 113 | 5 |
509204 | 509204 | 2020-09-07 | Mercer | Illinois | 17131 | 113 | 5 |
505972 | 505972 | 2020-09-06 | Mercer | Illinois | 17131 | 112 | 5 |
502738 | 502738 | 2020-09-05 | Mercer | Illinois | 17131 | 114 | 5 |
499504 | 499504 | 2020-09-04 | Mercer | Illinois | 17131 | 114 | 5 |
496271 | 496271 | 2020-09-03 | Mercer | Illinois | 17131 | 106 | 5 |
493037 | 493037 | 2020-09-02 | Mercer | Illinois | 17131 | 103 | 5 |
489804 | 489804 | 2020-09-01 | Mercer | Illinois | 17131 | 103 | 5 |
486571 | 486571 | 2020-08-31 | Mercer | Illinois | 17131 | 100 | 4 |
483336 | 483336 | 2020-08-30 | Mercer | Illinois | 17131 | 99 | 4 |
480102 | 480102 | 2020-08-29 | Mercer | Illinois | 17131 | 98 | 4 |
476869 | 476869 | 2020-08-28 | Mercer | Illinois | 17131 | 97 | 4 |
473636 | 473636 | 2020-08-27 | Mercer | Illinois | 17131 | 94 | 4 |
470404 | 470404 | 2020-08-26 | Mercer | Illinois | 17131 | 95 | 4 |
467175 | 467175 | 2020-08-25 | Mercer | Illinois | 17131 | 91 | 4 |
463946 | 463946 | 2020-08-24 | Mercer | Illinois | 17131 | 90 | 4 |
460717 | 460717 | 2020-08-23 | Mercer | Illinois | 17131 | 90 | 4 |
457490 | 457490 | 2020-08-22 | Mercer | Illinois | 17131 | 90 | 4 |
454262 | 454262 | 2020-08-21 | Mercer | Illinois | 17131 | 86 | 4 |
451034 | 451034 | 2020-08-20 | Mercer | Illinois | 17131 | 83 | 4 |
447806 | 447806 | 2020-08-19 | Mercer | Illinois | 17131 | 83 | 4 |
444579 | 444579 | 2020-08-18 | Mercer | Illinois | 17131 | 82 | 4 |
441353 | 441353 | 2020-08-17 | Mercer | Illinois | 17131 | 81 | 4 |
438127 | 438127 | 2020-08-16 | Mercer | Illinois | 17131 | 79 | 4 |
434901 | 434901 | 2020-08-15 | Mercer | Illinois | 17131 | 78 | 4 |
431676 | 431676 | 2020-08-14 | Mercer | Illinois | 17131 | 76 | 4 |
428448 | 428448 | 2020-08-13 | Mercer | Illinois | 17131 | 77 | 4 |
425224 | 425224 | 2020-08-12 | Mercer | Illinois | 17131 | 77 | 4 |
422003 | 422003 | 2020-08-11 | Mercer | Illinois | 17131 | 76 | 4 |
418780 | 418780 | 2020-08-10 | Mercer | Illinois | 17131 | 76 | 4 |
415559 | 415559 | 2020-08-09 | Mercer | Illinois | 17131 | 75 | 4 |
412339 | 412339 | 2020-08-08 | Mercer | Illinois | 17131 | 74 | 4 |
409120 | 409120 | 2020-08-07 | Mercer | Illinois | 17131 | 73 | 3 |
405900 | 405900 | 2020-08-06 | Mercer | Illinois | 17131 | 73 | 3 |
402682 | 402682 | 2020-08-05 | Mercer | Illinois | 17131 | 73 | 3 |
399466 | 399466 | 2020-08-04 | Mercer | Illinois | 17131 | 73 | 3 |
396250 | 396250 | 2020-08-03 | Mercer | Illinois | 17131 | 70 | 0 |
393034 | 393034 | 2020-08-02 | Mercer | Illinois | 17131 | 70 | 0 |
389817 | 389817 | 2020-08-01 | Mercer | Illinois | 17131 | 68 | 0 |
386600 | 386600 | 2020-07-31 | Mercer | Illinois | 17131 | 65 | 0 |
383382 | 383382 | 2020-07-30 | Mercer | Illinois | 17131 | 54 | 0 |
380165 | 380165 | 2020-07-29 | Mercer | Illinois | 17131 | 52 | 0 |
376948 | 376948 | 2020-07-28 | Mercer | Illinois | 17131 | 49 | 0 |
373733 | 373733 | 2020-07-27 | Mercer | Illinois | 17131 | 48 | 0 |
370521 | 370521 | 2020-07-26 | Mercer | Illinois | 17131 | 46 | 0 |
367311 | 367311 | 2020-07-25 | Mercer | Illinois | 17131 | 46 | 0 |
364104 | 364104 | 2020-07-24 | Mercer | Illinois | 17131 | 42 | 0 |
360897 | 360897 | 2020-07-23 | Mercer | Illinois | 17131 | 42 | 0 |
357692 | 357692 | 2020-07-22 | Mercer | Illinois | 17131 | 39 | 0 |
354490 | 354490 | 2020-07-21 | Mercer | Illinois | 17131 | 38 | 0 |
351288 | 351288 | 2020-07-20 | Mercer | Illinois | 17131 | 34 | 0 |
348088 | 348088 | 2020-07-19 | Mercer | Illinois | 17131 | 34 | 0 |
344887 | 344887 | 2020-07-18 | Mercer | Illinois | 17131 | 33 | 0 |
341687 | 341687 | 2020-07-17 | Mercer | Illinois | 17131 | 30 | 0 |
338491 | 338491 | 2020-07-16 | Mercer | Illinois | 17131 | 30 | 0 |
335295 | 335295 | 2020-07-15 | Mercer | Illinois | 17131 | 29 | 0 |
332102 | 332102 | 2020-07-14 | Mercer | Illinois | 17131 | 29 | 0 |
328915 | 328915 | 2020-07-13 | Mercer | Illinois | 17131 | 29 | 0 |
325729 | 325729 | 2020-07-12 | Mercer | Illinois | 17131 | 29 | 0 |
322548 | 322548 | 2020-07-11 | Mercer | Illinois | 17131 | 29 | 0 |
319369 | 319369 | 2020-07-10 | Mercer | Illinois | 17131 | 28 | 0 |
316196 | 316196 | 2020-07-09 | Mercer | Illinois | 17131 | 28 | 0 |
313022 | 313022 | 2020-07-08 | Mercer | Illinois | 17131 | 25 | 0 |
309852 | 309852 | 2020-07-07 | Mercer | Illinois | 17131 | 25 | 0 |
306684 | 306684 | 2020-07-06 | Mercer | Illinois | 17131 | 25 | 0 |
303519 | 303519 | 2020-07-05 | Mercer | Illinois | 17131 | 23 | 0 |
300355 | 300355 | 2020-07-04 | Mercer | Illinois | 17131 | 23 | 0 |
297193 | 297193 | 2020-07-03 | Mercer | Illinois | 17131 | 21 | 0 |
294036 | 294036 | 2020-07-02 | Mercer | Illinois | 17131 | 20 | 0 |
290882 | 290882 | 2020-07-01 | Mercer | Illinois | 17131 | 20 | 0 |
287732 | 287732 | 2020-06-30 | Mercer | Illinois | 17131 | 20 | 0 |
284583 | 284583 | 2020-06-29 | Mercer | Illinois | 17131 | 19 | 0 |
281438 | 281438 | 2020-06-28 | Mercer | Illinois | 17131 | 19 | 0 |
278290 | 278290 | 2020-06-27 | Mercer | Illinois | 17131 | 20 | 0 |
275142 | 275142 | 2020-06-26 | Mercer | Illinois | 17131 | 20 | 0 |
272000 | 272000 | 2020-06-25 | Mercer | Illinois | 17131 | 20 | 0 |
268863 | 268863 | 2020-06-24 | Mercer | Illinois | 17131 | 20 | 0 |
265733 | 265733 | 2020-06-23 | Mercer | Illinois | 17131 | 20 | 0 |
262605 | 262605 | 2020-06-22 | Mercer | Illinois | 17131 | 20 | 0 |
259478 | 259478 | 2020-06-21 | Mercer | Illinois | 17131 | 20 | 0 |
256352 | 256352 | 2020-06-20 | Mercer | Illinois | 17131 | 19 | 0 |
253232 | 253232 | 2020-06-19 | Mercer | Illinois | 17131 | 19 | 0 |
250117 | 250117 | 2020-06-18 | Mercer | Illinois | 17131 | 19 | 0 |
247005 | 247005 | 2020-06-17 | Mercer | Illinois | 17131 | 19 | 0 |
243892 | 243892 | 2020-06-16 | Mercer | Illinois | 17131 | 19 | 0 |
240781 | 240781 | 2020-06-15 | Mercer | Illinois | 17131 | 19 | 0 |
237673 | 237673 | 2020-06-14 | Mercer | Illinois | 17131 | 19 | 0 |
234566 | 234566 | 2020-06-13 | Mercer | Illinois | 17131 | 18 | 0 |
231460 | 231460 | 2020-06-12 | Mercer | Illinois | 17131 | 18 | 0 |
228357 | 228357 | 2020-06-11 | Mercer | Illinois | 17131 | 18 | 0 |
225255 | 225255 | 2020-06-10 | Mercer | Illinois | 17131 | 18 | 0 |
222160 | 222160 | 2020-06-09 | Mercer | Illinois | 17131 | 18 | 0 |
219065 | 219065 | 2020-06-08 | Mercer | Illinois | 17131 | 18 | 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);