ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where county = "Scott" and deaths = 103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Scott · 42 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2416012 | 2416012 | 2022-04-17 | Scott | Kentucky | 21209 | 17160 | 103 |
2412756 | 2412756 | 2022-04-16 | Scott | Kentucky | 21209 | 17160 | 103 |
2409500 | 2409500 | 2022-04-15 | Scott | Kentucky | 21209 | 17160 | 103 |
2406244 | 2406244 | 2022-04-14 | Scott | Kentucky | 21209 | 17160 | 103 |
2402988 | 2402988 | 2022-04-13 | Scott | Kentucky | 21209 | 17160 | 103 |
2399734 | 2399734 | 2022-04-12 | Scott | Kentucky | 21209 | 17160 | 103 |
2396478 | 2396478 | 2022-04-11 | Scott | Kentucky | 21209 | 17160 | 103 |
2393223 | 2393223 | 2022-04-10 | Scott | Kentucky | 21209 | 16907 | 103 |
2389967 | 2389967 | 2022-04-09 | Scott | Kentucky | 21209 | 16907 | 103 |
2386711 | 2386711 | 2022-04-08 | Scott | Kentucky | 21209 | 16907 | 103 |
2383456 | 2383456 | 2022-04-07 | Scott | Kentucky | 21209 | 16907 | 103 |
2380201 | 2380201 | 2022-04-06 | Scott | Kentucky | 21209 | 16907 | 103 |
2376946 | 2376946 | 2022-04-05 | Scott | Kentucky | 21209 | 16907 | 103 |
2373694 | 2373694 | 2022-04-04 | Scott | Kentucky | 21209 | 16907 | 103 |
2269274 | 2269274 | 2022-03-03 | Scott | Indiana | 18143 | 7834 | 103 |
2241844 | 2241844 | 2022-02-22 | Scott | Tennessee | 47151 | 8612 | 103 |
2238593 | 2238593 | 2022-02-21 | Scott | Tennessee | 47151 | 8612 | 103 |
2235342 | 2235342 | 2022-02-20 | Scott | Tennessee | 47151 | 8612 | 103 |
2232091 | 2232091 | 2022-02-19 | Scott | Tennessee | 47151 | 8612 | 103 |
2228840 | 2228840 | 2022-02-18 | Scott | Tennessee | 47151 | 8612 | 103 |
2225589 | 2225589 | 2022-02-17 | Scott | Tennessee | 47151 | 8612 | 103 |
2222338 | 2222338 | 2022-02-16 | Scott | Tennessee | 47151 | 8612 | 103 |
2165911 | 2165911 | 2022-01-30 | Scott | Mississippi | 28123 | 6163 | 103 |
2162656 | 2162656 | 2022-01-29 | Scott | Mississippi | 28123 | 6163 | 103 |
2159401 | 2159401 | 2022-01-28 | Scott | Mississippi | 28123 | 6163 | 103 |
2156147 | 2156147 | 2022-01-27 | Scott | Mississippi | 28123 | 6133 | 103 |
2152894 | 2152894 | 2022-01-26 | Scott | Mississippi | 28123 | 6092 | 103 |
1743480 | 1743480 | 2021-09-22 | Scott | Missouri | 29201 | 6757 | 103 |
1740231 | 1740231 | 2021-09-21 | Scott | Missouri | 29201 | 6732 | 103 |
1019198 | 1019198 | 2021-02-11 | Scott | Minnesota | 27139 | 12732 | 103 |
1015953 | 1015953 | 2021-02-10 | Scott | Minnesota | 27139 | 12700 | 103 |
1012708 | 1012708 | 2021-02-09 | Scott | Minnesota | 27139 | 12681 | 103 |
1009463 | 1009463 | 2021-02-08 | Scott | Minnesota | 27139 | 12646 | 103 |
1006216 | 1006216 | 2021-02-07 | Scott | Minnesota | 27139 | 12636 | 103 |
1002970 | 1002970 | 2021-02-06 | Scott | Minnesota | 27139 | 12602 | 103 |
999725 | 999725 | 2021-02-05 | Scott | Minnesota | 27139 | 12573 | 103 |
996479 | 996479 | 2021-02-04 | Scott | Minnesota | 27139 | 12552 | 103 |
993233 | 993233 | 2021-02-03 | Scott | Minnesota | 27139 | 12517 | 103 |
989987 | 989987 | 2021-02-02 | Scott | Minnesota | 27139 | 12483 | 103 |
986740 | 986740 | 2021-02-01 | Scott | Minnesota | 27139 | 12453 | 103 |
983493 | 983493 | 2021-01-31 | Scott | Minnesota | 27139 | 12421 | 103 |
980247 | 980247 | 2021-01-30 | Scott | Minnesota | 27139 | 12396 | 103 |
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);