ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Anoka" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921765 | 921765 | 2021-01-12 | Anoka | Minnesota | 27003 | 30475 | 352 |
918520 | 918520 | 2021-01-11 | Anoka | Minnesota | 27003 | 30430 | 347 |
915275 | 915275 | 2021-01-10 | Anoka | Minnesota | 27003 | 30354 | 347 |
912030 | 912030 | 2021-01-09 | Anoka | Minnesota | 27003 | 30210 | 346 |
908785 | 908785 | 2021-01-08 | Anoka | Minnesota | 27003 | 30068 | 342 |
905539 | 905539 | 2021-01-07 | Anoka | Minnesota | 27003 | 29922 | 339 |
902294 | 902294 | 2021-01-06 | Anoka | Minnesota | 27003 | 29803 | 337 |
899049 | 899049 | 2021-01-05 | Anoka | Minnesota | 27003 | 29635 | 335 |
895804 | 895804 | 2021-01-04 | Anoka | Minnesota | 27003 | 29531 | 334 |
892557 | 892557 | 2021-01-03 | Anoka | Minnesota | 27003 | 29310 | 332 |
889311 | 889311 | 2021-01-02 | Anoka | Minnesota | 27003 | 29116 | 327 |
886065 | 886065 | 2021-01-01 | Anoka | Minnesota | 27003 | 28973 | 323 |
882820 | 882820 | 2020-12-31 | Anoka | Minnesota | 27003 | 28973 | 323 |
879575 | 879575 | 2020-12-30 | Anoka | Minnesota | 27003 | 28886 | 322 |
876330 | 876330 | 2020-12-29 | Anoka | Minnesota | 27003 | 28773 | 320 |
873085 | 873085 | 2020-12-28 | Anoka | Minnesota | 27003 | 28716 | 317 |
869840 | 869840 | 2020-12-27 | Anoka | Minnesota | 27003 | 28635 | 317 |
866595 | 866595 | 2020-12-26 | Anoka | Minnesota | 27003 | 28436 | 312 |
863350 | 863350 | 2020-12-25 | Anoka | Minnesota | 27003 | 28326 | 307 |
860105 | 860105 | 2020-12-24 | Anoka | Minnesota | 27003 | 28326 | 307 |
856860 | 856860 | 2020-12-23 | Anoka | Minnesota | 27003 | 28226 | 302 |
853615 | 853615 | 2020-12-22 | Anoka | Minnesota | 27003 | 28113 | 295 |
850370 | 850370 | 2020-12-21 | Anoka | Minnesota | 27003 | 27974 | 295 |
847125 | 847125 | 2020-12-20 | Anoka | Minnesota | 27003 | 27829 | 291 |
843879 | 843879 | 2020-12-19 | Anoka | Minnesota | 27003 | 27654 | 285 |
840634 | 840634 | 2020-12-18 | Anoka | Minnesota | 27003 | 27470 | 281 |
837389 | 837389 | 2020-12-17 | Anoka | Minnesota | 27003 | 27329 | 272 |
834143 | 834143 | 2020-12-16 | Anoka | Minnesota | 27003 | 27164 | 268 |
830896 | 830896 | 2020-12-15 | Anoka | Minnesota | 27003 | 27003 | 265 |
827650 | 827650 | 2020-12-14 | Anoka | Minnesota | 27003 | 26802 | 263 |
824403 | 824403 | 2020-12-13 | Anoka | Minnesota | 27003 | 26575 | 262 |
821157 | 821157 | 2020-12-12 | Anoka | Minnesota | 27003 | 26364 | 255 |
817911 | 817911 | 2020-12-11 | Anoka | Minnesota | 27003 | 26078 | 254 |
814665 | 814665 | 2020-12-10 | Anoka | Minnesota | 27003 | 25815 | 250 |
811420 | 811420 | 2020-12-09 | Anoka | Minnesota | 27003 | 25626 | 247 |
808175 | 808175 | 2020-12-08 | Anoka | Minnesota | 27003 | 25287 | 246 |
804930 | 804930 | 2020-12-07 | Anoka | Minnesota | 27003 | 25033 | 246 |
801685 | 801685 | 2020-12-06 | Anoka | Minnesota | 27003 | 24617 | 245 |
798440 | 798440 | 2020-12-05 | Anoka | Minnesota | 27003 | 24254 | 241 |
795195 | 795195 | 2020-12-04 | Anoka | Minnesota | 27003 | 23888 | 238 |
791950 | 791950 | 2020-12-03 | Anoka | Minnesota | 27003 | 23541 | 236 |
788705 | 788705 | 2020-12-02 | Anoka | Minnesota | 27003 | 23196 | 232 |
785460 | 785460 | 2020-12-01 | Anoka | Minnesota | 27003 | 22841 | 228 |
782216 | 782216 | 2020-11-30 | Anoka | Minnesota | 27003 | 22583 | 228 |
778970 | 778970 | 2020-11-29 | Anoka | Minnesota | 27003 | 22149 | 228 |
775725 | 775725 | 2020-11-28 | Anoka | Minnesota | 27003 | 21526 | 225 |
772480 | 772480 | 2020-11-27 | Anoka | Minnesota | 27003 | 20851 | 224 |
769235 | 769235 | 2020-11-26 | Anoka | Minnesota | 27003 | 20522 | 218 |
765989 | 765989 | 2020-11-25 | Anoka | Minnesota | 27003 | 20522 | 218 |
762744 | 762744 | 2020-11-24 | Anoka | Minnesota | 27003 | 20172 | 216 |
759499 | 759499 | 2020-11-23 | Anoka | Minnesota | 27003 | 19724 | 213 |
756252 | 756252 | 2020-11-22 | Anoka | Minnesota | 27003 | 19211 | 213 |
753006 | 753006 | 2020-11-21 | Anoka | Minnesota | 27003 | 18740 | 210 |
749760 | 749760 | 2020-11-20 | Anoka | Minnesota | 27003 | 18296 | 208 |
746514 | 746514 | 2020-11-19 | Anoka | Minnesota | 27003 | 17859 | 203 |
743267 | 743267 | 2020-11-18 | Anoka | Minnesota | 27003 | 17374 | 196 |
740020 | 740020 | 2020-11-17 | Anoka | Minnesota | 27003 | 16981 | 193 |
736776 | 736776 | 2020-11-16 | Anoka | Minnesota | 27003 | 16571 | 190 |
733530 | 733530 | 2020-11-15 | Anoka | Minnesota | 27003 | 15956 | 189 |
730285 | 730285 | 2020-11-14 | Anoka | Minnesota | 27003 | 15539 | 188 |
727042 | 727042 | 2020-11-13 | Anoka | Minnesota | 27003 | 14815 | 187 |
723799 | 723799 | 2020-11-12 | Anoka | Minnesota | 27003 | 14363 | 185 |
720556 | 720556 | 2020-11-11 | Anoka | Minnesota | 27003 | 13689 | 183 |
717313 | 717313 | 2020-11-10 | Anoka | Minnesota | 27003 | 13321 | 178 |
714069 | 714069 | 2020-11-09 | Anoka | Minnesota | 27003 | 12787 | 177 |
710825 | 710825 | 2020-11-08 | Anoka | Minnesota | 27003 | 12436 | 175 |
707581 | 707581 | 2020-11-07 | Anoka | Minnesota | 27003 | 11961 | 174 |
704338 | 704338 | 2020-11-06 | Anoka | Minnesota | 27003 | 11561 | 169 |
701096 | 701096 | 2020-11-05 | Anoka | Minnesota | 27003 | 11103 | 165 |
697852 | 697852 | 2020-11-04 | Anoka | Minnesota | 27003 | 10778 | 161 |
694609 | 694609 | 2020-11-03 | Anoka | Minnesota | 27003 | 10514 | 161 |
691367 | 691367 | 2020-11-02 | Anoka | Minnesota | 27003 | 10246 | 159 |
688122 | 688122 | 2020-11-01 | Anoka | Minnesota | 27003 | 9947 | 159 |
684878 | 684878 | 2020-10-31 | Anoka | Minnesota | 27003 | 9812 | 158 |
681635 | 681635 | 2020-10-30 | Anoka | Minnesota | 27003 | 9573 | 156 |
678391 | 678391 | 2020-10-29 | Anoka | Minnesota | 27003 | 9344 | 155 |
675149 | 675149 | 2020-10-28 | Anoka | Minnesota | 27003 | 9160 | 153 |
671906 | 671906 | 2020-10-27 | Anoka | Minnesota | 27003 | 9039 | 151 |
668664 | 668664 | 2020-10-26 | Anoka | Minnesota | 27003 | 8872 | 150 |
665420 | 665420 | 2020-10-25 | Anoka | Minnesota | 27003 | 8661 | 150 |
662175 | 662175 | 2020-10-24 | Anoka | Minnesota | 27003 | 8552 | 150 |
658931 | 658931 | 2020-10-23 | Anoka | Minnesota | 27003 | 8414 | 150 |
655686 | 655686 | 2020-10-22 | Anoka | Minnesota | 27003 | 8324 | 150 |
652441 | 652441 | 2020-10-21 | Anoka | Minnesota | 27003 | 8216 | 150 |
649196 | 649196 | 2020-10-20 | Anoka | Minnesota | 27003 | 8154 | 148 |
645952 | 645952 | 2020-10-19 | Anoka | Minnesota | 27003 | 8093 | 148 |
642705 | 642705 | 2020-10-18 | Anoka | Minnesota | 27003 | 7955 | 148 |
639458 | 639458 | 2020-10-17 | Anoka | Minnesota | 27003 | 7826 | 147 |
636212 | 636212 | 2020-10-16 | Anoka | Minnesota | 27003 | 7715 | 147 |
632966 | 632966 | 2020-10-15 | Anoka | Minnesota | 27003 | 7614 | 147 |
629721 | 629721 | 2020-10-14 | Anoka | Minnesota | 27003 | 7548 | 144 |
626477 | 626477 | 2020-10-13 | Anoka | Minnesota | 27003 | 7485 | 144 |
623235 | 623235 | 2020-10-12 | Anoka | Minnesota | 27003 | 7372 | 144 |
619992 | 619992 | 2020-10-11 | Anoka | Minnesota | 27003 | 7277 | 143 |
616750 | 616750 | 2020-10-10 | Anoka | Minnesota | 27003 | 7177 | 142 |
613509 | 613509 | 2020-10-09 | Anoka | Minnesota | 27003 | 7061 | 142 |
610267 | 610267 | 2020-10-08 | Anoka | Minnesota | 27003 | 6958 | 142 |
607025 | 607025 | 2020-10-07 | Anoka | Minnesota | 27003 | 6892 | 141 |
603782 | 603782 | 2020-10-06 | Anoka | Minnesota | 27003 | 6826 | 141 |
600540 | 600540 | 2020-10-05 | Anoka | Minnesota | 27003 | 6729 | 140 |
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);