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 = "Placer" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
12234 | 12234 | Placer | Placer | 61 | 2021-02-14 | 19175 | 222 | TRUE |
12295 | 12295 | Placer | Placer | 61 | 2021-02-13 | 19175 | 222 | TRUE |
12356 | 12356 | Placer | Placer | 61 | 2021-02-12 | 19175 | 222 | TRUE |
12417 | 12417 | Placer | Placer | 61 | 2021-02-11 | 19175 | 222 | |
12478 | 12478 | Placer | Placer | 61 | 2021-02-10 | 19121 | 217 | |
12539 | 12539 | Placer | Placer | 61 | 2021-02-09 | 19036 | 216 | |
12600 | 12600 | Placer | Placer | 61 | 2021-02-08 | 18973 | 214 | |
12661 | 12661 | Placer | Placer | 61 | 2021-02-07 | 18784 | 206 | TRUE |
12722 | 12722 | Placer | Placer | 61 | 2021-02-06 | 18784 | 206 | TRUE |
12783 | 12783 | Placer | Placer | 61 | 2021-02-05 | 18784 | 206 | |
12844 | 12844 | Placer | Placer | 61 | 2021-02-04 | 18738 | 206 | |
12905 | 12905 | Placer | Placer | 61 | 2021-02-03 | 18670 | 205 | |
12966 | 12966 | Placer | Placer | 61 | 2021-02-02 | 18638 | 201 | |
13027 | 13027 | Placer | Placer | 61 | 2021-02-01 | 18608 | 201 | |
13088 | 13088 | Placer | Placer | 61 | 2021-01-31 | 18399 | 199 | TRUE |
13149 | 13149 | Placer | Placer | 61 | 2021-01-30 | 18399 | 199 | TRUE |
13210 | 13210 | Placer | Placer | 61 | 2021-01-29 | 18399 | 199 | |
13271 | 13271 | Placer | Placer | 61 | 2021-01-28 | 18267 | 192 | |
13332 | 13332 | Placer | Placer | 61 | 2021-01-27 | 18129 | 192 | |
13393 | 13393 | Placer | Placer | 61 | 2021-01-26 | 18034 | 188 | |
13454 | 13454 | Placer | Placer | 61 | 2021-01-25 | 17675 | 188 | TRUE |
13515 | 13515 | Placer | Placer | 61 | 2021-01-24 | 17675 | 188 | TRUE |
13576 | 13576 | Placer | Placer | 61 | 2021-01-23 | 17675 | 188 | TRUE |
13637 | 13637 | Placer | Placer | 61 | 2021-01-22 | 17675 | 188 | |
13698 | 13698 | Placer | Placer | 61 | 2021-01-21 | 17584 | 186 | |
13759 | 13759 | Placer | Placer | 61 | 2021-01-20 | 17490 | 184 | |
13820 | 13820 | Placer | Placer | 61 | 2021-01-19 | 17380 | 180 | |
13881 | 13881 | Placer | Placer | 61 | 2021-01-18 | 16761 | 173 | TRUE |
13942 | 13942 | Placer | Placer | 61 | 2021-01-17 | 16761 | 173 | TRUE |
14003 | 14003 | Placer | Placer | 61 | 2021-01-16 | 16761 | 173 | TRUE |
14064 | 14064 | Placer | Placer | 61 | 2021-01-15 | 16761 | 173 | |
14125 | 14125 | Placer | Placer | 61 | 2021-01-14 | 16532 | 172 | |
14186 | 14186 | Placer | Placer | 61 | 2021-01-13 | 16317 | 170 | |
14247 | 14247 | Placer | Placer | 61 | 2021-01-12 | 16135 | 160 | |
14308 | 14308 | Placer | Placer | 61 | 2021-01-11 | 15978 | 160 | |
14369 | 14369 | Placer | Placer | 61 | 2021-01-10 | 15454 | 159 | TRUE |
14430 | 14430 | Placer | Placer | 61 | 2021-01-09 | 15454 | 159 | TRUE |
14491 | 14491 | Placer | Placer | 61 | 2021-01-08 | 15454 | 159 | |
14552 | 14552 | Placer | Placer | 61 | 2021-01-07 | 15233 | 142 | |
14613 | 14613 | Placer | Placer | 61 | 2021-01-06 | 15015 | 132 | |
14674 | 14674 | Placer | Placer | 61 | 2021-01-05 | 14800 | 132 | |
14735 | 14735 | Placer | Placer | 61 | 2021-01-04 | 14687 | 132 | |
14796 | 14796 | Placer | Placer | 61 | 2021-01-03 | 13755 | 125 | TRUE |
14857 | 14857 | Placer | Placer | 61 | 2021-01-02 | 13755 | 125 | TRUE |
14918 | 14918 | Placer | Placer | 61 | 2021-01-01 | 13755 | 125 | TRUE |
14979 | 14979 | Placer | Placer | 61 | 2020-12-31 | 13755 | 125 | |
15040 | 15040 | Placer | Placer | 61 | 2020-12-30 | 13550 | 125 | |
15101 | 15101 | Placer | Placer | 61 | 2020-12-29 | 13272 | 125 | |
15162 | 15162 | Placer | Placer | 61 | 2020-12-28 | 13055 | 125 | |
15223 | 15223 | Placer | Placer | 61 | 2020-12-27 | 12262 | 120 | TRUE |
15284 | 15284 | Placer | Placer | 61 | 2020-12-26 | 12262 | 120 | TRUE |
15345 | 15345 | Placer | Placer | 61 | 2020-12-25 | 12262 | 120 | TRUE |
15406 | 15406 | Placer | Placer | 61 | 2020-12-24 | 12262 | 120 | |
15467 | 15467 | Placer | Placer | 61 | 2020-12-23 | 11968 | 110 | |
15528 | 15528 | Placer | Placer | 61 | 2020-12-22 | 11761 | 109 | |
15589 | 15589 | Placer | Placer | 61 | 2020-12-21 | 11541 | 104 | |
15650 | 15650 | Placer | Placer | 61 | 2020-12-20 | 10776 | 103 | TRUE |
15711 | 15711 | Placer | Placer | 61 | 2020-12-19 | 10776 | 103 | TRUE |
15772 | 15772 | Placer | Placer | 61 | 2020-12-18 | 10776 | 103 | |
15833 | 15833 | Placer | Placer | 61 | 2020-12-17 | 10554 | 98 | |
15894 | 15894 | Placer | Placer | 61 | 2020-12-16 | 9972 | 97 | |
15955 | 15955 | Placer | Placer | 61 | 2020-12-15 | 9722 | 94 | |
16016 | 16016 | Placer | Placer | 61 | 2020-12-14 | 9549 | 93 | |
16077 | 16077 | Placer | Placer | 61 | 2020-12-13 | 8879 | 92 | TRUE |
16138 | 16138 | Placer | Placer | 61 | 2020-12-12 | 8879 | 92 | TRUE |
16199 | 16199 | Placer | Placer | 61 | 2020-12-11 | 8879 | 92 | |
16260 | 16260 | Placer | Placer | 61 | 2020-12-10 | 8860 | 89 | |
16321 | 16321 | Placer | Placer | 61 | 2020-12-09 | 8544 | 85 | |
16382 | 16382 | Placer | Placer | 61 | 2020-12-08 | 8173 | 81 | |
16443 | 16443 | Placer | Placer | 61 | 2020-12-07 | 7979 | 81 | |
16504 | 16504 | Placer | Placer | 61 | 2020-12-06 | 6910 | 74 | TRUE |
16565 | 16565 | Placer | Placer | 61 | 2020-12-05 | 6910 | 74 | TRUE |
16626 | 16626 | Placer | Placer | 61 | 2020-12-04 | 6910 | 74 | |
16687 | 16687 | Placer | Placer | 61 | 2020-12-03 | 6784 | 72 | |
16748 | 16748 | Placer | Placer | 61 | 2020-12-02 | 6664 | 71 | |
16809 | 16809 | Placer | Placer | 61 | 2020-12-01 | 6664 | 71 | |
16870 | 16870 | Placer | Placer | 61 | 2020-11-30 | 6622 | 70 | |
16931 | 16931 | Placer | Placer | 61 | 2020-11-29 | 6354 | 68 | TRUE |
16992 | 16992 | Placer | Placer | 61 | 2020-11-28 | 6354 | 68 | TRUE |
17053 | 17053 | Placer | Placer | 61 | 2020-11-27 | 6354 | 68 | |
17114 | 17114 | Placer | Placer | 61 | 2020-11-26 | 6224 | 68 | TRUE |
17175 | 17175 | Placer | Placer | 61 | 2020-11-25 | 6224 | 68 | |
17236 | 17236 | Placer | Placer | 61 | 2020-11-24 | 6148 | 68 | |
17297 | 17297 | Placer | Placer | 61 | 2020-11-23 | 6071 | 65 | |
17358 | 17358 | Placer | Placer | 61 | 2020-11-22 | 5687 | 65 | TRUE |
17419 | 17419 | Placer | Placer | 61 | 2020-11-21 | 5687 | 65 | TRUE |
17480 | 17480 | Placer | Placer | 61 | 2020-11-20 | 5687 | 65 | |
17541 | 17541 | Placer | Placer | 61 | 2020-11-19 | 5642 | 65 | |
17602 | 17602 | Placer | Placer | 61 | 2020-11-18 | 5543 | 65 | |
17663 | 17663 | Placer | Placer | 61 | 2020-11-17 | 5489 | 64 | |
17724 | 17724 | Placer | Placer | 61 | 2020-11-16 | 5397 | 64 | |
17785 | 17785 | Placer | Placer | 61 | 2020-11-15 | 5134 | 63 | TRUE |
17846 | 17846 | Placer | Placer | 61 | 2020-11-14 | 5134 | 63 | TRUE |
17907 | 17907 | Placer | Placer | 61 | 2020-11-13 | 5134 | 63 | |
17968 | 17968 | Placer | Placer | 61 | 2020-11-12 | 5056 | 62 | |
18029 | 18029 | Placer | Placer | 61 | 2020-11-11 | 4993 | 60 | |
18090 | 18090 | Placer | Placer | 61 | 2020-11-10 | 4912 | 60 | |
18151 | 18151 | Placer | Placer | 61 | 2020-11-09 | 4853 | 60 | |
18212 | 18212 | Placer | Placer | 61 | 2020-11-08 | 4692 | 60 | TRUE |
18273 | 18273 | Placer | Placer | 61 | 2020-11-07 | 4692 | 60 | 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 );