ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where "date" is on date 2020-11-24 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Acadia 1
- Allen 1
- Ascension 1
- Assumption 1
- Avoyelles 1
- Beauregard 1
- Bienville 1
- Bossier 1
- Caddo 1
- Calcasieu 1
- Caldwell 1
- Cameron 1
- Catahoula 1
- Claiborne 1
- Concordia 1
- De Soto 1
- East Baton Rouge 1
- East Carroll 1
- East Feliciana 1
- Evangeline 1
- Franklin 1
- Grant 1
- Iberia 1
- Iberville 1
- Jackson 1
- Jefferson 1
- Jefferson Davis 1
- LaSalle 1
- Lafayette 1
- Lafourche 1
- …
state 1
- Louisiana · 65 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
762537 | 762537 | 2020-11-24 | Acadia | Louisiana | 22001 | 3869 | 115 |
762538 | 762538 | 2020-11-24 | Allen | Louisiana | 22003 | 2072 | 67 |
762539 | 762539 | 2020-11-24 | Ascension | Louisiana | 22005 | 5518 | 107 |
762540 | 762540 | 2020-11-24 | Assumption | Louisiana | 22007 | 1002 | 25 |
762541 | 762541 | 2020-11-24 | Avoyelles | Louisiana | 22009 | 2044 | 67 |
762542 | 762542 | 2020-11-24 | Beauregard | Louisiana | 22011 | 1325 | 49 |
762543 | 762543 | 2020-11-24 | Bienville | Louisiana | 22013 | 744 | 37 |
762544 | 762544 | 2020-11-24 | Bossier | Louisiana | 22015 | 6034 | 147 |
762545 | 762545 | 2020-11-24 | Caddo | Louisiana | 22017 | 12765 | 441 |
762546 | 762546 | 2020-11-24 | Calcasieu | Louisiana | 22019 | 10200 | 242 |
762547 | 762547 | 2020-11-24 | Caldwell | Louisiana | 22021 | 607 | 8 |
762548 | 762548 | 2020-11-24 | Cameron | Louisiana | 22023 | 286 | 3 |
762549 | 762549 | 2020-11-24 | Catahoula | Louisiana | 22025 | 604 | 18 |
762550 | 762550 | 2020-11-24 | Claiborne | Louisiana | 22027 | 729 | 29 |
762551 | 762551 | 2020-11-24 | Concordia | Louisiana | 22029 | 958 | 25 |
762552 | 762552 | 2020-11-24 | De Soto | Louisiana | 22031 | 1216 | 38 |
762553 | 762553 | 2020-11-24 | East Baton Rouge | Louisiana | 22033 | 19331 | 500 |
762554 | 762554 | 2020-11-24 | East Carroll | Louisiana | 22035 | 726 | 9 |
762555 | 762555 | 2020-11-24 | East Feliciana | Louisiana | 22037 | 2089 | 84 |
762556 | 762556 | 2020-11-24 | Evangeline | Louisiana | 22039 | 1852 | 44 |
762557 | 762557 | 2020-11-24 | Franklin | Louisiana | 22041 | 1693 | 61 |
762558 | 762558 | 2020-11-24 | Grant | Louisiana | 22043 | 751 | 32 |
762559 | 762559 | 2020-11-24 | Iberia | Louisiana | 22045 | 3592 | 104 |
762560 | 762560 | 2020-11-24 | Iberville | Louisiana | 22047 | 1869 | 65 |
762561 | 762561 | 2020-11-24 | Jackson | Louisiana | 22049 | 1120 | 31 |
762562 | 762562 | 2020-11-24 | Jefferson | Louisiana | 22051 | 21553 | 628 |
762563 | 762563 | 2020-11-24 | Jefferson Davis | Louisiana | 22053 | 1679 | 50 |
762564 | 762564 | 2020-11-24 | LaSalle | Louisiana | 22059 | 852 | 20 |
762565 | 762565 | 2020-11-24 | Lafayette | Louisiana | 22055 | 11695 | 146 |
762566 | 762566 | 2020-11-24 | Lafourche | Louisiana | 22057 | 4573 | 136 |
762567 | 762567 | 2020-11-24 | Lincoln | Louisiana | 22061 | 2443 | 58 |
762568 | 762568 | 2020-11-24 | Livingston | Louisiana | 22063 | 5748 | 89 |
762569 | 762569 | 2020-11-24 | Madison | Louisiana | 22065 | 1034 | 13 |
762570 | 762570 | 2020-11-24 | Morehouse | Louisiana | 22067 | 1322 | 30 |
762571 | 762571 | 2020-11-24 | Natchitoches | Louisiana | 22069 | 1990 | 44 |
762572 | 762572 | 2020-11-24 | Orleans | Louisiana | 22071 | 15323 | 646 |
762573 | 762573 | 2020-11-24 | Ouachita | Louisiana | 22073 | 9628 | 206 |
762574 | 762574 | 2020-11-24 | Plaquemines | Louisiana | 22075 | 1084 | 19 |
762575 | 762575 | 2020-11-24 | Pointe Coupee | Louisiana | 22077 | 1343 | 49 |
762576 | 762576 | 2020-11-24 | Rapides | Louisiana | 22079 | 6140 | 188 |
762577 | 762577 | 2020-11-24 | Red River | Louisiana | 22081 | 562 | 26 |
762578 | 762578 | 2020-11-24 | Richland | Louisiana | 22083 | 1359 | 26 |
762579 | 762579 | 2020-11-24 | Sabine | Louisiana | 22085 | 1378 | 19 |
762580 | 762580 | 2020-11-24 | St. Bernard | Louisiana | 22087 | 1766 | 34 |
762581 | 762581 | 2020-11-24 | St. Charles | Louisiana | 22089 | 2476 | 70 |
762582 | 762582 | 2020-11-24 | St. Helena | Louisiana | 22091 | 506 | 4 |
762583 | 762583 | 2020-11-24 | St. James | Louisiana | 22093 | 963 | 40 |
762584 | 762584 | 2020-11-24 | St. John the Baptist | Louisiana | 22095 | 1915 | 114 |
762585 | 762585 | 2020-11-24 | St. Landry | Louisiana | 22097 | 4799 | 153 |
762586 | 762586 | 2020-11-24 | St. Martin | Louisiana | 22099 | 2653 | 71 |
762587 | 762587 | 2020-11-24 | St. Mary | Louisiana | 22101 | 2322 | 95 |
762588 | 762588 | 2020-11-24 | St. Tammany | Louisiana | 22103 | 9896 | 289 |
762589 | 762589 | 2020-11-24 | Tangipahoa | Louisiana | 22105 | 6413 | 141 |
762590 | 762590 | 2020-11-24 | Tensas | Louisiana | 22107 | 212 | 3 |
762591 | 762591 | 2020-11-24 | Terrebonne | Louisiana | 22109 | 4394 | 135 |
762592 | 762592 | 2020-11-24 | Union | Louisiana | 22111 | 1385 | 56 |
762593 | 762593 | 2020-11-24 | Unknown | Louisiana | 354 | 0 | |
762594 | 762594 | 2020-11-24 | Vermilion | Louisiana | 22113 | 2505 | 74 |
762595 | 762595 | 2020-11-24 | Vernon | Louisiana | 22115 | 1384 | 61 |
762596 | 762596 | 2020-11-24 | Washington | Louisiana | 22117 | 2200 | 76 |
762597 | 762597 | 2020-11-24 | Webster | Louisiana | 22119 | 1922 | 52 |
762598 | 762598 | 2020-11-24 | West Baton Rouge | Louisiana | 22121 | 1289 | 43 |
762599 | 762599 | 2020-11-24 | West Carroll | Louisiana | 22123 | 617 | 20 |
762600 | 762600 | 2020-11-24 | West Feliciana | Louisiana | 22125 | 790 | 25 |
762601 | 762601 | 2020-11-24 | Winn | Louisiana | 22127 | 940 | 26 |
Advanced export
JSON shape: default, array, newline-delimited
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);