latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
586 rows where county = "Orange" sorted by new_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths ▼ |
---|---|---|---|---|---|---|---|---|
262 | 262 | 2021-08-29 | Orange | 59 | 283573 | 5202 | 0 | 0 |
320 | 320 | 2021-08-28 | Orange | 59 | 283573 | 5202 | 0 | 0 |
668 | 668 | 2021-08-22 | Orange | 59 | 279237 | 5176 | 0 | 0 |
726 | 726 | 2021-08-21 | Orange | 59 | 279237 | 5176 | 0 | 0 |
1074 | 1074 | 2021-08-15 | Orange | 59 | 273847 | 5156 | 0 | 0 |
1132 | 1132 | 2021-08-14 | Orange | 59 | 273847 | 5156 | 0 | 0 |
1306 | 1306 | 2021-08-11 | Orange | 59 | 272449 | 5152 | 612 | 0 |
1480 | 1480 | 2021-08-08 | Orange | 59 | 269016 | 5148 | 0 | 0 |
1538 | 1538 | 2021-08-07 | Orange | 59 | 269016 | 5148 | 0 | 0 |
1712 | 1712 | 2021-08-04 | Orange | 59 | 267131 | 5143 | 92 | 0 |
1770 | 1770 | 2021-08-03 | Orange | 59 | 267039 | 5143 | 872 | 0 |
1886 | 1886 | 2021-08-01 | Orange | 59 | 264171 | 5141 | 0 | 0 |
1944 | 1944 | 2021-07-31 | Orange | 59 | 264171 | 5141 | 0 | 0 |
2002 | 2002 | 2021-07-30 | Orange | 59 | 264171 | 5141 | 593 | 0 |
2118 | 2118 | 2021-07-28 | Orange | 59 | 263056 | 5140 | 532 | 0 |
2292 | 2292 | 2021-07-25 | Orange | 59 | 260720 | 5138 | 0 | 0 |
2350 | 2350 | 2021-07-24 | Orange | 59 | 260720 | 5138 | 0 | 0 |
2408 | 2408 | 2021-07-23 | Orange | 59 | 260720 | 5138 | 431 | 0 |
2524 | 2524 | 2021-07-21 | Orange | 59 | 259985 | 5136 | 290 | 0 |
2698 | 2698 | 2021-07-18 | Orange | 59 | 257826 | 5133 | 0 | 0 |
2756 | 2756 | 2021-07-17 | Orange | 59 | 257826 | 5133 | 0 | 0 |
2814 | 2814 | 2021-07-16 | Orange | 59 | 257826 | 5133 | 0 | 0 |
2872 | 2872 | 2021-07-15 | Orange | 59 | 257826 | 5133 | 0 | 0 |
2930 | 2930 | 2021-07-14 | Orange | 59 | 257826 | 5133 | 0 | 0 |
3046 | 3046 | 2021-07-12 | Orange | 59 | 256776 | 5124 | 0 | 0 |
3104 | 3104 | 2021-07-11 | Orange | 59 | 256776 | 5124 | 0 | 0 |
3162 | 3162 | 2021-07-10 | Orange | 59 | 256776 | 5124 | 0 | 0 |
3220 | 3220 | 2021-07-09 | Orange | 59 | 256776 | 5124 | 0 | 0 |
3278 | 3278 | 2021-07-08 | Orange | 59 | 256776 | 5124 | 0 | 0 |
3336 | 3336 | 2021-07-07 | Orange | 59 | 256776 | 5124 | 0 | 0 |
3452 | 3452 | 2021-07-05 | Orange | 59 | 256445 | 5123 | 0 | 0 |
3510 | 3510 | 2021-07-04 | Orange | 59 | 256445 | 5123 | 0 | 0 |
3568 | 3568 | 2021-07-03 | Orange | 59 | 256445 | 5123 | 0 | 0 |
3916 | 3916 | 2021-06-27 | Orange | 59 | 256052 | 5114 | 0 | 0 |
3974 | 3974 | 2021-06-26 | Orange | 59 | 256052 | 5114 | 0 | 0 |
4322 | 4322 | 2021-06-20 | Orange | 59 | 255810 | 5103 | 0 | 0 |
4380 | 4380 | 2021-06-19 | Orange | 59 | 255810 | 5103 | 0 | 0 |
4728 | 4728 | 2021-06-13 | Orange | 59 | 255588 | 5095 | 0 | 0 |
4786 | 4786 | 2021-06-12 | Orange | 59 | 255588 | 5095 | 0 | 0 |
5076 | 5076 | 2021-06-07 | Orange | 59 | 255473 | 5083 | 19 | 0 |
5424 | 5424 | 2021-06-01 | Orange | 59 | 255291 | 5065 | 50 | 0 |
5482 | 5482 | 2021-05-31 | Orange | 59 | 255241 | 5065 | 0 | 0 |
6236 | 6236 | 2021-05-18 | Orange | 59 | 254831 | 5031 | 48 | 0 |
6294 | 6294 | 2021-05-17 | Orange | 59 | 254783 | 5031 | 39 | 0 |
6700 | 6700 | 2021-05-10 | Orange | 59 | 254357 | 5008 | 46 | 0 |
7106 | 7106 | 2021-05-03 | Orange | 59 | 254044 | 4969 | 55 | 0 |
7512 | 7512 | 2021-04-26 | Orange | 59 | 253574 | 4933 | 80 | 0 |
7918 | 7918 | 2021-04-19 | Orange | 59 | 253026 | 4896 | 63 | 0 |
8324 | 8324 | 2021-04-12 | Orange | 59 | 252436 | 4839 | 120 | 0 |
8788 | 8788 | 2021-04-04 | Orange | 59 | 251102 | 4768 | 0 | 0 |
9890 | 9890 | 2021-03-16 | Orange | 59 | 248904 | 4486 | 23 | 0 |
11050 | 11050 | 2021-02-24 | Orange | 59 | 245460 | 3848 | 325 | 0 |
11108 | 11108 | 2021-02-23 | Orange | 59 | 245135 | 3848 | 250 | 0 |
11572 | 11572 | 2021-02-15 | Orange | 59 | 242505 | 3577 | 0 | 0 |
11746 | 11746 | 2021-02-12 | Orange | 59 | 240999 | 3493 | 0 | 0 |
13196 | 13196 | 2021-01-18 | Orange | 59 | 210813 | 2367 | 0 | 0 |
13950 | 13950 | 2021-01-05 | Orange | 59 | 171955 | 1926 | 1376 | 0 |
14066 | 14066 | 2021-01-03 | Orange | 59 | 161589 | 1901 | 0 | 0 |
14182 | 14182 | 2021-01-01 | Orange | 59 | 157183 | 1875 | 0 | 0 |
14414 | 14414 | 2020-12-28 | Orange | 59 | 149607 | 1846 | 2144 | 0 |
14588 | 14588 | 2020-12-25 | Orange | 59 | 138310 | 1782 | 0 | 0 |
15226 | 15226 | 2020-12-14 | Orange | 59 | 105764 | 1694 | 3250 | 0 |
15516 | 15516 | 2020-12-09 | Orange | 59 | 93126 | 1633 | 2613 | 0 |
15574 | 15574 | 2020-12-08 | Orange | 59 | 90513 | 1633 | 1671 | 0 |
15632 | 15632 | 2020-12-07 | Orange | 59 | 88842 | 1633 | 1964 | 0 |
15980 | 15980 | 2020-12-01 | Orange | 59 | 79343 | 1577 | 790 | 0 |
16038 | 16038 | 2020-11-30 | Orange | 59 | 78553 | 1577 | 734 | 0 |
16096 | 16096 | 2020-11-29 | Orange | 59 | 77819 | 1577 | 1058 | 0 |
16154 | 16154 | 2020-11-28 | Orange | 59 | 76761 | 1577 | 1666 | 0 |
16270 | 16270 | 2020-11-26 | Orange | 59 | 73152 | 1559 | 0 | 0 |
16444 | 16444 | 2020-11-23 | Orange | 59 | 71116 | 1554 | 1422 | 0 |
16792 | 16792 | 2020-11-17 | Orange | 59 | 65957 | 1526 | 352 | 0 |
16850 | 16850 | 2020-11-16 | Orange | 59 | 65605 | 1526 | 380 | 0 |
17256 | 17256 | 2020-11-09 | Orange | 59 | 62563 | 1509 | 308 | 0 |
17662 | 17662 | 2020-11-02 | Orange | 59 | 60298 | 1483 | 183 | 0 |
17720 | 17720 | 2020-11-01 | Orange | 59 | 60115 | 1483 | 233 | 0 |
18068 | 18068 | 2020-10-26 | Orange | 59 | 58725 | 1447 | 152 | 0 |
18532 | 18532 | 2020-10-18 | Orange | 59 | 56868 | 1409 | 196 | 0 |
18822 | 18822 | 2020-10-13 | Orange | 59 | 56070 | 1341 | 178 | 0 |
18880 | 18880 | 2020-10-12 | Orange | 59 | 55892 | 1341 | 117 | 0 |
19344 | 19344 | 2020-10-04 | Orange | 59 | 54640 | 1286 | 283 | 0 |
19692 | 19692 | 2020-09-28 | Orange | 59 | 53448 | 1216 | 133 | 0 |
20098 | 20098 | 2020-09-21 | Orange | 59 | 52201 | 1128 | 138 | 0 |
20504 | 20504 | 2020-09-14 | Orange | 59 | 50974 | 1093 | 44 | 0 |
20562 | 20562 | 2020-09-13 | Orange | 59 | 50930 | 1093 | 170 | 0 |
20910 | 20910 | 2020-09-07 | Orange | 59 | 49845 | 1053 | 113 | 0 |
21026 | 21026 | 2020-09-05 | Orange | 59 | 49258 | 1042 | 0 | 0 |
21722 | 21722 | 2020-08-24 | Orange | 59 | 46307 | 897 | 353 | 0 |
22128 | 22128 | 2020-08-17 | Orange | 59 | 43925 | 810 | 216 | 0 |
22534 | 22534 | 2020-08-10 | Orange | 59 | 40527 | 724 | 886 | 0 |
22940 | 22940 | 2020-08-03 | Orange | 59 | 37831 | 651 | 440 | 0 |
23810 | 23810 | 2020-07-19 | Orange | 59 | 29426 | 492 | 415 | 0 |
24564 | 24564 | 2020-07-06 | Orange | 59 | 17882 | 366 | 1028 | 0 |
25086 | 25086 | 2020-06-27 | Orange | 59 | 12462 | 323 | 502 | 0 |
25376 | 25376 | 2020-06-22 | Orange | 59 | 10595 | 269 | 173 | 0 |
25782 | 25782 | 2020-06-15 | Orange | 59 | 8759 | 221 | 186 | 0 |
26188 | 26188 | 2020-06-08 | Orange | 59 | 7527 | 177 | 87 | 0 |
26594 | 26594 | 2020-06-01 | Orange | 59 | 6474 | 147 | 213 | 0 |
26942 | 26942 | 2020-05-26 | Orange | 59 | 5578 | 131 | 109 | 0 |
27000 | 27000 | 2020-05-25 | Orange | 59 | 5469 | 131 | 133 | 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 );