ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Clay" and fips = 27027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636224 | 636224 | 2020-10-16 | Clay | Minnesota | 27027 | 1919 | 43 |
632978 | 632978 | 2020-10-15 | Clay | Minnesota | 27027 | 1862 | 43 |
629733 | 629733 | 2020-10-14 | Clay | Minnesota | 27027 | 1824 | 43 |
626489 | 626489 | 2020-10-13 | Clay | Minnesota | 27027 | 1773 | 42 |
623247 | 623247 | 2020-10-12 | Clay | Minnesota | 27027 | 1756 | 42 |
620004 | 620004 | 2020-10-11 | Clay | Minnesota | 27027 | 1737 | 42 |
616762 | 616762 | 2020-10-10 | Clay | Minnesota | 27027 | 1703 | 42 |
613521 | 613521 | 2020-10-09 | Clay | Minnesota | 27027 | 1668 | 42 |
610279 | 610279 | 2020-10-08 | Clay | Minnesota | 27027 | 1647 | 42 |
607037 | 607037 | 2020-10-07 | Clay | Minnesota | 27027 | 1613 | 42 |
603794 | 603794 | 2020-10-06 | Clay | Minnesota | 27027 | 1593 | 42 |
600552 | 600552 | 2020-10-05 | Clay | Minnesota | 27027 | 1578 | 41 |
597309 | 597309 | 2020-10-04 | Clay | Minnesota | 27027 | 1571 | 41 |
594068 | 594068 | 2020-10-03 | Clay | Minnesota | 27027 | 1546 | 41 |
590827 | 590827 | 2020-10-02 | Clay | Minnesota | 27027 | 1508 | 41 |
587586 | 587586 | 2020-10-01 | Clay | Minnesota | 27027 | 1480 | 41 |
584346 | 584346 | 2020-09-30 | Clay | Minnesota | 27027 | 1457 | 41 |
581105 | 581105 | 2020-09-29 | Clay | Minnesota | 27027 | 1424 | 41 |
577864 | 577864 | 2020-09-28 | Clay | Minnesota | 27027 | 1417 | 41 |
574623 | 574623 | 2020-09-27 | Clay | Minnesota | 27027 | 1411 | 40 |
571380 | 571380 | 2020-09-26 | Clay | Minnesota | 27027 | 1389 | 40 |
568138 | 568138 | 2020-09-25 | Clay | Minnesota | 27027 | 1371 | 40 |
564898 | 564898 | 2020-09-24 | Clay | Minnesota | 27027 | 1340 | 40 |
561658 | 561658 | 2020-09-23 | Clay | Minnesota | 27027 | 1316 | 40 |
558421 | 558421 | 2020-09-22 | Clay | Minnesota | 27027 | 1288 | 40 |
555184 | 555184 | 2020-09-21 | Clay | Minnesota | 27027 | 1281 | 40 |
551946 | 551946 | 2020-09-20 | Clay | Minnesota | 27027 | 1261 | 40 |
548707 | 548707 | 2020-09-19 | Clay | Minnesota | 27027 | 1232 | 40 |
545469 | 545469 | 2020-09-18 | Clay | Minnesota | 27027 | 1213 | 40 |
542232 | 542232 | 2020-09-17 | Clay | Minnesota | 27027 | 1199 | 40 |
538996 | 538996 | 2020-09-16 | Clay | Minnesota | 27027 | 1179 | 40 |
535759 | 535759 | 2020-09-15 | Clay | Minnesota | 27027 | 1165 | 40 |
532524 | 532524 | 2020-09-14 | Clay | Minnesota | 27027 | 1142 | 40 |
529288 | 529288 | 2020-09-13 | Clay | Minnesota | 27027 | 1131 | 40 |
526052 | 526052 | 2020-09-12 | Clay | Minnesota | 27027 | 1111 | 40 |
522816 | 522816 | 2020-09-11 | Clay | Minnesota | 27027 | 1059 | 40 |
519579 | 519579 | 2020-09-10 | Clay | Minnesota | 27027 | 1045 | 40 |
516344 | 516344 | 2020-09-09 | Clay | Minnesota | 27027 | 1027 | 40 |
513110 | 513110 | 2020-09-08 | Clay | Minnesota | 27027 | 1020 | 40 |
509878 | 509878 | 2020-09-07 | Clay | Minnesota | 27027 | 1011 | 40 |
506645 | 506645 | 2020-09-06 | Clay | Minnesota | 27027 | 1002 | 40 |
503412 | 503412 | 2020-09-05 | Clay | Minnesota | 27027 | 984 | 40 |
500178 | 500178 | 2020-09-04 | Clay | Minnesota | 27027 | 960 | 40 |
496944 | 496944 | 2020-09-03 | Clay | Minnesota | 27027 | 940 | 40 |
493711 | 493711 | 2020-09-02 | Clay | Minnesota | 27027 | 913 | 40 |
490477 | 490477 | 2020-09-01 | Clay | Minnesota | 27027 | 893 | 40 |
487244 | 487244 | 2020-08-31 | Clay | Minnesota | 27027 | 880 | 40 |
484010 | 484010 | 2020-08-30 | Clay | Minnesota | 27027 | 872 | 40 |
480775 | 480775 | 2020-08-29 | Clay | Minnesota | 27027 | 864 | 40 |
477543 | 477543 | 2020-08-28 | Clay | Minnesota | 27027 | 856 | 40 |
474310 | 474310 | 2020-08-27 | Clay | Minnesota | 27027 | 850 | 40 |
471078 | 471078 | 2020-08-26 | Clay | Minnesota | 27027 | 836 | 40 |
467848 | 467848 | 2020-08-25 | Clay | Minnesota | 27027 | 833 | 40 |
464619 | 464619 | 2020-08-24 | Clay | Minnesota | 27027 | 830 | 40 |
461388 | 461388 | 2020-08-23 | Clay | Minnesota | 27027 | 828 | 40 |
458161 | 458161 | 2020-08-22 | Clay | Minnesota | 27027 | 819 | 40 |
454933 | 454933 | 2020-08-21 | Clay | Minnesota | 27027 | 812 | 40 |
451705 | 451705 | 2020-08-20 | Clay | Minnesota | 27027 | 807 | 40 |
448477 | 448477 | 2020-08-19 | Clay | Minnesota | 27027 | 802 | 40 |
445251 | 445251 | 2020-08-18 | Clay | Minnesota | 27027 | 799 | 40 |
442025 | 442025 | 2020-08-17 | Clay | Minnesota | 27027 | 799 | 40 |
438798 | 438798 | 2020-08-16 | Clay | Minnesota | 27027 | 797 | 40 |
435573 | 435573 | 2020-08-15 | Clay | Minnesota | 27027 | 797 | 40 |
432347 | 432347 | 2020-08-14 | Clay | Minnesota | 27027 | 795 | 40 |
429120 | 429120 | 2020-08-13 | Clay | Minnesota | 27027 | 794 | 40 |
425896 | 425896 | 2020-08-12 | Clay | Minnesota | 27027 | 792 | 40 |
422674 | 422674 | 2020-08-11 | Clay | Minnesota | 27027 | 788 | 40 |
419452 | 419452 | 2020-08-10 | Clay | Minnesota | 27027 | 785 | 40 |
416231 | 416231 | 2020-08-09 | Clay | Minnesota | 27027 | 784 | 40 |
413011 | 413011 | 2020-08-08 | Clay | Minnesota | 27027 | 779 | 40 |
409791 | 409791 | 2020-08-07 | Clay | Minnesota | 27027 | 771 | 40 |
406571 | 406571 | 2020-08-06 | Clay | Minnesota | 27027 | 768 | 40 |
403353 | 403353 | 2020-08-05 | Clay | Minnesota | 27027 | 758 | 40 |
400136 | 400136 | 2020-08-04 | Clay | Minnesota | 27027 | 752 | 40 |
396922 | 396922 | 2020-08-03 | Clay | Minnesota | 27027 | 745 | 40 |
393706 | 393706 | 2020-08-02 | Clay | Minnesota | 27027 | 743 | 40 |
390489 | 390489 | 2020-08-01 | Clay | Minnesota | 27027 | 742 | 40 |
387272 | 387272 | 2020-07-31 | Clay | Minnesota | 27027 | 740 | 39 |
384054 | 384054 | 2020-07-30 | Clay | Minnesota | 27027 | 734 | 39 |
380837 | 380837 | 2020-07-29 | Clay | Minnesota | 27027 | 725 | 39 |
377620 | 377620 | 2020-07-28 | Clay | Minnesota | 27027 | 717 | 39 |
374405 | 374405 | 2020-07-27 | Clay | Minnesota | 27027 | 707 | 39 |
371193 | 371193 | 2020-07-26 | Clay | Minnesota | 27027 | 703 | 39 |
367983 | 367983 | 2020-07-25 | Clay | Minnesota | 27027 | 697 | 39 |
364776 | 364776 | 2020-07-24 | Clay | Minnesota | 27027 | 692 | 39 |
361569 | 361569 | 2020-07-23 | Clay | Minnesota | 27027 | 686 | 39 |
358364 | 358364 | 2020-07-22 | Clay | Minnesota | 27027 | 679 | 39 |
355161 | 355161 | 2020-07-21 | Clay | Minnesota | 27027 | 678 | 39 |
351959 | 351959 | 2020-07-20 | Clay | Minnesota | 27027 | 669 | 39 |
348759 | 348759 | 2020-07-19 | Clay | Minnesota | 27027 | 668 | 38 |
345558 | 345558 | 2020-07-18 | Clay | Minnesota | 27027 | 658 | 38 |
342358 | 342358 | 2020-07-17 | Clay | Minnesota | 27027 | 650 | 38 |
339162 | 339162 | 2020-07-16 | Clay | Minnesota | 27027 | 638 | 38 |
335966 | 335966 | 2020-07-15 | Clay | Minnesota | 27027 | 632 | 38 |
332773 | 332773 | 2020-07-14 | Clay | Minnesota | 27027 | 627 | 38 |
329586 | 329586 | 2020-07-13 | Clay | Minnesota | 27027 | 620 | 38 |
326400 | 326400 | 2020-07-12 | Clay | Minnesota | 27027 | 613 | 38 |
323217 | 323217 | 2020-07-11 | Clay | Minnesota | 27027 | 612 | 38 |
320038 | 320038 | 2020-07-10 | Clay | Minnesota | 27027 | 601 | 38 |
316863 | 316863 | 2020-07-09 | Clay | Minnesota | 27027 | 598 | 38 |
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);