ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 22103 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090379 | 1090379 | 2021-03-05 | St. Tammany | Louisiana | 22103 | 24324 | 496 |
1087134 | 1087134 | 2021-03-04 | St. Tammany | Louisiana | 22103 | 24259 | 493 |
1083888 | 1083888 | 2021-03-03 | St. Tammany | Louisiana | 22103 | 24186 | 492 |
1080642 | 1080642 | 2021-03-02 | St. Tammany | Louisiana | 22103 | 24130 | 492 |
1077397 | 1077397 | 2021-03-01 | St. Tammany | Louisiana | 22103 | 24087 | 491 |
1074151 | 1074151 | 2021-02-28 | St. Tammany | Louisiana | 22103 | 24061 | 488 |
1070905 | 1070905 | 2021-02-27 | St. Tammany | Louisiana | 22103 | 23905 | 487 |
1067660 | 1067660 | 2021-02-26 | St. Tammany | Louisiana | 22103 | 23905 | 487 |
1064415 | 1064415 | 2021-02-25 | St. Tammany | Louisiana | 22103 | 23820 | 485 |
1061170 | 1061170 | 2021-02-24 | St. Tammany | Louisiana | 22103 | 23746 | 483 |
1057924 | 1057924 | 2021-02-23 | St. Tammany | Louisiana | 22103 | 23589 | 477 |
1054678 | 1054678 | 2021-02-22 | St. Tammany | Louisiana | 22103 | 23454 | 477 |
1051431 | 1051431 | 2021-02-21 | St. Tammany | Louisiana | 22103 | 23409 | 477 |
1048184 | 1048184 | 2021-02-20 | St. Tammany | Louisiana | 22103 | 23223 | 475 |
1044939 | 1044939 | 2021-02-19 | St. Tammany | Louisiana | 22103 | 23223 | 475 |
1041694 | 1041694 | 2021-02-18 | St. Tammany | Louisiana | 22103 | 23182 | 475 |
1038449 | 1038449 | 2021-02-17 | St. Tammany | Louisiana | 22103 | 23084 | 474 |
1035204 | 1035204 | 2021-02-16 | St. Tammany | Louisiana | 22103 | 23025 | 470 |
1031958 | 1031958 | 2021-02-15 | St. Tammany | Louisiana | 22103 | 23025 | 470 |
1028711 | 1028711 | 2021-02-14 | St. Tammany | Louisiana | 22103 | 22966 | 468 |
1025466 | 1025466 | 2021-02-13 | St. Tammany | Louisiana | 22103 | 22846 | 467 |
1022221 | 1022221 | 2021-02-12 | St. Tammany | Louisiana | 22103 | 22846 | 467 |
1018976 | 1018976 | 2021-02-11 | St. Tammany | Louisiana | 22103 | 22767 | 463 |
1015731 | 1015731 | 2021-02-10 | St. Tammany | Louisiana | 22103 | 22543 | 460 |
1012486 | 1012486 | 2021-02-09 | St. Tammany | Louisiana | 22103 | 22507 | 458 |
1009240 | 1009240 | 2021-02-08 | St. Tammany | Louisiana | 22103 | 22423 | 458 |
1005994 | 1005994 | 2021-02-07 | St. Tammany | Louisiana | 22103 | 22312 | 454 |
1002748 | 1002748 | 2021-02-06 | St. Tammany | Louisiana | 22103 | 22201 | 453 |
999502 | 999502 | 2021-02-05 | St. Tammany | Louisiana | 22103 | 22201 | 453 |
996256 | 996256 | 2021-02-04 | St. Tammany | Louisiana | 22103 | 22150 | 451 |
993010 | 993010 | 2021-02-03 | St. Tammany | Louisiana | 22103 | 22029 | 449 |
989764 | 989764 | 2021-02-02 | St. Tammany | Louisiana | 22103 | 21805 | 448 |
986517 | 986517 | 2021-02-01 | St. Tammany | Louisiana | 22103 | 21688 | 445 |
983270 | 983270 | 2021-01-31 | St. Tammany | Louisiana | 22103 | 21620 | 437 |
980024 | 980024 | 2021-01-30 | St. Tammany | Louisiana | 22103 | 21444 | 433 |
976778 | 976778 | 2021-01-29 | St. Tammany | Louisiana | 22103 | 21444 | 433 |
973533 | 973533 | 2021-01-28 | St. Tammany | Louisiana | 22103 | 21126 | 426 |
970288 | 970288 | 2021-01-27 | St. Tammany | Louisiana | 22103 | 20888 | 421 |
967044 | 967044 | 2021-01-26 | St. Tammany | Louisiana | 22103 | 20736 | 419 |
963799 | 963799 | 2021-01-25 | St. Tammany | Louisiana | 22103 | 20484 | 418 |
960554 | 960554 | 2021-01-24 | St. Tammany | Louisiana | 22103 | 20264 | 415 |
957308 | 957308 | 2021-01-23 | St. Tammany | Louisiana | 22103 | 20085 | 413 |
954063 | 954063 | 2021-01-22 | St. Tammany | Louisiana | 22103 | 20085 | 413 |
950818 | 950818 | 2021-01-21 | St. Tammany | Louisiana | 22103 | 19917 | 410 |
947572 | 947572 | 2021-01-20 | St. Tammany | Louisiana | 22103 | 19676 | 407 |
944325 | 944325 | 2021-01-19 | St. Tammany | Louisiana | 22103 | 19538 | 403 |
941080 | 941080 | 2021-01-18 | St. Tammany | Louisiana | 22103 | 19404 | 400 |
937835 | 937835 | 2021-01-17 | St. Tammany | Louisiana | 22103 | 19309 | 396 |
934590 | 934590 | 2021-01-16 | St. Tammany | Louisiana | 22103 | 18989 | 384 |
931345 | 931345 | 2021-01-15 | St. Tammany | Louisiana | 22103 | 18989 | 384 |
928100 | 928100 | 2021-01-14 | St. Tammany | Louisiana | 22103 | 18481 | 384 |
924854 | 924854 | 2021-01-13 | St. Tammany | Louisiana | 22103 | 17756 | 379 |
921609 | 921609 | 2021-01-12 | St. Tammany | Louisiana | 22103 | 17601 | 376 |
918364 | 918364 | 2021-01-11 | St. Tammany | Louisiana | 22103 | 17336 | 373 |
915119 | 915119 | 2021-01-10 | St. Tammany | Louisiana | 22103 | 17215 | 369 |
911874 | 911874 | 2021-01-09 | St. Tammany | Louisiana | 22103 | 16910 | 368 |
908629 | 908629 | 2021-01-08 | St. Tammany | Louisiana | 22103 | 16910 | 368 |
905383 | 905383 | 2021-01-07 | St. Tammany | Louisiana | 22103 | 16699 | 360 |
902138 | 902138 | 2021-01-06 | St. Tammany | Louisiana | 22103 | 16425 | 358 |
898893 | 898893 | 2021-01-05 | St. Tammany | Louisiana | 22103 | 16099 | 354 |
895648 | 895648 | 2021-01-04 | St. Tammany | Louisiana | 22103 | 15838 | 351 |
892401 | 892401 | 2021-01-03 | St. Tammany | Louisiana | 22103 | 15735 | 348 |
889155 | 889155 | 2021-01-02 | St. Tammany | Louisiana | 22103 | 15312 | 345 |
885909 | 885909 | 2021-01-01 | St. Tammany | Louisiana | 22103 | 15312 | 345 |
882664 | 882664 | 2020-12-31 | St. Tammany | Louisiana | 22103 | 15312 | 345 |
879419 | 879419 | 2020-12-30 | St. Tammany | Louisiana | 22103 | 15033 | 342 |
876174 | 876174 | 2020-12-29 | St. Tammany | Louisiana | 22103 | 14686 | 339 |
872929 | 872929 | 2020-12-28 | St. Tammany | Louisiana | 22103 | 14462 | 335 |
869684 | 869684 | 2020-12-27 | St. Tammany | Louisiana | 22103 | 14401 | 326 |
866439 | 866439 | 2020-12-26 | St. Tammany | Louisiana | 22103 | 14111 | 326 |
863194 | 863194 | 2020-12-25 | St. Tammany | Louisiana | 22103 | 14111 | 326 |
859949 | 859949 | 2020-12-24 | St. Tammany | Louisiana | 22103 | 14111 | 326 |
856704 | 856704 | 2020-12-23 | St. Tammany | Louisiana | 22103 | 13944 | 324 |
853459 | 853459 | 2020-12-22 | St. Tammany | Louisiana | 22103 | 13701 | 322 |
850214 | 850214 | 2020-12-21 | St. Tammany | Louisiana | 22103 | 13551 | 321 |
846969 | 846969 | 2020-12-20 | St. Tammany | Louisiana | 22103 | 13443 | 320 |
843723 | 843723 | 2020-12-19 | St. Tammany | Louisiana | 22103 | 13258 | 318 |
840478 | 840478 | 2020-12-18 | St. Tammany | Louisiana | 22103 | 13258 | 318 |
837233 | 837233 | 2020-12-17 | St. Tammany | Louisiana | 22103 | 13106 | 316 |
833987 | 833987 | 2020-12-16 | St. Tammany | Louisiana | 22103 | 12904 | 310 |
830740 | 830740 | 2020-12-15 | St. Tammany | Louisiana | 22103 | 12622 | 308 |
827494 | 827494 | 2020-12-14 | St. Tammany | Louisiana | 22103 | 12334 | 307 |
824247 | 824247 | 2020-12-13 | St. Tammany | Louisiana | 22103 | 12257 | 306 |
821001 | 821001 | 2020-12-12 | St. Tammany | Louisiana | 22103 | 12029 | 305 |
817755 | 817755 | 2020-12-11 | St. Tammany | Louisiana | 22103 | 12029 | 305 |
814509 | 814509 | 2020-12-10 | St. Tammany | Louisiana | 22103 | 11920 | 302 |
811264 | 811264 | 2020-12-09 | St. Tammany | Louisiana | 22103 | 11780 | 302 |
808019 | 808019 | 2020-12-08 | St. Tammany | Louisiana | 22103 | 11502 | 301 |
804774 | 804774 | 2020-12-07 | St. Tammany | Louisiana | 22103 | 11365 | 300 |
801529 | 801529 | 2020-12-06 | St. Tammany | Louisiana | 22103 | 11305 | 300 |
798284 | 798284 | 2020-12-05 | St. Tammany | Louisiana | 22103 | 11128 | 298 |
795039 | 795039 | 2020-12-04 | St. Tammany | Louisiana | 22103 | 11128 | 298 |
791794 | 791794 | 2020-12-03 | St. Tammany | Louisiana | 22103 | 10983 | 296 |
788549 | 788549 | 2020-12-02 | St. Tammany | Louisiana | 22103 | 10878 | 296 |
785305 | 785305 | 2020-12-01 | St. Tammany | Louisiana | 22103 | 10678 | 294 |
782060 | 782060 | 2020-11-30 | St. Tammany | Louisiana | 22103 | 10379 | 292 |
778814 | 778814 | 2020-11-29 | St. Tammany | Louisiana | 22103 | 10383 | 291 |
775569 | 775569 | 2020-11-28 | St. Tammany | Louisiana | 22103 | 10283 | 291 |
772324 | 772324 | 2020-11-27 | St. Tammany | Louisiana | 22103 | 10283 | 291 |
769079 | 769079 | 2020-11-26 | St. Tammany | Louisiana | 22103 | 9931 | 290 |
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);