latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
551 rows where fips = 77 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 77 · 551 ✖
county 1
- San Joaquin 551
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
39 | 39 | 2021-09-02 | San Joaquin | 77 | 87365 | 1540 | 0 | 0 |
97 | 97 | 2021-09-01 | San Joaquin | 77 | 87365 | 1540 | 1443 | 12 |
155 | 155 | 2021-08-31 | San Joaquin | 77 | 85922 | 1528 | 0 | 0 |
213 | 213 | 2021-08-30 | San Joaquin | 77 | 85922 | 1528 | 1493 | 15 |
271 | 271 | 2021-08-29 | San Joaquin | 77 | 84429 | 1513 | 0 | 0 |
329 | 329 | 2021-08-28 | San Joaquin | 77 | 84429 | 1513 | 0 | 0 |
387 | 387 | 2021-08-27 | San Joaquin | 77 | 84429 | 1513 | 963 | 14 |
445 | 445 | 2021-08-26 | San Joaquin | 77 | 83466 | 1499 | 0 | 0 |
503 | 503 | 2021-08-25 | San Joaquin | 77 | 83466 | 1499 | 345 | 1 |
561 | 561 | 2021-08-24 | San Joaquin | 77 | 83121 | 1498 | 0 | 0 |
619 | 619 | 2021-08-23 | San Joaquin | 77 | 83121 | 1498 | 1074 | 7 |
677 | 677 | 2021-08-22 | San Joaquin | 77 | 82047 | 1491 | 0 | 0 |
735 | 735 | 2021-08-21 | San Joaquin | 77 | 82047 | 1491 | 0 | 0 |
793 | 793 | 2021-08-20 | San Joaquin | 77 | 82047 | 1491 | 747 | 2 |
851 | 851 | 2021-08-19 | San Joaquin | 77 | 81300 | 1489 | 0 | 0 |
909 | 909 | 2021-08-18 | San Joaquin | 77 | 81300 | 1489 | 468 | 1 |
967 | 967 | 2021-08-17 | San Joaquin | 77 | 80832 | 1488 | 0 | 0 |
1025 | 1025 | 2021-08-16 | San Joaquin | 77 | 80832 | 1488 | 1191 | 10 |
1083 | 1083 | 2021-08-15 | San Joaquin | 77 | 79641 | 1478 | 0 | 0 |
1141 | 1141 | 2021-08-14 | San Joaquin | 77 | 79641 | 1478 | 0 | 0 |
1199 | 1199 | 2021-08-13 | San Joaquin | 77 | 79641 | 1478 | 0 | 0 |
1257 | 1257 | 2021-08-12 | San Joaquin | 77 | 79641 | 1478 | 0 | 0 |
1315 | 1315 | 2021-08-11 | San Joaquin | 77 | 79641 | 1478 | 0 | 0 |
1373 | 1373 | 2021-08-10 | San Joaquin | 77 | 79641 | 1478 | 1522 | 4 |
1431 | 1431 | 2021-08-09 | San Joaquin | 77 | 78119 | 1474 | 0 | 0 |
1489 | 1489 | 2021-08-08 | San Joaquin | 77 | 78119 | 1474 | 0 | 0 |
1547 | 1547 | 2021-08-07 | San Joaquin | 77 | 78119 | 1474 | 0 | 0 |
1605 | 1605 | 2021-08-06 | San Joaquin | 77 | 78119 | 1474 | 0 | 0 |
1663 | 1663 | 2021-08-05 | San Joaquin | 77 | 78119 | 1474 | 0 | 0 |
1721 | 1721 | 2021-08-04 | San Joaquin | 77 | 78119 | 1474 | 1204 | 14 |
1779 | 1779 | 2021-08-03 | San Joaquin | 77 | 76915 | 1460 | 0 | 0 |
1837 | 1837 | 2021-08-02 | San Joaquin | 77 | 76915 | 1460 | 0 | 0 |
1895 | 1895 | 2021-08-01 | San Joaquin | 77 | 76915 | 1460 | 0 | 0 |
1953 | 1953 | 2021-07-31 | San Joaquin | 77 | 76915 | 1460 | 0 | 0 |
2011 | 2011 | 2021-07-30 | San Joaquin | 77 | 76915 | 1460 | 0 | 0 |
2069 | 2069 | 2021-07-29 | San Joaquin | 77 | 76915 | 1460 | 0 | 0 |
2127 | 2127 | 2021-07-28 | San Joaquin | 77 | 76915 | 1460 | 881 | 14 |
2185 | 2185 | 2021-07-27 | San Joaquin | 77 | 76034 | 1446 | 0 | 0 |
2243 | 2243 | 2021-07-26 | San Joaquin | 77 | 76034 | 1446 | 0 | 0 |
2301 | 2301 | 2021-07-25 | San Joaquin | 77 | 76034 | 1446 | 0 | 0 |
2359 | 2359 | 2021-07-24 | San Joaquin | 77 | 76034 | 1446 | 0 | 0 |
2417 | 2417 | 2021-07-23 | San Joaquin | 77 | 76034 | 1446 | 0 | 0 |
2475 | 2475 | 2021-07-22 | San Joaquin | 77 | 76034 | 1446 | 0 | 0 |
2533 | 2533 | 2021-07-21 | San Joaquin | 77 | 76034 | 1446 | 0 | 0 |
2591 | 2591 | 2021-07-20 | San Joaquin | 77 | 76034 | 1446 | 534 | 0 |
2649 | 2649 | 2021-07-19 | San Joaquin | 77 | 75500 | 1446 | -534 | 0 |
2707 | 2707 | 2021-07-18 | San Joaquin | 77 | 76034 | 1446 | 534 | 0 |
2765 | 2765 | 2021-07-17 | San Joaquin | 77 | 75500 | 1446 | 0 | 0 |
2823 | 2823 | 2021-07-16 | San Joaquin | 77 | 75500 | 1446 | 0 | 0 |
2881 | 2881 | 2021-07-15 | San Joaquin | 77 | 75500 | 1446 | 0 | 0 |
2939 | 2939 | 2021-07-14 | San Joaquin | 77 | 75500 | 1446 | 367 | 4 |
2997 | 2997 | 2021-07-13 | San Joaquin | 77 | 75133 | 1442 | 0 | 0 |
3055 | 3055 | 2021-07-12 | San Joaquin | 77 | 75133 | 1442 | 0 | 0 |
3113 | 3113 | 2021-07-11 | San Joaquin | 77 | 75133 | 1442 | 0 | 0 |
3171 | 3171 | 2021-07-10 | San Joaquin | 77 | 75133 | 1442 | 0 | 0 |
3229 | 3229 | 2021-07-09 | San Joaquin | 77 | 75133 | 1442 | 0 | 0 |
3287 | 3287 | 2021-07-08 | San Joaquin | 77 | 75133 | 1442 | 0 | 0 |
3345 | 3345 | 2021-07-07 | San Joaquin | 77 | 75133 | 1442 | 0 | 0 |
3403 | 3403 | 2021-07-06 | San Joaquin | 77 | 75133 | 1442 | 233 | 0 |
3461 | 3461 | 2021-07-05 | San Joaquin | 77 | 74900 | 1442 | 0 | -2 |
3519 | 3519 | 2021-07-04 | San Joaquin | 77 | 74900 | 1444 | 0 | 0 |
3577 | 3577 | 2021-07-03 | San Joaquin | 77 | 74900 | 1444 | 0 | 0 |
3635 | 3635 | 2021-07-02 | San Joaquin | 77 | 74900 | 1444 | 0 | 0 |
3693 | 3693 | 2021-07-01 | San Joaquin | 77 | 74900 | 1444 | 0 | 0 |
3751 | 3751 | 2021-06-30 | San Joaquin | 77 | 74900 | 1444 | 0 | 0 |
3809 | 3809 | 2021-06-29 | San Joaquin | 77 | 74900 | 1444 | 92 | 4 |
3867 | 3867 | 2021-06-28 | San Joaquin | 77 | 74808 | 1440 | 0 | 0 |
3925 | 3925 | 2021-06-27 | San Joaquin | 77 | 74808 | 1440 | 0 | 0 |
3983 | 3983 | 2021-06-26 | San Joaquin | 77 | 74808 | 1440 | 0 | 0 |
4041 | 4041 | 2021-06-25 | San Joaquin | 77 | 74808 | 1440 | 0 | 0 |
4099 | 4099 | 2021-06-24 | San Joaquin | 77 | 74808 | 1440 | 0 | 0 |
4157 | 4157 | 2021-06-23 | San Joaquin | 77 | 74808 | 1440 | 0 | 0 |
4215 | 4215 | 2021-06-22 | San Joaquin | 77 | 74808 | 1440 | 81 | 0 |
4273 | 4273 | 2021-06-21 | San Joaquin | 77 | 74727 | 1440 | 41 | 2 |
4331 | 4331 | 2021-06-20 | San Joaquin | 77 | 74686 | 1438 | 0 | 0 |
4389 | 4389 | 2021-06-19 | San Joaquin | 77 | 74686 | 1438 | 0 | 0 |
4447 | 4447 | 2021-06-18 | San Joaquin | 77 | 74686 | 1438 | 57 | 0 |
4505 | 4505 | 2021-06-17 | San Joaquin | 77 | 74629 | 1438 | 33 | 3 |
4563 | 4563 | 2021-06-16 | San Joaquin | 77 | 74596 | 1435 | 37 | 0 |
4621 | 4621 | 2021-06-15 | San Joaquin | 77 | 74559 | 1435 | 140 | 3 |
4679 | 4679 | 2021-06-14 | San Joaquin | 77 | 74419 | 1432 | 18 | 0 |
4737 | 4737 | 2021-06-13 | San Joaquin | 77 | 74401 | 1432 | 0 | 0 |
4795 | 4795 | 2021-06-12 | San Joaquin | 77 | 74401 | 1432 | 0 | 0 |
4853 | 4853 | 2021-06-11 | San Joaquin | 77 | 74401 | 1432 | 51 | 3 |
4911 | 4911 | 2021-06-10 | San Joaquin | 77 | 74350 | 1429 | 63 | 1 |
4969 | 4969 | 2021-06-09 | San Joaquin | 77 | 74287 | 1428 | 30 | 2 |
5027 | 5027 | 2021-06-08 | San Joaquin | 77 | 74257 | 1426 | 96 | 3 |
5085 | 5085 | 2021-06-07 | San Joaquin | 77 | 74161 | 1423 | 47 | 0 |
5143 | 5143 | 2021-06-06 | San Joaquin | 77 | 74114 | 1423 | 0 | 0 |
5201 | 5201 | 2021-06-05 | San Joaquin | 77 | 74114 | 1423 | 0 | 0 |
5259 | 5259 | 2021-06-04 | San Joaquin | 77 | 74114 | 1423 | 54 | 0 |
5317 | 5317 | 2021-06-03 | San Joaquin | 77 | 74060 | 1423 | 92 | 0 |
5375 | 5375 | 2021-06-02 | San Joaquin | 77 | 73968 | 1423 | 69 | 4 |
5433 | 5433 | 2021-06-01 | San Joaquin | 77 | 73899 | 1419 | 105 | 0 |
5491 | 5491 | 2021-05-31 | San Joaquin | 77 | 73794 | 1419 | 0 | 0 |
5549 | 5549 | 2021-05-30 | San Joaquin | 77 | 73794 | 1419 | 0 | 0 |
5607 | 5607 | 2021-05-29 | San Joaquin | 77 | 73794 | 1419 | 0 | 0 |
5665 | 5665 | 2021-05-28 | San Joaquin | 77 | 73794 | 1419 | 0 | 0 |
5723 | 5723 | 2021-05-27 | San Joaquin | 77 | 73794 | 1419 | 36 | 0 |
5781 | 5781 | 2021-05-26 | San Joaquin | 77 | 73758 | 1419 | 41 | 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 );