ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where county = "Richland", deaths = 57 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1535153 | 1535153 | 2021-07-20 | Richland | Louisiana | 22083 | 2607 | 57 |
1531906 | 1531906 | 2021-07-19 | Richland | Louisiana | 22083 | 2597 | 57 |
1528659 | 1528659 | 2021-07-18 | Richland | Louisiana | 22083 | 2590 | 57 |
1525412 | 1525412 | 2021-07-17 | Richland | Louisiana | 22083 | 2590 | 57 |
1522164 | 1522164 | 2021-07-16 | Richland | Louisiana | 22083 | 2590 | 57 |
1518916 | 1518916 | 2021-07-15 | Richland | Louisiana | 22083 | 2583 | 57 |
1515669 | 1515669 | 2021-07-14 | Richland | Louisiana | 22083 | 2576 | 57 |
1512423 | 1512423 | 2021-07-13 | Richland | Louisiana | 22083 | 2566 | 57 |
1509176 | 1509176 | 2021-07-12 | Richland | Louisiana | 22083 | 2568 | 57 |
1505930 | 1505930 | 2021-07-11 | Richland | Louisiana | 22083 | 2558 | 57 |
1502684 | 1502684 | 2021-07-10 | Richland | Louisiana | 22083 | 2558 | 57 |
1499438 | 1499438 | 2021-07-09 | Richland | Louisiana | 22083 | 2558 | 57 |
1496191 | 1496191 | 2021-07-08 | Richland | Louisiana | 22083 | 2558 | 57 |
1492945 | 1492945 | 2021-07-07 | Richland | Louisiana | 22083 | 2554 | 57 |
1489698 | 1489698 | 2021-07-06 | Richland | Louisiana | 22083 | 2546 | 57 |
1486451 | 1486451 | 2021-07-05 | Richland | Louisiana | 22083 | 2524 | 57 |
1483205 | 1483205 | 2021-07-04 | Richland | Louisiana | 22083 | 2524 | 57 |
1479958 | 1479958 | 2021-07-03 | Richland | Louisiana | 22083 | 2524 | 57 |
1476712 | 1476712 | 2021-07-02 | Richland | Louisiana | 22083 | 2524 | 57 |
1473466 | 1473466 | 2021-07-01 | Richland | Louisiana | 22083 | 2515 | 57 |
1470220 | 1470220 | 2021-06-30 | Richland | Louisiana | 22083 | 2513 | 57 |
1466975 | 1466975 | 2021-06-29 | Richland | Louisiana | 22083 | 2513 | 57 |
1463730 | 1463730 | 2021-06-28 | Richland | Louisiana | 22083 | 2511 | 57 |
1460485 | 1460485 | 2021-06-27 | Richland | Louisiana | 22083 | 2511 | 57 |
1457240 | 1457240 | 2021-06-26 | Richland | Louisiana | 22083 | 2511 | 57 |
1453995 | 1453995 | 2021-06-25 | Richland | Louisiana | 22083 | 2511 | 57 |
1450749 | 1450749 | 2021-06-24 | Richland | Louisiana | 22083 | 2510 | 57 |
1447504 | 1447504 | 2021-06-23 | Richland | Louisiana | 22083 | 2507 | 57 |
1444259 | 1444259 | 2021-06-22 | Richland | Louisiana | 22083 | 2503 | 57 |
1441014 | 1441014 | 2021-06-21 | Richland | Louisiana | 22083 | 2503 | 57 |
1437767 | 1437767 | 2021-06-20 | Richland | Louisiana | 22083 | 2495 | 57 |
1434520 | 1434520 | 2021-06-19 | Richland | Louisiana | 22083 | 2495 | 57 |
1431274 | 1431274 | 2021-06-18 | Richland | Louisiana | 22083 | 2495 | 57 |
1428029 | 1428029 | 2021-06-17 | Richland | Louisiana | 22083 | 2494 | 57 |
1424784 | 1424784 | 2021-06-16 | Richland | Louisiana | 22083 | 2492 | 57 |
1421536 | 1421536 | 2021-06-15 | Richland | Louisiana | 22083 | 2492 | 57 |
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);