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 |
---|---|---|---|---|---|---|---|
534725 | 534725 | 2020-09-15 | Summit | Colorado | 8117 | 377 | 4 |
531490 | 531490 | 2020-09-14 | Summit | Colorado | 8117 | 376 | 4 |
528253 | 528253 | 2020-09-13 | Summit | Colorado | 8117 | 372 | 4 |
525017 | 525017 | 2020-09-12 | Summit | Colorado | 8117 | 370 | 4 |
521781 | 521781 | 2020-09-11 | Summit | Colorado | 8117 | 370 | 4 |
518544 | 518544 | 2020-09-10 | Summit | Colorado | 8117 | 368 | 4 |
515309 | 515309 | 2020-09-09 | Summit | Colorado | 8117 | 368 | 4 |
512076 | 512076 | 2020-09-08 | Summit | Colorado | 8117 | 368 | 4 |
508843 | 508843 | 2020-09-07 | Summit | Colorado | 8117 | 366 | 4 |
505611 | 505611 | 2020-09-06 | Summit | Colorado | 8117 | 366 | 4 |
502377 | 502377 | 2020-09-05 | Summit | Colorado | 8117 | 366 | 4 |
499143 | 499143 | 2020-09-04 | Summit | Colorado | 8117 | 366 | 4 |
495910 | 495910 | 2020-09-03 | Summit | Colorado | 8117 | 365 | 4 |
492676 | 492676 | 2020-09-02 | Summit | Colorado | 8117 | 365 | 4 |
489443 | 489443 | 2020-09-01 | Summit | Colorado | 8117 | 364 | 4 |
486210 | 486210 | 2020-08-31 | Summit | Colorado | 8117 | 363 | 4 |
482975 | 482975 | 2020-08-30 | Summit | Colorado | 8117 | 363 | 4 |
479741 | 479741 | 2020-08-29 | Summit | Colorado | 8117 | 363 | 4 |
476508 | 476508 | 2020-08-28 | Summit | Colorado | 8117 | 363 | 4 |
473275 | 473275 | 2020-08-27 | Summit | Colorado | 8117 | 361 | 4 |
470043 | 470043 | 2020-08-26 | Summit | Colorado | 8117 | 361 | 4 |
466814 | 466814 | 2020-08-25 | Summit | Colorado | 8117 | 358 | 4 |
463585 | 463585 | 2020-08-24 | Summit | Colorado | 8117 | 352 | 4 |
460356 | 460356 | 2020-08-23 | Summit | Colorado | 8117 | 349 | 4 |
457129 | 457129 | 2020-08-22 | Summit | Colorado | 8117 | 349 | 4 |
453901 | 453901 | 2020-08-21 | Summit | Colorado | 8117 | 349 | 4 |
450673 | 450673 | 2020-08-20 | Summit | Colorado | 8117 | 346 | 4 |
447445 | 447445 | 2020-08-19 | Summit | Colorado | 8117 | 346 | 4 |
444218 | 444218 | 2020-08-18 | Summit | Colorado | 8117 | 346 | 4 |
440992 | 440992 | 2020-08-17 | Summit | Colorado | 8117 | 345 | 4 |
437766 | 437766 | 2020-08-16 | Summit | Colorado | 8117 | 344 | 4 |
434540 | 434540 | 2020-08-15 | Summit | Colorado | 8117 | 344 | 4 |
431315 | 431315 | 2020-08-14 | Summit | Colorado | 8117 | 344 | 4 |
428087 | 428087 | 2020-08-13 | Summit | Colorado | 8117 | 344 | 4 |
424863 | 424863 | 2020-08-12 | Summit | Colorado | 8117 | 344 | 4 |
421642 | 421642 | 2020-08-11 | Summit | Colorado | 8117 | 338 | 4 |
418421 | 418421 | 2020-08-10 | Summit | Colorado | 8117 | 333 | 4 |
415200 | 415200 | 2020-08-09 | Summit | Colorado | 8117 | 328 | 4 |
411980 | 411980 | 2020-08-08 | Summit | Colorado | 8117 | 327 | 4 |
408761 | 408761 | 2020-08-07 | Summit | Colorado | 8117 | 327 | 4 |
405541 | 405541 | 2020-08-06 | Summit | Colorado | 8117 | 327 | 4 |
402323 | 402323 | 2020-08-05 | Summit | Colorado | 8117 | 327 | 4 |
399107 | 399107 | 2020-08-04 | Summit | Colorado | 8117 | 324 | 4 |
395891 | 395891 | 2020-08-03 | Summit | Colorado | 8117 | 323 | 4 |
392675 | 392675 | 2020-08-02 | Summit | Colorado | 8117 | 323 | 4 |
389458 | 389458 | 2020-08-01 | Summit | Colorado | 8117 | 322 | 4 |
386241 | 386241 | 2020-07-31 | Summit | Colorado | 8117 | 339 | 4 |
383023 | 383023 | 2020-07-30 | Summit | Colorado | 8117 | 339 | 4 |
379806 | 379806 | 2020-07-29 | Summit | Colorado | 8117 | 320 | 4 |
376589 | 376589 | 2020-07-28 | Summit | Colorado | 8117 | 318 | 4 |
373375 | 373375 | 2020-07-27 | Summit | Colorado | 8117 | 318 | 4 |
370163 | 370163 | 2020-07-26 | Summit | Colorado | 8117 | 316 | 4 |
366953 | 366953 | 2020-07-25 | Summit | Colorado | 8117 | 315 | 4 |
363746 | 363746 | 2020-07-24 | Summit | Colorado | 8117 | 313 | 4 |
360539 | 360539 | 2020-07-23 | Summit | Colorado | 8117 | 312 | 4 |
357334 | 357334 | 2020-07-22 | Summit | Colorado | 8117 | 311 | 4 |
354131 | 354131 | 2020-07-21 | Summit | Colorado | 8117 | 308 | 4 |
350929 | 350929 | 2020-07-20 | Summit | Colorado | 8117 | 306 | 4 |
347728 | 347728 | 2020-07-19 | Summit | Colorado | 8117 | 306 | 4 |
344528 | 344528 | 2020-07-18 | Summit | Colorado | 8117 | 304 | 4 |
341329 | 341329 | 2020-07-17 | Summit | Colorado | 8117 | 304 | 4 |
338132 | 338132 | 2020-07-16 | Summit | Colorado | 8117 | 298 | 4 |
334937 | 334937 | 2020-07-15 | Summit | Colorado | 8117 | 294 | 4 |
331744 | 331744 | 2020-07-14 | Summit | Colorado | 8117 | 293 | 4 |
328557 | 328557 | 2020-07-13 | Summit | Colorado | 8117 | 293 | 4 |
325371 | 325371 | 2020-07-12 | Summit | Colorado | 8117 | 293 | 4 |
322190 | 322190 | 2020-07-11 | Summit | Colorado | 8117 | 293 | 4 |
319011 | 319011 | 2020-07-10 | Summit | Colorado | 8117 | 294 | 4 |
315838 | 315838 | 2020-07-09 | Summit | Colorado | 8117 | 289 | 4 |
312663 | 312663 | 2020-07-08 | Summit | Colorado | 8117 | 288 | 4 |
309493 | 309493 | 2020-07-07 | Summit | Colorado | 8117 | 286 | 4 |
306325 | 306325 | 2020-07-06 | Summit | Colorado | 8117 | 281 | 4 |
303161 | 303161 | 2020-07-05 | Summit | Colorado | 8117 | 281 | 4 |
299997 | 299997 | 2020-07-04 | Summit | Colorado | 8117 | 278 | 4 |
296835 | 296835 | 2020-07-03 | Summit | Colorado | 8117 | 277 | 4 |
293679 | 293679 | 2020-07-02 | Summit | Colorado | 8117 | 276 | 4 |
290525 | 290525 | 2020-07-01 | Summit | Colorado | 8117 | 274 | 3 |
287374 | 287374 | 2020-06-30 | Summit | Colorado | 8117 | 269 | 3 |
284228 | 284228 | 2020-06-29 | Summit | Colorado | 8117 | 269 | 3 |
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 |
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);