ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Ingham", fips = 26065 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 |
---|---|---|---|---|---|---|---|
1478 | 1478 | 2020-03-12 | Ingham | Michigan | 26065 | 1 | 0 |
1759 | 1759 | 2020-03-13 | Ingham | Michigan | 26065 | 1 | 0 |
2102 | 2102 | 2020-03-14 | Ingham | Michigan | 26065 | 1 | 0 |
2505 | 2505 | 2020-03-15 | Ingham | Michigan | 26065 | 1 | 0 |
2955 | 2955 | 2020-03-16 | Ingham | Michigan | 26065 | 1 | 0 |
3456 | 3456 | 2020-03-17 | Ingham | Michigan | 26065 | 2 | 0 |
4039 | 4039 | 2020-03-18 | Ingham | Michigan | 26065 | 2 | 0 |
4747 | 4747 | 2020-03-19 | Ingham | Michigan | 26065 | 7 | 0 |
5566 | 5566 | 2020-03-20 | Ingham | Michigan | 26065 | 7 | 0 |
6531 | 6531 | 2020-03-21 | Ingham | Michigan | 26065 | 11 | 0 |
7611 | 7611 | 2020-03-22 | Ingham | Michigan | 26065 | 11 | 0 |
8784 | 8784 | 2020-03-23 | Ingham | Michigan | 26065 | 12 | 0 |
10074 | 10074 | 2020-03-24 | Ingham | Michigan | 26065 | 15 | 0 |
11486 | 11486 | 2020-03-25 | Ingham | Michigan | 26065 | 18 | 0 |
13068 | 13068 | 2020-03-26 | Ingham | Michigan | 26065 | 22 | 0 |
14780 | 14780 | 2020-03-27 | Ingham | Michigan | 26065 | 26 | 1 |
16600 | 16600 | 2020-03-28 | Ingham | Michigan | 26065 | 32 | 1 |
18516 | 18516 | 2020-03-29 | Ingham | Michigan | 26065 | 43 | 0 |
20535 | 20535 | 2020-03-30 | Ingham | Michigan | 26065 | 73 | 0 |
22646 | 22646 | 2020-03-31 | Ingham | Michigan | 26065 | 91 | 0 |
24825 | 24825 | 2020-04-01 | Ingham | Michigan | 26065 | 121 | 1 |
27078 | 27078 | 2020-04-02 | Ingham | Michigan | 26065 | 128 | 1 |
29396 | 29396 | 2020-04-03 | Ingham | Michigan | 26065 | 152 | 1 |
31774 | 31774 | 2020-04-04 | Ingham | Michigan | 26065 | 168 | 1 |
34199 | 34199 | 2020-04-05 | Ingham | Michigan | 26065 | 172 | 2 |
36658 | 36658 | 2020-04-06 | Ingham | Michigan | 26065 | 178 | 1 |
39166 | 39166 | 2020-04-07 | Ingham | Michigan | 26065 | 189 | 1 |
41718 | 41718 | 2020-04-08 | Ingham | Michigan | 26065 | 205 | 2 |
44294 | 44294 | 2020-04-09 | Ingham | Michigan | 26065 | 222 | 3 |
46902 | 46902 | 2020-04-10 | Ingham | Michigan | 26065 | 239 | 3 |
49545 | 49545 | 2020-04-11 | Ingham | Michigan | 26065 | 241 | 3 |
52215 | 52215 | 2020-04-12 | Ingham | Michigan | 26065 | 250 | 3 |
54896 | 54896 | 2020-04-13 | Ingham | Michigan | 26065 | 254 | 4 |
57594 | 57594 | 2020-04-14 | Ingham | Michigan | 26065 | 263 | 4 |
60304 | 60304 | 2020-04-15 | Ingham | Michigan | 26065 | 270 | 5 |
63026 | 63026 | 2020-04-16 | Ingham | Michigan | 26065 | 278 | 6 |
65764 | 65764 | 2020-04-17 | Ingham | Michigan | 26065 | 298 | 6 |
68515 | 68515 | 2020-04-18 | Ingham | Michigan | 26065 | 304 | 6 |
71279 | 71279 | 2020-04-19 | Ingham | Michigan | 26065 | 308 | 6 |
74051 | 74051 | 2020-04-20 | Ingham | Michigan | 26065 | 314 | 6 |
76831 | 76831 | 2020-04-21 | Ingham | Michigan | 26065 | 335 | 6 |
79617 | 79617 | 2020-04-22 | Ingham | Michigan | 26065 | 350 | 7 |
82412 | 82412 | 2020-04-23 | Ingham | Michigan | 26065 | 370 | 9 |
85216 | 85216 | 2020-04-24 | Ingham | Michigan | 26065 | 391 | 9 |
88026 | 88026 | 2020-04-25 | Ingham | Michigan | 26065 | 395 | 9 |
90842 | 90842 | 2020-04-26 | Ingham | Michigan | 26065 | 406 | 9 |
93663 | 93663 | 2020-04-27 | Ingham | Michigan | 26065 | 413 | 10 |
96498 | 96498 | 2020-04-28 | Ingham | Michigan | 26065 | 426 | 10 |
99344 | 99344 | 2020-04-29 | Ingham | Michigan | 26065 | 446 | 10 |
102196 | 102196 | 2020-04-30 | Ingham | Michigan | 26065 | 470 | 11 |
105056 | 105056 | 2020-05-01 | Ingham | Michigan | 26065 | 483 | 12 |
107920 | 107920 | 2020-05-02 | Ingham | Michigan | 26065 | 497 | 13 |
110792 | 110792 | 2020-05-03 | Ingham | Michigan | 26065 | 506 | 13 |
113670 | 113670 | 2020-05-04 | Ingham | Michigan | 26065 | 506 | 13 |
116551 | 116551 | 2020-05-05 | Ingham | Michigan | 26065 | 518 | 14 |
119512 | 119512 | 2020-05-06 | Ingham | Michigan | 26065 | 539 | 14 |
122484 | 122484 | 2020-05-07 | Ingham | Michigan | 26065 | 557 | 14 |
125466 | 125466 | 2020-05-08 | Ingham | Michigan | 26065 | 563 | 16 |
128453 | 128453 | 2020-05-09 | Ingham | Michigan | 26065 | 575 | 16 |
131443 | 131443 | 2020-05-10 | Ingham | Michigan | 26065 | 579 | 16 |
134434 | 134434 | 2020-05-11 | Ingham | Michigan | 26065 | 586 | 17 |
137424 | 137424 | 2020-05-12 | Ingham | Michigan | 26065 | 594 | 17 |
140418 | 140418 | 2020-05-13 | Ingham | Michigan | 26065 | 605 | 18 |
143413 | 143413 | 2020-05-14 | Ingham | Michigan | 26065 | 619 | 19 |
146413 | 146413 | 2020-05-15 | Ingham | Michigan | 26065 | 629 | 20 |
149418 | 149418 | 2020-05-16 | Ingham | Michigan | 26065 | 643 | 21 |
152429 | 152429 | 2020-05-17 | Ingham | Michigan | 26065 | 648 | 22 |
155443 | 155443 | 2020-05-18 | Ingham | Michigan | 26065 | 649 | 23 |
158461 | 158461 | 2020-05-19 | Ingham | Michigan | 26065 | 650 | 23 |
161487 | 161487 | 2020-05-20 | Ingham | Michigan | 26065 | 667 | 23 |
164516 | 164516 | 2020-05-21 | Ingham | Michigan | 26065 | 674 | 24 |
167552 | 167552 | 2020-05-22 | Ingham | Michigan | 26065 | 682 | 24 |
170589 | 170589 | 2020-05-23 | Ingham | Michigan | 26065 | 695 | 25 |
173631 | 173631 | 2020-05-24 | Ingham | Michigan | 26065 | 696 | 25 |
176674 | 176674 | 2020-05-25 | Ingham | Michigan | 26065 | 701 | 25 |
179718 | 179718 | 2020-05-26 | Ingham | Michigan | 26065 | 705 | 25 |
182764 | 182764 | 2020-05-27 | Ingham | Michigan | 26065 | 717 | 25 |
185819 | 185819 | 2020-05-28 | Ingham | Michigan | 26065 | 729 | 25 |
188877 | 188877 | 2020-05-29 | Ingham | Michigan | 26065 | 734 | 25 |
191941 | 191941 | 2020-05-30 | Ingham | Michigan | 26065 | 736 | 25 |
195009 | 195009 | 2020-05-31 | Ingham | Michigan | 26065 | 738 | 26 |
198080 | 198080 | 2020-06-01 | Ingham | Michigan | 26065 | 740 | 26 |
201152 | 201152 | 2020-06-02 | Ingham | Michigan | 26065 | 745 | 27 |
204229 | 204229 | 2020-06-03 | Ingham | Michigan | 26065 | 746 | 27 |
207310 | 207310 | 2020-06-04 | Ingham | Michigan | 26065 | 755 | 27 |
210391 | 210391 | 2020-06-05 | Ingham | Michigan | 26065 | 793 | 27 |
213475 | 213475 | 2020-06-06 | Ingham | Michigan | 26065 | 801 | 27 |
216563 | 216563 | 2020-06-07 | Ingham | Michigan | 26065 | 806 | 27 |
219655 | 219655 | 2020-06-08 | Ingham | Michigan | 26065 | 809 | 27 |
222750 | 222750 | 2020-06-09 | Ingham | Michigan | 26065 | 808 | 28 |
225847 | 225847 | 2020-06-10 | Ingham | Michigan | 26065 | 810 | 28 |
228949 | 228949 | 2020-06-11 | Ingham | Michigan | 26065 | 832 | 29 |
232053 | 232053 | 2020-06-12 | Ingham | Michigan | 26065 | 815 | 29 |
235158 | 235158 | 2020-06-13 | Ingham | Michigan | 26065 | 824 | 29 |
238265 | 238265 | 2020-06-14 | Ingham | Michigan | 26065 | 825 | 29 |
241374 | 241374 | 2020-06-15 | Ingham | Michigan | 26065 | 825 | 29 |
244485 | 244485 | 2020-06-16 | Ingham | Michigan | 26065 | 825 | 29 |
247598 | 247598 | 2020-06-17 | Ingham | Michigan | 26065 | 825 | 29 |
250710 | 250710 | 2020-06-18 | Ingham | Michigan | 26065 | 825 | 29 |
253825 | 253825 | 2020-06-19 | Ingham | Michigan | 26065 | 831 | 29 |
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);