ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 26125 and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
869817 | 869817 | 2020-12-27 | Oakland | Michigan | 26125 | 59724 | 1604 |
866572 | 866572 | 2020-12-26 | Oakland | Michigan | 26125 | 59724 | 1604 |
863327 | 863327 | 2020-12-25 | Oakland | Michigan | 26125 | 58949 | 1572 |
860082 | 860082 | 2020-12-24 | Oakland | Michigan | 26125 | 58949 | 1572 |
856837 | 856837 | 2020-12-23 | Oakland | Michigan | 26125 | 58949 | 1572 |
853592 | 853592 | 2020-12-22 | Oakland | Michigan | 26125 | 58636 | 1564 |
850347 | 850347 | 2020-12-21 | Oakland | Michigan | 26125 | 58249 | 1546 |
847102 | 847102 | 2020-12-20 | Oakland | Michigan | 26125 | 57698 | 1543 |
843856 | 843856 | 2020-12-19 | Oakland | Michigan | 26125 | 57698 | 1543 |
840611 | 840611 | 2020-12-18 | Oakland | Michigan | 26125 | 57285 | 1514 |
837366 | 837366 | 2020-12-17 | Oakland | Michigan | 26125 | 56825 | 1511 |
834120 | 834120 | 2020-12-16 | Oakland | Michigan | 26125 | 56343 | 1495 |
830873 | 830873 | 2020-12-15 | Oakland | Michigan | 26125 | 55885 | 1490 |
827627 | 827627 | 2020-12-14 | Oakland | Michigan | 26125 | 55183 | 1478 |
824380 | 824380 | 2020-12-13 | Oakland | Michigan | 26125 | 54497 | 1476 |
821134 | 821134 | 2020-12-12 | Oakland | Michigan | 26125 | 54497 | 1476 |
817888 | 817888 | 2020-12-11 | Oakland | Michigan | 26125 | 54042 | 1463 |
814642 | 814642 | 2020-12-10 | Oakland | Michigan | 26125 | 53510 | 1462 |
811397 | 811397 | 2020-12-09 | Oakland | Michigan | 26125 | 52856 | 1440 |
808152 | 808152 | 2020-12-08 | Oakland | Michigan | 26125 | 52330 | 1437 |
804907 | 804907 | 2020-12-07 | Oakland | Michigan | 26125 | 51468 | 1415 |
801662 | 801662 | 2020-12-06 | Oakland | Michigan | 26125 | 50593 | 1414 |
798417 | 798417 | 2020-12-05 | Oakland | Michigan | 26125 | 50593 | 1414 |
795172 | 795172 | 2020-12-04 | Oakland | Michigan | 26125 | 50014 | 1398 |
791927 | 791927 | 2020-12-03 | Oakland | Michigan | 26125 | 49136 | 1395 |
788682 | 788682 | 2020-12-02 | Oakland | Michigan | 26125 | 48402 | 1375 |
785437 | 785437 | 2020-12-01 | Oakland | Michigan | 26125 | 47475 | 1367 |
782193 | 782193 | 2020-11-30 | Oakland | Michigan | 26125 | 46874 | 1364 |
778947 | 778947 | 2020-11-29 | Oakland | Michigan | 26125 | 45701 | 1358 |
775702 | 775702 | 2020-11-28 | Oakland | Michigan | 26125 | 45701 | 1358 |
772457 | 772457 | 2020-11-27 | Oakland | Michigan | 26125 | 44624 | 1344 |
769212 | 769212 | 2020-11-26 | Oakland | Michigan | 26125 | 42850 | 1332 |
765966 | 765966 | 2020-11-25 | Oakland | Michigan | 26125 | 42850 | 1332 |
762721 | 762721 | 2020-11-24 | Oakland | Michigan | 26125 | 42349 | 1322 |
759476 | 759476 | 2020-11-23 | Oakland | Michigan | 26125 | 41470 | 1311 |
756229 | 756229 | 2020-11-22 | Oakland | Michigan | 26125 | 40381 | 1310 |
752983 | 752983 | 2020-11-21 | Oakland | Michigan | 26125 | 40381 | 1310 |
749737 | 749737 | 2020-11-20 | Oakland | Michigan | 26125 | 39629 | 1302 |
746491 | 746491 | 2020-11-19 | Oakland | Michigan | 26125 | 38325 | 1299 |
743244 | 743244 | 2020-11-18 | Oakland | Michigan | 26125 | 37587 | 1287 |
739997 | 739997 | 2020-11-17 | Oakland | Michigan | 26125 | 36983 | 1285 |
736753 | 736753 | 2020-11-16 | Oakland | Michigan | 26125 | 36020 | 1283 |
733507 | 733507 | 2020-11-15 | Oakland | Michigan | 26125 | 34658 | 1282 |
730262 | 730262 | 2020-11-14 | Oakland | Michigan | 26125 | 34658 | 1282 |
727019 | 727019 | 2020-11-13 | Oakland | Michigan | 26125 | 33906 | 1275 |
723776 | 723776 | 2020-11-12 | Oakland | Michigan | 26125 | 33092 | 1260 |
720533 | 720533 | 2020-11-11 | Oakland | Michigan | 26125 | 32406 | 1260 |
717290 | 717290 | 2020-11-10 | Oakland | Michigan | 26125 | 31563 | 1259 |
714046 | 714046 | 2020-11-09 | Oakland | Michigan | 26125 | 30859 | 1257 |
710802 | 710802 | 2020-11-08 | Oakland | Michigan | 26125 | 29849 | 1255 |
707558 | 707558 | 2020-11-07 | Oakland | Michigan | 26125 | 29849 | 1255 |
704315 | 704315 | 2020-11-06 | Oakland | Michigan | 26125 | 29154 | 1249 |
701073 | 701073 | 2020-11-05 | Oakland | Michigan | 26125 | 28831 | 1247 |
697829 | 697829 | 2020-11-04 | Oakland | Michigan | 26125 | 28199 | 1244 |
694586 | 694586 | 2020-11-03 | Oakland | Michigan | 26125 | 27839 | 1244 |
691344 | 691344 | 2020-11-02 | Oakland | Michigan | 26125 | 27476 | 1241 |
688099 | 688099 | 2020-11-01 | Oakland | Michigan | 26125 | 26579 | 1241 |
684855 | 684855 | 2020-10-31 | Oakland | Michigan | 26125 | 26579 | 1241 |
681612 | 681612 | 2020-10-30 | Oakland | Michigan | 26125 | 26259 | 1239 |
678368 | 678368 | 2020-10-29 | Oakland | Michigan | 26125 | 25903 | 1239 |
675126 | 675126 | 2020-10-28 | Oakland | Michigan | 26125 | 25563 | 1237 |
671883 | 671883 | 2020-10-27 | Oakland | Michigan | 26125 | 25069 | 1237 |
668641 | 668641 | 2020-10-26 | Oakland | Michigan | 26125 | 24730 | 1235 |
665397 | 665397 | 2020-10-25 | Oakland | Michigan | 26125 | 24343 | 1235 |
662152 | 662152 | 2020-10-24 | Oakland | Michigan | 26125 | 24343 | 1235 |
658908 | 658908 | 2020-10-23 | Oakland | Michigan | 26125 | 24025 | 1233 |
655663 | 655663 | 2020-10-22 | Oakland | Michigan | 26125 | 23827 | 1233 |
652418 | 652418 | 2020-10-21 | Oakland | Michigan | 26125 | 23608 | 1228 |
649173 | 649173 | 2020-10-20 | Oakland | Michigan | 26125 | 23394 | 1228 |
645929 | 645929 | 2020-10-19 | Oakland | Michigan | 26125 | 23165 | 1227 |
642682 | 642682 | 2020-10-18 | Oakland | Michigan | 26125 | 22752 | 1224 |
639435 | 639435 | 2020-10-17 | Oakland | Michigan | 26125 | 22752 | 1224 |
636189 | 636189 | 2020-10-16 | Oakland | Michigan | 26125 | 22752 | 1224 |
632943 | 632943 | 2020-10-15 | Oakland | Michigan | 26125 | 22571 | 1224 |
629698 | 629698 | 2020-10-14 | Oakland | Michigan | 26125 | 22324 | 1222 |
626454 | 626454 | 2020-10-13 | Oakland | Michigan | 26125 | 22179 | 1222 |
623212 | 623212 | 2020-10-12 | Oakland | Michigan | 26125 | 22033 | 1221 |
619969 | 619969 | 2020-10-11 | Oakland | Michigan | 26125 | 21878 | 1220 |
616727 | 616727 | 2020-10-10 | Oakland | Michigan | 26125 | 21878 | 1220 |
613486 | 613486 | 2020-10-09 | Oakland | Michigan | 26125 | 21730 | 1215 |
610244 | 610244 | 2020-10-08 | Oakland | Michigan | 26125 | 21592 | 1214 |
607002 | 607002 | 2020-10-07 | Oakland | Michigan | 26125 | 21464 | 1210 |
603759 | 603759 | 2020-10-06 | Oakland | Michigan | 26125 | 21358 | 1211 |
600517 | 600517 | 2020-10-05 | Oakland | Michigan | 26125 | 21241 | 1207 |
597274 | 597274 | 2020-10-04 | Oakland | Michigan | 26125 | 21107 | 1207 |
594033 | 594033 | 2020-10-03 | Oakland | Michigan | 26125 | 21107 | 1207 |
590792 | 590792 | 2020-10-02 | Oakland | Michigan | 26125 | 20993 | 1206 |
587551 | 587551 | 2020-10-01 | Oakland | Michigan | 26125 | 20922 | 1206 |
584311 | 584311 | 2020-09-30 | Oakland | Michigan | 26125 | 20854 | 1203 |
581070 | 581070 | 2020-09-29 | Oakland | Michigan | 26125 | 20771 | 1203 |
577829 | 577829 | 2020-09-28 | Oakland | Michigan | 26125 | 20650 | 1201 |
574588 | 574588 | 2020-09-27 | Oakland | Michigan | 26125 | 20543 | 1200 |
571345 | 571345 | 2020-09-26 | Oakland | Michigan | 26125 | 20543 | 1200 |
568103 | 568103 | 2020-09-25 | Oakland | Michigan | 26125 | 20442 | 1196 |
564863 | 564863 | 2020-09-24 | Oakland | Michigan | 26125 | 20346 | 1196 |
561623 | 561623 | 2020-09-23 | Oakland | Michigan | 26125 | 20235 | 1196 |
558386 | 558386 | 2020-09-22 | Oakland | Michigan | 26125 | 20178 | 1195 |
555149 | 555149 | 2020-09-21 | Oakland | Michigan | 26125 | 20089 | 1194 |
551911 | 551911 | 2020-09-20 | Oakland | Michigan | 26125 | 19884 | 1193 |
548672 | 548672 | 2020-09-19 | Oakland | Michigan | 26125 | 19884 | 1193 |
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);