ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where county = "Grand", deaths = 5 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1089476 | 1089476 | 2021-03-05 | Grand | Colorado | 8049 | 1287 | 5 |
1086231 | 1086231 | 2021-03-04 | Grand | Colorado | 8049 | 1288 | 5 |
1082985 | 1082985 | 2021-03-03 | Grand | Colorado | 8049 | 1282 | 5 |
1079739 | 1079739 | 2021-03-02 | Grand | Colorado | 8049 | 1273 | 5 |
1076494 | 1076494 | 2021-03-01 | Grand | Colorado | 8049 | 1272 | 5 |
1073248 | 1073248 | 2021-02-28 | Grand | Colorado | 8049 | 1271 | 5 |
1070002 | 1070002 | 2021-02-27 | Grand | Colorado | 8049 | 1271 | 5 |
1066757 | 1066757 | 2021-02-26 | Grand | Colorado | 8049 | 1259 | 5 |
1063512 | 1063512 | 2021-02-25 | Grand | Colorado | 8049 | 1259 | 5 |
1060267 | 1060267 | 2021-02-24 | Grand | Colorado | 8049 | 1252 | 5 |
1057021 | 1057021 | 2021-02-23 | Grand | Colorado | 8049 | 1243 | 5 |
1053775 | 1053775 | 2021-02-22 | Grand | Colorado | 8049 | 1242 | 5 |
1050528 | 1050528 | 2021-02-21 | Grand | Colorado | 8049 | 1241 | 5 |
1047281 | 1047281 | 2021-02-20 | Grand | Colorado | 8049 | 1234 | 5 |
1044036 | 1044036 | 2021-02-19 | Grand | Colorado | 8049 | 1226 | 5 |
1040791 | 1040791 | 2021-02-18 | Grand | Colorado | 8049 | 1218 | 5 |
1037546 | 1037546 | 2021-02-17 | Grand | Colorado | 8049 | 1211 | 5 |
1034301 | 1034301 | 2021-02-16 | Grand | Colorado | 8049 | 1184 | 5 |
1031055 | 1031055 | 2021-02-15 | Grand | Colorado | 8049 | 1167 | 5 |
1027808 | 1027808 | 2021-02-14 | Grand | Colorado | 8049 | 1166 | 5 |
1024563 | 1024563 | 2021-02-13 | Grand | Colorado | 8049 | 1159 | 5 |
1021318 | 1021318 | 2021-02-12 | Grand | Colorado | 8049 | 1159 | 5 |
1018073 | 1018073 | 2021-02-11 | Grand | Colorado | 8049 | 1127 | 5 |
1014828 | 1014828 | 2021-02-10 | Grand | Colorado | 8049 | 1119 | 5 |
1011583 | 1011583 | 2021-02-09 | Grand | Colorado | 8049 | 1104 | 5 |
1008337 | 1008337 | 2021-02-08 | Grand | Colorado | 8049 | 1103 | 5 |
1005091 | 1005091 | 2021-02-07 | Grand | Colorado | 8049 | 1083 | 5 |
1001845 | 1001845 | 2021-02-06 | Grand | Colorado | 8049 | 1074 | 5 |
998599 | 998599 | 2021-02-05 | Grand | Colorado | 8049 | 1063 | 5 |
995353 | 995353 | 2021-02-04 | Grand | Colorado | 8049 | 1038 | 5 |
992107 | 992107 | 2021-02-03 | Grand | Colorado | 8049 | 1005 | 5 |
988861 | 988861 | 2021-02-02 | Grand | Colorado | 8049 | 979 | 5 |
985614 | 985614 | 2021-02-01 | Grand | Colorado | 8049 | 975 | 5 |
982367 | 982367 | 2021-01-31 | Grand | Colorado | 8049 | 930 | 5 |
979121 | 979121 | 2021-01-30 | Grand | Colorado | 8049 | 930 | 5 |
975876 | 975876 | 2021-01-29 | Grand | Colorado | 8049 | 930 | 5 |
972631 | 972631 | 2021-01-28 | Grand | Colorado | 8049 | 924 | 5 |
969386 | 969386 | 2021-01-27 | Grand | Colorado | 8049 | 917 | 5 |
966142 | 966142 | 2021-01-26 | Grand | Colorado | 8049 | 908 | 5 |
962897 | 962897 | 2021-01-25 | Grand | Colorado | 8049 | 898 | 5 |
959652 | 959652 | 2021-01-24 | Grand | Colorado | 8049 | 898 | 5 |
956406 | 956406 | 2021-01-23 | Grand | Colorado | 8049 | 892 | 5 |
953161 | 953161 | 2021-01-22 | Grand | Colorado | 8049 | 863 | 5 |
943423 | 943423 | 2021-01-19 | Grand | Colorado | 8049 | 805 | 5 |
940178 | 940178 | 2021-01-18 | Grand | Colorado | 8049 | 803 | 5 |
836331 | 836331 | 2020-12-17 | Grand | Colorado | 8049 | 567 | 5 |
833085 | 833085 | 2020-12-16 | Grand | Colorado | 8049 | 560 | 5 |
829838 | 829838 | 2020-12-15 | Grand | Colorado | 8049 | 535 | 5 |
826592 | 826592 | 2020-12-14 | Grand | Colorado | 8049 | 521 | 5 |
823345 | 823345 | 2020-12-13 | Grand | Colorado | 8049 | 521 | 5 |
820099 | 820099 | 2020-12-12 | Grand | Colorado | 8049 | 517 | 5 |
816853 | 816853 | 2020-12-11 | Grand | Colorado | 8049 | 517 | 5 |
813607 | 813607 | 2020-12-10 | Grand | Colorado | 8049 | 507 | 5 |
810363 | 810363 | 2020-12-09 | Grand | Colorado | 8049 | 498 | 5 |
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);