ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "El Paso" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277808 | 1277808 | 2021-05-02 | El Paso | Colorado | 8041 | 64366 | 791 |
1274561 | 1274561 | 2021-05-01 | El Paso | Colorado | 8041 | 64179 | 791 |
1271314 | 1271314 | 2021-04-30 | El Paso | Colorado | 8041 | 63886 | 791 |
1268067 | 1268067 | 2021-04-29 | El Paso | Colorado | 8041 | 63562 | 789 |
1264820 | 1264820 | 2021-04-28 | El Paso | Colorado | 8041 | 63082 | 785 |
1261573 | 1261573 | 2021-04-27 | El Paso | Colorado | 8041 | 62982 | 783 |
1258326 | 1258326 | 2021-04-26 | El Paso | Colorado | 8041 | 62522 | 783 |
1255079 | 1255079 | 2021-04-25 | El Paso | Colorado | 8041 | 62522 | 783 |
1251832 | 1251832 | 2021-04-24 | El Paso | Colorado | 8041 | 62254 | 783 |
1248585 | 1248585 | 2021-04-23 | El Paso | Colorado | 8041 | 62034 | 781 |
1245338 | 1245338 | 2021-04-22 | El Paso | Colorado | 8041 | 61751 | 781 |
1242091 | 1242091 | 2021-04-21 | El Paso | Colorado | 8041 | 61361 | 777 |
1238844 | 1238844 | 2021-04-20 | El Paso | Colorado | 8041 | 61137 | 777 |
1235597 | 1235597 | 2021-04-19 | El Paso | Colorado | 8041 | 60762 | 777 |
1232350 | 1232350 | 2021-04-18 | El Paso | Colorado | 8041 | 60646 | 777 |
1229101 | 1229101 | 2021-04-17 | El Paso | Colorado | 8041 | 60485 | 776 |
1225853 | 1225853 | 2021-04-16 | El Paso | Colorado | 8041 | 60309 | 775 |
1222606 | 1222606 | 2021-04-15 | El Paso | Colorado | 8041 | 59991 | 771 |
1219358 | 1219358 | 2021-04-14 | El Paso | Colorado | 8041 | 59786 | 768 |
1216110 | 1216110 | 2021-04-13 | El Paso | Colorado | 8041 | 59521 | 767 |
1212863 | 1212863 | 2021-04-12 | El Paso | Colorado | 8041 | 59284 | 764 |
1209615 | 1209615 | 2021-04-11 | El Paso | Colorado | 8041 | 59003 | 764 |
1206366 | 1206366 | 2021-04-10 | El Paso | Colorado | 8041 | 58854 | 764 |
1203118 | 1203118 | 2021-04-09 | El Paso | Colorado | 8041 | 58702 | 763 |
1199870 | 1199870 | 2021-04-08 | El Paso | Colorado | 8041 | 58475 | 762 |
1196621 | 1196621 | 2021-04-07 | El Paso | Colorado | 8041 | 58290 | 761 |
1193373 | 1193373 | 2021-04-06 | El Paso | Colorado | 8041 | 57917 | 761 |
1190123 | 1190123 | 2021-04-05 | El Paso | Colorado | 8041 | 57731 | 761 |
1186876 | 1186876 | 2021-04-04 | El Paso | Colorado | 8041 | 57603 | 761 |
1183629 | 1183629 | 2021-04-03 | El Paso | Colorado | 8041 | 57413 | 761 |
1180382 | 1180382 | 2021-04-02 | El Paso | Colorado | 8041 | 57190 | 761 |
1177135 | 1177135 | 2021-04-01 | El Paso | Colorado | 8041 | 56928 | 761 |
1173888 | 1173888 | 2021-03-31 | El Paso | Colorado | 8041 | 56653 | 758 |
1170641 | 1170641 | 2021-03-30 | El Paso | Colorado | 8041 | 56416 | 758 |
1167393 | 1167393 | 2021-03-29 | El Paso | Colorado | 8041 | 56201 | 757 |
1164145 | 1164145 | 2021-03-28 | El Paso | Colorado | 8041 | 56086 | 757 |
1160897 | 1160897 | 2021-03-27 | El Paso | Colorado | 8041 | 55931 | 757 |
1157649 | 1157649 | 2021-03-26 | El Paso | Colorado | 8041 | 55757 | 755 |
1154402 | 1154402 | 2021-03-25 | El Paso | Colorado | 8041 | 55561 | 755 |
1151155 | 1151155 | 2021-03-24 | El Paso | Colorado | 8041 | 55384 | 755 |
1147908 | 1147908 | 2021-03-23 | El Paso | Colorado | 8041 | 55241 | 754 |
1144661 | 1144661 | 2021-03-22 | El Paso | Colorado | 8041 | 55068 | 754 |
1141414 | 1141414 | 2021-03-21 | El Paso | Colorado | 8041 | 54988 | 754 |
1138168 | 1138168 | 2021-03-20 | El Paso | Colorado | 8041 | 54889 | 753 |
1134922 | 1134922 | 2021-03-19 | El Paso | Colorado | 8041 | 54682 | 753 |
1131675 | 1131675 | 2021-03-18 | El Paso | Colorado | 8041 | 54514 | 753 |
1128427 | 1128427 | 2021-03-17 | El Paso | Colorado | 8041 | 54258 | 753 |
1125181 | 1125181 | 2021-03-16 | El Paso | Colorado | 8041 | 54101 | 752 |
1121935 | 1121935 | 2021-03-15 | El Paso | Colorado | 8041 | 54026 | 750 |
1118688 | 1118688 | 2021-03-14 | El Paso | Colorado | 8041 | 53985 | 750 |
1115441 | 1115441 | 2021-03-13 | El Paso | Colorado | 8041 | 53829 | 750 |
1112195 | 1112195 | 2021-03-12 | El Paso | Colorado | 8041 | 53627 | 750 |
1108949 | 1108949 | 2021-03-11 | El Paso | Colorado | 8041 | 53484 | 753 |
1105703 | 1105703 | 2021-03-10 | El Paso | Colorado | 8041 | 53373 | 748 |
1102457 | 1102457 | 2021-03-09 | El Paso | Colorado | 8041 | 53258 | 748 |
1099211 | 1099211 | 2021-03-08 | El Paso | Colorado | 8041 | 53140 | 748 |
1095963 | 1095963 | 2021-03-07 | El Paso | Colorado | 8041 | 52976 | 748 |
1092717 | 1092717 | 2021-03-06 | El Paso | Colorado | 8041 | 52976 | 748 |
1089471 | 1089471 | 2021-03-05 | El Paso | Colorado | 8041 | 52787 | 748 |
1086226 | 1086226 | 2021-03-04 | El Paso | Colorado | 8041 | 52619 | 747 |
1082980 | 1082980 | 2021-03-03 | El Paso | Colorado | 8041 | 52443 | 746 |
1079734 | 1079734 | 2021-03-02 | El Paso | Colorado | 8041 | 52264 | 746 |
1076489 | 1076489 | 2021-03-01 | El Paso | Colorado | 8041 | 52145 | 746 |
1073243 | 1073243 | 2021-02-28 | El Paso | Colorado | 8041 | 51975 | 746 |
1069997 | 1069997 | 2021-02-27 | El Paso | Colorado | 8041 | 51890 | 746 |
1066752 | 1066752 | 2021-02-26 | El Paso | Colorado | 8041 | 51769 | 744 |
1063507 | 1063507 | 2021-02-25 | El Paso | Colorado | 8041 | 51633 | 744 |
1060262 | 1060262 | 2021-02-24 | El Paso | Colorado | 8041 | 51463 | 745 |
1057016 | 1057016 | 2021-02-23 | El Paso | Colorado | 8041 | 51293 | 742 |
1053770 | 1053770 | 2021-02-22 | El Paso | Colorado | 8041 | 51145 | 742 |
1050523 | 1050523 | 2021-02-21 | El Paso | Colorado | 8041 | 50951 | 741 |
1047276 | 1047276 | 2021-02-20 | El Paso | Colorado | 8041 | 50831 | 741 |
1044031 | 1044031 | 2021-02-19 | El Paso | Colorado | 8041 | 50710 | 740 |
1040786 | 1040786 | 2021-02-18 | El Paso | Colorado | 8041 | 50561 | 736 |
1037541 | 1037541 | 2021-02-17 | El Paso | Colorado | 8041 | 50379 | 731 |
1034296 | 1034296 | 2021-02-16 | El Paso | Colorado | 8041 | 50188 | 728 |
1031050 | 1031050 | 2021-02-15 | El Paso | Colorado | 8041 | 50029 | 728 |
1027803 | 1027803 | 2021-02-14 | El Paso | Colorado | 8041 | 49978 | 728 |
1024558 | 1024558 | 2021-02-13 | El Paso | Colorado | 8041 | 49854 | 727 |
1021313 | 1021313 | 2021-02-12 | El Paso | Colorado | 8041 | 49727 | 725 |
1018068 | 1018068 | 2021-02-11 | El Paso | Colorado | 8041 | 49536 | 725 |
1014823 | 1014823 | 2021-02-10 | El Paso | Colorado | 8041 | 49302 | 722 |
1011578 | 1011578 | 2021-02-09 | El Paso | Colorado | 8041 | 49154 | 721 |
1008332 | 1008332 | 2021-02-08 | El Paso | Colorado | 8041 | 49042 | 718 |
1005086 | 1005086 | 2021-02-07 | El Paso | Colorado | 8041 | 48851 | 716 |
1001840 | 1001840 | 2021-02-06 | El Paso | Colorado | 8041 | 48740 | 716 |
998594 | 998594 | 2021-02-05 | El Paso | Colorado | 8041 | 48555 | 715 |
995348 | 995348 | 2021-02-04 | El Paso | Colorado | 8041 | 48383 | 712 |
992102 | 992102 | 2021-02-03 | El Paso | Colorado | 8041 | 48185 | 706 |
988856 | 988856 | 2021-02-02 | El Paso | Colorado | 8041 | 48003 | 705 |
985609 | 985609 | 2021-02-01 | El Paso | Colorado | 8041 | 47890 | 705 |
982362 | 982362 | 2021-01-31 | El Paso | Colorado | 8041 | 47796 | 696 |
979116 | 979116 | 2021-01-30 | El Paso | Colorado | 8041 | 47732 | 696 |
975871 | 975871 | 2021-01-29 | El Paso | Colorado | 8041 | 47614 | 696 |
972626 | 972626 | 2021-01-28 | El Paso | Colorado | 8041 | 47432 | 696 |
969381 | 969381 | 2021-01-27 | El Paso | Colorado | 8041 | 47280 | 692 |
966137 | 966137 | 2021-01-26 | El Paso | Colorado | 8041 | 47195 | 684 |
962892 | 962892 | 2021-01-25 | El Paso | Colorado | 8041 | 47025 | 685 |
959647 | 959647 | 2021-01-24 | El Paso | Colorado | 8041 | 46875 | 685 |
956401 | 956401 | 2021-01-23 | El Paso | Colorado | 8041 | 46718 | 681 |
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);