ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where county = "Scott" and deaths = 83 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Scott · 50 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2012383 | 2012383 | 2021-12-14 | Scott | Indiana | 18143 | 5161 | 83 |
2009132 | 2009132 | 2021-12-13 | Scott | Indiana | 18143 | 5143 | 83 |
1943135 | 1943135 | 2021-11-22 | Scott | Virginia | 51169 | 3384 | 83 |
1939885 | 1939885 | 2021-11-21 | Scott | Virginia | 51169 | 3363 | 83 |
1936635 | 1936635 | 2021-11-20 | Scott | Virginia | 51169 | 3363 | 83 |
1933385 | 1933385 | 2021-11-19 | Scott | Virginia | 51169 | 3363 | 83 |
1930133 | 1930133 | 2021-11-18 | Scott | Virginia | 51169 | 3362 | 83 |
1926883 | 1926883 | 2021-11-17 | Scott | Virginia | 51169 | 3313 | 83 |
1923633 | 1923633 | 2021-11-16 | Scott | Virginia | 51169 | 3290 | 83 |
1920384 | 1920384 | 2021-11-15 | Scott | Virginia | 51169 | 3271 | 83 |
1665396 | 1665396 | 2021-08-29 | Scott | Mississippi | 28123 | 4086 | 83 |
1662148 | 1662148 | 2021-08-28 | Scott | Mississippi | 28123 | 4086 | 83 |
1658900 | 1658900 | 2021-08-27 | Scott | Mississippi | 28123 | 4086 | 83 |
1655651 | 1655651 | 2021-08-26 | Scott | Mississippi | 28123 | 4060 | 83 |
1652404 | 1652404 | 2021-08-25 | Scott | Mississippi | 28123 | 4025 | 83 |
1649156 | 1649156 | 2021-08-24 | Scott | Mississippi | 28123 | 3997 | 83 |
1259654 | 1259654 | 2021-04-26 | Scott | Missouri | 29201 | 4678 | 83 |
1256407 | 1256407 | 2021-04-25 | Scott | Missouri | 29201 | 4678 | 83 |
1253160 | 1253160 | 2021-04-24 | Scott | Missouri | 29201 | 4677 | 83 |
1249913 | 1249913 | 2021-04-23 | Scott | Missouri | 29201 | 4676 | 83 |
1246666 | 1246666 | 2021-04-22 | Scott | Missouri | 29201 | 4674 | 83 |
1243419 | 1243419 | 2021-04-21 | Scott | Missouri | 29201 | 4674 | 83 |
1240172 | 1240172 | 2021-04-20 | Scott | Missouri | 29201 | 4669 | 83 |
1236925 | 1236925 | 2021-04-19 | Scott | Missouri | 29201 | 4666 | 83 |
1233678 | 1233678 | 2021-04-18 | Scott | Missouri | 29201 | 4666 | 83 |
1230430 | 1230430 | 2021-04-17 | Scott | Missouri | 29201 | 4666 | 83 |
1227182 | 1227182 | 2021-04-16 | Scott | Missouri | 29201 | 4726 | 83 |
1223934 | 1223934 | 2021-04-15 | Scott | Missouri | 29201 | 4725 | 83 |
1220687 | 1220687 | 2021-04-14 | Scott | Missouri | 29201 | 4722 | 83 |
1217439 | 1217439 | 2021-04-13 | Scott | Missouri | 29201 | 4720 | 83 |
1214192 | 1214192 | 2021-04-12 | Scott | Missouri | 29201 | 4718 | 83 |
1210944 | 1210944 | 2021-04-11 | Scott | Missouri | 29201 | 4718 | 83 |
1207695 | 1207695 | 2021-04-10 | Scott | Missouri | 29201 | 4718 | 83 |
1204447 | 1204447 | 2021-04-09 | Scott | Missouri | 29201 | 4717 | 83 |
1201199 | 1201199 | 2021-04-08 | Scott | Missouri | 29201 | 4715 | 83 |
1197950 | 1197950 | 2021-04-07 | Scott | Missouri | 29201 | 4715 | 83 |
1194701 | 1194701 | 2021-04-06 | Scott | Missouri | 29201 | 4713 | 83 |
1191452 | 1191452 | 2021-04-05 | Scott | Missouri | 29201 | 4712 | 83 |
1188204 | 1188204 | 2021-04-04 | Scott | Missouri | 29201 | 4712 | 83 |
1184957 | 1184957 | 2021-04-03 | Scott | Missouri | 29201 | 4710 | 83 |
1181711 | 1181711 | 2021-04-02 | Scott | Missouri | 29201 | 4706 | 83 |
1178464 | 1178464 | 2021-04-01 | Scott | Missouri | 29201 | 4704 | 83 |
1175217 | 1175217 | 2021-03-31 | Scott | Missouri | 29201 | 4704 | 83 |
1171970 | 1171970 | 2021-03-30 | Scott | Missouri | 29201 | 4698 | 83 |
1168722 | 1168722 | 2021-03-29 | Scott | Missouri | 29201 | 4697 | 83 |
1165474 | 1165474 | 2021-03-28 | Scott | Missouri | 29201 | 4697 | 83 |
1162226 | 1162226 | 2021-03-27 | Scott | Missouri | 29201 | 4697 | 83 |
1158978 | 1158978 | 2021-03-26 | Scott | Missouri | 29201 | 4694 | 83 |
889378 | 889378 | 2021-01-02 | Scott | Minnesota | 27139 | 11108 | 83 |
768783 | 768783 | 2020-11-26 | Scott | Iowa | 19163 | 10856 | 83 |
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);