ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Charlevoix" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636141 | 636141 | 2020-10-16 | Charlevoix | Michigan | 26029 | 135 | 4 |
632895 | 632895 | 2020-10-15 | Charlevoix | Michigan | 26029 | 134 | 4 |
629650 | 629650 | 2020-10-14 | Charlevoix | Michigan | 26029 | 129 | 4 |
626406 | 626406 | 2020-10-13 | Charlevoix | Michigan | 26029 | 127 | 4 |
623164 | 623164 | 2020-10-12 | Charlevoix | Michigan | 26029 | 126 | 4 |
619921 | 619921 | 2020-10-11 | Charlevoix | Michigan | 26029 | 120 | 4 |
616679 | 616679 | 2020-10-10 | Charlevoix | Michigan | 26029 | 120 | 4 |
613438 | 613438 | 2020-10-09 | Charlevoix | Michigan | 26029 | 120 | 4 |
610196 | 610196 | 2020-10-08 | Charlevoix | Michigan | 26029 | 120 | 4 |
606954 | 606954 | 2020-10-07 | Charlevoix | Michigan | 26029 | 120 | 4 |
603711 | 603711 | 2020-10-06 | Charlevoix | Michigan | 26029 | 119 | 4 |
600469 | 600469 | 2020-10-05 | Charlevoix | Michigan | 26029 | 118 | 4 |
597226 | 597226 | 2020-10-04 | Charlevoix | Michigan | 26029 | 115 | 3 |
593985 | 593985 | 2020-10-03 | Charlevoix | Michigan | 26029 | 115 | 3 |
590744 | 590744 | 2020-10-02 | Charlevoix | Michigan | 26029 | 115 | 3 |
587503 | 587503 | 2020-10-01 | Charlevoix | Michigan | 26029 | 113 | 3 |
584263 | 584263 | 2020-09-30 | Charlevoix | Michigan | 26029 | 112 | 3 |
581022 | 581022 | 2020-09-29 | Charlevoix | Michigan | 26029 | 111 | 3 |
577781 | 577781 | 2020-09-28 | Charlevoix | Michigan | 26029 | 111 | 3 |
574540 | 574540 | 2020-09-27 | Charlevoix | Michigan | 26029 | 111 | 3 |
571297 | 571297 | 2020-09-26 | Charlevoix | Michigan | 26029 | 111 | 3 |
568055 | 568055 | 2020-09-25 | Charlevoix | Michigan | 26029 | 111 | 3 |
564815 | 564815 | 2020-09-24 | Charlevoix | Michigan | 26029 | 107 | 3 |
561575 | 561575 | 2020-09-23 | Charlevoix | Michigan | 26029 | 108 | 3 |
558338 | 558338 | 2020-09-22 | Charlevoix | Michigan | 26029 | 101 | 3 |
555101 | 555101 | 2020-09-21 | Charlevoix | Michigan | 26029 | 98 | 3 |
551863 | 551863 | 2020-09-20 | Charlevoix | Michigan | 26029 | 98 | 3 |
548624 | 548624 | 2020-09-19 | Charlevoix | Michigan | 26029 | 98 | 3 |
545386 | 545386 | 2020-09-18 | Charlevoix | Michigan | 26029 | 98 | 3 |
542149 | 542149 | 2020-09-17 | Charlevoix | Michigan | 26029 | 98 | 3 |
538913 | 538913 | 2020-09-16 | Charlevoix | Michigan | 26029 | 98 | 3 |
535676 | 535676 | 2020-09-15 | Charlevoix | Michigan | 26029 | 95 | 3 |
532441 | 532441 | 2020-09-14 | Charlevoix | Michigan | 26029 | 95 | 3 |
529205 | 529205 | 2020-09-13 | Charlevoix | Michigan | 26029 | 93 | 3 |
525969 | 525969 | 2020-09-12 | Charlevoix | Michigan | 26029 | 93 | 3 |
522733 | 522733 | 2020-09-11 | Charlevoix | Michigan | 26029 | 93 | 3 |
519496 | 519496 | 2020-09-10 | Charlevoix | Michigan | 26029 | 86 | 3 |
516261 | 516261 | 2020-09-09 | Charlevoix | Michigan | 26029 | 85 | 3 |
513027 | 513027 | 2020-09-08 | Charlevoix | Michigan | 26029 | 84 | 3 |
509795 | 509795 | 2020-09-07 | Charlevoix | Michigan | 26029 | 79 | 3 |
506562 | 506562 | 2020-09-06 | Charlevoix | Michigan | 26029 | 79 | 3 |
503329 | 503329 | 2020-09-05 | Charlevoix | Michigan | 26029 | 79 | 3 |
500095 | 500095 | 2020-09-04 | Charlevoix | Michigan | 26029 | 78 | 3 |
496861 | 496861 | 2020-09-03 | Charlevoix | Michigan | 26029 | 77 | 3 |
493628 | 493628 | 2020-09-02 | Charlevoix | Michigan | 26029 | 77 | 3 |
490394 | 490394 | 2020-09-01 | Charlevoix | Michigan | 26029 | 79 | 3 |
487161 | 487161 | 2020-08-31 | Charlevoix | Michigan | 26029 | 76 | 2 |
483927 | 483927 | 2020-08-30 | Charlevoix | Michigan | 26029 | 74 | 2 |
480692 | 480692 | 2020-08-29 | Charlevoix | Michigan | 26029 | 74 | 2 |
477460 | 477460 | 2020-08-28 | Charlevoix | Michigan | 26029 | 74 | 2 |
474227 | 474227 | 2020-08-27 | Charlevoix | Michigan | 26029 | 74 | 2 |
470995 | 470995 | 2020-08-26 | Charlevoix | Michigan | 26029 | 73 | 2 |
467765 | 467765 | 2020-08-25 | Charlevoix | Michigan | 26029 | 71 | 2 |
464536 | 464536 | 2020-08-24 | Charlevoix | Michigan | 26029 | 70 | 2 |
461305 | 461305 | 2020-08-23 | Charlevoix | Michigan | 26029 | 63 | 2 |
458078 | 458078 | 2020-08-22 | Charlevoix | Michigan | 26029 | 63 | 2 |
454850 | 454850 | 2020-08-21 | Charlevoix | Michigan | 26029 | 63 | 2 |
451622 | 451622 | 2020-08-20 | Charlevoix | Michigan | 26029 | 62 | 2 |
448394 | 448394 | 2020-08-19 | Charlevoix | Michigan | 26029 | 62 | 2 |
445168 | 445168 | 2020-08-18 | Charlevoix | Michigan | 26029 | 62 | 2 |
441942 | 441942 | 2020-08-17 | Charlevoix | Michigan | 26029 | 62 | 2 |
438715 | 438715 | 2020-08-16 | Charlevoix | Michigan | 26029 | 56 | 2 |
435490 | 435490 | 2020-08-15 | Charlevoix | Michigan | 26029 | 56 | 2 |
432264 | 432264 | 2020-08-14 | Charlevoix | Michigan | 26029 | 56 | 2 |
429037 | 429037 | 2020-08-13 | Charlevoix | Michigan | 26029 | 55 | 2 |
425813 | 425813 | 2020-08-12 | Charlevoix | Michigan | 26029 | 54 | 2 |
422591 | 422591 | 2020-08-11 | Charlevoix | Michigan | 26029 | 53 | 2 |
419369 | 419369 | 2020-08-10 | Charlevoix | Michigan | 26029 | 53 | 2 |
416148 | 416148 | 2020-08-09 | Charlevoix | Michigan | 26029 | 50 | 2 |
412928 | 412928 | 2020-08-08 | Charlevoix | Michigan | 26029 | 50 | 2 |
409708 | 409708 | 2020-08-07 | Charlevoix | Michigan | 26029 | 50 | 2 |
406488 | 406488 | 2020-08-06 | Charlevoix | Michigan | 26029 | 48 | 2 |
403270 | 403270 | 2020-08-05 | Charlevoix | Michigan | 26029 | 48 | 2 |
400053 | 400053 | 2020-08-04 | Charlevoix | Michigan | 26029 | 48 | 2 |
396839 | 396839 | 2020-08-03 | Charlevoix | Michigan | 26029 | 47 | 2 |
393623 | 393623 | 2020-08-02 | Charlevoix | Michigan | 26029 | 45 | 2 |
390406 | 390406 | 2020-08-01 | Charlevoix | Michigan | 26029 | 45 | 2 |
387189 | 387189 | 2020-07-31 | Charlevoix | Michigan | 26029 | 45 | 2 |
383971 | 383971 | 2020-07-30 | Charlevoix | Michigan | 26029 | 45 | 2 |
380754 | 380754 | 2020-07-29 | Charlevoix | Michigan | 26029 | 46 | 2 |
377537 | 377537 | 2020-07-28 | Charlevoix | Michigan | 26029 | 45 | 2 |
374322 | 374322 | 2020-07-27 | Charlevoix | Michigan | 26029 | 44 | 2 |
371110 | 371110 | 2020-07-26 | Charlevoix | Michigan | 26029 | 45 | 2 |
367900 | 367900 | 2020-07-25 | Charlevoix | Michigan | 26029 | 44 | 2 |
364693 | 364693 | 2020-07-24 | Charlevoix | Michigan | 26029 | 44 | 2 |
361486 | 361486 | 2020-07-23 | Charlevoix | Michigan | 26029 | 44 | 2 |
358281 | 358281 | 2020-07-22 | Charlevoix | Michigan | 26029 | 44 | 2 |
355078 | 355078 | 2020-07-21 | Charlevoix | Michigan | 26029 | 44 | 2 |
351876 | 351876 | 2020-07-20 | Charlevoix | Michigan | 26029 | 43 | 2 |
348676 | 348676 | 2020-07-19 | Charlevoix | Michigan | 26029 | 43 | 2 |
345475 | 345475 | 2020-07-18 | Charlevoix | Michigan | 26029 | 43 | 2 |
342275 | 342275 | 2020-07-17 | Charlevoix | Michigan | 26029 | 43 | 2 |
339079 | 339079 | 2020-07-16 | Charlevoix | Michigan | 26029 | 43 | 2 |
335883 | 335883 | 2020-07-15 | Charlevoix | Michigan | 26029 | 44 | 2 |
332690 | 332690 | 2020-07-14 | Charlevoix | Michigan | 26029 | 35 | 2 |
329503 | 329503 | 2020-07-13 | Charlevoix | Michigan | 26029 | 35 | 2 |
326317 | 326317 | 2020-07-12 | Charlevoix | Michigan | 26029 | 34 | 2 |
323134 | 323134 | 2020-07-11 | Charlevoix | Michigan | 26029 | 34 | 2 |
319955 | 319955 | 2020-07-10 | Charlevoix | Michigan | 26029 | 34 | 2 |
316780 | 316780 | 2020-07-09 | Charlevoix | Michigan | 26029 | 34 | 2 |
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);