ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 8031 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277804 | 1277804 | 2021-05-02 | Denver | Colorado | 8031 | 70708 | 806 |
1274557 | 1274557 | 2021-05-01 | Denver | Colorado | 8031 | 70636 | 806 |
1271310 | 1271310 | 2021-04-30 | Denver | Colorado | 8031 | 70444 | 806 |
1268063 | 1268063 | 2021-04-29 | Denver | Colorado | 8031 | 70296 | 805 |
1264816 | 1264816 | 2021-04-28 | Denver | Colorado | 8031 | 70027 | 800 |
1261569 | 1261569 | 2021-04-27 | Denver | Colorado | 8031 | 69820 | 800 |
1258322 | 1258322 | 2021-04-26 | Denver | Colorado | 8031 | 69387 | 798 |
1255075 | 1255075 | 2021-04-25 | Denver | Colorado | 8031 | 69387 | 798 |
1251828 | 1251828 | 2021-04-24 | Denver | Colorado | 8031 | 69248 | 797 |
1248581 | 1248581 | 2021-04-23 | Denver | Colorado | 8031 | 69048 | 795 |
1245334 | 1245334 | 2021-04-22 | Denver | Colorado | 8031 | 68849 | 794 |
1242087 | 1242087 | 2021-04-21 | Denver | Colorado | 8031 | 68682 | 794 |
1238840 | 1238840 | 2021-04-20 | Denver | Colorado | 8031 | 68518 | 793 |
1235593 | 1235593 | 2021-04-19 | Denver | Colorado | 8031 | 68255 | 793 |
1232346 | 1232346 | 2021-04-18 | Denver | Colorado | 8031 | 68188 | 793 |
1229097 | 1229097 | 2021-04-17 | Denver | Colorado | 8031 | 68034 | 793 |
1225849 | 1225849 | 2021-04-16 | Denver | Colorado | 8031 | 67865 | 793 |
1222602 | 1222602 | 2021-04-15 | Denver | Colorado | 8031 | 67641 | 792 |
1219354 | 1219354 | 2021-04-14 | Denver | Colorado | 8031 | 67387 | 791 |
1216106 | 1216106 | 2021-04-13 | Denver | Colorado | 8031 | 66826 | 792 |
1212859 | 1212859 | 2021-04-12 | Denver | Colorado | 8031 | 66592 | 792 |
1209611 | 1209611 | 2021-04-11 | Denver | Colorado | 8031 | 66509 | 793 |
1206362 | 1206362 | 2021-04-10 | Denver | Colorado | 8031 | 66359 | 793 |
1203114 | 1203114 | 2021-04-09 | Denver | Colorado | 8031 | 66166 | 793 |
1199866 | 1199866 | 2021-04-08 | Denver | Colorado | 8031 | 65934 | 791 |
1196617 | 1196617 | 2021-04-07 | Denver | Colorado | 8031 | 65395 | 791 |
1193369 | 1193369 | 2021-04-06 | Denver | Colorado | 8031 | 65448 | 790 |
1190119 | 1190119 | 2021-04-05 | Denver | Colorado | 8031 | 65148 | 789 |
1186872 | 1186872 | 2021-04-04 | Denver | Colorado | 8031 | 65044 | 789 |
1183625 | 1183625 | 2021-04-03 | Denver | Colorado | 8031 | 64930 | 789 |
1180378 | 1180378 | 2021-04-02 | Denver | Colorado | 8031 | 64748 | 787 |
1177131 | 1177131 | 2021-04-01 | Denver | Colorado | 8031 | 64555 | 787 |
1173884 | 1173884 | 2021-03-31 | Denver | Colorado | 8031 | 64387 | 786 |
1170637 | 1170637 | 2021-03-30 | Denver | Colorado | 8031 | 64100 | 786 |
1167389 | 1167389 | 2021-03-29 | Denver | Colorado | 8031 | 63851 | 786 |
1164141 | 1164141 | 2021-03-28 | Denver | Colorado | 8031 | 63786 | 785 |
1160893 | 1160893 | 2021-03-27 | Denver | Colorado | 8031 | 63651 | 786 |
1157645 | 1157645 | 2021-03-26 | Denver | Colorado | 8031 | 63496 | 786 |
1154398 | 1154398 | 2021-03-25 | Denver | Colorado | 8031 | 63306 | 786 |
1151151 | 1151151 | 2021-03-24 | Denver | Colorado | 8031 | 63123 | 783 |
1147904 | 1147904 | 2021-03-23 | Denver | Colorado | 8031 | 62839 | 782 |
1144657 | 1144657 | 2021-03-22 | Denver | Colorado | 8031 | 62647 | 780 |
1141410 | 1141410 | 2021-03-21 | Denver | Colorado | 8031 | 62578 | 779 |
1138164 | 1138164 | 2021-03-20 | Denver | Colorado | 8031 | 62475 | 779 |
1134918 | 1134918 | 2021-03-19 | Denver | Colorado | 8031 | 62254 | 778 |
1131671 | 1131671 | 2021-03-18 | Denver | Colorado | 8031 | 62090 | 779 |
1128423 | 1128423 | 2021-03-17 | Denver | Colorado | 8031 | 61899 | 778 |
1125177 | 1125177 | 2021-03-16 | Denver | Colorado | 8031 | 61880 | 775 |
1121931 | 1121931 | 2021-03-15 | Denver | Colorado | 8031 | 61859 | 775 |
1118684 | 1118684 | 2021-03-14 | Denver | Colorado | 8031 | 61788 | 772 |
1115437 | 1115437 | 2021-03-13 | Denver | Colorado | 8031 | 61583 | 772 |
1112191 | 1112191 | 2021-03-12 | Denver | Colorado | 8031 | 61442 | 772 |
1108945 | 1108945 | 2021-03-11 | Denver | Colorado | 8031 | 61275 | 771 |
1105699 | 1105699 | 2021-03-10 | Denver | Colorado | 8031 | 61117 | 769 |
1102453 | 1102453 | 2021-03-09 | Denver | Colorado | 8031 | 60887 | 768 |
1099207 | 1099207 | 2021-03-08 | Denver | Colorado | 8031 | 60715 | 769 |
1095959 | 1095959 | 2021-03-07 | Denver | Colorado | 8031 | 60544 | 770 |
1092713 | 1092713 | 2021-03-06 | Denver | Colorado | 8031 | 60505 | 770 |
1089467 | 1089467 | 2021-03-05 | Denver | Colorado | 8031 | 60389 | 769 |
1086222 | 1086222 | 2021-03-04 | Denver | Colorado | 8031 | 60140 | 769 |
1082976 | 1082976 | 2021-03-03 | Denver | Colorado | 8031 | 59985 | 769 |
1079730 | 1079730 | 2021-03-02 | Denver | Colorado | 8031 | 59842 | 769 |
1076485 | 1076485 | 2021-03-01 | Denver | Colorado | 8031 | 59779 | 768 |
1073239 | 1073239 | 2021-02-28 | Denver | Colorado | 8031 | 59693 | 768 |
1069993 | 1069993 | 2021-02-27 | Denver | Colorado | 8031 | 59616 | 766 |
1066748 | 1066748 | 2021-02-26 | Denver | Colorado | 8031 | 59534 | 766 |
1063503 | 1063503 | 2021-02-25 | Denver | Colorado | 8031 | 59242 | 767 |
1060258 | 1060258 | 2021-02-24 | Denver | Colorado | 8031 | 59083 | 766 |
1057012 | 1057012 | 2021-02-23 | Denver | Colorado | 8031 | 58929 | 766 |
1053766 | 1053766 | 2021-02-22 | Denver | Colorado | 8031 | 58688 | 766 |
1050519 | 1050519 | 2021-02-21 | Denver | Colorado | 8031 | 58628 | 766 |
1047272 | 1047272 | 2021-02-20 | Denver | Colorado | 8031 | 58432 | 765 |
1044027 | 1044027 | 2021-02-19 | Denver | Colorado | 8031 | 58432 | 765 |
1040782 | 1040782 | 2021-02-18 | Denver | Colorado | 8031 | 58288 | 762 |
1037537 | 1037537 | 2021-02-17 | Denver | Colorado | 8031 | 58156 | 760 |
1034292 | 1034292 | 2021-02-16 | Denver | Colorado | 8031 | 58038 | 756 |
1031046 | 1031046 | 2021-02-15 | Denver | Colorado | 8031 | 57952 | 752 |
1027799 | 1027799 | 2021-02-14 | Denver | Colorado | 8031 | 57888 | 752 |
1024554 | 1024554 | 2021-02-13 | Denver | Colorado | 8031 | 57809 | 752 |
1021309 | 1021309 | 2021-02-12 | Denver | Colorado | 8031 | 57582 | 752 |
1018064 | 1018064 | 2021-02-11 | Denver | Colorado | 8031 | 57539 | 751 |
1014819 | 1014819 | 2021-02-10 | Denver | Colorado | 8031 | 57100 | 751 |
1011574 | 1011574 | 2021-02-09 | Denver | Colorado | 8031 | 57081 | 748 |
1008328 | 1008328 | 2021-02-08 | Denver | Colorado | 8031 | 56945 | 748 |
1005082 | 1005082 | 2021-02-07 | Denver | Colorado | 8031 | 56831 | 746 |
1001836 | 1001836 | 2021-02-06 | Denver | Colorado | 8031 | 56679 | 746 |
998590 | 998590 | 2021-02-05 | Denver | Colorado | 8031 | 56523 | 744 |
995344 | 995344 | 2021-02-04 | Denver | Colorado | 8031 | 56340 | 744 |
992098 | 992098 | 2021-02-03 | Denver | Colorado | 8031 | 56166 | 745 |
988852 | 988852 | 2021-02-02 | Denver | Colorado | 8031 | 55979 | 745 |
985605 | 985605 | 2021-02-01 | Denver | Colorado | 8031 | 55887 | 743 |
982358 | 982358 | 2021-01-31 | Denver | Colorado | 8031 | 55782 | 744 |
979112 | 979112 | 2021-01-30 | Denver | Colorado | 8031 | 55640 | 743 |
975867 | 975867 | 2021-01-29 | Denver | Colorado | 8031 | 55464 | 741 |
972622 | 972622 | 2021-01-28 | Denver | Colorado | 8031 | 55907 | 739 |
969377 | 969377 | 2021-01-27 | Denver | Colorado | 8031 | 55009 | 738 |
966133 | 966133 | 2021-01-26 | Denver | Colorado | 8031 | 54812 | 736 |
962888 | 962888 | 2021-01-25 | Denver | Colorado | 8031 | 54680 | 733 |
959643 | 959643 | 2021-01-24 | Denver | Colorado | 8031 | 54554 | 732 |
956397 | 956397 | 2021-01-23 | Denver | Colorado | 8031 | 54371 | 728 |
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);