ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,478 rows where county = "Scott" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635057 | 635057 | 2020-10-16 | Scott | Arkansas | 5127 | 146 | 1 |
635568 | 635568 | 2020-10-16 | Scott | Illinois | 17171 | 88 | 0 |
635657 | 635657 | 2020-10-16 | Scott | Indiana | 18143 | 499 | 15 |
635760 | 635760 | 2020-10-16 | Scott | Iowa | 19163 | 3919 | 33 |
635864 | 635864 | 2020-10-16 | Scott | Kansas | 20171 | 188 | 1 |
635989 | 635989 | 2020-10-16 | Scott | Kentucky | 21209 | 978 | 17 |
636279 | 636279 | 2020-10-16 | Scott | Minnesota | 27139 | 3057 | 34 |
636360 | 636360 | 2020-10-16 | Scott | Mississippi | 28123 | 1216 | 29 |
636477 | 636477 | 2020-10-16 | Scott | Missouri | 29201 | 1186 | 18 |
637485 | 637485 | 2020-10-16 | Scott | Tennessee | 47151 | 300 | 3 |
637918 | 637918 | 2020-10-16 | Scott | Virginia | 51169 | 248 | 5 |
631811 | 631811 | 2020-10-15 | Scott | Arkansas | 5127 | 141 | 1 |
632322 | 632322 | 2020-10-15 | Scott | Illinois | 17171 | 88 | 0 |
632411 | 632411 | 2020-10-15 | Scott | Indiana | 18143 | 492 | 15 |
632514 | 632514 | 2020-10-15 | Scott | Iowa | 19163 | 3832 | 32 |
632618 | 632618 | 2020-10-15 | Scott | Kansas | 20171 | 172 | 1 |
632743 | 632743 | 2020-10-15 | Scott | Kentucky | 21209 | 971 | 17 |
633033 | 633033 | 2020-10-15 | Scott | Minnesota | 27139 | 3016 | 34 |
633114 | 633114 | 2020-10-15 | Scott | Mississippi | 28123 | 1213 | 29 |
633231 | 633231 | 2020-10-15 | Scott | Missouri | 29201 | 1164 | 18 |
634239 | 634239 | 2020-10-15 | Scott | Tennessee | 47151 | 299 | 3 |
634673 | 634673 | 2020-10-15 | Scott | Virginia | 51169 | 240 | 5 |
628567 | 628567 | 2020-10-14 | Scott | Arkansas | 5127 | 132 | 1 |
629078 | 629078 | 2020-10-14 | Scott | Illinois | 17171 | 84 | 0 |
629167 | 629167 | 2020-10-14 | Scott | Indiana | 18143 | 488 | 14 |
629270 | 629270 | 2020-10-14 | Scott | Iowa | 19163 | 3763 | 32 |
629374 | 629374 | 2020-10-14 | Scott | Kansas | 20171 | 172 | 1 |
629499 | 629499 | 2020-10-14 | Scott | Kentucky | 21209 | 956 | 16 |
629788 | 629788 | 2020-10-14 | Scott | Minnesota | 27139 | 2995 | 34 |
629869 | 629869 | 2020-10-14 | Scott | Mississippi | 28123 | 1206 | 29 |
629986 | 629986 | 2020-10-14 | Scott | Missouri | 29201 | 1151 | 18 |
630994 | 630994 | 2020-10-14 | Scott | Tennessee | 47151 | 294 | 3 |
631428 | 631428 | 2020-10-14 | Scott | Virginia | 51169 | 235 | 5 |
625324 | 625324 | 2020-10-13 | Scott | Arkansas | 5127 | 129 | 1 |
625835 | 625835 | 2020-10-13 | Scott | Illinois | 17171 | 84 | 0 |
625924 | 625924 | 2020-10-13 | Scott | Indiana | 18143 | 487 | 14 |
626027 | 626027 | 2020-10-13 | Scott | Iowa | 19163 | 3676 | 32 |
626131 | 626131 | 2020-10-13 | Scott | Kansas | 20171 | 172 | 1 |
626255 | 626255 | 2020-10-13 | Scott | Kentucky | 21209 | 934 | 16 |
626544 | 626544 | 2020-10-13 | Scott | Minnesota | 27139 | 2969 | 34 |
626625 | 626625 | 2020-10-13 | Scott | Mississippi | 28123 | 1202 | 29 |
626742 | 626742 | 2020-10-13 | Scott | Missouri | 29201 | 1114 | 17 |
627750 | 627750 | 2020-10-13 | Scott | Tennessee | 47151 | 283 | 3 |
628184 | 628184 | 2020-10-13 | Scott | Virginia | 51169 | 233 | 5 |
622081 | 622081 | 2020-10-12 | Scott | Arkansas | 5127 | 128 | 1 |
622593 | 622593 | 2020-10-12 | Scott | Illinois | 17171 | 84 | 0 |
622682 | 622682 | 2020-10-12 | Scott | Indiana | 18143 | 484 | 13 |
622785 | 622785 | 2020-10-12 | Scott | Iowa | 19163 | 3618 | 30 |
622889 | 622889 | 2020-10-12 | Scott | Kansas | 20171 | 166 | 1 |
623013 | 623013 | 2020-10-12 | Scott | Kentucky | 21209 | 929 | 16 |
623302 | 623302 | 2020-10-12 | Scott | Minnesota | 27139 | 2946 | 34 |
623383 | 623383 | 2020-10-12 | Scott | Mississippi | 28123 | 1199 | 29 |
623500 | 623500 | 2020-10-12 | Scott | Missouri | 29201 | 1114 | 17 |
624508 | 624508 | 2020-10-12 | Scott | Tennessee | 47151 | 280 | 3 |
624941 | 624941 | 2020-10-12 | Scott | Virginia | 51169 | 223 | 4 |
618838 | 618838 | 2020-10-11 | Scott | Arkansas | 5127 | 128 | 1 |
619349 | 619349 | 2020-10-11 | Scott | Illinois | 17171 | 84 | 0 |
619438 | 619438 | 2020-10-11 | Scott | Indiana | 18143 | 475 | 13 |
619541 | 619541 | 2020-10-11 | Scott | Iowa | 19163 | 3603 | 29 |
619645 | 619645 | 2020-10-11 | Scott | Kansas | 20171 | 151 | 1 |
619769 | 619769 | 2020-10-11 | Scott | Kentucky | 21209 | 922 | 16 |
620059 | 620059 | 2020-10-11 | Scott | Minnesota | 27139 | 2925 | 34 |
620140 | 620140 | 2020-10-11 | Scott | Mississippi | 28123 | 1199 | 29 |
620257 | 620257 | 2020-10-11 | Scott | Missouri | 29201 | 1114 | 17 |
621265 | 621265 | 2020-10-11 | Scott | Tennessee | 47151 | 274 | 3 |
621698 | 621698 | 2020-10-11 | Scott | Virginia | 51169 | 223 | 4 |
615596 | 615596 | 2020-10-10 | Scott | Arkansas | 5127 | 128 | 1 |
616107 | 616107 | 2020-10-10 | Scott | Illinois | 17171 | 84 | 0 |
616196 | 616196 | 2020-10-10 | Scott | Indiana | 18143 | 466 | 13 |
616299 | 616299 | 2020-10-10 | Scott | Iowa | 19163 | 3542 | 29 |
616403 | 616403 | 2020-10-10 | Scott | Kansas | 20171 | 151 | 1 |
616527 | 616527 | 2020-10-10 | Scott | Kentucky | 21209 | 908 | 16 |
616817 | 616817 | 2020-10-10 | Scott | Minnesota | 27139 | 2889 | 34 |
616898 | 616898 | 2020-10-10 | Scott | Mississippi | 28123 | 1198 | 29 |
617015 | 617015 | 2020-10-10 | Scott | Missouri | 29201 | 1114 | 17 |
618022 | 618022 | 2020-10-10 | Scott | Tennessee | 47151 | 271 | 3 |
618455 | 618455 | 2020-10-10 | Scott | Virginia | 51169 | 221 | 4 |
612355 | 612355 | 2020-10-09 | Scott | Arkansas | 5127 | 128 | 1 |
612866 | 612866 | 2020-10-09 | Scott | Illinois | 17171 | 83 | 0 |
612955 | 612955 | 2020-10-09 | Scott | Indiana | 18143 | 460 | 13 |
613058 | 613058 | 2020-10-09 | Scott | Iowa | 19163 | 3498 | 29 |
613162 | 613162 | 2020-10-09 | Scott | Kansas | 20171 | 141 | 1 |
613286 | 613286 | 2020-10-09 | Scott | Kentucky | 21209 | 896 | 16 |
613576 | 613576 | 2020-10-09 | Scott | Minnesota | 27139 | 2853 | 34 |
613657 | 613657 | 2020-10-09 | Scott | Mississippi | 28123 | 1193 | 28 |
613774 | 613774 | 2020-10-09 | Scott | Missouri | 29201 | 1026 | 17 |
614780 | 614780 | 2020-10-09 | Scott | Tennessee | 47151 | 263 | 3 |
615213 | 615213 | 2020-10-09 | Scott | Virginia | 51169 | 214 | 4 |
609113 | 609113 | 2020-10-08 | Scott | Arkansas | 5127 | 127 | 1 |
609624 | 609624 | 2020-10-08 | Scott | Illinois | 17171 | 82 | 0 |
609713 | 609713 | 2020-10-08 | Scott | Indiana | 18143 | 449 | 13 |
609816 | 609816 | 2020-10-08 | Scott | Iowa | 19163 | 3450 | 29 |
609920 | 609920 | 2020-10-08 | Scott | Kansas | 20171 | 141 | 1 |
610044 | 610044 | 2020-10-08 | Scott | Kentucky | 21209 | 884 | 16 |
610334 | 610334 | 2020-10-08 | Scott | Minnesota | 27139 | 2822 | 34 |
610415 | 610415 | 2020-10-08 | Scott | Mississippi | 28123 | 1193 | 28 |
610532 | 610532 | 2020-10-08 | Scott | Missouri | 29201 | 1002 | 17 |
611539 | 611539 | 2020-10-08 | Scott | Tennessee | 47151 | 264 | 3 |
611972 | 611972 | 2020-10-08 | Scott | Virginia | 51169 | 210 | 4 |
605870 | 605870 | 2020-10-07 | Scott | Arkansas | 5127 | 119 | 1 |
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);