cdph-county-cases-deaths
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- county
- The name of the county where the agency is based.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- date
- The date when the data were retrieved in ISO 8601 format.
- confirmed_cases
- The cumulative number of coronavirus cases that were confirmed as of that time. This is sometimes called the episode date by other sources.
- reported_cases
- The cumulative number of coronavirus cases that were reported as of that time. This reflects when cases were first announced by the state.
- probable_cases
- The cumulative number of probable coronavirus cases that were confirmed as of that time. This reflects the results of antigen tests, a rapid testing technique different from the standard test.
- reported_and_probable_cases
- The cumulative number of reported and probable coronavirus cases as of that time.
- reported_deaths
- The cumulative number of deaths reported at that time.
61,538 rows sorted by confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | population | confirmed_cases ▲ | reported_cases | probable_cases | reported_and_probable_cases | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
19 | 19 | 2022-12-27 | Los Angeles | 37 | 10098052 | 3420119 | 3420383 | 203950 | 3624333 | 34360 |
77 | 77 | 2022-12-26 | Los Angeles | 37 | 10098052 | 3420119 | 3399852 | 203950 | 3603802 | 34170 |
135 | 135 | 2022-12-25 | Los Angeles | 37 | 10098052 | 3420005 | 3399852 | 203934 | 3603786 | 34170 |
193 | 193 | 2022-12-24 | Los Angeles | 37 | 10098052 | 3419672 | 3399852 | 203902 | 3603754 | 34170 |
251 | 251 | 2022-12-23 | Los Angeles | 37 | 10098052 | 3419029 | 3399852 | 203771 | 3603623 | 34170 |
309 | 309 | 2022-12-22 | Los Angeles | 37 | 10098052 | 3417660 | 3399852 | 203580 | 3603432 | 34170 |
367 | 367 | 2022-12-21 | Los Angeles | 37 | 10098052 | 3416156 | 3399852 | 203330 | 3603182 | 34170 |
425 | 425 | 2022-12-20 | Los Angeles | 37 | 10098052 | 3414187 | 3399852 | 202895 | 3602747 | 34170 |
483 | 483 | 2022-12-19 | Los Angeles | 37 | 10098052 | 3411742 | 3390335 | 202473 | 3592808 | 34114 |
541 | 541 | 2022-12-18 | Los Angeles | 37 | 10098052 | 3409130 | 3390335 | 202089 | 3592424 | 34114 |
599 | 599 | 2022-12-17 | Los Angeles | 37 | 10098052 | 3408065 | 3390335 | 201918 | 3592253 | 34114 |
657 | 657 | 2022-12-16 | Los Angeles | 37 | 10098052 | 3406799 | 3390335 | 201694 | 3592029 | 34114 |
715 | 715 | 2022-12-15 | Los Angeles | 37 | 10098052 | 3404964 | 3390335 | 201403 | 3591738 | 34114 |
773 | 773 | 2022-12-14 | Los Angeles | 37 | 10098052 | 3402755 | 3390335 | 201010 | 3591345 | 34114 |
831 | 831 | 2022-12-13 | Los Angeles | 37 | 10098052 | 3400302 | 3390335 | 200613 | 3590948 | 34114 |
889 | 889 | 2022-12-12 | Los Angeles | 37 | 10098052 | 3397681 | 3370904 | 200237 | 3571141 | 34009 |
947 | 947 | 2022-12-11 | Los Angeles | 37 | 10098052 | 3394609 | 3370904 | 199738 | 3570642 | 34009 |
1005 | 1005 | 2022-12-10 | Los Angeles | 37 | 10098052 | 3393211 | 3370904 | 199515 | 3570419 | 34009 |
1063 | 1063 | 2022-12-09 | Los Angeles | 37 | 10098052 | 3391532 | 3370904 | 199229 | 3570133 | 34009 |
1121 | 1121 | 2022-12-08 | Los Angeles | 37 | 10098052 | 3389096 | 3370904 | 198846 | 3569750 | 34009 |
1179 | 1179 | 2022-12-07 | Los Angeles | 37 | 10098052 | 3386476 | 3370904 | 198391 | 3569295 | 34009 |
1237 | 1237 | 2022-12-06 | Los Angeles | 37 | 10098052 | 3383640 | 3370904 | 197847 | 3568751 | 34009 |
1295 | 1295 | 2022-12-05 | Los Angeles | 37 | 10098052 | 3380594 | 3346956 | 197321 | 3544277 | 33937 |
1353 | 1353 | 2022-12-04 | Los Angeles | 37 | 10098052 | 3376827 | 3346956 | 196680 | 3543636 | 33937 |
1411 | 1411 | 2022-12-03 | Los Angeles | 37 | 10098052 | 3374956 | 3346956 | 196359 | 3543315 | 33937 |
1469 | 1469 | 2022-12-02 | Los Angeles | 37 | 10098052 | 3372932 | 3346956 | 195967 | 3542923 | 33937 |
1527 | 1527 | 2022-12-01 | Los Angeles | 37 | 10098052 | 3370073 | 3346956 | 195485 | 3542441 | 33937 |
1585 | 1585 | 2022-11-30 | Los Angeles | 37 | 10098052 | 3366646 | 3346956 | 194944 | 3541900 | 33937 |
1643 | 1643 | 2022-11-29 | Los Angeles | 37 | 10098052 | 3362718 | 3346956 | 194380 | 3541336 | 33937 |
1701 | 1701 | 2022-11-28 | Los Angeles | 37 | 10098052 | 3358454 | 3332327 | 193844 | 3526171 | 33882 |
1759 | 1759 | 2022-11-27 | Los Angeles | 37 | 10098052 | 3353389 | 3332327 | 193193 | 3525520 | 33882 |
1817 | 1817 | 2022-11-26 | Los Angeles | 37 | 10098052 | 3350974 | 3332327 | 192853 | 3525180 | 33882 |
1875 | 1875 | 2022-11-25 | Los Angeles | 37 | 10098052 | 3348697 | 3332327 | 192477 | 3524804 | 33882 |
1933 | 1933 | 2022-11-24 | Los Angeles | 37 | 10098052 | 3346112 | 3332327 | 192052 | 3524379 | 33882 |
1991 | 1991 | 2022-11-23 | Los Angeles | 37 | 10098052 | 3345074 | 3332327 | 191864 | 3524191 | 33882 |
2049 | 2049 | 2022-11-22 | Los Angeles | 37 | 10098052 | 3342403 | 3332327 | 191421 | 3523748 | 33882 |
2107 | 2107 | 2022-11-21 | Los Angeles | 37 | 10098052 | 3339820 | 3320411 | 190976 | 3511387 | 33830 |
2165 | 2165 | 2022-11-20 | Los Angeles | 37 | 10098052 | 3336978 | 3320411 | 190519 | 3510930 | 33830 |
2223 | 2223 | 2022-11-19 | Los Angeles | 37 | 10098052 | 3335511 | 3320411 | 190281 | 3510692 | 33830 |
2281 | 2281 | 2022-11-18 | Los Angeles | 37 | 10098052 | 3334131 | 3320411 | 190038 | 3510449 | 33830 |
2339 | 2339 | 2022-11-17 | Los Angeles | 37 | 10098052 | 3332198 | 3320411 | 189754 | 3510165 | 33830 |
2397 | 2397 | 2022-11-16 | Los Angeles | 37 | 10098052 | 3330394 | 3320411 | 189448 | 3509859 | 33830 |
2455 | 2455 | 2022-11-15 | Los Angeles | 37 | 10098052 | 3328532 | 3320411 | 189183 | 3509594 | 33830 |
2513 | 2513 | 2022-11-14 | Los Angeles | 37 | 10098052 | 3326771 | 3311644 | 188877 | 3500521 | 33784 |
2571 | 2571 | 2022-11-13 | Los Angeles | 37 | 10098052 | 3324834 | 3311644 | 188603 | 3500247 | 33784 |
2629 | 2629 | 2022-11-12 | Los Angeles | 37 | 10098052 | 3323870 | 3311644 | 188437 | 3500081 | 33784 |
2687 | 2687 | 2022-11-11 | Los Angeles | 37 | 10098052 | 3322927 | 3311644 | 188270 | 3499914 | 33784 |
2745 | 2745 | 2022-11-10 | Los Angeles | 37 | 10098052 | 3321662 | 3311644 | 188112 | 3499756 | 33784 |
2803 | 2803 | 2022-11-09 | Los Angeles | 37 | 10098052 | 3320202 | 3311644 | 187932 | 3499576 | 33784 |
2861 | 2861 | 2022-11-08 | Los Angeles | 37 | 10098052 | 3318786 | 3311644 | 187732 | 3499376 | 33784 |
2919 | 2919 | 2022-11-07 | Los Angeles | 37 | 10098052 | 3317424 | 3304428 | 187489 | 3491917 | 33733 |
2977 | 2977 | 2022-11-06 | Los Angeles | 37 | 10098052 | 3315782 | 3304428 | 187245 | 3491673 | 33733 |
3035 | 3035 | 2022-11-05 | Los Angeles | 37 | 10098052 | 3314936 | 3304428 | 187107 | 3491535 | 33733 |
3093 | 3093 | 2022-11-04 | Los Angeles | 37 | 10098052 | 3314118 | 3304428 | 186960 | 3491388 | 33733 |
3151 | 3151 | 2022-11-03 | Los Angeles | 37 | 10098052 | 3313031 | 3304428 | 186761 | 3491189 | 33733 |
3209 | 3209 | 2022-11-02 | Los Angeles | 37 | 10098052 | 3311839 | 3304428 | 186568 | 3490996 | 33733 |
3267 | 3267 | 2022-11-01 | Los Angeles | 37 | 10098052 | 3310610 | 3304428 | 186350 | 3490778 | 33733 |
3325 | 3325 | 2022-10-31 | Los Angeles | 37 | 10098052 | 3309381 | 3298549 | 186119 | 3484668 | 33679 |
3383 | 3383 | 2022-10-30 | Los Angeles | 37 | 10098052 | 3308117 | 3298549 | 185880 | 3484429 | 33679 |
3441 | 3441 | 2022-10-29 | Los Angeles | 37 | 10098052 | 3307491 | 3298549 | 185767 | 3484316 | 33679 |
3499 | 3499 | 2022-10-28 | Los Angeles | 37 | 10098052 | 3306864 | 3298549 | 185643 | 3484192 | 33679 |
3557 | 3557 | 2022-10-27 | Los Angeles | 37 | 10098052 | 3305997 | 3298549 | 185495 | 3484044 | 33679 |
3615 | 3615 | 2022-10-26 | Los Angeles | 37 | 10098052 | 3305073 | 3298549 | 185349 | 3483898 | 33679 |
3673 | 3673 | 2022-10-25 | Los Angeles | 37 | 10098052 | 3304189 | 3298549 | 185205 | 3483754 | 33679 |
3731 | 3731 | 2022-10-24 | Los Angeles | 37 | 10098052 | 3303191 | 3289814 | 185034 | 3474848 | 33533 |
3789 | 3789 | 2022-10-23 | Los Angeles | 37 | 10098052 | 3302238 | 3289814 | 184837 | 3474651 | 33533 |
3847 | 3847 | 2022-10-22 | Los Angeles | 37 | 10098052 | 3301722 | 3289814 | 184748 | 3474562 | 33533 |
3905 | 3905 | 2022-10-21 | Los Angeles | 37 | 10098052 | 3301164 | 3289814 | 184624 | 3474438 | 33533 |
3963 | 3963 | 2022-10-20 | Los Angeles | 37 | 10098052 | 3300417 | 3289814 | 184500 | 3474314 | 33533 |
4021 | 4021 | 2022-10-19 | Los Angeles | 37 | 10098052 | 3299591 | 3289814 | 184362 | 3474176 | 33533 |
4079 | 4079 | 2022-10-18 | Los Angeles | 37 | 10098052 | 3298781 | 3289814 | 184226 | 3474040 | 33533 |
4137 | 4137 | 2022-10-17 | Los Angeles | 37 | 10098052 | 3297882 | 3285385 | 184075 | 3469460 | 33525 |
4195 | 4195 | 2022-10-16 | Los Angeles | 37 | 10098052 | 3296954 | 3285385 | 183919 | 3469304 | 33525 |
4253 | 4253 | 2022-10-15 | Los Angeles | 37 | 10098052 | 3296482 | 3285385 | 183828 | 3469213 | 33525 |
4311 | 4311 | 2022-10-14 | Los Angeles | 37 | 10098052 | 3295978 | 3285385 | 183732 | 3469117 | 33525 |
4369 | 4369 | 2022-10-13 | Los Angeles | 37 | 10098052 | 3295237 | 3285385 | 183600 | 3468985 | 33525 |
4427 | 4427 | 2022-10-12 | Los Angeles | 37 | 10098052 | 3294477 | 3285385 | 183457 | 3468842 | 33525 |
4485 | 4485 | 2022-10-11 | Los Angeles | 37 | 10098052 | 3293648 | 3285385 | 183326 | 3468711 | 33525 |
4543 | 4543 | 2022-10-10 | Los Angeles | 37 | 10098052 | 3292763 | 3278961 | 183175 | 3462136 | 33467 |
4601 | 4601 | 2022-10-09 | Los Angeles | 37 | 10098052 | 3291760 | 3278961 | 183007 | 3461968 | 33467 |
4659 | 4659 | 2022-10-08 | Los Angeles | 37 | 10098052 | 3291195 | 3278961 | 182916 | 3461877 | 33467 |
4717 | 4717 | 2022-10-07 | Los Angeles | 37 | 10098052 | 3290578 | 3278961 | 182811 | 3461772 | 33467 |
4775 | 4775 | 2022-10-06 | Los Angeles | 37 | 10098052 | 3289733 | 3278961 | 182663 | 3461624 | 33467 |
4833 | 4833 | 2022-10-05 | Los Angeles | 37 | 10098052 | 3288900 | 3278961 | 182515 | 3461476 | 33467 |
4891 | 4891 | 2022-10-04 | Los Angeles | 37 | 10098052 | 3288011 | 3278961 | 182350 | 3461311 | 33467 |
4949 | 4949 | 2022-10-03 | Los Angeles | 37 | 10098052 | 3286978 | 3271661 | 182191 | 3453852 | 33336 |
5007 | 5007 | 2022-10-02 | Los Angeles | 37 | 10098052 | 3285833 | 3271661 | 182031 | 3453692 | 33336 |
5065 | 5065 | 2022-10-01 | Los Angeles | 37 | 10098052 | 3285207 | 3271661 | 181917 | 3453578 | 33336 |
5123 | 5123 | 2022-09-30 | Los Angeles | 37 | 10098052 | 3284468 | 3271661 | 181797 | 3453458 | 33336 |
5181 | 5181 | 2022-09-29 | Los Angeles | 37 | 10098052 | 3283482 | 3271661 | 181684 | 3453345 | 33336 |
5239 | 5239 | 2022-09-28 | Los Angeles | 37 | 10098052 | 3282357 | 3271661 | 181575 | 3453236 | 33336 |
5297 | 5297 | 2022-09-27 | Los Angeles | 37 | 10098052 | 3281161 | 3271661 | 181414 | 3453075 | 33336 |
5355 | 5355 | 2022-09-26 | Los Angeles | 37 | 10098052 | 3279972 | 3263510 | 181239 | 3444749 | 33258 |
5413 | 5413 | 2022-09-25 | Los Angeles | 37 | 10098052 | 3278504 | 3263510 | 181042 | 3444552 | 33258 |
5471 | 5471 | 2022-09-24 | Los Angeles | 37 | 10098052 | 3277782 | 3263510 | 180898 | 3444408 | 33258 |
5529 | 5529 | 2022-09-23 | Los Angeles | 37 | 10098052 | 3277017 | 3263510 | 180818 | 3444328 | 33258 |
5587 | 5587 | 2022-09-22 | Los Angeles | 37 | 10098052 | 3275976 | 3263510 | 180668 | 3444178 | 33258 |
5645 | 5645 | 2022-09-21 | Los Angeles | 37 | 10098052 | 3274812 | 3263510 | 180499 | 3444009 | 33258 |
5703 | 5703 | 2022-09-20 | Los Angeles | 37 | 10098052 | 3273649 | 3263510 | 180352 | 3443862 | 33258 |
5761 | 5761 | 2022-09-19 | Los Angeles | 37 | 10098052 | 3272270 | 3253906 | 180168 | 3434074 | 33160 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-county-cases-deaths" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [population] INTEGER, [confirmed_cases] INTEGER, [reported_cases] INTEGER, [probable_cases] INTEGER, [reported_and_probable_cases] INTEGER, [reported_deaths] INTEGER );