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 |
---|---|---|---|---|---|---|---|
636189 | 636189 | 2020-10-16 | Oakland | Michigan | 26125 | 22752 | 1224 |
632943 | 632943 | 2020-10-15 | Oakland | Michigan | 26125 | 22571 | 1224 |
629698 | 629698 | 2020-10-14 | Oakland | Michigan | 26125 | 22324 | 1222 |
626454 | 626454 | 2020-10-13 | Oakland | Michigan | 26125 | 22179 | 1222 |
623212 | 623212 | 2020-10-12 | Oakland | Michigan | 26125 | 22033 | 1221 |
619969 | 619969 | 2020-10-11 | Oakland | Michigan | 26125 | 21878 | 1220 |
616727 | 616727 | 2020-10-10 | Oakland | Michigan | 26125 | 21878 | 1220 |
613486 | 613486 | 2020-10-09 | Oakland | Michigan | 26125 | 21730 | 1215 |
610244 | 610244 | 2020-10-08 | Oakland | Michigan | 26125 | 21592 | 1214 |
607002 | 607002 | 2020-10-07 | Oakland | Michigan | 26125 | 21464 | 1210 |
603759 | 603759 | 2020-10-06 | Oakland | Michigan | 26125 | 21358 | 1211 |
600517 | 600517 | 2020-10-05 | Oakland | Michigan | 26125 | 21241 | 1207 |
597274 | 597274 | 2020-10-04 | Oakland | Michigan | 26125 | 21107 | 1207 |
594033 | 594033 | 2020-10-03 | Oakland | Michigan | 26125 | 21107 | 1207 |
590792 | 590792 | 2020-10-02 | Oakland | Michigan | 26125 | 20993 | 1206 |
587551 | 587551 | 2020-10-01 | Oakland | Michigan | 26125 | 20922 | 1206 |
584311 | 584311 | 2020-09-30 | Oakland | Michigan | 26125 | 20854 | 1203 |
581070 | 581070 | 2020-09-29 | Oakland | Michigan | 26125 | 20771 | 1203 |
577829 | 577829 | 2020-09-28 | Oakland | Michigan | 26125 | 20650 | 1201 |
574588 | 574588 | 2020-09-27 | Oakland | Michigan | 26125 | 20543 | 1200 |
571345 | 571345 | 2020-09-26 | Oakland | Michigan | 26125 | 20543 | 1200 |
568103 | 568103 | 2020-09-25 | Oakland | Michigan | 26125 | 20442 | 1196 |
564863 | 564863 | 2020-09-24 | Oakland | Michigan | 26125 | 20346 | 1196 |
561623 | 561623 | 2020-09-23 | Oakland | Michigan | 26125 | 20235 | 1196 |
558386 | 558386 | 2020-09-22 | Oakland | Michigan | 26125 | 20178 | 1195 |
555149 | 555149 | 2020-09-21 | Oakland | Michigan | 26125 | 20089 | 1194 |
551911 | 551911 | 2020-09-20 | Oakland | Michigan | 26125 | 19884 | 1193 |
548672 | 548672 | 2020-09-19 | Oakland | Michigan | 26125 | 19884 | 1193 |
545434 | 545434 | 2020-09-18 | Oakland | Michigan | 26125 | 19828 | 1191 |
542197 | 542197 | 2020-09-17 | Oakland | Michigan | 26125 | 19751 | 1192 |
538961 | 538961 | 2020-09-16 | Oakland | Michigan | 26125 | 19624 | 1189 |
535724 | 535724 | 2020-09-15 | Oakland | Michigan | 26125 | 19549 | 1188 |
532489 | 532489 | 2020-09-14 | Oakland | Michigan | 26125 | 19466 | 1185 |
529253 | 529253 | 2020-09-13 | Oakland | Michigan | 26125 | 19348 | 1184 |
526017 | 526017 | 2020-09-12 | Oakland | Michigan | 26125 | 19348 | 1184 |
522781 | 522781 | 2020-09-11 | Oakland | Michigan | 26125 | 19272 | 1183 |
519544 | 519544 | 2020-09-10 | Oakland | Michigan | 26125 | 18972 | 1181 |
516309 | 516309 | 2020-09-09 | Oakland | Michigan | 26125 | 18888 | 1179 |
513075 | 513075 | 2020-09-08 | Oakland | Michigan | 26125 | 18746 | 1172 |
509843 | 509843 | 2020-09-07 | Oakland | Michigan | 26125 | 18672 | 1172 |
506610 | 506610 | 2020-09-06 | Oakland | Michigan | 26125 | 18513 | 1171 |
503377 | 503377 | 2020-09-05 | Oakland | Michigan | 26125 | 18513 | 1171 |
500143 | 500143 | 2020-09-04 | Oakland | Michigan | 26125 | 18455 | 1170 |
496909 | 496909 | 2020-09-03 | Oakland | Michigan | 26125 | 18351 | 1169 |
493676 | 493676 | 2020-09-02 | Oakland | Michigan | 26125 | 18247 | 1165 |
490442 | 490442 | 2020-09-01 | Oakland | Michigan | 26125 | 18168 | 1165 |
487209 | 487209 | 2020-08-31 | Oakland | Michigan | 26125 | 18053 | 1163 |
483975 | 483975 | 2020-08-30 | Oakland | Michigan | 26125 | 17996 | 1163 |
480740 | 480740 | 2020-08-29 | Oakland | Michigan | 26125 | 17922 | 1162 |
477508 | 477508 | 2020-08-28 | Oakland | Michigan | 26125 | 17794 | 1157 |
474275 | 474275 | 2020-08-27 | Oakland | Michigan | 26125 | 17694 | 1157 |
471043 | 471043 | 2020-08-26 | Oakland | Michigan | 26125 | 17579 | 1156 |
467813 | 467813 | 2020-08-25 | Oakland | Michigan | 26125 | 17459 | 1155 |
464584 | 464584 | 2020-08-24 | Oakland | Michigan | 26125 | 17358 | 1152 |
461353 | 461353 | 2020-08-23 | Oakland | Michigan | 26125 | 17225 | 1152 |
458126 | 458126 | 2020-08-22 | Oakland | Michigan | 26125 | 17106 | 1151 |
454898 | 454898 | 2020-08-21 | Oakland | Michigan | 26125 | 16885 | 1146 |
451670 | 451670 | 2020-08-20 | Oakland | Michigan | 26125 | 16885 | 1146 |
448442 | 448442 | 2020-08-19 | Oakland | Michigan | 26125 | 16794 | 1144 |
445216 | 445216 | 2020-08-18 | Oakland | Michigan | 26125 | 16641 | 1144 |
441990 | 441990 | 2020-08-17 | Oakland | Michigan | 26125 | 16547 | 1142 |
438763 | 438763 | 2020-08-16 | Oakland | Michigan | 26125 | 16469 | 1141 |
435538 | 435538 | 2020-08-15 | Oakland | Michigan | 26125 | 16378 | 1140 |
432312 | 432312 | 2020-08-14 | Oakland | Michigan | 26125 | 16236 | 1136 |
429085 | 429085 | 2020-08-13 | Oakland | Michigan | 26125 | 16083 | 1136 |
425861 | 425861 | 2020-08-12 | Oakland | Michigan | 26125 | 15876 | 1133 |
422639 | 422639 | 2020-08-11 | Oakland | Michigan | 26125 | 15751 | 1131 |
419417 | 419417 | 2020-08-10 | Oakland | Michigan | 26125 | 15615 | 1129 |
416196 | 416196 | 2020-08-09 | Oakland | Michigan | 26125 | 15501 | 1129 |
412976 | 412976 | 2020-08-08 | Oakland | Michigan | 26125 | 15427 | 1129 |
409756 | 409756 | 2020-08-07 | Oakland | Michigan | 26125 | 15292 | 1133 |
406536 | 406536 | 2020-08-06 | Oakland | Michigan | 26125 | 15176 | 1129 |
403318 | 403318 | 2020-08-05 | Oakland | Michigan | 26125 | 15030 | 1127 |
400101 | 400101 | 2020-08-04 | Oakland | Michigan | 26125 | 14950 | 1126 |
396887 | 396887 | 2020-08-03 | Oakland | Michigan | 26125 | 14861 | 1126 |
393671 | 393671 | 2020-08-02 | Oakland | Michigan | 26125 | 14777 | 1126 |
390454 | 390454 | 2020-08-01 | Oakland | Michigan | 26125 | 14721 | 1126 |
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 |
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);