ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
110 rows where cases = 32 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2130489 | 2130489 | 2022-01-19 | Unknown | New Mexico | 32 | 0 | |
759990 | 759990 | 2020-11-23 | De Baca | New Mexico | 35011 | 32 | 0 |
756744 | 756744 | 2020-11-22 | De Baca | New Mexico | 35011 | 32 | 0 |
753492 | 753492 | 2020-11-21 | Catron | New Mexico | 35003 | 32 | 1 |
753497 | 753497 | 2020-11-21 | De Baca | New Mexico | 35011 | 32 | 0 |
753509 | 753509 | 2020-11-21 | Mora | New Mexico | 35033 | 32 | 0 |
597812 | 597812 | 2020-10-04 | Union | New Mexico | 35059 | 32 | 2 |
594570 | 594570 | 2020-10-03 | Union | New Mexico | 35059 | 32 | 2 |
591329 | 591329 | 2020-10-02 | Union | New Mexico | 35059 | 32 | 2 |
588088 | 588088 | 2020-10-01 | Union | New Mexico | 35059 | 32 | 2 |
584848 | 584848 | 2020-09-30 | Union | New Mexico | 35059 | 32 | 2 |
581607 | 581607 | 2020-09-29 | Union | New Mexico | 35059 | 32 | 2 |
578366 | 578366 | 2020-09-28 | Union | New Mexico | 35059 | 32 | 2 |
575125 | 575125 | 2020-09-27 | Union | New Mexico | 35059 | 32 | 2 |
571882 | 571882 | 2020-09-26 | Union | New Mexico | 35059 | 32 | 2 |
568640 | 568640 | 2020-09-25 | Union | New Mexico | 35059 | 32 | 2 |
565383 | 565383 | 2020-09-24 | Los Alamos | New Mexico | 35028 | 32 | 0 |
565399 | 565399 | 2020-09-24 | Union | New Mexico | 35059 | 32 | 2 |
562142 | 562142 | 2020-09-23 | Los Alamos | New Mexico | 35028 | 32 | 0 |
562158 | 562158 | 2020-09-23 | Union | New Mexico | 35059 | 32 | 2 |
558921 | 558921 | 2020-09-22 | Union | New Mexico | 35059 | 32 | 2 |
555684 | 555684 | 2020-09-21 | Union | New Mexico | 35059 | 32 | 2 |
552446 | 552446 | 2020-09-20 | Union | New Mexico | 35059 | 32 | 2 |
549207 | 549207 | 2020-09-19 | Union | New Mexico | 35059 | 32 | 2 |
545969 | 545969 | 2020-09-18 | Union | New Mexico | 35059 | 32 | 2 |
542732 | 542732 | 2020-09-17 | Union | New Mexico | 35059 | 32 | 2 |
539495 | 539495 | 2020-09-16 | Union | New Mexico | 35059 | 32 | 2 |
536237 | 536237 | 2020-09-15 | Guadalupe | New Mexico | 35019 | 32 | 1 |
536258 | 536258 | 2020-09-15 | Union | New Mexico | 35059 | 32 | 2 |
533002 | 533002 | 2020-09-14 | Guadalupe | New Mexico | 35019 | 32 | 1 |
533023 | 533023 | 2020-09-14 | Union | New Mexico | 35059 | 32 | 2 |
529766 | 529766 | 2020-09-13 | Guadalupe | New Mexico | 35019 | 32 | 1 |
529787 | 529787 | 2020-09-13 | Union | New Mexico | 35059 | 32 | 2 |
526530 | 526530 | 2020-09-12 | Guadalupe | New Mexico | 35019 | 32 | 1 |
526551 | 526551 | 2020-09-12 | Union | New Mexico | 35059 | 32 | 2 |
523294 | 523294 | 2020-09-11 | Guadalupe | New Mexico | 35019 | 32 | 1 |
523315 | 523315 | 2020-09-11 | Union | New Mexico | 35059 | 32 | 2 |
520057 | 520057 | 2020-09-10 | Guadalupe | New Mexico | 35019 | 32 | 1 |
520078 | 520078 | 2020-09-10 | Union | New Mexico | 35059 | 32 | 2 |
516821 | 516821 | 2020-09-09 | Guadalupe | New Mexico | 35019 | 32 | 1 |
516842 | 516842 | 2020-09-09 | Union | New Mexico | 35059 | 32 | 2 |
513587 | 513587 | 2020-09-08 | Guadalupe | New Mexico | 35019 | 32 | 1 |
513608 | 513608 | 2020-09-08 | Union | New Mexico | 35059 | 32 | 2 |
510354 | 510354 | 2020-09-07 | Guadalupe | New Mexico | 35019 | 32 | 1 |
510375 | 510375 | 2020-09-07 | Union | New Mexico | 35059 | 32 | 2 |
507121 | 507121 | 2020-09-06 | Guadalupe | New Mexico | 35019 | 32 | 1 |
507142 | 507142 | 2020-09-06 | Union | New Mexico | 35059 | 32 | 2 |
503889 | 503889 | 2020-09-05 | Guadalupe | New Mexico | 35019 | 32 | 1 |
503910 | 503910 | 2020-09-05 | Union | New Mexico | 35059 | 32 | 2 |
500655 | 500655 | 2020-09-04 | Guadalupe | New Mexico | 35019 | 32 | 1 |
500676 | 500676 | 2020-09-04 | Union | New Mexico | 35059 | 32 | 2 |
497421 | 497421 | 2020-09-03 | Guadalupe | New Mexico | 35019 | 32 | 1 |
497442 | 497442 | 2020-09-03 | Union | New Mexico | 35059 | 32 | 2 |
494188 | 494188 | 2020-09-02 | Guadalupe | New Mexico | 35019 | 32 | 1 |
494209 | 494209 | 2020-09-02 | Union | New Mexico | 35059 | 32 | 2 |
490954 | 490954 | 2020-09-01 | Guadalupe | New Mexico | 35019 | 32 | 1 |
490975 | 490975 | 2020-09-01 | Union | New Mexico | 35059 | 32 | 2 |
487721 | 487721 | 2020-08-31 | Guadalupe | New Mexico | 35019 | 32 | 1 |
487742 | 487742 | 2020-08-31 | Union | New Mexico | 35059 | 32 | 2 |
484487 | 484487 | 2020-08-30 | Guadalupe | New Mexico | 35019 | 32 | 1 |
484508 | 484508 | 2020-08-30 | Union | New Mexico | 35059 | 32 | 2 |
481252 | 481252 | 2020-08-29 | Guadalupe | New Mexico | 35019 | 32 | 1 |
481273 | 481273 | 2020-08-29 | Union | New Mexico | 35059 | 32 | 2 |
478020 | 478020 | 2020-08-28 | Guadalupe | New Mexico | 35019 | 32 | 1 |
478041 | 478041 | 2020-08-28 | Union | New Mexico | 35059 | 32 | 2 |
474787 | 474787 | 2020-08-27 | Guadalupe | New Mexico | 35019 | 32 | 1 |
474808 | 474808 | 2020-08-27 | Union | New Mexico | 35059 | 32 | 2 |
471553 | 471553 | 2020-08-26 | Guadalupe | New Mexico | 35019 | 32 | 1 |
471574 | 471574 | 2020-08-26 | Union | New Mexico | 35059 | 32 | 2 |
468342 | 468342 | 2020-08-25 | Union | New Mexico | 35059 | 32 | 2 |
465114 | 465114 | 2020-08-24 | Union | New Mexico | 35059 | 32 | 2 |
461884 | 461884 | 2020-08-23 | Union | New Mexico | 35059 | 32 | 2 |
455408 | 455408 | 2020-08-21 | Guadalupe | New Mexico | 35019 | 32 | 0 |
455429 | 455429 | 2020-08-21 | Union | New Mexico | 35059 | 32 | 2 |
452180 | 452180 | 2020-08-20 | Guadalupe | New Mexico | 35019 | 32 | 0 |
452201 | 452201 | 2020-08-20 | Union | New Mexico | 35059 | 32 | 2 |
448951 | 448951 | 2020-08-19 | Guadalupe | New Mexico | 35019 | 32 | 0 |
448972 | 448972 | 2020-08-19 | Union | New Mexico | 35059 | 32 | 2 |
445724 | 445724 | 2020-08-18 | Guadalupe | New Mexico | 35019 | 32 | 0 |
442498 | 442498 | 2020-08-17 | Guadalupe | New Mexico | 35019 | 32 | 0 |
439271 | 439271 | 2020-08-16 | Guadalupe | New Mexico | 35019 | 32 | 0 |
436046 | 436046 | 2020-08-15 | Guadalupe | New Mexico | 35019 | 32 | 0 |
432820 | 432820 | 2020-08-14 | Guadalupe | New Mexico | 35019 | 32 | 0 |
432837 | 432837 | 2020-08-14 | Sierra | New Mexico | 35051 | 32 | 1 |
429593 | 429593 | 2020-08-13 | Guadalupe | New Mexico | 35019 | 32 | 0 |
429610 | 429610 | 2020-08-13 | Sierra | New Mexico | 35051 | 32 | 1 |
426369 | 426369 | 2020-08-12 | Guadalupe | New Mexico | 35019 | 32 | 0 |
426386 | 426386 | 2020-08-12 | Sierra | New Mexico | 35051 | 32 | 1 |
423146 | 423146 | 2020-08-11 | Guadalupe | New Mexico | 35019 | 32 | 0 |
423163 | 423163 | 2020-08-11 | Sierra | New Mexico | 35051 | 32 | 1 |
419940 | 419940 | 2020-08-10 | Sierra | New Mexico | 35051 | 32 | 1 |
416720 | 416720 | 2020-08-09 | Sierra | New Mexico | 35051 | 32 | 0 |
413499 | 413499 | 2020-08-08 | Sierra | New Mexico | 35051 | 32 | 0 |
394183 | 394183 | 2020-08-02 | Quay | New Mexico | 35037 | 32 | 1 |
349231 | 349231 | 2020-07-19 | San Miguel | New Mexico | 35047 | 32 | 0 |
342821 | 342821 | 2020-07-17 | Lincoln | New Mexico | 35027 | 32 | 0 |
339623 | 339623 | 2020-07-16 | Lincoln | New Mexico | 35027 | 32 | 0 |
323667 | 323667 | 2020-07-11 | Grant | New Mexico | 35017 | 32 | 0 |
238778 | 238778 | 2020-06-14 | Taos | New Mexico | 35055 | 32 | 0 |
235671 | 235671 | 2020-06-13 | Taos | New Mexico | 35055 | 32 | 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);