ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Kent" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636167 | 636167 | 2020-10-16 | Kent | Michigan | 26081 | 12207 | 178 |
632921 | 632921 | 2020-10-15 | Kent | Michigan | 26081 | 12030 | 173 |
629676 | 629676 | 2020-10-14 | Kent | Michigan | 26081 | 11823 | 173 |
626432 | 626432 | 2020-10-13 | Kent | Michigan | 26081 | 11631 | 172 |
623190 | 623190 | 2020-10-12 | Kent | Michigan | 26081 | 11512 | 172 |
619947 | 619947 | 2020-10-11 | Kent | Michigan | 26081 | 11274 | 172 |
616705 | 616705 | 2020-10-10 | Kent | Michigan | 26081 | 11274 | 172 |
613464 | 613464 | 2020-10-09 | Kent | Michigan | 26081 | 11102 | 172 |
610222 | 610222 | 2020-10-08 | Kent | Michigan | 26081 | 10981 | 175 |
606980 | 606980 | 2020-10-07 | Kent | Michigan | 26081 | 10870 | 176 |
603737 | 603737 | 2020-10-06 | Kent | Michigan | 26081 | 10773 | 176 |
600495 | 600495 | 2020-10-05 | Kent | Michigan | 26081 | 10683 | 175 |
597252 | 597252 | 2020-10-04 | Kent | Michigan | 26081 | 10504 | 175 |
594011 | 594011 | 2020-10-03 | Kent | Michigan | 26081 | 10504 | 175 |
590770 | 590770 | 2020-10-02 | Kent | Michigan | 26081 | 10381 | 174 |
587529 | 587529 | 2020-10-01 | Kent | Michigan | 26081 | 10285 | 174 |
584289 | 584289 | 2020-09-30 | Kent | Michigan | 26081 | 10193 | 176 |
581048 | 581048 | 2020-09-29 | Kent | Michigan | 26081 | 10067 | 176 |
577807 | 577807 | 2020-09-28 | Kent | Michigan | 26081 | 9984 | 175 |
574566 | 574566 | 2020-09-27 | Kent | Michigan | 26081 | 9849 | 175 |
571323 | 571323 | 2020-09-26 | Kent | Michigan | 26081 | 9849 | 175 |
568081 | 568081 | 2020-09-25 | Kent | Michigan | 26081 | 9758 | 175 |
564841 | 564841 | 2020-09-24 | Kent | Michigan | 26081 | 9673 | 173 |
561601 | 561601 | 2020-09-23 | Kent | Michigan | 26081 | 9600 | 174 |
558364 | 558364 | 2020-09-22 | Kent | Michigan | 26081 | 9528 | 174 |
555127 | 555127 | 2020-09-21 | Kent | Michigan | 26081 | 9463 | 174 |
551889 | 551889 | 2020-09-20 | Kent | Michigan | 26081 | 9348 | 174 |
548650 | 548650 | 2020-09-19 | Kent | Michigan | 26081 | 9348 | 174 |
545412 | 545412 | 2020-09-18 | Kent | Michigan | 26081 | 9308 | 173 |
542175 | 542175 | 2020-09-17 | Kent | Michigan | 26081 | 9249 | 173 |
538939 | 538939 | 2020-09-16 | Kent | Michigan | 26081 | 9177 | 173 |
535702 | 535702 | 2020-09-15 | Kent | Michigan | 26081 | 9131 | 173 |
532467 | 532467 | 2020-09-14 | Kent | Michigan | 26081 | 9092 | 173 |
529231 | 529231 | 2020-09-13 | Kent | Michigan | 26081 | 9015 | 172 |
525995 | 525995 | 2020-09-12 | Kent | Michigan | 26081 | 9015 | 172 |
522759 | 522759 | 2020-09-11 | Kent | Michigan | 26081 | 8969 | 171 |
519522 | 519522 | 2020-09-10 | Kent | Michigan | 26081 | 8900 | 171 |
516287 | 516287 | 2020-09-09 | Kent | Michigan | 26081 | 8838 | 171 |
513053 | 513053 | 2020-09-08 | Kent | Michigan | 26081 | 8777 | 171 |
509821 | 509821 | 2020-09-07 | Kent | Michigan | 26081 | 8737 | 172 |
506588 | 506588 | 2020-09-06 | Kent | Michigan | 26081 | 8684 | 170 |
503355 | 503355 | 2020-09-05 | Kent | Michigan | 26081 | 8684 | 170 |
500121 | 500121 | 2020-09-04 | Kent | Michigan | 26081 | 8646 | 169 |
496887 | 496887 | 2020-09-03 | Kent | Michigan | 26081 | 8616 | 169 |
493654 | 493654 | 2020-09-02 | Kent | Michigan | 26081 | 8568 | 168 |
490420 | 490420 | 2020-09-01 | Kent | Michigan | 26081 | 8537 | 168 |
487187 | 487187 | 2020-08-31 | Kent | Michigan | 26081 | 8490 | 167 |
483953 | 483953 | 2020-08-30 | Kent | Michigan | 26081 | 8449 | 167 |
480718 | 480718 | 2020-08-29 | Kent | Michigan | 26081 | 8409 | 164 |
477486 | 477486 | 2020-08-28 | Kent | Michigan | 26081 | 8353 | 162 |
474253 | 474253 | 2020-08-27 | Kent | Michigan | 26081 | 8290 | 162 |
471021 | 471021 | 2020-08-26 | Kent | Michigan | 26081 | 8235 | 162 |
467791 | 467791 | 2020-08-25 | Kent | Michigan | 26081 | 8171 | 162 |
464562 | 464562 | 2020-08-24 | Kent | Michigan | 26081 | 8119 | 160 |
461331 | 461331 | 2020-08-23 | Kent | Michigan | 26081 | 8055 | 160 |
458104 | 458104 | 2020-08-22 | Kent | Michigan | 26081 | 7999 | 160 |
454876 | 454876 | 2020-08-21 | Kent | Michigan | 26081 | 7905 | 159 |
451648 | 451648 | 2020-08-20 | Kent | Michigan | 26081 | 7905 | 159 |
448420 | 448420 | 2020-08-19 | Kent | Michigan | 26081 | 7881 | 158 |
445194 | 445194 | 2020-08-18 | Kent | Michigan | 26081 | 7850 | 158 |
441968 | 441968 | 2020-08-17 | Kent | Michigan | 26081 | 7808 | 158 |
438741 | 438741 | 2020-08-16 | Kent | Michigan | 26081 | 7783 | 158 |
435516 | 435516 | 2020-08-15 | Kent | Michigan | 26081 | 7749 | 157 |
432290 | 432290 | 2020-08-14 | Kent | Michigan | 26081 | 7708 | 157 |
429063 | 429063 | 2020-08-13 | Kent | Michigan | 26081 | 7677 | 157 |
425839 | 425839 | 2020-08-12 | Kent | Michigan | 26081 | 7635 | 157 |
422617 | 422617 | 2020-08-11 | Kent | Michigan | 26081 | 7606 | 157 |
419395 | 419395 | 2020-08-10 | Kent | Michigan | 26081 | 7555 | 157 |
416174 | 416174 | 2020-08-09 | Kent | Michigan | 26081 | 7529 | 157 |
412954 | 412954 | 2020-08-08 | Kent | Michigan | 26081 | 7491 | 157 |
409734 | 409734 | 2020-08-07 | Kent | Michigan | 26081 | 7454 | 158 |
406514 | 406514 | 2020-08-06 | Kent | Michigan | 26081 | 7386 | 157 |
403296 | 403296 | 2020-08-05 | Kent | Michigan | 26081 | 7342 | 154 |
400079 | 400079 | 2020-08-04 | Kent | Michigan | 26081 | 7300 | 154 |
396865 | 396865 | 2020-08-03 | Kent | Michigan | 26081 | 7239 | 154 |
393649 | 393649 | 2020-08-02 | Kent | Michigan | 26081 | 7204 | 154 |
390432 | 390432 | 2020-08-01 | Kent | Michigan | 26081 | 7111 | 154 |
387215 | 387215 | 2020-07-31 | Kent | Michigan | 26081 | 7059 | 154 |
383997 | 383997 | 2020-07-30 | Kent | Michigan | 26081 | 6997 | 154 |
380780 | 380780 | 2020-07-29 | Kent | Michigan | 26081 | 6951 | 154 |
377563 | 377563 | 2020-07-28 | Kent | Michigan | 26081 | 6908 | 154 |
374348 | 374348 | 2020-07-27 | Kent | Michigan | 26081 | 6829 | 152 |
371136 | 371136 | 2020-07-26 | Kent | Michigan | 26081 | 6787 | 152 |
367926 | 367926 | 2020-07-25 | Kent | Michigan | 26081 | 6654 | 152 |
364719 | 364719 | 2020-07-24 | Kent | Michigan | 26081 | 6613 | 151 |
361512 | 361512 | 2020-07-23 | Kent | Michigan | 26081 | 6574 | 150 |
358307 | 358307 | 2020-07-22 | Kent | Michigan | 26081 | 6492 | 150 |
355104 | 355104 | 2020-07-21 | Kent | Michigan | 26081 | 6430 | 149 |
351902 | 351902 | 2020-07-20 | Kent | Michigan | 26081 | 6363 | 148 |
348702 | 348702 | 2020-07-19 | Kent | Michigan | 26081 | 6341 | 147 |
345501 | 345501 | 2020-07-18 | Kent | Michigan | 26081 | 6276 | 147 |
342301 | 342301 | 2020-07-17 | Kent | Michigan | 26081 | 6216 | 146 |
339105 | 339105 | 2020-07-16 | Kent | Michigan | 26081 | 6130 | 145 |
335909 | 335909 | 2020-07-15 | Kent | Michigan | 26081 | 6067 | 145 |
332716 | 332716 | 2020-07-14 | Kent | Michigan | 26081 | 5988 | 145 |
329529 | 329529 | 2020-07-13 | Kent | Michigan | 26081 | 5891 | 145 |
326343 | 326343 | 2020-07-12 | Kent | Michigan | 26081 | 5857 | 144 |
323160 | 323160 | 2020-07-11 | Kent | Michigan | 26081 | 5791 | 144 |
319981 | 319981 | 2020-07-10 | Kent | Michigan | 26081 | 5681 | 141 |
316806 | 316806 | 2020-07-09 | Kent | Michigan | 26081 | 5581 | 139 |
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);