ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8014 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953143 | 953143 | 2021-01-22 | Broomfield | Colorado | 8014 | 3267 | 69 |
949898 | 949898 | 2021-01-21 | Broomfield | Colorado | 8014 | 3240 | 69 |
946652 | 946652 | 2021-01-20 | Broomfield | Colorado | 8014 | 3219 | 68 |
943405 | 943405 | 2021-01-19 | Broomfield | Colorado | 8014 | 3198 | 68 |
940160 | 940160 | 2021-01-18 | Broomfield | Colorado | 8014 | 3183 | 68 |
936915 | 936915 | 2021-01-17 | Broomfield | Colorado | 8014 | 3164 | 68 |
933670 | 933670 | 2021-01-16 | Broomfield | Colorado | 8014 | 3148 | 68 |
930425 | 930425 | 2021-01-15 | Broomfield | Colorado | 8014 | 3130 | 68 |
927180 | 927180 | 2021-01-14 | Broomfield | Colorado | 8014 | 3121 | 68 |
923934 | 923934 | 2021-01-13 | Broomfield | Colorado | 8014 | 3098 | 68 |
920689 | 920689 | 2021-01-12 | Broomfield | Colorado | 8014 | 3067 | 68 |
917444 | 917444 | 2021-01-11 | Broomfield | Colorado | 8014 | 3050 | 68 |
914199 | 914199 | 2021-01-10 | Broomfield | Colorado | 8014 | 3030 | 68 |
910954 | 910954 | 2021-01-09 | Broomfield | Colorado | 8014 | 3010 | 68 |
907709 | 907709 | 2021-01-08 | Broomfield | Colorado | 8014 | 2989 | 68 |
904463 | 904463 | 2021-01-07 | Broomfield | Colorado | 8014 | 2978 | 68 |
901218 | 901218 | 2021-01-06 | Broomfield | Colorado | 8014 | 2905 | 68 |
897973 | 897973 | 2021-01-05 | Broomfield | Colorado | 8014 | 2905 | 68 |
894728 | 894728 | 2021-01-04 | Broomfield | Colorado | 8014 | 2870 | 68 |
891481 | 891481 | 2021-01-03 | Broomfield | Colorado | 8014 | 2859 | 68 |
888234 | 888234 | 2021-01-02 | Broomfield | Colorado | 8014 | 2844 | 68 |
884989 | 884989 | 2021-01-01 | Broomfield | Colorado | 8014 | 2837 | 67 |
881744 | 881744 | 2020-12-31 | Broomfield | Colorado | 8014 | 2804 | 66 |
878499 | 878499 | 2020-12-30 | Broomfield | Colorado | 8014 | 2781 | 63 |
875254 | 875254 | 2020-12-29 | Broomfield | Colorado | 8014 | 2762 | 63 |
872009 | 872009 | 2020-12-28 | Broomfield | Colorado | 8014 | 2740 | 63 |
868764 | 868764 | 2020-12-27 | Broomfield | Colorado | 8014 | 2726 | 63 |
865519 | 865519 | 2020-12-26 | Broomfield | Colorado | 8014 | 2711 | 63 |
862274 | 862274 | 2020-12-25 | Broomfield | Colorado | 8014 | 2704 | 63 |
859029 | 859029 | 2020-12-24 | Broomfield | Colorado | 8014 | 2687 | 63 |
855784 | 855784 | 2020-12-23 | Broomfield | Colorado | 8014 | 2660 | 63 |
852539 | 852539 | 2020-12-22 | Broomfield | Colorado | 8014 | 2632 | 63 |
849294 | 849294 | 2020-12-21 | Broomfield | Colorado | 8014 | 2609 | 62 |
846049 | 846049 | 2020-12-20 | Broomfield | Colorado | 8014 | 2583 | 62 |
842803 | 842803 | 2020-12-19 | Broomfield | Colorado | 8014 | 2573 | 62 |
839558 | 839558 | 2020-12-18 | Broomfield | Colorado | 8014 | 2564 | 61 |
836313 | 836313 | 2020-12-17 | Broomfield | Colorado | 8014 | 2544 | 61 |
833067 | 833067 | 2020-12-16 | Broomfield | Colorado | 8014 | 2511 | 61 |
829820 | 829820 | 2020-12-15 | Broomfield | Colorado | 8014 | 2497 | 61 |
826574 | 826574 | 2020-12-14 | Broomfield | Colorado | 8014 | 2446 | 57 |
823327 | 823327 | 2020-12-13 | Broomfield | Colorado | 8014 | 2446 | 57 |
820081 | 820081 | 2020-12-12 | Broomfield | Colorado | 8014 | 2436 | 57 |
816835 | 816835 | 2020-12-11 | Broomfield | Colorado | 8014 | 2411 | 56 |
813589 | 813589 | 2020-12-10 | Broomfield | Colorado | 8014 | 2374 | 56 |
810345 | 810345 | 2020-12-09 | Broomfield | Colorado | 8014 | 2351 | 54 |
807100 | 807100 | 2020-12-08 | Broomfield | Colorado | 8014 | 2329 | 51 |
803855 | 803855 | 2020-12-07 | Broomfield | Colorado | 8014 | 2289 | 51 |
800610 | 800610 | 2020-12-06 | Broomfield | Colorado | 8014 | 2262 | 51 |
797365 | 797365 | 2020-12-05 | Broomfield | Colorado | 8014 | 2243 | 51 |
794120 | 794120 | 2020-12-04 | Broomfield | Colorado | 8014 | 2200 | 51 |
790875 | 790875 | 2020-12-03 | Broomfield | Colorado | 8014 | 2164 | 51 |
787630 | 787630 | 2020-12-02 | Broomfield | Colorado | 8014 | 2109 | 50 |
784386 | 784386 | 2020-12-01 | Broomfield | Colorado | 8014 | 2087 | 49 |
781141 | 781141 | 2020-11-30 | Broomfield | Colorado | 8014 | 2046 | 49 |
777895 | 777895 | 2020-11-29 | Broomfield | Colorado | 8014 | 2002 | 49 |
774650 | 774650 | 2020-11-28 | Broomfield | Colorado | 8014 | 1982 | 49 |
771405 | 771405 | 2020-11-27 | Broomfield | Colorado | 8014 | 1954 | 49 |
768160 | 768160 | 2020-11-26 | Broomfield | Colorado | 8014 | 1921 | 49 |
764914 | 764914 | 2020-11-25 | Broomfield | Colorado | 8014 | 1872 | 48 |
761669 | 761669 | 2020-11-24 | Broomfield | Colorado | 8014 | 1848 | 48 |
758424 | 758424 | 2020-11-23 | Broomfield | Colorado | 8014 | 1826 | 48 |
755177 | 755177 | 2020-11-22 | Broomfield | Colorado | 8014 | 1806 | 48 |
751931 | 751931 | 2020-11-21 | Broomfield | Colorado | 8014 | 1773 | 48 |
748685 | 748685 | 2020-11-20 | Broomfield | Colorado | 8014 | 1704 | 48 |
745439 | 745439 | 2020-11-19 | Broomfield | Colorado | 8014 | 1656 | 48 |
742192 | 742192 | 2020-11-18 | Broomfield | Colorado | 8014 | 1615 | 47 |
738945 | 738945 | 2020-11-17 | Broomfield | Colorado | 8014 | 1581 | 46 |
735701 | 735701 | 2020-11-16 | Broomfield | Colorado | 8014 | 1553 | 46 |
732455 | 732455 | 2020-11-15 | Broomfield | Colorado | 8014 | 1510 | 45 |
729210 | 729210 | 2020-11-14 | Broomfield | Colorado | 8014 | 1487 | 45 |
725967 | 725967 | 2020-11-13 | Broomfield | Colorado | 8014 | 1450 | 45 |
722724 | 722724 | 2020-11-12 | Broomfield | Colorado | 8014 | 1389 | 45 |
719481 | 719481 | 2020-11-11 | Broomfield | Colorado | 8014 | 1348 | 43 |
716238 | 716238 | 2020-11-10 | Broomfield | Colorado | 8014 | 1321 | 43 |
712994 | 712994 | 2020-11-09 | Broomfield | Colorado | 8014 | 1283 | 43 |
709750 | 709750 | 2020-11-08 | Broomfield | Colorado | 8014 | 1269 | 43 |
706506 | 706506 | 2020-11-07 | Broomfield | Colorado | 8014 | 1242 | 43 |
703263 | 703263 | 2020-11-06 | Broomfield | Colorado | 8014 | 1209 | 43 |
700020 | 700020 | 2020-11-05 | Broomfield | Colorado | 8014 | 1185 | 43 |
696776 | 696776 | 2020-11-04 | Broomfield | Colorado | 8014 | 1156 | 42 |
693534 | 693534 | 2020-11-03 | Broomfield | Colorado | 8014 | 1137 | 42 |
690291 | 690291 | 2020-11-02 | Broomfield | Colorado | 8014 | 1120 | 42 |
687046 | 687046 | 2020-11-01 | Broomfield | Colorado | 8014 | 1091 | 42 |
683802 | 683802 | 2020-10-31 | Broomfield | Colorado | 8014 | 1071 | 42 |
680559 | 680559 | 2020-10-30 | Broomfield | Colorado | 8014 | 1041 | 42 |
677316 | 677316 | 2020-10-29 | Broomfield | Colorado | 8014 | 997 | 42 |
674073 | 674073 | 2020-10-28 | Broomfield | Colorado | 8014 | 985 | 42 |
670831 | 670831 | 2020-10-27 | Broomfield | Colorado | 8014 | 947 | 41 |
667588 | 667588 | 2020-10-26 | Broomfield | Colorado | 8014 | 930 | 41 |
664343 | 664343 | 2020-10-25 | Broomfield | Colorado | 8014 | 902 | 41 |
661099 | 661099 | 2020-10-24 | Broomfield | Colorado | 8014 | 887 | 41 |
657855 | 657855 | 2020-10-23 | Broomfield | Colorado | 8014 | 879 | 41 |
654610 | 654610 | 2020-10-22 | Broomfield | Colorado | 8014 | 862 | 41 |
651365 | 651365 | 2020-10-21 | Broomfield | Colorado | 8014 | 846 | 41 |
648121 | 648121 | 2020-10-20 | Broomfield | Colorado | 8014 | 824 | 40 |
644876 | 644876 | 2020-10-19 | Broomfield | Colorado | 8014 | 798 | 40 |
641628 | 641628 | 2020-10-18 | Broomfield | Colorado | 8014 | 789 | 39 |
638381 | 638381 | 2020-10-17 | Broomfield | Colorado | 8014 | 778 | 39 |
635136 | 635136 | 2020-10-16 | Broomfield | Colorado | 8014 | 767 | 39 |
631890 | 631890 | 2020-10-15 | Broomfield | Colorado | 8014 | 763 | 37 |
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);