ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Grant" 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 |
---|---|---|---|---|---|---|---|
536236 | 536236 | 2020-09-15 | Grant | New Mexico | 35017 | 99 | 2 |
533001 | 533001 | 2020-09-14 | Grant | New Mexico | 35017 | 99 | 2 |
529765 | 529765 | 2020-09-13 | Grant | New Mexico | 35017 | 99 | 2 |
526529 | 526529 | 2020-09-12 | Grant | New Mexico | 35017 | 98 | 2 |
523293 | 523293 | 2020-09-11 | Grant | New Mexico | 35017 | 98 | 2 |
520056 | 520056 | 2020-09-10 | Grant | New Mexico | 35017 | 97 | 2 |
516820 | 516820 | 2020-09-09 | Grant | New Mexico | 35017 | 90 | 2 |
513586 | 513586 | 2020-09-08 | Grant | New Mexico | 35017 | 89 | 2 |
510353 | 510353 | 2020-09-07 | Grant | New Mexico | 35017 | 88 | 2 |
507120 | 507120 | 2020-09-06 | Grant | New Mexico | 35017 | 87 | 2 |
503888 | 503888 | 2020-09-05 | Grant | New Mexico | 35017 | 87 | 2 |
500654 | 500654 | 2020-09-04 | Grant | New Mexico | 35017 | 84 | 2 |
497420 | 497420 | 2020-09-03 | Grant | New Mexico | 35017 | 84 | 2 |
494187 | 494187 | 2020-09-02 | Grant | New Mexico | 35017 | 84 | 2 |
490953 | 490953 | 2020-09-01 | Grant | New Mexico | 35017 | 83 | 2 |
487720 | 487720 | 2020-08-31 | Grant | New Mexico | 35017 | 82 | 2 |
484486 | 484486 | 2020-08-30 | Grant | New Mexico | 35017 | 79 | 2 |
481251 | 481251 | 2020-08-29 | Grant | New Mexico | 35017 | 79 | 2 |
478019 | 478019 | 2020-08-28 | Grant | New Mexico | 35017 | 79 | 2 |
474786 | 474786 | 2020-08-27 | Grant | New Mexico | 35017 | 78 | 2 |
471552 | 471552 | 2020-08-26 | Grant | New Mexico | 35017 | 76 | 2 |
468320 | 468320 | 2020-08-25 | Grant | New Mexico | 35017 | 76 | 2 |
465092 | 465092 | 2020-08-24 | Grant | New Mexico | 35017 | 76 | 2 |
461862 | 461862 | 2020-08-23 | Grant | New Mexico | 35017 | 76 | 2 |
458634 | 458634 | 2020-08-22 | Grant | New Mexico | 35017 | 74 | 2 |
455407 | 455407 | 2020-08-21 | Grant | New Mexico | 35017 | 76 | 2 |
452179 | 452179 | 2020-08-20 | Grant | New Mexico | 35017 | 75 | 2 |
448950 | 448950 | 2020-08-19 | Grant | New Mexico | 35017 | 72 | 2 |
445723 | 445723 | 2020-08-18 | Grant | New Mexico | 35017 | 72 | 2 |
442497 | 442497 | 2020-08-17 | Grant | New Mexico | 35017 | 72 | 2 |
439270 | 439270 | 2020-08-16 | Grant | New Mexico | 35017 | 72 | 2 |
436045 | 436045 | 2020-08-15 | Grant | New Mexico | 35017 | 72 | 2 |
432819 | 432819 | 2020-08-14 | Grant | New Mexico | 35017 | 72 | 2 |
429592 | 429592 | 2020-08-13 | Grant | New Mexico | 35017 | 72 | 2 |
426368 | 426368 | 2020-08-12 | Grant | New Mexico | 35017 | 71 | 2 |
423145 | 423145 | 2020-08-11 | Grant | New Mexico | 35017 | 71 | 2 |
419922 | 419922 | 2020-08-10 | Grant | New Mexico | 35017 | 71 | 2 |
416702 | 416702 | 2020-08-09 | Grant | New Mexico | 35017 | 71 | 2 |
413481 | 413481 | 2020-08-08 | Grant | New Mexico | 35017 | 71 | 2 |
410261 | 410261 | 2020-08-07 | Grant | New Mexico | 35017 | 71 | 2 |
407041 | 407041 | 2020-08-06 | Grant | New Mexico | 35017 | 71 | 2 |
403822 | 403822 | 2020-08-05 | Grant | New Mexico | 35017 | 70 | 2 |
400604 | 400604 | 2020-08-04 | Grant | New Mexico | 35017 | 68 | 2 |
397389 | 397389 | 2020-08-03 | Grant | New Mexico | 35017 | 68 | 2 |
394172 | 394172 | 2020-08-02 | Grant | New Mexico | 35017 | 67 | 2 |
390955 | 390955 | 2020-08-01 | Grant | New Mexico | 35017 | 67 | 2 |
387739 | 387739 | 2020-07-31 | Grant | New Mexico | 35017 | 66 | 2 |
384522 | 384522 | 2020-07-30 | Grant | New Mexico | 35017 | 66 | 2 |
381304 | 381304 | 2020-07-29 | Grant | New Mexico | 35017 | 65 | 2 |
378086 | 378086 | 2020-07-28 | Grant | New Mexico | 35017 | 65 | 2 |
374871 | 374871 | 2020-07-27 | Grant | New Mexico | 35017 | 63 | 1 |
371659 | 371659 | 2020-07-26 | Grant | New Mexico | 35017 | 63 | 1 |
368447 | 368447 | 2020-07-25 | Grant | New Mexico | 35017 | 63 | 1 |
365238 | 365238 | 2020-07-24 | Grant | New Mexico | 35017 | 64 | 1 |
362032 | 362032 | 2020-07-23 | Grant | New Mexico | 35017 | 63 | 1 |
358826 | 358826 | 2020-07-22 | Grant | New Mexico | 35017 | 59 | 1 |
355622 | 355622 | 2020-07-21 | Grant | New Mexico | 35017 | 55 | 1 |
352419 | 352419 | 2020-07-20 | Grant | New Mexico | 35017 | 53 | 0 |
349216 | 349216 | 2020-07-19 | Grant | New Mexico | 35017 | 49 | 0 |
346015 | 346015 | 2020-07-18 | Grant | New Mexico | 35017 | 47 | 0 |
342816 | 342816 | 2020-07-17 | Grant | New Mexico | 35017 | 47 | 0 |
339618 | 339618 | 2020-07-16 | Grant | New Mexico | 35017 | 46 | 0 |
336422 | 336422 | 2020-07-15 | Grant | New Mexico | 35017 | 44 | 0 |
333228 | 333228 | 2020-07-14 | Grant | New Mexico | 35017 | 41 | 0 |
330038 | 330038 | 2020-07-13 | Grant | New Mexico | 35017 | 35 | 0 |
326851 | 326851 | 2020-07-12 | Grant | New Mexico | 35017 | 33 | 0 |
323667 | 323667 | 2020-07-11 | Grant | New Mexico | 35017 | 32 | 0 |
320487 | 320487 | 2020-07-10 | Grant | New Mexico | 35017 | 30 | 0 |
317311 | 317311 | 2020-07-09 | Grant | New Mexico | 35017 | 29 | 0 |
314137 | 314137 | 2020-07-08 | Grant | New Mexico | 35017 | 27 | 0 |
310966 | 310966 | 2020-07-07 | Grant | New Mexico | 35017 | 24 | 0 |
307798 | 307798 | 2020-07-06 | Grant | New Mexico | 35017 | 24 | 0 |
304631 | 304631 | 2020-07-05 | Grant | New Mexico | 35017 | 24 | 0 |
301468 | 301468 | 2020-07-04 | Grant | New Mexico | 35017 | 22 | 0 |
298305 | 298305 | 2020-07-03 | Grant | New Mexico | 35017 | 21 | 0 |
295145 | 295145 | 2020-07-02 | Grant | New Mexico | 35017 | 20 | 0 |
291990 | 291990 | 2020-07-01 | Grant | New Mexico | 35017 | 19 | 0 |
288838 | 288838 | 2020-06-30 | Grant | New Mexico | 35017 | 18 | 0 |
285688 | 285688 | 2020-06-29 | Grant | New Mexico | 35017 | 18 | 0 |
282543 | 282543 | 2020-06-28 | Grant | New Mexico | 35017 | 18 | 0 |
279396 | 279396 | 2020-06-27 | Grant | New Mexico | 35017 | 18 | 0 |
276248 | 276248 | 2020-06-26 | Grant | New Mexico | 35017 | 17 | 0 |
273103 | 273103 | 2020-06-25 | Grant | New Mexico | 35017 | 17 | 0 |
269964 | 269964 | 2020-06-24 | Grant | New Mexico | 35017 | 17 | 0 |
266829 | 266829 | 2020-06-23 | Grant | New Mexico | 35017 | 17 | 0 |
263702 | 263702 | 2020-06-22 | Grant | New Mexico | 35017 | 17 | 0 |
260573 | 260573 | 2020-06-21 | Grant | New Mexico | 35017 | 17 | 0 |
257447 | 257447 | 2020-06-20 | Grant | New Mexico | 35017 | 16 | 0 |
254324 | 254324 | 2020-06-19 | Grant | New Mexico | 35017 | 16 | 0 |
251209 | 251209 | 2020-06-18 | Grant | New Mexico | 35017 | 16 | 0 |
248094 | 248094 | 2020-06-17 | Grant | New Mexico | 35017 | 16 | 0 |
244981 | 244981 | 2020-06-16 | Grant | New Mexico | 35017 | 16 | 0 |
241869 | 241869 | 2020-06-15 | Grant | New Mexico | 35017 | 16 | 0 |
238759 | 238759 | 2020-06-14 | Grant | New Mexico | 35017 | 16 | 0 |
235652 | 235652 | 2020-06-13 | Grant | New Mexico | 35017 | 16 | 0 |
232547 | 232547 | 2020-06-12 | Grant | New Mexico | 35017 | 17 | 0 |
229442 | 229442 | 2020-06-11 | Grant | New Mexico | 35017 | 16 | 0 |
226338 | 226338 | 2020-06-10 | Grant | New Mexico | 35017 | 15 | 0 |
223238 | 223238 | 2020-06-09 | Grant | New Mexico | 35017 | 15 | 0 |
220143 | 220143 | 2020-06-08 | Grant | New Mexico | 35017 | 15 | 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);