Data source: Bay Area Pandemic Dashboard

51,220 rows

View and edit SQL

Suggested facets: county, metric, date (date)

Link date county metric value
2020-01-02 Napa cumul_pos 4899
2020-01-02 Napa cumul_tests 115288
2020-01-02 Napa positive 571
2020-01-02 Napa positivity 10.3
2020-01-02 Napa tests 5547
2020-01-05 Alameda cases 2
2020-01-05 Alameda cumul_cases 2
2020-01-06 Alameda cases 1
2020-01-06 Alameda cumul_cases 3
2020-01-09 Alameda cases 1
2020-01-09 Alameda cumul_cases 4
2020-01-12 Santa Clara cumul_neg 38
2020-01-12 Santa Clara cumul_pend -1
2020-01-12 Santa Clara cumul_pos 1
2020-01-12 Santa Clara cumul_tests 39
2020-01-12 Santa Clara negative 38
2020-01-12 Santa Clara pending -1
2020-01-12 Santa Clara positive 1
2020-01-12 Santa Clara tests 39
2020-01-19 Alameda cases 2
2020-01-19 Alameda cumul_cases 6
2020-01-19 Alameda cumul_neg -1
2020-01-19 Alameda cumul_pend -1
2020-01-19 Alameda cumul_pos -1
2020-01-19 Alameda cumul_tests -1
2020-01-19 Alameda negative 476
2020-01-19 Alameda pending -1
2020-01-19 Alameda positive 72
2020-01-19 Alameda tests 548
2020-01-20 Santa Clara cumul_neg 38
2020-01-20 Santa Clara cumul_pend -1
2020-01-20 Santa Clara cumul_pos 2
2020-01-20 Santa Clara cumul_tests 40
2020-01-20 Santa Clara negative 0
2020-01-20 Santa Clara pending -1
2020-01-20 Santa Clara positive 1
2020-01-20 Santa Clara tests 1
2020-01-21 Alameda cases 1
2020-01-21 Alameda cumul_cases 7
2020-01-21 Alameda cumul_neg -1
2020-01-21 Alameda cumul_pend -1
2020-01-21 Alameda cumul_pos -1
2020-01-21 Alameda cumul_tests -1
2020-01-21 Alameda negative 319
2020-01-21 Alameda pending -1
2020-01-21 Alameda positive 48
2020-01-21 Alameda tests 367
2020-01-21 Santa Clara cumul_neg 42
2020-01-21 Santa Clara cumul_pend -1
2020-01-21 Santa Clara cumul_pos 2
2020-01-21 Santa Clara cumul_tests 44
2020-01-21 Santa Clara negative 4
2020-01-21 Santa Clara pending -1
2020-01-21 Santa Clara positive 0
2020-01-21 Santa Clara tests 4
2020-01-23 Alameda cases 1
2020-01-23 Alameda cumul_cases 8
2020-01-23 Alameda cumul_neg -1
2020-01-23 Alameda cumul_pend -1
2020-01-23 Alameda cumul_pos -1
2020-01-23 Alameda cumul_tests -1
2020-01-23 Alameda negative 239
2020-01-23 Alameda pending -1
2020-01-23 Alameda positive 36
2020-01-23 Alameda tests 275
2020-01-23 Santa Clara cumul_neg 43
2020-01-23 Santa Clara cumul_pend -1
2020-01-23 Santa Clara cumul_pos 2
2020-01-23 Santa Clara cumul_tests 45
2020-01-23 Santa Clara negative 1
2020-01-23 Santa Clara pending -1
2020-01-23 Santa Clara positive 0
2020-01-23 Santa Clara tests 1
2020-01-24 Santa Clara cumul_neg 45
2020-01-24 Santa Clara cumul_pend -1
2020-01-24 Santa Clara cumul_pos 2
2020-01-24 Santa Clara cumul_tests 47
2020-01-24 Santa Clara negative 2
2020-01-24 Santa Clara pending -1
2020-01-24 Santa Clara positive 0
2020-01-24 Santa Clara tests 2
2020-01-25 Alameda cumul_neg -1
2020-01-25 Alameda cumul_pend -1
2020-01-25 Alameda cumul_pos -1
2020-01-25 Alameda cumul_tests -1
2020-01-25 Alameda negative 191
2020-01-25 Alameda pending -1
2020-01-25 Alameda positive 29
2020-01-25 Alameda tests 220
2020-01-26 San Mateo cumul_deaths 0
2020-01-26 San Mateo deaths 0
2020-01-26 Santa Clara cumul_neg 49
2020-01-26 Santa Clara cumul_pend -1
2020-01-26 Santa Clara cumul_pos 3
2020-01-26 Santa Clara cumul_tests 52
2020-01-26 Santa Clara negative 4
2020-01-26 Santa Clara pending -1
2020-01-26 Santa Clara positive 1
2020-01-26 Santa Clara tests 5
2020-01-27 Santa Clara cases 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [timeseries] (
   [date] TEXT,
   [county] TEXT,
   [metric] TEXT,
   [value] INTEGER,
   PRIMARY KEY ([date], [county], [metric])
);