latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
555 rows where fips = 19 sorted by new_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths ▼ |
---|---|---|---|---|---|---|---|---|
9232 | 9232 | 2021-03-27 | Fresno | 19 | 98821 | 1592 | 61 | 0 |
9406 | 9406 | 2021-03-24 | Fresno | 19 | 98554 | 1571 | 110 | 0 |
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 |
9928 | 9928 | 2021-03-15 | Fresno | 19 | 97637 | 1534 | 107 | 0 |
9986 | 9986 | 2021-03-14 | Fresno | 19 | 97530 | 1534 | 59 | 0 |
10334 | 10334 | 2021-03-08 | Fresno | 19 | 96945 | 1488 | 175 | 0 |
10392 | 10392 | 2021-03-07 | Fresno | 19 | 96770 | 1488 | 91 | 0 |
10624 | 10624 | 2021-03-03 | Fresno | 19 | 96269 | 1451 | 144 | 0 |
10740 | 10740 | 2021-03-01 | Fresno | 19 | 95988 | 1443 | 176 | 0 |
10798 | 10798 | 2021-02-28 | Fresno | 19 | 95812 | 1443 | 73 | 0 |
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 |
11552 | 11552 | 2021-02-15 | Fresno | 19 | 93988 | 1291 | 165 | 0 |
11610 | 11610 | 2021-02-14 | Fresno | 19 | 93823 | 1291 | 107 | 0 |
11668 | 11668 | 2021-02-13 | Fresno | 19 | 93716 | 1291 | 148 | 0 |
11726 | 11726 | 2021-02-12 | Fresno | 19 | 93568 | 1291 | 153 | 0 |
12016 | 12016 | 2021-02-07 | Fresno | 19 | 92573 | 1224 | 110 | 0 |
12074 | 12074 | 2021-02-06 | Fresno | 19 | 92463 | 1224 | 204 | 0 |
12132 | 12132 | 2021-02-05 | Fresno | 19 | 92259 | 1224 | 212 | 0 |
12422 | 12422 | 2021-01-31 | Fresno | 19 | 90888 | 1137 | 178 | 0 |
12480 | 12480 | 2021-01-30 | Fresno | 19 | 90710 | 1137 | 210 | 0 |
12538 | 12538 | 2021-01-29 | Fresno | 19 | 90500 | 1137 | 286 | 0 |
12828 | 12828 | 2021-01-24 | Fresno | 19 | 88761 | 1043 | 183 | 0 |
12886 | 12886 | 2021-01-23 | Fresno | 19 | 88578 | 1043 | 335 | 0 |
13060 | 13060 | 2021-01-20 | Fresno | 19 | 87419 | 968 | 514 | 0 |
13176 | 13176 | 2021-01-18 | Fresno | 19 | 86297 | 932 | 554 | 0 |
13234 | 13234 | 2021-01-17 | Fresno | 19 | 85743 | 932 | 271 | 0 |
13292 | 13292 | 2021-01-16 | Fresno | 19 | 85472 | 932 | 538 | 0 |
13466 | 13466 | 2021-01-13 | Fresno | 19 | 83595 | 846 | 863 | 0 |
13640 | 13640 | 2021-01-10 | Fresno | 19 | 81047 | 711 | 408 | 0 |
13698 | 13698 | 2021-01-09 | Fresno | 19 | 80639 | 711 | 814 | 0 |
13756 | 13756 | 2021-01-08 | Fresno | 19 | 79825 | 711 | 950 | 0 |
13814 | 13814 | 2021-01-07 | Fresno | 19 | 78875 | 711 | 842 | 0 |
13872 | 13872 | 2021-01-06 | Fresno | 19 | 78033 | 711 | 1231 | 0 |
13930 | 13930 | 2021-01-05 | Fresno | 19 | 76802 | 711 | 1258 | 0 |
13988 | 13988 | 2021-01-04 | Fresno | 19 | 75544 | 711 | 1146 | 0 |
14046 | 14046 | 2021-01-03 | Fresno | 19 | 74398 | 711 | 532 | 0 |
14104 | 14104 | 2021-01-02 | Fresno | 19 | 73866 | 711 | 1065 | 0 |
14220 | 14220 | 2020-12-31 | Fresno | 19 | 72383 | 646 | 838 | 0 |
14278 | 14278 | 2020-12-30 | Fresno | 19 | 71545 | 646 | 1367 | 0 |
14336 | 14336 | 2020-12-29 | Fresno | 19 | 70178 | 646 | 1265 | 0 |
14394 | 14394 | 2020-12-28 | Fresno | 19 | 68913 | 646 | 1237 | 0 |
14452 | 14452 | 2020-12-27 | Fresno | 19 | 67676 | 646 | 466 | 0 |
14510 | 14510 | 2020-12-26 | Fresno | 19 | 67210 | 646 | 861 | 0 |
14568 | 14568 | 2020-12-25 | Fresno | 19 | 66349 | 646 | 223 | 0 |
14626 | 14626 | 2020-12-24 | Fresno | 19 | 66126 | 646 | 605 | 0 |
14684 | 14684 | 2020-12-23 | Fresno | 19 | 65521 | 646 | 1028 | 0 |
14800 | 14800 | 2020-12-21 | Fresno | 19 | 63350 | 557 | 981 | 0 |
14858 | 14858 | 2020-12-20 | Fresno | 19 | 62369 | 557 | 321 | 0 |
14916 | 14916 | 2020-12-19 | Fresno | 19 | 62048 | 557 | 828 | 0 |
14974 | 14974 | 2020-12-18 | Fresno | 19 | 61220 | 557 | 859 | 0 |
15032 | 15032 | 2020-12-17 | Fresno | 19 | 60361 | 557 | 952 | 0 |
15090 | 15090 | 2020-12-16 | Fresno | 19 | 59409 | 557 | 1370 | 0 |
15206 | 15206 | 2020-12-14 | Fresno | 19 | 57022 | 542 | 1104 | 0 |
15264 | 15264 | 2020-12-13 | Fresno | 19 | 55918 | 542 | 350 | 0 |
15322 | 15322 | 2020-12-12 | Fresno | 19 | 55568 | 542 | 1008 | 0 |
15438 | 15438 | 2020-12-10 | Fresno | 19 | 53589 | 514 | 998 | 0 |
15496 | 15496 | 2020-12-09 | Fresno | 19 | 52591 | 514 | 1256 | 0 |
15612 | 15612 | 2020-12-07 | Fresno | 19 | 49873 | 506 | 944 | 0 |
15670 | 15670 | 2020-12-06 | Fresno | 19 | 48929 | 506 | 319 | 0 |
15728 | 15728 | 2020-12-05 | Fresno | 19 | 48610 | 506 | 710 | 0 |
15844 | 15844 | 2020-12-03 | Fresno | 19 | 47155 | 488 | 742 | 0 |
15902 | 15902 | 2020-12-02 | Fresno | 19 | 46413 | 488 | 896 | 0 |
16018 | 16018 | 2020-11-30 | Fresno | 19 | 44413 | 481 | 945 | 0 |
16076 | 16076 | 2020-11-29 | Fresno | 19 | 43468 | 481 | 343 | 0 |
16134 | 16134 | 2020-11-28 | Fresno | 19 | 43125 | 481 | 404 | 0 |
16250 | 16250 | 2020-11-26 | Fresno | 19 | 42322 | 477 | 232 | 0 |
16308 | 16308 | 2020-11-25 | Fresno | 19 | 42090 | 477 | 400 | 0 |
16424 | 16424 | 2020-11-23 | Fresno | 19 | 41243 | 471 | 480 | 0 |
16482 | 16482 | 2020-11-22 | Fresno | 19 | 40763 | 471 | 255 | 0 |
16540 | 16540 | 2020-11-21 | Fresno | 19 | 40508 | 471 | 291 | 0 |
16656 | 16656 | 2020-11-19 | Fresno | 19 | 39774 | 463 | 437 | 0 |
16714 | 16714 | 2020-11-18 | Fresno | 19 | 39337 | 463 | 592 | 0 |
16830 | 16830 | 2020-11-16 | Fresno | 19 | 38260 | 460 | 507 | 0 |
16888 | 16888 | 2020-11-15 | Fresno | 19 | 37753 | 460 | 249 | 0 |
16946 | 16946 | 2020-11-14 | Fresno | 19 | 37504 | 460 | 247 | 0 |
17062 | 17062 | 2020-11-12 | Fresno | 19 | 36914 | 456 | 318 | 0 |
17120 | 17120 | 2020-11-11 | Fresno | 19 | 36596 | 456 | 267 | 0 |
17236 | 17236 | 2020-11-09 | Fresno | 19 | 36022 | 454 | 332 | 0 |
17294 | 17294 | 2020-11-08 | Fresno | 19 | 35690 | 454 | 153 | 0 |
17352 | 17352 | 2020-11-07 | Fresno | 19 | 35537 | 454 | 188 | 0 |
17468 | 17468 | 2020-11-05 | Fresno | 19 | 35117 | 447 | 225 | 0 |
17526 | 17526 | 2020-11-04 | Fresno | 19 | 34892 | 447 | 263 | 0 |
17642 | 17642 | 2020-11-02 | Fresno | 19 | 34363 | 443 | 254 | 0 |
17700 | 17700 | 2020-11-01 | Fresno | 19 | 34109 | 443 | 136 | 0 |
17758 | 17758 | 2020-10-31 | Fresno | 19 | 33973 | 443 | 120 | 0 |
17874 | 17874 | 2020-10-29 | Fresno | 19 | 33698 | 439 | 119 | 0 |
17932 | 17932 | 2020-10-28 | Fresno | 19 | 33579 | 439 | 114 | 0 |
18048 | 18048 | 2020-10-26 | Fresno | 19 | 33353 | 436 | 128 | 0 |
18106 | 18106 | 2020-10-25 | Fresno | 19 | 33225 | 436 | 61 | 0 |
18164 | 18164 | 2020-10-24 | Fresno | 19 | 33164 | 436 | 67 | 0 |
18280 | 18280 | 2020-10-22 | Fresno | 19 | 32990 | 430 | 94 | 0 |
18338 | 18338 | 2020-10-21 | Fresno | 19 | 32896 | 430 | 102 | 0 |
18454 | 18454 | 2020-10-19 | Fresno | 19 | 32686 | 429 | 124 | 0 |
18512 | 18512 | 2020-10-18 | Fresno | 19 | 32562 | 429 | 54 | 0 |
18570 | 18570 | 2020-10-17 | Fresno | 19 | 32508 | 429 | 75 | 0 |
18686 | 18686 | 2020-10-15 | Fresno | 19 | 32340 | 424 | 112 | 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 );