ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where deaths = 1, fips = 47007 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
420627 | 420627 | 2020-08-10 | Bledsoe | Tennessee | 47007 | 708 | 1 |
417406 | 417406 | 2020-08-09 | Bledsoe | Tennessee | 47007 | 705 | 1 |
414185 | 414185 | 2020-08-08 | Bledsoe | Tennessee | 47007 | 695 | 1 |
410965 | 410965 | 2020-08-07 | Bledsoe | Tennessee | 47007 | 690 | 1 |
407746 | 407746 | 2020-08-06 | Bledsoe | Tennessee | 47007 | 686 | 1 |
404526 | 404526 | 2020-08-05 | Bledsoe | Tennessee | 47007 | 674 | 1 |
401308 | 401308 | 2020-08-04 | Bledsoe | Tennessee | 47007 | 674 | 1 |
398093 | 398093 | 2020-08-03 | Bledsoe | Tennessee | 47007 | 672 | 1 |
394876 | 394876 | 2020-08-02 | Bledsoe | Tennessee | 47007 | 668 | 1 |
391660 | 391660 | 2020-08-01 | Bledsoe | Tennessee | 47007 | 661 | 1 |
388443 | 388443 | 2020-07-31 | Bledsoe | Tennessee | 47007 | 659 | 1 |
385226 | 385226 | 2020-07-30 | Bledsoe | Tennessee | 47007 | 656 | 1 |
382008 | 382008 | 2020-07-29 | Bledsoe | Tennessee | 47007 | 654 | 1 |
378791 | 378791 | 2020-07-28 | Bledsoe | Tennessee | 47007 | 653 | 1 |
375575 | 375575 | 2020-07-27 | Bledsoe | Tennessee | 47007 | 649 | 1 |
372362 | 372362 | 2020-07-26 | Bledsoe | Tennessee | 47007 | 648 | 1 |
369150 | 369150 | 2020-07-25 | Bledsoe | Tennessee | 47007 | 647 | 1 |
365941 | 365941 | 2020-07-24 | Bledsoe | Tennessee | 47007 | 646 | 1 |
362735 | 362735 | 2020-07-23 | Bledsoe | Tennessee | 47007 | 646 | 1 |
359528 | 359528 | 2020-07-22 | Bledsoe | Tennessee | 47007 | 643 | 1 |
356324 | 356324 | 2020-07-21 | Bledsoe | Tennessee | 47007 | 643 | 1 |
353121 | 353121 | 2020-07-20 | Bledsoe | Tennessee | 47007 | 641 | 1 |
349918 | 349918 | 2020-07-19 | Bledsoe | Tennessee | 47007 | 642 | 1 |
346718 | 346718 | 2020-07-18 | Bledsoe | Tennessee | 47007 | 639 | 1 |
343518 | 343518 | 2020-07-17 | Bledsoe | Tennessee | 47007 | 638 | 1 |
340320 | 340320 | 2020-07-16 | Bledsoe | Tennessee | 47007 | 636 | 1 |
337123 | 337123 | 2020-07-15 | Bledsoe | Tennessee | 47007 | 634 | 1 |
333929 | 333929 | 2020-07-14 | Bledsoe | Tennessee | 47007 | 634 | 1 |
330737 | 330737 | 2020-07-13 | Bledsoe | Tennessee | 47007 | 631 | 1 |
327551 | 327551 | 2020-07-12 | Bledsoe | Tennessee | 47007 | 629 | 1 |
324366 | 324366 | 2020-07-11 | Bledsoe | Tennessee | 47007 | 629 | 1 |
321185 | 321185 | 2020-07-10 | Bledsoe | Tennessee | 47007 | 627 | 1 |
318007 | 318007 | 2020-07-09 | Bledsoe | Tennessee | 47007 | 625 | 1 |
314834 | 314834 | 2020-07-08 | Bledsoe | Tennessee | 47007 | 624 | 1 |
311660 | 311660 | 2020-07-07 | Bledsoe | Tennessee | 47007 | 623 | 1 |
308491 | 308491 | 2020-07-06 | Bledsoe | Tennessee | 47007 | 621 | 1 |
305323 | 305323 | 2020-07-05 | Bledsoe | Tennessee | 47007 | 620 | 1 |
302160 | 302160 | 2020-07-04 | Bledsoe | Tennessee | 47007 | 619 | 1 |
298996 | 298996 | 2020-07-03 | Bledsoe | Tennessee | 47007 | 618 | 1 |
295836 | 295836 | 2020-07-02 | Bledsoe | Tennessee | 47007 | 618 | 1 |
292680 | 292680 | 2020-07-01 | Bledsoe | Tennessee | 47007 | 618 | 1 |
289528 | 289528 | 2020-06-30 | Bledsoe | Tennessee | 47007 | 617 | 1 |
286377 | 286377 | 2020-06-29 | Bledsoe | Tennessee | 47007 | 616 | 1 |
283232 | 283232 | 2020-06-28 | Bledsoe | Tennessee | 47007 | 616 | 1 |
280086 | 280086 | 2020-06-27 | Bledsoe | Tennessee | 47007 | 616 | 1 |
276938 | 276938 | 2020-06-26 | Bledsoe | Tennessee | 47007 | 616 | 1 |
273791 | 273791 | 2020-06-25 | Bledsoe | Tennessee | 47007 | 616 | 1 |
270652 | 270652 | 2020-06-24 | Bledsoe | Tennessee | 47007 | 616 | 1 |
267518 | 267518 | 2020-06-23 | Bledsoe | Tennessee | 47007 | 613 | 1 |
264390 | 264390 | 2020-06-22 | Bledsoe | Tennessee | 47007 | 613 | 1 |
261262 | 261262 | 2020-06-21 | Bledsoe | Tennessee | 47007 | 613 | 1 |
258135 | 258135 | 2020-06-20 | Bledsoe | Tennessee | 47007 | 613 | 1 |
255009 | 255009 | 2020-06-19 | Bledsoe | Tennessee | 47007 | 614 | 1 |
251894 | 251894 | 2020-06-18 | Bledsoe | Tennessee | 47007 | 614 | 1 |
248779 | 248779 | 2020-06-17 | Bledsoe | Tennessee | 47007 | 614 | 1 |
245666 | 245666 | 2020-06-16 | Bledsoe | Tennessee | 47007 | 614 | 1 |
242554 | 242554 | 2020-06-15 | Bledsoe | Tennessee | 47007 | 614 | 1 |
239444 | 239444 | 2020-06-14 | Bledsoe | Tennessee | 47007 | 614 | 1 |
236336 | 236336 | 2020-06-13 | Bledsoe | Tennessee | 47007 | 614 | 1 |
233230 | 233230 | 2020-06-12 | Bledsoe | Tennessee | 47007 | 614 | 1 |
230125 | 230125 | 2020-06-11 | Bledsoe | Tennessee | 47007 | 614 | 1 |
227021 | 227021 | 2020-06-10 | Bledsoe | Tennessee | 47007 | 613 | 1 |
223921 | 223921 | 2020-06-09 | Bledsoe | Tennessee | 47007 | 611 | 1 |
220826 | 220826 | 2020-06-08 | Bledsoe | Tennessee | 47007 | 613 | 1 |
217734 | 217734 | 2020-06-07 | Bledsoe | Tennessee | 47007 | 614 | 1 |
214644 | 214644 | 2020-06-06 | Bledsoe | Tennessee | 47007 | 614 | 1 |
211557 | 211557 | 2020-06-05 | Bledsoe | Tennessee | 47007 | 613 | 1 |
208475 | 208475 | 2020-06-04 | Bledsoe | Tennessee | 47007 | 610 | 1 |
205393 | 205393 | 2020-06-03 | Bledsoe | Tennessee | 47007 | 610 | 1 |
202314 | 202314 | 2020-06-02 | Bledsoe | Tennessee | 47007 | 609 | 1 |
199239 | 199239 | 2020-06-01 | Bledsoe | Tennessee | 47007 | 607 | 1 |
196166 | 196166 | 2020-05-31 | Bledsoe | Tennessee | 47007 | 607 | 1 |
193096 | 193096 | 2020-05-30 | Bledsoe | Tennessee | 47007 | 607 | 1 |
190031 | 190031 | 2020-05-29 | Bledsoe | Tennessee | 47007 | 606 | 1 |
186967 | 186967 | 2020-05-28 | Bledsoe | Tennessee | 47007 | 608 | 1 |
183910 | 183910 | 2020-05-27 | Bledsoe | Tennessee | 47007 | 608 | 1 |
180860 | 180860 | 2020-05-26 | Bledsoe | Tennessee | 47007 | 608 | 1 |
177817 | 177817 | 2020-05-25 | Bledsoe | Tennessee | 47007 | 608 | 1 |
174773 | 174773 | 2020-05-24 | Bledsoe | Tennessee | 47007 | 607 | 1 |
171730 | 171730 | 2020-05-23 | Bledsoe | Tennessee | 47007 | 607 | 1 |
168691 | 168691 | 2020-05-22 | Bledsoe | Tennessee | 47007 | 607 | 1 |
165655 | 165655 | 2020-05-21 | Bledsoe | Tennessee | 47007 | 607 | 1 |
162626 | 162626 | 2020-05-20 | Bledsoe | Tennessee | 47007 | 607 | 1 |
159599 | 159599 | 2020-05-19 | Bledsoe | Tennessee | 47007 | 607 | 1 |
156578 | 156578 | 2020-05-18 | Bledsoe | Tennessee | 47007 | 607 | 1 |
153561 | 153561 | 2020-05-17 | Bledsoe | Tennessee | 47007 | 607 | 1 |
150550 | 150550 | 2020-05-16 | Bledsoe | Tennessee | 47007 | 607 | 1 |
147542 | 147542 | 2020-05-15 | Bledsoe | Tennessee | 47007 | 605 | 1 |
144541 | 144541 | 2020-05-14 | Bledsoe | Tennessee | 47007 | 603 | 1 |
141544 | 141544 | 2020-05-13 | Bledsoe | Tennessee | 47007 | 603 | 1 |
138548 | 138548 | 2020-05-12 | Bledsoe | Tennessee | 47007 | 604 | 1 |
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);