ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where county = "LaSalle" and deaths = 36 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1288431 | 1288431 | 2021-05-05 | LaSalle | Louisiana | 22059 | 1541 | 36 |
1285185 | 1285185 | 2021-05-04 | LaSalle | Louisiana | 22059 | 1532 | 36 |
1281938 | 1281938 | 2021-05-03 | LaSalle | Louisiana | 22059 | 1542 | 36 |
1278691 | 1278691 | 2021-05-02 | LaSalle | Louisiana | 22059 | 1528 | 36 |
1275444 | 1275444 | 2021-05-01 | LaSalle | Louisiana | 22059 | 1528 | 36 |
1272197 | 1272197 | 2021-04-30 | LaSalle | Louisiana | 22059 | 1528 | 36 |
1268950 | 1268950 | 2021-04-29 | LaSalle | Louisiana | 22059 | 1527 | 36 |
1265703 | 1265703 | 2021-04-28 | LaSalle | Louisiana | 22059 | 1530 | 36 |
1262456 | 1262456 | 2021-04-27 | LaSalle | Louisiana | 22059 | 1523 | 36 |
1259209 | 1259209 | 2021-04-26 | LaSalle | Louisiana | 22059 | 1523 | 36 |
1255962 | 1255962 | 2021-04-25 | LaSalle | Louisiana | 22059 | 1522 | 36 |
1252715 | 1252715 | 2021-04-24 | LaSalle | Louisiana | 22059 | 1522 | 36 |
1249468 | 1249468 | 2021-04-23 | LaSalle | Louisiana | 22059 | 1522 | 36 |
1246221 | 1246221 | 2021-04-22 | LaSalle | Louisiana | 22059 | 1521 | 36 |
1242974 | 1242974 | 2021-04-21 | LaSalle | Louisiana | 22059 | 1511 | 36 |
1239727 | 1239727 | 2021-04-20 | LaSalle | Louisiana | 22059 | 1512 | 36 |
1236480 | 1236480 | 2021-04-19 | LaSalle | Louisiana | 22059 | 1512 | 36 |
1233233 | 1233233 | 2021-04-18 | LaSalle | Louisiana | 22059 | 1496 | 36 |
1229985 | 1229985 | 2021-04-17 | LaSalle | Louisiana | 22059 | 1496 | 36 |
1226737 | 1226737 | 2021-04-16 | LaSalle | Louisiana | 22059 | 1496 | 36 |
1223490 | 1223490 | 2021-04-15 | LaSalle | Louisiana | 22059 | 1483 | 36 |
1220242 | 1220242 | 2021-04-14 | LaSalle | Louisiana | 22059 | 1478 | 36 |
1216994 | 1216994 | 2021-04-13 | LaSalle | Louisiana | 22059 | 1473 | 36 |
1213747 | 1213747 | 2021-04-12 | LaSalle | Louisiana | 22059 | 1472 | 36 |
1210499 | 1210499 | 2021-04-11 | LaSalle | Louisiana | 22059 | 1464 | 36 |
1207250 | 1207250 | 2021-04-10 | LaSalle | Louisiana | 22059 | 1464 | 36 |
1204002 | 1204002 | 2021-04-09 | LaSalle | Louisiana | 22059 | 1464 | 36 |
1200754 | 1200754 | 2021-04-08 | LaSalle | Louisiana | 22059 | 1467 | 36 |
1197505 | 1197505 | 2021-04-07 | LaSalle | Louisiana | 22059 | 1461 | 36 |
1194257 | 1194257 | 2021-04-06 | LaSalle | Louisiana | 22059 | 1459 | 36 |
1191007 | 1191007 | 2021-04-05 | LaSalle | Louisiana | 22059 | 1466 | 36 |
1187760 | 1187760 | 2021-04-04 | LaSalle | Louisiana | 22059 | 1457 | 36 |
1184513 | 1184513 | 2021-04-03 | LaSalle | Louisiana | 22059 | 1457 | 36 |
1181266 | 1181266 | 2021-04-02 | LaSalle | Louisiana | 22059 | 1457 | 36 |
1178019 | 1178019 | 2021-04-01 | LaSalle | Louisiana | 22059 | 1457 | 36 |
1174772 | 1174772 | 2021-03-31 | LaSalle | Louisiana | 22059 | 1455 | 36 |
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);