ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Caddo" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947529 | 947529 | 2021-01-20 | Caddo | Louisiana | 22017 | 21265 | 586 |
944282 | 944282 | 2021-01-19 | Caddo | Louisiana | 22017 | 21115 | 576 |
941037 | 941037 | 2021-01-18 | Caddo | Louisiana | 22017 | 21035 | 572 |
937792 | 937792 | 2021-01-17 | Caddo | Louisiana | 22017 | 20934 | 566 |
934547 | 934547 | 2021-01-16 | Caddo | Louisiana | 22017 | 20685 | 561 |
931302 | 931302 | 2021-01-15 | Caddo | Louisiana | 22017 | 20685 | 561 |
928057 | 928057 | 2021-01-14 | Caddo | Louisiana | 22017 | 20490 | 561 |
924811 | 924811 | 2021-01-13 | Caddo | Louisiana | 22017 | 20341 | 560 |
921566 | 921566 | 2021-01-12 | Caddo | Louisiana | 22017 | 20077 | 558 |
918321 | 918321 | 2021-01-11 | Caddo | Louisiana | 22017 | 19894 | 552 |
915076 | 915076 | 2021-01-10 | Caddo | Louisiana | 22017 | 19788 | 537 |
911831 | 911831 | 2021-01-09 | Caddo | Louisiana | 22017 | 19335 | 534 |
908586 | 908586 | 2021-01-08 | Caddo | Louisiana | 22017 | 19335 | 534 |
905340 | 905340 | 2021-01-07 | Caddo | Louisiana | 22017 | 19113 | 527 |
902095 | 902095 | 2021-01-06 | Caddo | Louisiana | 22017 | 18834 | 523 |
898850 | 898850 | 2021-01-05 | Caddo | Louisiana | 22017 | 18610 | 523 |
895605 | 895605 | 2021-01-04 | Caddo | Louisiana | 22017 | 18308 | 522 |
892358 | 892358 | 2021-01-03 | Caddo | Louisiana | 22017 | 18245 | 521 |
889112 | 889112 | 2021-01-02 | Caddo | Louisiana | 22017 | 17819 | 517 |
885866 | 885866 | 2021-01-01 | Caddo | Louisiana | 22017 | 17819 | 517 |
882621 | 882621 | 2020-12-31 | Caddo | Louisiana | 22017 | 17819 | 517 |
879376 | 879376 | 2020-12-30 | Caddo | Louisiana | 22017 | 17594 | 516 |
876131 | 876131 | 2020-12-29 | Caddo | Louisiana | 22017 | 17296 | 514 |
872886 | 872886 | 2020-12-28 | Caddo | Louisiana | 22017 | 17135 | 511 |
869641 | 869641 | 2020-12-27 | Caddo | Louisiana | 22017 | 17029 | 511 |
866396 | 866396 | 2020-12-26 | Caddo | Louisiana | 22017 | 16792 | 508 |
863151 | 863151 | 2020-12-25 | Caddo | Louisiana | 22017 | 16792 | 508 |
859906 | 859906 | 2020-12-24 | Caddo | Louisiana | 22017 | 16792 | 508 |
856661 | 856661 | 2020-12-23 | Caddo | Louisiana | 22017 | 16621 | 501 |
853416 | 853416 | 2020-12-22 | Caddo | Louisiana | 22017 | 16402 | 495 |
850171 | 850171 | 2020-12-21 | Caddo | Louisiana | 22017 | 16240 | 492 |
846926 | 846926 | 2020-12-20 | Caddo | Louisiana | 22017 | 16160 | 481 |
843680 | 843680 | 2020-12-19 | Caddo | Louisiana | 22017 | 15909 | 476 |
840435 | 840435 | 2020-12-18 | Caddo | Louisiana | 22017 | 15909 | 476 |
837190 | 837190 | 2020-12-17 | Caddo | Louisiana | 22017 | 15768 | 476 |
833944 | 833944 | 2020-12-16 | Caddo | Louisiana | 22017 | 15532 | 475 |
830697 | 830697 | 2020-12-15 | Caddo | Louisiana | 22017 | 15359 | 475 |
827451 | 827451 | 2020-12-14 | Caddo | Louisiana | 22017 | 15280 | 472 |
824204 | 824204 | 2020-12-13 | Caddo | Louisiana | 22017 | 15245 | 471 |
820958 | 820958 | 2020-12-12 | Caddo | Louisiana | 22017 | 15070 | 471 |
817712 | 817712 | 2020-12-11 | Caddo | Louisiana | 22017 | 15070 | 471 |
814466 | 814466 | 2020-12-10 | Caddo | Louisiana | 22017 | 14879 | 469 |
811221 | 811221 | 2020-12-09 | Caddo | Louisiana | 22017 | 14744 | 468 |
807976 | 807976 | 2020-12-08 | Caddo | Louisiana | 22017 | 14649 | 466 |
804731 | 804731 | 2020-12-07 | Caddo | Louisiana | 22017 | 14507 | 465 |
801486 | 801486 | 2020-12-06 | Caddo | Louisiana | 22017 | 14454 | 458 |
798241 | 798241 | 2020-12-05 | Caddo | Louisiana | 22017 | 14271 | 449 |
794996 | 794996 | 2020-12-04 | Caddo | Louisiana | 22017 | 14271 | 449 |
791751 | 791751 | 2020-12-03 | Caddo | Louisiana | 22017 | 14090 | 448 |
788506 | 788506 | 2020-12-02 | Caddo | Louisiana | 22017 | 13926 | 448 |
785262 | 785262 | 2020-12-01 | Caddo | Louisiana | 22017 | 13539 | 446 |
782017 | 782017 | 2020-11-30 | Caddo | Louisiana | 22017 | 13254 | 446 |
778771 | 778771 | 2020-11-29 | Caddo | Louisiana | 22017 | 13247 | 445 |
775526 | 775526 | 2020-11-28 | Caddo | Louisiana | 22017 | 13183 | 445 |
772281 | 772281 | 2020-11-27 | Caddo | Louisiana | 22017 | 13183 | 445 |
769036 | 769036 | 2020-11-26 | Caddo | Louisiana | 22017 | 12879 | 444 |
765790 | 765790 | 2020-11-25 | Caddo | Louisiana | 22017 | 12879 | 444 |
762545 | 762545 | 2020-11-24 | Caddo | Louisiana | 22017 | 12765 | 441 |
759300 | 759300 | 2020-11-23 | Caddo | Louisiana | 22017 | 12602 | 440 |
756053 | 756053 | 2020-11-22 | Caddo | Louisiana | 22017 | 12566 | 437 |
752807 | 752807 | 2020-11-21 | Caddo | Louisiana | 22017 | 12329 | 434 |
749561 | 749561 | 2020-11-20 | Caddo | Louisiana | 22017 | 12329 | 434 |
746315 | 746315 | 2020-11-19 | Caddo | Louisiana | 22017 | 11928 | 428 |
743068 | 743068 | 2020-11-18 | Caddo | Louisiana | 22017 | 11799 | 428 |
739821 | 739821 | 2020-11-17 | Caddo | Louisiana | 22017 | 11705 | 427 |
736577 | 736577 | 2020-11-16 | Caddo | Louisiana | 22017 | 11580 | 427 |
733331 | 733331 | 2020-11-15 | Caddo | Louisiana | 22017 | 11535 | 427 |
730086 | 730086 | 2020-11-14 | Caddo | Louisiana | 22017 | 11374 | 427 |
726843 | 726843 | 2020-11-13 | Caddo | Louisiana | 22017 | 11374 | 427 |
723600 | 723600 | 2020-11-12 | Caddo | Louisiana | 22017 | 11136 | 417 |
720357 | 720357 | 2020-11-11 | Caddo | Louisiana | 22017 | 10953 | 413 |
717114 | 717114 | 2020-11-10 | Caddo | Louisiana | 22017 | 10953 | 413 |
713870 | 713870 | 2020-11-09 | Caddo | Louisiana | 22017 | 10881 | 411 |
710626 | 710626 | 2020-11-08 | Caddo | Louisiana | 22017 | 10825 | 406 |
707382 | 707382 | 2020-11-07 | Caddo | Louisiana | 22017 | 10679 | 406 |
704139 | 704139 | 2020-11-06 | Caddo | Louisiana | 22017 | 10679 | 406 |
700897 | 700897 | 2020-11-05 | Caddo | Louisiana | 22017 | 10594 | 404 |
697653 | 697653 | 2020-11-04 | Caddo | Louisiana | 22017 | 10528 | 402 |
694410 | 694410 | 2020-11-03 | Caddo | Louisiana | 22017 | 10469 | 402 |
691168 | 691168 | 2020-11-02 | Caddo | Louisiana | 22017 | 10370 | 396 |
687923 | 687923 | 2020-11-01 | Caddo | Louisiana | 22017 | 10350 | 396 |
684679 | 684679 | 2020-10-31 | Caddo | Louisiana | 22017 | 10262 | 396 |
681436 | 681436 | 2020-10-30 | Caddo | Louisiana | 22017 | 10262 | 396 |
678192 | 678192 | 2020-10-29 | Caddo | Louisiana | 22017 | 10206 | 396 |
674950 | 674950 | 2020-10-28 | Caddo | Louisiana | 22017 | 10146 | 395 |
671707 | 671707 | 2020-10-27 | Caddo | Louisiana | 22017 | 10105 | 395 |
668465 | 668465 | 2020-10-26 | Caddo | Louisiana | 22017 | 10046 | 394 |
665221 | 665221 | 2020-10-25 | Caddo | Louisiana | 22017 | 10025 | 392 |
661976 | 661976 | 2020-10-24 | Caddo | Louisiana | 22017 | 9928 | 392 |
658732 | 658732 | 2020-10-23 | Caddo | Louisiana | 22017 | 9928 | 392 |
655487 | 655487 | 2020-10-22 | Caddo | Louisiana | 22017 | 9855 | 391 |
652242 | 652242 | 2020-10-21 | Caddo | Louisiana | 22017 | 9784 | 390 |
648997 | 648997 | 2020-10-20 | Caddo | Louisiana | 22017 | 9729 | 388 |
645753 | 645753 | 2020-10-19 | Caddo | Louisiana | 22017 | 9670 | 387 |
642506 | 642506 | 2020-10-18 | Caddo | Louisiana | 22017 | 9649 | 385 |
639259 | 639259 | 2020-10-17 | Caddo | Louisiana | 22017 | 9532 | 382 |
636013 | 636013 | 2020-10-16 | Caddo | Louisiana | 22017 | 9532 | 382 |
632767 | 632767 | 2020-10-15 | Caddo | Louisiana | 22017 | 9478 | 381 |
629523 | 629523 | 2020-10-14 | Caddo | Louisiana | 22017 | 9348 | 380 |
626279 | 626279 | 2020-10-13 | Caddo | Louisiana | 22017 | 9329 | 380 |
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);