ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where county = "Scott" and deaths = 71 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Scott · 45 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2040218 | 2040218 | 2021-12-22 | Scott | Tennessee | 47151 | 5972 | 71 |
2035469 | 2035469 | 2021-12-21 | Scott | Kentucky | 21209 | 9722 | 71 |
2036968 | 2036968 | 2021-12-21 | Scott | Tennessee | 47151 | 5952 | 71 |
2033718 | 2033718 | 2021-12-20 | Scott | Tennessee | 47151 | 5951 | 71 |
1827136 | 1827136 | 2021-10-18 | Scott | Indiana | 18143 | 4365 | 71 |
1783914 | 1783914 | 2021-10-04 | Scott | Virginia | 51169 | 2820 | 71 |
1780665 | 1780665 | 2021-10-03 | Scott | Virginia | 51169 | 2755 | 71 |
1777415 | 1777415 | 2021-10-02 | Scott | Virginia | 51169 | 2755 | 71 |
1774165 | 1774165 | 2021-10-01 | Scott | Virginia | 51169 | 2755 | 71 |
1145873 | 1145873 | 2021-03-22 | Scott | Mississippi | 28123 | 3038 | 71 |
1142626 | 1142626 | 2021-03-21 | Scott | Mississippi | 28123 | 3036 | 71 |
1139379 | 1139379 | 2021-03-20 | Scott | Mississippi | 28123 | 3032 | 71 |
1136133 | 1136133 | 2021-03-19 | Scott | Mississippi | 28123 | 3027 | 71 |
1132887 | 1132887 | 2021-03-18 | Scott | Mississippi | 28123 | 3019 | 71 |
1129639 | 1129639 | 2021-03-17 | Scott | Mississippi | 28123 | 3015 | 71 |
1126392 | 1126392 | 2021-03-16 | Scott | Mississippi | 28123 | 3003 | 71 |
1123146 | 1123146 | 2021-03-15 | Scott | Mississippi | 28123 | 3000 | 71 |
1119899 | 1119899 | 2021-03-14 | Scott | Mississippi | 28123 | 2999 | 71 |
1116652 | 1116652 | 2021-03-13 | Scott | Mississippi | 28123 | 2993 | 71 |
1113406 | 1113406 | 2021-03-12 | Scott | Mississippi | 28123 | 2986 | 71 |
1110160 | 1110160 | 2021-03-11 | Scott | Mississippi | 28123 | 2980 | 71 |
1106914 | 1106914 | 2021-03-10 | Scott | Mississippi | 28123 | 2973 | 71 |
1103668 | 1103668 | 2021-03-09 | Scott | Mississippi | 28123 | 2971 | 71 |
1100422 | 1100422 | 2021-03-08 | Scott | Mississippi | 28123 | 2968 | 71 |
1097175 | 1097175 | 2021-03-07 | Scott | Mississippi | 28123 | 2967 | 71 |
1093928 | 1093928 | 2021-03-06 | Scott | Mississippi | 28123 | 2961 | 71 |
1090682 | 1090682 | 2021-03-05 | Scott | Mississippi | 28123 | 2957 | 71 |
1087437 | 1087437 | 2021-03-04 | Scott | Mississippi | 28123 | 2952 | 71 |
1012906 | 1012906 | 2021-02-09 | Scott | Missouri | 29201 | 3727 | 71 |
1009661 | 1009661 | 2021-02-08 | Scott | Missouri | 29201 | 3724 | 71 |
1006414 | 1006414 | 2021-02-07 | Scott | Missouri | 29201 | 3723 | 71 |
1003168 | 1003168 | 2021-02-06 | Scott | Missouri | 29201 | 3711 | 71 |
999923 | 999923 | 2021-02-05 | Scott | Missouri | 29201 | 3699 | 71 |
996677 | 996677 | 2021-02-04 | Scott | Missouri | 29201 | 3691 | 71 |
993431 | 993431 | 2021-02-03 | Scott | Missouri | 29201 | 3680 | 71 |
990185 | 990185 | 2021-02-02 | Scott | Missouri | 29201 | 3674 | 71 |
986938 | 986938 | 2021-02-01 | Scott | Missouri | 29201 | 3672 | 71 |
983691 | 983691 | 2021-01-31 | Scott | Missouri | 29201 | 3671 | 71 |
980445 | 980445 | 2021-01-30 | Scott | Missouri | 29201 | 3672 | 71 |
977199 | 977199 | 2021-01-29 | Scott | Missouri | 29201 | 3666 | 71 |
973954 | 973954 | 2021-01-28 | Scott | Missouri | 29201 | 3656 | 71 |
970709 | 970709 | 2021-01-27 | Scott | Missouri | 29201 | 3646 | 71 |
967464 | 967464 | 2021-01-26 | Scott | Missouri | 29201 | 3633 | 71 |
830963 | 830963 | 2020-12-15 | Scott | Minnesota | 27139 | 10233 | 71 |
827717 | 827717 | 2020-12-14 | Scott | Minnesota | 27139 | 10160 | 71 |
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);