ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
841 rows where fips = 17031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
599827 | 599827 | 2020-10-05 | Cook | Illinois | 17031 | 149127 | 5260 |
596585 | 596585 | 2020-10-04 | Cook | Illinois | 17031 | 148381 | 5256 |
593343 | 593343 | 2020-10-03 | Cook | Illinois | 17031 | 147841 | 5245 |
590102 | 590102 | 2020-10-02 | Cook | Illinois | 17031 | 146917 | 5239 |
586861 | 586861 | 2020-10-01 | Cook | Illinois | 17031 | 146152 | 5229 |
583621 | 583621 | 2020-09-30 | Cook | Illinois | 17031 | 145462 | 5225 |
580382 | 580382 | 2020-09-29 | Cook | Illinois | 17031 | 144697 | 5221 |
577141 | 577141 | 2020-09-28 | Cook | Illinois | 17031 | 144315 | 5217 |
573899 | 573899 | 2020-09-27 | Cook | Illinois | 17031 | 143634 | 5210 |
570656 | 570656 | 2020-09-26 | Cook | Illinois | 17031 | 143084 | 5203 |
567414 | 567414 | 2020-09-25 | Cook | Illinois | 17031 | 142215 | 5194 |
564174 | 564174 | 2020-09-24 | Cook | Illinois | 17031 | 141430 | 5187 |
560934 | 560934 | 2020-09-23 | Cook | Illinois | 17031 | 140623 | 5180 |
557698 | 557698 | 2020-09-22 | Cook | Illinois | 17031 | 140078 | 5172 |
554461 | 554461 | 2020-09-21 | Cook | Illinois | 17031 | 139597 | 5167 |
551222 | 551222 | 2020-09-20 | Cook | Illinois | 17031 | 139088 | 5162 |
547983 | 547983 | 2020-09-19 | Cook | Illinois | 17031 | 138576 | 5157 |
544745 | 544745 | 2020-09-18 | Cook | Illinois | 17031 | 137580 | 5150 |
541509 | 541509 | 2020-09-17 | Cook | Illinois | 17031 | 136993 | 5147 |
538272 | 538272 | 2020-09-16 | Cook | Illinois | 17031 | 136246 | 5146 |
535036 | 535036 | 2020-09-15 | Cook | Illinois | 17031 | 135690 | 5137 |
531801 | 531801 | 2020-09-14 | Cook | Illinois | 17031 | 135274 | 5134 |
528564 | 528564 | 2020-09-13 | Cook | Illinois | 17031 | 134801 | 5133 |
525328 | 525328 | 2020-09-12 | Cook | Illinois | 17031 | 134352 | 5128 |
522092 | 522092 | 2020-09-11 | Cook | Illinois | 17031 | 133686 | 5113 |
518855 | 518855 | 2020-09-10 | Cook | Illinois | 17031 | 132966 | 5103 |
515620 | 515620 | 2020-09-09 | Cook | Illinois | 17031 | 132401 | 5100 |
512387 | 512387 | 2020-09-08 | Cook | Illinois | 17031 | 132079 | 5098 |
509154 | 509154 | 2020-09-07 | Cook | Illinois | 17031 | 131622 | 5097 |
505922 | 505922 | 2020-09-06 | Cook | Illinois | 17031 | 131078 | 5094 |
502688 | 502688 | 2020-09-05 | Cook | Illinois | 17031 | 130616 | 5092 |
499454 | 499454 | 2020-09-04 | Cook | Illinois | 17031 | 129545 | 5086 |
496221 | 496221 | 2020-09-03 | Cook | Illinois | 17031 | 128012 | 5080 |
492987 | 492987 | 2020-09-02 | Cook | Illinois | 17031 | 127616 | 5073 |
489754 | 489754 | 2020-09-01 | Cook | Illinois | 17031 | 126992 | 5069 |
486521 | 486521 | 2020-08-31 | Cook | Illinois | 17031 | 126577 | 5058 |
483286 | 483286 | 2020-08-30 | Cook | Illinois | 17031 | 126003 | 5054 |
480052 | 480052 | 2020-08-29 | Cook | Illinois | 17031 | 125124 | 5046 |
476819 | 476819 | 2020-08-28 | Cook | Illinois | 17031 | 124573 | 5045 |
473586 | 473586 | 2020-08-27 | Cook | Illinois | 17031 | 123691 | 5039 |
470354 | 470354 | 2020-08-26 | Cook | Illinois | 17031 | 123172 | 5031 |
467125 | 467125 | 2020-08-25 | Cook | Illinois | 17031 | 122423 | 5022 |
463896 | 463896 | 2020-08-24 | Cook | Illinois | 17031 | 121894 | 5015 |
460667 | 460667 | 2020-08-23 | Cook | Illinois | 17031 | 121308 | 5013 |
457440 | 457440 | 2020-08-22 | Cook | Illinois | 17031 | 120567 | 5008 |
454212 | 454212 | 2020-08-21 | Cook | Illinois | 17031 | 119644 | 4997 |
450984 | 450984 | 2020-08-20 | Cook | Illinois | 17031 | 118757 | 4988 |
447756 | 447756 | 2020-08-19 | Cook | Illinois | 17031 | 118012 | 4984 |
444529 | 444529 | 2020-08-18 | Cook | Illinois | 17031 | 117171 | 4974 |
441303 | 441303 | 2020-08-17 | Cook | Illinois | 17031 | 116620 | 4964 |
438077 | 438077 | 2020-08-16 | Cook | Illinois | 17031 | 115960 | 4962 |
434851 | 434851 | 2020-08-15 | Cook | Illinois | 17031 | 115344 | 4953 |
431626 | 431626 | 2020-08-14 | Cook | Illinois | 17031 | 114724 | 4951 |
428398 | 428398 | 2020-08-13 | Cook | Illinois | 17031 | 113796 | 4943 |
425174 | 425174 | 2020-08-12 | Cook | Illinois | 17031 | 113045 | 4934 |
421953 | 421953 | 2020-08-11 | Cook | Illinois | 17031 | 112485 | 4933 |
418730 | 418730 | 2020-08-10 | Cook | Illinois | 17031 | 111948 | 4928 |
415509 | 415509 | 2020-08-09 | Cook | Illinois | 17031 | 111447 | 4928 |
412289 | 412289 | 2020-08-08 | Cook | Illinois | 17031 | 110865 | 4924 |
409070 | 409070 | 2020-08-07 | Cook | Illinois | 17031 | 110002 | 4920 |
405850 | 405850 | 2020-08-06 | Cook | Illinois | 17031 | 109150 | 4912 |
402632 | 402632 | 2020-08-05 | Cook | Illinois | 17031 | 108425 | 4909 |
399416 | 399416 | 2020-08-04 | Cook | Illinois | 17031 | 107744 | 4902 |
396200 | 396200 | 2020-08-03 | Cook | Illinois | 17031 | 107247 | 4897 |
392984 | 392984 | 2020-08-02 | Cook | Illinois | 17031 | 106713 | 4894 |
389767 | 389767 | 2020-08-01 | Cook | Illinois | 17031 | 106131 | 4888 |
386550 | 386550 | 2020-07-31 | Cook | Illinois | 17031 | 105493 | 4886 |
383332 | 383332 | 2020-07-30 | Cook | Illinois | 17031 | 104691 | 4872 |
380115 | 380115 | 2020-07-29 | Cook | Illinois | 17031 | 104001 | 4864 |
376898 | 376898 | 2020-07-28 | Cook | Illinois | 17031 | 103441 | 4857 |
373683 | 373683 | 2020-07-27 | Cook | Illinois | 17031 | 103008 | 4845 |
370471 | 370471 | 2020-07-26 | Cook | Illinois | 17031 | 102583 | 4830 |
367261 | 367261 | 2020-07-25 | Cook | Illinois | 17031 | 101955 | 4829 |
364054 | 364054 | 2020-07-24 | Cook | Illinois | 17031 | 101420 | 4822 |
360847 | 360847 | 2020-07-23 | Cook | Illinois | 17031 | 100795 | 4810 |
357642 | 357642 | 2020-07-22 | Cook | Illinois | 17031 | 100124 | 4801 |
354440 | 354440 | 2020-07-21 | Cook | Illinois | 17031 | 99464 | 4788 |
351238 | 351238 | 2020-07-20 | Cook | Illinois | 17031 | 99052 | 4777 |
348038 | 348038 | 2020-07-19 | Cook | Illinois | 17031 | 98670 | 4776 |
344837 | 344837 | 2020-07-18 | Cook | Illinois | 17031 | 98292 | 4774 |
341637 | 341637 | 2020-07-17 | Cook | Illinois | 17031 | 97790 | 4765 |
338441 | 338441 | 2020-07-16 | Cook | Illinois | 17031 | 97214 | 4750 |
335245 | 335245 | 2020-07-15 | Cook | Illinois | 17031 | 96662 | 4745 |
332052 | 332052 | 2020-07-14 | Cook | Illinois | 17031 | 96186 | 4741 |
328865 | 328865 | 2020-07-13 | Cook | Illinois | 17031 | 95884 | 4729 |
325679 | 325679 | 2020-07-12 | Cook | Illinois | 17031 | 95557 | 4725 |
322498 | 322498 | 2020-07-11 | Cook | Illinois | 17031 | 95138 | 4711 |
319319 | 319319 | 2020-07-10 | Cook | Illinois | 17031 | 94605 | 4693 |
316146 | 316146 | 2020-07-09 | Cook | Illinois | 17031 | 94005 | 4676 |
312972 | 312972 | 2020-07-08 | Cook | Illinois | 17031 | 93496 | 4664 |
309802 | 309802 | 2020-07-07 | Cook | Illinois | 17031 | 93053 | 4651 |
306634 | 306634 | 2020-07-06 | Cook | Illinois | 17031 | 92781 | 4630 |
303469 | 303469 | 2020-07-05 | Cook | Illinois | 17031 | 92532 | 4627 |
300305 | 300305 | 2020-07-04 | Cook | Illinois | 17031 | 92240 | 4622 |
297143 | 297143 | 2020-07-03 | Cook | Illinois | 17031 | 91774 | 4618 |
293986 | 293986 | 2020-07-02 | Cook | Illinois | 17031 | 91381 | 4609 |
290832 | 290832 | 2020-07-01 | Cook | Illinois | 17031 | 90911 | 4581 |
287682 | 287682 | 2020-06-30 | Cook | Illinois | 17031 | 90536 | 4565 |
284533 | 284533 | 2020-06-29 | Cook | Illinois | 17031 | 90122 | 4554 |
281388 | 281388 | 2020-06-28 | Cook | Illinois | 17031 | 89755 | 4542 |
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);