ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 16027 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5397 | 5397 | 2020-03-20 | Canyon | Idaho | 16027 | 1 | 0 |
6331 | 6331 | 2020-03-21 | Canyon | Idaho | 16027 | 1 | 0 |
7379 | 7379 | 2020-03-22 | Canyon | Idaho | 16027 | 3 | 0 |
8534 | 8534 | 2020-03-23 | Canyon | Idaho | 16027 | 4 | 0 |
9796 | 9796 | 2020-03-24 | Canyon | Idaho | 16027 | 5 | 0 |
11181 | 11181 | 2020-03-25 | Canyon | Idaho | 16027 | 8 | 0 |
12734 | 12734 | 2020-03-26 | Canyon | Idaho | 16027 | 22 | 1 |
14409 | 14409 | 2020-03-27 | Canyon | Idaho | 16027 | 23 | 1 |
16201 | 16201 | 2020-03-28 | Canyon | Idaho | 16027 | 22 | 1 |
18098 | 18098 | 2020-03-29 | Canyon | Idaho | 16027 | 40 | 1 |
20095 | 20095 | 2020-03-30 | Canyon | Idaho | 16027 | 48 | 1 |
22186 | 22186 | 2020-03-31 | Canyon | Idaho | 16027 | 53 | 1 |
24352 | 24352 | 2020-04-01 | Canyon | Idaho | 16027 | 68 | 1 |
26584 | 26584 | 2020-04-02 | Canyon | Idaho | 16027 | 79 | 1 |
28891 | 28891 | 2020-04-03 | Canyon | Idaho | 16027 | 89 | 1 |
31252 | 31252 | 2020-04-04 | Canyon | Idaho | 16027 | 99 | 1 |
33659 | 33659 | 2020-04-05 | Canyon | Idaho | 16027 | 101 | 1 |
36110 | 36110 | 2020-04-06 | Canyon | Idaho | 16027 | 104 | 3 |
38603 | 38603 | 2020-04-07 | Canyon | Idaho | 16027 | 114 | 3 |
41147 | 41147 | 2020-04-08 | Canyon | Idaho | 16027 | 121 | 3 |
43721 | 43721 | 2020-04-09 | Canyon | Idaho | 16027 | 139 | 4 |
46323 | 46323 | 2020-04-10 | Canyon | Idaho | 16027 | 145 | 5 |
48954 | 48954 | 2020-04-11 | Canyon | Idaho | 16027 | 146 | 5 |
51616 | 51616 | 2020-04-12 | Canyon | Idaho | 16027 | 155 | 5 |
54296 | 54296 | 2020-04-13 | Canyon | Idaho | 16027 | 161 | 5 |
56988 | 56988 | 2020-04-14 | Canyon | Idaho | 16027 | 169 | 5 |
59695 | 59695 | 2020-04-15 | Canyon | Idaho | 16027 | 181 | 5 |
62415 | 62415 | 2020-04-16 | Canyon | Idaho | 16027 | 181 | 5 |
65147 | 65147 | 2020-04-17 | Canyon | Idaho | 16027 | 187 | 5 |
67895 | 67895 | 2020-04-18 | Canyon | Idaho | 16027 | 187 | 5 |
70657 | 70657 | 2020-04-19 | Canyon | Idaho | 16027 | 187 | 5 |
73426 | 73426 | 2020-04-20 | Canyon | Idaho | 16027 | 207 | 5 |
76202 | 76202 | 2020-04-21 | Canyon | Idaho | 16027 | 212 | 6 |
78986 | 78986 | 2020-04-22 | Canyon | Idaho | 16027 | 215 | 6 |
81779 | 81779 | 2020-04-23 | Canyon | Idaho | 16027 | 222 | 6 |
84579 | 84579 | 2020-04-24 | Canyon | Idaho | 16027 | 226 | 6 |
87388 | 87388 | 2020-04-25 | Canyon | Idaho | 16027 | 231 | 6 |
90204 | 90204 | 2020-04-26 | Canyon | Idaho | 16027 | 233 | 6 |
93023 | 93023 | 2020-04-27 | Canyon | Idaho | 16027 | 238 | 6 |
95855 | 95855 | 2020-04-28 | Canyon | Idaho | 16027 | 250 | 6 |
98699 | 98699 | 2020-04-29 | Canyon | Idaho | 16027 | 252 | 6 |
101550 | 101550 | 2020-04-30 | Canyon | Idaho | 16027 | 255 | 7 |
104405 | 104405 | 2020-05-01 | Canyon | Idaho | 16027 | 259 | 7 |
107270 | 107270 | 2020-05-02 | Canyon | Idaho | 16027 | 258 | 7 |
110140 | 110140 | 2020-05-03 | Canyon | Idaho | 16027 | 258 | 7 |
113015 | 113015 | 2020-05-04 | Canyon | Idaho | 16027 | 266 | 7 |
115898 | 115898 | 2020-05-05 | Canyon | Idaho | 16027 | 266 | 7 |
118858 | 118858 | 2020-05-06 | Canyon | Idaho | 16027 | 270 | 7 |
121828 | 121828 | 2020-05-07 | Canyon | Idaho | 16027 | 272 | 6 |
124807 | 124807 | 2020-05-08 | Canyon | Idaho | 16027 | 272 | 6 |
127794 | 127794 | 2020-05-09 | Canyon | Idaho | 16027 | 272 | 6 |
130785 | 130785 | 2020-05-10 | Canyon | Idaho | 16027 | 272 | 6 |
133776 | 133776 | 2020-05-11 | Canyon | Idaho | 16027 | 274 | 6 |
136765 | 136765 | 2020-05-12 | Canyon | Idaho | 16027 | 274 | 6 |
139756 | 139756 | 2020-05-13 | Canyon | Idaho | 16027 | 275 | 6 |
142752 | 142752 | 2020-05-14 | Canyon | Idaho | 16027 | 276 | 6 |
145752 | 145752 | 2020-05-15 | Canyon | Idaho | 16027 | 277 | 6 |
148755 | 148755 | 2020-05-16 | Canyon | Idaho | 16027 | 277 | 6 |
151764 | 151764 | 2020-05-17 | Canyon | Idaho | 16027 | 277 | 6 |
154776 | 154776 | 2020-05-18 | Canyon | Idaho | 16027 | 276 | 6 |
157792 | 157792 | 2020-05-19 | Canyon | Idaho | 16027 | 280 | 6 |
160818 | 160818 | 2020-05-20 | Canyon | Idaho | 16027 | 280 | 6 |
163846 | 163846 | 2020-05-21 | Canyon | Idaho | 16027 | 283 | 6 |
166879 | 166879 | 2020-05-22 | Canyon | Idaho | 16027 | 284 | 6 |
169916 | 169916 | 2020-05-23 | Canyon | Idaho | 16027 | 284 | 6 |
172957 | 172957 | 2020-05-24 | Canyon | Idaho | 16027 | 284 | 6 |
176001 | 176001 | 2020-05-25 | Canyon | Idaho | 16027 | 284 | 6 |
179045 | 179045 | 2020-05-26 | Canyon | Idaho | 16027 | 287 | 6 |
182089 | 182089 | 2020-05-27 | Canyon | Idaho | 16027 | 291 | 6 |
185143 | 185143 | 2020-05-28 | Canyon | Idaho | 16027 | 294 | 6 |
188199 | 188199 | 2020-05-29 | Canyon | Idaho | 16027 | 300 | 6 |
191264 | 191264 | 2020-05-30 | Canyon | Idaho | 16027 | 303 | 6 |
194331 | 194331 | 2020-05-31 | Canyon | Idaho | 16027 | 303 | 6 |
197401 | 197401 | 2020-06-01 | Canyon | Idaho | 16027 | 310 | 6 |
200474 | 200474 | 2020-06-02 | Canyon | Idaho | 16027 | 310 | 6 |
203550 | 203550 | 2020-06-03 | Canyon | Idaho | 16027 | 315 | 6 |
206630 | 206630 | 2020-06-04 | Canyon | Idaho | 16027 | 322 | 6 |
209711 | 209711 | 2020-06-05 | Canyon | Idaho | 16027 | 336 | 6 |
212796 | 212796 | 2020-06-06 | Canyon | Idaho | 16027 | 340 | 6 |
215883 | 215883 | 2020-06-07 | Canyon | Idaho | 16027 | 340 | 6 |
218974 | 218974 | 2020-06-08 | Canyon | Idaho | 16027 | 345 | 6 |
222069 | 222069 | 2020-06-09 | Canyon | Idaho | 16027 | 345 | 6 |
225164 | 225164 | 2020-06-10 | Canyon | Idaho | 16027 | 351 | 6 |
228266 | 228266 | 2020-06-11 | Canyon | Idaho | 16027 | 354 | 6 |
231369 | 231369 | 2020-06-12 | Canyon | Idaho | 16027 | 356 | 6 |
234475 | 234475 | 2020-06-13 | Canyon | Idaho | 16027 | 356 | 6 |
237582 | 237582 | 2020-06-14 | Canyon | Idaho | 16027 | 356 | 6 |
240690 | 240690 | 2020-06-15 | Canyon | Idaho | 16027 | 360 | 6 |
243801 | 243801 | 2020-06-16 | Canyon | Idaho | 16027 | 367 | 6 |
246914 | 246914 | 2020-06-17 | Canyon | Idaho | 16027 | 369 | 6 |
250026 | 250026 | 2020-06-18 | Canyon | Idaho | 16027 | 376 | 6 |
253141 | 253141 | 2020-06-19 | Canyon | Idaho | 16027 | 403 | 6 |
256260 | 256260 | 2020-06-20 | Canyon | Idaho | 16027 | 433 | 6 |
259387 | 259387 | 2020-06-21 | Canyon | Idaho | 16027 | 433 | 6 |
262514 | 262514 | 2020-06-22 | Canyon | Idaho | 16027 | 470 | 6 |
265642 | 265642 | 2020-06-23 | Canyon | Idaho | 16027 | 494 | 6 |
268772 | 268772 | 2020-06-24 | Canyon | Idaho | 16027 | 546 | 6 |
271909 | 271909 | 2020-06-25 | Canyon | Idaho | 16027 | 601 | 6 |
275050 | 275050 | 2020-06-26 | Canyon | Idaho | 16027 | 652 | 6 |
278198 | 278198 | 2020-06-27 | Canyon | Idaho | 16027 | 692 | 6 |
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);