ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
724 rows where county = "Bristol Bay plus Lake and Peninsula" and state = "Alaska" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
160342 | 160342 | 2020-05-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
163370 | 163370 | 2020-05-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
166402 | 166402 | 2020-05-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
169438 | 169438 | 2020-05-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
172479 | 172479 | 2020-05-24 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
175522 | 175522 | 2020-05-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
178567 | 178567 | 2020-05-26 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
181611 | 181611 | 2020-05-27 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
184663 | 184663 | 2020-05-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
187720 | 187720 | 2020-05-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
190784 | 190784 | 2020-05-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
193850 | 193850 | 2020-05-31 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
196920 | 196920 | 2020-06-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
199993 | 199993 | 2020-06-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
203069 | 203069 | 2020-06-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
206149 | 206149 | 2020-06-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 1 | 0 |
209231 | 209231 | 2020-06-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 3 | 0 |
212316 | 212316 | 2020-06-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 3 | 0 |
215403 | 215403 | 2020-06-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 3 | 0 |
218493 | 218493 | 2020-06-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 3 | 0 |
221586 | 221586 | 2020-06-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 3 | 0 |
224682 | 224682 | 2020-06-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 4 | 0 |
227783 | 227783 | 2020-06-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 4 | 0 |
230887 | 230887 | 2020-06-12 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 5 | 0 |
233992 | 233992 | 2020-06-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 5 | 0 |
237099 | 237099 | 2020-06-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 6 | 0 |
240207 | 240207 | 2020-06-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 6 | 0 |
243318 | 243318 | 2020-06-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 6 | 0 |
246431 | 246431 | 2020-06-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 6 | 0 |
249543 | 249543 | 2020-06-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 7 | 0 |
252658 | 252658 | 2020-06-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 7 | 0 |
255777 | 255777 | 2020-06-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 15 | 0 |
258904 | 258904 | 2020-06-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 16 | 0 |
262031 | 262031 | 2020-06-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 16 | 0 |
265160 | 265160 | 2020-06-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 16 | 0 |
268289 | 268289 | 2020-06-24 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 10 | 0 |
271423 | 271423 | 2020-06-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 11 | 0 |
274563 | 274563 | 2020-06-26 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 30 | 0 |
277711 | 277711 | 2020-06-27 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 31 | 0 |
280859 | 280859 | 2020-06-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 35 | 0 |
284005 | 284005 | 2020-06-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 35 | 0 |
287151 | 287151 | 2020-06-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 40 | 0 |
290301 | 290301 | 2020-07-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 40 | 0 |
293454 | 293454 | 2020-07-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 29 | 0 |
296609 | 296609 | 2020-07-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 44 | 0 |
299771 | 299771 | 2020-07-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 44 | 0 |
302935 | 302935 | 2020-07-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 44 | 0 |
306099 | 306099 | 2020-07-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 44 | 0 |
309268 | 309268 | 2020-07-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 52 | 0 |
312437 | 312437 | 2020-07-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 52 | 0 |
315612 | 315612 | 2020-07-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 52 | 0 |
318785 | 318785 | 2020-07-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 56 | 0 |
321964 | 321964 | 2020-07-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 56 | 0 |
325145 | 325145 | 2020-07-12 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 56 | 0 |
328331 | 328331 | 2020-07-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 56 | 0 |
331517 | 331517 | 2020-07-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 62 | 0 |
334710 | 334710 | 2020-07-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 66 | 0 |
337905 | 337905 | 2020-07-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 66 | 0 |
341101 | 341101 | 2020-07-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 66 | 0 |
344300 | 344300 | 2020-07-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 66 | 0 |
347500 | 347500 | 2020-07-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 66 | 0 |
350701 | 350701 | 2020-07-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 67 | 0 |
353903 | 353903 | 2020-07-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
357106 | 357106 | 2020-07-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
360311 | 360311 | 2020-07-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
363517 | 363517 | 2020-07-24 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
366724 | 366724 | 2020-07-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
369934 | 369934 | 2020-07-26 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
373146 | 373146 | 2020-07-27 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
376360 | 376360 | 2020-07-28 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
379576 | 379576 | 2020-07-29 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
382793 | 382793 | 2020-07-30 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
386011 | 386011 | 2020-07-31 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 68 | 0 |
389228 | 389228 | 2020-08-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 71 | 0 |
392445 | 392445 | 2020-08-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 71 | 0 |
395661 | 395661 | 2020-08-03 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 71 | 0 |
398877 | 398877 | 2020-08-04 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 71 | 0 |
402093 | 402093 | 2020-08-05 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 73 | 0 |
405311 | 405311 | 2020-08-06 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 73 | 0 |
408531 | 408531 | 2020-08-07 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 75 | 0 |
411750 | 411750 | 2020-08-08 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 75 | 0 |
414970 | 414970 | 2020-08-09 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
418191 | 418191 | 2020-08-10 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
421412 | 421412 | 2020-08-11 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
424633 | 424633 | 2020-08-12 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 75 | 0 |
427857 | 427857 | 2020-08-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
431085 | 431085 | 2020-08-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
434310 | 434310 | 2020-08-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
437536 | 437536 | 2020-08-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
440762 | 440762 | 2020-08-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
443988 | 443988 | 2020-08-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
447215 | 447215 | 2020-08-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
450443 | 450443 | 2020-08-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
453671 | 453671 | 2020-08-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
456899 | 456899 | 2020-08-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
460126 | 460126 | 2020-08-23 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
463355 | 463355 | 2020-08-24 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
466584 | 466584 | 2020-08-25 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
469813 | 469813 | 2020-08-26 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
473045 | 473045 | 2020-08-27 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 76 | 0 |
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);