ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where county = "Marshall" and deaths = 59 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 6
- Kentucky 14
- Tennessee 8
- Iowa 4
- Mississippi 4
- Alabama 2
- West Virginia 2
county 1
- Marshall · 34 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1463644 | 1463644 | 2021-06-28 | Marshall | Kentucky | 21157 | 2888 | 59 |
1460399 | 1460399 | 2021-06-27 | Marshall | Kentucky | 21157 | 2886 | 59 |
1457154 | 1457154 | 2021-06-26 | Marshall | Kentucky | 21157 | 2886 | 59 |
1453909 | 1453909 | 2021-06-25 | Marshall | Kentucky | 21157 | 2886 | 59 |
1450663 | 1450663 | 2021-06-24 | Marshall | Kentucky | 21157 | 2886 | 59 |
1447418 | 1447418 | 2021-06-23 | Marshall | Kentucky | 21157 | 2887 | 59 |
1444173 | 1444173 | 2021-06-22 | Marshall | Kentucky | 21157 | 2884 | 59 |
1440928 | 1440928 | 2021-06-21 | Marshall | Kentucky | 21157 | 2884 | 59 |
1437681 | 1437681 | 2021-06-20 | Marshall | Kentucky | 21157 | 2884 | 59 |
1434434 | 1434434 | 2021-06-19 | Marshall | Kentucky | 21157 | 2884 | 59 |
1431188 | 1431188 | 2021-06-18 | Marshall | Kentucky | 21157 | 2884 | 59 |
1427943 | 1427943 | 2021-06-17 | Marshall | Kentucky | 21157 | 2884 | 59 |
1424698 | 1424698 | 2021-06-16 | Marshall | Kentucky | 21157 | 2883 | 59 |
1421450 | 1421450 | 2021-06-15 | Marshall | Kentucky | 21157 | 2882 | 59 |
1406730 | 1406730 | 2021-06-10 | Marshall | Tennessee | 47117 | 4231 | 59 |
1403484 | 1403484 | 2021-06-09 | Marshall | Tennessee | 47117 | 4227 | 59 |
1400239 | 1400239 | 2021-06-08 | Marshall | Tennessee | 47117 | 4227 | 59 |
1396994 | 1396994 | 2021-06-07 | Marshall | Tennessee | 47117 | 4226 | 59 |
1393747 | 1393747 | 2021-06-06 | Marshall | Tennessee | 47117 | 4224 | 59 |
1390502 | 1390502 | 2021-06-05 | Marshall | Tennessee | 47117 | 4224 | 59 |
1387257 | 1387257 | 2021-06-04 | Marshall | Tennessee | 47117 | 4224 | 59 |
1384012 | 1384012 | 2021-06-03 | Marshall | Tennessee | 47117 | 4223 | 59 |
943028 | 943028 | 2021-01-18 | Marshall | West Virginia | 54051 | 2554 | 59 |
939783 | 939783 | 2021-01-17 | Marshall | West Virginia | 54051 | 2538 | 59 |
918050 | 918050 | 2021-01-11 | Marshall | Iowa | 19127 | 4204 | 59 |
914805 | 914805 | 2021-01-10 | Marshall | Iowa | 19127 | 4192 | 59 |
911560 | 911560 | 2021-01-09 | Marshall | Iowa | 19127 | 4185 | 59 |
908315 | 908315 | 2021-01-08 | Marshall | Iowa | 19127 | 4180 | 59 |
850503 | 850503 | 2020-12-21 | Marshall | Mississippi | 28093 | 2680 | 59 |
847258 | 847258 | 2020-12-20 | Marshall | Mississippi | 28093 | 2656 | 59 |
844012 | 844012 | 2020-12-19 | Marshall | Mississippi | 28093 | 2624 | 59 |
840767 | 840767 | 2020-12-18 | Marshall | Mississippi | 28093 | 2610 | 59 |
810141 | 810141 | 2020-12-09 | Marshall | Alabama | 1095 | 7435 | 59 |
806896 | 806896 | 2020-12-08 | Marshall | Alabama | 1095 | 7319 | 59 |
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);