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 |
---|---|---|---|---|---|---|---|
895823 | 895823 | 2021-01-04 | Douglas | Minnesota | 27041 | 3553 | 61 |
896006 | 896006 | 2021-01-04 | Douglas | Missouri | 29067 | 638 | 19 |
896173 | 896173 | 2021-01-04 | Douglas | Nebraska | 31055 | 54328 | 519 |
896242 | 896242 | 2021-01-04 | Douglas | Nevada | 32005 | 2073 | 18 |
896711 | 896711 | 2021-01-04 | Douglas | Oregon | 41019 | 1453 | 40 |
896956 | 896956 | 2021-01-04 | Douglas | South Dakota | 46043 | 385 | 8 |
897541 | 897541 | 2021-01-04 | Douglas | Washington | 53017 | 2716 | 15 |
897642 | 897642 | 2021-01-04 | Douglas | Wisconsin | 55031 | 3552 | 30 |
891492 | 891492 | 2021-01-03 | Douglas | Colorado | 8035 | 16271 | 201 |
891667 | 891667 | 2021-01-03 | Douglas | Georgia | 13097 | 8665 | 109 |
891850 | 891850 | 2021-01-03 | Douglas | Illinois | 17041 | 1877 | 29 |
892146 | 892146 | 2021-01-03 | Douglas | Kansas | 20045 | 6482 | 34 |
892576 | 892576 | 2021-01-03 | Douglas | Minnesota | 27041 | 3531 | 60 |
892759 | 892759 | 2021-01-03 | Douglas | Missouri | 29067 | 638 | 19 |
892926 | 892926 | 2021-01-03 | Douglas | Nebraska | 31055 | 54097 | 515 |
892995 | 892995 | 2021-01-03 | Douglas | Nevada | 32005 | 2047 | 18 |
893465 | 893465 | 2021-01-03 | Douglas | Oregon | 41019 | 1439 | 40 |
893710 | 893710 | 2021-01-03 | Douglas | South Dakota | 46043 | 385 | 8 |
894295 | 894295 | 2021-01-03 | Douglas | Washington | 53017 | 2716 | 15 |
894396 | 894396 | 2021-01-03 | Douglas | Wisconsin | 55031 | 3546 | 30 |
888245 | 888245 | 2021-01-02 | Douglas | Colorado | 8035 | 16200 | 201 |
888420 | 888420 | 2021-01-02 | Douglas | Georgia | 13097 | 8554 | 109 |
888603 | 888603 | 2021-01-02 | Douglas | Illinois | 17041 | 1876 | 28 |
888900 | 888900 | 2021-01-02 | Douglas | Kansas | 20045 | 6482 | 34 |
889330 | 889330 | 2021-01-02 | Douglas | Minnesota | 27041 | 3507 | 60 |
889513 | 889513 | 2021-01-02 | Douglas | Missouri | 29067 | 635 | 19 |
889680 | 889680 | 2021-01-02 | Douglas | Nebraska | 31055 | 53815 | 515 |
889749 | 889749 | 2021-01-02 | Douglas | Nevada | 32005 | 2037 | 18 |
890219 | 890219 | 2021-01-02 | Douglas | Oregon | 41019 | 1436 | 40 |
890464 | 890464 | 2021-01-02 | Douglas | South Dakota | 46043 | 383 | 7 |
891049 | 891049 | 2021-01-02 | Douglas | Washington | 53017 | 2716 | 15 |
891150 | 891150 | 2021-01-02 | Douglas | Wisconsin | 55031 | 3536 | 30 |
885000 | 885000 | 2021-01-01 | Douglas | Colorado | 8035 | 16085 | 200 |
885175 | 885175 | 2021-01-01 | Douglas | Georgia | 13097 | 8440 | 109 |
885358 | 885358 | 2021-01-01 | Douglas | Illinois | 17041 | 1854 | 28 |
885654 | 885654 | 2021-01-01 | Douglas | Kansas | 20045 | 6482 | 34 |
886084 | 886084 | 2021-01-01 | Douglas | Minnesota | 27041 | 3481 | 59 |
886267 | 886267 | 2021-01-01 | Douglas | Missouri | 29067 | 631 | 19 |
886434 | 886434 | 2021-01-01 | Douglas | Nebraska | 31055 | 53595 | 515 |
886503 | 886503 | 2021-01-01 | Douglas | Nevada | 32005 | 1974 | 16 |
886972 | 886972 | 2021-01-01 | Douglas | Oregon | 41019 | 1426 | 39 |
887217 | 887217 | 2021-01-01 | Douglas | South Dakota | 46043 | 382 | 7 |
887802 | 887802 | 2021-01-01 | Douglas | Washington | 53017 | 2716 | 15 |
887903 | 887903 | 2021-01-01 | Douglas | Wisconsin | 55031 | 3522 | 30 |
881755 | 881755 | 2020-12-31 | Douglas | Colorado | 8035 | 15981 | 199 |
881930 | 881930 | 2020-12-31 | Douglas | Georgia | 13097 | 8264 | 109 |
882113 | 882113 | 2020-12-31 | Douglas | Illinois | 17041 | 1854 | 28 |
882409 | 882409 | 2020-12-31 | Douglas | Kansas | 20045 | 6482 | 34 |
882839 | 882839 | 2020-12-31 | Douglas | Minnesota | 27041 | 3481 | 59 |
883022 | 883022 | 2020-12-31 | Douglas | Missouri | 29067 | 617 | 19 |
883189 | 883189 | 2020-12-31 | Douglas | Nebraska | 31055 | 53284 | 515 |
883258 | 883258 | 2020-12-31 | Douglas | Nevada | 32005 | 1974 | 16 |
883727 | 883727 | 2020-12-31 | Douglas | Oregon | 41019 | 1387 | 39 |
883972 | 883972 | 2020-12-31 | Douglas | South Dakota | 46043 | 382 | 7 |
884557 | 884557 | 2020-12-31 | Douglas | Washington | 53017 | 2716 | 15 |
884658 | 884658 | 2020-12-31 | Douglas | Wisconsin | 55031 | 3515 | 30 |
878510 | 878510 | 2020-12-30 | Douglas | Colorado | 8035 | 15782 | 196 |
878685 | 878685 | 2020-12-30 | Douglas | Georgia | 13097 | 8124 | 108 |
878868 | 878868 | 2020-12-30 | Douglas | Illinois | 17041 | 1836 | 28 |
879164 | 879164 | 2020-12-30 | Douglas | Kansas | 20045 | 6428 | 34 |
879594 | 879594 | 2020-12-30 | Douglas | Minnesota | 27041 | 3465 | 58 |
879777 | 879777 | 2020-12-30 | Douglas | Missouri | 29067 | 608 | 19 |
879944 | 879944 | 2020-12-30 | Douglas | Nebraska | 31055 | 52700 | 501 |
880013 | 880013 | 2020-12-30 | Douglas | Nevada | 32005 | 1938 | 15 |
880482 | 880482 | 2020-12-30 | Douglas | Oregon | 41019 | 1366 | 38 |
880727 | 880727 | 2020-12-30 | Douglas | South Dakota | 46043 | 381 | 7 |
881312 | 881312 | 2020-12-30 | Douglas | Washington | 53017 | 2625 | 15 |
881413 | 881413 | 2020-12-30 | Douglas | Wisconsin | 55031 | 3479 | 29 |
875265 | 875265 | 2020-12-29 | Douglas | Colorado | 8035 | 15700 | 189 |
875440 | 875440 | 2020-12-29 | Douglas | Georgia | 13097 | 8037 | 108 |
875623 | 875623 | 2020-12-29 | Douglas | Illinois | 17041 | 1820 | 27 |
875919 | 875919 | 2020-12-29 | Douglas | Kansas | 20045 | 6371 | 32 |
876349 | 876349 | 2020-12-29 | Douglas | Minnesota | 27041 | 3462 | 58 |
876532 | 876532 | 2020-12-29 | Douglas | Missouri | 29067 | 604 | 19 |
876699 | 876699 | 2020-12-29 | Douglas | Nebraska | 31055 | 52205 | 493 |
876768 | 876768 | 2020-12-29 | Douglas | Nevada | 32005 | 1922 | 15 |
877237 | 877237 | 2020-12-29 | Douglas | Oregon | 41019 | 1358 | 38 |
877482 | 877482 | 2020-12-29 | Douglas | South Dakota | 46043 | 378 | 7 |
878067 | 878067 | 2020-12-29 | Douglas | Washington | 53017 | 2625 | 14 |
878168 | 878168 | 2020-12-29 | Douglas | Wisconsin | 55031 | 3458 | 29 |
872020 | 872020 | 2020-12-28 | Douglas | Colorado | 8035 | 15593 | 188 |
872195 | 872195 | 2020-12-28 | Douglas | Georgia | 13097 | 7935 | 108 |
872378 | 872378 | 2020-12-28 | Douglas | Illinois | 17041 | 1804 | 27 |
872674 | 872674 | 2020-12-28 | Douglas | Kansas | 20045 | 6292 | 32 |
873104 | 873104 | 2020-12-28 | Douglas | Minnesota | 27041 | 3448 | 57 |
873287 | 873287 | 2020-12-28 | Douglas | Missouri | 29067 | 599 | 19 |
873454 | 873454 | 2020-12-28 | Douglas | Nebraska | 31055 | 51960 | 489 |
873523 | 873523 | 2020-12-28 | Douglas | Nevada | 32005 | 1907 | 15 |
873992 | 873992 | 2020-12-28 | Douglas | Oregon | 41019 | 1358 | 37 |
874237 | 874237 | 2020-12-28 | Douglas | South Dakota | 46043 | 378 | 7 |
874822 | 874822 | 2020-12-28 | Douglas | Washington | 53017 | 2587 | 14 |
874923 | 874923 | 2020-12-28 | Douglas | Wisconsin | 55031 | 3428 | 29 |
868775 | 868775 | 2020-12-27 | Douglas | Colorado | 8035 | 15442 | 186 |
868950 | 868950 | 2020-12-27 | Douglas | Georgia | 13097 | 7910 | 108 |
869133 | 869133 | 2020-12-27 | Douglas | Illinois | 17041 | 1789 | 27 |
869429 | 869429 | 2020-12-27 | Douglas | Kansas | 20045 | 6146 | 31 |
869859 | 869859 | 2020-12-27 | Douglas | Minnesota | 27041 | 3434 | 57 |
870042 | 870042 | 2020-12-27 | Douglas | Missouri | 29067 | 597 | 19 |
870209 | 870209 | 2020-12-27 | Douglas | Nebraska | 31055 | 51605 | 480 |
870278 | 870278 | 2020-12-27 | Douglas | Nevada | 32005 | 1893 | 15 |
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);