ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 47017 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536949 | 536949 | 2020-09-15 | Carroll | Tennessee | 47017 | 766 | 16 |
533713 | 533713 | 2020-09-14 | Carroll | Tennessee | 47017 | 762 | 15 |
530478 | 530478 | 2020-09-13 | Carroll | Tennessee | 47017 | 739 | 15 |
527241 | 527241 | 2020-09-12 | Carroll | Tennessee | 47017 | 736 | 15 |
524005 | 524005 | 2020-09-11 | Carroll | Tennessee | 47017 | 727 | 13 |
520769 | 520769 | 2020-09-10 | Carroll | Tennessee | 47017 | 713 | 13 |
517533 | 517533 | 2020-09-09 | Carroll | Tennessee | 47017 | 703 | 10 |
514298 | 514298 | 2020-09-08 | Carroll | Tennessee | 47017 | 698 | 10 |
511065 | 511065 | 2020-09-07 | Carroll | Tennessee | 47017 | 694 | 10 |
507832 | 507832 | 2020-09-06 | Carroll | Tennessee | 47017 | 685 | 10 |
504600 | 504600 | 2020-09-05 | Carroll | Tennessee | 47017 | 677 | 10 |
501366 | 501366 | 2020-09-04 | Carroll | Tennessee | 47017 | 667 | 9 |
498132 | 498132 | 2020-09-03 | Carroll | Tennessee | 47017 | 654 | 9 |
494899 | 494899 | 2020-09-02 | Carroll | Tennessee | 47017 | 666 | 9 |
491665 | 491665 | 2020-09-01 | Carroll | Tennessee | 47017 | 643 | 8 |
488432 | 488432 | 2020-08-31 | Carroll | Tennessee | 47017 | 637 | 8 |
485199 | 485199 | 2020-08-30 | Carroll | Tennessee | 47017 | 624 | 8 |
481964 | 481964 | 2020-08-29 | Carroll | Tennessee | 47017 | 611 | 8 |
478730 | 478730 | 2020-08-28 | Carroll | Tennessee | 47017 | 596 | 8 |
475497 | 475497 | 2020-08-27 | Carroll | Tennessee | 47017 | 566 | 7 |
472264 | 472264 | 2020-08-26 | Carroll | Tennessee | 47017 | 530 | 7 |
469032 | 469032 | 2020-08-25 | Carroll | Tennessee | 47017 | 525 | 7 |
465803 | 465803 | 2020-08-24 | Carroll | Tennessee | 47017 | 516 | 6 |
462574 | 462574 | 2020-08-23 | Carroll | Tennessee | 47017 | 508 | 6 |
459346 | 459346 | 2020-08-22 | Carroll | Tennessee | 47017 | 482 | 6 |
456118 | 456118 | 2020-08-21 | Carroll | Tennessee | 47017 | 463 | 6 |
452890 | 452890 | 2020-08-20 | Carroll | Tennessee | 47017 | 449 | 6 |
449662 | 449662 | 2020-08-19 | Carroll | Tennessee | 47017 | 426 | 6 |
446434 | 446434 | 2020-08-18 | Carroll | Tennessee | 47017 | 411 | 6 |
443208 | 443208 | 2020-08-17 | Carroll | Tennessee | 47017 | 401 | 6 |
439981 | 439981 | 2020-08-16 | Carroll | Tennessee | 47017 | 394 | 6 |
436756 | 436756 | 2020-08-15 | Carroll | Tennessee | 47017 | 384 | 6 |
433529 | 433529 | 2020-08-14 | Carroll | Tennessee | 47017 | 379 | 6 |
430304 | 430304 | 2020-08-13 | Carroll | Tennessee | 47017 | 352 | 6 |
427077 | 427077 | 2020-08-12 | Carroll | Tennessee | 47017 | 341 | 5 |
423854 | 423854 | 2020-08-11 | Carroll | Tennessee | 47017 | 330 | 3 |
420632 | 420632 | 2020-08-10 | Carroll | Tennessee | 47017 | 325 | 3 |
417411 | 417411 | 2020-08-09 | Carroll | Tennessee | 47017 | 314 | 3 |
414190 | 414190 | 2020-08-08 | Carroll | Tennessee | 47017 | 296 | 3 |
410970 | 410970 | 2020-08-07 | Carroll | Tennessee | 47017 | 290 | 3 |
407751 | 407751 | 2020-08-06 | Carroll | Tennessee | 47017 | 272 | 3 |
404531 | 404531 | 2020-08-05 | Carroll | Tennessee | 47017 | 251 | 3 |
401313 | 401313 | 2020-08-04 | Carroll | Tennessee | 47017 | 244 | 3 |
398098 | 398098 | 2020-08-03 | Carroll | Tennessee | 47017 | 228 | 3 |
394881 | 394881 | 2020-08-02 | Carroll | Tennessee | 47017 | 226 | 3 |
391665 | 391665 | 2020-08-01 | Carroll | Tennessee | 47017 | 216 | 3 |
388448 | 388448 | 2020-07-31 | Carroll | Tennessee | 47017 | 191 | 3 |
385231 | 385231 | 2020-07-30 | Carroll | Tennessee | 47017 | 181 | 3 |
382013 | 382013 | 2020-07-29 | Carroll | Tennessee | 47017 | 154 | 2 |
378796 | 378796 | 2020-07-28 | Carroll | Tennessee | 47017 | 151 | 2 |
375580 | 375580 | 2020-07-27 | Carroll | Tennessee | 47017 | 139 | 2 |
372367 | 372367 | 2020-07-26 | Carroll | Tennessee | 47017 | 128 | 2 |
369155 | 369155 | 2020-07-25 | Carroll | Tennessee | 47017 | 121 | 2 |
365946 | 365946 | 2020-07-24 | Carroll | Tennessee | 47017 | 109 | 2 |
362740 | 362740 | 2020-07-23 | Carroll | Tennessee | 47017 | 107 | 2 |
359533 | 359533 | 2020-07-22 | Carroll | Tennessee | 47017 | 90 | 2 |
356329 | 356329 | 2020-07-21 | Carroll | Tennessee | 47017 | 85 | 2 |
353126 | 353126 | 2020-07-20 | Carroll | Tennessee | 47017 | 80 | 2 |
349923 | 349923 | 2020-07-19 | Carroll | Tennessee | 47017 | 77 | 2 |
346723 | 346723 | 2020-07-18 | Carroll | Tennessee | 47017 | 73 | 2 |
343523 | 343523 | 2020-07-17 | Carroll | Tennessee | 47017 | 71 | 1 |
340325 | 340325 | 2020-07-16 | Carroll | Tennessee | 47017 | 69 | 1 |
337128 | 337128 | 2020-07-15 | Carroll | Tennessee | 47017 | 63 | 1 |
333934 | 333934 | 2020-07-14 | Carroll | Tennessee | 47017 | 58 | 1 |
330742 | 330742 | 2020-07-13 | Carroll | Tennessee | 47017 | 57 | 1 |
327556 | 327556 | 2020-07-12 | Carroll | Tennessee | 47017 | 52 | 1 |
324371 | 324371 | 2020-07-11 | Carroll | Tennessee | 47017 | 52 | 1 |
321190 | 321190 | 2020-07-10 | Carroll | Tennessee | 47017 | 52 | 1 |
318012 | 318012 | 2020-07-09 | Carroll | Tennessee | 47017 | 51 | 1 |
314839 | 314839 | 2020-07-08 | Carroll | Tennessee | 47017 | 49 | 1 |
311665 | 311665 | 2020-07-07 | Carroll | Tennessee | 47017 | 49 | 1 |
308496 | 308496 | 2020-07-06 | Carroll | Tennessee | 47017 | 48 | 1 |
305328 | 305328 | 2020-07-05 | Carroll | Tennessee | 47017 | 47 | 1 |
302165 | 302165 | 2020-07-04 | Carroll | Tennessee | 47017 | 48 | 1 |
299001 | 299001 | 2020-07-03 | Carroll | Tennessee | 47017 | 44 | 1 |
295841 | 295841 | 2020-07-02 | Carroll | Tennessee | 47017 | 40 | 1 |
292685 | 292685 | 2020-07-01 | Carroll | Tennessee | 47017 | 39 | 1 |
289533 | 289533 | 2020-06-30 | Carroll | Tennessee | 47017 | 39 | 1 |
286382 | 286382 | 2020-06-29 | Carroll | Tennessee | 47017 | 39 | 1 |
283237 | 283237 | 2020-06-28 | Carroll | Tennessee | 47017 | 38 | 1 |
280091 | 280091 | 2020-06-27 | Carroll | Tennessee | 47017 | 38 | 1 |
276943 | 276943 | 2020-06-26 | Carroll | Tennessee | 47017 | 36 | 1 |
273796 | 273796 | 2020-06-25 | Carroll | Tennessee | 47017 | 36 | 1 |
270657 | 270657 | 2020-06-24 | Carroll | Tennessee | 47017 | 36 | 1 |
267523 | 267523 | 2020-06-23 | Carroll | Tennessee | 47017 | 36 | 1 |
264395 | 264395 | 2020-06-22 | Carroll | Tennessee | 47017 | 36 | 1 |
261267 | 261267 | 2020-06-21 | Carroll | Tennessee | 47017 | 36 | 1 |
258140 | 258140 | 2020-06-20 | Carroll | Tennessee | 47017 | 36 | 1 |
255014 | 255014 | 2020-06-19 | Carroll | Tennessee | 47017 | 36 | 1 |
251899 | 251899 | 2020-06-18 | Carroll | Tennessee | 47017 | 36 | 1 |
248784 | 248784 | 2020-06-17 | Carroll | Tennessee | 47017 | 36 | 1 |
245671 | 245671 | 2020-06-16 | Carroll | Tennessee | 47017 | 36 | 1 |
242559 | 242559 | 2020-06-15 | Carroll | Tennessee | 47017 | 36 | 1 |
239449 | 239449 | 2020-06-14 | Carroll | Tennessee | 47017 | 36 | 1 |
236341 | 236341 | 2020-06-13 | Carroll | Tennessee | 47017 | 35 | 1 |
233235 | 233235 | 2020-06-12 | Carroll | Tennessee | 47017 | 34 | 1 |
230130 | 230130 | 2020-06-11 | Carroll | Tennessee | 47017 | 29 | 1 |
227026 | 227026 | 2020-06-10 | Carroll | Tennessee | 47017 | 29 | 1 |
223926 | 223926 | 2020-06-09 | Carroll | Tennessee | 47017 | 28 | 1 |
220831 | 220831 | 2020-06-08 | Carroll | Tennessee | 47017 | 28 | 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);