ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 31119 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
597696 | 597696 | 2020-10-04 | Madison | Nebraska | 31119 | 957 | 7 |
594454 | 594454 | 2020-10-03 | Madison | Nebraska | 31119 | 904 | 7 |
591213 | 591213 | 2020-10-02 | Madison | Nebraska | 31119 | 904 | 7 |
587972 | 587972 | 2020-10-01 | Madison | Nebraska | 31119 | 904 | 7 |
584732 | 584732 | 2020-09-30 | Madison | Nebraska | 31119 | 904 | 7 |
581491 | 581491 | 2020-09-29 | Madison | Nebraska | 31119 | 860 | 7 |
578250 | 578250 | 2020-09-28 | Madison | Nebraska | 31119 | 860 | 7 |
575009 | 575009 | 2020-09-27 | Madison | Nebraska | 31119 | 860 | 7 |
571766 | 571766 | 2020-09-26 | Madison | Nebraska | 31119 | 860 | 7 |
568524 | 568524 | 2020-09-25 | Madison | Nebraska | 31119 | 860 | 7 |
565283 | 565283 | 2020-09-24 | Madison | Nebraska | 31119 | 845 | 7 |
562042 | 562042 | 2020-09-23 | Madison | Nebraska | 31119 | 836 | 7 |
558805 | 558805 | 2020-09-22 | Madison | Nebraska | 31119 | 836 | 7 |
555568 | 555568 | 2020-09-21 | Madison | Nebraska | 31119 | 788 | 7 |
552330 | 552330 | 2020-09-20 | Madison | Nebraska | 31119 | 788 | 7 |
549091 | 549091 | 2020-09-19 | Madison | Nebraska | 31119 | 788 | 7 |
545853 | 545853 | 2020-09-18 | Madison | Nebraska | 31119 | 788 | 7 |
542616 | 542616 | 2020-09-17 | Madison | Nebraska | 31119 | 788 | 7 |
539380 | 539380 | 2020-09-16 | Madison | Nebraska | 31119 | 774 | 7 |
536142 | 536142 | 2020-09-15 | Madison | Nebraska | 31119 | 753 | 7 |
532907 | 532907 | 2020-09-14 | Madison | Nebraska | 31119 | 732 | 7 |
529671 | 529671 | 2020-09-13 | Madison | Nebraska | 31119 | 732 | 7 |
526435 | 526435 | 2020-09-12 | Madison | Nebraska | 31119 | 732 | 7 |
523199 | 523199 | 2020-09-11 | Madison | Nebraska | 31119 | 732 | 7 |
519962 | 519962 | 2020-09-10 | Madison | Nebraska | 31119 | 718 | 7 |
516727 | 516727 | 2020-09-09 | Madison | Nebraska | 31119 | 702 | 7 |
513493 | 513493 | 2020-09-08 | Madison | Nebraska | 31119 | 662 | 6 |
510261 | 510261 | 2020-09-07 | Madison | Nebraska | 31119 | 662 | 6 |
507028 | 507028 | 2020-09-06 | Madison | Nebraska | 31119 | 662 | 6 |
503795 | 503795 | 2020-09-05 | Madison | Nebraska | 31119 | 662 | 6 |
500561 | 500561 | 2020-09-04 | Madison | Nebraska | 31119 | 662 | 6 |
497327 | 497327 | 2020-09-03 | Madison | Nebraska | 31119 | 662 | 6 |
494094 | 494094 | 2020-09-02 | Madison | Nebraska | 31119 | 637 | 6 |
490860 | 490860 | 2020-09-01 | Madison | Nebraska | 31119 | 637 | 6 |
487627 | 487627 | 2020-08-31 | Madison | Nebraska | 31119 | 602 | 6 |
484393 | 484393 | 2020-08-30 | Madison | Nebraska | 31119 | 588 | 6 |
481158 | 481158 | 2020-08-29 | Madison | Nebraska | 31119 | 576 | 6 |
477926 | 477926 | 2020-08-28 | Madison | Nebraska | 31119 | 576 | 6 |
474693 | 474693 | 2020-08-27 | Madison | Nebraska | 31119 | 576 | 6 |
471460 | 471460 | 2020-08-26 | Madison | Nebraska | 31119 | 576 | 6 |
468229 | 468229 | 2020-08-25 | Madison | Nebraska | 31119 | 576 | 6 |
465000 | 465000 | 2020-08-24 | Madison | Nebraska | 31119 | 576 | 6 |
461769 | 461769 | 2020-08-23 | Madison | Nebraska | 31119 | 564 | 6 |
458542 | 458542 | 2020-08-22 | Madison | Nebraska | 31119 | 564 | 6 |
455314 | 455314 | 2020-08-21 | Madison | Nebraska | 31119 | 564 | 6 |
452086 | 452086 | 2020-08-20 | Madison | Nebraska | 31119 | 541 | 6 |
448858 | 448858 | 2020-08-19 | Madison | Nebraska | 31119 | 537 | 6 |
445632 | 445632 | 2020-08-18 | Madison | Nebraska | 31119 | 523 | 6 |
442405 | 442405 | 2020-08-17 | Madison | Nebraska | 31119 | 523 | 6 |
439178 | 439178 | 2020-08-16 | Madison | Nebraska | 31119 | 514 | 6 |
435953 | 435953 | 2020-08-15 | Madison | Nebraska | 31119 | 514 | 6 |
432727 | 432727 | 2020-08-14 | Madison | Nebraska | 31119 | 511 | 6 |
429500 | 429500 | 2020-08-13 | Madison | Nebraska | 31119 | 505 | 6 |
426275 | 426275 | 2020-08-12 | Madison | Nebraska | 31119 | 495 | 6 |
423053 | 423053 | 2020-08-11 | Madison | Nebraska | 31119 | 485 | 6 |
419830 | 419830 | 2020-08-10 | Madison | Nebraska | 31119 | 485 | 6 |
416609 | 416609 | 2020-08-09 | Madison | Nebraska | 31119 | 466 | 6 |
413389 | 413389 | 2020-08-08 | Madison | Nebraska | 31119 | 466 | 6 |
410169 | 410169 | 2020-08-07 | Madison | Nebraska | 31119 | 466 | 6 |
406949 | 406949 | 2020-08-06 | Madison | Nebraska | 31119 | 458 | 6 |
403730 | 403730 | 2020-08-05 | Madison | Nebraska | 31119 | 443 | 6 |
400512 | 400512 | 2020-08-04 | Madison | Nebraska | 31119 | 435 | 6 |
397297 | 397297 | 2020-08-03 | Madison | Nebraska | 31119 | 435 | 6 |
394081 | 394081 | 2020-08-02 | Madison | Nebraska | 31119 | 428 | 6 |
390864 | 390864 | 2020-08-01 | Madison | Nebraska | 31119 | 428 | 6 |
387647 | 387647 | 2020-07-31 | Madison | Nebraska | 31119 | 428 | 6 |
384429 | 384429 | 2020-07-30 | Madison | Nebraska | 31119 | 422 | 6 |
381213 | 381213 | 2020-07-29 | Madison | Nebraska | 31119 | 413 | 6 |
377995 | 377995 | 2020-07-28 | Madison | Nebraska | 31119 | 413 | 6 |
374779 | 374779 | 2020-07-27 | Madison | Nebraska | 31119 | 413 | 6 |
371567 | 371567 | 2020-07-26 | Madison | Nebraska | 31119 | 409 | 6 |
368356 | 368356 | 2020-07-25 | Madison | Nebraska | 31119 | 409 | 6 |
365147 | 365147 | 2020-07-24 | Madison | Nebraska | 31119 | 409 | 6 |
361941 | 361941 | 2020-07-23 | Madison | Nebraska | 31119 | 404 | 5 |
358735 | 358735 | 2020-07-22 | Madison | Nebraska | 31119 | 404 | 5 |
355531 | 355531 | 2020-07-21 | Madison | Nebraska | 31119 | 403 | 5 |
352328 | 352328 | 2020-07-20 | Madison | Nebraska | 31119 | 403 | 4 |
349127 | 349127 | 2020-07-19 | Madison | Nebraska | 31119 | 400 | 4 |
345926 | 345926 | 2020-07-18 | Madison | Nebraska | 31119 | 400 | 4 |
342726 | 342726 | 2020-07-17 | Madison | Nebraska | 31119 | 400 | 4 |
339529 | 339529 | 2020-07-16 | Madison | Nebraska | 31119 | 399 | 4 |
336332 | 336332 | 2020-07-15 | Madison | Nebraska | 31119 | 399 | 4 |
333138 | 333138 | 2020-07-14 | Madison | Nebraska | 31119 | 395 | 4 |
329948 | 329948 | 2020-07-13 | Madison | Nebraska | 31119 | 395 | 4 |
326761 | 326761 | 2020-07-12 | Madison | Nebraska | 31119 | 390 | 4 |
323577 | 323577 | 2020-07-11 | Madison | Nebraska | 31119 | 390 | 4 |
320398 | 320398 | 2020-07-10 | Madison | Nebraska | 31119 | 390 | 4 |
317223 | 317223 | 2020-07-09 | Madison | Nebraska | 31119 | 390 | 4 |
314049 | 314049 | 2020-07-08 | Madison | Nebraska | 31119 | 379 | 4 |
310878 | 310878 | 2020-07-07 | Madison | Nebraska | 31119 | 378 | 4 |
307710 | 307710 | 2020-07-06 | Madison | Nebraska | 31119 | 377 | 4 |
304543 | 304543 | 2020-07-05 | Madison | Nebraska | 31119 | 373 | 4 |
301379 | 301379 | 2020-07-04 | Madison | Nebraska | 31119 | 373 | 4 |
298216 | 298216 | 2020-07-03 | Madison | Nebraska | 31119 | 373 | 4 |
295057 | 295057 | 2020-07-02 | Madison | Nebraska | 31119 | 373 | 4 |
291902 | 291902 | 2020-07-01 | Madison | Nebraska | 31119 | 373 | 4 |
288750 | 288750 | 2020-06-30 | Madison | Nebraska | 31119 | 365 | 4 |
285600 | 285600 | 2020-06-29 | Madison | Nebraska | 31119 | 365 | 4 |
282455 | 282455 | 2020-06-28 | Madison | Nebraska | 31119 | 365 | 4 |
279307 | 279307 | 2020-06-27 | Madison | Nebraska | 31119 | 365 | 4 |
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);