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

586 rows where fips = 59 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 59 · 586 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
30 30 2021-09-02 Orange 59 286536 5236 437 7
88 88 2021-09-01 Orange 59 286099 5229 646 4
146 146 2021-08-31 Orange 59 285453 5225 355 5
204 204 2021-08-30 Orange 59 285098 5220 1525 18
262 262 2021-08-29 Orange 59 283573 5202 0 0
320 320 2021-08-28 Orange 59 283573 5202 0 0
378 378 2021-08-27 Orange 59 283573 5202 930 5
436 436 2021-08-26 Orange 59 282643 5197 477 7
494 494 2021-08-25 Orange 59 282166 5190 557 6
552 552 2021-08-24 Orange 59 281609 5184 517 6
610 610 2021-08-23 Orange 59 281092 5178 1855 2
668 668 2021-08-22 Orange 59 279237 5176 0 0
726 726 2021-08-21 Orange 59 279237 5176 0 0
784 784 2021-08-20 Orange 59 279237 5176 820 7
842 842 2021-08-19 Orange 59 278417 5169 572 4
900 900 2021-08-18 Orange 59 277845 5165 1213 4
958 958 2021-08-17 Orange 59 276632 5161 668 3
1016 1016 2021-08-16 Orange 59 275964 5158 2117 2
1074 1074 2021-08-15 Orange 59 273847 5156 0 0
1132 1132 2021-08-14 Orange 59 273847 5156 0 0
1190 1190 2021-08-13 Orange 59 273847 5156 933 2
1248 1248 2021-08-12 Orange 59 272914 5154 465 2
1306 1306 2021-08-11 Orange 59 272449 5152 612 0
1364 1364 2021-08-10 Orange 59 271837 5152 640 2
1422 1422 2021-08-09 Orange 59 271197 5150 2181 2
1480 1480 2021-08-08 Orange 59 269016 5148 0 0
1538 1538 2021-08-07 Orange 59 269016 5148 0 0
1596 1596 2021-08-06 Orange 59 269016 5148 1108 2
1654 1654 2021-08-05 Orange 59 267908 5146 777 3
1712 1712 2021-08-04 Orange 59 267131 5143 92 0
1770 1770 2021-08-03 Orange 59 267039 5143 872 0
1828 1828 2021-08-02 Orange 59 266167 5143 1996 2
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
2060 2060 2021-07-29 Orange 59 263578 5141 522 1
2118 2118 2021-07-28 Orange 59 263056 5140 532 0
2176 2176 2021-07-27 Orange 59 262524 5140 453 1
2234 2234 2021-07-26 Orange 59 262071 5139 1351 1
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
2466 2466 2021-07-22 Orange 59 260289 5138 304 2
2524 2524 2021-07-21 Orange 59 259985 5136 290 0
2582 2582 2021-07-20 Orange 59 259695 5136 315 1
2640 2640 2021-07-19 Orange 59 259380 5135 1554 2
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
2988 2988 2021-07-13 Orange 59 257826 5133 1050 9
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
3394 3394 2021-07-06 Orange 59 256776 5124 331 1
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
3626 3626 2021-07-02 Orange 59 256445 5123 74 1
3684 3684 2021-07-01 Orange 59 256371 5122 54 1
3742 3742 2021-06-30 Orange 59 256317 5121 51 1
3800 3800 2021-06-29 Orange 59 256266 5120 44 2
3858 3858 2021-06-28 Orange 59 256222 5118 170 4
3916 3916 2021-06-27 Orange 59 256052 5114 0 0
3974 3974 2021-06-26 Orange 59 256052 5114 0 0
4032 4032 2021-06-25 Orange 59 256052 5114 44 2
4090 4090 2021-06-24 Orange 59 256008 5112 31 1
4148 4148 2021-06-23 Orange 59 255977 5111 19 2
4206 4206 2021-06-22 Orange 59 255958 5109 36 2
4264 4264 2021-06-21 Orange 59 255922 5107 112 4
4322 4322 2021-06-20 Orange 59 255810 5103 0 0
4380 4380 2021-06-19 Orange 59 255810 5103 0 0
4438 4438 2021-06-18 Orange 59 255810 5103 39 1
4496 4496 2021-06-17 Orange 59 255771 5102 43 1
4554 4554 2021-06-16 Orange 59 255728 5101 33 2
4612 4612 2021-06-15 Orange 59 255695 5099 32 2
4670 4670 2021-06-14 Orange 59 255663 5097 75 2
4728 4728 2021-06-13 Orange 59 255588 5095 0 0
4786 4786 2021-06-12 Orange 59 255588 5095 0 0
4844 4844 2021-06-11 Orange 59 255588 5095 18 3
4902 4902 2021-06-10 Orange 59 255570 5092 40 2
4960 4960 2021-06-09 Orange 59 255530 5090 26 2
5018 5018 2021-06-08 Orange 59 255504 5088 31 5
5076 5076 2021-06-07 Orange 59 255473 5083 19 0
5134 5134 2021-06-06 Orange 59 255454 5083 41 5
5192 5192 2021-06-05 Orange 59 255413 5078 42 5
5250 5250 2021-06-04 Orange 59 255371 5073 24 3
5308 5308 2021-06-03 Orange 59 255347 5070 25 2
5366 5366 2021-06-02 Orange 59 255322 5068 31 3
5424 5424 2021-06-01 Orange 59 255291 5065 50 0
5482 5482 2021-05-31 Orange 59 255241 5065 0 0
5540 5540 2021-05-30 Orange 59 255241 5065 21 2
5598 5598 2021-05-29 Orange 59 255220 5063 56 4
5656 5656 2021-05-28 Orange 59 255164 5059 55 3
5714 5714 2021-05-27 Orange 59 255109 5056 28 1
5772 5772 2021-05-26 Orange 59 255081 5055 11 1

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