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-13 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
2009479 2009479 2021-12-13 Acadia Louisiana 22001 10733 251
2009480 2009480 2021-12-13 Allen Louisiana 22003 4822 118
2009481 2009481 2021-12-13 Ascension Louisiana 22005 22244 249
2009482 2009482 2021-12-13 Assumption Louisiana 22007 3711 57
2009483 2009483 2021-12-13 Avoyelles Louisiana 22009 7421 181
2009484 2009484 2021-12-13 Beauregard Louisiana 22011 6197 127
2009485 2009485 2021-12-13 Bienville Louisiana 22013 2534 99
2009486 2009486 2021-12-13 Bossier Louisiana 22015 22314 410
2009487 2009487 2021-12-13 Caddo Louisiana 22017 40441 984
2009488 2009488 2021-12-13 Calcasieu Louisiana 22019 35182 633
2009489 2009489 2021-12-13 Caldwell Louisiana 22021 2325 41
2009490 2009490 2021-12-13 Cameron Louisiana 22023 869 8
2009491 2009491 2021-12-13 Catahoula Louisiana 22025 1821 48
2009492 2009492 2021-12-13 Claiborne Louisiana 22027 2059 66
2009493 2009493 2021-12-13 Concordia Louisiana 22029 3302 80
2009494 2009494 2021-12-13 De Soto Louisiana 22031 4856 113
2009495 2009495 2021-12-13 East Baton Rouge Louisiana 22033 65004 1174
2009496 2009496 2021-12-13 East Carroll Louisiana 22035 1731 32
2009497 2009497 2021-12-13 East Feliciana Louisiana 22037 4558 145
2009498 2009498 2021-12-13 Evangeline Louisiana 22039 5953 143
2009499 2009499 2021-12-13 Franklin Louisiana 22041 4835 141
2009500 2009500 2021-12-13 Grant Louisiana 22043 3927 78
2009501 2009501 2021-12-13 Iberia Louisiana 22045 12711 229
2009502 2009502 2021-12-13 Iberville Louisiana 22047 5917 129
2009503 2009503 2021-12-13 Jackson Louisiana 22049 2827 64
2009504 2009504 2021-12-13 Jefferson Louisiana 22051 70858 1183
2009505 2009505 2021-12-13 Jefferson Davis Louisiana 22053 4831 130
2009506 2009506 2021-12-13 LaSalle Louisiana 22059 2797 46
2009507 2009507 2021-12-13 Lafayette Louisiana 22055 39894 410
2009508 2009508 2021-12-13 Lafourche Louisiana 22057 18312 320
2009509 2009509 2021-12-13 Lincoln Louisiana 22061 7329 118
2009510 2009510 2021-12-13 Livingston Louisiana 22063 24989 385
2009511 2009511 2021-12-13 Madison Louisiana 22065 2293 55
2009512 2009512 2021-12-13 Morehouse Louisiana 22067 4607 117
2009513 2009513 2021-12-13 Natchitoches Louisiana 22069 6788 137
2009514 2009514 2021-12-13 Orleans Louisiana 22071 48056 1006
2009515 2009515 2021-12-13 Ouachita Louisiana 22073 32520 604
2009516 2009516 2021-12-13 Plaquemines Louisiana 22075 4068 40
2009517 2009517 2021-12-13 Pointe Coupee Louisiana 22077 4013 85
2009518 2009518 2021-12-13 Rapides Louisiana 22079 21690 478
2009519 2009519 2021-12-13 Red River Louisiana 22081 1427 49
2009520 2009520 2021-12-13 Richland Louisiana 22083 4430 80
2009521 2009521 2021-12-13 Sabine Louisiana 22085 4585 96
2009522 2009522 2021-12-13 St. Bernard Louisiana 22087 7083 98
2009523 2009523 2021-12-13 St. Charles Louisiana 22089 9084 128
2009524 2009524 2021-12-13 St. Helena Louisiana 22091 1270 19
2009525 2009525 2021-12-13 St. James Louisiana 22093 3559 70
2009526 2009526 2021-12-13 St. John the Baptist Louisiana 22095 6428 173
2009527 2009527 2021-12-13 St. Landry Louisiana 22097 14483 351
2009528 2009528 2021-12-13 St. Martin Louisiana 22099 8581 163
2009529 2009529 2021-12-13 St. Mary Louisiana 22101 8645 228
2009530 2009530 2021-12-13 St. Tammany Louisiana 22103 44687 738
2009531 2009531 2021-12-13 Tangipahoa Louisiana 22105 23170 530
2009532 2009532 2021-12-13 Tensas Louisiana 22107 564 10
2009533 2009533 2021-12-13 Terrebonne Louisiana 22109 19949 360
2009534 2009534 2021-12-13 Union Louisiana 22111 4251 112
2009535 2009535 2021-12-13 Unknown Louisiana   589 0
2009536 2009536 2021-12-13 Vermilion Louisiana 22113 10437 195
2009537 2009537 2021-12-13 Vernon Louisiana 22115 6538 167
2009538 2009538 2021-12-13 Washington Louisiana 22117 8307 221
2009539 2009539 2021-12-13 Webster Louisiana 22119 6862 152
2009540 2009540 2021-12-13 West Baton Rouge Louisiana 22121 4464 79
2009541 2009541 2021-12-13 West Carroll Louisiana 22123 2192 52
2009542 2009542 2021-12-13 West Feliciana Louisiana 22125 1515 41
2009543 2009543 2021-12-13 Winn Louisiana 22127 2667 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);