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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4680 | 4680 | 2020-03-19 | Scott | Kentucky | 21209 | 1 | 0 |
4775 | 4775 | 2020-03-19 | Scott | Minnesota | 27139 | 1 | 0 |
4796 | 4796 | 2020-03-19 | Scott | Mississippi | 28123 | 1 | 0 |
5494 | 5494 | 2020-03-20 | Scott | Kentucky | 21209 | 1 | 0 |
5627 | 5627 | 2020-03-20 | Scott | Mississippi | 28123 | 1 | 0 |
5644 | 5644 | 2020-03-20 | Scott | Missouri | 29201 | 1 | 0 |
6441 | 6441 | 2020-03-21 | Scott | Kentucky | 21209 | 1 | 0 |
6610 | 6610 | 2020-03-21 | Scott | Mississippi | 28123 | 1 | 0 |
6634 | 6634 | 2020-03-21 | Scott | Missouri | 29201 | 1 | 0 |
7444 | 7444 | 2020-03-22 | Scott | Indiana | 18143 | 1 | 1 |
7471 | 7471 | 2020-03-22 | Scott | Iowa | 19163 | 1 | 0 |
7515 | 7515 | 2020-03-22 | Scott | Kentucky | 21209 | 1 | 0 |
7696 | 7696 | 2020-03-22 | Scott | Mississippi | 28123 | 1 | 0 |
7723 | 7723 | 2020-03-22 | Scott | Missouri | 29201 | 1 | 0 |
8602 | 8602 | 2020-03-23 | Scott | Indiana | 18143 | 1 | 1 |
8630 | 8630 | 2020-03-23 | Scott | Iowa | 19163 | 1 | 0 |
8678 | 8678 | 2020-03-23 | Scott | Kentucky | 21209 | 1 | 0 |
8878 | 8878 | 2020-03-23 | Scott | Mississippi | 28123 | 1 | 0 |
8914 | 8914 | 2020-03-23 | Scott | Missouri | 29201 | 1 | 0 |
9875 | 9875 | 2020-03-24 | Scott | Indiana | 18143 | 1 | 1 |
9909 | 9909 | 2020-03-24 | Scott | Iowa | 19163 | 1 | 0 |
9965 | 9965 | 2020-03-24 | Scott | Kentucky | 21209 | 1 | 0 |
10216 | 10216 | 2020-03-24 | Scott | Missouri | 29201 | 1 | 0 |
11271 | 11271 | 2020-03-25 | Scott | Indiana | 18143 | 1 | 1 |
11368 | 11368 | 2020-03-25 | Scott | Kentucky | 21209 | 1 | 0 |
11644 | 11644 | 2020-03-25 | Scott | Missouri | 29201 | 1 | 0 |
12831 | 12831 | 2020-03-26 | Scott | Indiana | 18143 | 1 | 1 |
12941 | 12941 | 2020-03-26 | Scott | Kentucky | 21209 | 1 | 0 |
13242 | 13242 | 2020-03-26 | Scott | Missouri | 29201 | 1 | 0 |
14517 | 14517 | 2020-03-27 | Scott | Indiana | 18143 | 1 | 1 |
14970 | 14970 | 2020-03-27 | Scott | Missouri | 29201 | 1 | 0 |
16316 | 16316 | 2020-03-28 | Scott | Indiana | 18143 | 1 | 1 |
18220 | 18220 | 2020-03-29 | Scott | Indiana | 18143 | 1 | 1 |
20226 | 20226 | 2020-03-30 | Scott | Indiana | 18143 | 1 | 1 |
21851 | 21851 | 2020-03-31 | Scott | Arkansas | 5127 | 1 | 0 |
22321 | 22321 | 2020-03-31 | Scott | Indiana | 18143 | 1 | 1 |
24009 | 24009 | 2020-04-01 | Scott | Arkansas | 5127 | 1 | 0 |
24492 | 24492 | 2020-04-01 | Scott | Indiana | 18143 | 1 | 1 |
26236 | 26236 | 2020-04-02 | Scott | Arkansas | 5127 | 1 | 0 |
28535 | 28535 | 2020-04-03 | Scott | Arkansas | 5127 | 1 | 0 |
30893 | 30893 | 2020-04-04 | Scott | Arkansas | 5127 | 1 | 0 |
33298 | 33298 | 2020-04-05 | Scott | Arkansas | 5127 | 1 | 0 |
35742 | 35742 | 2020-04-06 | Scott | Arkansas | 5127 | 1 | 0 |
38231 | 38231 | 2020-04-07 | Scott | Arkansas | 5127 | 1 | 0 |
38919 | 38919 | 2020-04-07 | Scott | Kansas | 20171 | 1 | 0 |
40775 | 40775 | 2020-04-08 | Scott | Arkansas | 5127 | 1 | 0 |
41466 | 41466 | 2020-04-08 | Scott | Kansas | 20171 | 1 | 0 |
43347 | 43347 | 2020-04-09 | Scott | Arkansas | 5127 | 1 | 0 |
44042 | 44042 | 2020-04-09 | Scott | Kansas | 20171 | 1 | 0 |
45947 | 45947 | 2020-04-10 | Scott | Arkansas | 5127 | 1 | 0 |
48577 | 48577 | 2020-04-11 | Scott | Arkansas | 5127 | 1 | 0 |
51239 | 51239 | 2020-04-12 | Scott | Arkansas | 5127 | 1 | 0 |
53918 | 53918 | 2020-04-13 | Scott | Arkansas | 5127 | 1 | 0 |
56610 | 56610 | 2020-04-14 | Scott | Arkansas | 5127 | 1 | 0 |
59318 | 59318 | 2020-04-15 | Scott | Arkansas | 5127 | 1 | 0 |
62037 | 62037 | 2020-04-16 | Scott | Arkansas | 5127 | 1 | 0 |
64770 | 64770 | 2020-04-17 | Scott | Arkansas | 5127 | 1 | 0 |
65492 | 65492 | 2020-04-17 | Scott | Kansas | 20171 | 1 | 0 |
67518 | 67518 | 2020-04-18 | Scott | Arkansas | 5127 | 1 | 0 |
68241 | 68241 | 2020-04-18 | Scott | Kansas | 20171 | 1 | 0 |
70280 | 70280 | 2020-04-19 | Scott | Arkansas | 5127 | 1 | 0 |
71002 | 71002 | 2020-04-19 | Scott | Kansas | 20171 | 1 | 0 |
73049 | 73049 | 2020-04-20 | Scott | Arkansas | 5127 | 1 | 0 |
73774 | 73774 | 2020-04-20 | Scott | Kansas | 20171 | 1 | 0 |
75825 | 75825 | 2020-04-21 | Scott | Arkansas | 5127 | 1 | 0 |
76554 | 76554 | 2020-04-21 | Scott | Kansas | 20171 | 1 | 0 |
78609 | 78609 | 2020-04-22 | Scott | Arkansas | 5127 | 1 | 0 |
79339 | 79339 | 2020-04-22 | Scott | Kansas | 20171 | 1 | 0 |
81403 | 81403 | 2020-04-23 | Scott | Arkansas | 5127 | 1 | 0 |
82135 | 82135 | 2020-04-23 | Scott | Kansas | 20171 | 1 | 0 |
84203 | 84203 | 2020-04-24 | Scott | Arkansas | 5127 | 1 | 0 |
84938 | 84938 | 2020-04-24 | Scott | Kansas | 20171 | 1 | 0 |
87011 | 87011 | 2020-04-25 | Scott | Arkansas | 5127 | 1 | 0 |
87747 | 87747 | 2020-04-25 | Scott | Kansas | 20171 | 1 | 0 |
89828 | 89828 | 2020-04-26 | Scott | Arkansas | 5127 | 1 | 0 |
90563 | 90563 | 2020-04-26 | Scott | Kansas | 20171 | 1 | 0 |
92646 | 92646 | 2020-04-27 | Scott | Arkansas | 5127 | 1 | 0 |
93384 | 93384 | 2020-04-27 | Scott | Kansas | 20171 | 1 | 0 |
95477 | 95477 | 2020-04-28 | Scott | Arkansas | 5127 | 1 | 0 |
96217 | 96217 | 2020-04-28 | Scott | Kansas | 20171 | 1 | 0 |
98322 | 98322 | 2020-04-29 | Scott | Arkansas | 5127 | 1 | 0 |
99063 | 99063 | 2020-04-29 | Scott | Kansas | 20171 | 1 | 0 |
101172 | 101172 | 2020-04-30 | Scott | Arkansas | 5127 | 1 | 0 |
101915 | 101915 | 2020-04-30 | Scott | Kansas | 20171 | 1 | 0 |
104027 | 104027 | 2020-05-01 | Scott | Arkansas | 5127 | 1 | 0 |
104776 | 104776 | 2020-05-01 | Scott | Kansas | 20171 | 1 | 0 |
106892 | 106892 | 2020-05-02 | Scott | Arkansas | 5127 | 1 | 0 |
107641 | 107641 | 2020-05-02 | Scott | Kansas | 20171 | 1 | 0 |
109761 | 109761 | 2020-05-03 | Scott | Arkansas | 5127 | 1 | 0 |
110512 | 110512 | 2020-05-03 | Scott | Kansas | 20171 | 1 | 0 |
112636 | 112636 | 2020-05-04 | Scott | Arkansas | 5127 | 1 | 0 |
113389 | 113389 | 2020-05-04 | Scott | Kansas | 20171 | 1 | 0 |
115519 | 115519 | 2020-05-05 | Scott | Arkansas | 5127 | 1 | 0 |
118478 | 118478 | 2020-05-06 | Scott | Arkansas | 5127 | 1 | 0 |
121445 | 121445 | 2020-05-07 | Scott | Arkansas | 5127 | 1 | 0 |
124425 | 124425 | 2020-05-08 | Scott | Arkansas | 5127 | 1 | 0 |
127410 | 127410 | 2020-05-09 | Scott | Arkansas | 5127 | 1 | 0 |
130400 | 130400 | 2020-05-10 | Scott | Arkansas | 5127 | 1 | 0 |
133390 | 133390 | 2020-05-11 | Scott | Arkansas | 5127 | 1 | 0 |
136380 | 136380 | 2020-05-12 | Scott | Arkansas | 5127 | 1 | 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);