ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where "date" is on date 2020-04-14 and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 45
- 31001 1
- 31003 1
- 31013 1
- 31019 1
- 31021 1
- 31025 1
- 31031 1
- 31033 1
- 31035 1
- 31037 1
- 31039 1
- 31041 1
- 31043 1
- 31047 1
- 31053 1
- 31055 1
- 31061 1
- 31067 1
- 31073 1
- 31079 1
- 31081 1
- 31097 1
- 31099 1
- 31105 1
- 31107 1
- 31109 1
- 31111 1
- 31119 1
- 31121 1
- 31127 1
- 31131 1
- 31137 1
- 31139 1
- 31141 1
- 31143 1
- 31151 1
- 31153 1
- 31155 1
- 31157 1
- 31159 1
- 31167 1
- 31177 1
- 31179 1
- 31181 1
- 31185 1
county 45
- Adams 1
- Antelope 1
- Box Butte 1
- Buffalo 1
- Burt 1
- Cass 1
- Cherry 1
- Cheyenne 1
- Clay 1
- Colfax 1
- Cuming 1
- Custer 1
- Dakota 1
- Dawson 1
- Dodge 1
- Douglas 1
- Franklin 1
- Gage 1
- Gosper 1
- Hall 1
- Hamilton 1
- Johnson 1
- Kearney 1
- Kimball 1
- Knox 1
- Lancaster 1
- Lincoln 1
- Madison 1
- Merrick 1
- Nemaha 1
- Otoe 1
- Phelps 1
- Pierce 1
- Platte 1
- Polk 1
- Saline 1
- Sarpy 1
- Saunders 1
- Scotts Bluff 1
- Seward 1
- Stanton 1
- Washington 1
- Wayne 1
- Webster 1
- York 1
state 1
- Nebraska · 45 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
57914 | 57914 | 2020-04-14 | Adams | Nebraska | 31001 | 62 | 0 |
57915 | 57915 | 2020-04-14 | Antelope | Nebraska | 31003 | 1 | 0 |
57916 | 57916 | 2020-04-14 | Box Butte | Nebraska | 31013 | 1 | 0 |
57917 | 57917 | 2020-04-14 | Buffalo | Nebraska | 31019 | 41 | 1 |
57918 | 57918 | 2020-04-14 | Burt | Nebraska | 31021 | 1 | 0 |
57919 | 57919 | 2020-04-14 | Cass | Nebraska | 31025 | 3 | 0 |
57920 | 57920 | 2020-04-14 | Cherry | Nebraska | 31031 | 1 | 0 |
57921 | 57921 | 2020-04-14 | Cheyenne | Nebraska | 31033 | 2 | 0 |
57922 | 57922 | 2020-04-14 | Clay | Nebraska | 31035 | 2 | 0 |
57923 | 57923 | 2020-04-14 | Colfax | Nebraska | 31037 | 4 | 0 |
57924 | 57924 | 2020-04-14 | Cuming | Nebraska | 31039 | 2 | 0 |
57925 | 57925 | 2020-04-14 | Custer | Nebraska | 31041 | 19 | 2 |
57926 | 57926 | 2020-04-14 | Dakota | Nebraska | 31043 | 2 | 0 |
57927 | 57927 | 2020-04-14 | Dawson | Nebraska | 31047 | 21 | 0 |
57928 | 57928 | 2020-04-14 | Dodge | Nebraska | 31053 | 12 | 0 |
57929 | 57929 | 2020-04-14 | Douglas | Nebraska | 31055 | 269 | 8 |
57930 | 57930 | 2020-04-14 | Franklin | Nebraska | 31061 | 3 | 0 |
57931 | 57931 | 2020-04-14 | Gage | Nebraska | 31067 | 26 | 1 |
57932 | 57932 | 2020-04-14 | Gosper | Nebraska | 31073 | 1 | 0 |
57933 | 57933 | 2020-04-14 | Hall | Nebraska | 31079 | 235 | 4 |
57934 | 57934 | 2020-04-14 | Hamilton | Nebraska | 31081 | 13 | 0 |
57935 | 57935 | 2020-04-14 | Johnson | Nebraska | 31097 | 1 | 0 |
57936 | 57936 | 2020-04-14 | Kearney | Nebraska | 31099 | 3 | 0 |
57937 | 57937 | 2020-04-14 | Kimball | Nebraska | 31105 | 10 | 0 |
57938 | 57938 | 2020-04-14 | Knox | Nebraska | 31107 | 2 | 0 |
57939 | 57939 | 2020-04-14 | Lancaster | Nebraska | 31109 | 57 | 1 |
57940 | 57940 | 2020-04-14 | Lincoln | Nebraska | 31111 | 17 | 1 |
57941 | 57941 | 2020-04-14 | Madison | Nebraska | 31119 | 6 | 2 |
57942 | 57942 | 2020-04-14 | Merrick | Nebraska | 31121 | 3 | 0 |
57943 | 57943 | 2020-04-14 | Nemaha | Nebraska | 31127 | 1 | 0 |
57944 | 57944 | 2020-04-14 | Otoe | Nebraska | 31131 | 1 | 0 |
57945 | 57945 | 2020-04-14 | Phelps | Nebraska | 31137 | 1 | 0 |
57946 | 57946 | 2020-04-14 | Pierce | Nebraska | 31139 | 1 | 0 |
57947 | 57947 | 2020-04-14 | Platte | Nebraska | 31141 | 6 | 0 |
57948 | 57948 | 2020-04-14 | Polk | Nebraska | 31143 | 2 | 0 |
57949 | 57949 | 2020-04-14 | Saline | Nebraska | 31151 | 1 | 0 |
57950 | 57950 | 2020-04-14 | Sarpy | Nebraska | 31153 | 46 | 0 |
57951 | 57951 | 2020-04-14 | Saunders | Nebraska | 31155 | 6 | 0 |
57952 | 57952 | 2020-04-14 | Scotts Bluff | Nebraska | 31157 | 14 | 0 |
57953 | 57953 | 2020-04-14 | Seward | Nebraska | 31159 | 1 | 0 |
57954 | 57954 | 2020-04-14 | Stanton | Nebraska | 31167 | 1 | 0 |
57955 | 57955 | 2020-04-14 | Washington | Nebraska | 31177 | 22 | 1 |
57956 | 57956 | 2020-04-14 | Wayne | Nebraska | 31179 | 1 | 0 |
57957 | 57957 | 2020-04-14 | Webster | Nebraska | 31181 | 1 | 0 |
57958 | 57958 | 2020-04-14 | York | Nebraska | 31185 | 5 | 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);