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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054795 | 1054795 | 2021-02-22 | Livingston | Michigan | 26093 | 10223 | 139 |
1051548 | 1051548 | 2021-02-21 | Livingston | Michigan | 26093 | 10164 | 139 |
1048301 | 1048301 | 2021-02-20 | Livingston | Michigan | 26093 | 10164 | 139 |
1045055 | 1045055 | 2021-02-19 | Livingston | Michigan | 26093 | 10164 | 136 |
1041810 | 1041810 | 2021-02-18 | Livingston | Michigan | 26093 | 10141 | 136 |
1038565 | 1038565 | 2021-02-17 | Livingston | Michigan | 26093 | 10132 | 134 |
1035320 | 1035320 | 2021-02-16 | Livingston | Michigan | 26093 | 10104 | 134 |
1032075 | 1032075 | 2021-02-15 | Livingston | Michigan | 26093 | 10066 | 134 |
1028828 | 1028828 | 2021-02-14 | Livingston | Michigan | 26093 | 10035 | 134 |
1025582 | 1025582 | 2021-02-13 | Livingston | Michigan | 26093 | 10035 | 134 |
1022337 | 1022337 | 2021-02-12 | Livingston | Michigan | 26093 | 10019 | 131 |
1019092 | 1019092 | 2021-02-11 | Livingston | Michigan | 26093 | 10009 | 131 |
1015847 | 1015847 | 2021-02-10 | Livingston | Michigan | 26093 | 9996 | 129 |
1012602 | 1012602 | 2021-02-09 | Livingston | Michigan | 26093 | 9958 | 129 |
1009357 | 1009357 | 2021-02-08 | Livingston | Michigan | 26093 | 9939 | 124 |
1006110 | 1006110 | 2021-02-07 | Livingston | Michigan | 26093 | 9882 | 123 |
1002864 | 1002864 | 2021-02-06 | Livingston | Michigan | 26093 | 9882 | 123 |
999619 | 999619 | 2021-02-05 | Livingston | Michigan | 26093 | 9882 | 121 |
996373 | 996373 | 2021-02-04 | Livingston | Michigan | 26093 | 9861 | 121 |
993127 | 993127 | 2021-02-03 | Livingston | Michigan | 26093 | 9775 | 118 |
989881 | 989881 | 2021-02-02 | Livingston | Michigan | 26093 | 9739 | 116 |
986634 | 986634 | 2021-02-01 | Livingston | Michigan | 26093 | 9720 | 113 |
983387 | 983387 | 2021-01-31 | Livingston | Michigan | 26093 | 9645 | 113 |
980141 | 980141 | 2021-01-30 | Livingston | Michigan | 26093 | 9645 | 113 |
976895 | 976895 | 2021-01-29 | Livingston | Michigan | 26093 | 9645 | 111 |
973650 | 973650 | 2021-01-28 | Livingston | Michigan | 26093 | 9586 | 110 |
970405 | 970405 | 2021-01-27 | Livingston | Michigan | 26093 | 9542 | 106 |
967160 | 967160 | 2021-01-26 | Livingston | Michigan | 26093 | 9494 | 105 |
963916 | 963916 | 2021-01-25 | Livingston | Michigan | 26093 | 9430 | 106 |
960671 | 960671 | 2021-01-24 | Livingston | Michigan | 26093 | 9333 | 104 |
957425 | 957425 | 2021-01-23 | Livingston | Michigan | 26093 | 9333 | 104 |
954180 | 954180 | 2021-01-22 | Livingston | Michigan | 26093 | 9333 | 103 |
950935 | 950935 | 2021-01-21 | Livingston | Michigan | 26093 | 9275 | 104 |
947689 | 947689 | 2021-01-20 | Livingston | Michigan | 26093 | 9174 | 101 |
944442 | 944442 | 2021-01-19 | Livingston | Michigan | 26093 | 9144 | 100 |
941197 | 941197 | 2021-01-18 | Livingston | Michigan | 26093 | 9086 | 96 |
937952 | 937952 | 2021-01-17 | Livingston | Michigan | 26093 | 9001 | 96 |
934707 | 934707 | 2021-01-16 | Livingston | Michigan | 26093 | 9001 | 96 |
931462 | 931462 | 2021-01-15 | Livingston | Michigan | 26093 | 8978 | 95 |
928217 | 928217 | 2021-01-14 | Livingston | Michigan | 26093 | 8920 | 95 |
924971 | 924971 | 2021-01-13 | Livingston | Michigan | 26093 | 8812 | 93 |
921726 | 921726 | 2021-01-12 | Livingston | Michigan | 26093 | 8782 | 92 |
918481 | 918481 | 2021-01-11 | Livingston | Michigan | 26093 | 8718 | 90 |
915236 | 915236 | 2021-01-10 | Livingston | Michigan | 26093 | 8562 | 90 |
911991 | 911991 | 2021-01-09 | Livingston | Michigan | 26093 | 8562 | 90 |
908746 | 908746 | 2021-01-08 | Livingston | Michigan | 26093 | 8533 | 88 |
905500 | 905500 | 2021-01-07 | Livingston | Michigan | 26093 | 8457 | 88 |
902255 | 902255 | 2021-01-06 | Livingston | Michigan | 26093 | 8385 | 82 |
899010 | 899010 | 2021-01-05 | Livingston | Michigan | 26093 | 8271 | 81 |
895765 | 895765 | 2021-01-04 | Livingston | Michigan | 26093 | 8186 | 78 |
892518 | 892518 | 2021-01-03 | Livingston | Michigan | 26093 | 8025 | 77 |
889272 | 889272 | 2021-01-02 | Livingston | Michigan | 26093 | 8025 | 77 |
886026 | 886026 | 2021-01-01 | Livingston | Michigan | 26093 | 7853 | 74 |
882781 | 882781 | 2020-12-31 | Livingston | Michigan | 26093 | 7853 | 74 |
879536 | 879536 | 2020-12-30 | Livingston | Michigan | 26093 | 7853 | 74 |
876291 | 876291 | 2020-12-29 | Livingston | Michigan | 26093 | 7853 | 74 |
873046 | 873046 | 2020-12-28 | Livingston | Michigan | 26093 | 7761 | 72 |
869801 | 869801 | 2020-12-27 | Livingston | Michigan | 26093 | 7655 | 72 |
866556 | 866556 | 2020-12-26 | Livingston | Michigan | 26093 | 7655 | 72 |
863311 | 863311 | 2020-12-25 | Livingston | Michigan | 26093 | 7550 | 72 |
860066 | 860066 | 2020-12-24 | Livingston | Michigan | 26093 | 7550 | 72 |
856821 | 856821 | 2020-12-23 | Livingston | Michigan | 26093 | 7550 | 72 |
853576 | 853576 | 2020-12-22 | Livingston | Michigan | 26093 | 7509 | 67 |
850331 | 850331 | 2020-12-21 | Livingston | Michigan | 26093 | 7504 | 66 |
847086 | 847086 | 2020-12-20 | Livingston | Michigan | 26093 | 7399 | 65 |
843840 | 843840 | 2020-12-19 | Livingston | Michigan | 26093 | 7399 | 65 |
840595 | 840595 | 2020-12-18 | Livingston | Michigan | 26093 | 7399 | 64 |
837350 | 837350 | 2020-12-17 | Livingston | Michigan | 26093 | 7314 | 63 |
834104 | 834104 | 2020-12-16 | Livingston | Michigan | 26093 | 7251 | 59 |
830857 | 830857 | 2020-12-15 | Livingston | Michigan | 26093 | 7201 | 58 |
827611 | 827611 | 2020-12-14 | Livingston | Michigan | 26093 | 7079 | 58 |
824364 | 824364 | 2020-12-13 | Livingston | Michigan | 26093 | 6973 | 58 |
821118 | 821118 | 2020-12-12 | Livingston | Michigan | 26093 | 6973 | 58 |
817872 | 817872 | 2020-12-11 | Livingston | Michigan | 26093 | 6913 | 57 |
814626 | 814626 | 2020-12-10 | Livingston | Michigan | 26093 | 6811 | 57 |
811381 | 811381 | 2020-12-09 | Livingston | Michigan | 26093 | 6677 | 54 |
808136 | 808136 | 2020-12-08 | Livingston | Michigan | 26093 | 6616 | 54 |
804891 | 804891 | 2020-12-07 | Livingston | Michigan | 26093 | 6490 | 53 |
801646 | 801646 | 2020-12-06 | Livingston | Michigan | 26093 | 6290 | 53 |
798401 | 798401 | 2020-12-05 | Livingston | Michigan | 26093 | 6290 | 53 |
795156 | 795156 | 2020-12-04 | Livingston | Michigan | 26093 | 6236 | 53 |
791911 | 791911 | 2020-12-03 | Livingston | Michigan | 26093 | 6118 | 51 |
788666 | 788666 | 2020-12-02 | Livingston | Michigan | 26093 | 5957 | 51 |
785421 | 785421 | 2020-12-01 | Livingston | Michigan | 26093 | 5881 | 51 |
782177 | 782177 | 2020-11-30 | Livingston | Michigan | 26093 | 5746 | 48 |
778931 | 778931 | 2020-11-29 | Livingston | Michigan | 26093 | 5541 | 48 |
775686 | 775686 | 2020-11-28 | Livingston | Michigan | 26093 | 5541 | 48 |
772441 | 772441 | 2020-11-27 | Livingston | Michigan | 26093 | 5336 | 47 |
769196 | 769196 | 2020-11-26 | Livingston | Michigan | 26093 | 4998 | 46 |
765950 | 765950 | 2020-11-25 | Livingston | Michigan | 26093 | 4998 | 46 |
762705 | 762705 | 2020-11-24 | Livingston | Michigan | 26093 | 4934 | 45 |
759460 | 759460 | 2020-11-23 | Livingston | Michigan | 26093 | 4787 | 43 |
756213 | 756213 | 2020-11-22 | Livingston | Michigan | 26093 | 4560 | 43 |
752967 | 752967 | 2020-11-21 | Livingston | Michigan | 26093 | 4560 | 43 |
749721 | 749721 | 2020-11-20 | Livingston | Michigan | 26093 | 4401 | 41 |
746475 | 746475 | 2020-11-19 | Livingston | Michigan | 26093 | 4125 | 41 |
743228 | 743228 | 2020-11-18 | Livingston | Michigan | 26093 | 4016 | 40 |
739981 | 739981 | 2020-11-17 | Livingston | Michigan | 26093 | 3979 | 38 |
736737 | 736737 | 2020-11-16 | Livingston | Michigan | 26093 | 3802 | 37 |
733491 | 733491 | 2020-11-15 | Livingston | Michigan | 26093 | 3575 | 36 |
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);