latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
551 rows where fips = 77 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▼ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
27492 | 27492 | San Joaquin | San Joaquin | 77 | 2020-06-09 | 1258 | 39 | |
27431 | 27431 | San Joaquin | San Joaquin | 77 | 2020-06-10 | 1311 | 40 | |
27370 | 27370 | San Joaquin | San Joaquin | 77 | 2020-06-11 | 1397 | 42 | |
27309 | 27309 | San Joaquin | San Joaquin | 77 | 2020-06-12 | 1440 | 42 | |
27248 | 27248 | San Joaquin | San Joaquin | 77 | 2020-06-13 | 1587 | 42 | |
27187 | 27187 | San Joaquin | San Joaquin | 77 | 2020-06-14 | 1686 | 42 | |
27126 | 27126 | San Joaquin | San Joaquin | 77 | 2020-06-15 | 1717 | 42 | |
27065 | 27065 | San Joaquin | San Joaquin | 77 | 2020-06-16 | 1781 | 45 | |
27004 | 27004 | San Joaquin | San Joaquin | 77 | 2020-06-17 | 1919 | 45 | |
26943 | 26943 | San Joaquin | San Joaquin | 77 | 2020-06-18 | 2031 | 45 | |
26882 | 26882 | San Joaquin | San Joaquin | 77 | 2020-06-19 | 2129 | 45 | |
26821 | 26821 | San Joaquin | San Joaquin | 77 | 2020-06-20 | 2271 | 45 | |
26760 | 26760 | San Joaquin | San Joaquin | 77 | 2020-06-21 | 2343 | 45 | |
26699 | 26699 | San Joaquin | San Joaquin | 77 | 2020-06-22 | 2458 | 48 | |
26638 | 26638 | San Joaquin | San Joaquin | 77 | 2020-06-23 | 2635 | 48 | |
26577 | 26577 | San Joaquin | San Joaquin | 77 | 2020-06-24 | 2784 | 49 | |
26516 | 26516 | San Joaquin | San Joaquin | 77 | 2020-06-25 | 2954 | 49 | |
26455 | 26455 | San Joaquin | San Joaquin | 77 | 2020-06-26 | 3140 | 52 | |
26394 | 26394 | San Joaquin | San Joaquin | 77 | 2020-06-27 | 3214 | 52 | |
26333 | 26333 | San Joaquin | San Joaquin | 77 | 2020-06-28 | 3417 | 52 | |
26272 | 26272 | San Joaquin | San Joaquin | 77 | 2020-06-29 | 3607 | 52 | |
26211 | 26211 | San Joaquin | San Joaquin | 77 | 2020-06-30 | 3899 | 52 | |
26150 | 26150 | San Joaquin | San Joaquin | 77 | 2020-07-01 | 4103 | 54 | |
26089 | 26089 | San Joaquin | San Joaquin | 77 | 2020-07-02 | 4317 | 55 | |
26028 | 26028 | San Joaquin | San Joaquin | 77 | 2020-07-03 | 4523 | 55 | |
25967 | 25967 | San Joaquin | San Joaquin | 77 | 2020-07-04 | 4907 | 55 | |
25906 | 25906 | San Joaquin | San Joaquin | 77 | 2020-07-05 | 5231 | 55 | |
25845 | 25845 | San Joaquin | San Joaquin | 77 | 2020-07-06 | 5451 | 55 | |
25784 | 25784 | San Joaquin | San Joaquin | 77 | 2020-07-07 | 5600 | 58 | |
25723 | 25723 | San Joaquin | San Joaquin | 77 | 2020-07-08 | 5817 | 61 | |
25662 | 25662 | San Joaquin | San Joaquin | 77 | 2020-07-09 | 6065 | 67 | |
25601 | 25601 | San Joaquin | San Joaquin | 77 | 2020-07-10 | 6279 | 68 | |
25540 | 25540 | San Joaquin | San Joaquin | 77 | 2020-07-11 | 6279 | 68 | TRUE |
25479 | 25479 | San Joaquin | San Joaquin | 77 | 2020-07-12 | 6279 | 68 | TRUE |
25418 | 25418 | San Joaquin | San Joaquin | 77 | 2020-07-13 | 6988 | 70 | |
25357 | 25357 | San Joaquin | San Joaquin | 77 | 2020-07-14 | 7216 | 73 | |
25296 | 25296 | San Joaquin | San Joaquin | 77 | 2020-07-15 | 7428 | 73 | |
25235 | 25235 | San Joaquin | San Joaquin | 77 | 2020-07-16 | 7680 | 81 | |
25174 | 25174 | San Joaquin | San Joaquin | 77 | 2020-07-17 | 7819 | 83 | |
25113 | 25113 | San Joaquin | San Joaquin | 77 | 2020-07-18 | 7819 | 83 | TRUE |
25052 | 25052 | San Joaquin | San Joaquin | 77 | 2020-07-19 | 7819 | 83 | TRUE |
24991 | 24991 | San Joaquin | San Joaquin | 77 | 2020-07-20 | 8321 | 94 | |
24930 | 24930 | San Joaquin | San Joaquin | 77 | 2020-07-21 | 8799 | 95 | |
24869 | 24869 | San Joaquin | San Joaquin | 77 | 2020-07-22 | 9595 | 98 | |
24808 | 24808 | San Joaquin | San Joaquin | 77 | 2020-07-23 | 9826 | 107 | |
24747 | 24747 | San Joaquin | San Joaquin | 77 | 2020-07-24 | 10126 | 110 | |
24686 | 24686 | San Joaquin | San Joaquin | 77 | 2020-07-25 | 10126 | 110 | TRUE |
24625 | 24625 | San Joaquin | San Joaquin | 77 | 2020-07-26 | 10126 | 110 | TRUE |
24564 | 24564 | San Joaquin | San Joaquin | 77 | 2020-07-27 | 10675 | 118 | |
24503 | 24503 | San Joaquin | San Joaquin | 77 | 2020-07-28 | 10923 | 133 | |
24442 | 24442 | San Joaquin | San Joaquin | 77 | 2020-07-29 | 11209 | 146 | |
24381 | 24381 | San Joaquin | San Joaquin | 77 | 2020-07-30 | 11342 | 151 | |
24320 | 24320 | San Joaquin | San Joaquin | 77 | 2020-07-31 | 11483 | 168 | |
24259 | 24259 | San Joaquin | San Joaquin | 77 | 2020-08-01 | 11483 | 168 | TRUE |
24198 | 24198 | San Joaquin | San Joaquin | 77 | 2020-08-02 | 11483 | 168 | TRUE |
24137 | 24137 | San Joaquin | San Joaquin | 77 | 2020-08-03 | 11885 | 180 | |
24076 | 24076 | San Joaquin | San Joaquin | 77 | 2020-08-04 | 11958 | 180 | |
24015 | 24015 | San Joaquin | San Joaquin | 77 | 2020-08-05 | 12034 | 187 | |
23954 | 23954 | San Joaquin | San Joaquin | 77 | 2020-08-06 | 12119 | 192 | |
23893 | 23893 | San Joaquin | San Joaquin | 77 | 2020-08-07 | 12303 | 211 | |
23832 | 23832 | San Joaquin | San Joaquin | 77 | 2020-08-08 | 12303 | 211 | TRUE |
23771 | 23771 | San Joaquin | San Joaquin | 77 | 2020-08-09 | 12303 | 211 | TRUE |
23710 | 23710 | San Joaquin | San Joaquin | 77 | 2020-08-10 | 12864 | 223 | |
23649 | 23649 | San Joaquin | San Joaquin | 77 | 2020-08-11 | 13870 | 235 | |
23588 | 23588 | San Joaquin | San Joaquin | 77 | 2020-08-12 | 14026 | 239 | |
23527 | 23527 | San Joaquin | San Joaquin | 77 | 2020-08-13 | 14276 | 245 | |
23466 | 23466 | San Joaquin | San Joaquin | 77 | 2020-08-14 | 14651 | 261 | |
23405 | 23405 | San Joaquin | San Joaquin | 77 | 2020-08-15 | 14651 | 261 | TRUE |
23344 | 23344 | San Joaquin | San Joaquin | 77 | 2020-08-16 | 14651 | 261 | TRUE |
23283 | 23283 | San Joaquin | San Joaquin | 77 | 2020-08-17 | 15008 | 269 | |
23222 | 23222 | San Joaquin | San Joaquin | 77 | 2020-08-18 | 15201 | 280 | |
23161 | 23161 | San Joaquin | San Joaquin | 77 | 2020-08-19 | 15379 | 287 | |
23100 | 23100 | San Joaquin | San Joaquin | 77 | 2020-08-20 | 15492 | 288 | |
23039 | 23039 | San Joaquin | San Joaquin | 77 | 2020-08-21 | 15622 | 294 | |
22978 | 22978 | San Joaquin | San Joaquin | 77 | 2020-08-22 | 15622 | 294 | TRUE |
22917 | 22917 | San Joaquin | San Joaquin | 77 | 2020-08-23 | 15622 | 294 | TRUE |
22856 | 22856 | San Joaquin | San Joaquin | 77 | 2020-08-24 | 16131 | 297 | |
22795 | 22795 | San Joaquin | San Joaquin | 77 | 2020-08-25 | 16545 | 297 | |
22734 | 22734 | San Joaquin | San Joaquin | 77 | 2020-08-26 | 16615 | 297 | |
22673 | 22673 | San Joaquin | San Joaquin | 77 | 2020-08-27 | 16773 | 305 | |
22612 | 22612 | San Joaquin | San Joaquin | 77 | 2020-08-28 | 16913 | 307 | |
22551 | 22551 | San Joaquin | San Joaquin | 77 | 2020-08-29 | 16913 | 307 | TRUE |
22490 | 22490 | San Joaquin | San Joaquin | 77 | 2020-08-30 | 16913 | 307 | TRUE |
22429 | 22429 | San Joaquin | San Joaquin | 77 | 2020-08-31 | 17497 | 328 | |
22368 | 22368 | San Joaquin | San Joaquin | 77 | 2020-09-01 | 17620 | 330 | |
22307 | 22307 | San Joaquin | San Joaquin | 77 | 2020-09-02 | 17778 | 344 | |
22246 | 22246 | San Joaquin | San Joaquin | 77 | 2020-09-03 | 18000 | 361 | |
22185 | 22185 | San Joaquin | San Joaquin | 77 | 2020-09-04 | 18099 | 368 | |
22124 | 22124 | San Joaquin | San Joaquin | 77 | 2020-09-05 | 18099 | 368 | TRUE |
22063 | 22063 | San Joaquin | San Joaquin | 77 | 2020-09-06 | 18099 | 368 | TRUE |
22002 | 22002 | San Joaquin | San Joaquin | 77 | 2020-09-07 | 18099 | 368 | TRUE |
21941 | 21941 | San Joaquin | San Joaquin | 77 | 2020-09-08 | 18204 | 377 | |
21880 | 21880 | San Joaquin | San Joaquin | 77 | 2020-09-09 | 18464 | 382 | |
21819 | 21819 | San Joaquin | San Joaquin | 77 | 2020-09-10 | 18528 | 383 | |
21758 | 21758 | San Joaquin | San Joaquin | 77 | 2020-09-11 | 18687 | 383 | |
21697 | 21697 | San Joaquin | San Joaquin | 77 | 2020-09-12 | 18687 | 383 | TRUE |
21636 | 21636 | San Joaquin | San Joaquin | 77 | 2020-09-13 | 18687 | 383 | TRUE |
21575 | 21575 | San Joaquin | San Joaquin | 77 | 2020-09-14 | 19364 | 389 | |
21514 | 21514 | San Joaquin | San Joaquin | 77 | 2020-09-15 | 19564 | 392 | |
21453 | 21453 | San Joaquin | San Joaquin | 77 | 2020-09-16 | 19623 | 399 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );