ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
271 rows where county = "Jackson" and deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 20
- Oklahoma 65
- Iowa 50
- Alabama 43
- North Carolina 21
- Georgia 17
- Oregon 17
- Indiana 16
- Kansas 10
- South Dakota 6
- Louisiana 4
- Michigan 3
- Minnesota 3
- Tennessee 3
- Texas 3
- Illinois 2
- Kentucky 2
- Missouri 2
- West Virginia 2
- Mississippi 1
- Wisconsin 1
fips 20
county 1
- Jackson · 271 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
830926 | 830926 | 2020-12-15 | Jackson | Minnesota | 27063 | 697 | 3 |
827680 | 827680 | 2020-12-14 | Jackson | Minnesota | 27063 | 691 | 3 |
824433 | 824433 | 2020-12-13 | Jackson | Minnesota | 27063 | 688 | 3 |
738625 | 738625 | 2020-11-16 | Jackson | Wisconsin | 55053 | 1278 | 3 |
702261 | 702261 | 2020-11-05 | Jackson | South Dakota | 46071 | 147 | 3 |
699017 | 699017 | 2020-11-04 | Jackson | South Dakota | 46071 | 143 | 3 |
695774 | 695774 | 2020-11-03 | Jackson | South Dakota | 46071 | 141 | 3 |
690882 | 690882 | 2020-11-02 | Jackson | Iowa | 19097 | 796 | 3 |
692532 | 692532 | 2020-11-02 | Jackson | South Dakota | 46071 | 137 | 3 |
687637 | 687637 | 2020-11-01 | Jackson | Iowa | 19097 | 769 | 3 |
689288 | 689288 | 2020-11-01 | Jackson | South Dakota | 46071 | 137 | 3 |
684393 | 684393 | 2020-10-31 | Jackson | Iowa | 19097 | 750 | 3 |
686043 | 686043 | 2020-10-31 | Jackson | South Dakota | 46071 | 135 | 3 |
681150 | 681150 | 2020-10-30 | Jackson | Iowa | 19097 | 722 | 3 |
677907 | 677907 | 2020-10-29 | Jackson | Iowa | 19097 | 689 | 3 |
674664 | 674664 | 2020-10-28 | Jackson | Iowa | 19097 | 666 | 3 |
671422 | 671422 | 2020-10-27 | Jackson | Iowa | 19097 | 647 | 3 |
668179 | 668179 | 2020-10-26 | Jackson | Iowa | 19097 | 633 | 3 |
664935 | 664935 | 2020-10-25 | Jackson | Iowa | 19097 | 628 | 3 |
661690 | 661690 | 2020-10-24 | Jackson | Iowa | 19097 | 603 | 3 |
658446 | 658446 | 2020-10-23 | Jackson | Iowa | 19097 | 579 | 3 |
655201 | 655201 | 2020-10-22 | Jackson | Iowa | 19097 | 563 | 3 |
651956 | 651956 | 2020-10-21 | Jackson | Iowa | 19097 | 548 | 3 |
648712 | 648712 | 2020-10-20 | Jackson | Iowa | 19097 | 539 | 3 |
645467 | 645467 | 2020-10-19 | Jackson | Iowa | 19097 | 528 | 3 |
642220 | 642220 | 2020-10-18 | Jackson | Iowa | 19097 | 525 | 3 |
638973 | 638973 | 2020-10-17 | Jackson | Iowa | 19097 | 518 | 3 |
635727 | 635727 | 2020-10-16 | Jackson | Iowa | 19097 | 508 | 3 |
632481 | 632481 | 2020-10-15 | Jackson | Iowa | 19097 | 491 | 3 |
632575 | 632575 | 2020-10-15 | Jackson | Kansas | 20085 | 279 | 3 |
629237 | 629237 | 2020-10-14 | Jackson | Iowa | 19097 | 468 | 3 |
629331 | 629331 | 2020-10-14 | Jackson | Kansas | 20085 | 279 | 3 |
625994 | 625994 | 2020-10-13 | Jackson | Iowa | 19097 | 463 | 3 |
626088 | 626088 | 2020-10-13 | Jackson | Kansas | 20085 | 275 | 3 |
622752 | 622752 | 2020-10-12 | Jackson | Iowa | 19097 | 456 | 3 |
622846 | 622846 | 2020-10-12 | Jackson | Kansas | 20085 | 275 | 3 |
619508 | 619508 | 2020-10-11 | Jackson | Iowa | 19097 | 453 | 3 |
619602 | 619602 | 2020-10-11 | Jackson | Kansas | 20085 | 273 | 3 |
616266 | 616266 | 2020-10-10 | Jackson | Iowa | 19097 | 446 | 3 |
616360 | 616360 | 2020-10-10 | Jackson | Kansas | 20085 | 273 | 3 |
613025 | 613025 | 2020-10-09 | Jackson | Iowa | 19097 | 437 | 3 |
613119 | 613119 | 2020-10-09 | Jackson | Kansas | 20085 | 273 | 3 |
609783 | 609783 | 2020-10-08 | Jackson | Iowa | 19097 | 433 | 3 |
609877 | 609877 | 2020-10-08 | Jackson | Kansas | 20085 | 266 | 3 |
606540 | 606540 | 2020-10-07 | Jackson | Iowa | 19097 | 418 | 3 |
606634 | 606634 | 2020-10-07 | Jackson | Kansas | 20085 | 266 | 3 |
603298 | 603298 | 2020-10-06 | Jackson | Iowa | 19097 | 412 | 3 |
603392 | 603392 | 2020-10-06 | Jackson | Kansas | 20085 | 258 | 3 |
600055 | 600055 | 2020-10-05 | Jackson | Iowa | 19097 | 409 | 3 |
596813 | 596813 | 2020-10-04 | Jackson | Iowa | 19097 | 402 | 3 |
593571 | 593571 | 2020-10-03 | Jackson | Iowa | 19097 | 400 | 3 |
590330 | 590330 | 2020-10-02 | Jackson | Iowa | 19097 | 389 | 3 |
587089 | 587089 | 2020-10-01 | Jackson | Iowa | 19097 | 375 | 3 |
583849 | 583849 | 2020-09-30 | Jackson | Iowa | 19097 | 368 | 3 |
580610 | 580610 | 2020-09-29 | Jackson | Iowa | 19097 | 358 | 3 |
577369 | 577369 | 2020-09-28 | Jackson | Iowa | 19097 | 352 | 3 |
574127 | 574127 | 2020-09-27 | Jackson | Iowa | 19097 | 350 | 3 |
570884 | 570884 | 2020-09-26 | Jackson | Iowa | 19097 | 349 | 3 |
567642 | 567642 | 2020-09-25 | Jackson | Iowa | 19097 | 337 | 3 |
564402 | 564402 | 2020-09-24 | Jackson | Iowa | 19097 | 330 | 3 |
561162 | 561162 | 2020-09-23 | Jackson | Iowa | 19097 | 318 | 3 |
557926 | 557926 | 2020-09-22 | Jackson | Iowa | 19097 | 310 | 3 |
554689 | 554689 | 2020-09-21 | Jackson | Iowa | 19097 | 304 | 3 |
551450 | 551450 | 2020-09-20 | Jackson | Iowa | 19097 | 300 | 3 |
548211 | 548211 | 2020-09-19 | Jackson | Iowa | 19097 | 296 | 3 |
544973 | 544973 | 2020-09-18 | Jackson | Iowa | 19097 | 292 | 3 |
546366 | 546366 | 2020-09-18 | Jackson | Oregon | 41029 | 1021 | 3 |
541737 | 541737 | 2020-09-17 | Jackson | Iowa | 19097 | 284 | 3 |
543129 | 543129 | 2020-09-17 | Jackson | Oregon | 41029 | 1007 | 3 |
543457 | 543457 | 2020-09-17 | Jackson | Tennessee | 47087 | 294 | 3 |
538500 | 538500 | 2020-09-16 | Jackson | Iowa | 19097 | 277 | 3 |
539893 | 539893 | 2020-09-16 | Jackson | Oregon | 41029 | 994 | 3 |
540221 | 540221 | 2020-09-16 | Jackson | Tennessee | 47087 | 291 | 3 |
535264 | 535264 | 2020-09-15 | Jackson | Iowa | 19097 | 266 | 3 |
536656 | 536656 | 2020-09-15 | Jackson | Oregon | 41029 | 981 | 3 |
536984 | 536984 | 2020-09-15 | Jackson | Tennessee | 47087 | 285 | 3 |
532029 | 532029 | 2020-09-14 | Jackson | Iowa | 19097 | 265 | 3 |
533420 | 533420 | 2020-09-14 | Jackson | Oregon | 41029 | 971 | 3 |
530185 | 530185 | 2020-09-13 | Jackson | Oregon | 41029 | 967 | 3 |
526948 | 526948 | 2020-09-12 | Jackson | Oregon | 41029 | 954 | 3 |
523712 | 523712 | 2020-09-11 | Jackson | Oregon | 41029 | 943 | 3 |
520476 | 520476 | 2020-09-10 | Jackson | Oregon | 41029 | 936 | 3 |
517240 | 517240 | 2020-09-09 | Jackson | Oregon | 41029 | 928 | 3 |
514005 | 514005 | 2020-09-08 | Jackson | Oregon | 41029 | 921 | 3 |
510772 | 510772 | 2020-09-07 | Jackson | Oregon | 41029 | 904 | 3 |
507539 | 507539 | 2020-09-06 | Jackson | Oregon | 41029 | 895 | 3 |
504307 | 504307 | 2020-09-05 | Jackson | Oregon | 41029 | 882 | 3 |
501073 | 501073 | 2020-09-04 | Jackson | Oregon | 41029 | 864 | 3 |
497839 | 497839 | 2020-09-03 | Jackson | Oregon | 41029 | 853 | 3 |
494606 | 494606 | 2020-09-02 | Jackson | Oregon | 41029 | 835 | 3 |
400735 | 400735 | 2020-08-04 | Jackson | North Carolina | 37099 | 407 | 3 |
397520 | 397520 | 2020-08-03 | Jackson | North Carolina | 37099 | 395 | 3 |
394303 | 394303 | 2020-08-02 | Jackson | North Carolina | 37099 | 394 | 3 |
391087 | 391087 | 2020-08-01 | Jackson | North Carolina | 37099 | 395 | 3 |
387870 | 387870 | 2020-07-31 | Jackson | North Carolina | 37099 | 389 | 3 |
388097 | 388097 | 2020-07-31 | Jackson | Oklahoma | 40065 | 468 | 3 |
384653 | 384653 | 2020-07-30 | Jackson | North Carolina | 37099 | 382 | 3 |
384880 | 384880 | 2020-07-30 | Jackson | Oklahoma | 40065 | 442 | 3 |
381435 | 381435 | 2020-07-29 | Jackson | North Carolina | 37099 | 374 | 3 |
381662 | 381662 | 2020-07-29 | Jackson | Oklahoma | 40065 | 424 | 3 |
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);