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 |
---|---|---|---|---|---|---|---|
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 |
314158 | 314158 | 2020-07-08 | Union | New Mexico | 35059 | 8 | 0 |
310987 | 310987 | 2020-07-07 | Union | New Mexico | 35059 | 8 | 0 |
307819 | 307819 | 2020-07-06 | Union | New Mexico | 35059 | 8 | 0 |
304652 | 304652 | 2020-07-05 | Union | New Mexico | 35059 | 8 | 0 |
301489 | 301489 | 2020-07-04 | Union | New Mexico | 35059 | 8 | 0 |
298326 | 298326 | 2020-07-03 | Union | New Mexico | 35059 | 8 | 0 |
295166 | 295166 | 2020-07-02 | Union | New Mexico | 35059 | 8 | 0 |
292011 | 292011 | 2020-07-01 | Union | New Mexico | 35059 | 8 | 0 |
288859 | 288859 | 2020-06-30 | Union | New Mexico | 35059 | 7 | 0 |
285709 | 285709 | 2020-06-29 | Union | New Mexico | 35059 | 7 | 0 |
282564 | 282564 | 2020-06-28 | Union | New Mexico | 35059 | 7 | 0 |
279417 | 279417 | 2020-06-27 | Union | New Mexico | 35059 | 7 | 0 |
276269 | 276269 | 2020-06-26 | Union | New Mexico | 35059 | 7 | 0 |
273124 | 273124 | 2020-06-25 | Union | New Mexico | 35059 | 6 | 0 |
269985 | 269985 | 2020-06-24 | Union | New Mexico | 35059 | 6 | 0 |
266850 | 266850 | 2020-06-23 | Union | New Mexico | 35059 | 5 | 0 |
263723 | 263723 | 2020-06-22 | Union | New Mexico | 35059 | 5 | 0 |
260594 | 260594 | 2020-06-21 | Union | New Mexico | 35059 | 5 | 0 |
257468 | 257468 | 2020-06-20 | Union | New Mexico | 35059 | 5 | 0 |
254345 | 254345 | 2020-06-19 | Union | New Mexico | 35059 | 5 | 0 |
251230 | 251230 | 2020-06-18 | Union | New Mexico | 35059 | 5 | 0 |
248115 | 248115 | 2020-06-17 | Union | New Mexico | 35059 | 5 | 0 |
245002 | 245002 | 2020-06-16 | Union | New Mexico | 35059 | 5 | 0 |
241890 | 241890 | 2020-06-15 | Union | New Mexico | 35059 | 5 | 0 |
238780 | 238780 | 2020-06-14 | Union | New Mexico | 35059 | 5 | 0 |
235673 | 235673 | 2020-06-13 | Union | New Mexico | 35059 | 5 | 0 |
232568 | 232568 | 2020-06-12 | Union | New Mexico | 35059 | 5 | 0 |
229463 | 229463 | 2020-06-11 | Union | New Mexico | 35059 | 5 | 0 |
226359 | 226359 | 2020-06-10 | Union | New Mexico | 35059 | 5 | 0 |
223259 | 223259 | 2020-06-09 | Union | New Mexico | 35059 | 5 | 0 |
220164 | 220164 | 2020-06-08 | Union | New Mexico | 35059 | 5 | 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);