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 |
---|---|---|---|---|---|---|---|
636134 | 636134 | 2020-10-16 | Barry | Michigan | 26015 | 504 | 5 |
632888 | 632888 | 2020-10-15 | Barry | Michigan | 26015 | 494 | 5 |
629643 | 629643 | 2020-10-14 | Barry | Michigan | 26015 | 476 | 4 |
626399 | 626399 | 2020-10-13 | Barry | Michigan | 26015 | 457 | 5 |
623157 | 623157 | 2020-10-12 | Barry | Michigan | 26015 | 441 | 4 |
619914 | 619914 | 2020-10-11 | Barry | Michigan | 26015 | 414 | 4 |
616672 | 616672 | 2020-10-10 | Barry | Michigan | 26015 | 414 | 4 |
613431 | 613431 | 2020-10-09 | Barry | Michigan | 26015 | 404 | 4 |
610189 | 610189 | 2020-10-08 | Barry | Michigan | 26015 | 395 | 4 |
606947 | 606947 | 2020-10-07 | Barry | Michigan | 26015 | 377 | 4 |
603704 | 603704 | 2020-10-06 | Barry | Michigan | 26015 | 369 | 4 |
600462 | 600462 | 2020-10-05 | Barry | Michigan | 26015 | 354 | 4 |
597219 | 597219 | 2020-10-04 | Barry | Michigan | 26015 | 347 | 4 |
593978 | 593978 | 2020-10-03 | Barry | Michigan | 26015 | 347 | 4 |
590737 | 590737 | 2020-10-02 | Barry | Michigan | 26015 | 338 | 4 |
587496 | 587496 | 2020-10-01 | Barry | Michigan | 26015 | 333 | 4 |
584256 | 584256 | 2020-09-30 | Barry | Michigan | 26015 | 326 | 4 |
581015 | 581015 | 2020-09-29 | Barry | Michigan | 26015 | 317 | 4 |
577774 | 577774 | 2020-09-28 | Barry | Michigan | 26015 | 309 | 4 |
574533 | 574533 | 2020-09-27 | Barry | Michigan | 26015 | 306 | 4 |
571290 | 571290 | 2020-09-26 | Barry | Michigan | 26015 | 306 | 4 |
568048 | 568048 | 2020-09-25 | Barry | Michigan | 26015 | 292 | 4 |
564808 | 564808 | 2020-09-24 | Barry | Michigan | 26015 | 289 | 3 |
561568 | 561568 | 2020-09-23 | Barry | Michigan | 26015 | 283 | 3 |
558331 | 558331 | 2020-09-22 | Barry | Michigan | 26015 | 283 | 3 |
555094 | 555094 | 2020-09-21 | Barry | Michigan | 26015 | 282 | 2 |
551856 | 551856 | 2020-09-20 | Barry | Michigan | 26015 | 272 | 2 |
548617 | 548617 | 2020-09-19 | Barry | Michigan | 26015 | 272 | 2 |
545379 | 545379 | 2020-09-18 | Barry | Michigan | 26015 | 273 | 2 |
542142 | 542142 | 2020-09-17 | Barry | Michigan | 26015 | 272 | 2 |
538906 | 538906 | 2020-09-16 | Barry | Michigan | 26015 | 270 | 2 |
535669 | 535669 | 2020-09-15 | Barry | Michigan | 26015 | 263 | 2 |
532434 | 532434 | 2020-09-14 | Barry | Michigan | 26015 | 259 | 2 |
529198 | 529198 | 2020-09-13 | Barry | Michigan | 26015 | 257 | 2 |
525962 | 525962 | 2020-09-12 | Barry | Michigan | 26015 | 257 | 2 |
522726 | 522726 | 2020-09-11 | Barry | Michigan | 26015 | 255 | 2 |
519489 | 519489 | 2020-09-10 | Barry | Michigan | 26015 | 248 | 2 |
516254 | 516254 | 2020-09-09 | Barry | Michigan | 26015 | 247 | 2 |
513020 | 513020 | 2020-09-08 | Barry | Michigan | 26015 | 234 | 2 |
509788 | 509788 | 2020-09-07 | Barry | Michigan | 26015 | 228 | 2 |
506555 | 506555 | 2020-09-06 | Barry | Michigan | 26015 | 225 | 2 |
503322 | 503322 | 2020-09-05 | Barry | Michigan | 26015 | 225 | 2 |
500088 | 500088 | 2020-09-04 | Barry | Michigan | 26015 | 224 | 2 |
496854 | 496854 | 2020-09-03 | Barry | Michigan | 26015 | 217 | 2 |
493621 | 493621 | 2020-09-02 | Barry | Michigan | 26015 | 216 | 2 |
490387 | 490387 | 2020-09-01 | Barry | Michigan | 26015 | 216 | 2 |
487154 | 487154 | 2020-08-31 | Barry | Michigan | 26015 | 214 | 2 |
483920 | 483920 | 2020-08-30 | Barry | Michigan | 26015 | 215 | 2 |
480685 | 480685 | 2020-08-29 | Barry | Michigan | 26015 | 212 | 2 |
477453 | 477453 | 2020-08-28 | Barry | Michigan | 26015 | 212 | 2 |
474220 | 474220 | 2020-08-27 | Barry | Michigan | 26015 | 210 | 2 |
470988 | 470988 | 2020-08-26 | Barry | Michigan | 26015 | 209 | 2 |
467758 | 467758 | 2020-08-25 | Barry | Michigan | 26015 | 208 | 2 |
464529 | 464529 | 2020-08-24 | Barry | Michigan | 26015 | 204 | 2 |
461298 | 461298 | 2020-08-23 | Barry | Michigan | 26015 | 203 | 2 |
458071 | 458071 | 2020-08-22 | Barry | Michigan | 26015 | 200 | 2 |
454843 | 454843 | 2020-08-21 | Barry | Michigan | 26015 | 200 | 2 |
451615 | 451615 | 2020-08-20 | Barry | Michigan | 26015 | 200 | 2 |
448387 | 448387 | 2020-08-19 | Barry | Michigan | 26015 | 199 | 2 |
445161 | 445161 | 2020-08-18 | Barry | Michigan | 26015 | 198 | 2 |
441935 | 441935 | 2020-08-17 | Barry | Michigan | 26015 | 200 | 2 |
438708 | 438708 | 2020-08-16 | Barry | Michigan | 26015 | 198 | 2 |
435483 | 435483 | 2020-08-15 | Barry | Michigan | 26015 | 197 | 2 |
432257 | 432257 | 2020-08-14 | Barry | Michigan | 26015 | 195 | 2 |
429030 | 429030 | 2020-08-13 | Barry | Michigan | 26015 | 192 | 2 |
425806 | 425806 | 2020-08-12 | Barry | Michigan | 26015 | 191 | 2 |
422584 | 422584 | 2020-08-11 | Barry | Michigan | 26015 | 194 | 2 |
419362 | 419362 | 2020-08-10 | Barry | Michigan | 26015 | 191 | 2 |
416141 | 416141 | 2020-08-09 | Barry | Michigan | 26015 | 181 | 2 |
412921 | 412921 | 2020-08-08 | Barry | Michigan | 26015 | 180 | 2 |
409701 | 409701 | 2020-08-07 | Barry | Michigan | 26015 | 175 | 2 |
406481 | 406481 | 2020-08-06 | Barry | Michigan | 26015 | 173 | 2 |
403263 | 403263 | 2020-08-05 | Barry | Michigan | 26015 | 170 | 2 |
400046 | 400046 | 2020-08-04 | Barry | Michigan | 26015 | 167 | 2 |
396832 | 396832 | 2020-08-03 | Barry | Michigan | 26015 | 172 | 2 |
393616 | 393616 | 2020-08-02 | Barry | Michigan | 26015 | 171 | 2 |
390399 | 390399 | 2020-08-01 | Barry | Michigan | 26015 | 171 | 2 |
387182 | 387182 | 2020-07-31 | Barry | Michigan | 26015 | 170 | 2 |
383964 | 383964 | 2020-07-30 | Barry | Michigan | 26015 | 169 | 2 |
380747 | 380747 | 2020-07-29 | Barry | Michigan | 26015 | 168 | 2 |
377530 | 377530 | 2020-07-28 | Barry | Michigan | 26015 | 168 | 2 |
374315 | 374315 | 2020-07-27 | Barry | Michigan | 26015 | 170 | 2 |
371103 | 371103 | 2020-07-26 | Barry | Michigan | 26015 | 170 | 2 |
367893 | 367893 | 2020-07-25 | Barry | Michigan | 26015 | 168 | 2 |
364686 | 364686 | 2020-07-24 | Barry | Michigan | 26015 | 167 | 2 |
361479 | 361479 | 2020-07-23 | Barry | Michigan | 26015 | 164 | 2 |
358274 | 358274 | 2020-07-22 | Barry | Michigan | 26015 | 160 | 2 |
355071 | 355071 | 2020-07-21 | Barry | Michigan | 26015 | 156 | 2 |
351869 | 351869 | 2020-07-20 | Barry | Michigan | 26015 | 155 | 2 |
348669 | 348669 | 2020-07-19 | Barry | Michigan | 26015 | 153 | 2 |
345468 | 345468 | 2020-07-18 | Barry | Michigan | 26015 | 149 | 2 |
342268 | 342268 | 2020-07-17 | Barry | Michigan | 26015 | 146 | 2 |
339072 | 339072 | 2020-07-16 | Barry | Michigan | 26015 | 145 | 2 |
335876 | 335876 | 2020-07-15 | Barry | Michigan | 26015 | 140 | 2 |
332683 | 332683 | 2020-07-14 | Barry | Michigan | 26015 | 140 | 2 |
329496 | 329496 | 2020-07-13 | Barry | Michigan | 26015 | 139 | 2 |
326310 | 326310 | 2020-07-12 | Barry | Michigan | 26015 | 134 | 2 |
323127 | 323127 | 2020-07-11 | Barry | Michigan | 26015 | 131 | 2 |
319948 | 319948 | 2020-07-10 | Barry | Michigan | 26015 | 130 | 2 |
316773 | 316773 | 2020-07-09 | Barry | Michigan | 26015 | 123 | 3 |
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);