ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Shiawassee" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194426 | 1194426 | 2021-04-06 | Shiawassee | Michigan | 26155 | 4776 | 86 |
1191177 | 1191177 | 2021-04-05 | Shiawassee | Michigan | 26155 | 4736 | 85 |
1187929 | 1187929 | 2021-04-04 | Shiawassee | Michigan | 26155 | 4636 | 85 |
1184682 | 1184682 | 2021-04-03 | Shiawassee | Michigan | 26155 | 4636 | 85 |
1181436 | 1181436 | 2021-04-02 | Shiawassee | Michigan | 26155 | 4569 | 84 |
1178189 | 1178189 | 2021-04-01 | Shiawassee | Michigan | 26155 | 4521 | 84 |
1174942 | 1174942 | 2021-03-31 | Shiawassee | Michigan | 26155 | 4465 | 84 |
1171695 | 1171695 | 2021-03-30 | Shiawassee | Michigan | 26155 | 4405 | 84 |
1168447 | 1168447 | 2021-03-29 | Shiawassee | Michigan | 26155 | 4351 | 84 |
1165199 | 1165199 | 2021-03-28 | Shiawassee | Michigan | 26155 | 4288 | 84 |
1161951 | 1161951 | 2021-03-27 | Shiawassee | Michigan | 26155 | 4288 | 84 |
1158703 | 1158703 | 2021-03-26 | Shiawassee | Michigan | 26155 | 4259 | 84 |
1155456 | 1155456 | 2021-03-25 | Shiawassee | Michigan | 26155 | 4225 | 84 |
1152209 | 1152209 | 2021-03-24 | Shiawassee | Michigan | 26155 | 4175 | 84 |
1148962 | 1148962 | 2021-03-23 | Shiawassee | Michigan | 26155 | 4143 | 84 |
1145715 | 1145715 | 2021-03-22 | Shiawassee | Michigan | 26155 | 4115 | 84 |
1142468 | 1142468 | 2021-03-21 | Shiawassee | Michigan | 26155 | 4086 | 84 |
1139221 | 1139221 | 2021-03-20 | Shiawassee | Michigan | 26155 | 4086 | 84 |
1135975 | 1135975 | 2021-03-19 | Shiawassee | Michigan | 26155 | 4058 | 83 |
1132729 | 1132729 | 2021-03-18 | Shiawassee | Michigan | 26155 | 4029 | 83 |
1129481 | 1129481 | 2021-03-17 | Shiawassee | Michigan | 26155 | 4011 | 83 |
1126234 | 1126234 | 2021-03-16 | Shiawassee | Michigan | 26155 | 3996 | 83 |
1122988 | 1122988 | 2021-03-15 | Shiawassee | Michigan | 26155 | 3986 | 83 |
1119741 | 1119741 | 2021-03-14 | Shiawassee | Michigan | 26155 | 3968 | 83 |
1116494 | 1116494 | 2021-03-13 | Shiawassee | Michigan | 26155 | 3968 | 83 |
1113248 | 1113248 | 2021-03-12 | Shiawassee | Michigan | 26155 | 3951 | 83 |
1110002 | 1110002 | 2021-03-11 | Shiawassee | Michigan | 26155 | 3936 | 83 |
1106756 | 1106756 | 2021-03-10 | Shiawassee | Michigan | 26155 | 3919 | 81 |
1103510 | 1103510 | 2021-03-09 | Shiawassee | Michigan | 26155 | 3904 | 81 |
1100264 | 1100264 | 2021-03-08 | Shiawassee | Michigan | 26155 | 3901 | 81 |
1097017 | 1097017 | 2021-03-07 | Shiawassee | Michigan | 26155 | 3894 | 81 |
1093770 | 1093770 | 2021-03-06 | Shiawassee | Michigan | 26155 | 3894 | 81 |
1090524 | 1090524 | 2021-03-05 | Shiawassee | Michigan | 26155 | 3879 | 80 |
1087279 | 1087279 | 2021-03-04 | Shiawassee | Michigan | 26155 | 3864 | 80 |
1084034 | 1084034 | 2021-03-03 | Shiawassee | Michigan | 26155 | 3850 | 79 |
1080788 | 1080788 | 2021-03-02 | Shiawassee | Michigan | 26155 | 3831 | 79 |
1077542 | 1077542 | 2021-03-01 | Shiawassee | Michigan | 26155 | 3819 | 79 |
1074296 | 1074296 | 2021-02-28 | Shiawassee | Michigan | 26155 | 3807 | 79 |
1071050 | 1071050 | 2021-02-27 | Shiawassee | Michigan | 26155 | 3807 | 79 |
1067805 | 1067805 | 2021-02-26 | Shiawassee | Michigan | 26155 | 3794 | 78 |
1064560 | 1064560 | 2021-02-25 | Shiawassee | Michigan | 26155 | 3785 | 78 |
1061316 | 1061316 | 2021-02-24 | Shiawassee | Michigan | 26155 | 3775 | 78 |
1058070 | 1058070 | 2021-02-23 | Shiawassee | Michigan | 26155 | 3769 | 78 |
1054824 | 1054824 | 2021-02-22 | Shiawassee | Michigan | 26155 | 3762 | 78 |
1051577 | 1051577 | 2021-02-21 | Shiawassee | Michigan | 26155 | 3746 | 78 |
1048330 | 1048330 | 2021-02-20 | Shiawassee | Michigan | 26155 | 3746 | 78 |
1045084 | 1045084 | 2021-02-19 | Shiawassee | Michigan | 26155 | 3740 | 77 |
1041839 | 1041839 | 2021-02-18 | Shiawassee | Michigan | 26155 | 3733 | 77 |
1038594 | 1038594 | 2021-02-17 | Shiawassee | Michigan | 26155 | 3719 | 76 |
1035349 | 1035349 | 2021-02-16 | Shiawassee | Michigan | 26155 | 3711 | 76 |
1032104 | 1032104 | 2021-02-15 | Shiawassee | Michigan | 26155 | 3706 | 76 |
1028857 | 1028857 | 2021-02-14 | Shiawassee | Michigan | 26155 | 3700 | 75 |
1025611 | 1025611 | 2021-02-13 | Shiawassee | Michigan | 26155 | 3700 | 75 |
1022366 | 1022366 | 2021-02-12 | Shiawassee | Michigan | 26155 | 3688 | 74 |
1019121 | 1019121 | 2021-02-11 | Shiawassee | Michigan | 26155 | 3679 | 74 |
1015876 | 1015876 | 2021-02-10 | Shiawassee | Michigan | 26155 | 3664 | 74 |
1012631 | 1012631 | 2021-02-09 | Shiawassee | Michigan | 26155 | 3650 | 74 |
1009386 | 1009386 | 2021-02-08 | Shiawassee | Michigan | 26155 | 3647 | 74 |
1006139 | 1006139 | 2021-02-07 | Shiawassee | Michigan | 26155 | 3628 | 74 |
1002893 | 1002893 | 2021-02-06 | Shiawassee | Michigan | 26155 | 3628 | 74 |
999648 | 999648 | 2021-02-05 | Shiawassee | Michigan | 26155 | 3623 | 74 |
996402 | 996402 | 2021-02-04 | Shiawassee | Michigan | 26155 | 3609 | 74 |
993156 | 993156 | 2021-02-03 | Shiawassee | Michigan | 26155 | 3602 | 73 |
989910 | 989910 | 2021-02-02 | Shiawassee | Michigan | 26155 | 3583 | 72 |
986663 | 986663 | 2021-02-01 | Shiawassee | Michigan | 26155 | 3575 | 72 |
983416 | 983416 | 2021-01-31 | Shiawassee | Michigan | 26155 | 3557 | 72 |
980170 | 980170 | 2021-01-30 | Shiawassee | Michigan | 26155 | 3557 | 72 |
976924 | 976924 | 2021-01-29 | Shiawassee | Michigan | 26155 | 3538 | 73 |
973679 | 973679 | 2021-01-28 | Shiawassee | Michigan | 26155 | 3533 | 74 |
970434 | 970434 | 2021-01-27 | Shiawassee | Michigan | 26155 | 3522 | 68 |
967189 | 967189 | 2021-01-26 | Shiawassee | Michigan | 26155 | 3507 | 68 |
963945 | 963945 | 2021-01-25 | Shiawassee | Michigan | 26155 | 3496 | 68 |
960700 | 960700 | 2021-01-24 | Shiawassee | Michigan | 26155 | 3461 | 68 |
957454 | 957454 | 2021-01-23 | Shiawassee | Michigan | 26155 | 3461 | 68 |
954209 | 954209 | 2021-01-22 | Shiawassee | Michigan | 26155 | 3454 | 67 |
950964 | 950964 | 2021-01-21 | Shiawassee | Michigan | 26155 | 3432 | 67 |
947718 | 947718 | 2021-01-20 | Shiawassee | Michigan | 26155 | 3405 | 65 |
944471 | 944471 | 2021-01-19 | Shiawassee | Michigan | 26155 | 3375 | 65 |
941226 | 941226 | 2021-01-18 | Shiawassee | Michigan | 26155 | 3366 | 65 |
937981 | 937981 | 2021-01-17 | Shiawassee | Michigan | 26155 | 3328 | 65 |
934736 | 934736 | 2021-01-16 | Shiawassee | Michigan | 26155 | 3328 | 65 |
931491 | 931491 | 2021-01-15 | Shiawassee | Michigan | 26155 | 3315 | 64 |
928246 | 928246 | 2021-01-14 | Shiawassee | Michigan | 26155 | 3298 | 63 |
925000 | 925000 | 2021-01-13 | Shiawassee | Michigan | 26155 | 3274 | 62 |
921755 | 921755 | 2021-01-12 | Shiawassee | Michigan | 26155 | 3252 | 61 |
918510 | 918510 | 2021-01-11 | Shiawassee | Michigan | 26155 | 3224 | 62 |
915265 | 915265 | 2021-01-10 | Shiawassee | Michigan | 26155 | 3181 | 60 |
912020 | 912020 | 2021-01-09 | Shiawassee | Michigan | 26155 | 3181 | 60 |
908775 | 908775 | 2021-01-08 | Shiawassee | Michigan | 26155 | 3150 | 59 |
905529 | 905529 | 2021-01-07 | Shiawassee | Michigan | 26155 | 3126 | 59 |
902284 | 902284 | 2021-01-06 | Shiawassee | Michigan | 26155 | 3088 | 59 |
899039 | 899039 | 2021-01-05 | Shiawassee | Michigan | 26155 | 3060 | 59 |
895794 | 895794 | 2021-01-04 | Shiawassee | Michigan | 26155 | 3047 | 58 |
892547 | 892547 | 2021-01-03 | Shiawassee | Michigan | 26155 | 3012 | 58 |
889301 | 889301 | 2021-01-02 | Shiawassee | Michigan | 26155 | 3012 | 58 |
886055 | 886055 | 2021-01-01 | Shiawassee | Michigan | 26155 | 2954 | 58 |
882810 | 882810 | 2020-12-31 | Shiawassee | Michigan | 26155 | 2954 | 58 |
879565 | 879565 | 2020-12-30 | Shiawassee | Michigan | 26155 | 2954 | 58 |
876320 | 876320 | 2020-12-29 | Shiawassee | Michigan | 26155 | 2918 | 57 |
873075 | 873075 | 2020-12-28 | Shiawassee | Michigan | 26155 | 2895 | 56 |
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);