ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where date = "2021-01-24" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
960503 | 960503 | 2021-01-24 | Acadia | Louisiana | 22001 | 5685 | 175 |
960504 | 960504 | 2021-01-24 | Allen | Louisiana | 22003 | 2728 | 77 |
960505 | 960505 | 2021-01-24 | Ascension | Louisiana | 22005 | 9829 | 136 |
960506 | 960506 | 2021-01-24 | Assumption | Louisiana | 22007 | 1785 | 31 |
960507 | 960507 | 2021-01-24 | Avoyelles | Louisiana | 22009 | 3355 | 103 |
960508 | 960508 | 2021-01-24 | Beauregard | Louisiana | 22011 | 2496 | 60 |
960509 | 960509 | 2021-01-24 | Bienville | Louisiana | 22013 | 1476 | 64 |
960510 | 960510 | 2021-01-24 | Bossier | Louisiana | 22015 | 11230 | 232 |
960511 | 960511 | 2021-01-24 | Caddo | Louisiana | 22017 | 21916 | 591 |
960512 | 960512 | 2021-01-24 | Calcasieu | Louisiana | 22019 | 16928 | 312 |
960513 | 960513 | 2021-01-24 | Caldwell | Louisiana | 22021 | 1036 | 23 |
960514 | 960514 | 2021-01-24 | Cameron | Louisiana | 22023 | 466 | 4 |
960515 | 960515 | 2021-01-24 | Catahoula | Louisiana | 22025 | 1003 | 30 |
960516 | 960516 | 2021-01-24 | Claiborne | Louisiana | 22027 | 1313 | 47 |
960517 | 960517 | 2021-01-24 | Concordia | Louisiana | 22029 | 1670 | 50 |
960518 | 960518 | 2021-01-24 | De Soto | Louisiana | 22031 | 2231 | 59 |
960519 | 960519 | 2021-01-24 | East Baton Rouge | Louisiana | 22033 | 31179 | 659 |
960520 | 960520 | 2021-01-24 | East Carroll | Louisiana | 22035 | 1064 | 20 |
960521 | 960521 | 2021-01-24 | East Feliciana | Louisiana | 22037 | 2723 | 98 |
960522 | 960522 | 2021-01-24 | Evangeline | Louisiana | 22039 | 3023 | 68 |
960523 | 960523 | 2021-01-24 | Franklin | Louisiana | 22041 | 2307 | 93 |
960524 | 960524 | 2021-01-24 | Grant | Louisiana | 22043 | 1790 | 43 |
960525 | 960525 | 2021-01-24 | Iberia | Louisiana | 22045 | 5816 | 132 |
960526 | 960526 | 2021-01-24 | Iberville | Louisiana | 22047 | 3128 | 82 |
960527 | 960527 | 2021-01-24 | Jackson | Louisiana | 22049 | 1582 | 43 |
960528 | 960528 | 2021-01-24 | Jefferson | Louisiana | 22051 | 39268 | 766 |
960529 | 960529 | 2021-01-24 | Jefferson Davis | Louisiana | 22053 | 2656 | 76 |
960530 | 960530 | 2021-01-24 | LaSalle | Louisiana | 22059 | 1303 | 33 |
960531 | 960531 | 2021-01-24 | Lafayette | Louisiana | 22055 | 19943 | 227 |
960532 | 960532 | 2021-01-24 | Lafourche | Louisiana | 22057 | 7794 | 172 |
960533 | 960533 | 2021-01-24 | Lincoln | Louisiana | 22061 | 3924 | 83 |
960534 | 960534 | 2021-01-24 | Livingston | Louisiana | 22063 | 10701 | 149 |
960535 | 960535 | 2021-01-24 | Madison | Louisiana | 22065 | 1494 | 28 |
960536 | 960536 | 2021-01-24 | Morehouse | Louisiana | 22067 | 2531 | 60 |
960537 | 960537 | 2021-01-24 | Natchitoches | Louisiana | 22069 | 3549 | 74 |
960538 | 960538 | 2021-01-24 | Orleans | Louisiana | 22071 | 25358 | 717 |
960539 | 960539 | 2021-01-24 | Ouachita | Louisiana | 22073 | 16563 | 366 |
960540 | 960540 | 2021-01-24 | Plaquemines | Louisiana | 22075 | 2037 | 22 |
960541 | 960541 | 2021-01-24 | Pointe Coupee | Louisiana | 22077 | 2210 | 63 |
960542 | 960542 | 2021-01-24 | Rapides | Louisiana | 22079 | 10280 | 243 |
960543 | 960543 | 2021-01-24 | Red River | Louisiana | 22081 | 771 | 30 |
960544 | 960544 | 2021-01-24 | Richland | Louisiana | 22083 | 2105 | 43 |
960545 | 960545 | 2021-01-24 | Sabine | Louisiana | 22085 | 2483 | 48 |
960546 | 960546 | 2021-01-24 | St. Bernard | Louisiana | 22087 | 3092 | 44 |
960547 | 960547 | 2021-01-24 | St. Charles | Louisiana | 22089 | 4608 | 81 |
960548 | 960548 | 2021-01-24 | St. Helena | Louisiana | 22091 | 816 | 7 |
960549 | 960549 | 2021-01-24 | St. James | Louisiana | 22093 | 1666 | 46 |
960550 | 960550 | 2021-01-24 | St. John the Baptist | Louisiana | 22095 | 3153 | 125 |
960551 | 960551 | 2021-01-24 | St. Landry | Louisiana | 22097 | 7663 | 222 |
960552 | 960552 | 2021-01-24 | St. Martin | Louisiana | 22099 | 4468 | 99 |
960553 | 960553 | 2021-01-24 | St. Mary | Louisiana | 22101 | 3700 | 109 |
960554 | 960554 | 2021-01-24 | St. Tammany | Louisiana | 22103 | 20264 | 415 |
960555 | 960555 | 2021-01-24 | Tangipahoa | Louisiana | 22105 | 10665 | 225 |
960556 | 960556 | 2021-01-24 | Tensas | Louisiana | 22107 | 337 | 5 |
960557 | 960557 | 2021-01-24 | Terrebonne | Louisiana | 22109 | 8112 | 167 |
960558 | 960558 | 2021-01-24 | Union | Louisiana | 22111 | 2168 | 71 |
960559 | 960559 | 2021-01-24 | Unknown | Louisiana | 416 | 0 | |
960560 | 960560 | 2021-01-24 | Vermilion | Louisiana | 22113 | 4404 | 97 |
960561 | 960561 | 2021-01-24 | Vernon | Louisiana | 22115 | 2618 | 82 |
960562 | 960562 | 2021-01-24 | Washington | Louisiana | 22117 | 3703 | 109 |
960563 | 960563 | 2021-01-24 | Webster | Louisiana | 22119 | 3553 | 80 |
960564 | 960564 | 2021-01-24 | West Baton Rouge | Louisiana | 22121 | 2221 | 50 |
960565 | 960565 | 2021-01-24 | West Carroll | Louisiana | 22123 | 1104 | 36 |
960566 | 960566 | 2021-01-24 | West Feliciana | Louisiana | 22125 | 1042 | 28 |
960567 | 960567 | 2021-01-24 | Winn | Louisiana | 22127 | 1360 | 35 |
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);