ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 8031 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635145 | 635145 | 2020-10-16 | Denver | Colorado | 8031 | 15645 | 449 |
631899 | 631899 | 2020-10-15 | Denver | Colorado | 8031 | 15466 | 449 |
628655 | 628655 | 2020-10-14 | Denver | Colorado | 8031 | 15251 | 449 |
625412 | 625412 | 2020-10-13 | Denver | Colorado | 8031 | 15103 | 449 |
622169 | 622169 | 2020-10-12 | Denver | Colorado | 8031 | 14970 | 449 |
618926 | 618926 | 2020-10-11 | Denver | Colorado | 8031 | 14821 | 447 |
615684 | 615684 | 2020-10-10 | Denver | Colorado | 8031 | 14666 | 447 |
612443 | 612443 | 2020-10-09 | Denver | Colorado | 8031 | 14469 | 447 |
609201 | 609201 | 2020-10-08 | Denver | Colorado | 8031 | 14383 | 447 |
605958 | 605958 | 2020-10-07 | Denver | Colorado | 8031 | 14212 | 447 |
602716 | 602716 | 2020-10-06 | Denver | Colorado | 8031 | 14036 | 447 |
599473 | 599473 | 2020-10-05 | Denver | Colorado | 8031 | 13956 | 447 |
596230 | 596230 | 2020-10-04 | Denver | Colorado | 8031 | 13834 | 441 |
592988 | 592988 | 2020-10-03 | Denver | Colorado | 8031 | 13755 | 441 |
589748 | 589748 | 2020-10-02 | Denver | Colorado | 8031 | 13636 | 441 |
586507 | 586507 | 2020-10-01 | Denver | Colorado | 8031 | 13519 | 441 |
583267 | 583267 | 2020-09-30 | Denver | Colorado | 8031 | 13404 | 441 |
580028 | 580028 | 2020-09-29 | Denver | Colorado | 8031 | 13298 | 441 |
576787 | 576787 | 2020-09-28 | Denver | Colorado | 8031 | 13241 | 440 |
573544 | 573544 | 2020-09-27 | Denver | Colorado | 8031 | 13116 | 440 |
570302 | 570302 | 2020-09-26 | Denver | Colorado | 8031 | 13011 | 440 |
567060 | 567060 | 2020-09-25 | Denver | Colorado | 8031 | 12945 | 440 |
563820 | 563820 | 2020-09-24 | Denver | Colorado | 8031 | 12825 | 440 |
560581 | 560581 | 2020-09-23 | Denver | Colorado | 8031 | 12718 | 440 |
557345 | 557345 | 2020-09-22 | Denver | Colorado | 8031 | 12591 | 440 |
554108 | 554108 | 2020-09-21 | Denver | Colorado | 8031 | 12514 | 440 |
550869 | 550869 | 2020-09-20 | Denver | Colorado | 8031 | 12422 | 438 |
547630 | 547630 | 2020-09-19 | Denver | Colorado | 8031 | 12313 | 438 |
544392 | 544392 | 2020-09-18 | Denver | Colorado | 8031 | 12239 | 438 |
541156 | 541156 | 2020-09-17 | Denver | Colorado | 8031 | 12148 | 438 |
537919 | 537919 | 2020-09-16 | Denver | Colorado | 8031 | 12055 | 437 |
534683 | 534683 | 2020-09-15 | Denver | Colorado | 8031 | 11976 | 437 |
531448 | 531448 | 2020-09-14 | Denver | Colorado | 8031 | 11883 | 437 |
528211 | 528211 | 2020-09-13 | Denver | Colorado | 8031 | 11816 | 434 |
524975 | 524975 | 2020-09-12 | Denver | Colorado | 8031 | 11760 | 434 |
521739 | 521739 | 2020-09-11 | Denver | Colorado | 8031 | 11685 | 434 |
518502 | 518502 | 2020-09-10 | Denver | Colorado | 8031 | 11627 | 434 |
515267 | 515267 | 2020-09-09 | Denver | Colorado | 8031 | 11592 | 434 |
512034 | 512034 | 2020-09-08 | Denver | Colorado | 8031 | 11579 | 434 |
508801 | 508801 | 2020-09-07 | Denver | Colorado | 8031 | 11557 | 434 |
505569 | 505569 | 2020-09-06 | Denver | Colorado | 8031 | 11500 | 434 |
502335 | 502335 | 2020-09-05 | Denver | Colorado | 8031 | 11479 | 434 |
499101 | 499101 | 2020-09-04 | Denver | Colorado | 8031 | 11417 | 434 |
495868 | 495868 | 2020-09-03 | Denver | Colorado | 8031 | 11366 | 434 |
492634 | 492634 | 2020-09-02 | Denver | Colorado | 8031 | 11339 | 434 |
489401 | 489401 | 2020-09-01 | Denver | Colorado | 8031 | 11307 | 434 |
486168 | 486168 | 2020-08-31 | Denver | Colorado | 8031 | 11265 | 434 |
482933 | 482933 | 2020-08-30 | Denver | Colorado | 8031 | 11225 | 429 |
479699 | 479699 | 2020-08-29 | Denver | Colorado | 8031 | 11196 | 429 |
476466 | 476466 | 2020-08-28 | Denver | Colorado | 8031 | 11147 | 429 |
473233 | 473233 | 2020-08-27 | Denver | Colorado | 8031 | 11077 | 428 |
470001 | 470001 | 2020-08-26 | Denver | Colorado | 8031 | 11021 | 426 |
466772 | 466772 | 2020-08-25 | Denver | Colorado | 8031 | 11038 | 426 |
463543 | 463543 | 2020-08-24 | Denver | Colorado | 8031 | 10931 | 426 |
460314 | 460314 | 2020-08-23 | Denver | Colorado | 8031 | 10901 | 426 |
457087 | 457087 | 2020-08-22 | Denver | Colorado | 8031 | 10842 | 426 |
453859 | 453859 | 2020-08-21 | Denver | Colorado | 8031 | 10789 | 426 |
450631 | 450631 | 2020-08-20 | Denver | Colorado | 8031 | 10732 | 426 |
447403 | 447403 | 2020-08-19 | Denver | Colorado | 8031 | 10691 | 426 |
444176 | 444176 | 2020-08-18 | Denver | Colorado | 8031 | 10651 | 426 |
440950 | 440950 | 2020-08-17 | Denver | Colorado | 8031 | 10607 | 426 |
437724 | 437724 | 2020-08-16 | Denver | Colorado | 8031 | 10572 | 420 |
434498 | 434498 | 2020-08-15 | Denver | Colorado | 8031 | 10508 | 420 |
431273 | 431273 | 2020-08-14 | Denver | Colorado | 8031 | 10471 | 420 |
428045 | 428045 | 2020-08-13 | Denver | Colorado | 8031 | 10426 | 420 |
424821 | 424821 | 2020-08-12 | Denver | Colorado | 8031 | 10370 | 420 |
421600 | 421600 | 2020-08-11 | Denver | Colorado | 8031 | 10319 | 419 |
418379 | 418379 | 2020-08-10 | Denver | Colorado | 8031 | 10263 | 419 |
415158 | 415158 | 2020-08-09 | Denver | Colorado | 8031 | 10224 | 418 |
411938 | 411938 | 2020-08-08 | Denver | Colorado | 8031 | 10173 | 418 |
408719 | 408719 | 2020-08-07 | Denver | Colorado | 8031 | 10122 | 418 |
405499 | 405499 | 2020-08-06 | Denver | Colorado | 8031 | 10052 | 417 |
402281 | 402281 | 2020-08-05 | Denver | Colorado | 8031 | 9968 | 417 |
399065 | 399065 | 2020-08-04 | Denver | Colorado | 8031 | 9876 | 417 |
395849 | 395849 | 2020-08-03 | Denver | Colorado | 8031 | 9813 | 416 |
392633 | 392633 | 2020-08-02 | Denver | Colorado | 8031 | 9778 | 413 |
389416 | 389416 | 2020-08-01 | Denver | Colorado | 8031 | 9693 | 413 |
386199 | 386199 | 2020-07-31 | Denver | Colorado | 8031 | 9623 | 412 |
382981 | 382981 | 2020-07-30 | Denver | Colorado | 8031 | 9529 | 411 |
379764 | 379764 | 2020-07-29 | Denver | Colorado | 8031 | 9482 | 411 |
376547 | 376547 | 2020-07-28 | Denver | Colorado | 8031 | 9387 | 407 |
373333 | 373333 | 2020-07-27 | Denver | Colorado | 8031 | 9256 | 405 |
370121 | 370121 | 2020-07-26 | Denver | Colorado | 8031 | 9205 | 405 |
366911 | 366911 | 2020-07-25 | Denver | Colorado | 8031 | 9101 | 405 |
363704 | 363704 | 2020-07-24 | Denver | Colorado | 8031 | 8939 | 403 |
360497 | 360497 | 2020-07-23 | Denver | Colorado | 8031 | 8809 | 403 |
357292 | 357292 | 2020-07-22 | Denver | Colorado | 8031 | 8650 | 402 |
354089 | 354089 | 2020-07-21 | Denver | Colorado | 8031 | 8532 | 399 |
350887 | 350887 | 2020-07-20 | Denver | Colorado | 8031 | 8429 | 398 |
347686 | 347686 | 2020-07-19 | Denver | Colorado | 8031 | 8371 | 398 |
344486 | 344486 | 2020-07-18 | Denver | Colorado | 8031 | 8320 | 398 |
341287 | 341287 | 2020-07-17 | Denver | Colorado | 8031 | 8254 | 398 |
338091 | 338091 | 2020-07-16 | Denver | Colorado | 8031 | 8164 | 398 |
334896 | 334896 | 2020-07-15 | Denver | Colorado | 8031 | 8098 | 397 |
331703 | 331703 | 2020-07-14 | Denver | Colorado | 8031 | 8011 | 395 |
328517 | 328517 | 2020-07-13 | Denver | Colorado | 8031 | 7952 | 394 |
325331 | 325331 | 2020-07-12 | Denver | Colorado | 8031 | 7902 | 394 |
322150 | 322150 | 2020-07-11 | Denver | Colorado | 8031 | 7832 | 394 |
318971 | 318971 | 2020-07-10 | Denver | Colorado | 8031 | 7759 | 394 |
315798 | 315798 | 2020-07-09 | Denver | Colorado | 8031 | 7651 | 386 |
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);