ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where county = "Saline" and deaths = 166 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1762359 | 1762359 | 2021-09-28 | Saline | Kansas | 20169 | 7860 | 166 |
1759111 | 1759111 | 2021-09-27 | Saline | Kansas | 20169 | 7860 | 166 |
1755863 | 1755863 | 2021-09-26 | Saline | Kansas | 20169 | 7829 | 166 |
1752615 | 1752615 | 2021-09-25 | Saline | Kansas | 20169 | 7829 | 166 |
1749366 | 1749366 | 2021-09-24 | Saline | Kansas | 20169 | 7829 | 166 |
1293947 | 1293947 | 2021-05-07 | Saline | Arkansas | 5125 | 11921 | 166 |
1290701 | 1290701 | 2021-05-06 | Saline | Arkansas | 5125 | 11907 | 166 |
1287455 | 1287455 | 2021-05-05 | Saline | Arkansas | 5125 | 11899 | 166 |
1284209 | 1284209 | 2021-05-04 | Saline | Arkansas | 5125 | 11891 | 166 |
1280962 | 1280962 | 2021-05-03 | Saline | Arkansas | 5125 | 11875 | 166 |
1277715 | 1277715 | 2021-05-02 | Saline | Arkansas | 5125 | 11873 | 166 |
1274468 | 1274468 | 2021-05-01 | Saline | Arkansas | 5125 | 11867 | 166 |
1271221 | 1271221 | 2021-04-30 | Saline | Arkansas | 5125 | 11858 | 166 |
1267974 | 1267974 | 2021-04-29 | Saline | Arkansas | 5125 | 11848 | 166 |
1264727 | 1264727 | 2021-04-28 | Saline | Arkansas | 5125 | 11842 | 166 |
1261480 | 1261480 | 2021-04-27 | Saline | Arkansas | 5125 | 11834 | 166 |
1258233 | 1258233 | 2021-04-26 | Saline | Arkansas | 5125 | 11826 | 166 |
1254986 | 1254986 | 2021-04-25 | Saline | Arkansas | 5125 | 11824 | 166 |
1251739 | 1251739 | 2021-04-24 | Saline | Arkansas | 5125 | 11823 | 166 |
1248492 | 1248492 | 2021-04-23 | Saline | Arkansas | 5125 | 11820 | 166 |
1245245 | 1245245 | 2021-04-22 | Saline | Arkansas | 5125 | 11814 | 166 |
1241998 | 1241998 | 2021-04-21 | Saline | Arkansas | 5125 | 11809 | 166 |
1238751 | 1238751 | 2021-04-20 | Saline | Arkansas | 5125 | 11802 | 166 |
1235504 | 1235504 | 2021-04-19 | Saline | Arkansas | 5125 | 11790 | 166 |
1232257 | 1232257 | 2021-04-18 | Saline | Arkansas | 5125 | 11788 | 166 |
1229008 | 1229008 | 2021-04-17 | Saline | Arkansas | 5125 | 11785 | 166 |
1225760 | 1225760 | 2021-04-16 | Saline | Arkansas | 5125 | 11781 | 166 |
1222513 | 1222513 | 2021-04-15 | Saline | Arkansas | 5125 | 11774 | 166 |
1219265 | 1219265 | 2021-04-14 | Saline | Arkansas | 5125 | 11769 | 166 |
1216017 | 1216017 | 2021-04-13 | Saline | Arkansas | 5125 | 11762 | 166 |
1212770 | 1212770 | 2021-04-12 | Saline | Arkansas | 5125 | 11758 | 166 |
1209522 | 1209522 | 2021-04-11 | Saline | Arkansas | 5125 | 11757 | 166 |
1206273 | 1206273 | 2021-04-10 | Saline | Arkansas | 5125 | 11755 | 166 |
1203025 | 1203025 | 2021-04-09 | Saline | Arkansas | 5125 | 11752 | 166 |
1199777 | 1199777 | 2021-04-08 | Saline | Arkansas | 5125 | 11753 | 166 |
1196528 | 1196528 | 2021-04-07 | Saline | Arkansas | 5125 | 11744 | 166 |
1193280 | 1193280 | 2021-04-06 | Saline | Arkansas | 5125 | 11744 | 166 |
1190030 | 1190030 | 2021-04-05 | Saline | Arkansas | 5125 | 11743 | 166 |
1186783 | 1186783 | 2021-04-04 | Saline | Arkansas | 5125 | 11743 | 166 |
1183536 | 1183536 | 2021-04-03 | Saline | Arkansas | 5125 | 11740 | 166 |
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);