ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Scott" and fips = 20171 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
38919 | 38919 | 2020-04-07 | Scott | Kansas | 20171 | 1 | 0 |
41466 | 41466 | 2020-04-08 | Scott | Kansas | 20171 | 1 | 0 |
44042 | 44042 | 2020-04-09 | Scott | Kansas | 20171 | 1 | 0 |
65492 | 65492 | 2020-04-17 | Scott | Kansas | 20171 | 1 | 0 |
68241 | 68241 | 2020-04-18 | Scott | Kansas | 20171 | 1 | 0 |
71002 | 71002 | 2020-04-19 | Scott | Kansas | 20171 | 1 | 0 |
73774 | 73774 | 2020-04-20 | Scott | Kansas | 20171 | 1 | 0 |
76554 | 76554 | 2020-04-21 | Scott | Kansas | 20171 | 1 | 0 |
79339 | 79339 | 2020-04-22 | Scott | Kansas | 20171 | 1 | 0 |
82135 | 82135 | 2020-04-23 | Scott | Kansas | 20171 | 1 | 0 |
84938 | 84938 | 2020-04-24 | Scott | Kansas | 20171 | 1 | 0 |
87747 | 87747 | 2020-04-25 | Scott | Kansas | 20171 | 1 | 0 |
90563 | 90563 | 2020-04-26 | Scott | Kansas | 20171 | 1 | 0 |
93384 | 93384 | 2020-04-27 | Scott | Kansas | 20171 | 1 | 0 |
96217 | 96217 | 2020-04-28 | Scott | Kansas | 20171 | 1 | 0 |
99063 | 99063 | 2020-04-29 | Scott | Kansas | 20171 | 1 | 0 |
101915 | 101915 | 2020-04-30 | Scott | Kansas | 20171 | 1 | 0 |
104776 | 104776 | 2020-05-01 | Scott | Kansas | 20171 | 1 | 0 |
107641 | 107641 | 2020-05-02 | Scott | Kansas | 20171 | 1 | 0 |
110512 | 110512 | 2020-05-03 | Scott | Kansas | 20171 | 1 | 0 |
113389 | 113389 | 2020-05-04 | Scott | Kansas | 20171 | 1 | 0 |
46649 | 46649 | 2020-04-10 | Scott | Kansas | 20171 | 2 | 0 |
49286 | 49286 | 2020-04-11 | Scott | Kansas | 20171 | 2 | 0 |
51951 | 51951 | 2020-04-12 | Scott | Kansas | 20171 | 2 | 0 |
54633 | 54633 | 2020-04-13 | Scott | Kansas | 20171 | 2 | 0 |
57327 | 57327 | 2020-04-14 | Scott | Kansas | 20171 | 2 | 0 |
60035 | 60035 | 2020-04-15 | Scott | Kansas | 20171 | 2 | 0 |
62756 | 62756 | 2020-04-16 | Scott | Kansas | 20171 | 2 | 0 |
116271 | 116271 | 2020-05-05 | Scott | Kansas | 20171 | 2 | 0 |
119232 | 119232 | 2020-05-06 | Scott | Kansas | 20171 | 2 | 0 |
122202 | 122202 | 2020-05-07 | Scott | Kansas | 20171 | 2 | 0 |
125184 | 125184 | 2020-05-08 | Scott | Kansas | 20171 | 3 | 0 |
128172 | 128172 | 2020-05-09 | Scott | Kansas | 20171 | 3 | 0 |
131162 | 131162 | 2020-05-10 | Scott | Kansas | 20171 | 3 | 0 |
134153 | 134153 | 2020-05-11 | Scott | Kansas | 20171 | 4 | 0 |
137143 | 137143 | 2020-05-12 | Scott | Kansas | 20171 | 4 | 0 |
140136 | 140136 | 2020-05-13 | Scott | Kansas | 20171 | 6 | 0 |
143132 | 143132 | 2020-05-14 | Scott | Kansas | 20171 | 6 | 0 |
146132 | 146132 | 2020-05-15 | Scott | Kansas | 20171 | 7 | 0 |
149136 | 149136 | 2020-05-16 | Scott | Kansas | 20171 | 7 | 0 |
152147 | 152147 | 2020-05-17 | Scott | Kansas | 20171 | 7 | 0 |
155160 | 155160 | 2020-05-18 | Scott | Kansas | 20171 | 12 | 0 |
158177 | 158177 | 2020-05-19 | Scott | Kansas | 20171 | 12 | 0 |
161202 | 161202 | 2020-05-20 | Scott | Kansas | 20171 | 12 | 0 |
164231 | 164231 | 2020-05-21 | Scott | Kansas | 20171 | 12 | 0 |
167266 | 167266 | 2020-05-22 | Scott | Kansas | 20171 | 13 | 0 |
170304 | 170304 | 2020-05-23 | Scott | Kansas | 20171 | 13 | 0 |
173345 | 173345 | 2020-05-24 | Scott | Kansas | 20171 | 13 | 0 |
176389 | 176389 | 2020-05-25 | Scott | Kansas | 20171 | 13 | 0 |
179433 | 179433 | 2020-05-26 | Scott | Kansas | 20171 | 13 | 0 |
182478 | 182478 | 2020-05-27 | Scott | Kansas | 20171 | 13 | 0 |
185532 | 185532 | 2020-05-28 | Scott | Kansas | 20171 | 13 | 0 |
188590 | 188590 | 2020-05-29 | Scott | Kansas | 20171 | 13 | 0 |
191654 | 191654 | 2020-05-30 | Scott | Kansas | 20171 | 13 | 0 |
194722 | 194722 | 2020-05-31 | Scott | Kansas | 20171 | 13 | 0 |
197792 | 197792 | 2020-06-01 | Scott | Kansas | 20171 | 14 | 0 |
200864 | 200864 | 2020-06-02 | Scott | Kansas | 20171 | 14 | 0 |
203941 | 203941 | 2020-06-03 | Scott | Kansas | 20171 | 14 | 0 |
207022 | 207022 | 2020-06-04 | Scott | Kansas | 20171 | 14 | 0 |
210103 | 210103 | 2020-06-05 | Scott | Kansas | 20171 | 14 | 0 |
213188 | 213188 | 2020-06-06 | Scott | Kansas | 20171 | 14 | 0 |
216275 | 216275 | 2020-06-07 | Scott | Kansas | 20171 | 14 | 0 |
219367 | 219367 | 2020-06-08 | Scott | Kansas | 20171 | 15 | 0 |
222462 | 222462 | 2020-06-09 | Scott | Kansas | 20171 | 15 | 0 |
225557 | 225557 | 2020-06-10 | Scott | Kansas | 20171 | 15 | 0 |
228659 | 228659 | 2020-06-11 | Scott | Kansas | 20171 | 15 | 0 |
231762 | 231762 | 2020-06-12 | Scott | Kansas | 20171 | 15 | 0 |
234868 | 234868 | 2020-06-13 | Scott | Kansas | 20171 | 15 | 0 |
237975 | 237975 | 2020-06-14 | Scott | Kansas | 20171 | 15 | 0 |
241084 | 241084 | 2020-06-15 | Scott | Kansas | 20171 | 16 | 0 |
244195 | 244195 | 2020-06-16 | Scott | Kansas | 20171 | 16 | 0 |
247308 | 247308 | 2020-06-17 | Scott | Kansas | 20171 | 16 | 0 |
250420 | 250420 | 2020-06-18 | Scott | Kansas | 20171 | 16 | 0 |
253535 | 253535 | 2020-06-19 | Scott | Kansas | 20171 | 16 | 0 |
256655 | 256655 | 2020-06-20 | Scott | Kansas | 20171 | 16 | 0 |
259781 | 259781 | 2020-06-21 | Scott | Kansas | 20171 | 16 | 0 |
262908 | 262908 | 2020-06-22 | Scott | Kansas | 20171 | 16 | 0 |
266036 | 266036 | 2020-06-23 | Scott | Kansas | 20171 | 16 | 0 |
269168 | 269168 | 2020-06-24 | Scott | Kansas | 20171 | 16 | 0 |
272305 | 272305 | 2020-06-25 | Scott | Kansas | 20171 | 16 | 0 |
275448 | 275448 | 2020-06-26 | Scott | Kansas | 20171 | 16 | 0 |
278596 | 278596 | 2020-06-27 | Scott | Kansas | 20171 | 16 | 0 |
281744 | 281744 | 2020-06-28 | Scott | Kansas | 20171 | 16 | 0 |
291189 | 291189 | 2020-07-01 | Scott | Kansas | 20171 | 16 | 0 |
294343 | 294343 | 2020-07-02 | Scott | Kansas | 20171 | 16 | 0 |
297501 | 297501 | 2020-07-03 | Scott | Kansas | 20171 | 16 | 0 |
300663 | 300663 | 2020-07-04 | Scott | Kansas | 20171 | 16 | 0 |
303827 | 303827 | 2020-07-05 | Scott | Kansas | 20171 | 16 | 0 |
306994 | 306994 | 2020-07-06 | Scott | Kansas | 20171 | 16 | 0 |
310162 | 310162 | 2020-07-07 | Scott | Kansas | 20171 | 16 | 0 |
313332 | 313332 | 2020-07-08 | Scott | Kansas | 20171 | 16 | 0 |
316506 | 316506 | 2020-07-09 | Scott | Kansas | 20171 | 16 | 0 |
284890 | 284890 | 2020-06-29 | Scott | Kansas | 20171 | 17 | 0 |
288039 | 288039 | 2020-06-30 | Scott | Kansas | 20171 | 17 | 0 |
319681 | 319681 | 2020-07-10 | Scott | Kansas | 20171 | 17 | 0 |
322860 | 322860 | 2020-07-11 | Scott | Kansas | 20171 | 17 | 0 |
326043 | 326043 | 2020-07-12 | Scott | Kansas | 20171 | 18 | 0 |
329229 | 329229 | 2020-07-13 | Scott | Kansas | 20171 | 18 | 0 |
332416 | 332416 | 2020-07-14 | Scott | Kansas | 20171 | 19 | 0 |
335609 | 335609 | 2020-07-15 | Scott | Kansas | 20171 | 19 | 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);