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 new_deaths
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 ▼ |
---|---|---|---|---|---|---|---|---|
3461 | 3461 | 2021-07-05 | San Joaquin | 77 | 74900 | 1442 | 0 | -2 |
19759 | 19759 | 2020-09-27 | San Joaquin | 77 | 20194 | 440 | 0 | -1 |
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 |
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 |
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 |
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 |
4215 | 4215 | 2021-06-22 | San Joaquin | 77 | 74808 | 1440 | 81 | 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 |
4447 | 4447 | 2021-06-18 | San Joaquin | 77 | 74686 | 1438 | 57 | 0 |
4563 | 4563 | 2021-06-16 | San Joaquin | 77 | 74596 | 1435 | 37 | 0 |
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 |
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 |
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 |
5955 | 5955 | 2021-05-23 | San Joaquin | 77 | 73544 | 1402 | 0 | 0 |
6013 | 6013 | 2021-05-22 | San Joaquin | 77 | 73544 | 1402 | 0 | 0 |
6071 | 6071 | 2021-05-21 | San Joaquin | 77 | 73544 | 1402 | 68 | 0 |
6303 | 6303 | 2021-05-17 | San Joaquin | 77 | 73339 | 1394 | 29 | 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 |
6535 | 6535 | 2021-05-13 | San Joaquin | 77 | 73267 | 1391 | 47 | 0 |
6593 | 6593 | 2021-05-12 | San Joaquin | 77 | 73220 | 1391 | 40 | 0 |
6651 | 6651 | 2021-05-11 | San Joaquin | 77 | 73180 | 1391 | 6 | 0 |
6709 | 6709 | 2021-05-10 | San Joaquin | 77 | 73174 | 1391 | 165 | 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 |
6883 | 6883 | 2021-05-07 | San Joaquin | 77 | 73009 | 1391 | 67 | 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 |
7289 | 7289 | 2021-04-30 | San Joaquin | 77 | 72478 | 1346 | 83 | 0 |
7347 | 7347 | 2021-04-29 | San Joaquin | 77 | 72395 | 1346 | 50 | 0 |
7405 | 7405 | 2021-04-28 | San Joaquin | 77 | 72345 | 1346 | 64 | 0 |
7463 | 7463 | 2021-04-27 | San Joaquin | 77 | 72281 | 1346 | 294 | 0 |
7579 | 7579 | 2021-04-25 | San Joaquin | 77 | 71972 | 1340 | 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 );