ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 26015 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 |
---|---|---|---|---|---|---|---|
6522 | 6522 | 2020-03-21 | Barry | Michigan | 26015 | 1 | 0 |
7599 | 7599 | 2020-03-22 | Barry | Michigan | 26015 | 1 | 0 |
8771 | 8771 | 2020-03-23 | Barry | Michigan | 26015 | 1 | 0 |
10060 | 10060 | 2020-03-24 | Barry | Michigan | 26015 | 1 | 0 |
11472 | 11472 | 2020-03-25 | Barry | Michigan | 26015 | 1 | 0 |
13053 | 13053 | 2020-03-26 | Barry | Michigan | 26015 | 1 | 0 |
14761 | 14761 | 2020-03-27 | Barry | Michigan | 26015 | 1 | 0 |
16581 | 16581 | 2020-03-28 | Barry | Michigan | 26015 | 1 | 0 |
18496 | 18496 | 2020-03-29 | Barry | Michigan | 26015 | 1 | 0 |
20513 | 20513 | 2020-03-30 | Barry | Michigan | 26015 | 1 | 0 |
22623 | 22623 | 2020-03-31 | Barry | Michigan | 26015 | 2 | 0 |
24802 | 24802 | 2020-04-01 | Barry | Michigan | 26015 | 2 | 0 |
27054 | 27054 | 2020-04-02 | Barry | Michigan | 26015 | 4 | 0 |
29372 | 29372 | 2020-04-03 | Barry | Michigan | 26015 | 5 | 0 |
31750 | 31750 | 2020-04-04 | Barry | Michigan | 26015 | 5 | 0 |
34175 | 34175 | 2020-04-05 | Barry | Michigan | 26015 | 6 | 0 |
36634 | 36634 | 2020-04-06 | Barry | Michigan | 26015 | 7 | 0 |
39142 | 39142 | 2020-04-07 | Barry | Michigan | 26015 | 7 | 0 |
41694 | 41694 | 2020-04-08 | Barry | Michigan | 26015 | 7 | 0 |
44270 | 44270 | 2020-04-09 | Barry | Michigan | 26015 | 7 | 0 |
46878 | 46878 | 2020-04-10 | Barry | Michigan | 26015 | 7 | 0 |
49521 | 49521 | 2020-04-11 | Barry | Michigan | 26015 | 8 | 0 |
52191 | 52191 | 2020-04-12 | Barry | Michigan | 26015 | 8 | 0 |
54872 | 54872 | 2020-04-13 | Barry | Michigan | 26015 | 11 | 1 |
57570 | 57570 | 2020-04-14 | Barry | Michigan | 26015 | 14 | 1 |
60280 | 60280 | 2020-04-15 | Barry | Michigan | 26015 | 18 | 1 |
63002 | 63002 | 2020-04-16 | Barry | Michigan | 26015 | 20 | 1 |
65740 | 65740 | 2020-04-17 | Barry | Michigan | 26015 | 21 | 1 |
68490 | 68490 | 2020-04-18 | Barry | Michigan | 26015 | 21 | 1 |
71254 | 71254 | 2020-04-19 | Barry | Michigan | 26015 | 25 | 1 |
74026 | 74026 | 2020-04-20 | Barry | Michigan | 26015 | 26 | 1 |
76806 | 76806 | 2020-04-21 | Barry | Michigan | 26015 | 26 | 1 |
79592 | 79592 | 2020-04-22 | Barry | Michigan | 26015 | 28 | 1 |
82387 | 82387 | 2020-04-23 | Barry | Michigan | 26015 | 28 | 1 |
85191 | 85191 | 2020-04-24 | Barry | Michigan | 26015 | 29 | 1 |
88001 | 88001 | 2020-04-25 | Barry | Michigan | 26015 | 28 | 1 |
90817 | 90817 | 2020-04-26 | Barry | Michigan | 26015 | 29 | 1 |
93638 | 93638 | 2020-04-27 | Barry | Michigan | 26015 | 31 | 1 |
96473 | 96473 | 2020-04-28 | Barry | Michigan | 26015 | 31 | 1 |
99319 | 99319 | 2020-04-29 | Barry | Michigan | 26015 | 34 | 1 |
102171 | 102171 | 2020-04-30 | Barry | Michigan | 26015 | 35 | 1 |
105031 | 105031 | 2020-05-01 | Barry | Michigan | 26015 | 36 | 1 |
107895 | 107895 | 2020-05-02 | Barry | Michigan | 26015 | 39 | 1 |
110767 | 110767 | 2020-05-03 | Barry | Michigan | 26015 | 37 | 1 |
113645 | 113645 | 2020-05-04 | Barry | Michigan | 26015 | 37 | 1 |
116526 | 116526 | 2020-05-05 | Barry | Michigan | 26015 | 39 | 1 |
119487 | 119487 | 2020-05-06 | Barry | Michigan | 26015 | 39 | 1 |
122459 | 122459 | 2020-05-07 | Barry | Michigan | 26015 | 41 | 1 |
125441 | 125441 | 2020-05-08 | Barry | Michigan | 26015 | 44 | 1 |
128428 | 128428 | 2020-05-09 | Barry | Michigan | 26015 | 49 | 1 |
131418 | 131418 | 2020-05-10 | Barry | Michigan | 26015 | 48 | 1 |
134409 | 134409 | 2020-05-11 | Barry | Michigan | 26015 | 51 | 1 |
137399 | 137399 | 2020-05-12 | Barry | Michigan | 26015 | 52 | 1 |
140393 | 140393 | 2020-05-13 | Barry | Michigan | 26015 | 54 | 1 |
143388 | 143388 | 2020-05-14 | Barry | Michigan | 26015 | 58 | 1 |
146388 | 146388 | 2020-05-15 | Barry | Michigan | 26015 | 56 | 1 |
149393 | 149393 | 2020-05-16 | Barry | Michigan | 26015 | 56 | 1 |
152404 | 152404 | 2020-05-17 | Barry | Michigan | 26015 | 56 | 1 |
155418 | 155418 | 2020-05-18 | Barry | Michigan | 26015 | 57 | 1 |
158436 | 158436 | 2020-05-19 | Barry | Michigan | 26015 | 58 | 1 |
161462 | 161462 | 2020-05-20 | Barry | Michigan | 26015 | 57 | 1 |
164491 | 164491 | 2020-05-21 | Barry | Michigan | 26015 | 57 | 1 |
167527 | 167527 | 2020-05-22 | Barry | Michigan | 26015 | 57 | 2 |
170564 | 170564 | 2020-05-23 | Barry | Michigan | 26015 | 59 | 2 |
173606 | 173606 | 2020-05-24 | Barry | Michigan | 26015 | 60 | 2 |
176649 | 176649 | 2020-05-25 | Barry | Michigan | 26015 | 61 | 2 |
179693 | 179693 | 2020-05-26 | Barry | Michigan | 26015 | 61 | 2 |
182739 | 182739 | 2020-05-27 | Barry | Michigan | 26015 | 62 | 2 |
185794 | 185794 | 2020-05-28 | Barry | Michigan | 26015 | 62 | 2 |
188852 | 188852 | 2020-05-29 | Barry | Michigan | 26015 | 62 | 2 |
191916 | 191916 | 2020-05-30 | Barry | Michigan | 26015 | 62 | 2 |
194984 | 194984 | 2020-05-31 | Barry | Michigan | 26015 | 63 | 2 |
198055 | 198055 | 2020-06-01 | Barry | Michigan | 26015 | 63 | 2 |
201127 | 201127 | 2020-06-02 | Barry | Michigan | 26015 | 64 | 2 |
204204 | 204204 | 2020-06-03 | Barry | Michigan | 26015 | 64 | 2 |
207285 | 207285 | 2020-06-04 | Barry | Michigan | 26015 | 65 | 2 |
210366 | 210366 | 2020-06-05 | Barry | Michigan | 26015 | 84 | 2 |
213450 | 213450 | 2020-06-06 | Barry | Michigan | 26015 | 86 | 2 |
216538 | 216538 | 2020-06-07 | Barry | Michigan | 26015 | 87 | 2 |
219630 | 219630 | 2020-06-08 | Barry | Michigan | 26015 | 87 | 2 |
222725 | 222725 | 2020-06-09 | Barry | Michigan | 26015 | 87 | 2 |
225822 | 225822 | 2020-06-10 | Barry | Michigan | 26015 | 89 | 2 |
228924 | 228924 | 2020-06-11 | Barry | Michigan | 26015 | 90 | 2 |
232028 | 232028 | 2020-06-12 | Barry | Michigan | 26015 | 91 | 2 |
235133 | 235133 | 2020-06-13 | Barry | Michigan | 26015 | 91 | 2 |
238240 | 238240 | 2020-06-14 | Barry | Michigan | 26015 | 91 | 2 |
241349 | 241349 | 2020-06-15 | Barry | Michigan | 26015 | 91 | 2 |
244460 | 244460 | 2020-06-16 | Barry | Michigan | 26015 | 91 | 2 |
247573 | 247573 | 2020-06-17 | Barry | Michigan | 26015 | 92 | 2 |
250685 | 250685 | 2020-06-18 | Barry | Michigan | 26015 | 93 | 2 |
253800 | 253800 | 2020-06-19 | Barry | Michigan | 26015 | 94 | 2 |
256920 | 256920 | 2020-06-20 | Barry | Michigan | 26015 | 93 | 2 |
260046 | 260046 | 2020-06-21 | Barry | Michigan | 26015 | 94 | 2 |
263175 | 263175 | 2020-06-22 | Barry | Michigan | 26015 | 95 | 2 |
266301 | 266301 | 2020-06-23 | Barry | Michigan | 26015 | 95 | 2 |
269434 | 269434 | 2020-06-24 | Barry | Michigan | 26015 | 96 | 2 |
272571 | 272571 | 2020-06-25 | Barry | Michigan | 26015 | 95 | 2 |
275714 | 275714 | 2020-06-26 | Barry | Michigan | 26015 | 95 | 2 |
278862 | 278862 | 2020-06-27 | Barry | Michigan | 26015 | 96 | 2 |
282010 | 282010 | 2020-06-28 | Barry | Michigan | 26015 | 97 | 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);