ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Cheatham" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4280 | 4280 | 2020-03-18 | Cheatham | Tennessee | 47021 | 1 | 0 |
5025 | 5025 | 2020-03-19 | Cheatham | Tennessee | 47021 | 1 | 0 |
5909 | 5909 | 2020-03-20 | Cheatham | Tennessee | 47021 | 2 | 0 |
6920 | 6920 | 2020-03-21 | Cheatham | Tennessee | 47021 | 2 | 0 |
8042 | 8042 | 2020-03-22 | Cheatham | Tennessee | 47021 | 4 | 0 |
9260 | 9260 | 2020-03-23 | Cheatham | Tennessee | 47021 | 4 | 0 |
10587 | 10587 | 2020-03-24 | Cheatham | Tennessee | 47021 | 5 | 0 |
12064 | 12064 | 2020-03-25 | Cheatham | Tennessee | 47021 | 7 | 0 |
13688 | 13688 | 2020-03-26 | Cheatham | Tennessee | 47021 | 7 | 0 |
15440 | 15440 | 2020-03-27 | Cheatham | Tennessee | 47021 | 7 | 0 |
17301 | 17301 | 2020-03-28 | Cheatham | Tennessee | 47021 | 7 | 0 |
19246 | 19246 | 2020-03-29 | Cheatham | Tennessee | 47021 | 8 | 0 |
21299 | 21299 | 2020-03-30 | Cheatham | Tennessee | 47021 | 8 | 0 |
23437 | 23437 | 2020-03-31 | Cheatham | Tennessee | 47021 | 10 | 0 |
25635 | 25635 | 2020-04-01 | Cheatham | Tennessee | 47021 | 11 | 0 |
27913 | 27913 | 2020-04-02 | Cheatham | Tennessee | 47021 | 11 | 0 |
30248 | 30248 | 2020-04-03 | Cheatham | Tennessee | 47021 | 11 | 0 |
32639 | 32639 | 2020-04-04 | Cheatham | Tennessee | 47021 | 12 | 0 |
35075 | 35075 | 2020-04-05 | Cheatham | Tennessee | 47021 | 13 | 0 |
37551 | 37551 | 2020-04-06 | Cheatham | Tennessee | 47021 | 13 | 0 |
40074 | 40074 | 2020-04-07 | Cheatham | Tennessee | 47021 | 13 | 0 |
42635 | 42635 | 2020-04-08 | Cheatham | Tennessee | 47021 | 13 | 0 |
45222 | 45222 | 2020-04-09 | Cheatham | Tennessee | 47021 | 15 | 0 |
47840 | 47840 | 2020-04-10 | Cheatham | Tennessee | 47021 | 17 | 0 |
50498 | 50498 | 2020-04-11 | Cheatham | Tennessee | 47021 | 17 | 0 |
53173 | 53173 | 2020-04-12 | Cheatham | Tennessee | 47021 | 17 | 0 |
55859 | 55859 | 2020-04-13 | Cheatham | Tennessee | 47021 | 18 | 0 |
58562 | 58562 | 2020-04-14 | Cheatham | Tennessee | 47021 | 19 | 0 |
61277 | 61277 | 2020-04-15 | Cheatham | Tennessee | 47021 | 19 | 0 |
64004 | 64004 | 2020-04-16 | Cheatham | Tennessee | 47021 | 20 | 0 |
66750 | 66750 | 2020-04-17 | Cheatham | Tennessee | 47021 | 21 | 0 |
69508 | 69508 | 2020-04-18 | Cheatham | Tennessee | 47021 | 22 | 0 |
72275 | 72275 | 2020-04-19 | Cheatham | Tennessee | 47021 | 22 | 0 |
75050 | 75050 | 2020-04-20 | Cheatham | Tennessee | 47021 | 22 | 0 |
77832 | 77832 | 2020-04-21 | Cheatham | Tennessee | 47021 | 22 | 0 |
80622 | 80622 | 2020-04-22 | Cheatham | Tennessee | 47021 | 26 | 0 |
83421 | 83421 | 2020-04-23 | Cheatham | Tennessee | 47021 | 28 | 0 |
86226 | 86226 | 2020-04-24 | Cheatham | Tennessee | 47021 | 32 | 0 |
89041 | 89041 | 2020-04-25 | Cheatham | Tennessee | 47021 | 36 | 0 |
91858 | 91858 | 2020-04-26 | Cheatham | Tennessee | 47021 | 36 | 0 |
94686 | 94686 | 2020-04-27 | Cheatham | Tennessee | 47021 | 39 | 0 |
97526 | 97526 | 2020-04-28 | Cheatham | Tennessee | 47021 | 42 | 0 |
100376 | 100376 | 2020-04-29 | Cheatham | Tennessee | 47021 | 42 | 0 |
103229 | 103229 | 2020-04-30 | Cheatham | Tennessee | 47021 | 46 | 0 |
106092 | 106092 | 2020-05-01 | Cheatham | Tennessee | 47021 | 48 | 0 |
108959 | 108959 | 2020-05-02 | Cheatham | Tennessee | 47021 | 48 | 0 |
111833 | 111833 | 2020-05-03 | Cheatham | Tennessee | 47021 | 53 | 0 |
114715 | 114715 | 2020-05-04 | Cheatham | Tennessee | 47021 | 56 | 0 |
117671 | 117671 | 2020-05-05 | Cheatham | Tennessee | 47021 | 57 | 0 |
120635 | 120635 | 2020-05-06 | Cheatham | Tennessee | 47021 | 58 | 0 |
123613 | 123613 | 2020-05-07 | Cheatham | Tennessee | 47021 | 58 | 0 |
126596 | 126596 | 2020-05-08 | Cheatham | Tennessee | 47021 | 59 | 0 |
129585 | 129585 | 2020-05-09 | Cheatham | Tennessee | 47021 | 61 | 0 |
132574 | 132574 | 2020-05-10 | Cheatham | Tennessee | 47021 | 63 | 0 |
135565 | 135565 | 2020-05-11 | Cheatham | Tennessee | 47021 | 66 | 0 |
138555 | 138555 | 2020-05-12 | Cheatham | Tennessee | 47021 | 76 | 0 |
141551 | 141551 | 2020-05-13 | Cheatham | Tennessee | 47021 | 78 | 0 |
144548 | 144548 | 2020-05-14 | Cheatham | Tennessee | 47021 | 85 | 0 |
147549 | 147549 | 2020-05-15 | Cheatham | Tennessee | 47021 | 88 | 0 |
150557 | 150557 | 2020-05-16 | Cheatham | Tennessee | 47021 | 88 | 0 |
153568 | 153568 | 2020-05-17 | Cheatham | Tennessee | 47021 | 88 | 0 |
156585 | 156585 | 2020-05-18 | Cheatham | Tennessee | 47021 | 92 | 0 |
159606 | 159606 | 2020-05-19 | Cheatham | Tennessee | 47021 | 93 | 0 |
162633 | 162633 | 2020-05-20 | Cheatham | Tennessee | 47021 | 93 | 0 |
165662 | 165662 | 2020-05-21 | Cheatham | Tennessee | 47021 | 97 | 0 |
168698 | 168698 | 2020-05-22 | Cheatham | Tennessee | 47021 | 100 | 0 |
171737 | 171737 | 2020-05-23 | Cheatham | Tennessee | 47021 | 103 | 0 |
174780 | 174780 | 2020-05-24 | Cheatham | Tennessee | 47021 | 104 | 0 |
177824 | 177824 | 2020-05-25 | Cheatham | Tennessee | 47021 | 110 | 0 |
180867 | 180867 | 2020-05-26 | Cheatham | Tennessee | 47021 | 112 | 0 |
183917 | 183917 | 2020-05-27 | Cheatham | Tennessee | 47021 | 114 | 0 |
186974 | 186974 | 2020-05-28 | Cheatham | Tennessee | 47021 | 118 | 0 |
190038 | 190038 | 2020-05-29 | Cheatham | Tennessee | 47021 | 116 | 0 |
193103 | 193103 | 2020-05-30 | Cheatham | Tennessee | 47021 | 123 | 0 |
196173 | 196173 | 2020-05-31 | Cheatham | Tennessee | 47021 | 123 | 0 |
199246 | 199246 | 2020-06-01 | Cheatham | Tennessee | 47021 | 123 | 0 |
202321 | 202321 | 2020-06-02 | Cheatham | Tennessee | 47021 | 134 | 0 |
205400 | 205400 | 2020-06-03 | Cheatham | Tennessee | 47021 | 135 | 0 |
208482 | 208482 | 2020-06-04 | Cheatham | Tennessee | 47021 | 135 | 0 |
211564 | 211564 | 2020-06-05 | Cheatham | Tennessee | 47021 | 140 | 0 |
214651 | 214651 | 2020-06-06 | Cheatham | Tennessee | 47021 | 141 | 0 |
217741 | 217741 | 2020-06-07 | Cheatham | Tennessee | 47021 | 143 | 0 |
220833 | 220833 | 2020-06-08 | Cheatham | Tennessee | 47021 | 144 | 0 |
223928 | 223928 | 2020-06-09 | Cheatham | Tennessee | 47021 | 146 | 0 |
227028 | 227028 | 2020-06-10 | Cheatham | Tennessee | 47021 | 149 | 0 |
230132 | 230132 | 2020-06-11 | Cheatham | Tennessee | 47021 | 151 | 0 |
233237 | 233237 | 2020-06-12 | Cheatham | Tennessee | 47021 | 152 | 0 |
236343 | 236343 | 2020-06-13 | Cheatham | Tennessee | 47021 | 153 | 0 |
239451 | 239451 | 2020-06-14 | Cheatham | Tennessee | 47021 | 153 | 0 |
242561 | 242561 | 2020-06-15 | Cheatham | Tennessee | 47021 | 155 | 0 |
245673 | 245673 | 2020-06-16 | Cheatham | Tennessee | 47021 | 158 | 0 |
248786 | 248786 | 2020-06-17 | Cheatham | Tennessee | 47021 | 159 | 0 |
251901 | 251901 | 2020-06-18 | Cheatham | Tennessee | 47021 | 161 | 0 |
255016 | 255016 | 2020-06-19 | Cheatham | Tennessee | 47021 | 164 | 0 |
258142 | 258142 | 2020-06-20 | Cheatham | Tennessee | 47021 | 164 | 0 |
261269 | 261269 | 2020-06-21 | Cheatham | Tennessee | 47021 | 165 | 0 |
264397 | 264397 | 2020-06-22 | Cheatham | Tennessee | 47021 | 167 | 0 |
267525 | 267525 | 2020-06-23 | Cheatham | Tennessee | 47021 | 175 | 0 |
270659 | 270659 | 2020-06-24 | Cheatham | Tennessee | 47021 | 177 | 0 |
273798 | 273798 | 2020-06-25 | Cheatham | Tennessee | 47021 | 187 | 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);