ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 8045 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053773 | 1053773 | 2021-02-22 | Garfield | Colorado | 8045 | 5026 | 38 |
1050526 | 1050526 | 2021-02-21 | Garfield | Colorado | 8045 | 5022 | 38 |
1047279 | 1047279 | 2021-02-20 | Garfield | Colorado | 8045 | 5017 | 38 |
1044034 | 1044034 | 2021-02-19 | Garfield | Colorado | 8045 | 5010 | 39 |
1040789 | 1040789 | 2021-02-18 | Garfield | Colorado | 8045 | 4995 | 38 |
1037544 | 1037544 | 2021-02-17 | Garfield | Colorado | 8045 | 4986 | 38 |
1034299 | 1034299 | 2021-02-16 | Garfield | Colorado | 8045 | 4978 | 38 |
1031053 | 1031053 | 2021-02-15 | Garfield | Colorado | 8045 | 4971 | 38 |
1027806 | 1027806 | 2021-02-14 | Garfield | Colorado | 8045 | 4969 | 38 |
1024561 | 1024561 | 2021-02-13 | Garfield | Colorado | 8045 | 4963 | 38 |
1021316 | 1021316 | 2021-02-12 | Garfield | Colorado | 8045 | 4957 | 38 |
1018071 | 1018071 | 2021-02-11 | Garfield | Colorado | 8045 | 4948 | 39 |
1014826 | 1014826 | 2021-02-10 | Garfield | Colorado | 8045 | 4939 | 38 |
1011581 | 1011581 | 2021-02-09 | Garfield | Colorado | 8045 | 4933 | 38 |
1008335 | 1008335 | 2021-02-08 | Garfield | Colorado | 8045 | 4928 | 38 |
1005089 | 1005089 | 2021-02-07 | Garfield | Colorado | 8045 | 4922 | 38 |
1001843 | 1001843 | 2021-02-06 | Garfield | Colorado | 8045 | 4909 | 37 |
998597 | 998597 | 2021-02-05 | Garfield | Colorado | 8045 | 4895 | 37 |
995351 | 995351 | 2021-02-04 | Garfield | Colorado | 8045 | 4877 | 37 |
992105 | 992105 | 2021-02-03 | Garfield | Colorado | 8045 | 4851 | 37 |
988859 | 988859 | 2021-02-02 | Garfield | Colorado | 8045 | 4840 | 37 |
985612 | 985612 | 2021-02-01 | Garfield | Colorado | 8045 | 4831 | 37 |
982365 | 982365 | 2021-01-31 | Garfield | Colorado | 8045 | 4783 | 38 |
979119 | 979119 | 2021-01-30 | Garfield | Colorado | 8045 | 4783 | 38 |
975874 | 975874 | 2021-01-29 | Garfield | Colorado | 8045 | 4783 | 38 |
972629 | 972629 | 2021-01-28 | Garfield | Colorado | 8045 | 4763 | 36 |
969384 | 969384 | 2021-01-27 | Garfield | Colorado | 8045 | 4760 | 36 |
966140 | 966140 | 2021-01-26 | Garfield | Colorado | 8045 | 4712 | 36 |
962895 | 962895 | 2021-01-25 | Garfield | Colorado | 8045 | 4640 | 36 |
959650 | 959650 | 2021-01-24 | Garfield | Colorado | 8045 | 4640 | 36 |
956404 | 956404 | 2021-01-23 | Garfield | Colorado | 8045 | 4627 | 36 |
953159 | 953159 | 2021-01-22 | Garfield | Colorado | 8045 | 4608 | 36 |
949914 | 949914 | 2021-01-21 | Garfield | Colorado | 8045 | 4585 | 36 |
946668 | 946668 | 2021-01-20 | Garfield | Colorado | 8045 | 4558 | 37 |
943421 | 943421 | 2021-01-19 | Garfield | Colorado | 8045 | 4534 | 36 |
940176 | 940176 | 2021-01-18 | Garfield | Colorado | 8045 | 4528 | 35 |
936931 | 936931 | 2021-01-17 | Garfield | Colorado | 8045 | 4509 | 35 |
933686 | 933686 | 2021-01-16 | Garfield | Colorado | 8045 | 4488 | 35 |
930441 | 930441 | 2021-01-15 | Garfield | Colorado | 8045 | 4451 | 35 |
927196 | 927196 | 2021-01-14 | Garfield | Colorado | 8045 | 4403 | 35 |
923950 | 923950 | 2021-01-13 | Garfield | Colorado | 8045 | 4376 | 35 |
920705 | 920705 | 2021-01-12 | Garfield | Colorado | 8045 | 4347 | 35 |
917460 | 917460 | 2021-01-11 | Garfield | Colorado | 8045 | 4319 | 35 |
914215 | 914215 | 2021-01-10 | Garfield | Colorado | 8045 | 4300 | 35 |
910970 | 910970 | 2021-01-09 | Garfield | Colorado | 8045 | 4270 | 34 |
907725 | 907725 | 2021-01-08 | Garfield | Colorado | 8045 | 4226 | 34 |
904479 | 904479 | 2021-01-07 | Garfield | Colorado | 8045 | 4150 | 34 |
901234 | 901234 | 2021-01-06 | Garfield | Colorado | 8045 | 4057 | 31 |
897989 | 897989 | 2021-01-05 | Garfield | Colorado | 8045 | 4057 | 31 |
894744 | 894744 | 2021-01-04 | Garfield | Colorado | 8045 | 4033 | 30 |
891497 | 891497 | 2021-01-03 | Garfield | Colorado | 8045 | 3991 | 30 |
888250 | 888250 | 2021-01-02 | Garfield | Colorado | 8045 | 3942 | 30 |
885005 | 885005 | 2021-01-01 | Garfield | Colorado | 8045 | 3916 | 29 |
881760 | 881760 | 2020-12-31 | Garfield | Colorado | 8045 | 3875 | 28 |
878515 | 878515 | 2020-12-30 | Garfield | Colorado | 8045 | 3833 | 28 |
875270 | 875270 | 2020-12-29 | Garfield | Colorado | 8045 | 3799 | 27 |
872025 | 872025 | 2020-12-28 | Garfield | Colorado | 8045 | 3767 | 27 |
868780 | 868780 | 2020-12-27 | Garfield | Colorado | 8045 | 3731 | 26 |
865535 | 865535 | 2020-12-26 | Garfield | Colorado | 8045 | 3687 | 26 |
862290 | 862290 | 2020-12-25 | Garfield | Colorado | 8045 | 3667 | 26 |
859045 | 859045 | 2020-12-24 | Garfield | Colorado | 8045 | 3635 | 25 |
855800 | 855800 | 2020-12-23 | Garfield | Colorado | 8045 | 3585 | 25 |
852555 | 852555 | 2020-12-22 | Garfield | Colorado | 8045 | 3515 | 25 |
849310 | 849310 | 2020-12-21 | Garfield | Colorado | 8045 | 3489 | 24 |
846065 | 846065 | 2020-12-20 | Garfield | Colorado | 8045 | 3461 | 24 |
842819 | 842819 | 2020-12-19 | Garfield | Colorado | 8045 | 3422 | 24 |
839574 | 839574 | 2020-12-18 | Garfield | Colorado | 8045 | 3349 | 24 |
836329 | 836329 | 2020-12-17 | Garfield | Colorado | 8045 | 3242 | 25 |
833083 | 833083 | 2020-12-16 | Garfield | Colorado | 8045 | 3197 | 24 |
829836 | 829836 | 2020-12-15 | Garfield | Colorado | 8045 | 3107 | 24 |
826590 | 826590 | 2020-12-14 | Garfield | Colorado | 8045 | 2995 | 17 |
823343 | 823343 | 2020-12-13 | Garfield | Colorado | 8045 | 2995 | 17 |
820097 | 820097 | 2020-12-12 | Garfield | Colorado | 8045 | 2951 | 17 |
816851 | 816851 | 2020-12-11 | Garfield | Colorado | 8045 | 2868 | 16 |
813605 | 813605 | 2020-12-10 | Garfield | Colorado | 8045 | 2762 | 14 |
810361 | 810361 | 2020-12-09 | Garfield | Colorado | 8045 | 2682 | 14 |
807116 | 807116 | 2020-12-08 | Garfield | Colorado | 8045 | 2630 | 10 |
803871 | 803871 | 2020-12-07 | Garfield | Colorado | 8045 | 2607 | 10 |
800626 | 800626 | 2020-12-06 | Garfield | Colorado | 8045 | 2535 | 10 |
797381 | 797381 | 2020-12-05 | Garfield | Colorado | 8045 | 2490 | 10 |
794136 | 794136 | 2020-12-04 | Garfield | Colorado | 8045 | 2416 | 10 |
790891 | 790891 | 2020-12-03 | Garfield | Colorado | 8045 | 2361 | 10 |
787646 | 787646 | 2020-12-02 | Garfield | Colorado | 8045 | 2321 | 10 |
784402 | 784402 | 2020-12-01 | Garfield | Colorado | 8045 | 2280 | 9 |
781157 | 781157 | 2020-11-30 | Garfield | Colorado | 8045 | 2246 | 7 |
777911 | 777911 | 2020-11-29 | Garfield | Colorado | 8045 | 2191 | 6 |
774666 | 774666 | 2020-11-28 | Garfield | Colorado | 8045 | 2158 | 6 |
771421 | 771421 | 2020-11-27 | Garfield | Colorado | 8045 | 2098 | 6 |
768176 | 768176 | 2020-11-26 | Garfield | Colorado | 8045 | 2071 | 6 |
764930 | 764930 | 2020-11-25 | Garfield | Colorado | 8045 | 2014 | 6 |
761685 | 761685 | 2020-11-24 | Garfield | Colorado | 8045 | 1974 | 6 |
758440 | 758440 | 2020-11-23 | Garfield | Colorado | 8045 | 1916 | 6 |
755193 | 755193 | 2020-11-22 | Garfield | Colorado | 8045 | 1886 | 6 |
751947 | 751947 | 2020-11-21 | Garfield | Colorado | 8045 | 1851 | 6 |
748701 | 748701 | 2020-11-20 | Garfield | Colorado | 8045 | 1776 | 6 |
745455 | 745455 | 2020-11-19 | Garfield | Colorado | 8045 | 1744 | 6 |
742208 | 742208 | 2020-11-18 | Garfield | Colorado | 8045 | 1695 | 6 |
738961 | 738961 | 2020-11-17 | Garfield | Colorado | 8045 | 1666 | 6 |
735717 | 735717 | 2020-11-16 | Garfield | Colorado | 8045 | 1632 | 7 |
732471 | 732471 | 2020-11-15 | Garfield | Colorado | 8045 | 1582 | 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);