ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Garfield" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
729226 | 729226 | 2020-11-14 | Garfield | Colorado | 8045 | 1548 | 7 |
725983 | 725983 | 2020-11-13 | Garfield | Colorado | 8045 | 1499 | 7 |
722740 | 722740 | 2020-11-12 | Garfield | Colorado | 8045 | 1465 | 7 |
719497 | 719497 | 2020-11-11 | Garfield | Colorado | 8045 | 1434 | 5 |
716254 | 716254 | 2020-11-10 | Garfield | Colorado | 8045 | 1415 | 5 |
713010 | 713010 | 2020-11-09 | Garfield | Colorado | 8045 | 1403 | 5 |
709766 | 709766 | 2020-11-08 | Garfield | Colorado | 8045 | 1390 | 5 |
706522 | 706522 | 2020-11-07 | Garfield | Colorado | 8045 | 1383 | 5 |
703279 | 703279 | 2020-11-06 | Garfield | Colorado | 8045 | 1347 | 5 |
700036 | 700036 | 2020-11-05 | Garfield | Colorado | 8045 | 1307 | 5 |
696792 | 696792 | 2020-11-04 | Garfield | Colorado | 8045 | 1288 | 5 |
693550 | 693550 | 2020-11-03 | Garfield | Colorado | 8045 | 1261 | 5 |
690307 | 690307 | 2020-11-02 | Garfield | Colorado | 8045 | 1249 | 5 |
687062 | 687062 | 2020-11-01 | Garfield | Colorado | 8045 | 1239 | 5 |
683818 | 683818 | 2020-10-31 | Garfield | Colorado | 8045 | 1230 | 5 |
680575 | 680575 | 2020-10-30 | Garfield | Colorado | 8045 | 1219 | 5 |
677332 | 677332 | 2020-10-29 | Garfield | Colorado | 8045 | 1202 | 5 |
674089 | 674089 | 2020-10-28 | Garfield | Colorado | 8045 | 1187 | 5 |
670847 | 670847 | 2020-10-27 | Garfield | Colorado | 8045 | 1163 | 5 |
667604 | 667604 | 2020-10-26 | Garfield | Colorado | 8045 | 1153 | 5 |
664359 | 664359 | 2020-10-25 | Garfield | Colorado | 8045 | 1140 | 5 |
661115 | 661115 | 2020-10-24 | Garfield | Colorado | 8045 | 1135 | 5 |
657871 | 657871 | 2020-10-23 | Garfield | Colorado | 8045 | 1118 | 5 |
654626 | 654626 | 2020-10-22 | Garfield | Colorado | 8045 | 1107 | 5 |
651381 | 651381 | 2020-10-21 | Garfield | Colorado | 8045 | 1087 | 5 |
648137 | 648137 | 2020-10-20 | Garfield | Colorado | 8045 | 1080 | 5 |
644892 | 644892 | 2020-10-19 | Garfield | Colorado | 8045 | 1074 | 5 |
641644 | 641644 | 2020-10-18 | Garfield | Colorado | 8045 | 1063 | 5 |
638397 | 638397 | 2020-10-17 | Garfield | Colorado | 8045 | 1058 | 5 |
635152 | 635152 | 2020-10-16 | Garfield | Colorado | 8045 | 1053 | 5 |
631906 | 631906 | 2020-10-15 | Garfield | Colorado | 8045 | 1047 | 5 |
628662 | 628662 | 2020-10-14 | Garfield | Colorado | 8045 | 1028 | 5 |
625419 | 625419 | 2020-10-13 | Garfield | Colorado | 8045 | 1022 | 5 |
622176 | 622176 | 2020-10-12 | Garfield | Colorado | 8045 | 1016 | 5 |
618933 | 618933 | 2020-10-11 | Garfield | Colorado | 8045 | 1013 | 5 |
615691 | 615691 | 2020-10-10 | Garfield | Colorado | 8045 | 1006 | 5 |
612450 | 612450 | 2020-10-09 | Garfield | Colorado | 8045 | 993 | 5 |
609208 | 609208 | 2020-10-08 | Garfield | Colorado | 8045 | 990 | 5 |
605965 | 605965 | 2020-10-07 | Garfield | Colorado | 8045 | 985 | 5 |
602723 | 602723 | 2020-10-06 | Garfield | Colorado | 8045 | 982 | 5 |
599480 | 599480 | 2020-10-05 | Garfield | Colorado | 8045 | 972 | 5 |
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);