latimes_county_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals

551 rows where county = "San Joaquin" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);