ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "San Miguel" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053807 | 1053807 | 2021-02-22 | San Miguel | Colorado | 8113 | 802 | 0 |
1050560 | 1050560 | 2021-02-21 | San Miguel | Colorado | 8113 | 803 | 0 |
1047313 | 1047313 | 2021-02-20 | San Miguel | Colorado | 8113 | 801 | 0 |
1044068 | 1044068 | 2021-02-19 | San Miguel | Colorado | 8113 | 797 | 0 |
1040823 | 1040823 | 2021-02-18 | San Miguel | Colorado | 8113 | 797 | 0 |
1037578 | 1037578 | 2021-02-17 | San Miguel | Colorado | 8113 | 797 | 0 |
1034333 | 1034333 | 2021-02-16 | San Miguel | Colorado | 8113 | 793 | 0 |
1031087 | 1031087 | 2021-02-15 | San Miguel | Colorado | 8113 | 793 | 0 |
1027840 | 1027840 | 2021-02-14 | San Miguel | Colorado | 8113 | 791 | 0 |
1024595 | 1024595 | 2021-02-13 | San Miguel | Colorado | 8113 | 787 | 0 |
1021350 | 1021350 | 2021-02-12 | San Miguel | Colorado | 8113 | 786 | 0 |
1018105 | 1018105 | 2021-02-11 | San Miguel | Colorado | 8113 | 770 | 0 |
1014860 | 1014860 | 2021-02-10 | San Miguel | Colorado | 8113 | 760 | 0 |
1011615 | 1011615 | 2021-02-09 | San Miguel | Colorado | 8113 | 750 | 0 |
1008369 | 1008369 | 2021-02-08 | San Miguel | Colorado | 8113 | 739 | 0 |
1005123 | 1005123 | 2021-02-07 | San Miguel | Colorado | 8113 | 733 | 0 |
1001877 | 1001877 | 2021-02-06 | San Miguel | Colorado | 8113 | 732 | 0 |
998631 | 998631 | 2021-02-05 | San Miguel | Colorado | 8113 | 720 | 0 |
995385 | 995385 | 2021-02-04 | San Miguel | Colorado | 8113 | 703 | 0 |
992139 | 992139 | 2021-02-03 | San Miguel | Colorado | 8113 | 684 | 0 |
988893 | 988893 | 2021-02-02 | San Miguel | Colorado | 8113 | 684 | 0 |
985646 | 985646 | 2021-02-01 | San Miguel | Colorado | 8113 | 682 | 0 |
982399 | 982399 | 2021-01-31 | San Miguel | Colorado | 8113 | 667 | 0 |
979153 | 979153 | 2021-01-30 | San Miguel | Colorado | 8113 | 667 | 0 |
975908 | 975908 | 2021-01-29 | San Miguel | Colorado | 8113 | 667 | 0 |
972663 | 972663 | 2021-01-28 | San Miguel | Colorado | 8113 | 645 | 0 |
969418 | 969418 | 2021-01-27 | San Miguel | Colorado | 8113 | 612 | 0 |
966174 | 966174 | 2021-01-26 | San Miguel | Colorado | 8113 | 611 | 0 |
962929 | 962929 | 2021-01-25 | San Miguel | Colorado | 8113 | 597 | 0 |
959684 | 959684 | 2021-01-24 | San Miguel | Colorado | 8113 | 597 | 0 |
956438 | 956438 | 2021-01-23 | San Miguel | Colorado | 8113 | 594 | 0 |
953193 | 953193 | 2021-01-22 | San Miguel | Colorado | 8113 | 583 | 0 |
949948 | 949948 | 2021-01-21 | San Miguel | Colorado | 8113 | 532 | 0 |
946702 | 946702 | 2021-01-20 | San Miguel | Colorado | 8113 | 484 | 0 |
943455 | 943455 | 2021-01-19 | San Miguel | Colorado | 8113 | 480 | 0 |
940210 | 940210 | 2021-01-18 | San Miguel | Colorado | 8113 | 469 | 0 |
936965 | 936965 | 2021-01-17 | San Miguel | Colorado | 8113 | 466 | 0 |
933720 | 933720 | 2021-01-16 | San Miguel | Colorado | 8113 | 462 | 0 |
930475 | 930475 | 2021-01-15 | San Miguel | Colorado | 8113 | 449 | 0 |
927230 | 927230 | 2021-01-14 | San Miguel | Colorado | 8113 | 443 | 0 |
923984 | 923984 | 2021-01-13 | San Miguel | Colorado | 8113 | 437 | 0 |
920739 | 920739 | 2021-01-12 | San Miguel | Colorado | 8113 | 435 | 0 |
917494 | 917494 | 2021-01-11 | San Miguel | Colorado | 8113 | 433 | 0 |
914249 | 914249 | 2021-01-10 | San Miguel | Colorado | 8113 | 431 | 0 |
911004 | 911004 | 2021-01-09 | San Miguel | Colorado | 8113 | 417 | 0 |
907759 | 907759 | 2021-01-08 | San Miguel | Colorado | 8113 | 413 | 0 |
904513 | 904513 | 2021-01-07 | San Miguel | Colorado | 8113 | 407 | 0 |
901268 | 901268 | 2021-01-06 | San Miguel | Colorado | 8113 | 399 | 0 |
898023 | 898023 | 2021-01-05 | San Miguel | Colorado | 8113 | 399 | 0 |
894778 | 894778 | 2021-01-04 | San Miguel | Colorado | 8113 | 400 | 0 |
891531 | 891531 | 2021-01-03 | San Miguel | Colorado | 8113 | 400 | 0 |
888284 | 888284 | 2021-01-02 | San Miguel | Colorado | 8113 | 396 | 0 |
885039 | 885039 | 2021-01-01 | San Miguel | Colorado | 8113 | 394 | 0 |
881794 | 881794 | 2020-12-31 | San Miguel | Colorado | 8113 | 394 | 0 |
878549 | 878549 | 2020-12-30 | San Miguel | Colorado | 8113 | 391 | 0 |
875304 | 875304 | 2020-12-29 | San Miguel | Colorado | 8113 | 389 | 0 |
872059 | 872059 | 2020-12-28 | San Miguel | Colorado | 8113 | 388 | 0 |
868814 | 868814 | 2020-12-27 | San Miguel | Colorado | 8113 | 388 | 0 |
865569 | 865569 | 2020-12-26 | San Miguel | Colorado | 8113 | 384 | 0 |
862324 | 862324 | 2020-12-25 | San Miguel | Colorado | 8113 | 384 | 0 |
859079 | 859079 | 2020-12-24 | San Miguel | Colorado | 8113 | 383 | 0 |
855834 | 855834 | 2020-12-23 | San Miguel | Colorado | 8113 | 379 | 0 |
852589 | 852589 | 2020-12-22 | San Miguel | Colorado | 8113 | 378 | 0 |
849344 | 849344 | 2020-12-21 | San Miguel | Colorado | 8113 | 372 | 0 |
846099 | 846099 | 2020-12-20 | San Miguel | Colorado | 8113 | 371 | 0 |
842853 | 842853 | 2020-12-19 | San Miguel | Colorado | 8113 | 366 | 0 |
839608 | 839608 | 2020-12-18 | San Miguel | Colorado | 8113 | 337 | 0 |
836363 | 836363 | 2020-12-17 | San Miguel | Colorado | 8113 | 317 | 0 |
833117 | 833117 | 2020-12-16 | San Miguel | Colorado | 8113 | 302 | 0 |
829870 | 829870 | 2020-12-15 | San Miguel | Colorado | 8113 | 296 | 0 |
826624 | 826624 | 2020-12-14 | San Miguel | Colorado | 8113 | 288 | 0 |
823377 | 823377 | 2020-12-13 | San Miguel | Colorado | 8113 | 288 | 0 |
820131 | 820131 | 2020-12-12 | San Miguel | Colorado | 8113 | 283 | 0 |
816885 | 816885 | 2020-12-11 | San Miguel | Colorado | 8113 | 269 | 0 |
813639 | 813639 | 2020-12-10 | San Miguel | Colorado | 8113 | 264 | 0 |
810395 | 810395 | 2020-12-09 | San Miguel | Colorado | 8113 | 251 | 0 |
807150 | 807150 | 2020-12-08 | San Miguel | Colorado | 8113 | 269 | 0 |
803905 | 803905 | 2020-12-07 | San Miguel | Colorado | 8113 | 268 | 0 |
800660 | 800660 | 2020-12-06 | San Miguel | Colorado | 8113 | 267 | 0 |
797415 | 797415 | 2020-12-05 | San Miguel | Colorado | 8113 | 255 | 0 |
794170 | 794170 | 2020-12-04 | San Miguel | Colorado | 8113 | 227 | 0 |
790925 | 790925 | 2020-12-03 | San Miguel | Colorado | 8113 | 222 | 0 |
787680 | 787680 | 2020-12-02 | San Miguel | Colorado | 8113 | 216 | 0 |
784436 | 784436 | 2020-12-01 | San Miguel | Colorado | 8113 | 213 | 0 |
781191 | 781191 | 2020-11-30 | San Miguel | Colorado | 8113 | 211 | 0 |
777945 | 777945 | 2020-11-29 | San Miguel | Colorado | 8113 | 211 | 0 |
774700 | 774700 | 2020-11-28 | San Miguel | Colorado | 8113 | 196 | 0 |
771455 | 771455 | 2020-11-27 | San Miguel | Colorado | 8113 | 192 | 0 |
768210 | 768210 | 2020-11-26 | San Miguel | Colorado | 8113 | 190 | 0 |
764964 | 764964 | 2020-11-25 | San Miguel | Colorado | 8113 | 188 | 0 |
761719 | 761719 | 2020-11-24 | San Miguel | Colorado | 8113 | 186 | 0 |
758474 | 758474 | 2020-11-23 | San Miguel | Colorado | 8113 | 184 | 0 |
755227 | 755227 | 2020-11-22 | San Miguel | Colorado | 8113 | 178 | 0 |
751981 | 751981 | 2020-11-21 | San Miguel | Colorado | 8113 | 180 | 0 |
748735 | 748735 | 2020-11-20 | San Miguel | Colorado | 8113 | 174 | 0 |
745489 | 745489 | 2020-11-19 | San Miguel | Colorado | 8113 | 173 | 0 |
742242 | 742242 | 2020-11-18 | San Miguel | Colorado | 8113 | 168 | 0 |
738995 | 738995 | 2020-11-17 | San Miguel | Colorado | 8113 | 166 | 0 |
735751 | 735751 | 2020-11-16 | San Miguel | Colorado | 8113 | 165 | 0 |
732505 | 732505 | 2020-11-15 | San Miguel | Colorado | 8113 | 163 | 0 |
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);