ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22045 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947543 | 947543 | 2021-01-20 | Iberia | Louisiana | 22045 | 5691 | 132 |
944296 | 944296 | 2021-01-19 | Iberia | Louisiana | 22045 | 5651 | 132 |
941051 | 941051 | 2021-01-18 | Iberia | Louisiana | 22045 | 5611 | 132 |
937806 | 937806 | 2021-01-17 | Iberia | Louisiana | 22045 | 5594 | 130 |
934561 | 934561 | 2021-01-16 | Iberia | Louisiana | 22045 | 5537 | 127 |
931316 | 931316 | 2021-01-15 | Iberia | Louisiana | 22045 | 5537 | 127 |
928071 | 928071 | 2021-01-14 | Iberia | Louisiana | 22045 | 5508 | 127 |
924825 | 924825 | 2021-01-13 | Iberia | Louisiana | 22045 | 5449 | 126 |
921580 | 921580 | 2021-01-12 | Iberia | Louisiana | 22045 | 5426 | 125 |
918335 | 918335 | 2021-01-11 | Iberia | Louisiana | 22045 | 5343 | 125 |
915090 | 915090 | 2021-01-10 | Iberia | Louisiana | 22045 | 5325 | 125 |
911845 | 911845 | 2021-01-09 | Iberia | Louisiana | 22045 | 5262 | 124 |
908600 | 908600 | 2021-01-08 | Iberia | Louisiana | 22045 | 5262 | 124 |
905354 | 905354 | 2021-01-07 | Iberia | Louisiana | 22045 | 5238 | 125 |
902109 | 902109 | 2021-01-06 | Iberia | Louisiana | 22045 | 5139 | 123 |
898864 | 898864 | 2021-01-05 | Iberia | Louisiana | 22045 | 5067 | 122 |
895619 | 895619 | 2021-01-04 | Iberia | Louisiana | 22045 | 4920 | 122 |
892372 | 892372 | 2021-01-03 | Iberia | Louisiana | 22045 | 4917 | 120 |
889126 | 889126 | 2021-01-02 | Iberia | Louisiana | 22045 | 4840 | 120 |
885880 | 885880 | 2021-01-01 | Iberia | Louisiana | 22045 | 4840 | 120 |
882635 | 882635 | 2020-12-31 | Iberia | Louisiana | 22045 | 4840 | 120 |
879390 | 879390 | 2020-12-30 | Iberia | Louisiana | 22045 | 4769 | 120 |
876145 | 876145 | 2020-12-29 | Iberia | Louisiana | 22045 | 4642 | 120 |
872900 | 872900 | 2020-12-28 | Iberia | Louisiana | 22045 | 4623 | 120 |
869655 | 869655 | 2020-12-27 | Iberia | Louisiana | 22045 | 4606 | 120 |
866410 | 866410 | 2020-12-26 | Iberia | Louisiana | 22045 | 4587 | 120 |
863165 | 863165 | 2020-12-25 | Iberia | Louisiana | 22045 | 4587 | 120 |
859920 | 859920 | 2020-12-24 | Iberia | Louisiana | 22045 | 4587 | 120 |
856675 | 856675 | 2020-12-23 | Iberia | Louisiana | 22045 | 4543 | 119 |
853430 | 853430 | 2020-12-22 | Iberia | Louisiana | 22045 | 4504 | 118 |
850185 | 850185 | 2020-12-21 | Iberia | Louisiana | 22045 | 4417 | 115 |
846940 | 846940 | 2020-12-20 | Iberia | Louisiana | 22045 | 4411 | 115 |
843694 | 843694 | 2020-12-19 | Iberia | Louisiana | 22045 | 4366 | 114 |
840449 | 840449 | 2020-12-18 | Iberia | Louisiana | 22045 | 4366 | 114 |
837204 | 837204 | 2020-12-17 | Iberia | Louisiana | 22045 | 4321 | 114 |
833958 | 833958 | 2020-12-16 | Iberia | Louisiana | 22045 | 4291 | 114 |
830711 | 830711 | 2020-12-15 | Iberia | Louisiana | 22045 | 4252 | 114 |
827465 | 827465 | 2020-12-14 | Iberia | Louisiana | 22045 | 4192 | 113 |
824218 | 824218 | 2020-12-13 | Iberia | Louisiana | 22045 | 4186 | 113 |
820972 | 820972 | 2020-12-12 | Iberia | Louisiana | 22045 | 4111 | 113 |
817726 | 817726 | 2020-12-11 | Iberia | Louisiana | 22045 | 4111 | 113 |
814480 | 814480 | 2020-12-10 | Iberia | Louisiana | 22045 | 4070 | 111 |
811235 | 811235 | 2020-12-09 | Iberia | Louisiana | 22045 | 4043 | 110 |
807990 | 807990 | 2020-12-08 | Iberia | Louisiana | 22045 | 4000 | 110 |
804745 | 804745 | 2020-12-07 | Iberia | Louisiana | 22045 | 3941 | 110 |
801500 | 801500 | 2020-12-06 | Iberia | Louisiana | 22045 | 3917 | 110 |
798255 | 798255 | 2020-12-05 | Iberia | Louisiana | 22045 | 3862 | 110 |
795010 | 795010 | 2020-12-04 | Iberia | Louisiana | 22045 | 3862 | 110 |
791765 | 791765 | 2020-12-03 | Iberia | Louisiana | 22045 | 3832 | 110 |
788520 | 788520 | 2020-12-02 | Iberia | Louisiana | 22045 | 3773 | 110 |
785276 | 785276 | 2020-12-01 | Iberia | Louisiana | 22045 | 3772 | 107 |
782031 | 782031 | 2020-11-30 | Iberia | Louisiana | 22045 | 3691 | 107 |
778785 | 778785 | 2020-11-29 | Iberia | Louisiana | 22045 | 3687 | 106 |
775540 | 775540 | 2020-11-28 | Iberia | Louisiana | 22045 | 3671 | 106 |
772295 | 772295 | 2020-11-27 | Iberia | Louisiana | 22045 | 3671 | 106 |
769050 | 769050 | 2020-11-26 | Iberia | Louisiana | 22045 | 3603 | 105 |
765804 | 765804 | 2020-11-25 | Iberia | Louisiana | 22045 | 3603 | 105 |
762559 | 762559 | 2020-11-24 | Iberia | Louisiana | 22045 | 3592 | 104 |
759314 | 759314 | 2020-11-23 | Iberia | Louisiana | 22045 | 3524 | 104 |
756067 | 756067 | 2020-11-22 | Iberia | Louisiana | 22045 | 3515 | 104 |
752821 | 752821 | 2020-11-21 | Iberia | Louisiana | 22045 | 3446 | 104 |
749575 | 749575 | 2020-11-20 | Iberia | Louisiana | 22045 | 3446 | 104 |
746329 | 746329 | 2020-11-19 | Iberia | Louisiana | 22045 | 3433 | 103 |
743082 | 743082 | 2020-11-18 | Iberia | Louisiana | 22045 | 3405 | 103 |
739835 | 739835 | 2020-11-17 | Iberia | Louisiana | 22045 | 3392 | 103 |
736591 | 736591 | 2020-11-16 | Iberia | Louisiana | 22045 | 3321 | 103 |
733345 | 733345 | 2020-11-15 | Iberia | Louisiana | 22045 | 3313 | 102 |
730100 | 730100 | 2020-11-14 | Iberia | Louisiana | 22045 | 3280 | 102 |
726857 | 726857 | 2020-11-13 | Iberia | Louisiana | 22045 | 3280 | 102 |
723614 | 723614 | 2020-11-12 | Iberia | Louisiana | 22045 | 3166 | 99 |
720371 | 720371 | 2020-11-11 | Iberia | Louisiana | 22045 | 3153 | 99 |
717128 | 717128 | 2020-11-10 | Iberia | Louisiana | 22045 | 3153 | 99 |
713884 | 713884 | 2020-11-09 | Iberia | Louisiana | 22045 | 3126 | 99 |
710640 | 710640 | 2020-11-08 | Iberia | Louisiana | 22045 | 3122 | 99 |
707396 | 707396 | 2020-11-07 | Iberia | Louisiana | 22045 | 3116 | 99 |
704153 | 704153 | 2020-11-06 | Iberia | Louisiana | 22045 | 3116 | 99 |
700911 | 700911 | 2020-11-05 | Iberia | Louisiana | 22045 | 3114 | 98 |
697667 | 697667 | 2020-11-04 | Iberia | Louisiana | 22045 | 3111 | 97 |
694424 | 694424 | 2020-11-03 | Iberia | Louisiana | 22045 | 3112 | 97 |
691182 | 691182 | 2020-11-02 | Iberia | Louisiana | 22045 | 3084 | 97 |
687937 | 687937 | 2020-11-01 | Iberia | Louisiana | 22045 | 3088 | 97 |
684693 | 684693 | 2020-10-31 | Iberia | Louisiana | 22045 | 3079 | 97 |
681450 | 681450 | 2020-10-30 | Iberia | Louisiana | 22045 | 3079 | 97 |
678206 | 678206 | 2020-10-29 | Iberia | Louisiana | 22045 | 3081 | 97 |
674964 | 674964 | 2020-10-28 | Iberia | Louisiana | 22045 | 3080 | 97 |
671721 | 671721 | 2020-10-27 | Iberia | Louisiana | 22045 | 3072 | 96 |
668479 | 668479 | 2020-10-26 | Iberia | Louisiana | 22045 | 3068 | 95 |
665235 | 665235 | 2020-10-25 | Iberia | Louisiana | 22045 | 3062 | 95 |
661990 | 661990 | 2020-10-24 | Iberia | Louisiana | 22045 | 3059 | 95 |
658746 | 658746 | 2020-10-23 | Iberia | Louisiana | 22045 | 3059 | 95 |
655501 | 655501 | 2020-10-22 | Iberia | Louisiana | 22045 | 3060 | 93 |
652256 | 652256 | 2020-10-21 | Iberia | Louisiana | 22045 | 3049 | 93 |
649011 | 649011 | 2020-10-20 | Iberia | Louisiana | 22045 | 3043 | 93 |
645767 | 645767 | 2020-10-19 | Iberia | Louisiana | 22045 | 3032 | 93 |
642520 | 642520 | 2020-10-18 | Iberia | Louisiana | 22045 | 3036 | 93 |
639273 | 639273 | 2020-10-17 | Iberia | Louisiana | 22045 | 3029 | 93 |
636027 | 636027 | 2020-10-16 | Iberia | Louisiana | 22045 | 3029 | 93 |
632781 | 632781 | 2020-10-15 | Iberia | Louisiana | 22045 | 3027 | 93 |
629537 | 629537 | 2020-10-14 | Iberia | Louisiana | 22045 | 3026 | 92 |
626293 | 626293 | 2020-10-13 | Iberia | Louisiana | 22045 | 3021 | 92 |
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);