ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
704 rows where fips = 2100 and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531264 | 531264 | 2020-09-14 | Haines Borough | Alaska | 2100 | 9 | 0 |
528027 | 528027 | 2020-09-13 | Haines Borough | Alaska | 2100 | 9 | 0 |
524791 | 524791 | 2020-09-12 | Haines Borough | Alaska | 2100 | 9 | 0 |
521555 | 521555 | 2020-09-11 | Haines Borough | Alaska | 2100 | 9 | 0 |
518318 | 518318 | 2020-09-10 | Haines Borough | Alaska | 2100 | 9 | 0 |
515083 | 515083 | 2020-09-09 | Haines Borough | Alaska | 2100 | 9 | 0 |
511850 | 511850 | 2020-09-08 | Haines Borough | Alaska | 2100 | 9 | 0 |
508617 | 508617 | 2020-09-07 | Haines Borough | Alaska | 2100 | 9 | 0 |
505385 | 505385 | 2020-09-06 | Haines Borough | Alaska | 2100 | 9 | 0 |
502151 | 502151 | 2020-09-05 | Haines Borough | Alaska | 2100 | 9 | 0 |
498917 | 498917 | 2020-09-04 | Haines Borough | Alaska | 2100 | 9 | 0 |
495684 | 495684 | 2020-09-03 | Haines Borough | Alaska | 2100 | 9 | 0 |
492450 | 492450 | 2020-09-02 | Haines Borough | Alaska | 2100 | 9 | 0 |
489217 | 489217 | 2020-09-01 | Haines Borough | Alaska | 2100 | 10 | 0 |
485984 | 485984 | 2020-08-31 | Haines Borough | Alaska | 2100 | 10 | 0 |
482749 | 482749 | 2020-08-30 | Haines Borough | Alaska | 2100 | 10 | 0 |
479515 | 479515 | 2020-08-29 | Haines Borough | Alaska | 2100 | 10 | 0 |
476282 | 476282 | 2020-08-28 | Haines Borough | Alaska | 2100 | 10 | 0 |
473049 | 473049 | 2020-08-27 | Haines Borough | Alaska | 2100 | 10 | 0 |
469817 | 469817 | 2020-08-26 | Haines Borough | Alaska | 2100 | 10 | 0 |
466588 | 466588 | 2020-08-25 | Haines Borough | Alaska | 2100 | 10 | 0 |
463359 | 463359 | 2020-08-24 | Haines Borough | Alaska | 2100 | 10 | 0 |
460130 | 460130 | 2020-08-23 | Haines Borough | Alaska | 2100 | 10 | 0 |
456903 | 456903 | 2020-08-22 | Haines Borough | Alaska | 2100 | 10 | 0 |
453675 | 453675 | 2020-08-21 | Haines Borough | Alaska | 2100 | 10 | 0 |
450447 | 450447 | 2020-08-20 | Haines Borough | Alaska | 2100 | 10 | 0 |
447219 | 447219 | 2020-08-19 | Haines Borough | Alaska | 2100 | 10 | 0 |
443992 | 443992 | 2020-08-18 | Haines Borough | Alaska | 2100 | 10 | 0 |
440766 | 440766 | 2020-08-17 | Haines Borough | Alaska | 2100 | 10 | 0 |
437540 | 437540 | 2020-08-16 | Haines Borough | Alaska | 2100 | 10 | 0 |
434314 | 434314 | 2020-08-15 | Haines Borough | Alaska | 2100 | 10 | 0 |
431089 | 431089 | 2020-08-14 | Haines Borough | Alaska | 2100 | 10 | 0 |
427861 | 427861 | 2020-08-13 | Haines Borough | Alaska | 2100 | 9 | 0 |
424637 | 424637 | 2020-08-12 | Haines Borough | Alaska | 2100 | 9 | 0 |
421416 | 421416 | 2020-08-11 | Haines Borough | Alaska | 2100 | 8 | 0 |
418195 | 418195 | 2020-08-10 | Haines Borough | Alaska | 2100 | 8 | 0 |
414974 | 414974 | 2020-08-09 | Haines Borough | Alaska | 2100 | 8 | 0 |
411754 | 411754 | 2020-08-08 | Haines Borough | Alaska | 2100 | 8 | 0 |
408535 | 408535 | 2020-08-07 | Haines Borough | Alaska | 2100 | 8 | 0 |
405315 | 405315 | 2020-08-06 | Haines Borough | Alaska | 2100 | 8 | 0 |
402097 | 402097 | 2020-08-05 | Haines Borough | Alaska | 2100 | 8 | 0 |
398881 | 398881 | 2020-08-04 | Haines Borough | Alaska | 2100 | 8 | 0 |
395665 | 395665 | 2020-08-03 | Haines Borough | Alaska | 2100 | 8 | 0 |
392449 | 392449 | 2020-08-02 | Haines Borough | Alaska | 2100 | 8 | 0 |
389232 | 389232 | 2020-08-01 | Haines Borough | Alaska | 2100 | 8 | 0 |
386015 | 386015 | 2020-07-31 | Haines Borough | Alaska | 2100 | 8 | 0 |
382797 | 382797 | 2020-07-30 | Haines Borough | Alaska | 2100 | 8 | 0 |
379580 | 379580 | 2020-07-29 | Haines Borough | Alaska | 2100 | 8 | 0 |
376364 | 376364 | 2020-07-28 | Haines Borough | Alaska | 2100 | 8 | 0 |
373150 | 373150 | 2020-07-27 | Haines Borough | Alaska | 2100 | 8 | 0 |
369938 | 369938 | 2020-07-26 | Haines Borough | Alaska | 2100 | 8 | 0 |
366728 | 366728 | 2020-07-25 | Haines Borough | Alaska | 2100 | 8 | 0 |
363521 | 363521 | 2020-07-24 | Haines Borough | Alaska | 2100 | 7 | 0 |
360315 | 360315 | 2020-07-23 | Haines Borough | Alaska | 2100 | 7 | 0 |
357110 | 357110 | 2020-07-22 | Haines Borough | Alaska | 2100 | 7 | 0 |
353907 | 353907 | 2020-07-21 | Haines Borough | Alaska | 2100 | 7 | 0 |
350705 | 350705 | 2020-07-20 | Haines Borough | Alaska | 2100 | 7 | 0 |
347504 | 347504 | 2020-07-19 | Haines Borough | Alaska | 2100 | 7 | 0 |
344304 | 344304 | 2020-07-18 | Haines Borough | Alaska | 2100 | 7 | 0 |
341105 | 341105 | 2020-07-17 | Haines Borough | Alaska | 2100 | 7 | 0 |
337909 | 337909 | 2020-07-16 | Haines Borough | Alaska | 2100 | 7 | 0 |
334714 | 334714 | 2020-07-15 | Haines Borough | Alaska | 2100 | 6 | 0 |
331521 | 331521 | 2020-07-14 | Haines Borough | Alaska | 2100 | 6 | 0 |
328335 | 328335 | 2020-07-13 | Haines Borough | Alaska | 2100 | 6 | 0 |
325149 | 325149 | 2020-07-12 | Haines Borough | Alaska | 2100 | 6 | 0 |
321968 | 321968 | 2020-07-11 | Haines Borough | Alaska | 2100 | 6 | 0 |
318789 | 318789 | 2020-07-10 | Haines Borough | Alaska | 2100 | 6 | 0 |
315616 | 315616 | 2020-07-09 | Haines Borough | Alaska | 2100 | 6 | 0 |
312441 | 312441 | 2020-07-08 | Haines Borough | Alaska | 2100 | 6 | 0 |
309272 | 309272 | 2020-07-07 | Haines Borough | Alaska | 2100 | 6 | 0 |
306103 | 306103 | 2020-07-06 | Haines Borough | Alaska | 2100 | 6 | 0 |
302939 | 302939 | 2020-07-05 | Haines Borough | Alaska | 2100 | 6 | 0 |
299775 | 299775 | 2020-07-04 | Haines Borough | Alaska | 2100 | 6 | 0 |
296613 | 296613 | 2020-07-03 | Haines Borough | Alaska | 2100 | 6 | 0 |
293458 | 293458 | 2020-07-02 | Haines Borough | Alaska | 2100 | 6 | 0 |
290305 | 290305 | 2020-07-01 | Haines Borough | Alaska | 2100 | 5 | 0 |
287155 | 287155 | 2020-06-30 | Haines Borough | Alaska | 2100 | 5 | 0 |
284009 | 284009 | 2020-06-29 | Haines Borough | Alaska | 2100 | 5 | 0 |
280863 | 280863 | 2020-06-28 | Haines Borough | Alaska | 2100 | 5 | 0 |
277715 | 277715 | 2020-06-27 | Haines Borough | Alaska | 2100 | 5 | 0 |
274567 | 274567 | 2020-06-26 | Haines Borough | Alaska | 2100 | 5 | 0 |
271427 | 271427 | 2020-06-25 | Haines Borough | Alaska | 2100 | 5 | 0 |
268292 | 268292 | 2020-06-24 | Haines Borough | Alaska | 2100 | 5 | 0 |
265163 | 265163 | 2020-06-23 | Haines Borough | Alaska | 2100 | 5 | 0 |
262034 | 262034 | 2020-06-22 | Haines Borough | Alaska | 2100 | 5 | 0 |
258907 | 258907 | 2020-06-21 | Haines Borough | Alaska | 2100 | 2 | 0 |
255780 | 255780 | 2020-06-20 | Haines Borough | Alaska | 2100 | 2 | 0 |
252661 | 252661 | 2020-06-19 | Haines Borough | Alaska | 2100 | 2 | 0 |
249546 | 249546 | 2020-06-18 | Haines Borough | Alaska | 2100 | 1 | 0 |
246434 | 246434 | 2020-06-17 | Haines Borough | Alaska | 2100 | 1 | 0 |
243321 | 243321 | 2020-06-16 | Haines Borough | Alaska | 2100 | 1 | 0 |
240210 | 240210 | 2020-06-15 | Haines Borough | Alaska | 2100 | 1 | 0 |
237102 | 237102 | 2020-06-14 | Haines Borough | Alaska | 2100 | 1 | 0 |
233995 | 233995 | 2020-06-13 | Haines Borough | Alaska | 2100 | 1 | 0 |
230890 | 230890 | 2020-06-12 | Haines Borough | Alaska | 2100 | 1 | 0 |
227786 | 227786 | 2020-06-11 | Haines Borough | Alaska | 2100 | 1 | 0 |
224685 | 224685 | 2020-06-10 | Haines Borough | Alaska | 2100 | 1 | 0 |
221589 | 221589 | 2020-06-09 | Haines Borough | Alaska | 2100 | 1 | 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);