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 county = "Contra Costa" 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

county 1

  • Contra Costa · 559 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
7 7 2021-09-02 Contra Costa 13 90440 882 193 10
65 65 2021-09-01 Contra Costa 13 90247 872 293 3
123 123 2021-08-31 Contra Costa 13 89954 869 1904 0
181 181 2021-08-30 Contra Costa 13 88050 869 244 0
239 239 2021-08-29 Contra Costa 13 87806 869 508 0
297 297 2021-08-28 Contra Costa 13 87298 869 561 0
355 355 2021-08-27 Contra Costa 13 86737 869 549 6
413 413 2021-08-26 Contra Costa 13 86188 863 489 3
471 471 2021-08-25 Contra Costa 13 85699 860 361 6
529 529 2021-08-24 Contra Costa 13 85338 854 319 0
587 587 2021-08-23 Contra Costa 13 85019 854 290 0
645 645 2021-08-22 Contra Costa 13 84729 854 238 0
703 703 2021-08-21 Contra Costa 13 84491 854 409 0
761 761 2021-08-20 Contra Costa 13 84082 854 431 5
819 819 2021-08-19 Contra Costa 13 83651 849 801 3
877 877 2021-08-18 Contra Costa 13 82850 846 0 0
935 935 2021-08-17 Contra Costa 13 82850 846 410 0
993 993 2021-08-16 Contra Costa 13 82440 846 290 0
1051 1051 2021-08-15 Contra Costa 13 82150 846 327 0
1109 1109 2021-08-14 Contra Costa 13 81823 846 417 0
1167 1167 2021-08-13 Contra Costa 13 81406 846 316 3
1225 1225 2021-08-12 Contra Costa 13 81090 843 462 2
1283 1283 2021-08-11 Contra Costa 13 80628 841 260 3
1341 1341 2021-08-10 Contra Costa 13 80368 838 268 0
1399 1399 2021-08-09 Contra Costa 13 80100 838 286 0
1457 1457 2021-08-08 Contra Costa 13 79814 838 284 0
1515 1515 2021-08-07 Contra Costa 13 79530 838 385 0
1573 1573 2021-08-06 Contra Costa 13 79145 838 276 0
1631 1631 2021-08-05 Contra Costa 13 78869 838 555 0
1689 1689 2021-08-04 Contra Costa 13 78314 838 230 4
1747 1747 2021-08-03 Contra Costa 13 78084 834 218 0
1805 1805 2021-08-02 Contra Costa 13 77866 834 158 0
1863 1863 2021-08-01 Contra Costa 13 77708 834 437 0
1921 1921 2021-07-31 Contra Costa 13 77271 834 595 1
1979 1979 2021-07-30 Contra Costa 13 76676 833 470 3
2037 2037 2021-07-29 Contra Costa 13 76206 830 364 0
2095 2095 2021-07-28 Contra Costa 13 75842 830 262 2
2153 2153 2021-07-27 Contra Costa 13 75580 828 368 0
2211 2211 2021-07-26 Contra Costa 13 75212 828 227 0
2269 2269 2021-07-25 Contra Costa 13 74985 828 319 0
2327 2327 2021-07-24 Contra Costa 13 74666 828 297 0
2385 2385 2021-07-23 Contra Costa 13 74369 828 339 0
2443 2443 2021-07-22 Contra Costa 13 74030 828 368 3
2501 2501 2021-07-21 Contra Costa 13 73662 825 167 2
2559 2559 2021-07-20 Contra Costa 13 73495 823 205 0
2617 2617 2021-07-19 Contra Costa 13 73290 823 88 0
2675 2675 2021-07-18 Contra Costa 13 73202 823 221 0
2733 2733 2021-07-17 Contra Costa 13 72981 823 205 0
2791 2791 2021-07-16 Contra Costa 13 72776 823 174 1
2849 2849 2021-07-15 Contra Costa 13 72602 822 160 1
2907 2907 2021-07-14 Contra Costa 13 72442 821 116 0
2965 2965 2021-07-13 Contra Costa 13 72326 821 217 0
3023 3023 2021-07-12 Contra Costa 13 72109 821 0 0
3081 3081 2021-07-11 Contra Costa 13 72109 821 128 0
3139 3139 2021-07-10 Contra Costa 13 71981 821 105 1
3197 3197 2021-07-09 Contra Costa 13 71876 820 118 1
3255 3255 2021-07-08 Contra Costa 13 71758 819 64 0
3313 3313 2021-07-07 Contra Costa 13 71694 819 46 1
3371 3371 2021-07-06 Contra Costa 13 71648 818 32 0
3429 3429 2021-07-05 Contra Costa 13 71616 818 68 0
3487 3487 2021-07-04 Contra Costa 13 71548 818 70 0
3545 3545 2021-07-03 Contra Costa 13 71478 818 79 1
3603 3603 2021-07-02 Contra Costa 13 71399 817 80 1
3661 3661 2021-07-01 Contra Costa 13 71319 816 69 0
3719 3719 2021-06-30 Contra Costa 13 71250 816 100 1
3777 3777 2021-06-29 Contra Costa 13 71150 815 57 0
3835 3835 2021-06-28 Contra Costa 13 71093 815 45 0
3893 3893 2021-06-27 Contra Costa 13 71048 815 103 1
3951 3951 2021-06-26 Contra Costa 13 70945 814 0 0
4009 4009 2021-06-25 Contra Costa 13 70945 814 63 2
4067 4067 2021-06-24 Contra Costa 13 70882 812 64 0
4125 4125 2021-06-23 Contra Costa 13 70818 812 48 1
4183 4183 2021-06-22 Contra Costa 13 70770 811 40 0
4241 4241 2021-06-21 Contra Costa 13 70730 811 39 0
4299 4299 2021-06-20 Contra Costa 13 70691 811 67 0
4357 4357 2021-06-19 Contra Costa 13 70624 811 63 0
4415 4415 2021-06-18 Contra Costa 13 70561 811 83 3
4473 4473 2021-06-17 Contra Costa 13 70478 808 50 0
4531 4531 2021-06-16 Contra Costa 13 70428 808 39 0
4589 4589 2021-06-15 Contra Costa 13 70389 808 31 0
4647 4647 2021-06-14 Contra Costa 13 70358 808 30 0
4705 4705 2021-06-13 Contra Costa 13 70328 808 52 0
4763 4763 2021-06-12 Contra Costa 13 70276 808 48 2
4821 4821 2021-06-11 Contra Costa 13 70228 806 60 1
4879 4879 2021-06-10 Contra Costa 13 70168 805 52 1
4937 4937 2021-06-09 Contra Costa 13 70116 804 68 0
4995 4995 2021-06-08 Contra Costa 13 70048 804 45 0
5053 5053 2021-06-07 Contra Costa 13 70003 804 58 0
5111 5111 2021-06-06 Contra Costa 13 69945 804 59 0
5169 5169 2021-06-05 Contra Costa 13 69886 804 59 2
5227 5227 2021-06-04 Contra Costa 13 69827 802 36 0
5285 5285 2021-06-03 Contra Costa 13 69791 802 46 2
5343 5343 2021-06-02 Contra Costa 13 69745 800 52 1
5401 5401 2021-06-01 Contra Costa 13 69693 799 17 0
5459 5459 2021-05-31 Contra Costa 13 69676 799 13 0
5517 5517 2021-05-30 Contra Costa 13 69663 799 28 0
5575 5575 2021-05-29 Contra Costa 13 69635 799 61 0
5633 5633 2021-05-28 Contra Costa 13 69574 799 42 0
5691 5691 2021-05-27 Contra Costa 13 69532 799 36 1
5749 5749 2021-05-26 Contra Costa 13 69496 798 42 2

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