ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Jackson" and fips = 22049 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636029 | 636029 | 2020-10-16 | Jackson | Louisiana | 22049 | 787 | 22 |
632783 | 632783 | 2020-10-15 | Jackson | Louisiana | 22049 | 780 | 22 |
629539 | 629539 | 2020-10-14 | Jackson | Louisiana | 22049 | 758 | 22 |
626295 | 626295 | 2020-10-13 | Jackson | Louisiana | 22049 | 753 | 22 |
623053 | 623053 | 2020-10-12 | Jackson | Louisiana | 22049 | 744 | 22 |
619809 | 619809 | 2020-10-11 | Jackson | Louisiana | 22049 | 745 | 22 |
616567 | 616567 | 2020-10-10 | Jackson | Louisiana | 22049 | 719 | 22 |
613326 | 613326 | 2020-10-09 | Jackson | Louisiana | 22049 | 719 | 22 |
610084 | 610084 | 2020-10-08 | Jackson | Louisiana | 22049 | 718 | 22 |
606842 | 606842 | 2020-10-07 | Jackson | Louisiana | 22049 | 703 | 22 |
603600 | 603600 | 2020-10-06 | Jackson | Louisiana | 22049 | 688 | 22 |
600357 | 600357 | 2020-10-05 | Jackson | Louisiana | 22049 | 692 | 22 |
597115 | 597115 | 2020-10-04 | Jackson | Louisiana | 22049 | 691 | 22 |
593873 | 593873 | 2020-10-03 | Jackson | Louisiana | 22049 | 675 | 22 |
590632 | 590632 | 2020-10-02 | Jackson | Louisiana | 22049 | 675 | 22 |
587391 | 587391 | 2020-10-01 | Jackson | Louisiana | 22049 | 668 | 22 |
584151 | 584151 | 2020-09-30 | Jackson | Louisiana | 22049 | 662 | 22 |
580911 | 580911 | 2020-09-29 | Jackson | Louisiana | 22049 | 655 | 22 |
577670 | 577670 | 2020-09-28 | Jackson | Louisiana | 22049 | 648 | 22 |
574428 | 574428 | 2020-09-27 | Jackson | Louisiana | 22049 | 649 | 22 |
571185 | 571185 | 2020-09-26 | Jackson | Louisiana | 22049 | 640 | 22 |
567943 | 567943 | 2020-09-25 | Jackson | Louisiana | 22049 | 640 | 22 |
564703 | 564703 | 2020-09-24 | Jackson | Louisiana | 22049 | 633 | 22 |
561463 | 561463 | 2020-09-23 | Jackson | Louisiana | 22049 | 632 | 22 |
558227 | 558227 | 2020-09-22 | Jackson | Louisiana | 22049 | 630 | 22 |
554990 | 554990 | 2020-09-21 | Jackson | Louisiana | 22049 | 628 | 22 |
551751 | 551751 | 2020-09-20 | Jackson | Louisiana | 22049 | 628 | 22 |
548512 | 548512 | 2020-09-19 | Jackson | Louisiana | 22049 | 611 | 22 |
545274 | 545274 | 2020-09-18 | Jackson | Louisiana | 22049 | 611 | 22 |
542038 | 542038 | 2020-09-17 | Jackson | Louisiana | 22049 | 603 | 22 |
538802 | 538802 | 2020-09-16 | Jackson | Louisiana | 22049 | 586 | 22 |
535565 | 535565 | 2020-09-15 | Jackson | Louisiana | 22049 | 586 | 23 |
532330 | 532330 | 2020-09-14 | Jackson | Louisiana | 22049 | 584 | 23 |
529093 | 529093 | 2020-09-13 | Jackson | Louisiana | 22049 | 584 | 23 |
525857 | 525857 | 2020-09-12 | Jackson | Louisiana | 22049 | 551 | 23 |
522621 | 522621 | 2020-09-11 | Jackson | Louisiana | 22049 | 551 | 23 |
519384 | 519384 | 2020-09-10 | Jackson | Louisiana | 22049 | 546 | 21 |
516149 | 516149 | 2020-09-09 | Jackson | Louisiana | 22049 | 543 | 21 |
512916 | 512916 | 2020-09-08 | Jackson | Louisiana | 22049 | 538 | 21 |
509684 | 509684 | 2020-09-07 | Jackson | Louisiana | 22049 | 535 | 21 |
506451 | 506451 | 2020-09-06 | Jackson | Louisiana | 22049 | 528 | 21 |
503217 | 503217 | 2020-09-05 | Jackson | Louisiana | 22049 | 513 | 21 |
499984 | 499984 | 2020-09-04 | Jackson | Louisiana | 22049 | 513 | 21 |
496750 | 496750 | 2020-09-03 | Jackson | Louisiana | 22049 | 496 | 21 |
493517 | 493517 | 2020-09-02 | Jackson | Louisiana | 22049 | 485 | 21 |
490283 | 490283 | 2020-09-01 | Jackson | Louisiana | 22049 | 475 | 21 |
487050 | 487050 | 2020-08-31 | Jackson | Louisiana | 22049 | 477 | 21 |
483815 | 483815 | 2020-08-30 | Jackson | Louisiana | 22049 | 470 | 21 |
480581 | 480581 | 2020-08-29 | Jackson | Louisiana | 22049 | 451 | 21 |
477348 | 477348 | 2020-08-28 | Jackson | Louisiana | 22049 | 451 | 21 |
474115 | 474115 | 2020-08-27 | Jackson | Louisiana | 22049 | 439 | 20 |
470883 | 470883 | 2020-08-26 | Jackson | Louisiana | 22049 | 431 | 20 |
467654 | 467654 | 2020-08-25 | Jackson | Louisiana | 22049 | 425 | 20 |
464425 | 464425 | 2020-08-24 | Jackson | Louisiana | 22049 | 421 | 20 |
461194 | 461194 | 2020-08-23 | Jackson | Louisiana | 22049 | 416 | 19 |
457967 | 457967 | 2020-08-22 | Jackson | Louisiana | 22049 | 409 | 20 |
454739 | 454739 | 2020-08-21 | Jackson | Louisiana | 22049 | 409 | 20 |
451511 | 451511 | 2020-08-20 | Jackson | Louisiana | 22049 | 406 | 19 |
448283 | 448283 | 2020-08-19 | Jackson | Louisiana | 22049 | 404 | 19 |
445056 | 445056 | 2020-08-18 | Jackson | Louisiana | 22049 | 403 | 19 |
441830 | 441830 | 2020-08-17 | Jackson | Louisiana | 22049 | 403 | 19 |
438603 | 438603 | 2020-08-16 | Jackson | Louisiana | 22049 | 402 | 19 |
435378 | 435378 | 2020-08-15 | Jackson | Louisiana | 22049 | 397 | 19 |
432153 | 432153 | 2020-08-14 | Jackson | Louisiana | 22049 | 397 | 19 |
428925 | 428925 | 2020-08-13 | Jackson | Louisiana | 22049 | 386 | 18 |
425701 | 425701 | 2020-08-12 | Jackson | Louisiana | 22049 | 383 | 18 |
422480 | 422480 | 2020-08-11 | Jackson | Louisiana | 22049 | 378 | 18 |
419258 | 419258 | 2020-08-10 | Jackson | Louisiana | 22049 | 376 | 18 |
416037 | 416037 | 2020-08-09 | Jackson | Louisiana | 22049 | 376 | 18 |
412817 | 412817 | 2020-08-08 | Jackson | Louisiana | 22049 | 368 | 18 |
409597 | 409597 | 2020-08-07 | Jackson | Louisiana | 22049 | 368 | 18 |
406377 | 406377 | 2020-08-06 | Jackson | Louisiana | 22049 | 368 | 18 |
403159 | 403159 | 2020-08-05 | Jackson | Louisiana | 22049 | 366 | 18 |
399942 | 399942 | 2020-08-04 | Jackson | Louisiana | 22049 | 361 | 18 |
396727 | 396727 | 2020-08-03 | Jackson | Louisiana | 22049 | 359 | 18 |
393511 | 393511 | 2020-08-02 | Jackson | Louisiana | 22049 | 357 | 18 |
390294 | 390294 | 2020-08-01 | Jackson | Louisiana | 22049 | 349 | 18 |
387077 | 387077 | 2020-07-31 | Jackson | Louisiana | 22049 | 349 | 18 |
383859 | 383859 | 2020-07-30 | Jackson | Louisiana | 22049 | 347 | 18 |
380642 | 380642 | 2020-07-29 | Jackson | Louisiana | 22049 | 345 | 18 |
377425 | 377425 | 2020-07-28 | Jackson | Louisiana | 22049 | 341 | 18 |
374210 | 374210 | 2020-07-27 | Jackson | Louisiana | 22049 | 340 | 18 |
370998 | 370998 | 2020-07-26 | Jackson | Louisiana | 22049 | 338 | 18 |
367788 | 367788 | 2020-07-25 | Jackson | Louisiana | 22049 | 332 | 18 |
364581 | 364581 | 2020-07-24 | Jackson | Louisiana | 22049 | 332 | 18 |
361374 | 361374 | 2020-07-23 | Jackson | Louisiana | 22049 | 330 | 18 |
358169 | 358169 | 2020-07-22 | Jackson | Louisiana | 22049 | 325 | 18 |
354966 | 354966 | 2020-07-21 | Jackson | Louisiana | 22049 | 320 | 18 |
351764 | 351764 | 2020-07-20 | Jackson | Louisiana | 22049 | 318 | 18 |
348564 | 348564 | 2020-07-19 | Jackson | Louisiana | 22049 | 276 | 18 |
345363 | 345363 | 2020-07-18 | Jackson | Louisiana | 22049 | 264 | 18 |
342163 | 342163 | 2020-07-17 | Jackson | Louisiana | 22049 | 264 | 18 |
338967 | 338967 | 2020-07-16 | Jackson | Louisiana | 22049 | 252 | 17 |
335771 | 335771 | 2020-07-15 | Jackson | Louisiana | 22049 | 247 | 17 |
332578 | 332578 | 2020-07-14 | Jackson | Louisiana | 22049 | 243 | 17 |
329391 | 329391 | 2020-07-13 | Jackson | Louisiana | 22049 | 236 | 17 |
326205 | 326205 | 2020-07-12 | Jackson | Louisiana | 22049 | 235 | 17 |
323022 | 323022 | 2020-07-11 | Jackson | Louisiana | 22049 | 234 | 17 |
319843 | 319843 | 2020-07-10 | Jackson | Louisiana | 22049 | 230 | 16 |
316668 | 316668 | 2020-07-09 | Jackson | Louisiana | 22049 | 221 | 16 |
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);