latimes-county-totals
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 confirmed coronavirus case at that time.
- deaths
- The cumulative number of deaths at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- new_deaths
- The net change in deaths over the previous date.
31,362 rows sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | fips ▲ | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5858 | 5858 | 2021-05-25 | Yuba | 115 | 6344 | 41 | 4 | 0 |
5916 | 5916 | 2021-05-24 | Yuba | 115 | 6340 | 41 | 17 | 0 |
5974 | 5974 | 2021-05-23 | Yuba | 115 | 6323 | 41 | 0 | 0 |
6032 | 6032 | 2021-05-22 | Yuba | 115 | 6323 | 41 | 0 | 0 |
6090 | 6090 | 2021-05-21 | Yuba | 115 | 6323 | 41 | 7 | 0 |
6148 | 6148 | 2021-05-20 | Yuba | 115 | 6316 | 41 | 7 | 0 |
6206 | 6206 | 2021-05-19 | Yuba | 115 | 6309 | 41 | 9 | 0 |
6264 | 6264 | 2021-05-18 | Yuba | 115 | 6300 | 41 | 8 | 0 |
6322 | 6322 | 2021-05-17 | Yuba | 115 | 6292 | 41 | 7 | 0 |
6380 | 6380 | 2021-05-16 | Yuba | 115 | 6285 | 41 | 0 | 0 |
6438 | 6438 | 2021-05-15 | Yuba | 115 | 6285 | 41 | 0 | 0 |
6496 | 6496 | 2021-05-14 | Yuba | 115 | 6285 | 41 | 8 | 0 |
6554 | 6554 | 2021-05-13 | Yuba | 115 | 6277 | 41 | 9 | 0 |
6612 | 6612 | 2021-05-12 | Yuba | 115 | 6268 | 41 | 6 | 0 |
6670 | 6670 | 2021-05-11 | Yuba | 115 | 6262 | 41 | 9 | 0 |
6728 | 6728 | 2021-05-10 | Yuba | 115 | 6253 | 41 | 32 | 0 |
6786 | 6786 | 2021-05-09 | Yuba | 115 | 6221 | 41 | 0 | 0 |
6844 | 6844 | 2021-05-08 | Yuba | 115 | 6221 | 41 | 0 | 0 |
6902 | 6902 | 2021-05-07 | Yuba | 115 | 6221 | 41 | 4 | 0 |
6960 | 6960 | 2021-05-06 | Yuba | 115 | 6217 | 41 | 4 | 0 |
7018 | 7018 | 2021-05-05 | Yuba | 115 | 6213 | 41 | 4 | 1 |
7076 | 7076 | 2021-05-04 | Yuba | 115 | 6209 | 40 | 6 | 0 |
7134 | 7134 | 2021-05-03 | Yuba | 115 | 6203 | 40 | 18 | 0 |
7192 | 7192 | 2021-05-02 | Yuba | 115 | 6185 | 40 | 0 | 0 |
7250 | 7250 | 2021-05-01 | Yuba | 115 | 6185 | 40 | 0 | 0 |
7308 | 7308 | 2021-04-30 | Yuba | 115 | 6185 | 40 | 5 | 0 |
7366 | 7366 | 2021-04-29 | Yuba | 115 | 6180 | 40 | 8 | 0 |
7424 | 7424 | 2021-04-28 | Yuba | 115 | 6172 | 40 | 7 | 0 |
7482 | 7482 | 2021-04-27 | Yuba | 115 | 6165 | 40 | 0 | 0 |
7540 | 7540 | 2021-04-26 | Yuba | 115 | 6165 | 40 | 23 | 0 |
7598 | 7598 | 2021-04-25 | Yuba | 115 | 6142 | 40 | 0 | 0 |
7656 | 7656 | 2021-04-24 | Yuba | 115 | 6142 | 40 | 0 | 0 |
7714 | 7714 | 2021-04-23 | Yuba | 115 | 6142 | 40 | 4 | 0 |
7772 | 7772 | 2021-04-22 | Yuba | 115 | 6138 | 40 | 2 | 0 |
7830 | 7830 | 2021-04-21 | Yuba | 115 | 6136 | 40 | 9 | 0 |
7888 | 7888 | 2021-04-20 | Yuba | 115 | 6127 | 40 | 17 | 0 |
7946 | 7946 | 2021-04-19 | Yuba | 115 | 6110 | 40 | 12 | 0 |
8004 | 8004 | 2021-04-18 | Yuba | 115 | 6098 | 40 | 0 | 0 |
8062 | 8062 | 2021-04-17 | Yuba | 115 | 6098 | 40 | 0 | 0 |
8120 | 8120 | 2021-04-16 | Yuba | 115 | 6098 | 40 | 5 | 0 |
8178 | 8178 | 2021-04-15 | Yuba | 115 | 6093 | 40 | 9 | 0 |
8236 | 8236 | 2021-04-14 | Yuba | 115 | 6084 | 40 | 1 | 0 |
8294 | 8294 | 2021-04-13 | Yuba | 115 | 6083 | 40 | 10 | 0 |
8352 | 8352 | 2021-04-12 | Yuba | 115 | 6073 | 40 | 9 | 0 |
8410 | 8410 | 2021-04-11 | Yuba | 115 | 6064 | 40 | 0 | 0 |
8468 | 8468 | 2021-04-10 | Yuba | 115 | 6064 | 40 | 0 | 0 |
8526 | 8526 | 2021-04-09 | Yuba | 115 | 6064 | 40 | 3 | 0 |
8584 | 8584 | 2021-04-08 | Yuba | 115 | 6061 | 40 | 10 | 0 |
8642 | 8642 | 2021-04-07 | Yuba | 115 | 6051 | 40 | 5 | 0 |
8700 | 8700 | 2021-04-06 | Yuba | 115 | 6046 | 40 | 5 | 0 |
8758 | 8758 | 2021-04-05 | Yuba | 115 | 6041 | 40 | 20 | 0 |
8816 | 8816 | 2021-04-04 | Yuba | 115 | 6021 | 40 | 0 | 0 |
8874 | 8874 | 2021-04-03 | Yuba | 115 | 6021 | 40 | 0 | 0 |
8932 | 8932 | 2021-04-02 | Yuba | 115 | 6021 | 40 | 16 | 0 |
8990 | 8990 | 2021-04-01 | Yuba | 115 | 6005 | 40 | 6 | 0 |
9048 | 9048 | 2021-03-31 | Yuba | 115 | 5999 | 40 | 16 | 0 |
9106 | 9106 | 2021-03-30 | Yuba | 115 | 5983 | 40 | 2 | 0 |
9164 | 9164 | 2021-03-29 | Yuba | 115 | 5981 | 40 | 28 | 0 |
9222 | 9222 | 2021-03-28 | Yuba | 115 | 5953 | 40 | 0 | 0 |
9280 | 9280 | 2021-03-27 | Yuba | 115 | 5953 | 40 | 0 | 0 |
9338 | 9338 | 2021-03-26 | Yuba | 115 | 5953 | 40 | 14 | 0 |
9396 | 9396 | 2021-03-25 | Yuba | 115 | 5939 | 40 | 13 | 0 |
9454 | 9454 | 2021-03-24 | Yuba | 115 | 5926 | 40 | 11 | 0 |
9512 | 9512 | 2021-03-23 | Yuba | 115 | 5915 | 40 | 3 | 0 |
9570 | 9570 | 2021-03-22 | Yuba | 115 | 5912 | 40 | 9 | 0 |
9628 | 9628 | 2021-03-21 | Yuba | 115 | 5903 | 40 | 0 | 0 |
9686 | 9686 | 2021-03-20 | Yuba | 115 | 5903 | 40 | 0 | 0 |
9744 | 9744 | 2021-03-19 | Yuba | 115 | 5903 | 40 | 3 | 0 |
9802 | 9802 | 2021-03-18 | Yuba | 115 | 5900 | 40 | 8 | 0 |
9860 | 9860 | 2021-03-17 | Yuba | 115 | 5892 | 40 | 4 | 0 |
9918 | 9918 | 2021-03-16 | Yuba | 115 | 5888 | 40 | 14 | 0 |
9976 | 9976 | 2021-03-15 | Yuba | 115 | 5874 | 40 | 20 | 0 |
10034 | 10034 | 2021-03-14 | Yuba | 115 | 5854 | 40 | 0 | 0 |
10092 | 10092 | 2021-03-13 | Yuba | 115 | 5854 | 40 | 0 | 0 |
10150 | 10150 | 2021-03-12 | Yuba | 115 | 5854 | 40 | 6 | 0 |
10208 | 10208 | 2021-03-11 | Yuba | 115 | 5848 | 40 | 8 | 1 |
10266 | 10266 | 2021-03-10 | Yuba | 115 | 5840 | 39 | 2 | 0 |
10324 | 10324 | 2021-03-09 | Yuba | 115 | 5838 | 39 | 7 | 0 |
10382 | 10382 | 2021-03-08 | Yuba | 115 | 5831 | 39 | 36 | 0 |
10440 | 10440 | 2021-03-07 | Yuba | 115 | 5795 | 39 | 0 | 0 |
10498 | 10498 | 2021-03-06 | Yuba | 115 | 5795 | 39 | 0 | 0 |
10556 | 10556 | 2021-03-05 | Yuba | 115 | 5795 | 39 | 9 | 0 |
10614 | 10614 | 2021-03-04 | Yuba | 115 | 5786 | 39 | 10 | 1 |
10672 | 10672 | 2021-03-03 | Yuba | 115 | 5776 | 38 | 5 | 1 |
10730 | 10730 | 2021-03-02 | Yuba | 115 | 5771 | 37 | 7 | 0 |
10788 | 10788 | 2021-03-01 | Yuba | 115 | 5764 | 37 | 14 | 0 |
10846 | 10846 | 2021-02-28 | Yuba | 115 | 5750 | 37 | 0 | 0 |
10904 | 10904 | 2021-02-27 | Yuba | 115 | 5750 | 37 | 0 | 0 |
10962 | 10962 | 2021-02-26 | Yuba | 115 | 5750 | 37 | 17 | 1 |
11020 | 11020 | 2021-02-25 | Yuba | 115 | 5733 | 36 | 11 | 0 |
11078 | 11078 | 2021-02-24 | Yuba | 115 | 5722 | 36 | 3 | 0 |
11136 | 11136 | 2021-02-23 | Yuba | 115 | 5719 | 36 | 8 | 0 |
11194 | 11194 | 2021-02-22 | Yuba | 115 | 5711 | 36 | 30 | 0 |
11252 | 11252 | 2021-02-21 | Yuba | 115 | 5681 | 36 | 0 | 0 |
11310 | 11310 | 2021-02-20 | Yuba | 115 | 5681 | 36 | 0 | 0 |
11368 | 11368 | 2021-02-19 | Yuba | 115 | 5681 | 36 | 20 | 0 |
11426 | 11426 | 2021-02-18 | Yuba | 115 | 5661 | 36 | 12 | 0 |
11484 | 11484 | 2021-02-17 | Yuba | 115 | 5649 | 36 | 15 | 0 |
11542 | 11542 | 2021-02-16 | Yuba | 115 | 5634 | 36 | 51 | 0 |
11600 | 11600 | 2021-02-15 | Yuba | 115 | 5583 | 36 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );