ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2021-03-20 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 93
- 31001 1
- 31003 1
- 31005 1
- 31007 1
- 31009 1
- 31011 1
- 31013 1
- 31015 1
- 31017 1
- 31019 1
- 31021 1
- 31023 1
- 31025 1
- 31027 1
- 31029 1
- 31031 1
- 31033 1
- 31035 1
- 31037 1
- 31039 1
- 31041 1
- 31043 1
- 31045 1
- 31047 1
- 31049 1
- 31051 1
- 31053 1
- 31055 1
- 31057 1
- 31059 1
- 31061 1
- 31063 1
- 31065 1
- 31067 1
- 31069 1
- 31071 1
- 31073 1
- 31075 1
- 31077 1
- 31079 1
- 31081 1
- 31083 1
- 31085 1
- 31087 1
- 31089 1
- 31091 1
- 31093 1
- 31095 1
- 31097 1
- 31099 1
- 31101 1
- 31103 1
- 31105 1
- 31107 1
- 31109 1
- 31111 1
- 31113 1
- 31115 1
- 31117 1
- 31119 1
- 31121 1
- 31123 1
- 31125 1
- 31127 1
- 31129 1
- 31131 1
- 31133 1
- 31135 1
- 31137 1
- 31139 1
- 31141 1
- 31143 1
- 31145 1
- 31147 1
- 31149 1
- 31151 1
- 31153 1
- 31155 1
- 31157 1
- 31159 1
- 31161 1
- 31163 1
- 31165 1
- 31167 1
- 31169 1
- 31171 1
- 31173 1
- 31175 1
- 31177 1
- 31179 1
- 31181 1
- 31183 1
- 31185 1
county 93
- Adams 1
- Antelope 1
- Arthur 1
- Banner 1
- Blaine 1
- Boone 1
- Box Butte 1
- Boyd 1
- Brown 1
- Buffalo 1
- Burt 1
- Butler 1
- Cass 1
- Cedar 1
- Chase 1
- Cherry 1
- Cheyenne 1
- Clay 1
- Colfax 1
- Cuming 1
- Custer 1
- Dakota 1
- Dawes 1
- Dawson 1
- Deuel 1
- Dixon 1
- Dodge 1
- Douglas 1
- Dundy 1
- Fillmore 1
- Franklin 1
- Frontier 1
- Furnas 1
- Gage 1
- Garden 1
- Garfield 1
- Gosper 1
- Grant 1
- Greeley 1
- Hall 1
- Hamilton 1
- Harlan 1
- Hayes 1
- Hitchcock 1
- Holt 1
- Hooker 1
- Howard 1
- Jefferson 1
- Johnson 1
- Kearney 1
- Keith 1
- Keya Paha 1
- Kimball 1
- Knox 1
- Lancaster 1
- Lincoln 1
- Logan 1
- Loup 1
- Madison 1
- McPherson 1
- Merrick 1
- Morrill 1
- Nance 1
- Nemaha 1
- Nuckolls 1
- Otoe 1
- Pawnee 1
- Perkins 1
- Phelps 1
- Pierce 1
- Platte 1
- Polk 1
- Red Willow 1
- Richardson 1
- Rock 1
- Saline 1
- Sarpy 1
- Saunders 1
- Scotts Bluff 1
- Seward 1
- Sheridan 1
- Sherman 1
- Sioux 1
- Stanton 1
- Thayer 1
- Thomas 1
- Thurston 1
- Valley 1
- Washington 1
- Wayne 1
- Webster 1
- Wheeler 1
- York 1
state 1
- Nebraska · 93 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1139573 | 1139573 | 2021-03-20 | Adams | Nebraska | 31001 | 2775 | 38 |
1139574 | 1139574 | 2021-03-20 | Antelope | Nebraska | 31003 | 485 | 6 |
1139575 | 1139575 | 2021-03-20 | Arthur | Nebraska | 31005 | 22 | 1 |
1139576 | 1139576 | 2021-03-20 | Banner | Nebraska | 31007 | 35 | 0 |
1139577 | 1139577 | 2021-03-20 | Blaine | Nebraska | 31009 | 20 | 0 |
1139578 | 1139578 | 2021-03-20 | Boone | Nebraska | 31011 | 542 | 5 |
1139579 | 1139579 | 2021-03-20 | Box Butte | Nebraska | 31013 | 922 | 8 |
1139580 | 1139580 | 2021-03-20 | Boyd | Nebraska | 31015 | 173 | 3 |
1139581 | 1139581 | 2021-03-20 | Brown | Nebraska | 31017 | 216 | 2 |
1139582 | 1139582 | 2021-03-20 | Buffalo | Nebraska | 31019 | 5223 | 56 |
1139583 | 1139583 | 2021-03-20 | Burt | Nebraska | 31021 | 645 | 11 |
1139584 | 1139584 | 2021-03-20 | Butler | Nebraska | 31023 | 840 | 12 |
1139585 | 1139585 | 2021-03-20 | Cass | Nebraska | 31025 | 2396 | 15 |
1139586 | 1139586 | 2021-03-20 | Cedar | Nebraska | 31027 | 749 | 12 |
1139587 | 1139587 | 2021-03-20 | Chase | Nebraska | 31029 | 451 | 3 |
1139588 | 1139588 | 2021-03-20 | Cherry | Nebraska | 31031 | 271 | 6 |
1139589 | 1139589 | 2021-03-20 | Cheyenne | Nebraska | 31033 | 910 | 18 |
1139590 | 1139590 | 2021-03-20 | Clay | Nebraska | 31035 | 672 | 11 |
1139591 | 1139591 | 2021-03-20 | Colfax | Nebraska | 31037 | 1555 | 20 |
1139592 | 1139592 | 2021-03-20 | Cuming | Nebraska | 31039 | 1003 | 11 |
1139593 | 1139593 | 2021-03-20 | Custer | Nebraska | 31041 | 840 | 18 |
1139594 | 1139594 | 2021-03-20 | Dakota | Nebraska | 31043 | 3951 | 67 |
1139595 | 1139595 | 2021-03-20 | Dawes | Nebraska | 31045 | 721 | 18 |
1139596 | 1139596 | 2021-03-20 | Dawson | Nebraska | 31047 | 2823 | 31 |
1139597 | 1139597 | 2021-03-20 | Deuel | Nebraska | 31049 | 100 | 2 |
1139598 | 1139598 | 2021-03-20 | Dixon | Nebraska | 31051 | 582 | 8 |
1139599 | 1139599 | 2021-03-20 | Dodge | Nebraska | 31053 | 4732 | 56 |
1139600 | 1139600 | 2021-03-20 | Douglas | Nebraska | 31055 | 65383 | 679 |
1139601 | 1139601 | 2021-03-20 | Dundy | Nebraska | 31057 | 178 | 4 |
1139602 | 1139602 | 2021-03-20 | Fillmore | Nebraska | 31059 | 474 | 10 |
1139603 | 1139603 | 2021-03-20 | Franklin | Nebraska | 31061 | 234 | 3 |
1139604 | 1139604 | 2021-03-20 | Frontier | Nebraska | 31063 | 189 | 1 |
1139605 | 1139605 | 2021-03-20 | Furnas | Nebraska | 31065 | 496 | 4 |
1139606 | 1139606 | 2021-03-20 | Gage | Nebraska | 31067 | 2123 | 19 |
1139607 | 1139607 | 2021-03-20 | Garden | Nebraska | 31069 | 111 | 1 |
1139608 | 1139608 | 2021-03-20 | Garfield | Nebraska | 31071 | 145 | 3 |
1139609 | 1139609 | 2021-03-20 | Gosper | Nebraska | 31073 | 180 | 4 |
1139610 | 1139610 | 2021-03-20 | Grant | Nebraska | 31075 | 38 | 4 |
1139611 | 1139611 | 2021-03-20 | Greeley | Nebraska | 31077 | 210 | 2 |
1139612 | 1139612 | 2021-03-20 | Hall | Nebraska | 31079 | 7498 | 112 |
1139613 | 1139613 | 2021-03-20 | Hamilton | Nebraska | 31081 | 906 | 17 |
1139614 | 1139614 | 2021-03-20 | Harlan | Nebraska | 31083 | 212 | 0 |
1139615 | 1139615 | 2021-03-20 | Hayes | Nebraska | 31085 | 58 | 0 |
1139616 | 1139616 | 2021-03-20 | Hitchcock | Nebraska | 31087 | 238 | 4 |
1139617 | 1139617 | 2021-03-20 | Holt | Nebraska | 31089 | 794 | 16 |
1139618 | 1139618 | 2021-03-20 | Hooker | Nebraska | 31091 | 52 | 2 |
1139619 | 1139619 | 2021-03-20 | Howard | Nebraska | 31093 | 528 | 17 |
1139620 | 1139620 | 2021-03-20 | Jefferson | Nebraska | 31095 | 626 | 1 |
1139621 | 1139621 | 2021-03-20 | Johnson | Nebraska | 31097 | 635 | 8 |
1139622 | 1139622 | 2021-03-20 | Kearney | Nebraska | 31099 | 670 | 5 |
1139623 | 1139623 | 2021-03-20 | Keith | Nebraska | 31101 | 691 | 6 |
1139624 | 1139624 | 2021-03-20 | Keya Paha | Nebraska | 31103 | 51 | 0 |
1139625 | 1139625 | 2021-03-20 | Kimball | Nebraska | 31105 | 412 | 7 |
1139626 | 1139626 | 2021-03-20 | Knox | Nebraska | 31107 | 854 | 12 |
1139627 | 1139627 | 2021-03-20 | Lancaster | Nebraska | 31109 | 29111 | 221 |
1139628 | 1139628 | 2021-03-20 | Lincoln | Nebraska | 31111 | 3623 | 52 |
1139629 | 1139629 | 2021-03-20 | Logan | Nebraska | 31113 | 79 | 0 |
1139630 | 1139630 | 2021-03-20 | Loup | Nebraska | 31115 | 40 | 0 |
1139631 | 1139631 | 2021-03-20 | Madison | Nebraska | 31119 | 4413 | 44 |
1139632 | 1139632 | 2021-03-20 | McPherson | Nebraska | 31117 | 29 | 1 |
1139633 | 1139633 | 2021-03-20 | Merrick | Nebraska | 31121 | 753 | 14 |
1139634 | 1139634 | 2021-03-20 | Morrill | Nebraska | 31123 | 492 | 15 |
1139635 | 1139635 | 2021-03-20 | Nance | Nebraska | 31125 | 386 | 10 |
1139636 | 1139636 | 2021-03-20 | Nemaha | Nebraska | 31127 | 623 | 14 |
1139637 | 1139637 | 2021-03-20 | Nuckolls | Nebraska | 31129 | 408 | 1 |
1139638 | 1139638 | 2021-03-20 | Otoe | Nebraska | 31131 | 1356 | 9 |
1139639 | 1139639 | 2021-03-20 | Pawnee | Nebraska | 31133 | 228 | 1 |
1139640 | 1139640 | 2021-03-20 | Perkins | Nebraska | 31135 | 273 | 11 |
1139641 | 1139641 | 2021-03-20 | Phelps | Nebraska | 31137 | 946 | 9 |
1139642 | 1139642 | 2021-03-20 | Pierce | Nebraska | 31139 | 607 | 20 |
1139643 | 1139643 | 2021-03-20 | Platte | Nebraska | 31141 | 3879 | 47 |
1139644 | 1139644 | 2021-03-20 | Polk | Nebraska | 31143 | 576 | 18 |
1139645 | 1139645 | 2021-03-20 | Red Willow | Nebraska | 31145 | 1182 | 12 |
1139646 | 1139646 | 2021-03-20 | Richardson | Nebraska | 31147 | 694 | 18 |
1139647 | 1139647 | 2021-03-20 | Rock | Nebraska | 31149 | 102 | 2 |
1139648 | 1139648 | 2021-03-20 | Saline | Nebraska | 31151 | 1955 | 3 |
1139649 | 1139649 | 2021-03-20 | Sarpy | Nebraska | 31153 | 20636 | 108 |
1139650 | 1139650 | 2021-03-20 | Saunders | Nebraska | 31155 | 2363 | 14 |
1139651 | 1139651 | 2021-03-20 | Scotts Bluff | Nebraska | 31157 | 4563 | 95 |
1139652 | 1139652 | 2021-03-20 | Seward | Nebraska | 31159 | 1886 | 29 |
1139653 | 1139653 | 2021-03-20 | Sheridan | Nebraska | 31161 | 489 | 19 |
1139654 | 1139654 | 2021-03-20 | Sherman | Nebraska | 31163 | 187 | 4 |
1139655 | 1139655 | 2021-03-20 | Sioux | Nebraska | 31165 | 36 | 0 |
1139656 | 1139656 | 2021-03-20 | Stanton | Nebraska | 31167 | 355 | 9 |
1139657 | 1139657 | 2021-03-20 | Thayer | Nebraska | 31169 | 480 | 4 |
1139658 | 1139658 | 2021-03-20 | Thomas | Nebraska | 31171 | 52 | 1 |
1139659 | 1139659 | 2021-03-20 | Thurston | Nebraska | 31173 | 818 | 11 |
1139660 | 1139660 | 2021-03-20 | Valley | Nebraska | 31175 | 314 | 3 |
1139661 | 1139661 | 2021-03-20 | Washington | Nebraska | 31177 | 2046 | 21 |
1139662 | 1139662 | 2021-03-20 | Wayne | Nebraska | 31179 | 1014 | 7 |
1139663 | 1139663 | 2021-03-20 | Webster | Nebraska | 31181 | 323 | 4 |
1139664 | 1139664 | 2021-03-20 | Wheeler | Nebraska | 31183 | 38 | 0 |
1139665 | 1139665 | 2021-03-20 | York | Nebraska | 31185 | 1690 | 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);