ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "St. Clair" and state = "Michigan" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
256988 | 256988 | 2020-06-20 | St. Clair | Michigan | 26147 | 525 | 48 |
260114 | 260114 | 2020-06-21 | St. Clair | Michigan | 26147 | 525 | 48 |
263243 | 263243 | 2020-06-22 | St. Clair | Michigan | 26147 | 530 | 48 |
266369 | 266369 | 2020-06-23 | St. Clair | Michigan | 26147 | 530 | 49 |
269502 | 269502 | 2020-06-24 | St. Clair | Michigan | 26147 | 534 | 49 |
272639 | 272639 | 2020-06-25 | St. Clair | Michigan | 26147 | 538 | 49 |
275782 | 275782 | 2020-06-26 | St. Clair | Michigan | 26147 | 543 | 49 |
278930 | 278930 | 2020-06-27 | St. Clair | Michigan | 26147 | 547 | 49 |
282078 | 282078 | 2020-06-28 | St. Clair | Michigan | 26147 | 549 | 49 |
285223 | 285223 | 2020-06-29 | St. Clair | Michigan | 26147 | 553 | 49 |
288373 | 288373 | 2020-06-30 | St. Clair | Michigan | 26147 | 560 | 50 |
291524 | 291524 | 2020-07-01 | St. Clair | Michigan | 26147 | 561 | 50 |
294678 | 294678 | 2020-07-02 | St. Clair | Michigan | 26147 | 572 | 50 |
297836 | 297836 | 2020-07-03 | St. Clair | Michigan | 26147 | 579 | 50 |
300999 | 300999 | 2020-07-04 | St. Clair | Michigan | 26147 | 586 | 50 |
304163 | 304163 | 2020-07-05 | St. Clair | Michigan | 26147 | 590 | 50 |
307330 | 307330 | 2020-07-06 | St. Clair | Michigan | 26147 | 590 | 50 |
310498 | 310498 | 2020-07-07 | St. Clair | Michigan | 26147 | 593 | 51 |
313668 | 313668 | 2020-07-08 | St. Clair | Michigan | 26147 | 599 | 52 |
316842 | 316842 | 2020-07-09 | St. Clair | Michigan | 26147 | 602 | 53 |
320017 | 320017 | 2020-07-10 | St. Clair | Michigan | 26147 | 607 | 53 |
323196 | 323196 | 2020-07-11 | St. Clair | Michigan | 26147 | 607 | 53 |
326379 | 326379 | 2020-07-12 | St. Clair | Michigan | 26147 | 611 | 53 |
329565 | 329565 | 2020-07-13 | St. Clair | Michigan | 26147 | 615 | 53 |
332752 | 332752 | 2020-07-14 | St. Clair | Michigan | 26147 | 619 | 53 |
335945 | 335945 | 2020-07-15 | St. Clair | Michigan | 26147 | 626 | 53 |
339141 | 339141 | 2020-07-16 | St. Clair | Michigan | 26147 | 628 | 53 |
342337 | 342337 | 2020-07-17 | St. Clair | Michigan | 26147 | 639 | 53 |
345537 | 345537 | 2020-07-18 | St. Clair | Michigan | 26147 | 642 | 53 |
348738 | 348738 | 2020-07-19 | St. Clair | Michigan | 26147 | 649 | 53 |
351938 | 351938 | 2020-07-20 | St. Clair | Michigan | 26147 | 656 | 53 |
355140 | 355140 | 2020-07-21 | St. Clair | Michigan | 26147 | 662 | 53 |
358343 | 358343 | 2020-07-22 | St. Clair | Michigan | 26147 | 672 | 53 |
361548 | 361548 | 2020-07-23 | St. Clair | Michigan | 26147 | 672 | 53 |
364755 | 364755 | 2020-07-24 | St. Clair | Michigan | 26147 | 681 | 53 |
367962 | 367962 | 2020-07-25 | St. Clair | Michigan | 26147 | 689 | 53 |
371172 | 371172 | 2020-07-26 | St. Clair | Michigan | 26147 | 702 | 53 |
374384 | 374384 | 2020-07-27 | St. Clair | Michigan | 26147 | 710 | 53 |
377599 | 377599 | 2020-07-28 | St. Clair | Michigan | 26147 | 724 | 53 |
380816 | 380816 | 2020-07-29 | St. Clair | Michigan | 26147 | 749 | 53 |
384033 | 384033 | 2020-07-30 | St. Clair | Michigan | 26147 | 749 | 53 |
387251 | 387251 | 2020-07-31 | St. Clair | Michigan | 26147 | 756 | 53 |
390468 | 390468 | 2020-08-01 | St. Clair | Michigan | 26147 | 775 | 53 |
393685 | 393685 | 2020-08-02 | St. Clair | Michigan | 26147 | 777 | 53 |
396901 | 396901 | 2020-08-03 | St. Clair | Michigan | 26147 | 781 | 53 |
400115 | 400115 | 2020-08-04 | St. Clair | Michigan | 26147 | 786 | 53 |
403332 | 403332 | 2020-08-05 | St. Clair | Michigan | 26147 | 792 | 53 |
406550 | 406550 | 2020-08-06 | St. Clair | Michigan | 26147 | 797 | 53 |
409770 | 409770 | 2020-08-07 | St. Clair | Michigan | 26147 | 805 | 53 |
412990 | 412990 | 2020-08-08 | St. Clair | Michigan | 26147 | 812 | 53 |
416210 | 416210 | 2020-08-09 | St. Clair | Michigan | 26147 | 815 | 53 |
419431 | 419431 | 2020-08-10 | St. Clair | Michigan | 26147 | 824 | 53 |
422653 | 422653 | 2020-08-11 | St. Clair | Michigan | 26147 | 828 | 53 |
425875 | 425875 | 2020-08-12 | St. Clair | Michigan | 26147 | 829 | 53 |
429099 | 429099 | 2020-08-13 | St. Clair | Michigan | 26147 | 838 | 53 |
432326 | 432326 | 2020-08-14 | St. Clair | Michigan | 26147 | 842 | 53 |
435552 | 435552 | 2020-08-15 | St. Clair | Michigan | 26147 | 842 | 53 |
438777 | 438777 | 2020-08-16 | St. Clair | Michigan | 26147 | 845 | 53 |
442004 | 442004 | 2020-08-17 | St. Clair | Michigan | 26147 | 845 | 53 |
445230 | 445230 | 2020-08-18 | St. Clair | Michigan | 26147 | 851 | 53 |
448456 | 448456 | 2020-08-19 | St. Clair | Michigan | 26147 | 857 | 53 |
451684 | 451684 | 2020-08-20 | St. Clair | Michigan | 26147 | 866 | 53 |
454912 | 454912 | 2020-08-21 | St. Clair | Michigan | 26147 | 866 | 53 |
458140 | 458140 | 2020-08-22 | St. Clair | Michigan | 26147 | 876 | 53 |
461367 | 461367 | 2020-08-23 | St. Clair | Michigan | 26147 | 882 | 53 |
464598 | 464598 | 2020-08-24 | St. Clair | Michigan | 26147 | 884 | 53 |
467827 | 467827 | 2020-08-25 | St. Clair | Michigan | 26147 | 889 | 53 |
471057 | 471057 | 2020-08-26 | St. Clair | Michigan | 26147 | 898 | 53 |
474289 | 474289 | 2020-08-27 | St. Clair | Michigan | 26147 | 905 | 53 |
477522 | 477522 | 2020-08-28 | St. Clair | Michigan | 26147 | 912 | 53 |
480754 | 480754 | 2020-08-29 | St. Clair | Michigan | 26147 | 922 | 53 |
483989 | 483989 | 2020-08-30 | St. Clair | Michigan | 26147 | 922 | 53 |
487223 | 487223 | 2020-08-31 | St. Clair | Michigan | 26147 | 927 | 53 |
490456 | 490456 | 2020-09-01 | St. Clair | Michigan | 26147 | 934 | 53 |
493690 | 493690 | 2020-09-02 | St. Clair | Michigan | 26147 | 935 | 53 |
496923 | 496923 | 2020-09-03 | St. Clair | Michigan | 26147 | 939 | 53 |
500157 | 500157 | 2020-09-04 | St. Clair | Michigan | 26147 | 941 | 53 |
503391 | 503391 | 2020-09-05 | St. Clair | Michigan | 26147 | 947 | 53 |
506624 | 506624 | 2020-09-06 | St. Clair | Michigan | 26147 | 947 | 53 |
509857 | 509857 | 2020-09-07 | St. Clair | Michigan | 26147 | 949 | 53 |
513089 | 513089 | 2020-09-08 | St. Clair | Michigan | 26147 | 953 | 53 |
516323 | 516323 | 2020-09-09 | St. Clair | Michigan | 26147 | 953 | 53 |
519558 | 519558 | 2020-09-10 | St. Clair | Michigan | 26147 | 956 | 53 |
522795 | 522795 | 2020-09-11 | St. Clair | Michigan | 26147 | 956 | 53 |
526031 | 526031 | 2020-09-12 | St. Clair | Michigan | 26147 | 958 | 53 |
529267 | 529267 | 2020-09-13 | St. Clair | Michigan | 26147 | 958 | 53 |
532503 | 532503 | 2020-09-14 | St. Clair | Michigan | 26147 | 961 | 53 |
535738 | 535738 | 2020-09-15 | St. Clair | Michigan | 26147 | 969 | 53 |
538975 | 538975 | 2020-09-16 | St. Clair | Michigan | 26147 | 970 | 53 |
542211 | 542211 | 2020-09-17 | St. Clair | Michigan | 26147 | 974 | 53 |
545448 | 545448 | 2020-09-18 | St. Clair | Michigan | 26147 | 979 | 53 |
548686 | 548686 | 2020-09-19 | St. Clair | Michigan | 26147 | 982 | 53 |
551925 | 551925 | 2020-09-20 | St. Clair | Michigan | 26147 | 982 | 53 |
555163 | 555163 | 2020-09-21 | St. Clair | Michigan | 26147 | 985 | 53 |
558400 | 558400 | 2020-09-22 | St. Clair | Michigan | 26147 | 985 | 53 |
561637 | 561637 | 2020-09-23 | St. Clair | Michigan | 26147 | 985 | 55 |
564877 | 564877 | 2020-09-24 | St. Clair | Michigan | 26147 | 995 | 56 |
568117 | 568117 | 2020-09-25 | St. Clair | Michigan | 26147 | 1001 | 56 |
571359 | 571359 | 2020-09-26 | St. Clair | Michigan | 26147 | 1012 | 56 |
574602 | 574602 | 2020-09-27 | St. Clair | Michigan | 26147 | 1014 | 56 |
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);