ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Summit" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281082 | 281082 | 2020-06-28 | Summit | Colorado | 8117 | 269 | 3 |
277935 | 277935 | 2020-06-27 | Summit | Colorado | 8117 | 267 | 3 |
274787 | 274787 | 2020-06-26 | Summit | Colorado | 8117 | 267 | 3 |
271647 | 271647 | 2020-06-25 | Summit | Colorado | 8117 | 265 | 3 |
268511 | 268511 | 2020-06-24 | Summit | Colorado | 8117 | 264 | 3 |
265381 | 265381 | 2020-06-23 | Summit | Colorado | 8117 | 264 | 3 |
262253 | 262253 | 2020-06-22 | Summit | Colorado | 8117 | 263 | 3 |
259126 | 259126 | 2020-06-21 | Summit | Colorado | 8117 | 262 | 3 |
255999 | 255999 | 2020-06-20 | Summit | Colorado | 8117 | 262 | 3 |
252880 | 252880 | 2020-06-19 | Summit | Colorado | 8117 | 262 | 3 |
249765 | 249765 | 2020-06-18 | Summit | Colorado | 8117 | 262 | 3 |
246653 | 246653 | 2020-06-17 | Summit | Colorado | 8117 | 262 | 3 |
243540 | 243540 | 2020-06-16 | Summit | Colorado | 8117 | 258 | 3 |
240429 | 240429 | 2020-06-15 | Summit | Colorado | 8117 | 257 | 2 |
237321 | 237321 | 2020-06-14 | Summit | Colorado | 8117 | 256 | 2 |
234214 | 234214 | 2020-06-13 | Summit | Colorado | 8117 | 256 | 2 |
231108 | 231108 | 2020-06-12 | Summit | Colorado | 8117 | 254 | 2 |
228005 | 228005 | 2020-06-11 | Summit | Colorado | 8117 | 253 | 2 |
224903 | 224903 | 2020-06-10 | Summit | Colorado | 8117 | 252 | 2 |
221808 | 221808 | 2020-06-09 | Summit | Colorado | 8117 | 248 | 2 |
218713 | 218713 | 2020-06-08 | Summit | Colorado | 8117 | 247 | 2 |
215622 | 215622 | 2020-06-07 | Summit | Colorado | 8117 | 248 | 2 |
212535 | 212535 | 2020-06-06 | Summit | Colorado | 8117 | 243 | 2 |
209450 | 209450 | 2020-06-05 | Summit | Colorado | 8117 | 239 | 2 |
206369 | 206369 | 2020-06-04 | Summit | Colorado | 8117 | 239 | 2 |
203289 | 203289 | 2020-06-03 | Summit | Colorado | 8117 | 237 | 2 |
200213 | 200213 | 2020-06-02 | Summit | Colorado | 8117 | 233 | 2 |
197140 | 197140 | 2020-06-01 | Summit | Colorado | 8117 | 231 | 2 |
194070 | 194070 | 2020-05-31 | Summit | Colorado | 8117 | 226 | 2 |
191003 | 191003 | 2020-05-30 | Summit | Colorado | 8117 | 224 | 2 |
187938 | 187938 | 2020-05-29 | Summit | Colorado | 8117 | 219 | 2 |
184882 | 184882 | 2020-05-28 | Summit | Colorado | 8117 | 213 | 2 |
181828 | 181828 | 2020-05-27 | Summit | Colorado | 8117 | 214 | 2 |
178784 | 178784 | 2020-05-26 | Summit | Colorado | 8117 | 212 | 2 |
175740 | 175740 | 2020-05-25 | Summit | Colorado | 8117 | 205 | 2 |
172696 | 172696 | 2020-05-24 | Summit | Colorado | 8117 | 207 | 2 |
169655 | 169655 | 2020-05-23 | Summit | Colorado | 8117 | 203 | 2 |
166618 | 166618 | 2020-05-22 | Summit | Colorado | 8117 | 197 | 2 |
163585 | 163585 | 2020-05-21 | Summit | Colorado | 8117 | 195 | 2 |
160557 | 160557 | 2020-05-20 | Summit | Colorado | 8117 | 194 | 2 |
157531 | 157531 | 2020-05-19 | Summit | Colorado | 8117 | 192 | 2 |
154515 | 154515 | 2020-05-18 | Summit | Colorado | 8117 | 186 | 2 |
151503 | 151503 | 2020-05-17 | Summit | Colorado | 8117 | 183 | 2 |
148494 | 148494 | 2020-05-16 | Summit | Colorado | 8117 | 182 | 2 |
145491 | 145491 | 2020-05-15 | Summit | Colorado | 8117 | 178 | 2 |
142491 | 142491 | 2020-05-14 | Summit | Colorado | 8117 | 175 | 2 |
139495 | 139495 | 2020-05-13 | Summit | Colorado | 8117 | 174 | 2 |
136504 | 136504 | 2020-05-12 | Summit | Colorado | 8117 | 171 | 2 |
133515 | 133515 | 2020-05-11 | Summit | Colorado | 8117 | 169 | 2 |
130524 | 130524 | 2020-05-10 | Summit | Colorado | 8117 | 165 | 2 |
127533 | 127533 | 2020-05-09 | Summit | Colorado | 8117 | 162 | 2 |
124547 | 124547 | 2020-05-08 | Summit | Colorado | 8117 | 156 | 2 |
121567 | 121567 | 2020-05-07 | Summit | Colorado | 8117 | 155 | 2 |
118598 | 118598 | 2020-05-06 | Summit | Colorado | 8117 | 155 | 2 |
115638 | 115638 | 2020-05-05 | Summit | Colorado | 8117 | 151 | 2 |
112755 | 112755 | 2020-05-04 | Summit | Colorado | 8117 | 144 | 2 |
109880 | 109880 | 2020-05-03 | Summit | Colorado | 8117 | 144 | 2 |
107011 | 107011 | 2020-05-02 | Summit | Colorado | 8117 | 136 | 2 |
104146 | 104146 | 2020-05-01 | Summit | Colorado | 8117 | 130 | 2 |
101291 | 101291 | 2020-04-30 | Summit | Colorado | 8117 | 128 | 2 |
98441 | 98441 | 2020-04-29 | Summit | Colorado | 8117 | 121 | 2 |
95596 | 95596 | 2020-04-28 | Summit | Colorado | 8117 | 119 | 2 |
92764 | 92764 | 2020-04-27 | Summit | Colorado | 8117 | 106 | 2 |
89946 | 89946 | 2020-04-26 | Summit | Colorado | 8117 | 105 | 2 |
87129 | 87129 | 2020-04-25 | Summit | Colorado | 8117 | 97 | 1 |
84321 | 84321 | 2020-04-24 | Summit | Colorado | 8117 | 97 | 1 |
81521 | 81521 | 2020-04-23 | Summit | Colorado | 8117 | 89 | 1 |
78727 | 78727 | 2020-04-22 | Summit | Colorado | 8117 | 88 | 1 |
75943 | 75943 | 2020-04-21 | Summit | Colorado | 8117 | 88 | 1 |
73167 | 73167 | 2020-04-20 | Summit | Colorado | 8117 | 88 | 1 |
70398 | 70398 | 2020-04-19 | Summit | Colorado | 8117 | 86 | 1 |
67636 | 67636 | 2020-04-18 | Summit | Colorado | 8117 | 86 | 1 |
64888 | 64888 | 2020-04-17 | Summit | Colorado | 8117 | 82 | 1 |
62155 | 62155 | 2020-04-16 | Summit | Colorado | 8117 | 77 | 1 |
59436 | 59436 | 2020-04-15 | Summit | Colorado | 8117 | 76 | 1 |
56728 | 56728 | 2020-04-14 | Summit | Colorado | 8117 | 74 | 1 |
54036 | 54036 | 2020-04-13 | Summit | Colorado | 8117 | 72 | 1 |
51357 | 51357 | 2020-04-12 | Summit | Colorado | 8117 | 68 | 1 |
48695 | 48695 | 2020-04-11 | Summit | Colorado | 8117 | 68 | 0 |
46065 | 46065 | 2020-04-10 | Summit | Colorado | 8117 | 61 | 0 |
43465 | 43465 | 2020-04-09 | Summit | Colorado | 8117 | 57 | 0 |
40891 | 40891 | 2020-04-08 | Summit | Colorado | 8117 | 56 | 0 |
38348 | 38348 | 2020-04-07 | Summit | Colorado | 8117 | 53 | 0 |
35858 | 35858 | 2020-04-06 | Summit | Colorado | 8117 | 47 | 0 |
33413 | 33413 | 2020-04-05 | Summit | Colorado | 8117 | 45 | 0 |
31007 | 31007 | 2020-04-04 | Summit | Colorado | 8117 | 43 | 0 |
28649 | 28649 | 2020-04-03 | Summit | Colorado | 8117 | 35 | 0 |
26347 | 26347 | 2020-04-02 | Summit | Colorado | 8117 | 26 | 0 |
24117 | 24117 | 2020-04-01 | Summit | Colorado | 8117 | 23 | 0 |
21958 | 21958 | 2020-03-31 | Summit | Colorado | 8117 | 20 | 0 |
19881 | 19881 | 2020-03-30 | Summit | Colorado | 8117 | 14 | 0 |
17902 | 17902 | 2020-03-29 | Summit | Colorado | 8117 | 11 | 0 |
16010 | 16010 | 2020-03-28 | Summit | Colorado | 8117 | 11 | 0 |
14226 | 14226 | 2020-03-27 | Summit | Colorado | 8117 | 10 | 0 |
12557 | 12557 | 2020-03-26 | Summit | Colorado | 8117 | 9 | 0 |
11010 | 11010 | 2020-03-25 | Summit | Colorado | 8117 | 9 | 0 |
9636 | 9636 | 2020-03-24 | Summit | Colorado | 8117 | 10 | 0 |
8391 | 8391 | 2020-03-23 | Summit | Colorado | 8117 | 8 | 0 |
7246 | 7246 | 2020-03-22 | Summit | Colorado | 8117 | 7 | 0 |
6211 | 6211 | 2020-03-21 | Summit | Colorado | 8117 | 7 | 0 |
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);