ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Crowley" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053763 | 1053763 | 2021-02-22 | Crowley | Colorado | 8025 | 1959 | 14 |
1050516 | 1050516 | 2021-02-21 | Crowley | Colorado | 8025 | 1959 | 14 |
1047269 | 1047269 | 2021-02-20 | Crowley | Colorado | 8025 | 1957 | 14 |
1044024 | 1044024 | 2021-02-19 | Crowley | Colorado | 8025 | 1954 | 14 |
1040779 | 1040779 | 2021-02-18 | Crowley | Colorado | 8025 | 1934 | 14 |
1037534 | 1037534 | 2021-02-17 | Crowley | Colorado | 8025 | 1934 | 14 |
1034289 | 1034289 | 2021-02-16 | Crowley | Colorado | 8025 | 1931 | 14 |
1031043 | 1031043 | 2021-02-15 | Crowley | Colorado | 8025 | 1931 | 14 |
1027796 | 1027796 | 2021-02-14 | Crowley | Colorado | 8025 | 1932 | 14 |
1024551 | 1024551 | 2021-02-13 | Crowley | Colorado | 8025 | 1927 | 14 |
1021306 | 1021306 | 2021-02-12 | Crowley | Colorado | 8025 | 1918 | 14 |
1018061 | 1018061 | 2021-02-11 | Crowley | Colorado | 8025 | 1885 | 14 |
1014816 | 1014816 | 2021-02-10 | Crowley | Colorado | 8025 | 1884 | 14 |
1011571 | 1011571 | 2021-02-09 | Crowley | Colorado | 8025 | 1883 | 14 |
1008325 | 1008325 | 2021-02-08 | Crowley | Colorado | 8025 | 1883 | 14 |
1005079 | 1005079 | 2021-02-07 | Crowley | Colorado | 8025 | 1885 | 14 |
1001833 | 1001833 | 2021-02-06 | Crowley | Colorado | 8025 | 1885 | 14 |
998587 | 998587 | 2021-02-05 | Crowley | Colorado | 8025 | 1884 | 14 |
995341 | 995341 | 2021-02-04 | Crowley | Colorado | 8025 | 1818 | 14 |
992095 | 992095 | 2021-02-03 | Crowley | Colorado | 8025 | 1817 | 14 |
988849 | 988849 | 2021-02-02 | Crowley | Colorado | 8025 | 1816 | 14 |
985602 | 985602 | 2021-02-01 | Crowley | Colorado | 8025 | 1816 | 14 |
982355 | 982355 | 2021-01-31 | Crowley | Colorado | 8025 | 1803 | 14 |
979109 | 979109 | 2021-01-30 | Crowley | Colorado | 8025 | 1803 | 14 |
975864 | 975864 | 2021-01-29 | Crowley | Colorado | 8025 | 1803 | 14 |
972619 | 972619 | 2021-01-28 | Crowley | Colorado | 8025 | 1766 | 14 |
969374 | 969374 | 2021-01-27 | Crowley | Colorado | 8025 | 1766 | 14 |
966130 | 966130 | 2021-01-26 | Crowley | Colorado | 8025 | 1766 | 14 |
962885 | 962885 | 2021-01-25 | Crowley | Colorado | 8025 | 1764 | 14 |
959640 | 959640 | 2021-01-24 | Crowley | Colorado | 8025 | 1764 | 14 |
956394 | 956394 | 2021-01-23 | Crowley | Colorado | 8025 | 1765 | 14 |
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 |
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);