ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Clark" and fips = 17023 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312968 | 312968 | 2020-07-08 | Clark | Illinois | 17023 | 18 | 0 |
316142 | 316142 | 2020-07-09 | Clark | Illinois | 17023 | 21 | 0 |
319315 | 319315 | 2020-07-10 | Clark | Illinois | 17023 | 36 | 0 |
322494 | 322494 | 2020-07-11 | Clark | Illinois | 17023 | 40 | 0 |
325675 | 325675 | 2020-07-12 | Clark | Illinois | 17023 | 41 | 0 |
328861 | 328861 | 2020-07-13 | Clark | Illinois | 17023 | 40 | 0 |
332048 | 332048 | 2020-07-14 | Clark | Illinois | 17023 | 41 | 0 |
335241 | 335241 | 2020-07-15 | Clark | Illinois | 17023 | 45 | 0 |
338437 | 338437 | 2020-07-16 | Clark | Illinois | 17023 | 45 | 0 |
341633 | 341633 | 2020-07-17 | Clark | Illinois | 17023 | 48 | 0 |
344833 | 344833 | 2020-07-18 | Clark | Illinois | 17023 | 49 | 0 |
348034 | 348034 | 2020-07-19 | Clark | Illinois | 17023 | 49 | 0 |
351234 | 351234 | 2020-07-20 | Clark | Illinois | 17023 | 50 | 0 |
354436 | 354436 | 2020-07-21 | Clark | Illinois | 17023 | 50 | 0 |
357638 | 357638 | 2020-07-22 | Clark | Illinois | 17023 | 50 | 0 |
360843 | 360843 | 2020-07-23 | Clark | Illinois | 17023 | 51 | 0 |
364050 | 364050 | 2020-07-24 | Clark | Illinois | 17023 | 52 | 0 |
367257 | 367257 | 2020-07-25 | Clark | Illinois | 17023 | 53 | 0 |
370467 | 370467 | 2020-07-26 | Clark | Illinois | 17023 | 57 | 0 |
373679 | 373679 | 2020-07-27 | Clark | Illinois | 17023 | 59 | 0 |
376894 | 376894 | 2020-07-28 | Clark | Illinois | 17023 | 63 | 0 |
380111 | 380111 | 2020-07-29 | Clark | Illinois | 17023 | 63 | 0 |
383328 | 383328 | 2020-07-30 | Clark | Illinois | 17023 | 65 | 0 |
386546 | 386546 | 2020-07-31 | Clark | Illinois | 17023 | 66 | 0 |
389763 | 389763 | 2020-08-01 | Clark | Illinois | 17023 | 66 | 0 |
392980 | 392980 | 2020-08-02 | Clark | Illinois | 17023 | 66 | 0 |
396196 | 396196 | 2020-08-03 | Clark | Illinois | 17023 | 68 | 0 |
399412 | 399412 | 2020-08-04 | Clark | Illinois | 17023 | 70 | 0 |
402628 | 402628 | 2020-08-05 | Clark | Illinois | 17023 | 73 | 1 |
405846 | 405846 | 2020-08-06 | Clark | Illinois | 17023 | 76 | 1 |
409066 | 409066 | 2020-08-07 | Clark | Illinois | 17023 | 79 | 2 |
412285 | 412285 | 2020-08-08 | Clark | Illinois | 17023 | 81 | 2 |
415505 | 415505 | 2020-08-09 | Clark | Illinois | 17023 | 82 | 2 |
418726 | 418726 | 2020-08-10 | Clark | Illinois | 17023 | 83 | 2 |
421949 | 421949 | 2020-08-11 | Clark | Illinois | 17023 | 87 | 2 |
425170 | 425170 | 2020-08-12 | Clark | Illinois | 17023 | 87 | 2 |
428394 | 428394 | 2020-08-13 | Clark | Illinois | 17023 | 88 | 2 |
431622 | 431622 | 2020-08-14 | Clark | Illinois | 17023 | 91 | 2 |
434847 | 434847 | 2020-08-15 | Clark | Illinois | 17023 | 93 | 2 |
438073 | 438073 | 2020-08-16 | Clark | Illinois | 17023 | 95 | 2 |
441299 | 441299 | 2020-08-17 | Clark | Illinois | 17023 | 96 | 2 |
444525 | 444525 | 2020-08-18 | Clark | Illinois | 17023 | 96 | 2 |
447752 | 447752 | 2020-08-19 | Clark | Illinois | 17023 | 98 | 2 |
450980 | 450980 | 2020-08-20 | Clark | Illinois | 17023 | 104 | 2 |
454208 | 454208 | 2020-08-21 | Clark | Illinois | 17023 | 105 | 2 |
457436 | 457436 | 2020-08-22 | Clark | Illinois | 17023 | 112 | 2 |
460663 | 460663 | 2020-08-23 | Clark | Illinois | 17023 | 112 | 2 |
463892 | 463892 | 2020-08-24 | Clark | Illinois | 17023 | 112 | 2 |
467121 | 467121 | 2020-08-25 | Clark | Illinois | 17023 | 112 | 2 |
470350 | 470350 | 2020-08-26 | Clark | Illinois | 17023 | 113 | 2 |
473582 | 473582 | 2020-08-27 | Clark | Illinois | 17023 | 112 | 2 |
476815 | 476815 | 2020-08-28 | Clark | Illinois | 17023 | 115 | 2 |
480048 | 480048 | 2020-08-29 | Clark | Illinois | 17023 | 116 | 2 |
483282 | 483282 | 2020-08-30 | Clark | Illinois | 17023 | 116 | 2 |
486517 | 486517 | 2020-08-31 | Clark | Illinois | 17023 | 116 | 2 |
489750 | 489750 | 2020-09-01 | Clark | Illinois | 17023 | 116 | 2 |
492983 | 492983 | 2020-09-02 | Clark | Illinois | 17023 | 119 | 2 |
496217 | 496217 | 2020-09-03 | Clark | Illinois | 17023 | 119 | 2 |
499450 | 499450 | 2020-09-04 | Clark | Illinois | 17023 | 120 | 2 |
502684 | 502684 | 2020-09-05 | Clark | Illinois | 17023 | 121 | 2 |
505918 | 505918 | 2020-09-06 | Clark | Illinois | 17023 | 121 | 2 |
509150 | 509150 | 2020-09-07 | Clark | Illinois | 17023 | 122 | 2 |
512383 | 512383 | 2020-09-08 | Clark | Illinois | 17023 | 121 | 2 |
515616 | 515616 | 2020-09-09 | Clark | Illinois | 17023 | 122 | 2 |
518851 | 518851 | 2020-09-10 | Clark | Illinois | 17023 | 123 | 2 |
522088 | 522088 | 2020-09-11 | Clark | Illinois | 17023 | 125 | 2 |
525324 | 525324 | 2020-09-12 | Clark | Illinois | 17023 | 133 | 2 |
528560 | 528560 | 2020-09-13 | Clark | Illinois | 17023 | 137 | 2 |
531797 | 531797 | 2020-09-14 | Clark | Illinois | 17023 | 140 | 2 |
535032 | 535032 | 2020-09-15 | Clark | Illinois | 17023 | 141 | 2 |
538268 | 538268 | 2020-09-16 | Clark | Illinois | 17023 | 141 | 2 |
541505 | 541505 | 2020-09-17 | Clark | Illinois | 17023 | 143 | 2 |
544741 | 544741 | 2020-09-18 | Clark | Illinois | 17023 | 144 | 2 |
547979 | 547979 | 2020-09-19 | Clark | Illinois | 17023 | 146 | 2 |
551218 | 551218 | 2020-09-20 | Clark | Illinois | 17023 | 147 | 2 |
554457 | 554457 | 2020-09-21 | Clark | Illinois | 17023 | 147 | 2 |
557694 | 557694 | 2020-09-22 | Clark | Illinois | 17023 | 151 | 2 |
560930 | 560930 | 2020-09-23 | Clark | Illinois | 17023 | 154 | 2 |
564170 | 564170 | 2020-09-24 | Clark | Illinois | 17023 | 156 | 2 |
567410 | 567410 | 2020-09-25 | Clark | Illinois | 17023 | 158 | 2 |
570652 | 570652 | 2020-09-26 | Clark | Illinois | 17023 | 172 | 2 |
573895 | 573895 | 2020-09-27 | Clark | Illinois | 17023 | 173 | 2 |
577137 | 577137 | 2020-09-28 | Clark | Illinois | 17023 | 174 | 2 |
580378 | 580378 | 2020-09-29 | Clark | Illinois | 17023 | 176 | 3 |
583617 | 583617 | 2020-09-30 | Clark | Illinois | 17023 | 183 | 3 |
586857 | 586857 | 2020-10-01 | Clark | Illinois | 17023 | 184 | 3 |
590098 | 590098 | 2020-10-02 | Clark | Illinois | 17023 | 186 | 3 |
593339 | 593339 | 2020-10-03 | Clark | Illinois | 17023 | 190 | 3 |
596581 | 596581 | 2020-10-04 | Clark | Illinois | 17023 | 190 | 3 |
599823 | 599823 | 2020-10-05 | Clark | Illinois | 17023 | 193 | 3 |
603066 | 603066 | 2020-10-06 | Clark | Illinois | 17023 | 194 | 3 |
606308 | 606308 | 2020-10-07 | Clark | Illinois | 17023 | 206 | 3 |
609551 | 609551 | 2020-10-08 | Clark | Illinois | 17023 | 207 | 4 |
612793 | 612793 | 2020-10-09 | Clark | Illinois | 17023 | 227 | 4 |
616034 | 616034 | 2020-10-10 | Clark | Illinois | 17023 | 229 | 4 |
619276 | 619276 | 2020-10-11 | Clark | Illinois | 17023 | 229 | 4 |
622520 | 622520 | 2020-10-12 | Clark | Illinois | 17023 | 233 | 4 |
625762 | 625762 | 2020-10-13 | Clark | Illinois | 17023 | 234 | 4 |
629005 | 629005 | 2020-10-14 | Clark | Illinois | 17023 | 240 | 4 |
632249 | 632249 | 2020-10-15 | Clark | Illinois | 17023 | 241 | 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);