ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Scotts Bluff" and state = "Nebraska" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
18764 | 18764 | 2020-03-29 | Scotts Bluff | Nebraska | 31157 | 1 | 0 |
20800 | 20800 | 2020-03-30 | Scotts Bluff | Nebraska | 31157 | 1 | 0 |
22924 | 22924 | 2020-03-31 | Scotts Bluff | Nebraska | 31157 | 1 | 0 |
25114 | 25114 | 2020-04-01 | Scotts Bluff | Nebraska | 31157 | 3 | 0 |
27374 | 27374 | 2020-04-02 | Scotts Bluff | Nebraska | 31157 | 3 | 0 |
29698 | 29698 | 2020-04-03 | Scotts Bluff | Nebraska | 31157 | 3 | 0 |
32081 | 32081 | 2020-04-04 | Scotts Bluff | Nebraska | 31157 | 3 | 0 |
34511 | 34511 | 2020-04-05 | Scotts Bluff | Nebraska | 31157 | 3 | 0 |
36980 | 36980 | 2020-04-06 | Scotts Bluff | Nebraska | 31157 | 6 | 0 |
39496 | 39496 | 2020-04-07 | Scotts Bluff | Nebraska | 31157 | 6 | 0 |
42052 | 42052 | 2020-04-08 | Scotts Bluff | Nebraska | 31157 | 10 | 0 |
44634 | 44634 | 2020-04-09 | Scotts Bluff | Nebraska | 31157 | 10 | 0 |
47246 | 47246 | 2020-04-10 | Scotts Bluff | Nebraska | 31157 | 10 | 0 |
49897 | 49897 | 2020-04-11 | Scotts Bluff | Nebraska | 31157 | 12 | 0 |
52571 | 52571 | 2020-04-12 | Scotts Bluff | Nebraska | 31157 | 14 | 0 |
55252 | 55252 | 2020-04-13 | Scotts Bluff | Nebraska | 31157 | 14 | 0 |
57952 | 57952 | 2020-04-14 | Scotts Bluff | Nebraska | 31157 | 14 | 0 |
60667 | 60667 | 2020-04-15 | Scotts Bluff | Nebraska | 31157 | 16 | 0 |
63392 | 63392 | 2020-04-16 | Scotts Bluff | Nebraska | 31157 | 17 | 0 |
66134 | 66134 | 2020-04-17 | Scotts Bluff | Nebraska | 31157 | 18 | 0 |
68889 | 68889 | 2020-04-18 | Scotts Bluff | Nebraska | 31157 | 18 | 0 |
71656 | 71656 | 2020-04-19 | Scotts Bluff | Nebraska | 31157 | 22 | 0 |
74430 | 74430 | 2020-04-20 | Scotts Bluff | Nebraska | 31157 | 22 | 0 |
77210 | 77210 | 2020-04-21 | Scotts Bluff | Nebraska | 31157 | 22 | 0 |
79999 | 79999 | 2020-04-22 | Scotts Bluff | Nebraska | 31157 | 22 | 0 |
82796 | 82796 | 2020-04-23 | Scotts Bluff | Nebraska | 31157 | 23 | 0 |
85601 | 85601 | 2020-04-24 | Scotts Bluff | Nebraska | 31157 | 23 | 0 |
88411 | 88411 | 2020-04-25 | Scotts Bluff | Nebraska | 31157 | 26 | 0 |
91227 | 91227 | 2020-04-26 | Scotts Bluff | Nebraska | 31157 | 27 | 0 |
94049 | 94049 | 2020-04-27 | Scotts Bluff | Nebraska | 31157 | 27 | 0 |
96885 | 96885 | 2020-04-28 | Scotts Bluff | Nebraska | 31157 | 29 | 0 |
99732 | 99732 | 2020-04-29 | Scotts Bluff | Nebraska | 31157 | 29 | 0 |
102585 | 102585 | 2020-04-30 | Scotts Bluff | Nebraska | 31157 | 29 | 0 |
105446 | 105446 | 2020-05-01 | Scotts Bluff | Nebraska | 31157 | 29 | 0 |
108313 | 108313 | 2020-05-02 | Scotts Bluff | Nebraska | 31157 | 31 | 0 |
111186 | 111186 | 2020-05-03 | Scotts Bluff | Nebraska | 31157 | 34 | 0 |
114066 | 114066 | 2020-05-04 | Scotts Bluff | Nebraska | 31157 | 34 | 0 |
116948 | 116948 | 2020-05-05 | Scotts Bluff | Nebraska | 31157 | 34 | 0 |
119908 | 119908 | 2020-05-06 | Scotts Bluff | Nebraska | 31157 | 36 | 0 |
122882 | 122882 | 2020-05-07 | Scotts Bluff | Nebraska | 31157 | 36 | 0 |
125864 | 125864 | 2020-05-08 | Scotts Bluff | Nebraska | 31157 | 42 | 0 |
128853 | 128853 | 2020-05-09 | Scotts Bluff | Nebraska | 31157 | 44 | 0 |
131843 | 131843 | 2020-05-10 | Scotts Bluff | Nebraska | 31157 | 44 | 0 |
134834 | 134834 | 2020-05-11 | Scotts Bluff | Nebraska | 31157 | 44 | 0 |
137824 | 137824 | 2020-05-12 | Scotts Bluff | Nebraska | 31157 | 46 | 0 |
140819 | 140819 | 2020-05-13 | Scotts Bluff | Nebraska | 31157 | 47 | 0 |
143814 | 143814 | 2020-05-14 | Scotts Bluff | Nebraska | 31157 | 48 | 0 |
146815 | 146815 | 2020-05-15 | Scotts Bluff | Nebraska | 31157 | 51 | 0 |
149822 | 149822 | 2020-05-16 | Scotts Bluff | Nebraska | 31157 | 51 | 0 |
152833 | 152833 | 2020-05-17 | Scotts Bluff | Nebraska | 31157 | 54 | 0 |
155847 | 155847 | 2020-05-18 | Scotts Bluff | Nebraska | 31157 | 54 | 0 |
158865 | 158865 | 2020-05-19 | Scotts Bluff | Nebraska | 31157 | 54 | 0 |
161891 | 161891 | 2020-05-20 | Scotts Bluff | Nebraska | 31157 | 55 | 0 |
164920 | 164920 | 2020-05-21 | Scotts Bluff | Nebraska | 31157 | 58 | 0 |
167956 | 167956 | 2020-05-22 | Scotts Bluff | Nebraska | 31157 | 58 | 0 |
170995 | 170995 | 2020-05-23 | Scotts Bluff | Nebraska | 31157 | 62 | 0 |
174038 | 174038 | 2020-05-24 | Scotts Bluff | Nebraska | 31157 | 67 | 0 |
177081 | 177081 | 2020-05-25 | Scotts Bluff | Nebraska | 31157 | 67 | 0 |
180125 | 180125 | 2020-05-26 | Scotts Bluff | Nebraska | 31157 | 72 | 0 |
183173 | 183173 | 2020-05-27 | Scotts Bluff | Nebraska | 31157 | 75 | 0 |
186229 | 186229 | 2020-05-28 | Scotts Bluff | Nebraska | 31157 | 84 | 0 |
189288 | 189288 | 2020-05-29 | Scotts Bluff | Nebraska | 31157 | 88 | 0 |
192352 | 192352 | 2020-05-30 | Scotts Bluff | Nebraska | 31157 | 102 | 0 |
195422 | 195422 | 2020-05-31 | Scotts Bluff | Nebraska | 31157 | 102 | 0 |
198495 | 198495 | 2020-06-01 | Scotts Bluff | Nebraska | 31157 | 107 | 0 |
201569 | 201569 | 2020-06-02 | Scotts Bluff | Nebraska | 31157 | 112 | 0 |
204646 | 204646 | 2020-06-03 | Scotts Bluff | Nebraska | 31157 | 120 | 0 |
207727 | 207727 | 2020-06-04 | Scotts Bluff | Nebraska | 31157 | 124 | 0 |
210809 | 210809 | 2020-06-05 | Scotts Bluff | Nebraska | 31157 | 137 | 0 |
213893 | 213893 | 2020-06-06 | Scotts Bluff | Nebraska | 31157 | 140 | 0 |
216982 | 216982 | 2020-06-07 | Scotts Bluff | Nebraska | 31157 | 143 | 0 |
220074 | 220074 | 2020-06-08 | Scotts Bluff | Nebraska | 31157 | 145 | 0 |
223170 | 223170 | 2020-06-09 | Scotts Bluff | Nebraska | 31157 | 149 | 1 |
226269 | 226269 | 2020-06-10 | Scotts Bluff | Nebraska | 31157 | 149 | 1 |
229372 | 229372 | 2020-06-11 | Scotts Bluff | Nebraska | 31157 | 162 | 2 |
232477 | 232477 | 2020-06-12 | Scotts Bluff | Nebraska | 31157 | 170 | 2 |
235583 | 235583 | 2020-06-13 | Scotts Bluff | Nebraska | 31157 | 172 | 2 |
238690 | 238690 | 2020-06-14 | Scotts Bluff | Nebraska | 31157 | 172 | 2 |
241800 | 241800 | 2020-06-15 | Scotts Bluff | Nebraska | 31157 | 177 | 2 |
244911 | 244911 | 2020-06-16 | Scotts Bluff | Nebraska | 31157 | 178 | 2 |
248024 | 248024 | 2020-06-17 | Scotts Bluff | Nebraska | 31157 | 184 | 2 |
251139 | 251139 | 2020-06-18 | Scotts Bluff | Nebraska | 31157 | 187 | 2 |
254254 | 254254 | 2020-06-19 | Scotts Bluff | Nebraska | 31157 | 187 | 2 |
257377 | 257377 | 2020-06-20 | Scotts Bluff | Nebraska | 31157 | 188 | 2 |
260503 | 260503 | 2020-06-21 | Scotts Bluff | Nebraska | 31157 | 190 | 2 |
263632 | 263632 | 2020-06-22 | Scotts Bluff | Nebraska | 31157 | 193 | 3 |
266759 | 266759 | 2020-06-23 | Scotts Bluff | Nebraska | 31157 | 199 | 3 |
269894 | 269894 | 2020-06-24 | Scotts Bluff | Nebraska | 31157 | 202 | 3 |
273033 | 273033 | 2020-06-25 | Scotts Bluff | Nebraska | 31157 | 205 | 3 |
276176 | 276176 | 2020-06-26 | Scotts Bluff | Nebraska | 31157 | 208 | 3 |
279324 | 279324 | 2020-06-27 | Scotts Bluff | Nebraska | 31157 | 209 | 3 |
282472 | 282472 | 2020-06-28 | Scotts Bluff | Nebraska | 31157 | 209 | 3 |
285617 | 285617 | 2020-06-29 | Scotts Bluff | Nebraska | 31157 | 213 | 3 |
288767 | 288767 | 2020-06-30 | Scotts Bluff | Nebraska | 31157 | 215 | 3 |
291919 | 291919 | 2020-07-01 | Scotts Bluff | Nebraska | 31157 | 216 | 3 |
295074 | 295074 | 2020-07-02 | Scotts Bluff | Nebraska | 31157 | 216 | 3 |
298233 | 298233 | 2020-07-03 | Scotts Bluff | Nebraska | 31157 | 224 | 3 |
301396 | 301396 | 2020-07-04 | Scotts Bluff | Nebraska | 31157 | 224 | 3 |
304560 | 304560 | 2020-07-05 | Scotts Bluff | Nebraska | 31157 | 224 | 3 |
307727 | 307727 | 2020-07-06 | Scotts Bluff | Nebraska | 31157 | 227 | 3 |
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);