ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,352 rows where county = "Douglas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934765 | 934765 | 2021-01-16 | Douglas | Minnesota | 27041 | 3724 | 66 |
934948 | 934948 | 2021-01-16 | Douglas | Missouri | 29067 | 709 | 20 |
935115 | 935115 | 2021-01-16 | Douglas | Nebraska | 31055 | 58043 | 561 |
935184 | 935184 | 2021-01-16 | Douglas | Nevada | 32005 | 2250 | 25 |
935653 | 935653 | 2021-01-16 | Douglas | Oregon | 41019 | 1666 | 43 |
935898 | 935898 | 2021-01-16 | Douglas | South Dakota | 46043 | 404 | 9 |
936483 | 936483 | 2021-01-16 | Douglas | Washington | 53017 | 2957 | 17 |
936584 | 936584 | 2021-01-16 | Douglas | Wisconsin | 55031 | 3884 | 30 |
930436 | 930436 | 2021-01-15 | Douglas | Colorado | 8035 | 18024 | 217 |
930611 | 930611 | 2021-01-15 | Douglas | Georgia | 13097 | 10083 | 122 |
930794 | 930794 | 2021-01-15 | Douglas | Illinois | 17041 | 1986 | 33 |
931090 | 931090 | 2021-01-15 | Douglas | Kansas | 20045 | 7470 | 36 |
931520 | 931520 | 2021-01-15 | Douglas | Minnesota | 27041 | 3715 | 66 |
931703 | 931703 | 2021-01-15 | Douglas | Missouri | 29067 | 702 | 20 |
931870 | 931870 | 2021-01-15 | Douglas | Nebraska | 31055 | 58043 | 561 |
931939 | 931939 | 2021-01-15 | Douglas | Nevada | 32005 | 2235 | 25 |
932408 | 932408 | 2021-01-15 | Douglas | Oregon | 41019 | 1650 | 43 |
932653 | 932653 | 2021-01-15 | Douglas | South Dakota | 46043 | 401 | 9 |
933238 | 933238 | 2021-01-15 | Douglas | Washington | 53017 | 2957 | 17 |
933339 | 933339 | 2021-01-15 | Douglas | Wisconsin | 55031 | 3863 | 30 |
927191 | 927191 | 2021-01-14 | Douglas | Colorado | 8035 | 17911 | 216 |
927366 | 927366 | 2021-01-14 | Douglas | Georgia | 13097 | 9969 | 121 |
927549 | 927549 | 2021-01-14 | Douglas | Illinois | 17041 | 1982 | 33 |
927845 | 927845 | 2021-01-14 | Douglas | Kansas | 20045 | 7440 | 36 |
928275 | 928275 | 2021-01-14 | Douglas | Minnesota | 27041 | 3703 | 66 |
928458 | 928458 | 2021-01-14 | Douglas | Missouri | 29067 | 697 | 20 |
928625 | 928625 | 2021-01-14 | Douglas | Nebraska | 31055 | 57813 | 554 |
928694 | 928694 | 2021-01-14 | Douglas | Nevada | 32005 | 2223 | 25 |
929163 | 929163 | 2021-01-14 | Douglas | Oregon | 41019 | 1629 | 43 |
929408 | 929408 | 2021-01-14 | Douglas | South Dakota | 46043 | 396 | 9 |
929993 | 929993 | 2021-01-14 | Douglas | Washington | 53017 | 2949 | 16 |
930094 | 930094 | 2021-01-14 | Douglas | Wisconsin | 55031 | 3831 | 30 |
923945 | 923945 | 2021-01-13 | Douglas | Colorado | 8035 | 17720 | 215 |
924120 | 924120 | 2021-01-13 | Douglas | Georgia | 13097 | 9873 | 120 |
924303 | 924303 | 2021-01-13 | Douglas | Illinois | 17041 | 1978 | 32 |
924599 | 924599 | 2021-01-13 | Douglas | Kansas | 20045 | 7373 | 36 |
925029 | 925029 | 2021-01-13 | Douglas | Minnesota | 27041 | 3693 | 66 |
925212 | 925212 | 2021-01-13 | Douglas | Missouri | 29067 | 694 | 20 |
925379 | 925379 | 2021-01-13 | Douglas | Nebraska | 31055 | 57546 | 548 |
925448 | 925448 | 2021-01-13 | Douglas | Nevada | 32005 | 2208 | 25 |
925918 | 925918 | 2021-01-13 | Douglas | Oregon | 41019 | 1614 | 43 |
926163 | 926163 | 2021-01-13 | Douglas | South Dakota | 46043 | 397 | 9 |
926748 | 926748 | 2021-01-13 | Douglas | Washington | 53017 | 2932 | 15 |
926849 | 926849 | 2021-01-13 | Douglas | Wisconsin | 55031 | 3801 | 30 |
920700 | 920700 | 2021-01-12 | Douglas | Colorado | 8035 | 17594 | 214 |
920875 | 920875 | 2021-01-12 | Douglas | Georgia | 13097 | 9746 | 117 |
921058 | 921058 | 2021-01-12 | Douglas | Illinois | 17041 | 1967 | 32 |
921354 | 921354 | 2021-01-12 | Douglas | Kansas | 20045 | 7287 | 36 |
921784 | 921784 | 2021-01-12 | Douglas | Minnesota | 27041 | 3683 | 65 |
921967 | 921967 | 2021-01-12 | Douglas | Missouri | 29067 | 688 | 20 |
922134 | 922134 | 2021-01-12 | Douglas | Nebraska | 31055 | 57113 | 544 |
922203 | 922203 | 2021-01-12 | Douglas | Nevada | 32005 | 2176 | 25 |
922672 | 922672 | 2021-01-12 | Douglas | Oregon | 41019 | 1590 | 42 |
922917 | 922917 | 2021-01-12 | Douglas | South Dakota | 46043 | 396 | 9 |
923502 | 923502 | 2021-01-12 | Douglas | Washington | 53017 | 2910 | 15 |
923603 | 923603 | 2021-01-12 | Douglas | Wisconsin | 55031 | 3782 | 30 |
917455 | 917455 | 2021-01-11 | Douglas | Colorado | 8035 | 17520 | 212 |
917630 | 917630 | 2021-01-11 | Douglas | Georgia | 13097 | 9645 | 116 |
917813 | 917813 | 2021-01-11 | Douglas | Illinois | 17041 | 1956 | 33 |
918109 | 918109 | 2021-01-11 | Douglas | Kansas | 20045 | 7233 | 36 |
918539 | 918539 | 2021-01-11 | Douglas | Minnesota | 27041 | 3669 | 64 |
918722 | 918722 | 2021-01-11 | Douglas | Missouri | 29067 | 682 | 20 |
918889 | 918889 | 2021-01-11 | Douglas | Nebraska | 31055 | 56784 | 544 |
918958 | 918958 | 2021-01-11 | Douglas | Nevada | 32005 | 2176 | 25 |
919427 | 919427 | 2021-01-11 | Douglas | Oregon | 41019 | 1570 | 42 |
919672 | 919672 | 2021-01-11 | Douglas | South Dakota | 46043 | 396 | 9 |
920257 | 920257 | 2021-01-11 | Douglas | Washington | 53017 | 2864 | 15 |
920358 | 920358 | 2021-01-11 | Douglas | Wisconsin | 55031 | 3760 | 30 |
914210 | 914210 | 2021-01-10 | Douglas | Colorado | 8035 | 17420 | 212 |
914385 | 914385 | 2021-01-10 | Douglas | Georgia | 13097 | 9535 | 116 |
914568 | 914568 | 2021-01-10 | Douglas | Illinois | 17041 | 1945 | 33 |
914864 | 914864 | 2021-01-10 | Douglas | Kansas | 20045 | 7046 | 36 |
915294 | 915294 | 2021-01-10 | Douglas | Minnesota | 27041 | 3663 | 64 |
915477 | 915477 | 2021-01-10 | Douglas | Missouri | 29067 | 679 | 20 |
915644 | 915644 | 2021-01-10 | Douglas | Nebraska | 31055 | 56528 | 541 |
915713 | 915713 | 2021-01-10 | Douglas | Nevada | 32005 | 2162 | 25 |
916182 | 916182 | 2021-01-10 | Douglas | Oregon | 41019 | 1554 | 42 |
916427 | 916427 | 2021-01-10 | Douglas | South Dakota | 46043 | 395 | 9 |
917012 | 917012 | 2021-01-10 | Douglas | Washington | 53017 | 2852 | 15 |
917113 | 917113 | 2021-01-10 | Douglas | Wisconsin | 55031 | 3744 | 30 |
910965 | 910965 | 2021-01-09 | Douglas | Colorado | 8035 | 17264 | 211 |
911140 | 911140 | 2021-01-09 | Douglas | Georgia | 13097 | 9444 | 116 |
911323 | 911323 | 2021-01-09 | Douglas | Illinois | 17041 | 1944 | 33 |
911619 | 911619 | 2021-01-09 | Douglas | Kansas | 20045 | 7046 | 36 |
912049 | 912049 | 2021-01-09 | Douglas | Minnesota | 27041 | 3653 | 64 |
912232 | 912232 | 2021-01-09 | Douglas | Missouri | 29067 | 677 | 20 |
912399 | 912399 | 2021-01-09 | Douglas | Nebraska | 31055 | 56390 | 541 |
912468 | 912468 | 2021-01-09 | Douglas | Nevada | 32005 | 2147 | 25 |
912937 | 912937 | 2021-01-09 | Douglas | Oregon | 41019 | 1542 | 42 |
913182 | 913182 | 2021-01-09 | Douglas | South Dakota | 46043 | 391 | 9 |
913767 | 913767 | 2021-01-09 | Douglas | Washington | 53017 | 2852 | 15 |
913868 | 913868 | 2021-01-09 | Douglas | Wisconsin | 55031 | 3736 | 30 |
907720 | 907720 | 2021-01-08 | Douglas | Colorado | 8035 | 16957 | 210 |
907895 | 907895 | 2021-01-08 | Douglas | Georgia | 13097 | 9279 | 113 |
908078 | 908078 | 2021-01-08 | Douglas | Illinois | 17041 | 1942 | 34 |
908374 | 908374 | 2021-01-08 | Douglas | Kansas | 20045 | 7046 | 36 |
908804 | 908804 | 2021-01-08 | Douglas | Minnesota | 27041 | 3635 | 64 |
908987 | 908987 | 2021-01-08 | Douglas | Missouri | 29067 | 665 | 20 |
909154 | 909154 | 2021-01-08 | Douglas | Nebraska | 31055 | 56038 | 541 |
909223 | 909223 | 2021-01-08 | Douglas | Nevada | 32005 | 2132 | 24 |
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);