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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5830 | 5830 | 2021-05-25 | Orange | 59 | 255070 | 5054 | 22 | 2 |
5888 | 5888 | 2021-05-24 | Orange | 59 | 255048 | 5052 | 26 | 3 |
5946 | 5946 | 2021-05-23 | Orange | 59 | 255022 | 5049 | 47 | 2 |
6004 | 6004 | 2021-05-22 | Orange | 59 | 254975 | 5047 | 29 | 5 |
6062 | 6062 | 2021-05-21 | Orange | 59 | 254946 | 5042 | 27 | 4 |
6120 | 6120 | 2021-05-20 | Orange | 59 | 254919 | 5038 | 37 | 4 |
6178 | 6178 | 2021-05-19 | Orange | 59 | 254882 | 5034 | 51 | 3 |
6236 | 6236 | 2021-05-18 | Orange | 59 | 254831 | 5031 | 48 | 0 |
6294 | 6294 | 2021-05-17 | Orange | 59 | 254783 | 5031 | 39 | 0 |
6352 | 6352 | 2021-05-16 | Orange | 59 | 254744 | 5031 | 52 | 1 |
6410 | 6410 | 2021-05-15 | Orange | 59 | 254692 | 5030 | 55 | 2 |
6468 | 6468 | 2021-05-14 | Orange | 59 | 254637 | 5028 | 145 | 2 |
6526 | 6526 | 2021-05-13 | Orange | 59 | 254492 | 5026 | 35 | 3 |
6584 | 6584 | 2021-05-12 | Orange | 59 | 254457 | 5023 | 42 | 6 |
6642 | 6642 | 2021-05-11 | Orange | 59 | 254415 | 5017 | 58 | 9 |
6700 | 6700 | 2021-05-10 | Orange | 59 | 254357 | 5008 | 46 | 0 |
6758 | 6758 | 2021-05-09 | Orange | 59 | 254311 | 5008 | 33 | 3 |
6816 | 6816 | 2021-05-08 | Orange | 59 | 254278 | 5005 | 47 | 5 |
6874 | 6874 | 2021-05-07 | Orange | 59 | 254231 | 5000 | 30 | 8 |
6932 | 6932 | 2021-05-06 | Orange | 59 | 254201 | 4992 | 38 | 13 |
6990 | 6990 | 2021-05-05 | Orange | 59 | 254163 | 4979 | 47 | 1 |
7048 | 7048 | 2021-05-04 | Orange | 59 | 254116 | 4978 | 72 | 9 |
7106 | 7106 | 2021-05-03 | Orange | 59 | 254044 | 4969 | 55 | 0 |
7164 | 7164 | 2021-05-02 | Orange | 59 | 253989 | 4969 | 75 | 4 |
7222 | 7222 | 2021-05-01 | Orange | 59 | 253914 | 4965 | 66 | 8 |
7280 | 7280 | 2021-04-30 | Orange | 59 | 253848 | 4957 | 68 | 9 |
7338 | 7338 | 2021-04-29 | Orange | 59 | 253780 | 4948 | 43 | 4 |
7396 | 7396 | 2021-04-28 | Orange | 59 | 253737 | 4944 | 73 | 5 |
7454 | 7454 | 2021-04-27 | Orange | 59 | 253664 | 4939 | 90 | 6 |
7512 | 7512 | 2021-04-26 | Orange | 59 | 253574 | 4933 | 80 | 0 |
7570 | 7570 | 2021-04-25 | Orange | 59 | 253494 | 4933 | 69 | 9 |
7628 | 7628 | 2021-04-24 | Orange | 59 | 253425 | 4924 | 85 | 6 |
7686 | 7686 | 2021-04-23 | Orange | 59 | 253340 | 4918 | 65 | 8 |
7744 | 7744 | 2021-04-22 | Orange | 59 | 253275 | 4910 | 69 | 8 |
7802 | 7802 | 2021-04-21 | Orange | 59 | 253206 | 4902 | 53 | 2 |
7860 | 7860 | 2021-04-20 | Orange | 59 | 253153 | 4900 | 127 | 4 |
7918 | 7918 | 2021-04-19 | Orange | 59 | 253026 | 4896 | 63 | 0 |
7976 | 7976 | 2021-04-18 | Orange | 59 | 252963 | 4896 | 79 | 5 |
8034 | 8034 | 2021-04-17 | Orange | 59 | 252884 | 4891 | 80 | 5 |
8092 | 8092 | 2021-04-16 | Orange | 59 | 252804 | 4886 | 112 | 17 |
8150 | 8150 | 2021-04-15 | Orange | 59 | 252692 | 4869 | 65 | 7 |
8208 | 8208 | 2021-04-14 | Orange | 59 | 252627 | 4862 | 89 | 13 |
8266 | 8266 | 2021-04-13 | Orange | 59 | 252538 | 4849 | 102 | 10 |
8324 | 8324 | 2021-04-12 | Orange | 59 | 252436 | 4839 | 120 | 0 |
8382 | 8382 | 2021-04-11 | Orange | 59 | 252316 | 4839 | 196 | 8 |
8440 | 8440 | 2021-04-10 | Orange | 59 | 252120 | 4831 | 422 | 5 |
8498 | 8498 | 2021-04-09 | Orange | 59 | 251698 | 4826 | 87 | 16 |
8556 | 8556 | 2021-04-08 | Orange | 59 | 251611 | 4810 | 95 | 19 |
8614 | 8614 | 2021-04-07 | Orange | 59 | 251516 | 4791 | 75 | 7 |
8672 | 8672 | 2021-04-06 | Orange | 59 | 251441 | 4784 | 131 | 12 |
8730 | 8730 | 2021-04-05 | Orange | 59 | 251310 | 4772 | 208 | 4 |
8788 | 8788 | 2021-04-04 | Orange | 59 | 251102 | 4768 | 0 | 0 |
8846 | 8846 | 2021-04-03 | Orange | 59 | 251102 | 4768 | 248 | 7 |
8904 | 8904 | 2021-04-02 | Orange | 59 | 250854 | 4761 | 90 | 6 |
8962 | 8962 | 2021-04-01 | Orange | 59 | 250764 | 4755 | 81 | 11 |
9020 | 9020 | 2021-03-31 | Orange | 59 | 250683 | 4744 | 146 | 4 |
9078 | 9078 | 2021-03-30 | Orange | 59 | 250537 | 4740 | 106 | 14 |
9136 | 9136 | 2021-03-29 | Orange | 59 | 250431 | 4726 | 123 | 1 |
9194 | 9194 | 2021-03-28 | Orange | 59 | 250308 | 4725 | 119 | 14 |
9252 | 9252 | 2021-03-27 | Orange | 59 | 250189 | 4711 | 94 | 27 |
9310 | 9310 | 2021-03-26 | Orange | 59 | 250095 | 4684 | 156 | 19 |
9368 | 9368 | 2021-03-25 | Orange | 59 | 249939 | 4665 | 97 | 19 |
9426 | 9426 | 2021-03-24 | Orange | 59 | 249842 | 4646 | 82 | 11 |
9484 | 9484 | 2021-03-23 | Orange | 59 | 249760 | 4635 | 119 | 27 |
9542 | 9542 | 2021-03-22 | Orange | 59 | 249641 | 4608 | 102 | 1 |
9600 | 9600 | 2021-03-21 | Orange | 59 | 249539 | 4607 | 113 | 45 |
9658 | 9658 | 2021-03-20 | Orange | 59 | 249426 | 4562 | 118 | 26 |
9716 | 9716 | 2021-03-19 | Orange | 59 | 249308 | 4536 | 127 | 14 |
9774 | 9774 | 2021-03-18 | Orange | 59 | 249181 | 4522 | 114 | 11 |
9832 | 9832 | 2021-03-17 | Orange | 59 | 249067 | 4511 | 163 | 25 |
9890 | 9890 | 2021-03-16 | Orange | 59 | 248904 | 4486 | 23 | 0 |
9948 | 9948 | 2021-03-15 | Orange | 59 | 248881 | 4486 | 169 | 21 |
10006 | 10006 | 2021-03-14 | Orange | 59 | 248712 | 4465 | 151 | 31 |
10064 | 10064 | 2021-03-13 | Orange | 59 | 248561 | 4434 | 172 | 26 |
10122 | 10122 | 2021-03-12 | Orange | 59 | 248389 | 4408 | 172 | 29 |
10180 | 10180 | 2021-03-11 | Orange | 59 | 248217 | 4379 | 139 | 33 |
10238 | 10238 | 2021-03-10 | Orange | 59 | 248078 | 4346 | 56 | 33 |
10296 | 10296 | 2021-03-09 | Orange | 59 | 248022 | 4313 | 108 | 61 |
10354 | 10354 | 2021-03-08 | Orange | 59 | 247914 | 4252 | 163 | 26 |
10412 | 10412 | 2021-03-07 | Orange | 59 | 247751 | 4226 | 110 | 53 |
10470 | 10470 | 2021-03-06 | Orange | 59 | 247641 | 4173 | 269 | 98 |
10528 | 10528 | 2021-03-05 | Orange | 59 | 247372 | 4075 | 232 | 62 |
10586 | 10586 | 2021-03-04 | Orange | 59 | 247140 | 4013 | 160 | 47 |
10644 | 10644 | 2021-03-03 | Orange | 59 | 246980 | 3966 | 160 | 14 |
10702 | 10702 | 2021-03-02 | Orange | 59 | 246820 | 3952 | 186 | 31 |
10760 | 10760 | 2021-03-01 | Orange | 59 | 246634 | 3921 | 179 | 4 |
10818 | 10818 | 2021-02-28 | Orange | 59 | 246455 | 3917 | 191 | 13 |
10876 | 10876 | 2021-02-27 | Orange | 59 | 246264 | 3904 | 281 | 12 |
10934 | 10934 | 2021-02-26 | Orange | 59 | 245983 | 3892 | 349 | 3 |
10992 | 10992 | 2021-02-25 | Orange | 59 | 245634 | 3889 | 174 | 41 |
11050 | 11050 | 2021-02-24 | Orange | 59 | 245460 | 3848 | 325 | 0 |
11108 | 11108 | 2021-02-23 | Orange | 59 | 245135 | 3848 | 250 | 0 |
11166 | 11166 | 2021-02-22 | Orange | 59 | 244885 | 3848 | 253 | 38 |
11224 | 11224 | 2021-02-21 | Orange | 59 | 244632 | 3810 | 252 | 40 |
11282 | 11282 | 2021-02-20 | Orange | 59 | 244380 | 3770 | 391 | 44 |
11340 | 11340 | 2021-02-19 | Orange | 59 | 243989 | 3726 | 324 | 41 |
11398 | 11398 | 2021-02-18 | Orange | 59 | 243665 | 3685 | 336 | 41 |
11456 | 11456 | 2021-02-17 | Orange | 59 | 243329 | 3644 | 166 | 27 |
11514 | 11514 | 2021-02-16 | Orange | 59 | 243163 | 3617 | 658 | 40 |
11572 | 11572 | 2021-02-15 | Orange | 59 | 242505 | 3577 | 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 );