latimes_county_totals
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 new_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases ▼ | new_deaths |
---|---|---|---|---|---|---|---|---|
2649 | 2649 | 2021-07-19 | San Joaquin | 77 | 75500 | 1446 | -534 | 0 |
39 | 39 | 2021-09-02 | San Joaquin | 77 | 87365 | 1540 | 0 | 0 |
155 | 155 | 2021-08-31 | San Joaquin | 77 | 85922 | 1528 | 0 | 0 |
271 | 271 | 2021-08-29 | San Joaquin | 77 | 84429 | 1513 | 0 | 0 |
329 | 329 | 2021-08-28 | San Joaquin | 77 | 84429 | 1513 | 0 | 0 |
445 | 445 | 2021-08-26 | San Joaquin | 77 | 83466 | 1499 | 0 | 0 |
561 | 561 | 2021-08-24 | San Joaquin | 77 | 83121 | 1498 | 0 | 0 |
677 | 677 | 2021-08-22 | San Joaquin | 77 | 82047 | 1491 | 0 | 0 |
735 | 735 | 2021-08-21 | San Joaquin | 77 | 82047 | 1491 | 0 | 0 |
851 | 851 | 2021-08-19 | San Joaquin | 77 | 81300 | 1489 | 0 | 0 |
967 | 967 | 2021-08-17 | San Joaquin | 77 | 80832 | 1488 | 0 | 0 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
4331 | 4331 | 2021-06-20 | San Joaquin | 77 | 74686 | 1438 | 0 | 0 |
4389 | 4389 | 2021-06-19 | San Joaquin | 77 | 74686 | 1438 | 0 | 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 |
5143 | 5143 | 2021-06-06 | San Joaquin | 77 | 74114 | 1423 | 0 | 0 |
5201 | 5201 | 2021-06-05 | San Joaquin | 77 | 74114 | 1423 | 0 | 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 |
5955 | 5955 | 2021-05-23 | San Joaquin | 77 | 73544 | 1402 | 0 | 0 |
6013 | 6013 | 2021-05-22 | San Joaquin | 77 | 73544 | 1402 | 0 | 0 |
6361 | 6361 | 2021-05-16 | San Joaquin | 77 | 73310 | 1394 | 0 | 0 |
6419 | 6419 | 2021-05-15 | San Joaquin | 77 | 73310 | 1394 | 0 | 0 |
6767 | 6767 | 2021-05-09 | San Joaquin | 77 | 73009 | 1391 | 0 | 0 |
6825 | 6825 | 2021-05-08 | San Joaquin | 77 | 73009 | 1391 | 0 | 0 |
7173 | 7173 | 2021-05-02 | San Joaquin | 77 | 72478 | 1346 | 0 | 0 |
7231 | 7231 | 2021-05-01 | San Joaquin | 77 | 72478 | 1346 | 0 | 0 |
7579 | 7579 | 2021-04-25 | San Joaquin | 77 | 71972 | 1340 | 0 | 0 |
7637 | 7637 | 2021-04-24 | San Joaquin | 77 | 71972 | 1340 | 0 | 0 |
7985 | 7985 | 2021-04-18 | San Joaquin | 77 | 71431 | 1334 | 0 | 0 |
8043 | 8043 | 2021-04-17 | San Joaquin | 77 | 71431 | 1334 | 0 | 0 |
8391 | 8391 | 2021-04-11 | San Joaquin | 77 | 70746 | 1328 | 0 | 0 |
8449 | 8449 | 2021-04-10 | San Joaquin | 77 | 70746 | 1328 | 0 | 0 |
8797 | 8797 | 2021-04-04 | San Joaquin | 77 | 70117 | 1310 | 0 | 0 |
8855 | 8855 | 2021-04-03 | San Joaquin | 77 | 70117 | 1310 | 0 | 0 |
9203 | 9203 | 2021-03-28 | San Joaquin | 77 | 69448 | 1250 | 0 | 0 |
9261 | 9261 | 2021-03-27 | San Joaquin | 77 | 69448 | 1250 | 0 | 0 |
9609 | 9609 | 2021-03-21 | San Joaquin | 77 | 68714 | 1229 | 0 | 0 |
9667 | 9667 | 2021-03-20 | San Joaquin | 77 | 68714 | 1229 | 0 | 0 |
9957 | 9957 | 2021-03-15 | San Joaquin | 77 | 67817 | 1210 | 0 | 0 |
10015 | 10015 | 2021-03-14 | San Joaquin | 77 | 67817 | 1210 | 0 | 0 |
10073 | 10073 | 2021-03-13 | San Joaquin | 77 | 67817 | 1210 | 0 | 0 |
10131 | 10131 | 2021-03-12 | San Joaquin | 77 | 67817 | 1210 | 0 | 0 |
10421 | 10421 | 2021-03-07 | San Joaquin | 77 | 67284 | 1182 | 0 | 0 |
10479 | 10479 | 2021-03-06 | San Joaquin | 77 | 67284 | 1182 | 0 | 0 |
10827 | 10827 | 2021-02-28 | San Joaquin | 77 | 66709 | 1101 | 0 | 0 |
10885 | 10885 | 2021-02-27 | San Joaquin | 77 | 66709 | 1101 | 0 | 0 |
11233 | 11233 | 2021-02-21 | San Joaquin | 77 | 65891 | 1026 | 0 | 0 |
11291 | 11291 | 2021-02-20 | San Joaquin | 77 | 65891 | 1026 | 0 | 0 |
11581 | 11581 | 2021-02-15 | San Joaquin | 77 | 64969 | 992 | 0 | 0 |
11639 | 11639 | 2021-02-14 | San Joaquin | 77 | 64969 | 992 | 0 | 0 |
11697 | 11697 | 2021-02-13 | San Joaquin | 77 | 64969 | 992 | 0 | 0 |
12045 | 12045 | 2021-02-07 | San Joaquin | 77 | 63619 | 893 | 0 | 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 );