latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
555 rows where agency = "Fresno" 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 |
---|---|---|---|---|---|---|---|---|
6111 | 6111 | Fresno | Fresno | 19 | 2021-05-25 | 101771 | 1698 | |
6172 | 6172 | Fresno | Fresno | 19 | 2021-05-24 | 101732 | 1698 | |
6233 | 6233 | Fresno | Fresno | 19 | 2021-05-23 | 101688 | 1698 | |
6294 | 6294 | Fresno | Fresno | 19 | 2021-05-22 | 101674 | 1698 | |
6355 | 6355 | Fresno | Fresno | 19 | 2021-05-21 | 101646 | 1696 | |
6416 | 6416 | Fresno | Fresno | 19 | 2021-05-20 | 101626 | 1693 | |
6477 | 6477 | Fresno | Fresno | 19 | 2021-05-19 | 101597 | 1690 | |
6538 | 6538 | Fresno | Fresno | 19 | 2021-05-18 | 101560 | 1690 | |
6599 | 6599 | Fresno | Fresno | 19 | 2021-05-17 | 101517 | 1690 | |
6660 | 6660 | Fresno | Fresno | 19 | 2021-05-16 | 101474 | 1690 | |
6721 | 6721 | Fresno | Fresno | 19 | 2021-05-15 | 101439 | 1688 | |
6782 | 6782 | Fresno | Fresno | 19 | 2021-05-14 | 101411 | 1687 | |
6843 | 6843 | Fresno | Fresno | 19 | 2021-05-13 | 101383 | 1687 | |
6904 | 6904 | Fresno | Fresno | 19 | 2021-05-12 | 101336 | 1686 | |
6965 | 6965 | Fresno | Fresno | 19 | 2021-05-11 | 101292 | 1682 | |
7026 | 7026 | Fresno | Fresno | 19 | 2021-05-10 | 101261 | 1682 | |
7087 | 7087 | Fresno | Fresno | 19 | 2021-05-09 | 101223 | 1682 | |
7148 | 7148 | Fresno | Fresno | 19 | 2021-05-08 | 101188 | 1682 | |
7209 | 7209 | Fresno | Fresno | 19 | 2021-05-07 | 101156 | 1680 | |
7270 | 7270 | Fresno | Fresno | 19 | 2021-05-06 | 101115 | 1680 | |
7331 | 7331 | Fresno | Fresno | 19 | 2021-05-05 | 101066 | 1677 | |
7392 | 7392 | Fresno | Fresno | 19 | 2021-05-04 | 101012 | 1677 | |
7453 | 7453 | Fresno | Fresno | 19 | 2021-05-03 | 100959 | 1677 | |
7514 | 7514 | Fresno | Fresno | 19 | 2021-05-02 | 100888 | 1677 | |
7575 | 7575 | Fresno | Fresno | 19 | 2021-05-01 | 100843 | 1670 | |
7636 | 7636 | Fresno | Fresno | 19 | 2021-04-30 | 100797 | 1667 | |
7697 | 7697 | Fresno | Fresno | 19 | 2021-04-29 | 100743 | 1666 | |
7758 | 7758 | Fresno | Fresno | 19 | 2021-04-28 | 100697 | 1663 | |
7819 | 7819 | Fresno | Fresno | 19 | 2021-04-27 | 100634 | 1662 | |
7880 | 7880 | Fresno | Fresno | 19 | 2021-04-26 | 100579 | 1662 | |
7941 | 7941 | Fresno | Fresno | 19 | 2021-04-25 | 100521 | 1662 | |
8002 | 8002 | Fresno | Fresno | 19 | 2021-04-24 | 100490 | 1662 | |
8063 | 8063 | Fresno | Fresno | 19 | 2021-04-23 | 100450 | 1657 | |
8124 | 8124 | Fresno | Fresno | 19 | 2021-04-22 | 100406 | 1654 | |
8185 | 8185 | Fresno | Fresno | 19 | 2021-04-21 | 100351 | 1650 | |
8246 | 8246 | Fresno | Fresno | 19 | 2021-04-20 | 100294 | 1646 | |
8307 | 8307 | Fresno | Fresno | 19 | 2021-04-19 | 100226 | 1646 | |
8368 | 8368 | Fresno | Fresno | 19 | 2021-04-18 | 100169 | 1646 | |
8429 | 8429 | Fresno | Fresno | 19 | 2021-04-17 | 100138 | 1643 | |
8490 | 8490 | Fresno | Fresno | 19 | 2021-04-16 | 100089 | 1642 | |
8551 | 8551 | Fresno | Fresno | 19 | 2021-04-15 | 100030 | 1640 | |
8612 | 8612 | Fresno | Fresno | 19 | 2021-04-14 | 99974 | 1636 | |
8673 | 8673 | Fresno | Fresno | 19 | 2021-04-13 | 99894 | 1633 | |
8734 | 8734 | Fresno | Fresno | 19 | 2021-04-12 | 99833 | 1633 | |
8795 | 8795 | Fresno | Fresno | 19 | 2021-04-11 | 99767 | 1630 | TRUE |
8856 | 8856 | Fresno | Fresno | 19 | 2021-04-10 | 99734 | 1630 | |
8917 | 8917 | Fresno | Fresno | 19 | 2021-04-09 | 99700 | 1627 | |
8978 | 8978 | Fresno | Fresno | 19 | 2021-04-08 | 99637 | 1627 | |
9039 | 9039 | Fresno | Fresno | 19 | 2021-04-07 | 99574 | 1626 | |
9100 | 9100 | Fresno | Fresno | 19 | 2021-04-06 | 99510 | 1622 | |
9161 | 9161 | Fresno | Fresno | 19 | 2021-04-05 | 99426 | 1597 | |
9222 | 9222 | Fresno | Fresno | 19 | 2021-04-04 | 99352 | 1597 | TRUE |
9283 | 9283 | Fresno | Fresno | 19 | 2021-04-03 | 99296 | 1597 | |
9344 | 9344 | Fresno | Fresno | 19 | 2021-04-02 | 99242 | 1597 | |
9405 | 9405 | Fresno | Fresno | 19 | 2021-04-01 | 99191 | 1596 | |
9466 | 9466 | Fresno | Fresno | 19 | 2021-03-31 | 99101 | 1593 | |
9527 | 9527 | Fresno | Fresno | 19 | 2021-03-30 | 99037 | 1593 | |
9588 | 9588 | Fresno | Fresno | 19 | 2021-03-29 | 98954 | 1592 | |
9649 | 9649 | Fresno | Fresno | 19 | 2021-03-28 | 98873 | 1592 | TRUE |
9710 | 9710 | Fresno | Fresno | 19 | 2021-03-27 | 98821 | 1592 | |
9771 | 9771 | Fresno | Fresno | 19 | 2021-03-26 | 98760 | 1592 | |
9832 | 9832 | Fresno | Fresno | 19 | 2021-03-25 | 98644 | 1590 | |
9893 | 9893 | Fresno | Fresno | 19 | 2021-03-24 | 98554 | 1571 | |
9954 | 9954 | Fresno | Fresno | 19 | 2021-03-23 | 98444 | 1571 | |
10015 | 10015 | Fresno | Fresno | 19 | 2021-03-22 | 98348 | 1568 | |
10076 | 10076 | Fresno | Fresno | 19 | 2021-03-21 | 98237 | 1546 | TRUE |
10137 | 10137 | Fresno | Fresno | 19 | 2021-03-20 | 98177 | 1546 | |
10198 | 10198 | Fresno | Fresno | 19 | 2021-03-19 | 98096 | 1546 | TRUE |
10259 | 10259 | Fresno | Fresno | 19 | 2021-03-18 | 98002 | 1546 | |
10320 | 10320 | Fresno | Fresno | 19 | 2021-03-17 | 97892 | 1543 | |
10381 | 10381 | Fresno | Fresno | 19 | 2021-03-16 | 97762 | 1535 | |
10442 | 10442 | Fresno | Fresno | 19 | 2021-03-15 | 97637 | 1534 | |
10503 | 10503 | Fresno | Fresno | 19 | 2021-03-14 | 97530 | 1534 | TRUE |
10564 | 10564 | Fresno | Fresno | 19 | 2021-03-13 | 97471 | 1534 | |
10625 | 10625 | Fresno | Fresno | 19 | 2021-03-12 | 97376 | 1527 | |
10686 | 10686 | Fresno | Fresno | 19 | 2021-03-11 | 97262 | 1519 | |
10747 | 10747 | Fresno | Fresno | 19 | 2021-03-10 | 97156 | 1509 | |
10808 | 10808 | Fresno | Fresno | 19 | 2021-03-09 | 97038 | 1505 | |
10869 | 10869 | Fresno | Fresno | 19 | 2021-03-08 | 96945 | 1488 | |
10930 | 10930 | Fresno | Fresno | 19 | 2021-03-07 | 96770 | 1488 | |
10991 | 10991 | Fresno | Fresno | 19 | 2021-03-06 | 96679 | 1488 | |
11052 | 11052 | Fresno | Fresno | 19 | 2021-03-05 | 96573 | 1466 | |
11113 | 11113 | Fresno | Fresno | 19 | 2021-03-04 | 96410 | 1458 | |
11174 | 11174 | Fresno | Fresno | 19 | 2021-03-03 | 96269 | 1451 | |
11235 | 11235 | Fresno | Fresno | 19 | 2021-03-02 | 96125 | 1451 | |
11296 | 11296 | Fresno | Fresno | 19 | 2021-03-01 | 95988 | 1443 | |
11357 | 11357 | Fresno | Fresno | 19 | 2021-02-28 | 95812 | 1443 | |
11418 | 11418 | Fresno | Fresno | 19 | 2021-02-27 | 95739 | 1443 | |
11479 | 11479 | Fresno | Fresno | 19 | 2021-02-26 | 95635 | 1422 | |
11540 | 11540 | Fresno | Fresno | 19 | 2021-02-25 | 95492 | 1412 | |
11601 | 11601 | Fresno | Fresno | 19 | 2021-02-24 | 95346 | 1401 | |
11662 | 11662 | Fresno | Fresno | 19 | 2021-02-23 | 95185 | 1397 | |
11723 | 11723 | Fresno | Fresno | 19 | 2021-02-22 | 95021 | 1367 | |
11784 | 11784 | Fresno | Fresno | 19 | 2021-02-21 | 94875 | 1367 | |
11845 | 11845 | Fresno | Fresno | 19 | 2021-02-20 | 94788 | 1367 | |
11906 | 11906 | Fresno | Fresno | 19 | 2021-02-19 | 94658 | 1367 | |
11967 | 11967 | Fresno | Fresno | 19 | 2021-02-18 | 94490 | 1356 | |
12028 | 12028 | Fresno | Fresno | 19 | 2021-02-17 | 94358 | 1349 | |
12089 | 12089 | Fresno | Fresno | 19 | 2021-02-16 | 94187 | 1341 | |
12150 | 12150 | Fresno | Fresno | 19 | 2021-02-15 | 93988 | 1291 | 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 );