ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Fayette" and fips = 47047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536964 | 536964 | 2020-09-15 | Fayette | Tennessee | 47047 | 1063 | 16 |
533728 | 533728 | 2020-09-14 | Fayette | Tennessee | 47047 | 1063 | 14 |
530493 | 530493 | 2020-09-13 | Fayette | Tennessee | 47047 | 1040 | 14 |
527256 | 527256 | 2020-09-12 | Fayette | Tennessee | 47047 | 1039 | 14 |
524020 | 524020 | 2020-09-11 | Fayette | Tennessee | 47047 | 1030 | 14 |
520784 | 520784 | 2020-09-10 | Fayette | Tennessee | 47047 | 1021 | 13 |
517548 | 517548 | 2020-09-09 | Fayette | Tennessee | 47047 | 1008 | 12 |
514313 | 514313 | 2020-09-08 | Fayette | Tennessee | 47047 | 1008 | 12 |
511080 | 511080 | 2020-09-07 | Fayette | Tennessee | 47047 | 1005 | 11 |
507847 | 507847 | 2020-09-06 | Fayette | Tennessee | 47047 | 997 | 11 |
504615 | 504615 | 2020-09-05 | Fayette | Tennessee | 47047 | 983 | 11 |
501381 | 501381 | 2020-09-04 | Fayette | Tennessee | 47047 | 976 | 11 |
498147 | 498147 | 2020-09-03 | Fayette | Tennessee | 47047 | 973 | 11 |
494914 | 494914 | 2020-09-02 | Fayette | Tennessee | 47047 | 909 | 10 |
491680 | 491680 | 2020-09-01 | Fayette | Tennessee | 47047 | 888 | 10 |
488447 | 488447 | 2020-08-31 | Fayette | Tennessee | 47047 | 886 | 10 |
485214 | 485214 | 2020-08-30 | Fayette | Tennessee | 47047 | 882 | 10 |
481979 | 481979 | 2020-08-29 | Fayette | Tennessee | 47047 | 875 | 10 |
478745 | 478745 | 2020-08-28 | Fayette | Tennessee | 47047 | 873 | 10 |
475512 | 475512 | 2020-08-27 | Fayette | Tennessee | 47047 | 859 | 10 |
472279 | 472279 | 2020-08-26 | Fayette | Tennessee | 47047 | 851 | 10 |
469047 | 469047 | 2020-08-25 | Fayette | Tennessee | 47047 | 824 | 10 |
465818 | 465818 | 2020-08-24 | Fayette | Tennessee | 47047 | 820 | 10 |
462589 | 462589 | 2020-08-23 | Fayette | Tennessee | 47047 | 814 | 10 |
459361 | 459361 | 2020-08-22 | Fayette | Tennessee | 47047 | 806 | 10 |
456133 | 456133 | 2020-08-21 | Fayette | Tennessee | 47047 | 803 | 10 |
452905 | 452905 | 2020-08-20 | Fayette | Tennessee | 47047 | 797 | 10 |
449677 | 449677 | 2020-08-19 | Fayette | Tennessee | 47047 | 787 | 10 |
446449 | 446449 | 2020-08-18 | Fayette | Tennessee | 47047 | 766 | 10 |
443223 | 443223 | 2020-08-17 | Fayette | Tennessee | 47047 | 759 | 8 |
439996 | 439996 | 2020-08-16 | Fayette | Tennessee | 47047 | 755 | 8 |
436771 | 436771 | 2020-08-15 | Fayette | Tennessee | 47047 | 749 | 8 |
433544 | 433544 | 2020-08-14 | Fayette | Tennessee | 47047 | 744 | 8 |
430319 | 430319 | 2020-08-13 | Fayette | Tennessee | 47047 | 725 | 8 |
427092 | 427092 | 2020-08-12 | Fayette | Tennessee | 47047 | 718 | 8 |
423869 | 423869 | 2020-08-11 | Fayette | Tennessee | 47047 | 704 | 8 |
420647 | 420647 | 2020-08-10 | Fayette | Tennessee | 47047 | 702 | 8 |
417426 | 417426 | 2020-08-09 | Fayette | Tennessee | 47047 | 698 | 8 |
414205 | 414205 | 2020-08-08 | Fayette | Tennessee | 47047 | 686 | 8 |
410985 | 410985 | 2020-08-07 | Fayette | Tennessee | 47047 | 670 | 8 |
407766 | 407766 | 2020-08-06 | Fayette | Tennessee | 47047 | 652 | 8 |
404546 | 404546 | 2020-08-05 | Fayette | Tennessee | 47047 | 646 | 8 |
401328 | 401328 | 2020-08-04 | Fayette | Tennessee | 47047 | 642 | 8 |
398113 | 398113 | 2020-08-03 | Fayette | Tennessee | 47047 | 620 | 8 |
394896 | 394896 | 2020-08-02 | Fayette | Tennessee | 47047 | 617 | 8 |
391680 | 391680 | 2020-08-01 | Fayette | Tennessee | 47047 | 616 | 8 |
388463 | 388463 | 2020-07-31 | Fayette | Tennessee | 47047 | 596 | 8 |
385246 | 385246 | 2020-07-30 | Fayette | Tennessee | 47047 | 584 | 8 |
382028 | 382028 | 2020-07-29 | Fayette | Tennessee | 47047 | 574 | 8 |
378811 | 378811 | 2020-07-28 | Fayette | Tennessee | 47047 | 567 | 8 |
375595 | 375595 | 2020-07-27 | Fayette | Tennessee | 47047 | 541 | 8 |
372382 | 372382 | 2020-07-26 | Fayette | Tennessee | 47047 | 525 | 8 |
369170 | 369170 | 2020-07-25 | Fayette | Tennessee | 47047 | 519 | 8 |
365961 | 365961 | 2020-07-24 | Fayette | Tennessee | 47047 | 512 | 8 |
362755 | 362755 | 2020-07-23 | Fayette | Tennessee | 47047 | 510 | 8 |
359548 | 359548 | 2020-07-22 | Fayette | Tennessee | 47047 | 495 | 8 |
356344 | 356344 | 2020-07-21 | Fayette | Tennessee | 47047 | 495 | 7 |
353141 | 353141 | 2020-07-20 | Fayette | Tennessee | 47047 | 473 | 7 |
349938 | 349938 | 2020-07-19 | Fayette | Tennessee | 47047 | 465 | 7 |
346738 | 346738 | 2020-07-18 | Fayette | Tennessee | 47047 | 454 | 7 |
343538 | 343538 | 2020-07-17 | Fayette | Tennessee | 47047 | 433 | 7 |
340340 | 340340 | 2020-07-16 | Fayette | Tennessee | 47047 | 424 | 6 |
337143 | 337143 | 2020-07-15 | Fayette | Tennessee | 47047 | 404 | 6 |
333949 | 333949 | 2020-07-14 | Fayette | Tennessee | 47047 | 393 | 6 |
330757 | 330757 | 2020-07-13 | Fayette | Tennessee | 47047 | 380 | 5 |
327571 | 327571 | 2020-07-12 | Fayette | Tennessee | 47047 | 370 | 5 |
324386 | 324386 | 2020-07-11 | Fayette | Tennessee | 47047 | 368 | 5 |
321205 | 321205 | 2020-07-10 | Fayette | Tennessee | 47047 | 357 | 3 |
318027 | 318027 | 2020-07-09 | Fayette | Tennessee | 47047 | 346 | 3 |
314854 | 314854 | 2020-07-08 | Fayette | Tennessee | 47047 | 344 | 3 |
311680 | 311680 | 2020-07-07 | Fayette | Tennessee | 47047 | 328 | 2 |
308511 | 308511 | 2020-07-06 | Fayette | Tennessee | 47047 | 323 | 2 |
305343 | 305343 | 2020-07-05 | Fayette | Tennessee | 47047 | 317 | 2 |
302180 | 302180 | 2020-07-04 | Fayette | Tennessee | 47047 | 312 | 2 |
299016 | 299016 | 2020-07-03 | Fayette | Tennessee | 47047 | 310 | 2 |
295856 | 295856 | 2020-07-02 | Fayette | Tennessee | 47047 | 301 | 2 |
292700 | 292700 | 2020-07-01 | Fayette | Tennessee | 47047 | 292 | 2 |
289548 | 289548 | 2020-06-30 | Fayette | Tennessee | 47047 | 273 | 2 |
286397 | 286397 | 2020-06-29 | Fayette | Tennessee | 47047 | 263 | 2 |
283252 | 283252 | 2020-06-28 | Fayette | Tennessee | 47047 | 244 | 2 |
280106 | 280106 | 2020-06-27 | Fayette | Tennessee | 47047 | 244 | 2 |
276958 | 276958 | 2020-06-26 | Fayette | Tennessee | 47047 | 233 | 2 |
273811 | 273811 | 2020-06-25 | Fayette | Tennessee | 47047 | 229 | 2 |
270672 | 270672 | 2020-06-24 | Fayette | Tennessee | 47047 | 224 | 2 |
267538 | 267538 | 2020-06-23 | Fayette | Tennessee | 47047 | 213 | 2 |
264410 | 264410 | 2020-06-22 | Fayette | Tennessee | 47047 | 203 | 2 |
261282 | 261282 | 2020-06-21 | Fayette | Tennessee | 47047 | 195 | 2 |
258155 | 258155 | 2020-06-20 | Fayette | Tennessee | 47047 | 193 | 2 |
255029 | 255029 | 2020-06-19 | Fayette | Tennessee | 47047 | 193 | 2 |
251914 | 251914 | 2020-06-18 | Fayette | Tennessee | 47047 | 189 | 2 |
248799 | 248799 | 2020-06-17 | Fayette | Tennessee | 47047 | 186 | 2 |
245686 | 245686 | 2020-06-16 | Fayette | Tennessee | 47047 | 183 | 2 |
242574 | 242574 | 2020-06-15 | Fayette | Tennessee | 47047 | 177 | 2 |
239464 | 239464 | 2020-06-14 | Fayette | Tennessee | 47047 | 172 | 2 |
236356 | 236356 | 2020-06-13 | Fayette | Tennessee | 47047 | 169 | 2 |
233250 | 233250 | 2020-06-12 | Fayette | Tennessee | 47047 | 167 | 2 |
230145 | 230145 | 2020-06-11 | Fayette | Tennessee | 47047 | 163 | 2 |
227041 | 227041 | 2020-06-10 | Fayette | Tennessee | 47047 | 162 | 2 |
223941 | 223941 | 2020-06-09 | Fayette | Tennessee | 47047 | 159 | 2 |
220846 | 220846 | 2020-06-08 | Fayette | Tennessee | 47047 | 155 | 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);