ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Morgan" and fips = 47129 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
308552 | 308552 | 2020-07-06 | Morgan | Tennessee | 47129 | 27 | 1 |
311721 | 311721 | 2020-07-07 | Morgan | Tennessee | 47129 | 28 | 1 |
314895 | 314895 | 2020-07-08 | Morgan | Tennessee | 47129 | 29 | 1 |
318068 | 318068 | 2020-07-09 | Morgan | Tennessee | 47129 | 29 | 1 |
321246 | 321246 | 2020-07-10 | Morgan | Tennessee | 47129 | 30 | 1 |
324427 | 324427 | 2020-07-11 | Morgan | Tennessee | 47129 | 31 | 1 |
327612 | 327612 | 2020-07-12 | Morgan | Tennessee | 47129 | 32 | 1 |
330798 | 330798 | 2020-07-13 | Morgan | Tennessee | 47129 | 34 | 1 |
333990 | 333990 | 2020-07-14 | Morgan | Tennessee | 47129 | 34 | 1 |
337184 | 337184 | 2020-07-15 | Morgan | Tennessee | 47129 | 37 | 1 |
340381 | 340381 | 2020-07-16 | Morgan | Tennessee | 47129 | 38 | 1 |
343579 | 343579 | 2020-07-17 | Morgan | Tennessee | 47129 | 38 | 1 |
346779 | 346779 | 2020-07-18 | Morgan | Tennessee | 47129 | 40 | 1 |
349979 | 349979 | 2020-07-19 | Morgan | Tennessee | 47129 | 41 | 1 |
353182 | 353182 | 2020-07-20 | Morgan | Tennessee | 47129 | 42 | 1 |
356385 | 356385 | 2020-07-21 | Morgan | Tennessee | 47129 | 45 | 1 |
359589 | 359589 | 2020-07-22 | Morgan | Tennessee | 47129 | 46 | 1 |
362796 | 362796 | 2020-07-23 | Morgan | Tennessee | 47129 | 50 | 1 |
366002 | 366002 | 2020-07-24 | Morgan | Tennessee | 47129 | 50 | 1 |
369211 | 369211 | 2020-07-25 | Morgan | Tennessee | 47129 | 51 | 1 |
372423 | 372423 | 2020-07-26 | Morgan | Tennessee | 47129 | 55 | 1 |
375636 | 375636 | 2020-07-27 | Morgan | Tennessee | 47129 | 59 | 1 |
378852 | 378852 | 2020-07-28 | Morgan | Tennessee | 47129 | 62 | 1 |
382069 | 382069 | 2020-07-29 | Morgan | Tennessee | 47129 | 64 | 1 |
385287 | 385287 | 2020-07-30 | Morgan | Tennessee | 47129 | 65 | 1 |
388504 | 388504 | 2020-07-31 | Morgan | Tennessee | 47129 | 70 | 1 |
391721 | 391721 | 2020-08-01 | Morgan | Tennessee | 47129 | 76 | 1 |
394937 | 394937 | 2020-08-02 | Morgan | Tennessee | 47129 | 79 | 1 |
398154 | 398154 | 2020-08-03 | Morgan | Tennessee | 47129 | 82 | 1 |
401369 | 401369 | 2020-08-04 | Morgan | Tennessee | 47129 | 91 | 1 |
404587 | 404587 | 2020-08-05 | Morgan | Tennessee | 47129 | 94 | 1 |
407807 | 407807 | 2020-08-06 | Morgan | Tennessee | 47129 | 98 | 1 |
411026 | 411026 | 2020-08-07 | Morgan | Tennessee | 47129 | 103 | 1 |
414246 | 414246 | 2020-08-08 | Morgan | Tennessee | 47129 | 118 | 1 |
417467 | 417467 | 2020-08-09 | Morgan | Tennessee | 47129 | 122 | 1 |
420688 | 420688 | 2020-08-10 | Morgan | Tennessee | 47129 | 126 | 1 |
423910 | 423910 | 2020-08-11 | Morgan | Tennessee | 47129 | 127 | 1 |
427133 | 427133 | 2020-08-12 | Morgan | Tennessee | 47129 | 130 | 1 |
430360 | 430360 | 2020-08-13 | Morgan | Tennessee | 47129 | 133 | 1 |
433585 | 433585 | 2020-08-14 | Morgan | Tennessee | 47129 | 135 | 1 |
436812 | 436812 | 2020-08-15 | Morgan | Tennessee | 47129 | 140 | 1 |
440037 | 440037 | 2020-08-16 | Morgan | Tennessee | 47129 | 141 | 1 |
443264 | 443264 | 2020-08-17 | Morgan | Tennessee | 47129 | 145 | 1 |
446490 | 446490 | 2020-08-18 | Morgan | Tennessee | 47129 | 148 | 1 |
449718 | 449718 | 2020-08-19 | Morgan | Tennessee | 47129 | 162 | 1 |
452946 | 452946 | 2020-08-20 | Morgan | Tennessee | 47129 | 167 | 1 |
456174 | 456174 | 2020-08-21 | Morgan | Tennessee | 47129 | 170 | 1 |
459402 | 459402 | 2020-08-22 | Morgan | Tennessee | 47129 | 176 | 1 |
462630 | 462630 | 2020-08-23 | Morgan | Tennessee | 47129 | 182 | 1 |
465859 | 465859 | 2020-08-24 | Morgan | Tennessee | 47129 | 184 | 1 |
469088 | 469088 | 2020-08-25 | Morgan | Tennessee | 47129 | 185 | 1 |
472320 | 472320 | 2020-08-26 | Morgan | Tennessee | 47129 | 187 | 1 |
475553 | 475553 | 2020-08-27 | Morgan | Tennessee | 47129 | 191 | 1 |
478786 | 478786 | 2020-08-28 | Morgan | Tennessee | 47129 | 204 | 1 |
482020 | 482020 | 2020-08-29 | Morgan | Tennessee | 47129 | 205 | 1 |
485255 | 485255 | 2020-08-30 | Morgan | Tennessee | 47129 | 207 | 2 |
488488 | 488488 | 2020-08-31 | Morgan | Tennessee | 47129 | 209 | 2 |
491721 | 491721 | 2020-09-01 | Morgan | Tennessee | 47129 | 214 | 2 |
494955 | 494955 | 2020-09-02 | Morgan | Tennessee | 47129 | 220 | 2 |
498188 | 498188 | 2020-09-03 | Morgan | Tennessee | 47129 | 248 | 2 |
501422 | 501422 | 2020-09-04 | Morgan | Tennessee | 47129 | 255 | 2 |
504656 | 504656 | 2020-09-05 | Morgan | Tennessee | 47129 | 261 | 2 |
507888 | 507888 | 2020-09-06 | Morgan | Tennessee | 47129 | 265 | 2 |
511121 | 511121 | 2020-09-07 | Morgan | Tennessee | 47129 | 266 | 2 |
514354 | 514354 | 2020-09-08 | Morgan | Tennessee | 47129 | 266 | 2 |
517589 | 517589 | 2020-09-09 | Morgan | Tennessee | 47129 | 268 | 2 |
520825 | 520825 | 2020-09-10 | Morgan | Tennessee | 47129 | 274 | 2 |
524061 | 524061 | 2020-09-11 | Morgan | Tennessee | 47129 | 276 | 2 |
527297 | 527297 | 2020-09-12 | Morgan | Tennessee | 47129 | 281 | 2 |
530534 | 530534 | 2020-09-13 | Morgan | Tennessee | 47129 | 281 | 2 |
533769 | 533769 | 2020-09-14 | Morgan | Tennessee | 47129 | 282 | 2 |
537005 | 537005 | 2020-09-15 | Morgan | Tennessee | 47129 | 282 | 2 |
540242 | 540242 | 2020-09-16 | Morgan | Tennessee | 47129 | 289 | 3 |
543478 | 543478 | 2020-09-17 | Morgan | Tennessee | 47129 | 293 | 3 |
546715 | 546715 | 2020-09-18 | Morgan | Tennessee | 47129 | 299 | 3 |
549954 | 549954 | 2020-09-19 | Morgan | Tennessee | 47129 | 302 | 3 |
553193 | 553193 | 2020-09-20 | Morgan | Tennessee | 47129 | 304 | 3 |
556430 | 556430 | 2020-09-21 | Morgan | Tennessee | 47129 | 305 | 3 |
559667 | 559667 | 2020-09-22 | Morgan | Tennessee | 47129 | 306 | 3 |
562904 | 562904 | 2020-09-23 | Morgan | Tennessee | 47129 | 310 | 3 |
566145 | 566145 | 2020-09-24 | Morgan | Tennessee | 47129 | 311 | 3 |
569386 | 569386 | 2020-09-25 | Morgan | Tennessee | 47129 | 315 | 3 |
572628 | 572628 | 2020-09-26 | Morgan | Tennessee | 47129 | 317 | 3 |
575872 | 575872 | 2020-09-27 | Morgan | Tennessee | 47129 | 320 | 3 |
579113 | 579113 | 2020-09-28 | Morgan | Tennessee | 47129 | 321 | 3 |
582353 | 582353 | 2020-09-29 | Morgan | Tennessee | 47129 | 321 | 3 |
585593 | 585593 | 2020-09-30 | Morgan | Tennessee | 47129 | 325 | 3 |
588833 | 588833 | 2020-10-01 | Morgan | Tennessee | 47129 | 327 | 4 |
592074 | 592074 | 2020-10-02 | Morgan | Tennessee | 47129 | 330 | 4 |
595315 | 595315 | 2020-10-03 | Morgan | Tennessee | 47129 | 333 | 4 |
598558 | 598558 | 2020-10-04 | Morgan | Tennessee | 47129 | 333 | 4 |
601801 | 601801 | 2020-10-05 | Morgan | Tennessee | 47129 | 340 | 4 |
605043 | 605043 | 2020-10-06 | Morgan | Tennessee | 47129 | 347 | 4 |
608286 | 608286 | 2020-10-07 | Morgan | Tennessee | 47129 | 348 | 4 |
611528 | 611528 | 2020-10-08 | Morgan | Tennessee | 47129 | 355 | 4 |
614769 | 614769 | 2020-10-09 | Morgan | Tennessee | 47129 | 355 | 4 |
618011 | 618011 | 2020-10-10 | Morgan | Tennessee | 47129 | 360 | 4 |
621254 | 621254 | 2020-10-11 | Morgan | Tennessee | 47129 | 366 | 5 |
624497 | 624497 | 2020-10-12 | Morgan | Tennessee | 47129 | 372 | 5 |
627739 | 627739 | 2020-10-13 | Morgan | Tennessee | 47129 | 376 | 6 |
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);