ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 8025 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953149 | 953149 | 2021-01-22 | Crowley | Colorado | 8025 | 1762 | 14 |
949904 | 949904 | 2021-01-21 | Crowley | Colorado | 8025 | 1743 | 14 |
946658 | 946658 | 2021-01-20 | Crowley | Colorado | 8025 | 1743 | 14 |
943411 | 943411 | 2021-01-19 | Crowley | Colorado | 8025 | 1744 | 14 |
940166 | 940166 | 2021-01-18 | Crowley | Colorado | 8025 | 1743 | 14 |
936921 | 936921 | 2021-01-17 | Crowley | Colorado | 8025 | 1742 | 14 |
933676 | 933676 | 2021-01-16 | Crowley | Colorado | 8025 | 1744 | 14 |
930431 | 930431 | 2021-01-15 | Crowley | Colorado | 8025 | 1730 | 14 |
927186 | 927186 | 2021-01-14 | Crowley | Colorado | 8025 | 1689 | 14 |
923940 | 923940 | 2021-01-13 | Crowley | Colorado | 8025 | 1688 | 14 |
920695 | 920695 | 2021-01-12 | Crowley | Colorado | 8025 | 1686 | 14 |
917450 | 917450 | 2021-01-11 | Crowley | Colorado | 8025 | 1685 | 14 |
914205 | 914205 | 2021-01-10 | Crowley | Colorado | 8025 | 1685 | 14 |
910960 | 910960 | 2021-01-09 | Crowley | Colorado | 8025 | 1684 | 14 |
907715 | 907715 | 2021-01-08 | Crowley | Colorado | 8025 | 1683 | 13 |
904469 | 904469 | 2021-01-07 | Crowley | Colorado | 8025 | 1667 | 12 |
901224 | 901224 | 2021-01-06 | Crowley | Colorado | 8025 | 1666 | 12 |
897979 | 897979 | 2021-01-05 | Crowley | Colorado | 8025 | 1666 | 12 |
894734 | 894734 | 2021-01-04 | Crowley | Colorado | 8025 | 1660 | 12 |
891487 | 891487 | 2021-01-03 | Crowley | Colorado | 8025 | 1660 | 12 |
888240 | 888240 | 2021-01-02 | Crowley | Colorado | 8025 | 1660 | 12 |
884995 | 884995 | 2021-01-01 | Crowley | Colorado | 8025 | 1660 | 12 |
881750 | 881750 | 2020-12-31 | Crowley | Colorado | 8025 | 1647 | 12 |
878505 | 878505 | 2020-12-30 | Crowley | Colorado | 8025 | 1640 | 12 |
875260 | 875260 | 2020-12-29 | Crowley | Colorado | 8025 | 1638 | 12 |
872015 | 872015 | 2020-12-28 | Crowley | Colorado | 8025 | 1635 | 12 |
868770 | 868770 | 2020-12-27 | Crowley | Colorado | 8025 | 1632 | 12 |
865525 | 865525 | 2020-12-26 | Crowley | Colorado | 8025 | 1630 | 12 |
862280 | 862280 | 2020-12-25 | Crowley | Colorado | 8025 | 1625 | 12 |
859035 | 859035 | 2020-12-24 | Crowley | Colorado | 8025 | 1604 | 12 |
855790 | 855790 | 2020-12-23 | Crowley | Colorado | 8025 | 1585 | 12 |
852545 | 852545 | 2020-12-22 | Crowley | Colorado | 8025 | 1578 | 12 |
849300 | 849300 | 2020-12-21 | Crowley | Colorado | 8025 | 1578 | 12 |
846055 | 846055 | 2020-12-20 | Crowley | Colorado | 8025 | 1578 | 12 |
842809 | 842809 | 2020-12-19 | Crowley | Colorado | 8025 | 1576 | 12 |
839564 | 839564 | 2020-12-18 | Crowley | Colorado | 8025 | 1565 | 12 |
836319 | 836319 | 2020-12-17 | Crowley | Colorado | 8025 | 1498 | 10 |
833073 | 833073 | 2020-12-16 | Crowley | Colorado | 8025 | 1466 | 10 |
829826 | 829826 | 2020-12-15 | Crowley | Colorado | 8025 | 1457 | 10 |
826580 | 826580 | 2020-12-14 | Crowley | Colorado | 8025 | 1430 | 10 |
823333 | 823333 | 2020-12-13 | Crowley | Colorado | 8025 | 1430 | 10 |
820087 | 820087 | 2020-12-12 | Crowley | Colorado | 8025 | 1428 | 10 |
816841 | 816841 | 2020-12-11 | Crowley | Colorado | 8025 | 1421 | 10 |
813595 | 813595 | 2020-12-10 | Crowley | Colorado | 8025 | 1378 | 9 |
810351 | 810351 | 2020-12-09 | Crowley | Colorado | 8025 | 1361 | 7 |
807106 | 807106 | 2020-12-08 | Crowley | Colorado | 8025 | 1356 | 5 |
803861 | 803861 | 2020-12-07 | Crowley | Colorado | 8025 | 1347 | 5 |
800616 | 800616 | 2020-12-06 | Crowley | Colorado | 8025 | 1340 | 5 |
797371 | 797371 | 2020-12-05 | Crowley | Colorado | 8025 | 1336 | 5 |
794126 | 794126 | 2020-12-04 | Crowley | Colorado | 8025 | 1310 | 5 |
790881 | 790881 | 2020-12-03 | Crowley | Colorado | 8025 | 1299 | 5 |
787636 | 787636 | 2020-12-02 | Crowley | Colorado | 8025 | 1242 | 3 |
784392 | 784392 | 2020-12-01 | Crowley | Colorado | 8025 | 1241 | 3 |
781147 | 781147 | 2020-11-30 | Crowley | Colorado | 8025 | 1239 | 3 |
777901 | 777901 | 2020-11-29 | Crowley | Colorado | 8025 | 1237 | 3 |
774656 | 774656 | 2020-11-28 | Crowley | Colorado | 8025 | 1222 | 3 |
771411 | 771411 | 2020-11-27 | Crowley | Colorado | 8025 | 1149 | 3 |
768166 | 768166 | 2020-11-26 | Crowley | Colorado | 8025 | 1087 | 3 |
764920 | 764920 | 2020-11-25 | Crowley | Colorado | 8025 | 1015 | 2 |
761675 | 761675 | 2020-11-24 | Crowley | Colorado | 8025 | 1011 | 2 |
758430 | 758430 | 2020-11-23 | Crowley | Colorado | 8025 | 1009 | 1 |
755183 | 755183 | 2020-11-22 | Crowley | Colorado | 8025 | 1007 | 1 |
751937 | 751937 | 2020-11-21 | Crowley | Colorado | 8025 | 991 | 1 |
748691 | 748691 | 2020-11-20 | Crowley | Colorado | 8025 | 928 | 1 |
745445 | 745445 | 2020-11-19 | Crowley | Colorado | 8025 | 796 | 1 |
742198 | 742198 | 2020-11-18 | Crowley | Colorado | 8025 | 711 | 1 |
738951 | 738951 | 2020-11-17 | Crowley | Colorado | 8025 | 697 | 1 |
735707 | 735707 | 2020-11-16 | Crowley | Colorado | 8025 | 688 | 1 |
732461 | 732461 | 2020-11-15 | Crowley | Colorado | 8025 | 669 | 1 |
729216 | 729216 | 2020-11-14 | Crowley | Colorado | 8025 | 614 | 1 |
725973 | 725973 | 2020-11-13 | Crowley | Colorado | 8025 | 527 | 1 |
722730 | 722730 | 2020-11-12 | Crowley | Colorado | 8025 | 351 | 1 |
719487 | 719487 | 2020-11-11 | Crowley | Colorado | 8025 | 245 | 1 |
716244 | 716244 | 2020-11-10 | Crowley | Colorado | 8025 | 220 | 1 |
713000 | 713000 | 2020-11-09 | Crowley | Colorado | 8025 | 208 | 1 |
709756 | 709756 | 2020-11-08 | Crowley | Colorado | 8025 | 203 | 1 |
706512 | 706512 | 2020-11-07 | Crowley | Colorado | 8025 | 202 | 1 |
703269 | 703269 | 2020-11-06 | Crowley | Colorado | 8025 | 201 | 1 |
700026 | 700026 | 2020-11-05 | Crowley | Colorado | 8025 | 199 | 1 |
696782 | 696782 | 2020-11-04 | Crowley | Colorado | 8025 | 196 | 1 |
693540 | 693540 | 2020-11-03 | Crowley | Colorado | 8025 | 165 | 1 |
690297 | 690297 | 2020-11-02 | Crowley | Colorado | 8025 | 112 | 1 |
687052 | 687052 | 2020-11-01 | Crowley | Colorado | 8025 | 99 | 1 |
683808 | 683808 | 2020-10-31 | Crowley | Colorado | 8025 | 96 | 1 |
680565 | 680565 | 2020-10-30 | Crowley | Colorado | 8025 | 96 | 1 |
677322 | 677322 | 2020-10-29 | Crowley | Colorado | 8025 | 95 | 1 |
674079 | 674079 | 2020-10-28 | Crowley | Colorado | 8025 | 92 | 1 |
670837 | 670837 | 2020-10-27 | Crowley | Colorado | 8025 | 91 | 1 |
667594 | 667594 | 2020-10-26 | Crowley | Colorado | 8025 | 91 | 1 |
664349 | 664349 | 2020-10-25 | Crowley | Colorado | 8025 | 91 | 1 |
661105 | 661105 | 2020-10-24 | Crowley | Colorado | 8025 | 89 | 1 |
657861 | 657861 | 2020-10-23 | Crowley | Colorado | 8025 | 85 | 1 |
654616 | 654616 | 2020-10-22 | Crowley | Colorado | 8025 | 83 | 1 |
651371 | 651371 | 2020-10-21 | Crowley | Colorado | 8025 | 83 | 1 |
648127 | 648127 | 2020-10-20 | Crowley | Colorado | 8025 | 81 | 1 |
644882 | 644882 | 2020-10-19 | Crowley | Colorado | 8025 | 81 | 1 |
641634 | 641634 | 2020-10-18 | Crowley | Colorado | 8025 | 80 | 1 |
638387 | 638387 | 2020-10-17 | Crowley | Colorado | 8025 | 80 | 1 |
635142 | 635142 | 2020-10-16 | Crowley | Colorado | 8025 | 80 | 1 |
631896 | 631896 | 2020-10-15 | Crowley | Colorado | 8025 | 78 | 1 |
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);