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-30 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
681428 681428 2020-10-30 Acadia Louisiana 22001 3169 101
681429 681429 2020-10-30 Allen Louisiana 22003 1848 63
681430 681430 2020-10-30 Ascension Louisiana 22005 4212 100
681431 681431 2020-10-30 Assumption Louisiana 22007 802 24
681432 681432 2020-10-30 Avoyelles Louisiana 22009 1757 62
681433 681433 2020-10-30 Beauregard Louisiana 22011 1077 40
681434 681434 2020-10-30 Bienville Louisiana 22013 614 35
681435 681435 2020-10-30 Bossier Louisiana 22015 4339 121
681436 681436 2020-10-30 Caddo Louisiana 22017 10262 396
681437 681437 2020-10-30 Calcasieu Louisiana 22019 8461 230
681438 681438 2020-10-30 Caldwell Louisiana 22021 367 3
681439 681439 2020-10-30 Cameron Louisiana 22023 247 2
681440 681440 2020-10-30 Catahoula Louisiana 22025 465 15
681441 681441 2020-10-30 Claiborne Louisiana 22027 603 26
681442 681442 2020-10-30 Concordia Louisiana 22029 611 16
681443 681443 2020-10-30 De Soto Louisiana 22031 1037 35
681444 681444 2020-10-30 East Baton Rouge Louisiana 22033 16202 459
681445 681445 2020-10-30 East Carroll Louisiana 22035 586 6
681446 681446 2020-10-30 East Feliciana Louisiana 22037 1799 78
681447 681447 2020-10-30 Evangeline Louisiana 22039 1413 40
681448 681448 2020-10-30 Franklin Louisiana 22041 1348 47
681449 681449 2020-10-30 Grant Louisiana 22043 543 30
681450 681450 2020-10-30 Iberia Louisiana 22045 3079 97
681451 681451 2020-10-30 Iberville Louisiana 22047 1487 61
681452 681452 2020-10-30 Jackson Louisiana 22049 869 24
681453 681453 2020-10-30 Jefferson Louisiana 22051 18785 589
681454 681454 2020-10-30 Jefferson Davis Louisiana 22053 1355 44
681455 681455 2020-10-30 LaSalle Louisiana 22059 517 10
681456 681456 2020-10-30 Lafayette Louisiana 22055 9505 140
681457 681457 2020-10-30 Lafourche Louisiana 22057 3907 131
681458 681458 2020-10-30 Lincoln Louisiana 22061 1688 50
681459 681459 2020-10-30 Livingston Louisiana 22063 4232 80
681460 681460 2020-10-30 Madison Louisiana 22065 895 9
681461 681461 2020-10-30 Morehouse Louisiana 22067 896 27
681462 681462 2020-10-30 Natchitoches Louisiana 22069 1503 28
681463 681463 2020-10-30 Orleans Louisiana 22071 13536 595
681464 681464 2020-10-30 Ouachita Louisiana 22073 7082 167
681465 681465 2020-10-30 Plaquemines Louisiana 22075 898 19
681466 681466 2020-10-30 Pointe Coupee Louisiana 22077 1140 42
681467 681467 2020-10-30 Rapides Louisiana 22079 4749 160
681468 681468 2020-10-30 Red River Louisiana 22081 446 24
681469 681469 2020-10-30 Richland Louisiana 22083 901 18
681470 681470 2020-10-30 Sabine Louisiana 22085 1005 15
681471 681471 2020-10-30 St. Bernard Louisiana 22087 1557 32
681472 681472 2020-10-30 St. Charles Louisiana 22089 1964 63
681473 681473 2020-10-30 St. Helena Louisiana 22091 439 4
681474 681474 2020-10-30 St. James Louisiana 22093 846 40
681475 681475 2020-10-30 St. John the Baptist Louisiana 22095 1659 107
681476 681476 2020-10-30 St. Landry Louisiana 22097 3681 135
681477 681477 2020-10-30 St. Martin Louisiana 22099 2237 64
681478 681478 2020-10-30 St. Mary Louisiana 22101 2026 86
681479 681479 2020-10-30 St. Tammany Louisiana 22103 7764 271
681480 681480 2020-10-30 Tangipahoa Louisiana 22105 5047 126
681481 681481 2020-10-30 Tensas Louisiana 22107 187 2
681482 681482 2020-10-30 Terrebonne Louisiana 22109 3880 125
681483 681483 2020-10-30 Union Louisiana 22111 1127 52
681484 681484 2020-10-30 Unknown Louisiana   4700 214
681485 681485 2020-10-30 Vermilion Louisiana 22113 2131 70
681486 681486 2020-10-30 Vernon Louisiana 22115 1128 56
681487 681487 2020-10-30 Washington Louisiana 22117 1753 72
681488 681488 2020-10-30 Webster Louisiana 22119 1490 41
681489 681489 2020-10-30 West Baton Rouge Louisiana 22121 964 42
681490 681490 2020-10-30 West Carroll Louisiana 22123 377 13
681491 681491 2020-10-30 West Feliciana Louisiana 22125 760 25
681492 681492 2020-10-30 Winn Louisiana 22127 695 20

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