ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where "date" is on date 2020-05-20 and state = "Nebraska" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 69
- 31001 1
- 31003 1
- 31011 1
- 31013 1
- 31019 1
- 31021 1
- 31023 1
- 31025 1
- 31027 1
- 31031 1
- 31033 1
- 31035 1
- 31037 1
- 31039 1
- 31041 1
- 31043 1
- 31045 1
- 31047 1
- 31051 1
- 31053 1
- 31055 1
- 31059 1
- 31061 1
- 31063 1
- 31065 1
- 31067 1
- 31073 1
- 31077 1
- 31079 1
- 31081 1
- 31087 1
- 31089 1
- 31093 1
- 31095 1
- 31097 1
- 31099 1
- 31101 1
- 31105 1
- 31107 1
- 31109 1
- 31111 1
- 31119 1
- 31121 1
- 31123 1
- 31125 1
- 31127 1
- 31129 1
- 31131 1
- 31137 1
- 31139 1
- 31141 1
- 31143 1
- 31145 1
- 31147 1
- 31151 1
- 31153 1
- 31155 1
- 31157 1
- 31159 1
- 31163 1
- 31167 1
- 31171 1
- 31173 1
- 31175 1
- 31177 1
- 31179 1
- 31181 1
- 31185 1
- - 1
county 69
- Adams 1
- Antelope 1
- Boone 1
- Box Butte 1
- Buffalo 1
- Burt 1
- Butler 1
- Cass 1
- Cedar 1
- Cherry 1
- Cheyenne 1
- Clay 1
- Colfax 1
- Cuming 1
- Custer 1
- Dakota 1
- Dawes 1
- Dawson 1
- Dixon 1
- Dodge 1
- Douglas 1
- Fillmore 1
- Franklin 1
- Frontier 1
- Furnas 1
- Gage 1
- Gosper 1
- Greeley 1
- Hall 1
- Hamilton 1
- Hitchcock 1
- Holt 1
- Howard 1
- Jefferson 1
- Johnson 1
- Kearney 1
- Keith 1
- Kimball 1
- Knox 1
- Lancaster 1
- Lincoln 1
- Madison 1
- Merrick 1
- Morrill 1
- Nance 1
- Nemaha 1
- Nuckolls 1
- Otoe 1
- Phelps 1
- Pierce 1
- Platte 1
- Polk 1
- Red Willow 1
- Richardson 1
- Saline 1
- Sarpy 1
- Saunders 1
- Scotts Bluff 1
- Seward 1
- Sherman 1
- Stanton 1
- Thomas 1
- Thurston 1
- Unknown 1
- Valley 1
- Washington 1
- Wayne 1
- Webster 1
- York 1
state 1
- Nebraska · 69 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
161837 | 161837 | 2020-05-20 | Box Butte | Nebraska | 31013 | 1 | 0 |
161843 | 161843 | 2020-05-20 | Cherry | Nebraska | 31031 | 1 | 0 |
161850 | 161850 | 2020-05-20 | Dawes | Nebraska | 31045 | 1 | 0 |
161857 | 161857 | 2020-05-20 | Frontier | Nebraska | 31063 | 1 | 0 |
161864 | 161864 | 2020-05-20 | Hitchcock | Nebraska | 31087 | 1 | 0 |
161865 | 161865 | 2020-05-20 | Holt | Nebraska | 31089 | 1 | 0 |
161880 | 161880 | 2020-05-20 | Nuckolls | Nebraska | 31129 | 1 | 0 |
161883 | 161883 | 2020-05-20 | Pierce | Nebraska | 31139 | 1 | 0 |
161887 | 161887 | 2020-05-20 | Richardson | Nebraska | 31147 | 1 | 0 |
161895 | 161895 | 2020-05-20 | Thomas | Nebraska | 31171 | 1 | 0 |
161861 | 161861 | 2020-05-20 | Greeley | Nebraska | 31077 | 2 | 0 |
161870 | 161870 | 2020-05-20 | Keith | Nebraska | 31101 | 2 | 0 |
161893 | 161893 | 2020-05-20 | Sherman | Nebraska | 31163 | 2 | 0 |
161836 | 161836 | 2020-05-20 | Boone | Nebraska | 31011 | 3 | 0 |
161879 | 161879 | 2020-05-20 | Nemaha | Nebraska | 31127 | 3 | 0 |
161898 | 161898 | 2020-05-20 | Valley | Nebraska | 31175 | 3 | 0 |
161878 | 161878 | 2020-05-20 | Nance | Nebraska | 31125 | 4 | 0 |
161900 | 161900 | 2020-05-20 | Wayne | Nebraska | 31179 | 4 | 0 |
161855 | 161855 | 2020-05-20 | Fillmore | Nebraska | 31059 | 5 | 0 |
161856 | 161856 | 2020-05-20 | Franklin | Nebraska | 31061 | 5 | 0 |
161886 | 161886 | 2020-05-20 | Red Willow | Nebraska | 31145 | 5 | 0 |
161901 | 161901 | 2020-05-20 | Webster | Nebraska | 31181 | 5 | 0 |
161839 | 161839 | 2020-05-20 | Burt | Nebraska | 31021 | 6 | 0 |
161842 | 161842 | 2020-05-20 | Cedar | Nebraska | 31027 | 6 | 0 |
161858 | 161858 | 2020-05-20 | Furnas | Nebraska | 31065 | 6 | 0 |
161867 | 161867 | 2020-05-20 | Jefferson | Nebraska | 31095 | 6 | 0 |
161881 | 161881 | 2020-05-20 | Otoe | Nebraska | 31131 | 6 | 0 |
161835 | 161835 | 2020-05-20 | Antelope | Nebraska | 31003 | 7 | 0 |
161868 | 161868 | 2020-05-20 | Johnson | Nebraska | 31097 | 7 | 0 |
161872 | 161872 | 2020-05-20 | Knox | Nebraska | 31107 | 8 | 0 |
161844 | 161844 | 2020-05-20 | Cheyenne | Nebraska | 31033 | 9 | 0 |
161885 | 161885 | 2020-05-20 | Polk | Nebraska | 31143 | 9 | 0 |
161871 | 161871 | 2020-05-20 | Kimball | Nebraska | 31105 | 10 | 0 |
161877 | 161877 | 2020-05-20 | Morrill | Nebraska | 31123 | 10 | 0 |
161897 | 161897 | 2020-05-20 | Unknown | Nebraska | 10 | 0 | |
161869 | 161869 | 2020-05-20 | Kearney | Nebraska | 31099 | 11 | 0 |
161860 | 161860 | 2020-05-20 | Gosper | Nebraska | 31073 | 13 | 0 |
161894 | 161894 | 2020-05-20 | Stanton | Nebraska | 31167 | 15 | 0 |
161882 | 161882 | 2020-05-20 | Phelps | Nebraska | 31137 | 16 | 0 |
161847 | 161847 | 2020-05-20 | Cuming | Nebraska | 31039 | 18 | 0 |
161845 | 161845 | 2020-05-20 | Clay | Nebraska | 31035 | 20 | 0 |
161896 | 161896 | 2020-05-20 | Thurston | Nebraska | 31173 | 20 | 0 |
161890 | 161890 | 2020-05-20 | Saunders | Nebraska | 31155 | 22 | 1 |
161841 | 161841 | 2020-05-20 | Cass | Nebraska | 31025 | 26 | 0 |
161892 | 161892 | 2020-05-20 | Seward | Nebraska | 31159 | 26 | 1 |
161899 | 161899 | 2020-05-20 | Washington | Nebraska | 31177 | 26 | 1 |
161852 | 161852 | 2020-05-20 | Dixon | Nebraska | 31051 | 27 | 0 |
161876 | 161876 | 2020-05-20 | Merrick | Nebraska | 31121 | 30 | 0 |
161902 | 161902 | 2020-05-20 | York | Nebraska | 31185 | 30 | 0 |
161848 | 161848 | 2020-05-20 | Custer | Nebraska | 31041 | 35 | 4 |
161840 | 161840 | 2020-05-20 | Butler | Nebraska | 31023 | 37 | 0 |
161866 | 161866 | 2020-05-20 | Howard | Nebraska | 31093 | 38 | 0 |
161859 | 161859 | 2020-05-20 | Gage | Nebraska | 31067 | 43 | 4 |
161874 | 161874 | 2020-05-20 | Lincoln | Nebraska | 31111 | 46 | 2 |
161891 | 161891 | 2020-05-20 | Scotts Bluff | Nebraska | 31157 | 55 | 0 |
161863 | 161863 | 2020-05-20 | Hamilton | Nebraska | 31081 | 58 | 12 |
161838 | 161838 | 2020-05-20 | Buffalo | Nebraska | 31019 | 136 | 1 |
161834 | 161834 | 2020-05-20 | Adams | Nebraska | 31001 | 256 | 11 |
161853 | 161853 | 2020-05-20 | Dodge | Nebraska | 31053 | 282 | 1 |
161875 | 161875 | 2020-05-20 | Madison | Nebraska | 31119 | 289 | 3 |
161889 | 161889 | 2020-05-20 | Sarpy | Nebraska | 31153 | 382 | 2 |
161888 | 161888 | 2020-05-20 | Saline | Nebraska | 31151 | 448 | 1 |
161884 | 161884 | 2020-05-20 | Platte | Nebraska | 31141 | 505 | 1 |
161846 | 161846 | 2020-05-20 | Colfax | Nebraska | 31037 | 559 | 2 |
161851 | 161851 | 2020-05-20 | Dawson | Nebraska | 31047 | 812 | 7 |
161873 | 161873 | 2020-05-20 | Lancaster | Nebraska | 31109 | 934 | 7 |
161862 | 161862 | 2020-05-20 | Hall | Nebraska | 31079 | 1446 | 39 |
161849 | 161849 | 2020-05-20 | Dakota | Nebraska | 31043 | 1576 | 17 |
161854 | 161854 | 2020-05-20 | Douglas | Nebraska | 31055 | 2729 | 24 |
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);