latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
586 rows where agency = "Santa Clara" sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | agency | county | fips | date | confirmed_cases ▼ | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
33014 | 33014 | Santa Clara | Santa Clara | 85 | 2020-01-26 | 0 | 0 | |
32997 | 32997 | Santa Clara | Santa Clara | 85 | 2020-01-27 | 1 | 0 | |
32994 | 32994 | Santa Clara | Santa Clara | 85 | 2020-01-28 | 2 | 0 | |
32991 | 32991 | Santa Clara | Santa Clara | 85 | 2020-01-29 | 3 | 0 | |
32988 | 32988 | Santa Clara | Santa Clara | 85 | 2020-01-30 | 4 | 0 | |
32882 | 32882 | Santa Clara | Santa Clara | 85 | 2020-02-16 | 6 | 1 | |
32886 | 32886 | Santa Clara | Santa Clara | 85 | 2020-02-15 | 6 | 1 | |
32890 | 32890 | Santa Clara | Santa Clara | 85 | 2020-02-14 | 6 | 1 | |
32894 | 32894 | Santa Clara | Santa Clara | 85 | 2020-02-13 | 6 | 1 | |
32898 | 32898 | Santa Clara | Santa Clara | 85 | 2020-02-12 | 6 | 1 | |
32902 | 32902 | Santa Clara | Santa Clara | 85 | 2020-02-11 | 6 | 1 | |
32906 | 32906 | Santa Clara | Santa Clara | 85 | 2020-02-10 | 6 | 1 | |
32910 | 32910 | Santa Clara | Santa Clara | 85 | 2020-02-09 | 6 | 1 | |
32914 | 32914 | Santa Clara | Santa Clara | 85 | 2020-02-08 | 6 | 1 | |
32918 | 32918 | Santa Clara | Santa Clara | 85 | 2020-02-07 | 6 | 1 | |
32922 | 32922 | Santa Clara | Santa Clara | 85 | 2020-02-06 | 6 | 1 | |
32926 | 32926 | Santa Clara | Santa Clara | 85 | 2020-02-05 | 6 | 0 | |
32930 | 32930 | Santa Clara | Santa Clara | 85 | 2020-02-04 | 6 | 0 | |
32934 | 32934 | Santa Clara | Santa Clara | 85 | 2020-02-03 | 6 | 0 | |
32951 | 32951 | Santa Clara | Santa Clara | 85 | 2020-02-02 | 6 | 0 | |
32961 | 32961 | Santa Clara | Santa Clara | 85 | 2020-02-01 | 6 | 0 | |
32978 | 32978 | Santa Clara | Santa Clara | 85 | 2020-01-31 | 6 | 0 | |
32870 | 32870 | Santa Clara | Santa Clara | 85 | 2020-02-19 | 7 | 2 | |
32874 | 32874 | Santa Clara | Santa Clara | 85 | 2020-02-18 | 7 | 2 | |
32878 | 32878 | Santa Clara | Santa Clara | 85 | 2020-02-17 | 7 | 2 | |
32800 | 32800 | Santa Clara | Santa Clara | 85 | 2020-02-25 | 8 | 2 | |
32806 | 32806 | Santa Clara | Santa Clara | 85 | 2020-02-24 | 8 | 2 | |
32812 | 32812 | Santa Clara | Santa Clara | 85 | 2020-02-23 | 8 | 2 | |
32818 | 32818 | Santa Clara | Santa Clara | 85 | 2020-02-22 | 8 | 2 | |
32835 | 32835 | Santa Clara | Santa Clara | 85 | 2020-02-21 | 8 | 2 | |
32859 | 32859 | Santa Clara | Santa Clara | 85 | 2020-02-20 | 8 | 2 | |
32768 | 32768 | Santa Clara | Santa Clara | 85 | 2020-02-27 | 10 | 2 | |
32787 | 32787 | Santa Clara | Santa Clara | 85 | 2020-02-26 | 10 | 2 | |
32754 | 32754 | Santa Clara | Santa Clara | 85 | 2020-02-28 | 12 | 2 | |
32704 | 32704 | Santa Clara | Santa Clara | 85 | 2020-03-01 | 16 | 2 | |
32729 | 32729 | Santa Clara | Santa Clara | 85 | 2020-02-29 | 16 | 2 | |
32678 | 32678 | Santa Clara | Santa Clara | 85 | 2020-03-02 | 21 | 2 | |
32652 | 32652 | Santa Clara | Santa Clara | 85 | 2020-03-03 | 23 | 2 | |
32626 | 32626 | Santa Clara | Santa Clara | 85 | 2020-03-04 | 28 | 2 | |
32600 | 32600 | Santa Clara | Santa Clara | 85 | 2020-03-05 | 35 | 2 | |
32574 | 32574 | Santa Clara | Santa Clara | 85 | 2020-03-06 | 45 | 3 | |
32548 | 32548 | Santa Clara | Santa Clara | 85 | 2020-03-07 | 53 | 3 | |
32521 | 32521 | Santa Clara | Santa Clara | 85 | 2020-03-08 | 57 | 3 | |
32494 | 32494 | Santa Clara | Santa Clara | 85 | 2020-03-09 | 74 | 5 | |
32467 | 32467 | Santa Clara | Santa Clara | 85 | 2020-03-10 | 89 | 5 | |
32439 | 32439 | Santa Clara | Santa Clara | 85 | 2020-03-11 | 115 | 5 | |
32409 | 32409 | Santa Clara | Santa Clara | 85 | 2020-03-12 | 138 | 5 | |
32379 | 32379 | Santa Clara | Santa Clara | 85 | 2020-03-13 | 186 | 6 | |
32348 | 32348 | Santa Clara | Santa Clara | 85 | 2020-03-14 | 229 | 6 | |
32316 | 32316 | Santa Clara | Santa Clara | 85 | 2020-03-15 | 261 | 7 | |
32282 | 32282 | Santa Clara | Santa Clara | 85 | 2020-03-16 | 298 | 10 | |
32247 | 32247 | Santa Clara | Santa Clara | 85 | 2020-03-17 | 351 | 10 | |
32210 | 32210 | Santa Clara | Santa Clara | 85 | 2020-03-18 | 396 | 12 | |
32172 | 32172 | Santa Clara | Santa Clara | 85 | 2020-03-19 | 442 | 12 | |
32134 | 32134 | Santa Clara | Santa Clara | 85 | 2020-03-20 | 506 | 12 | |
32093 | 32093 | Santa Clara | Santa Clara | 85 | 2020-03-21 | 542 | 14 | |
32050 | 32050 | Santa Clara | Santa Clara | 85 | 2020-03-22 | 583 | 16 | |
32005 | 32005 | Santa Clara | Santa Clara | 85 | 2020-03-23 | 662 | 21 | |
31960 | 31960 | Santa Clara | Santa Clara | 85 | 2020-03-24 | 734 | 22 | |
31914 | 31914 | Santa Clara | Santa Clara | 85 | 2020-03-25 | 812 | 29 | |
31867 | 31867 | Santa Clara | Santa Clara | 85 | 2020-03-26 | 887 | 30 | TRUE |
31820 | 31820 | Santa Clara | Santa Clara | 85 | 2020-03-27 | 954 | 30 | |
31770 | 31770 | Santa Clara | Santa Clara | 85 | 2020-03-28 | 994 | 32 | |
31720 | 31720 | Santa Clara | Santa Clara | 85 | 2020-03-29 | 1018 | 34 | |
31669 | 31669 | Santa Clara | Santa Clara | 85 | 2020-03-30 | 1096 | 36 | |
31617 | 31617 | Santa Clara | Santa Clara | 85 | 2020-03-31 | 1147 | 37 | |
31563 | 31563 | Santa Clara | Santa Clara | 85 | 2020-04-01 | 1197 | 40 | |
31509 | 31509 | Santa Clara | Santa Clara | 85 | 2020-04-02 | 1250 | 42 | |
31454 | 31454 | Santa Clara | Santa Clara | 85 | 2020-04-03 | 1293 | 43 | |
31399 | 31399 | Santa Clara | Santa Clara | 85 | 2020-04-04 | 1326 | 45 | |
31344 | 31344 | Santa Clara | Santa Clara | 85 | 2020-04-05 | 1369 | 47 | |
31288 | 31288 | Santa Clara | Santa Clara | 85 | 2020-04-06 | 1422 | 48 | |
31232 | 31232 | Santa Clara | Santa Clara | 85 | 2020-04-07 | 1463 | 49 | |
31176 | 31176 | Santa Clara | Santa Clara | 85 | 2020-04-08 | 1535 | 51 | |
31120 | 31120 | Santa Clara | Santa Clara | 85 | 2020-04-09 | 1603 | 55 | |
31064 | 31064 | Santa Clara | Santa Clara | 85 | 2020-04-10 | 1685 | 56 | |
31008 | 31008 | Santa Clara | Santa Clara | 85 | 2020-04-11 | 1726 | 61 | |
30952 | 30952 | Santa Clara | Santa Clara | 85 | 2020-04-12 | 1750 | 67 | |
30896 | 30896 | Santa Clara | Santa Clara | 85 | 2020-04-13 | 1791 | 68 | |
30840 | 30840 | Santa Clara | Santa Clara | 85 | 2020-04-14 | 1835 | 70 | TRUE |
30784 | 30784 | Santa Clara | Santa Clara | 85 | 2020-04-15 | 1865 | 74 | |
30728 | 30728 | Santa Clara | Santa Clara | 85 | 2020-04-16 | 1892 | 77 | |
30672 | 30672 | Santa Clara | Santa Clara | 85 | 2020-04-17 | 1934 | 82 | |
30616 | 30616 | Santa Clara | Santa Clara | 85 | 2020-04-18 | 1949 | 86 | TRUE |
30560 | 30560 | Santa Clara | Santa Clara | 85 | 2020-04-19 | 1963 | 88 | TRUE |
30504 | 30504 | Santa Clara | Santa Clara | 85 | 2020-04-20 | 1988 | 93 | |
30448 | 30448 | Santa Clara | Santa Clara | 85 | 2020-04-21 | 2014 | 96 | |
30392 | 30392 | Santa Clara | Santa Clara | 85 | 2020-04-22 | 2063 | 99 | |
30336 | 30336 | Santa Clara | Santa Clara | 85 | 2020-04-23 | 2083 | 100 | |
30280 | 30280 | Santa Clara | Santa Clara | 85 | 2020-04-24 | 2113 | 101 | |
30224 | 30224 | Santa Clara | Santa Clara | 85 | 2020-04-25 | 2127 | 102 | |
30168 | 30168 | Santa Clara | Santa Clara | 85 | 2020-04-26 | 2138 | 105 | |
30112 | 30112 | Santa Clara | Santa Clara | 85 | 2020-04-27 | 2162 | 107 | |
30056 | 30056 | Santa Clara | Santa Clara | 85 | 2020-04-28 | 2184 | 109 | |
29997 | 29997 | Santa Clara | Santa Clara | 85 | 2020-04-29 | 2212 | 110 | |
29936 | 29936 | Santa Clara | Santa Clara | 85 | 2020-04-30 | 2223 | 113 | |
29875 | 29875 | Santa Clara | Santa Clara | 85 | 2020-05-01 | 2244 | 115 | |
29814 | 29814 | Santa Clara | Santa Clara | 85 | 2020-05-02 | 2256 | 118 | |
29753 | 29753 | Santa Clara | Santa Clara | 85 | 2020-05-03 | 2264 | 120 | |
29692 | 29692 | Santa Clara | Santa Clara | 85 | 2020-05-04 | 2283 | 124 |
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 );