ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 30023 and state = "Montana" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
310798 | 310798 | 2020-07-07 | Deer Lodge | Montana | 30023 | 4 | 0 |
313969 | 313969 | 2020-07-08 | Deer Lodge | Montana | 30023 | 4 | 0 |
317143 | 317143 | 2020-07-09 | Deer Lodge | Montana | 30023 | 4 | 0 |
320318 | 320318 | 2020-07-10 | Deer Lodge | Montana | 30023 | 4 | 0 |
323497 | 323497 | 2020-07-11 | Deer Lodge | Montana | 30023 | 6 | 0 |
326680 | 326680 | 2020-07-12 | Deer Lodge | Montana | 30023 | 6 | 0 |
329866 | 329866 | 2020-07-13 | Deer Lodge | Montana | 30023 | 6 | 0 |
333053 | 333053 | 2020-07-14 | Deer Lodge | Montana | 30023 | 6 | 0 |
336246 | 336246 | 2020-07-15 | Deer Lodge | Montana | 30023 | 6 | 0 |
339443 | 339443 | 2020-07-16 | Deer Lodge | Montana | 30023 | 6 | 0 |
342639 | 342639 | 2020-07-17 | Deer Lodge | Montana | 30023 | 8 | 0 |
345839 | 345839 | 2020-07-18 | Deer Lodge | Montana | 30023 | 8 | 0 |
349040 | 349040 | 2020-07-19 | Deer Lodge | Montana | 30023 | 8 | 0 |
352240 | 352240 | 2020-07-20 | Deer Lodge | Montana | 30023 | 8 | 0 |
355443 | 355443 | 2020-07-21 | Deer Lodge | Montana | 30023 | 8 | 0 |
358646 | 358646 | 2020-07-22 | Deer Lodge | Montana | 30023 | 8 | 0 |
361851 | 361851 | 2020-07-23 | Deer Lodge | Montana | 30023 | 10 | 0 |
365058 | 365058 | 2020-07-24 | Deer Lodge | Montana | 30023 | 10 | 0 |
368267 | 368267 | 2020-07-25 | Deer Lodge | Montana | 30023 | 14 | 0 |
371478 | 371478 | 2020-07-26 | Deer Lodge | Montana | 30023 | 14 | 0 |
374690 | 374690 | 2020-07-27 | Deer Lodge | Montana | 30023 | 14 | 0 |
377905 | 377905 | 2020-07-28 | Deer Lodge | Montana | 30023 | 14 | 0 |
381122 | 381122 | 2020-07-29 | Deer Lodge | Montana | 30023 | 18 | 0 |
384338 | 384338 | 2020-07-30 | Deer Lodge | Montana | 30023 | 20 | 0 |
387556 | 387556 | 2020-07-31 | Deer Lodge | Montana | 30023 | 20 | 0 |
390773 | 390773 | 2020-08-01 | Deer Lodge | Montana | 30023 | 20 | 0 |
393990 | 393990 | 2020-08-02 | Deer Lodge | Montana | 30023 | 20 | 0 |
397206 | 397206 | 2020-08-03 | Deer Lodge | Montana | 30023 | 20 | 0 |
400420 | 400420 | 2020-08-04 | Deer Lodge | Montana | 30023 | 22 | 0 |
403637 | 403637 | 2020-08-05 | Deer Lodge | Montana | 30023 | 23 | 0 |
406855 | 406855 | 2020-08-06 | Deer Lodge | Montana | 30023 | 23 | 0 |
410075 | 410075 | 2020-08-07 | Deer Lodge | Montana | 30023 | 25 | 0 |
413295 | 413295 | 2020-08-08 | Deer Lodge | Montana | 30023 | 25 | 0 |
416515 | 416515 | 2020-08-09 | Deer Lodge | Montana | 30023 | 25 | 0 |
419736 | 419736 | 2020-08-10 | Deer Lodge | Montana | 30023 | 25 | 0 |
422958 | 422958 | 2020-08-11 | Deer Lodge | Montana | 30023 | 25 | 0 |
426180 | 426180 | 2020-08-12 | Deer Lodge | Montana | 30023 | 26 | 0 |
429404 | 429404 | 2020-08-13 | Deer Lodge | Montana | 30023 | 26 | 0 |
432631 | 432631 | 2020-08-14 | Deer Lodge | Montana | 30023 | 28 | 0 |
435857 | 435857 | 2020-08-15 | Deer Lodge | Montana | 30023 | 30 | 0 |
439082 | 439082 | 2020-08-16 | Deer Lodge | Montana | 30023 | 30 | 0 |
442309 | 442309 | 2020-08-17 | Deer Lodge | Montana | 30023 | 30 | 0 |
445535 | 445535 | 2020-08-18 | Deer Lodge | Montana | 30023 | 30 | 0 |
448761 | 448761 | 2020-08-19 | Deer Lodge | Montana | 30023 | 30 | 0 |
451989 | 451989 | 2020-08-20 | Deer Lodge | Montana | 30023 | 31 | 0 |
455217 | 455217 | 2020-08-21 | Deer Lodge | Montana | 30023 | 31 | 0 |
458445 | 458445 | 2020-08-22 | Deer Lodge | Montana | 30023 | 32 | 0 |
461672 | 461672 | 2020-08-23 | Deer Lodge | Montana | 30023 | 32 | 0 |
464903 | 464903 | 2020-08-24 | Deer Lodge | Montana | 30023 | 32 | 0 |
468132 | 468132 | 2020-08-25 | Deer Lodge | Montana | 30023 | 32 | 0 |
471362 | 471362 | 2020-08-26 | Deer Lodge | Montana | 30023 | 33 | 0 |
474594 | 474594 | 2020-08-27 | Deer Lodge | Montana | 30023 | 34 | 0 |
477827 | 477827 | 2020-08-28 | Deer Lodge | Montana | 30023 | 33 | 0 |
481059 | 481059 | 2020-08-29 | Deer Lodge | Montana | 30023 | 33 | 0 |
484294 | 484294 | 2020-08-30 | Deer Lodge | Montana | 30023 | 33 | 0 |
487528 | 487528 | 2020-08-31 | Deer Lodge | Montana | 30023 | 33 | 0 |
490761 | 490761 | 2020-09-01 | Deer Lodge | Montana | 30023 | 33 | 0 |
493995 | 493995 | 2020-09-02 | Deer Lodge | Montana | 30023 | 33 | 0 |
497228 | 497228 | 2020-09-03 | Deer Lodge | Montana | 30023 | 35 | 0 |
500462 | 500462 | 2020-09-04 | Deer Lodge | Montana | 30023 | 59 | 0 |
503696 | 503696 | 2020-09-05 | Deer Lodge | Montana | 30023 | 80 | 0 |
506929 | 506929 | 2020-09-06 | Deer Lodge | Montana | 30023 | 80 | 0 |
510162 | 510162 | 2020-09-07 | Deer Lodge | Montana | 30023 | 80 | 0 |
513394 | 513394 | 2020-09-08 | Deer Lodge | Montana | 30023 | 82 | 0 |
516628 | 516628 | 2020-09-09 | Deer Lodge | Montana | 30023 | 82 | 0 |
519863 | 519863 | 2020-09-10 | Deer Lodge | Montana | 30023 | 84 | 0 |
523100 | 523100 | 2020-09-11 | Deer Lodge | Montana | 30023 | 84 | 0 |
526336 | 526336 | 2020-09-12 | Deer Lodge | Montana | 30023 | 85 | 0 |
529572 | 529572 | 2020-09-13 | Deer Lodge | Montana | 30023 | 87 | 0 |
532808 | 532808 | 2020-09-14 | Deer Lodge | Montana | 30023 | 87 | 0 |
536043 | 536043 | 2020-09-15 | Deer Lodge | Montana | 30023 | 87 | 0 |
539280 | 539280 | 2020-09-16 | Deer Lodge | Montana | 30023 | 87 | 0 |
542516 | 542516 | 2020-09-17 | Deer Lodge | Montana | 30023 | 88 | 0 |
545753 | 545753 | 2020-09-18 | Deer Lodge | Montana | 30023 | 88 | 0 |
548991 | 548991 | 2020-09-19 | Deer Lodge | Montana | 30023 | 113 | 0 |
552230 | 552230 | 2020-09-20 | Deer Lodge | Montana | 30023 | 113 | 0 |
555468 | 555468 | 2020-09-21 | Deer Lodge | Montana | 30023 | 113 | 0 |
558705 | 558705 | 2020-09-22 | Deer Lodge | Montana | 30023 | 113 | 0 |
561942 | 561942 | 2020-09-23 | Deer Lodge | Montana | 30023 | 114 | 0 |
565183 | 565183 | 2020-09-24 | Deer Lodge | Montana | 30023 | 114 | 0 |
568423 | 568423 | 2020-09-25 | Deer Lodge | Montana | 30023 | 114 | 0 |
571665 | 571665 | 2020-09-26 | Deer Lodge | Montana | 30023 | 116 | 0 |
574908 | 574908 | 2020-09-27 | Deer Lodge | Montana | 30023 | 116 | 0 |
578149 | 578149 | 2020-09-28 | Deer Lodge | Montana | 30023 | 116 | 0 |
581390 | 581390 | 2020-09-29 | Deer Lodge | Montana | 30023 | 115 | 0 |
584631 | 584631 | 2020-09-30 | Deer Lodge | Montana | 30023 | 117 | 0 |
587871 | 587871 | 2020-10-01 | Deer Lodge | Montana | 30023 | 118 | 0 |
591112 | 591112 | 2020-10-02 | Deer Lodge | Montana | 30023 | 123 | 0 |
594353 | 594353 | 2020-10-03 | Deer Lodge | Montana | 30023 | 152 | 0 |
597594 | 597594 | 2020-10-04 | Deer Lodge | Montana | 30023 | 174 | 0 |
600837 | 600837 | 2020-10-05 | Deer Lodge | Montana | 30023 | 194 | 0 |
604079 | 604079 | 2020-10-06 | Deer Lodge | Montana | 30023 | 194 | 0 |
607322 | 607322 | 2020-10-07 | Deer Lodge | Montana | 30023 | 207 | 0 |
610564 | 610564 | 2020-10-08 | Deer Lodge | Montana | 30023 | 210 | 0 |
613806 | 613806 | 2020-10-09 | Deer Lodge | Montana | 30023 | 226 | 0 |
617047 | 617047 | 2020-10-10 | Deer Lodge | Montana | 30023 | 238 | 0 |
620289 | 620289 | 2020-10-11 | Deer Lodge | Montana | 30023 | 259 | 0 |
623532 | 623532 | 2020-10-12 | Deer Lodge | Montana | 30023 | 267 | 0 |
626774 | 626774 | 2020-10-13 | Deer Lodge | Montana | 30023 | 267 | 0 |
630018 | 630018 | 2020-10-14 | Deer Lodge | Montana | 30023 | 271 | 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);