ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Clay" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921777 | 921777 | 2021-01-12 | Clay | Minnesota | 27027 | 6392 | 78 |
918532 | 918532 | 2021-01-11 | Clay | Minnesota | 27027 | 6372 | 78 |
915287 | 915287 | 2021-01-10 | Clay | Minnesota | 27027 | 6369 | 78 |
912042 | 912042 | 2021-01-09 | Clay | Minnesota | 27027 | 6357 | 78 |
908797 | 908797 | 2021-01-08 | Clay | Minnesota | 27027 | 6345 | 78 |
905551 | 905551 | 2021-01-07 | Clay | Minnesota | 27027 | 6320 | 78 |
902306 | 902306 | 2021-01-06 | Clay | Minnesota | 27027 | 6306 | 78 |
899061 | 899061 | 2021-01-05 | Clay | Minnesota | 27027 | 6280 | 78 |
895816 | 895816 | 2021-01-04 | Clay | Minnesota | 27027 | 6261 | 78 |
892569 | 892569 | 2021-01-03 | Clay | Minnesota | 27027 | 6212 | 78 |
889323 | 889323 | 2021-01-02 | Clay | Minnesota | 27027 | 6188 | 78 |
886077 | 886077 | 2021-01-01 | Clay | Minnesota | 27027 | 6163 | 78 |
882832 | 882832 | 2020-12-31 | Clay | Minnesota | 27027 | 6163 | 78 |
879587 | 879587 | 2020-12-30 | Clay | Minnesota | 27027 | 6143 | 78 |
876342 | 876342 | 2020-12-29 | Clay | Minnesota | 27027 | 6129 | 77 |
873097 | 873097 | 2020-12-28 | Clay | Minnesota | 27027 | 6123 | 77 |
869852 | 869852 | 2020-12-27 | Clay | Minnesota | 27027 | 6115 | 77 |
866607 | 866607 | 2020-12-26 | Clay | Minnesota | 27027 | 6090 | 75 |
863362 | 863362 | 2020-12-25 | Clay | Minnesota | 27027 | 6065 | 75 |
860117 | 860117 | 2020-12-24 | Clay | Minnesota | 27027 | 6065 | 75 |
856872 | 856872 | 2020-12-23 | Clay | Minnesota | 27027 | 6050 | 73 |
853627 | 853627 | 2020-12-22 | Clay | Minnesota | 27027 | 6036 | 73 |
850382 | 850382 | 2020-12-21 | Clay | Minnesota | 27027 | 6003 | 73 |
847137 | 847137 | 2020-12-20 | Clay | Minnesota | 27027 | 5983 | 73 |
843891 | 843891 | 2020-12-19 | Clay | Minnesota | 27027 | 5955 | 73 |
840646 | 840646 | 2020-12-18 | Clay | Minnesota | 27027 | 5920 | 71 |
837401 | 837401 | 2020-12-17 | Clay | Minnesota | 27027 | 5896 | 70 |
834155 | 834155 | 2020-12-16 | Clay | Minnesota | 27027 | 5864 | 69 |
830908 | 830908 | 2020-12-15 | Clay | Minnesota | 27027 | 5827 | 69 |
827662 | 827662 | 2020-12-14 | Clay | Minnesota | 27027 | 5799 | 69 |
824415 | 824415 | 2020-12-13 | Clay | Minnesota | 27027 | 5757 | 69 |
821169 | 821169 | 2020-12-12 | Clay | Minnesota | 27027 | 5730 | 68 |
817923 | 817923 | 2020-12-11 | Clay | Minnesota | 27027 | 5691 | 68 |
814677 | 814677 | 2020-12-10 | Clay | Minnesota | 27027 | 5655 | 67 |
811432 | 811432 | 2020-12-09 | Clay | Minnesota | 27027 | 5623 | 64 |
808187 | 808187 | 2020-12-08 | Clay | Minnesota | 27027 | 5537 | 64 |
804942 | 804942 | 2020-12-07 | Clay | Minnesota | 27027 | 5510 | 64 |
801697 | 801697 | 2020-12-06 | Clay | Minnesota | 27027 | 5453 | 64 |
798452 | 798452 | 2020-12-05 | Clay | Minnesota | 27027 | 5405 | 62 |
795207 | 795207 | 2020-12-04 | Clay | Minnesota | 27027 | 5355 | 62 |
791962 | 791962 | 2020-12-03 | Clay | Minnesota | 27027 | 5299 | 60 |
788717 | 788717 | 2020-12-02 | Clay | Minnesota | 27027 | 5213 | 59 |
785472 | 785472 | 2020-12-01 | Clay | Minnesota | 27027 | 5141 | 57 |
782228 | 782228 | 2020-11-30 | Clay | Minnesota | 27027 | 5089 | 57 |
778982 | 778982 | 2020-11-29 | Clay | Minnesota | 27027 | 4984 | 57 |
775737 | 775737 | 2020-11-28 | Clay | Minnesota | 27027 | 4839 | 56 |
772492 | 772492 | 2020-11-27 | Clay | Minnesota | 27027 | 4733 | 56 |
769247 | 769247 | 2020-11-26 | Clay | Minnesota | 27027 | 4638 | 56 |
766001 | 766001 | 2020-11-25 | Clay | Minnesota | 27027 | 4638 | 56 |
762756 | 762756 | 2020-11-24 | Clay | Minnesota | 27027 | 4496 | 55 |
759511 | 759511 | 2020-11-23 | Clay | Minnesota | 27027 | 4451 | 55 |
756264 | 756264 | 2020-11-22 | Clay | Minnesota | 27027 | 4359 | 54 |
753018 | 753018 | 2020-11-21 | Clay | Minnesota | 27027 | 4248 | 52 |
749772 | 749772 | 2020-11-20 | Clay | Minnesota | 27027 | 4144 | 52 |
746526 | 746526 | 2020-11-19 | Clay | Minnesota | 27027 | 4076 | 51 |
743279 | 743279 | 2020-11-18 | Clay | Minnesota | 27027 | 3955 | 51 |
740032 | 740032 | 2020-11-17 | Clay | Minnesota | 27027 | 3902 | 50 |
736788 | 736788 | 2020-11-16 | Clay | Minnesota | 27027 | 3841 | 50 |
733542 | 733542 | 2020-11-15 | Clay | Minnesota | 27027 | 3773 | 50 |
730297 | 730297 | 2020-11-14 | Clay | Minnesota | 27027 | 3693 | 50 |
727054 | 727054 | 2020-11-13 | Clay | Minnesota | 27027 | 3582 | 50 |
723811 | 723811 | 2020-11-12 | Clay | Minnesota | 27027 | 3490 | 48 |
720568 | 720568 | 2020-11-11 | Clay | Minnesota | 27027 | 3356 | 48 |
717325 | 717325 | 2020-11-10 | Clay | Minnesota | 27027 | 3276 | 46 |
714081 | 714081 | 2020-11-09 | Clay | Minnesota | 27027 | 3233 | 46 |
710837 | 710837 | 2020-11-08 | Clay | Minnesota | 27027 | 3203 | 46 |
707593 | 707593 | 2020-11-07 | Clay | Minnesota | 27027 | 3087 | 46 |
704350 | 704350 | 2020-11-06 | Clay | Minnesota | 27027 | 3014 | 46 |
701108 | 701108 | 2020-11-05 | Clay | Minnesota | 27027 | 2934 | 46 |
697864 | 697864 | 2020-11-04 | Clay | Minnesota | 27027 | 2888 | 46 |
694621 | 694621 | 2020-11-03 | Clay | Minnesota | 27027 | 2762 | 46 |
691379 | 691379 | 2020-11-02 | Clay | Minnesota | 27027 | 2712 | 46 |
688134 | 688134 | 2020-11-01 | Clay | Minnesota | 27027 | 2690 | 45 |
684890 | 684890 | 2020-10-31 | Clay | Minnesota | 27027 | 2613 | 45 |
681647 | 681647 | 2020-10-30 | Clay | Minnesota | 27027 | 2591 | 45 |
678403 | 678403 | 2020-10-29 | Clay | Minnesota | 27027 | 2529 | 44 |
675161 | 675161 | 2020-10-28 | Clay | Minnesota | 27027 | 2464 | 43 |
671918 | 671918 | 2020-10-27 | Clay | Minnesota | 27027 | 2362 | 43 |
668676 | 668676 | 2020-10-26 | Clay | Minnesota | 27027 | 2328 | 43 |
665432 | 665432 | 2020-10-25 | Clay | Minnesota | 27027 | 2297 | 43 |
662187 | 662187 | 2020-10-24 | Clay | Minnesota | 27027 | 2280 | 43 |
658943 | 658943 | 2020-10-23 | Clay | Minnesota | 27027 | 2214 | 43 |
655698 | 655698 | 2020-10-22 | Clay | Minnesota | 27027 | 2153 | 43 |
652453 | 652453 | 2020-10-21 | Clay | Minnesota | 27027 | 2093 | 43 |
649208 | 649208 | 2020-10-20 | Clay | Minnesota | 27027 | 2073 | 43 |
645964 | 645964 | 2020-10-19 | Clay | Minnesota | 27027 | 2032 | 43 |
642717 | 642717 | 2020-10-18 | Clay | Minnesota | 27027 | 2008 | 43 |
639470 | 639470 | 2020-10-17 | Clay | Minnesota | 27027 | 1966 | 43 |
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 |
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);