ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where county = "Jackson" and deaths = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
905569 | 905569 | 2021-01-07 | Jackson | Minnesota | 27063 | 817 | 9 |
801294 | 801294 | 2020-12-06 | Jackson | Kansas | 20085 | 762 | 9 |
798049 | 798049 | 2020-12-05 | Jackson | Kansas | 20085 | 762 | 9 |
794804 | 794804 | 2020-12-04 | Jackson | Kansas | 20085 | 762 | 9 |
791559 | 791559 | 2020-12-03 | Jackson | Kansas | 20085 | 735 | 9 |
787522 | 787522 | 2020-12-02 | Jackson | Arkansas | 5067 | 1868 | 9 |
788314 | 788314 | 2020-12-02 | Jackson | Kansas | 20085 | 735 | 9 |
757495 | 757495 | 2020-11-22 | Jackson | Tennessee | 47087 | 657 | 9 |
754248 | 754248 | 2020-11-21 | Jackson | Tennessee | 47087 | 652 | 9 |
751002 | 751002 | 2020-11-20 | Jackson | Tennessee | 47087 | 650 | 9 |
747756 | 747756 | 2020-11-19 | Jackson | Tennessee | 47087 | 639 | 9 |
744510 | 744510 | 2020-11-18 | Jackson | Tennessee | 47087 | 634 | 9 |
705109 | 705109 | 2020-11-06 | Jackson | Ohio | 39079 | 601 | 9 |
701866 | 701866 | 2020-11-05 | Jackson | Ohio | 39079 | 590 | 9 |
698622 | 698622 | 2020-11-04 | Jackson | Ohio | 39079 | 578 | 9 |
695379 | 695379 | 2020-11-03 | Jackson | Ohio | 39079 | 561 | 9 |
533360 | 533360 | 2020-09-14 | Jackson | Oklahoma | 40065 | 650 | 9 |
530125 | 530125 | 2020-09-13 | Jackson | Oklahoma | 40065 | 649 | 9 |
526888 | 526888 | 2020-09-12 | Jackson | Oklahoma | 40065 | 646 | 9 |
523652 | 523652 | 2020-09-11 | Jackson | Oklahoma | 40065 | 642 | 9 |
520416 | 520416 | 2020-09-10 | Jackson | Oklahoma | 40065 | 637 | 9 |
515043 | 515043 | 2020-09-09 | Jackson | Alabama | 1071 | 1385 | 9 |
517180 | 517180 | 2020-09-09 | Jackson | Oklahoma | 40065 | 628 | 9 |
511810 | 511810 | 2020-09-08 | Jackson | Alabama | 1071 | 1380 | 9 |
513945 | 513945 | 2020-09-08 | Jackson | Oklahoma | 40065 | 626 | 9 |
508577 | 508577 | 2020-09-07 | Jackson | Alabama | 1071 | 1375 | 9 |
510712 | 510712 | 2020-09-07 | Jackson | Oklahoma | 40065 | 623 | 9 |
505345 | 505345 | 2020-09-06 | Jackson | Alabama | 1071 | 1372 | 9 |
507479 | 507479 | 2020-09-06 | Jackson | Oklahoma | 40065 | 620 | 9 |
502111 | 502111 | 2020-09-05 | Jackson | Alabama | 1071 | 1367 | 9 |
504247 | 504247 | 2020-09-05 | Jackson | Oklahoma | 40065 | 616 | 9 |
498877 | 498877 | 2020-09-04 | Jackson | Alabama | 1071 | 1360 | 9 |
501013 | 501013 | 2020-09-04 | Jackson | Oklahoma | 40065 | 614 | 9 |
495644 | 495644 | 2020-09-03 | Jackson | Alabama | 1071 | 1343 | 9 |
497779 | 497779 | 2020-09-03 | Jackson | Oklahoma | 40065 | 602 | 9 |
492410 | 492410 | 2020-09-02 | Jackson | Alabama | 1071 | 1335 | 9 |
494546 | 494546 | 2020-09-02 | Jackson | Oklahoma | 40065 | 597 | 9 |
489177 | 489177 | 2020-09-01 | Jackson | Alabama | 1071 | 1322 | 9 |
491312 | 491312 | 2020-09-01 | Jackson | Oklahoma | 40065 | 596 | 9 |
485944 | 485944 | 2020-08-31 | Jackson | Alabama | 1071 | 1318 | 9 |
488079 | 488079 | 2020-08-31 | Jackson | Oklahoma | 40065 | 596 | 9 |
482709 | 482709 | 2020-08-30 | Jackson | Alabama | 1071 | 1317 | 9 |
483409 | 483409 | 2020-08-30 | Jackson | Indiana | 18071 | 700 | 9 |
484846 | 484846 | 2020-08-30 | Jackson | Oklahoma | 40065 | 591 | 9 |
479475 | 479475 | 2020-08-29 | Jackson | Alabama | 1071 | 1301 | 9 |
480175 | 480175 | 2020-08-29 | Jackson | Indiana | 18071 | 692 | 9 |
481611 | 481611 | 2020-08-29 | Jackson | Oklahoma | 40065 | 582 | 9 |
476242 | 476242 | 2020-08-28 | Jackson | Alabama | 1071 | 1290 | 9 |
476942 | 476942 | 2020-08-28 | Jackson | Indiana | 18071 | 688 | 9 |
473009 | 473009 | 2020-08-27 | Jackson | Alabama | 1071 | 1280 | 9 |
473709 | 473709 | 2020-08-27 | Jackson | Indiana | 18071 | 685 | 9 |
427283 | 427283 | 2020-08-12 | Jackson | Texas | 48239 | 411 | 9 |
271811 | 271811 | 2020-06-25 | Jackson | Georgia | 13157 | 337 | 9 |
152300 | 152300 | 2020-05-17 | Jackson | Louisiana | 22049 | 69 | 9 |
149289 | 149289 | 2020-05-16 | Jackson | Louisiana | 22049 | 68 | 9 |
118919 | 118919 | 2020-05-06 | Jackson | Illinois | 17077 | 154 | 9 |
115959 | 115959 | 2020-05-05 | Jackson | Illinois | 17077 | 146 | 9 |
116711 | 116711 | 2020-05-05 | Jackson | Mississippi | 28059 | 270 | 9 |
113076 | 113076 | 2020-05-04 | Jackson | Illinois | 17077 | 140 | 9 |
110201 | 110201 | 2020-05-03 | Jackson | Illinois | 17077 | 139 | 9 |
107331 | 107331 | 2020-05-02 | Jackson | Illinois | 17077 | 125 | 9 |
104466 | 104466 | 2020-05-01 | Jackson | Illinois | 17077 | 120 | 9 |
92369 | 92369 | 2020-04-26 | Jackson | West Virginia | 54035 | 127 | 9 |
60545 | 60545 | 2020-04-15 | Jackson | Missouri | 29095 | 243 | 9 |
57832 | 57832 | 2020-04-14 | Jackson | Missouri | 29095 | 237 | 9 |
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);