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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
29042 | 29042 | 2020-04-03 | Scott | Indiana | 18143 | 6 | 1 |
29115 | 29115 | 2020-04-03 | Scott | Iowa | 19163 | 31 | 0 |
29240 | 29240 | 2020-04-03 | Scott | Kentucky | 21209 | 8 | 0 |
29480 | 29480 | 2020-04-03 | Scott | Minnesota | 27139 | 11 | 1 |
29554 | 29554 | 2020-04-03 | Scott | Mississippi | 28123 | 17 | 0 |
29636 | 29636 | 2020-04-03 | Scott | Missouri | 29201 | 7 | 0 |
30305 | 30305 | 2020-04-03 | Scott | Tennessee | 47151 | 3 | 0 |
30893 | 30893 | 2020-04-04 | Scott | Arkansas | 5127 | 1 | 0 |
31409 | 31409 | 2020-04-04 | Scott | Indiana | 18143 | 7 | 1 |
31487 | 31487 | 2020-04-04 | Scott | Iowa | 19163 | 38 | 0 |
31618 | 31618 | 2020-04-04 | Scott | Kentucky | 21209 | 8 | 0 |
31860 | 31860 | 2020-04-04 | Scott | Minnesota | 27139 | 12 | 1 |
31934 | 31934 | 2020-04-04 | Scott | Mississippi | 28123 | 17 | 0 |
32017 | 32017 | 2020-04-04 | Scott | Missouri | 29201 | 7 | 0 |
32696 | 32696 | 2020-04-04 | Scott | Tennessee | 47151 | 3 | 0 |
33298 | 33298 | 2020-04-05 | Scott | Arkansas | 5127 | 1 | 0 |
33820 | 33820 | 2020-04-05 | Scott | Indiana | 18143 | 8 | 1 |
33900 | 33900 | 2020-04-05 | Scott | Iowa | 19163 | 41 | 1 |
34043 | 34043 | 2020-04-05 | Scott | Kentucky | 21209 | 21 | 0 |
34287 | 34287 | 2020-04-05 | Scott | Minnesota | 27139 | 13 | 1 |
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 |
36274 | 36274 | 2020-04-06 | Scott | Indiana | 18143 | 7 | 1 |
36356 | 36356 | 2020-04-06 | Scott | Iowa | 19163 | 52 | 1 |
36501 | 36501 | 2020-04-06 | Scott | Kentucky | 21209 | 21 | 0 |
36749 | 36749 | 2020-04-06 | Scott | Minnesota | 27139 | 15 | 1 |
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 |
38772 | 38772 | 2020-04-07 | Scott | Indiana | 18143 | 8 | 1 |
38857 | 38857 | 2020-04-07 | Scott | Iowa | 19163 | 66 | 1 |
38919 | 38919 | 2020-04-07 | Scott | Kansas | 20171 | 1 | 0 |
39008 | 39008 | 2020-04-07 | Scott | Kentucky | 21209 | 21 | 0 |
39259 | 39259 | 2020-04-07 | Scott | Minnesota | 27139 | 16 | 1 |
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 |
41318 | 41318 | 2020-04-08 | Scott | Indiana | 18143 | 11 | 2 |
41403 | 41403 | 2020-04-08 | Scott | Iowa | 19163 | 77 | 1 |
41466 | 41466 | 2020-04-08 | Scott | Kansas | 20171 | 1 | 0 |
41558 | 41558 | 2020-04-08 | Scott | Kentucky | 21209 | 21 | 0 |
41813 | 41813 | 2020-04-08 | Scott | Minnesota | 27139 | 17 | 1 |
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 |
43894 | 43894 | 2020-04-09 | Scott | Indiana | 18143 | 12 | 2 |
43979 | 43979 | 2020-04-09 | Scott | Iowa | 19163 | 88 | 1 |
44042 | 44042 | 2020-04-09 | Scott | Kansas | 20171 | 1 | 0 |
44134 | 44134 | 2020-04-09 | Scott | Kentucky | 21209 | 21 | 0 |
44389 | 44389 | 2020-04-09 | Scott | Minnesota | 27139 | 19 | 1 |
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 |
46499 | 46499 | 2020-04-10 | Scott | Indiana | 18143 | 12 | 2 |
46585 | 46585 | 2020-04-10 | Scott | Iowa | 19163 | 99 | 1 |
46649 | 46649 | 2020-04-10 | Scott | Kansas | 20171 | 2 | 0 |
46742 | 46742 | 2020-04-10 | Scott | Kentucky | 21209 | 21 | 0 |
46999 | 46999 | 2020-04-10 | Scott | Minnesota | 27139 | 19 | 1 |
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 |
49133 | 49133 | 2020-04-11 | Scott | Indiana | 18143 | 14 | 2 |
49219 | 49219 | 2020-04-11 | Scott | Iowa | 19163 | 111 | 1 |
49286 | 49286 | 2020-04-11 | Scott | Kansas | 20171 | 2 | 0 |
49383 | 49383 | 2020-04-11 | Scott | Kentucky | 21209 | 22 | 0 |
49644 | 49644 | 2020-04-11 | Scott | Minnesota | 27139 | 20 | 1 |
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 |
51797 | 51797 | 2020-04-12 | Scott | Indiana | 18143 | 17 | 2 |
51883 | 51883 | 2020-04-12 | Scott | Iowa | 19163 | 115 | 1 |
51951 | 51951 | 2020-04-12 | Scott | Kansas | 20171 | 2 | 0 |
52051 | 52051 | 2020-04-12 | Scott | Kentucky | 21209 | 26 | 0 |
52316 | 52316 | 2020-04-12 | Scott | Minnesota | 27139 | 20 | 1 |
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 |
54478 | 54478 | 2020-04-13 | Scott | Indiana | 18143 | 17 | 2 |
54565 | 54565 | 2020-04-13 | Scott | Iowa | 19163 | 118 | 1 |
54633 | 54633 | 2020-04-13 | Scott | Kansas | 20171 | 2 | 0 |
54732 | 54732 | 2020-04-13 | Scott | Kentucky | 21209 | 26 | 0 |
54998 | 54998 | 2020-04-13 | Scott | Minnesota | 27139 | 20 | 1 |
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 |
57171 | 57171 | 2020-04-14 | Scott | Indiana | 18143 | 17 | 2 |
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);