ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Jefferson" and fips = 31095 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
374771 | 374771 | 2020-07-27 | Jefferson | Nebraska | 31095 | 12 | 0 |
371559 | 371559 | 2020-07-26 | Jefferson | Nebraska | 31095 | 13 | 0 |
368348 | 368348 | 2020-07-25 | Jefferson | Nebraska | 31095 | 13 | 0 |
365139 | 365139 | 2020-07-24 | Jefferson | Nebraska | 31095 | 13 | 0 |
361933 | 361933 | 2020-07-23 | Jefferson | Nebraska | 31095 | 13 | 0 |
358727 | 358727 | 2020-07-22 | Jefferson | Nebraska | 31095 | 12 | 0 |
355523 | 355523 | 2020-07-21 | Jefferson | Nebraska | 31095 | 12 | 0 |
352320 | 352320 | 2020-07-20 | Jefferson | Nebraska | 31095 | 12 | 0 |
349119 | 349119 | 2020-07-19 | Jefferson | Nebraska | 31095 | 12 | 0 |
345918 | 345918 | 2020-07-18 | Jefferson | Nebraska | 31095 | 12 | 0 |
342718 | 342718 | 2020-07-17 | Jefferson | Nebraska | 31095 | 12 | 0 |
339521 | 339521 | 2020-07-16 | Jefferson | Nebraska | 31095 | 11 | 0 |
336324 | 336324 | 2020-07-15 | Jefferson | Nebraska | 31095 | 11 | 0 |
333130 | 333130 | 2020-07-14 | Jefferson | Nebraska | 31095 | 11 | 0 |
329940 | 329940 | 2020-07-13 | Jefferson | Nebraska | 31095 | 11 | 0 |
326753 | 326753 | 2020-07-12 | Jefferson | Nebraska | 31095 | 11 | 0 |
323569 | 323569 | 2020-07-11 | Jefferson | Nebraska | 31095 | 11 | 0 |
320390 | 320390 | 2020-07-10 | Jefferson | Nebraska | 31095 | 10 | 0 |
317215 | 317215 | 2020-07-09 | Jefferson | Nebraska | 31095 | 10 | 0 |
314041 | 314041 | 2020-07-08 | Jefferson | Nebraska | 31095 | 10 | 0 |
310870 | 310870 | 2020-07-07 | Jefferson | Nebraska | 31095 | 10 | 0 |
307702 | 307702 | 2020-07-06 | Jefferson | Nebraska | 31095 | 10 | 0 |
304535 | 304535 | 2020-07-05 | Jefferson | Nebraska | 31095 | 10 | 0 |
301371 | 301371 | 2020-07-04 | Jefferson | Nebraska | 31095 | 10 | 0 |
298208 | 298208 | 2020-07-03 | Jefferson | Nebraska | 31095 | 10 | 0 |
295049 | 295049 | 2020-07-02 | Jefferson | Nebraska | 31095 | 10 | 0 |
291894 | 291894 | 2020-07-01 | Jefferson | Nebraska | 31095 | 10 | 0 |
288742 | 288742 | 2020-06-30 | Jefferson | Nebraska | 31095 | 9 | 0 |
285592 | 285592 | 2020-06-29 | Jefferson | Nebraska | 31095 | 9 | 0 |
282447 | 282447 | 2020-06-28 | Jefferson | Nebraska | 31095 | 9 | 0 |
279299 | 279299 | 2020-06-27 | Jefferson | Nebraska | 31095 | 9 | 0 |
276151 | 276151 | 2020-06-26 | Jefferson | Nebraska | 31095 | 9 | 0 |
273008 | 273008 | 2020-06-25 | Jefferson | Nebraska | 31095 | 9 | 0 |
269869 | 269869 | 2020-06-24 | Jefferson | Nebraska | 31095 | 9 | 0 |
266735 | 266735 | 2020-06-23 | Jefferson | Nebraska | 31095 | 9 | 0 |
263608 | 263608 | 2020-06-22 | Jefferson | Nebraska | 31095 | 9 | 0 |
260479 | 260479 | 2020-06-21 | Jefferson | Nebraska | 31095 | 9 | 0 |
257353 | 257353 | 2020-06-20 | Jefferson | Nebraska | 31095 | 9 | 0 |
254230 | 254230 | 2020-06-19 | Jefferson | Nebraska | 31095 | 9 | 0 |
251115 | 251115 | 2020-06-18 | Jefferson | Nebraska | 31095 | 9 | 0 |
248000 | 248000 | 2020-06-17 | Jefferson | Nebraska | 31095 | 9 | 0 |
244887 | 244887 | 2020-06-16 | Jefferson | Nebraska | 31095 | 9 | 0 |
241776 | 241776 | 2020-06-15 | Jefferson | Nebraska | 31095 | 9 | 0 |
238666 | 238666 | 2020-06-14 | Jefferson | Nebraska | 31095 | 9 | 0 |
235559 | 235559 | 2020-06-13 | Jefferson | Nebraska | 31095 | 9 | 0 |
232453 | 232453 | 2020-06-12 | Jefferson | Nebraska | 31095 | 9 | 0 |
229348 | 229348 | 2020-06-11 | Jefferson | Nebraska | 31095 | 9 | 0 |
226245 | 226245 | 2020-06-10 | Jefferson | Nebraska | 31095 | 9 | 0 |
223146 | 223146 | 2020-06-09 | Jefferson | Nebraska | 31095 | 9 | 0 |
220050 | 220050 | 2020-06-08 | Jefferson | Nebraska | 31095 | 8 | 0 |
216958 | 216958 | 2020-06-07 | Jefferson | Nebraska | 31095 | 8 | 0 |
213869 | 213869 | 2020-06-06 | Jefferson | Nebraska | 31095 | 7 | 0 |
210785 | 210785 | 2020-06-05 | Jefferson | Nebraska | 31095 | 7 | 0 |
207703 | 207703 | 2020-06-04 | Jefferson | Nebraska | 31095 | 7 | 0 |
204622 | 204622 | 2020-06-03 | Jefferson | Nebraska | 31095 | 7 | 0 |
201545 | 201545 | 2020-06-02 | Jefferson | Nebraska | 31095 | 7 | 0 |
198471 | 198471 | 2020-06-01 | Jefferson | Nebraska | 31095 | 6 | 0 |
195398 | 195398 | 2020-05-31 | Jefferson | Nebraska | 31095 | 6 | 0 |
192328 | 192328 | 2020-05-30 | Jefferson | Nebraska | 31095 | 6 | 0 |
189264 | 189264 | 2020-05-29 | Jefferson | Nebraska | 31095 | 6 | 0 |
186205 | 186205 | 2020-05-28 | Jefferson | Nebraska | 31095 | 6 | 0 |
183149 | 183149 | 2020-05-27 | Jefferson | Nebraska | 31095 | 6 | 0 |
180101 | 180101 | 2020-05-26 | Jefferson | Nebraska | 31095 | 6 | 0 |
177057 | 177057 | 2020-05-25 | Jefferson | Nebraska | 31095 | 6 | 0 |
174014 | 174014 | 2020-05-24 | Jefferson | Nebraska | 31095 | 6 | 0 |
170971 | 170971 | 2020-05-23 | Jefferson | Nebraska | 31095 | 6 | 0 |
167932 | 167932 | 2020-05-22 | Jefferson | Nebraska | 31095 | 6 | 0 |
164896 | 164896 | 2020-05-21 | Jefferson | Nebraska | 31095 | 6 | 0 |
161867 | 161867 | 2020-05-20 | Jefferson | Nebraska | 31095 | 6 | 0 |
158841 | 158841 | 2020-05-19 | Jefferson | Nebraska | 31095 | 6 | 0 |
155823 | 155823 | 2020-05-18 | Jefferson | Nebraska | 31095 | 6 | 0 |
152809 | 152809 | 2020-05-17 | Jefferson | Nebraska | 31095 | 6 | 0 |
149798 | 149798 | 2020-05-16 | Jefferson | Nebraska | 31095 | 6 | 0 |
146792 | 146792 | 2020-05-15 | Jefferson | Nebraska | 31095 | 6 | 0 |
143791 | 143791 | 2020-05-14 | Jefferson | Nebraska | 31095 | 6 | 0 |
140796 | 140796 | 2020-05-13 | Jefferson | Nebraska | 31095 | 6 | 0 |
137802 | 137802 | 2020-05-12 | Jefferson | Nebraska | 31095 | 5 | 0 |
134812 | 134812 | 2020-05-11 | Jefferson | Nebraska | 31095 | 5 | 0 |
131821 | 131821 | 2020-05-10 | Jefferson | Nebraska | 31095 | 4 | 0 |
128831 | 128831 | 2020-05-09 | Jefferson | Nebraska | 31095 | 4 | 0 |
125842 | 125842 | 2020-05-08 | Jefferson | Nebraska | 31095 | 4 | 0 |
122860 | 122860 | 2020-05-07 | Jefferson | Nebraska | 31095 | 4 | 0 |
119886 | 119886 | 2020-05-06 | Jefferson | Nebraska | 31095 | 4 | 0 |
116926 | 116926 | 2020-05-05 | Jefferson | Nebraska | 31095 | 4 | 0 |
114044 | 114044 | 2020-05-04 | Jefferson | Nebraska | 31095 | 4 | 0 |
111164 | 111164 | 2020-05-03 | Jefferson | Nebraska | 31095 | 4 | 0 |
108291 | 108291 | 2020-05-02 | Jefferson | Nebraska | 31095 | 4 | 0 |
105425 | 105425 | 2020-05-01 | Jefferson | Nebraska | 31095 | 4 | 0 |
102564 | 102564 | 2020-04-30 | Jefferson | Nebraska | 31095 | 4 | 0 |
99711 | 99711 | 2020-04-29 | Jefferson | Nebraska | 31095 | 3 | 0 |
96864 | 96864 | 2020-04-28 | Jefferson | Nebraska | 31095 | 3 | 0 |
94028 | 94028 | 2020-04-27 | Jefferson | Nebraska | 31095 | 2 | 0 |
91206 | 91206 | 2020-04-26 | Jefferson | Nebraska | 31095 | 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);