latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
198 rows where deaths = 4 and fips = 51 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_confirmed_cases, new_deaths, date (date)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
3332 | 3332 | 2021-07-07 | Mono | 51 | 1300 | 4 | 1 | 0 |
3390 | 3390 | 2021-07-06 | Mono | 51 | 1299 | 4 | 0 | 0 |
3448 | 3448 | 2021-07-05 | Mono | 51 | 1299 | 4 | 0 | 0 |
3506 | 3506 | 2021-07-04 | Mono | 51 | 1299 | 4 | 0 | 0 |
3564 | 3564 | 2021-07-03 | Mono | 51 | 1299 | 4 | 0 | 0 |
3622 | 3622 | 2021-07-02 | Mono | 51 | 1299 | 4 | 0 | 0 |
3680 | 3680 | 2021-07-01 | Mono | 51 | 1299 | 4 | 0 | 0 |
3738 | 3738 | 2021-06-30 | Mono | 51 | 1299 | 4 | 0 | 0 |
3796 | 3796 | 2021-06-29 | Mono | 51 | 1299 | 4 | 0 | 0 |
3854 | 3854 | 2021-06-28 | Mono | 51 | 1299 | 4 | 1 | 0 |
3912 | 3912 | 2021-06-27 | Mono | 51 | 1298 | 4 | 0 | 0 |
3970 | 3970 | 2021-06-26 | Mono | 51 | 1298 | 4 | 0 | 0 |
4028 | 4028 | 2021-06-25 | Mono | 51 | 1298 | 4 | 0 | 0 |
4086 | 4086 | 2021-06-24 | Mono | 51 | 1298 | 4 | 0 | 0 |
4144 | 4144 | 2021-06-23 | Mono | 51 | 1298 | 4 | 0 | 0 |
4202 | 4202 | 2021-06-22 | Mono | 51 | 1298 | 4 | 3 | 0 |
4260 | 4260 | 2021-06-21 | Mono | 51 | 1295 | 4 | 0 | 0 |
4318 | 4318 | 2021-06-20 | Mono | 51 | 1295 | 4 | 0 | 0 |
4376 | 4376 | 2021-06-19 | Mono | 51 | 1295 | 4 | 0 | 0 |
4434 | 4434 | 2021-06-18 | Mono | 51 | 1295 | 4 | 0 | 0 |
4492 | 4492 | 2021-06-17 | Mono | 51 | 1295 | 4 | 0 | 0 |
4550 | 4550 | 2021-06-16 | Mono | 51 | 1295 | 4 | 0 | 0 |
4608 | 4608 | 2021-06-15 | Mono | 51 | 1295 | 4 | 0 | 0 |
4666 | 4666 | 2021-06-14 | Mono | 51 | 1295 | 4 | 0 | 0 |
4724 | 4724 | 2021-06-13 | Mono | 51 | 1295 | 4 | 0 | 0 |
4782 | 4782 | 2021-06-12 | Mono | 51 | 1295 | 4 | 0 | 0 |
4840 | 4840 | 2021-06-11 | Mono | 51 | 1295 | 4 | 1 | 0 |
4898 | 4898 | 2021-06-10 | Mono | 51 | 1294 | 4 | 0 | 0 |
4956 | 4956 | 2021-06-09 | Mono | 51 | 1294 | 4 | 0 | 0 |
5014 | 5014 | 2021-06-08 | Mono | 51 | 1294 | 4 | 0 | 0 |
5072 | 5072 | 2021-06-07 | Mono | 51 | 1294 | 4 | 0 | 0 |
5130 | 5130 | 2021-06-06 | Mono | 51 | 1294 | 4 | 0 | 0 |
5188 | 5188 | 2021-06-05 | Mono | 51 | 1294 | 4 | 0 | 0 |
5246 | 5246 | 2021-06-04 | Mono | 51 | 1294 | 4 | 0 | 0 |
5304 | 5304 | 2021-06-03 | Mono | 51 | 1294 | 4 | 0 | 0 |
5362 | 5362 | 2021-06-02 | Mono | 51 | 1294 | 4 | 0 | 0 |
5420 | 5420 | 2021-06-01 | Mono | 51 | 1294 | 4 | 0 | 0 |
5478 | 5478 | 2021-05-31 | Mono | 51 | 1294 | 4 | 0 | 0 |
5536 | 5536 | 2021-05-30 | Mono | 51 | 1294 | 4 | 0 | 0 |
5594 | 5594 | 2021-05-29 | Mono | 51 | 1294 | 4 | 0 | 0 |
5652 | 5652 | 2021-05-28 | Mono | 51 | 1294 | 4 | 1 | 0 |
5710 | 5710 | 2021-05-27 | Mono | 51 | 1293 | 4 | 0 | 0 |
5768 | 5768 | 2021-05-26 | Mono | 51 | 1293 | 4 | 0 | 0 |
5826 | 5826 | 2021-05-25 | Mono | 51 | 1293 | 4 | 2 | 0 |
5884 | 5884 | 2021-05-24 | Mono | 51 | 1291 | 4 | 3 | 0 |
5942 | 5942 | 2021-05-23 | Mono | 51 | 1288 | 4 | 0 | 0 |
6000 | 6000 | 2021-05-22 | Mono | 51 | 1288 | 4 | 0 | 0 |
6058 | 6058 | 2021-05-21 | Mono | 51 | 1288 | 4 | 0 | 0 |
6116 | 6116 | 2021-05-20 | Mono | 51 | 1288 | 4 | 1 | 0 |
6174 | 6174 | 2021-05-19 | Mono | 51 | 1287 | 4 | 2 | 0 |
6232 | 6232 | 2021-05-18 | Mono | 51 | 1285 | 4 | 1 | 0 |
6290 | 6290 | 2021-05-17 | Mono | 51 | 1284 | 4 | 0 | 0 |
6348 | 6348 | 2021-05-16 | Mono | 51 | 1284 | 4 | 0 | 0 |
6406 | 6406 | 2021-05-15 | Mono | 51 | 1284 | 4 | 0 | 0 |
6464 | 6464 | 2021-05-14 | Mono | 51 | 1284 | 4 | 0 | 0 |
6522 | 6522 | 2021-05-13 | Mono | 51 | 1284 | 4 | 0 | 0 |
6580 | 6580 | 2021-05-12 | Mono | 51 | 1284 | 4 | 0 | 0 |
6638 | 6638 | 2021-05-11 | Mono | 51 | 1284 | 4 | 4 | 0 |
6696 | 6696 | 2021-05-10 | Mono | 51 | 1280 | 4 | 0 | 0 |
6754 | 6754 | 2021-05-09 | Mono | 51 | 1280 | 4 | 0 | 0 |
6812 | 6812 | 2021-05-08 | Mono | 51 | 1280 | 4 | 0 | 0 |
6870 | 6870 | 2021-05-07 | Mono | 51 | 1280 | 4 | 0 | 0 |
6928 | 6928 | 2021-05-06 | Mono | 51 | 1280 | 4 | 1 | 0 |
6986 | 6986 | 2021-05-05 | Mono | 51 | 1279 | 4 | 1 | 0 |
7044 | 7044 | 2021-05-04 | Mono | 51 | 1278 | 4 | 0 | 0 |
7102 | 7102 | 2021-05-03 | Mono | 51 | 1278 | 4 | 1 | 0 |
7160 | 7160 | 2021-05-02 | Mono | 51 | 1277 | 4 | 0 | 0 |
7218 | 7218 | 2021-05-01 | Mono | 51 | 1277 | 4 | 0 | 0 |
7276 | 7276 | 2021-04-30 | Mono | 51 | 1277 | 4 | 0 | 0 |
7334 | 7334 | 2021-04-29 | Mono | 51 | 1277 | 4 | 1 | 0 |
7392 | 7392 | 2021-04-28 | Mono | 51 | 1276 | 4 | 0 | 0 |
7450 | 7450 | 2021-04-27 | Mono | 51 | 1276 | 4 | 0 | 0 |
7508 | 7508 | 2021-04-26 | Mono | 51 | 1276 | 4 | 0 | 0 |
7566 | 7566 | 2021-04-25 | Mono | 51 | 1276 | 4 | 0 | 0 |
7624 | 7624 | 2021-04-24 | Mono | 51 | 1276 | 4 | 0 | 0 |
7682 | 7682 | 2021-04-23 | Mono | 51 | 1276 | 4 | 2 | 0 |
7740 | 7740 | 2021-04-22 | Mono | 51 | 1274 | 4 | 0 | 0 |
7798 | 7798 | 2021-04-21 | Mono | 51 | 1274 | 4 | 0 | 0 |
7856 | 7856 | 2021-04-20 | Mono | 51 | 1274 | 4 | 0 | 0 |
7914 | 7914 | 2021-04-19 | Mono | 51 | 1274 | 4 | 1 | 0 |
7972 | 7972 | 2021-04-18 | Mono | 51 | 1273 | 4 | 0 | 0 |
8030 | 8030 | 2021-04-17 | Mono | 51 | 1273 | 4 | 0 | 0 |
8088 | 8088 | 2021-04-16 | Mono | 51 | 1273 | 4 | 0 | 0 |
8146 | 8146 | 2021-04-15 | Mono | 51 | 1273 | 4 | 0 | 0 |
8204 | 8204 | 2021-04-14 | Mono | 51 | 1273 | 4 | 1 | 0 |
8262 | 8262 | 2021-04-13 | Mono | 51 | 1272 | 4 | 0 | 0 |
8320 | 8320 | 2021-04-12 | Mono | 51 | 1272 | 4 | 2 | 0 |
8378 | 8378 | 2021-04-11 | Mono | 51 | 1270 | 4 | 0 | 0 |
8436 | 8436 | 2021-04-10 | Mono | 51 | 1270 | 4 | 0 | 0 |
8494 | 8494 | 2021-04-09 | Mono | 51 | 1270 | 4 | 0 | 0 |
8552 | 8552 | 2021-04-08 | Mono | 51 | 1270 | 4 | 1 | 0 |
8610 | 8610 | 2021-04-07 | Mono | 51 | 1269 | 4 | 1 | 0 |
8668 | 8668 | 2021-04-06 | Mono | 51 | 1268 | 4 | 0 | 0 |
8726 | 8726 | 2021-04-05 | Mono | 51 | 1268 | 4 | 0 | 0 |
8784 | 8784 | 2021-04-04 | Mono | 51 | 1268 | 4 | 0 | 0 |
8842 | 8842 | 2021-04-03 | Mono | 51 | 1268 | 4 | 0 | 0 |
8900 | 8900 | 2021-04-02 | Mono | 51 | 1268 | 4 | 1 | 0 |
8958 | 8958 | 2021-04-01 | Mono | 51 | 1267 | 4 | 3 | 0 |
9016 | 9016 | 2021-03-31 | Mono | 51 | 1264 | 4 | 0 | 0 |
9074 | 9074 | 2021-03-30 | Mono | 51 | 1264 | 4 | 2 | 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 );