ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Eagle" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277807 | 1277807 | 2021-05-02 | Eagle | Colorado | 8037 | 6231 | 22 |
1274560 | 1274560 | 2021-05-01 | Eagle | Colorado | 8037 | 6230 | 22 |
1271313 | 1271313 | 2021-04-30 | Eagle | Colorado | 8037 | 6215 | 22 |
1268066 | 1268066 | 2021-04-29 | Eagle | Colorado | 8037 | 6197 | 22 |
1264819 | 1264819 | 2021-04-28 | Eagle | Colorado | 8037 | 6184 | 22 |
1261572 | 1261572 | 2021-04-27 | Eagle | Colorado | 8037 | 6176 | 22 |
1258325 | 1258325 | 2021-04-26 | Eagle | Colorado | 8037 | 6157 | 22 |
1255078 | 1255078 | 2021-04-25 | Eagle | Colorado | 8037 | 6157 | 22 |
1251831 | 1251831 | 2021-04-24 | Eagle | Colorado | 8037 | 6150 | 22 |
1248584 | 1248584 | 2021-04-23 | Eagle | Colorado | 8037 | 6138 | 22 |
1245337 | 1245337 | 2021-04-22 | Eagle | Colorado | 8037 | 6123 | 22 |
1242090 | 1242090 | 2021-04-21 | Eagle | Colorado | 8037 | 6107 | 22 |
1238843 | 1238843 | 2021-04-20 | Eagle | Colorado | 8037 | 6089 | 22 |
1235596 | 1235596 | 2021-04-19 | Eagle | Colorado | 8037 | 6064 | 22 |
1232349 | 1232349 | 2021-04-18 | Eagle | Colorado | 8037 | 6055 | 22 |
1229100 | 1229100 | 2021-04-17 | Eagle | Colorado | 8037 | 6045 | 22 |
1225852 | 1225852 | 2021-04-16 | Eagle | Colorado | 8037 | 6036 | 22 |
1222605 | 1222605 | 2021-04-15 | Eagle | Colorado | 8037 | 6018 | 22 |
1219357 | 1219357 | 2021-04-14 | Eagle | Colorado | 8037 | 6009 | 22 |
1216109 | 1216109 | 2021-04-13 | Eagle | Colorado | 8037 | 5988 | 22 |
1212862 | 1212862 | 2021-04-12 | Eagle | Colorado | 8037 | 5961 | 22 |
1209614 | 1209614 | 2021-04-11 | Eagle | Colorado | 8037 | 5955 | 22 |
1206365 | 1206365 | 2021-04-10 | Eagle | Colorado | 8037 | 5937 | 22 |
1203117 | 1203117 | 2021-04-09 | Eagle | Colorado | 8037 | 5910 | 22 |
1199869 | 1199869 | 2021-04-08 | Eagle | Colorado | 8037 | 5889 | 22 |
1196620 | 1196620 | 2021-04-07 | Eagle | Colorado | 8037 | 5842 | 22 |
1193372 | 1193372 | 2021-04-06 | Eagle | Colorado | 8037 | 5842 | 22 |
1190122 | 1190122 | 2021-04-05 | Eagle | Colorado | 8037 | 5809 | 22 |
1186875 | 1186875 | 2021-04-04 | Eagle | Colorado | 8037 | 5799 | 22 |
1183628 | 1183628 | 2021-04-03 | Eagle | Colorado | 8037 | 5790 | 22 |
1180381 | 1180381 | 2021-04-02 | Eagle | Colorado | 8037 | 5777 | 22 |
1177134 | 1177134 | 2021-04-01 | Eagle | Colorado | 8037 | 5756 | 22 |
1173887 | 1173887 | 2021-03-31 | Eagle | Colorado | 8037 | 5738 | 22 |
1170640 | 1170640 | 2021-03-30 | Eagle | Colorado | 8037 | 5704 | 22 |
1167392 | 1167392 | 2021-03-29 | Eagle | Colorado | 8037 | 5694 | 22 |
1164144 | 1164144 | 2021-03-28 | Eagle | Colorado | 8037 | 5687 | 22 |
1160896 | 1160896 | 2021-03-27 | Eagle | Colorado | 8037 | 5663 | 22 |
1157648 | 1157648 | 2021-03-26 | Eagle | Colorado | 8037 | 5645 | 22 |
1154401 | 1154401 | 2021-03-25 | Eagle | Colorado | 8037 | 5612 | 22 |
1151154 | 1151154 | 2021-03-24 | Eagle | Colorado | 8037 | 5585 | 22 |
1147907 | 1147907 | 2021-03-23 | Eagle | Colorado | 8037 | 5566 | 22 |
1144660 | 1144660 | 2021-03-22 | Eagle | Colorado | 8037 | 5536 | 22 |
1141413 | 1141413 | 2021-03-21 | Eagle | Colorado | 8037 | 5523 | 22 |
1138167 | 1138167 | 2021-03-20 | Eagle | Colorado | 8037 | 5497 | 22 |
1134921 | 1134921 | 2021-03-19 | Eagle | Colorado | 8037 | 5489 | 22 |
1131674 | 1131674 | 2021-03-18 | Eagle | Colorado | 8037 | 5468 | 22 |
1128426 | 1128426 | 2021-03-17 | Eagle | Colorado | 8037 | 5431 | 22 |
1125180 | 1125180 | 2021-03-16 | Eagle | Colorado | 8037 | 5415 | 22 |
1121934 | 1121934 | 2021-03-15 | Eagle | Colorado | 8037 | 5398 | 22 |
1118687 | 1118687 | 2021-03-14 | Eagle | Colorado | 8037 | 5383 | 22 |
1115440 | 1115440 | 2021-03-13 | Eagle | Colorado | 8037 | 5364 | 22 |
1112194 | 1112194 | 2021-03-12 | Eagle | Colorado | 8037 | 5347 | 22 |
1108948 | 1108948 | 2021-03-11 | Eagle | Colorado | 8037 | 5323 | 22 |
1105702 | 1105702 | 2021-03-10 | Eagle | Colorado | 8037 | 5311 | 22 |
1102456 | 1102456 | 2021-03-09 | Eagle | Colorado | 8037 | 5289 | 22 |
1099210 | 1099210 | 2021-03-08 | Eagle | Colorado | 8037 | 5265 | 22 |
1095962 | 1095962 | 2021-03-07 | Eagle | Colorado | 8037 | 5224 | 21 |
1092716 | 1092716 | 2021-03-06 | Eagle | Colorado | 8037 | 5224 | 21 |
1089470 | 1089470 | 2021-03-05 | Eagle | Colorado | 8037 | 5198 | 21 |
1086225 | 1086225 | 2021-03-04 | Eagle | Colorado | 8037 | 5167 | 21 |
1082979 | 1082979 | 2021-03-03 | Eagle | Colorado | 8037 | 5148 | 21 |
1079733 | 1079733 | 2021-03-02 | Eagle | Colorado | 8037 | 5120 | 20 |
1076488 | 1076488 | 2021-03-01 | Eagle | Colorado | 8037 | 5088 | 20 |
1073242 | 1073242 | 2021-02-28 | Eagle | Colorado | 8037 | 5065 | 20 |
1069996 | 1069996 | 2021-02-27 | Eagle | Colorado | 8037 | 5045 | 20 |
1066751 | 1066751 | 2021-02-26 | Eagle | Colorado | 8037 | 4997 | 20 |
1063506 | 1063506 | 2021-02-25 | Eagle | Colorado | 8037 | 4997 | 20 |
1060261 | 1060261 | 2021-02-24 | Eagle | Colorado | 8037 | 4970 | 20 |
1057015 | 1057015 | 2021-02-23 | Eagle | Colorado | 8037 | 4940 | 20 |
1053769 | 1053769 | 2021-02-22 | Eagle | Colorado | 8037 | 4907 | 20 |
1050522 | 1050522 | 2021-02-21 | Eagle | Colorado | 8037 | 4897 | 20 |
1047275 | 1047275 | 2021-02-20 | Eagle | Colorado | 8037 | 4878 | 20 |
1044030 | 1044030 | 2021-02-19 | Eagle | Colorado | 8037 | 4860 | 20 |
1040785 | 1040785 | 2021-02-18 | Eagle | Colorado | 8037 | 4825 | 20 |
1037540 | 1037540 | 2021-02-17 | Eagle | Colorado | 8037 | 4800 | 20 |
1034295 | 1034295 | 2021-02-16 | Eagle | Colorado | 8037 | 4778 | 20 |
1031049 | 1031049 | 2021-02-15 | Eagle | Colorado | 8037 | 4755 | 20 |
1027802 | 1027802 | 2021-02-14 | Eagle | Colorado | 8037 | 4732 | 20 |
1024557 | 1024557 | 2021-02-13 | Eagle | Colorado | 8037 | 4721 | 20 |
1021312 | 1021312 | 2021-02-12 | Eagle | Colorado | 8037 | 4700 | 20 |
1018067 | 1018067 | 2021-02-11 | Eagle | Colorado | 8037 | 4673 | 20 |
1014822 | 1014822 | 2021-02-10 | Eagle | Colorado | 8037 | 4648 | 20 |
1011577 | 1011577 | 2021-02-09 | Eagle | Colorado | 8037 | 4635 | 20 |
1008331 | 1008331 | 2021-02-08 | Eagle | Colorado | 8037 | 4621 | 20 |
1005085 | 1005085 | 2021-02-07 | Eagle | Colorado | 8037 | 4598 | 20 |
1001839 | 1001839 | 2021-02-06 | Eagle | Colorado | 8037 | 4578 | 20 |
998593 | 998593 | 2021-02-05 | Eagle | Colorado | 8037 | 4553 | 19 |
995347 | 995347 | 2021-02-04 | Eagle | Colorado | 8037 | 4522 | 19 |
992101 | 992101 | 2021-02-03 | Eagle | Colorado | 8037 | 4479 | 17 |
988855 | 988855 | 2021-02-02 | Eagle | Colorado | 8037 | 4427 | 17 |
985608 | 985608 | 2021-02-01 | Eagle | Colorado | 8037 | 4402 | 17 |
982361 | 982361 | 2021-01-31 | Eagle | Colorado | 8037 | 4342 | 17 |
979115 | 979115 | 2021-01-30 | Eagle | Colorado | 8037 | 4342 | 17 |
975870 | 975870 | 2021-01-29 | Eagle | Colorado | 8037 | 4342 | 17 |
972625 | 972625 | 2021-01-28 | Eagle | Colorado | 8037 | 4311 | 17 |
969380 | 969380 | 2021-01-27 | Eagle | Colorado | 8037 | 4282 | 17 |
966136 | 966136 | 2021-01-26 | Eagle | Colorado | 8037 | 4268 | 18 |
962891 | 962891 | 2021-01-25 | Eagle | Colorado | 8037 | 4192 | 18 |
959646 | 959646 | 2021-01-24 | Eagle | Colorado | 8037 | 4192 | 18 |
956400 | 956400 | 2021-01-23 | Eagle | Colorado | 8037 | 4172 | 18 |
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);