ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 8045 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277811 | 1277811 | 2021-05-02 | Garfield | Colorado | 8045 | 5775 | 38 |
1274564 | 1274564 | 2021-05-01 | Garfield | Colorado | 8045 | 5770 | 38 |
1271317 | 1271317 | 2021-04-30 | Garfield | Colorado | 8045 | 5760 | 38 |
1268070 | 1268070 | 2021-04-29 | Garfield | Colorado | 8045 | 5754 | 38 |
1264823 | 1264823 | 2021-04-28 | Garfield | Colorado | 8045 | 5740 | 38 |
1261576 | 1261576 | 2021-04-27 | Garfield | Colorado | 8045 | 5730 | 38 |
1258329 | 1258329 | 2021-04-26 | Garfield | Colorado | 8045 | 5721 | 38 |
1255082 | 1255082 | 2021-04-25 | Garfield | Colorado | 8045 | 5721 | 38 |
1251835 | 1251835 | 2021-04-24 | Garfield | Colorado | 8045 | 5708 | 38 |
1248588 | 1248588 | 2021-04-23 | Garfield | Colorado | 8045 | 5697 | 38 |
1245341 | 1245341 | 2021-04-22 | Garfield | Colorado | 8045 | 5692 | 38 |
1242094 | 1242094 | 2021-04-21 | Garfield | Colorado | 8045 | 5678 | 38 |
1238847 | 1238847 | 2021-04-20 | Garfield | Colorado | 8045 | 5673 | 38 |
1235600 | 1235600 | 2021-04-19 | Garfield | Colorado | 8045 | 5660 | 38 |
1232353 | 1232353 | 2021-04-18 | Garfield | Colorado | 8045 | 5653 | 38 |
1229104 | 1229104 | 2021-04-17 | Garfield | Colorado | 8045 | 5648 | 38 |
1225856 | 1225856 | 2021-04-16 | Garfield | Colorado | 8045 | 5640 | 38 |
1222609 | 1222609 | 2021-04-15 | Garfield | Colorado | 8045 | 5629 | 38 |
1219361 | 1219361 | 2021-04-14 | Garfield | Colorado | 8045 | 5615 | 38 |
1216113 | 1216113 | 2021-04-13 | Garfield | Colorado | 8045 | 5605 | 38 |
1212866 | 1212866 | 2021-04-12 | Garfield | Colorado | 8045 | 5580 | 38 |
1209618 | 1209618 | 2021-04-11 | Garfield | Colorado | 8045 | 5574 | 38 |
1206369 | 1206369 | 2021-04-10 | Garfield | Colorado | 8045 | 5566 | 38 |
1203121 | 1203121 | 2021-04-09 | Garfield | Colorado | 8045 | 5561 | 38 |
1199873 | 1199873 | 2021-04-08 | Garfield | Colorado | 8045 | 5534 | 38 |
1196624 | 1196624 | 2021-04-07 | Garfield | Colorado | 8045 | 5497 | 38 |
1193376 | 1193376 | 2021-04-06 | Garfield | Colorado | 8045 | 5497 | 38 |
1190126 | 1190126 | 2021-04-05 | Garfield | Colorado | 8045 | 5489 | 38 |
1186879 | 1186879 | 2021-04-04 | Garfield | Colorado | 8045 | 5481 | 38 |
1183632 | 1183632 | 2021-04-03 | Garfield | Colorado | 8045 | 5470 | 38 |
1180385 | 1180385 | 2021-04-02 | Garfield | Colorado | 8045 | 5455 | 38 |
1177138 | 1177138 | 2021-04-01 | Garfield | Colorado | 8045 | 5439 | 38 |
1173891 | 1173891 | 2021-03-31 | Garfield | Colorado | 8045 | 5414 | 38 |
1170644 | 1170644 | 2021-03-30 | Garfield | Colorado | 8045 | 5402 | 38 |
1167396 | 1167396 | 2021-03-29 | Garfield | Colorado | 8045 | 5392 | 38 |
1164148 | 1164148 | 2021-03-28 | Garfield | Colorado | 8045 | 5386 | 38 |
1160900 | 1160900 | 2021-03-27 | Garfield | Colorado | 8045 | 5373 | 38 |
1157652 | 1157652 | 2021-03-26 | Garfield | Colorado | 8045 | 5364 | 38 |
1154405 | 1154405 | 2021-03-25 | Garfield | Colorado | 8045 | 5339 | 38 |
1151158 | 1151158 | 2021-03-24 | Garfield | Colorado | 8045 | 5325 | 38 |
1147911 | 1147911 | 2021-03-23 | Garfield | Colorado | 8045 | 5310 | 38 |
1144664 | 1144664 | 2021-03-22 | Garfield | Colorado | 8045 | 5300 | 38 |
1141417 | 1141417 | 2021-03-21 | Garfield | Colorado | 8045 | 5286 | 38 |
1138171 | 1138171 | 2021-03-20 | Garfield | Colorado | 8045 | 5272 | 38 |
1134925 | 1134925 | 2021-03-19 | Garfield | Colorado | 8045 | 5254 | 38 |
1131678 | 1131678 | 2021-03-18 | Garfield | Colorado | 8045 | 5249 | 38 |
1128430 | 1128430 | 2021-03-17 | Garfield | Colorado | 8045 | 5240 | 38 |
1125184 | 1125184 | 2021-03-16 | Garfield | Colorado | 8045 | 5229 | 38 |
1121938 | 1121938 | 2021-03-15 | Garfield | Colorado | 8045 | 5218 | 38 |
1118691 | 1118691 | 2021-03-14 | Garfield | Colorado | 8045 | 5213 | 38 |
1115444 | 1115444 | 2021-03-13 | Garfield | Colorado | 8045 | 5204 | 38 |
1112198 | 1112198 | 2021-03-12 | Garfield | Colorado | 8045 | 5191 | 38 |
1108952 | 1108952 | 2021-03-11 | Garfield | Colorado | 8045 | 5169 | 38 |
1105706 | 1105706 | 2021-03-10 | Garfield | Colorado | 8045 | 5159 | 38 |
1102460 | 1102460 | 2021-03-09 | Garfield | Colorado | 8045 | 5152 | 38 |
1099214 | 1099214 | 2021-03-08 | Garfield | Colorado | 8045 | 5145 | 38 |
1095966 | 1095966 | 2021-03-07 | Garfield | Colorado | 8045 | 5141 | 38 |
1092720 | 1092720 | 2021-03-06 | Garfield | Colorado | 8045 | 5141 | 38 |
1089474 | 1089474 | 2021-03-05 | Garfield | Colorado | 8045 | 5132 | 39 |
1086229 | 1086229 | 2021-03-04 | Garfield | Colorado | 8045 | 5131 | 38 |
1082983 | 1082983 | 2021-03-03 | Garfield | Colorado | 8045 | 5120 | 38 |
1079737 | 1079737 | 2021-03-02 | Garfield | Colorado | 8045 | 5116 | 38 |
1076492 | 1076492 | 2021-03-01 | Garfield | Colorado | 8045 | 5110 | 38 |
1073246 | 1073246 | 2021-02-28 | Garfield | Colorado | 8045 | 5096 | 38 |
1070000 | 1070000 | 2021-02-27 | Garfield | Colorado | 8045 | 5081 | 38 |
1066755 | 1066755 | 2021-02-26 | Garfield | Colorado | 8045 | 5054 | 38 |
1063510 | 1063510 | 2021-02-25 | Garfield | Colorado | 8045 | 5054 | 38 |
1060265 | 1060265 | 2021-02-24 | Garfield | Colorado | 8045 | 5049 | 38 |
1057019 | 1057019 | 2021-02-23 | Garfield | Colorado | 8045 | 5034 | 38 |
1053773 | 1053773 | 2021-02-22 | Garfield | Colorado | 8045 | 5026 | 38 |
1050526 | 1050526 | 2021-02-21 | Garfield | Colorado | 8045 | 5022 | 38 |
1047279 | 1047279 | 2021-02-20 | Garfield | Colorado | 8045 | 5017 | 38 |
1044034 | 1044034 | 2021-02-19 | Garfield | Colorado | 8045 | 5010 | 39 |
1040789 | 1040789 | 2021-02-18 | Garfield | Colorado | 8045 | 4995 | 38 |
1037544 | 1037544 | 2021-02-17 | Garfield | Colorado | 8045 | 4986 | 38 |
1034299 | 1034299 | 2021-02-16 | Garfield | Colorado | 8045 | 4978 | 38 |
1031053 | 1031053 | 2021-02-15 | Garfield | Colorado | 8045 | 4971 | 38 |
1027806 | 1027806 | 2021-02-14 | Garfield | Colorado | 8045 | 4969 | 38 |
1024561 | 1024561 | 2021-02-13 | Garfield | Colorado | 8045 | 4963 | 38 |
1021316 | 1021316 | 2021-02-12 | Garfield | Colorado | 8045 | 4957 | 38 |
1018071 | 1018071 | 2021-02-11 | Garfield | Colorado | 8045 | 4948 | 39 |
1014826 | 1014826 | 2021-02-10 | Garfield | Colorado | 8045 | 4939 | 38 |
1011581 | 1011581 | 2021-02-09 | Garfield | Colorado | 8045 | 4933 | 38 |
1008335 | 1008335 | 2021-02-08 | Garfield | Colorado | 8045 | 4928 | 38 |
1005089 | 1005089 | 2021-02-07 | Garfield | Colorado | 8045 | 4922 | 38 |
1001843 | 1001843 | 2021-02-06 | Garfield | Colorado | 8045 | 4909 | 37 |
998597 | 998597 | 2021-02-05 | Garfield | Colorado | 8045 | 4895 | 37 |
995351 | 995351 | 2021-02-04 | Garfield | Colorado | 8045 | 4877 | 37 |
992105 | 992105 | 2021-02-03 | Garfield | Colorado | 8045 | 4851 | 37 |
988859 | 988859 | 2021-02-02 | Garfield | Colorado | 8045 | 4840 | 37 |
985612 | 985612 | 2021-02-01 | Garfield | Colorado | 8045 | 4831 | 37 |
982365 | 982365 | 2021-01-31 | Garfield | Colorado | 8045 | 4783 | 38 |
979119 | 979119 | 2021-01-30 | Garfield | Colorado | 8045 | 4783 | 38 |
975874 | 975874 | 2021-01-29 | Garfield | Colorado | 8045 | 4783 | 38 |
972629 | 972629 | 2021-01-28 | Garfield | Colorado | 8045 | 4763 | 36 |
969384 | 969384 | 2021-01-27 | Garfield | Colorado | 8045 | 4760 | 36 |
966140 | 966140 | 2021-01-26 | Garfield | Colorado | 8045 | 4712 | 36 |
962895 | 962895 | 2021-01-25 | Garfield | Colorado | 8045 | 4640 | 36 |
959650 | 959650 | 2021-01-24 | Garfield | Colorado | 8045 | 4640 | 36 |
956404 | 956404 | 2021-01-23 | Garfield | Colorado | 8045 | 4627 | 36 |
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);