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-08-24 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
464401 464401 2020-08-24 Acadia Louisiana 22001 2748 93
464402 464402 2020-08-24 Allen Louisiana 22003 1409 37
464403 464403 2020-08-24 Ascension Louisiana 22005 3226 87
464404 464404 2020-08-24 Assumption Louisiana 22007 631 21
464405 464405 2020-08-24 Avoyelles Louisiana 22009 1218 43
464406 464406 2020-08-24 Beauregard Louisiana 22011 941 29
464407 464407 2020-08-24 Bienville Louisiana 22013 403 30
464408 464408 2020-08-24 Bossier Louisiana 22015 2557 91
464409 464409 2020-08-24 Caddo Louisiana 22017 7180 310
464410 464410 2020-08-24 Calcasieu Louisiana 22019 7284 178
464411 464411 2020-08-24 Caldwell Louisiana 22021 271 3
464412 464412 2020-08-24 Cameron Louisiana 22023 175 1
464413 464413 2020-08-24 Catahoula Louisiana 22025 351 6
464414 464414 2020-08-24 Claiborne Louisiana 22027 331 12
464415 464415 2020-08-24 Concordia Louisiana 22029 411 9
464416 464416 2020-08-24 De Soto Louisiana 22031 803 30
464417 464417 2020-08-24 East Baton Rouge Louisiana 22033 13412 403
464418 464418 2020-08-24 East Carroll Louisiana 22035 529 2
464419 464419 2020-08-24 East Feliciana Louisiana 22037 862 43
464420 464420 2020-08-24 Evangeline Louisiana 22039 1006 23
464421 464421 2020-08-24 Franklin Louisiana 22041 1042 26
464422 464422 2020-08-24 Grant Louisiana 22043 382 25
464423 464423 2020-08-24 Iberia Louisiana 22045 2670 81
464424 464424 2020-08-24 Iberville Louisiana 22047 1330 52
464425 464425 2020-08-24 Jackson Louisiana 22049 421 20
464426 464426 2020-08-24 Jefferson Louisiana 22051 16171 538
464427 464427 2020-08-24 Jefferson Davis Louisiana 22053 1120 34
464428 464428 2020-08-24 LaSalle Louisiana 22059 379 5
464429 464429 2020-08-24 Lafayette Louisiana 22055 8168 106
464430 464430 2020-08-24 Lafourche Louisiana 22057 3111 107
464431 464431 2020-08-24 Lincoln Louisiana 22061 885 39
464432 464432 2020-08-24 Livingston Louisiana 22063 3279 62
464433 464433 2020-08-24 Madison Louisiana 22065 655 6
464434 464434 2020-08-24 Morehouse Louisiana 22067 570 15
464435 464435 2020-08-24 Natchitoches Louisiana 22069 894 22
464436 464436 2020-08-24 Orleans Louisiana 22071 11214 570
464437 464437 2020-08-24 Ouachita Louisiana 22073 5389 124
464438 464438 2020-08-24 Plaquemines Louisiana 22075 489 19
464439 464439 2020-08-24 Pointe Coupee Louisiana 22077 894 36
464440 464440 2020-08-24 Rapides Louisiana 22079 3703 131
464441 464441 2020-08-24 Red River Louisiana 22081 300 19
464442 464442 2020-08-24 Richland Louisiana 22083 667 9
464443 464443 2020-08-24 Sabine Louisiana 22085 712 13
464444 464444 2020-08-24 St. Bernard Louisiana 22087 1196 25
464445 464445 2020-08-24 St. Charles Louisiana 22089 1587 54
464446 464446 2020-08-24 St. Helena Louisiana 22091 307 2
464447 464447 2020-08-24 St. James Louisiana 22093 749 34
464448 464448 2020-08-24 St. John the Baptist Louisiana 22095 1490 94
464449 464449 2020-08-24 St. Landry Louisiana 22097 3001 108
464450 464450 2020-08-24 St. Martin Louisiana 22099 1839 51
464451 464451 2020-08-24 St. Mary Louisiana 22101 1726 65
464452 464452 2020-08-24 St. Tammany Louisiana 22103 5841 226
464453 464453 2020-08-24 Tangipahoa Louisiana 22105 3959 88
464454 464454 2020-08-24 Tensas Louisiana 22107 127 1
464455 464455 2020-08-24 Terrebonne Louisiana 22109 3333 94
464456 464456 2020-08-24 Union Louisiana 22111 788 39
464457 464457 2020-08-24 Unknown Louisiana   388 141
464458 464458 2020-08-24 Vermilion Louisiana 22113 1789 38
464459 464459 2020-08-24 Vernon Louisiana 22115 898 36
464460 464460 2020-08-24 Washington Louisiana 22117 1415 59
464461 464461 2020-08-24 Webster Louisiana 22119 988 19
464462 464462 2020-08-24 West Baton Rouge Louisiana 22121 787 38
464463 464463 2020-08-24 West Carroll Louisiana 22123 321 8
464464 464464 2020-08-24 West Feliciana Louisiana 22125 468 19
464465 464465 2020-08-24 Winn Louisiana 22127 517 15

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