ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where county = "Valencia", deaths = 4 and state = "New Mexico" 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 |
---|---|---|---|---|---|---|---|
665936 | 665936 | 2020-10-25 | Valencia | New Mexico | 35061 | 992 | 4 |
662691 | 662691 | 2020-10-24 | Valencia | New Mexico | 35061 | 938 | 4 |
659447 | 659447 | 2020-10-23 | Valencia | New Mexico | 35061 | 905 | 4 |
656203 | 656203 | 2020-10-22 | Valencia | New Mexico | 35061 | 877 | 4 |
652958 | 652958 | 2020-10-21 | Valencia | New Mexico | 35061 | 844 | 4 |
649713 | 649713 | 2020-10-20 | Valencia | New Mexico | 35061 | 828 | 4 |
646469 | 646469 | 2020-10-19 | Valencia | New Mexico | 35061 | 813 | 4 |
643223 | 643223 | 2020-10-18 | Valencia | New Mexico | 35061 | 794 | 4 |
639975 | 639975 | 2020-10-17 | Valencia | New Mexico | 35061 | 780 | 4 |
636729 | 636729 | 2020-10-16 | Valencia | New Mexico | 35061 | 765 | 4 |
633483 | 633483 | 2020-10-15 | Valencia | New Mexico | 35061 | 742 | 4 |
630238 | 630238 | 2020-10-14 | Valencia | New Mexico | 35061 | 719 | 4 |
626994 | 626994 | 2020-10-13 | Valencia | New Mexico | 35061 | 704 | 4 |
623752 | 623752 | 2020-10-12 | Valencia | New Mexico | 35061 | 694 | 4 |
620509 | 620509 | 2020-10-11 | Valencia | New Mexico | 35061 | 686 | 4 |
617267 | 617267 | 2020-10-10 | Valencia | New Mexico | 35061 | 682 | 4 |
614025 | 614025 | 2020-10-09 | Valencia | New Mexico | 35061 | 671 | 4 |
610784 | 610784 | 2020-10-08 | Valencia | New Mexico | 35061 | 666 | 4 |
607542 | 607542 | 2020-10-07 | Valencia | New Mexico | 35061 | 659 | 4 |
604299 | 604299 | 2020-10-06 | Valencia | New Mexico | 35061 | 655 | 4 |
601057 | 601057 | 2020-10-05 | Valencia | New Mexico | 35061 | 641 | 4 |
597814 | 597814 | 2020-10-04 | Valencia | New Mexico | 35061 | 638 | 4 |
594571 | 594571 | 2020-10-03 | Valencia | New Mexico | 35061 | 637 | 4 |
591330 | 591330 | 2020-10-02 | Valencia | New Mexico | 35061 | 629 | 4 |
588089 | 588089 | 2020-10-01 | Valencia | New Mexico | 35061 | 626 | 4 |
584849 | 584849 | 2020-09-30 | Valencia | New Mexico | 35061 | 619 | 4 |
581608 | 581608 | 2020-09-29 | Valencia | New Mexico | 35061 | 615 | 4 |
578368 | 578368 | 2020-09-28 | Valencia | New Mexico | 35061 | 614 | 4 |
575127 | 575127 | 2020-09-27 | Valencia | New Mexico | 35061 | 611 | 4 |
571883 | 571883 | 2020-09-26 | Valencia | New Mexico | 35061 | 609 | 4 |
568641 | 568641 | 2020-09-25 | Valencia | New Mexico | 35061 | 609 | 4 |
565400 | 565400 | 2020-09-24 | Valencia | New Mexico | 35061 | 605 | 4 |
562159 | 562159 | 2020-09-23 | Valencia | New Mexico | 35061 | 600 | 4 |
558922 | 558922 | 2020-09-22 | Valencia | New Mexico | 35061 | 591 | 4 |
555685 | 555685 | 2020-09-21 | Valencia | New Mexico | 35061 | 588 | 4 |
552448 | 552448 | 2020-09-20 | Valencia | New Mexico | 35061 | 583 | 4 |
549209 | 549209 | 2020-09-19 | Valencia | New Mexico | 35061 | 581 | 4 |
545970 | 545970 | 2020-09-18 | Valencia | New Mexico | 35061 | 574 | 4 |
542733 | 542733 | 2020-09-17 | Valencia | New Mexico | 35061 | 566 | 4 |
539497 | 539497 | 2020-09-16 | Valencia | New Mexico | 35061 | 564 | 4 |
536260 | 536260 | 2020-09-15 | Valencia | New Mexico | 35061 | 564 | 4 |
533024 | 533024 | 2020-09-14 | Valencia | New Mexico | 35061 | 563 | 4 |
529789 | 529789 | 2020-09-13 | Valencia | New Mexico | 35061 | 563 | 4 |
526552 | 526552 | 2020-09-12 | Valencia | New Mexico | 35061 | 561 | 4 |
523316 | 523316 | 2020-09-11 | Valencia | New Mexico | 35061 | 560 | 4 |
520080 | 520080 | 2020-09-10 | Valencia | New Mexico | 35061 | 557 | 4 |
516844 | 516844 | 2020-09-09 | Valencia | New Mexico | 35061 | 557 | 4 |
513609 | 513609 | 2020-09-08 | Valencia | New Mexico | 35061 | 556 | 4 |
510376 | 510376 | 2020-09-07 | Valencia | New Mexico | 35061 | 555 | 4 |
507143 | 507143 | 2020-09-06 | Valencia | New Mexico | 35061 | 556 | 4 |
503911 | 503911 | 2020-09-05 | Valencia | New Mexico | 35061 | 555 | 4 |
500677 | 500677 | 2020-09-04 | Valencia | New Mexico | 35061 | 552 | 4 |
497443 | 497443 | 2020-09-03 | Valencia | New Mexico | 35061 | 549 | 4 |
494210 | 494210 | 2020-09-02 | Valencia | New Mexico | 35061 | 544 | 4 |
490976 | 490976 | 2020-09-01 | Valencia | New Mexico | 35061 | 543 | 4 |
487743 | 487743 | 2020-08-31 | Valencia | New Mexico | 35061 | 541 | 4 |
484510 | 484510 | 2020-08-30 | Valencia | New Mexico | 35061 | 539 | 4 |
481275 | 481275 | 2020-08-29 | Valencia | New Mexico | 35061 | 538 | 4 |
478042 | 478042 | 2020-08-28 | Valencia | New Mexico | 35061 | 534 | 4 |
474809 | 474809 | 2020-08-27 | Valencia | New Mexico | 35061 | 532 | 4 |
471575 | 471575 | 2020-08-26 | Valencia | New Mexico | 35061 | 527 | 4 |
468343 | 468343 | 2020-08-25 | Valencia | New Mexico | 35061 | 522 | 4 |
465115 | 465115 | 2020-08-24 | Valencia | New Mexico | 35061 | 520 | 4 |
461886 | 461886 | 2020-08-23 | Valencia | New Mexico | 35061 | 518 | 4 |
458658 | 458658 | 2020-08-22 | Valencia | New Mexico | 35061 | 511 | 4 |
455430 | 455430 | 2020-08-21 | Valencia | New Mexico | 35061 | 504 | 4 |
452202 | 452202 | 2020-08-20 | Valencia | New Mexico | 35061 | 499 | 4 |
448974 | 448974 | 2020-08-19 | Valencia | New Mexico | 35061 | 493 | 4 |
445746 | 445746 | 2020-08-18 | Valencia | New Mexico | 35061 | 491 | 4 |
442520 | 442520 | 2020-08-17 | Valencia | New Mexico | 35061 | 489 | 4 |
439293 | 439293 | 2020-08-16 | Valencia | New Mexico | 35061 | 485 | 4 |
436068 | 436068 | 2020-08-15 | Valencia | New Mexico | 35061 | 481 | 4 |
432842 | 432842 | 2020-08-14 | Valencia | New Mexico | 35061 | 474 | 4 |
429616 | 429616 | 2020-08-13 | Valencia | New Mexico | 35061 | 471 | 4 |
426391 | 426391 | 2020-08-12 | Valencia | New Mexico | 35061 | 466 | 4 |
423168 | 423168 | 2020-08-11 | Valencia | New Mexico | 35061 | 457 | 4 |
419945 | 419945 | 2020-08-10 | Valencia | New Mexico | 35061 | 453 | 4 |
416725 | 416725 | 2020-08-09 | Valencia | New Mexico | 35061 | 439 | 4 |
413504 | 413504 | 2020-08-08 | Valencia | New Mexico | 35061 | 431 | 4 |
410284 | 410284 | 2020-08-07 | Valencia | New Mexico | 35061 | 429 | 4 |
407064 | 407064 | 2020-08-06 | Valencia | New Mexico | 35061 | 424 | 4 |
403845 | 403845 | 2020-08-05 | Valencia | New Mexico | 35061 | 414 | 4 |
400627 | 400627 | 2020-08-04 | Valencia | New Mexico | 35061 | 406 | 4 |
397412 | 397412 | 2020-08-03 | Valencia | New Mexico | 35061 | 398 | 4 |
394195 | 394195 | 2020-08-02 | Valencia | New Mexico | 35061 | 394 | 4 |
390979 | 390979 | 2020-08-01 | Valencia | New Mexico | 35061 | 382 | 4 |
387762 | 387762 | 2020-07-31 | Valencia | New Mexico | 35061 | 379 | 4 |
384545 | 384545 | 2020-07-30 | Valencia | New Mexico | 35061 | 371 | 4 |
381327 | 381327 | 2020-07-29 | Valencia | New Mexico | 35061 | 367 | 4 |
378110 | 378110 | 2020-07-28 | Valencia | New Mexico | 35061 | 357 | 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);