ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636164 | 636164 | 2020-10-16 | Jackson | Michigan | 26075 | 3170 | 82 |
632918 | 632918 | 2020-10-15 | Jackson | Michigan | 26075 | 3122 | 82 |
629673 | 629673 | 2020-10-14 | Jackson | Michigan | 26075 | 3095 | 79 |
626429 | 626429 | 2020-10-13 | Jackson | Michigan | 26075 | 3057 | 79 |
623187 | 623187 | 2020-10-12 | Jackson | Michigan | 26075 | 3044 | 76 |
619944 | 619944 | 2020-10-11 | Jackson | Michigan | 26075 | 3017 | 75 |
616702 | 616702 | 2020-10-10 | Jackson | Michigan | 26075 | 3017 | 75 |
613461 | 613461 | 2020-10-09 | Jackson | Michigan | 26075 | 2979 | 73 |
610219 | 610219 | 2020-10-08 | Jackson | Michigan | 26075 | 2953 | 73 |
606977 | 606977 | 2020-10-07 | Jackson | Michigan | 26075 | 2935 | 71 |
603734 | 603734 | 2020-10-06 | Jackson | Michigan | 26075 | 2910 | 71 |
600492 | 600492 | 2020-10-05 | Jackson | Michigan | 26075 | 2928 | 70 |
597249 | 597249 | 2020-10-04 | Jackson | Michigan | 26075 | 2912 | 68 |
594008 | 594008 | 2020-10-03 | Jackson | Michigan | 26075 | 2912 | 68 |
590767 | 590767 | 2020-10-02 | Jackson | Michigan | 26075 | 2885 | 67 |
587526 | 587526 | 2020-10-01 | Jackson | Michigan | 26075 | 2875 | 67 |
584286 | 584286 | 2020-09-30 | Jackson | Michigan | 26075 | 2864 | 67 |
581045 | 581045 | 2020-09-29 | Jackson | Michigan | 26075 | 2858 | 67 |
577804 | 577804 | 2020-09-28 | Jackson | Michigan | 26075 | 2835 | 67 |
574563 | 574563 | 2020-09-27 | Jackson | Michigan | 26075 | 2814 | 67 |
571320 | 571320 | 2020-09-26 | Jackson | Michigan | 26075 | 2814 | 67 |
568078 | 568078 | 2020-09-25 | Jackson | Michigan | 26075 | 2806 | 66 |
564838 | 564838 | 2020-09-24 | Jackson | Michigan | 26075 | 2793 | 66 |
561598 | 561598 | 2020-09-23 | Jackson | Michigan | 26075 | 2772 | 66 |
558361 | 558361 | 2020-09-22 | Jackson | Michigan | 26075 | 2761 | 66 |
555124 | 555124 | 2020-09-21 | Jackson | Michigan | 26075 | 2733 | 66 |
551886 | 551886 | 2020-09-20 | Jackson | Michigan | 26075 | 2715 | 66 |
548647 | 548647 | 2020-09-19 | Jackson | Michigan | 26075 | 2715 | 66 |
545409 | 545409 | 2020-09-18 | Jackson | Michigan | 26075 | 2711 | 65 |
542172 | 542172 | 2020-09-17 | Jackson | Michigan | 26075 | 2705 | 65 |
538936 | 538936 | 2020-09-16 | Jackson | Michigan | 26075 | 2683 | 64 |
535699 | 535699 | 2020-09-15 | Jackson | Michigan | 26075 | 2675 | 64 |
532464 | 532464 | 2020-09-14 | Jackson | Michigan | 26075 | 2663 | 64 |
529228 | 529228 | 2020-09-13 | Jackson | Michigan | 26075 | 2665 | 64 |
525992 | 525992 | 2020-09-12 | Jackson | Michigan | 26075 | 2665 | 64 |
522756 | 522756 | 2020-09-11 | Jackson | Michigan | 26075 | 2653 | 63 |
519519 | 519519 | 2020-09-10 | Jackson | Michigan | 26075 | 2644 | 63 |
516284 | 516284 | 2020-09-09 | Jackson | Michigan | 26075 | 2623 | 63 |
513050 | 513050 | 2020-09-08 | Jackson | Michigan | 26075 | 2617 | 63 |
509818 | 509818 | 2020-09-07 | Jackson | Michigan | 26075 | 2605 | 63 |
506585 | 506585 | 2020-09-06 | Jackson | Michigan | 26075 | 2597 | 62 |
503352 | 503352 | 2020-09-05 | Jackson | Michigan | 26075 | 2597 | 62 |
500118 | 500118 | 2020-09-04 | Jackson | Michigan | 26075 | 2586 | 62 |
496884 | 496884 | 2020-09-03 | Jackson | Michigan | 26075 | 2583 | 62 |
493651 | 493651 | 2020-09-02 | Jackson | Michigan | 26075 | 2580 | 62 |
490417 | 490417 | 2020-09-01 | Jackson | Michigan | 26075 | 2570 | 62 |
487184 | 487184 | 2020-08-31 | Jackson | Michigan | 26075 | 2554 | 62 |
483950 | 483950 | 2020-08-30 | Jackson | Michigan | 26075 | 2547 | 62 |
480715 | 480715 | 2020-08-29 | Jackson | Michigan | 26075 | 2547 | 62 |
477483 | 477483 | 2020-08-28 | Jackson | Michigan | 26075 | 2536 | 62 |
474250 | 474250 | 2020-08-27 | Jackson | Michigan | 26075 | 2524 | 62 |
471018 | 471018 | 2020-08-26 | Jackson | Michigan | 26075 | 2514 | 60 |
467788 | 467788 | 2020-08-25 | Jackson | Michigan | 26075 | 2509 | 60 |
464559 | 464559 | 2020-08-24 | Jackson | Michigan | 26075 | 2498 | 59 |
461328 | 461328 | 2020-08-23 | Jackson | Michigan | 26075 | 2496 | 59 |
458101 | 458101 | 2020-08-22 | Jackson | Michigan | 26075 | 2494 | 58 |
454873 | 454873 | 2020-08-21 | Jackson | Michigan | 26075 | 2476 | 58 |
451645 | 451645 | 2020-08-20 | Jackson | Michigan | 26075 | 2476 | 58 |
448417 | 448417 | 2020-08-19 | Jackson | Michigan | 26075 | 2475 | 58 |
445191 | 445191 | 2020-08-18 | Jackson | Michigan | 26075 | 2473 | 58 |
441965 | 441965 | 2020-08-17 | Jackson | Michigan | 26075 | 2470 | 57 |
438738 | 438738 | 2020-08-16 | Jackson | Michigan | 26075 | 2467 | 57 |
435513 | 435513 | 2020-08-15 | Jackson | Michigan | 26075 | 2462 | 57 |
432287 | 432287 | 2020-08-14 | Jackson | Michigan | 26075 | 2459 | 56 |
429060 | 429060 | 2020-08-13 | Jackson | Michigan | 26075 | 2449 | 56 |
425836 | 425836 | 2020-08-12 | Jackson | Michigan | 26075 | 2447 | 56 |
422614 | 422614 | 2020-08-11 | Jackson | Michigan | 26075 | 2438 | 56 |
419392 | 419392 | 2020-08-10 | Jackson | Michigan | 26075 | 2432 | 56 |
416171 | 416171 | 2020-08-09 | Jackson | Michigan | 26075 | 2430 | 56 |
412951 | 412951 | 2020-08-08 | Jackson | Michigan | 26075 | 2430 | 56 |
409731 | 409731 | 2020-08-07 | Jackson | Michigan | 26075 | 2430 | 56 |
406511 | 406511 | 2020-08-06 | Jackson | Michigan | 26075 | 2428 | 56 |
403293 | 403293 | 2020-08-05 | Jackson | Michigan | 26075 | 2422 | 55 |
400076 | 400076 | 2020-08-04 | Jackson | Michigan | 26075 | 2416 | 55 |
396862 | 396862 | 2020-08-03 | Jackson | Michigan | 26075 | 2411 | 55 |
393646 | 393646 | 2020-08-02 | Jackson | Michigan | 26075 | 2405 | 55 |
390429 | 390429 | 2020-08-01 | Jackson | Michigan | 26075 | 2401 | 55 |
387212 | 387212 | 2020-07-31 | Jackson | Michigan | 26075 | 2392 | 55 |
383994 | 383994 | 2020-07-30 | Jackson | Michigan | 26075 | 2387 | 55 |
380777 | 380777 | 2020-07-29 | Jackson | Michigan | 26075 | 2373 | 55 |
377560 | 377560 | 2020-07-28 | Jackson | Michigan | 26075 | 2357 | 55 |
374345 | 374345 | 2020-07-27 | Jackson | Michigan | 26075 | 2351 | 54 |
371133 | 371133 | 2020-07-26 | Jackson | Michigan | 26075 | 2350 | 54 |
367923 | 367923 | 2020-07-25 | Jackson | Michigan | 26075 | 2344 | 54 |
364716 | 364716 | 2020-07-24 | Jackson | Michigan | 26075 | 2227 | 54 |
361509 | 361509 | 2020-07-23 | Jackson | Michigan | 26075 | 2221 | 54 |
358304 | 358304 | 2020-07-22 | Jackson | Michigan | 26075 | 2210 | 54 |
355101 | 355101 | 2020-07-21 | Jackson | Michigan | 26075 | 2204 | 54 |
351899 | 351899 | 2020-07-20 | Jackson | Michigan | 26075 | 2195 | 54 |
348699 | 348699 | 2020-07-19 | Jackson | Michigan | 26075 | 2193 | 54 |
345498 | 345498 | 2020-07-18 | Jackson | Michigan | 26075 | 2187 | 54 |
342298 | 342298 | 2020-07-17 | Jackson | Michigan | 26075 | 2180 | 54 |
339102 | 339102 | 2020-07-16 | Jackson | Michigan | 26075 | 2173 | 54 |
335906 | 335906 | 2020-07-15 | Jackson | Michigan | 26075 | 2168 | 54 |
332713 | 332713 | 2020-07-14 | Jackson | Michigan | 26075 | 2166 | 54 |
329526 | 329526 | 2020-07-13 | Jackson | Michigan | 26075 | 2163 | 54 |
326340 | 326340 | 2020-07-12 | Jackson | Michigan | 26075 | 2159 | 54 |
323157 | 323157 | 2020-07-11 | Jackson | Michigan | 26075 | 2155 | 54 |
319978 | 319978 | 2020-07-10 | Jackson | Michigan | 26075 | 2148 | 54 |
316803 | 316803 | 2020-07-09 | Jackson | Michigan | 26075 | 2143 | 54 |
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);