ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Montcalm" and state = "Michigan" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1480 | 1480 | 2020-03-12 | Montcalm | Michigan | 26117 | 1 | 0 |
1763 | 1763 | 2020-03-13 | Montcalm | Michigan | 26117 | 1 | 0 |
2107 | 2107 | 2020-03-14 | Montcalm | Michigan | 26117 | 1 | 0 |
2510 | 2510 | 2020-03-15 | Montcalm | Michigan | 26117 | 1 | 0 |
2960 | 2960 | 2020-03-16 | Montcalm | Michigan | 26117 | 1 | 0 |
3462 | 3462 | 2020-03-17 | Montcalm | Michigan | 26117 | 1 | 0 |
4045 | 4045 | 2020-03-18 | Montcalm | Michigan | 26117 | 1 | 0 |
4755 | 4755 | 2020-03-19 | Montcalm | Michigan | 26117 | 1 | 0 |
5574 | 5574 | 2020-03-20 | Montcalm | Michigan | 26117 | 1 | 0 |
6539 | 6539 | 2020-03-21 | Montcalm | Michigan | 26117 | 1 | 0 |
7619 | 7619 | 2020-03-22 | Montcalm | Michigan | 26117 | 1 | 0 |
8793 | 8793 | 2020-03-23 | Montcalm | Michigan | 26117 | 1 | 0 |
10087 | 10087 | 2020-03-24 | Montcalm | Michigan | 26117 | 1 | 0 |
11502 | 11502 | 2020-03-25 | Montcalm | Michigan | 26117 | 2 | 0 |
13087 | 13087 | 2020-03-26 | Montcalm | Michigan | 26117 | 3 | 0 |
14799 | 14799 | 2020-03-27 | Montcalm | Michigan | 26117 | 3 | 0 |
16619 | 16619 | 2020-03-28 | Montcalm | Michigan | 26117 | 3 | 0 |
18535 | 18535 | 2020-03-29 | Montcalm | Michigan | 26117 | 3 | 0 |
20554 | 20554 | 2020-03-30 | Montcalm | Michigan | 26117 | 4 | 0 |
22665 | 22665 | 2020-03-31 | Montcalm | Michigan | 26117 | 5 | 0 |
24845 | 24845 | 2020-04-01 | Montcalm | Michigan | 26117 | 10 | 0 |
27098 | 27098 | 2020-04-02 | Montcalm | Michigan | 26117 | 10 | 0 |
29417 | 29417 | 2020-04-03 | Montcalm | Michigan | 26117 | 12 | 0 |
31795 | 31795 | 2020-04-04 | Montcalm | Michigan | 26117 | 13 | 0 |
34220 | 34220 | 2020-04-05 | Montcalm | Michigan | 26117 | 14 | 0 |
36679 | 36679 | 2020-04-06 | Montcalm | Michigan | 26117 | 15 | 0 |
39188 | 39188 | 2020-04-07 | Montcalm | Michigan | 26117 | 16 | 1 |
41740 | 41740 | 2020-04-08 | Montcalm | Michigan | 26117 | 18 | 1 |
44316 | 44316 | 2020-04-09 | Montcalm | Michigan | 26117 | 19 | 1 |
46925 | 46925 | 2020-04-10 | Montcalm | Michigan | 26117 | 20 | 1 |
49569 | 49569 | 2020-04-11 | Montcalm | Michigan | 26117 | 21 | 1 |
52239 | 52239 | 2020-04-12 | Montcalm | Michigan | 26117 | 22 | 1 |
54920 | 54920 | 2020-04-13 | Montcalm | Michigan | 26117 | 22 | 1 |
57618 | 57618 | 2020-04-14 | Montcalm | Michigan | 26117 | 23 | 1 |
60328 | 60328 | 2020-04-15 | Montcalm | Michigan | 26117 | 23 | 1 |
63050 | 63050 | 2020-04-16 | Montcalm | Michigan | 26117 | 23 | 1 |
65788 | 65788 | 2020-04-17 | Montcalm | Michigan | 26117 | 24 | 1 |
68539 | 68539 | 2020-04-18 | Montcalm | Michigan | 26117 | 24 | 1 |
71303 | 71303 | 2020-04-19 | Montcalm | Michigan | 26117 | 24 | 1 |
74075 | 74075 | 2020-04-20 | Montcalm | Michigan | 26117 | 26 | 1 |
76855 | 76855 | 2020-04-21 | Montcalm | Michigan | 26117 | 26 | 1 |
79641 | 79641 | 2020-04-22 | Montcalm | Michigan | 26117 | 26 | 1 |
82436 | 82436 | 2020-04-23 | Montcalm | Michigan | 26117 | 28 | 1 |
85240 | 85240 | 2020-04-24 | Montcalm | Michigan | 26117 | 28 | 1 |
88050 | 88050 | 2020-04-25 | Montcalm | Michigan | 26117 | 29 | 1 |
90866 | 90866 | 2020-04-26 | Montcalm | Michigan | 26117 | 32 | 1 |
93687 | 93687 | 2020-04-27 | Montcalm | Michigan | 26117 | 32 | 1 |
96522 | 96522 | 2020-04-28 | Montcalm | Michigan | 26117 | 37 | 1 |
99368 | 99368 | 2020-04-29 | Montcalm | Michigan | 26117 | 38 | 1 |
102220 | 102220 | 2020-04-30 | Montcalm | Michigan | 26117 | 40 | 1 |
105080 | 105080 | 2020-05-01 | Montcalm | Michigan | 26117 | 40 | 1 |
107944 | 107944 | 2020-05-02 | Montcalm | Michigan | 26117 | 45 | 1 |
110816 | 110816 | 2020-05-03 | Montcalm | Michigan | 26117 | 44 | 1 |
113694 | 113694 | 2020-05-04 | Montcalm | Michigan | 26117 | 45 | 1 |
116575 | 116575 | 2020-05-05 | Montcalm | Michigan | 26117 | 46 | 1 |
119536 | 119536 | 2020-05-06 | Montcalm | Michigan | 26117 | 46 | 1 |
122508 | 122508 | 2020-05-07 | Montcalm | Michigan | 26117 | 46 | 1 |
125490 | 125490 | 2020-05-08 | Montcalm | Michigan | 26117 | 46 | 1 |
128477 | 128477 | 2020-05-09 | Montcalm | Michigan | 26117 | 46 | 1 |
131467 | 131467 | 2020-05-10 | Montcalm | Michigan | 26117 | 46 | 1 |
134458 | 134458 | 2020-05-11 | Montcalm | Michigan | 26117 | 46 | 1 |
137448 | 137448 | 2020-05-12 | Montcalm | Michigan | 26117 | 47 | 1 |
140442 | 140442 | 2020-05-13 | Montcalm | Michigan | 26117 | 52 | 1 |
143437 | 143437 | 2020-05-14 | Montcalm | Michigan | 26117 | 52 | 1 |
146437 | 146437 | 2020-05-15 | Montcalm | Michigan | 26117 | 52 | 1 |
149442 | 149442 | 2020-05-16 | Montcalm | Michigan | 26117 | 53 | 1 |
152453 | 152453 | 2020-05-17 | Montcalm | Michigan | 26117 | 53 | 1 |
155467 | 155467 | 2020-05-18 | Montcalm | Michigan | 26117 | 57 | 1 |
158485 | 158485 | 2020-05-19 | Montcalm | Michigan | 26117 | 58 | 1 |
161511 | 161511 | 2020-05-20 | Montcalm | Michigan | 26117 | 62 | 1 |
164540 | 164540 | 2020-05-21 | Montcalm | Michigan | 26117 | 64 | 1 |
167576 | 167576 | 2020-05-22 | Montcalm | Michigan | 26117 | 65 | 1 |
170613 | 170613 | 2020-05-23 | Montcalm | Michigan | 26117 | 68 | 1 |
173655 | 173655 | 2020-05-24 | Montcalm | Michigan | 26117 | 67 | 1 |
176698 | 176698 | 2020-05-25 | Montcalm | Michigan | 26117 | 67 | 1 |
179742 | 179742 | 2020-05-26 | Montcalm | Michigan | 26117 | 67 | 1 |
182788 | 182788 | 2020-05-27 | Montcalm | Michigan | 26117 | 67 | 1 |
185843 | 185843 | 2020-05-28 | Montcalm | Michigan | 26117 | 67 | 1 |
188901 | 188901 | 2020-05-29 | Montcalm | Michigan | 26117 | 67 | 1 |
191965 | 191965 | 2020-05-30 | Montcalm | Michigan | 26117 | 67 | 1 |
195033 | 195033 | 2020-05-31 | Montcalm | Michigan | 26117 | 68 | 1 |
198104 | 198104 | 2020-06-01 | Montcalm | Michigan | 26117 | 68 | 1 |
201177 | 201177 | 2020-06-02 | Montcalm | Michigan | 26117 | 68 | 1 |
204254 | 204254 | 2020-06-03 | Montcalm | Michigan | 26117 | 69 | 1 |
207335 | 207335 | 2020-06-04 | Montcalm | Michigan | 26117 | 71 | 1 |
210416 | 210416 | 2020-06-05 | Montcalm | Michigan | 26117 | 76 | 1 |
213500 | 213500 | 2020-06-06 | Montcalm | Michigan | 26117 | 78 | 1 |
216588 | 216588 | 2020-06-07 | Montcalm | Michigan | 26117 | 79 | 1 |
219680 | 219680 | 2020-06-08 | Montcalm | Michigan | 26117 | 80 | 1 |
222775 | 222775 | 2020-06-09 | Montcalm | Michigan | 26117 | 81 | 1 |
225873 | 225873 | 2020-06-10 | Montcalm | Michigan | 26117 | 83 | 1 |
228975 | 228975 | 2020-06-11 | Montcalm | Michigan | 26117 | 83 | 1 |
232079 | 232079 | 2020-06-12 | Montcalm | Michigan | 26117 | 82 | 1 |
235184 | 235184 | 2020-06-13 | Montcalm | Michigan | 26117 | 82 | 1 |
238291 | 238291 | 2020-06-14 | Montcalm | Michigan | 26117 | 82 | 1 |
241400 | 241400 | 2020-06-15 | Montcalm | Michigan | 26117 | 82 | 1 |
244511 | 244511 | 2020-06-16 | Montcalm | Michigan | 26117 | 83 | 1 |
247624 | 247624 | 2020-06-17 | Montcalm | Michigan | 26117 | 83 | 1 |
250736 | 250736 | 2020-06-18 | Montcalm | Michigan | 26117 | 83 | 1 |
253851 | 253851 | 2020-06-19 | Montcalm | Michigan | 26117 | 83 | 1 |
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);