ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Montgomery" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637472 | 637472 | 2020-10-16 | Montgomery | Tennessee | 47125 | 3691 | 51 |
634226 | 634226 | 2020-10-15 | Montgomery | Tennessee | 47125 | 3678 | 51 |
630981 | 630981 | 2020-10-14 | Montgomery | Tennessee | 47125 | 3623 | 50 |
627737 | 627737 | 2020-10-13 | Montgomery | Tennessee | 47125 | 3592 | 50 |
624495 | 624495 | 2020-10-12 | Montgomery | Tennessee | 47125 | 3575 | 49 |
621252 | 621252 | 2020-10-11 | Montgomery | Tennessee | 47125 | 3491 | 49 |
618009 | 618009 | 2020-10-10 | Montgomery | Tennessee | 47125 | 3468 | 48 |
614767 | 614767 | 2020-10-09 | Montgomery | Tennessee | 47125 | 3417 | 48 |
611526 | 611526 | 2020-10-08 | Montgomery | Tennessee | 47125 | 3384 | 47 |
608284 | 608284 | 2020-10-07 | Montgomery | Tennessee | 47125 | 3358 | 46 |
605041 | 605041 | 2020-10-06 | Montgomery | Tennessee | 47125 | 3321 | 46 |
601799 | 601799 | 2020-10-05 | Montgomery | Tennessee | 47125 | 3292 | 46 |
598556 | 598556 | 2020-10-04 | Montgomery | Tennessee | 47125 | 3235 | 46 |
595313 | 595313 | 2020-10-03 | Montgomery | Tennessee | 47125 | 3212 | 46 |
592072 | 592072 | 2020-10-02 | Montgomery | Tennessee | 47125 | 3205 | 46 |
588831 | 588831 | 2020-10-01 | Montgomery | Tennessee | 47125 | 3178 | 46 |
585591 | 585591 | 2020-09-30 | Montgomery | Tennessee | 47125 | 3174 | 46 |
582351 | 582351 | 2020-09-29 | Montgomery | Tennessee | 47125 | 3133 | 44 |
579111 | 579111 | 2020-09-28 | Montgomery | Tennessee | 47125 | 3123 | 44 |
575870 | 575870 | 2020-09-27 | Montgomery | Tennessee | 47125 | 3111 | 44 |
572626 | 572626 | 2020-09-26 | Montgomery | Tennessee | 47125 | 3070 | 44 |
569384 | 569384 | 2020-09-25 | Montgomery | Tennessee | 47125 | 3045 | 44 |
566143 | 566143 | 2020-09-24 | Montgomery | Tennessee | 47125 | 3022 | 44 |
562902 | 562902 | 2020-09-23 | Montgomery | Tennessee | 47125 | 3015 | 43 |
559665 | 559665 | 2020-09-22 | Montgomery | Tennessee | 47125 | 2971 | 43 |
556428 | 556428 | 2020-09-21 | Montgomery | Tennessee | 47125 | 2962 | 43 |
553191 | 553191 | 2020-09-20 | Montgomery | Tennessee | 47125 | 2952 | 43 |
549952 | 549952 | 2020-09-19 | Montgomery | Tennessee | 47125 | 2922 | 43 |
546713 | 546713 | 2020-09-18 | Montgomery | Tennessee | 47125 | 2918 | 41 |
543476 | 543476 | 2020-09-17 | Montgomery | Tennessee | 47125 | 2887 | 41 |
540240 | 540240 | 2020-09-16 | Montgomery | Tennessee | 47125 | 2870 | 41 |
537003 | 537003 | 2020-09-15 | Montgomery | Tennessee | 47125 | 2833 | 41 |
533767 | 533767 | 2020-09-14 | Montgomery | Tennessee | 47125 | 2826 | 40 |
530532 | 530532 | 2020-09-13 | Montgomery | Tennessee | 47125 | 2790 | 39 |
527295 | 527295 | 2020-09-12 | Montgomery | Tennessee | 47125 | 2761 | 39 |
524059 | 524059 | 2020-09-11 | Montgomery | Tennessee | 47125 | 2749 | 37 |
520823 | 520823 | 2020-09-10 | Montgomery | Tennessee | 47125 | 2703 | 35 |
517587 | 517587 | 2020-09-09 | Montgomery | Tennessee | 47125 | 2661 | 35 |
514352 | 514352 | 2020-09-08 | Montgomery | Tennessee | 47125 | 2639 | 33 |
511119 | 511119 | 2020-09-07 | Montgomery | Tennessee | 47125 | 2628 | 31 |
507886 | 507886 | 2020-09-06 | Montgomery | Tennessee | 47125 | 2595 | 31 |
504654 | 504654 | 2020-09-05 | Montgomery | Tennessee | 47125 | 2576 | 31 |
501420 | 501420 | 2020-09-04 | Montgomery | Tennessee | 47125 | 2555 | 30 |
498186 | 498186 | 2020-09-03 | Montgomery | Tennessee | 47125 | 2536 | 30 |
494953 | 494953 | 2020-09-02 | Montgomery | Tennessee | 47125 | 2504 | 30 |
491719 | 491719 | 2020-09-01 | Montgomery | Tennessee | 47125 | 2494 | 30 |
488486 | 488486 | 2020-08-31 | Montgomery | Tennessee | 47125 | 2475 | 30 |
485253 | 485253 | 2020-08-30 | Montgomery | Tennessee | 47125 | 2467 | 30 |
482018 | 482018 | 2020-08-29 | Montgomery | Tennessee | 47125 | 2452 | 28 |
478784 | 478784 | 2020-08-28 | Montgomery | Tennessee | 47125 | 2440 | 28 |
475551 | 475551 | 2020-08-27 | Montgomery | Tennessee | 47125 | 2418 | 28 |
472318 | 472318 | 2020-08-26 | Montgomery | Tennessee | 47125 | 2377 | 28 |
469086 | 469086 | 2020-08-25 | Montgomery | Tennessee | 47125 | 2345 | 28 |
465857 | 465857 | 2020-08-24 | Montgomery | Tennessee | 47125 | 2330 | 27 |
462628 | 462628 | 2020-08-23 | Montgomery | Tennessee | 47125 | 2313 | 24 |
459400 | 459400 | 2020-08-22 | Montgomery | Tennessee | 47125 | 2294 | 24 |
456172 | 456172 | 2020-08-21 | Montgomery | Tennessee | 47125 | 2277 | 23 |
452944 | 452944 | 2020-08-20 | Montgomery | Tennessee | 47125 | 2240 | 22 |
449716 | 449716 | 2020-08-19 | Montgomery | Tennessee | 47125 | 2212 | 21 |
446488 | 446488 | 2020-08-18 | Montgomery | Tennessee | 47125 | 2182 | 18 |
443262 | 443262 | 2020-08-17 | Montgomery | Tennessee | 47125 | 2169 | 16 |
440035 | 440035 | 2020-08-16 | Montgomery | Tennessee | 47125 | 2150 | 16 |
436810 | 436810 | 2020-08-15 | Montgomery | Tennessee | 47125 | 2118 | 16 |
433583 | 433583 | 2020-08-14 | Montgomery | Tennessee | 47125 | 2085 | 15 |
430358 | 430358 | 2020-08-13 | Montgomery | Tennessee | 47125 | 2041 | 15 |
427131 | 427131 | 2020-08-12 | Montgomery | Tennessee | 47125 | 2015 | 14 |
423908 | 423908 | 2020-08-11 | Montgomery | Tennessee | 47125 | 1986 | 14 |
420686 | 420686 | 2020-08-10 | Montgomery | Tennessee | 47125 | 1952 | 13 |
417465 | 417465 | 2020-08-09 | Montgomery | Tennessee | 47125 | 1939 | 13 |
414244 | 414244 | 2020-08-08 | Montgomery | Tennessee | 47125 | 1902 | 13 |
411024 | 411024 | 2020-08-07 | Montgomery | Tennessee | 47125 | 1883 | 13 |
407805 | 407805 | 2020-08-06 | Montgomery | Tennessee | 47125 | 1815 | 13 |
404585 | 404585 | 2020-08-05 | Montgomery | Tennessee | 47125 | 1781 | 13 |
401367 | 401367 | 2020-08-04 | Montgomery | Tennessee | 47125 | 1752 | 12 |
398152 | 398152 | 2020-08-03 | Montgomery | Tennessee | 47125 | 1734 | 11 |
394935 | 394935 | 2020-08-02 | Montgomery | Tennessee | 47125 | 1711 | 11 |
391719 | 391719 | 2020-08-01 | Montgomery | Tennessee | 47125 | 1677 | 11 |
388502 | 388502 | 2020-07-31 | Montgomery | Tennessee | 47125 | 1646 | 11 |
385285 | 385285 | 2020-07-30 | Montgomery | Tennessee | 47125 | 1568 | 11 |
382067 | 382067 | 2020-07-29 | Montgomery | Tennessee | 47125 | 1524 | 10 |
378850 | 378850 | 2020-07-28 | Montgomery | Tennessee | 47125 | 1482 | 9 |
375634 | 375634 | 2020-07-27 | Montgomery | Tennessee | 47125 | 1455 | 9 |
372421 | 372421 | 2020-07-26 | Montgomery | Tennessee | 47125 | 1439 | 9 |
369209 | 369209 | 2020-07-25 | Montgomery | Tennessee | 47125 | 1350 | 9 |
366000 | 366000 | 2020-07-24 | Montgomery | Tennessee | 47125 | 1325 | 9 |
362794 | 362794 | 2020-07-23 | Montgomery | Tennessee | 47125 | 1288 | 9 |
359587 | 359587 | 2020-07-22 | Montgomery | Tennessee | 47125 | 1222 | 9 |
356383 | 356383 | 2020-07-21 | Montgomery | Tennessee | 47125 | 1196 | 9 |
353180 | 353180 | 2020-07-20 | Montgomery | Tennessee | 47125 | 1173 | 8 |
349977 | 349977 | 2020-07-19 | Montgomery | Tennessee | 47125 | 1157 | 8 |
346777 | 346777 | 2020-07-18 | Montgomery | Tennessee | 47125 | 1133 | 8 |
343577 | 343577 | 2020-07-17 | Montgomery | Tennessee | 47125 | 1065 | 8 |
340379 | 340379 | 2020-07-16 | Montgomery | Tennessee | 47125 | 974 | 7 |
337182 | 337182 | 2020-07-15 | Montgomery | Tennessee | 47125 | 906 | 7 |
333988 | 333988 | 2020-07-14 | Montgomery | Tennessee | 47125 | 850 | 7 |
330796 | 330796 | 2020-07-13 | Montgomery | Tennessee | 47125 | 824 | 7 |
327610 | 327610 | 2020-07-12 | Montgomery | Tennessee | 47125 | 778 | 7 |
324425 | 324425 | 2020-07-11 | Montgomery | Tennessee | 47125 | 732 | 7 |
321244 | 321244 | 2020-07-10 | Montgomery | Tennessee | 47125 | 712 | 7 |
318066 | 318066 | 2020-07-09 | Montgomery | Tennessee | 47125 | 658 | 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);