latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where county = "Shasta" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date ▼ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
33016 | 33016 | Shasta | Shasta | 89 | 2020-01-26 | 0 | 0 | |
32980 | 32980 | Shasta | Shasta | 89 | 2020-01-31 | 0 | 0 | |
32953 | 32953 | Shasta | Shasta | 89 | 2020-02-02 | 0 | 0 | |
32861 | 32861 | Shasta | Shasta | 89 | 2020-02-20 | 0 | 0 | |
32837 | 32837 | Shasta | Shasta | 89 | 2020-02-21 | 0 | 0 | |
32789 | 32789 | Shasta | Shasta | 89 | 2020-02-26 | 0 | 0 | |
32756 | 32756 | Shasta | Shasta | 89 | 2020-02-28 | 0 | 0 | |
32731 | 32731 | Shasta | Shasta | 89 | 2020-02-29 | 0 | 0 | |
32706 | 32706 | Shasta | Shasta | 89 | 2020-03-01 | 0 | 0 | |
32680 | 32680 | Shasta | Shasta | 89 | 2020-03-02 | 0 | 0 | |
32654 | 32654 | Shasta | Shasta | 89 | 2020-03-03 | 0 | 0 | |
32628 | 32628 | Shasta | Shasta | 89 | 2020-03-04 | 0 | 0 | |
32602 | 32602 | Shasta | Shasta | 89 | 2020-03-05 | 0 | 0 | |
32576 | 32576 | Shasta | Shasta | 89 | 2020-03-06 | 0 | 0 | |
32550 | 32550 | Shasta | Shasta | 89 | 2020-03-07 | 0 | 0 | |
32523 | 32523 | Shasta | Shasta | 89 | 2020-03-08 | 1 | 0 | |
32496 | 32496 | Shasta | Shasta | 89 | 2020-03-09 | 1 | 0 | |
32469 | 32469 | Shasta | Shasta | 89 | 2020-03-10 | 1 | 0 | |
32441 | 32441 | Shasta | Shasta | 89 | 2020-03-11 | 1 | 0 | |
32411 | 32411 | Shasta | Shasta | 89 | 2020-03-12 | 1 | 0 | |
32381 | 32381 | Shasta | Shasta | 89 | 2020-03-13 | 1 | 0 | |
32350 | 32350 | Shasta | Shasta | 89 | 2020-03-14 | 1 | 0 | |
32318 | 32318 | Shasta | Shasta | 89 | 2020-03-15 | 1 | 0 | |
32284 | 32284 | Shasta | Shasta | 89 | 2020-03-16 | 1 | 0 | |
32249 | 32249 | Shasta | Shasta | 89 | 2020-03-17 | 1 | 0 | |
32212 | 32212 | Shasta | Shasta | 89 | 2020-03-18 | 1 | 0 | |
32174 | 32174 | Shasta | Shasta | 89 | 2020-03-19 | 1 | 0 | |
32136 | 32136 | Shasta | Shasta | 89 | 2020-03-20 | 1 | 0 | |
32095 | 32095 | Shasta | Shasta | 89 | 2020-03-21 | 1 | 0 | |
32052 | 32052 | Shasta | Shasta | 89 | 2020-03-22 | 2 | 0 | |
32007 | 32007 | Shasta | Shasta | 89 | 2020-03-23 | 3 | 0 | |
31962 | 31962 | Shasta | Shasta | 89 | 2020-03-24 | 3 | 0 | |
31916 | 31916 | Shasta | Shasta | 89 | 2020-03-25 | 3 | 1 | |
31869 | 31869 | Shasta | Shasta | 89 | 2020-03-26 | 3 | 1 | TRUE |
31822 | 31822 | Shasta | Shasta | 89 | 2020-03-27 | 3 | 1 | |
31772 | 31772 | Shasta | Shasta | 89 | 2020-03-28 | 4 | 1 | |
31722 | 31722 | Shasta | Shasta | 89 | 2020-03-29 | 4 | 1 | TRUE |
31671 | 31671 | Shasta | Shasta | 89 | 2020-03-30 | 6 | 1 | |
31619 | 31619 | Shasta | Shasta | 89 | 2020-03-31 | 7 | 1 | |
31565 | 31565 | Shasta | Shasta | 89 | 2020-04-01 | 7 | 1 | |
31511 | 31511 | Shasta | Shasta | 89 | 2020-04-02 | 11 | 1 | |
31456 | 31456 | Shasta | Shasta | 89 | 2020-04-03 | 12 | 2 | |
31401 | 31401 | Shasta | Shasta | 89 | 2020-04-04 | 17 | 2 | |
31346 | 31346 | Shasta | Shasta | 89 | 2020-04-05 | 20 | 3 | |
31290 | 31290 | Shasta | Shasta | 89 | 2020-04-06 | 21 | 3 | |
31234 | 31234 | Shasta | Shasta | 89 | 2020-04-07 | 23 | 3 | |
31178 | 31178 | Shasta | Shasta | 89 | 2020-04-08 | 24 | 3 | |
31122 | 31122 | Shasta | Shasta | 89 | 2020-04-09 | 24 | 3 | |
31066 | 31066 | Shasta | Shasta | 89 | 2020-04-10 | 24 | 3 | |
31010 | 31010 | Shasta | Shasta | 89 | 2020-04-11 | 24 | 3 | TRUE |
30954 | 30954 | Shasta | Shasta | 89 | 2020-04-12 | 24 | 3 | |
30898 | 30898 | Shasta | Shasta | 89 | 2020-04-13 | 25 | 3 | |
30842 | 30842 | Shasta | Shasta | 89 | 2020-04-14 | 25 | 3 | |
30786 | 30786 | Shasta | Shasta | 89 | 2020-04-15 | 25 | 3 | |
30730 | 30730 | Shasta | Shasta | 89 | 2020-04-16 | 26 | 3 | |
30674 | 30674 | Shasta | Shasta | 89 | 2020-04-17 | 26 | 3 | |
30618 | 30618 | Shasta | Shasta | 89 | 2020-04-18 | 26 | 3 | |
30562 | 30562 | Shasta | Shasta | 89 | 2020-04-19 | 26 | 3 | |
30506 | 30506 | Shasta | Shasta | 89 | 2020-04-20 | 26 | 3 | |
30450 | 30450 | Shasta | Shasta | 89 | 2020-04-21 | 26 | 3 | |
30394 | 30394 | Shasta | Shasta | 89 | 2020-04-22 | 27 | 3 | |
30338 | 30338 | Shasta | Shasta | 89 | 2020-04-23 | 28 | 3 | |
30282 | 30282 | Shasta | Shasta | 89 | 2020-04-24 | 30 | 4 | |
30226 | 30226 | Shasta | Shasta | 89 | 2020-04-25 | 30 | 4 | |
30170 | 30170 | Shasta | Shasta | 89 | 2020-04-26 | 30 | 4 | |
30114 | 30114 | Shasta | Shasta | 89 | 2020-04-27 | 30 | 4 | |
30058 | 30058 | Shasta | Shasta | 89 | 2020-04-28 | 31 | 4 | |
29999 | 29999 | Shasta | Shasta | 89 | 2020-04-29 | 31 | 4 | |
29938 | 29938 | Shasta | Shasta | 89 | 2020-04-30 | 31 | 4 | |
29877 | 29877 | Shasta | Shasta | 89 | 2020-05-01 | 31 | 4 | |
29816 | 29816 | Shasta | Shasta | 89 | 2020-05-02 | 31 | 4 | TRUE |
29755 | 29755 | Shasta | Shasta | 89 | 2020-05-03 | 31 | 4 | |
29694 | 29694 | Shasta | Shasta | 89 | 2020-05-04 | 31 | 4 | |
29633 | 29633 | Shasta | Shasta | 89 | 2020-05-05 | 31 | 4 | |
29572 | 29572 | Shasta | Shasta | 89 | 2020-05-06 | 31 | 4 | |
29511 | 29511 | Shasta | Shasta | 89 | 2020-05-07 | 31 | 4 | |
29450 | 29450 | Shasta | Shasta | 89 | 2020-05-08 | 31 | 4 | |
29389 | 29389 | Shasta | Shasta | 89 | 2020-05-09 | 31 | 4 | |
29328 | 29328 | Shasta | Shasta | 89 | 2020-05-10 | 31 | 4 | |
29267 | 29267 | Shasta | Shasta | 89 | 2020-05-11 | 32 | 4 | |
29206 | 29206 | Shasta | Shasta | 89 | 2020-05-12 | 32 | 4 | |
29145 | 29145 | Shasta | Shasta | 89 | 2020-05-13 | 32 | 4 | |
29084 | 29084 | Shasta | Shasta | 89 | 2020-05-14 | 33 | 4 | |
29023 | 29023 | Shasta | Shasta | 89 | 2020-05-15 | 33 | 4 | |
28962 | 28962 | Shasta | Shasta | 89 | 2020-05-16 | 34 | 4 | |
28901 | 28901 | Shasta | Shasta | 89 | 2020-05-17 | 34 | 4 | |
28840 | 28840 | Shasta | Shasta | 89 | 2020-05-18 | 34 | 4 | TRUE |
28779 | 28779 | Shasta | Shasta | 89 | 2020-05-19 | 34 | 4 | |
28718 | 28718 | Shasta | Shasta | 89 | 2020-05-20 | 34 | 4 | |
28657 | 28657 | Shasta | Shasta | 89 | 2020-05-21 | 34 | 4 | |
28596 | 28596 | Shasta | Shasta | 89 | 2020-05-22 | 36 | 4 | |
28535 | 28535 | Shasta | Shasta | 89 | 2020-05-23 | 36 | 4 | |
28474 | 28474 | Shasta | Shasta | 89 | 2020-05-24 | 36 | 4 | |
28413 | 28413 | Shasta | Shasta | 89 | 2020-05-25 | 36 | 4 | |
28352 | 28352 | Shasta | Shasta | 89 | 2020-05-26 | 36 | 4 | |
28291 | 28291 | Shasta | Shasta | 89 | 2020-05-27 | 37 | 4 | |
28230 | 28230 | Shasta | Shasta | 89 | 2020-05-28 | 37 | 4 | |
28169 | 28169 | Shasta | Shasta | 89 | 2020-05-29 | 37 | 4 | |
28108 | 28108 | Shasta | Shasta | 89 | 2020-05-30 | 39 | 4 | |
28047 | 28047 | Shasta | Shasta | 89 | 2020-05-31 | 39 | 4 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );