latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
541 rows where fips = 25 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
18985 | 18985 | Imperial | Imperial | 25 | 2020-10-26 | 12882 | 336 | |
19046 | 19046 | Imperial | Imperial | 25 | 2020-10-25 | 12700 | 336 | TRUE |
19107 | 19107 | Imperial | Imperial | 25 | 2020-10-24 | 12700 | 336 | TRUE |
19168 | 19168 | Imperial | Imperial | 25 | 2020-10-23 | 12700 | 336 | |
19229 | 19229 | Imperial | Imperial | 25 | 2020-10-22 | 12668 | 336 | |
19290 | 19290 | Imperial | Imperial | 25 | 2020-10-21 | 12610 | 336 | |
19351 | 19351 | Imperial | Imperial | 25 | 2020-10-20 | 12534 | 335 | |
19412 | 19412 | Imperial | Imperial | 25 | 2020-10-19 | 12475 | 335 | |
19473 | 19473 | Imperial | Imperial | 25 | 2020-10-18 | 12410 | 335 | TRUE |
19534 | 19534 | Imperial | Imperial | 25 | 2020-10-17 | 12410 | 335 | TRUE |
19595 | 19595 | Imperial | Imperial | 25 | 2020-10-16 | 12410 | 335 | |
19656 | 19656 | Imperial | Imperial | 25 | 2020-10-15 | 12373 | 335 | |
19717 | 19717 | Imperial | Imperial | 25 | 2020-10-14 | 12334 | 335 | |
19778 | 19778 | Imperial | Imperial | 25 | 2020-10-13 | 12290 | 330 | |
19839 | 19839 | Imperial | Imperial | 25 | 2020-10-12 | 12220 | 330 | |
19900 | 19900 | Imperial | Imperial | 25 | 2020-10-11 | 12145 | 329 | TRUE |
19961 | 19961 | Imperial | Imperial | 25 | 2020-10-10 | 12145 | 329 | TRUE |
20022 | 20022 | Imperial | Imperial | 25 | 2020-10-09 | 12145 | 329 | TRUE |
20083 | 20083 | Imperial | Imperial | 25 | 2020-10-08 | 12145 | 329 | |
20144 | 20144 | Imperial | Imperial | 25 | 2020-10-07 | 12120 | 327 | |
20205 | 20205 | Imperial | Imperial | 25 | 2020-10-06 | 12109 | 326 | |
20266 | 20266 | Imperial | Imperial | 25 | 2020-10-05 | 12076 | 326 | |
20327 | 20327 | Imperial | Imperial | 25 | 2020-10-04 | 12047 | 326 | TRUE |
20388 | 20388 | Imperial | Imperial | 25 | 2020-10-03 | 12047 | 326 | |
20449 | 20449 | Imperial | Imperial | 25 | 2020-10-02 | 12002 | 323 | |
20510 | 20510 | Imperial | Imperial | 25 | 2020-10-01 | 11993 | 323 | |
20571 | 20571 | Imperial | Imperial | 25 | 2020-09-30 | 11908 | 320 | |
20632 | 20632 | Imperial | Imperial | 25 | 2020-09-29 | 11877 | 317 | |
20693 | 20693 | Imperial | Imperial | 25 | 2020-09-28 | 11852 | 317 | |
20754 | 20754 | Imperial | Imperial | 25 | 2020-09-27 | 11835 | 317 | TRUE |
20815 | 20815 | Imperial | Imperial | 25 | 2020-09-26 | 11835 | 317 | |
20876 | 20876 | Imperial | Imperial | 25 | 2020-09-25 | 11781 | 317 | |
20937 | 20937 | Imperial | Imperial | 25 | 2020-09-24 | 11741 | 317 | |
20998 | 20998 | Imperial | Imperial | 25 | 2020-09-23 | 11658 | 317 | |
21059 | 21059 | Imperial | Imperial | 25 | 2020-09-22 | 11606 | 314 | |
21120 | 21120 | Imperial | Imperial | 25 | 2020-09-21 | 11583 | 314 | |
21181 | 21181 | Imperial | Imperial | 25 | 2020-09-20 | 11558 | 314 | TRUE |
21242 | 21242 | Imperial | Imperial | 25 | 2020-09-19 | 11558 | 314 | |
21303 | 21303 | Imperial | Imperial | 25 | 2020-09-18 | 11534 | 312 | |
21364 | 21364 | Imperial | Imperial | 25 | 2020-09-17 | 11457 | 310 | |
21425 | 21425 | Imperial | Imperial | 25 | 2020-09-16 | 11435 | 309 | |
21486 | 21486 | Imperial | Imperial | 25 | 2020-09-15 | 11392 | 309 | |
21547 | 21547 | Imperial | Imperial | 25 | 2020-09-14 | 11291 | 308 | |
21608 | 21608 | Imperial | Imperial | 25 | 2020-09-13 | 11274 | 308 | TRUE |
21669 | 21669 | Imperial | Imperial | 25 | 2020-09-12 | 11274 | 308 | |
21730 | 21730 | Imperial | Imperial | 25 | 2020-09-11 | 11218 | 308 | |
21791 | 21791 | Imperial | Imperial | 25 | 2020-09-10 | 11183 | 303 | |
21852 | 21852 | Imperial | Imperial | 25 | 2020-09-09 | 11093 | 301 | |
21913 | 21913 | Imperial | Imperial | 25 | 2020-09-08 | 11056 | 296 | |
21974 | 21974 | Imperial | Imperial | 25 | 2020-09-07 | 11041 | 296 | TRUE |
22035 | 22035 | Imperial | Imperial | 25 | 2020-09-06 | 11041 | 296 | TRUE |
22096 | 22096 | Imperial | Imperial | 25 | 2020-09-05 | 11041 | 296 | |
22157 | 22157 | Imperial | Imperial | 25 | 2020-09-04 | 11001 | 296 | |
22218 | 22218 | Imperial | Imperial | 25 | 2020-09-03 | 10773 | 296 | |
22279 | 22279 | Imperial | Imperial | 25 | 2020-09-02 | 10746 | 296 | |
22340 | 22340 | Imperial | Imperial | 25 | 2020-09-01 | 10711 | 294 | |
22401 | 22401 | Imperial | Imperial | 25 | 2020-08-31 | 10711 | 293 | |
22462 | 22462 | Imperial | Imperial | 25 | 2020-08-30 | 10667 | 293 | TRUE |
22523 | 22523 | Imperial | Imperial | 25 | 2020-08-29 | 10667 | 293 | |
22584 | 22584 | Imperial | Imperial | 25 | 2020-08-28 | 10641 | 287 | |
22645 | 22645 | Imperial | Imperial | 25 | 2020-08-27 | 10573 | 286 | |
22706 | 22706 | Imperial | Imperial | 25 | 2020-08-26 | 10509 | 283 | |
22767 | 22767 | Imperial | Imperial | 25 | 2020-08-25 | 10486 | 272 | |
22828 | 22828 | Imperial | Imperial | 25 | 2020-08-24 | 10396 | 272 | |
22889 | 22889 | Imperial | Imperial | 25 | 2020-08-23 | 10393 | 272 | TRUE |
22950 | 22950 | Imperial | Imperial | 25 | 2020-08-22 | 10393 | 272 | |
23011 | 23011 | Imperial | Imperial | 25 | 2020-08-21 | 10366 | 269 | |
23072 | 23072 | Imperial | Imperial | 25 | 2020-08-20 | 10325 | 266 | |
23133 | 23133 | Imperial | Imperial | 25 | 2020-08-19 | 10304 | 265 | |
23194 | 23194 | Imperial | Imperial | 25 | 2020-08-18 | 10268 | 265 | |
23255 | 23255 | Imperial | Imperial | 25 | 2020-08-17 | 10145 | 257 | |
23316 | 23316 | Imperial | Imperial | 25 | 2020-08-16 | 10058 | 257 | TRUE |
23377 | 23377 | Imperial | Imperial | 25 | 2020-08-15 | 10058 | 257 | |
23438 | 23438 | Imperial | Imperial | 25 | 2020-08-14 | 10035 | 257 | |
23499 | 23499 | Imperial | Imperial | 25 | 2020-08-13 | 9957 | 257 | |
23560 | 23560 | Imperial | Imperial | 25 | 2020-08-12 | 9919 | 252 | |
23621 | 23621 | Imperial | Imperial | 25 | 2020-08-11 | 9867 | 244 | |
23682 | 23682 | Imperial | Imperial | 25 | 2020-08-10 | 9693 | 244 | |
23743 | 23743 | Imperial | Imperial | 25 | 2020-08-09 | 9693 | 244 | TRUE |
23804 | 23804 | Imperial | Imperial | 25 | 2020-08-08 | 9693 | 244 | |
23865 | 23865 | Imperial | Imperial | 25 | 2020-08-07 | 9629 | 242 | |
23926 | 23926 | Imperial | Imperial | 25 | 2020-08-06 | 9601 | 240 | |
23987 | 23987 | Imperial | Imperial | 25 | 2020-08-05 | 9546 | 234 | |
24048 | 24048 | Imperial | Imperial | 25 | 2020-08-04 | 9513 | 232 | |
24109 | 24109 | Imperial | Imperial | 25 | 2020-08-03 | 9448 | 222 | |
24170 | 24170 | Imperial | Imperial | 25 | 2020-08-02 | 9409 | 220 | TRUE |
24231 | 24231 | Imperial | Imperial | 25 | 2020-08-01 | 9409 | 220 | |
24292 | 24292 | Imperial | Imperial | 25 | 2020-07-31 | 9366 | 210 | |
24353 | 24353 | Imperial | Imperial | 25 | 2020-07-30 | 9298 | 200 | |
24414 | 24414 | Imperial | Imperial | 25 | 2020-07-29 | 9241 | 188 | |
24475 | 24475 | Imperial | Imperial | 25 | 2020-07-28 | 9189 | 188 | |
24536 | 24536 | Imperial | Imperial | 25 | 2020-07-27 | 9162 | 181 | |
24597 | 24597 | Imperial | Imperial | 25 | 2020-07-26 | 9067 | 181 | TRUE |
24658 | 24658 | Imperial | Imperial | 25 | 2020-07-25 | 9067 | 181 | |
24719 | 24719 | Imperial | Imperial | 25 | 2020-07-24 | 8967 | 173 | |
24780 | 24780 | Imperial | Imperial | 25 | 2020-07-23 | 8919 | 170 | |
24841 | 24841 | Imperial | Imperial | 25 | 2020-07-22 | 8799 | 165 | |
24902 | 24902 | Imperial | Imperial | 25 | 2020-07-21 | 8606 | 163 | TRUE |
24963 | 24963 | Imperial | Imperial | 25 | 2020-07-20 | 8606 | 163 | |
25024 | 25024 | Imperial | Imperial | 25 | 2020-07-19 | 8531 | 161 | TRUE |
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 );