ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Antrim" and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20512 | 20512 | 2020-03-30 | Antrim | Michigan | 26009 | 2 | 0 |
22621 | 22621 | 2020-03-31 | Antrim | Michigan | 26009 | 3 | 0 |
24800 | 24800 | 2020-04-01 | Antrim | Michigan | 26009 | 4 | 0 |
27052 | 27052 | 2020-04-02 | Antrim | Michigan | 26009 | 4 | 0 |
29370 | 29370 | 2020-04-03 | Antrim | Michigan | 26009 | 4 | 0 |
31748 | 31748 | 2020-04-04 | Antrim | Michigan | 26009 | 4 | 0 |
34173 | 34173 | 2020-04-05 | Antrim | Michigan | 26009 | 4 | 0 |
36632 | 36632 | 2020-04-06 | Antrim | Michigan | 26009 | 5 | 0 |
39140 | 39140 | 2020-04-07 | Antrim | Michigan | 26009 | 6 | 0 |
41692 | 41692 | 2020-04-08 | Antrim | Michigan | 26009 | 6 | 0 |
44268 | 44268 | 2020-04-09 | Antrim | Michigan | 26009 | 6 | 0 |
46876 | 46876 | 2020-04-10 | Antrim | Michigan | 26009 | 6 | 0 |
49519 | 49519 | 2020-04-11 | Antrim | Michigan | 26009 | 7 | 0 |
52189 | 52189 | 2020-04-12 | Antrim | Michigan | 26009 | 8 | 0 |
54870 | 54870 | 2020-04-13 | Antrim | Michigan | 26009 | 8 | 0 |
57568 | 57568 | 2020-04-14 | Antrim | Michigan | 26009 | 8 | 0 |
60278 | 60278 | 2020-04-15 | Antrim | Michigan | 26009 | 9 | 0 |
62999 | 62999 | 2020-04-16 | Antrim | Michigan | 26009 | 9 | 0 |
65737 | 65737 | 2020-04-17 | Antrim | Michigan | 26009 | 8 | 0 |
68487 | 68487 | 2020-04-18 | Antrim | Michigan | 26009 | 8 | 0 |
71251 | 71251 | 2020-04-19 | Antrim | Michigan | 26009 | 9 | 0 |
74023 | 74023 | 2020-04-20 | Antrim | Michigan | 26009 | 9 | 0 |
76803 | 76803 | 2020-04-21 | Antrim | Michigan | 26009 | 9 | 0 |
79589 | 79589 | 2020-04-22 | Antrim | Michigan | 26009 | 9 | 0 |
82384 | 82384 | 2020-04-23 | Antrim | Michigan | 26009 | 9 | 0 |
85188 | 85188 | 2020-04-24 | Antrim | Michigan | 26009 | 9 | 0 |
87998 | 87998 | 2020-04-25 | Antrim | Michigan | 26009 | 10 | 1 |
90814 | 90814 | 2020-04-26 | Antrim | Michigan | 26009 | 9 | 0 |
93635 | 93635 | 2020-04-27 | Antrim | Michigan | 26009 | 9 | 0 |
96470 | 96470 | 2020-04-28 | Antrim | Michigan | 26009 | 9 | 0 |
99316 | 99316 | 2020-04-29 | Antrim | Michigan | 26009 | 10 | 0 |
102168 | 102168 | 2020-04-30 | Antrim | Michigan | 26009 | 10 | 0 |
105028 | 105028 | 2020-05-01 | Antrim | Michigan | 26009 | 10 | 0 |
107892 | 107892 | 2020-05-02 | Antrim | Michigan | 26009 | 10 | 0 |
110764 | 110764 | 2020-05-03 | Antrim | Michigan | 26009 | 10 | 0 |
113642 | 113642 | 2020-05-04 | Antrim | Michigan | 26009 | 10 | 0 |
116523 | 116523 | 2020-05-05 | Antrim | Michigan | 26009 | 10 | 0 |
119484 | 119484 | 2020-05-06 | Antrim | Michigan | 26009 | 10 | 0 |
122456 | 122456 | 2020-05-07 | Antrim | Michigan | 26009 | 10 | 0 |
125438 | 125438 | 2020-05-08 | Antrim | Michigan | 26009 | 10 | 0 |
128425 | 128425 | 2020-05-09 | Antrim | Michigan | 26009 | 10 | 0 |
131415 | 131415 | 2020-05-10 | Antrim | Michigan | 26009 | 10 | 0 |
134406 | 134406 | 2020-05-11 | Antrim | Michigan | 26009 | 10 | 0 |
137396 | 137396 | 2020-05-12 | Antrim | Michigan | 26009 | 10 | 0 |
140390 | 140390 | 2020-05-13 | Antrim | Michigan | 26009 | 10 | 0 |
143385 | 143385 | 2020-05-14 | Antrim | Michigan | 26009 | 10 | 0 |
146385 | 146385 | 2020-05-15 | Antrim | Michigan | 26009 | 10 | 0 |
149390 | 149390 | 2020-05-16 | Antrim | Michigan | 26009 | 11 | 0 |
152401 | 152401 | 2020-05-17 | Antrim | Michigan | 26009 | 11 | 0 |
155415 | 155415 | 2020-05-18 | Antrim | Michigan | 26009 | 11 | 0 |
158433 | 158433 | 2020-05-19 | Antrim | Michigan | 26009 | 11 | 0 |
161459 | 161459 | 2020-05-20 | Antrim | Michigan | 26009 | 11 | 0 |
164488 | 164488 | 2020-05-21 | Antrim | Michigan | 26009 | 11 | 0 |
167524 | 167524 | 2020-05-22 | Antrim | Michigan | 26009 | 11 | 0 |
170561 | 170561 | 2020-05-23 | Antrim | Michigan | 26009 | 11 | 0 |
173603 | 173603 | 2020-05-24 | Antrim | Michigan | 26009 | 11 | 0 |
176646 | 176646 | 2020-05-25 | Antrim | Michigan | 26009 | 11 | 0 |
179690 | 179690 | 2020-05-26 | Antrim | Michigan | 26009 | 12 | 0 |
182736 | 182736 | 2020-05-27 | Antrim | Michigan | 26009 | 12 | 0 |
185791 | 185791 | 2020-05-28 | Antrim | Michigan | 26009 | 12 | 0 |
188849 | 188849 | 2020-05-29 | Antrim | Michigan | 26009 | 12 | 0 |
191913 | 191913 | 2020-05-30 | Antrim | Michigan | 26009 | 12 | 0 |
194981 | 194981 | 2020-05-31 | Antrim | Michigan | 26009 | 12 | 0 |
198052 | 198052 | 2020-06-01 | Antrim | Michigan | 26009 | 13 | 0 |
201124 | 201124 | 2020-06-02 | Antrim | Michigan | 26009 | 13 | 0 |
204201 | 204201 | 2020-06-03 | Antrim | Michigan | 26009 | 13 | 0 |
207282 | 207282 | 2020-06-04 | Antrim | Michigan | 26009 | 13 | 0 |
210363 | 210363 | 2020-06-05 | Antrim | Michigan | 26009 | 13 | 0 |
213447 | 213447 | 2020-06-06 | Antrim | Michigan | 26009 | 13 | 0 |
216535 | 216535 | 2020-06-07 | Antrim | Michigan | 26009 | 13 | 0 |
219627 | 219627 | 2020-06-08 | Antrim | Michigan | 26009 | 13 | 0 |
222722 | 222722 | 2020-06-09 | Antrim | Michigan | 26009 | 13 | 0 |
225819 | 225819 | 2020-06-10 | Antrim | Michigan | 26009 | 14 | 0 |
228921 | 228921 | 2020-06-11 | Antrim | Michigan | 26009 | 14 | 0 |
232025 | 232025 | 2020-06-12 | Antrim | Michigan | 26009 | 14 | 0 |
235130 | 235130 | 2020-06-13 | Antrim | Michigan | 26009 | 14 | 0 |
238237 | 238237 | 2020-06-14 | Antrim | Michigan | 26009 | 14 | 0 |
241346 | 241346 | 2020-06-15 | Antrim | Michigan | 26009 | 14 | 0 |
244457 | 244457 | 2020-06-16 | Antrim | Michigan | 26009 | 14 | 0 |
247570 | 247570 | 2020-06-17 | Antrim | Michigan | 26009 | 14 | 0 |
250682 | 250682 | 2020-06-18 | Antrim | Michigan | 26009 | 14 | 0 |
253797 | 253797 | 2020-06-19 | Antrim | Michigan | 26009 | 14 | 0 |
256917 | 256917 | 2020-06-20 | Antrim | Michigan | 26009 | 16 | 0 |
260043 | 260043 | 2020-06-21 | Antrim | Michigan | 26009 | 16 | 0 |
263172 | 263172 | 2020-06-22 | Antrim | Michigan | 26009 | 16 | 0 |
266298 | 266298 | 2020-06-23 | Antrim | Michigan | 26009 | 16 | 0 |
269431 | 269431 | 2020-06-24 | Antrim | Michigan | 26009 | 16 | 0 |
272568 | 272568 | 2020-06-25 | Antrim | Michigan | 26009 | 18 | 0 |
275711 | 275711 | 2020-06-26 | Antrim | Michigan | 26009 | 18 | 0 |
278859 | 278859 | 2020-06-27 | Antrim | Michigan | 26009 | 18 | 0 |
282007 | 282007 | 2020-06-28 | Antrim | Michigan | 26009 | 18 | 0 |
285152 | 285152 | 2020-06-29 | Antrim | Michigan | 26009 | 18 | 0 |
288302 | 288302 | 2020-06-30 | Antrim | Michigan | 26009 | 18 | 0 |
291453 | 291453 | 2020-07-01 | Antrim | Michigan | 26009 | 19 | 0 |
294607 | 294607 | 2020-07-02 | Antrim | Michigan | 26009 | 20 | 0 |
297765 | 297765 | 2020-07-03 | Antrim | Michigan | 26009 | 21 | 0 |
300927 | 300927 | 2020-07-04 | Antrim | Michigan | 26009 | 22 | 0 |
304091 | 304091 | 2020-07-05 | Antrim | Michigan | 26009 | 23 | 0 |
307258 | 307258 | 2020-07-06 | Antrim | Michigan | 26009 | 23 | 0 |
310426 | 310426 | 2020-07-07 | Antrim | Michigan | 26009 | 23 | 0 |
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);