latimes_place_totals

Table actions
⚠️ 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

12 rows where county = "Calaveras" and "date" is on date 2022-02-23 sorted by date descending

✎ View and edit SQL

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

fips 1

  • 9 12

county 1

  • Calaveras · 12 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
388115 388115 95221, 95222 95221, 95222 2022-02-23 Calaveras 9 1009   5029
388116 388116 95223 95223 2022-02-23 Calaveras 9 369   2666
388117 388117 95225 95225 2022-02-23 Calaveras 9 97   378
388118 388118 95226, 95252 95226, 95252 2022-02-23 Calaveras 9 2430   16262
388119 388119 95228 95228 2022-02-23 Calaveras 9 795   4541
388120 388120 95232, 95245 95232, 95245 2022-02-23 Calaveras 9 282   161
388121 388121 95233, 95224, 95247, 95251, 95229 95233, 95224, 95247, 95251, 95229 2022-02-23 Calaveras 9 833   5364
388122 388122 95246, 95250 95246, 95250 2022-02-23 Calaveras 9 148   1159
388123 388123 95249 95249 2022-02-23 Calaveras 9 725   5444
388124 388124 95254 95254 2022-02-23 Calaveras 9 82   1035
388125 388125 95255, 95257, 95248 95255, 95257, 95248 2022-02-23 Calaveras 9 307   1802
388126 388126 Other Other 2022-02-23 Calaveras 9 53    

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
);