us-counties
Data source: Big Local News · About: big-local-datasette
570,096 rows sorted by state descending
This data as json, copyable, CSV (advanced)
| Link | rowid | date | county | state ▲ | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 1364 | 1364 | 2020-03-11 | Sheridan | Wyoming | 56033 | 1 | 0 |
| 1619 | 1619 | 2020-03-12 | Sheridan | Wyoming | 56033 | 1 | 0 |
| 1933 | 1933 | 2020-03-13 | Fremont | Wyoming | 56013 | 1 | 0 |
| 1934 | 1934 | 2020-03-13 | Sheridan | Wyoming | 56033 | 1 | 0 |
| 2308 | 2308 | 2020-03-14 | Fremont | Wyoming | 56013 | 1 | 0 |
| 2309 | 2309 | 2020-03-14 | Sheridan | Wyoming | 56033 | 2 | 0 |
| 2737 | 2737 | 2020-03-15 | Fremont | Wyoming | 56013 | 1 | 0 |
| 2738 | 2738 | 2020-03-15 | Sheridan | Wyoming | 56033 | 2 | 0 |
| 3213 | 3213 | 2020-03-16 | Fremont | Wyoming | 56013 | 8 | 0 |
| 3214 | 3214 | 2020-03-16 | Sheridan | Wyoming | 56033 | 2 | 0 |
| 3757 | 3757 | 2020-03-17 | Fremont | Wyoming | 56013 | 8 | 0 |
| 3758 | 3758 | 2020-03-17 | Laramie | Wyoming | 56021 | 2 | 0 |
| 3759 | 3759 | 2020-03-17 | Park | Wyoming | 56029 | 1 | 0 |
| 3760 | 3760 | 2020-03-17 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 4396 | 4396 | 2020-03-18 | Fremont | Wyoming | 56013 | 8 | 0 |
| 4397 | 4397 | 2020-03-18 | Laramie | Wyoming | 56021 | 3 | 0 |
| 4398 | 4398 | 2020-03-18 | Park | Wyoming | 56029 | 1 | 0 |
| 4399 | 4399 | 2020-03-18 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 4400 | 4400 | 2020-03-18 | Teton | Wyoming | 56039 | 1 | 0 |
| 5162 | 5162 | 2020-03-19 | Fremont | Wyoming | 56013 | 8 | 0 |
| 5163 | 5163 | 2020-03-19 | Laramie | Wyoming | 56021 | 4 | 0 |
| 5164 | 5164 | 2020-03-19 | Park | Wyoming | 56029 | 1 | 0 |
| 5165 | 5165 | 2020-03-19 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 5166 | 5166 | 2020-03-19 | Teton | Wyoming | 56039 | 1 | 0 |
| 6076 | 6076 | 2020-03-20 | Campbell | Wyoming | 56005 | 1 | 0 |
| 6077 | 6077 | 2020-03-20 | Fremont | Wyoming | 56013 | 9 | 0 |
| 6078 | 6078 | 2020-03-20 | Laramie | Wyoming | 56021 | 4 | 0 |
| 6079 | 6079 | 2020-03-20 | Natrona | Wyoming | 56025 | 1 | 0 |
| 6080 | 6080 | 2020-03-20 | Park | Wyoming | 56029 | 1 | 0 |
| 6081 | 6081 | 2020-03-20 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 6082 | 6082 | 2020-03-20 | Teton | Wyoming | 56039 | 2 | 0 |
| 7109 | 7109 | 2020-03-21 | Campbell | Wyoming | 56005 | 1 | 0 |
| 7110 | 7110 | 2020-03-21 | Carbon | Wyoming | 56007 | 1 | 0 |
| 7111 | 7111 | 2020-03-21 | Fremont | Wyoming | 56013 | 9 | 0 |
| 7112 | 7112 | 2020-03-21 | Laramie | Wyoming | 56021 | 5 | 0 |
| 7113 | 7113 | 2020-03-21 | Natrona | Wyoming | 56025 | 1 | 0 |
| 7114 | 7114 | 2020-03-21 | Park | Wyoming | 56029 | 1 | 0 |
| 7115 | 7115 | 2020-03-21 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 7116 | 7116 | 2020-03-21 | Teton | Wyoming | 56039 | 2 | 0 |
| 8247 | 8247 | 2020-03-22 | Campbell | Wyoming | 56005 | 1 | 0 |
| 8248 | 8248 | 2020-03-22 | Carbon | Wyoming | 56007 | 1 | 0 |
| 8249 | 8249 | 2020-03-22 | Fremont | Wyoming | 56013 | 10 | 0 |
| 8250 | 8250 | 2020-03-22 | Laramie | Wyoming | 56021 | 6 | 0 |
| 8251 | 8251 | 2020-03-22 | Natrona | Wyoming | 56025 | 1 | 0 |
| 8252 | 8252 | 2020-03-22 | Park | Wyoming | 56029 | 1 | 0 |
| 8253 | 8253 | 2020-03-22 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 8254 | 8254 | 2020-03-22 | Teton | Wyoming | 56039 | 2 | 0 |
| 9473 | 9473 | 2020-03-23 | Campbell | Wyoming | 56005 | 1 | 0 |
| 9474 | 9474 | 2020-03-23 | Carbon | Wyoming | 56007 | 2 | 0 |
| 9475 | 9475 | 2020-03-23 | Fremont | Wyoming | 56013 | 10 | 0 |
| 9476 | 9476 | 2020-03-23 | Laramie | Wyoming | 56021 | 7 | 0 |
| 9477 | 9477 | 2020-03-23 | Natrona | Wyoming | 56025 | 1 | 0 |
| 9478 | 9478 | 2020-03-23 | Park | Wyoming | 56029 | 1 | 0 |
| 9479 | 9479 | 2020-03-23 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 9480 | 9480 | 2020-03-23 | Teton | Wyoming | 56039 | 2 | 0 |
| 10827 | 10827 | 2020-03-24 | Campbell | Wyoming | 56005 | 1 | 0 |
| 10828 | 10828 | 2020-03-24 | Carbon | Wyoming | 56007 | 3 | 0 |
| 10829 | 10829 | 2020-03-24 | Fremont | Wyoming | 56013 | 12 | 0 |
| 10830 | 10830 | 2020-03-24 | Laramie | Wyoming | 56021 | 8 | 0 |
| 10831 | 10831 | 2020-03-24 | Natrona | Wyoming | 56025 | 4 | 0 |
| 10832 | 10832 | 2020-03-24 | Park | Wyoming | 56029 | 1 | 0 |
| 10833 | 10833 | 2020-03-24 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 10834 | 10834 | 2020-03-24 | Sweetwater | Wyoming | 56037 | 1 | 0 |
| 10835 | 10835 | 2020-03-24 | Teton | Wyoming | 56039 | 3 | 0 |
| 12358 | 12358 | 2020-03-25 | Albany | Wyoming | 56001 | 1 | 0 |
| 12359 | 12359 | 2020-03-25 | Campbell | Wyoming | 56005 | 1 | 0 |
| 12360 | 12360 | 2020-03-25 | Carbon | Wyoming | 56007 | 3 | 0 |
| 12361 | 12361 | 2020-03-25 | Fremont | Wyoming | 56013 | 14 | 0 |
| 12362 | 12362 | 2020-03-25 | Laramie | Wyoming | 56021 | 12 | 0 |
| 12363 | 12363 | 2020-03-25 | Natrona | Wyoming | 56025 | 6 | 0 |
| 12364 | 12364 | 2020-03-25 | Park | Wyoming | 56029 | 1 | 0 |
| 12365 | 12365 | 2020-03-25 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 12366 | 12366 | 2020-03-25 | Sweetwater | Wyoming | 56037 | 1 | 0 |
| 12367 | 12367 | 2020-03-25 | Teton | Wyoming | 56039 | 6 | 0 |
| 14014 | 14014 | 2020-03-26 | Albany | Wyoming | 56001 | 1 | 0 |
| 14015 | 14015 | 2020-03-26 | Campbell | Wyoming | 56005 | 1 | 0 |
| 14016 | 14016 | 2020-03-26 | Carbon | Wyoming | 56007 | 3 | 0 |
| 14017 | 14017 | 2020-03-26 | Fremont | Wyoming | 56013 | 14 | 0 |
| 14018 | 14018 | 2020-03-26 | Hot Springs | Wyoming | 56017 | 1 | 0 |
| 14019 | 14019 | 2020-03-26 | Johnson | Wyoming | 56019 | 1 | 0 |
| 14020 | 14020 | 2020-03-26 | Laramie | Wyoming | 56021 | 15 | 0 |
| 14021 | 14021 | 2020-03-26 | Natrona | Wyoming | 56025 | 6 | 0 |
| 14022 | 14022 | 2020-03-26 | Park | Wyoming | 56029 | 1 | 0 |
| 14023 | 14023 | 2020-03-26 | Sheridan | Wyoming | 56033 | 4 | 0 |
| 14024 | 14024 | 2020-03-26 | Sweetwater | Wyoming | 56037 | 1 | 0 |
| 14025 | 14025 | 2020-03-26 | Teton | Wyoming | 56039 | 8 | 0 |
| 15790 | 15790 | 2020-03-27 | Albany | Wyoming | 56001 | 1 | 0 |
| 15791 | 15791 | 2020-03-27 | Campbell | Wyoming | 56005 | 1 | 0 |
| 15792 | 15792 | 2020-03-27 | Carbon | Wyoming | 56007 | 3 | 0 |
| 15793 | 15793 | 2020-03-27 | Fremont | Wyoming | 56013 | 17 | 0 |
| 15794 | 15794 | 2020-03-27 | Goshen | Wyoming | 56015 | 1 | 0 |
| 15795 | 15795 | 2020-03-27 | Hot Springs | Wyoming | 56017 | 1 | 0 |
| 15796 | 15796 | 2020-03-27 | Johnson | Wyoming | 56019 | 4 | 0 |
| 15797 | 15797 | 2020-03-27 | Laramie | Wyoming | 56021 | 18 | 0 |
| 15798 | 15798 | 2020-03-27 | Natrona | Wyoming | 56025 | 8 | 0 |
| 15799 | 15799 | 2020-03-27 | Park | Wyoming | 56029 | 1 | 0 |
| 15800 | 15800 | 2020-03-27 | Sheridan | Wyoming | 56033 | 5 | 0 |
| 15801 | 15801 | 2020-03-27 | Sweetwater | Wyoming | 56037 | 1 | 0 |
| 15802 | 15802 | 2020-03-27 | Teton | Wyoming | 56039 | 12 | 0 |
| 15803 | 15803 | 2020-03-27 | Washakie | Wyoming | 56043 | 1 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );