ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Montgomery" and fips = 47125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
314893 | 314893 | 2020-07-08 | Montgomery | Tennessee | 47125 | 620 | 7 |
311719 | 311719 | 2020-07-07 | Montgomery | Tennessee | 47125 | 587 | 7 |
308550 | 308550 | 2020-07-06 | Montgomery | Tennessee | 47125 | 567 | 7 |
305382 | 305382 | 2020-07-05 | Montgomery | Tennessee | 47125 | 554 | 7 |
302219 | 302219 | 2020-07-04 | Montgomery | Tennessee | 47125 | 549 | 7 |
299055 | 299055 | 2020-07-03 | Montgomery | Tennessee | 47125 | 534 | 7 |
295895 | 295895 | 2020-07-02 | Montgomery | Tennessee | 47125 | 513 | 7 |
292739 | 292739 | 2020-07-01 | Montgomery | Tennessee | 47125 | 493 | 7 |
289587 | 289587 | 2020-06-30 | Montgomery | Tennessee | 47125 | 479 | 7 |
286436 | 286436 | 2020-06-29 | Montgomery | Tennessee | 47125 | 464 | 7 |
283291 | 283291 | 2020-06-28 | Montgomery | Tennessee | 47125 | 438 | 7 |
280145 | 280145 | 2020-06-27 | Montgomery | Tennessee | 47125 | 438 | 7 |
276997 | 276997 | 2020-06-26 | Montgomery | Tennessee | 47125 | 434 | 7 |
273850 | 273850 | 2020-06-25 | Montgomery | Tennessee | 47125 | 413 | 7 |
270711 | 270711 | 2020-06-24 | Montgomery | Tennessee | 47125 | 407 | 6 |
267577 | 267577 | 2020-06-23 | Montgomery | Tennessee | 47125 | 392 | 5 |
264449 | 264449 | 2020-06-22 | Montgomery | Tennessee | 47125 | 385 | 5 |
261321 | 261321 | 2020-06-21 | Montgomery | Tennessee | 47125 | 384 | 5 |
258194 | 258194 | 2020-06-20 | Montgomery | Tennessee | 47125 | 368 | 5 |
255068 | 255068 | 2020-06-19 | Montgomery | Tennessee | 47125 | 363 | 5 |
251953 | 251953 | 2020-06-18 | Montgomery | Tennessee | 47125 | 356 | 5 |
248838 | 248838 | 2020-06-17 | Montgomery | Tennessee | 47125 | 341 | 5 |
245725 | 245725 | 2020-06-16 | Montgomery | Tennessee | 47125 | 341 | 5 |
242613 | 242613 | 2020-06-15 | Montgomery | Tennessee | 47125 | 339 | 5 |
239503 | 239503 | 2020-06-14 | Montgomery | Tennessee | 47125 | 332 | 5 |
236395 | 236395 | 2020-06-13 | Montgomery | Tennessee | 47125 | 324 | 5 |
233289 | 233289 | 2020-06-12 | Montgomery | Tennessee | 47125 | 319 | 5 |
230184 | 230184 | 2020-06-11 | Montgomery | Tennessee | 47125 | 312 | 4 |
227080 | 227080 | 2020-06-10 | Montgomery | Tennessee | 47125 | 309 | 4 |
223980 | 223980 | 2020-06-09 | Montgomery | Tennessee | 47125 | 310 | 4 |
220885 | 220885 | 2020-06-08 | Montgomery | Tennessee | 47125 | 301 | 3 |
217793 | 217793 | 2020-06-07 | Montgomery | Tennessee | 47125 | 294 | 3 |
214703 | 214703 | 2020-06-06 | Montgomery | Tennessee | 47125 | 287 | 3 |
211616 | 211616 | 2020-06-05 | Montgomery | Tennessee | 47125 | 287 | 3 |
208534 | 208534 | 2020-06-04 | Montgomery | Tennessee | 47125 | 286 | 3 |
205452 | 205452 | 2020-06-03 | Montgomery | Tennessee | 47125 | 283 | 3 |
202373 | 202373 | 2020-06-02 | Montgomery | Tennessee | 47125 | 277 | 3 |
199298 | 199298 | 2020-06-01 | Montgomery | Tennessee | 47125 | 269 | 3 |
196225 | 196225 | 2020-05-31 | Montgomery | Tennessee | 47125 | 269 | 3 |
193155 | 193155 | 2020-05-30 | Montgomery | Tennessee | 47125 | 269 | 3 |
190090 | 190090 | 2020-05-29 | Montgomery | Tennessee | 47125 | 262 | 3 |
187026 | 187026 | 2020-05-28 | Montgomery | Tennessee | 47125 | 261 | 3 |
183969 | 183969 | 2020-05-27 | Montgomery | Tennessee | 47125 | 258 | 3 |
180919 | 180919 | 2020-05-26 | Montgomery | Tennessee | 47125 | 251 | 3 |
177876 | 177876 | 2020-05-25 | Montgomery | Tennessee | 47125 | 248 | 3 |
174832 | 174832 | 2020-05-24 | Montgomery | Tennessee | 47125 | 240 | 3 |
171789 | 171789 | 2020-05-23 | Montgomery | Tennessee | 47125 | 234 | 3 |
168750 | 168750 | 2020-05-22 | Montgomery | Tennessee | 47125 | 218 | 3 |
165714 | 165714 | 2020-05-21 | Montgomery | Tennessee | 47125 | 217 | 2 |
162685 | 162685 | 2020-05-20 | Montgomery | Tennessee | 47125 | 216 | 2 |
159658 | 159658 | 2020-05-19 | Montgomery | Tennessee | 47125 | 216 | 2 |
156636 | 156636 | 2020-05-18 | Montgomery | Tennessee | 47125 | 213 | 2 |
153619 | 153619 | 2020-05-17 | Montgomery | Tennessee | 47125 | 206 | 2 |
150608 | 150608 | 2020-05-16 | Montgomery | Tennessee | 47125 | 204 | 2 |
147600 | 147600 | 2020-05-15 | Montgomery | Tennessee | 47125 | 203 | 2 |
144599 | 144599 | 2020-05-14 | Montgomery | Tennessee | 47125 | 199 | 2 |
141602 | 141602 | 2020-05-13 | Montgomery | Tennessee | 47125 | 191 | 2 |
138606 | 138606 | 2020-05-12 | Montgomery | Tennessee | 47125 | 188 | 2 |
135616 | 135616 | 2020-05-11 | Montgomery | Tennessee | 47125 | 180 | 2 |
132625 | 132625 | 2020-05-10 | Montgomery | Tennessee | 47125 | 174 | 2 |
129636 | 129636 | 2020-05-09 | Montgomery | Tennessee | 47125 | 172 | 2 |
126647 | 126647 | 2020-05-08 | Montgomery | Tennessee | 47125 | 161 | 2 |
123664 | 123664 | 2020-05-07 | Montgomery | Tennessee | 47125 | 155 | 2 |
120686 | 120686 | 2020-05-06 | Montgomery | Tennessee | 47125 | 153 | 2 |
117722 | 117722 | 2020-05-05 | Montgomery | Tennessee | 47125 | 151 | 2 |
114766 | 114766 | 2020-05-04 | Montgomery | Tennessee | 47125 | 149 | 2 |
111884 | 111884 | 2020-05-03 | Montgomery | Tennessee | 47125 | 148 | 2 |
109010 | 109010 | 2020-05-02 | Montgomery | Tennessee | 47125 | 148 | 2 |
106143 | 106143 | 2020-05-01 | Montgomery | Tennessee | 47125 | 146 | 2 |
103280 | 103280 | 2020-04-30 | Montgomery | Tennessee | 47125 | 146 | 2 |
100427 | 100427 | 2020-04-29 | Montgomery | Tennessee | 47125 | 141 | 2 |
97577 | 97577 | 2020-04-28 | Montgomery | Tennessee | 47125 | 139 | 2 |
94737 | 94737 | 2020-04-27 | Montgomery | Tennessee | 47125 | 138 | 2 |
91909 | 91909 | 2020-04-26 | Montgomery | Tennessee | 47125 | 136 | 2 |
89092 | 89092 | 2020-04-25 | Montgomery | Tennessee | 47125 | 134 | 2 |
86277 | 86277 | 2020-04-24 | Montgomery | Tennessee | 47125 | 132 | 2 |
83472 | 83472 | 2020-04-23 | Montgomery | Tennessee | 47125 | 130 | 2 |
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);