ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8107 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053804 | 1053804 | 2021-02-22 | Routt | Colorado | 8107 | 1832 | 19 |
1050557 | 1050557 | 2021-02-21 | Routt | Colorado | 8107 | 1830 | 19 |
1047310 | 1047310 | 2021-02-20 | Routt | Colorado | 8107 | 1823 | 19 |
1044065 | 1044065 | 2021-02-19 | Routt | Colorado | 8107 | 1818 | 19 |
1040820 | 1040820 | 2021-02-18 | Routt | Colorado | 8107 | 1813 | 19 |
1037575 | 1037575 | 2021-02-17 | Routt | Colorado | 8107 | 1806 | 19 |
1034330 | 1034330 | 2021-02-16 | Routt | Colorado | 8107 | 1799 | 19 |
1031084 | 1031084 | 2021-02-15 | Routt | Colorado | 8107 | 1797 | 19 |
1027837 | 1027837 | 2021-02-14 | Routt | Colorado | 8107 | 1795 | 19 |
1024592 | 1024592 | 2021-02-13 | Routt | Colorado | 8107 | 1780 | 19 |
1021347 | 1021347 | 2021-02-12 | Routt | Colorado | 8107 | 1773 | 19 |
1018102 | 1018102 | 2021-02-11 | Routt | Colorado | 8107 | 1754 | 19 |
1014857 | 1014857 | 2021-02-10 | Routt | Colorado | 8107 | 1746 | 19 |
1011612 | 1011612 | 2021-02-09 | Routt | Colorado | 8107 | 1734 | 19 |
1008366 | 1008366 | 2021-02-08 | Routt | Colorado | 8107 | 1731 | 19 |
1005120 | 1005120 | 2021-02-07 | Routt | Colorado | 8107 | 1723 | 19 |
1001874 | 1001874 | 2021-02-06 | Routt | Colorado | 8107 | 1711 | 19 |
998628 | 998628 | 2021-02-05 | Routt | Colorado | 8107 | 1699 | 19 |
995382 | 995382 | 2021-02-04 | Routt | Colorado | 8107 | 1681 | 19 |
992136 | 992136 | 2021-02-03 | Routt | Colorado | 8107 | 1659 | 19 |
988890 | 988890 | 2021-02-02 | Routt | Colorado | 8107 | 1646 | 19 |
985643 | 985643 | 2021-02-01 | Routt | Colorado | 8107 | 1630 | 19 |
982396 | 982396 | 2021-01-31 | Routt | Colorado | 8107 | 1582 | 19 |
979150 | 979150 | 2021-01-30 | Routt | Colorado | 8107 | 1582 | 19 |
975905 | 975905 | 2021-01-29 | Routt | Colorado | 8107 | 1582 | 19 |
972660 | 972660 | 2021-01-28 | Routt | Colorado | 8107 | 1567 | 19 |
969415 | 969415 | 2021-01-27 | Routt | Colorado | 8107 | 1552 | 19 |
966171 | 966171 | 2021-01-26 | Routt | Colorado | 8107 | 1529 | 19 |
962926 | 962926 | 2021-01-25 | Routt | Colorado | 8107 | 1503 | 19 |
959681 | 959681 | 2021-01-24 | Routt | Colorado | 8107 | 1503 | 19 |
956435 | 956435 | 2021-01-23 | Routt | Colorado | 8107 | 1478 | 19 |
953190 | 953190 | 2021-01-22 | Routt | Colorado | 8107 | 1443 | 19 |
949945 | 949945 | 2021-01-21 | Routt | Colorado | 8107 | 1415 | 19 |
946699 | 946699 | 2021-01-20 | Routt | Colorado | 8107 | 1381 | 19 |
943452 | 943452 | 2021-01-19 | Routt | Colorado | 8107 | 1365 | 19 |
940207 | 940207 | 2021-01-18 | Routt | Colorado | 8107 | 1344 | 19 |
936962 | 936962 | 2021-01-17 | Routt | Colorado | 8107 | 1331 | 19 |
933717 | 933717 | 2021-01-16 | Routt | Colorado | 8107 | 1308 | 19 |
930472 | 930472 | 2021-01-15 | Routt | Colorado | 8107 | 1283 | 19 |
927227 | 927227 | 2021-01-14 | Routt | Colorado | 8107 | 1252 | 18 |
923981 | 923981 | 2021-01-13 | Routt | Colorado | 8107 | 1231 | 18 |
920736 | 920736 | 2021-01-12 | Routt | Colorado | 8107 | 1209 | 18 |
917491 | 917491 | 2021-01-11 | Routt | Colorado | 8107 | 1180 | 18 |
914246 | 914246 | 2021-01-10 | Routt | Colorado | 8107 | 1168 | 18 |
911001 | 911001 | 2021-01-09 | Routt | Colorado | 8107 | 1159 | 18 |
907756 | 907756 | 2021-01-08 | Routt | Colorado | 8107 | 1147 | 18 |
904510 | 904510 | 2021-01-07 | Routt | Colorado | 8107 | 1112 | 18 |
901265 | 901265 | 2021-01-06 | Routt | Colorado | 8107 | 1084 | 18 |
898020 | 898020 | 2021-01-05 | Routt | Colorado | 8107 | 1084 | 18 |
894775 | 894775 | 2021-01-04 | Routt | Colorado | 8107 | 1077 | 18 |
891528 | 891528 | 2021-01-03 | Routt | Colorado | 8107 | 1075 | 18 |
888281 | 888281 | 2021-01-02 | Routt | Colorado | 8107 | 1068 | 18 |
885036 | 885036 | 2021-01-01 | Routt | Colorado | 8107 | 1058 | 18 |
881791 | 881791 | 2020-12-31 | Routt | Colorado | 8107 | 1042 | 18 |
878546 | 878546 | 2020-12-30 | Routt | Colorado | 8107 | 1031 | 18 |
875301 | 875301 | 2020-12-29 | Routt | Colorado | 8107 | 1023 | 18 |
872056 | 872056 | 2020-12-28 | Routt | Colorado | 8107 | 1013 | 18 |
868811 | 868811 | 2020-12-27 | Routt | Colorado | 8107 | 1010 | 18 |
865566 | 865566 | 2020-12-26 | Routt | Colorado | 8107 | 1004 | 18 |
862321 | 862321 | 2020-12-25 | Routt | Colorado | 8107 | 998 | 18 |
859076 | 859076 | 2020-12-24 | Routt | Colorado | 8107 | 988 | 18 |
855831 | 855831 | 2020-12-23 | Routt | Colorado | 8107 | 978 | 18 |
852586 | 852586 | 2020-12-22 | Routt | Colorado | 8107 | 964 | 18 |
849341 | 849341 | 2020-12-21 | Routt | Colorado | 8107 | 957 | 18 |
846096 | 846096 | 2020-12-20 | Routt | Colorado | 8107 | 951 | 18 |
842850 | 842850 | 2020-12-19 | Routt | Colorado | 8107 | 946 | 18 |
839605 | 839605 | 2020-12-18 | Routt | Colorado | 8107 | 945 | 18 |
836360 | 836360 | 2020-12-17 | Routt | Colorado | 8107 | 941 | 18 |
833114 | 833114 | 2020-12-16 | Routt | Colorado | 8107 | 928 | 16 |
829867 | 829867 | 2020-12-15 | Routt | Colorado | 8107 | 905 | 16 |
826621 | 826621 | 2020-12-14 | Routt | Colorado | 8107 | 879 | 17 |
823374 | 823374 | 2020-12-13 | Routt | Colorado | 8107 | 879 | 17 |
820128 | 820128 | 2020-12-12 | Routt | Colorado | 8107 | 869 | 16 |
816882 | 816882 | 2020-12-11 | Routt | Colorado | 8107 | 850 | 16 |
813636 | 813636 | 2020-12-10 | Routt | Colorado | 8107 | 823 | 16 |
810392 | 810392 | 2020-12-09 | Routt | Colorado | 8107 | 818 | 16 |
807147 | 807147 | 2020-12-08 | Routt | Colorado | 8107 | 798 | 16 |
803902 | 803902 | 2020-12-07 | Routt | Colorado | 8107 | 786 | 16 |
800657 | 800657 | 2020-12-06 | Routt | Colorado | 8107 | 765 | 16 |
797412 | 797412 | 2020-12-05 | Routt | Colorado | 8107 | 738 | 16 |
794167 | 794167 | 2020-12-04 | Routt | Colorado | 8107 | 725 | 16 |
790922 | 790922 | 2020-12-03 | Routt | Colorado | 8107 | 718 | 16 |
787677 | 787677 | 2020-12-02 | Routt | Colorado | 8107 | 708 | 15 |
784433 | 784433 | 2020-12-01 | Routt | Colorado | 8107 | 685 | 14 |
781188 | 781188 | 2020-11-30 | Routt | Colorado | 8107 | 662 | 14 |
777942 | 777942 | 2020-11-29 | Routt | Colorado | 8107 | 657 | 11 |
774697 | 774697 | 2020-11-28 | Routt | Colorado | 8107 | 644 | 11 |
771452 | 771452 | 2020-11-27 | Routt | Colorado | 8107 | 640 | 11 |
768207 | 768207 | 2020-11-26 | Routt | Colorado | 8107 | 615 | 10 |
764961 | 764961 | 2020-11-25 | Routt | Colorado | 8107 | 595 | 10 |
761716 | 761716 | 2020-11-24 | Routt | Colorado | 8107 | 560 | 10 |
758471 | 758471 | 2020-11-23 | Routt | Colorado | 8107 | 526 | 9 |
755224 | 755224 | 2020-11-22 | Routt | Colorado | 8107 | 519 | 9 |
751978 | 751978 | 2020-11-21 | Routt | Colorado | 8107 | 516 | 9 |
748732 | 748732 | 2020-11-20 | Routt | Colorado | 8107 | 500 | 9 |
745486 | 745486 | 2020-11-19 | Routt | Colorado | 8107 | 472 | 9 |
742239 | 742239 | 2020-11-18 | Routt | Colorado | 8107 | 443 | 9 |
738992 | 738992 | 2020-11-17 | Routt | Colorado | 8107 | 418 | 9 |
735748 | 735748 | 2020-11-16 | Routt | Colorado | 8107 | 399 | 9 |
732502 | 732502 | 2020-11-15 | Routt | Colorado | 8107 | 390 | 9 |
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);