ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Yellowstone" and state = "Montana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
260440 | 260440 | 2020-06-21 | Yellowstone | Montana | 30111 | 123 | 3 |
263569 | 263569 | 2020-06-22 | Yellowstone | Montana | 30111 | 125 | 4 |
266695 | 266695 | 2020-06-23 | Yellowstone | Montana | 30111 | 126 | 4 |
269829 | 269829 | 2020-06-24 | Yellowstone | Montana | 30111 | 129 | 4 |
272968 | 272968 | 2020-06-25 | Yellowstone | Montana | 30111 | 139 | 4 |
276111 | 276111 | 2020-06-26 | Yellowstone | Montana | 30111 | 144 | 4 |
279259 | 279259 | 2020-06-27 | Yellowstone | Montana | 30111 | 149 | 4 |
282407 | 282407 | 2020-06-28 | Yellowstone | Montana | 30111 | 151 | 4 |
285552 | 285552 | 2020-06-29 | Yellowstone | Montana | 30111 | 165 | 4 |
288702 | 288702 | 2020-06-30 | Yellowstone | Montana | 30111 | 174 | 4 |
291853 | 291853 | 2020-07-01 | Yellowstone | Montana | 30111 | 189 | 4 |
295008 | 295008 | 2020-07-02 | Yellowstone | Montana | 30111 | 203 | 4 |
298167 | 298167 | 2020-07-03 | Yellowstone | Montana | 30111 | 226 | 4 |
301330 | 301330 | 2020-07-04 | Yellowstone | Montana | 30111 | 245 | 4 |
304494 | 304494 | 2020-07-05 | Yellowstone | Montana | 30111 | 261 | 4 |
307661 | 307661 | 2020-07-06 | Yellowstone | Montana | 30111 | 270 | 4 |
310829 | 310829 | 2020-07-07 | Yellowstone | Montana | 30111 | 325 | 4 |
314000 | 314000 | 2020-07-08 | Yellowstone | Montana | 30111 | 330 | 4 |
317174 | 317174 | 2020-07-09 | Yellowstone | Montana | 30111 | 377 | 6 |
320349 | 320349 | 2020-07-10 | Yellowstone | Montana | 30111 | 431 | 9 |
323528 | 323528 | 2020-07-11 | Yellowstone | Montana | 30111 | 435 | 9 |
326712 | 326712 | 2020-07-12 | Yellowstone | Montana | 30111 | 489 | 9 |
329899 | 329899 | 2020-07-13 | Yellowstone | Montana | 30111 | 525 | 11 |
333088 | 333088 | 2020-07-14 | Yellowstone | Montana | 30111 | 557 | 13 |
336282 | 336282 | 2020-07-15 | Yellowstone | Montana | 30111 | 584 | 13 |
339479 | 339479 | 2020-07-16 | Yellowstone | Montana | 30111 | 629 | 14 |
342675 | 342675 | 2020-07-17 | Yellowstone | Montana | 30111 | 652 | 15 |
345875 | 345875 | 2020-07-18 | Yellowstone | Montana | 30111 | 682 | 15 |
349076 | 349076 | 2020-07-19 | Yellowstone | Montana | 30111 | 702 | 15 |
352277 | 352277 | 2020-07-20 | Yellowstone | Montana | 30111 | 717 | 17 |
355480 | 355480 | 2020-07-21 | Yellowstone | Montana | 30111 | 731 | 18 |
358684 | 358684 | 2020-07-22 | Yellowstone | Montana | 30111 | 756 | 19 |
361890 | 361890 | 2020-07-23 | Yellowstone | Montana | 30111 | 780 | 20 |
365097 | 365097 | 2020-07-24 | Yellowstone | Montana | 30111 | 820 | 21 |
368306 | 368306 | 2020-07-25 | Yellowstone | Montana | 30111 | 843 | 21 |
371517 | 371517 | 2020-07-26 | Yellowstone | Montana | 30111 | 872 | 21 |
374729 | 374729 | 2020-07-27 | Yellowstone | Montana | 30111 | 893 | 22 |
377944 | 377944 | 2020-07-28 | Yellowstone | Montana | 30111 | 910 | 23 |
381162 | 381162 | 2020-07-29 | Yellowstone | Montana | 30111 | 950 | 25 |
384378 | 384378 | 2020-07-30 | Yellowstone | Montana | 30111 | 983 | 25 |
387596 | 387596 | 2020-07-31 | Yellowstone | Montana | 30111 | 1022 | 26 |
390813 | 390813 | 2020-08-01 | Yellowstone | Montana | 30111 | 1048 | 26 |
394030 | 394030 | 2020-08-02 | Yellowstone | Montana | 30111 | 1098 | 26 |
397246 | 397246 | 2020-08-03 | Yellowstone | Montana | 30111 | 1110 | 27 |
400461 | 400461 | 2020-08-04 | Yellowstone | Montana | 30111 | 1118 | 27 |
403679 | 403679 | 2020-08-05 | Yellowstone | Montana | 30111 | 1144 | 27 |
406897 | 406897 | 2020-08-06 | Yellowstone | Montana | 30111 | 1191 | 28 |
410117 | 410117 | 2020-08-07 | Yellowstone | Montana | 30111 | 1212 | 28 |
413337 | 413337 | 2020-08-08 | Yellowstone | Montana | 30111 | 1261 | 30 |
416557 | 416557 | 2020-08-09 | Yellowstone | Montana | 30111 | 1285 | 30 |
419778 | 419778 | 2020-08-10 | Yellowstone | Montana | 30111 | 1295 | 30 |
423001 | 423001 | 2020-08-11 | Yellowstone | Montana | 30111 | 1316 | 30 |
426223 | 426223 | 2020-08-12 | Yellowstone | Montana | 30111 | 1387 | 31 |
429447 | 429447 | 2020-08-13 | Yellowstone | Montana | 30111 | 1424 | 32 |
432674 | 432674 | 2020-08-14 | Yellowstone | Montana | 30111 | 1463 | 32 |
435900 | 435900 | 2020-08-15 | Yellowstone | Montana | 30111 | 1487 | 32 |
439125 | 439125 | 2020-08-16 | Yellowstone | Montana | 30111 | 1522 | 32 |
442352 | 442352 | 2020-08-17 | Yellowstone | Montana | 30111 | 1533 | 32 |
445578 | 445578 | 2020-08-18 | Yellowstone | Montana | 30111 | 1539 | 32 |
448804 | 448804 | 2020-08-19 | Yellowstone | Montana | 30111 | 1595 | 32 |
452032 | 452032 | 2020-08-20 | Yellowstone | Montana | 30111 | 1637 | 34 |
455260 | 455260 | 2020-08-21 | Yellowstone | Montana | 30111 | 1689 | 34 |
458488 | 458488 | 2020-08-22 | Yellowstone | Montana | 30111 | 1773 | 35 |
461715 | 461715 | 2020-08-23 | Yellowstone | Montana | 30111 | 1792 | 35 |
464946 | 464946 | 2020-08-24 | Yellowstone | Montana | 30111 | 1797 | 36 |
468175 | 468175 | 2020-08-25 | Yellowstone | Montana | 30111 | 1816 | 41 |
471405 | 471405 | 2020-08-26 | Yellowstone | Montana | 30111 | 1864 | 41 |
474637 | 474637 | 2020-08-27 | Yellowstone | Montana | 30111 | 1906 | 41 |
477870 | 477870 | 2020-08-28 | Yellowstone | Montana | 30111 | 1958 | 42 |
481102 | 481102 | 2020-08-29 | Yellowstone | Montana | 30111 | 2012 | 43 |
484337 | 484337 | 2020-08-30 | Yellowstone | Montana | 30111 | 2053 | 43 |
487571 | 487571 | 2020-08-31 | Yellowstone | Montana | 30111 | 2080 | 43 |
490804 | 490804 | 2020-09-01 | Yellowstone | Montana | 30111 | 2094 | 43 |
494038 | 494038 | 2020-09-02 | Yellowstone | Montana | 30111 | 2166 | 43 |
497271 | 497271 | 2020-09-03 | Yellowstone | Montana | 30111 | 2200 | 45 |
500505 | 500505 | 2020-09-04 | Yellowstone | Montana | 30111 | 2230 | 46 |
503739 | 503739 | 2020-09-05 | Yellowstone | Montana | 30111 | 2239 | 47 |
506972 | 506972 | 2020-09-06 | Yellowstone | Montana | 30111 | 2284 | 48 |
510205 | 510205 | 2020-09-07 | Yellowstone | Montana | 30111 | 2305 | 48 |
513437 | 513437 | 2020-09-08 | Yellowstone | Montana | 30111 | 2310 | 49 |
516671 | 516671 | 2020-09-09 | Yellowstone | Montana | 30111 | 2319 | 50 |
519906 | 519906 | 2020-09-10 | Yellowstone | Montana | 30111 | 2394 | 50 |
523143 | 523143 | 2020-09-11 | Yellowstone | Montana | 30111 | 2427 | 50 |
526379 | 526379 | 2020-09-12 | Yellowstone | Montana | 30111 | 2457 | 51 |
529615 | 529615 | 2020-09-13 | Yellowstone | Montana | 30111 | 2491 | 51 |
532851 | 532851 | 2020-09-14 | Yellowstone | Montana | 30111 | 2518 | 52 |
536086 | 536086 | 2020-09-15 | Yellowstone | Montana | 30111 | 2536 | 54 |
539323 | 539323 | 2020-09-16 | Yellowstone | Montana | 30111 | 2617 | 54 |
542559 | 542559 | 2020-09-17 | Yellowstone | Montana | 30111 | 2677 | 56 |
545796 | 545796 | 2020-09-18 | Yellowstone | Montana | 30111 | 2708 | 56 |
549034 | 549034 | 2020-09-19 | Yellowstone | Montana | 30111 | 2797 | 56 |
552273 | 552273 | 2020-09-20 | Yellowstone | Montana | 30111 | 2841 | 57 |
555511 | 555511 | 2020-09-21 | Yellowstone | Montana | 30111 | 2863 | 59 |
558748 | 558748 | 2020-09-22 | Yellowstone | Montana | 30111 | 2882 | 61 |
561985 | 561985 | 2020-09-23 | Yellowstone | Montana | 30111 | 2927 | 62 |
565226 | 565226 | 2020-09-24 | Yellowstone | Montana | 30111 | 2990 | 62 |
568466 | 568466 | 2020-09-25 | Yellowstone | Montana | 30111 | 3046 | 63 |
571708 | 571708 | 2020-09-26 | Yellowstone | Montana | 30111 | 3121 | 63 |
574951 | 574951 | 2020-09-27 | Yellowstone | Montana | 30111 | 3206 | 64 |
578192 | 578192 | 2020-09-28 | Yellowstone | Montana | 30111 | 3244 | 64 |
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);