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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
county 1
- St. Clair · 3,137 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1482 | 1482 | 2020-03-12 | St. Clair | Michigan | 26147 | 1 | 0 |
1765 | 1765 | 2020-03-13 | St. Clair | Michigan | 26147 | 1 | 0 |
2047 | 2047 | 2020-03-14 | St. Clair | Illinois | 17163 | 2 | 0 |
2109 | 2109 | 2020-03-14 | St. Clair | Michigan | 26147 | 1 | 0 |
2438 | 2438 | 2020-03-15 | St. Clair | Illinois | 17163 | 2 | 0 |
2513 | 2513 | 2020-03-15 | St. Clair | Michigan | 26147 | 2 | 0 |
2880 | 2880 | 2020-03-16 | St. Clair | Illinois | 17163 | 2 | 0 |
2963 | 2963 | 2020-03-16 | St. Clair | Michigan | 26147 | 2 | 0 |
3223 | 3223 | 2020-03-17 | St. Clair | Alabama | 1115 | 1 | 0 |
3369 | 3369 | 2020-03-17 | St. Clair | Illinois | 17163 | 2 | 0 |
3466 | 3466 | 2020-03-17 | St. Clair | Michigan | 26147 | 2 | 0 |
3770 | 3770 | 2020-03-18 | St. Clair | Alabama | 1115 | 1 | 0 |
3937 | 3937 | 2020-03-18 | St. Clair | Illinois | 17163 | 3 | 0 |
4049 | 4049 | 2020-03-18 | St. Clair | Michigan | 26147 | 2 | 0 |
4412 | 4412 | 2020-03-19 | St. Clair | Alabama | 1115 | 1 | 0 |
4613 | 4613 | 2020-03-19 | St. Clair | Illinois | 17163 | 3 | 0 |
4759 | 4759 | 2020-03-19 | St. Clair | Michigan | 26147 | 4 | 0 |
5182 | 5182 | 2020-03-20 | St. Clair | Alabama | 1115 | 1 | 0 |
5419 | 5419 | 2020-03-20 | St. Clair | Illinois | 17163 | 3 | 0 |
5578 | 5578 | 2020-03-20 | St. Clair | Michigan | 26147 | 7 | 0 |
6099 | 6099 | 2020-03-21 | St. Clair | Alabama | 1115 | 1 | 0 |
6354 | 6354 | 2020-03-21 | St. Clair | Illinois | 17163 | 3 | 0 |
6544 | 6544 | 2020-03-21 | St. Clair | Michigan | 26147 | 7 | 0 |
7133 | 7133 | 2020-03-22 | St. Clair | Alabama | 1115 | 3 | 0 |
7407 | 7407 | 2020-03-22 | St. Clair | Illinois | 17163 | 3 | 0 |
7625 | 7625 | 2020-03-22 | St. Clair | Michigan | 26147 | 7 | 0 |
8273 | 8273 | 2020-03-23 | St. Clair | Alabama | 1115 | 3 | 0 |
8563 | 8563 | 2020-03-23 | St. Clair | Illinois | 17163 | 4 | 0 |
8801 | 8801 | 2020-03-23 | St. Clair | Michigan | 26147 | 7 | 0 |
9501 | 9501 | 2020-03-24 | St. Clair | Alabama | 1115 | 4 | 0 |
9827 | 9827 | 2020-03-24 | St. Clair | Illinois | 17163 | 7 | 0 |
10095 | 10095 | 2020-03-24 | St. Clair | Michigan | 26147 | 8 | 0 |
10870 | 10870 | 2020-03-25 | St. Clair | Alabama | 1115 | 6 | 0 |
11220 | 11220 | 2020-03-25 | St. Clair | Illinois | 17163 | 7 | 0 |
11511 | 11511 | 2020-03-25 | St. Clair | Michigan | 26147 | 10 | 0 |
12409 | 12409 | 2020-03-26 | St. Clair | Alabama | 1115 | 6 | 0 |
12776 | 12776 | 2020-03-26 | St. Clair | Illinois | 17163 | 13 | 0 |
13099 | 13099 | 2020-03-26 | St. Clair | Michigan | 26147 | 13 | 0 |
14071 | 14071 | 2020-03-27 | St. Clair | Alabama | 1115 | 9 | 0 |
14454 | 14454 | 2020-03-27 | St. Clair | Illinois | 17163 | 15 | 1 |
14811 | 14811 | 2020-03-27 | St. Clair | Michigan | 26147 | 15 | 0 |
15850 | 15850 | 2020-03-28 | St. Clair | Alabama | 1115 | 10 | 0 |
16250 | 16250 | 2020-03-28 | St. Clair | Illinois | 17163 | 18 | 1 |
16632 | 16632 | 2020-03-28 | St. Clair | Michigan | 26147 | 16 | 0 |
17734 | 17734 | 2020-03-29 | St. Clair | Alabama | 1115 | 13 | 0 |
18152 | 18152 | 2020-03-29 | St. Clair | Illinois | 17163 | 31 | 3 |
18548 | 18548 | 2020-03-29 | St. Clair | Michigan | 26147 | 20 | 0 |
19706 | 19706 | 2020-03-30 | St. Clair | Alabama | 1115 | 14 | 0 |
20157 | 20157 | 2020-03-30 | St. Clair | Illinois | 17163 | 36 | 3 |
20567 | 20567 | 2020-03-30 | St. Clair | Michigan | 26147 | 25 | 0 |
21778 | 21778 | 2020-03-31 | St. Clair | Alabama | 1115 | 15 | 0 |
22250 | 22250 | 2020-03-31 | St. Clair | Illinois | 17163 | 43 | 2 |
22679 | 22679 | 2020-03-31 | St. Clair | Michigan | 26147 | 32 | 0 |
23934 | 23934 | 2020-04-01 | St. Clair | Alabama | 1115 | 17 | 0 |
24419 | 24419 | 2020-04-01 | St. Clair | Illinois | 17163 | 53 | 2 |
24859 | 24859 | 2020-04-01 | St. Clair | Michigan | 26147 | 41 | 0 |
26156 | 26156 | 2020-04-02 | St. Clair | Alabama | 1115 | 19 | 0 |
26657 | 26657 | 2020-04-02 | St. Clair | Illinois | 17163 | 55 | 3 |
27112 | 27112 | 2020-04-02 | St. Clair | Michigan | 26147 | 53 | 0 |
28453 | 28453 | 2020-04-03 | St. Clair | Alabama | 1115 | 23 | 0 |
28967 | 28967 | 2020-04-03 | St. Clair | Illinois | 17163 | 57 | 3 |
29431 | 29431 | 2020-04-03 | St. Clair | Michigan | 26147 | 66 | 0 |
30810 | 30810 | 2020-04-04 | St. Clair | Alabama | 1115 | 25 | 0 |
31333 | 31333 | 2020-04-04 | St. Clair | Illinois | 17163 | 80 | 3 |
31809 | 31809 | 2020-04-04 | St. Clair | Michigan | 26147 | 85 | 2 |
33214 | 33214 | 2020-04-05 | St. Clair | Alabama | 1115 | 28 | 0 |
33743 | 33743 | 2020-04-05 | St. Clair | Illinois | 17163 | 86 | 3 |
34234 | 34234 | 2020-04-05 | St. Clair | Michigan | 26147 | 94 | 2 |
35653 | 35653 | 2020-04-06 | St. Clair | Alabama | 1115 | 31 | 0 |
36195 | 36195 | 2020-04-06 | St. Clair | Illinois | 17163 | 92 | 3 |
36694 | 36694 | 2020-04-06 | St. Clair | Michigan | 26147 | 110 | 3 |
38141 | 38141 | 2020-04-07 | St. Clair | Alabama | 1115 | 30 | 0 |
38693 | 38693 | 2020-04-07 | St. Clair | Illinois | 17163 | 109 | 3 |
39203 | 39203 | 2020-04-07 | St. Clair | Michigan | 26147 | 129 | 3 |
40683 | 40683 | 2020-04-08 | St. Clair | Alabama | 1115 | 35 | 0 |
41238 | 41238 | 2020-04-08 | St. Clair | Illinois | 17163 | 127 | 3 |
41756 | 41756 | 2020-04-08 | St. Clair | Michigan | 26147 | 140 | 3 |
43257 | 43257 | 2020-04-09 | St. Clair | Alabama | 1115 | 37 | 0 |
43814 | 43814 | 2020-04-09 | St. Clair | Illinois | 17163 | 144 | 4 |
44332 | 44332 | 2020-04-09 | St. Clair | Michigan | 26147 | 162 | 4 |
44561 | 44561 | 2020-04-09 | St. Clair | Missouri | 29185 | 2 | 0 |
45855 | 45855 | 2020-04-10 | St. Clair | Alabama | 1115 | 37 | 0 |
46418 | 46418 | 2020-04-10 | St. Clair | Illinois | 17163 | 159 | 5 |
46941 | 46941 | 2020-04-10 | St. Clair | Michigan | 26147 | 179 | 4 |
47170 | 47170 | 2020-04-10 | St. Clair | Missouri | 29185 | 2 | 0 |
48484 | 48484 | 2020-04-11 | St. Clair | Alabama | 1115 | 39 | 0 |
49051 | 49051 | 2020-04-11 | St. Clair | Illinois | 17163 | 173 | 7 |
49585 | 49585 | 2020-04-11 | St. Clair | Michigan | 26147 | 190 | 4 |
49818 | 49818 | 2020-04-11 | St. Clair | Missouri | 29185 | 2 | 0 |
51146 | 51146 | 2020-04-12 | St. Clair | Alabama | 1115 | 42 | 0 |
51713 | 51713 | 2020-04-12 | St. Clair | Illinois | 17163 | 189 | 8 |
52255 | 52255 | 2020-04-12 | St. Clair | Michigan | 26147 | 199 | 6 |
52491 | 52491 | 2020-04-12 | St. Clair | Missouri | 29185 | 2 | 0 |
53824 | 53824 | 2020-04-13 | St. Clair | Alabama | 1115 | 43 | 0 |
54394 | 54394 | 2020-04-13 | St. Clair | Illinois | 17163 | 202 | 8 |
54937 | 54937 | 2020-04-13 | St. Clair | Michigan | 26147 | 206 | 7 |
55173 | 55173 | 2020-04-13 | St. Clair | Missouri | 29185 | 2 | 0 |
56516 | 56516 | 2020-04-14 | St. Clair | Alabama | 1115 | 45 | 0 |
57087 | 57087 | 2020-04-14 | St. Clair | Illinois | 17163 | 220 | 8 |
57635 | 57635 | 2020-04-14 | St. Clair | Michigan | 26147 | 211 | 7 |
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);