ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Scott" and fips = 21209 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- …
state 1
- Kentucky 786
fips 1
- 21209 · 786 ✖
county 1
- Scott · 786 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4680 | 4680 | 2020-03-19 | Scott | Kentucky | 21209 | 1 | 0 |
5494 | 5494 | 2020-03-20 | Scott | Kentucky | 21209 | 1 | 0 |
6441 | 6441 | 2020-03-21 | Scott | Kentucky | 21209 | 1 | 0 |
7515 | 7515 | 2020-03-22 | Scott | Kentucky | 21209 | 1 | 0 |
8678 | 8678 | 2020-03-23 | Scott | Kentucky | 21209 | 1 | 0 |
9965 | 9965 | 2020-03-24 | Scott | Kentucky | 21209 | 1 | 0 |
11368 | 11368 | 2020-03-25 | Scott | Kentucky | 21209 | 1 | 0 |
12941 | 12941 | 2020-03-26 | Scott | Kentucky | 21209 | 1 | 0 |
14647 | 14647 | 2020-03-27 | Scott | Kentucky | 21209 | 3 | 0 |
16463 | 16463 | 2020-03-28 | Scott | Kentucky | 21209 | 5 | 0 |
18374 | 18374 | 2020-03-29 | Scott | Kentucky | 21209 | 6 | 0 |
20390 | 20390 | 2020-03-30 | Scott | Kentucky | 21209 | 6 | 0 |
22498 | 22498 | 2020-03-31 | Scott | Kentucky | 21209 | 7 | 0 |
24674 | 24674 | 2020-04-01 | Scott | Kentucky | 21209 | 7 | 0 |
26924 | 26924 | 2020-04-02 | Scott | Kentucky | 21209 | 8 | 0 |
29240 | 29240 | 2020-04-03 | Scott | Kentucky | 21209 | 8 | 0 |
31618 | 31618 | 2020-04-04 | Scott | Kentucky | 21209 | 8 | 0 |
34043 | 34043 | 2020-04-05 | Scott | Kentucky | 21209 | 21 | 0 |
36501 | 36501 | 2020-04-06 | Scott | Kentucky | 21209 | 21 | 0 |
39008 | 39008 | 2020-04-07 | Scott | Kentucky | 21209 | 21 | 0 |
41558 | 41558 | 2020-04-08 | Scott | Kentucky | 21209 | 21 | 0 |
44134 | 44134 | 2020-04-09 | Scott | Kentucky | 21209 | 21 | 0 |
46742 | 46742 | 2020-04-10 | Scott | Kentucky | 21209 | 21 | 0 |
49383 | 49383 | 2020-04-11 | Scott | Kentucky | 21209 | 22 | 0 |
52051 | 52051 | 2020-04-12 | Scott | Kentucky | 21209 | 26 | 0 |
54732 | 54732 | 2020-04-13 | Scott | Kentucky | 21209 | 26 | 0 |
57430 | 57430 | 2020-04-14 | Scott | Kentucky | 21209 | 27 | 0 |
60139 | 60139 | 2020-04-15 | Scott | Kentucky | 21209 | 27 | 0 |
62859 | 62859 | 2020-04-16 | Scott | Kentucky | 21209 | 27 | 0 |
65598 | 65598 | 2020-04-17 | Scott | Kentucky | 21209 | 27 | 0 |
68347 | 68347 | 2020-04-18 | Scott | Kentucky | 21209 | 27 | 0 |
71110 | 71110 | 2020-04-19 | Scott | Kentucky | 21209 | 27 | 0 |
73882 | 73882 | 2020-04-20 | Scott | Kentucky | 21209 | 27 | 0 |
76663 | 76663 | 2020-04-21 | Scott | Kentucky | 21209 | 27 | 0 |
79448 | 79448 | 2020-04-22 | Scott | Kentucky | 21209 | 27 | 0 |
82245 | 82245 | 2020-04-23 | Scott | Kentucky | 21209 | 28 | 0 |
85048 | 85048 | 2020-04-24 | Scott | Kentucky | 21209 | 28 | 0 |
87857 | 87857 | 2020-04-25 | Scott | Kentucky | 21209 | 28 | 0 |
90673 | 90673 | 2020-04-26 | Scott | Kentucky | 21209 | 28 | 0 |
93494 | 93494 | 2020-04-27 | Scott | Kentucky | 21209 | 28 | 0 |
96329 | 96329 | 2020-04-28 | Scott | Kentucky | 21209 | 29 | 0 |
99175 | 99175 | 2020-04-29 | Scott | Kentucky | 21209 | 29 | 0 |
102027 | 102027 | 2020-04-30 | Scott | Kentucky | 21209 | 29 | 0 |
104888 | 104888 | 2020-05-01 | Scott | Kentucky | 21209 | 29 | 0 |
107753 | 107753 | 2020-05-02 | Scott | Kentucky | 21209 | 29 | 0 |
110624 | 110624 | 2020-05-03 | Scott | Kentucky | 21209 | 29 | 0 |
113501 | 113501 | 2020-05-04 | Scott | Kentucky | 21209 | 31 | 0 |
116383 | 116383 | 2020-05-05 | Scott | Kentucky | 21209 | 31 | 0 |
119344 | 119344 | 2020-05-06 | Scott | Kentucky | 21209 | 31 | 0 |
122315 | 122315 | 2020-05-07 | Scott | Kentucky | 21209 | 32 | 0 |
125297 | 125297 | 2020-05-08 | Scott | Kentucky | 21209 | 32 | 0 |
128285 | 128285 | 2020-05-09 | Scott | Kentucky | 21209 | 32 | 0 |
131275 | 131275 | 2020-05-10 | Scott | Kentucky | 21209 | 32 | 0 |
134266 | 134266 | 2020-05-11 | Scott | Kentucky | 21209 | 32 | 0 |
137256 | 137256 | 2020-05-12 | Scott | Kentucky | 21209 | 33 | 0 |
140249 | 140249 | 2020-05-13 | Scott | Kentucky | 21209 | 33 | 0 |
143245 | 143245 | 2020-05-14 | Scott | Kentucky | 21209 | 33 | 0 |
146245 | 146245 | 2020-05-15 | Scott | Kentucky | 21209 | 34 | 0 |
149250 | 149250 | 2020-05-16 | Scott | Kentucky | 21209 | 34 | 0 |
152261 | 152261 | 2020-05-17 | Scott | Kentucky | 21209 | 34 | 0 |
155275 | 155275 | 2020-05-18 | Scott | Kentucky | 21209 | 34 | 0 |
158292 | 158292 | 2020-05-19 | Scott | Kentucky | 21209 | 34 | 0 |
161318 | 161318 | 2020-05-20 | Scott | Kentucky | 21209 | 34 | 0 |
164347 | 164347 | 2020-05-21 | Scott | Kentucky | 21209 | 34 | 0 |
167383 | 167383 | 2020-05-22 | Scott | Kentucky | 21209 | 34 | 0 |
170421 | 170421 | 2020-05-23 | Scott | Kentucky | 21209 | 34 | 0 |
173462 | 173462 | 2020-05-24 | Scott | Kentucky | 21209 | 34 | 0 |
176506 | 176506 | 2020-05-25 | Scott | Kentucky | 21209 | 34 | 0 |
179550 | 179550 | 2020-05-26 | Scott | Kentucky | 21209 | 35 | 0 |
182595 | 182595 | 2020-05-27 | Scott | Kentucky | 21209 | 35 | 0 |
185650 | 185650 | 2020-05-28 | Scott | Kentucky | 21209 | 35 | 0 |
188708 | 188708 | 2020-05-29 | Scott | Kentucky | 21209 | 35 | 0 |
191772 | 191772 | 2020-05-30 | Scott | Kentucky | 21209 | 35 | 0 |
194840 | 194840 | 2020-05-31 | Scott | Kentucky | 21209 | 35 | 0 |
197911 | 197911 | 2020-06-01 | Scott | Kentucky | 21209 | 35 | 0 |
200983 | 200983 | 2020-06-02 | Scott | Kentucky | 21209 | 35 | 0 |
204060 | 204060 | 2020-06-03 | Scott | Kentucky | 21209 | 35 | 0 |
207141 | 207141 | 2020-06-04 | Scott | Kentucky | 21209 | 37 | 0 |
210222 | 210222 | 2020-06-05 | Scott | Kentucky | 21209 | 37 | 0 |
213307 | 213307 | 2020-06-06 | Scott | Kentucky | 21209 | 37 | 0 |
216394 | 216394 | 2020-06-07 | Scott | Kentucky | 21209 | 37 | 0 |
219486 | 219486 | 2020-06-08 | Scott | Kentucky | 21209 | 54 | 0 |
222581 | 222581 | 2020-06-09 | Scott | Kentucky | 21209 | 54 | 0 |
225677 | 225677 | 2020-06-10 | Scott | Kentucky | 21209 | 54 | 0 |
228779 | 228779 | 2020-06-11 | Scott | Kentucky | 21209 | 54 | 0 |
231883 | 231883 | 2020-06-12 | Scott | Kentucky | 21209 | 54 | 0 |
234988 | 234988 | 2020-06-13 | Scott | Kentucky | 21209 | 54 | 0 |
238095 | 238095 | 2020-06-14 | Scott | Kentucky | 21209 | 54 | 0 |
241204 | 241204 | 2020-06-15 | Scott | Kentucky | 21209 | 54 | 0 |
244315 | 244315 | 2020-06-16 | Scott | Kentucky | 21209 | 54 | 0 |
247428 | 247428 | 2020-06-17 | Scott | Kentucky | 21209 | 54 | 0 |
250540 | 250540 | 2020-06-18 | Scott | Kentucky | 21209 | 57 | 0 |
253655 | 253655 | 2020-06-19 | Scott | Kentucky | 21209 | 60 | 0 |
256775 | 256775 | 2020-06-20 | Scott | Kentucky | 21209 | 66 | 0 |
259901 | 259901 | 2020-06-21 | Scott | Kentucky | 21209 | 67 | 0 |
263030 | 263030 | 2020-06-22 | Scott | Kentucky | 21209 | 67 | 0 |
266157 | 266157 | 2020-06-23 | Scott | Kentucky | 21209 | 75 | 0 |
269290 | 269290 | 2020-06-24 | Scott | Kentucky | 21209 | 76 | 0 |
272426 | 272426 | 2020-06-25 | Scott | Kentucky | 21209 | 79 | 0 |
278717 | 278717 | 2020-06-27 | Scott | Kentucky | 21209 | 82 | 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);