ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Jackson" and fips = 47087 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637453 | 637453 | 2020-10-16 | Jackson | Tennessee | 47087 | 406 | 5 |
634207 | 634207 | 2020-10-15 | Jackson | Tennessee | 47087 | 403 | 5 |
630962 | 630962 | 2020-10-14 | Jackson | Tennessee | 47087 | 399 | 5 |
627718 | 627718 | 2020-10-13 | Jackson | Tennessee | 47087 | 395 | 5 |
624476 | 624476 | 2020-10-12 | Jackson | Tennessee | 47087 | 391 | 5 |
621233 | 621233 | 2020-10-11 | Jackson | Tennessee | 47087 | 385 | 5 |
617990 | 617990 | 2020-10-10 | Jackson | Tennessee | 47087 | 382 | 5 |
614748 | 614748 | 2020-10-09 | Jackson | Tennessee | 47087 | 377 | 5 |
611507 | 611507 | 2020-10-08 | Jackson | Tennessee | 47087 | 373 | 5 |
608265 | 608265 | 2020-10-07 | Jackson | Tennessee | 47087 | 374 | 5 |
605022 | 605022 | 2020-10-06 | Jackson | Tennessee | 47087 | 368 | 5 |
601780 | 601780 | 2020-10-05 | Jackson | Tennessee | 47087 | 362 | 5 |
598537 | 598537 | 2020-10-04 | Jackson | Tennessee | 47087 | 359 | 5 |
595294 | 595294 | 2020-10-03 | Jackson | Tennessee | 47087 | 352 | 5 |
592053 | 592053 | 2020-10-02 | Jackson | Tennessee | 47087 | 347 | 5 |
588812 | 588812 | 2020-10-01 | Jackson | Tennessee | 47087 | 343 | 5 |
585572 | 585572 | 2020-09-30 | Jackson | Tennessee | 47087 | 335 | 5 |
582332 | 582332 | 2020-09-29 | Jackson | Tennessee | 47087 | 332 | 5 |
579092 | 579092 | 2020-09-28 | Jackson | Tennessee | 47087 | 332 | 5 |
575851 | 575851 | 2020-09-27 | Jackson | Tennessee | 47087 | 331 | 5 |
572607 | 572607 | 2020-09-26 | Jackson | Tennessee | 47087 | 326 | 5 |
569365 | 569365 | 2020-09-25 | Jackson | Tennessee | 47087 | 324 | 5 |
566124 | 566124 | 2020-09-24 | Jackson | Tennessee | 47087 | 317 | 5 |
562883 | 562883 | 2020-09-23 | Jackson | Tennessee | 47087 | 314 | 5 |
559646 | 559646 | 2020-09-22 | Jackson | Tennessee | 47087 | 308 | 5 |
556409 | 556409 | 2020-09-21 | Jackson | Tennessee | 47087 | 305 | 5 |
553172 | 553172 | 2020-09-20 | Jackson | Tennessee | 47087 | 305 | 4 |
549933 | 549933 | 2020-09-19 | Jackson | Tennessee | 47087 | 302 | 4 |
546694 | 546694 | 2020-09-18 | Jackson | Tennessee | 47087 | 298 | 4 |
543457 | 543457 | 2020-09-17 | Jackson | Tennessee | 47087 | 294 | 3 |
540221 | 540221 | 2020-09-16 | Jackson | Tennessee | 47087 | 291 | 3 |
536984 | 536984 | 2020-09-15 | Jackson | Tennessee | 47087 | 285 | 3 |
533748 | 533748 | 2020-09-14 | Jackson | Tennessee | 47087 | 284 | 2 |
530513 | 530513 | 2020-09-13 | Jackson | Tennessee | 47087 | 279 | 2 |
527276 | 527276 | 2020-09-12 | Jackson | Tennessee | 47087 | 279 | 2 |
524040 | 524040 | 2020-09-11 | Jackson | Tennessee | 47087 | 275 | 2 |
520804 | 520804 | 2020-09-10 | Jackson | Tennessee | 47087 | 272 | 2 |
517568 | 517568 | 2020-09-09 | Jackson | Tennessee | 47087 | 264 | 2 |
514333 | 514333 | 2020-09-08 | Jackson | Tennessee | 47087 | 262 | 2 |
511100 | 511100 | 2020-09-07 | Jackson | Tennessee | 47087 | 261 | 2 |
507867 | 507867 | 2020-09-06 | Jackson | Tennessee | 47087 | 261 | 2 |
504635 | 504635 | 2020-09-05 | Jackson | Tennessee | 47087 | 261 | 2 |
501401 | 501401 | 2020-09-04 | Jackson | Tennessee | 47087 | 258 | 2 |
498167 | 498167 | 2020-09-03 | Jackson | Tennessee | 47087 | 250 | 2 |
494934 | 494934 | 2020-09-02 | Jackson | Tennessee | 47087 | 221 | 2 |
491700 | 491700 | 2020-09-01 | Jackson | Tennessee | 47087 | 220 | 1 |
488467 | 488467 | 2020-08-31 | Jackson | Tennessee | 47087 | 217 | 1 |
485234 | 485234 | 2020-08-30 | Jackson | Tennessee | 47087 | 217 | 1 |
481999 | 481999 | 2020-08-29 | Jackson | Tennessee | 47087 | 214 | 1 |
478765 | 478765 | 2020-08-28 | Jackson | Tennessee | 47087 | 208 | 1 |
475532 | 475532 | 2020-08-27 | Jackson | Tennessee | 47087 | 203 | 1 |
472299 | 472299 | 2020-08-26 | Jackson | Tennessee | 47087 | 197 | 1 |
469067 | 469067 | 2020-08-25 | Jackson | Tennessee | 47087 | 193 | 1 |
465838 | 465838 | 2020-08-24 | Jackson | Tennessee | 47087 | 189 | 1 |
462609 | 462609 | 2020-08-23 | Jackson | Tennessee | 47087 | 189 | 1 |
459381 | 459381 | 2020-08-22 | Jackson | Tennessee | 47087 | 188 | 1 |
456153 | 456153 | 2020-08-21 | Jackson | Tennessee | 47087 | 187 | 1 |
452925 | 452925 | 2020-08-20 | Jackson | Tennessee | 47087 | 174 | 1 |
449697 | 449697 | 2020-08-19 | Jackson | Tennessee | 47087 | 170 | 1 |
446469 | 446469 | 2020-08-18 | Jackson | Tennessee | 47087 | 156 | 1 |
443243 | 443243 | 2020-08-17 | Jackson | Tennessee | 47087 | 153 | 1 |
440016 | 440016 | 2020-08-16 | Jackson | Tennessee | 47087 | 149 | 1 |
436791 | 436791 | 2020-08-15 | Jackson | Tennessee | 47087 | 144 | 1 |
433564 | 433564 | 2020-08-14 | Jackson | Tennessee | 47087 | 145 | 1 |
430339 | 430339 | 2020-08-13 | Jackson | Tennessee | 47087 | 137 | 1 |
427112 | 427112 | 2020-08-12 | Jackson | Tennessee | 47087 | 131 | 1 |
423889 | 423889 | 2020-08-11 | Jackson | Tennessee | 47087 | 130 | 1 |
420667 | 420667 | 2020-08-10 | Jackson | Tennessee | 47087 | 129 | 1 |
417446 | 417446 | 2020-08-09 | Jackson | Tennessee | 47087 | 127 | 1 |
414225 | 414225 | 2020-08-08 | Jackson | Tennessee | 47087 | 124 | 1 |
411005 | 411005 | 2020-08-07 | Jackson | Tennessee | 47087 | 118 | 1 |
407786 | 407786 | 2020-08-06 | Jackson | Tennessee | 47087 | 112 | 1 |
404566 | 404566 | 2020-08-05 | Jackson | Tennessee | 47087 | 109 | 1 |
401348 | 401348 | 2020-08-04 | Jackson | Tennessee | 47087 | 108 | 1 |
398133 | 398133 | 2020-08-03 | Jackson | Tennessee | 47087 | 106 | 1 |
394916 | 394916 | 2020-08-02 | Jackson | Tennessee | 47087 | 107 | 1 |
391700 | 391700 | 2020-08-01 | Jackson | Tennessee | 47087 | 105 | 1 |
388483 | 388483 | 2020-07-31 | Jackson | Tennessee | 47087 | 105 | 1 |
385266 | 385266 | 2020-07-30 | Jackson | Tennessee | 47087 | 103 | 0 |
382048 | 382048 | 2020-07-29 | Jackson | Tennessee | 47087 | 103 | 0 |
378831 | 378831 | 2020-07-28 | Jackson | Tennessee | 47087 | 99 | 0 |
375615 | 375615 | 2020-07-27 | Jackson | Tennessee | 47087 | 97 | 0 |
372402 | 372402 | 2020-07-26 | Jackson | Tennessee | 47087 | 97 | 0 |
369190 | 369190 | 2020-07-25 | Jackson | Tennessee | 47087 | 93 | 0 |
365981 | 365981 | 2020-07-24 | Jackson | Tennessee | 47087 | 93 | 0 |
362775 | 362775 | 2020-07-23 | Jackson | Tennessee | 47087 | 91 | 0 |
359568 | 359568 | 2020-07-22 | Jackson | Tennessee | 47087 | 90 | 0 |
356364 | 356364 | 2020-07-21 | Jackson | Tennessee | 47087 | 87 | 0 |
353161 | 353161 | 2020-07-20 | Jackson | Tennessee | 47087 | 72 | 0 |
349958 | 349958 | 2020-07-19 | Jackson | Tennessee | 47087 | 72 | 0 |
346758 | 346758 | 2020-07-18 | Jackson | Tennessee | 47087 | 72 | 0 |
343558 | 343558 | 2020-07-17 | Jackson | Tennessee | 47087 | 67 | 0 |
340360 | 340360 | 2020-07-16 | Jackson | Tennessee | 47087 | 65 | 0 |
337163 | 337163 | 2020-07-15 | Jackson | Tennessee | 47087 | 62 | 0 |
333969 | 333969 | 2020-07-14 | Jackson | Tennessee | 47087 | 52 | 0 |
330777 | 330777 | 2020-07-13 | Jackson | Tennessee | 47087 | 50 | 0 |
327591 | 327591 | 2020-07-12 | Jackson | Tennessee | 47087 | 47 | 0 |
324406 | 324406 | 2020-07-11 | Jackson | Tennessee | 47087 | 47 | 0 |
321225 | 321225 | 2020-07-10 | Jackson | Tennessee | 47087 | 46 | 0 |
318047 | 318047 | 2020-07-09 | Jackson | Tennessee | 47087 | 41 | 0 |
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);