ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Barry" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194358 | 1194358 | 2021-04-06 | Barry | Michigan | 26015 | 4430 | 53 |
1191109 | 1191109 | 2021-04-05 | Barry | Michigan | 26015 | 4395 | 52 |
1187861 | 1187861 | 2021-04-04 | Barry | Michigan | 26015 | 4344 | 52 |
1184614 | 1184614 | 2021-04-03 | Barry | Michigan | 26015 | 4344 | 52 |
1181368 | 1181368 | 2021-04-02 | Barry | Michigan | 26015 | 4301 | 52 |
1178121 | 1178121 | 2021-04-01 | Barry | Michigan | 26015 | 4266 | 52 |
1174874 | 1174874 | 2021-03-31 | Barry | Michigan | 26015 | 4236 | 52 |
1171627 | 1171627 | 2021-03-30 | Barry | Michigan | 26015 | 4196 | 52 |
1168379 | 1168379 | 2021-03-29 | Barry | Michigan | 26015 | 4170 | 50 |
1165131 | 1165131 | 2021-03-28 | Barry | Michigan | 26015 | 4117 | 50 |
1161883 | 1161883 | 2021-03-27 | Barry | Michigan | 26015 | 4117 | 50 |
1158635 | 1158635 | 2021-03-26 | Barry | Michigan | 26015 | 4096 | 50 |
1155388 | 1155388 | 2021-03-25 | Barry | Michigan | 26015 | 4065 | 50 |
1152141 | 1152141 | 2021-03-24 | Barry | Michigan | 26015 | 4039 | 50 |
1148894 | 1148894 | 2021-03-23 | Barry | Michigan | 26015 | 4015 | 50 |
1145647 | 1145647 | 2021-03-22 | Barry | Michigan | 26015 | 3994 | 50 |
1142400 | 1142400 | 2021-03-21 | Barry | Michigan | 26015 | 3969 | 49 |
1139153 | 1139153 | 2021-03-20 | Barry | Michigan | 26015 | 3969 | 49 |
1135907 | 1135907 | 2021-03-19 | Barry | Michigan | 26015 | 3957 | 49 |
1132661 | 1132661 | 2021-03-18 | Barry | Michigan | 26015 | 3938 | 49 |
1129413 | 1129413 | 2021-03-17 | Barry | Michigan | 26015 | 3920 | 49 |
1126166 | 1126166 | 2021-03-16 | Barry | Michigan | 26015 | 3912 | 49 |
1122920 | 1122920 | 2021-03-15 | Barry | Michigan | 26015 | 3897 | 49 |
1119673 | 1119673 | 2021-03-14 | Barry | Michigan | 26015 | 3879 | 49 |
1116426 | 1116426 | 2021-03-13 | Barry | Michigan | 26015 | 3879 | 49 |
1113180 | 1113180 | 2021-03-12 | Barry | Michigan | 26015 | 3869 | 49 |
1109934 | 1109934 | 2021-03-11 | Barry | Michigan | 26015 | 3862 | 48 |
1106688 | 1106688 | 2021-03-10 | Barry | Michigan | 26015 | 3855 | 48 |
1103442 | 1103442 | 2021-03-09 | Barry | Michigan | 26015 | 3838 | 48 |
1100196 | 1100196 | 2021-03-08 | Barry | Michigan | 26015 | 3833 | 47 |
1096949 | 1096949 | 2021-03-07 | Barry | Michigan | 26015 | 3821 | 47 |
1093702 | 1093702 | 2021-03-06 | Barry | Michigan | 26015 | 3821 | 47 |
1090456 | 1090456 | 2021-03-05 | Barry | Michigan | 26015 | 3809 | 46 |
1087211 | 1087211 | 2021-03-04 | Barry | Michigan | 26015 | 3799 | 46 |
1083966 | 1083966 | 2021-03-03 | Barry | Michigan | 26015 | 3790 | 45 |
1080720 | 1080720 | 2021-03-02 | Barry | Michigan | 26015 | 3781 | 45 |
1077474 | 1077474 | 2021-03-01 | Barry | Michigan | 26015 | 3775 | 45 |
1074228 | 1074228 | 2021-02-28 | Barry | Michigan | 26015 | 3757 | 44 |
1070982 | 1070982 | 2021-02-27 | Barry | Michigan | 26015 | 3757 | 44 |
1067737 | 1067737 | 2021-02-26 | Barry | Michigan | 26015 | 3749 | 44 |
1064492 | 1064492 | 2021-02-25 | Barry | Michigan | 26015 | 3742 | 44 |
1061248 | 1061248 | 2021-02-24 | Barry | Michigan | 26015 | 3737 | 43 |
1058002 | 1058002 | 2021-02-23 | Barry | Michigan | 26015 | 3722 | 43 |
1054756 | 1054756 | 2021-02-22 | Barry | Michigan | 26015 | 3712 | 43 |
1051509 | 1051509 | 2021-02-21 | Barry | Michigan | 26015 | 3700 | 42 |
1048262 | 1048262 | 2021-02-20 | Barry | Michigan | 26015 | 3700 | 42 |
1045016 | 1045016 | 2021-02-19 | Barry | Michigan | 26015 | 3690 | 42 |
1041771 | 1041771 | 2021-02-18 | Barry | Michigan | 26015 | 3680 | 42 |
1038526 | 1038526 | 2021-02-17 | Barry | Michigan | 26015 | 3669 | 42 |
1035281 | 1035281 | 2021-02-16 | Barry | Michigan | 26015 | 3657 | 42 |
1032036 | 1032036 | 2021-02-15 | Barry | Michigan | 26015 | 3647 | 42 |
1028789 | 1028789 | 2021-02-14 | Barry | Michigan | 26015 | 3642 | 41 |
1025543 | 1025543 | 2021-02-13 | Barry | Michigan | 26015 | 3642 | 41 |
1022298 | 1022298 | 2021-02-12 | Barry | Michigan | 26015 | 3640 | 41 |
1019053 | 1019053 | 2021-02-11 | Barry | Michigan | 26015 | 3629 | 41 |
1015808 | 1015808 | 2021-02-10 | Barry | Michigan | 26015 | 3621 | 41 |
1012563 | 1012563 | 2021-02-09 | Barry | Michigan | 26015 | 3616 | 41 |
1009318 | 1009318 | 2021-02-08 | Barry | Michigan | 26015 | 3610 | 41 |
1006071 | 1006071 | 2021-02-07 | Barry | Michigan | 26015 | 3603 | 41 |
1002825 | 1002825 | 2021-02-06 | Barry | Michigan | 26015 | 3603 | 41 |
999580 | 999580 | 2021-02-05 | Barry | Michigan | 26015 | 3594 | 42 |
996334 | 996334 | 2021-02-04 | Barry | Michigan | 26015 | 3591 | 41 |
993088 | 993088 | 2021-02-03 | Barry | Michigan | 26015 | 3583 | 41 |
989842 | 989842 | 2021-02-02 | Barry | Michigan | 26015 | 3565 | 41 |
986595 | 986595 | 2021-02-01 | Barry | Michigan | 26015 | 3550 | 40 |
983348 | 983348 | 2021-01-31 | Barry | Michigan | 26015 | 3538 | 40 |
980102 | 980102 | 2021-01-30 | Barry | Michigan | 26015 | 3538 | 40 |
976856 | 976856 | 2021-01-29 | Barry | Michigan | 26015 | 3527 | 40 |
973611 | 973611 | 2021-01-28 | Barry | Michigan | 26015 | 3502 | 40 |
970366 | 970366 | 2021-01-27 | Barry | Michigan | 26015 | 3490 | 40 |
967121 | 967121 | 2021-01-26 | Barry | Michigan | 26015 | 3475 | 40 |
963877 | 963877 | 2021-01-25 | Barry | Michigan | 26015 | 3461 | 40 |
960632 | 960632 | 2021-01-24 | Barry | Michigan | 26015 | 3433 | 40 |
957386 | 957386 | 2021-01-23 | Barry | Michigan | 26015 | 3433 | 40 |
954141 | 954141 | 2021-01-22 | Barry | Michigan | 26015 | 3424 | 40 |
950896 | 950896 | 2021-01-21 | Barry | Michigan | 26015 | 3409 | 40 |
947650 | 947650 | 2021-01-20 | Barry | Michigan | 26015 | 3374 | 39 |
944403 | 944403 | 2021-01-19 | Barry | Michigan | 26015 | 3358 | 39 |
941158 | 941158 | 2021-01-18 | Barry | Michigan | 26015 | 3353 | 39 |
937913 | 937913 | 2021-01-17 | Barry | Michigan | 26015 | 3323 | 39 |
934668 | 934668 | 2021-01-16 | Barry | Michigan | 26015 | 3323 | 39 |
931423 | 931423 | 2021-01-15 | Barry | Michigan | 26015 | 3314 | 38 |
928178 | 928178 | 2021-01-14 | Barry | Michigan | 26015 | 3294 | 38 |
924932 | 924932 | 2021-01-13 | Barry | Michigan | 26015 | 3265 | 38 |
921687 | 921687 | 2021-01-12 | Barry | Michigan | 26015 | 3240 | 38 |
918442 | 918442 | 2021-01-11 | Barry | Michigan | 26015 | 3216 | 38 |
915197 | 915197 | 2021-01-10 | Barry | Michigan | 26015 | 3177 | 38 |
911952 | 911952 | 2021-01-09 | Barry | Michigan | 26015 | 3177 | 38 |
908707 | 908707 | 2021-01-08 | Barry | Michigan | 26015 | 3153 | 38 |
905461 | 905461 | 2021-01-07 | Barry | Michigan | 26015 | 3142 | 38 |
902216 | 902216 | 2021-01-06 | Barry | Michigan | 26015 | 3110 | 38 |
898971 | 898971 | 2021-01-05 | Barry | Michigan | 26015 | 3081 | 38 |
895726 | 895726 | 2021-01-04 | Barry | Michigan | 26015 | 3056 | 35 |
892479 | 892479 | 2021-01-03 | Barry | Michigan | 26015 | 3012 | 35 |
889233 | 889233 | 2021-01-02 | Barry | Michigan | 26015 | 3012 | 35 |
885987 | 885987 | 2021-01-01 | Barry | Michigan | 26015 | 2968 | 34 |
882742 | 882742 | 2020-12-31 | Barry | Michigan | 26015 | 2968 | 34 |
879497 | 879497 | 2020-12-30 | Barry | Michigan | 26015 | 2968 | 34 |
876252 | 876252 | 2020-12-29 | Barry | Michigan | 26015 | 2946 | 34 |
873007 | 873007 | 2020-12-28 | Barry | Michigan | 26015 | 2907 | 34 |
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);