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 2020-10-26 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
668457 668457 2020-10-26 Acadia Louisiana 22001 3119 100
668458 668458 2020-10-26 Allen Louisiana 22003 1851 59
668459 668459 2020-10-26 Ascension Louisiana 22005 4075 99
668460 668460 2020-10-26 Assumption Louisiana 22007 796 24
668461 668461 2020-10-26 Avoyelles Louisiana 22009 1708 62
668462 668462 2020-10-26 Beauregard Louisiana 22011 1068 40
668463 668463 2020-10-26 Bienville Louisiana 22013 595 33
668464 668464 2020-10-26 Bossier Louisiana 22015 4212 120
668465 668465 2020-10-26 Caddo Louisiana 22017 10046 394
668466 668466 2020-10-26 Calcasieu Louisiana 22019 8366 230
668467 668467 2020-10-26 Caldwell Louisiana 22021 355 3
668468 668468 2020-10-26 Cameron Louisiana 22023 240 2
668469 668469 2020-10-26 Catahoula Louisiana 22025 464 14
668470 668470 2020-10-26 Claiborne Louisiana 22027 604 25
668471 668471 2020-10-26 Concordia Louisiana 22029 600 16
668472 668472 2020-10-26 De Soto Louisiana 22031 1015 35
668473 668473 2020-10-26 East Baton Rouge Louisiana 22033 16039 458
668474 668474 2020-10-26 East Carroll Louisiana 22035 582 6
668475 668475 2020-10-26 East Feliciana Louisiana 22037 1801 78
668476 668476 2020-10-26 Evangeline Louisiana 22039 1414 39
668477 668477 2020-10-26 Franklin Louisiana 22041 1312 47
668478 668478 2020-10-26 Grant Louisiana 22043 541 30
668479 668479 2020-10-26 Iberia Louisiana 22045 3068 95
668480 668480 2020-10-26 Iberville Louisiana 22047 1472 61
668481 668481 2020-10-26 Jackson Louisiana 22049 856 23
668482 668482 2020-10-26 Jefferson Louisiana 22051 18645 584
668483 668483 2020-10-26 Jefferson Davis Louisiana 22053 1339 43
668484 668484 2020-10-26 LaSalle Louisiana 22059 496 10
668485 668485 2020-10-26 Lafayette Louisiana 22055 9433 139
668486 668486 2020-10-26 Lafourche Louisiana 22057 3886 128
668487 668487 2020-10-26 Lincoln Louisiana 22061 1658 48
668488 668488 2020-10-26 Livingston Louisiana 22063 4188 79
668489 668489 2020-10-26 Madison Louisiana 22065 893 9
668490 668490 2020-10-26 Morehouse Louisiana 22067 890 26
668491 668491 2020-10-26 Natchitoches Louisiana 22069 1470 28
668492 668492 2020-10-26 Orleans Louisiana 22071 13434 592
668493 668493 2020-10-26 Ouachita Louisiana 22073 6983 163
668494 668494 2020-10-26 Plaquemines Louisiana 22075 892 19
668495 668495 2020-10-26 Pointe Coupee Louisiana 22077 1136 41
668496 668496 2020-10-26 Rapides Louisiana 22079 4680 156
668497 668497 2020-10-26 Red River Louisiana 22081 430 24
668498 668498 2020-10-26 Richland Louisiana 22083 886 16
668499 668499 2020-10-26 Sabine Louisiana 22085 984 15
668500 668500 2020-10-26 St. Bernard Louisiana 22087 1542 32
668501 668501 2020-10-26 St. Charles Louisiana 22089 1945 63
668502 668502 2020-10-26 St. Helena Louisiana 22091 434 4
668503 668503 2020-10-26 St. James Louisiana 22093 839 40
668504 668504 2020-10-26 St. John the Baptist Louisiana 22095 1643 107
668505 668505 2020-10-26 St. Landry Louisiana 22097 3625 135
668506 668506 2020-10-26 St. Martin Louisiana 22099 2215 63
668507 668507 2020-10-26 St. Mary Louisiana 22101 2018 85
668508 668508 2020-10-26 St. Tammany Louisiana 22103 7689 270
668509 668509 2020-10-26 Tangipahoa Louisiana 22105 4983 126
668510 668510 2020-10-26 Tensas Louisiana 22107 186 2
668511 668511 2020-10-26 Terrebonne Louisiana 22109 3865 123
668512 668512 2020-10-26 Union Louisiana 22111 1105 51
668513 668513 2020-10-26 Unknown Louisiana   3986 206
668514 668514 2020-10-26 Vermilion Louisiana 22113 2117 70
668515 668515 2020-10-26 Vernon Louisiana 22115 1116 55
668516 668516 2020-10-26 Washington Louisiana 22117 1748 71
668517 668517 2020-10-26 Webster Louisiana 22119 1466 40
668518 668518 2020-10-26 West Baton Rouge Louisiana 22121 964 42
668519 668519 2020-10-26 West Carroll Louisiana 22123 373 12
668520 668520 2020-10-26 West Feliciana Louisiana 22125 740 25
668521 668521 2020-10-26 Winn Louisiana 22127 681 19

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