ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 31185 and state = "Nebraska" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20803 | 20803 | 2020-03-30 | York | Nebraska | 31185 | 1 | 0 |
22926 | 22926 | 2020-03-31 | York | Nebraska | 31185 | 1 | 0 |
25117 | 25117 | 2020-04-01 | York | Nebraska | 31185 | 1 | 0 |
27377 | 27377 | 2020-04-02 | York | Nebraska | 31185 | 1 | 0 |
29700 | 29700 | 2020-04-03 | York | Nebraska | 31185 | 1 | 0 |
32083 | 32083 | 2020-04-04 | York | Nebraska | 31185 | 1 | 0 |
34514 | 34514 | 2020-04-05 | York | Nebraska | 31185 | 1 | 0 |
36984 | 36984 | 2020-04-06 | York | Nebraska | 31185 | 1 | 0 |
39500 | 39500 | 2020-04-07 | York | Nebraska | 31185 | 2 | 0 |
42056 | 42056 | 2020-04-08 | York | Nebraska | 31185 | 2 | 0 |
44638 | 44638 | 2020-04-09 | York | Nebraska | 31185 | 2 | 0 |
47251 | 47251 | 2020-04-10 | York | Nebraska | 31185 | 3 | 0 |
49903 | 49903 | 2020-04-11 | York | Nebraska | 31185 | 3 | 0 |
52577 | 52577 | 2020-04-12 | York | Nebraska | 31185 | 4 | 0 |
55259 | 55259 | 2020-04-13 | York | Nebraska | 31185 | 4 | 0 |
57958 | 57958 | 2020-04-14 | York | Nebraska | 31185 | 5 | 0 |
60673 | 60673 | 2020-04-15 | York | Nebraska | 31185 | 5 | 0 |
63398 | 63398 | 2020-04-16 | York | Nebraska | 31185 | 6 | 0 |
66140 | 66140 | 2020-04-17 | York | Nebraska | 31185 | 6 | 0 |
68895 | 68895 | 2020-04-18 | York | Nebraska | 31185 | 7 | 0 |
71663 | 71663 | 2020-04-19 | York | Nebraska | 31185 | 7 | 0 |
74437 | 74437 | 2020-04-20 | York | Nebraska | 31185 | 7 | 0 |
77217 | 77217 | 2020-04-21 | York | Nebraska | 31185 | 7 | 0 |
80006 | 80006 | 2020-04-22 | York | Nebraska | 31185 | 7 | 0 |
82804 | 82804 | 2020-04-23 | York | Nebraska | 31185 | 8 | 0 |
85608 | 85608 | 2020-04-24 | York | Nebraska | 31185 | 9 | 0 |
88419 | 88419 | 2020-04-25 | York | Nebraska | 31185 | 9 | 0 |
91235 | 91235 | 2020-04-26 | York | Nebraska | 31185 | 11 | 0 |
94058 | 94058 | 2020-04-27 | York | Nebraska | 31185 | 11 | 0 |
96894 | 96894 | 2020-04-28 | York | Nebraska | 31185 | 11 | 0 |
99741 | 99741 | 2020-04-29 | York | Nebraska | 31185 | 11 | 0 |
102594 | 102594 | 2020-04-30 | York | Nebraska | 31185 | 12 | 0 |
105456 | 105456 | 2020-05-01 | York | Nebraska | 31185 | 12 | 0 |
108322 | 108322 | 2020-05-02 | York | Nebraska | 31185 | 12 | 0 |
111195 | 111195 | 2020-05-03 | York | Nebraska | 31185 | 12 | 0 |
114076 | 114076 | 2020-05-04 | York | Nebraska | 31185 | 13 | 0 |
116957 | 116957 | 2020-05-05 | York | Nebraska | 31185 | 15 | 0 |
119918 | 119918 | 2020-05-06 | York | Nebraska | 31185 | 15 | 0 |
122893 | 122893 | 2020-05-07 | York | Nebraska | 31185 | 15 | 0 |
125875 | 125875 | 2020-05-08 | York | Nebraska | 31185 | 15 | 0 |
128864 | 128864 | 2020-05-09 | York | Nebraska | 31185 | 17 | 0 |
131854 | 131854 | 2020-05-10 | York | Nebraska | 31185 | 17 | 0 |
134844 | 134844 | 2020-05-11 | York | Nebraska | 31185 | 25 | 0 |
137834 | 137834 | 2020-05-12 | York | Nebraska | 31185 | 25 | 0 |
140830 | 140830 | 2020-05-13 | York | Nebraska | 31185 | 25 | 0 |
143825 | 143825 | 2020-05-14 | York | Nebraska | 31185 | 27 | 0 |
146826 | 146826 | 2020-05-15 | York | Nebraska | 31185 | 28 | 0 |
149833 | 149833 | 2020-05-16 | York | Nebraska | 31185 | 29 | 0 |
152844 | 152844 | 2020-05-17 | York | Nebraska | 31185 | 30 | 0 |
155858 | 155858 | 2020-05-18 | York | Nebraska | 31185 | 30 | 0 |
158876 | 158876 | 2020-05-19 | York | Nebraska | 31185 | 30 | 0 |
161902 | 161902 | 2020-05-20 | York | Nebraska | 31185 | 30 | 0 |
164931 | 164931 | 2020-05-21 | York | Nebraska | 31185 | 30 | 0 |
167967 | 167967 | 2020-05-22 | York | Nebraska | 31185 | 35 | 0 |
171006 | 171006 | 2020-05-23 | York | Nebraska | 31185 | 35 | 0 |
174049 | 174049 | 2020-05-24 | York | Nebraska | 31185 | 35 | 0 |
177092 | 177092 | 2020-05-25 | York | Nebraska | 31185 | 35 | 0 |
180136 | 180136 | 2020-05-26 | York | Nebraska | 31185 | 35 | 0 |
183184 | 183184 | 2020-05-27 | York | Nebraska | 31185 | 35 | 0 |
186240 | 186240 | 2020-05-28 | York | Nebraska | 31185 | 35 | 0 |
189300 | 189300 | 2020-05-29 | York | Nebraska | 31185 | 36 | 0 |
192364 | 192364 | 2020-05-30 | York | Nebraska | 31185 | 36 | 0 |
195434 | 195434 | 2020-05-31 | York | Nebraska | 31185 | 36 | 0 |
198507 | 198507 | 2020-06-01 | York | Nebraska | 31185 | 36 | 0 |
201581 | 201581 | 2020-06-02 | York | Nebraska | 31185 | 36 | 0 |
204658 | 204658 | 2020-06-03 | York | Nebraska | 31185 | 36 | 0 |
207739 | 207739 | 2020-06-04 | York | Nebraska | 31185 | 36 | 0 |
210821 | 210821 | 2020-06-05 | York | Nebraska | 31185 | 37 | 0 |
213905 | 213905 | 2020-06-06 | York | Nebraska | 31185 | 36 | 0 |
216994 | 216994 | 2020-06-07 | York | Nebraska | 31185 | 37 | 0 |
220086 | 220086 | 2020-06-08 | York | Nebraska | 31185 | 37 | 0 |
223181 | 223181 | 2020-06-09 | York | Nebraska | 31185 | 37 | 0 |
226281 | 226281 | 2020-06-10 | York | Nebraska | 31185 | 37 | 0 |
229385 | 229385 | 2020-06-11 | York | Nebraska | 31185 | 37 | 0 |
232490 | 232490 | 2020-06-12 | York | Nebraska | 31185 | 36 | 0 |
235595 | 235595 | 2020-06-13 | York | Nebraska | 31185 | 36 | 0 |
238702 | 238702 | 2020-06-14 | York | Nebraska | 31185 | 37 | 0 |
241812 | 241812 | 2020-06-15 | York | Nebraska | 31185 | 37 | 0 |
244924 | 244924 | 2020-06-16 | York | Nebraska | 31185 | 37 | 0 |
248037 | 248037 | 2020-06-17 | York | Nebraska | 31185 | 37 | 0 |
251152 | 251152 | 2020-06-18 | York | Nebraska | 31185 | 37 | 0 |
254267 | 254267 | 2020-06-19 | York | Nebraska | 31185 | 39 | 0 |
257390 | 257390 | 2020-06-20 | York | Nebraska | 31185 | 40 | 0 |
260516 | 260516 | 2020-06-21 | York | Nebraska | 31185 | 40 | 0 |
263645 | 263645 | 2020-06-22 | York | Nebraska | 31185 | 40 | 0 |
266772 | 266772 | 2020-06-23 | York | Nebraska | 31185 | 41 | 0 |
269907 | 269907 | 2020-06-24 | York | Nebraska | 31185 | 41 | 0 |
273046 | 273046 | 2020-06-25 | York | Nebraska | 31185 | 41 | 0 |
276190 | 276190 | 2020-06-26 | York | Nebraska | 31185 | 41 | 0 |
279338 | 279338 | 2020-06-27 | York | Nebraska | 31185 | 41 | 0 |
282485 | 282485 | 2020-06-28 | York | Nebraska | 31185 | 41 | 0 |
285630 | 285630 | 2020-06-29 | York | Nebraska | 31185 | 41 | 0 |
288780 | 288780 | 2020-06-30 | York | Nebraska | 31185 | 41 | 0 |
291932 | 291932 | 2020-07-01 | York | Nebraska | 31185 | 42 | 0 |
295087 | 295087 | 2020-07-02 | York | Nebraska | 31185 | 44 | 0 |
298247 | 298247 | 2020-07-03 | York | Nebraska | 31185 | 45 | 0 |
301410 | 301410 | 2020-07-04 | York | Nebraska | 31185 | 45 | 0 |
304573 | 304573 | 2020-07-05 | York | Nebraska | 31185 | 45 | 0 |
307740 | 307740 | 2020-07-06 | York | Nebraska | 31185 | 45 | 0 |
310908 | 310908 | 2020-07-07 | York | Nebraska | 31185 | 47 | 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);