latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where agency = "Alameda" 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 |
---|---|---|---|---|---|---|---|---|
6101 | 6101 | Alameda | Alameda | 1 | 2021-05-25 | 85047 | 1217 | |
6162 | 6162 | Alameda | Alameda | 1 | 2021-05-24 | 85002 | 1217 | |
6223 | 6223 | Alameda | Alameda | 1 | 2021-05-23 | 84927 | 1217 | |
6284 | 6284 | Alameda | Alameda | 1 | 2021-05-22 | 84884 | 1217 | TRUE |
6345 | 6345 | Alameda | Alameda | 1 | 2021-05-21 | 84869 | 1217 | |
6406 | 6406 | Alameda | Alameda | 1 | 2021-05-20 | 84797 | 1217 | |
6467 | 6467 | Alameda | Alameda | 1 | 2021-05-19 | 84750 | 1217 | |
6528 | 6528 | Alameda | Alameda | 1 | 2021-05-18 | 84696 | 1217 | |
6589 | 6589 | Alameda | Alameda | 1 | 2021-05-17 | 84649 | 1217 | |
6650 | 6650 | Alameda | Alameda | 1 | 2021-05-16 | 84625 | 1217 | |
6711 | 6711 | Alameda | Alameda | 1 | 2021-05-15 | 84584 | 1217 | TRUE |
6772 | 6772 | Alameda | Alameda | 1 | 2021-05-14 | 84526 | 1217 | |
6833 | 6833 | Alameda | Alameda | 1 | 2021-05-13 | 84458 | 1217 | |
6894 | 6894 | Alameda | Alameda | 1 | 2021-05-12 | 84395 | 1217 | |
6955 | 6955 | Alameda | Alameda | 1 | 2021-05-11 | 84335 | 1217 | |
7016 | 7016 | Alameda | Alameda | 1 | 2021-05-10 | 84277 | 1217 | |
7077 | 7077 | Alameda | Alameda | 1 | 2021-05-09 | 84204 | 1217 | |
7138 | 7138 | Alameda | Alameda | 1 | 2021-05-08 | 84124 | 1217 | |
7199 | 7199 | Alameda | Alameda | 1 | 2021-05-07 | 84042 | 1217 | |
7260 | 7260 | Alameda | Alameda | 1 | 2021-05-06 | 83951 | 1217 | |
7321 | 7321 | Alameda | Alameda | 1 | 2021-05-05 | 83855 | 1217 | |
7382 | 7382 | Alameda | Alameda | 1 | 2021-05-04 | 83801 | 1217 | |
7443 | 7443 | Alameda | Alameda | 1 | 2021-05-03 | 83775 | 1217 | |
7504 | 7504 | Alameda | Alameda | 1 | 2021-05-02 | 83712 | 1217 | |
7565 | 7565 | Alameda | Alameda | 1 | 2021-05-01 | 83636 | 1217 | |
7626 | 7626 | Alameda | Alameda | 1 | 2021-04-30 | 83542 | 1217 | |
7687 | 7687 | Alameda | Alameda | 1 | 2021-04-29 | 83436 | 1217 | |
7748 | 7748 | Alameda | Alameda | 1 | 2021-04-28 | 83341 | 1217 | |
7809 | 7809 | Alameda | Alameda | 1 | 2021-04-27 | 83276 | 1217 | |
7870 | 7870 | Alameda | Alameda | 1 | 2021-04-26 | 83209 | 1217 | |
7931 | 7931 | Alameda | Alameda | 1 | 2021-04-25 | 83137 | 1217 | |
7992 | 7992 | Alameda | Alameda | 1 | 2021-04-24 | 82987 | 1217 | |
8053 | 8053 | Alameda | Alameda | 1 | 2021-04-23 | 82909 | 1217 | |
8114 | 8114 | Alameda | Alameda | 1 | 2021-04-22 | 82791 | 1217 | |
8175 | 8175 | Alameda | Alameda | 1 | 2021-04-21 | 82683 | 1216 | |
8236 | 8236 | Alameda | Alameda | 1 | 2021-04-20 | 82608 | 1214 | |
8297 | 8297 | Alameda | Alameda | 1 | 2021-04-19 | 82541 | 1213 | |
8358 | 8358 | Alameda | Alameda | 1 | 2021-04-18 | 82438 | 1210 | |
8419 | 8419 | Alameda | Alameda | 1 | 2021-04-17 | 82326 | 1208 | |
8480 | 8480 | Alameda | Alameda | 1 | 2021-04-16 | 82202 | 1208 | |
8541 | 8541 | Alameda | Alameda | 1 | 2021-04-15 | 82068 | 1208 | |
8602 | 8602 | Alameda | Alameda | 1 | 2021-04-14 | 81986 | 1208 | |
8663 | 8663 | Alameda | Alameda | 1 | 2021-04-13 | 81905 | 1208 | |
8724 | 8724 | Alameda | Alameda | 1 | 2021-04-12 | 81823 | 1208 | |
8785 | 8785 | Alameda | Alameda | 1 | 2021-04-11 | 81761 | 1207 | |
8846 | 8846 | Alameda | Alameda | 1 | 2021-04-10 | 81634 | 1207 | |
8907 | 8907 | Alameda | Alameda | 1 | 2021-04-09 | 81430 | 1206 | TRUE |
8968 | 8968 | Alameda | Alameda | 1 | 2021-04-08 | 81249 | 1206 | |
9029 | 9029 | Alameda | Alameda | 1 | 2021-04-07 | 81160 | 1206 | |
9090 | 9090 | Alameda | Alameda | 1 | 2021-04-06 | 81110 | 1206 | |
9151 | 9151 | Alameda | Alameda | 1 | 2021-04-05 | 81032 | 1204 | |
9212 | 9212 | Alameda | Alameda | 1 | 2021-04-04 | 80972 | 1204 | |
9273 | 9273 | Alameda | Alameda | 1 | 2021-04-03 | 80885 | 1204 | |
9334 | 9334 | Alameda | Alameda | 1 | 2021-04-02 | 80800 | 1204 | |
9395 | 9395 | Alameda | Alameda | 1 | 2021-04-01 | 80612 | 1204 | |
9456 | 9456 | Alameda | Alameda | 1 | 2021-03-31 | 80512 | 1204 | |
9517 | 9517 | Alameda | Alameda | 1 | 2021-03-30 | 80446 | 1203 | |
9578 | 9578 | Alameda | Alameda | 1 | 2021-03-29 | 80390 | 1203 | |
9639 | 9639 | Alameda | Alameda | 1 | 2021-03-28 | 80290 | 1201 | TRUE |
9700 | 9700 | Alameda | Alameda | 1 | 2021-03-27 | 80221 | 1200 | TRUE |
9761 | 9761 | Alameda | Alameda | 1 | 2021-03-26 | 80097 | 1200 | |
9822 | 9822 | Alameda | Alameda | 1 | 2021-03-25 | 79993 | 1198 | |
9883 | 9883 | Alameda | Alameda | 1 | 2021-03-24 | 79898 | 1197 | |
9944 | 9944 | Alameda | Alameda | 1 | 2021-03-23 | 79830 | 1196 | |
10005 | 10005 | Alameda | Alameda | 1 | 2021-03-22 | 79783 | 1196 | |
10066 | 10066 | Alameda | Alameda | 1 | 2021-03-21 | 79720 | 1196 | |
10127 | 10127 | Alameda | Alameda | 1 | 2021-03-20 | 79648 | 1196 | |
10188 | 10188 | Alameda | Alameda | 1 | 2021-03-19 | 79545 | 1194 | |
10249 | 10249 | Alameda | Alameda | 1 | 2021-03-18 | 79462 | 1194 | |
10310 | 10310 | Alameda | Alameda | 1 | 2021-03-17 | 79392 | 1192 | |
10371 | 10371 | Alameda | Alameda | 1 | 2021-03-16 | 79294 | 1192 | |
10432 | 10432 | Alameda | Alameda | 1 | 2021-03-15 | 79208 | 1192 | |
10493 | 10493 | Alameda | Alameda | 1 | 2021-03-14 | 79169 | 1189 | |
10554 | 10554 | Alameda | Alameda | 1 | 2021-03-13 | 79069 | 1189 | |
10615 | 10615 | Alameda | Alameda | 1 | 2021-03-12 | 78967 | 1188 | |
10676 | 10676 | Alameda | Alameda | 1 | 2021-03-11 | 78882 | 1188 | |
10737 | 10737 | Alameda | Alameda | 1 | 2021-03-10 | 78785 | 1186 | |
10798 | 10798 | Alameda | Alameda | 1 | 2021-03-09 | 78702 | 1184 | |
10859 | 10859 | Alameda | Alameda | 1 | 2021-03-08 | 78647 | 1183 | |
10920 | 10920 | Alameda | Alameda | 1 | 2021-03-07 | 78526 | 1182 | |
10981 | 10981 | Alameda | Alameda | 1 | 2021-03-06 | 78424 | 1182 | |
11042 | 11042 | Alameda | Alameda | 1 | 2021-03-05 | 78319 | 1181 | |
11103 | 11103 | Alameda | Alameda | 1 | 2021-03-04 | 78194 | 1181 | |
11164 | 11164 | Alameda | Alameda | 1 | 2021-03-03 | 78066 | 1179 | |
11225 | 11225 | Alameda | Alameda | 1 | 2021-03-02 | 77975 | 1179 | |
11286 | 11286 | Alameda | Alameda | 1 | 2021-03-01 | 77882 | 1179 | |
11347 | 11347 | Alameda | Alameda | 1 | 2021-02-28 | 77812 | 1177 | |
11408 | 11408 | Alameda | Alameda | 1 | 2021-02-27 | 77655 | 1176 | |
11469 | 11469 | Alameda | Alameda | 1 | 2021-02-26 | 77478 | 1174 | |
11530 | 11530 | Alameda | Alameda | 1 | 2021-02-25 | 77238 | 1174 | |
11591 | 11591 | Alameda | Alameda | 1 | 2021-02-24 | 77090 | 1173 | |
11652 | 11652 | Alameda | Alameda | 1 | 2021-02-23 | 76951 | 1171 | |
11713 | 11713 | Alameda | Alameda | 1 | 2021-02-22 | 76804 | 1168 | |
11774 | 11774 | Alameda | Alameda | 1 | 2021-02-21 | 76648 | 1166 | |
11835 | 11835 | Alameda | Alameda | 1 | 2021-02-20 | 76494 | 1163 | |
11896 | 11896 | Alameda | Alameda | 1 | 2021-02-19 | 76314 | 1163 | |
11957 | 11957 | Alameda | Alameda | 1 | 2021-02-18 | 76104 | 1162 | |
12018 | 12018 | Alameda | Alameda | 1 | 2021-02-17 | 75868 | 1161 | |
12079 | 12079 | Alameda | Alameda | 1 | 2021-02-16 | 75739 | 1161 | |
12140 | 12140 | Alameda | Alameda | 1 | 2021-02-15 | 75613 | 1160 |
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 );