latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
555 rows where county = "Fresno" 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 |
---|---|---|---|---|---|---|---|---|
5810 | 5810 | 2021-05-25 | Fresno | 19 | 101771 | 1698 | 39 | 0 |
5868 | 5868 | 2021-05-24 | Fresno | 19 | 101732 | 1698 | 44 | 0 |
5926 | 5926 | 2021-05-23 | Fresno | 19 | 101688 | 1698 | 14 | 0 |
5984 | 5984 | 2021-05-22 | Fresno | 19 | 101674 | 1698 | 28 | 2 |
6042 | 6042 | 2021-05-21 | Fresno | 19 | 101646 | 1696 | 20 | 3 |
6100 | 6100 | 2021-05-20 | Fresno | 19 | 101626 | 1693 | 29 | 3 |
6158 | 6158 | 2021-05-19 | Fresno | 19 | 101597 | 1690 | 37 | 0 |
6216 | 6216 | 2021-05-18 | Fresno | 19 | 101560 | 1690 | 43 | 0 |
6274 | 6274 | 2021-05-17 | Fresno | 19 | 101517 | 1690 | 43 | 0 |
6332 | 6332 | 2021-05-16 | Fresno | 19 | 101474 | 1690 | 35 | 2 |
6390 | 6390 | 2021-05-15 | Fresno | 19 | 101439 | 1688 | 28 | 1 |
6448 | 6448 | 2021-05-14 | Fresno | 19 | 101411 | 1687 | 28 | 0 |
6506 | 6506 | 2021-05-13 | Fresno | 19 | 101383 | 1687 | 47 | 1 |
6564 | 6564 | 2021-05-12 | Fresno | 19 | 101336 | 1686 | 44 | 4 |
6622 | 6622 | 2021-05-11 | Fresno | 19 | 101292 | 1682 | 31 | 0 |
6680 | 6680 | 2021-05-10 | Fresno | 19 | 101261 | 1682 | 38 | 0 |
6738 | 6738 | 2021-05-09 | Fresno | 19 | 101223 | 1682 | 35 | 0 |
6796 | 6796 | 2021-05-08 | Fresno | 19 | 101188 | 1682 | 32 | 2 |
6854 | 6854 | 2021-05-07 | Fresno | 19 | 101156 | 1680 | 41 | 0 |
6912 | 6912 | 2021-05-06 | Fresno | 19 | 101115 | 1680 | 49 | 3 |
6970 | 6970 | 2021-05-05 | Fresno | 19 | 101066 | 1677 | 54 | 0 |
7028 | 7028 | 2021-05-04 | Fresno | 19 | 101012 | 1677 | 53 | 0 |
7086 | 7086 | 2021-05-03 | Fresno | 19 | 100959 | 1677 | 71 | 0 |
7144 | 7144 | 2021-05-02 | Fresno | 19 | 100888 | 1677 | 45 | 7 |
7202 | 7202 | 2021-05-01 | Fresno | 19 | 100843 | 1670 | 46 | 3 |
7260 | 7260 | 2021-04-30 | Fresno | 19 | 100797 | 1667 | 54 | 1 |
7318 | 7318 | 2021-04-29 | Fresno | 19 | 100743 | 1666 | 46 | 3 |
7376 | 7376 | 2021-04-28 | Fresno | 19 | 100697 | 1663 | 63 | 1 |
7434 | 7434 | 2021-04-27 | Fresno | 19 | 100634 | 1662 | 55 | 0 |
7492 | 7492 | 2021-04-26 | Fresno | 19 | 100579 | 1662 | 58 | 0 |
7550 | 7550 | 2021-04-25 | Fresno | 19 | 100521 | 1662 | 31 | 0 |
7608 | 7608 | 2021-04-24 | Fresno | 19 | 100490 | 1662 | 40 | 5 |
7666 | 7666 | 2021-04-23 | Fresno | 19 | 100450 | 1657 | 44 | 3 |
7724 | 7724 | 2021-04-22 | Fresno | 19 | 100406 | 1654 | 55 | 4 |
7782 | 7782 | 2021-04-21 | Fresno | 19 | 100351 | 1650 | 57 | 4 |
7840 | 7840 | 2021-04-20 | Fresno | 19 | 100294 | 1646 | 68 | 0 |
7898 | 7898 | 2021-04-19 | Fresno | 19 | 100226 | 1646 | 57 | 0 |
7956 | 7956 | 2021-04-18 | Fresno | 19 | 100169 | 1646 | 31 | 3 |
8014 | 8014 | 2021-04-17 | Fresno | 19 | 100138 | 1643 | 49 | 1 |
8072 | 8072 | 2021-04-16 | Fresno | 19 | 100089 | 1642 | 59 | 2 |
8130 | 8130 | 2021-04-15 | Fresno | 19 | 100030 | 1640 | 56 | 4 |
8188 | 8188 | 2021-04-14 | Fresno | 19 | 99974 | 1636 | 80 | 3 |
8246 | 8246 | 2021-04-13 | Fresno | 19 | 99894 | 1633 | 61 | 0 |
8304 | 8304 | 2021-04-12 | Fresno | 19 | 99833 | 1633 | 66 | 3 |
8362 | 8362 | 2021-04-11 | Fresno | 19 | 99767 | 1630 | 33 | 0 |
8420 | 8420 | 2021-04-10 | Fresno | 19 | 99734 | 1630 | 34 | 3 |
8478 | 8478 | 2021-04-09 | Fresno | 19 | 99700 | 1627 | 63 | 0 |
8536 | 8536 | 2021-04-08 | Fresno | 19 | 99637 | 1627 | 63 | 1 |
8594 | 8594 | 2021-04-07 | Fresno | 19 | 99574 | 1626 | 64 | 4 |
8652 | 8652 | 2021-04-06 | Fresno | 19 | 99510 | 1622 | 84 | 25 |
8710 | 8710 | 2021-04-05 | Fresno | 19 | 99426 | 1597 | 74 | 0 |
8768 | 8768 | 2021-04-04 | Fresno | 19 | 99352 | 1597 | 56 | 0 |
8826 | 8826 | 2021-04-03 | Fresno | 19 | 99296 | 1597 | 54 | 0 |
8884 | 8884 | 2021-04-02 | Fresno | 19 | 99242 | 1597 | 51 | 1 |
8942 | 8942 | 2021-04-01 | Fresno | 19 | 99191 | 1596 | 90 | 3 |
9000 | 9000 | 2021-03-31 | Fresno | 19 | 99101 | 1593 | 64 | 0 |
9058 | 9058 | 2021-03-30 | Fresno | 19 | 99037 | 1593 | 83 | 1 |
9116 | 9116 | 2021-03-29 | Fresno | 19 | 98954 | 1592 | 81 | 0 |
9174 | 9174 | 2021-03-28 | Fresno | 19 | 98873 | 1592 | 52 | 0 |
9232 | 9232 | 2021-03-27 | Fresno | 19 | 98821 | 1592 | 61 | 0 |
9290 | 9290 | 2021-03-26 | Fresno | 19 | 98760 | 1592 | 116 | 2 |
9348 | 9348 | 2021-03-25 | Fresno | 19 | 98644 | 1590 | 90 | 19 |
9406 | 9406 | 2021-03-24 | Fresno | 19 | 98554 | 1571 | 110 | 0 |
9464 | 9464 | 2021-03-23 | Fresno | 19 | 98444 | 1571 | 96 | 3 |
9522 | 9522 | 2021-03-22 | Fresno | 19 | 98348 | 1568 | 111 | 22 |
9580 | 9580 | 2021-03-21 | Fresno | 19 | 98237 | 1546 | 60 | 0 |
9638 | 9638 | 2021-03-20 | Fresno | 19 | 98177 | 1546 | 81 | 0 |
9696 | 9696 | 2021-03-19 | Fresno | 19 | 98096 | 1546 | 94 | 0 |
9754 | 9754 | 2021-03-18 | Fresno | 19 | 98002 | 1546 | 110 | 3 |
9812 | 9812 | 2021-03-17 | Fresno | 19 | 97892 | 1543 | 130 | 8 |
9870 | 9870 | 2021-03-16 | Fresno | 19 | 97762 | 1535 | 125 | 1 |
9928 | 9928 | 2021-03-15 | Fresno | 19 | 97637 | 1534 | 107 | 0 |
9986 | 9986 | 2021-03-14 | Fresno | 19 | 97530 | 1534 | 59 | 0 |
10044 | 10044 | 2021-03-13 | Fresno | 19 | 97471 | 1534 | 95 | 7 |
10102 | 10102 | 2021-03-12 | Fresno | 19 | 97376 | 1527 | 114 | 8 |
10160 | 10160 | 2021-03-11 | Fresno | 19 | 97262 | 1519 | 106 | 10 |
10218 | 10218 | 2021-03-10 | Fresno | 19 | 97156 | 1509 | 118 | 4 |
10276 | 10276 | 2021-03-09 | Fresno | 19 | 97038 | 1505 | 93 | 17 |
10334 | 10334 | 2021-03-08 | Fresno | 19 | 96945 | 1488 | 175 | 0 |
10392 | 10392 | 2021-03-07 | Fresno | 19 | 96770 | 1488 | 91 | 0 |
10450 | 10450 | 2021-03-06 | Fresno | 19 | 96679 | 1488 | 106 | 22 |
10508 | 10508 | 2021-03-05 | Fresno | 19 | 96573 | 1466 | 163 | 8 |
10566 | 10566 | 2021-03-04 | Fresno | 19 | 96410 | 1458 | 141 | 7 |
10624 | 10624 | 2021-03-03 | Fresno | 19 | 96269 | 1451 | 144 | 0 |
10682 | 10682 | 2021-03-02 | Fresno | 19 | 96125 | 1451 | 137 | 8 |
10740 | 10740 | 2021-03-01 | Fresno | 19 | 95988 | 1443 | 176 | 0 |
10798 | 10798 | 2021-02-28 | Fresno | 19 | 95812 | 1443 | 73 | 0 |
10856 | 10856 | 2021-02-27 | Fresno | 19 | 95739 | 1443 | 104 | 21 |
10914 | 10914 | 2021-02-26 | Fresno | 19 | 95635 | 1422 | 143 | 10 |
10972 | 10972 | 2021-02-25 | Fresno | 19 | 95492 | 1412 | 146 | 11 |
11030 | 11030 | 2021-02-24 | Fresno | 19 | 95346 | 1401 | 161 | 4 |
11088 | 11088 | 2021-02-23 | Fresno | 19 | 95185 | 1397 | 164 | 30 |
11146 | 11146 | 2021-02-22 | Fresno | 19 | 95021 | 1367 | 146 | 0 |
11204 | 11204 | 2021-02-21 | Fresno | 19 | 94875 | 1367 | 87 | 0 |
11262 | 11262 | 2021-02-20 | Fresno | 19 | 94788 | 1367 | 130 | 0 |
11320 | 11320 | 2021-02-19 | Fresno | 19 | 94658 | 1367 | 168 | 11 |
11378 | 11378 | 2021-02-18 | Fresno | 19 | 94490 | 1356 | 132 | 7 |
11436 | 11436 | 2021-02-17 | Fresno | 19 | 94358 | 1349 | 171 | 8 |
11494 | 11494 | 2021-02-16 | Fresno | 19 | 94187 | 1341 | 199 | 50 |
11552 | 11552 | 2021-02-15 | Fresno | 19 | 93988 | 1291 | 165 | 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 );