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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
5032 | 5032 | 2020-03-19 | Montgomery | Tennessee | 47125 | 1 | 0 |
5920 | 5920 | 2020-03-20 | Montgomery | Tennessee | 47125 | 3 | 0 |
6934 | 6934 | 2020-03-21 | Montgomery | Tennessee | 47125 | 3 | 0 |
8063 | 8063 | 2020-03-22 | Montgomery | Tennessee | 47125 | 3 | 0 |
9281 | 9281 | 2020-03-23 | Montgomery | Tennessee | 47125 | 3 | 0 |
10614 | 10614 | 2020-03-24 | Montgomery | Tennessee | 47125 | 6 | 0 |
12093 | 12093 | 2020-03-25 | Montgomery | Tennessee | 47125 | 6 | 0 |
13719 | 13719 | 2020-03-26 | Montgomery | Tennessee | 47125 | 6 | 0 |
15471 | 15471 | 2020-03-27 | Montgomery | Tennessee | 47125 | 9 | 0 |
17334 | 17334 | 2020-03-28 | Montgomery | Tennessee | 47125 | 11 | 0 |
19283 | 19283 | 2020-03-29 | Montgomery | Tennessee | 47125 | 13 | 0 |
21340 | 21340 | 2020-03-30 | Montgomery | Tennessee | 47125 | 13 | 0 |
23479 | 23479 | 2020-03-31 | Montgomery | Tennessee | 47125 | 19 | 0 |
25681 | 25681 | 2020-04-01 | Montgomery | Tennessee | 47125 | 27 | 0 |
27960 | 27960 | 2020-04-02 | Montgomery | Tennessee | 47125 | 37 | 0 |
30295 | 30295 | 2020-04-03 | Montgomery | Tennessee | 47125 | 41 | 0 |
32686 | 32686 | 2020-04-04 | Montgomery | Tennessee | 47125 | 46 | 0 |
35123 | 35123 | 2020-04-05 | Montgomery | Tennessee | 47125 | 51 | 1 |
37599 | 37599 | 2020-04-06 | Montgomery | Tennessee | 47125 | 54 | 1 |
40122 | 40122 | 2020-04-07 | Montgomery | Tennessee | 47125 | 65 | 2 |
42684 | 42684 | 2020-04-08 | Montgomery | Tennessee | 47125 | 72 | 2 |
45271 | 45271 | 2020-04-09 | Montgomery | Tennessee | 47125 | 79 | 2 |
47889 | 47889 | 2020-04-10 | Montgomery | Tennessee | 47125 | 84 | 2 |
50547 | 50547 | 2020-04-11 | Montgomery | Tennessee | 47125 | 88 | 2 |
53222 | 53222 | 2020-04-12 | Montgomery | Tennessee | 47125 | 88 | 2 |
58612 | 58612 | 2020-04-14 | Montgomery | Tennessee | 47125 | 101 | 2 |
55909 | 55909 | 2020-04-13 | Montgomery | Tennessee | 47125 | 102 | 2 |
61327 | 61327 | 2020-04-15 | Montgomery | Tennessee | 47125 | 102 | 2 |
64054 | 64054 | 2020-04-16 | Montgomery | Tennessee | 47125 | 102 | 2 |
66800 | 66800 | 2020-04-17 | Montgomery | Tennessee | 47125 | 108 | 2 |
69559 | 69559 | 2020-04-18 | Montgomery | Tennessee | 47125 | 113 | 2 |
72326 | 72326 | 2020-04-19 | Montgomery | Tennessee | 47125 | 119 | 2 |
75101 | 75101 | 2020-04-20 | Montgomery | Tennessee | 47125 | 122 | 2 |
77883 | 77883 | 2020-04-21 | Montgomery | Tennessee | 47125 | 124 | 2 |
80673 | 80673 | 2020-04-22 | Montgomery | Tennessee | 47125 | 128 | 2 |
83472 | 83472 | 2020-04-23 | Montgomery | Tennessee | 47125 | 130 | 2 |
86277 | 86277 | 2020-04-24 | Montgomery | Tennessee | 47125 | 132 | 2 |
89092 | 89092 | 2020-04-25 | Montgomery | Tennessee | 47125 | 134 | 2 |
91909 | 91909 | 2020-04-26 | Montgomery | Tennessee | 47125 | 136 | 2 |
94737 | 94737 | 2020-04-27 | Montgomery | Tennessee | 47125 | 138 | 2 |
97577 | 97577 | 2020-04-28 | Montgomery | Tennessee | 47125 | 139 | 2 |
100427 | 100427 | 2020-04-29 | Montgomery | Tennessee | 47125 | 141 | 2 |
103280 | 103280 | 2020-04-30 | Montgomery | Tennessee | 47125 | 146 | 2 |
106143 | 106143 | 2020-05-01 | Montgomery | Tennessee | 47125 | 146 | 2 |
109010 | 109010 | 2020-05-02 | Montgomery | Tennessee | 47125 | 148 | 2 |
111884 | 111884 | 2020-05-03 | Montgomery | Tennessee | 47125 | 148 | 2 |
114766 | 114766 | 2020-05-04 | Montgomery | Tennessee | 47125 | 149 | 2 |
117722 | 117722 | 2020-05-05 | Montgomery | Tennessee | 47125 | 151 | 2 |
120686 | 120686 | 2020-05-06 | Montgomery | Tennessee | 47125 | 153 | 2 |
123664 | 123664 | 2020-05-07 | Montgomery | Tennessee | 47125 | 155 | 2 |
126647 | 126647 | 2020-05-08 | Montgomery | Tennessee | 47125 | 161 | 2 |
129636 | 129636 | 2020-05-09 | Montgomery | Tennessee | 47125 | 172 | 2 |
132625 | 132625 | 2020-05-10 | Montgomery | Tennessee | 47125 | 174 | 2 |
135616 | 135616 | 2020-05-11 | Montgomery | Tennessee | 47125 | 180 | 2 |
138606 | 138606 | 2020-05-12 | Montgomery | Tennessee | 47125 | 188 | 2 |
141602 | 141602 | 2020-05-13 | Montgomery | Tennessee | 47125 | 191 | 2 |
144599 | 144599 | 2020-05-14 | Montgomery | Tennessee | 47125 | 199 | 2 |
147600 | 147600 | 2020-05-15 | Montgomery | Tennessee | 47125 | 203 | 2 |
150608 | 150608 | 2020-05-16 | Montgomery | Tennessee | 47125 | 204 | 2 |
153619 | 153619 | 2020-05-17 | Montgomery | Tennessee | 47125 | 206 | 2 |
156636 | 156636 | 2020-05-18 | Montgomery | Tennessee | 47125 | 213 | 2 |
159658 | 159658 | 2020-05-19 | Montgomery | Tennessee | 47125 | 216 | 2 |
162685 | 162685 | 2020-05-20 | Montgomery | Tennessee | 47125 | 216 | 2 |
165714 | 165714 | 2020-05-21 | Montgomery | Tennessee | 47125 | 217 | 2 |
168750 | 168750 | 2020-05-22 | Montgomery | Tennessee | 47125 | 218 | 3 |
171789 | 171789 | 2020-05-23 | Montgomery | Tennessee | 47125 | 234 | 3 |
174832 | 174832 | 2020-05-24 | Montgomery | Tennessee | 47125 | 240 | 3 |
177876 | 177876 | 2020-05-25 | Montgomery | Tennessee | 47125 | 248 | 3 |
180919 | 180919 | 2020-05-26 | Montgomery | Tennessee | 47125 | 251 | 3 |
183969 | 183969 | 2020-05-27 | Montgomery | Tennessee | 47125 | 258 | 3 |
187026 | 187026 | 2020-05-28 | Montgomery | Tennessee | 47125 | 261 | 3 |
190090 | 190090 | 2020-05-29 | Montgomery | Tennessee | 47125 | 262 | 3 |
193155 | 193155 | 2020-05-30 | Montgomery | Tennessee | 47125 | 269 | 3 |
196225 | 196225 | 2020-05-31 | Montgomery | Tennessee | 47125 | 269 | 3 |
199298 | 199298 | 2020-06-01 | Montgomery | Tennessee | 47125 | 269 | 3 |
202373 | 202373 | 2020-06-02 | Montgomery | Tennessee | 47125 | 277 | 3 |
205452 | 205452 | 2020-06-03 | Montgomery | Tennessee | 47125 | 283 | 3 |
208534 | 208534 | 2020-06-04 | Montgomery | Tennessee | 47125 | 286 | 3 |
211616 | 211616 | 2020-06-05 | Montgomery | Tennessee | 47125 | 287 | 3 |
214703 | 214703 | 2020-06-06 | Montgomery | Tennessee | 47125 | 287 | 3 |
217793 | 217793 | 2020-06-07 | Montgomery | Tennessee | 47125 | 294 | 3 |
220885 | 220885 | 2020-06-08 | Montgomery | Tennessee | 47125 | 301 | 3 |
227080 | 227080 | 2020-06-10 | Montgomery | Tennessee | 47125 | 309 | 4 |
223980 | 223980 | 2020-06-09 | Montgomery | Tennessee | 47125 | 310 | 4 |
230184 | 230184 | 2020-06-11 | Montgomery | Tennessee | 47125 | 312 | 4 |
233289 | 233289 | 2020-06-12 | Montgomery | Tennessee | 47125 | 319 | 5 |
236395 | 236395 | 2020-06-13 | Montgomery | Tennessee | 47125 | 324 | 5 |
239503 | 239503 | 2020-06-14 | Montgomery | Tennessee | 47125 | 332 | 5 |
242613 | 242613 | 2020-06-15 | Montgomery | Tennessee | 47125 | 339 | 5 |
245725 | 245725 | 2020-06-16 | Montgomery | Tennessee | 47125 | 341 | 5 |
248838 | 248838 | 2020-06-17 | Montgomery | Tennessee | 47125 | 341 | 5 |
251953 | 251953 | 2020-06-18 | Montgomery | Tennessee | 47125 | 356 | 5 |
255068 | 255068 | 2020-06-19 | Montgomery | Tennessee | 47125 | 363 | 5 |
258194 | 258194 | 2020-06-20 | Montgomery | Tennessee | 47125 | 368 | 5 |
261321 | 261321 | 2020-06-21 | Montgomery | Tennessee | 47125 | 384 | 5 |
264449 | 264449 | 2020-06-22 | Montgomery | Tennessee | 47125 | 385 | 5 |
267577 | 267577 | 2020-06-23 | Montgomery | Tennessee | 47125 | 392 | 5 |
270711 | 270711 | 2020-06-24 | Montgomery | Tennessee | 47125 | 407 | 6 |
273850 | 273850 | 2020-06-25 | Montgomery | Tennessee | 47125 | 413 | 7 |
276997 | 276997 | 2020-06-26 | Montgomery | Tennessee | 47125 | 434 | 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);