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

6,152 rows where county = "Solano" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 95 6,152

county 1

  • Solano · 6,152 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
1161 1161 Benicia Benicia 2022-05-21 Solano 95 3406   27570
1162 1162 Dixon Dixon 2022-05-21 Solano 95 4500   19794
1163 1163 Fairfield Fairfield 2022-05-21 Solano 95 23687   117149
1164 1164 Rio Vista Rio Vista 2022-05-21 Solano 95 1231   9416
1165 1165 Suisun City Suisun City 2022-05-21 Solano 95 6236   29447
1166 1166 Unincorporated Other 2022-05-21 Solano 95 203   19580
1167 1167 Vacaville Vacaville 2022-05-21 Solano 95 22632   98807
1168 1168 Vallejo Vallejo 2022-05-21 Solano 95 26789   119544
2438 2438 Benicia Benicia 2022-05-20 Solano 95 3406   27570
2439 2439 Dixon Dixon 2022-05-20 Solano 95 4500   19794
2440 2440 Fairfield Fairfield 2022-05-20 Solano 95 23687   117149
2441 2441 Rio Vista Rio Vista 2022-05-20 Solano 95 1231   9416
2442 2442 Suisun City Suisun City 2022-05-20 Solano 95 6236   29447
2443 2443 Unincorporated Other 2022-05-20 Solano 95 203   19580
2444 2444 Vacaville Vacaville 2022-05-20 Solano 95 22632   98807
2445 2445 Vallejo Vallejo 2022-05-20 Solano 95 26789   119544
3715 3715 Benicia Benicia 2022-05-19 Solano 95 3406   27570
3716 3716 Dixon Dixon 2022-05-19 Solano 95 4500   19794
3717 3717 Fairfield Fairfield 2022-05-19 Solano 95 23687   117149
3718 3718 Rio Vista Rio Vista 2022-05-19 Solano 95 1231   9416
3719 3719 Suisun City Suisun City 2022-05-19 Solano 95 6236   29447
3720 3720 Unincorporated Other 2022-05-19 Solano 95 203   19580
3721 3721 Vacaville Vacaville 2022-05-19 Solano 95 22632   98807
3722 3722 Vallejo Vallejo 2022-05-19 Solano 95 26789   119544
4992 4992 Benicia Benicia 2022-05-18 Solano 95 3363   27570
4993 4993 Dixon Dixon 2022-05-18 Solano 95 4477   19794
4994 4994 Fairfield Fairfield 2022-05-18 Solano 95 23539   117149
4995 4995 Rio Vista Rio Vista 2022-05-18 Solano 95 1223   9416
4996 4996 Suisun City Suisun City 2022-05-18 Solano 95 6188   29447
4997 4997 Unincorporated Other 2022-05-18 Solano 95 202   19580
4998 4998 Vacaville Vacaville 2022-05-18 Solano 95 22456   98807
4999 4999 Vallejo Vallejo 2022-05-18 Solano 95 26605   119544
6269 6269 Benicia Benicia 2022-05-17 Solano 95 3363   27570
6270 6270 Dixon Dixon 2022-05-17 Solano 95 4477   19794
6271 6271 Fairfield Fairfield 2022-05-17 Solano 95 23539   117149
6272 6272 Rio Vista Rio Vista 2022-05-17 Solano 95 1223   9416
6273 6273 Suisun City Suisun City 2022-05-17 Solano 95 6188   29447
6274 6274 Unincorporated Other 2022-05-17 Solano 95 202   19580
6275 6275 Vacaville Vacaville 2022-05-17 Solano 95 22456   98807
6276 6276 Vallejo Vallejo 2022-05-17 Solano 95 26605   119544
7546 7546 Benicia Benicia 2022-05-16 Solano 95 3363   27570
7547 7547 Dixon Dixon 2022-05-16 Solano 95 4477   19794
7548 7548 Fairfield Fairfield 2022-05-16 Solano 95 23539   117149
7549 7549 Rio Vista Rio Vista 2022-05-16 Solano 95 1223   9416
7550 7550 Suisun City Suisun City 2022-05-16 Solano 95 6188   29447
7551 7551 Unincorporated Other 2022-05-16 Solano 95 202   19580
7552 7552 Vacaville Vacaville 2022-05-16 Solano 95 22456   98807
7553 7553 Vallejo Vallejo 2022-05-16 Solano 95 26605   119544
8823 8823 Benicia Benicia 2022-05-15 Solano 95 3324   27570
8824 8824 Dixon Dixon 2022-05-15 Solano 95 4440   19794
8825 8825 Fairfield Fairfield 2022-05-15 Solano 95 23370   117149
8826 8826 Rio Vista Rio Vista 2022-05-15 Solano 95 1219   9416
8827 8827 Suisun City Suisun City 2022-05-15 Solano 95 6140   29447
8828 8828 Unincorporated Other 2022-05-15 Solano 95 202   19580
8829 8829 Vacaville Vacaville 2022-05-15 Solano 95 22302   98807
8830 8830 Vallejo Vallejo 2022-05-15 Solano 95 26381   119544
10100 10100 Benicia Benicia 2022-05-14 Solano 95 3324   27570
10101 10101 Dixon Dixon 2022-05-14 Solano 95 4440   19794
10102 10102 Fairfield Fairfield 2022-05-14 Solano 95 23370   117149
10103 10103 Rio Vista Rio Vista 2022-05-14 Solano 95 1219   9416
10104 10104 Suisun City Suisun City 2022-05-14 Solano 95 6140   29447
10105 10105 Unincorporated Other 2022-05-14 Solano 95 202   19580
10106 10106 Vacaville Vacaville 2022-05-14 Solano 95 22302   98807
10107 10107 Vallejo Vallejo 2022-05-14 Solano 95 26381   119544
11377 11377 Benicia Benicia 2022-05-13 Solano 95 3324   27570
11378 11378 Dixon Dixon 2022-05-13 Solano 95 4440   19794
11379 11379 Fairfield Fairfield 2022-05-13 Solano 95 23370   117149
11380 11380 Rio Vista Rio Vista 2022-05-13 Solano 95 1219   9416
11381 11381 Suisun City Suisun City 2022-05-13 Solano 95 6140   29447
11382 11382 Unincorporated Other 2022-05-13 Solano 95 202   19580
11383 11383 Vacaville Vacaville 2022-05-13 Solano 95 22302   98807
11384 11384 Vallejo Vallejo 2022-05-13 Solano 95 26381   119544
12654 12654 Benicia Benicia 2022-05-12 Solano 95 3324   27570
12655 12655 Dixon Dixon 2022-05-12 Solano 95 4440   19794
12656 12656 Fairfield Fairfield 2022-05-12 Solano 95 23370   117149
12657 12657 Rio Vista Rio Vista 2022-05-12 Solano 95 1219   9416
12658 12658 Suisun City Suisun City 2022-05-12 Solano 95 6140   29447
12659 12659 Unincorporated Other 2022-05-12 Solano 95 202   19580
12660 12660 Vacaville Vacaville 2022-05-12 Solano 95 22302   98807
12661 12661 Vallejo Vallejo 2022-05-12 Solano 95 26381   119544
13931 13931 Benicia Benicia 2022-05-11 Solano 95 3310   27570
13932 13932 Dixon Dixon 2022-05-11 Solano 95 4421   19794
13933 13933 Fairfield Fairfield 2022-05-11 Solano 95 23260   117149
13934 13934 Rio Vista Rio Vista 2022-05-11 Solano 95 1212   9416
13935 13935 Suisun City Suisun City 2022-05-11 Solano 95 6109   29447
13936 13936 Unincorporated Other 2022-05-11 Solano 95 201   19580
13937 13937 Vacaville Vacaville 2022-05-11 Solano 95 22107   98807
13938 13938 Vallejo Vallejo 2022-05-11 Solano 95 26256   119544
15208 15208 Benicia Benicia 2022-05-10 Solano 95 3310   27570
15209 15209 Dixon Dixon 2022-05-10 Solano 95 4421   19794
15210 15210 Fairfield Fairfield 2022-05-10 Solano 95 23260   117149
15211 15211 Rio Vista Rio Vista 2022-05-10 Solano 95 1212   9416
15212 15212 Suisun City Suisun City 2022-05-10 Solano 95 6109   29447
15213 15213 Unincorporated Other 2022-05-10 Solano 95 201   19580
15214 15214 Vacaville Vacaville 2022-05-10 Solano 95 22107   98807
15215 15215 Vallejo Vallejo 2022-05-10 Solano 95 26256   119544
16485 16485 Benicia Benicia 2022-05-09 Solano 95 3310   27570
16486 16486 Dixon Dixon 2022-05-09 Solano 95 4421   19794
16487 16487 Fairfield Fairfield 2022-05-09 Solano 95 23260   117149
16488 16488 Rio Vista Rio Vista 2022-05-09 Solano 95 1212   9416

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 1716.26ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals