ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where county = "Saline" and deaths = 40 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1646021 | 1646021 | 2021-08-23 | Saline | Missouri | 29195 | 3396 | 40 |
1642772 | 1642772 | 2021-08-22 | Saline | Missouri | 29195 | 3387 | 40 |
1639522 | 1639522 | 2021-08-21 | Saline | Missouri | 29195 | 3380 | 40 |
1636272 | 1636272 | 2021-08-20 | Saline | Missouri | 29195 | 3368 | 40 |
1633022 | 1633022 | 2021-08-19 | Saline | Missouri | 29195 | 3347 | 40 |
1629775 | 1629775 | 2021-08-18 | Saline | Missouri | 29195 | 3328 | 40 |
1626528 | 1626528 | 2021-08-17 | Saline | Missouri | 29195 | 3310 | 40 |
1623281 | 1623281 | 2021-08-16 | Saline | Missouri | 29195 | 3301 | 40 |
1620034 | 1620034 | 2021-08-15 | Saline | Missouri | 29195 | 3295 | 40 |
1616786 | 1616786 | 2021-08-14 | Saline | Missouri | 29195 | 3285 | 40 |
1613538 | 1613538 | 2021-08-13 | Saline | Missouri | 29195 | 3270 | 40 |
1610289 | 1610289 | 2021-08-12 | Saline | Missouri | 29195 | 3259 | 40 |
1607041 | 1607041 | 2021-08-11 | Saline | Missouri | 29195 | 3231 | 40 |
1603792 | 1603792 | 2021-08-10 | Saline | Missouri | 29195 | 3213 | 40 |
1600543 | 1600543 | 2021-08-09 | Saline | Missouri | 29195 | 3198 | 40 |
1597295 | 1597295 | 2021-08-08 | Saline | Missouri | 29195 | 3188 | 40 |
1594046 | 1594046 | 2021-08-07 | Saline | Missouri | 29195 | 3170 | 40 |
1590797 | 1590797 | 2021-08-06 | Saline | Missouri | 29195 | 3160 | 40 |
1587548 | 1587548 | 2021-08-05 | Saline | Missouri | 29195 | 3147 | 40 |
1584297 | 1584297 | 2021-08-04 | Saline | Missouri | 29195 | 3137 | 40 |
1581048 | 1581048 | 2021-08-03 | Saline | Missouri | 29195 | 3113 | 40 |
1577799 | 1577799 | 2021-08-02 | Saline | Missouri | 29195 | 3105 | 40 |
1574551 | 1574551 | 2021-08-01 | Saline | Missouri | 29195 | 3101 | 40 |
1571303 | 1571303 | 2021-07-31 | Saline | Missouri | 29195 | 3089 | 40 |
1568055 | 1568055 | 2021-07-30 | Saline | Missouri | 29195 | 3072 | 40 |
1564807 | 1564807 | 2021-07-29 | Saline | Missouri | 29195 | 3054 | 40 |
1561559 | 1561559 | 2021-07-28 | Saline | Missouri | 29195 | 3045 | 40 |
1558311 | 1558311 | 2021-07-27 | Saline | Missouri | 29195 | 3036 | 40 |
885419 | 885419 | 2021-01-01 | Saline | Illinois | 17165 | 1764 | 40 |
882174 | 882174 | 2020-12-31 | Saline | Illinois | 17165 | 1764 | 40 |
878929 | 878929 | 2020-12-30 | Saline | Illinois | 17165 | 1748 | 40 |
875684 | 875684 | 2020-12-29 | Saline | Illinois | 17165 | 1721 | 40 |
706426 | 706426 | 2020-11-07 | Saline | Arkansas | 5125 | 3351 | 40 |
703183 | 703183 | 2020-11-06 | Saline | Arkansas | 5125 | 3287 | 40 |
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);