ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 47157 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637488 | 637488 | 2020-10-16 | Shelby | Tennessee | 47157 | 33960 | 548 |
634242 | 634242 | 2020-10-15 | Shelby | Tennessee | 47157 | 33710 | 547 |
630997 | 630997 | 2020-10-14 | Shelby | Tennessee | 47157 | 33625 | 545 |
627753 | 627753 | 2020-10-13 | Shelby | Tennessee | 47157 | 33481 | 540 |
624511 | 624511 | 2020-10-12 | Shelby | Tennessee | 47157 | 33056 | 538 |
621268 | 621268 | 2020-10-11 | Shelby | Tennessee | 47157 | 32975 | 537 |
618025 | 618025 | 2020-10-10 | Shelby | Tennessee | 47157 | 32916 | 533 |
614783 | 614783 | 2020-10-09 | Shelby | Tennessee | 47157 | 32770 | 529 |
611542 | 611542 | 2020-10-08 | Shelby | Tennessee | 47157 | 32595 | 524 |
608300 | 608300 | 2020-10-07 | Shelby | Tennessee | 47157 | 32513 | 493 |
605057 | 605057 | 2020-10-06 | Shelby | Tennessee | 47157 | 32306 | 491 |
601815 | 601815 | 2020-10-05 | Shelby | Tennessee | 47157 | 32048 | 489 |
598572 | 598572 | 2020-10-04 | Shelby | Tennessee | 47157 | 31953 | 487 |
595329 | 595329 | 2020-10-03 | Shelby | Tennessee | 47157 | 31850 | 483 |
592088 | 592088 | 2020-10-02 | Shelby | Tennessee | 47157 | 31771 | 480 |
588847 | 588847 | 2020-10-01 | Shelby | Tennessee | 47157 | 31643 | 479 |
585607 | 585607 | 2020-09-30 | Shelby | Tennessee | 47157 | 31540 | 472 |
582367 | 582367 | 2020-09-29 | Shelby | Tennessee | 47157 | 31462 | 466 |
579127 | 579127 | 2020-09-28 | Shelby | Tennessee | 47157 | 31391 | 460 |
575886 | 575886 | 2020-09-27 | Shelby | Tennessee | 47157 | 31227 | 459 |
572642 | 572642 | 2020-09-26 | Shelby | Tennessee | 47157 | 31044 | 458 |
569400 | 569400 | 2020-09-25 | Shelby | Tennessee | 47157 | 30922 | 455 |
566159 | 566159 | 2020-09-24 | Shelby | Tennessee | 47157 | 30837 | 452 |
562918 | 562918 | 2020-09-23 | Shelby | Tennessee | 47157 | 30690 | 449 |
559681 | 559681 | 2020-09-22 | Shelby | Tennessee | 47157 | 30594 | 449 |
556444 | 556444 | 2020-09-21 | Shelby | Tennessee | 47157 | 30486 | 447 |
553207 | 553207 | 2020-09-20 | Shelby | Tennessee | 47157 | 30255 | 447 |
549968 | 549968 | 2020-09-19 | Shelby | Tennessee | 47157 | 30135 | 446 |
546729 | 546729 | 2020-09-18 | Shelby | Tennessee | 47157 | 29957 | 443 |
543492 | 543492 | 2020-09-17 | Shelby | Tennessee | 47157 | 29797 | 440 |
540256 | 540256 | 2020-09-16 | Shelby | Tennessee | 47157 | 29504 | 440 |
537019 | 537019 | 2020-09-15 | Shelby | Tennessee | 47157 | 29330 | 433 |
533783 | 533783 | 2020-09-14 | Shelby | Tennessee | 47157 | 29117 | 428 |
530548 | 530548 | 2020-09-13 | Shelby | Tennessee | 47157 | 28890 | 427 |
527311 | 527311 | 2020-09-12 | Shelby | Tennessee | 47157 | 28890 | 421 |
524075 | 524075 | 2020-09-11 | Shelby | Tennessee | 47157 | 28754 | 417 |
520839 | 520839 | 2020-09-10 | Shelby | Tennessee | 47157 | 28754 | 412 |
517603 | 517603 | 2020-09-09 | Shelby | Tennessee | 47157 | 28547 | 406 |
514368 | 514368 | 2020-09-08 | Shelby | Tennessee | 47157 | 28478 | 407 |
511135 | 511135 | 2020-09-07 | Shelby | Tennessee | 47157 | 28332 | 402 |
507902 | 507902 | 2020-09-06 | Shelby | Tennessee | 47157 | 28207 | 402 |
504670 | 504670 | 2020-09-05 | Shelby | Tennessee | 47157 | 28067 | 400 |
501436 | 501436 | 2020-09-04 | Shelby | Tennessee | 47157 | 27975 | 398 |
498202 | 498202 | 2020-09-03 | Shelby | Tennessee | 47157 | 27865 | 393 |
494969 | 494969 | 2020-09-02 | Shelby | Tennessee | 47157 | 27779 | 389 |
491735 | 491735 | 2020-09-01 | Shelby | Tennessee | 47157 | 27697 | 387 |
488502 | 488502 | 2020-08-31 | Shelby | Tennessee | 47157 | 27697 | 387 |
485269 | 485269 | 2020-08-30 | Shelby | Tennessee | 47157 | 27467 | 385 |
482034 | 482034 | 2020-08-29 | Shelby | Tennessee | 47157 | 27273 | 380 |
478800 | 478800 | 2020-08-28 | Shelby | Tennessee | 47157 | 27052 | 378 |
475567 | 475567 | 2020-08-27 | Shelby | Tennessee | 47157 | 26903 | 377 |
472334 | 472334 | 2020-08-26 | Shelby | Tennessee | 47157 | 26656 | 374 |
469102 | 469102 | 2020-08-25 | Shelby | Tennessee | 47157 | 26528 | 370 |
465873 | 465873 | 2020-08-24 | Shelby | Tennessee | 47157 | 26406 | 380 |
462644 | 462644 | 2020-08-23 | Shelby | Tennessee | 47157 | 26117 | 369 |
459416 | 459416 | 2020-08-22 | Shelby | Tennessee | 47157 | 26030 | 364 |
456188 | 456188 | 2020-08-21 | Shelby | Tennessee | 47157 | 25811 | 360 |
452960 | 452960 | 2020-08-20 | Shelby | Tennessee | 47157 | 25664 | 346 |
449732 | 449732 | 2020-08-19 | Shelby | Tennessee | 47157 | 25507 | 341 |
446504 | 446504 | 2020-08-18 | Shelby | Tennessee | 47157 | 25364 | 340 |
443278 | 443278 | 2020-08-17 | Shelby | Tennessee | 47157 | 25275 | 334 |
440051 | 440051 | 2020-08-16 | Shelby | Tennessee | 47157 | 25046 | 327 |
436826 | 436826 | 2020-08-15 | Shelby | Tennessee | 47157 | 24803 | 323 |
433599 | 433599 | 2020-08-14 | Shelby | Tennessee | 47157 | 24547 | 321 |
430374 | 430374 | 2020-08-13 | Shelby | Tennessee | 47157 | 24347 | 319 |
427147 | 427147 | 2020-08-12 | Shelby | Tennessee | 47157 | 24176 | 315 |
423924 | 423924 | 2020-08-11 | Shelby | Tennessee | 47157 | 24057 | 314 |
420702 | 420702 | 2020-08-10 | Shelby | Tennessee | 47157 | 23810 | 308 |
417481 | 417481 | 2020-08-09 | Shelby | Tennessee | 47157 | 23529 | 304 |
414260 | 414260 | 2020-08-08 | Shelby | Tennessee | 47157 | 23192 | 302 |
411040 | 411040 | 2020-08-07 | Shelby | Tennessee | 47157 | 23192 | 302 |
407821 | 407821 | 2020-08-06 | Shelby | Tennessee | 47157 | 22552 | 300 |
404601 | 404601 | 2020-08-05 | Shelby | Tennessee | 47157 | 22317 | 298 |
401383 | 401383 | 2020-08-04 | Shelby | Tennessee | 47157 | 22120 | 293 |
398168 | 398168 | 2020-08-03 | Shelby | Tennessee | 47157 | 21913 | 288 |
394951 | 394951 | 2020-08-02 | Shelby | Tennessee | 47157 | 21655 | 285 |
391735 | 391735 | 2020-08-01 | Shelby | Tennessee | 47157 | 21461 | 284 |
388518 | 388518 | 2020-07-31 | Shelby | Tennessee | 47157 | 20797 | 279 |
385301 | 385301 | 2020-07-30 | Shelby | Tennessee | 47157 | 20380 | 275 |
382083 | 382083 | 2020-07-29 | Shelby | Tennessee | 47157 | 20056 | 273 |
378866 | 378866 | 2020-07-28 | Shelby | Tennessee | 47157 | 19694 | 269 |
375650 | 375650 | 2020-07-27 | Shelby | Tennessee | 47157 | 19166 | 264 |
372437 | 372437 | 2020-07-26 | Shelby | Tennessee | 47157 | 18764 | 267 |
369225 | 369225 | 2020-07-25 | Shelby | Tennessee | 47157 | 18488 | 265 |
366016 | 366016 | 2020-07-24 | Shelby | Tennessee | 47157 | 18058 | 263 |
362810 | 362810 | 2020-07-23 | Shelby | Tennessee | 47157 | 17684 | 260 |
359603 | 359603 | 2020-07-22 | Shelby | Tennessee | 47157 | 17255 | 257 |
356399 | 356399 | 2020-07-21 | Shelby | Tennessee | 47157 | 16978 | 252 |
353196 | 353196 | 2020-07-20 | Shelby | Tennessee | 47157 | 16767 | 245 |
349993 | 349993 | 2020-07-19 | Shelby | Tennessee | 47157 | 16468 | 245 |
346793 | 346793 | 2020-07-18 | Shelby | Tennessee | 47157 | 16224 | 241 |
343593 | 343593 | 2020-07-17 | Shelby | Tennessee | 47157 | 15678 | 235 |
340395 | 340395 | 2020-07-16 | Shelby | Tennessee | 47157 | 15324 | 233 |
337198 | 337198 | 2020-07-15 | Shelby | Tennessee | 47157 | 14891 | 233 |
334004 | 334004 | 2020-07-14 | Shelby | Tennessee | 47157 | 14555 | 229 |
330812 | 330812 | 2020-07-13 | Shelby | Tennessee | 47157 | 14163 | 224 |
327626 | 327626 | 2020-07-12 | Shelby | Tennessee | 47157 | 13702 | 224 |
324441 | 324441 | 2020-07-11 | Shelby | Tennessee | 47157 | 13452 | 223 |
321260 | 321260 | 2020-07-10 | Shelby | Tennessee | 47157 | 13135 | 219 |
318082 | 318082 | 2020-07-09 | Shelby | Tennessee | 47157 | 12842 | 214 |
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);