latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
555 rows where fips = 19 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 |
---|---|---|---|---|---|---|---|---|
18982 | 18982 | Fresno | Fresno | 19 | 2020-10-26 | 33353 | 436 | |
19043 | 19043 | Fresno | Fresno | 19 | 2020-10-25 | 33225 | 436 | |
19104 | 19104 | Fresno | Fresno | 19 | 2020-10-24 | 33164 | 436 | |
19165 | 19165 | Fresno | Fresno | 19 | 2020-10-23 | 33097 | 436 | |
19226 | 19226 | Fresno | Fresno | 19 | 2020-10-22 | 32990 | 430 | |
19287 | 19287 | Fresno | Fresno | 19 | 2020-10-21 | 32896 | 430 | |
19348 | 19348 | Fresno | Fresno | 19 | 2020-10-20 | 32794 | 430 | |
19409 | 19409 | Fresno | Fresno | 19 | 2020-10-19 | 32686 | 429 | |
19470 | 19470 | Fresno | Fresno | 19 | 2020-10-18 | 32562 | 429 | TRUE |
19531 | 19531 | Fresno | Fresno | 19 | 2020-10-17 | 32508 | 429 | |
19592 | 19592 | Fresno | Fresno | 19 | 2020-10-16 | 32433 | 429 | |
19653 | 19653 | Fresno | Fresno | 19 | 2020-10-15 | 32340 | 424 | |
19714 | 19714 | Fresno | Fresno | 19 | 2020-10-14 | 32228 | 424 | |
19775 | 19775 | Fresno | Fresno | 19 | 2020-10-13 | 32109 | 424 | |
19836 | 19836 | Fresno | Fresno | 19 | 2020-10-12 | 31976 | 406 | |
19897 | 19897 | Fresno | Fresno | 19 | 2020-10-11 | 31839 | 406 | TRUE |
19958 | 19958 | Fresno | Fresno | 19 | 2020-10-10 | 31776 | 406 | |
20019 | 20019 | Fresno | Fresno | 19 | 2020-10-09 | 31703 | 406 | |
20080 | 20080 | Fresno | Fresno | 19 | 2020-10-08 | 31598 | 406 | |
20141 | 20141 | Fresno | Fresno | 19 | 2020-10-07 | 31476 | 406 | |
20202 | 20202 | Fresno | Fresno | 19 | 2020-10-06 | 31334 | 406 | |
20263 | 20263 | Fresno | Fresno | 19 | 2020-10-05 | 31218 | 399 | |
20324 | 20324 | Fresno | Fresno | 19 | 2020-10-04 | 31095 | 399 | TRUE |
20385 | 20385 | Fresno | Fresno | 19 | 2020-10-03 | 31036 | 399 | |
20446 | 20446 | Fresno | Fresno | 19 | 2020-10-02 | 30953 | 399 | |
20507 | 20507 | Fresno | Fresno | 19 | 2020-10-01 | 30873 | 390 | |
20568 | 20568 | Fresno | Fresno | 19 | 2020-09-30 | 30782 | 390 | |
20629 | 20629 | Fresno | Fresno | 19 | 2020-09-29 | 30688 | 390 | |
20690 | 20690 | Fresno | Fresno | 19 | 2020-09-28 | 30606 | 382 | |
20751 | 20751 | Fresno | Fresno | 19 | 2020-09-27 | 30501 | 382 | TRUE |
20812 | 20812 | Fresno | Fresno | 19 | 2020-09-26 | 30434 | 382 | |
20873 | 20873 | Fresno | Fresno | 19 | 2020-09-25 | 30376 | 382 | |
20934 | 20934 | Fresno | Fresno | 19 | 2020-09-24 | 30272 | 362 | |
20995 | 20995 | Fresno | Fresno | 19 | 2020-09-23 | 30179 | 362 | |
21056 | 21056 | Fresno | Fresno | 19 | 2020-09-22 | 30086 | 362 | |
21117 | 21117 | Fresno | Fresno | 19 | 2020-09-21 | 29986 | 355 | |
21178 | 21178 | Fresno | Fresno | 19 | 2020-09-20 | 29872 | 355 | TRUE |
21239 | 21239 | Fresno | Fresno | 19 | 2020-09-19 | 29799 | 355 | |
21300 | 21300 | Fresno | Fresno | 19 | 2020-09-18 | 29735 | 355 | |
21361 | 21361 | Fresno | Fresno | 19 | 2020-09-17 | 29626 | 348 | |
21422 | 21422 | Fresno | Fresno | 19 | 2020-09-16 | 29522 | 348 | |
21483 | 21483 | Fresno | Fresno | 19 | 2020-09-15 | 29418 | 348 | |
21544 | 21544 | Fresno | Fresno | 19 | 2020-09-14 | 29333 | 337 | |
21605 | 21605 | Fresno | Fresno | 19 | 2020-09-13 | 29226 | 337 | TRUE |
21666 | 21666 | Fresno | Fresno | 19 | 2020-09-12 | 29157 | 337 | |
21727 | 21727 | Fresno | Fresno | 19 | 2020-09-11 | 29077 | 337 | |
21788 | 21788 | Fresno | Fresno | 19 | 2020-09-10 | 28958 | 326 | |
21849 | 21849 | Fresno | Fresno | 19 | 2020-09-09 | 28857 | 326 | |
21910 | 21910 | Fresno | Fresno | 19 | 2020-09-08 | 28738 | 326 | |
21971 | 21971 | Fresno | Fresno | 19 | 2020-09-07 | 28646 | 312 | |
22032 | 22032 | Fresno | Fresno | 19 | 2020-09-06 | 28582 | 312 | TRUE |
22093 | 22093 | Fresno | Fresno | 19 | 2020-09-05 | 28514 | 312 | |
22154 | 22154 | Fresno | Fresno | 19 | 2020-09-04 | 28409 | 312 | |
22215 | 22215 | Fresno | Fresno | 19 | 2020-09-03 | 28291 | 290 | |
22276 | 22276 | Fresno | Fresno | 19 | 2020-09-02 | 28146 | 290 | |
22337 | 22337 | Fresno | Fresno | 19 | 2020-09-01 | 28001 | 290 | |
22398 | 22398 | Fresno | Fresno | 19 | 2020-08-31 | 27784 | 263 | |
22459 | 22459 | Fresno | Fresno | 19 | 2020-08-30 | 27660 | 263 | TRUE |
22520 | 22520 | Fresno | Fresno | 19 | 2020-08-29 | 27605 | 263 | |
22581 | 22581 | Fresno | Fresno | 19 | 2020-08-28 | 27471 | 263 | |
22642 | 22642 | Fresno | Fresno | 19 | 2020-08-27 | 27292 | 239 | |
22703 | 22703 | Fresno | Fresno | 19 | 2020-08-26 | 27145 | 239 | |
22764 | 22764 | Fresno | Fresno | 19 | 2020-08-25 | 26958 | 239 | |
22825 | 22825 | Fresno | Fresno | 19 | 2020-08-24 | 26773 | 226 | |
22886 | 22886 | Fresno | Fresno | 19 | 2020-08-23 | 26571 | 226 | TRUE |
22947 | 22947 | Fresno | Fresno | 19 | 2020-08-22 | 26473 | 226 | |
23008 | 23008 | Fresno | Fresno | 19 | 2020-08-21 | 26303 | 226 | |
23069 | 23069 | Fresno | Fresno | 19 | 2020-08-20 | 26121 | 205 | |
23130 | 23130 | Fresno | Fresno | 19 | 2020-08-19 | 25932 | 205 | |
23191 | 23191 | Fresno | Fresno | 19 | 2020-08-18 | 25713 | 205 | |
23252 | 23252 | Fresno | Fresno | 19 | 2020-08-17 | 25508 | 203 | |
23313 | 23313 | Fresno | Fresno | 19 | 2020-08-16 | 25290 | 203 | TRUE |
23374 | 23374 | Fresno | Fresno | 19 | 2020-08-15 | 25174 | 203 | |
23435 | 23435 | Fresno | Fresno | 19 | 2020-08-14 | 25040 | 203 | |
23496 | 23496 | Fresno | Fresno | 19 | 2020-08-13 | 24816 | 191 | |
23557 | 23557 | Fresno | Fresno | 19 | 2020-08-12 | 24586 | 191 | |
23618 | 23618 | Fresno | Fresno | 19 | 2020-08-11 | 24266 | 191 | |
23679 | 23679 | Fresno | Fresno | 19 | 2020-08-10 | 23988 | 171 | |
23740 | 23740 | Fresno | Fresno | 19 | 2020-08-09 | 23682 | 171 | TRUE |
23801 | 23801 | Fresno | Fresno | 19 | 2020-08-08 | 23547 | 171 | |
23862 | 23862 | Fresno | Fresno | 19 | 2020-08-07 | 23387 | 171 | |
23923 | 23923 | Fresno | Fresno | 19 | 2020-08-06 | 23091 | 157 | |
23984 | 23984 | Fresno | Fresno | 19 | 2020-08-05 | 22851 | 157 | |
24045 | 24045 | Fresno | Fresno | 19 | 2020-08-04 | 22569 | 157 | |
24106 | 24106 | Fresno | Fresno | 19 | 2020-08-03 | 22275 | 138 | |
24167 | 24167 | Fresno | Fresno | 19 | 2020-08-02 | 22000 | 138 | TRUE |
24228 | 24228 | Fresno | Fresno | 19 | 2020-08-01 | 21863 | 138 | |
24289 | 24289 | Fresno | Fresno | 19 | 2020-07-31 | 21644 | 138 | |
24350 | 24350 | Fresno | Fresno | 19 | 2020-07-30 | 21310 | 120 | |
24411 | 24411 | Fresno | Fresno | 19 | 2020-07-29 | 21019 | 120 | |
24472 | 24472 | Fresno | Fresno | 19 | 2020-07-28 | 20686 | 120 | |
24533 | 24533 | Fresno | Fresno | 19 | 2020-07-27 | 20340 | 112 | |
24594 | 24594 | Fresno | Fresno | 19 | 2020-07-26 | 19950 | 112 | TRUE |
24655 | 24655 | Fresno | Fresno | 19 | 2020-07-25 | 19764 | 112 | |
24716 | 24716 | Fresno | Fresno | 19 | 2020-07-24 | 19538 | 112 | |
24777 | 24777 | Fresno | Fresno | 19 | 2020-07-23 | 19182 | 104 | |
24838 | 24838 | Fresno | Fresno | 19 | 2020-07-22 | 18823 | 104 | |
24899 | 24899 | Fresno | Fresno | 19 | 2020-07-21 | 18426 | 104 | |
24960 | 24960 | Fresno | Fresno | 19 | 2020-07-20 | 17985 | 100 | |
25021 | 25021 | Fresno | Fresno | 19 | 2020-07-19 | 17463 | 100 | 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 );