latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where fips = 75 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date ▼ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
33012 | 33012 | San Francisco | San Francisco | 75 | 2020-01-26 | 0 | 0 | |
32976 | 32976 | San Francisco | San Francisco | 75 | 2020-01-31 | 0 | 0 | |
32949 | 32949 | San Francisco | San Francisco | 75 | 2020-02-02 | 0 | 0 | |
32857 | 32857 | San Francisco | San Francisco | 75 | 2020-02-20 | 0 | 0 | |
32833 | 32833 | San Francisco | San Francisco | 75 | 2020-02-21 | 0 | 0 | |
32785 | 32785 | San Francisco | San Francisco | 75 | 2020-02-26 | 0 | 0 | |
32752 | 32752 | San Francisco | San Francisco | 75 | 2020-02-28 | 0 | 0 | |
32727 | 32727 | San Francisco | San Francisco | 75 | 2020-02-29 | 0 | 0 | |
32701 | 32701 | San Francisco | San Francisco | 75 | 2020-03-01 | 0 | 0 | |
32675 | 32675 | San Francisco | San Francisco | 75 | 2020-03-02 | 0 | 0 | |
32649 | 32649 | San Francisco | San Francisco | 75 | 2020-03-03 | 0 | 0 | |
32623 | 32623 | San Francisco | San Francisco | 75 | 2020-03-04 | 0 | 0 | |
32597 | 32597 | San Francisco | San Francisco | 75 | 2020-03-05 | 2 | 0 | |
32571 | 32571 | San Francisco | San Francisco | 75 | 2020-03-06 | 2 | 0 | |
32545 | 32545 | San Francisco | San Francisco | 75 | 2020-03-07 | 8 | 0 | |
32518 | 32518 | San Francisco | San Francisco | 75 | 2020-03-08 | 8 | 0 | |
32491 | 32491 | San Francisco | San Francisco | 75 | 2020-03-09 | 13 | 0 | |
32464 | 32464 | San Francisco | San Francisco | 75 | 2020-03-10 | 14 | 0 | |
32436 | 32436 | San Francisco | San Francisco | 75 | 2020-03-11 | 14 | 0 | |
32406 | 32406 | San Francisco | San Francisco | 75 | 2020-03-12 | 18 | 0 | |
32376 | 32376 | San Francisco | San Francisco | 75 | 2020-03-13 | 23 | 0 | |
32344 | 32344 | San Francisco | San Francisco | 75 | 2020-03-14 | 28 | 0 | |
32311 | 32311 | San Francisco | San Francisco | 75 | 2020-03-15 | 37 | 0 | |
32277 | 32277 | San Francisco | San Francisco | 75 | 2020-03-16 | 40 | 0 | |
32242 | 32242 | San Francisco | San Francisco | 75 | 2020-03-17 | 43 | 0 | |
32205 | 32205 | San Francisco | San Francisco | 75 | 2020-03-18 | 51 | 0 | |
32167 | 32167 | San Francisco | San Francisco | 75 | 2020-03-19 | 70 | 0 | |
32129 | 32129 | San Francisco | San Francisco | 75 | 2020-03-20 | 76 | 0 | |
32088 | 32088 | San Francisco | San Francisco | 75 | 2020-03-21 | 84 | 0 | |
32045 | 32045 | San Francisco | San Francisco | 75 | 2020-03-22 | 108 | 0 | |
32000 | 32000 | San Francisco | San Francisco | 75 | 2020-03-23 | 131 | 0 | |
31955 | 31955 | San Francisco | San Francisco | 75 | 2020-03-24 | 152 | 1 | |
31909 | 31909 | San Francisco | San Francisco | 75 | 2020-03-25 | 178 | 1 | |
31862 | 31862 | San Francisco | San Francisco | 75 | 2020-03-26 | 223 | 2 | |
31815 | 31815 | San Francisco | San Francisco | 75 | 2020-03-27 | 279 | 3 | |
31765 | 31765 | San Francisco | San Francisco | 75 | 2020-03-28 | 308 | 4 | |
31715 | 31715 | San Francisco | San Francisco | 75 | 2020-03-29 | 340 | 5 | |
31664 | 31664 | San Francisco | San Francisco | 75 | 2020-03-30 | 374 | 6 | |
31612 | 31612 | San Francisco | San Francisco | 75 | 2020-03-31 | 397 | 6 | |
31558 | 31558 | San Francisco | San Francisco | 75 | 2020-04-01 | 434 | 7 | |
31504 | 31504 | San Francisco | San Francisco | 75 | 2020-04-02 | 450 | 7 | |
31449 | 31449 | San Francisco | San Francisco | 75 | 2020-04-03 | 497 | 7 | |
31394 | 31394 | San Francisco | San Francisco | 75 | 2020-04-04 | 529 | 8 | |
31339 | 31339 | San Francisco | San Francisco | 75 | 2020-04-05 | 568 | 8 | |
31283 | 31283 | San Francisco | San Francisco | 75 | 2020-04-06 | 583 | 9 | |
31227 | 31227 | San Francisco | San Francisco | 75 | 2020-04-07 | 622 | 9 | |
31171 | 31171 | San Francisco | San Francisco | 75 | 2020-04-08 | 676 | 10 | |
31115 | 31115 | San Francisco | San Francisco | 75 | 2020-04-09 | 724 | 10 | |
31059 | 31059 | San Francisco | San Francisco | 75 | 2020-04-10 | 797 | 13 | |
31003 | 31003 | San Francisco | San Francisco | 75 | 2020-04-11 | 857 | 13 | |
30947 | 30947 | San Francisco | San Francisco | 75 | 2020-04-12 | 872 | 14 | |
30891 | 30891 | San Francisco | San Francisco | 75 | 2020-04-13 | 957 | 15 | |
30835 | 30835 | San Francisco | San Francisco | 75 | 2020-04-14 | 987 | 15 | |
30779 | 30779 | San Francisco | San Francisco | 75 | 2020-04-15 | 1013 | 17 | |
30723 | 30723 | San Francisco | San Francisco | 75 | 2020-04-16 | 1019 | 17 | |
30667 | 30667 | San Francisco | San Francisco | 75 | 2020-04-17 | 1058 | 20 | |
30611 | 30611 | San Francisco | San Francisco | 75 | 2020-04-18 | 1137 | 20 | |
30555 | 30555 | San Francisco | San Francisco | 75 | 2020-04-19 | 1157 | 20 | |
30499 | 30499 | San Francisco | San Francisco | 75 | 2020-04-20 | 1216 | 20 | |
30443 | 30443 | San Francisco | San Francisco | 75 | 2020-04-21 | 1231 | 20 | |
30387 | 30387 | San Francisco | San Francisco | 75 | 2020-04-22 | 1233 | 21 | |
30331 | 30331 | San Francisco | San Francisco | 75 | 2020-04-23 | 1302 | 21 | |
30275 | 30275 | San Francisco | San Francisco | 75 | 2020-04-24 | 1340 | 22 | |
30219 | 30219 | San Francisco | San Francisco | 75 | 2020-04-25 | 1354 | 22 | |
30163 | 30163 | San Francisco | San Francisco | 75 | 2020-04-26 | 1408 | 22 | |
30107 | 30107 | San Francisco | San Francisco | 75 | 2020-04-27 | 1424 | 23 | |
30051 | 30051 | San Francisco | San Francisco | 75 | 2020-04-28 | 1468 | 23 | |
29992 | 29992 | San Francisco | San Francisco | 75 | 2020-04-29 | 1490 | 23 | |
29931 | 29931 | San Francisco | San Francisco | 75 | 2020-04-30 | 1499 | 25 | |
29870 | 29870 | San Francisco | San Francisco | 75 | 2020-05-01 | 1523 | 28 | |
29809 | 29809 | San Francisco | San Francisco | 75 | 2020-05-02 | 1543 | 29 | |
29748 | 29748 | San Francisco | San Francisco | 75 | 2020-05-03 | 1602 | 29 | |
29687 | 29687 | San Francisco | San Francisco | 75 | 2020-05-04 | 1624 | 29 | |
29626 | 29626 | San Francisco | San Francisco | 75 | 2020-05-05 | 1728 | 31 | |
29565 | 29565 | San Francisco | San Francisco | 75 | 2020-05-06 | 1754 | 31 | |
29504 | 29504 | San Francisco | San Francisco | 75 | 2020-05-07 | 1806 | 32 | |
29443 | 29443 | San Francisco | San Francisco | 75 | 2020-05-08 | 1853 | 33 | |
29382 | 29382 | San Francisco | San Francisco | 75 | 2020-05-09 | 1891 | 33 | |
29321 | 29321 | San Francisco | San Francisco | 75 | 2020-05-10 | 1943 | 34 | |
29260 | 29260 | San Francisco | San Francisco | 75 | 2020-05-11 | 1954 | 35 | |
29199 | 29199 | San Francisco | San Francisco | 75 | 2020-05-12 | 1977 | 35 | |
29138 | 29138 | San Francisco | San Francisco | 75 | 2020-05-13 | 1994 | 35 | |
29077 | 29077 | San Francisco | San Francisco | 75 | 2020-05-14 | 1999 | 35 | |
29016 | 29016 | San Francisco | San Francisco | 75 | 2020-05-15 | 2026 | 36 | |
28955 | 28955 | San Francisco | San Francisco | 75 | 2020-05-16 | 2054 | 36 | |
28894 | 28894 | San Francisco | San Francisco | 75 | 2020-05-17 | 2091 | 36 | |
28833 | 28833 | San Francisco | San Francisco | 75 | 2020-05-18 | 2131 | 36 | |
28772 | 28772 | San Francisco | San Francisco | 75 | 2020-05-19 | 2179 | 36 | |
28711 | 28711 | San Francisco | San Francisco | 75 | 2020-05-20 | 2185 | 37 | |
28650 | 28650 | San Francisco | San Francisco | 75 | 2020-05-21 | 2198 | 37 | |
28589 | 28589 | San Francisco | San Francisco | 75 | 2020-05-22 | 2320 | 40 | |
28528 | 28528 | San Francisco | San Francisco | 75 | 2020-05-23 | 2350 | 40 | |
28467 | 28467 | San Francisco | San Francisco | 75 | 2020-05-24 | 2367 | 40 | |
28406 | 28406 | San Francisco | San Francisco | 75 | 2020-05-25 | 2386 | 40 | |
28345 | 28345 | San Francisco | San Francisco | 75 | 2020-05-26 | 2399 | 40 | |
28284 | 28284 | San Francisco | San Francisco | 75 | 2020-05-27 | 2408 | 40 | |
28223 | 28223 | San Francisco | San Francisco | 75 | 2020-05-28 | 2437 | 40 | |
28162 | 28162 | San Francisco | San Francisco | 75 | 2020-05-29 | 2473 | 41 | |
28101 | 28101 | San Francisco | San Francisco | 75 | 2020-05-30 | 2532 | 41 | |
28040 | 28040 | San Francisco | San Francisco | 75 | 2020-05-31 | 2558 | 42 |
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 );