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 date
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 |
---|---|---|---|---|---|---|---|---|
31059 | 31059 | 2020-03-01 | San Joaquin | 77 | 0 | 0 | ||
31035 | 31035 | 2020-03-02 | San Joaquin | 77 | 0 | 0 | 0 | 0 |
31011 | 31011 | 2020-03-03 | San Joaquin | 77 | 0 | 0 | 0 | 0 |
30987 | 30987 | 2020-03-04 | San Joaquin | 77 | 0 | 0 | 0 | 0 |
30963 | 30963 | 2020-03-05 | San Joaquin | 77 | 1 | 0 | 1 | 0 |
30939 | 30939 | 2020-03-06 | San Joaquin | 77 | 1 | 0 | 0 | 0 |
30915 | 30915 | 2020-03-07 | San Joaquin | 77 | 1 | 0 | 0 | 0 |
30890 | 30890 | 2020-03-08 | San Joaquin | 77 | 2 | 0 | 1 | 0 |
30865 | 30865 | 2020-03-09 | San Joaquin | 77 | 2 | 0 | 0 | 0 |
30840 | 30840 | 2020-03-10 | San Joaquin | 77 | 2 | 0 | 0 | 0 |
30814 | 30814 | 2020-03-11 | San Joaquin | 77 | 3 | 0 | 1 | 0 |
30787 | 30787 | 2020-03-12 | San Joaquin | 77 | 3 | 0 | 0 | 0 |
30760 | 30760 | 2020-03-13 | San Joaquin | 77 | 4 | 0 | 1 | 0 |
30731 | 30731 | 2020-03-14 | San Joaquin | 77 | 6 | 0 | 2 | 0 |
30701 | 30701 | 2020-03-15 | San Joaquin | 77 | 6 | 0 | 0 | 0 |
30670 | 30670 | 2020-03-16 | San Joaquin | 77 | 6 | 0 | 0 | 0 |
30638 | 30638 | 2020-03-17 | San Joaquin | 77 | 9 | 0 | 3 | 0 |
30604 | 30604 | 2020-03-18 | San Joaquin | 77 | 13 | 2 | 4 | 2 |
30569 | 30569 | 2020-03-19 | San Joaquin | 77 | 14 | 2 | 1 | 0 |
30534 | 30534 | 2020-03-20 | San Joaquin | 77 | 17 | 2 | 3 | 0 |
30496 | 30496 | 2020-03-21 | San Joaquin | 77 | 24 | 2 | 7 | 0 |
30456 | 30456 | 2020-03-22 | San Joaquin | 77 | 29 | 2 | 5 | 0 |
30414 | 30414 | 2020-03-23 | San Joaquin | 77 | 36 | 2 | 7 | 0 |
30372 | 30372 | 2020-03-24 | San Joaquin | 77 | 52 | 2 | 16 | 0 |
30329 | 30329 | 2020-03-25 | San Joaquin | 77 | 61 | 3 | 9 | 1 |
30285 | 30285 | 2020-03-26 | San Joaquin | 77 | 75 | 3 | 14 | 0 |
30241 | 30241 | 2020-03-27 | San Joaquin | 77 | 86 | 4 | 11 | 1 |
30194 | 30194 | 2020-03-28 | San Joaquin | 77 | 95 | 4 | 9 | 0 |
30147 | 30147 | 2020-03-29 | San Joaquin | 77 | 108 | 5 | 13 | 1 |
30099 | 30099 | 2020-03-30 | San Joaquin | 77 | 123 | 6 | 15 | 1 |
30050 | 30050 | 2020-03-31 | San Joaquin | 77 | 137 | 8 | 14 | 2 |
29999 | 29999 | 2020-04-01 | San Joaquin | 77 | 151 | 8 | 14 | 0 |
29948 | 29948 | 2020-04-02 | San Joaquin | 77 | 164 | 10 | 13 | 2 |
29896 | 29896 | 2020-04-03 | San Joaquin | 77 | 180 | 11 | 16 | 1 |
29844 | 29844 | 2020-04-04 | San Joaquin | 77 | 186 | 11 | 6 | 0 |
29792 | 29792 | 2020-04-05 | San Joaquin | 77 | 196 | 11 | 10 | 0 |
29739 | 29739 | 2020-04-06 | San Joaquin | 77 | 204 | 11 | 8 | 0 |
29686 | 29686 | 2020-04-07 | San Joaquin | 77 | 216 | 13 | 12 | 2 |
29633 | 29633 | 2020-04-08 | San Joaquin | 77 | 224 | 14 | 8 | 1 |
29580 | 29580 | 2020-04-09 | San Joaquin | 77 | 237 | 14 | 13 | 0 |
29527 | 29527 | 2020-04-10 | San Joaquin | 77 | 249 | 14 | 12 | 0 |
29474 | 29474 | 2020-04-11 | San Joaquin | 77 | 260 | 15 | 11 | 1 |
29421 | 29421 | 2020-04-12 | San Joaquin | 77 | 261 | 16 | 1 | 1 |
29368 | 29368 | 2020-04-13 | San Joaquin | 77 | 273 | 17 | 12 | 1 |
29315 | 29315 | 2020-04-14 | San Joaquin | 77 | 312 | 17 | 39 | 0 |
29262 | 29262 | 2020-04-15 | San Joaquin | 77 | 336 | 17 | 24 | 0 |
29209 | 29209 | 2020-04-16 | San Joaquin | 77 | 361 | 17 | 25 | 0 |
29156 | 29156 | 2020-04-17 | San Joaquin | 77 | 369 | 17 | 8 | 0 |
29103 | 29103 | 2020-04-18 | San Joaquin | 77 | 394 | 17 | 25 | 0 |
29050 | 29050 | 2020-04-19 | San Joaquin | 77 | 408 | 17 | 14 | 0 |
28997 | 28997 | 2020-04-20 | San Joaquin | 77 | 418 | 18 | 10 | 1 |
28944 | 28944 | 2020-04-21 | San Joaquin | 77 | 444 | 20 | 26 | 2 |
28891 | 28891 | 2020-04-22 | San Joaquin | 77 | 455 | 20 | 11 | 0 |
28838 | 28838 | 2020-04-23 | San Joaquin | 77 | 469 | 22 | 14 | 2 |
28785 | 28785 | 2020-04-24 | San Joaquin | 77 | 485 | 24 | 16 | 2 |
28732 | 28732 | 2020-04-25 | San Joaquin | 77 | 492 | 25 | 7 | 1 |
28679 | 28679 | 2020-04-26 | San Joaquin | 77 | 504 | 25 | 12 | 0 |
28626 | 28626 | 2020-04-27 | San Joaquin | 77 | 519 | 25 | 15 | 0 |
28573 | 28573 | 2020-04-28 | San Joaquin | 77 | 525 | 25 | 6 | 0 |
28517 | 28517 | 2020-04-29 | San Joaquin | 77 | 536 | 25 | 11 | 0 |
28459 | 28459 | 2020-04-30 | San Joaquin | 77 | 542 | 25 | 6 | 0 |
28401 | 28401 | 2020-05-01 | San Joaquin | 77 | 555 | 25 | 13 | 0 |
28343 | 28343 | 2020-05-02 | San Joaquin | 77 | 558 | 25 | 3 | 0 |
28285 | 28285 | 2020-05-03 | San Joaquin | 77 | 569 | 25 | 11 | 0 |
28227 | 28227 | 2020-05-04 | San Joaquin | 77 | 573 | 26 | 4 | 1 |
28169 | 28169 | 2020-05-05 | San Joaquin | 77 | 577 | 26 | 4 | 0 |
28111 | 28111 | 2020-05-06 | San Joaquin | 77 | 580 | 27 | 3 | 1 |
28053 | 28053 | 2020-05-07 | San Joaquin | 77 | 583 | 28 | 3 | 1 |
27995 | 27995 | 2020-05-08 | San Joaquin | 77 | 598 | 28 | 15 | 0 |
27937 | 27937 | 2020-05-09 | San Joaquin | 77 | 604 | 28 | 6 | 0 |
27879 | 27879 | 2020-05-10 | San Joaquin | 77 | 613 | 29 | 9 | 1 |
27821 | 27821 | 2020-05-11 | San Joaquin | 77 | 620 | 29 | 7 | 0 |
27763 | 27763 | 2020-05-12 | San Joaquin | 77 | 628 | 30 | 8 | 1 |
27705 | 27705 | 2020-05-13 | San Joaquin | 77 | 636 | 31 | 8 | 1 |
27647 | 27647 | 2020-05-14 | San Joaquin | 77 | 643 | 31 | 7 | 0 |
27589 | 27589 | 2020-05-15 | San Joaquin | 77 | 656 | 31 | 13 | 0 |
27531 | 27531 | 2020-05-16 | San Joaquin | 77 | 668 | 31 | 12 | 0 |
27473 | 27473 | 2020-05-17 | San Joaquin | 77 | 687 | 32 | 19 | 1 |
27415 | 27415 | 2020-05-18 | San Joaquin | 77 | 697 | 32 | 10 | 0 |
27357 | 27357 | 2020-05-19 | San Joaquin | 77 | 707 | 33 | 10 | 1 |
27299 | 27299 | 2020-05-20 | San Joaquin | 77 | 716 | 33 | 9 | 0 |
27241 | 27241 | 2020-05-21 | San Joaquin | 77 | 733 | 33 | 17 | 0 |
27183 | 27183 | 2020-05-22 | San Joaquin | 77 | 752 | 33 | 19 | 0 |
27125 | 27125 | 2020-05-23 | San Joaquin | 77 | 772 | 33 | 20 | 0 |
27067 | 27067 | 2020-05-24 | San Joaquin | 77 | 777 | 33 | 5 | 0 |
27009 | 27009 | 2020-05-25 | San Joaquin | 77 | 809 | 33 | 32 | 0 |
26951 | 26951 | 2020-05-26 | San Joaquin | 77 | 812 | 33 | 3 | 0 |
26893 | 26893 | 2020-05-27 | San Joaquin | 77 | 832 | 34 | 20 | 1 |
26835 | 26835 | 2020-05-28 | San Joaquin | 77 | 844 | 34 | 12 | 0 |
26777 | 26777 | 2020-05-29 | San Joaquin | 77 | 866 | 34 | 22 | 0 |
26719 | 26719 | 2020-05-30 | San Joaquin | 77 | 910 | 34 | 44 | 0 |
26661 | 26661 | 2020-05-31 | San Joaquin | 77 | 928 | 34 | 18 | 0 |
26603 | 26603 | 2020-06-01 | San Joaquin | 77 | 949 | 34 | 21 | 0 |
26545 | 26545 | 2020-06-02 | San Joaquin | 77 | 981 | 35 | 32 | 1 |
26487 | 26487 | 2020-06-03 | San Joaquin | 77 | 1010 | 35 | 29 | 0 |
26429 | 26429 | 2020-06-04 | San Joaquin | 77 | 1030 | 36 | 20 | 1 |
26371 | 26371 | 2020-06-05 | San Joaquin | 77 | 1059 | 36 | 29 | 0 |
26313 | 26313 | 2020-06-06 | San Joaquin | 77 | 1125 | 37 | 66 | 1 |
26255 | 26255 | 2020-06-07 | San Joaquin | 77 | 1170 | 37 | 45 | 0 |
26197 | 26197 | 2020-06-08 | San Joaquin | 77 | 1198 | 37 | 28 | 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 );