ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Routt" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
729257 | 729257 | 2020-11-14 | Routt | Colorado | 8107 | 379 | 9 |
726014 | 726014 | 2020-11-13 | Routt | Colorado | 8107 | 358 | 9 |
722771 | 722771 | 2020-11-12 | Routt | Colorado | 8107 | 335 | 9 |
719528 | 719528 | 2020-11-11 | Routt | Colorado | 8107 | 325 | 9 |
716285 | 716285 | 2020-11-10 | Routt | Colorado | 8107 | 309 | 9 |
713041 | 713041 | 2020-11-09 | Routt | Colorado | 8107 | 298 | 9 |
709797 | 709797 | 2020-11-08 | Routt | Colorado | 8107 | 286 | 9 |
706553 | 706553 | 2020-11-07 | Routt | Colorado | 8107 | 278 | 9 |
703310 | 703310 | 2020-11-06 | Routt | Colorado | 8107 | 261 | 9 |
700067 | 700067 | 2020-11-05 | Routt | Colorado | 8107 | 248 | 9 |
696823 | 696823 | 2020-11-04 | Routt | Colorado | 8107 | 243 | 9 |
693581 | 693581 | 2020-11-03 | Routt | Colorado | 8107 | 239 | 9 |
690338 | 690338 | 2020-11-02 | Routt | Colorado | 8107 | 230 | 9 |
687093 | 687093 | 2020-11-01 | Routt | Colorado | 8107 | 230 | 9 |
683849 | 683849 | 2020-10-31 | Routt | Colorado | 8107 | 230 | 9 |
680606 | 680606 | 2020-10-30 | Routt | Colorado | 8107 | 221 | 8 |
677363 | 677363 | 2020-10-29 | Routt | Colorado | 8107 | 219 | 8 |
674120 | 674120 | 2020-10-28 | Routt | Colorado | 8107 | 215 | 8 |
670878 | 670878 | 2020-10-27 | Routt | Colorado | 8107 | 211 | 8 |
667635 | 667635 | 2020-10-26 | Routt | Colorado | 8107 | 204 | 8 |
664390 | 664390 | 2020-10-25 | Routt | Colorado | 8107 | 202 | 8 |
661146 | 661146 | 2020-10-24 | Routt | Colorado | 8107 | 202 | 8 |
657902 | 657902 | 2020-10-23 | Routt | Colorado | 8107 | 200 | 8 |
654657 | 654657 | 2020-10-22 | Routt | Colorado | 8107 | 197 | 8 |
651412 | 651412 | 2020-10-21 | Routt | Colorado | 8107 | 196 | 8 |
648168 | 648168 | 2020-10-20 | Routt | Colorado | 8107 | 193 | 8 |
644923 | 644923 | 2020-10-19 | Routt | Colorado | 8107 | 187 | 8 |
641675 | 641675 | 2020-10-18 | Routt | Colorado | 8107 | 187 | 8 |
638428 | 638428 | 2020-10-17 | Routt | Colorado | 8107 | 185 | 8 |
635183 | 635183 | 2020-10-16 | Routt | Colorado | 8107 | 180 | 8 |
631937 | 631937 | 2020-10-15 | Routt | Colorado | 8107 | 175 | 8 |
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);