ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 26115 and state = "Michigan" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
263225 | 263225 | 2020-06-22 | Monroe | Michigan | 26115 | 581 | 21 |
266351 | 266351 | 2020-06-23 | Monroe | Michigan | 26115 | 580 | 21 |
269484 | 269484 | 2020-06-24 | Monroe | Michigan | 26115 | 583 | 21 |
272621 | 272621 | 2020-06-25 | Monroe | Michigan | 26115 | 591 | 21 |
275764 | 275764 | 2020-06-26 | Monroe | Michigan | 26115 | 597 | 21 |
278912 | 278912 | 2020-06-27 | Monroe | Michigan | 26115 | 602 | 21 |
282060 | 282060 | 2020-06-28 | Monroe | Michigan | 26115 | 603 | 21 |
285205 | 285205 | 2020-06-29 | Monroe | Michigan | 26115 | 606 | 21 |
288355 | 288355 | 2020-06-30 | Monroe | Michigan | 26115 | 617 | 21 |
291506 | 291506 | 2020-07-01 | Monroe | Michigan | 26115 | 618 | 21 |
294660 | 294660 | 2020-07-02 | Monroe | Michigan | 26115 | 619 | 21 |
297818 | 297818 | 2020-07-03 | Monroe | Michigan | 26115 | 626 | 21 |
300980 | 300980 | 2020-07-04 | Monroe | Michigan | 26115 | 629 | 21 |
304144 | 304144 | 2020-07-05 | Monroe | Michigan | 26115 | 633 | 21 |
307311 | 307311 | 2020-07-06 | Monroe | Michigan | 26115 | 641 | 21 |
310479 | 310479 | 2020-07-07 | Monroe | Michigan | 26115 | 647 | 21 |
313649 | 313649 | 2020-07-08 | Monroe | Michigan | 26115 | 653 | 21 |
316823 | 316823 | 2020-07-09 | Monroe | Michigan | 26115 | 656 | 21 |
319998 | 319998 | 2020-07-10 | Monroe | Michigan | 26115 | 655 | 21 |
323177 | 323177 | 2020-07-11 | Monroe | Michigan | 26115 | 659 | 21 |
326360 | 326360 | 2020-07-12 | Monroe | Michigan | 26115 | 661 | 21 |
329546 | 329546 | 2020-07-13 | Monroe | Michigan | 26115 | 671 | 21 |
332733 | 332733 | 2020-07-14 | Monroe | Michigan | 26115 | 673 | 23 |
335926 | 335926 | 2020-07-15 | Monroe | Michigan | 26115 | 693 | 23 |
339122 | 339122 | 2020-07-16 | Monroe | Michigan | 26115 | 706 | 23 |
342318 | 342318 | 2020-07-17 | Monroe | Michigan | 26115 | 719 | 23 |
345518 | 345518 | 2020-07-18 | Monroe | Michigan | 26115 | 728 | 22 |
348719 | 348719 | 2020-07-19 | Monroe | Michigan | 26115 | 740 | 22 |
351919 | 351919 | 2020-07-20 | Monroe | Michigan | 26115 | 743 | 22 |
355121 | 355121 | 2020-07-21 | Monroe | Michigan | 26115 | 747 | 21 |
358324 | 358324 | 2020-07-22 | Monroe | Michigan | 26115 | 754 | 21 |
361529 | 361529 | 2020-07-23 | Monroe | Michigan | 26115 | 765 | 21 |
364736 | 364736 | 2020-07-24 | Monroe | Michigan | 26115 | 773 | 21 |
367943 | 367943 | 2020-07-25 | Monroe | Michigan | 26115 | 784 | 21 |
371153 | 371153 | 2020-07-26 | Monroe | Michigan | 26115 | 794 | 21 |
374365 | 374365 | 2020-07-27 | Monroe | Michigan | 26115 | 803 | 21 |
377580 | 377580 | 2020-07-28 | Monroe | Michigan | 26115 | 817 | 21 |
380797 | 380797 | 2020-07-29 | Monroe | Michigan | 26115 | 833 | 21 |
384014 | 384014 | 2020-07-30 | Monroe | Michigan | 26115 | 854 | 21 |
387232 | 387232 | 2020-07-31 | Monroe | Michigan | 26115 | 867 | 22 |
390449 | 390449 | 2020-08-01 | Monroe | Michigan | 26115 | 882 | 22 |
393666 | 393666 | 2020-08-02 | Monroe | Michigan | 26115 | 885 | 22 |
396882 | 396882 | 2020-08-03 | Monroe | Michigan | 26115 | 904 | 22 |
400096 | 400096 | 2020-08-04 | Monroe | Michigan | 26115 | 920 | 22 |
403313 | 403313 | 2020-08-05 | Monroe | Michigan | 26115 | 935 | 22 |
406531 | 406531 | 2020-08-06 | Monroe | Michigan | 26115 | 945 | 23 |
409751 | 409751 | 2020-08-07 | Monroe | Michigan | 26115 | 955 | 25 |
412971 | 412971 | 2020-08-08 | Monroe | Michigan | 26115 | 972 | 24 |
416191 | 416191 | 2020-08-09 | Monroe | Michigan | 26115 | 984 | 24 |
419412 | 419412 | 2020-08-10 | Monroe | Michigan | 26115 | 987 | 25 |
422634 | 422634 | 2020-08-11 | Monroe | Michigan | 26115 | 1005 | 24 |
425856 | 425856 | 2020-08-12 | Monroe | Michigan | 26115 | 1016 | 25 |
429080 | 429080 | 2020-08-13 | Monroe | Michigan | 26115 | 1032 | 25 |
432307 | 432307 | 2020-08-14 | Monroe | Michigan | 26115 | 1050 | 25 |
435533 | 435533 | 2020-08-15 | Monroe | Michigan | 26115 | 1056 | 25 |
438758 | 438758 | 2020-08-16 | Monroe | Michigan | 26115 | 1064 | 25 |
441985 | 441985 | 2020-08-17 | Monroe | Michigan | 26115 | 1074 | 23 |
445211 | 445211 | 2020-08-18 | Monroe | Michigan | 26115 | 1094 | 24 |
448437 | 448437 | 2020-08-19 | Monroe | Michigan | 26115 | 1115 | 24 |
451665 | 451665 | 2020-08-20 | Monroe | Michigan | 26115 | 1136 | 25 |
454893 | 454893 | 2020-08-21 | Monroe | Michigan | 26115 | 1136 | 25 |
458121 | 458121 | 2020-08-22 | Monroe | Michigan | 26115 | 1170 | 26 |
461348 | 461348 | 2020-08-23 | Monroe | Michigan | 26115 | 1184 | 26 |
464579 | 464579 | 2020-08-24 | Monroe | Michigan | 26115 | 1198 | 26 |
467808 | 467808 | 2020-08-25 | Monroe | Michigan | 26115 | 1230 | 26 |
471038 | 471038 | 2020-08-26 | Monroe | Michigan | 26115 | 1242 | 26 |
474270 | 474270 | 2020-08-27 | Monroe | Michigan | 26115 | 1258 | 26 |
477503 | 477503 | 2020-08-28 | Monroe | Michigan | 26115 | 1269 | 27 |
480735 | 480735 | 2020-08-29 | Monroe | Michigan | 26115 | 1287 | 27 |
483970 | 483970 | 2020-08-30 | Monroe | Michigan | 26115 | 1310 | 27 |
487204 | 487204 | 2020-08-31 | Monroe | Michigan | 26115 | 1320 | 27 |
490437 | 490437 | 2020-09-01 | Monroe | Michigan | 26115 | 1325 | 27 |
493671 | 493671 | 2020-09-02 | Monroe | Michigan | 26115 | 1340 | 28 |
496904 | 496904 | 2020-09-03 | Monroe | Michigan | 26115 | 1357 | 28 |
500138 | 500138 | 2020-09-04 | Monroe | Michigan | 26115 | 1367 | 28 |
503372 | 503372 | 2020-09-05 | Monroe | Michigan | 26115 | 1377 | 28 |
506605 | 506605 | 2020-09-06 | Monroe | Michigan | 26115 | 1377 | 28 |
509838 | 509838 | 2020-09-07 | Monroe | Michigan | 26115 | 1395 | 28 |
513070 | 513070 | 2020-09-08 | Monroe | Michigan | 26115 | 1400 | 29 |
516304 | 516304 | 2020-09-09 | Monroe | Michigan | 26115 | 1405 | 29 |
519539 | 519539 | 2020-09-10 | Monroe | Michigan | 26115 | 1418 | 29 |
522776 | 522776 | 2020-09-11 | Monroe | Michigan | 26115 | 1423 | 29 |
526012 | 526012 | 2020-09-12 | Monroe | Michigan | 26115 | 1427 | 29 |
529248 | 529248 | 2020-09-13 | Monroe | Michigan | 26115 | 1427 | 29 |
532484 | 532484 | 2020-09-14 | Monroe | Michigan | 26115 | 1438 | 29 |
535719 | 535719 | 2020-09-15 | Monroe | Michigan | 26115 | 1443 | 28 |
538956 | 538956 | 2020-09-16 | Monroe | Michigan | 26115 | 1454 | 28 |
542192 | 542192 | 2020-09-17 | Monroe | Michigan | 26115 | 1455 | 28 |
545429 | 545429 | 2020-09-18 | Monroe | Michigan | 26115 | 1454 | 28 |
548667 | 548667 | 2020-09-19 | Monroe | Michigan | 26115 | 1458 | 28 |
551906 | 551906 | 2020-09-20 | Monroe | Michigan | 26115 | 1458 | 28 |
555144 | 555144 | 2020-09-21 | Monroe | Michigan | 26115 | 1471 | 28 |
558381 | 558381 | 2020-09-22 | Monroe | Michigan | 26115 | 1476 | 28 |
561618 | 561618 | 2020-09-23 | Monroe | Michigan | 26115 | 1486 | 29 |
564858 | 564858 | 2020-09-24 | Monroe | Michigan | 26115 | 1504 | 28 |
568098 | 568098 | 2020-09-25 | Monroe | Michigan | 26115 | 1506 | 28 |
571340 | 571340 | 2020-09-26 | Monroe | Michigan | 26115 | 1513 | 28 |
574583 | 574583 | 2020-09-27 | Monroe | Michigan | 26115 | 1513 | 28 |
577824 | 577824 | 2020-09-28 | Monroe | Michigan | 26115 | 1528 | 28 |
581065 | 581065 | 2020-09-29 | Monroe | Michigan | 26115 | 1540 | 28 |
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);