latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
31,362 rows sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Los Angeles 586
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Calaveras 559
- Contra Costa 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Tulare 541
- Amador 539
- San Luis Obispo 538
- San Bernardino 537
- Santa Barbara 537
- …
Link | rowid | date | county ▼ | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5801 | 5801 | 2021-05-25 | Alameda | 1 | 88665 | 1263 | 45 | 0 |
5859 | 5859 | 2021-05-24 | Alameda | 1 | 88620 | 1263 | 75 | 0 |
5917 | 5917 | 2021-05-23 | Alameda | 1 | 88545 | 1263 | 43 | 0 |
5975 | 5975 | 2021-05-22 | Alameda | 1 | 88502 | 1263 | 19 | 0 |
6033 | 6033 | 2021-05-21 | Alameda | 1 | 88483 | 1263 | 75 | 0 |
6091 | 6091 | 2021-05-20 | Alameda | 1 | 88408 | 1263 | 49 | 0 |
6149 | 6149 | 2021-05-19 | Alameda | 1 | 88359 | 1263 | 55 | 0 |
6207 | 6207 | 2021-05-18 | Alameda | 1 | 88304 | 1263 | 49 | 0 |
6265 | 6265 | 2021-05-17 | Alameda | 1 | 88255 | 1263 | 25 | 0 |
6323 | 6323 | 2021-05-16 | Alameda | 1 | 88230 | 1263 | 43 | 0 |
6381 | 6381 | 2021-05-15 | Alameda | 1 | 88187 | 1263 | 58 | 0 |
6439 | 6439 | 2021-05-14 | Alameda | 1 | 88129 | 1263 | 68 | 0 |
6497 | 6497 | 2021-05-13 | Alameda | 1 | 88061 | 1263 | 63 | 0 |
6555 | 6555 | 2021-05-12 | Alameda | 1 | 87998 | 1263 | 63 | 0 |
6613 | 6613 | 2021-05-11 | Alameda | 1 | 87935 | 1263 | 59 | 0 |
6671 | 6671 | 2021-05-10 | Alameda | 1 | 87876 | 1263 | 75 | 0 |
6729 | 6729 | 2021-05-09 | Alameda | 1 | 87801 | 1263 | 84 | 0 |
6787 | 6787 | 2021-05-08 | Alameda | 1 | 87717 | 1263 | 87 | 0 |
6845 | 6845 | 2021-05-07 | Alameda | 1 | 87630 | 1263 | 96 | 0 |
6903 | 6903 | 2021-05-06 | Alameda | 1 | 87534 | 1263 | 102 | 0 |
6961 | 6961 | 2021-05-05 | Alameda | 1 | 87432 | 1263 | 54 | 0 |
7019 | 7019 | 2021-05-04 | Alameda | 1 | 87378 | 1263 | 27 | 0 |
7077 | 7077 | 2021-05-03 | Alameda | 1 | 87351 | 1263 | 66 | 0 |
7135 | 7135 | 2021-05-02 | Alameda | 1 | 87285 | 1263 | 80 | 0 |
7193 | 7193 | 2021-05-01 | Alameda | 1 | 87205 | 1263 | 99 | 0 |
7251 | 7251 | 2021-04-30 | Alameda | 1 | 87106 | 1263 | 109 | 0 |
7309 | 7309 | 2021-04-29 | Alameda | 1 | 86997 | 1263 | 97 | 0 |
7367 | 7367 | 2021-04-28 | Alameda | 1 | 86900 | 1263 | 68 | 0 |
7425 | 7425 | 2021-04-27 | Alameda | 1 | 86832 | 1263 | 71 | 0 |
7483 | 7483 | 2021-04-26 | Alameda | 1 | 86761 | 1263 | 74 | 0 |
7541 | 7541 | 2021-04-25 | Alameda | 1 | 86687 | 1263 | 151 | 0 |
7599 | 7599 | 2021-04-24 | Alameda | 1 | 86536 | 1263 | 80 | 0 |
7657 | 7657 | 2021-04-23 | Alameda | 1 | 86456 | 1263 | 126 | 0 |
7715 | 7715 | 2021-04-22 | Alameda | 1 | 86330 | 1263 | 112 | 1 |
7773 | 7773 | 2021-04-21 | Alameda | 1 | 86218 | 1262 | 81 | 2 |
7831 | 7831 | 2021-04-20 | Alameda | 1 | 86137 | 1260 | 71 | 1 |
7889 | 7889 | 2021-04-19 | Alameda | 1 | 86066 | 1259 | 105 | 3 |
7947 | 7947 | 2021-04-18 | Alameda | 1 | 85961 | 1256 | 113 | 2 |
8005 | 8005 | 2021-04-17 | Alameda | 1 | 85848 | 1254 | 128 | 0 |
8063 | 8063 | 2021-04-16 | Alameda | 1 | 85720 | 1254 | 140 | 0 |
8121 | 8121 | 2021-04-15 | Alameda | 1 | 85580 | 1254 | 84 | 0 |
8179 | 8179 | 2021-04-14 | Alameda | 1 | 85496 | 1254 | 83 | 0 |
8237 | 8237 | 2021-04-13 | Alameda | 1 | 85413 | 1254 | 90 | 0 |
8295 | 8295 | 2021-04-12 | Alameda | 1 | 85323 | 1254 | 65 | 1 |
8353 | 8353 | 2021-04-11 | Alameda | 1 | 85258 | 1253 | 131 | 0 |
8411 | 8411 | 2021-04-10 | Alameda | 1 | 85127 | 1253 | 209 | 1 |
8469 | 8469 | 2021-04-09 | Alameda | 1 | 84918 | 1252 | 183 | 0 |
8527 | 8527 | 2021-04-08 | Alameda | 1 | 84735 | 1252 | 92 | 0 |
8585 | 8585 | 2021-04-07 | Alameda | 1 | 84643 | 1252 | 51 | 0 |
8643 | 8643 | 2021-04-06 | Alameda | 1 | 84592 | 1252 | 88 | 2 |
8701 | 8701 | 2021-04-05 | Alameda | 1 | 84504 | 1250 | 63 | 0 |
8759 | 8759 | 2021-04-04 | Alameda | 1 | 84441 | 1250 | 90 | 0 |
8817 | 8817 | 2021-04-03 | Alameda | 1 | 84351 | 1250 | 89 | 0 |
8875 | 8875 | 2021-04-02 | Alameda | 1 | 84262 | 1250 | 196 | 0 |
8933 | 8933 | 2021-04-01 | Alameda | 1 | 84066 | 1250 | 109 | 0 |
8991 | 8991 | 2021-03-31 | Alameda | 1 | 83957 | 1250 | 70 | 1 |
9049 | 9049 | 2021-03-30 | Alameda | 1 | 83887 | 1249 | 60 | 0 |
9107 | 9107 | 2021-03-29 | Alameda | 1 | 83827 | 1249 | 103 | 2 |
9165 | 9165 | 2021-03-28 | Alameda | 1 | 83724 | 1247 | 74 | 1 |
9223 | 9223 | 2021-03-27 | Alameda | 1 | 83650 | 1246 | 127 | 0 |
9281 | 9281 | 2021-03-26 | Alameda | 1 | 83523 | 1246 | 107 | 2 |
9339 | 9339 | 2021-03-25 | Alameda | 1 | 83416 | 1244 | 100 | 1 |
9397 | 9397 | 2021-03-24 | Alameda | 1 | 83316 | 1243 | 71 | 2 |
9455 | 9455 | 2021-03-23 | Alameda | 1 | 83245 | 1241 | 54 | 0 |
9513 | 9513 | 2021-03-22 | Alameda | 1 | 83191 | 1241 | 67 | 0 |
9571 | 9571 | 2021-03-21 | Alameda | 1 | 83124 | 1241 | 72 | 0 |
9629 | 9629 | 2021-03-20 | Alameda | 1 | 83052 | 1241 | 107 | 2 |
9687 | 9687 | 2021-03-19 | Alameda | 1 | 82945 | 1239 | 85 | 0 |
9745 | 9745 | 2021-03-18 | Alameda | 1 | 82860 | 1239 | 76 | 2 |
9803 | 9803 | 2021-03-17 | Alameda | 1 | 82784 | 1237 | 107 | 0 |
9861 | 9861 | 2021-03-16 | Alameda | 1 | 82677 | 1237 | 97 | 0 |
9919 | 9919 | 2021-03-15 | Alameda | 1 | 82580 | 1237 | 43 | 3 |
9977 | 9977 | 2021-03-14 | Alameda | 1 | 82537 | 1234 | 105 | 0 |
10035 | 10035 | 2021-03-13 | Alameda | 1 | 82432 | 1234 | 109 | 1 |
10093 | 10093 | 2021-03-12 | Alameda | 1 | 82323 | 1233 | 91 | 0 |
10151 | 10151 | 2021-03-11 | Alameda | 1 | 82232 | 1233 | 103 | 2 |
10209 | 10209 | 2021-03-10 | Alameda | 1 | 82129 | 1231 | 94 | 2 |
10267 | 10267 | 2021-03-09 | Alameda | 1 | 82035 | 1229 | 62 | 1 |
10325 | 10325 | 2021-03-08 | Alameda | 1 | 81973 | 1228 | 129 | 1 |
10383 | 10383 | 2021-03-07 | Alameda | 1 | 81844 | 1227 | 108 | 0 |
10441 | 10441 | 2021-03-06 | Alameda | 1 | 81736 | 1227 | 113 | 1 |
10499 | 10499 | 2021-03-05 | Alameda | 1 | 81623 | 1226 | 132 | 0 |
10557 | 10557 | 2021-03-04 | Alameda | 1 | 81491 | 1226 | 138 | 2 |
10615 | 10615 | 2021-03-03 | Alameda | 1 | 81353 | 1224 | 98 | 0 |
10673 | 10673 | 2021-03-02 | Alameda | 1 | 81255 | 1224 | 96 | 0 |
10731 | 10731 | 2021-03-01 | Alameda | 1 | 81159 | 1224 | 77 | 2 |
10789 | 10789 | 2021-02-28 | Alameda | 1 | 81082 | 1222 | 162 | 1 |
10847 | 10847 | 2021-02-27 | Alameda | 1 | 80920 | 1221 | 189 | 2 |
10905 | 10905 | 2021-02-26 | Alameda | 1 | 80731 | 1219 | 250 | 0 |
10963 | 10963 | 2021-02-25 | Alameda | 1 | 80481 | 1219 | 153 | 1 |
11021 | 11021 | 2021-02-24 | Alameda | 1 | 80328 | 1218 | 147 | 2 |
11079 | 11079 | 2021-02-23 | Alameda | 1 | 80181 | 1216 | 154 | 3 |
11137 | 11137 | 2021-02-22 | Alameda | 1 | 80027 | 1213 | 158 | 2 |
11195 | 11195 | 2021-02-21 | Alameda | 1 | 79869 | 1211 | 160 | 3 |
11253 | 11253 | 2021-02-20 | Alameda | 1 | 79709 | 1208 | 184 | 0 |
11311 | 11311 | 2021-02-19 | Alameda | 1 | 79525 | 1208 | 231 | 1 |
11369 | 11369 | 2021-02-18 | Alameda | 1 | 79294 | 1207 | 259 | 1 |
11427 | 11427 | 2021-02-17 | Alameda | 1 | 79035 | 1206 | 145 | 0 |
11485 | 11485 | 2021-02-16 | Alameda | 1 | 78890 | 1206 | 127 | 1 |
11543 | 11543 | 2021-02-15 | Alameda | 1 | 78763 | 1205 | 198 | 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 );