latimes_county_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_county_totals

560 rows where fips = 95 sorted by date descending

✎ View and edit SQL

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

Suggested facets: new_deaths, date (date)

fips 1

  • 95 · 560 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
48 48 2021-09-02 Solano 95 41521 273 0 0
106 106 2021-09-01 Solano 95 41521 273 1044 3
164 164 2021-08-31 Solano 95 40477 270 0 0
222 222 2021-08-30 Solano 95 40477 270 677 4
280 280 2021-08-29 Solano 95 39800 266 0 0
338 338 2021-08-28 Solano 95 39800 266 0 0
396 396 2021-08-27 Solano 95 39800 266 471 0
454 454 2021-08-26 Solano 95 39329 266 0 0
512 512 2021-08-25 Solano 95 39329 266 327 2
570 570 2021-08-24 Solano 95 39002 264 0 0
628 628 2021-08-23 Solano 95 39002 264 238 2
686 686 2021-08-22 Solano 95 38764 262 0 0
744 744 2021-08-21 Solano 95 38764 262 0 0
802 802 2021-08-20 Solano 95 38764 262 470 3
860 860 2021-08-19 Solano 95 38294 259 0 0
918 918 2021-08-18 Solano 95 38294 259 380 0
976 976 2021-08-17 Solano 95 37914 259 0 0
1034 1034 2021-08-16 Solano 95 37914 259 250 5
1092 1092 2021-08-15 Solano 95 37664 254 0 0
1150 1150 2021-08-14 Solano 95 37664 254 0 0
1208 1208 2021-08-13 Solano 95 37664 254 314 0
1266 1266 2021-08-12 Solano 95 37350 254 0 0
1324 1324 2021-08-11 Solano 95 37350 254 294 0
1382 1382 2021-08-10 Solano 95 37056 254 0 0
1440 1440 2021-08-09 Solano 95 37056 254 208 5
1498 1498 2021-08-08 Solano 95 36848 249 0 0
1556 1556 2021-08-07 Solano 95 36848 249 0 0
1614 1614 2021-08-06 Solano 95 36848 249 323 0
1672 1672 2021-08-05 Solano 95 36525 249 0 0
1730 1730 2021-08-04 Solano 95 36525 249 276 0
1788 1788 2021-08-03 Solano 95 36249 249 0 0
1846 1846 2021-08-02 Solano 95 36249 249 245 0
1904 1904 2021-08-01 Solano 95 36004 249 0 0
1962 1962 2021-07-31 Solano 95 36004 249 0 0
2020 2020 2021-07-30 Solano 95 36004 249 301 0
2078 2078 2021-07-29 Solano 95 35703 249 0 0
2136 2136 2021-07-28 Solano 95 35703 249 221 4
2194 2194 2021-07-27 Solano 95 35482 245 0 0
2252 2252 2021-07-26 Solano 95 35482 245 289 0
2310 2310 2021-07-25 Solano 95 35193 245 0 0
2368 2368 2021-07-24 Solano 95 35193 245 0 0
2426 2426 2021-07-23 Solano 95 35193 245 308 0
2484 2484 2021-07-22 Solano 95 34885 245 0 0
2542 2542 2021-07-21 Solano 95 34885 245 124 0
2600 2600 2021-07-20 Solano 95 34761 245 0 0
2658 2658 2021-07-19 Solano 95 34761 245 131 0
2716 2716 2021-07-18 Solano 95 34630 245 0 0
2774 2774 2021-07-17 Solano 95 34630 245 0 0
2832 2832 2021-07-16 Solano 95 34630 245 169 0
2890 2890 2021-07-15 Solano 95 34461 245 0 0
2948 2948 2021-07-14 Solano 95 34461 245 84 0
3006 3006 2021-07-13 Solano 95 34377 245 0 0
3064 3064 2021-07-12 Solano 95 34377 245 137 0
3122 3122 2021-07-11 Solano 95 34240 245 0 0
3180 3180 2021-07-10 Solano 95 34240 245 91 0
3238 3238 2021-07-09 Solano 95 34149 245 0 0
3296 3296 2021-07-08 Solano 95 34149 245 0 0
3354 3354 2021-07-07 Solano 95 34149 245 105 1
3412 3412 2021-07-06 Solano 95 34044 244 0 0
3470 3470 2021-07-05 Solano 95 34044 244 0 0
3528 3528 2021-07-04 Solano 95 34044 244 0 0
3586 3586 2021-07-03 Solano 95 34044 244 0 0
3644 3644 2021-07-02 Solano 95 34044 244 71 0
3702 3702 2021-07-01 Solano 95 33973 244 0 0
3760 3760 2021-06-30 Solano 95 33973 244 75 0
3818 3818 2021-06-29 Solano 95 33898 244 0 0
3876 3876 2021-06-28 Solano 95 33898 244 52 0
3934 3934 2021-06-27 Solano 95 33846 244 0 0
3992 3992 2021-06-26 Solano 95 33846 244 0 0
4050 4050 2021-06-25 Solano 95 33846 244 49 0
4108 4108 2021-06-24 Solano 95 33797 244 0 0
4166 4166 2021-06-23 Solano 95 33797 244 35 0
4224 4224 2021-06-22 Solano 95 33762 244 0 0
4282 4282 2021-06-21 Solano 95 33762 244 55 0
4340 4340 2021-06-20 Solano 95 33707 244 0 0
4398 4398 2021-06-19 Solano 95 33707 244 0 0
4456 4456 2021-06-18 Solano 95 33707 244 34 0
4514 4514 2021-06-17 Solano 95 33673 244 22 0
4572 4572 2021-06-16 Solano 95 33651 244 15 0
4630 4630 2021-06-15 Solano 95 33636 244 11 0
4688 4688 2021-06-14 Solano 95 33625 244 56 0
4746 4746 2021-06-13 Solano 95 33569 244 0 0
4804 4804 2021-06-12 Solano 95 33569 244 0 0
4862 4862 2021-06-11 Solano 95 33569 244 10 0
4920 4920 2021-06-10 Solano 95 33559 244 26 0
4978 4978 2021-06-09 Solano 95 33533 244 15 0
5036 5036 2021-06-08 Solano 95 33518 244 7 0
5094 5094 2021-06-07 Solano 95 33511 244 20 0
5152 5152 2021-06-06 Solano 95 33491 244 0 0
5210 5210 2021-06-05 Solano 95 33491 244 0 0
5268 5268 2021-06-04 Solano 95 33491 244 22 1
5326 5326 2021-06-03 Solano 95 33469 243 39 0
5384 5384 2021-06-02 Solano 95 33430 243 33 0
5442 5442 2021-06-01 Solano 95 33397 243 104 5
5500 5500 2021-05-31 Solano 95 33293 238 0 0
5558 5558 2021-05-30 Solano 95 33293 238 0 0
5616 5616 2021-05-29 Solano 95 33293 238 0 0
5674 5674 2021-05-28 Solano 95 33293 238 32 4
5732 5732 2021-05-27 Solano 95 33261 234 43 0
5790 5790 2021-05-26 Solano 95 33218 234 16 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);