Data source: Bay Area Pandemic Dashboard

373 rows

View and edit SQL

Suggested facets: county, update_time, category, metric, update_time (date)

Link county update_time category group metric value
Alameda 2022-01-14T00:00:00-08:00 age_group 18-30 case_totals 50846
Alameda 2022-01-14T00:00:00-08:00 age_group 18-30 death_totals 9
Alameda 2022-01-14T00:00:00-08:00 age_group 31-40 case_totals 38156
Alameda 2022-01-14T00:00:00-08:00 age_group 31-40 death_totals 32
Alameda 2022-01-14T00:00:00-08:00 age_group 41-50 case_totals 29182
Alameda 2022-01-14T00:00:00-08:00 age_group 41-50 death_totals 82
Alameda 2022-01-14T00:00:00-08:00 age_group 51-60 case_totals 22427
Alameda 2022-01-14T00:00:00-08:00 age_group 51-60 death_totals 160
Alameda 2022-01-14T00:00:00-08:00 age_group 61-70 case_totals 13295
Alameda 2022-01-14T00:00:00-08:00 age_group 61-70 death_totals 276
Alameda 2022-01-14T00:00:00-08:00 age_group 71-80 case_totals 5913
Alameda 2022-01-14T00:00:00-08:00 age_group 71-80 death_totals 350
Alameda 2022-01-14T00:00:00-08:00 age_group 81+ case_totals 3904
Alameda 2022-01-14T00:00:00-08:00 age_group 81+ death_totals 667
Alameda 2022-01-14T00:00:00-08:00 age_group <18 case_totals 34605
Alameda 2022-01-14T00:00:00-08:00 age_group <18 death_totals 1
Alameda 2022-01-14T00:00:00-08:00 age_group Unknown case_totals 63
Alameda 2022-01-14T00:00:00-08:00 age_group Unknown Age case_totals 8
Alameda 2022-01-14T00:00:00-08:00 gender female case_totals 100528
Alameda 2022-01-14T00:00:00-08:00 gender female death_totals 695
Alameda 2022-01-14T00:00:00-08:00 gender male case_totals 93867
Alameda 2022-01-14T00:00:00-08:00 gender male death_totals 841
Alameda 2022-01-14T00:00:00-08:00 gender transgender and other case_totals 198
Alameda 2022-01-14T00:00:00-08:00 gender unknown case_totals 3768
Alameda 2022-01-14T00:00:00-08:00 gender unknown death_totals 41
Alameda 2022-01-14T00:00:00-08:00 race_eth African American/Black case_totals 18807
Alameda 2022-01-14T00:00:00-08:00 race_eth African American/Black death_totals 289
Alameda 2022-01-14T00:00:00-08:00 race_eth Asian case_totals 29234
Alameda 2022-01-14T00:00:00-08:00 race_eth Asian death_totals 309
Alameda 2022-01-14T00:00:00-08:00 race_eth Hispanic/Latino case_totals 61645
Alameda 2022-01-14T00:00:00-08:00 race_eth Hispanic/Latino death_totals 347
Alameda 2022-01-14T00:00:00-08:00 race_eth Multirace case_totals 4597
Alameda 2022-01-14T00:00:00-08:00 race_eth Multirace death_totals 98
Alameda 2022-01-14T00:00:00-08:00 race_eth Native American case_totals 557
Alameda 2022-01-14T00:00:00-08:00 race_eth Native American death_totals 6
Alameda 2022-01-14T00:00:00-08:00 race_eth Pacific Islander case_totals 2029
Alameda 2022-01-14T00:00:00-08:00 race_eth Pacific Islander death_totals 19
Alameda 2022-01-14T00:00:00-08:00 race_eth Unknown case_totals 50945
Alameda 2022-01-14T00:00:00-08:00 race_eth Unknown death_totals 101
Alameda 2022-01-14T00:00:00-08:00 race_eth White case_totals 30584
Alameda 2022-01-14T00:00:00-08:00 race_eth White death_totals 408
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 13-18 case_totals 12855
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 13-18 death_totals 1
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 19-30 case_totals 33861
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 19-30 death_totals 3
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 31-40 case_totals 28283
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 31-40 death_totals 20
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 4 or under case_totals 6481
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 4 or under death_totals 1
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 41-50 case_totals 24052
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 41-50 death_totals 49
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 5-12 case_totals 13966
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 5-12 death_totals 0
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 51-60 case_totals 19580
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 51-60 death_totals 126
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 61-70 case_totals 10912
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 61-70 death_totals 210
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 71-80 case_totals 5171
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 71-80 death_totals 251
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 81-90 case_totals 2462
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group 81-90 death_totals 272
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group Over 90 case_totals 812
Contra Costa 2022-01-21T19:30:20.915000+00:00 age_group Over 90 death_totals 158
Contra Costa 2022-01-21T19:30:20.915000+00:00 ethnicity Latinx_or_Hispanic case_totals 41475
Contra Costa 2022-01-21T19:30:20.915000+00:00 ethnicity Latinx_or_Hispanic death_totals 325
Contra Costa 2022-01-21T19:30:20.915000+00:00 ethnicity Other case_totals 67511
Contra Costa 2022-01-21T19:30:20.915000+00:00 ethnicity Other death_totals 753
Contra Costa 2022-01-21T19:30:20.915000+00:00 ethnicity Unknown case_totals 49481
Contra Costa 2022-01-21T19:30:20.915000+00:00 ethnicity Unknown death_totals 13
Contra Costa 2022-01-21T19:30:20.915000+00:00 gender female case_totals 83188
Contra Costa 2022-01-21T19:30:20.915000+00:00 gender female death_totals 481
Contra Costa 2022-01-21T19:30:20.915000+00:00 gender male case_totals 74234
Contra Costa 2022-01-21T19:30:20.915000+00:00 gender male death_totals 610
Contra Costa 2022-01-21T19:30:20.915000+00:00 gender unknown case_totals 1045
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth African_Amer case_totals 13393
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth African_Amer death_totals 152
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Asian case_totals 13509
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Asian death_totals 130
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Latinx_or_Hispanic case_totals -1
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Latinx_or_Hispanic death_totals -1
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Multiple_Race case_totals 4662
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Multiple_Race death_totals 48
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Native_Amer case_totals -1
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Native_Amer death_totals -1
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Other case_totals 50041
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Other death_totals 271
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Pacific_Islander case_totals -1
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Pacific_Islander death_totals -1
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Unknown case_totals 33800
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth Unknown death_totals 7
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth White case_totals 43062
Contra Costa 2022-01-21T19:30:20.915000+00:00 race_eth White death_totals 483
Marin 2022-01-22T08:00:56+00:00 age_group 0-4 case_totals 1000
Marin 2022-01-22T08:00:56+00:00 age_group 0-4 death_totals 0
Marin 2022-01-22T08:00:56+00:00 age_group 12-18 case_totals 2179
Marin 2022-01-22T08:00:56+00:00 age_group 12-18 death_totals 0
Marin 2022-01-22T08:00:56+00:00 age_group 19-34 case_totals 6493
Marin 2022-01-22T08:00:56+00:00 age_group 19-34 death_totals 0
Marin 2022-01-22T08:00:56+00:00 age_group 35-49 case_totals 6203
Marin 2022-01-22T08:00:56+00:00 age_group 35-49 death_totals 5

Next page

Advanced export

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

CSV options:

CREATE TABLE [demographic_totals] (
   [county] TEXT,
   [update_time] TEXT,
   [category] TEXT,
   [group] TEXT,
   [metric] TEXT,
   [value] INTEGER,
   PRIMARY KEY ([county], [update_time], [category], [group], [metric])
);