latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
531 rows where fips = 7 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
18042 | 18042 | 2020-10-26 | Butte | 7 | 3095 | 52 | 8 | 0 |
18100 | 18100 | 2020-10-25 | Butte | 7 | 3087 | 52 | 9 | 0 |
18158 | 18158 | 2020-10-24 | Butte | 7 | 3078 | 52 | 19 | 0 |
18216 | 18216 | 2020-10-23 | Butte | 7 | 3059 | 52 | 13 | 0 |
18274 | 18274 | 2020-10-22 | Butte | 7 | 3046 | 52 | 5 | 1 |
18332 | 18332 | 2020-10-21 | Butte | 7 | 3041 | 51 | 14 | 0 |
18390 | 18390 | 2020-10-20 | Butte | 7 | 3027 | 51 | 1 | 0 |
18448 | 18448 | 2020-10-19 | Butte | 7 | 3026 | 51 | 7 | 1 |
18506 | 18506 | 2020-10-18 | Butte | 7 | 3019 | 50 | 7 | 0 |
18564 | 18564 | 2020-10-17 | Butte | 7 | 3012 | 50 | 8 | 0 |
18622 | 18622 | 2020-10-16 | Butte | 7 | 3004 | 50 | 4 | 0 |
18680 | 18680 | 2020-10-15 | Butte | 7 | 3000 | 50 | 5 | 0 |
18738 | 18738 | 2020-10-14 | Butte | 7 | 2995 | 50 | 3 | 2 |
18796 | 18796 | 2020-10-13 | Butte | 7 | 2992 | 48 | 17 | 0 |
18854 | 18854 | 2020-10-12 | Butte | 7 | 2975 | 48 | 8 | 0 |
18912 | 18912 | 2020-10-11 | Butte | 7 | 2967 | 48 | 5 | 0 |
18970 | 18970 | 2020-10-10 | Butte | 7 | 2962 | 48 | 6 | 0 |
19028 | 19028 | 2020-10-09 | Butte | 7 | 2956 | 48 | 21 | 3 |
19086 | 19086 | 2020-10-08 | Butte | 7 | 2935 | 45 | 8 | 0 |
19144 | 19144 | 2020-10-07 | Butte | 7 | 2927 | 45 | 2 | 0 |
19202 | 19202 | 2020-10-06 | Butte | 7 | 2925 | 45 | 15 | 0 |
19260 | 19260 | 2020-10-05 | Butte | 7 | 2910 | 45 | 7 | 0 |
19318 | 19318 | 2020-10-04 | Butte | 7 | 2903 | 45 | 9 | 0 |
19376 | 19376 | 2020-10-03 | Butte | 7 | 2894 | 45 | 15 | 0 |
19434 | 19434 | 2020-10-02 | Butte | 7 | 2879 | 45 | 14 | 0 |
19492 | 19492 | 2020-10-01 | Butte | 7 | 2865 | 45 | 7 | 0 |
19550 | 19550 | 2020-09-30 | Butte | 7 | 2858 | 45 | 10 | 1 |
19608 | 19608 | 2020-09-29 | Butte | 7 | 2848 | 44 | 11 | 0 |
19666 | 19666 | 2020-09-28 | Butte | 7 | 2837 | 44 | 4 | 0 |
19724 | 19724 | 2020-09-27 | Butte | 7 | 2833 | 44 | 6 | 0 |
19782 | 19782 | 2020-09-26 | Butte | 7 | 2827 | 44 | 8 | 0 |
19840 | 19840 | 2020-09-25 | Butte | 7 | 2819 | 44 | 16 | 1 |
19898 | 19898 | 2020-09-24 | Butte | 7 | 2803 | 43 | 13 | 0 |
19956 | 19956 | 2020-09-23 | Butte | 7 | 2790 | 43 | 14 | 3 |
20014 | 20014 | 2020-09-22 | Butte | 7 | 2776 | 40 | 7 | 0 |
20072 | 20072 | 2020-09-21 | Butte | 7 | 2769 | 40 | 5 | 5 |
20130 | 20130 | 2020-09-20 | Butte | 7 | 2764 | 35 | 16 | 0 |
20188 | 20188 | 2020-09-19 | Butte | 7 | 2748 | 35 | 10 | 0 |
20246 | 20246 | 2020-09-18 | Butte | 7 | 2738 | 35 | 18 | 2 |
20304 | 20304 | 2020-09-17 | Butte | 7 | 2720 | 33 | 16 | 0 |
20362 | 20362 | 2020-09-16 | Butte | 7 | 2704 | 33 | 9 | 2 |
20420 | 20420 | 2020-09-15 | Butte | 7 | 2695 | 31 | 53 | 3 |
20478 | 20478 | 2020-09-14 | Butte | 7 | 2642 | 28 | 2 | 0 |
20536 | 20536 | 2020-09-13 | Butte | 7 | 2640 | 28 | 11 | 0 |
20594 | 20594 | 2020-09-12 | Butte | 7 | 2629 | 28 | 24 | 0 |
20652 | 20652 | 2020-09-11 | Butte | 7 | 2605 | 28 | 15 | 0 |
20710 | 20710 | 2020-09-10 | Butte | 7 | 2590 | 28 | 29 | 0 |
20768 | 20768 | 2020-09-09 | Butte | 7 | 2561 | 28 | 108 | 0 |
20826 | 20826 | 2020-09-08 | Butte | 7 | 2453 | 28 | 3 | 5 |
20884 | 20884 | 2020-09-07 | Butte | 7 | 2450 | 23 | 4 | 0 |
20942 | 20942 | 2020-09-06 | Butte | 7 | 2446 | 23 | 40 | 0 |
21000 | 21000 | 2020-09-05 | Butte | 7 | 2406 | 23 | 81 | 0 |
21058 | 21058 | 2020-09-04 | Butte | 7 | 2325 | 23 | 51 | 0 |
21116 | 21116 | 2020-09-03 | Butte | 7 | 2274 | 23 | 33 | 0 |
21174 | 21174 | 2020-09-02 | Butte | 7 | 2241 | 23 | 95 | 0 |
21232 | 21232 | 2020-09-01 | Butte | 7 | 2146 | 23 | 77 | 0 |
21290 | 21290 | 2020-08-31 | Butte | 7 | 2069 | 23 | 81 | 0 |
21348 | 21348 | 2020-08-30 | Butte | 7 | 1988 | 23 | 40 | 0 |
21406 | 21406 | 2020-08-29 | Butte | 7 | 1948 | 23 | 62 | 0 |
21464 | 21464 | 2020-08-28 | Butte | 7 | 1886 | 23 | 83 | 2 |
21522 | 21522 | 2020-08-27 | Butte | 7 | 1803 | 21 | 38 | 0 |
21580 | 21580 | 2020-08-26 | Butte | 7 | 1765 | 21 | 47 | 3 |
21638 | 21638 | 2020-08-25 | Butte | 7 | 1718 | 18 | 69 | 0 |
21696 | 21696 | 2020-08-24 | Butte | 7 | 1649 | 18 | 12 | 1 |
21754 | 21754 | 2020-08-23 | Butte | 7 | 1637 | 17 | 19 | 0 |
21812 | 21812 | 2020-08-22 | Butte | 7 | 1618 | 17 | 36 | 0 |
21870 | 21870 | 2020-08-21 | Butte | 7 | 1582 | 17 | 33 | 0 |
21928 | 21928 | 2020-08-20 | Butte | 7 | 1549 | 17 | 32 | 3 |
21986 | 21986 | 2020-08-19 | Butte | 7 | 1517 | 14 | 26 | 0 |
22044 | 22044 | 2020-08-18 | Butte | 7 | 1491 | 14 | 28 | 2 |
22102 | 22102 | 2020-08-17 | Butte | 7 | 1463 | 12 | 31 | 0 |
22160 | 22160 | 2020-08-16 | Butte | 7 | 1432 | 12 | 23 | 0 |
22218 | 22218 | 2020-08-15 | Butte | 7 | 1409 | 12 | 25 | 0 |
22276 | 22276 | 2020-08-14 | Butte | 7 | 1384 | 12 | 39 | 0 |
22334 | 22334 | 2020-08-13 | Butte | 7 | 1345 | 12 | 28 | 4 |
22392 | 22392 | 2020-08-12 | Butte | 7 | 1317 | 8 | 21 | 0 |
22450 | 22450 | 2020-08-11 | Butte | 7 | 1296 | 8 | 122 | 0 |
22508 | 22508 | 2020-08-10 | Butte | 7 | 1174 | 8 | 19 | 0 |
22566 | 22566 | 2020-08-09 | Butte | 7 | 1155 | 8 | 15 | 0 |
22624 | 22624 | 2020-08-08 | Butte | 7 | 1140 | 8 | 48 | 0 |
22682 | 22682 | 2020-08-07 | Butte | 7 | 1092 | 8 | 32 | 0 |
22740 | 22740 | 2020-08-06 | Butte | 7 | 1060 | 8 | 22 | 0 |
22798 | 22798 | 2020-08-05 | Butte | 7 | 1038 | 8 | 27 | 0 |
22856 | 22856 | 2020-08-04 | Butte | 7 | 1011 | 8 | 22 | 1 |
22914 | 22914 | 2020-08-03 | Butte | 7 | 989 | 7 | 2 | 0 |
22972 | 22972 | 2020-08-02 | Butte | 7 | 987 | 7 | 11 | 0 |
23030 | 23030 | 2020-08-01 | Butte | 7 | 976 | 7 | 51 | 0 |
23088 | 23088 | 2020-07-31 | Butte | 7 | 925 | 7 | 10 | 0 |
23146 | 23146 | 2020-07-30 | Butte | 7 | 915 | 7 | 26 | 0 |
23204 | 23204 | 2020-07-29 | Butte | 7 | 889 | 7 | 32 | 0 |
23262 | 23262 | 2020-07-28 | Butte | 7 | 857 | 7 | 14 | 0 |
23320 | 23320 | 2020-07-27 | Butte | 7 | 843 | 7 | 21 | 2 |
23378 | 23378 | 2020-07-26 | Butte | 7 | 822 | 5 | 12 | 0 |
23436 | 23436 | 2020-07-25 | Butte | 7 | 810 | 5 | 59 | 0 |
23494 | 23494 | 2020-07-24 | Butte | 7 | 751 | 5 | 25 | 0 |
23552 | 23552 | 2020-07-23 | Butte | 7 | 726 | 5 | 32 | 0 |
23610 | 23610 | 2020-07-22 | Butte | 7 | 694 | 5 | 35 | 0 |
23668 | 23668 | 2020-07-21 | Butte | 7 | 659 | 5 | 73 | 0 |
23726 | 23726 | 2020-07-20 | Butte | 7 | 586 | 5 | 31 | 1 |
23784 | 23784 | 2020-07-19 | Butte | 7 | 555 | 4 | 4 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );