ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

33,184 rows where state = "Idaho" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • Idaho · 33,184 ✖
Link rowid date ▲ county state fips cases deaths
2500133 2500133 2022-05-13 Ada Idaho 16001 135259 1022
2500134 2500134 2022-05-13 Adams Idaho 16003 704 15
2500135 2500135 2022-05-13 Bannock Idaho 16005 20914 247
2500136 2500136 2022-05-13 Bear Lake Idaho 16007 931 16
2500137 2500137 2022-05-13 Benewah Idaho 16009 2397 41
2500138 2500138 2022-05-13 Bingham Idaho 16011 9836 154
2500139 2500139 2022-05-13 Blaine Idaho 16013 6059 30
2500140 2500140 2022-05-13 Boise Idaho 16015 1094 14
2500141 2500141 2022-05-13 Bonner Idaho 16017 8941 188
2500142 2500142 2022-05-13 Bonneville Idaho 16019 30942 286
2500143 2500143 2022-05-13 Boundary Idaho 16021 2107 62
2500144 2500144 2022-05-13 Butte Idaho 16023 475 9
2500145 2500145 2022-05-13 Camas Idaho 16025 158 2
2500146 2500146 2022-05-13 Canyon Idaho 16027 61709 685
2500147 2500147 2022-05-13 Caribou Idaho 16029 1495 28
2500148 2500148 2022-05-13 Cassia Idaho 16031 5032 52
2500149 2500149 2022-05-13 Clark Idaho 16033 109 1
2500150 2500150 2022-05-13 Clearwater Idaho 16035 2324 33
2500151 2500151 2022-05-13 Custer Idaho 16037 532 9
2500152 2500152 2022-05-13 Elmore Idaho 16039 7264 70
2500153 2500153 2022-05-13 Franklin Idaho 16041 2331 29
2500154 2500154 2022-05-13 Fremont Idaho 16043 2158 28
2500155 2500155 2022-05-13 Gem Idaho 16045 3681 79
2500156 2500156 2022-05-13 Gooding Idaho 16047 3297 55
2500157 2500157 2022-05-13 Idaho Idaho 16049 2998 52
2500158 2500158 2022-05-13 Jefferson Idaho 16051 6043 65
2500159 2500159 2022-05-13 Jerome Idaho 16053 6101 65
2500160 2500160 2022-05-13 Kootenai Idaho 16055 42145 594
2500161 2500161 2022-05-13 Latah Idaho 16057 6801 49
2500162 2500162 2022-05-13 Lemhi Idaho 16059 1261 25
2500163 2500163 2022-05-13 Lewis Idaho 16061 1134 29
2500164 2500164 2022-05-13 Lincoln Idaho 16063 1107 15
2500165 2500165 2022-05-13 Madison Idaho 16065 12674 50
2500166 2500166 2022-05-13 Minidoka Idaho 16067 4235 64
2500167 2500167 2022-05-13 Nez Perce Idaho 16069 8969 148
2500168 2500168 2022-05-13 Oneida Idaho 16071 807 11
2500169 2500169 2022-05-13 Owyhee Idaho 16073 2274 53
2500170 2500170 2022-05-13 Payette Idaho 16075 5586 87
2500171 2500171 2022-05-13 Power Idaho 16077 1496 20
2500172 2500172 2022-05-13 Shoshone Idaho 16079 2746 76
2500173 2500173 2022-05-13 Teton Idaho 16081 2723 9
2500174 2500174 2022-05-13 Twin Falls Idaho 16083 24129 296
2500175 2500175 2022-05-13 Valley Idaho 16085 2642 16
2500176 2500176 2022-05-13 Washington Idaho 16087 2394 57
2496875 2496875 2022-05-12 Ada Idaho 16001 135084 1021
2496876 2496876 2022-05-12 Adams Idaho 16003 703 15
2496877 2496877 2022-05-12 Bannock Idaho 16005 20906 247
2496878 2496878 2022-05-12 Bear Lake Idaho 16007 931 16
2496879 2496879 2022-05-12 Benewah Idaho 16009 2397 41
2496880 2496880 2022-05-12 Bingham Idaho 16011 9833 154
2496881 2496881 2022-05-12 Blaine Idaho 16013 6047 30
2496882 2496882 2022-05-12 Boise Idaho 16015 1093 14
2496883 2496883 2022-05-12 Bonner Idaho 16017 8934 188
2496884 2496884 2022-05-12 Bonneville Idaho 16019 30928 286
2496885 2496885 2022-05-12 Boundary Idaho 16021 2107 62
2496886 2496886 2022-05-12 Butte Idaho 16023 475 9
2496887 2496887 2022-05-12 Camas Idaho 16025 158 2
2496888 2496888 2022-05-12 Canyon Idaho 16027 61669 685
2496889 2496889 2022-05-12 Caribou Idaho 16029 1495 28
2496890 2496890 2022-05-12 Cassia Idaho 16031 5032 52
2496891 2496891 2022-05-12 Clark Idaho 16033 109 1
2496892 2496892 2022-05-12 Clearwater Idaho 16035 2323 33
2496893 2496893 2022-05-12 Custer Idaho 16037 531 9
2496894 2496894 2022-05-12 Elmore Idaho 16039 7257 70
2496895 2496895 2022-05-12 Franklin Idaho 16041 2330 29
2496896 2496896 2022-05-12 Fremont Idaho 16043 2158 28
2496897 2496897 2022-05-12 Gem Idaho 16045 3680 79
2496898 2496898 2022-05-12 Gooding Idaho 16047 3297 55
2496899 2496899 2022-05-12 Idaho Idaho 16049 2998 52
2496900 2496900 2022-05-12 Jefferson Idaho 16051 6042 65
2496901 2496901 2022-05-12 Jerome Idaho 16053 6098 65
2496902 2496902 2022-05-12 Kootenai Idaho 16055 42108 594
2496903 2496903 2022-05-12 Latah Idaho 16057 6787 48
2496904 2496904 2022-05-12 Lemhi Idaho 16059 1261 25
2496905 2496905 2022-05-12 Lewis Idaho 16061 1134 29
2496906 2496906 2022-05-12 Lincoln Idaho 16063 1107 15
2496907 2496907 2022-05-12 Madison Idaho 16065 12669 50
2496908 2496908 2022-05-12 Minidoka Idaho 16067 4234 64
2496909 2496909 2022-05-12 Nez Perce Idaho 16069 8967 148
2496910 2496910 2022-05-12 Oneida Idaho 16071 807 11
2496911 2496911 2022-05-12 Owyhee Idaho 16073 2274 53
2496912 2496912 2022-05-12 Payette Idaho 16075 5584 87
2496913 2496913 2022-05-12 Power Idaho 16077 1495 20
2496914 2496914 2022-05-12 Shoshone Idaho 16079 2745 76
2496915 2496915 2022-05-12 Teton Idaho 16081 2722 9
2496916 2496916 2022-05-12 Twin Falls Idaho 16083 24115 295
2496917 2496917 2022-05-12 Valley Idaho 16085 2638 16
2496918 2496918 2022-05-12 Washington Idaho 16087 2393 57
2493617 2493617 2022-05-11 Ada Idaho 16001 135084 1021
2493618 2493618 2022-05-11 Adams Idaho 16003 703 15
2493619 2493619 2022-05-11 Bannock Idaho 16005 20906 247
2493620 2493620 2022-05-11 Bear Lake Idaho 16007 931 16
2493621 2493621 2022-05-11 Benewah Idaho 16009 2397 41
2493622 2493622 2022-05-11 Bingham Idaho 16011 9831 154
2493623 2493623 2022-05-11 Blaine Idaho 16013 6047 30
2493624 2493624 2022-05-11 Boise Idaho 16015 1093 14
2493625 2493625 2022-05-11 Bonner Idaho 16017 8934 188
2493626 2493626 2022-05-11 Bonneville Idaho 16019 30928 286
2493627 2493627 2022-05-11 Boundary Idaho 16021 2107 62
2493628 2493628 2022-05-11 Butte Idaho 16023 475 9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);