ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where county = "Scott" and deaths = 26 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
county 1
- Scott · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1794043 | 1794043 | 2021-10-08 | Scott | Arkansas | 5127 | 1680 | 26 |
1790795 | 1790795 | 2021-10-07 | Scott | Arkansas | 5127 | 1676 | 26 |
1787546 | 1787546 | 2021-10-06 | Scott | Arkansas | 5127 | 1673 | 26 |
1784297 | 1784297 | 2021-10-05 | Scott | Arkansas | 5127 | 1670 | 26 |
1723371 | 1723371 | 2021-09-16 | Scott | Kansas | 20171 | 675 | 26 |
1720122 | 1720122 | 2021-09-15 | Scott | Kansas | 20171 | 675 | 26 |
1716874 | 1716874 | 2021-09-14 | Scott | Kansas | 20171 | 664 | 26 |
1713628 | 1713628 | 2021-09-13 | Scott | Kansas | 20171 | 664 | 26 |
1710381 | 1710381 | 2021-09-12 | Scott | Kansas | 20171 | 663 | 26 |
1707134 | 1707134 | 2021-09-11 | Scott | Kansas | 20171 | 663 | 26 |
1703886 | 1703886 | 2021-09-10 | Scott | Kansas | 20171 | 663 | 26 |
1129268 | 1129268 | 2021-03-17 | Scott | Kentucky | 21209 | 4368 | 26 |
1126022 | 1126022 | 2021-03-16 | Scott | Kentucky | 21209 | 4354 | 26 |
1122776 | 1122776 | 2021-03-15 | Scott | Kentucky | 21209 | 4335 | 26 |
1119529 | 1119529 | 2021-03-14 | Scott | Kentucky | 21209 | 4333 | 26 |
1116282 | 1116282 | 2021-03-13 | Scott | Kentucky | 21209 | 4330 | 26 |
1113036 | 1113036 | 2021-03-12 | Scott | Kentucky | 21209 | 4324 | 26 |
1109790 | 1109790 | 2021-03-11 | Scott | Kentucky | 21209 | 4303 | 26 |
1106544 | 1106544 | 2021-03-10 | Scott | Kentucky | 21209 | 4292 | 26 |
1103298 | 1103298 | 2021-03-09 | Scott | Kentucky | 21209 | 4253 | 26 |
1100052 | 1100052 | 2021-03-08 | Scott | Kentucky | 21209 | 4226 | 26 |
1096804 | 1096804 | 2021-03-07 | Scott | Kentucky | 21209 | 4214 | 26 |
1093558 | 1093558 | 2021-03-06 | Scott | Kentucky | 21209 | 4199 | 26 |
1090312 | 1090312 | 2021-03-05 | Scott | Kentucky | 21209 | 4164 | 26 |
1087067 | 1087067 | 2021-03-04 | Scott | Kentucky | 21209 | 4135 | 26 |
1083821 | 1083821 | 2021-03-03 | Scott | Kentucky | 21209 | 4115 | 26 |
1080575 | 1080575 | 2021-03-02 | Scott | Kentucky | 21209 | 4082 | 26 |
1077330 | 1077330 | 2021-03-01 | Scott | Kentucky | 21209 | 4057 | 26 |
1074084 | 1074084 | 2021-02-28 | Scott | Kentucky | 21209 | 4050 | 26 |
1070838 | 1070838 | 2021-02-27 | Scott | Kentucky | 21209 | 4039 | 26 |
1067593 | 1067593 | 2021-02-26 | Scott | Kentucky | 21209 | 4013 | 26 |
1064348 | 1064348 | 2021-02-25 | Scott | Kentucky | 21209 | 3986 | 26 |
1061103 | 1061103 | 2021-02-24 | Scott | Kentucky | 21209 | 3949 | 26 |
1057857 | 1057857 | 2021-02-23 | Scott | Kentucky | 21209 | 3915 | 26 |
1054611 | 1054611 | 2021-02-22 | Scott | Kentucky | 21209 | 3887 | 26 |
1051364 | 1051364 | 2021-02-21 | Scott | Kentucky | 21209 | 3878 | 26 |
1048117 | 1048117 | 2021-02-20 | Scott | Kentucky | 21209 | 3859 | 26 |
1044872 | 1044872 | 2021-02-19 | Scott | Kentucky | 21209 | 3835 | 26 |
1041627 | 1041627 | 2021-02-18 | Scott | Kentucky | 21209 | 3801 | 26 |
1038382 | 1038382 | 2021-02-17 | Scott | Kentucky | 21209 | 3786 | 26 |
1035137 | 1035137 | 2021-02-16 | Scott | Kentucky | 21209 | 3767 | 26 |
1031891 | 1031891 | 2021-02-15 | Scott | Kentucky | 21209 | 3760 | 26 |
1028644 | 1028644 | 2021-02-14 | Scott | Kentucky | 21209 | 3753 | 26 |
1025399 | 1025399 | 2021-02-13 | Scott | Kentucky | 21209 | 3729 | 26 |
1022154 | 1022154 | 2021-02-12 | Scott | Kentucky | 21209 | 3725 | 26 |
1018909 | 1018909 | 2021-02-11 | Scott | Kentucky | 21209 | 3703 | 26 |
1015664 | 1015664 | 2021-02-10 | Scott | Kentucky | 21209 | 3683 | 26 |
1012419 | 1012419 | 2021-02-09 | Scott | Kentucky | 21209 | 3668 | 26 |
1009173 | 1009173 | 2021-02-08 | Scott | Kentucky | 21209 | 3641 | 26 |
906813 | 906813 | 2021-01-07 | Scott | Tennessee | 47151 | 2131 | 26 |
903567 | 903567 | 2021-01-06 | Scott | Tennessee | 47151 | 2106 | 26 |
852078 | 852078 | 2020-12-21 | Scott | Virginia | 51169 | 1107 | 26 |
848833 | 848833 | 2020-12-20 | Scott | Virginia | 51169 | 1090 | 26 |
788150 | 788150 | 2020-12-02 | Scott | Indiana | 18143 | 1248 | 26 |
691632 | 691632 | 2020-11-02 | Scott | Missouri | 29201 | 1585 | 26 |
688387 | 688387 | 2020-11-01 | Scott | Missouri | 29201 | 1551 | 26 |
685143 | 685143 | 2020-10-31 | Scott | Missouri | 29201 | 1519 | 26 |
561794 | 561794 | 2020-09-23 | Scott | Mississippi | 28123 | 1171 | 26 |
538533 | 538533 | 2020-09-16 | Scott | Iowa | 19163 | 2601 | 26 |
535297 | 535297 | 2020-09-15 | Scott | Iowa | 19163 | 2550 | 26 |
532062 | 532062 | 2020-09-14 | Scott | Iowa | 19163 | 2534 | 26 |
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);