ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Roosevelt" and state = "Montana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
279251 | 279251 | 2020-06-27 | Roosevelt | Montana | 30085 | 8 | 0 |
282399 | 282399 | 2020-06-28 | Roosevelt | Montana | 30085 | 8 | 0 |
285544 | 285544 | 2020-06-29 | Roosevelt | Montana | 30085 | 7 | 0 |
288694 | 288694 | 2020-06-30 | Roosevelt | Montana | 30085 | 7 | 0 |
291845 | 291845 | 2020-07-01 | Roosevelt | Montana | 30085 | 7 | 0 |
294999 | 294999 | 2020-07-02 | Roosevelt | Montana | 30085 | 7 | 0 |
298157 | 298157 | 2020-07-03 | Roosevelt | Montana | 30085 | 7 | 0 |
301320 | 301320 | 2020-07-04 | Roosevelt | Montana | 30085 | 7 | 0 |
304484 | 304484 | 2020-07-05 | Roosevelt | Montana | 30085 | 7 | 0 |
307651 | 307651 | 2020-07-06 | Roosevelt | Montana | 30085 | 7 | 0 |
310819 | 310819 | 2020-07-07 | Roosevelt | Montana | 30085 | 7 | 0 |
313990 | 313990 | 2020-07-08 | Roosevelt | Montana | 30085 | 7 | 0 |
317164 | 317164 | 2020-07-09 | Roosevelt | Montana | 30085 | 8 | 0 |
320339 | 320339 | 2020-07-10 | Roosevelt | Montana | 30085 | 8 | 0 |
323518 | 323518 | 2020-07-11 | Roosevelt | Montana | 30085 | 10 | 0 |
326702 | 326702 | 2020-07-12 | Roosevelt | Montana | 30085 | 10 | 0 |
329889 | 329889 | 2020-07-13 | Roosevelt | Montana | 30085 | 10 | 0 |
333076 | 333076 | 2020-07-14 | Roosevelt | Montana | 30085 | 9 | 0 |
336269 | 336269 | 2020-07-15 | Roosevelt | Montana | 30085 | 9 | 0 |
339466 | 339466 | 2020-07-16 | Roosevelt | Montana | 30085 | 9 | 0 |
342662 | 342662 | 2020-07-17 | Roosevelt | Montana | 30085 | 9 | 0 |
345862 | 345862 | 2020-07-18 | Roosevelt | Montana | 30085 | 9 | 0 |
349063 | 349063 | 2020-07-19 | Roosevelt | Montana | 30085 | 9 | 0 |
352264 | 352264 | 2020-07-20 | Roosevelt | Montana | 30085 | 9 | 0 |
355467 | 355467 | 2020-07-21 | Roosevelt | Montana | 30085 | 11 | 0 |
358671 | 358671 | 2020-07-22 | Roosevelt | Montana | 30085 | 8 | 0 |
361877 | 361877 | 2020-07-23 | Roosevelt | Montana | 30085 | 9 | 0 |
365084 | 365084 | 2020-07-24 | Roosevelt | Montana | 30085 | 10 | 0 |
368293 | 368293 | 2020-07-25 | Roosevelt | Montana | 30085 | 9 | 0 |
371504 | 371504 | 2020-07-26 | Roosevelt | Montana | 30085 | 10 | 0 |
374716 | 374716 | 2020-07-27 | Roosevelt | Montana | 30085 | 10 | 0 |
377931 | 377931 | 2020-07-28 | Roosevelt | Montana | 30085 | 11 | 0 |
381149 | 381149 | 2020-07-29 | Roosevelt | Montana | 30085 | 14 | 0 |
384365 | 384365 | 2020-07-30 | Roosevelt | Montana | 30085 | 17 | 0 |
387583 | 387583 | 2020-07-31 | Roosevelt | Montana | 30085 | 17 | 0 |
390800 | 390800 | 2020-08-01 | Roosevelt | Montana | 30085 | 19 | 0 |
394017 | 394017 | 2020-08-02 | Roosevelt | Montana | 30085 | 19 | 0 |
397233 | 397233 | 2020-08-03 | Roosevelt | Montana | 30085 | 19 | 0 |
400448 | 400448 | 2020-08-04 | Roosevelt | Montana | 30085 | 20 | 0 |
403666 | 403666 | 2020-08-05 | Roosevelt | Montana | 30085 | 20 | 0 |
406884 | 406884 | 2020-08-06 | Roosevelt | Montana | 30085 | 21 | 0 |
410104 | 410104 | 2020-08-07 | Roosevelt | Montana | 30085 | 21 | 0 |
413324 | 413324 | 2020-08-08 | Roosevelt | Montana | 30085 | 23 | 0 |
416544 | 416544 | 2020-08-09 | Roosevelt | Montana | 30085 | 23 | 0 |
419765 | 419765 | 2020-08-10 | Roosevelt | Montana | 30085 | 23 | 0 |
422988 | 422988 | 2020-08-11 | Roosevelt | Montana | 30085 | 23 | 0 |
426210 | 426210 | 2020-08-12 | Roosevelt | Montana | 30085 | 24 | 0 |
429434 | 429434 | 2020-08-13 | Roosevelt | Montana | 30085 | 25 | 0 |
432661 | 432661 | 2020-08-14 | Roosevelt | Montana | 30085 | 29 | 0 |
435887 | 435887 | 2020-08-15 | Roosevelt | Montana | 30085 | 30 | 0 |
439112 | 439112 | 2020-08-16 | Roosevelt | Montana | 30085 | 35 | 0 |
442339 | 442339 | 2020-08-17 | Roosevelt | Montana | 30085 | 35 | 0 |
445565 | 445565 | 2020-08-18 | Roosevelt | Montana | 30085 | 30 | 1 |
448791 | 448791 | 2020-08-19 | Roosevelt | Montana | 30085 | 30 | 1 |
452019 | 452019 | 2020-08-20 | Roosevelt | Montana | 30085 | 31 | 1 |
455247 | 455247 | 2020-08-21 | Roosevelt | Montana | 30085 | 31 | 1 |
458475 | 458475 | 2020-08-22 | Roosevelt | Montana | 30085 | 34 | 1 |
461702 | 461702 | 2020-08-23 | Roosevelt | Montana | 30085 | 34 | 1 |
464933 | 464933 | 2020-08-24 | Roosevelt | Montana | 30085 | 34 | 1 |
468162 | 468162 | 2020-08-25 | Roosevelt | Montana | 30085 | 35 | 1 |
471392 | 471392 | 2020-08-26 | Roosevelt | Montana | 30085 | 34 | 1 |
474624 | 474624 | 2020-08-27 | Roosevelt | Montana | 30085 | 34 | 1 |
477857 | 477857 | 2020-08-28 | Roosevelt | Montana | 30085 | 34 | 1 |
481089 | 481089 | 2020-08-29 | Roosevelt | Montana | 30085 | 34 | 1 |
484324 | 484324 | 2020-08-30 | Roosevelt | Montana | 30085 | 34 | 1 |
487558 | 487558 | 2020-08-31 | Roosevelt | Montana | 30085 | 42 | 1 |
490791 | 490791 | 2020-09-01 | Roosevelt | Montana | 30085 | 43 | 1 |
494025 | 494025 | 2020-09-02 | Roosevelt | Montana | 30085 | 44 | 1 |
497258 | 497258 | 2020-09-03 | Roosevelt | Montana | 30085 | 48 | 1 |
500492 | 500492 | 2020-09-04 | Roosevelt | Montana | 30085 | 51 | 1 |
503726 | 503726 | 2020-09-05 | Roosevelt | Montana | 30085 | 61 | 1 |
506959 | 506959 | 2020-09-06 | Roosevelt | Montana | 30085 | 62 | 1 |
510192 | 510192 | 2020-09-07 | Roosevelt | Montana | 30085 | 62 | 1 |
513424 | 513424 | 2020-09-08 | Roosevelt | Montana | 30085 | 62 | 1 |
516658 | 516658 | 2020-09-09 | Roosevelt | Montana | 30085 | 63 | 1 |
519893 | 519893 | 2020-09-10 | Roosevelt | Montana | 30085 | 63 | 1 |
523130 | 523130 | 2020-09-11 | Roosevelt | Montana | 30085 | 66 | 1 |
526366 | 526366 | 2020-09-12 | Roosevelt | Montana | 30085 | 74 | 1 |
529602 | 529602 | 2020-09-13 | Roosevelt | Montana | 30085 | 86 | 1 |
532838 | 532838 | 2020-09-14 | Roosevelt | Montana | 30085 | 86 | 1 |
536073 | 536073 | 2020-09-15 | Roosevelt | Montana | 30085 | 87 | 1 |
539310 | 539310 | 2020-09-16 | Roosevelt | Montana | 30085 | 87 | 1 |
542546 | 542546 | 2020-09-17 | Roosevelt | Montana | 30085 | 101 | 1 |
545783 | 545783 | 2020-09-18 | Roosevelt | Montana | 30085 | 126 | 1 |
549021 | 549021 | 2020-09-19 | Roosevelt | Montana | 30085 | 147 | 1 |
552260 | 552260 | 2020-09-20 | Roosevelt | Montana | 30085 | 151 | 1 |
555498 | 555498 | 2020-09-21 | Roosevelt | Montana | 30085 | 168 | 1 |
558735 | 558735 | 2020-09-22 | Roosevelt | Montana | 30085 | 199 | 1 |
561972 | 561972 | 2020-09-23 | Roosevelt | Montana | 30085 | 213 | 1 |
565213 | 565213 | 2020-09-24 | Roosevelt | Montana | 30085 | 269 | 1 |
568453 | 568453 | 2020-09-25 | Roosevelt | Montana | 30085 | 287 | 4 |
571695 | 571695 | 2020-09-26 | Roosevelt | Montana | 30085 | 336 | 4 |
574938 | 574938 | 2020-09-27 | Roosevelt | Montana | 30085 | 354 | 4 |
578179 | 578179 | 2020-09-28 | Roosevelt | Montana | 30085 | 383 | 4 |
581420 | 581420 | 2020-09-29 | Roosevelt | Montana | 30085 | 384 | 4 |
584661 | 584661 | 2020-09-30 | Roosevelt | Montana | 30085 | 394 | 5 |
587901 | 587901 | 2020-10-01 | Roosevelt | Montana | 30085 | 407 | 4 |
591142 | 591142 | 2020-10-02 | Roosevelt | Montana | 30085 | 416 | 7 |
594383 | 594383 | 2020-10-03 | Roosevelt | Montana | 30085 | 417 | 7 |
597624 | 597624 | 2020-10-04 | Roosevelt | Montana | 30085 | 414 | 7 |
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);