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 county
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 |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2022-12-27 | Alameda | 1 | 1643700 | 367947 | 367954 | 21599 | 389553 | 2094 |
59 | 59 | 2022-12-26 | Alameda | 1 | 1643700 | 367947 | 366018 | 21599 | 387617 | 2088 |
117 | 117 | 2022-12-25 | Alameda | 1 | 1643700 | 367801 | 366018 | 21599 | 387617 | 2088 |
175 | 175 | 2022-12-24 | Alameda | 1 | 1643700 | 367725 | 366018 | 21599 | 387617 | 2088 |
233 | 233 | 2022-12-23 | Alameda | 1 | 1643700 | 367613 | 366018 | 21599 | 387617 | 2088 |
291 | 291 | 2022-12-22 | Alameda | 1 | 1643700 | 367333 | 366018 | 21599 | 387617 | 2088 |
349 | 349 | 2022-12-21 | Alameda | 1 | 1643700 | 367027 | 366018 | 21599 | 387617 | 2088 |
407 | 407 | 2022-12-20 | Alameda | 1 | 1643700 | 366718 | 366018 | 21599 | 387617 | 2088 |
465 | 465 | 2022-12-19 | Alameda | 1 | 1643700 | 366390 | 363758 | 21599 | 385357 | 2082 |
523 | 523 | 2022-12-18 | Alameda | 1 | 1643700 | 366005 | 363758 | 21568 | 385326 | 2082 |
581 | 581 | 2022-12-17 | Alameda | 1 | 1643700 | 365797 | 363758 | 21559 | 385317 | 2082 |
639 | 639 | 2022-12-16 | Alameda | 1 | 1643700 | 365572 | 363758 | 21537 | 385295 | 2082 |
697 | 697 | 2022-12-15 | Alameda | 1 | 1643700 | 365261 | 363758 | 21502 | 385260 | 2082 |
755 | 755 | 2022-12-14 | Alameda | 1 | 1643700 | 364947 | 363758 | 21467 | 385225 | 2082 |
813 | 813 | 2022-12-13 | Alameda | 1 | 1643700 | 364577 | 363758 | 21430 | 385188 | 2082 |
871 | 871 | 2022-12-12 | Alameda | 1 | 1643700 | 364181 | 360943 | 21389 | 382332 | 2081 |
929 | 929 | 2022-12-11 | Alameda | 1 | 1643700 | 363767 | 360943 | 21350 | 382293 | 2081 |
987 | 987 | 2022-12-10 | Alameda | 1 | 1643700 | 363536 | 360943 | 21322 | 382265 | 2081 |
1045 | 1045 | 2022-12-09 | Alameda | 1 | 1643700 | 363258 | 360943 | 21296 | 382239 | 2081 |
1103 | 1103 | 2022-12-08 | Alameda | 1 | 1643700 | 362848 | 360943 | 21254 | 382197 | 2081 |
1161 | 1161 | 2022-12-07 | Alameda | 1 | 1643700 | 362480 | 360943 | 21208 | 382151 | 2081 |
1219 | 1219 | 2022-12-06 | Alameda | 1 | 1643700 | 362052 | 360943 | 21174 | 382117 | 2081 |
1277 | 1277 | 2022-12-05 | Alameda | 1 | 1643700 | 361610 | 357689 | 21143 | 378832 | 2063 |
1335 | 1335 | 2022-12-04 | Alameda | 1 | 1643700 | 361070 | 357689 | 21084 | 378773 | 2063 |
1393 | 1393 | 2022-12-03 | Alameda | 1 | 1643700 | 360835 | 357689 | 21051 | 378740 | 2063 |
1451 | 1451 | 2022-12-02 | Alameda | 1 | 1643700 | 360571 | 357689 | 21030 | 378719 | 2063 |
1509 | 1509 | 2022-12-01 | Alameda | 1 | 1643700 | 360168 | 357689 | 20979 | 378668 | 2063 |
1567 | 1567 | 2022-11-30 | Alameda | 1 | 1643700 | 359744 | 357689 | 20937 | 378626 | 2063 |
1625 | 1625 | 2022-11-29 | Alameda | 1 | 1643700 | 359320 | 357689 | 20896 | 378585 | 2063 |
1683 | 1683 | 2022-11-28 | Alameda | 1 | 1643700 | 358874 | 356253 | 20867 | 377120 | 2059 |
1741 | 1741 | 2022-11-27 | Alameda | 1 | 1643700 | 358294 | 356253 | 20788 | 377041 | 2059 |
1799 | 1799 | 2022-11-26 | Alameda | 1 | 1643700 | 358024 | 356253 | 20763 | 377016 | 2059 |
1857 | 1857 | 2022-11-25 | Alameda | 1 | 1643700 | 357759 | 356253 | 20738 | 376991 | 2059 |
1915 | 1915 | 2022-11-24 | Alameda | 1 | 1643700 | 357450 | 356253 | 20717 | 376970 | 2059 |
1973 | 1973 | 2022-11-23 | Alameda | 1 | 1643700 | 357300 | 356253 | 20708 | 376961 | 2059 |
2031 | 2031 | 2022-11-22 | Alameda | 1 | 1643700 | 356931 | 356253 | 20666 | 376919 | 2059 |
2089 | 2089 | 2022-11-21 | Alameda | 1 | 1643700 | 356660 | 354457 | 20640 | 375097 | 2054 |
2147 | 2147 | 2022-11-20 | Alameda | 1 | 1643700 | 356315 | 354457 | 20605 | 375062 | 2054 |
2205 | 2205 | 2022-11-19 | Alameda | 1 | 1643700 | 356138 | 354457 | 20584 | 375041 | 2054 |
2263 | 2263 | 2022-11-18 | Alameda | 1 | 1643700 | 355955 | 354457 | 20567 | 375024 | 2054 |
2321 | 2321 | 2022-11-17 | Alameda | 1 | 1643700 | 355700 | 354457 | 20537 | 374994 | 2054 |
2379 | 2379 | 2022-11-16 | Alameda | 1 | 1643700 | 355470 | 354457 | 20514 | 374971 | 2054 |
2437 | 2437 | 2022-11-15 | Alameda | 1 | 1643700 | 355240 | 354457 | 20499 | 374956 | 2054 |
2495 | 2495 | 2022-11-14 | Alameda | 1 | 1643700 | 354967 | 352725 | 20469 | 373194 | 2050 |
2553 | 2553 | 2022-11-13 | Alameda | 1 | 1643700 | 354655 | 352725 | 20444 | 373169 | 2050 |
2611 | 2611 | 2022-11-12 | Alameda | 1 | 1643700 | 354509 | 352725 | 20429 | 373154 | 2050 |
2669 | 2669 | 2022-11-11 | Alameda | 1 | 1643700 | 354367 | 352725 | 20417 | 373142 | 2050 |
2727 | 2727 | 2022-11-10 | Alameda | 1 | 1643700 | 354183 | 352725 | 20405 | 373130 | 2050 |
2785 | 2785 | 2022-11-09 | Alameda | 1 | 1643700 | 353962 | 352725 | 20376 | 373101 | 2050 |
2843 | 2843 | 2022-11-08 | Alameda | 1 | 1643700 | 353758 | 352725 | 20349 | 373074 | 2050 |
2901 | 2901 | 2022-11-07 | Alameda | 1 | 1643700 | 353523 | 351524 | 20327 | 371851 | 2044 |
2959 | 2959 | 2022-11-06 | Alameda | 1 | 1643700 | 353297 | 351524 | 20308 | 371832 | 2044 |
3017 | 3017 | 2022-11-05 | Alameda | 1 | 1643700 | 353153 | 351524 | 20299 | 371823 | 2044 |
3075 | 3075 | 2022-11-04 | Alameda | 1 | 1643700 | 353011 | 351524 | 20282 | 371806 | 2044 |
3133 | 3133 | 2022-11-03 | Alameda | 1 | 1643700 | 352826 | 351524 | 20265 | 371789 | 2044 |
3191 | 3191 | 2022-11-02 | Alameda | 1 | 1643700 | 352646 | 351524 | 20248 | 371772 | 2044 |
3249 | 3249 | 2022-11-01 | Alameda | 1 | 1643700 | 352451 | 351524 | 20229 | 371753 | 2044 |
3307 | 3307 | 2022-10-31 | Alameda | 1 | 1643700 | 352232 | 350419 | 20206 | 370625 | 2040 |
3365 | 3365 | 2022-10-30 | Alameda | 1 | 1643700 | 352022 | 350419 | 20183 | 370602 | 2040 |
3423 | 3423 | 2022-10-29 | Alameda | 1 | 1643700 | 351913 | 350419 | 20173 | 370592 | 2040 |
3481 | 3481 | 2022-10-28 | Alameda | 1 | 1643700 | 351824 | 350419 | 20167 | 370586 | 2040 |
3539 | 3539 | 2022-10-27 | Alameda | 1 | 1643700 | 351692 | 350419 | 20152 | 370571 | 2040 |
3597 | 3597 | 2022-10-26 | Alameda | 1 | 1643700 | 351522 | 350419 | 20136 | 370555 | 2040 |
3655 | 3655 | 2022-10-25 | Alameda | 1 | 1643700 | 351372 | 350419 | 20117 | 370536 | 2040 |
3713 | 3713 | 2022-10-24 | Alameda | 1 | 1643700 | 351214 | 349337 | 20107 | 369444 | 2031 |
3771 | 3771 | 2022-10-23 | Alameda | 1 | 1643700 | 351022 | 349337 | 20088 | 369425 | 2031 |
3829 | 3829 | 2022-10-22 | Alameda | 1 | 1643700 | 350922 | 349337 | 20082 | 369419 | 2031 |
3887 | 3887 | 2022-10-21 | Alameda | 1 | 1643700 | 350842 | 349337 | 20075 | 369412 | 2031 |
3945 | 3945 | 2022-10-20 | Alameda | 1 | 1643700 | 350706 | 349337 | 20070 | 369407 | 2031 |
4003 | 4003 | 2022-10-19 | Alameda | 1 | 1643700 | 350570 | 349337 | 20059 | 369396 | 2031 |
4061 | 4061 | 2022-10-18 | Alameda | 1 | 1643700 | 350446 | 349337 | 20045 | 369382 | 2031 |
4119 | 4119 | 2022-10-17 | Alameda | 1 | 1643700 | 350296 | 348487 | 20038 | 368525 | 2027 |
4177 | 4177 | 2022-10-16 | Alameda | 1 | 1643700 | 350133 | 348487 | 20019 | 368506 | 2027 |
4235 | 4235 | 2022-10-15 | Alameda | 1 | 1643700 | 350036 | 348487 | 20006 | 368493 | 2027 |
4293 | 4293 | 2022-10-14 | Alameda | 1 | 1643700 | 349962 | 348487 | 19994 | 368481 | 2027 |
4351 | 4351 | 2022-10-13 | Alameda | 1 | 1643700 | 349824 | 348487 | 19977 | 368464 | 2027 |
4409 | 4409 | 2022-10-12 | Alameda | 1 | 1643700 | 349702 | 348487 | 19961 | 368448 | 2027 |
4467 | 4467 | 2022-10-11 | Alameda | 1 | 1643700 | 349539 | 348487 | 19952 | 368439 | 2027 |
4525 | 4525 | 2022-10-10 | Alameda | 1 | 1643700 | 349391 | 347497 | 19941 | 367438 | 2023 |
4583 | 4583 | 2022-10-09 | Alameda | 1 | 1643700 | 349239 | 347497 | 19919 | 367416 | 2023 |
4641 | 4641 | 2022-10-08 | Alameda | 1 | 1643700 | 349152 | 347497 | 19912 | 367409 | 2023 |
4699 | 4699 | 2022-10-07 | Alameda | 1 | 1643700 | 349034 | 347497 | 19909 | 367406 | 2023 |
4757 | 4757 | 2022-10-06 | Alameda | 1 | 1643700 | 348896 | 347497 | 19897 | 367394 | 2023 |
4815 | 4815 | 2022-10-05 | Alameda | 1 | 1643700 | 348739 | 347497 | 19887 | 367384 | 2023 |
4873 | 4873 | 2022-10-04 | Alameda | 1 | 1643700 | 348600 | 347497 | 19871 | 367368 | 2023 |
4931 | 4931 | 2022-10-03 | Alameda | 1 | 1643700 | 348418 | 346369 | 19862 | 366231 | 2020 |
4989 | 4989 | 2022-10-02 | Alameda | 1 | 1643700 | 348215 | 346369 | 19848 | 366217 | 2020 |
5047 | 5047 | 2022-10-01 | Alameda | 1 | 1643700 | 348100 | 346369 | 19845 | 366214 | 2020 |
5105 | 5105 | 2022-09-30 | Alameda | 1 | 1643700 | 347985 | 346369 | 19838 | 366207 | 2020 |
5163 | 5163 | 2022-09-29 | Alameda | 1 | 1643700 | 347822 | 346369 | 19822 | 366191 | 2020 |
5221 | 5221 | 2022-09-28 | Alameda | 1 | 1643700 | 347661 | 346369 | 19806 | 366175 | 2020 |
5279 | 5279 | 2022-09-27 | Alameda | 1 | 1643700 | 347494 | 346369 | 19792 | 366161 | 2020 |
5337 | 5337 | 2022-09-26 | Alameda | 1 | 1643700 | 347304 | 345351 | 19787 | 365138 | 2012 |
5395 | 5395 | 2022-09-25 | Alameda | 1 | 1643700 | 347089 | 345351 | 19766 | 365117 | 2012 |
5453 | 5453 | 2022-09-24 | Alameda | 1 | 1643700 | 346977 | 345351 | 19759 | 365110 | 2012 |
5511 | 5511 | 2022-09-23 | Alameda | 1 | 1643700 | 346837 | 345351 | 19747 | 365098 | 2012 |
5569 | 5569 | 2022-09-22 | Alameda | 1 | 1643700 | 346669 | 345351 | 19741 | 365092 | 2012 |
5627 | 5627 | 2022-09-21 | Alameda | 1 | 1643700 | 346503 | 345351 | 19726 | 365077 | 2012 |
5685 | 5685 | 2022-09-20 | Alameda | 1 | 1643700 | 346350 | 345351 | 19710 | 365061 | 2012 |
5743 | 5743 | 2022-09-19 | Alameda | 1 | 1643700 | 346182 | 344045 | 19693 | 363738 | 2007 |
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 );