ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,137 rows where county = "St. Clair" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- St. Clair · 716 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535107 | 535107 | 2020-09-15 | St. Clair | Illinois | 17163 | 6750 | 181 |
535738 | 535738 | 2020-09-15 | St. Clair | Michigan | 26147 | 969 | 53 |
536016 | 536016 | 2020-09-15 | St. Clair | Missouri | 29185 | 33 | 0 |
531247 | 531247 | 2020-09-14 | St. Clair | Alabama | 1115 | 2132 | 34 |
531872 | 531872 | 2020-09-14 | St. Clair | Illinois | 17163 | 6704 | 180 |
532503 | 532503 | 2020-09-14 | St. Clair | Michigan | 26147 | 961 | 53 |
532781 | 532781 | 2020-09-14 | St. Clair | Missouri | 29185 | 33 | 0 |
528010 | 528010 | 2020-09-13 | St. Clair | Alabama | 1115 | 2114 | 34 |
528635 | 528635 | 2020-09-13 | St. Clair | Illinois | 17163 | 6652 | 180 |
529267 | 529267 | 2020-09-13 | St. Clair | Michigan | 26147 | 958 | 53 |
529545 | 529545 | 2020-09-13 | St. Clair | Missouri | 29185 | 33 | 0 |
524774 | 524774 | 2020-09-12 | St. Clair | Alabama | 1115 | 2083 | 34 |
525399 | 525399 | 2020-09-12 | St. Clair | Illinois | 17163 | 6632 | 180 |
526031 | 526031 | 2020-09-12 | St. Clair | Michigan | 26147 | 958 | 53 |
526309 | 526309 | 2020-09-12 | St. Clair | Missouri | 29185 | 33 | 0 |
521538 | 521538 | 2020-09-11 | St. Clair | Alabama | 1115 | 2056 | 33 |
522163 | 522163 | 2020-09-11 | St. Clair | Illinois | 17163 | 6583 | 179 |
522795 | 522795 | 2020-09-11 | St. Clair | Michigan | 26147 | 956 | 53 |
523073 | 523073 | 2020-09-11 | St. Clair | Missouri | 29185 | 32 | 0 |
518301 | 518301 | 2020-09-10 | St. Clair | Alabama | 1115 | 2030 | 33 |
518926 | 518926 | 2020-09-10 | St. Clair | Illinois | 17163 | 6516 | 179 |
519558 | 519558 | 2020-09-10 | St. Clair | Michigan | 26147 | 956 | 53 |
519836 | 519836 | 2020-09-10 | St. Clair | Missouri | 29185 | 31 | 0 |
515066 | 515066 | 2020-09-09 | St. Clair | Alabama | 1115 | 2012 | 32 |
515691 | 515691 | 2020-09-09 | St. Clair | Illinois | 17163 | 6421 | 178 |
516323 | 516323 | 2020-09-09 | St. Clair | Michigan | 26147 | 953 | 53 |
516601 | 516601 | 2020-09-09 | St. Clair | Missouri | 29185 | 30 | 0 |
511833 | 511833 | 2020-09-08 | St. Clair | Alabama | 1115 | 1997 | 32 |
512458 | 512458 | 2020-09-08 | St. Clair | Illinois | 17163 | 6356 | 178 |
513089 | 513089 | 2020-09-08 | St. Clair | Michigan | 26147 | 953 | 53 |
513367 | 513367 | 2020-09-08 | St. Clair | Missouri | 29185 | 30 | 0 |
508600 | 508600 | 2020-09-07 | St. Clair | Alabama | 1115 | 1981 | 32 |
509225 | 509225 | 2020-09-07 | St. Clair | Illinois | 17163 | 6306 | 176 |
509857 | 509857 | 2020-09-07 | St. Clair | Michigan | 26147 | 949 | 53 |
510135 | 510135 | 2020-09-07 | St. Clair | Missouri | 29185 | 30 | 0 |
505368 | 505368 | 2020-09-06 | St. Clair | Alabama | 1115 | 1968 | 32 |
505993 | 505993 | 2020-09-06 | St. Clair | Illinois | 17163 | 6259 | 176 |
506624 | 506624 | 2020-09-06 | St. Clair | Michigan | 26147 | 947 | 53 |
506902 | 506902 | 2020-09-06 | St. Clair | Missouri | 29185 | 29 | 0 |
502134 | 502134 | 2020-09-05 | St. Clair | Alabama | 1115 | 1959 | 32 |
502759 | 502759 | 2020-09-05 | St. Clair | Illinois | 17163 | 6231 | 176 |
503391 | 503391 | 2020-09-05 | St. Clair | Michigan | 26147 | 947 | 53 |
503669 | 503669 | 2020-09-05 | St. Clair | Missouri | 29185 | 29 | 0 |
498900 | 498900 | 2020-09-04 | St. Clair | Alabama | 1115 | 1933 | 32 |
499525 | 499525 | 2020-09-04 | St. Clair | Illinois | 17163 | 6167 | 175 |
500157 | 500157 | 2020-09-04 | St. Clair | Michigan | 26147 | 941 | 53 |
500435 | 500435 | 2020-09-04 | St. Clair | Missouri | 29185 | 28 | 0 |
495667 | 495667 | 2020-09-03 | St. Clair | Alabama | 1115 | 1914 | 30 |
496292 | 496292 | 2020-09-03 | St. Clair | Illinois | 17163 | 6041 | 175 |
496923 | 496923 | 2020-09-03 | St. Clair | Michigan | 26147 | 939 | 53 |
497201 | 497201 | 2020-09-03 | St. Clair | Missouri | 29185 | 27 | 0 |
492433 | 492433 | 2020-09-02 | St. Clair | Alabama | 1115 | 1888 | 30 |
493058 | 493058 | 2020-09-02 | St. Clair | Illinois | 17163 | 5992 | 175 |
493690 | 493690 | 2020-09-02 | St. Clair | Michigan | 26147 | 935 | 53 |
493968 | 493968 | 2020-09-02 | St. Clair | Missouri | 29185 | 27 | 0 |
489200 | 489200 | 2020-09-01 | St. Clair | Alabama | 1115 | 1877 | 29 |
489825 | 489825 | 2020-09-01 | St. Clair | Illinois | 17163 | 5935 | 175 |
490456 | 490456 | 2020-09-01 | St. Clair | Michigan | 26147 | 934 | 53 |
490734 | 490734 | 2020-09-01 | St. Clair | Missouri | 29185 | 27 | 0 |
485967 | 485967 | 2020-08-31 | St. Clair | Alabama | 1115 | 1844 | 29 |
486592 | 486592 | 2020-08-31 | St. Clair | Illinois | 17163 | 5850 | 174 |
487223 | 487223 | 2020-08-31 | St. Clair | Michigan | 26147 | 927 | 53 |
487501 | 487501 | 2020-08-31 | St. Clair | Missouri | 29185 | 27 | 0 |
482732 | 482732 | 2020-08-30 | St. Clair | Alabama | 1115 | 1833 | 28 |
483357 | 483357 | 2020-08-30 | St. Clair | Illinois | 17163 | 5794 | 174 |
483989 | 483989 | 2020-08-30 | St. Clair | Michigan | 26147 | 922 | 53 |
484267 | 484267 | 2020-08-30 | St. Clair | Missouri | 29185 | 27 | 0 |
479498 | 479498 | 2020-08-29 | St. Clair | Alabama | 1115 | 1811 | 28 |
480123 | 480123 | 2020-08-29 | St. Clair | Illinois | 17163 | 5775 | 174 |
480754 | 480754 | 2020-08-29 | St. Clair | Michigan | 26147 | 922 | 53 |
481032 | 481032 | 2020-08-29 | St. Clair | Missouri | 29185 | 28 | 0 |
476265 | 476265 | 2020-08-28 | St. Clair | Alabama | 1115 | 1795 | 27 |
476890 | 476890 | 2020-08-28 | St. Clair | Illinois | 17163 | 5683 | 174 |
477522 | 477522 | 2020-08-28 | St. Clair | Michigan | 26147 | 912 | 53 |
477800 | 477800 | 2020-08-28 | St. Clair | Missouri | 29185 | 26 | 0 |
473032 | 473032 | 2020-08-27 | St. Clair | Alabama | 1115 | 1765 | 26 |
473657 | 473657 | 2020-08-27 | St. Clair | Illinois | 17163 | 5617 | 174 |
474289 | 474289 | 2020-08-27 | St. Clair | Michigan | 26147 | 905 | 53 |
474567 | 474567 | 2020-08-27 | St. Clair | Missouri | 29185 | 26 | 0 |
469800 | 469800 | 2020-08-26 | St. Clair | Alabama | 1115 | 1749 | 25 |
470425 | 470425 | 2020-08-26 | St. Clair | Illinois | 17163 | 5549 | 174 |
471057 | 471057 | 2020-08-26 | St. Clair | Michigan | 26147 | 898 | 53 |
471335 | 471335 | 2020-08-26 | St. Clair | Missouri | 29185 | 26 | 0 |
466571 | 466571 | 2020-08-25 | St. Clair | Alabama | 1115 | 1704 | 25 |
467196 | 467196 | 2020-08-25 | St. Clair | Illinois | 17163 | 5503 | 174 |
467827 | 467827 | 2020-08-25 | St. Clair | Michigan | 26147 | 889 | 53 |
468105 | 468105 | 2020-08-25 | St. Clair | Missouri | 29185 | 26 | 0 |
463342 | 463342 | 2020-08-24 | St. Clair | Alabama | 1115 | 1701 | 25 |
463967 | 463967 | 2020-08-24 | St. Clair | Illinois | 17163 | 5449 | 173 |
464598 | 464598 | 2020-08-24 | St. Clair | Michigan | 26147 | 884 | 53 |
464876 | 464876 | 2020-08-24 | St. Clair | Missouri | 29185 | 26 | 0 |
460113 | 460113 | 2020-08-23 | St. Clair | Alabama | 1115 | 1677 | 25 |
460738 | 460738 | 2020-08-23 | St. Clair | Illinois | 17163 | 5370 | 173 |
461367 | 461367 | 2020-08-23 | St. Clair | Michigan | 26147 | 882 | 53 |
461645 | 461645 | 2020-08-23 | St. Clair | Missouri | 29185 | 25 | 0 |
456886 | 456886 | 2020-08-22 | St. Clair | Alabama | 1115 | 1641 | 25 |
457511 | 457511 | 2020-08-22 | St. Clair | Illinois | 17163 | 5296 | 172 |
458140 | 458140 | 2020-08-22 | St. Clair | Michigan | 26147 | 876 | 53 |
458418 | 458418 | 2020-08-22 | St. Clair | Missouri | 29185 | 25 | 0 |
453658 | 453658 | 2020-08-21 | St. Clair | Alabama | 1115 | 1639 | 24 |
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);