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

559 rows where fips = 113 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

  • 113 · 559 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
57 57 2021-09-02 Yolo 113 17244 231 68 0
115 115 2021-09-01 Yolo 113 17176 231 126 0
173 173 2021-08-31 Yolo 113 17050 231 125 2
231 231 2021-08-30 Yolo 113 16925 229 165 0
289 289 2021-08-29 Yolo 113 16760 229 0 0
347 347 2021-08-28 Yolo 113 16760 229 0 0
405 405 2021-08-27 Yolo 113 16760 229 118 0
463 463 2021-08-26 Yolo 113 16642 229 108 0
521 521 2021-08-25 Yolo 113 16534 229 76 0
579 579 2021-08-24 Yolo 113 16458 229 90 5
637 637 2021-08-23 Yolo 113 16368 224 203 1
695 695 2021-08-22 Yolo 113 16165 223 0 0
753 753 2021-08-21 Yolo 113 16165 223 0 0
811 811 2021-08-20 Yolo 113 16165 223 118 0
869 869 2021-08-19 Yolo 113 16047 223 61 0
927 927 2021-08-18 Yolo 113 15986 223 53 0
985 985 2021-08-17 Yolo 113 15933 223 56 0
1043 1043 2021-08-16 Yolo 113 15877 223 161 0
1101 1101 2021-08-15 Yolo 113 15716 223 0 0
1159 1159 2021-08-14 Yolo 113 15716 223 0 0
1217 1217 2021-08-13 Yolo 113 15716 223 81 1
1275 1275 2021-08-12 Yolo 113 15635 222 75 6
1333 1333 2021-08-11 Yolo 113 15560 216 27 0
1391 1391 2021-08-10 Yolo 113 15533 216 102 0
1449 1449 2021-08-09 Yolo 113 15431 216 179 0
1507 1507 2021-08-08 Yolo 113 15252 216 0 0
1565 1565 2021-08-07 Yolo 113 15252 216 0 0
1623 1623 2021-08-06 Yolo 113 15252 216 44 0
1681 1681 2021-08-05 Yolo 113 15208 216 76 3
1739 1739 2021-08-04 Yolo 113 15132 213 93 0
1797 1797 2021-08-03 Yolo 113 15039 213 0 0
1855 1855 2021-08-02 Yolo 113 15039 213 176 0
1913 1913 2021-08-01 Yolo 113 14863 213 0 0
1971 1971 2021-07-31 Yolo 113 14863 213 0 0
2029 2029 2021-07-30 Yolo 113 14863 213 64 0
2087 2087 2021-07-29 Yolo 113 14799 213 44 0
2145 2145 2021-07-28 Yolo 113 14755 213 15 0
2203 2203 2021-07-27 Yolo 113 14740 213 41 0
2261 2261 2021-07-26 Yolo 113 14699 213 125 0
2319 2319 2021-07-25 Yolo 113 14574 213 0 0
2377 2377 2021-07-24 Yolo 113 14574 213 0 0
2435 2435 2021-07-23 Yolo 113 14574 213 51 1
2493 2493 2021-07-22 Yolo 113 14523 212 25 1
2551 2551 2021-07-21 Yolo 113 14498 211 48 0
2609 2609 2021-07-20 Yolo 113 14450 211 24 0
2667 2667 2021-07-19 Yolo 113 14426 211 68 0
2725 2725 2021-07-18 Yolo 113 14358 211 0 0
2783 2783 2021-07-17 Yolo 113 14358 211 0 0
2841 2841 2021-07-16 Yolo 113 14358 211 43 0
2899 2899 2021-07-15 Yolo 113 14315 211 24 0
2957 2957 2021-07-14 Yolo 113 14291 211 19 1
3015 3015 2021-07-13 Yolo 113 14272 210 18 0
3073 3073 2021-07-12 Yolo 113 14254 210 35 0
3131 3131 2021-07-11 Yolo 113 14219 210 0 0
3189 3189 2021-07-10 Yolo 113 14219 210 0 0
3247 3247 2021-07-09 Yolo 113 14219 210 25 0
3305 3305 2021-07-08 Yolo 113 14194 210 14 0
3363 3363 2021-07-07 Yolo 113 14180 210 10 0
3421 3421 2021-07-06 Yolo 113 14170 210 23 0
3479 3479 2021-07-05 Yolo 113 14147 210 0 0
3537 3537 2021-07-04 Yolo 113 14147 210 0 0
3595 3595 2021-07-03 Yolo 113 14147 210 0 0
3653 3653 2021-07-02 Yolo 113 14147 210 12 0
3711 3711 2021-07-01 Yolo 113 14135 210 5 0
3769 3769 2021-06-30 Yolo 113 14130 210 6 0
3827 3827 2021-06-29 Yolo 113 14124 210 0 0
3885 3885 2021-06-28 Yolo 113 14124 210 2 0
3943 3943 2021-06-27 Yolo 113 14122 210 0 0
4001 4001 2021-06-26 Yolo 113 14122 210 0 0
4059 4059 2021-06-25 Yolo 113 14122 210 6 0
4117 4117 2021-06-24 Yolo 113 14116 210 7 1
4175 4175 2021-06-23 Yolo 113 14109 209 0 0
4233 4233 2021-06-22 Yolo 113 14109 209 10 0
4291 4291 2021-06-21 Yolo 113 14099 209 17 0
4349 4349 2021-06-20 Yolo 113 14082 209 0 0
4407 4407 2021-06-19 Yolo 113 14082 209 0 0
4465 4465 2021-06-18 Yolo 113 14082 209 3 0
4523 4523 2021-06-17 Yolo 113 14079 209 9 0
4581 4581 2021-06-16 Yolo 113 14070 209 6 0
4639 4639 2021-06-15 Yolo 113 14064 209 2 0
4697 4697 2021-06-14 Yolo 113 14062 209 13 0
4755 4755 2021-06-13 Yolo 113 14049 209 0 0
4813 4813 2021-06-12 Yolo 113 14049 209 0 0
4871 4871 2021-06-11 Yolo 113 14049 209 8 0
4929 4929 2021-06-10 Yolo 113 14041 209 4 0
4987 4987 2021-06-09 Yolo 113 14037 209 3 0
5045 5045 2021-06-08 Yolo 113 14034 209 9 1
5103 5103 2021-06-07 Yolo 113 14025 208 8 0
5161 5161 2021-06-06 Yolo 113 14017 208 0 0
5219 5219 2021-06-05 Yolo 113 14017 208 0 0
5277 5277 2021-06-04 Yolo 113 14017 208 5 0
5335 5335 2021-06-03 Yolo 113 14012 208 12 0
5393 5393 2021-06-02 Yolo 113 14000 208 5 0
5451 5451 2021-06-01 Yolo 113 13995 208 13 0
5509 5509 2021-05-31 Yolo 113 13982 208 0 0
5567 5567 2021-05-30 Yolo 113 13982 208 0 0
5625 5625 2021-05-29 Yolo 113 13982 208 0 0
5683 5683 2021-05-28 Yolo 113 13982 208 14 0
5741 5741 2021-05-27 Yolo 113 13968 208 11 0
5799 5799 2021-05-26 Yolo 113 13957 208 18 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
);