ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
749 rows where county = "Union" and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636728 | 636728 | 2020-10-16 | Union | New Mexico | 35059 | 43 | 2 |
633482 | 633482 | 2020-10-15 | Union | New Mexico | 35059 | 42 | 2 |
630237 | 630237 | 2020-10-14 | Union | New Mexico | 35059 | 42 | 2 |
626993 | 626993 | 2020-10-13 | Union | New Mexico | 35059 | 42 | 2 |
623751 | 623751 | 2020-10-12 | Union | New Mexico | 35059 | 42 | 2 |
620508 | 620508 | 2020-10-11 | Union | New Mexico | 35059 | 42 | 2 |
617266 | 617266 | 2020-10-10 | Union | New Mexico | 35059 | 42 | 2 |
614024 | 614024 | 2020-10-09 | Union | New Mexico | 35059 | 42 | 2 |
610783 | 610783 | 2020-10-08 | Union | New Mexico | 35059 | 39 | 2 |
607541 | 607541 | 2020-10-07 | Union | New Mexico | 35059 | 34 | 2 |
604298 | 604298 | 2020-10-06 | Union | New Mexico | 35059 | 33 | 2 |
601056 | 601056 | 2020-10-05 | Union | New Mexico | 35059 | 33 | 2 |
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 |
565399 | 565399 | 2020-09-24 | Union | New Mexico | 35059 | 32 | 2 |
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 |
536258 | 536258 | 2020-09-15 | Union | New Mexico | 35059 | 32 | 2 |
533023 | 533023 | 2020-09-14 | Union | New Mexico | 35059 | 32 | 2 |
529787 | 529787 | 2020-09-13 | Union | New Mexico | 35059 | 32 | 2 |
526551 | 526551 | 2020-09-12 | Union | New Mexico | 35059 | 32 | 2 |
523315 | 523315 | 2020-09-11 | Union | New Mexico | 35059 | 32 | 2 |
520078 | 520078 | 2020-09-10 | Union | New Mexico | 35059 | 32 | 2 |
516842 | 516842 | 2020-09-09 | Union | New Mexico | 35059 | 32 | 2 |
513608 | 513608 | 2020-09-08 | Union | New Mexico | 35059 | 32 | 2 |
510375 | 510375 | 2020-09-07 | Union | New Mexico | 35059 | 32 | 2 |
507142 | 507142 | 2020-09-06 | Union | New Mexico | 35059 | 32 | 2 |
503910 | 503910 | 2020-09-05 | Union | New Mexico | 35059 | 32 | 2 |
500676 | 500676 | 2020-09-04 | Union | New Mexico | 35059 | 32 | 2 |
497442 | 497442 | 2020-09-03 | Union | New Mexico | 35059 | 32 | 2 |
494209 | 494209 | 2020-09-02 | Union | New Mexico | 35059 | 32 | 2 |
490975 | 490975 | 2020-09-01 | Union | New Mexico | 35059 | 32 | 2 |
487742 | 487742 | 2020-08-31 | Union | New Mexico | 35059 | 32 | 2 |
484508 | 484508 | 2020-08-30 | Union | New Mexico | 35059 | 32 | 2 |
481273 | 481273 | 2020-08-29 | Union | New Mexico | 35059 | 32 | 2 |
478041 | 478041 | 2020-08-28 | Union | New Mexico | 35059 | 32 | 2 |
474808 | 474808 | 2020-08-27 | Union | New Mexico | 35059 | 32 | 2 |
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 |
458656 | 458656 | 2020-08-22 | Union | New Mexico | 35059 | 30 | 2 |
455429 | 455429 | 2020-08-21 | Union | New Mexico | 35059 | 32 | 2 |
452201 | 452201 | 2020-08-20 | Union | New Mexico | 35059 | 32 | 2 |
448972 | 448972 | 2020-08-19 | Union | New Mexico | 35059 | 32 | 2 |
445745 | 445745 | 2020-08-18 | Union | New Mexico | 35059 | 31 | 2 |
442519 | 442519 | 2020-08-17 | Union | New Mexico | 35059 | 31 | 2 |
439292 | 439292 | 2020-08-16 | Union | New Mexico | 35059 | 31 | 2 |
436067 | 436067 | 2020-08-15 | Union | New Mexico | 35059 | 31 | 2 |
432841 | 432841 | 2020-08-14 | Union | New Mexico | 35059 | 31 | 2 |
429614 | 429614 | 2020-08-13 | Union | New Mexico | 35059 | 31 | 2 |
426390 | 426390 | 2020-08-12 | Union | New Mexico | 35059 | 31 | 2 |
423167 | 423167 | 2020-08-11 | Union | New Mexico | 35059 | 31 | 2 |
419944 | 419944 | 2020-08-10 | Union | New Mexico | 35059 | 31 | 2 |
416724 | 416724 | 2020-08-09 | Union | New Mexico | 35059 | 31 | 2 |
413503 | 413503 | 2020-08-08 | Union | New Mexico | 35059 | 30 | 2 |
410283 | 410283 | 2020-08-07 | Union | New Mexico | 35059 | 30 | 2 |
407063 | 407063 | 2020-08-06 | Union | New Mexico | 35059 | 29 | 2 |
403844 | 403844 | 2020-08-05 | Union | New Mexico | 35059 | 29 | 2 |
400626 | 400626 | 2020-08-04 | Union | New Mexico | 35059 | 29 | 0 |
397411 | 397411 | 2020-08-03 | Union | New Mexico | 35059 | 28 | 0 |
394194 | 394194 | 2020-08-02 | Union | New Mexico | 35059 | 28 | 0 |
390977 | 390977 | 2020-08-01 | Union | New Mexico | 35059 | 28 | 0 |
387761 | 387761 | 2020-07-31 | Union | New Mexico | 35059 | 26 | 0 |
384544 | 384544 | 2020-07-30 | Union | New Mexico | 35059 | 26 | 0 |
381326 | 381326 | 2020-07-29 | Union | New Mexico | 35059 | 25 | 0 |
378108 | 378108 | 2020-07-28 | Union | New Mexico | 35059 | 25 | 0 |
374893 | 374893 | 2020-07-27 | Union | New Mexico | 35059 | 24 | 0 |
371681 | 371681 | 2020-07-26 | Union | New Mexico | 35059 | 24 | 0 |
368469 | 368469 | 2020-07-25 | Union | New Mexico | 35059 | 22 | 0 |
365260 | 365260 | 2020-07-24 | Union | New Mexico | 35059 | 22 | 0 |
362054 | 362054 | 2020-07-23 | Union | New Mexico | 35059 | 17 | 0 |
358848 | 358848 | 2020-07-22 | Union | New Mexico | 35059 | 14 | 0 |
355644 | 355644 | 2020-07-21 | Union | New Mexico | 35059 | 14 | 0 |
352441 | 352441 | 2020-07-20 | Union | New Mexico | 35059 | 14 | 0 |
349238 | 349238 | 2020-07-19 | Union | New Mexico | 35059 | 14 | 0 |
346037 | 346037 | 2020-07-18 | Union | New Mexico | 35059 | 14 | 0 |
342838 | 342838 | 2020-07-17 | Union | New Mexico | 35059 | 14 | 0 |
339640 | 339640 | 2020-07-16 | Union | New Mexico | 35059 | 14 | 0 |
336444 | 336444 | 2020-07-15 | Union | New Mexico | 35059 | 14 | 0 |
333250 | 333250 | 2020-07-14 | Union | New Mexico | 35059 | 14 | 0 |
330060 | 330060 | 2020-07-13 | Union | New Mexico | 35059 | 8 | 0 |
326873 | 326873 | 2020-07-12 | Union | New Mexico | 35059 | 8 | 0 |
323689 | 323689 | 2020-07-11 | Union | New Mexico | 35059 | 8 | 0 |
320509 | 320509 | 2020-07-10 | Union | New Mexico | 35059 | 8 | 0 |
317332 | 317332 | 2020-07-09 | Union | New Mexico | 35059 | 8 | 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);