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 |
---|---|---|---|---|---|---|---|
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 |
729229 | 729229 | 2020-11-14 | Gunnison | Colorado | 8051 | 404 | 7 |
725986 | 725986 | 2020-11-13 | Gunnison | Colorado | 8051 | 401 | 7 |
722743 | 722743 | 2020-11-12 | Gunnison | Colorado | 8051 | 394 | 7 |
719500 | 719500 | 2020-11-11 | Gunnison | Colorado | 8051 | 374 | 7 |
716257 | 716257 | 2020-11-10 | Gunnison | Colorado | 8051 | 373 | 7 |
713013 | 713013 | 2020-11-09 | Gunnison | Colorado | 8051 | 369 | 7 |
709769 | 709769 | 2020-11-08 | Gunnison | Colorado | 8051 | 347 | 7 |
706525 | 706525 | 2020-11-07 | Gunnison | Colorado | 8051 | 344 | 7 |
703282 | 703282 | 2020-11-06 | Gunnison | Colorado | 8051 | 332 | 7 |
700039 | 700039 | 2020-11-05 | Gunnison | Colorado | 8051 | 332 | 7 |
696795 | 696795 | 2020-11-04 | Gunnison | Colorado | 8051 | 329 | 7 |
693553 | 693553 | 2020-11-03 | Gunnison | Colorado | 8051 | 323 | 7 |
690310 | 690310 | 2020-11-02 | Gunnison | Colorado | 8051 | 322 | 7 |
687065 | 687065 | 2020-11-01 | Gunnison | Colorado | 8051 | 322 | 7 |
683821 | 683821 | 2020-10-31 | Gunnison | Colorado | 8051 | 319 | 7 |
680578 | 680578 | 2020-10-30 | Gunnison | Colorado | 8051 | 313 | 7 |
677335 | 677335 | 2020-10-29 | Gunnison | Colorado | 8051 | 310 | 7 |
674092 | 674092 | 2020-10-28 | Gunnison | Colorado | 8051 | 307 | 7 |
670850 | 670850 | 2020-10-27 | Gunnison | Colorado | 8051 | 306 | 7 |
667607 | 667607 | 2020-10-26 | Gunnison | Colorado | 8051 | 306 | 7 |
664362 | 664362 | 2020-10-25 | Gunnison | Colorado | 8051 | 305 | 7 |
661118 | 661118 | 2020-10-24 | Gunnison | Colorado | 8051 | 305 | 7 |
657874 | 657874 | 2020-10-23 | Gunnison | Colorado | 8051 | 305 | 7 |
654629 | 654629 | 2020-10-22 | Gunnison | Colorado | 8051 | 305 | 7 |
651384 | 651384 | 2020-10-21 | Gunnison | Colorado | 8051 | 304 | 7 |
648140 | 648140 | 2020-10-20 | Gunnison | Colorado | 8051 | 301 | 7 |
644895 | 644895 | 2020-10-19 | Gunnison | Colorado | 8051 | 299 | 7 |
641647 | 641647 | 2020-10-18 | Gunnison | Colorado | 8051 | 297 | 7 |
638400 | 638400 | 2020-10-17 | Gunnison | Colorado | 8051 | 296 | 7 |
635155 | 635155 | 2020-10-16 | Gunnison | Colorado | 8051 | 296 | 7 |
631909 | 631909 | 2020-10-15 | Gunnison | Colorado | 8051 | 296 | 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);