ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Jefferson" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277818 | 1277818 | 2021-05-02 | Jefferson | Colorado | 8059 | 45356 | 750 |
1274571 | 1274571 | 2021-05-01 | Jefferson | Colorado | 8059 | 45266 | 750 |
1271324 | 1271324 | 2021-04-30 | Jefferson | Colorado | 8059 | 45079 | 750 |
1268077 | 1268077 | 2021-04-29 | Jefferson | Colorado | 8059 | 44888 | 747 |
1264830 | 1264830 | 2021-04-28 | Jefferson | Colorado | 8059 | 44644 | 748 |
1261583 | 1261583 | 2021-04-27 | Jefferson | Colorado | 8059 | 44558 | 748 |
1258336 | 1258336 | 2021-04-26 | Jefferson | Colorado | 8059 | 44215 | 747 |
1255089 | 1255089 | 2021-04-25 | Jefferson | Colorado | 8059 | 44215 | 747 |
1251842 | 1251842 | 2021-04-24 | Jefferson | Colorado | 8059 | 44019 | 747 |
1248595 | 1248595 | 2021-04-23 | Jefferson | Colorado | 8059 | 43818 | 745 |
1245348 | 1245348 | 2021-04-22 | Jefferson | Colorado | 8059 | 43651 | 745 |
1242101 | 1242101 | 2021-04-21 | Jefferson | Colorado | 8059 | 43431 | 743 |
1238854 | 1238854 | 2021-04-20 | Jefferson | Colorado | 8059 | 43304 | 743 |
1235607 | 1235607 | 2021-04-19 | Jefferson | Colorado | 8059 | 43107 | 740 |
1232360 | 1232360 | 2021-04-18 | Jefferson | Colorado | 8059 | 43044 | 739 |
1229111 | 1229111 | 2021-04-17 | Jefferson | Colorado | 8059 | 42881 | 739 |
1225863 | 1225863 | 2021-04-16 | Jefferson | Colorado | 8059 | 42738 | 739 |
1222616 | 1222616 | 2021-04-15 | Jefferson | Colorado | 8059 | 42496 | 738 |
1219368 | 1219368 | 2021-04-14 | Jefferson | Colorado | 8059 | 42314 | 739 |
1216120 | 1216120 | 2021-04-13 | Jefferson | Colorado | 8059 | 42136 | 739 |
1212873 | 1212873 | 2021-04-12 | Jefferson | Colorado | 8059 | 41987 | 735 |
1209625 | 1209625 | 2021-04-11 | Jefferson | Colorado | 8059 | 41917 | 735 |
1206376 | 1206376 | 2021-04-10 | Jefferson | Colorado | 8059 | 41807 | 734 |
1203128 | 1203128 | 2021-04-09 | Jefferson | Colorado | 8059 | 41687 | 733 |
1199880 | 1199880 | 2021-04-08 | Jefferson | Colorado | 8059 | 41488 | 733 |
1196631 | 1196631 | 2021-04-07 | Jefferson | Colorado | 8059 | 41129 | 733 |
1193383 | 1193383 | 2021-04-06 | Jefferson | Colorado | 8059 | 41129 | 733 |
1190133 | 1190133 | 2021-04-05 | Jefferson | Colorado | 8059 | 41024 | 733 |
1186886 | 1186886 | 2021-04-04 | Jefferson | Colorado | 8059 | 40951 | 733 |
1183639 | 1183639 | 2021-04-03 | Jefferson | Colorado | 8059 | 40823 | 733 |
1180392 | 1180392 | 2021-04-02 | Jefferson | Colorado | 8059 | 40674 | 733 |
1177145 | 1177145 | 2021-04-01 | Jefferson | Colorado | 8059 | 40529 | 733 |
1173898 | 1173898 | 2021-03-31 | Jefferson | Colorado | 8059 | 40391 | 733 |
1170651 | 1170651 | 2021-03-30 | Jefferson | Colorado | 8059 | 40260 | 733 |
1167403 | 1167403 | 2021-03-29 | Jefferson | Colorado | 8059 | 40162 | 731 |
1164155 | 1164155 | 2021-03-28 | Jefferson | Colorado | 8059 | 40108 | 731 |
1160907 | 1160907 | 2021-03-27 | Jefferson | Colorado | 8059 | 40037 | 731 |
1157659 | 1157659 | 2021-03-26 | Jefferson | Colorado | 8059 | 39925 | 729 |
1154412 | 1154412 | 2021-03-25 | Jefferson | Colorado | 8059 | 39806 | 731 |
1151165 | 1151165 | 2021-03-24 | Jefferson | Colorado | 8059 | 39665 | 730 |
1147918 | 1147918 | 2021-03-23 | Jefferson | Colorado | 8059 | 39560 | 729 |
1144671 | 1144671 | 2021-03-22 | Jefferson | Colorado | 8059 | 39417 | 729 |
1141424 | 1141424 | 2021-03-21 | Jefferson | Colorado | 8059 | 39384 | 729 |
1138178 | 1138178 | 2021-03-20 | Jefferson | Colorado | 8059 | 39306 | 730 |
1134932 | 1134932 | 2021-03-19 | Jefferson | Colorado | 8059 | 39152 | 730 |
1131685 | 1131685 | 2021-03-18 | Jefferson | Colorado | 8059 | 38966 | 731 |
1128437 | 1128437 | 2021-03-17 | Jefferson | Colorado | 8059 | 38837 | 733 |
1125191 | 1125191 | 2021-03-16 | Jefferson | Colorado | 8059 | 38778 | 732 |
1121945 | 1121945 | 2021-03-15 | Jefferson | Colorado | 8059 | 38761 | 730 |
1118698 | 1118698 | 2021-03-14 | Jefferson | Colorado | 8059 | 38724 | 730 |
1115451 | 1115451 | 2021-03-13 | Jefferson | Colorado | 8059 | 38602 | 730 |
1112205 | 1112205 | 2021-03-12 | Jefferson | Colorado | 8059 | 38482 | 730 |
1108959 | 1108959 | 2021-03-11 | Jefferson | Colorado | 8059 | 38359 | 730 |
1105713 | 1105713 | 2021-03-10 | Jefferson | Colorado | 8059 | 38265 | 730 |
1102467 | 1102467 | 2021-03-09 | Jefferson | Colorado | 8059 | 38165 | 731 |
1099221 | 1099221 | 2021-03-08 | Jefferson | Colorado | 8059 | 38093 | 728 |
1095973 | 1095973 | 2021-03-07 | Jefferson | Colorado | 8059 | 37933 | 728 |
1092727 | 1092727 | 2021-03-06 | Jefferson | Colorado | 8059 | 37933 | 728 |
1089481 | 1089481 | 2021-03-05 | Jefferson | Colorado | 8059 | 37809 | 729 |
1086236 | 1086236 | 2021-03-04 | Jefferson | Colorado | 8059 | 37583 | 727 |
1082990 | 1082990 | 2021-03-03 | Jefferson | Colorado | 8059 | 37452 | 727 |
1079744 | 1079744 | 2021-03-02 | Jefferson | Colorado | 8059 | 37380 | 725 |
1076499 | 1076499 | 2021-03-01 | Jefferson | Colorado | 8059 | 37323 | 720 |
1073253 | 1073253 | 2021-02-28 | Jefferson | Colorado | 8059 | 37202 | 720 |
1070007 | 1070007 | 2021-02-27 | Jefferson | Colorado | 8059 | 37111 | 720 |
1066762 | 1066762 | 2021-02-26 | Jefferson | Colorado | 8059 | 36851 | 715 |
1063517 | 1063517 | 2021-02-25 | Jefferson | Colorado | 8059 | 36851 | 715 |
1060272 | 1060272 | 2021-02-24 | Jefferson | Colorado | 8059 | 36750 | 713 |
1057026 | 1057026 | 2021-02-23 | Jefferson | Colorado | 8059 | 36660 | 711 |
1053780 | 1053780 | 2021-02-22 | Jefferson | Colorado | 8059 | 36588 | 706 |
1050533 | 1050533 | 2021-02-21 | Jefferson | Colorado | 8059 | 36523 | 706 |
1047286 | 1047286 | 2021-02-20 | Jefferson | Colorado | 8059 | 36435 | 705 |
1044041 | 1044041 | 2021-02-19 | Jefferson | Colorado | 8059 | 36348 | 702 |
1040796 | 1040796 | 2021-02-18 | Jefferson | Colorado | 8059 | 36263 | 702 |
1037551 | 1037551 | 2021-02-17 | Jefferson | Colorado | 8059 | 36182 | 702 |
1034306 | 1034306 | 2021-02-16 | Jefferson | Colorado | 8059 | 36104 | 698 |
1031060 | 1031060 | 2021-02-15 | Jefferson | Colorado | 8059 | 36057 | 698 |
1027813 | 1027813 | 2021-02-14 | Jefferson | Colorado | 8059 | 36010 | 698 |
1024568 | 1024568 | 2021-02-13 | Jefferson | Colorado | 8059 | 35913 | 695 |
1021323 | 1021323 | 2021-02-12 | Jefferson | Colorado | 8059 | 35803 | 692 |
1018078 | 1018078 | 2021-02-11 | Jefferson | Colorado | 8059 | 35660 | 691 |
1014833 | 1014833 | 2021-02-10 | Jefferson | Colorado | 8059 | 35480 | 691 |
1011588 | 1011588 | 2021-02-09 | Jefferson | Colorado | 8059 | 35433 | 689 |
1008342 | 1008342 | 2021-02-08 | Jefferson | Colorado | 8059 | 35360 | 690 |
1005096 | 1005096 | 2021-02-07 | Jefferson | Colorado | 8059 | 35284 | 690 |
1001850 | 1001850 | 2021-02-06 | Jefferson | Colorado | 8059 | 35181 | 690 |
998604 | 998604 | 2021-02-05 | Jefferson | Colorado | 8059 | 35072 | 691 |
995358 | 995358 | 2021-02-04 | Jefferson | Colorado | 8059 | 34966 | 684 |
992112 | 992112 | 2021-02-03 | Jefferson | Colorado | 8059 | 34827 | 682 |
988866 | 988866 | 2021-02-02 | Jefferson | Colorado | 8059 | 34737 | 684 |
985619 | 985619 | 2021-02-01 | Jefferson | Colorado | 8059 | 34665 | 683 |
982372 | 982372 | 2021-01-31 | Jefferson | Colorado | 8059 | 34364 | 683 |
979126 | 979126 | 2021-01-30 | Jefferson | Colorado | 8059 | 34364 | 683 |
975881 | 975881 | 2021-01-29 | Jefferson | Colorado | 8059 | 34364 | 683 |
972636 | 972636 | 2021-01-28 | Jefferson | Colorado | 8059 | 34228 | 680 |
969391 | 969391 | 2021-01-27 | Jefferson | Colorado | 8059 | 34087 | 679 |
966147 | 966147 | 2021-01-26 | Jefferson | Colorado | 8059 | 33960 | 679 |
962902 | 962902 | 2021-01-25 | Jefferson | Colorado | 8059 | 33760 | 676 |
959657 | 959657 | 2021-01-24 | Jefferson | Colorado | 8059 | 33760 | 676 |
956411 | 956411 | 2021-01-23 | Jefferson | Colorado | 8059 | 33640 | 675 |
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);