ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 5, fips = 35029 and state = "New Mexico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
533008 | 533008 | 2020-09-14 | Luna | New Mexico | 35029 | 372 | 5 |
529772 | 529772 | 2020-09-13 | Luna | New Mexico | 35029 | 357 | 5 |
526536 | 526536 | 2020-09-12 | Luna | New Mexico | 35029 | 358 | 5 |
523300 | 523300 | 2020-09-11 | Luna | New Mexico | 35029 | 354 | 5 |
520063 | 520063 | 2020-09-10 | Luna | New Mexico | 35029 | 350 | 5 |
516827 | 516827 | 2020-09-09 | Luna | New Mexico | 35029 | 345 | 5 |
513593 | 513593 | 2020-09-08 | Luna | New Mexico | 35029 | 342 | 5 |
510360 | 510360 | 2020-09-07 | Luna | New Mexico | 35029 | 341 | 5 |
507127 | 507127 | 2020-09-06 | Luna | New Mexico | 35029 | 339 | 5 |
503895 | 503895 | 2020-09-05 | Luna | New Mexico | 35029 | 339 | 5 |
500661 | 500661 | 2020-09-04 | Luna | New Mexico | 35029 | 321 | 5 |
497427 | 497427 | 2020-09-03 | Luna | New Mexico | 35029 | 321 | 5 |
494194 | 494194 | 2020-09-02 | Luna | New Mexico | 35029 | 316 | 5 |
490960 | 490960 | 2020-09-01 | Luna | New Mexico | 35029 | 316 | 5 |
487727 | 487727 | 2020-08-31 | Luna | New Mexico | 35029 | 316 | 5 |
484493 | 484493 | 2020-08-30 | Luna | New Mexico | 35029 | 315 | 5 |
481258 | 481258 | 2020-08-29 | Luna | New Mexico | 35029 | 314 | 5 |
478026 | 478026 | 2020-08-28 | Luna | New Mexico | 35029 | 311 | 5 |
474793 | 474793 | 2020-08-27 | Luna | New Mexico | 35029 | 307 | 5 |
471559 | 471559 | 2020-08-26 | Luna | New Mexico | 35029 | 275 | 5 |
468327 | 468327 | 2020-08-25 | Luna | New Mexico | 35029 | 273 | 5 |
465099 | 465099 | 2020-08-24 | Luna | New Mexico | 35029 | 273 | 5 |
461869 | 461869 | 2020-08-23 | Luna | New Mexico | 35029 | 269 | 5 |
458641 | 458641 | 2020-08-22 | Luna | New Mexico | 35029 | 261 | 5 |
455414 | 455414 | 2020-08-21 | Luna | New Mexico | 35029 | 264 | 5 |
452186 | 452186 | 2020-08-20 | Luna | New Mexico | 35029 | 263 | 5 |
448957 | 448957 | 2020-08-19 | Luna | New Mexico | 35029 | 259 | 5 |
445730 | 445730 | 2020-08-18 | Luna | New Mexico | 35029 | 257 | 5 |
442504 | 442504 | 2020-08-17 | Luna | New Mexico | 35029 | 257 | 5 |
439277 | 439277 | 2020-08-16 | Luna | New Mexico | 35029 | 257 | 5 |
436052 | 436052 | 2020-08-15 | Luna | New Mexico | 35029 | 257 | 5 |
432826 | 432826 | 2020-08-14 | Luna | New Mexico | 35029 | 256 | 5 |
429599 | 429599 | 2020-08-13 | Luna | New Mexico | 35029 | 255 | 5 |
426375 | 426375 | 2020-08-12 | Luna | New Mexico | 35029 | 254 | 5 |
423152 | 423152 | 2020-08-11 | Luna | New Mexico | 35029 | 255 | 5 |
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);