ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Oakland" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387237 | 387237 | 2020-07-31 | Oakland | Michigan | 26125 | 14614 | 1126 |
384019 | 384019 | 2020-07-30 | Oakland | Michigan | 26125 | 14494 | 1126 |
380802 | 380802 | 2020-07-29 | Oakland | Michigan | 26125 | 14362 | 1122 |
377585 | 377585 | 2020-07-28 | Oakland | Michigan | 26125 | 14200 | 1126 |
374370 | 374370 | 2020-07-27 | Oakland | Michigan | 26125 | 14111 | 1127 |
371158 | 371158 | 2020-07-26 | Oakland | Michigan | 26125 | 14035 | 1127 |
367948 | 367948 | 2020-07-25 | Oakland | Michigan | 26125 | 13823 | 1127 |
364741 | 364741 | 2020-07-24 | Oakland | Michigan | 26125 | 13782 | 1125 |
361534 | 361534 | 2020-07-23 | Oakland | Michigan | 26125 | 13711 | 1122 |
358329 | 358329 | 2020-07-22 | Oakland | Michigan | 26125 | 13644 | 1121 |
355126 | 355126 | 2020-07-21 | Oakland | Michigan | 26125 | 13492 | 1119 |
351924 | 351924 | 2020-07-20 | Oakland | Michigan | 26125 | 13442 | 1117 |
348724 | 348724 | 2020-07-19 | Oakland | Michigan | 26125 | 13398 | 1114 |
345523 | 345523 | 2020-07-18 | Oakland | Michigan | 26125 | 13329 | 1114 |
342323 | 342323 | 2020-07-17 | Oakland | Michigan | 26125 | 13260 | 1114 |
339127 | 339127 | 2020-07-16 | Oakland | Michigan | 26125 | 13171 | 1113 |
335931 | 335931 | 2020-07-15 | Oakland | Michigan | 26125 | 13022 | 1110 |
332738 | 332738 | 2020-07-14 | Oakland | Michigan | 26125 | 12814 | 1109 |
329551 | 329551 | 2020-07-13 | Oakland | Michigan | 26125 | 12752 | 1109 |
326365 | 326365 | 2020-07-12 | Oakland | Michigan | 26125 | 12700 | 1108 |
323182 | 323182 | 2020-07-11 | Oakland | Michigan | 26125 | 12642 | 1108 |
320003 | 320003 | 2020-07-10 | Oakland | Michigan | 26125 | 12568 | 1102 |
316828 | 316828 | 2020-07-09 | Oakland | Michigan | 26125 | 12488 | 1097 |
313654 | 313654 | 2020-07-08 | Oakland | Michigan | 26125 | 12408 | 1096 |
310484 | 310484 | 2020-07-07 | Oakland | Michigan | 26125 | 12320 | 1095 |
307316 | 307316 | 2020-07-06 | Oakland | Michigan | 26125 | 12254 | 1091 |
304149 | 304149 | 2020-07-05 | Oakland | Michigan | 26125 | 12233 | 1091 |
300985 | 300985 | 2020-07-04 | Oakland | Michigan | 26125 | 12208 | 1091 |
297823 | 297823 | 2020-07-03 | Oakland | Michigan | 26125 | 12160 | 1091 |
294665 | 294665 | 2020-07-02 | Oakland | Michigan | 26125 | 12108 | 1091 |
291511 | 291511 | 2020-07-01 | Oakland | Michigan | 26125 | 12051 | 1091 |
288360 | 288360 | 2020-06-30 | Oakland | Michigan | 26125 | 12017 | 1090 |
285210 | 285210 | 2020-06-29 | Oakland | Michigan | 26125 | 11942 | 1085 |
282065 | 282065 | 2020-06-28 | Oakland | Michigan | 26125 | 11916 | 1085 |
278917 | 278917 | 2020-06-27 | Oakland | Michigan | 26125 | 11886 | 1085 |
275769 | 275769 | 2020-06-26 | Oakland | Michigan | 26125 | 11843 | 1084 |
272626 | 272626 | 2020-06-25 | Oakland | Michigan | 26125 | 11826 | 1084 |
269489 | 269489 | 2020-06-24 | Oakland | Michigan | 26125 | 11805 | 1081 |
266356 | 266356 | 2020-06-23 | Oakland | Michigan | 26125 | 11791 | 1081 |
263230 | 263230 | 2020-06-22 | Oakland | Michigan | 26125 | 11740 | 1078 |
260101 | 260101 | 2020-06-21 | Oakland | Michigan | 26125 | 11685 | 1077 |
256975 | 256975 | 2020-06-20 | Oakland | Michigan | 26125 | 11667 | 1076 |
253855 | 253855 | 2020-06-19 | Oakland | Michigan | 26125 | 11485 | 1071 |
250740 | 250740 | 2020-06-18 | Oakland | Michigan | 26125 | 11425 | 1071 |
247628 | 247628 | 2020-06-17 | Oakland | Michigan | 26125 | 11384 | 1069 |
244515 | 244515 | 2020-06-16 | Oakland | Michigan | 26125 | 11372 | 1069 |
241404 | 241404 | 2020-06-15 | Oakland | Michigan | 26125 | 11313 | 1067 |
238295 | 238295 | 2020-06-14 | Oakland | Michigan | 26125 | 11306 | 1067 |
235188 | 235188 | 2020-06-13 | Oakland | Michigan | 26125 | 11298 | 1067 |
232083 | 232083 | 2020-06-12 | Oakland | Michigan | 26125 | 11286 | 1062 |
228979 | 228979 | 2020-06-11 | Oakland | Michigan | 26125 | 11283 | 1061 |
225877 | 225877 | 2020-06-10 | Oakland | Michigan | 26125 | 11262 | 1058 |
222779 | 222779 | 2020-06-09 | Oakland | Michigan | 26125 | 11255 | 1056 |
219684 | 219684 | 2020-06-08 | Oakland | Michigan | 26125 | 11133 | 1056 |
216592 | 216592 | 2020-06-07 | Oakland | Michigan | 26125 | 11005 | 1055 |
213504 | 213504 | 2020-06-06 | Oakland | Michigan | 26125 | 10980 | 1055 |
210420 | 210420 | 2020-06-05 | Oakland | Michigan | 26125 | 10859 | 1048 |
207339 | 207339 | 2020-06-04 | Oakland | Michigan | 26125 | 8438 | 1006 |
204258 | 204258 | 2020-06-03 | Oakland | Michigan | 26125 | 8425 | 1003 |
201181 | 201181 | 2020-06-02 | Oakland | Michigan | 26125 | 8412 | 999 |
198108 | 198108 | 2020-06-01 | Oakland | Michigan | 26125 | 8407 | 992 |
195037 | 195037 | 2020-05-31 | Oakland | Michigan | 26125 | 8396 | 988 |
191969 | 191969 | 2020-05-30 | Oakland | Michigan | 26125 | 8319 | 983 |
188905 | 188905 | 2020-05-29 | Oakland | Michigan | 26125 | 8311 | 975 |
185847 | 185847 | 2020-05-28 | Oakland | Michigan | 26125 | 8281 | 971 |
182792 | 182792 | 2020-05-27 | Oakland | Michigan | 26125 | 8260 | 961 |
179746 | 179746 | 2020-05-26 | Oakland | Michigan | 26125 | 8240 | 958 |
176702 | 176702 | 2020-05-25 | Oakland | Michigan | 26125 | 8226 | 955 |
173659 | 173659 | 2020-05-24 | Oakland | Michigan | 26125 | 8215 | 955 |
170617 | 170617 | 2020-05-23 | Oakland | Michigan | 26125 | 8192 | 954 |
167580 | 167580 | 2020-05-22 | Oakland | Michigan | 26125 | 8131 | 944 |
164544 | 164544 | 2020-05-21 | Oakland | Michigan | 26125 | 8125 | 945 |
161515 | 161515 | 2020-05-20 | Oakland | Michigan | 26125 | 8117 | 935 |
158489 | 158489 | 2020-05-19 | Oakland | Michigan | 26125 | 8078 | 928 |
155471 | 155471 | 2020-05-18 | Oakland | Michigan | 26125 | 8050 | 913 |
152457 | 152457 | 2020-05-17 | Oakland | Michigan | 26125 | 8043 | 912 |
149446 | 149446 | 2020-05-16 | Oakland | Michigan | 26125 | 8023 | 910 |
146441 | 146441 | 2020-05-15 | Oakland | Michigan | 26125 | 7994 | 896 |
143441 | 143441 | 2020-05-14 | Oakland | Michigan | 26125 | 7952 | 888 |
140446 | 140446 | 2020-05-13 | Oakland | Michigan | 26125 | 7830 | 874 |
137452 | 137452 | 2020-05-12 | Oakland | Michigan | 26125 | 7784 | 872 |
134462 | 134462 | 2020-05-11 | Oakland | Michigan | 26125 | 7752 | 849 |
131471 | 131471 | 2020-05-10 | Oakland | Michigan | 26125 | 7736 | 843 |
128481 | 128481 | 2020-05-09 | Oakland | Michigan | 26125 | 7692 | 841 |
125494 | 125494 | 2020-05-08 | Oakland | Michigan | 26125 | 7664 | 805 |
122512 | 122512 | 2020-05-07 | Oakland | Michigan | 26125 | 7624 | 789 |
119540 | 119540 | 2020-05-06 | Oakland | Michigan | 26125 | 7573 | 774 |
116579 | 116579 | 2020-05-05 | Oakland | Michigan | 26125 | 7522 | 772 |
113698 | 113698 | 2020-05-04 | Oakland | Michigan | 26125 | 7499 | 762 |
110820 | 110820 | 2020-05-03 | Oakland | Michigan | 26125 | 7518 | 757 |
107948 | 107948 | 2020-05-02 | Oakland | Michigan | 26125 | 7475 | 745 |
105084 | 105084 | 2020-05-01 | Oakland | Michigan | 26125 | 7423 | 705 |
102224 | 102224 | 2020-04-30 | Oakland | Michigan | 26125 | 7267 | 696 |
99372 | 99372 | 2020-04-29 | Oakland | Michigan | 26125 | 7159 | 668 |
96526 | 96526 | 2020-04-28 | Oakland | Michigan | 26125 | 7012 | 654 |
93691 | 93691 | 2020-04-27 | Oakland | Michigan | 26125 | 6913 | 631 |
90870 | 90870 | 2020-04-26 | Oakland | Michigan | 26125 | 6928 | 620 |
88054 | 88054 | 2020-04-25 | Oakland | Michigan | 26125 | 6881 | 612 |
85244 | 85244 | 2020-04-24 | Oakland | Michigan | 26125 | 6804 | 585 |
82440 | 82440 | 2020-04-23 | Oakland | Michigan | 26125 | 6634 | 567 |
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);