johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where "last_update" is on date 2020-04-09 and province_or_state = "Nebraska" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3947228 | 3947228 | 2020-04-09 | US | Nebraska | Adams | 31001 | 28 | 0 | 0 | 28 | 40.52449420000001 | -98.50117804 | 2020-04-09 23:02:37 | Adams, Nebraska, US |
3947274 | 3947274 | 2020-04-09 | US | Nebraska | Antelope | 31003 | 1 | 0 | 0 | 1 | 42.17695516 | -98.06662829999999 | 2020-04-09 23:02:37 | Antelope, Nebraska, US |
3947466 | 3947466 | 2020-04-09 | US | Nebraska | Buffalo | 31019 | 31 | 1 | 0 | 30 | 40.85486962 | -99.07500296 | 2020-04-09 23:02:37 | Buffalo, Nebraska, US |
3947480 | 3947480 | 2020-04-09 | US | Nebraska | Burt | 31021 | 1 | 0 | 0 | 1 | 41.85056773 | -96.32605633 | 2020-04-09 23:02:37 | Burt, Nebraska, US |
3947568 | 3947568 | 2020-04-09 | US | Nebraska | Cass | 31025 | 3 | 0 | 0 | 3 | 40.90899107 | -96.13971217 | 2020-04-09 23:02:37 | Cass, Nebraska, US |
3947619 | 3947619 | 2020-04-09 | US | Nebraska | Cherry | 31031 | 1 | 0 | 0 | 1 | 42.54502621 | -101.1244332 | 2020-04-09 23:02:37 | Cherry, Nebraska, US |
3947627 | 3947627 | 2020-04-09 | US | Nebraska | Cheyenne | 31033 | 1 | 0 | 0 | 1 | 41.21999357 | -102.9941693 | 2020-04-09 23:02:37 | Cheyenne, Nebraska, US |
3947718 | 3947718 | 2020-04-09 | US | Nebraska | Colfax | 31037 | 3 | 0 | 0 | 3 | 41.57486951 | -97.0868542 | 2020-04-09 23:02:37 | Colfax, Nebraska, US |
3947801 | 3947801 | 2020-04-09 | US | Nebraska | Cuming | 31039 | 2 | 0 | 0 | 2 | 41.91637624 | -96.78730772 | 2020-04-09 23:02:37 | Cuming, Nebraska, US |
3947807 | 3947807 | 2020-04-09 | US | Nebraska | Custer | 31041 | 3 | 0 | 0 | 3 | 41.39374521 | -99.72805369 | 2020-04-09 23:02:37 | Custer, Nebraska, US |
3947833 | 3947833 | 2020-04-09 | US | Nebraska | Dawson | 31047 | 2 | 0 | 0 | 2 | 40.87028216 | -99.82014609999999 | 2020-04-09 23:02:37 | Dawson, Nebraska, US |
3947882 | 3947882 | 2020-04-09 | US | Nebraska | Dodge | 31053 | 7 | 0 | 0 | 7 | 41.58071748 | -96.65598179 | 2020-04-09 23:02:37 | Dodge, Nebraska, US |
3947897 | 3947897 | 2020-04-09 | US | Nebraska | Douglas | 31055 | 198 | 5 | 0 | 193 | 41.29518299 | -96.15085305 | 2020-04-09 23:02:37 | Douglas, Nebraska, US |
3948050 | 3948050 | 2020-04-09 | US | Nebraska | Gage | 31067 | 24 | 1 | 0 | 23 | 40.26186809 | -96.68946704 | 2020-04-09 23:02:37 | Gage, Nebraska, US |
3948098 | 3948098 | 2020-04-09 | US | Nebraska | Gosper | 31073 | 1 | 0 | 0 | 1 | 40.51481965 | -99.83020279 | 2020-04-09 23:02:37 | Gosper, Nebraska, US |
3948170 | 3948170 | 2020-04-09 | US | Nebraska | Hall | 31079 | 84 | 2 | 0 | 82 | 40.87257079 | -98.50218293 | 2020-04-09 23:02:37 | Hall, Nebraska, US |
3948175 | 3948175 | 2020-04-09 | US | Nebraska | Hamilton | 31081 | 8 | 0 | 0 | 8 | 40.87349452 | -98.02099117 | 2020-04-09 23:02:37 | Hamilton, Nebraska, US |
3948404 | 3948404 | 2020-04-09 | US | Nebraska | Johnson | 31097 | 1 | 0 | 0 | 1 | 40.39257596 | -96.26522753 | 2020-04-09 23:02:37 | Johnson, Nebraska, US |
3948430 | 3948430 | 2020-04-09 | US | Nebraska | Kearney | 31099 | 3 | 0 | 0 | 3 | 40.50663314 | -98.94877182 | 2020-04-09 23:02:37 | Kearney, Nebraska, US |
3948448 | 3948448 | 2020-04-09 | US | Nebraska | Kimball | 31105 | 10 | 0 | 0 | 10 | 41.19774275 | -103.7148131 | 2020-04-09 23:02:37 | Kimball, Nebraska, US |
3948466 | 3948466 | 2020-04-09 | US | Nebraska | Knox | 31107 | 2 | 0 | 0 | 2 | 42.63758421 | -97.89178836 | 2020-04-09 23:02:37 | Knox, Nebraska, US |
3948507 | 3948507 | 2020-04-09 | US | Nebraska | Lancaster | 31109 | 44 | 1 | 0 | 43 | 40.78416049 | -96.68777155 | 2020-04-09 23:02:37 | Lancaster, Nebraska, US |
3948589 | 3948589 | 2020-04-09 | US | Nebraska | Lincoln | 31111 | 17 | 1 | 0 | 16 | 41.04658298 | -100.74753740000001 | 2020-04-09 23:02:37 | Lincoln, Nebraska, US |
3948615 | 3948615 | 2020-04-09 | US | Nebraska | Logan | 31113 | 0 | 0 | 0 | 0 | 41.56650314 | -100.4817851 | 2020-04-09 23:02:37 | Logan, Nebraska, US |
3948670 | 3948670 | 2020-04-09 | US | Nebraska | Madison | 31119 | 6 | 1 | 0 | 5 | 41.91676024 | -97.6005481 | 2020-04-09 23:02:37 | Madison, Nebraska, US |
3948791 | 3948791 | 2020-04-09 | US | Nebraska | Merrick | 31121 | 2 | 0 | 0 | 2 | 41.16624273 | -98.0374887 | 2020-04-09 23:02:37 | Merrick, Nebraska, US |
3948910 | 3948910 | 2020-04-09 | US | Nebraska | Nemaha | 31127 | 1 | 0 | 0 | 1 | 40.38514847 | -95.85433992 | 2020-04-09 23:02:37 | Nemaha, Nebraska, US |
3949008 | 3949008 | 2020-04-09 | US | Nebraska | Otoe | 31131 | 1 | 0 | 0 | 1 | 40.64843556 | -96.13374142 | 2020-04-09 23:02:37 | Otoe, Nebraska, US |
3949077 | 3949077 | 2020-04-09 | US | Nebraska | Phelps | 31137 | 1 | 0 | 0 | 1 | 40.51156033 | -99.41461667 | 2020-04-09 23:02:37 | Phelps, Nebraska, US |
3949110 | 3949110 | 2020-04-09 | US | Nebraska | Platte | 31141 | 5 | 0 | 0 | 5 | 41.57246836 | -97.52144359 | 2020-04-09 23:02:37 | Platte, Nebraska, US |
3949124 | 3949124 | 2020-04-09 | US | Nebraska | Polk | 31143 | 1 | 0 | 0 | 1 | 41.18813488 | -97.56630712 | 2020-04-09 23:02:37 | Polk, Nebraska, US |
3949303 | 3949303 | 2020-04-09 | US | Nebraska | Sarpy | 31153 | 38 | 0 | 0 | 38 | 41.11314181 | -96.11156432 | 2020-04-09 23:02:37 | Sarpy, Nebraska, US |
3949305 | 3949305 | 2020-04-09 | US | Nebraska | Saunders | 31155 | 4 | 0 | 0 | 4 | 41.227810299999994 | -96.63773905 | 2020-04-09 23:02:37 | Saunders, Nebraska, US |
3949326 | 3949326 | 2020-04-09 | US | Nebraska | Scotts Bluff | 31157 | 10 | 0 | 0 | 10 | 41.85070896 | -103.70809859999999 | 2020-04-09 23:02:37 | Scotts Bluff, Nebraska, US |
3949341 | 3949341 | 2020-04-09 | US | Nebraska | Seward | 31159 | 1 | 0 | 0 | 1 | 40.87241834 | -97.139673 | 2020-04-09 23:02:37 | Seward, Nebraska, US |
3949423 | 3949423 | 2020-04-09 | US | Nebraska | Stanton | 31167 | 1 | 0 | 0 | 1 | 41.9169835 | -97.19394708 | 2020-04-09 23:02:37 | Stanton, Nebraska, US |
3949588 | 3949588 | 2020-04-09 | US | Nebraska | Unassigned | 90031 | 0 | 2 | 0 | 0 | 42.8997274 | 0.0 | 2020-04-09 23:02:37 | Unassigned, Nebraska, US |
3949709 | 3949709 | 2020-04-09 | US | Nebraska | Washington | 31177 | 20 | 0 | 0 | 20 | 41.52815707 | -96.22019892 | 2020-04-09 23:02:37 | Washington, Nebraska, US |
3949846 | 3949846 | 2020-04-09 | US | Nebraska | York | 31185 | 2 | 0 | 0 | 2 | 40.87272618 | -97.59710186 | 2020-04-09 23:02:37 | York, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);