ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Livingston" and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4751 | 4751 | 2020-03-19 | Livingston | Michigan | 26093 | 3 | 0 |
5570 | 5570 | 2020-03-20 | Livingston | Michigan | 26093 | 3 | 0 |
6535 | 6535 | 2020-03-21 | Livingston | Michigan | 26093 | 6 | 0 |
7615 | 7615 | 2020-03-22 | Livingston | Michigan | 26093 | 8 | 0 |
8789 | 8789 | 2020-03-23 | Livingston | Michigan | 26093 | 9 | 0 |
10082 | 10082 | 2020-03-24 | Livingston | Michigan | 26093 | 13 | 0 |
11496 | 11496 | 2020-03-25 | Livingston | Michigan | 26093 | 16 | 1 |
13079 | 13079 | 2020-03-26 | Livingston | Michigan | 26093 | 21 | 1 |
14791 | 14791 | 2020-03-27 | Livingston | Michigan | 26093 | 31 | 1 |
16611 | 16611 | 2020-03-28 | Livingston | Michigan | 26093 | 41 | 2 |
18527 | 18527 | 2020-03-29 | Livingston | Michigan | 26093 | 59 | 2 |
20546 | 20546 | 2020-03-30 | Livingston | Michigan | 26093 | 64 | 2 |
22657 | 22657 | 2020-03-31 | Livingston | Michigan | 26093 | 80 | 2 |
24836 | 24836 | 2020-04-01 | Livingston | Michigan | 26093 | 101 | 2 |
27089 | 27089 | 2020-04-02 | Livingston | Michigan | 26093 | 113 | 2 |
29407 | 29407 | 2020-04-03 | Livingston | Michigan | 26093 | 121 | 2 |
31785 | 31785 | 2020-04-04 | Livingston | Michigan | 26093 | 129 | 2 |
34210 | 34210 | 2020-04-05 | Livingston | Michigan | 26093 | 135 | 2 |
36669 | 36669 | 2020-04-06 | Livingston | Michigan | 26093 | 143 | 2 |
39177 | 39177 | 2020-04-07 | Livingston | Michigan | 26093 | 155 | 2 |
41729 | 41729 | 2020-04-08 | Livingston | Michigan | 26093 | 174 | 2 |
44305 | 44305 | 2020-04-09 | Livingston | Michigan | 26093 | 181 | 2 |
46913 | 46913 | 2020-04-10 | Livingston | Michigan | 26093 | 196 | 3 |
49557 | 49557 | 2020-04-11 | Livingston | Michigan | 26093 | 206 | 3 |
52227 | 52227 | 2020-04-12 | Livingston | Michigan | 26093 | 209 | 4 |
54908 | 54908 | 2020-04-13 | Livingston | Michigan | 26093 | 225 | 5 |
57606 | 57606 | 2020-04-14 | Livingston | Michigan | 26093 | 238 | 6 |
60316 | 60316 | 2020-04-15 | Livingston | Michigan | 26093 | 260 | 7 |
63038 | 63038 | 2020-04-16 | Livingston | Michigan | 26093 | 269 | 9 |
65776 | 65776 | 2020-04-17 | Livingston | Michigan | 26093 | 275 | 9 |
68527 | 68527 | 2020-04-18 | Livingston | Michigan | 26093 | 282 | 10 |
71291 | 71291 | 2020-04-19 | Livingston | Michigan | 26093 | 285 | 11 |
74063 | 74063 | 2020-04-20 | Livingston | Michigan | 26093 | 294 | 11 |
76843 | 76843 | 2020-04-21 | Livingston | Michigan | 26093 | 307 | 11 |
79629 | 79629 | 2020-04-22 | Livingston | Michigan | 26093 | 314 | 11 |
82424 | 82424 | 2020-04-23 | Livingston | Michigan | 26093 | 318 | 11 |
85228 | 85228 | 2020-04-24 | Livingston | Michigan | 26093 | 319 | 12 |
88038 | 88038 | 2020-04-25 | Livingston | Michigan | 26093 | 322 | 15 |
90854 | 90854 | 2020-04-26 | Livingston | Michigan | 26093 | 322 | 15 |
93675 | 93675 | 2020-04-27 | Livingston | Michigan | 26093 | 327 | 15 |
96510 | 96510 | 2020-04-28 | Livingston | Michigan | 26093 | 334 | 19 |
99356 | 99356 | 2020-04-29 | Livingston | Michigan | 26093 | 343 | 19 |
102208 | 102208 | 2020-04-30 | Livingston | Michigan | 26093 | 345 | 20 |
105068 | 105068 | 2020-05-01 | Livingston | Michigan | 26093 | 351 | 20 |
107932 | 107932 | 2020-05-02 | Livingston | Michigan | 26093 | 360 | 20 |
110804 | 110804 | 2020-05-03 | Livingston | Michigan | 26093 | 369 | 20 |
113682 | 113682 | 2020-05-04 | Livingston | Michigan | 26093 | 364 | 21 |
116563 | 116563 | 2020-05-05 | Livingston | Michigan | 26093 | 370 | 21 |
119524 | 119524 | 2020-05-06 | Livingston | Michigan | 26093 | 374 | 21 |
122496 | 122496 | 2020-05-07 | Livingston | Michigan | 26093 | 376 | 21 |
125478 | 125478 | 2020-05-08 | Livingston | Michigan | 26093 | 382 | 21 |
128465 | 128465 | 2020-05-09 | Livingston | Michigan | 26093 | 383 | 23 |
131455 | 131455 | 2020-05-10 | Livingston | Michigan | 26093 | 384 | 23 |
134446 | 134446 | 2020-05-11 | Livingston | Michigan | 26093 | 384 | 23 |
137436 | 137436 | 2020-05-12 | Livingston | Michigan | 26093 | 385 | 23 |
140430 | 140430 | 2020-05-13 | Livingston | Michigan | 26093 | 386 | 24 |
143425 | 143425 | 2020-05-14 | Livingston | Michigan | 26093 | 388 | 24 |
146425 | 146425 | 2020-05-15 | Livingston | Michigan | 26093 | 389 | 26 |
149430 | 149430 | 2020-05-16 | Livingston | Michigan | 26093 | 391 | 26 |
152441 | 152441 | 2020-05-17 | Livingston | Michigan | 26093 | 393 | 26 |
155455 | 155455 | 2020-05-18 | Livingston | Michigan | 26093 | 394 | 26 |
158473 | 158473 | 2020-05-19 | Livingston | Michigan | 26093 | 393 | 27 |
161499 | 161499 | 2020-05-20 | Livingston | Michigan | 26093 | 395 | 27 |
164528 | 164528 | 2020-05-21 | Livingston | Michigan | 26093 | 397 | 27 |
167564 | 167564 | 2020-05-22 | Livingston | Michigan | 26093 | 398 | 27 |
170601 | 170601 | 2020-05-23 | Livingston | Michigan | 26093 | 398 | 27 |
173643 | 173643 | 2020-05-24 | Livingston | Michigan | 26093 | 399 | 27 |
176686 | 176686 | 2020-05-25 | Livingston | Michigan | 26093 | 399 | 27 |
179730 | 179730 | 2020-05-26 | Livingston | Michigan | 26093 | 400 | 27 |
182776 | 182776 | 2020-05-27 | Livingston | Michigan | 26093 | 399 | 27 |
185831 | 185831 | 2020-05-28 | Livingston | Michigan | 26093 | 399 | 27 |
188889 | 188889 | 2020-05-29 | Livingston | Michigan | 26093 | 403 | 27 |
191953 | 191953 | 2020-05-30 | Livingston | Michigan | 26093 | 403 | 27 |
195021 | 195021 | 2020-05-31 | Livingston | Michigan | 26093 | 403 | 27 |
198092 | 198092 | 2020-06-01 | Livingston | Michigan | 26093 | 514 | 27 |
201165 | 201165 | 2020-06-02 | Livingston | Michigan | 26093 | 531 | 27 |
204242 | 204242 | 2020-06-03 | Livingston | Michigan | 26093 | 540 | 27 |
207323 | 207323 | 2020-06-04 | Livingston | Michigan | 26093 | 547 | 27 |
210404 | 210404 | 2020-06-05 | Livingston | Michigan | 26093 | 555 | 28 |
213488 | 213488 | 2020-06-06 | Livingston | Michigan | 26093 | 555 | 29 |
216576 | 216576 | 2020-06-07 | Livingston | Michigan | 26093 | 555 | 29 |
219668 | 219668 | 2020-06-08 | Livingston | Michigan | 26093 | 563 | 29 |
222763 | 222763 | 2020-06-09 | Livingston | Michigan | 26093 | 566 | 29 |
225861 | 225861 | 2020-06-10 | Livingston | Michigan | 26093 | 567 | 29 |
228963 | 228963 | 2020-06-11 | Livingston | Michigan | 26093 | 567 | 29 |
232067 | 232067 | 2020-06-12 | Livingston | Michigan | 26093 | 568 | 29 |
235172 | 235172 | 2020-06-13 | Livingston | Michigan | 26093 | 568 | 29 |
238279 | 238279 | 2020-06-14 | Livingston | Michigan | 26093 | 568 | 29 |
241388 | 241388 | 2020-06-15 | Livingston | Michigan | 26093 | 570 | 29 |
244499 | 244499 | 2020-06-16 | Livingston | Michigan | 26093 | 572 | 29 |
247612 | 247612 | 2020-06-17 | Livingston | Michigan | 26093 | 574 | 29 |
250724 | 250724 | 2020-06-18 | Livingston | Michigan | 26093 | 576 | 29 |
253839 | 253839 | 2020-06-19 | Livingston | Michigan | 26093 | 582 | 29 |
256959 | 256959 | 2020-06-20 | Livingston | Michigan | 26093 | 582 | 29 |
260085 | 260085 | 2020-06-21 | Livingston | Michigan | 26093 | 582 | 29 |
263214 | 263214 | 2020-06-22 | Livingston | Michigan | 26093 | 591 | 29 |
266340 | 266340 | 2020-06-23 | Livingston | Michigan | 26093 | 594 | 29 |
269473 | 269473 | 2020-06-24 | Livingston | Michigan | 26093 | 596 | 29 |
272610 | 272610 | 2020-06-25 | Livingston | Michigan | 26093 | 599 | 29 |
275753 | 275753 | 2020-06-26 | Livingston | Michigan | 26093 | 602 | 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);