ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 26125 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
250740 | 250740 | 2020-06-18 | Oakland | Michigan | 26125 | 11425 | 1071 |
253855 | 253855 | 2020-06-19 | Oakland | Michigan | 26125 | 11485 | 1071 |
256975 | 256975 | 2020-06-20 | Oakland | Michigan | 26125 | 11667 | 1076 |
260101 | 260101 | 2020-06-21 | Oakland | Michigan | 26125 | 11685 | 1077 |
263230 | 263230 | 2020-06-22 | Oakland | Michigan | 26125 | 11740 | 1078 |
266356 | 266356 | 2020-06-23 | Oakland | Michigan | 26125 | 11791 | 1081 |
269489 | 269489 | 2020-06-24 | Oakland | Michigan | 26125 | 11805 | 1081 |
272626 | 272626 | 2020-06-25 | Oakland | Michigan | 26125 | 11826 | 1084 |
275769 | 275769 | 2020-06-26 | Oakland | Michigan | 26125 | 11843 | 1084 |
278917 | 278917 | 2020-06-27 | Oakland | Michigan | 26125 | 11886 | 1085 |
282065 | 282065 | 2020-06-28 | Oakland | Michigan | 26125 | 11916 | 1085 |
285210 | 285210 | 2020-06-29 | Oakland | Michigan | 26125 | 11942 | 1085 |
288360 | 288360 | 2020-06-30 | Oakland | Michigan | 26125 | 12017 | 1090 |
291511 | 291511 | 2020-07-01 | Oakland | Michigan | 26125 | 12051 | 1091 |
294665 | 294665 | 2020-07-02 | Oakland | Michigan | 26125 | 12108 | 1091 |
297823 | 297823 | 2020-07-03 | Oakland | Michigan | 26125 | 12160 | 1091 |
300985 | 300985 | 2020-07-04 | Oakland | Michigan | 26125 | 12208 | 1091 |
304149 | 304149 | 2020-07-05 | Oakland | Michigan | 26125 | 12233 | 1091 |
307316 | 307316 | 2020-07-06 | Oakland | Michigan | 26125 | 12254 | 1091 |
310484 | 310484 | 2020-07-07 | Oakland | Michigan | 26125 | 12320 | 1095 |
313654 | 313654 | 2020-07-08 | Oakland | Michigan | 26125 | 12408 | 1096 |
316828 | 316828 | 2020-07-09 | Oakland | Michigan | 26125 | 12488 | 1097 |
320003 | 320003 | 2020-07-10 | Oakland | Michigan | 26125 | 12568 | 1102 |
323182 | 323182 | 2020-07-11 | Oakland | Michigan | 26125 | 12642 | 1108 |
326365 | 326365 | 2020-07-12 | Oakland | Michigan | 26125 | 12700 | 1108 |
329551 | 329551 | 2020-07-13 | Oakland | Michigan | 26125 | 12752 | 1109 |
332738 | 332738 | 2020-07-14 | Oakland | Michigan | 26125 | 12814 | 1109 |
335931 | 335931 | 2020-07-15 | Oakland | Michigan | 26125 | 13022 | 1110 |
339127 | 339127 | 2020-07-16 | Oakland | Michigan | 26125 | 13171 | 1113 |
342323 | 342323 | 2020-07-17 | Oakland | Michigan | 26125 | 13260 | 1114 |
345523 | 345523 | 2020-07-18 | Oakland | Michigan | 26125 | 13329 | 1114 |
348724 | 348724 | 2020-07-19 | Oakland | Michigan | 26125 | 13398 | 1114 |
351924 | 351924 | 2020-07-20 | Oakland | Michigan | 26125 | 13442 | 1117 |
355126 | 355126 | 2020-07-21 | Oakland | Michigan | 26125 | 13492 | 1119 |
358329 | 358329 | 2020-07-22 | Oakland | Michigan | 26125 | 13644 | 1121 |
361534 | 361534 | 2020-07-23 | Oakland | Michigan | 26125 | 13711 | 1122 |
364741 | 364741 | 2020-07-24 | Oakland | Michigan | 26125 | 13782 | 1125 |
367948 | 367948 | 2020-07-25 | Oakland | Michigan | 26125 | 13823 | 1127 |
371158 | 371158 | 2020-07-26 | Oakland | Michigan | 26125 | 14035 | 1127 |
374370 | 374370 | 2020-07-27 | Oakland | Michigan | 26125 | 14111 | 1127 |
377585 | 377585 | 2020-07-28 | Oakland | Michigan | 26125 | 14200 | 1126 |
380802 | 380802 | 2020-07-29 | Oakland | Michigan | 26125 | 14362 | 1122 |
384019 | 384019 | 2020-07-30 | Oakland | Michigan | 26125 | 14494 | 1126 |
387237 | 387237 | 2020-07-31 | Oakland | Michigan | 26125 | 14614 | 1126 |
390454 | 390454 | 2020-08-01 | Oakland | Michigan | 26125 | 14721 | 1126 |
393671 | 393671 | 2020-08-02 | Oakland | Michigan | 26125 | 14777 | 1126 |
396887 | 396887 | 2020-08-03 | Oakland | Michigan | 26125 | 14861 | 1126 |
400101 | 400101 | 2020-08-04 | Oakland | Michigan | 26125 | 14950 | 1126 |
403318 | 403318 | 2020-08-05 | Oakland | Michigan | 26125 | 15030 | 1127 |
406536 | 406536 | 2020-08-06 | Oakland | Michigan | 26125 | 15176 | 1129 |
409756 | 409756 | 2020-08-07 | Oakland | Michigan | 26125 | 15292 | 1133 |
412976 | 412976 | 2020-08-08 | Oakland | Michigan | 26125 | 15427 | 1129 |
416196 | 416196 | 2020-08-09 | Oakland | Michigan | 26125 | 15501 | 1129 |
419417 | 419417 | 2020-08-10 | Oakland | Michigan | 26125 | 15615 | 1129 |
422639 | 422639 | 2020-08-11 | Oakland | Michigan | 26125 | 15751 | 1131 |
425861 | 425861 | 2020-08-12 | Oakland | Michigan | 26125 | 15876 | 1133 |
429085 | 429085 | 2020-08-13 | Oakland | Michigan | 26125 | 16083 | 1136 |
432312 | 432312 | 2020-08-14 | Oakland | Michigan | 26125 | 16236 | 1136 |
435538 | 435538 | 2020-08-15 | Oakland | Michigan | 26125 | 16378 | 1140 |
438763 | 438763 | 2020-08-16 | Oakland | Michigan | 26125 | 16469 | 1141 |
441990 | 441990 | 2020-08-17 | Oakland | Michigan | 26125 | 16547 | 1142 |
445216 | 445216 | 2020-08-18 | Oakland | Michigan | 26125 | 16641 | 1144 |
448442 | 448442 | 2020-08-19 | Oakland | Michigan | 26125 | 16794 | 1144 |
451670 | 451670 | 2020-08-20 | Oakland | Michigan | 26125 | 16885 | 1146 |
454898 | 454898 | 2020-08-21 | Oakland | Michigan | 26125 | 16885 | 1146 |
458126 | 458126 | 2020-08-22 | Oakland | Michigan | 26125 | 17106 | 1151 |
461353 | 461353 | 2020-08-23 | Oakland | Michigan | 26125 | 17225 | 1152 |
464584 | 464584 | 2020-08-24 | Oakland | Michigan | 26125 | 17358 | 1152 |
467813 | 467813 | 2020-08-25 | Oakland | Michigan | 26125 | 17459 | 1155 |
471043 | 471043 | 2020-08-26 | Oakland | Michigan | 26125 | 17579 | 1156 |
474275 | 474275 | 2020-08-27 | Oakland | Michigan | 26125 | 17694 | 1157 |
477508 | 477508 | 2020-08-28 | Oakland | Michigan | 26125 | 17794 | 1157 |
480740 | 480740 | 2020-08-29 | Oakland | Michigan | 26125 | 17922 | 1162 |
483975 | 483975 | 2020-08-30 | Oakland | Michigan | 26125 | 17996 | 1163 |
487209 | 487209 | 2020-08-31 | Oakland | Michigan | 26125 | 18053 | 1163 |
490442 | 490442 | 2020-09-01 | Oakland | Michigan | 26125 | 18168 | 1165 |
493676 | 493676 | 2020-09-02 | Oakland | Michigan | 26125 | 18247 | 1165 |
496909 | 496909 | 2020-09-03 | Oakland | Michigan | 26125 | 18351 | 1169 |
500143 | 500143 | 2020-09-04 | Oakland | Michigan | 26125 | 18455 | 1170 |
503377 | 503377 | 2020-09-05 | Oakland | Michigan | 26125 | 18513 | 1171 |
506610 | 506610 | 2020-09-06 | Oakland | Michigan | 26125 | 18513 | 1171 |
509843 | 509843 | 2020-09-07 | Oakland | Michigan | 26125 | 18672 | 1172 |
513075 | 513075 | 2020-09-08 | Oakland | Michigan | 26125 | 18746 | 1172 |
516309 | 516309 | 2020-09-09 | Oakland | Michigan | 26125 | 18888 | 1179 |
519544 | 519544 | 2020-09-10 | Oakland | Michigan | 26125 | 18972 | 1181 |
522781 | 522781 | 2020-09-11 | Oakland | Michigan | 26125 | 19272 | 1183 |
526017 | 526017 | 2020-09-12 | Oakland | Michigan | 26125 | 19348 | 1184 |
529253 | 529253 | 2020-09-13 | Oakland | Michigan | 26125 | 19348 | 1184 |
532489 | 532489 | 2020-09-14 | Oakland | Michigan | 26125 | 19466 | 1185 |
535724 | 535724 | 2020-09-15 | Oakland | Michigan | 26125 | 19549 | 1188 |
538961 | 538961 | 2020-09-16 | Oakland | Michigan | 26125 | 19624 | 1189 |
542197 | 542197 | 2020-09-17 | Oakland | Michigan | 26125 | 19751 | 1192 |
545434 | 545434 | 2020-09-18 | Oakland | Michigan | 26125 | 19828 | 1191 |
548672 | 548672 | 2020-09-19 | Oakland | Michigan | 26125 | 19884 | 1193 |
551911 | 551911 | 2020-09-20 | Oakland | Michigan | 26125 | 19884 | 1193 |
555149 | 555149 | 2020-09-21 | Oakland | Michigan | 26125 | 20089 | 1194 |
558386 | 558386 | 2020-09-22 | Oakland | Michigan | 26125 | 20178 | 1195 |
561623 | 561623 | 2020-09-23 | Oakland | Michigan | 26125 | 20235 | 1196 |
564863 | 564863 | 2020-09-24 | Oakland | Michigan | 26125 | 20346 | 1196 |
568103 | 568103 | 2020-09-25 | Oakland | Michigan | 26125 | 20442 | 1196 |
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);