ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 107 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- New Mexico · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
607534 | 607534 | 2020-10-07 | San Miguel | New Mexico | 35047 | 107 | 0 |
584845 | 584845 | 2020-09-30 | Socorro | New Mexico | 35053 | 107 | 6 |
526550 | 526550 | 2020-09-12 | Torrance | New Mexico | 35057 | 107 | 1 |
523314 | 523314 | 2020-09-11 | Torrance | New Mexico | 35057 | 107 | 1 |
520077 | 520077 | 2020-09-10 | Torrance | New Mexico | 35057 | 107 | 1 |
516841 | 516841 | 2020-09-09 | Torrance | New Mexico | 35057 | 107 | 1 |
513607 | 513607 | 2020-09-08 | Torrance | New Mexico | 35057 | 107 | 1 |
510374 | 510374 | 2020-09-07 | Torrance | New Mexico | 35057 | 107 | 1 |
507141 | 507141 | 2020-09-06 | Torrance | New Mexico | 35057 | 107 | 1 |
503909 | 503909 | 2020-09-05 | Torrance | New Mexico | 35057 | 107 | 1 |
500675 | 500675 | 2020-09-04 | Torrance | New Mexico | 35057 | 107 | 1 |
497441 | 497441 | 2020-09-03 | Torrance | New Mexico | 35057 | 107 | 1 |
494208 | 494208 | 2020-09-02 | Torrance | New Mexico | 35057 | 107 | 1 |
490974 | 490974 | 2020-09-01 | Torrance | New Mexico | 35057 | 107 | 1 |
487741 | 487741 | 2020-08-31 | Torrance | New Mexico | 35057 | 107 | 1 |
484507 | 484507 | 2020-08-30 | Torrance | New Mexico | 35057 | 107 | 1 |
481272 | 481272 | 2020-08-29 | Torrance | New Mexico | 35057 | 107 | 1 |
478040 | 478040 | 2020-08-28 | Torrance | New Mexico | 35057 | 107 | 1 |
474807 | 474807 | 2020-08-27 | Torrance | New Mexico | 35057 | 107 | 1 |
471573 | 471573 | 2020-08-26 | Torrance | New Mexico | 35057 | 107 | 1 |
468341 | 468341 | 2020-08-25 | Torrance | New Mexico | 35057 | 107 | 1 |
465113 | 465113 | 2020-08-24 | Torrance | New Mexico | 35057 | 107 | 1 |
461883 | 461883 | 2020-08-23 | Torrance | New Mexico | 35057 | 107 | 1 |
458655 | 458655 | 2020-08-22 | Torrance | New Mexico | 35057 | 107 | 1 |
455428 | 455428 | 2020-08-21 | Torrance | New Mexico | 35057 | 107 | 1 |
452200 | 452200 | 2020-08-20 | Torrance | New Mexico | 35057 | 107 | 1 |
448971 | 448971 | 2020-08-19 | Torrance | New Mexico | 35057 | 107 | 1 |
445744 | 445744 | 2020-08-18 | Torrance | New Mexico | 35057 | 107 | 1 |
442518 | 442518 | 2020-08-17 | Torrance | New Mexico | 35057 | 107 | 1 |
439291 | 439291 | 2020-08-16 | Torrance | New Mexico | 35057 | 107 | 1 |
436066 | 436066 | 2020-08-15 | Torrance | New Mexico | 35057 | 107 | 1 |
310965 | 310965 | 2020-07-07 | Eddy | New Mexico | 35015 | 107 | 1 |
111265 | 111265 | 2020-05-03 | Santa Fe | New Mexico | 35049 | 107 | 0 |
108392 | 108392 | 2020-05-02 | Santa Fe | New Mexico | 35049 | 107 | 0 |
39557 | 39557 | 2020-04-07 | San Juan | New Mexico | 35045 | 107 | 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);