covid_casesdeaths_reshaped_bln
Data source: Big Local News · About: big-local-datasette
1,191,735 rows sorted by State descending
This data as json, copyable, CSV (advanced)
Link | rowid | countyFIPS | County Name | State ▲ | stateFIPS | date | cases | deaths |
---|---|---|---|---|---|---|---|---|
3172 | 3172 | 0 | Statewide Unallocated | WY | 56 | 1/22/20 | 0 | 0 |
3173 | 3173 | 56001 | Albany County | WY | 56 | 1/22/20 | 0 | 0 |
3174 | 3174 | 56003 | Big Horn County | WY | 56 | 1/22/20 | 0 | 0 |
3175 | 3175 | 56005 | Campbell County | WY | 56 | 1/22/20 | 0 | 0 |
3176 | 3176 | 56007 | Carbon County | WY | 56 | 1/22/20 | 0 | 0 |
3177 | 3177 | 56009 | Converse County | WY | 56 | 1/22/20 | 0 | 0 |
3178 | 3178 | 56011 | Crook County | WY | 56 | 1/22/20 | 0 | 0 |
3179 | 3179 | 56013 | Fremont County | WY | 56 | 1/22/20 | 0 | 0 |
3180 | 3180 | 56015 | Goshen County | WY | 56 | 1/22/20 | 0 | 0 |
3181 | 3181 | 56017 | Hot Springs County | WY | 56 | 1/22/20 | 0 | 0 |
3182 | 3182 | 56019 | Johnson County | WY | 56 | 1/22/20 | 0 | 0 |
3183 | 3183 | 56021 | Laramie County | WY | 56 | 1/22/20 | 0 | 0 |
3184 | 3184 | 56023 | Lincoln County | WY | 56 | 1/22/20 | 0 | 0 |
3185 | 3185 | 56025 | Natrona County | WY | 56 | 1/22/20 | 0 | 0 |
3186 | 3186 | 56027 | Niobrara County | WY | 56 | 1/22/20 | 0 | 0 |
3187 | 3187 | 56029 | Park County | WY | 56 | 1/22/20 | 0 | 0 |
3188 | 3188 | 56031 | Platte County | WY | 56 | 1/22/20 | 0 | 0 |
3189 | 3189 | 56033 | Sheridan County | WY | 56 | 1/22/20 | 0 | 0 |
3190 | 3190 | 56035 | Sublette County | WY | 56 | 1/22/20 | 0 | 0 |
3191 | 3191 | 56037 | Sweetwater County | WY | 56 | 1/22/20 | 0 | 0 |
3192 | 3192 | 56039 | Teton County | WY | 56 | 1/22/20 | 0 | 0 |
3193 | 3193 | 56041 | Uinta County | WY | 56 | 1/22/20 | 0 | 0 |
3194 | 3194 | 56043 | Washakie County | WY | 56 | 1/22/20 | 0 | 0 |
3195 | 3195 | 56045 | Weston County | WY | 56 | 1/22/20 | 0 | 0 |
6367 | 6367 | 0 | Statewide Unallocated | WY | 56 | 1/23/20 | 0 | 0 |
6368 | 6368 | 56001 | Albany County | WY | 56 | 1/23/20 | 0 | 0 |
6369 | 6369 | 56003 | Big Horn County | WY | 56 | 1/23/20 | 0 | 0 |
6370 | 6370 | 56005 | Campbell County | WY | 56 | 1/23/20 | 0 | 0 |
6371 | 6371 | 56007 | Carbon County | WY | 56 | 1/23/20 | 0 | 0 |
6372 | 6372 | 56009 | Converse County | WY | 56 | 1/23/20 | 0 | 0 |
6373 | 6373 | 56011 | Crook County | WY | 56 | 1/23/20 | 0 | 0 |
6374 | 6374 | 56013 | Fremont County | WY | 56 | 1/23/20 | 0 | 0 |
6375 | 6375 | 56015 | Goshen County | WY | 56 | 1/23/20 | 0 | 0 |
6376 | 6376 | 56017 | Hot Springs County | WY | 56 | 1/23/20 | 0 | 0 |
6377 | 6377 | 56019 | Johnson County | WY | 56 | 1/23/20 | 0 | 0 |
6378 | 6378 | 56021 | Laramie County | WY | 56 | 1/23/20 | 0 | 0 |
6379 | 6379 | 56023 | Lincoln County | WY | 56 | 1/23/20 | 0 | 0 |
6380 | 6380 | 56025 | Natrona County | WY | 56 | 1/23/20 | 0 | 0 |
6381 | 6381 | 56027 | Niobrara County | WY | 56 | 1/23/20 | 0 | 0 |
6382 | 6382 | 56029 | Park County | WY | 56 | 1/23/20 | 0 | 0 |
6383 | 6383 | 56031 | Platte County | WY | 56 | 1/23/20 | 0 | 0 |
6384 | 6384 | 56033 | Sheridan County | WY | 56 | 1/23/20 | 0 | 0 |
6385 | 6385 | 56035 | Sublette County | WY | 56 | 1/23/20 | 0 | 0 |
6386 | 6386 | 56037 | Sweetwater County | WY | 56 | 1/23/20 | 0 | 0 |
6387 | 6387 | 56039 | Teton County | WY | 56 | 1/23/20 | 0 | 0 |
6388 | 6388 | 56041 | Uinta County | WY | 56 | 1/23/20 | 0 | 0 |
6389 | 6389 | 56043 | Washakie County | WY | 56 | 1/23/20 | 0 | 0 |
6390 | 6390 | 56045 | Weston County | WY | 56 | 1/23/20 | 0 | 0 |
9562 | 9562 | 0 | Statewide Unallocated | WY | 56 | 1/24/20 | 0 | 0 |
9563 | 9563 | 56001 | Albany County | WY | 56 | 1/24/20 | 0 | 0 |
9564 | 9564 | 56003 | Big Horn County | WY | 56 | 1/24/20 | 0 | 0 |
9565 | 9565 | 56005 | Campbell County | WY | 56 | 1/24/20 | 0 | 0 |
9566 | 9566 | 56007 | Carbon County | WY | 56 | 1/24/20 | 0 | 0 |
9567 | 9567 | 56009 | Converse County | WY | 56 | 1/24/20 | 0 | 0 |
9568 | 9568 | 56011 | Crook County | WY | 56 | 1/24/20 | 0 | 0 |
9569 | 9569 | 56013 | Fremont County | WY | 56 | 1/24/20 | 0 | 0 |
9570 | 9570 | 56015 | Goshen County | WY | 56 | 1/24/20 | 0 | 0 |
9571 | 9571 | 56017 | Hot Springs County | WY | 56 | 1/24/20 | 0 | 0 |
9572 | 9572 | 56019 | Johnson County | WY | 56 | 1/24/20 | 0 | 0 |
9573 | 9573 | 56021 | Laramie County | WY | 56 | 1/24/20 | 0 | 0 |
9574 | 9574 | 56023 | Lincoln County | WY | 56 | 1/24/20 | 0 | 0 |
9575 | 9575 | 56025 | Natrona County | WY | 56 | 1/24/20 | 0 | 0 |
9576 | 9576 | 56027 | Niobrara County | WY | 56 | 1/24/20 | 0 | 0 |
9577 | 9577 | 56029 | Park County | WY | 56 | 1/24/20 | 0 | 0 |
9578 | 9578 | 56031 | Platte County | WY | 56 | 1/24/20 | 0 | 0 |
9579 | 9579 | 56033 | Sheridan County | WY | 56 | 1/24/20 | 0 | 0 |
9580 | 9580 | 56035 | Sublette County | WY | 56 | 1/24/20 | 0 | 0 |
9581 | 9581 | 56037 | Sweetwater County | WY | 56 | 1/24/20 | 0 | 0 |
9582 | 9582 | 56039 | Teton County | WY | 56 | 1/24/20 | 0 | 0 |
9583 | 9583 | 56041 | Uinta County | WY | 56 | 1/24/20 | 0 | 0 |
9584 | 9584 | 56043 | Washakie County | WY | 56 | 1/24/20 | 0 | 0 |
9585 | 9585 | 56045 | Weston County | WY | 56 | 1/24/20 | 0 | 0 |
12757 | 12757 | 0 | Statewide Unallocated | WY | 56 | 1/25/20 | 0 | 0 |
12758 | 12758 | 56001 | Albany County | WY | 56 | 1/25/20 | 0 | 0 |
12759 | 12759 | 56003 | Big Horn County | WY | 56 | 1/25/20 | 0 | 0 |
12760 | 12760 | 56005 | Campbell County | WY | 56 | 1/25/20 | 0 | 0 |
12761 | 12761 | 56007 | Carbon County | WY | 56 | 1/25/20 | 0 | 0 |
12762 | 12762 | 56009 | Converse County | WY | 56 | 1/25/20 | 0 | 0 |
12763 | 12763 | 56011 | Crook County | WY | 56 | 1/25/20 | 0 | 0 |
12764 | 12764 | 56013 | Fremont County | WY | 56 | 1/25/20 | 0 | 0 |
12765 | 12765 | 56015 | Goshen County | WY | 56 | 1/25/20 | 0 | 0 |
12766 | 12766 | 56017 | Hot Springs County | WY | 56 | 1/25/20 | 0 | 0 |
12767 | 12767 | 56019 | Johnson County | WY | 56 | 1/25/20 | 0 | 0 |
12768 | 12768 | 56021 | Laramie County | WY | 56 | 1/25/20 | 0 | 0 |
12769 | 12769 | 56023 | Lincoln County | WY | 56 | 1/25/20 | 0 | 0 |
12770 | 12770 | 56025 | Natrona County | WY | 56 | 1/25/20 | 0 | 0 |
12771 | 12771 | 56027 | Niobrara County | WY | 56 | 1/25/20 | 0 | 0 |
12772 | 12772 | 56029 | Park County | WY | 56 | 1/25/20 | 0 | 0 |
12773 | 12773 | 56031 | Platte County | WY | 56 | 1/25/20 | 0 | 0 |
12774 | 12774 | 56033 | Sheridan County | WY | 56 | 1/25/20 | 0 | 0 |
12775 | 12775 | 56035 | Sublette County | WY | 56 | 1/25/20 | 0 | 0 |
12776 | 12776 | 56037 | Sweetwater County | WY | 56 | 1/25/20 | 0 | 0 |
12777 | 12777 | 56039 | Teton County | WY | 56 | 1/25/20 | 0 | 0 |
12778 | 12778 | 56041 | Uinta County | WY | 56 | 1/25/20 | 0 | 0 |
12779 | 12779 | 56043 | Washakie County | WY | 56 | 1/25/20 | 0 | 0 |
12780 | 12780 | 56045 | Weston County | WY | 56 | 1/25/20 | 0 | 0 |
15952 | 15952 | 0 | Statewide Unallocated | WY | 56 | 1/26/20 | 0 | 0 |
15953 | 15953 | 56001 | Albany County | WY | 56 | 1/26/20 | 0 | 0 |
15954 | 15954 | 56003 | Big Horn County | WY | 56 | 1/26/20 | 0 | 0 |
15955 | 15955 | 56005 | Campbell County | WY | 56 | 1/26/20 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [covid_casesdeaths_reshaped_bln] ( [countyFIPS] INTEGER, [County Name] TEXT, [State] TEXT, [stateFIPS] INTEGER, [date] TEXT, [cases] INTEGER, [deaths] INTEGER );