ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Unknown" and state = "Louisiana" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4004 | 4004 | 2020-03-18 | Unknown | Louisiana | 2 | 0 | |
4704 | 4704 | 2020-03-19 | Unknown | Louisiana | 3 | 0 | |
5522 | 5522 | 2020-03-20 | Unknown | Louisiana | 5 | 0 | |
6477 | 6477 | 2020-03-21 | Unknown | Louisiana | 9 | 0 | |
7552 | 7552 | 2020-03-22 | Unknown | Louisiana | 11 | 0 | |
8721 | 8721 | 2020-03-23 | Unknown | Louisiana | 12 | 0 | |
20453 | 20453 | 2020-03-30 | Unknown | Louisiana | 14 | 0 | |
24738 | 24738 | 2020-04-01 | Unknown | Louisiana | 28 | 0 | |
31684 | 31684 | 2020-04-04 | Unknown | Louisiana | 35 | 0 | |
54804 | 54804 | 2020-04-13 | Unknown | Louisiana | 56 | 0 | |
57502 | 57502 | 2020-04-14 | Unknown | Louisiana | 56 | 0 | |
726891 | 726891 | 2020-11-13 | Unknown | Louisiana | 316 | 0 | |
730134 | 730134 | 2020-11-14 | Unknown | Louisiana | 317 | 0 | |
733379 | 733379 | 2020-11-15 | Unknown | Louisiana | 325 | 0 | |
736625 | 736625 | 2020-11-16 | Unknown | Louisiana | 325 | 0 | |
739869 | 739869 | 2020-11-17 | Unknown | Louisiana | 316 | 0 | |
743116 | 743116 | 2020-11-18 | Unknown | Louisiana | 330 | 0 | |
746363 | 746363 | 2020-11-19 | Unknown | Louisiana | 345 | 0 | |
749609 | 749609 | 2020-11-20 | Unknown | Louisiana | 357 | 0 | |
752855 | 752855 | 2020-11-21 | Unknown | Louisiana | 357 | 0 | |
756101 | 756101 | 2020-11-22 | Unknown | Louisiana | 373 | 0 | |
759348 | 759348 | 2020-11-23 | Unknown | Louisiana | 375 | 0 | |
762593 | 762593 | 2020-11-24 | Unknown | Louisiana | 354 | 0 | |
765838 | 765838 | 2020-11-25 | Unknown | Louisiana | 361 | 0 | |
769084 | 769084 | 2020-11-26 | Unknown | Louisiana | 361 | 0 | |
772329 | 772329 | 2020-11-27 | Unknown | Louisiana | 382 | 0 | |
775574 | 775574 | 2020-11-28 | Unknown | Louisiana | 382 | 0 | |
778819 | 778819 | 2020-11-29 | Unknown | Louisiana | 383 | 0 | |
782065 | 782065 | 2020-11-30 | Unknown | Louisiana | 384 | 0 | |
785310 | 785310 | 2020-12-01 | Unknown | Louisiana | 406 | 0 | |
788554 | 788554 | 2020-12-02 | Unknown | Louisiana | 392 | 0 | |
791799 | 791799 | 2020-12-03 | Unknown | Louisiana | 401 | 0 | |
795044 | 795044 | 2020-12-04 | Unknown | Louisiana | 404 | 0 | |
798289 | 798289 | 2020-12-05 | Unknown | Louisiana | 404 | 0 | |
801534 | 801534 | 2020-12-06 | Unknown | Louisiana | 412 | 0 | |
804779 | 804779 | 2020-12-07 | Unknown | Louisiana | 416 | 0 | |
808024 | 808024 | 2020-12-08 | Unknown | Louisiana | 422 | 0 | |
811269 | 811269 | 2020-12-09 | Unknown | Louisiana | 389 | 0 | |
814514 | 814514 | 2020-12-10 | Unknown | Louisiana | 399 | 0 | |
817760 | 817760 | 2020-12-11 | Unknown | Louisiana | 410 | 0 | |
821006 | 821006 | 2020-12-12 | Unknown | Louisiana | 410 | 0 | |
824252 | 824252 | 2020-12-13 | Unknown | Louisiana | 416 | 0 | |
827499 | 827499 | 2020-12-14 | Unknown | Louisiana | 423 | 0 | |
830745 | 830745 | 2020-12-15 | Unknown | Louisiana | 380 | 0 | |
833992 | 833992 | 2020-12-16 | Unknown | Louisiana | 388 | 0 | |
837238 | 837238 | 2020-12-17 | Unknown | Louisiana | 388 | 0 | |
840483 | 840483 | 2020-12-18 | Unknown | Louisiana | 398 | 0 | |
843728 | 843728 | 2020-12-19 | Unknown | Louisiana | 398 | 0 | |
846974 | 846974 | 2020-12-20 | Unknown | Louisiana | 409 | 0 | |
850219 | 850219 | 2020-12-21 | Unknown | Louisiana | 413 | 0 | |
853464 | 853464 | 2020-12-22 | Unknown | Louisiana | 398 | 0 | |
856709 | 856709 | 2020-12-23 | Unknown | Louisiana | 405 | 0 | |
859954 | 859954 | 2020-12-24 | Unknown | Louisiana | 410 | 0 | |
863199 | 863199 | 2020-12-25 | Unknown | Louisiana | 410 | 0 | |
866444 | 866444 | 2020-12-26 | Unknown | Louisiana | 410 | 0 | |
869689 | 869689 | 2020-12-27 | Unknown | Louisiana | 411 | 0 | |
872934 | 872934 | 2020-12-28 | Unknown | Louisiana | 418 | 0 | |
876179 | 876179 | 2020-12-29 | Unknown | Louisiana | 401 | 0 | |
879424 | 879424 | 2020-12-30 | Unknown | Louisiana | 402 | 0 | |
882669 | 882669 | 2020-12-31 | Unknown | Louisiana | 399 | 0 | |
885914 | 885914 | 2021-01-01 | Unknown | Louisiana | 399 | 0 | |
889160 | 889160 | 2021-01-02 | Unknown | Louisiana | 399 | 0 | |
892406 | 892406 | 2021-01-03 | Unknown | Louisiana | 409 | 0 | |
895653 | 895653 | 2021-01-04 | Unknown | Louisiana | 411 | 0 | |
898898 | 898898 | 2021-01-05 | Unknown | Louisiana | 400 | 0 | |
902143 | 902143 | 2021-01-06 | Unknown | Louisiana | 410 | 0 | |
905388 | 905388 | 2021-01-07 | Unknown | Louisiana | 417 | 0 | |
908634 | 908634 | 2021-01-08 | Unknown | Louisiana | 421 | 0 | |
911879 | 911879 | 2021-01-09 | Unknown | Louisiana | 421 | 0 | |
915124 | 915124 | 2021-01-10 | Unknown | Louisiana | 427 | 0 | |
918369 | 918369 | 2021-01-11 | Unknown | Louisiana | 426 | 0 | |
921614 | 921614 | 2021-01-12 | Unknown | Louisiana | 410 | 0 | |
924859 | 924859 | 2021-01-13 | Unknown | Louisiana | 408 | 0 | |
928105 | 928105 | 2021-01-14 | Unknown | Louisiana | 415 | 0 | |
931350 | 931350 | 2021-01-15 | Unknown | Louisiana | 417 | 0 | |
934595 | 934595 | 2021-01-16 | Unknown | Louisiana | 417 | 0 | |
937840 | 937840 | 2021-01-17 | Unknown | Louisiana | 414 | 0 | |
941085 | 941085 | 2021-01-18 | Unknown | Louisiana | 417 | 0 | |
944330 | 944330 | 2021-01-19 | Unknown | Louisiana | 410 | 0 | |
947577 | 947577 | 2021-01-20 | Unknown | Louisiana | 412 | 0 | |
950823 | 950823 | 2021-01-21 | Unknown | Louisiana | 414 | 0 | |
954068 | 954068 | 2021-01-22 | Unknown | Louisiana | 412 | 0 | |
957313 | 957313 | 2021-01-23 | Unknown | Louisiana | 412 | 0 | |
960559 | 960559 | 2021-01-24 | Unknown | Louisiana | 416 | 0 | |
963804 | 963804 | 2021-01-25 | Unknown | Louisiana | 421 | 0 | |
967049 | 967049 | 2021-01-26 | Unknown | Louisiana | 412 | 0 | |
970293 | 970293 | 2021-01-27 | Unknown | Louisiana | 413 | 0 | |
973538 | 973538 | 2021-01-28 | Unknown | Louisiana | 414 | 0 | |
976783 | 976783 | 2021-01-29 | Unknown | Louisiana | 415 | 0 | |
980029 | 980029 | 2021-01-30 | Unknown | Louisiana | 415 | 0 | |
983275 | 983275 | 2021-01-31 | Unknown | Louisiana | 423 | 0 | |
986522 | 986522 | 2021-02-01 | Unknown | Louisiana | 428 | 0 | |
989769 | 989769 | 2021-02-02 | Unknown | Louisiana | 416 | 0 | |
993015 | 993015 | 2021-02-03 | Unknown | Louisiana | 418 | 0 | |
996261 | 996261 | 2021-02-04 | Unknown | Louisiana | 417 | 0 | |
999507 | 999507 | 2021-02-05 | Unknown | Louisiana | 412 | 0 | |
1002753 | 1002753 | 2021-02-06 | Unknown | Louisiana | 412 | 0 | |
1005999 | 1005999 | 2021-02-07 | Unknown | Louisiana | 414 | 0 | |
1009245 | 1009245 | 2021-02-08 | Unknown | Louisiana | 416 | 0 | |
1012491 | 1012491 | 2021-02-09 | Unknown | Louisiana | 418 | 0 |
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);