ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Wayne" and state = "Michigan" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
250759 | 250759 | 2020-06-18 | Wayne | Michigan | 26163 | 21964 | 2682 |
253874 | 253874 | 2020-06-19 | Wayne | Michigan | 26163 | 22018 | 2683 |
256994 | 256994 | 2020-06-20 | Wayne | Michigan | 26163 | 22108 | 2689 |
260120 | 260120 | 2020-06-21 | Wayne | Michigan | 26163 | 22162 | 2689 |
263249 | 263249 | 2020-06-22 | Wayne | Michigan | 26163 | 22203 | 2691 |
266375 | 266375 | 2020-06-23 | Wayne | Michigan | 26163 | 22268 | 2692 |
269508 | 269508 | 2020-06-24 | Wayne | Michigan | 26163 | 22347 | 2695 |
272645 | 272645 | 2020-06-25 | Wayne | Michigan | 26163 | 22476 | 2705 |
275788 | 275788 | 2020-06-26 | Wayne | Michigan | 26163 | 22503 | 2703 |
278936 | 278936 | 2020-06-27 | Wayne | Michigan | 26163 | 22603 | 2710 |
282084 | 282084 | 2020-06-28 | Wayne | Michigan | 26163 | 22645 | 2712 |
285229 | 285229 | 2020-06-29 | Wayne | Michigan | 26163 | 22686 | 2713 |
288379 | 288379 | 2020-06-30 | Wayne | Michigan | 26163 | 22791 | 2722 |
291530 | 291530 | 2020-07-01 | Wayne | Michigan | 26163 | 22879 | 2724 |
294684 | 294684 | 2020-07-02 | Wayne | Michigan | 26163 | 23015 | 2730 |
297842 | 297842 | 2020-07-03 | Wayne | Michigan | 26163 | 23078 | 2730 |
301005 | 301005 | 2020-07-04 | Wayne | Michigan | 26163 | 23147 | 2730 |
304169 | 304169 | 2020-07-05 | Wayne | Michigan | 26163 | 23206 | 2730 |
307336 | 307336 | 2020-07-06 | Wayne | Michigan | 26163 | 23283 | 2732 |
310504 | 310504 | 2020-07-07 | Wayne | Michigan | 26163 | 23459 | 2743 |
313674 | 313674 | 2020-07-08 | Wayne | Michigan | 26163 | 23621 | 2745 |
316848 | 316848 | 2020-07-09 | Wayne | Michigan | 26163 | 23725 | 2746 |
320023 | 320023 | 2020-07-10 | Wayne | Michigan | 26163 | 23835 | 2750 |
323202 | 323202 | 2020-07-11 | Wayne | Michigan | 26163 | 23922 | 2760 |
326385 | 326385 | 2020-07-12 | Wayne | Michigan | 26163 | 24020 | 2761 |
329571 | 329571 | 2020-07-13 | Wayne | Michigan | 26163 | 24100 | 2763 |
332758 | 332758 | 2020-07-14 | Wayne | Michigan | 26163 | 24294 | 2764 |
335951 | 335951 | 2020-07-15 | Wayne | Michigan | 26163 | 24549 | 2764 |
339147 | 339147 | 2020-07-16 | Wayne | Michigan | 26163 | 24784 | 2772 |
342343 | 342343 | 2020-07-17 | Wayne | Michigan | 26163 | 24939 | 2776 |
345543 | 345543 | 2020-07-18 | Wayne | Michigan | 26163 | 25075 | 2782 |
348744 | 348744 | 2020-07-19 | Wayne | Michigan | 26163 | 25160 | 2783 |
351944 | 351944 | 2020-07-20 | Wayne | Michigan | 26163 | 25251 | 2783 |
355146 | 355146 | 2020-07-21 | Wayne | Michigan | 26163 | 25434 | 2784 |
358349 | 358349 | 2020-07-22 | Wayne | Michigan | 26163 | 25544 | 2786 |
361554 | 361554 | 2020-07-23 | Wayne | Michigan | 26163 | 25673 | 2790 |
364761 | 364761 | 2020-07-24 | Wayne | Michigan | 26163 | 25794 | 2791 |
367968 | 367968 | 2020-07-25 | Wayne | Michigan | 26163 | 25902 | 2784 |
371178 | 371178 | 2020-07-26 | Wayne | Michigan | 26163 | 26109 | 2784 |
374390 | 374390 | 2020-07-27 | Wayne | Michigan | 26163 | 26186 | 2785 |
377605 | 377605 | 2020-07-28 | Wayne | Michigan | 26163 | 26356 | 2791 |
380822 | 380822 | 2020-07-29 | Wayne | Michigan | 26163 | 26714 | 2794 |
384039 | 384039 | 2020-07-30 | Wayne | Michigan | 26163 | 26949 | 2800 |
387257 | 387257 | 2020-07-31 | Wayne | Michigan | 26163 | 27092 | 2804 |
390474 | 390474 | 2020-08-01 | Wayne | Michigan | 26163 | 27208 | 2805 |
393691 | 393691 | 2020-08-02 | Wayne | Michigan | 26163 | 27259 | 2804 |
396907 | 396907 | 2020-08-03 | Wayne | Michigan | 26163 | 27402 | 2807 |
400121 | 400121 | 2020-08-04 | Wayne | Michigan | 26163 | 27589 | 2811 |
403338 | 403338 | 2020-08-05 | Wayne | Michigan | 26163 | 27713 | 2811 |
406556 | 406556 | 2020-08-06 | Wayne | Michigan | 26163 | 27861 | 2823 |
409776 | 409776 | 2020-08-07 | Wayne | Michigan | 26163 | 27980 | 2829 |
412996 | 412996 | 2020-08-08 | Wayne | Michigan | 26163 | 28115 | 2828 |
416216 | 416216 | 2020-08-09 | Wayne | Michigan | 26163 | 28188 | 2826 |
419437 | 419437 | 2020-08-10 | Wayne | Michigan | 26163 | 28298 | 2828 |
422659 | 422659 | 2020-08-11 | Wayne | Michigan | 26163 | 28448 | 2830 |
425881 | 425881 | 2020-08-12 | Wayne | Michigan | 26163 | 28416 | 2830 |
429105 | 429105 | 2020-08-13 | Wayne | Michigan | 26163 | 28715 | 2835 |
432332 | 432332 | 2020-08-14 | Wayne | Michigan | 26163 | 28902 | 2837 |
435558 | 435558 | 2020-08-15 | Wayne | Michigan | 26163 | 29087 | 2839 |
438783 | 438783 | 2020-08-16 | Wayne | Michigan | 26163 | 29136 | 2841 |
442010 | 442010 | 2020-08-17 | Wayne | Michigan | 26163 | 29242 | 2841 |
445236 | 445236 | 2020-08-18 | Wayne | Michigan | 26163 | 29424 | 2847 |
448462 | 448462 | 2020-08-19 | Wayne | Michigan | 26163 | 29542 | 2849 |
451690 | 451690 | 2020-08-20 | Wayne | Michigan | 26163 | 29647 | 2854 |
454918 | 454918 | 2020-08-21 | Wayne | Michigan | 26163 | 29647 | 2854 |
458146 | 458146 | 2020-08-22 | Wayne | Michigan | 26163 | 29879 | 2859 |
461373 | 461373 | 2020-08-23 | Wayne | Michigan | 26163 | 30038 | 2859 |
464604 | 464604 | 2020-08-24 | Wayne | Michigan | 26163 | 30191 | 2862 |
467833 | 467833 | 2020-08-25 | Wayne | Michigan | 26163 | 30358 | 2865 |
471063 | 471063 | 2020-08-26 | Wayne | Michigan | 26163 | 30620 | 2866 |
474295 | 474295 | 2020-08-27 | Wayne | Michigan | 26163 | 30845 | 2874 |
477528 | 477528 | 2020-08-28 | Wayne | Michigan | 26163 | 30980 | 2876 |
480760 | 480760 | 2020-08-29 | Wayne | Michigan | 26163 | 31086 | 2882 |
483995 | 483995 | 2020-08-30 | Wayne | Michigan | 26163 | 31178 | 2883 |
487229 | 487229 | 2020-08-31 | Wayne | Michigan | 26163 | 31256 | 2885 |
490462 | 490462 | 2020-09-01 | Wayne | Michigan | 26163 | 31382 | 2891 |
493696 | 493696 | 2020-09-02 | Wayne | Michigan | 26163 | 31508 | 2891 |
496929 | 496929 | 2020-09-03 | Wayne | Michigan | 26163 | 31632 | 2895 |
500163 | 500163 | 2020-09-04 | Wayne | Michigan | 26163 | 31850 | 2897 |
503397 | 503397 | 2020-09-05 | Wayne | Michigan | 26163 | 31983 | 2898 |
506630 | 506630 | 2020-09-06 | Wayne | Michigan | 26163 | 31983 | 2898 |
509863 | 509863 | 2020-09-07 | Wayne | Michigan | 26163 | 32303 | 2898 |
513095 | 513095 | 2020-09-08 | Wayne | Michigan | 26163 | 32401 | 2899 |
516329 | 516329 | 2020-09-09 | Wayne | Michigan | 26163 | 32646 | 2931 |
519564 | 519564 | 2020-09-10 | Wayne | Michigan | 26163 | 32877 | 2941 |
522801 | 522801 | 2020-09-11 | Wayne | Michigan | 26163 | 33138 | 2942 |
526037 | 526037 | 2020-09-12 | Wayne | Michigan | 26163 | 33276 | 2943 |
529273 | 529273 | 2020-09-13 | Wayne | Michigan | 26163 | 33276 | 2943 |
532509 | 532509 | 2020-09-14 | Wayne | Michigan | 26163 | 33536 | 2944 |
535744 | 535744 | 2020-09-15 | Wayne | Michigan | 26163 | 33678 | 2948 |
538981 | 538981 | 2020-09-16 | Wayne | Michigan | 26163 | 33815 | 2951 |
542217 | 542217 | 2020-09-17 | Wayne | Michigan | 26163 | 33973 | 2953 |
545454 | 545454 | 2020-09-18 | Wayne | Michigan | 26163 | 34059 | 2953 |
548692 | 548692 | 2020-09-19 | Wayne | Michigan | 26163 | 34107 | 2957 |
551931 | 551931 | 2020-09-20 | Wayne | Michigan | 26163 | 34107 | 2957 |
555169 | 555169 | 2020-09-21 | Wayne | Michigan | 26163 | 34327 | 2961 |
558406 | 558406 | 2020-09-22 | Wayne | Michigan | 26163 | 34446 | 2965 |
561643 | 561643 | 2020-09-23 | Wayne | Michigan | 26163 | 34607 | 2970 |
564883 | 564883 | 2020-09-24 | Wayne | Michigan | 26163 | 34784 | 2972 |
568123 | 568123 | 2020-09-25 | Wayne | Michigan | 26163 | 34928 | 2975 |
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);