ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8117 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635188 | 635188 | 2020-10-16 | Summit | Colorado | 8117 | 540 | 4 |
631942 | 631942 | 2020-10-15 | Summit | Colorado | 8117 | 537 | 4 |
628698 | 628698 | 2020-10-14 | Summit | Colorado | 8117 | 529 | 4 |
625455 | 625455 | 2020-10-13 | Summit | Colorado | 8117 | 525 | 4 |
622212 | 622212 | 2020-10-12 | Summit | Colorado | 8117 | 523 | 4 |
618969 | 618969 | 2020-10-11 | Summit | Colorado | 8117 | 517 | 4 |
615727 | 615727 | 2020-10-10 | Summit | Colorado | 8117 | 516 | 4 |
612486 | 612486 | 2020-10-09 | Summit | Colorado | 8117 | 512 | 4 |
609244 | 609244 | 2020-10-08 | Summit | Colorado | 8117 | 505 | 4 |
606001 | 606001 | 2020-10-07 | Summit | Colorado | 8117 | 500 | 4 |
602759 | 602759 | 2020-10-06 | Summit | Colorado | 8117 | 492 | 4 |
599516 | 599516 | 2020-10-05 | Summit | Colorado | 8117 | 489 | 4 |
596273 | 596273 | 2020-10-04 | Summit | Colorado | 8117 | 487 | 4 |
593031 | 593031 | 2020-10-03 | Summit | Colorado | 8117 | 479 | 4 |
589791 | 589791 | 2020-10-02 | Summit | Colorado | 8117 | 473 | 4 |
586550 | 586550 | 2020-10-01 | Summit | Colorado | 8117 | 471 | 4 |
583310 | 583310 | 2020-09-30 | Summit | Colorado | 8117 | 465 | 4 |
580071 | 580071 | 2020-09-29 | Summit | Colorado | 8117 | 463 | 4 |
576830 | 576830 | 2020-09-28 | Summit | Colorado | 8117 | 463 | 4 |
573587 | 573587 | 2020-09-27 | Summit | Colorado | 8117 | 462 | 4 |
570345 | 570345 | 2020-09-26 | Summit | Colorado | 8117 | 458 | 4 |
567103 | 567103 | 2020-09-25 | Summit | Colorado | 8117 | 451 | 4 |
563863 | 563863 | 2020-09-24 | Summit | Colorado | 8117 | 447 | 4 |
560623 | 560623 | 2020-09-23 | Summit | Colorado | 8117 | 428 | 4 |
557387 | 557387 | 2020-09-22 | Summit | Colorado | 8117 | 422 | 4 |
554150 | 554150 | 2020-09-21 | Summit | Colorado | 8117 | 423 | 4 |
550911 | 550911 | 2020-09-20 | Summit | Colorado | 8117 | 423 | 4 |
547672 | 547672 | 2020-09-19 | Summit | Colorado | 8117 | 417 | 4 |
544434 | 544434 | 2020-09-18 | Summit | Colorado | 8117 | 408 | 4 |
541198 | 541198 | 2020-09-17 | Summit | Colorado | 8117 | 403 | 4 |
537961 | 537961 | 2020-09-16 | Summit | Colorado | 8117 | 391 | 4 |
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 |
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);