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 |
---|---|---|---|---|---|---|---|
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 |
729260 | 729260 | 2020-11-14 | San Miguel | Colorado | 8113 | 155 | 0 |
726017 | 726017 | 2020-11-13 | San Miguel | Colorado | 8113 | 144 | 0 |
722774 | 722774 | 2020-11-12 | San Miguel | Colorado | 8113 | 128 | 0 |
719531 | 719531 | 2020-11-11 | San Miguel | Colorado | 8113 | 127 | 0 |
716288 | 716288 | 2020-11-10 | San Miguel | Colorado | 8113 | 126 | 0 |
713044 | 713044 | 2020-11-09 | San Miguel | Colorado | 8113 | 125 | 0 |
709800 | 709800 | 2020-11-08 | San Miguel | Colorado | 8113 | 118 | 0 |
706556 | 706556 | 2020-11-07 | San Miguel | Colorado | 8113 | 116 | 0 |
703313 | 703313 | 2020-11-06 | San Miguel | Colorado | 8113 | 114 | 0 |
700070 | 700070 | 2020-11-05 | San Miguel | Colorado | 8113 | 114 | 0 |
696826 | 696826 | 2020-11-04 | San Miguel | Colorado | 8113 | 112 | 0 |
693584 | 693584 | 2020-11-03 | San Miguel | Colorado | 8113 | 112 | 0 |
690341 | 690341 | 2020-11-02 | San Miguel | Colorado | 8113 | 111 | 0 |
687096 | 687096 | 2020-11-01 | San Miguel | Colorado | 8113 | 110 | 0 |
683852 | 683852 | 2020-10-31 | San Miguel | Colorado | 8113 | 109 | 0 |
680609 | 680609 | 2020-10-30 | San Miguel | Colorado | 8113 | 104 | 0 |
677366 | 677366 | 2020-10-29 | San Miguel | Colorado | 8113 | 104 | 0 |
674123 | 674123 | 2020-10-28 | San Miguel | Colorado | 8113 | 104 | 0 |
670881 | 670881 | 2020-10-27 | San Miguel | Colorado | 8113 | 102 | 0 |
667638 | 667638 | 2020-10-26 | San Miguel | Colorado | 8113 | 102 | 0 |
664393 | 664393 | 2020-10-25 | San Miguel | Colorado | 8113 | 101 | 0 |
661149 | 661149 | 2020-10-24 | San Miguel | Colorado | 8113 | 101 | 0 |
657905 | 657905 | 2020-10-23 | San Miguel | Colorado | 8113 | 100 | 0 |
654660 | 654660 | 2020-10-22 | San Miguel | Colorado | 8113 | 100 | 0 |
651415 | 651415 | 2020-10-21 | San Miguel | Colorado | 8113 | 100 | 0 |
648171 | 648171 | 2020-10-20 | San Miguel | Colorado | 8113 | 100 | 0 |
644926 | 644926 | 2020-10-19 | San Miguel | Colorado | 8113 | 100 | 0 |
641678 | 641678 | 2020-10-18 | San Miguel | Colorado | 8113 | 100 | 0 |
638431 | 638431 | 2020-10-17 | San Miguel | Colorado | 8113 | 100 | 0 |
635186 | 635186 | 2020-10-16 | San Miguel | Colorado | 8113 | 99 | 0 |
631940 | 631940 | 2020-10-15 | San Miguel | Colorado | 8113 | 99 | 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);