ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
276 rows where cases = 2 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 |
---|---|---|---|---|---|---|---|
1509858 | 1509858 | 2021-07-12 | Unknown | New Mexico | 2 | 0 | |
1438450 | 1438450 | 2021-06-20 | Unknown | New Mexico | 2 | 0 | |
1435203 | 1435203 | 2021-06-19 | Unknown | New Mexico | 2 | 0 | |
1431956 | 1431956 | 2021-06-18 | Unknown | New Mexico | 2 | 0 | |
948245 | 948245 | 2021-01-20 | Unknown | New Mexico | 2 | 0 | |
944998 | 944998 | 2021-01-19 | Unknown | New Mexico | 2 | 0 | |
698342 | 698342 | 2020-11-04 | De Baca | New Mexico | 35011 | 2 | 0 |
688613 | 688613 | 2020-11-01 | De Baca | New Mexico | 35011 | 2 | 0 |
685368 | 685368 | 2020-10-31 | De Baca | New Mexico | 35011 | 2 | 0 |
682125 | 682125 | 2020-10-30 | De Baca | New Mexico | 35011 | 2 | 0 |
678882 | 678882 | 2020-10-29 | De Baca | New Mexico | 35011 | 2 | 0 |
675639 | 675639 | 2020-10-28 | De Baca | New Mexico | 35011 | 2 | 0 |
584828 | 584828 | 2020-09-30 | Harding | New Mexico | 35021 | 2 | 0 |
581587 | 581587 | 2020-09-29 | Harding | New Mexico | 35021 | 2 | 0 |
578346 | 578346 | 2020-09-28 | Harding | New Mexico | 35021 | 2 | 0 |
578367 | 578367 | 2020-09-28 | Unknown | New Mexico | 2 | 0 | |
575105 | 575105 | 2020-09-27 | Harding | New Mexico | 35021 | 2 | 0 |
571862 | 571862 | 2020-09-26 | Harding | New Mexico | 35021 | 2 | 0 |
568620 | 568620 | 2020-09-25 | Harding | New Mexico | 35021 | 2 | 0 |
565379 | 565379 | 2020-09-24 | Harding | New Mexico | 35021 | 2 | 0 |
562138 | 562138 | 2020-09-23 | Harding | New Mexico | 35021 | 2 | 0 |
558901 | 558901 | 2020-09-22 | Harding | New Mexico | 35021 | 2 | 0 |
555664 | 555664 | 2020-09-21 | Harding | New Mexico | 35021 | 2 | 0 |
552426 | 552426 | 2020-09-20 | Harding | New Mexico | 35021 | 2 | 0 |
549187 | 549187 | 2020-09-19 | Harding | New Mexico | 35021 | 2 | 0 |
545949 | 545949 | 2020-09-18 | Harding | New Mexico | 35021 | 2 | 0 |
542712 | 542712 | 2020-09-17 | Harding | New Mexico | 35021 | 2 | 0 |
539475 | 539475 | 2020-09-16 | Harding | New Mexico | 35021 | 2 | 0 |
536238 | 536238 | 2020-09-15 | Harding | New Mexico | 35021 | 2 | 0 |
532998 | 532998 | 2020-09-14 | De Baca | New Mexico | 35011 | 2 | 0 |
533003 | 533003 | 2020-09-14 | Harding | New Mexico | 35021 | 2 | 0 |
529762 | 529762 | 2020-09-13 | De Baca | New Mexico | 35011 | 2 | 0 |
529767 | 529767 | 2020-09-13 | Harding | New Mexico | 35021 | 2 | 0 |
529788 | 529788 | 2020-09-13 | Unknown | New Mexico | 2 | 0 | |
526526 | 526526 | 2020-09-12 | De Baca | New Mexico | 35011 | 2 | 0 |
526531 | 526531 | 2020-09-12 | Harding | New Mexico | 35021 | 2 | 0 |
523295 | 523295 | 2020-09-11 | Harding | New Mexico | 35021 | 2 | 0 |
520058 | 520058 | 2020-09-10 | Harding | New Mexico | 35021 | 2 | 0 |
520079 | 520079 | 2020-09-10 | Unknown | New Mexico | 2 | 0 | |
516822 | 516822 | 2020-09-09 | Harding | New Mexico | 35021 | 2 | 0 |
516843 | 516843 | 2020-09-09 | Unknown | New Mexico | 2 | 0 | |
513588 | 513588 | 2020-09-08 | Harding | New Mexico | 35021 | 2 | 0 |
510355 | 510355 | 2020-09-07 | Harding | New Mexico | 35021 | 2 | 0 |
507122 | 507122 | 2020-09-06 | Harding | New Mexico | 35021 | 2 | 0 |
503890 | 503890 | 2020-09-05 | Harding | New Mexico | 35021 | 2 | 0 |
500656 | 500656 | 2020-09-04 | Harding | New Mexico | 35021 | 2 | 0 |
497422 | 497422 | 2020-09-03 | Harding | New Mexico | 35021 | 2 | 0 |
494189 | 494189 | 2020-09-02 | Harding | New Mexico | 35021 | 2 | 0 |
490955 | 490955 | 2020-09-01 | Harding | New Mexico | 35021 | 2 | 0 |
487722 | 487722 | 2020-08-31 | Harding | New Mexico | 35021 | 2 | 0 |
484488 | 484488 | 2020-08-30 | Harding | New Mexico | 35021 | 2 | 0 |
481253 | 481253 | 2020-08-29 | Harding | New Mexico | 35021 | 2 | 0 |
478021 | 478021 | 2020-08-28 | Harding | New Mexico | 35021 | 2 | 0 |
474788 | 474788 | 2020-08-27 | Harding | New Mexico | 35021 | 2 | 0 |
471554 | 471554 | 2020-08-26 | Harding | New Mexico | 35021 | 2 | 0 |
468322 | 468322 | 2020-08-25 | Harding | New Mexico | 35021 | 2 | 0 |
465094 | 465094 | 2020-08-24 | Harding | New Mexico | 35021 | 2 | 0 |
461864 | 461864 | 2020-08-23 | Harding | New Mexico | 35021 | 2 | 0 |
461885 | 461885 | 2020-08-23 | Unknown | New Mexico | 2 | 0 | |
458636 | 458636 | 2020-08-22 | Harding | New Mexico | 35021 | 2 | 0 |
455409 | 455409 | 2020-08-21 | Harding | New Mexico | 35021 | 2 | 0 |
452181 | 452181 | 2020-08-20 | Harding | New Mexico | 35021 | 2 | 0 |
448952 | 448952 | 2020-08-19 | Harding | New Mexico | 35021 | 2 | 0 |
445725 | 445725 | 2020-08-18 | Harding | New Mexico | 35021 | 2 | 0 |
442499 | 442499 | 2020-08-17 | Harding | New Mexico | 35021 | 2 | 0 |
439272 | 439272 | 2020-08-16 | Harding | New Mexico | 35021 | 2 | 0 |
339627 | 339627 | 2020-07-16 | Mora | New Mexico | 35033 | 2 | 0 |
336431 | 336431 | 2020-07-15 | Mora | New Mexico | 35033 | 2 | 0 |
333237 | 333237 | 2020-07-14 | Mora | New Mexico | 35033 | 2 | 0 |
323676 | 323676 | 2020-07-11 | Mora | New Mexico | 35033 | 2 | 0 |
320480 | 320480 | 2020-07-10 | Catron | New Mexico | 35003 | 2 | 1 |
317304 | 317304 | 2020-07-09 | Catron | New Mexico | 35003 | 2 | 1 |
314130 | 314130 | 2020-07-08 | Catron | New Mexico | 35003 | 2 | 1 |
310959 | 310959 | 2020-07-07 | Catron | New Mexico | 35003 | 2 | 1 |
307791 | 307791 | 2020-07-06 | Catron | New Mexico | 35003 | 2 | 1 |
304624 | 304624 | 2020-07-05 | Catron | New Mexico | 35003 | 2 | 1 |
301461 | 301461 | 2020-07-04 | Catron | New Mexico | 35003 | 2 | 1 |
298298 | 298298 | 2020-07-03 | Catron | New Mexico | 35003 | 2 | 1 |
295138 | 295138 | 2020-07-02 | Catron | New Mexico | 35003 | 2 | 1 |
291983 | 291983 | 2020-07-01 | Catron | New Mexico | 35003 | 2 | 1 |
288831 | 288831 | 2020-06-30 | Catron | New Mexico | 35003 | 2 | 1 |
285681 | 285681 | 2020-06-29 | Catron | New Mexico | 35003 | 2 | 1 |
282536 | 282536 | 2020-06-28 | Catron | New Mexico | 35003 | 2 | 1 |
279389 | 279389 | 2020-06-27 | Catron | New Mexico | 35003 | 2 | 1 |
276241 | 276241 | 2020-06-26 | Catron | New Mexico | 35003 | 2 | 1 |
273096 | 273096 | 2020-06-25 | Catron | New Mexico | 35003 | 2 | 1 |
269957 | 269957 | 2020-06-24 | Catron | New Mexico | 35003 | 2 | 1 |
266822 | 266822 | 2020-06-23 | Catron | New Mexico | 35003 | 2 | 1 |
263695 | 263695 | 2020-06-22 | Catron | New Mexico | 35003 | 2 | 1 |
260566 | 260566 | 2020-06-21 | Catron | New Mexico | 35003 | 2 | 1 |
257440 | 257440 | 2020-06-20 | Catron | New Mexico | 35003 | 2 | 1 |
254317 | 254317 | 2020-06-19 | Catron | New Mexico | 35003 | 2 | 1 |
251202 | 251202 | 2020-06-18 | Catron | New Mexico | 35003 | 2 | 1 |
248087 | 248087 | 2020-06-17 | Catron | New Mexico | 35003 | 2 | 1 |
244974 | 244974 | 2020-06-16 | Catron | New Mexico | 35003 | 2 | 1 |
241862 | 241862 | 2020-06-15 | Catron | New Mexico | 35003 | 2 | 1 |
238752 | 238752 | 2020-06-14 | Catron | New Mexico | 35003 | 2 | 1 |
235645 | 235645 | 2020-06-13 | Catron | New Mexico | 35003 | 2 | 1 |
232540 | 232540 | 2020-06-12 | Catron | New Mexico | 35003 | 2 | 1 |
232550 | 232550 | 2020-06-12 | Hidalgo | New Mexico | 35023 | 2 | 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);