latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
530 rows where fips = 47 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
18062 | 18062 | 2020-10-26 | Merced | 47 | 9531 | 155 | 66 | 0 |
18120 | 18120 | 2020-10-25 | Merced | 47 | 9465 | 155 | 0 | 0 |
18178 | 18178 | 2020-10-24 | Merced | 47 | 9465 | 155 | 0 | 0 |
18236 | 18236 | 2020-10-23 | Merced | 47 | 9465 | 155 | 26 | 1 |
18294 | 18294 | 2020-10-22 | Merced | 47 | 9439 | 154 | 24 | 0 |
18352 | 18352 | 2020-10-21 | Merced | 47 | 9415 | 154 | 29 | 1 |
18410 | 18410 | 2020-10-20 | Merced | 47 | 9386 | 153 | 11 | 1 |
18468 | 18468 | 2020-10-19 | Merced | 47 | 9375 | 152 | 61 | 0 |
18526 | 18526 | 2020-10-18 | Merced | 47 | 9314 | 152 | 0 | 0 |
18584 | 18584 | 2020-10-17 | Merced | 47 | 9314 | 152 | 0 | 0 |
18642 | 18642 | 2020-10-16 | Merced | 47 | 9314 | 152 | 12 | 0 |
18700 | 18700 | 2020-10-15 | Merced | 47 | 9302 | 152 | 16 | 0 |
18758 | 18758 | 2020-10-14 | Merced | 47 | 9286 | 152 | 21 | 0 |
18816 | 18816 | 2020-10-13 | Merced | 47 | 9265 | 152 | 116 | 2 |
18874 | 18874 | 2020-10-12 | Merced | 47 | 9149 | 150 | 0 | 0 |
18932 | 18932 | 2020-10-11 | Merced | 47 | 9149 | 150 | 0 | 0 |
18990 | 18990 | 2020-10-10 | Merced | 47 | 9149 | 150 | 0 | 0 |
19048 | 19048 | 2020-10-09 | Merced | 47 | 9149 | 150 | 19 | 0 |
19106 | 19106 | 2020-10-08 | Merced | 47 | 9130 | 150 | 19 | 1 |
19164 | 19164 | 2020-10-07 | Merced | 47 | 9111 | 149 | 21 | 0 |
19222 | 19222 | 2020-10-06 | Merced | 47 | 9090 | 149 | 9 | 1 |
19280 | 19280 | 2020-10-05 | Merced | 47 | 9081 | 148 | 48 | 3 |
19338 | 19338 | 2020-10-04 | Merced | 47 | 9033 | 145 | 0 | 0 |
19396 | 19396 | 2020-10-03 | Merced | 47 | 9033 | 145 | 0 | 0 |
19454 | 19454 | 2020-10-02 | Merced | 47 | 9033 | 145 | 14 | 0 |
19512 | 19512 | 2020-10-01 | Merced | 47 | 9019 | 145 | 26 | 0 |
19570 | 19570 | 2020-09-30 | Merced | 47 | 8993 | 145 | 32 | 2 |
19628 | 19628 | 2020-09-29 | Merced | 47 | 8961 | 143 | 22 | 0 |
19686 | 19686 | 2020-09-28 | Merced | 47 | 8939 | 143 | 67 | 1 |
19744 | 19744 | 2020-09-27 | Merced | 47 | 8872 | 142 | 0 | 0 |
19802 | 19802 | 2020-09-26 | Merced | 47 | 8872 | 142 | 0 | 0 |
19860 | 19860 | 2020-09-25 | Merced | 47 | 8872 | 142 | 26 | 2 |
19918 | 19918 | 2020-09-24 | Merced | 47 | 8846 | 140 | 18 | 0 |
19976 | 19976 | 2020-09-23 | Merced | 47 | 8828 | 140 | 25 | 0 |
20034 | 20034 | 2020-09-22 | Merced | 47 | 8803 | 140 | 0 | 3 |
20092 | 20092 | 2020-09-21 | Merced | 47 | 8803 | 137 | 53 | 3 |
20150 | 20150 | 2020-09-20 | Merced | 47 | 8750 | 134 | 0 | 0 |
20208 | 20208 | 2020-09-19 | Merced | 47 | 8750 | 134 | 0 | 0 |
20266 | 20266 | 2020-09-18 | Merced | 47 | 8750 | 134 | 31 | 1 |
20324 | 20324 | 2020-09-17 | Merced | 47 | 8719 | 133 | 27 | 2 |
20382 | 20382 | 2020-09-16 | Merced | 47 | 8692 | 131 | 47 | 0 |
20440 | 20440 | 2020-09-15 | Merced | 47 | 8645 | 131 | 29 | 2 |
20498 | 20498 | 2020-09-14 | Merced | 47 | 8616 | 129 | 75 | 2 |
20556 | 20556 | 2020-09-13 | Merced | 47 | 8541 | 127 | 0 | 0 |
20614 | 20614 | 2020-09-12 | Merced | 47 | 8541 | 127 | 0 | 0 |
20672 | 20672 | 2020-09-11 | Merced | 47 | 8541 | 127 | 54 | 1 |
20730 | 20730 | 2020-09-10 | Merced | 47 | 8487 | 126 | 47 | 1 |
20788 | 20788 | 2020-09-09 | Merced | 47 | 8440 | 125 | 25 | 2 |
20846 | 20846 | 2020-09-08 | Merced | 47 | 8415 | 123 | 138 | 3 |
20904 | 20904 | 2020-09-07 | Merced | 47 | 8277 | 120 | 0 | 0 |
20962 | 20962 | 2020-09-06 | Merced | 47 | 8277 | 120 | 0 | 0 |
21020 | 21020 | 2020-09-05 | Merced | 47 | 8277 | 120 | 0 | 0 |
21078 | 21078 | 2020-09-04 | Merced | 47 | 8277 | 120 | 75 | 0 |
21136 | 21136 | 2020-09-03 | Merced | 47 | 8202 | 120 | 80 | 1 |
21194 | 21194 | 2020-09-02 | Merced | 47 | 8122 | 119 | 41 | 1 |
21252 | 21252 | 2020-09-01 | Merced | 47 | 8081 | 118 | 49 | 1 |
21310 | 21310 | 2020-08-31 | Merced | 47 | 8032 | 117 | 142 | 2 |
21368 | 21368 | 2020-08-30 | Merced | 47 | 7890 | 115 | 0 | 0 |
21426 | 21426 | 2020-08-29 | Merced | 47 | 7890 | 115 | 0 | 0 |
21484 | 21484 | 2020-08-28 | Merced | 47 | 7890 | 115 | 76 | 1 |
21542 | 21542 | 2020-08-27 | Merced | 47 | 7814 | 114 | 70 | 2 |
21600 | 21600 | 2020-08-26 | Merced | 47 | 7744 | 112 | 54 | 2 |
21658 | 21658 | 2020-08-25 | Merced | 47 | 7690 | 110 | 37 | 4 |
21716 | 21716 | 2020-08-24 | Merced | 47 | 7653 | 106 | 225 | 7 |
21774 | 21774 | 2020-08-23 | Merced | 47 | 7428 | 99 | 0 | 0 |
21832 | 21832 | 2020-08-22 | Merced | 47 | 7428 | 99 | 0 | 0 |
21890 | 21890 | 2020-08-21 | Merced | 47 | 7428 | 99 | 94 | 0 |
21948 | 21948 | 2020-08-20 | Merced | 47 | 7334 | 99 | 105 | 2 |
22006 | 22006 | 2020-08-19 | Merced | 47 | 7229 | 97 | 58 | 2 |
22064 | 22064 | 2020-08-18 | Merced | 47 | 7171 | 95 | 130 | 2 |
22122 | 22122 | 2020-08-17 | Merced | 47 | 7041 | 93 | 264 | 4 |
22180 | 22180 | 2020-08-16 | Merced | 47 | 6777 | 89 | 0 | 0 |
22238 | 22238 | 2020-08-15 | Merced | 47 | 6777 | 89 | 0 | 0 |
22296 | 22296 | 2020-08-14 | Merced | 47 | 6777 | 89 | 216 | 0 |
22354 | 22354 | 2020-08-13 | Merced | 47 | 6561 | 89 | 337 | 15 |
22412 | 22412 | 2020-08-12 | Merced | 47 | 6224 | 74 | 122 | 0 |
22470 | 22470 | 2020-08-11 | Merced | 47 | 6102 | 74 | 366 | 4 |
22528 | 22528 | 2020-08-10 | Merced | 47 | 5736 | 70 | 724 | 6 |
22586 | 22586 | 2020-08-09 | Merced | 47 | 5012 | 64 | 0 | 0 |
22644 | 22644 | 2020-08-08 | Merced | 47 | 5012 | 64 | 0 | 0 |
22702 | 22702 | 2020-08-07 | Merced | 47 | 5012 | 64 | 157 | 2 |
22760 | 22760 | 2020-08-06 | Merced | 47 | 4855 | 62 | 95 | 2 |
22818 | 22818 | 2020-08-05 | Merced | 47 | 4760 | 60 | 177 | 9 |
22876 | 22876 | 2020-08-04 | Merced | 47 | 4583 | 51 | 161 | 1 |
22934 | 22934 | 2020-08-03 | Merced | 47 | 4422 | 50 | 137 | 0 |
22992 | 22992 | 2020-08-02 | Merced | 47 | 4285 | 50 | 0 | 0 |
23050 | 23050 | 2020-08-01 | Merced | 47 | 4285 | 50 | 0 | 0 |
23108 | 23108 | 2020-07-31 | Merced | 47 | 4285 | 50 | 220 | 11 |
23166 | 23166 | 2020-07-30 | Merced | 47 | 4065 | 39 | 159 | 4 |
23224 | 23224 | 2020-07-29 | Merced | 47 | 3906 | 35 | 143 | 6 |
23282 | 23282 | 2020-07-28 | Merced | 47 | 3763 | 29 | 253 | 0 |
23340 | 23340 | 2020-07-27 | Merced | 47 | 3510 | 29 | 265 | 2 |
23398 | 23398 | 2020-07-26 | Merced | 47 | 3245 | 27 | 0 | 0 |
23456 | 23456 | 2020-07-25 | Merced | 47 | 3245 | 27 | 0 | 0 |
23514 | 23514 | 2020-07-24 | Merced | 47 | 3245 | 27 | 122 | 0 |
23572 | 23572 | 2020-07-23 | Merced | 47 | 3123 | 27 | 129 | 1 |
23630 | 23630 | 2020-07-22 | Merced | 47 | 2994 | 26 | 181 | 4 |
23688 | 23688 | 2020-07-21 | Merced | 47 | 2813 | 22 | 119 | 0 |
23746 | 23746 | 2020-07-20 | Merced | 47 | 2694 | 22 | 291 | 7 |
23804 | 23804 | 2020-07-19 | Merced | 47 | 2403 | 15 | 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 );