latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where fips = 75 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 1
- 75 · 459 ✖
county 1
- San Francisco 459
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5838 | 5838 | 2021-05-25 | San Francisco | 75 | 36605 | 542 | 27 | 0 |
5896 | 5896 | 2021-05-24 | San Francisco | 75 | 36578 | 542 | 15 | 0 |
5954 | 5954 | 2021-05-23 | San Francisco | 75 | 36563 | 542 | 16 | 0 |
6012 | 6012 | 2021-05-22 | San Francisco | 75 | 36547 | 542 | 16 | 1 |
6070 | 6070 | 2021-05-21 | San Francisco | 75 | 36531 | 541 | 15 | 0 |
6128 | 6128 | 2021-05-20 | San Francisco | 75 | 36516 | 541 | 11 | 0 |
6186 | 6186 | 2021-05-19 | San Francisco | 75 | 36505 | 541 | 18 | 0 |
6244 | 6244 | 2021-05-18 | San Francisco | 75 | 36487 | 541 | 0 | 1 |
6302 | 6302 | 2021-05-17 | San Francisco | 75 | 36487 | 540 | 0 | 0 |
6360 | 6360 | 2021-05-16 | San Francisco | 75 | 36487 | 540 | 5 | 0 |
6418 | 6418 | 2021-05-15 | San Francisco | 75 | 36482 | 540 | 68 | 0 |
6476 | 6476 | 2021-05-14 | San Francisco | 75 | 36414 | 540 | 14 | 1 |
6534 | 6534 | 2021-05-13 | San Francisco | 75 | 36400 | 539 | 17 | 0 |
6592 | 6592 | 2021-05-12 | San Francisco | 75 | 36383 | 539 | 23 | 1 |
6650 | 6650 | 2021-05-11 | San Francisco | 75 | 36360 | 538 | 40 | 0 |
6708 | 6708 | 2021-05-10 | San Francisco | 75 | 36320 | 538 | 11 | 0 |
6766 | 6766 | 2021-05-09 | San Francisco | 75 | 36309 | 538 | 25 | 0 |
6824 | 6824 | 2021-05-08 | San Francisco | 75 | 36284 | 538 | 24 | 0 |
6882 | 6882 | 2021-05-07 | San Francisco | 75 | 36260 | 538 | 12 | 0 |
6940 | 6940 | 2021-05-06 | San Francisco | 75 | 36248 | 538 | 14 | 0 |
6998 | 6998 | 2021-05-05 | San Francisco | 75 | 36234 | 538 | 33 | 1 |
7056 | 7056 | 2021-05-04 | San Francisco | 75 | 36201 | 537 | 55 | 1 |
7114 | 7114 | 2021-05-03 | San Francisco | 75 | 36146 | 536 | 21 | 0 |
7172 | 7172 | 2021-05-02 | San Francisco | 75 | 36125 | 536 | 14 | 0 |
7230 | 7230 | 2021-05-01 | San Francisco | 75 | 36111 | 536 | 37 | 2 |
7288 | 7288 | 2021-04-30 | San Francisco | 75 | 36074 | 534 | 12 | 0 |
7346 | 7346 | 2021-04-29 | San Francisco | 75 | 36062 | 534 | 18 | 3 |
7404 | 7404 | 2021-04-28 | San Francisco | 75 | 36044 | 531 | 30 | 0 |
7462 | 7462 | 2021-04-27 | San Francisco | 75 | 36014 | 531 | 36 | 0 |
7520 | 7520 | 2021-04-26 | San Francisco | 75 | 35978 | 531 | 13 | 0 |
7578 | 7578 | 2021-04-25 | San Francisco | 75 | 35965 | 531 | 34 | 0 |
7636 | 7636 | 2021-04-24 | San Francisco | 75 | 35931 | 531 | 38 | 0 |
7694 | 7694 | 2021-04-23 | San Francisco | 75 | 35893 | 531 | 12 | 3 |
7752 | 7752 | 2021-04-22 | San Francisco | 75 | 35881 | 528 | 31 | 0 |
7810 | 7810 | 2021-04-21 | San Francisco | 75 | 35850 | 528 | 34 | 0 |
7868 | 7868 | 2021-04-20 | San Francisco | 75 | 35816 | 528 | 70 | 11 |
7926 | 7926 | 2021-04-19 | San Francisco | 75 | 35746 | 517 | 52 | 0 |
7984 | 7984 | 2021-04-18 | San Francisco | 75 | 35694 | 517 | 0 | 0 |
8042 | 8042 | 2021-04-17 | San Francisco | 75 | 35694 | 517 | 41 | 0 |
8100 | 8100 | 2021-04-16 | San Francisco | 75 | 35653 | 517 | 0 | 4 |
8158 | 8158 | 2021-04-15 | San Francisco | 75 | 35653 | 513 | 19 | 6 |
8216 | 8216 | 2021-04-14 | San Francisco | 75 | 35634 | 507 | 35 | 5 |
8274 | 8274 | 2021-04-13 | San Francisco | 75 | 35599 | 502 | 23 | 0 |
8332 | 8332 | 2021-04-12 | San Francisco | 75 | 35576 | 502 | 94 | 6 |
8390 | 8390 | 2021-04-11 | San Francisco | 75 | 35482 | 496 | 0 | 0 |
8448 | 8448 | 2021-04-10 | San Francisco | 75 | 35482 | 496 | 57 | 3 |
8506 | 8506 | 2021-04-09 | San Francisco | 75 | 35425 | 493 | 20 | 6 |
8564 | 8564 | 2021-04-08 | San Francisco | 75 | 35405 | 487 | 49 | 2 |
8622 | 8622 | 2021-04-07 | San Francisco | 75 | 35356 | 485 | 27 | 3 |
8680 | 8680 | 2021-04-06 | San Francisco | 75 | 35329 | 482 | 17 | 0 |
8738 | 8738 | 2021-04-05 | San Francisco | 75 | 35312 | 482 | 92 | 6 |
8796 | 8796 | 2021-04-04 | San Francisco | 75 | 35220 | 476 | 0 | 0 |
8854 | 8854 | 2021-04-03 | San Francisco | 75 | 35220 | 476 | 50 | 2 |
8912 | 8912 | 2021-04-02 | San Francisco | 75 | 35170 | 474 | 41 | 3 |
8970 | 8970 | 2021-04-01 | San Francisco | 75 | 35129 | 471 | 46 | 8 |
9028 | 9028 | 2021-03-31 | San Francisco | 75 | 35083 | 463 | 18 | 0 |
9086 | 9086 | 2021-03-30 | San Francisco | 75 | 35065 | 463 | 36 | 0 |
9144 | 9144 | 2021-03-29 | San Francisco | 75 | 35029 | 463 | 58 | 0 |
9202 | 9202 | 2021-03-28 | San Francisco | 75 | 34971 | 463 | 0 | 0 |
9260 | 9260 | 2021-03-27 | San Francisco | 75 | 34971 | 463 | 41 | 2 |
9318 | 9318 | 2021-03-26 | San Francisco | 75 | 34930 | 461 | 41 | 6 |
9376 | 9376 | 2021-03-25 | San Francisco | 75 | 34889 | 455 | 49 | 4 |
9434 | 9434 | 2021-03-24 | San Francisco | 75 | 34840 | 451 | 35 | 0 |
9492 | 9492 | 2021-03-23 | San Francisco | 75 | 34805 | 451 | 24 | 0 |
9550 | 9550 | 2021-03-22 | San Francisco | 75 | 34781 | 451 | 71 | 0 |
9608 | 9608 | 2021-03-21 | San Francisco | 75 | 34710 | 451 | 0 | 0 |
9666 | 9666 | 2021-03-20 | San Francisco | 75 | 34710 | 451 | 33 | 0 |
9724 | 9724 | 2021-03-19 | San Francisco | 75 | 34677 | 451 | 54 | 4 |
9782 | 9782 | 2021-03-18 | San Francisco | 75 | 34623 | 447 | 34 | 0 |
9840 | 9840 | 2021-03-17 | San Francisco | 75 | 34589 | 447 | 16 | 1 |
9898 | 9898 | 2021-03-16 | San Francisco | 75 | 34573 | 446 | 0 | 0 |
9956 | 9956 | 2021-03-15 | San Francisco | 75 | 34573 | 446 | 46 | 1 |
10014 | 10014 | 2021-03-14 | San Francisco | 75 | 34527 | 445 | 0 | 0 |
10072 | 10072 | 2021-03-13 | San Francisco | 75 | 34527 | 445 | 32 | 0 |
10130 | 10130 | 2021-03-12 | San Francisco | 75 | 34495 | 445 | 32 | 5 |
10188 | 10188 | 2021-03-11 | San Francisco | 75 | 34463 | 440 | 41 | 0 |
10246 | 10246 | 2021-03-10 | San Francisco | 75 | 34422 | 440 | 22 | 4 |
10304 | 10304 | 2021-03-09 | San Francisco | 75 | 34400 | 436 | 41 | 0 |
10362 | 10362 | 2021-03-08 | San Francisco | 75 | 34359 | 436 | 73 | 4 |
10420 | 10420 | 2021-03-07 | San Francisco | 75 | 34286 | 432 | 0 | 0 |
10478 | 10478 | 2021-03-06 | San Francisco | 75 | 34286 | 432 | 41 | 6 |
10536 | 10536 | 2021-03-05 | San Francisco | 75 | 34245 | 426 | 38 | 3 |
10594 | 10594 | 2021-03-04 | San Francisco | 75 | 34207 | 423 | 54 | 1 |
10652 | 10652 | 2021-03-03 | San Francisco | 75 | 34153 | 422 | 39 | 0 |
10710 | 10710 | 2021-03-02 | San Francisco | 75 | 34114 | 422 | 44 | 0 |
10768 | 10768 | 2021-03-01 | San Francisco | 75 | 34070 | 422 | 36 | 0 |
10826 | 10826 | 2021-02-28 | San Francisco | 75 | 34034 | 422 | 64 | 10 |
10884 | 10884 | 2021-02-27 | San Francisco | 75 | 33970 | 412 | 60 | 2 |
10942 | 10942 | 2021-02-26 | San Francisco | 75 | 33910 | 410 | 131 | 12 |
11000 | 11000 | 2021-02-25 | San Francisco | 75 | 33779 | 398 | 58 | 4 |
11058 | 11058 | 2021-02-24 | San Francisco | 75 | 33721 | 394 | 58 | 0 |
11116 | 11116 | 2021-02-23 | San Francisco | 75 | 33663 | 394 | 50 | 0 |
11174 | 11174 | 2021-02-22 | San Francisco | 75 | 33613 | 394 | 54 | 0 |
11232 | 11232 | 2021-02-21 | San Francisco | 75 | 33559 | 394 | 88 | 0 |
11290 | 11290 | 2021-02-20 | San Francisco | 75 | 33471 | 394 | 74 | 7 |
11348 | 11348 | 2021-02-19 | San Francisco | 75 | 33397 | 387 | 90 | 11 |
11406 | 11406 | 2021-02-18 | San Francisco | 75 | 33307 | 376 | 96 | 0 |
11464 | 11464 | 2021-02-17 | San Francisco | 75 | 33211 | 376 | 52 | 4 |
11522 | 11522 | 2021-02-16 | San Francisco | 75 | 33159 | 372 | 60 | 6 |
11580 | 11580 | 2021-02-15 | San Francisco | 75 | 33099 | 366 | 69 | 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 );