ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 31081 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536125 | 536125 | 2020-09-15 | Hamilton | Nebraska | 31081 | 113 | 13 |
532890 | 532890 | 2020-09-14 | Hamilton | Nebraska | 31081 | 113 | 13 |
529654 | 529654 | 2020-09-13 | Hamilton | Nebraska | 31081 | 113 | 13 |
526418 | 526418 | 2020-09-12 | Hamilton | Nebraska | 31081 | 113 | 13 |
523182 | 523182 | 2020-09-11 | Hamilton | Nebraska | 31081 | 113 | 13 |
519945 | 519945 | 2020-09-10 | Hamilton | Nebraska | 31081 | 112 | 13 |
516710 | 516710 | 2020-09-09 | Hamilton | Nebraska | 31081 | 112 | 13 |
513476 | 513476 | 2020-09-08 | Hamilton | Nebraska | 31081 | 111 | 13 |
510244 | 510244 | 2020-09-07 | Hamilton | Nebraska | 31081 | 111 | 13 |
507011 | 507011 | 2020-09-06 | Hamilton | Nebraska | 31081 | 111 | 13 |
503778 | 503778 | 2020-09-05 | Hamilton | Nebraska | 31081 | 111 | 13 |
500544 | 500544 | 2020-09-04 | Hamilton | Nebraska | 31081 | 111 | 13 |
497310 | 497310 | 2020-09-03 | Hamilton | Nebraska | 31081 | 109 | 13 |
494077 | 494077 | 2020-09-02 | Hamilton | Nebraska | 31081 | 109 | 13 |
490843 | 490843 | 2020-09-01 | Hamilton | Nebraska | 31081 | 109 | 13 |
487610 | 487610 | 2020-08-31 | Hamilton | Nebraska | 31081 | 109 | 13 |
484376 | 484376 | 2020-08-30 | Hamilton | Nebraska | 31081 | 106 | 13 |
481141 | 481141 | 2020-08-29 | Hamilton | Nebraska | 31081 | 106 | 13 |
477909 | 477909 | 2020-08-28 | Hamilton | Nebraska | 31081 | 106 | 13 |
474676 | 474676 | 2020-08-27 | Hamilton | Nebraska | 31081 | 106 | 13 |
471444 | 471444 | 2020-08-26 | Hamilton | Nebraska | 31081 | 106 | 13 |
468214 | 468214 | 2020-08-25 | Hamilton | Nebraska | 31081 | 106 | 13 |
464985 | 464985 | 2020-08-24 | Hamilton | Nebraska | 31081 | 106 | 13 |
461754 | 461754 | 2020-08-23 | Hamilton | Nebraska | 31081 | 106 | 13 |
458527 | 458527 | 2020-08-22 | Hamilton | Nebraska | 31081 | 106 | 13 |
455299 | 455299 | 2020-08-21 | Hamilton | Nebraska | 31081 | 106 | 13 |
452071 | 452071 | 2020-08-20 | Hamilton | Nebraska | 31081 | 105 | 13 |
448843 | 448843 | 2020-08-19 | Hamilton | Nebraska | 31081 | 105 | 13 |
445617 | 445617 | 2020-08-18 | Hamilton | Nebraska | 31081 | 106 | 13 |
442391 | 442391 | 2020-08-17 | Hamilton | Nebraska | 31081 | 105 | 13 |
439164 | 439164 | 2020-08-16 | Hamilton | Nebraska | 31081 | 103 | 13 |
435939 | 435939 | 2020-08-15 | Hamilton | Nebraska | 31081 | 103 | 13 |
432713 | 432713 | 2020-08-14 | Hamilton | Nebraska | 31081 | 103 | 13 |
429486 | 429486 | 2020-08-13 | Hamilton | Nebraska | 31081 | 101 | 13 |
426261 | 426261 | 2020-08-12 | Hamilton | Nebraska | 31081 | 101 | 13 |
423039 | 423039 | 2020-08-11 | Hamilton | Nebraska | 31081 | 101 | 13 |
419816 | 419816 | 2020-08-10 | Hamilton | Nebraska | 31081 | 101 | 13 |
416595 | 416595 | 2020-08-09 | Hamilton | Nebraska | 31081 | 100 | 13 |
413375 | 413375 | 2020-08-08 | Hamilton | Nebraska | 31081 | 100 | 13 |
410155 | 410155 | 2020-08-07 | Hamilton | Nebraska | 31081 | 100 | 13 |
406935 | 406935 | 2020-08-06 | Hamilton | Nebraska | 31081 | 99 | 13 |
403716 | 403716 | 2020-08-05 | Hamilton | Nebraska | 31081 | 99 | 13 |
400498 | 400498 | 2020-08-04 | Hamilton | Nebraska | 31081 | 98 | 13 |
397283 | 397283 | 2020-08-03 | Hamilton | Nebraska | 31081 | 98 | 13 |
394067 | 394067 | 2020-08-02 | Hamilton | Nebraska | 31081 | 96 | 13 |
390850 | 390850 | 2020-08-01 | Hamilton | Nebraska | 31081 | 96 | 13 |
387633 | 387633 | 2020-07-31 | Hamilton | Nebraska | 31081 | 96 | 13 |
384415 | 384415 | 2020-07-30 | Hamilton | Nebraska | 31081 | 92 | 13 |
381199 | 381199 | 2020-07-29 | Hamilton | Nebraska | 31081 | 92 | 13 |
377981 | 377981 | 2020-07-28 | Hamilton | Nebraska | 31081 | 89 | 13 |
374765 | 374765 | 2020-07-27 | Hamilton | Nebraska | 31081 | 88 | 13 |
371553 | 371553 | 2020-07-26 | Hamilton | Nebraska | 31081 | 87 | 13 |
368342 | 368342 | 2020-07-25 | Hamilton | Nebraska | 31081 | 87 | 13 |
365133 | 365133 | 2020-07-24 | Hamilton | Nebraska | 31081 | 85 | 13 |
361927 | 361927 | 2020-07-23 | Hamilton | Nebraska | 31081 | 84 | 13 |
358721 | 358721 | 2020-07-22 | Hamilton | Nebraska | 31081 | 82 | 13 |
355517 | 355517 | 2020-07-21 | Hamilton | Nebraska | 31081 | 82 | 13 |
352314 | 352314 | 2020-07-20 | Hamilton | Nebraska | 31081 | 82 | 13 |
349113 | 349113 | 2020-07-19 | Hamilton | Nebraska | 31081 | 78 | 13 |
345912 | 345912 | 2020-07-18 | Hamilton | Nebraska | 31081 | 77 | 13 |
342712 | 342712 | 2020-07-17 | Hamilton | Nebraska | 31081 | 77 | 13 |
339515 | 339515 | 2020-07-16 | Hamilton | Nebraska | 31081 | 75 | 13 |
336318 | 336318 | 2020-07-15 | Hamilton | Nebraska | 31081 | 75 | 13 |
333124 | 333124 | 2020-07-14 | Hamilton | Nebraska | 31081 | 73 | 13 |
329934 | 329934 | 2020-07-13 | Hamilton | Nebraska | 31081 | 73 | 13 |
326747 | 326747 | 2020-07-12 | Hamilton | Nebraska | 31081 | 73 | 13 |
323563 | 323563 | 2020-07-11 | Hamilton | Nebraska | 31081 | 73 | 13 |
320384 | 320384 | 2020-07-10 | Hamilton | Nebraska | 31081 | 73 | 13 |
317209 | 317209 | 2020-07-09 | Hamilton | Nebraska | 31081 | 70 | 13 |
314035 | 314035 | 2020-07-08 | Hamilton | Nebraska | 31081 | 70 | 13 |
310864 | 310864 | 2020-07-07 | Hamilton | Nebraska | 31081 | 67 | 13 |
307696 | 307696 | 2020-07-06 | Hamilton | Nebraska | 31081 | 67 | 13 |
304529 | 304529 | 2020-07-05 | Hamilton | Nebraska | 31081 | 67 | 13 |
301365 | 301365 | 2020-07-04 | Hamilton | Nebraska | 31081 | 67 | 13 |
298202 | 298202 | 2020-07-03 | Hamilton | Nebraska | 31081 | 67 | 13 |
295043 | 295043 | 2020-07-02 | Hamilton | Nebraska | 31081 | 67 | 13 |
291888 | 291888 | 2020-07-01 | Hamilton | Nebraska | 31081 | 67 | 13 |
288737 | 288737 | 2020-06-30 | Hamilton | Nebraska | 31081 | 64 | 13 |
285587 | 285587 | 2020-06-29 | Hamilton | Nebraska | 31081 | 64 | 13 |
282442 | 282442 | 2020-06-28 | Hamilton | Nebraska | 31081 | 64 | 13 |
279294 | 279294 | 2020-06-27 | Hamilton | Nebraska | 31081 | 64 | 13 |
276146 | 276146 | 2020-06-26 | Hamilton | Nebraska | 31081 | 64 | 13 |
273003 | 273003 | 2020-06-25 | Hamilton | Nebraska | 31081 | 64 | 13 |
269864 | 269864 | 2020-06-24 | Hamilton | Nebraska | 31081 | 64 | 13 |
266730 | 266730 | 2020-06-23 | Hamilton | Nebraska | 31081 | 62 | 13 |
263604 | 263604 | 2020-06-22 | Hamilton | Nebraska | 31081 | 62 | 13 |
260475 | 260475 | 2020-06-21 | Hamilton | Nebraska | 31081 | 62 | 13 |
257349 | 257349 | 2020-06-20 | Hamilton | Nebraska | 31081 | 62 | 13 |
254226 | 254226 | 2020-06-19 | Hamilton | Nebraska | 31081 | 62 | 13 |
251111 | 251111 | 2020-06-18 | Hamilton | Nebraska | 31081 | 61 | 13 |
247996 | 247996 | 2020-06-17 | Hamilton | Nebraska | 31081 | 61 | 13 |
244883 | 244883 | 2020-06-16 | Hamilton | Nebraska | 31081 | 61 | 13 |
241772 | 241772 | 2020-06-15 | Hamilton | Nebraska | 31081 | 61 | 13 |
238662 | 238662 | 2020-06-14 | Hamilton | Nebraska | 31081 | 61 | 13 |
235555 | 235555 | 2020-06-13 | Hamilton | Nebraska | 31081 | 61 | 13 |
232449 | 232449 | 2020-06-12 | Hamilton | Nebraska | 31081 | 61 | 13 |
229344 | 229344 | 2020-06-11 | Hamilton | Nebraska | 31081 | 61 | 13 |
226241 | 226241 | 2020-06-10 | Hamilton | Nebraska | 31081 | 61 | 13 |
223142 | 223142 | 2020-06-09 | Hamilton | Nebraska | 31081 | 61 | 13 |
220046 | 220046 | 2020-06-08 | Hamilton | Nebraska | 31081 | 61 | 13 |
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);