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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
34043 | 34043 | 2020-04-05 | Scott | Kentucky | 21209 | 21 | 0 |
34361 | 34361 | 2020-04-05 | Scott | Mississippi | 28123 | 23 | 0 |
34445 | 34445 | 2020-04-05 | Scott | Missouri | 29201 | 7 | 0 |
35133 | 35133 | 2020-04-05 | Scott | Tennessee | 47151 | 3 | 0 |
35742 | 35742 | 2020-04-06 | Scott | Arkansas | 5127 | 1 | 0 |
36501 | 36501 | 2020-04-06 | Scott | Kentucky | 21209 | 21 | 0 |
36824 | 36824 | 2020-04-06 | Scott | Mississippi | 28123 | 23 | 0 |
36911 | 36911 | 2020-04-06 | Scott | Missouri | 29201 | 10 | 0 |
37609 | 37609 | 2020-04-06 | Scott | Tennessee | 47151 | 3 | 0 |
38231 | 38231 | 2020-04-07 | Scott | Arkansas | 5127 | 1 | 0 |
38919 | 38919 | 2020-04-07 | Scott | Kansas | 20171 | 1 | 0 |
39008 | 39008 | 2020-04-07 | Scott | Kentucky | 21209 | 21 | 0 |
39335 | 39335 | 2020-04-07 | Scott | Mississippi | 28123 | 32 | 0 |
39427 | 39427 | 2020-04-07 | Scott | Missouri | 29201 | 10 | 0 |
40132 | 40132 | 2020-04-07 | Scott | Tennessee | 47151 | 4 | 0 |
40775 | 40775 | 2020-04-08 | Scott | Arkansas | 5127 | 1 | 0 |
41466 | 41466 | 2020-04-08 | Scott | Kansas | 20171 | 1 | 0 |
41558 | 41558 | 2020-04-08 | Scott | Kentucky | 21209 | 21 | 0 |
41889 | 41889 | 2020-04-08 | Scott | Mississippi | 28123 | 34 | 0 |
41981 | 41981 | 2020-04-08 | Scott | Missouri | 29201 | 11 | 0 |
42694 | 42694 | 2020-04-08 | Scott | Tennessee | 47151 | 5 | 0 |
43347 | 43347 | 2020-04-09 | Scott | Arkansas | 5127 | 1 | 0 |
44042 | 44042 | 2020-04-09 | Scott | Kansas | 20171 | 1 | 0 |
44134 | 44134 | 2020-04-09 | Scott | Kentucky | 21209 | 21 | 0 |
44466 | 44466 | 2020-04-09 | Scott | Mississippi | 28123 | 43 | 0 |
44558 | 44558 | 2020-04-09 | Scott | Missouri | 29201 | 13 | 0 |
45281 | 45281 | 2020-04-09 | Scott | Tennessee | 47151 | 5 | 0 |
45947 | 45947 | 2020-04-10 | Scott | Arkansas | 5127 | 1 | 0 |
46649 | 46649 | 2020-04-10 | Scott | Kansas | 20171 | 2 | 0 |
46742 | 46742 | 2020-04-10 | Scott | Kentucky | 21209 | 21 | 0 |
47075 | 47075 | 2020-04-10 | Scott | Mississippi | 28123 | 47 | 0 |
47167 | 47167 | 2020-04-10 | Scott | Missouri | 29201 | 13 | 0 |
47899 | 47899 | 2020-04-10 | Scott | Tennessee | 47151 | 8 | 0 |
48241 | 48241 | 2020-04-10 | Scott | Virginia | 51169 | 3 | 0 |
48577 | 48577 | 2020-04-11 | Scott | Arkansas | 5127 | 1 | 0 |
49286 | 49286 | 2020-04-11 | Scott | Kansas | 20171 | 2 | 0 |
49383 | 49383 | 2020-04-11 | Scott | Kentucky | 21209 | 22 | 0 |
49721 | 49721 | 2020-04-11 | Scott | Mississippi | 28123 | 52 | 0 |
49815 | 49815 | 2020-04-11 | Scott | Missouri | 29201 | 14 | 0 |
50557 | 50557 | 2020-04-11 | Scott | Tennessee | 47151 | 8 | 0 |
50899 | 50899 | 2020-04-11 | Scott | Virginia | 51169 | 3 | 0 |
51239 | 51239 | 2020-04-12 | Scott | Arkansas | 5127 | 1 | 0 |
51951 | 51951 | 2020-04-12 | Scott | Kansas | 20171 | 2 | 0 |
52051 | 52051 | 2020-04-12 | Scott | Kentucky | 21209 | 26 | 0 |
52394 | 52394 | 2020-04-12 | Scott | Mississippi | 28123 | 54 | 0 |
52488 | 52488 | 2020-04-12 | Scott | Missouri | 29201 | 15 | 0 |
53232 | 53232 | 2020-04-12 | Scott | Tennessee | 47151 | 8 | 0 |
53574 | 53574 | 2020-04-12 | Scott | Virginia | 51169 | 3 | 0 |
53918 | 53918 | 2020-04-13 | Scott | Arkansas | 5127 | 1 | 0 |
54633 | 54633 | 2020-04-13 | Scott | Kansas | 20171 | 2 | 0 |
54732 | 54732 | 2020-04-13 | Scott | Kentucky | 21209 | 26 | 0 |
55076 | 55076 | 2020-04-13 | Scott | Mississippi | 28123 | 58 | 0 |
55170 | 55170 | 2020-04-13 | Scott | Missouri | 29201 | 24 | 0 |
55919 | 55919 | 2020-04-13 | Scott | Tennessee | 47151 | 9 | 0 |
56264 | 56264 | 2020-04-13 | Scott | Virginia | 51169 | 3 | 0 |
56610 | 56610 | 2020-04-14 | Scott | Arkansas | 5127 | 1 | 0 |
57327 | 57327 | 2020-04-14 | Scott | Kansas | 20171 | 2 | 0 |
57430 | 57430 | 2020-04-14 | Scott | Kentucky | 21209 | 27 | 0 |
57774 | 57774 | 2020-04-14 | Scott | Mississippi | 28123 | 62 | 0 |
57868 | 57868 | 2020-04-14 | Scott | Missouri | 29201 | 25 | 0 |
58622 | 58622 | 2020-04-14 | Scott | Tennessee | 47151 | 10 | 0 |
58970 | 58970 | 2020-04-14 | Scott | Virginia | 51169 | 3 | 0 |
59318 | 59318 | 2020-04-15 | Scott | Arkansas | 5127 | 1 | 0 |
60035 | 60035 | 2020-04-15 | Scott | Kansas | 20171 | 2 | 0 |
60139 | 60139 | 2020-04-15 | Scott | Kentucky | 21209 | 27 | 0 |
60485 | 60485 | 2020-04-15 | Scott | Mississippi | 28123 | 79 | 0 |
60582 | 60582 | 2020-04-15 | Scott | Missouri | 29201 | 26 | 0 |
61338 | 61338 | 2020-04-15 | Scott | Tennessee | 47151 | 11 | 0 |
61689 | 61689 | 2020-04-15 | Scott | Virginia | 51169 | 3 | 0 |
62037 | 62037 | 2020-04-16 | Scott | Arkansas | 5127 | 1 | 0 |
62756 | 62756 | 2020-04-16 | Scott | Kansas | 20171 | 2 | 0 |
62859 | 62859 | 2020-04-16 | Scott | Kentucky | 21209 | 27 | 0 |
63207 | 63207 | 2020-04-16 | Scott | Mississippi | 28123 | 100 | 0 |
63304 | 63304 | 2020-04-16 | Scott | Missouri | 29201 | 41 | 0 |
64065 | 64065 | 2020-04-16 | Scott | Tennessee | 47151 | 11 | 0 |
64422 | 64422 | 2020-04-16 | Scott | Virginia | 51169 | 3 | 0 |
64770 | 64770 | 2020-04-17 | Scott | Arkansas | 5127 | 1 | 0 |
65492 | 65492 | 2020-04-17 | Scott | Kansas | 20171 | 1 | 0 |
65598 | 65598 | 2020-04-17 | Scott | Kentucky | 21209 | 27 | 0 |
65947 | 65947 | 2020-04-17 | Scott | Mississippi | 28123 | 96 | 0 |
66044 | 66044 | 2020-04-17 | Scott | Missouri | 29201 | 42 | 0 |
66812 | 66812 | 2020-04-17 | Scott | Tennessee | 47151 | 11 | 0 |
67170 | 67170 | 2020-04-17 | Scott | Virginia | 51169 | 3 | 0 |
67518 | 67518 | 2020-04-18 | Scott | Arkansas | 5127 | 1 | 0 |
68241 | 68241 | 2020-04-18 | Scott | Kansas | 20171 | 1 | 0 |
68347 | 68347 | 2020-04-18 | Scott | Kentucky | 21209 | 27 | 0 |
68699 | 68699 | 2020-04-18 | Scott | Mississippi | 28123 | 106 | 0 |
69571 | 69571 | 2020-04-18 | Scott | Tennessee | 47151 | 11 | 0 |
69932 | 69932 | 2020-04-18 | Scott | Virginia | 51169 | 4 | 0 |
70280 | 70280 | 2020-04-19 | Scott | Arkansas | 5127 | 1 | 0 |
71002 | 71002 | 2020-04-19 | Scott | Kansas | 20171 | 1 | 0 |
71110 | 71110 | 2020-04-19 | Scott | Kentucky | 21209 | 27 | 0 |
71465 | 71465 | 2020-04-19 | Scott | Mississippi | 28123 | 130 | 0 |
72338 | 72338 | 2020-04-19 | Scott | Tennessee | 47151 | 11 | 0 |
72702 | 72702 | 2020-04-19 | Scott | Virginia | 51169 | 4 | 0 |
73049 | 73049 | 2020-04-20 | Scott | Arkansas | 5127 | 1 | 0 |
73774 | 73774 | 2020-04-20 | Scott | Kansas | 20171 | 1 | 0 |
73882 | 73882 | 2020-04-20 | Scott | Kentucky | 21209 | 27 | 0 |
74238 | 74238 | 2020-04-20 | Scott | Mississippi | 28123 | 148 | 0 |
75113 | 75113 | 2020-04-20 | Scott | Tennessee | 47151 | 11 | 0 |
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);