ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 8051 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053776 | 1053776 | 2021-02-22 | Gunnison | Colorado | 8051 | 1182 | 6 |
1050529 | 1050529 | 2021-02-21 | Gunnison | Colorado | 8051 | 1181 | 6 |
1047282 | 1047282 | 2021-02-20 | Gunnison | Colorado | 8051 | 1182 | 6 |
1044037 | 1044037 | 2021-02-19 | Gunnison | Colorado | 8051 | 1181 | 6 |
1040792 | 1040792 | 2021-02-18 | Gunnison | Colorado | 8051 | 1179 | 6 |
1037547 | 1037547 | 2021-02-17 | Gunnison | Colorado | 8051 | 1179 | 6 |
1034302 | 1034302 | 2021-02-16 | Gunnison | Colorado | 8051 | 1176 | 6 |
1031056 | 1031056 | 2021-02-15 | Gunnison | Colorado | 8051 | 1175 | 6 |
1027809 | 1027809 | 2021-02-14 | Gunnison | Colorado | 8051 | 1175 | 6 |
1024564 | 1024564 | 2021-02-13 | Gunnison | Colorado | 8051 | 1159 | 6 |
1021319 | 1021319 | 2021-02-12 | Gunnison | Colorado | 8051 | 1138 | 6 |
1018074 | 1018074 | 2021-02-11 | Gunnison | Colorado | 8051 | 1100 | 6 |
1014829 | 1014829 | 2021-02-10 | Gunnison | Colorado | 8051 | 1092 | 6 |
1011584 | 1011584 | 2021-02-09 | Gunnison | Colorado | 8051 | 1091 | 6 |
1008338 | 1008338 | 2021-02-08 | Gunnison | Colorado | 8051 | 1089 | 6 |
1005092 | 1005092 | 2021-02-07 | Gunnison | Colorado | 8051 | 1086 | 6 |
1001846 | 1001846 | 2021-02-06 | Gunnison | Colorado | 8051 | 1082 | 6 |
998600 | 998600 | 2021-02-05 | Gunnison | Colorado | 8051 | 1079 | 6 |
995354 | 995354 | 2021-02-04 | Gunnison | Colorado | 8051 | 1075 | 6 |
992108 | 992108 | 2021-02-03 | Gunnison | Colorado | 8051 | 1069 | 6 |
988862 | 988862 | 2021-02-02 | Gunnison | Colorado | 8051 | 1061 | 6 |
985615 | 985615 | 2021-02-01 | Gunnison | Colorado | 8051 | 1056 | 6 |
982368 | 982368 | 2021-01-31 | Gunnison | Colorado | 8051 | 1042 | 6 |
979122 | 979122 | 2021-01-30 | Gunnison | Colorado | 8051 | 1042 | 6 |
975877 | 975877 | 2021-01-29 | Gunnison | Colorado | 8051 | 1042 | 6 |
972632 | 972632 | 2021-01-28 | Gunnison | Colorado | 8051 | 1034 | 6 |
969387 | 969387 | 2021-01-27 | Gunnison | Colorado | 8051 | 1029 | 6 |
966143 | 966143 | 2021-01-26 | Gunnison | Colorado | 8051 | 1014 | 6 |
962898 | 962898 | 2021-01-25 | Gunnison | Colorado | 8051 | 987 | 6 |
959653 | 959653 | 2021-01-24 | Gunnison | Colorado | 8051 | 987 | 6 |
956407 | 956407 | 2021-01-23 | Gunnison | Colorado | 8051 | 975 | 6 |
953162 | 953162 | 2021-01-22 | Gunnison | Colorado | 8051 | 962 | 6 |
949917 | 949917 | 2021-01-21 | Gunnison | Colorado | 8051 | 949 | 6 |
946671 | 946671 | 2021-01-20 | Gunnison | Colorado | 8051 | 940 | 6 |
943424 | 943424 | 2021-01-19 | Gunnison | Colorado | 8051 | 933 | 6 |
940179 | 940179 | 2021-01-18 | Gunnison | Colorado | 8051 | 912 | 6 |
936934 | 936934 | 2021-01-17 | Gunnison | Colorado | 8051 | 873 | 6 |
933689 | 933689 | 2021-01-16 | Gunnison | Colorado | 8051 | 863 | 6 |
930444 | 930444 | 2021-01-15 | Gunnison | Colorado | 8051 | 844 | 6 |
927199 | 927199 | 2021-01-14 | Gunnison | Colorado | 8051 | 824 | 6 |
923953 | 923953 | 2021-01-13 | Gunnison | Colorado | 8051 | 813 | 6 |
920708 | 920708 | 2021-01-12 | Gunnison | Colorado | 8051 | 798 | 6 |
917463 | 917463 | 2021-01-11 | Gunnison | Colorado | 8051 | 792 | 6 |
914218 | 914218 | 2021-01-10 | Gunnison | Colorado | 8051 | 787 | 6 |
910973 | 910973 | 2021-01-09 | Gunnison | Colorado | 8051 | 771 | 6 |
907728 | 907728 | 2021-01-08 | Gunnison | Colorado | 8051 | 752 | 6 |
904482 | 904482 | 2021-01-07 | Gunnison | Colorado | 8051 | 742 | 6 |
901237 | 901237 | 2021-01-06 | Gunnison | Colorado | 8051 | 733 | 6 |
897992 | 897992 | 2021-01-05 | Gunnison | Colorado | 8051 | 733 | 6 |
894747 | 894747 | 2021-01-04 | Gunnison | Colorado | 8051 | 727 | 6 |
891500 | 891500 | 2021-01-03 | Gunnison | Colorado | 8051 | 725 | 6 |
888253 | 888253 | 2021-01-02 | Gunnison | Colorado | 8051 | 720 | 6 |
885008 | 885008 | 2021-01-01 | Gunnison | Colorado | 8051 | 714 | 6 |
881763 | 881763 | 2020-12-31 | Gunnison | Colorado | 8051 | 696 | 6 |
878518 | 878518 | 2020-12-30 | Gunnison | Colorado | 8051 | 693 | 5 |
875273 | 875273 | 2020-12-29 | Gunnison | Colorado | 8051 | 686 | 5 |
872028 | 872028 | 2020-12-28 | Gunnison | Colorado | 8051 | 680 | 5 |
868783 | 868783 | 2020-12-27 | Gunnison | Colorado | 8051 | 670 | 5 |
865538 | 865538 | 2020-12-26 | Gunnison | Colorado | 8051 | 667 | 5 |
862293 | 862293 | 2020-12-25 | Gunnison | Colorado | 8051 | 665 | 5 |
859048 | 859048 | 2020-12-24 | Gunnison | Colorado | 8051 | 652 | 5 |
855803 | 855803 | 2020-12-23 | Gunnison | Colorado | 8051 | 652 | 5 |
852558 | 852558 | 2020-12-22 | Gunnison | Colorado | 8051 | 623 | 5 |
849313 | 849313 | 2020-12-21 | Gunnison | Colorado | 8051 | 604 | 5 |
846068 | 846068 | 2020-12-20 | Gunnison | Colorado | 8051 | 602 | 5 |
842822 | 842822 | 2020-12-19 | Gunnison | Colorado | 8051 | 599 | 5 |
839577 | 839577 | 2020-12-18 | Gunnison | Colorado | 8051 | 583 | 5 |
836332 | 836332 | 2020-12-17 | Gunnison | Colorado | 8051 | 569 | 7 |
833086 | 833086 | 2020-12-16 | Gunnison | Colorado | 8051 | 561 | 7 |
829839 | 829839 | 2020-12-15 | Gunnison | Colorado | 8051 | 554 | 7 |
826593 | 826593 | 2020-12-14 | Gunnison | Colorado | 8051 | 542 | 7 |
823346 | 823346 | 2020-12-13 | Gunnison | Colorado | 8051 | 542 | 7 |
820100 | 820100 | 2020-12-12 | Gunnison | Colorado | 8051 | 538 | 7 |
816854 | 816854 | 2020-12-11 | Gunnison | Colorado | 8051 | 533 | 7 |
813608 | 813608 | 2020-12-10 | Gunnison | Colorado | 8051 | 518 | 7 |
810364 | 810364 | 2020-12-09 | Gunnison | Colorado | 8051 | 513 | 7 |
807119 | 807119 | 2020-12-08 | Gunnison | Colorado | 8051 | 512 | 7 |
803874 | 803874 | 2020-12-07 | Gunnison | Colorado | 8051 | 508 | 7 |
800629 | 800629 | 2020-12-06 | Gunnison | Colorado | 8051 | 502 | 7 |
797384 | 797384 | 2020-12-05 | Gunnison | Colorado | 8051 | 495 | 7 |
794139 | 794139 | 2020-12-04 | Gunnison | Colorado | 8051 | 493 | 7 |
790894 | 790894 | 2020-12-03 | Gunnison | Colorado | 8051 | 491 | 7 |
787649 | 787649 | 2020-12-02 | Gunnison | Colorado | 8051 | 477 | 7 |
784405 | 784405 | 2020-12-01 | Gunnison | Colorado | 8051 | 476 | 7 |
781160 | 781160 | 2020-11-30 | Gunnison | Colorado | 8051 | 473 | 7 |
777914 | 777914 | 2020-11-29 | Gunnison | Colorado | 8051 | 471 | 7 |
774669 | 774669 | 2020-11-28 | Gunnison | Colorado | 8051 | 466 | 7 |
771424 | 771424 | 2020-11-27 | Gunnison | Colorado | 8051 | 461 | 7 |
768179 | 768179 | 2020-11-26 | Gunnison | Colorado | 8051 | 451 | 7 |
764933 | 764933 | 2020-11-25 | Gunnison | Colorado | 8051 | 448 | 7 |
761688 | 761688 | 2020-11-24 | Gunnison | Colorado | 8051 | 447 | 7 |
758443 | 758443 | 2020-11-23 | Gunnison | Colorado | 8051 | 446 | 7 |
755196 | 755196 | 2020-11-22 | Gunnison | Colorado | 8051 | 439 | 7 |
751950 | 751950 | 2020-11-21 | Gunnison | Colorado | 8051 | 438 | 7 |
748704 | 748704 | 2020-11-20 | Gunnison | Colorado | 8051 | 429 | 7 |
745458 | 745458 | 2020-11-19 | Gunnison | Colorado | 8051 | 428 | 7 |
742211 | 742211 | 2020-11-18 | Gunnison | Colorado | 8051 | 427 | 7 |
738964 | 738964 | 2020-11-17 | Gunnison | Colorado | 8051 | 426 | 7 |
735720 | 735720 | 2020-11-16 | Gunnison | Colorado | 8051 | 422 | 7 |
732474 | 732474 | 2020-11-15 | Gunnison | Colorado | 8051 | 405 | 7 |
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);