ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Macomb" and state = "Michigan" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- …
state 1
- Michigan · 792 ✖
fips 1
- 26099 792
county 1
- Macomb · 792 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1762 | 1762 | 2020-03-13 | Macomb | Michigan | 26099 | 1 | 0 |
2105 | 2105 | 2020-03-14 | Macomb | Michigan | 26099 | 2 | 0 |
2508 | 2508 | 2020-03-15 | Macomb | Michigan | 26099 | 5 | 0 |
2958 | 2958 | 2020-03-16 | Macomb | Michigan | 26099 | 6 | 0 |
3460 | 3460 | 2020-03-17 | Macomb | Michigan | 26099 | 8 | 0 |
4043 | 4043 | 2020-03-18 | Macomb | Michigan | 26099 | 10 | 0 |
4752 | 4752 | 2020-03-19 | Macomb | Michigan | 26099 | 55 | 0 |
5571 | 5571 | 2020-03-20 | Macomb | Michigan | 26099 | 86 | 0 |
6536 | 6536 | 2020-03-21 | Macomb | Michigan | 26099 | 101 | 0 |
7616 | 7616 | 2020-03-22 | Macomb | Michigan | 26099 | 140 | 1 |
8790 | 8790 | 2020-03-23 | Macomb | Michigan | 26099 | 175 | 2 |
10083 | 10083 | 2020-03-24 | Macomb | Michigan | 26099 | 225 | 3 |
11497 | 11497 | 2020-03-25 | Macomb | Michigan | 26099 | 281 | 7 |
13080 | 13080 | 2020-03-26 | Macomb | Michigan | 26099 | 347 | 11 |
14792 | 14792 | 2020-03-27 | Macomb | Michigan | 26099 | 404 | 14 |
16612 | 16612 | 2020-03-28 | Macomb | Michigan | 26099 | 534 | 17 |
18528 | 18528 | 2020-03-29 | Macomb | Michigan | 26099 | 620 | 20 |
20547 | 20547 | 2020-03-30 | Macomb | Michigan | 26099 | 728 | 27 |
22658 | 22658 | 2020-03-31 | Macomb | Michigan | 26099 | 853 | 38 |
24838 | 24838 | 2020-04-01 | Macomb | Michigan | 26099 | 1088 | 51 |
27091 | 27091 | 2020-04-02 | Macomb | Michigan | 26099 | 1332 | 58 |
29410 | 29410 | 2020-04-03 | Macomb | Michigan | 26099 | 1560 | 65 |
31788 | 31788 | 2020-04-04 | Macomb | Michigan | 26099 | 1838 | 78 |
34213 | 34213 | 2020-04-05 | Macomb | Michigan | 26099 | 2003 | 83 |
36672 | 36672 | 2020-04-06 | Macomb | Michigan | 26099 | 2159 | 100 |
39180 | 39180 | 2020-04-07 | Macomb | Michigan | 26099 | 2414 | 121 |
41732 | 41732 | 2020-04-08 | Macomb | Michigan | 26099 | 2626 | 141 |
44308 | 44308 | 2020-04-09 | Macomb | Michigan | 26099 | 2783 | 165 |
46916 | 46916 | 2020-04-10 | Macomb | Michigan | 26099 | 2973 | 197 |
49560 | 49560 | 2020-04-11 | Macomb | Michigan | 26099 | 3164 | 209 |
52230 | 52230 | 2020-04-12 | Macomb | Michigan | 26099 | 3254 | 217 |
54911 | 54911 | 2020-04-13 | Macomb | Michigan | 26099 | 3418 | 240 |
57609 | 57609 | 2020-04-14 | Macomb | Michigan | 26099 | 3620 | 293 |
60319 | 60319 | 2020-04-15 | Macomb | Michigan | 26099 | 3866 | 330 |
63041 | 63041 | 2020-04-16 | Macomb | Michigan | 26099 | 4069 | 354 |
65779 | 65779 | 2020-04-17 | Macomb | Michigan | 26099 | 4222 | 373 |
68530 | 68530 | 2020-04-18 | Macomb | Michigan | 26099 | 4328 | 384 |
71294 | 71294 | 2020-04-19 | Macomb | Michigan | 26099 | 4439 | 392 |
74066 | 74066 | 2020-04-20 | Macomb | Michigan | 26099 | 4505 | 404 |
76846 | 76846 | 2020-04-21 | Macomb | Michigan | 26099 | 4625 | 446 |
79632 | 79632 | 2020-04-22 | Macomb | Michigan | 26099 | 4712 | 477 |
82427 | 82427 | 2020-04-23 | Macomb | Michigan | 26099 | 4946 | 497 |
85231 | 85231 | 2020-04-24 | Macomb | Michigan | 26099 | 5106 | 508 |
88041 | 88041 | 2020-04-25 | Macomb | Michigan | 26099 | 5223 | 521 |
90857 | 90857 | 2020-04-26 | Macomb | Michigan | 26099 | 5288 | 524 |
93678 | 93678 | 2020-04-27 | Macomb | Michigan | 26099 | 5336 | 531 |
96513 | 96513 | 2020-04-28 | Macomb | Michigan | 26099 | 5430 | 576 |
99359 | 99359 | 2020-04-29 | Macomb | Michigan | 26099 | 5521 | 602 |
102211 | 102211 | 2020-04-30 | Macomb | Michigan | 26099 | 5606 | 608 |
105071 | 105071 | 2020-05-01 | Macomb | Michigan | 26099 | 5718 | 619 |
107935 | 107935 | 2020-05-02 | Macomb | Michigan | 26099 | 5761 | 630 |
110807 | 110807 | 2020-05-03 | Macomb | Michigan | 26099 | 5854 | 633 |
113685 | 113685 | 2020-05-04 | Macomb | Michigan | 26099 | 5835 | 648 |
116566 | 116566 | 2020-05-05 | Macomb | Michigan | 26099 | 5888 | 652 |
119527 | 119527 | 2020-05-06 | Macomb | Michigan | 26099 | 5932 | 667 |
122499 | 122499 | 2020-05-07 | Macomb | Michigan | 26099 | 5976 | 683 |
125481 | 125481 | 2020-05-08 | Macomb | Michigan | 26099 | 6063 | 687 |
128468 | 128468 | 2020-05-09 | Macomb | Michigan | 26099 | 6124 | 702 |
131458 | 131458 | 2020-05-10 | Macomb | Michigan | 26099 | 6150 | 703 |
134449 | 134449 | 2020-05-11 | Macomb | Michigan | 26099 | 6172 | 704 |
137439 | 137439 | 2020-05-12 | Macomb | Michigan | 26099 | 6205 | 715 |
140433 | 140433 | 2020-05-13 | Macomb | Michigan | 26099 | 6245 | 722 |
143428 | 143428 | 2020-05-14 | Macomb | Michigan | 26099 | 6341 | 733 |
146428 | 146428 | 2020-05-15 | Macomb | Michigan | 26099 | 6383 | 734 |
149433 | 149433 | 2020-05-16 | Macomb | Michigan | 26099 | 6413 | 744 |
152444 | 152444 | 2020-05-17 | Macomb | Michigan | 26099 | 6455 | 745 |
155458 | 155458 | 2020-05-18 | Macomb | Michigan | 26099 | 6467 | 745 |
158476 | 158476 | 2020-05-19 | Macomb | Michigan | 26099 | 6477 | 758 |
161502 | 161502 | 2020-05-20 | Macomb | Michigan | 26099 | 6502 | 768 |
164531 | 164531 | 2020-05-21 | Macomb | Michigan | 26099 | 6530 | 777 |
167567 | 167567 | 2020-05-22 | Macomb | Michigan | 26099 | 6555 | 781 |
170604 | 170604 | 2020-05-23 | Macomb | Michigan | 26099 | 6592 | 783 |
173646 | 173646 | 2020-05-24 | Macomb | Michigan | 26099 | 6611 | 783 |
176689 | 176689 | 2020-05-25 | Macomb | Michigan | 26099 | 6628 | 783 |
179733 | 179733 | 2020-05-26 | Macomb | Michigan | 26099 | 6640 | 784 |
182779 | 182779 | 2020-05-27 | Macomb | Michigan | 26099 | 6670 | 789 |
185834 | 185834 | 2020-05-28 | Macomb | Michigan | 26099 | 6698 | 792 |
188892 | 188892 | 2020-05-29 | Macomb | Michigan | 26099 | 6728 | 798 |
191956 | 191956 | 2020-05-30 | Macomb | Michigan | 26099 | 6736 | 807 |
195024 | 195024 | 2020-05-31 | Macomb | Michigan | 26099 | 6848 | 815 |
198095 | 198095 | 2020-06-01 | Macomb | Michigan | 26099 | 6860 | 819 |
201168 | 201168 | 2020-06-02 | Macomb | Michigan | 26099 | 6873 | 823 |
204245 | 204245 | 2020-06-03 | Macomb | Michigan | 26099 | 7005 | 831 |
207326 | 207326 | 2020-06-04 | Macomb | Michigan | 26099 | 7026 | 833 |
210407 | 210407 | 2020-06-05 | Macomb | Michigan | 26099 | 7140 | 871 |
213491 | 213491 | 2020-06-06 | Macomb | Michigan | 26099 | 7177 | 875 |
216579 | 216579 | 2020-06-07 | Macomb | Michigan | 26099 | 7235 | 875 |
219671 | 219671 | 2020-06-08 | Macomb | Michigan | 26099 | 7246 | 875 |
222766 | 222766 | 2020-06-09 | Macomb | Michigan | 26099 | 7236 | 878 |
225864 | 225864 | 2020-06-10 | Macomb | Michigan | 26099 | 7239 | 881 |
228966 | 228966 | 2020-06-11 | Macomb | Michigan | 26099 | 7245 | 884 |
232070 | 232070 | 2020-06-12 | Macomb | Michigan | 26099 | 7255 | 886 |
235175 | 235175 | 2020-06-13 | Macomb | Michigan | 26099 | 7274 | 894 |
238282 | 238282 | 2020-06-14 | Macomb | Michigan | 26099 | 7289 | 894 |
241391 | 241391 | 2020-06-15 | Macomb | Michigan | 26099 | 7299 | 894 |
244502 | 244502 | 2020-06-16 | Macomb | Michigan | 26099 | 7330 | 896 |
247615 | 247615 | 2020-06-17 | Macomb | Michigan | 26099 | 7341 | 897 |
250727 | 250727 | 2020-06-18 | Macomb | Michigan | 26099 | 7351 | 902 |
253842 | 253842 | 2020-06-19 | Macomb | Michigan | 26099 | 7362 | 902 |
256962 | 256962 | 2020-06-20 | Macomb | Michigan | 26099 | 7385 | 904 |
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);