ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

65 rows where "date" is on date 2021-01-20 and state = "Louisiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Louisiana · 65 ✖
Link rowid date ▲ county state fips cases deaths
947521 947521 2021-01-20 Acadia Louisiana 22001 5627 174
947522 947522 2021-01-20 Allen Louisiana 22003 2697 76
947523 947523 2021-01-20 Ascension Louisiana 22005 9607 134
947524 947524 2021-01-20 Assumption Louisiana 22007 1682 29
947525 947525 2021-01-20 Avoyelles Louisiana 22009 3262 100
947526 947526 2021-01-20 Beauregard Louisiana 22011 2433 60
947527 947527 2021-01-20 Bienville Louisiana 22013 1403 63
947528 947528 2021-01-20 Bossier Louisiana 22015 10826 224
947529 947529 2021-01-20 Caddo Louisiana 22017 21265 586
947530 947530 2021-01-20 Calcasieu Louisiana 22019 16456 310
947531 947531 2021-01-20 Caldwell Louisiana 22021 1018 23
947532 947532 2021-01-20 Cameron Louisiana 22023 458 4
947533 947533 2021-01-20 Catahoula Louisiana 22025 980 29
947534 947534 2021-01-20 Claiborne Louisiana 22027 1276 47
947535 947535 2021-01-20 Concordia Louisiana 22029 1642 49
947536 947536 2021-01-20 De Soto Louisiana 22031 2108 56
947537 947537 2021-01-20 East Baton Rouge Louisiana 22033 30494 648
947538 947538 2021-01-20 East Carroll Louisiana 22035 1048 19
947539 947539 2021-01-20 East Feliciana Louisiana 22037 2713 98
947540 947540 2021-01-20 Evangeline Louisiana 22039 2973 68
947541 947541 2021-01-20 Franklin Louisiana 22041 2276 93
947542 947542 2021-01-20 Grant Louisiana 22043 1759 42
947543 947543 2021-01-20 Iberia Louisiana 22045 5691 132
947544 947544 2021-01-20 Iberville Louisiana 22047 3091 78
947545 947545 2021-01-20 Jackson Louisiana 22049 1540 41
947546 947546 2021-01-20 Jefferson Louisiana 22051 38283 738
947547 947547 2021-01-20 Jefferson Davis Louisiana 22053 2595 74
947548 947548 2021-01-20 LaSalle Louisiana 22059 1279 31
947549 947549 2021-01-20 Lafayette Louisiana 22055 19507 223
947550 947550 2021-01-20 Lafourche Louisiana 22057 7570 172
947551 947551 2021-01-20 Lincoln Louisiana 22061 3788 81
947552 947552 2021-01-20 Livingston Louisiana 22063 10521 147
947553 947553 2021-01-20 Madison Louisiana 22065 1480 27
947554 947554 2021-01-20 Morehouse Louisiana 22067 2471 58
947555 947555 2021-01-20 Natchitoches Louisiana 22069 3457 71
947556 947556 2021-01-20 Orleans Louisiana 22071 24844 702
947557 947557 2021-01-20 Ouachita Louisiana 22073 16252 350
947558 947558 2021-01-20 Plaquemines Louisiana 22075 2004 22
947559 947559 2021-01-20 Pointe Coupee Louisiana 22077 2172 63
947560 947560 2021-01-20 Rapides Louisiana 22079 10022 237
947561 947561 2021-01-20 Red River Louisiana 22081 754 30
947562 947562 2021-01-20 Richland Louisiana 22083 2039 42
947563 947563 2021-01-20 Sabine Louisiana 22085 2418 48
947564 947564 2021-01-20 St. Bernard Louisiana 22087 2993 42
947565 947565 2021-01-20 St. Charles Louisiana 22089 4492 80
947566 947566 2021-01-20 St. Helena Louisiana 22091 813 7
947567 947567 2021-01-20 St. James Louisiana 22093 1636 45
947568 947568 2021-01-20 St. John the Baptist Louisiana 22095 3090 124
947569 947569 2021-01-20 St. Landry Louisiana 22097 7518 218
947570 947570 2021-01-20 St. Martin Louisiana 22099 4409 99
947571 947571 2021-01-20 St. Mary Louisiana 22101 3586 107
947572 947572 2021-01-20 St. Tammany Louisiana 22103 19676 407
947573 947573 2021-01-20 Tangipahoa Louisiana 22105 10392 211
947574 947574 2021-01-20 Tensas Louisiana 22107 333 5
947575 947575 2021-01-20 Terrebonne Louisiana 22109 7755 163
947576 947576 2021-01-20 Union Louisiana 22111 2139 71
947577 947577 2021-01-20 Unknown Louisiana   412 0
947578 947578 2021-01-20 Vermilion Louisiana 22113 4284 95
947579 947579 2021-01-20 Vernon Louisiana 22115 2558 82
947580 947580 2021-01-20 Washington Louisiana 22117 3633 102
947581 947581 2021-01-20 Webster Louisiana 22119 3449 78
947582 947582 2021-01-20 West Baton Rouge Louisiana 22121 2182 50
947583 947583 2021-01-20 West Carroll Louisiana 22123 1084 36
947584 947584 2021-01-20 West Feliciana Louisiana 22125 1038 28
947585 947585 2021-01-20 Winn Louisiana 22127 1329 34

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);