home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for latimes_place_totals
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

47,912 rows where county = "Alameda" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 1 47,912

county 1

  • Alameda · 47,912 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1 1 94501 94501: Alameda 2022-08-19 Alameda 1 10658   62826
2 2 94502 94502: Alameda 2022-08-19 Alameda 1 1794   14117
3 3 94505 94505: Discovery Bay 2022-08-19 Alameda 1 4   16382
4 4 94514 94514: Byron 2022-08-19 Alameda 1 3   1461
5 5 94536 94536: Fremont 2022-08-19 Alameda 1 12208   72976
6 6 94538 94538: Fremont 2022-08-19 Alameda 1 12813   63911
7 7 94539 94539: Fremont 2022-08-19 Alameda 1 6812   52960
8 8 94541 94541: Hayward 2022-08-19 Alameda 1 17848   65132
9 9 94542 94542: Hayward 2022-08-19 Alameda 1 2785   13973
10 10 94544 94544: Hayward 2022-08-19 Alameda 1 21741   77121
11 11 94545 94545: Hayward 2022-08-19 Alameda 1 8398   31657
12 12 94546 94546: Castro Valley 2022-08-19 Alameda 1 8673   45536
13 13 94550 94550: Livermore 2022-08-19 Alameda 1 8696   50138
14 14 94551 94551: Livermore 2022-08-19 Alameda 1 8143   38986
15 15 94552 94552: Castro Valley 2022-08-19 Alameda 1 2187   15204
16 16 94555 94555: Fremont 2022-08-19 Alameda 1 5360   36037
17 17 94560 94560: Newark 2022-08-19 Alameda 1 10615   44245
18 18 94566 94566: Pleasanton 2022-08-19 Alameda 1 6322   45046
19 19 94568 94568: Dublin 2022-08-19 Alameda 1 12647   58399
20 20 94577 94577: San Leandro 2022-08-19 Alameda 1 10751   48666
21 21 94578 94578: San Leandro 2022-08-19 Alameda 1 10256   40150
22 22 94579 94579: San Leandro 2022-08-19 Alameda 1 4935   20237
23 23 94580 94580: San Lorenzo 2022-08-19 Alameda 1 7281   28970
24 24 94586 94586: Sunol 2022-08-19 Alameda 1 131   797
25 25 94587 94587: Union City 2022-08-19 Alameda 1 14791   72446
26 26 94588 94588: Pleasanton 2022-08-19 Alameda 1 5221   31895
27 27 94601 94601: Oakland 2022-08-19 Alameda 1 15607   53261
28 28 94602 94602: Oakland 2022-08-19 Alameda 1 5421   29770
29 29 94603 94603: Oakland 2022-08-19 Alameda 1 10953   33241
30 30 94605 94605: Oakland 2022-08-19 Alameda 1 10105   42375
31 31 94606 94606: Oakland 2022-08-19 Alameda 1 8062   37076
32 32 94607 94607: Oakland 2022-08-19 Alameda 1 6365   26646
33 33 94608 94608: Emeryville 2022-08-19 Alameda 1 6509   31000
34 34 94609 94609: Oakland 2022-08-19 Alameda 1 4714   22293
35 35 94610 94610: Oakland 2022-08-19 Alameda 1 5094   30862
36 36 94611 94611: Oakland 2022-08-19 Alameda 1 5802   37826
37 37 94612 94612: Oakland 2022-08-19 Alameda 1 3845   17279
38 38 94613 94613: Oakland 2022-08-19 Alameda 1 5   212
39 39 94618 94618: Oakland 2022-08-19 Alameda 1 2077   15545
40 40 94619 94619: Oakland 2022-08-19 Alameda 1 4852   24080
41 41 94621 94621: Oakland 2022-08-19 Alameda 1 10711   32915
42 42 94702 94702: Berkeley 2022-08-19 Alameda 1 3068   16520
43 43 94703 94703: Berkeley 2022-08-19 Alameda 1 3361   19805
44 44 94704 94704: Berkeley 2022-08-19 Alameda 1 4865   29129
45 45 94705 94705: Berkeley 2022-08-19 Alameda 1 1883   13152
46 46 94706 94706: Albany 2022-08-19 Alameda 1 2520   19921
47 47 94707 94707: Berkeley 2022-08-19 Alameda 1 1017   12862
48 48 94708 94708: Berkeley 2022-08-19 Alameda 1 972   11725
49 49 94709 94709: Berkeley 2022-08-19 Alameda 1 1533   11796
50 50 94710 94710: Berkeley 2022-08-19 Alameda 1 1912   8059
51 51 94720 94720: Berkeley 2022-08-19 Alameda 1 1006   1336
52 52 95377 95377: Tracy 2022-08-19 Alameda 1 1   32091
53 53 95391 95391: Mountain House 2022-08-19 Alameda 1 4   20131
1224 1224 94501 94501: Alameda 2022-08-18 Alameda 1 10658   62826
1225 1225 94502 94502: Alameda 2022-08-18 Alameda 1 1794   14117
1226 1226 94505 94505: Discovery Bay 2022-08-18 Alameda 1 4   16382
1227 1227 94514 94514: Byron 2022-08-18 Alameda 1 3   1461
1228 1228 94536 94536: Fremont 2022-08-18 Alameda 1 12208   72976
1229 1229 94538 94538: Fremont 2022-08-18 Alameda 1 12813   63911
1230 1230 94539 94539: Fremont 2022-08-18 Alameda 1 6812   52960
1231 1231 94541 94541: Hayward 2022-08-18 Alameda 1 17848   65132
1232 1232 94542 94542: Hayward 2022-08-18 Alameda 1 2785   13973
1233 1233 94544 94544: Hayward 2022-08-18 Alameda 1 21741   77121
1234 1234 94545 94545: Hayward 2022-08-18 Alameda 1 8398   31657
1235 1235 94546 94546: Castro Valley 2022-08-18 Alameda 1 8673   45536
1236 1236 94550 94550: Livermore 2022-08-18 Alameda 1 8696   50138
1237 1237 94551 94551: Livermore 2022-08-18 Alameda 1 8143   38986
1238 1238 94552 94552: Castro Valley 2022-08-18 Alameda 1 2187   15204
1239 1239 94555 94555: Fremont 2022-08-18 Alameda 1 5360   36037
1240 1240 94560 94560: Newark 2022-08-18 Alameda 1 10615   44245
1241 1241 94566 94566: Pleasanton 2022-08-18 Alameda 1 6322   45046
1242 1242 94568 94568: Dublin 2022-08-18 Alameda 1 12647   58399
1243 1243 94577 94577: San Leandro 2022-08-18 Alameda 1 10751   48666
1244 1244 94578 94578: San Leandro 2022-08-18 Alameda 1 10256   40150
1245 1245 94579 94579: San Leandro 2022-08-18 Alameda 1 4935   20237
1246 1246 94580 94580: San Lorenzo 2022-08-18 Alameda 1 7281   28970
1247 1247 94586 94586: Sunol 2022-08-18 Alameda 1 131   797
1248 1248 94587 94587: Union City 2022-08-18 Alameda 1 14791   72446
1249 1249 94588 94588: Pleasanton 2022-08-18 Alameda 1 5221   31895
1250 1250 94601 94601: Oakland 2022-08-18 Alameda 1 15607   53261
1251 1251 94602 94602: Oakland 2022-08-18 Alameda 1 5421   29770
1252 1252 94603 94603: Oakland 2022-08-18 Alameda 1 10953   33241
1253 1253 94605 94605: Oakland 2022-08-18 Alameda 1 10105   42375
1254 1254 94606 94606: Oakland 2022-08-18 Alameda 1 8062   37076
1255 1255 94607 94607: Oakland 2022-08-18 Alameda 1 6365   26646
1256 1256 94608 94608: Emeryville 2022-08-18 Alameda 1 6509   31000
1257 1257 94609 94609: Oakland 2022-08-18 Alameda 1 4714   22293
1258 1258 94610 94610: Oakland 2022-08-18 Alameda 1 5094   30862
1259 1259 94611 94611: Oakland 2022-08-18 Alameda 1 5802   37826
1260 1260 94612 94612: Oakland 2022-08-18 Alameda 1 3845   17279
1261 1261 94613 94613: Oakland 2022-08-18 Alameda 1 5   212
1262 1262 94618 94618: Oakland 2022-08-18 Alameda 1 2077   15545
1263 1263 94619 94619: Oakland 2022-08-18 Alameda 1 4852   24080
1264 1264 94621 94621: Oakland 2022-08-18 Alameda 1 10711   32915
1265 1265 94702 94702: Berkeley 2022-08-18 Alameda 1 3068   16520
1266 1266 94703 94703: Berkeley 2022-08-18 Alameda 1 3361   19805
1267 1267 94704 94704: Berkeley 2022-08-18 Alameda 1 4865   29129
1268 1268 94705 94705: Berkeley 2022-08-18 Alameda 1 1883   13152
1269 1269 94706 94706: Albany 2022-08-18 Alameda 1 2520   19921
1270 1270 94707 94707: Berkeley 2022-08-18 Alameda 1 1017   12862

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);
Powered by Datasette · Queries took 1210.959ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals