latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
586 rows where fips = 85 sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date | confirmed_cases ▼ | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
29631 | 29631 | Santa Clara | Santa Clara | 85 | 2020-05-05 | 2296 | 126 | |
29570 | 29570 | Santa Clara | Santa Clara | 85 | 2020-05-06 | 2324 | 126 | |
29509 | 29509 | Santa Clara | Santa Clara | 85 | 2020-05-07 | 2336 | 127 | |
29448 | 29448 | Santa Clara | Santa Clara | 85 | 2020-05-08 | 2360 | 127 | |
29387 | 29387 | Santa Clara | Santa Clara | 85 | 2020-05-09 | 2371 | 128 | |
29326 | 29326 | Santa Clara | Santa Clara | 85 | 2020-05-10 | 2374 | 130 | |
29265 | 29265 | Santa Clara | Santa Clara | 85 | 2020-05-11 | 2394 | 130 | |
29204 | 29204 | Santa Clara | Santa Clara | 85 | 2020-05-12 | 2409 | 131 | |
29143 | 29143 | Santa Clara | Santa Clara | 85 | 2020-05-13 | 2429 | 132 | |
29082 | 29082 | Santa Clara | Santa Clara | 85 | 2020-05-14 | 2453 | 133 | |
29021 | 29021 | Santa Clara | Santa Clara | 85 | 2020-05-15 | 2468 | 134 | |
28960 | 28960 | Santa Clara | Santa Clara | 85 | 2020-05-16 | 2483 | 135 | |
28899 | 28899 | Santa Clara | Santa Clara | 85 | 2020-05-17 | 2490 | 136 | |
28838 | 28838 | Santa Clara | Santa Clara | 85 | 2020-05-18 | 2529 | 136 | |
28777 | 28777 | Santa Clara | Santa Clara | 85 | 2020-05-19 | 2573 | 136 | |
28716 | 28716 | Santa Clara | Santa Clara | 85 | 2020-05-20 | 2609 | 136 | |
28655 | 28655 | Santa Clara | Santa Clara | 85 | 2020-05-21 | 2630 | 136 | |
28594 | 28594 | Santa Clara | Santa Clara | 85 | 2020-05-22 | 2656 | 137 | |
28533 | 28533 | Santa Clara | Santa Clara | 85 | 2020-05-23 | 2673 | 137 | |
28472 | 28472 | Santa Clara | Santa Clara | 85 | 2020-05-24 | 2675 | 137 | |
28411 | 28411 | Santa Clara | Santa Clara | 85 | 2020-05-25 | 2682 | 137 | |
28350 | 28350 | Santa Clara | Santa Clara | 85 | 2020-05-26 | 2714 | 137 | |
28289 | 28289 | Santa Clara | Santa Clara | 85 | 2020-05-27 | 2753 | 137 | |
28228 | 28228 | Santa Clara | Santa Clara | 85 | 2020-05-28 | 2776 | 139 | |
28167 | 28167 | Santa Clara | Santa Clara | 85 | 2020-05-29 | 2820 | 141 | |
28106 | 28106 | Santa Clara | Santa Clara | 85 | 2020-05-30 | 2836 | 141 | |
28045 | 28045 | Santa Clara | Santa Clara | 85 | 2020-05-31 | 2846 | 141 | |
27984 | 27984 | Santa Clara | Santa Clara | 85 | 2020-06-01 | 2880 | 142 | |
27923 | 27923 | Santa Clara | Santa Clara | 85 | 2020-06-02 | 2905 | 143 | |
27862 | 27862 | Santa Clara | Santa Clara | 85 | 2020-06-03 | 2947 | 144 | |
27801 | 27801 | Santa Clara | Santa Clara | 85 | 2020-06-04 | 2984 | 144 | |
27740 | 27740 | Santa Clara | Santa Clara | 85 | 2020-06-05 | 3020 | 144 | |
27679 | 27679 | Santa Clara | Santa Clara | 85 | 2020-06-06 | 3033 | 145 | |
27618 | 27618 | Santa Clara | Santa Clara | 85 | 2020-06-07 | 3051 | 145 | |
27557 | 27557 | Santa Clara | Santa Clara | 85 | 2020-06-08 | 3090 | 145 | |
27496 | 27496 | Santa Clara | Santa Clara | 85 | 2020-06-09 | 3137 | 145 | |
27435 | 27435 | Santa Clara | Santa Clara | 85 | 2020-06-10 | 3200 | 146 | |
27374 | 27374 | Santa Clara | Santa Clara | 85 | 2020-06-11 | 3250 | 147 | |
27313 | 27313 | Santa Clara | Santa Clara | 85 | 2020-06-12 | 3308 | 147 | |
27252 | 27252 | Santa Clara | Santa Clara | 85 | 2020-06-13 | 3329 | 148 | |
27191 | 27191 | Santa Clara | Santa Clara | 85 | 2020-06-14 | 3342 | 148 | |
27130 | 27130 | Santa Clara | Santa Clara | 85 | 2020-06-15 | 3404 | 148 | |
27069 | 27069 | Santa Clara | Santa Clara | 85 | 2020-06-16 | 3499 | 148 | |
27008 | 27008 | Santa Clara | Santa Clara | 85 | 2020-06-17 | 3592 | 148 | |
26947 | 26947 | Santa Clara | Santa Clara | 85 | 2020-06-18 | 3694 | 148 | |
26886 | 26886 | Santa Clara | Santa Clara | 85 | 2020-06-19 | 3804 | 148 | |
26825 | 26825 | Santa Clara | Santa Clara | 85 | 2020-06-20 | 3854 | 149 | |
26764 | 26764 | Santa Clara | Santa Clara | 85 | 2020-06-21 | 3891 | 151 | |
26703 | 26703 | Santa Clara | Santa Clara | 85 | 2020-06-22 | 3997 | 151 | |
26642 | 26642 | Santa Clara | Santa Clara | 85 | 2020-06-23 | 4188 | 151 | |
26581 | 26581 | Santa Clara | Santa Clara | 85 | 2020-06-24 | 4335 | 152 | |
26520 | 26520 | Santa Clara | Santa Clara | 85 | 2020-06-25 | 4472 | 153 | |
26459 | 26459 | Santa Clara | Santa Clara | 85 | 2020-06-26 | 4607 | 155 | |
26398 | 26398 | Santa Clara | Santa Clara | 85 | 2020-06-27 | 4718 | 155 | TRUE |
26337 | 26337 | Santa Clara | Santa Clara | 85 | 2020-06-28 | 4779 | 155 | |
26276 | 26276 | Santa Clara | Santa Clara | 85 | 2020-06-29 | 4919 | 155 | |
26215 | 26215 | Santa Clara | Santa Clara | 85 | 2020-06-30 | 5107 | 156 | |
26154 | 26154 | Santa Clara | Santa Clara | 85 | 2020-07-01 | 5291 | 156 | |
26093 | 26093 | Santa Clara | Santa Clara | 85 | 2020-07-02 | 5476 | 156 | |
26032 | 26032 | Santa Clara | Santa Clara | 85 | 2020-07-03 | 5555 | 157 | |
25971 | 25971 | Santa Clara | Santa Clara | 85 | 2020-07-04 | 5599 | 159 | |
25910 | 25910 | Santa Clara | Santa Clara | 85 | 2020-07-05 | 5696 | 162 | |
25849 | 25849 | Santa Clara | Santa Clara | 85 | 2020-07-06 | 5950 | 164 | |
25788 | 25788 | Santa Clara | Santa Clara | 85 | 2020-07-07 | 6242 | 165 | |
25727 | 25727 | Santa Clara | Santa Clara | 85 | 2020-07-08 | 6530 | 170 | |
25666 | 25666 | Santa Clara | Santa Clara | 85 | 2020-07-09 | 6811 | 170 | |
25605 | 25605 | Santa Clara | Santa Clara | 85 | 2020-07-10 | 7055 | 171 | |
25544 | 25544 | Santa Clara | Santa Clara | 85 | 2020-07-11 | 7237 | 171 | |
25483 | 25483 | Santa Clara | Santa Clara | 85 | 2020-07-12 | 7356 | 171 | |
25422 | 25422 | Santa Clara | Santa Clara | 85 | 2020-07-13 | 7562 | 172 | |
25361 | 25361 | Santa Clara | Santa Clara | 85 | 2020-07-14 | 7916 | 174 | |
25300 | 25300 | Santa Clara | Santa Clara | 85 | 2020-07-15 | 8302 | 175 | |
25239 | 25239 | Santa Clara | Santa Clara | 85 | 2020-07-16 | 8642 | 177 | |
25178 | 25178 | Santa Clara | Santa Clara | 85 | 2020-07-17 | 8941 | 178 | |
25117 | 25117 | Santa Clara | Santa Clara | 85 | 2020-07-18 | 9111 | 180 | |
25056 | 25056 | Santa Clara | Santa Clara | 85 | 2020-07-19 | 9198 | 181 | |
24995 | 24995 | Santa Clara | Santa Clara | 85 | 2020-07-20 | 9414 | 182 | |
24934 | 24934 | Santa Clara | Santa Clara | 85 | 2020-07-21 | 9726 | 183 | |
24873 | 24873 | Santa Clara | Santa Clara | 85 | 2020-07-22 | 10027 | 186 | |
24812 | 24812 | Santa Clara | Santa Clara | 85 | 2020-07-23 | 10309 | 186 | |
24751 | 24751 | Santa Clara | Santa Clara | 85 | 2020-07-24 | 10555 | 187 | |
24690 | 24690 | Santa Clara | Santa Clara | 85 | 2020-07-25 | 10682 | 189 | |
24629 | 24629 | Santa Clara | Santa Clara | 85 | 2020-07-26 | 10768 | 190 | |
24568 | 24568 | Santa Clara | Santa Clara | 85 | 2020-07-27 | 10944 | 192 | |
24507 | 24507 | Santa Clara | Santa Clara | 85 | 2020-07-28 | 11242 | 192 | |
24446 | 24446 | Santa Clara | Santa Clara | 85 | 2020-07-29 | 11515 | 194 | |
24385 | 24385 | Santa Clara | Santa Clara | 85 | 2020-07-30 | 11757 | 194 | |
24324 | 24324 | Santa Clara | Santa Clara | 85 | 2020-07-31 | 12019 | 195 | |
24263 | 24263 | Santa Clara | Santa Clara | 85 | 2020-08-01 | 12192 | 197 | |
24202 | 24202 | Santa Clara | Santa Clara | 85 | 2020-08-02 | 12276 | 199 | |
24141 | 24141 | Santa Clara | Santa Clara | 85 | 2020-08-03 | 12446 | 202 | |
24080 | 24080 | Santa Clara | Santa Clara | 85 | 2020-08-04 | 12748 | 205 | |
24019 | 24019 | Santa Clara | Santa Clara | 85 | 2020-08-05 | 13081 | 206 | |
23958 | 23958 | Santa Clara | Santa Clara | 85 | 2020-08-06 | 13326 | 207 | |
23897 | 23897 | Santa Clara | Santa Clara | 85 | 2020-08-07 | 13585 | 207 | |
23836 | 23836 | Santa Clara | Santa Clara | 85 | 2020-08-08 | 13792 | 207 | |
23775 | 23775 | Santa Clara | Santa Clara | 85 | 2020-08-09 | 13903 | 207 | |
23714 | 23714 | Santa Clara | Santa Clara | 85 | 2020-08-10 | 14127 | 209 | |
23653 | 23653 | Santa Clara | Santa Clara | 85 | 2020-08-11 | 14458 | 209 | |
23592 | 23592 | Santa Clara | Santa Clara | 85 | 2020-08-12 | 14742 | 210 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );