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-12-05 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
1983474 1983474 2021-12-05 Acadia Louisiana 22001 10690 251
1983475 1983475 2021-12-05 Allen Louisiana 22003 4791 117
1983476 1983476 2021-12-05 Ascension Louisiana 22005 22112 247
1983477 1983477 2021-12-05 Assumption Louisiana 22007 3702 57
1983478 1983478 2021-12-05 Avoyelles Louisiana 22009 7396 182
1983479 1983479 2021-12-05 Beauregard Louisiana 22011 6179 125
1983480 1983480 2021-12-05 Bienville Louisiana 22013 2519 99
1983481 1983481 2021-12-05 Bossier Louisiana 22015 22183 409
1983482 1983482 2021-12-05 Caddo Louisiana 22017 40205 981
1983483 1983483 2021-12-05 Calcasieu Louisiana 22019 35010 627
1983484 1983484 2021-12-05 Caldwell Louisiana 22021 2314 39
1983485 1983485 2021-12-05 Cameron Louisiana 22023 865 9
1983486 1983486 2021-12-05 Catahoula Louisiana 22025 1813 48
1983487 1983487 2021-12-05 Claiborne Louisiana 22027 2035 66
1983488 1983488 2021-12-05 Concordia Louisiana 22029 3277 80
1983489 1983489 2021-12-05 De Soto Louisiana 22031 4833 113
1983490 1983490 2021-12-05 East Baton Rouge Louisiana 22033 64746 1172
1983491 1983491 2021-12-05 East Carroll Louisiana 22035 1667 32
1983492 1983492 2021-12-05 East Feliciana Louisiana 22037 4537 145
1983493 1983493 2021-12-05 Evangeline Louisiana 22039 5925 142
1983494 1983494 2021-12-05 Franklin Louisiana 22041 4799 140
1983495 1983495 2021-12-05 Grant Louisiana 22043 3910 79
1983496 1983496 2021-12-05 Iberia Louisiana 22045 12643 228
1983497 1983497 2021-12-05 Iberville Louisiana 22047 5893 128
1983498 1983498 2021-12-05 Jackson Louisiana 22049 2822 64
1983499 1983499 2021-12-05 Jefferson Louisiana 22051 70500 1177
1983500 1983500 2021-12-05 Jefferson Davis Louisiana 22053 4811 130
1983501 1983501 2021-12-05 LaSalle Louisiana 22059 2787 46
1983502 1983502 2021-12-05 Lafayette Louisiana 22055 39680 408
1983503 1983503 2021-12-05 Lafourche Louisiana 22057 18241 321
1983504 1983504 2021-12-05 Lincoln Louisiana 22061 7289 117
1983505 1983505 2021-12-05 Livingston Louisiana 22063 24845 384
1983506 1983506 2021-12-05 Madison Louisiana 22065 2283 53
1983507 1983507 2021-12-05 Morehouse Louisiana 22067 4563 116
1983508 1983508 2021-12-05 Natchitoches Louisiana 22069 6742 137
1983509 1983509 2021-12-05 Orleans Louisiana 22071 47643 1007
1983510 1983510 2021-12-05 Ouachita Louisiana 22073 32291 602
1983511 1983511 2021-12-05 Plaquemines Louisiana 22075 4049 40
1983512 1983512 2021-12-05 Pointe Coupee Louisiana 22077 3994 85
1983513 1983513 2021-12-05 Rapides Louisiana 22079 21595 478
1983514 1983514 2021-12-05 Red River Louisiana 22081 1418 49
1983515 1983515 2021-12-05 Richland Louisiana 22083 4406 80
1983516 1983516 2021-12-05 Sabine Louisiana 22085 4568 96
1983517 1983517 2021-12-05 St. Bernard Louisiana 22087 7047 99
1983518 1983518 2021-12-05 St. Charles Louisiana 22089 8998 128
1983519 1983519 2021-12-05 St. Helena Louisiana 22091 1268 19
1983520 1983520 2021-12-05 St. James Louisiana 22093 3552 70
1983521 1983521 2021-12-05 St. John the Baptist Louisiana 22095 6408 173
1983522 1983522 2021-12-05 St. Landry Louisiana 22097 14417 350
1983523 1983523 2021-12-05 St. Martin Louisiana 22099 8511 162
1983524 1983524 2021-12-05 St. Mary Louisiana 22101 8615 227
1983525 1983525 2021-12-05 St. Tammany Louisiana 22103 44437 736
1983526 1983526 2021-12-05 Tangipahoa Louisiana 22105 23085 526
1983527 1983527 2021-12-05 Tensas Louisiana 22107 564 10
1983528 1983528 2021-12-05 Terrebonne Louisiana 22109 19817 355
1983529 1983529 2021-12-05 Union Louisiana 22111 4203 109
1983530 1983530 2021-12-05 Unknown Louisiana   588 0
1983531 1983531 2021-12-05 Vermilion Louisiana 22113 10398 193
1983532 1983532 2021-12-05 Vernon Louisiana 22115 6505 165
1983533 1983533 2021-12-05 Washington Louisiana 22117 8252 219
1983534 1983534 2021-12-05 Webster Louisiana 22119 6788 150
1983535 1983535 2021-12-05 West Baton Rouge Louisiana 22121 4453 78
1983536 1983536 2021-12-05 West Carroll Louisiana 22123 2142 52
1983537 1983537 2021-12-05 West Feliciana Louisiana 22125 1513 41
1983538 1983538 2021-12-05 Winn Louisiana 22127 2657 58

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