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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536177 | 536177 | 2020-09-15 | York | Nebraska | 31185 | 139 | 1 |
532942 | 532942 | 2020-09-14 | York | Nebraska | 31185 | 137 | 1 |
529706 | 529706 | 2020-09-13 | York | Nebraska | 31185 | 135 | 1 |
526470 | 526470 | 2020-09-12 | York | Nebraska | 31185 | 134 | 1 |
523234 | 523234 | 2020-09-11 | York | Nebraska | 31185 | 130 | 1 |
519997 | 519997 | 2020-09-10 | York | Nebraska | 31185 | 128 | 1 |
516762 | 516762 | 2020-09-09 | York | Nebraska | 31185 | 125 | 0 |
513528 | 513528 | 2020-09-08 | York | Nebraska | 31185 | 123 | 0 |
510295 | 510295 | 2020-09-07 | York | Nebraska | 31185 | 120 | 0 |
507062 | 507062 | 2020-09-06 | York | Nebraska | 31185 | 121 | 0 |
503830 | 503830 | 2020-09-05 | York | Nebraska | 31185 | 120 | 0 |
500596 | 500596 | 2020-09-04 | York | Nebraska | 31185 | 120 | 0 |
497362 | 497362 | 2020-09-03 | York | Nebraska | 31185 | 119 | 0 |
494129 | 494129 | 2020-09-02 | York | Nebraska | 31185 | 114 | 0 |
490895 | 490895 | 2020-09-01 | York | Nebraska | 31185 | 114 | 0 |
487662 | 487662 | 2020-08-31 | York | Nebraska | 31185 | 113 | 0 |
484428 | 484428 | 2020-08-30 | York | Nebraska | 31185 | 113 | 0 |
481193 | 481193 | 2020-08-29 | York | Nebraska | 31185 | 109 | 0 |
477961 | 477961 | 2020-08-28 | York | Nebraska | 31185 | 109 | 0 |
474728 | 474728 | 2020-08-27 | York | Nebraska | 31185 | 108 | 0 |
471495 | 471495 | 2020-08-26 | York | Nebraska | 31185 | 107 | 0 |
468263 | 468263 | 2020-08-25 | York | Nebraska | 31185 | 104 | 0 |
465035 | 465035 | 2020-08-24 | York | Nebraska | 31185 | 102 | 0 |
461804 | 461804 | 2020-08-23 | York | Nebraska | 31185 | 101 | 0 |
458577 | 458577 | 2020-08-22 | York | Nebraska | 31185 | 101 | 0 |
455349 | 455349 | 2020-08-21 | York | Nebraska | 31185 | 96 | 0 |
452121 | 452121 | 2020-08-20 | York | Nebraska | 31185 | 97 | 0 |
448893 | 448893 | 2020-08-19 | York | Nebraska | 31185 | 97 | 0 |
445666 | 445666 | 2020-08-18 | York | Nebraska | 31185 | 89 | 0 |
442440 | 442440 | 2020-08-17 | York | Nebraska | 31185 | 93 | 0 |
439213 | 439213 | 2020-08-16 | York | Nebraska | 31185 | 94 | 0 |
435988 | 435988 | 2020-08-15 | York | Nebraska | 31185 | 93 | 0 |
432762 | 432762 | 2020-08-14 | York | Nebraska | 31185 | 90 | 0 |
429535 | 429535 | 2020-08-13 | York | Nebraska | 31185 | 89 | 0 |
426310 | 426310 | 2020-08-12 | York | Nebraska | 31185 | 87 | 0 |
423088 | 423088 | 2020-08-11 | York | Nebraska | 31185 | 84 | 0 |
419865 | 419865 | 2020-08-10 | York | Nebraska | 31185 | 80 | 0 |
416644 | 416644 | 2020-08-09 | York | Nebraska | 31185 | 79 | 0 |
413423 | 413423 | 2020-08-08 | York | Nebraska | 31185 | 78 | 0 |
410203 | 410203 | 2020-08-07 | York | Nebraska | 31185 | 78 | 0 |
406983 | 406983 | 2020-08-06 | York | Nebraska | 31185 | 77 | 0 |
403764 | 403764 | 2020-08-05 | York | Nebraska | 31185 | 77 | 0 |
400546 | 400546 | 2020-08-04 | York | Nebraska | 31185 | 73 | 0 |
397331 | 397331 | 2020-08-03 | York | Nebraska | 31185 | 72 | 0 |
394115 | 394115 | 2020-08-02 | York | Nebraska | 31185 | 74 | 0 |
390898 | 390898 | 2020-08-01 | York | Nebraska | 31185 | 73 | 0 |
387681 | 387681 | 2020-07-31 | York | Nebraska | 31185 | 69 | 0 |
384464 | 384464 | 2020-07-30 | York | Nebraska | 31185 | 67 | 0 |
381247 | 381247 | 2020-07-29 | York | Nebraska | 31185 | 66 | 0 |
378029 | 378029 | 2020-07-28 | York | Nebraska | 31185 | 63 | 0 |
374814 | 374814 | 2020-07-27 | York | Nebraska | 31185 | 63 | 0 |
371602 | 371602 | 2020-07-26 | York | Nebraska | 31185 | 62 | 0 |
368390 | 368390 | 2020-07-25 | York | Nebraska | 31185 | 62 | 0 |
365181 | 365181 | 2020-07-24 | York | Nebraska | 31185 | 62 | 0 |
361975 | 361975 | 2020-07-23 | York | Nebraska | 31185 | 61 | 0 |
358769 | 358769 | 2020-07-22 | York | Nebraska | 31185 | 61 | 0 |
355565 | 355565 | 2020-07-21 | York | Nebraska | 31185 | 60 | 0 |
352362 | 352362 | 2020-07-20 | York | Nebraska | 31185 | 59 | 0 |
349159 | 349159 | 2020-07-19 | York | Nebraska | 31185 | 59 | 0 |
345958 | 345958 | 2020-07-18 | York | Nebraska | 31185 | 55 | 0 |
342759 | 342759 | 2020-07-17 | York | Nebraska | 31185 | 56 | 0 |
339561 | 339561 | 2020-07-16 | York | Nebraska | 31185 | 54 | 0 |
336365 | 336365 | 2020-07-15 | York | Nebraska | 31185 | 54 | 0 |
333171 | 333171 | 2020-07-14 | York | Nebraska | 31185 | 52 | 0 |
329980 | 329980 | 2020-07-13 | York | Nebraska | 31185 | 52 | 0 |
326793 | 326793 | 2020-07-12 | York | Nebraska | 31185 | 52 | 0 |
323609 | 323609 | 2020-07-11 | York | Nebraska | 31185 | 51 | 0 |
320429 | 320429 | 2020-07-10 | York | Nebraska | 31185 | 49 | 0 |
317253 | 317253 | 2020-07-09 | York | Nebraska | 31185 | 50 | 0 |
314079 | 314079 | 2020-07-08 | York | Nebraska | 31185 | 49 | 0 |
310908 | 310908 | 2020-07-07 | York | Nebraska | 31185 | 47 | 0 |
307740 | 307740 | 2020-07-06 | York | Nebraska | 31185 | 45 | 0 |
304573 | 304573 | 2020-07-05 | York | Nebraska | 31185 | 45 | 0 |
301410 | 301410 | 2020-07-04 | York | Nebraska | 31185 | 45 | 0 |
298247 | 298247 | 2020-07-03 | York | Nebraska | 31185 | 45 | 0 |
295087 | 295087 | 2020-07-02 | York | Nebraska | 31185 | 44 | 0 |
291932 | 291932 | 2020-07-01 | York | Nebraska | 31185 | 42 | 0 |
288780 | 288780 | 2020-06-30 | York | Nebraska | 31185 | 41 | 0 |
285630 | 285630 | 2020-06-29 | York | Nebraska | 31185 | 41 | 0 |
282485 | 282485 | 2020-06-28 | York | Nebraska | 31185 | 41 | 0 |
279338 | 279338 | 2020-06-27 | York | Nebraska | 31185 | 41 | 0 |
276190 | 276190 | 2020-06-26 | York | Nebraska | 31185 | 41 | 0 |
273046 | 273046 | 2020-06-25 | York | Nebraska | 31185 | 41 | 0 |
269907 | 269907 | 2020-06-24 | York | Nebraska | 31185 | 41 | 0 |
266772 | 266772 | 2020-06-23 | York | Nebraska | 31185 | 41 | 0 |
263645 | 263645 | 2020-06-22 | York | Nebraska | 31185 | 40 | 0 |
260516 | 260516 | 2020-06-21 | York | Nebraska | 31185 | 40 | 0 |
257390 | 257390 | 2020-06-20 | York | Nebraska | 31185 | 40 | 0 |
254267 | 254267 | 2020-06-19 | York | Nebraska | 31185 | 39 | 0 |
251152 | 251152 | 2020-06-18 | York | Nebraska | 31185 | 37 | 0 |
248037 | 248037 | 2020-06-17 | York | Nebraska | 31185 | 37 | 0 |
244924 | 244924 | 2020-06-16 | York | Nebraska | 31185 | 37 | 0 |
241812 | 241812 | 2020-06-15 | York | Nebraska | 31185 | 37 | 0 |
238702 | 238702 | 2020-06-14 | York | Nebraska | 31185 | 37 | 0 |
235595 | 235595 | 2020-06-13 | York | Nebraska | 31185 | 36 | 0 |
232490 | 232490 | 2020-06-12 | York | Nebraska | 31185 | 36 | 0 |
229385 | 229385 | 2020-06-11 | York | Nebraska | 31185 | 37 | 0 |
226281 | 226281 | 2020-06-10 | York | Nebraska | 31185 | 37 | 0 |
223181 | 223181 | 2020-06-09 | York | Nebraska | 31185 | 37 | 0 |
220086 | 220086 | 2020-06-08 | York | Nebraska | 31185 | 37 | 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);