ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Branch" and state = "Michigan" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
22626 | 22626 | 2020-03-31 | Branch | Michigan | 26023 | 2 | 0 |
24805 | 24805 | 2020-04-01 | Branch | Michigan | 26023 | 2 | 0 |
27057 | 27057 | 2020-04-02 | Branch | Michigan | 26023 | 5 | 0 |
29375 | 29375 | 2020-04-03 | Branch | Michigan | 26023 | 6 | 0 |
31753 | 31753 | 2020-04-04 | Branch | Michigan | 26023 | 10 | 1 |
34178 | 34178 | 2020-04-05 | Branch | Michigan | 26023 | 13 | 1 |
36637 | 36637 | 2020-04-06 | Branch | Michigan | 26023 | 15 | 1 |
39145 | 39145 | 2020-04-07 | Branch | Michigan | 26023 | 16 | 1 |
41697 | 41697 | 2020-04-08 | Branch | Michigan | 26023 | 18 | 1 |
44273 | 44273 | 2020-04-09 | Branch | Michigan | 26023 | 24 | 1 |
46881 | 46881 | 2020-04-10 | Branch | Michigan | 26023 | 25 | 2 |
49524 | 49524 | 2020-04-11 | Branch | Michigan | 26023 | 26 | 2 |
52194 | 52194 | 2020-04-12 | Branch | Michigan | 26023 | 27 | 2 |
54875 | 54875 | 2020-04-13 | Branch | Michigan | 26023 | 29 | 2 |
57573 | 57573 | 2020-04-14 | Branch | Michigan | 26023 | 29 | 2 |
60283 | 60283 | 2020-04-15 | Branch | Michigan | 26023 | 106 | 4 |
63005 | 63005 | 2020-04-16 | Branch | Michigan | 26023 | 116 | 4 |
65743 | 65743 | 2020-04-17 | Branch | Michigan | 26023 | 120 | 4 |
68494 | 68494 | 2020-04-18 | Branch | Michigan | 26023 | 120 | 4 |
71258 | 71258 | 2020-04-19 | Branch | Michigan | 26023 | 134 | 7 |
74030 | 74030 | 2020-04-20 | Branch | Michigan | 26023 | 152 | 7 |
76810 | 76810 | 2020-04-21 | Branch | Michigan | 26023 | 155 | 7 |
79596 | 79596 | 2020-04-22 | Branch | Michigan | 26023 | 250 | 10 |
82391 | 82391 | 2020-04-23 | Branch | Michigan | 26023 | 252 | 10 |
85195 | 85195 | 2020-04-24 | Branch | Michigan | 26023 | 439 | 11 |
88005 | 88005 | 2020-04-25 | Branch | Michigan | 26023 | 689 | 12 |
90821 | 90821 | 2020-04-26 | Branch | Michigan | 26023 | 825 | 13 |
93642 | 93642 | 2020-04-27 | Branch | Michigan | 26023 | 835 | 13 |
96477 | 96477 | 2020-04-28 | Branch | Michigan | 26023 | 838 | 15 |
99323 | 99323 | 2020-04-29 | Branch | Michigan | 26023 | 841 | 15 |
102175 | 102175 | 2020-04-30 | Branch | Michigan | 26023 | 850 | 16 |
105035 | 105035 | 2020-05-01 | Branch | Michigan | 26023 | 853 | 16 |
107899 | 107899 | 2020-05-02 | Branch | Michigan | 26023 | 855 | 16 |
113649 | 113649 | 2020-05-04 | Branch | Michigan | 26023 | 857 | 16 |
110771 | 110771 | 2020-05-03 | Branch | Michigan | 26023 | 859 | 16 |
116530 | 116530 | 2020-05-05 | Branch | Michigan | 26023 | 861 | 17 |
119491 | 119491 | 2020-05-06 | Branch | Michigan | 26023 | 863 | 18 |
122463 | 122463 | 2020-05-07 | Branch | Michigan | 26023 | 864 | 18 |
125445 | 125445 | 2020-05-08 | Branch | Michigan | 26023 | 867 | 20 |
128432 | 128432 | 2020-05-09 | Branch | Michigan | 26023 | 870 | 20 |
131422 | 131422 | 2020-05-10 | Branch | Michigan | 26023 | 870 | 20 |
134413 | 134413 | 2020-05-11 | Branch | Michigan | 26023 | 871 | 21 |
137403 | 137403 | 2020-05-12 | Branch | Michigan | 26023 | 873 | 21 |
140397 | 140397 | 2020-05-13 | Branch | Michigan | 26023 | 875 | 22 |
143392 | 143392 | 2020-05-14 | Branch | Michigan | 26023 | 881 | 22 |
146392 | 146392 | 2020-05-15 | Branch | Michigan | 26023 | 883 | 22 |
149397 | 149397 | 2020-05-16 | Branch | Michigan | 26023 | 886 | 22 |
152408 | 152408 | 2020-05-17 | Branch | Michigan | 26023 | 887 | 22 |
155422 | 155422 | 2020-05-18 | Branch | Michigan | 26023 | 888 | 23 |
158440 | 158440 | 2020-05-19 | Branch | Michigan | 26023 | 888 | 24 |
161466 | 161466 | 2020-05-20 | Branch | Michigan | 26023 | 890 | 24 |
164495 | 164495 | 2020-05-21 | Branch | Michigan | 26023 | 891 | 24 |
167531 | 167531 | 2020-05-22 | Branch | Michigan | 26023 | 892 | 24 |
170568 | 170568 | 2020-05-23 | Branch | Michigan | 26023 | 893 | 24 |
173610 | 173610 | 2020-05-24 | Branch | Michigan | 26023 | 894 | 24 |
176653 | 176653 | 2020-05-25 | Branch | Michigan | 26023 | 895 | 24 |
179697 | 179697 | 2020-05-26 | Branch | Michigan | 26023 | 896 | 24 |
182743 | 182743 | 2020-05-27 | Branch | Michigan | 26023 | 898 | 24 |
185798 | 185798 | 2020-05-28 | Branch | Michigan | 26023 | 902 | 24 |
188856 | 188856 | 2020-05-29 | Branch | Michigan | 26023 | 904 | 24 |
191920 | 191920 | 2020-05-30 | Branch | Michigan | 26023 | 910 | 24 |
194988 | 194988 | 2020-05-31 | Branch | Michigan | 26023 | 914 | 25 |
198059 | 198059 | 2020-06-01 | Branch | Michigan | 26023 | 916 | 25 |
201131 | 201131 | 2020-06-02 | Branch | Michigan | 26023 | 917 | 25 |
204208 | 204208 | 2020-06-03 | Branch | Michigan | 26023 | 917 | 25 |
207289 | 207289 | 2020-06-04 | Branch | Michigan | 26023 | 919 | 25 |
210370 | 210370 | 2020-06-05 | Branch | Michigan | 26023 | 932 | 25 |
213454 | 213454 | 2020-06-06 | Branch | Michigan | 26023 | 940 | 25 |
216542 | 216542 | 2020-06-07 | Branch | Michigan | 26023 | 942 | 25 |
219634 | 219634 | 2020-06-08 | Branch | Michigan | 26023 | 944 | 25 |
222729 | 222729 | 2020-06-09 | Branch | Michigan | 26023 | 946 | 25 |
225826 | 225826 | 2020-06-10 | Branch | Michigan | 26023 | 948 | 25 |
228928 | 228928 | 2020-06-11 | Branch | Michigan | 26023 | 953 | 25 |
232032 | 232032 | 2020-06-12 | Branch | Michigan | 26023 | 954 | 25 |
235137 | 235137 | 2020-06-13 | Branch | Michigan | 26023 | 957 | 25 |
238244 | 238244 | 2020-06-14 | Branch | Michigan | 26023 | 1028 | 25 |
241353 | 241353 | 2020-06-15 | Branch | Michigan | 26023 | 1028 | 25 |
244464 | 244464 | 2020-06-16 | Branch | Michigan | 26023 | 1030 | 25 |
247577 | 247577 | 2020-06-17 | Branch | Michigan | 26023 | 1031 | 25 |
250689 | 250689 | 2020-06-18 | Branch | Michigan | 26023 | 1032 | 25 |
253804 | 253804 | 2020-06-19 | Branch | Michigan | 26023 | 1040 | 25 |
256924 | 256924 | 2020-06-20 | Branch | Michigan | 26023 | 1043 | 25 |
260050 | 260050 | 2020-06-21 | Branch | Michigan | 26023 | 1043 | 25 |
263179 | 263179 | 2020-06-22 | Branch | Michigan | 26023 | 1043 | 25 |
266305 | 266305 | 2020-06-23 | Branch | Michigan | 26023 | 1043 | 25 |
269438 | 269438 | 2020-06-24 | Branch | Michigan | 26023 | 1047 | 25 |
272575 | 272575 | 2020-06-25 | Branch | Michigan | 26023 | 1047 | 25 |
275718 | 275718 | 2020-06-26 | Branch | Michigan | 26023 | 1047 | 25 |
278866 | 278866 | 2020-06-27 | Branch | Michigan | 26023 | 1048 | 25 |
282014 | 282014 | 2020-06-28 | Branch | Michigan | 26023 | 1050 | 25 |
285159 | 285159 | 2020-06-29 | Branch | Michigan | 26023 | 1050 | 25 |
288309 | 288309 | 2020-06-30 | Branch | Michigan | 26023 | 1050 | 25 |
291460 | 291460 | 2020-07-01 | Branch | Michigan | 26023 | 1050 | 25 |
294614 | 294614 | 2020-07-02 | Branch | Michigan | 26023 | 1050 | 25 |
297772 | 297772 | 2020-07-03 | Branch | Michigan | 26023 | 1053 | 25 |
300934 | 300934 | 2020-07-04 | Branch | Michigan | 26023 | 1053 | 25 |
304098 | 304098 | 2020-07-05 | Branch | Michigan | 26023 | 1053 | 25 |
307265 | 307265 | 2020-07-06 | Branch | Michigan | 26023 | 1053 | 25 |
310433 | 310433 | 2020-07-07 | Branch | Michigan | 26023 | 1053 | 25 |
313603 | 313603 | 2020-07-08 | Branch | Michigan | 26023 | 1058 | 25 |
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);