latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
30 rows where agency = "Santa Clara" and did_not_update = "TRUE" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed_cases, deaths, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
290 | 290 | Santa Clara | Santa Clara | 85 | 2021-08-29 | 132504 | 1731 | TRUE |
351 | 351 | Santa Clara | Santa Clara | 85 | 2021-08-28 | 132504 | 1731 | TRUE |
717 | 717 | Santa Clara | Santa Clara | 85 | 2021-08-22 | 130007 | 1721 | TRUE |
778 | 778 | Santa Clara | Santa Clara | 85 | 2021-08-21 | 130007 | 1721 | TRUE |
1144 | 1144 | Santa Clara | Santa Clara | 85 | 2021-08-15 | 127446 | 1716 | TRUE |
1205 | 1205 | Santa Clara | Santa Clara | 85 | 2021-08-14 | 127446 | 1716 | TRUE |
1571 | 1571 | Santa Clara | Santa Clara | 85 | 2021-08-08 | 125235 | 1711 | TRUE |
1632 | 1632 | Santa Clara | Santa Clara | 85 | 2021-08-07 | 125235 | 1711 | TRUE |
1998 | 1998 | Santa Clara | Santa Clara | 85 | 2021-08-01 | 123404 | 1709 | TRUE |
2059 | 2059 | Santa Clara | Santa Clara | 85 | 2021-07-31 | 123404 | 1709 | TRUE |
2425 | 2425 | Santa Clara | Santa Clara | 85 | 2021-07-25 | 121767 | 1707 | TRUE |
2486 | 2486 | Santa Clara | Santa Clara | 85 | 2021-07-24 | 121767 | 1707 | TRUE |
2852 | 2852 | Santa Clara | Santa Clara | 85 | 2021-07-18 | 120604 | 1706 | TRUE |
2913 | 2913 | Santa Clara | Santa Clara | 85 | 2021-07-17 | 120604 | 1706 | TRUE |
3828 | 3828 | Santa Clara | Santa Clara | 85 | 2021-07-02 | 119388 | 1698 | TRUE |
4316 | 4316 | Santa Clara | Santa Clara | 85 | 2021-06-24 | 119083 | 1696 | TRUE |
4987 | 4987 | Santa Clara | Santa Clara | 85 | 2021-06-13 | 118757 | 1695 | TRUE |
11636 | 11636 | Santa Clara | Santa Clara | 85 | 2021-02-24 | 109597 | 1574 | TRUE |
13588 | 13588 | Santa Clara | Santa Clara | 85 | 2021-01-23 | 98941 | 1290 | TRUE |
14747 | 14747 | Santa Clara | Santa Clara | 85 | 2021-01-04 | 78751 | 949 | TRUE |
15052 | 15052 | Santa Clara | Santa Clara | 85 | 2020-12-30 | 73787 | 845 | TRUE |
15357 | 15357 | Santa Clara | Santa Clara | 85 | 2020-12-25 | 66440 | 739 | TRUE |
21823 | 21823 | Santa Clara | Santa Clara | 85 | 2020-09-10 | 19556 | 271 | TRUE |
21945 | 21945 | Santa Clara | Santa Clara | 85 | 2020-09-08 | 19204 | 270 | TRUE |
22494 | 22494 | Santa Clara | Santa Clara | 85 | 2020-08-30 | 17877 | 254 | TRUE |
26398 | 26398 | Santa Clara | Santa Clara | 85 | 2020-06-27 | 4718 | 155 | TRUE |
30560 | 30560 | Santa Clara | Santa Clara | 85 | 2020-04-19 | 1963 | 88 | TRUE |
30616 | 30616 | Santa Clara | Santa Clara | 85 | 2020-04-18 | 1949 | 86 | TRUE |
30840 | 30840 | Santa Clara | Santa Clara | 85 | 2020-04-14 | 1835 | 70 | TRUE |
31867 | 31867 | Santa Clara | Santa Clara | 85 | 2020-03-26 | 887 | 30 | TRUE |
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 );