latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where fips = 61 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 |
---|---|---|---|---|---|---|---|---|
8209 | 8209 | 2021-04-14 | Placer | 61 | 21644 | 281 | 44 | 0 |
8267 | 8267 | 2021-04-13 | Placer | 61 | 21600 | 281 | 60 | 2 |
8325 | 8325 | 2021-04-12 | Placer | 61 | 21540 | 279 | 151 | 0 |
8383 | 8383 | 2021-04-11 | Placer | 61 | 21389 | 279 | 0 | 0 |
8441 | 8441 | 2021-04-10 | Placer | 61 | 21389 | 279 | 0 | 0 |
8499 | 8499 | 2021-04-09 | Placer | 61 | 21389 | 279 | 72 | 1 |
8557 | 8557 | 2021-04-08 | Placer | 61 | 21317 | 278 | 30 | 1 |
8615 | 8615 | 2021-04-07 | Placer | 61 | 21287 | 277 | 48 | 0 |
8673 | 8673 | 2021-04-06 | Placer | 61 | 21239 | 277 | 51 | 0 |
8731 | 8731 | 2021-04-05 | Placer | 61 | 21188 | 277 | 93 | 1 |
8789 | 8789 | 2021-04-04 | Placer | 61 | 21095 | 276 | 0 | 0 |
8847 | 8847 | 2021-04-03 | Placer | 61 | 21095 | 276 | 0 | 0 |
8905 | 8905 | 2021-04-02 | Placer | 61 | 21095 | 276 | 123 | 1 |
8963 | 8963 | 2021-04-01 | Placer | 61 | 20972 | 275 | 20 | 1 |
9021 | 9021 | 2021-03-31 | Placer | 61 | 20952 | 274 | 23 | 2 |
9079 | 9079 | 2021-03-30 | Placer | 61 | 20929 | 272 | 41 | 0 |
9137 | 9137 | 2021-03-29 | Placer | 61 | 20888 | 272 | 152 | 9 |
9195 | 9195 | 2021-03-28 | Placer | 61 | 20736 | 263 | 0 | 0 |
9253 | 9253 | 2021-03-27 | Placer | 61 | 20736 | 263 | 0 | 0 |
9311 | 9311 | 2021-03-26 | Placer | 61 | 20736 | 263 | 39 | 6 |
9369 | 9369 | 2021-03-25 | Placer | 61 | 20697 | 257 | 32 | 6 |
9427 | 9427 | 2021-03-24 | Placer | 61 | 20665 | 251 | 38 | 1 |
9485 | 9485 | 2021-03-23 | Placer | 61 | 20627 | 250 | 24 | 2 |
9543 | 9543 | 2021-03-22 | Placer | 61 | 20603 | 248 | 110 | 4 |
9601 | 9601 | 2021-03-21 | Placer | 61 | 20493 | 244 | 0 | 0 |
9659 | 9659 | 2021-03-20 | Placer | 61 | 20493 | 244 | 0 | 0 |
9717 | 9717 | 2021-03-19 | Placer | 61 | 20493 | 244 | 33 | 0 |
9775 | 9775 | 2021-03-18 | Placer | 61 | 20460 | 244 | 53 | 7 |
9833 | 9833 | 2021-03-17 | Placer | 61 | 20407 | 237 | 13 | 0 |
9891 | 9891 | 2021-03-16 | Placer | 61 | 20394 | 237 | 30 | 5 |
9949 | 9949 | 2021-03-15 | Placer | 61 | 20364 | 232 | 91 | 0 |
10007 | 10007 | 2021-03-14 | Placer | 61 | 20273 | 232 | 0 | 0 |
10065 | 10065 | 2021-03-13 | Placer | 61 | 20273 | 232 | 0 | 0 |
10123 | 10123 | 2021-03-12 | Placer | 61 | 20273 | 232 | 31 | 0 |
10181 | 10181 | 2021-03-11 | Placer | 61 | 20242 | 232 | 38 | 0 |
10239 | 10239 | 2021-03-10 | Placer | 61 | 20204 | 232 | 21 | 0 |
10297 | 10297 | 2021-03-09 | Placer | 61 | 20183 | 232 | 21 | 0 |
10355 | 10355 | 2021-03-08 | Placer | 61 | 20162 | 232 | 127 | 0 |
10413 | 10413 | 2021-03-07 | Placer | 61 | 20035 | 232 | 0 | 0 |
10471 | 10471 | 2021-03-06 | Placer | 61 | 20035 | 232 | 0 | 0 |
10529 | 10529 | 2021-03-05 | Placer | 61 | 20035 | 232 | 72 | 0 |
10587 | 10587 | 2021-03-04 | Placer | 61 | 19963 | 232 | 52 | 0 |
10645 | 10645 | 2021-03-03 | Placer | 61 | 19911 | 232 | 29 | 0 |
10703 | 10703 | 2021-03-02 | Placer | 61 | 19882 | 232 | 21 | 0 |
10761 | 10761 | 2021-03-01 | Placer | 61 | 19861 | 232 | 98 | 0 |
10819 | 10819 | 2021-02-28 | Placer | 61 | 19763 | 232 | 0 | 0 |
10877 | 10877 | 2021-02-27 | Placer | 61 | 19763 | 232 | 0 | 0 |
10935 | 10935 | 2021-02-26 | Placer | 61 | 19763 | 232 | 50 | 1 |
10993 | 10993 | 2021-02-25 | Placer | 61 | 19713 | 231 | 11 | 0 |
11051 | 11051 | 2021-02-24 | Placer | 61 | 19702 | 231 | 41 | 0 |
11109 | 11109 | 2021-02-23 | Placer | 61 | 19661 | 231 | 141 | 2 |
11167 | 11167 | 2021-02-22 | Placer | 61 | 19520 | 229 | 0 | 0 |
11225 | 11225 | 2021-02-21 | Placer | 61 | 19520 | 229 | 0 | 0 |
11283 | 11283 | 2021-02-20 | Placer | 61 | 19520 | 229 | 0 | 0 |
11341 | 11341 | 2021-02-19 | Placer | 61 | 19520 | 229 | 58 | 0 |
11399 | 11399 | 2021-02-18 | Placer | 61 | 19462 | 229 | 5 | 6 |
11457 | 11457 | 2021-02-17 | Placer | 61 | 19457 | 223 | 24 | 0 |
11515 | 11515 | 2021-02-16 | Placer | 61 | 19433 | 223 | 258 | 1 |
11573 | 11573 | 2021-02-15 | Placer | 61 | 19175 | 222 | 0 | 0 |
11631 | 11631 | 2021-02-14 | Placer | 61 | 19175 | 222 | 0 | 0 |
11689 | 11689 | 2021-02-13 | Placer | 61 | 19175 | 222 | 0 | 0 |
11747 | 11747 | 2021-02-12 | Placer | 61 | 19175 | 222 | 0 | 0 |
11805 | 11805 | 2021-02-11 | Placer | 61 | 19175 | 222 | 54 | 5 |
11863 | 11863 | 2021-02-10 | Placer | 61 | 19121 | 217 | 85 | 1 |
11921 | 11921 | 2021-02-09 | Placer | 61 | 19036 | 216 | 63 | 2 |
11979 | 11979 | 2021-02-08 | Placer | 61 | 18973 | 214 | 189 | 8 |
12037 | 12037 | 2021-02-07 | Placer | 61 | 18784 | 206 | 0 | 0 |
12095 | 12095 | 2021-02-06 | Placer | 61 | 18784 | 206 | 0 | 0 |
12153 | 12153 | 2021-02-05 | Placer | 61 | 18784 | 206 | 46 | 0 |
12211 | 12211 | 2021-02-04 | Placer | 61 | 18738 | 206 | 68 | 1 |
12269 | 12269 | 2021-02-03 | Placer | 61 | 18670 | 205 | 32 | 4 |
12327 | 12327 | 2021-02-02 | Placer | 61 | 18638 | 201 | 30 | 0 |
12385 | 12385 | 2021-02-01 | Placer | 61 | 18608 | 201 | 209 | 2 |
12443 | 12443 | 2021-01-31 | Placer | 61 | 18399 | 199 | 0 | 0 |
12501 | 12501 | 2021-01-30 | Placer | 61 | 18399 | 199 | 0 | 0 |
12559 | 12559 | 2021-01-29 | Placer | 61 | 18399 | 199 | 132 | 7 |
12617 | 12617 | 2021-01-28 | Placer | 61 | 18267 | 192 | 138 | 0 |
12675 | 12675 | 2021-01-27 | Placer | 61 | 18129 | 192 | 95 | 4 |
12733 | 12733 | 2021-01-26 | Placer | 61 | 18034 | 188 | 359 | 0 |
12791 | 12791 | 2021-01-25 | Placer | 61 | 17675 | 188 | 0 | 0 |
12849 | 12849 | 2021-01-24 | Placer | 61 | 17675 | 188 | 0 | 0 |
12907 | 12907 | 2021-01-23 | Placer | 61 | 17675 | 188 | 0 | 0 |
12965 | 12965 | 2021-01-22 | Placer | 61 | 17675 | 188 | 91 | 2 |
13023 | 13023 | 2021-01-21 | Placer | 61 | 17584 | 186 | 94 | 2 |
13081 | 13081 | 2021-01-20 | Placer | 61 | 17490 | 184 | 110 | 4 |
13139 | 13139 | 2021-01-19 | Placer | 61 | 17380 | 180 | 619 | 7 |
13197 | 13197 | 2021-01-18 | Placer | 61 | 16761 | 173 | 0 | 0 |
13255 | 13255 | 2021-01-17 | Placer | 61 | 16761 | 173 | 0 | 0 |
13313 | 13313 | 2021-01-16 | Placer | 61 | 16761 | 173 | 0 | 0 |
13371 | 13371 | 2021-01-15 | Placer | 61 | 16761 | 173 | 229 | 1 |
13429 | 13429 | 2021-01-14 | Placer | 61 | 16532 | 172 | 215 | 2 |
13487 | 13487 | 2021-01-13 | Placer | 61 | 16317 | 170 | 182 | 10 |
13545 | 13545 | 2021-01-12 | Placer | 61 | 16135 | 160 | 157 | 0 |
13603 | 13603 | 2021-01-11 | Placer | 61 | 15978 | 160 | 524 | 1 |
13661 | 13661 | 2021-01-10 | Placer | 61 | 15454 | 159 | 0 | 0 |
13719 | 13719 | 2021-01-09 | Placer | 61 | 15454 | 159 | 0 | 0 |
13777 | 13777 | 2021-01-08 | Placer | 61 | 15454 | 159 | 221 | 17 |
13835 | 13835 | 2021-01-07 | Placer | 61 | 15233 | 142 | 218 | 10 |
13893 | 13893 | 2021-01-06 | Placer | 61 | 15015 | 132 | 215 | 0 |
13951 | 13951 | 2021-01-05 | Placer | 61 | 14800 | 132 | 113 | 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 );