ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where "date" is on date 2021-02-24 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1062523 | 1062523 | 2021-02-24 | Anderson | Tennessee | 47001 | 7893 | 155 |
1062524 | 1062524 | 2021-02-24 | Bedford | Tennessee | 47003 | 5756 | 117 |
1062525 | 1062525 | 2021-02-24 | Benton | Tennessee | 47005 | 1499 | 39 |
1062526 | 1062526 | 2021-02-24 | Bledsoe | Tennessee | 47007 | 1982 | 10 |
1062527 | 1062527 | 2021-02-24 | Blount | Tennessee | 47009 | 13929 | 178 |
1062528 | 1062528 | 2021-02-24 | Bradley | Tennessee | 47011 | 12734 | 138 |
1062529 | 1062529 | 2021-02-24 | Campbell | Tennessee | 47013 | 3781 | 58 |
1062530 | 1062530 | 2021-02-24 | Cannon | Tennessee | 47015 | 1736 | 28 |
1062531 | 1062531 | 2021-02-24 | Carroll | Tennessee | 47017 | 3468 | 81 |
1062532 | 1062532 | 2021-02-24 | Carter | Tennessee | 47019 | 5926 | 152 |
1062533 | 1062533 | 2021-02-24 | Cheatham | Tennessee | 47021 | 3857 | 43 |
1062534 | 1062534 | 2021-02-24 | Chester | Tennessee | 47023 | 2006 | 47 |
1062535 | 1062535 | 2021-02-24 | Claiborne | Tennessee | 47025 | 2736 | 66 |
1062536 | 1062536 | 2021-02-24 | Clay | Tennessee | 47027 | 1062 | 30 |
1062537 | 1062537 | 2021-02-24 | Cocke | Tennessee | 47029 | 3961 | 92 |
1062538 | 1062538 | 2021-02-24 | Coffee | Tennessee | 47031 | 6264 | 114 |
1062539 | 1062539 | 2021-02-24 | Crockett | Tennessee | 47033 | 1969 | 46 |
1062540 | 1062540 | 2021-02-24 | Cumberland | Tennessee | 47035 | 6072 | 117 |
1062541 | 1062541 | 2021-02-24 | Davidson | Tennessee | 47037 | 89086 | 841 |
1062542 | 1062542 | 2021-02-24 | DeKalb | Tennessee | 47041 | 2615 | 48 |
1062543 | 1062543 | 2021-02-24 | Decatur | Tennessee | 47039 | 1531 | 37 |
1062544 | 1062544 | 2021-02-24 | Dickson | Tennessee | 47043 | 6148 | 103 |
1062545 | 1062545 | 2021-02-24 | Dyer | Tennessee | 47045 | 5222 | 101 |
1062546 | 1062546 | 2021-02-24 | Fayette | Tennessee | 47047 | 4637 | 71 |
1062547 | 1062547 | 2021-02-24 | Fentress | Tennessee | 47049 | 2283 | 44 |
1062548 | 1062548 | 2021-02-24 | Franklin | Tennessee | 47051 | 4706 | 84 |
1062549 | 1062549 | 2021-02-24 | Gibson | Tennessee | 47053 | 6168 | 140 |
1062550 | 1062550 | 2021-02-24 | Giles | Tennessee | 47055 | 3710 | 95 |
1062551 | 1062551 | 2021-02-24 | Grainger | Tennessee | 47057 | 2407 | 46 |
1062552 | 1062552 | 2021-02-24 | Greene | Tennessee | 47059 | 7258 | 144 |
1062553 | 1062553 | 2021-02-24 | Grundy | Tennessee | 47061 | 1663 | 30 |
1062554 | 1062554 | 2021-02-24 | Hamblen | Tennessee | 47063 | 7958 | 161 |
1062555 | 1062555 | 2021-02-24 | Hamilton | Tennessee | 47065 | 40314 | 456 |
1062556 | 1062556 | 2021-02-24 | Hancock | Tennessee | 47067 | 493 | 12 |
1062557 | 1062557 | 2021-02-24 | Hardeman | Tennessee | 47069 | 3376 | 63 |
1062558 | 1062558 | 2021-02-24 | Hardin | Tennessee | 47071 | 3297 | 62 |
1062559 | 1062559 | 2021-02-24 | Hawkins | Tennessee | 47073 | 5187 | 93 |
1062560 | 1062560 | 2021-02-24 | Haywood | Tennessee | 47075 | 2643 | 59 |
1062561 | 1062561 | 2021-02-24 | Henderson | Tennessee | 47077 | 3611 | 73 |
1062562 | 1062562 | 2021-02-24 | Henry | Tennessee | 47079 | 2989 | 75 |
1062563 | 1062563 | 2021-02-24 | Hickman | Tennessee | 47081 | 2628 | 40 |
1062564 | 1062564 | 2021-02-24 | Houston | Tennessee | 47083 | 1023 | 30 |
1062565 | 1062565 | 2021-02-24 | Humphreys | Tennessee | 47085 | 1513 | 21 |
1062566 | 1062566 | 2021-02-24 | Jackson | Tennessee | 47087 | 1248 | 34 |
1062567 | 1062567 | 2021-02-24 | Jefferson | Tennessee | 47089 | 5580 | 116 |
1062568 | 1062568 | 2021-02-24 | Johnson | Tennessee | 47091 | 2150 | 38 |
1062569 | 1062569 | 2021-02-24 | Knox | Tennessee | 47093 | 46377 | 571 |
1062570 | 1062570 | 2021-02-24 | Lake | Tennessee | 47095 | 1673 | 26 |
1062571 | 1062571 | 2021-02-24 | Lauderdale | Tennessee | 47097 | 3093 | 42 |
1062572 | 1062572 | 2021-02-24 | Lawrence | Tennessee | 47099 | 5546 | 81 |
1062573 | 1062573 | 2021-02-24 | Lewis | Tennessee | 47101 | 1457 | 24 |
1062574 | 1062574 | 2021-02-24 | Lincoln | Tennessee | 47103 | 4105 | 61 |
1062575 | 1062575 | 2021-02-24 | Loudon | Tennessee | 47105 | 5631 | 64 |
1062576 | 1062576 | 2021-02-24 | Macon | Tennessee | 47111 | 3350 | 73 |
1062577 | 1062577 | 2021-02-24 | Madison | Tennessee | 47113 | 10049 | 226 |
1062578 | 1062578 | 2021-02-24 | Marion | Tennessee | 47115 | 2902 | 44 |
1062579 | 1062579 | 2021-02-24 | Marshall | Tennessee | 47117 | 3883 | 54 |
1062580 | 1062580 | 2021-02-24 | Maury | Tennessee | 47119 | 12141 | 159 |
1062581 | 1062581 | 2021-02-24 | McMinn | Tennessee | 47107 | 5862 | 89 |
1062582 | 1062582 | 2021-02-24 | McNairy | Tennessee | 47109 | 2650 | 51 |
1062583 | 1062583 | 2021-02-24 | Meigs | Tennessee | 47121 | 1254 | 21 |
1062584 | 1062584 | 2021-02-24 | Monroe | Tennessee | 47123 | 5263 | 89 |
1062585 | 1062585 | 2021-02-24 | Montgomery | Tennessee | 47125 | 17207 | 207 |
1062586 | 1062586 | 2021-02-24 | Moore | Tennessee | 47127 | 936 | 16 |
1062587 | 1062587 | 2021-02-24 | Morgan | Tennessee | 47129 | 2285 | 37 |
1062588 | 1062588 | 2021-02-24 | Obion | Tennessee | 47131 | 4357 | 94 |
1062589 | 1062589 | 2021-02-24 | Overton | Tennessee | 47133 | 2837 | 57 |
1062590 | 1062590 | 2021-02-24 | Perry | Tennessee | 47135 | 1025 | 27 |
1062591 | 1062591 | 2021-02-24 | Pickett | Tennessee | 47137 | 747 | 23 |
1062592 | 1062592 | 2021-02-24 | Polk | Tennessee | 47139 | 1736 | 21 |
1062593 | 1062593 | 2021-02-24 | Putnam | Tennessee | 47141 | 10537 | 168 |
1062594 | 1062594 | 2021-02-24 | Rhea | Tennessee | 47143 | 4117 | 73 |
1062595 | 1062595 | 2021-02-24 | Roane | Tennessee | 47145 | 5817 | 95 |
1062596 | 1062596 | 2021-02-24 | Robertson | Tennessee | 47147 | 8886 | 118 |
1062597 | 1062597 | 2021-02-24 | Rutherford | Tennessee | 47149 | 37906 | 375 |
1062598 | 1062598 | 2021-02-24 | Scott | Tennessee | 47151 | 2850 | 42 |
1062599 | 1062599 | 2021-02-24 | Sequatchie | Tennessee | 47153 | 1539 | 27 |
1062600 | 1062600 | 2021-02-24 | Sevier | Tennessee | 47155 | 11889 | 161 |
1062601 | 1062601 | 2021-02-24 | Shelby | Tennessee | 47157 | 87449 | 1479 |
1062602 | 1062602 | 2021-02-24 | Smith | Tennessee | 47159 | 2533 | 36 |
1062603 | 1062603 | 2021-02-24 | Stewart | Tennessee | 47161 | 1231 | 24 |
1062604 | 1062604 | 2021-02-24 | Sullivan | Tennessee | 47163 | 14169 | 273 |
1062605 | 1062605 | 2021-02-24 | Sumner | Tennessee | 47165 | 21166 | 312 |
1062606 | 1062606 | 2021-02-24 | Tipton | Tennessee | 47167 | 6896 | 101 |
1062607 | 1062607 | 2021-02-24 | Trousdale | Tennessee | 47169 | 2379 | 22 |
1062608 | 1062608 | 2021-02-24 | Unicoi | Tennessee | 47171 | 1793 | 47 |
1062609 | 1062609 | 2021-02-24 | Union | Tennessee | 47173 | 1689 | 30 |
1062610 | 1062610 | 2021-02-24 | Unknown | Tennessee | 8407 | 116 | |
1062611 | 1062611 | 2021-02-24 | Van Buren | Tennessee | 47175 | 791 | 20 |
1062612 | 1062612 | 2021-02-24 | Warren | Tennessee | 47177 | 5298 | 75 |
1062613 | 1062613 | 2021-02-24 | Washington | Tennessee | 47179 | 12671 | 231 |
1062614 | 1062614 | 2021-02-24 | Wayne | Tennessee | 47181 | 2864 | 30 |
1062615 | 1062615 | 2021-02-24 | Weakley | Tennessee | 47183 | 3775 | 59 |
1062616 | 1062616 | 2021-02-24 | White | Tennessee | 47185 | 3339 | 65 |
1062617 | 1062617 | 2021-02-24 | Williamson | Tennessee | 47187 | 25011 | 202 |
1062618 | 1062618 | 2021-02-24 | Wilson | Tennessee | 47189 | 16194 | 209 |
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);