ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 26075 and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3457 | 3457 | 2020-03-17 | Jackson | Michigan | 26075 | 1 | 0 |
4040 | 4040 | 2020-03-18 | Jackson | Michigan | 26075 | 1 | 0 |
4748 | 4748 | 2020-03-19 | Jackson | Michigan | 26075 | 1 | 0 |
5567 | 5567 | 2020-03-20 | Jackson | Michigan | 26075 | 1 | 0 |
6532 | 6532 | 2020-03-21 | Jackson | Michigan | 26075 | 1 | 0 |
7612 | 7612 | 2020-03-22 | Jackson | Michigan | 26075 | 1 | 0 |
8785 | 8785 | 2020-03-23 | Jackson | Michigan | 26075 | 1 | 0 |
10076 | 10076 | 2020-03-24 | Jackson | Michigan | 26075 | 6 | 0 |
11489 | 11489 | 2020-03-25 | Jackson | Michigan | 26075 | 12 | 0 |
13072 | 13072 | 2020-03-26 | Jackson | Michigan | 26075 | 17 | 0 |
14784 | 14784 | 2020-03-27 | Jackson | Michigan | 26075 | 17 | 0 |
16604 | 16604 | 2020-03-28 | Jackson | Michigan | 26075 | 20 | 0 |
18520 | 18520 | 2020-03-29 | Jackson | Michigan | 26075 | 28 | 1 |
20539 | 20539 | 2020-03-30 | Jackson | Michigan | 26075 | 37 | 1 |
22650 | 22650 | 2020-03-31 | Jackson | Michigan | 26075 | 47 | 1 |
24829 | 24829 | 2020-04-01 | Jackson | Michigan | 26075 | 56 | 2 |
27082 | 27082 | 2020-04-02 | Jackson | Michigan | 26075 | 67 | 2 |
29400 | 29400 | 2020-04-03 | Jackson | Michigan | 26075 | 69 | 3 |
31778 | 31778 | 2020-04-04 | Jackson | Michigan | 26075 | 81 | 3 |
34203 | 34203 | 2020-04-05 | Jackson | Michigan | 26075 | 90 | 3 |
36662 | 36662 | 2020-04-06 | Jackson | Michigan | 26075 | 103 | 4 |
39170 | 39170 | 2020-04-07 | Jackson | Michigan | 26075 | 114 | 4 |
41722 | 41722 | 2020-04-08 | Jackson | Michigan | 26075 | 126 | 4 |
44298 | 44298 | 2020-04-09 | Jackson | Michigan | 26075 | 131 | 4 |
46906 | 46906 | 2020-04-10 | Jackson | Michigan | 26075 | 140 | 4 |
49549 | 49549 | 2020-04-11 | Jackson | Michigan | 26075 | 152 | 4 |
52219 | 52219 | 2020-04-12 | Jackson | Michigan | 26075 | 171 | 4 |
54900 | 54900 | 2020-04-13 | Jackson | Michigan | 26075 | 172 | 6 |
57598 | 57598 | 2020-04-14 | Jackson | Michigan | 26075 | 183 | 7 |
60308 | 60308 | 2020-04-15 | Jackson | Michigan | 26075 | 409 | 14 |
63030 | 63030 | 2020-04-16 | Jackson | Michigan | 26075 | 430 | 14 |
65768 | 65768 | 2020-04-17 | Jackson | Michigan | 26075 | 448 | 15 |
68519 | 68519 | 2020-04-18 | Jackson | Michigan | 26075 | 453 | 15 |
71283 | 71283 | 2020-04-19 | Jackson | Michigan | 26075 | 502 | 18 |
74055 | 74055 | 2020-04-20 | Jackson | Michigan | 26075 | 529 | 18 |
76835 | 76835 | 2020-04-21 | Jackson | Michigan | 26075 | 550 | 20 |
79621 | 79621 | 2020-04-22 | Jackson | Michigan | 26075 | 588 | 20 |
82416 | 82416 | 2020-04-23 | Jackson | Michigan | 26075 | 597 | 22 |
85220 | 85220 | 2020-04-24 | Jackson | Michigan | 26075 | 626 | 24 |
88030 | 88030 | 2020-04-25 | Jackson | Michigan | 26075 | 646 | 26 |
90846 | 90846 | 2020-04-26 | Jackson | Michigan | 26075 | 650 | 26 |
93667 | 93667 | 2020-04-27 | Jackson | Michigan | 26075 | 676 | 28 |
96502 | 96502 | 2020-04-28 | Jackson | Michigan | 26075 | 678 | 32 |
99348 | 99348 | 2020-04-29 | Jackson | Michigan | 26075 | 717 | 33 |
102200 | 102200 | 2020-04-30 | Jackson | Michigan | 26075 | 735 | 37 |
105060 | 105060 | 2020-05-01 | Jackson | Michigan | 26075 | 944 | 37 |
107924 | 107924 | 2020-05-02 | Jackson | Michigan | 26075 | 1001 | 39 |
110796 | 110796 | 2020-05-03 | Jackson | Michigan | 26075 | 1272 | 39 |
113674 | 113674 | 2020-05-04 | Jackson | Michigan | 26075 | 1278 | 42 |
116555 | 116555 | 2020-05-05 | Jackson | Michigan | 26075 | 1301 | 42 |
119516 | 119516 | 2020-05-06 | Jackson | Michigan | 26075 | 1311 | 43 |
122488 | 122488 | 2020-05-07 | Jackson | Michigan | 26075 | 1320 | 43 |
125470 | 125470 | 2020-05-08 | Jackson | Michigan | 26075 | 1328 | 42 |
128457 | 128457 | 2020-05-09 | Jackson | Michigan | 26075 | 1346 | 43 |
131447 | 131447 | 2020-05-10 | Jackson | Michigan | 26075 | 1364 | 43 |
134438 | 134438 | 2020-05-11 | Jackson | Michigan | 26075 | 1381 | 43 |
137428 | 137428 | 2020-05-12 | Jackson | Michigan | 26075 | 1382 | 43 |
140422 | 140422 | 2020-05-13 | Jackson | Michigan | 26075 | 1389 | 44 |
143417 | 143417 | 2020-05-14 | Jackson | Michigan | 26075 | 1411 | 44 |
146417 | 146417 | 2020-05-15 | Jackson | Michigan | 26075 | 1416 | 44 |
149422 | 149422 | 2020-05-16 | Jackson | Michigan | 26075 | 1444 | 44 |
152433 | 152433 | 2020-05-17 | Jackson | Michigan | 26075 | 1447 | 44 |
155447 | 155447 | 2020-05-18 | Jackson | Michigan | 26075 | 1455 | 44 |
158465 | 158465 | 2020-05-19 | Jackson | Michigan | 26075 | 1459 | 45 |
161491 | 161491 | 2020-05-20 | Jackson | Michigan | 26075 | 1462 | 45 |
164520 | 164520 | 2020-05-21 | Jackson | Michigan | 26075 | 1466 | 45 |
167556 | 167556 | 2020-05-22 | Jackson | Michigan | 26075 | 1471 | 45 |
170593 | 170593 | 2020-05-23 | Jackson | Michigan | 26075 | 1473 | 45 |
173635 | 173635 | 2020-05-24 | Jackson | Michigan | 26075 | 1492 | 45 |
176678 | 176678 | 2020-05-25 | Jackson | Michigan | 26075 | 1494 | 45 |
179722 | 179722 | 2020-05-26 | Jackson | Michigan | 26075 | 1494 | 45 |
182768 | 182768 | 2020-05-27 | Jackson | Michigan | 26075 | 1495 | 45 |
185823 | 185823 | 2020-05-28 | Jackson | Michigan | 26075 | 1502 | 46 |
188881 | 188881 | 2020-05-29 | Jackson | Michigan | 26075 | 1567 | 47 |
191945 | 191945 | 2020-05-30 | Jackson | Michigan | 26075 | 1504 | 47 |
195013 | 195013 | 2020-05-31 | Jackson | Michigan | 26075 | 1806 | 49 |
198084 | 198084 | 2020-06-01 | Jackson | Michigan | 26075 | 1980 | 49 |
201157 | 201157 | 2020-06-02 | Jackson | Michigan | 26075 | 1988 | 49 |
204234 | 204234 | 2020-06-03 | Jackson | Michigan | 26075 | 1990 | 50 |
207315 | 207315 | 2020-06-04 | Jackson | Michigan | 26075 | 1997 | 50 |
210396 | 210396 | 2020-06-05 | Jackson | Michigan | 26075 | 2031 | 51 |
213480 | 213480 | 2020-06-06 | Jackson | Michigan | 26075 | 2031 | 51 |
216568 | 216568 | 2020-06-07 | Jackson | Michigan | 26075 | 2033 | 52 |
219660 | 219660 | 2020-06-08 | Jackson | Michigan | 26075 | 2041 | 52 |
222755 | 222755 | 2020-06-09 | Jackson | Michigan | 26075 | 2041 | 52 |
225852 | 225852 | 2020-06-10 | Jackson | Michigan | 26075 | 2051 | 52 |
228954 | 228954 | 2020-06-11 | Jackson | Michigan | 26075 | 2055 | 52 |
232058 | 232058 | 2020-06-12 | Jackson | Michigan | 26075 | 2051 | 52 |
235163 | 235163 | 2020-06-13 | Jackson | Michigan | 26075 | 2053 | 52 |
238270 | 238270 | 2020-06-14 | Jackson | Michigan | 26075 | 2054 | 52 |
241379 | 241379 | 2020-06-15 | Jackson | Michigan | 26075 | 2054 | 52 |
244490 | 244490 | 2020-06-16 | Jackson | Michigan | 26075 | 2054 | 52 |
247603 | 247603 | 2020-06-17 | Jackson | Michigan | 26075 | 2054 | 52 |
250715 | 250715 | 2020-06-18 | Jackson | Michigan | 26075 | 2055 | 52 |
253830 | 253830 | 2020-06-19 | Jackson | Michigan | 26075 | 2055 | 52 |
256950 | 256950 | 2020-06-20 | Jackson | Michigan | 26075 | 2056 | 52 |
260076 | 260076 | 2020-06-21 | Jackson | Michigan | 26075 | 2056 | 52 |
263205 | 263205 | 2020-06-22 | Jackson | Michigan | 26075 | 2055 | 52 |
266331 | 266331 | 2020-06-23 | Jackson | Michigan | 26075 | 2056 | 52 |
269464 | 269464 | 2020-06-24 | Jackson | Michigan | 26075 | 2056 | 52 |
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);