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 |
---|---|---|---|---|---|---|---|
1053757 | 1053757 | 2021-02-22 | Broomfield | Colorado | 8014 | 3665 | 74 |
1050510 | 1050510 | 2021-02-21 | Broomfield | Colorado | 8014 | 3654 | 74 |
1047263 | 1047263 | 2021-02-20 | Broomfield | Colorado | 8014 | 3646 | 74 |
1044018 | 1044018 | 2021-02-19 | Broomfield | Colorado | 8014 | 3636 | 74 |
1040773 | 1040773 | 2021-02-18 | Broomfield | Colorado | 8014 | 3623 | 73 |
1037528 | 1037528 | 2021-02-17 | Broomfield | Colorado | 8014 | 3612 | 73 |
1034283 | 1034283 | 2021-02-16 | Broomfield | Colorado | 8014 | 3599 | 73 |
1031037 | 1031037 | 2021-02-15 | Broomfield | Colorado | 8014 | 3598 | 73 |
1027790 | 1027790 | 2021-02-14 | Broomfield | Colorado | 8014 | 3596 | 73 |
1024545 | 1024545 | 2021-02-13 | Broomfield | Colorado | 8014 | 3587 | 73 |
1021300 | 1021300 | 2021-02-12 | Broomfield | Colorado | 8014 | 3580 | 73 |
1018055 | 1018055 | 2021-02-11 | Broomfield | Colorado | 8014 | 3566 | 73 |
1014810 | 1014810 | 2021-02-10 | Broomfield | Colorado | 8014 | 3554 | 72 |
1011565 | 1011565 | 2021-02-09 | Broomfield | Colorado | 8014 | 3553 | 72 |
1008319 | 1008319 | 2021-02-08 | Broomfield | Colorado | 8014 | 3539 | 72 |
1005073 | 1005073 | 2021-02-07 | Broomfield | Colorado | 8014 | 3533 | 72 |
1001827 | 1001827 | 2021-02-06 | Broomfield | Colorado | 8014 | 3514 | 72 |
998581 | 998581 | 2021-02-05 | Broomfield | Colorado | 8014 | 3497 | 72 |
995335 | 995335 | 2021-02-04 | Broomfield | Colorado | 8014 | 3466 | 71 |
992089 | 992089 | 2021-02-03 | Broomfield | Colorado | 8014 | 3446 | 71 |
988843 | 988843 | 2021-02-02 | Broomfield | Colorado | 8014 | 3435 | 70 |
985596 | 985596 | 2021-02-01 | Broomfield | Colorado | 8014 | 3426 | 70 |
982349 | 982349 | 2021-01-31 | Broomfield | Colorado | 8014 | 3391 | 69 |
979103 | 979103 | 2021-01-30 | Broomfield | Colorado | 8014 | 3391 | 69 |
975858 | 975858 | 2021-01-29 | Broomfield | Colorado | 8014 | 3391 | 69 |
972613 | 972613 | 2021-01-28 | Broomfield | Colorado | 8014 | 3373 | 69 |
969368 | 969368 | 2021-01-27 | Broomfield | Colorado | 8014 | 3353 | 69 |
966124 | 966124 | 2021-01-26 | Broomfield | Colorado | 8014 | 3332 | 69 |
962879 | 962879 | 2021-01-25 | Broomfield | Colorado | 8014 | 3313 | 69 |
959634 | 959634 | 2021-01-24 | Broomfield | Colorado | 8014 | 3313 | 69 |
956388 | 956388 | 2021-01-23 | Broomfield | Colorado | 8014 | 3290 | 69 |
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 |
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);