ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Anchorage" and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631709 | 631709 | 2020-10-15 | Anchorage | Alaska | 2020 | 5966 | 41 |
628465 | 628465 | 2020-10-14 | Anchorage | Alaska | 2020 | 5877 | 41 |
625222 | 625222 | 2020-10-13 | Anchorage | Alaska | 2020 | 5775 | 38 |
621979 | 621979 | 2020-10-12 | Anchorage | Alaska | 2020 | 5704 | 38 |
618736 | 618736 | 2020-10-11 | Anchorage | Alaska | 2020 | 5594 | 38 |
615494 | 615494 | 2020-10-10 | Anchorage | Alaska | 2020 | 5456 | 38 |
612253 | 612253 | 2020-10-09 | Anchorage | Alaska | 2020 | 5309 | 38 |
609011 | 609011 | 2020-10-08 | Anchorage | Alaska | 2020 | 5223 | 38 |
605768 | 605768 | 2020-10-07 | Anchorage | Alaska | 2020 | 5166 | 37 |
602526 | 602526 | 2020-10-06 | Anchorage | Alaska | 2020 | 5098 | 36 |
599283 | 599283 | 2020-10-05 | Anchorage | Alaska | 2020 | 5030 | 36 |
596040 | 596040 | 2020-10-04 | Anchorage | Alaska | 2020 | 4910 | 36 |
592798 | 592798 | 2020-10-03 | Anchorage | Alaska | 2020 | 4784 | 36 |
589558 | 589558 | 2020-10-02 | Anchorage | Alaska | 2020 | 4699 | 36 |
586317 | 586317 | 2020-10-01 | Anchorage | Alaska | 2020 | 4641 | 36 |
583077 | 583077 | 2020-09-30 | Anchorage | Alaska | 2020 | 4580 | 35 |
579838 | 579838 | 2020-09-29 | Anchorage | Alaska | 2020 | 4517 | 35 |
576597 | 576597 | 2020-09-28 | Anchorage | Alaska | 2020 | 4441 | 35 |
573353 | 573353 | 2020-09-27 | Anchorage | Alaska | 2020 | 4354 | 35 |
570111 | 570111 | 2020-09-26 | Anchorage | Alaska | 2020 | 4290 | 31 |
566870 | 566870 | 2020-09-25 | Anchorage | Alaska | 2020 | 4224 | 31 |
563629 | 563629 | 2020-09-24 | Anchorage | Alaska | 2020 | 4157 | 28 |
560390 | 560390 | 2020-09-23 | Anchorage | Alaska | 2020 | 4079 | 28 |
557154 | 557154 | 2020-09-22 | Anchorage | Alaska | 2020 | 4056 | 28 |
553917 | 553917 | 2020-09-21 | Anchorage | Alaska | 2020 | 4021 | 28 |
550678 | 550678 | 2020-09-20 | Anchorage | Alaska | 2020 | 3982 | 28 |
547439 | 547439 | 2020-09-19 | Anchorage | Alaska | 2020 | 3948 | 28 |
544202 | 544202 | 2020-09-18 | Anchorage | Alaska | 2020 | 3893 | 28 |
540966 | 540966 | 2020-09-17 | Anchorage | Alaska | 2020 | 3823 | 27 |
537729 | 537729 | 2020-09-16 | Anchorage | Alaska | 2020 | 3776 | 27 |
534493 | 534493 | 2020-09-15 | Anchorage | Alaska | 2020 | 3755 | 27 |
531258 | 531258 | 2020-09-14 | Anchorage | Alaska | 2020 | 3735 | 27 |
528021 | 528021 | 2020-09-13 | Anchorage | Alaska | 2020 | 3688 | 27 |
524785 | 524785 | 2020-09-12 | Anchorage | Alaska | 2020 | 3659 | 27 |
521549 | 521549 | 2020-09-11 | Anchorage | Alaska | 2020 | 3594 | 26 |
518312 | 518312 | 2020-09-10 | Anchorage | Alaska | 2020 | 3551 | 25 |
515077 | 515077 | 2020-09-09 | Anchorage | Alaska | 2020 | 3486 | 25 |
511844 | 511844 | 2020-09-08 | Anchorage | Alaska | 2020 | 3454 | 25 |
508611 | 508611 | 2020-09-07 | Anchorage | Alaska | 2020 | 3438 | 25 |
505379 | 505379 | 2020-09-06 | Anchorage | Alaska | 2020 | 3425 | 25 |
502145 | 502145 | 2020-09-05 | Anchorage | Alaska | 2020 | 3386 | 25 |
498911 | 498911 | 2020-09-04 | Anchorage | Alaska | 2020 | 3327 | 24 |
495678 | 495678 | 2020-09-03 | Anchorage | Alaska | 2020 | 3243 | 24 |
492444 | 492444 | 2020-09-02 | Anchorage | Alaska | 2020 | 3187 | 23 |
489211 | 489211 | 2020-09-01 | Anchorage | Alaska | 2020 | 3156 | 23 |
485978 | 485978 | 2020-08-31 | Anchorage | Alaska | 2020 | 3139 | 21 |
482743 | 482743 | 2020-08-30 | Anchorage | Alaska | 2020 | 3109 | 21 |
479509 | 479509 | 2020-08-29 | Anchorage | Alaska | 2020 | 3099 | 21 |
476276 | 476276 | 2020-08-28 | Anchorage | Alaska | 2020 | 3015 | 21 |
473043 | 473043 | 2020-08-27 | Anchorage | Alaska | 2020 | 2934 | 21 |
469811 | 469811 | 2020-08-26 | Anchorage | Alaska | 2020 | 2890 | 21 |
466582 | 466582 | 2020-08-25 | Anchorage | Alaska | 2020 | 2865 | 20 |
463353 | 463353 | 2020-08-24 | Anchorage | Alaska | 2020 | 2877 | 16 |
460124 | 460124 | 2020-08-23 | Anchorage | Alaska | 2020 | 2834 | 16 |
456897 | 456897 | 2020-08-22 | Anchorage | Alaska | 2020 | 2804 | 16 |
453669 | 453669 | 2020-08-21 | Anchorage | Alaska | 2020 | 2760 | 16 |
450441 | 450441 | 2020-08-20 | Anchorage | Alaska | 2020 | 2729 | 16 |
447213 | 447213 | 2020-08-19 | Anchorage | Alaska | 2020 | 2687 | 16 |
443986 | 443986 | 2020-08-18 | Anchorage | Alaska | 2020 | 2655 | 16 |
440760 | 440760 | 2020-08-17 | Anchorage | Alaska | 2020 | 2633 | 15 |
437534 | 437534 | 2020-08-16 | Anchorage | Alaska | 2020 | 2597 | 15 |
434308 | 434308 | 2020-08-15 | Anchorage | Alaska | 2020 | 2544 | 15 |
431083 | 431083 | 2020-08-14 | Anchorage | Alaska | 2020 | 2509 | 14 |
427855 | 427855 | 2020-08-13 | Anchorage | Alaska | 2020 | 2425 | 14 |
424631 | 424631 | 2020-08-12 | Anchorage | Alaska | 2020 | 2395 | 14 |
421410 | 421410 | 2020-08-11 | Anchorage | Alaska | 2020 | 2353 | 14 |
418189 | 418189 | 2020-08-10 | Anchorage | Alaska | 2020 | 2329 | 14 |
414968 | 414968 | 2020-08-09 | Anchorage | Alaska | 2020 | 2290 | 14 |
411748 | 411748 | 2020-08-08 | Anchorage | Alaska | 2020 | 2231 | 14 |
408529 | 408529 | 2020-08-07 | Anchorage | Alaska | 2020 | 2173 | 13 |
405309 | 405309 | 2020-08-06 | Anchorage | Alaska | 2020 | 2145 | 13 |
402091 | 402091 | 2020-08-05 | Anchorage | Alaska | 2020 | 2122 | 13 |
398875 | 398875 | 2020-08-04 | Anchorage | Alaska | 2020 | 2083 | 13 |
395659 | 395659 | 2020-08-03 | Anchorage | Alaska | 2020 | 2042 | 13 |
392443 | 392443 | 2020-08-02 | Anchorage | Alaska | 2020 | 1999 | 12 |
389226 | 389226 | 2020-08-01 | Anchorage | Alaska | 2020 | 1890 | 12 |
386009 | 386009 | 2020-07-31 | Anchorage | Alaska | 2020 | 1779 | 11 |
382791 | 382791 | 2020-07-30 | Anchorage | Alaska | 2020 | 1696 | 10 |
379574 | 379574 | 2020-07-29 | Anchorage | Alaska | 2020 | 1653 | 9 |
376358 | 376358 | 2020-07-28 | Anchorage | Alaska | 2020 | 1601 | 9 |
373144 | 373144 | 2020-07-27 | Anchorage | Alaska | 2020 | 1513 | 9 |
369932 | 369932 | 2020-07-26 | Anchorage | Alaska | 2020 | 1448 | 9 |
366722 | 366722 | 2020-07-25 | Anchorage | Alaska | 2020 | 1290 | 9 |
363515 | 363515 | 2020-07-24 | Anchorage | Alaska | 2020 | 1238 | 9 |
360309 | 360309 | 2020-07-23 | Anchorage | Alaska | 2020 | 1207 | 9 |
357104 | 357104 | 2020-07-22 | Anchorage | Alaska | 2020 | 1176 | 9 |
353901 | 353901 | 2020-07-21 | Anchorage | Alaska | 2020 | 1133 | 9 |
350699 | 350699 | 2020-07-20 | Anchorage | Alaska | 2020 | 1064 | 9 |
347498 | 347498 | 2020-07-19 | Anchorage | Alaska | 2020 | 1006 | 9 |
344298 | 344298 | 2020-07-18 | Anchorage | Alaska | 2020 | 967 | 9 |
341099 | 341099 | 2020-07-17 | Anchorage | Alaska | 2020 | 930 | 8 |
337903 | 337903 | 2020-07-16 | Anchorage | Alaska | 2020 | 902 | 8 |
334708 | 334708 | 2020-07-15 | Anchorage | Alaska | 2020 | 876 | 8 |
331515 | 331515 | 2020-07-14 | Anchorage | Alaska | 2020 | 840 | 8 |
328329 | 328329 | 2020-07-13 | Anchorage | Alaska | 2020 | 812 | 8 |
325143 | 325143 | 2020-07-12 | Anchorage | Alaska | 2020 | 768 | 8 |
321962 | 321962 | 2020-07-11 | Anchorage | Alaska | 2020 | 733 | 8 |
318783 | 318783 | 2020-07-10 | Anchorage | Alaska | 2020 | 698 | 8 |
315610 | 315610 | 2020-07-09 | Anchorage | Alaska | 2020 | 675 | 8 |
312435 | 312435 | 2020-07-08 | Anchorage | Alaska | 2020 | 654 | 8 |
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);