latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where county = "San Francisco" 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 |
---|---|---|---|---|---|---|---|---|
6141 | 6141 | San Francisco | San Francisco | 75 | 2021-05-25 | 36605 | 542 | |
6202 | 6202 | San Francisco | San Francisco | 75 | 2021-05-24 | 36578 | 542 | |
6263 | 6263 | San Francisco | San Francisco | 75 | 2021-05-23 | 36563 | 542 | |
6324 | 6324 | San Francisco | San Francisco | 75 | 2021-05-22 | 36547 | 542 | |
6385 | 6385 | San Francisco | San Francisco | 75 | 2021-05-21 | 36531 | 541 | |
6446 | 6446 | San Francisco | San Francisco | 75 | 2021-05-20 | 36516 | 541 | |
6507 | 6507 | San Francisco | San Francisco | 75 | 2021-05-19 | 36505 | 541 | |
6568 | 6568 | San Francisco | San Francisco | 75 | 2021-05-18 | 36487 | 541 | |
6629 | 6629 | San Francisco | San Francisco | 75 | 2021-05-17 | 36487 | 540 | |
6690 | 6690 | San Francisco | San Francisco | 75 | 2021-05-16 | 36487 | 540 | |
6751 | 6751 | San Francisco | San Francisco | 75 | 2021-05-15 | 36482 | 540 | |
6812 | 6812 | San Francisco | San Francisco | 75 | 2021-05-14 | 36414 | 540 | |
6873 | 6873 | San Francisco | San Francisco | 75 | 2021-05-13 | 36400 | 539 | |
6934 | 6934 | San Francisco | San Francisco | 75 | 2021-05-12 | 36383 | 539 | |
6995 | 6995 | San Francisco | San Francisco | 75 | 2021-05-11 | 36360 | 538 | |
7056 | 7056 | San Francisco | San Francisco | 75 | 2021-05-10 | 36320 | 538 | |
7117 | 7117 | San Francisco | San Francisco | 75 | 2021-05-09 | 36309 | 538 | |
7178 | 7178 | San Francisco | San Francisco | 75 | 2021-05-08 | 36284 | 538 | |
7239 | 7239 | San Francisco | San Francisco | 75 | 2021-05-07 | 36260 | 538 | |
7300 | 7300 | San Francisco | San Francisco | 75 | 2021-05-06 | 36248 | 538 | |
7361 | 7361 | San Francisco | San Francisco | 75 | 2021-05-05 | 36234 | 538 | |
7422 | 7422 | San Francisco | San Francisco | 75 | 2021-05-04 | 36201 | 537 | |
7483 | 7483 | San Francisco | San Francisco | 75 | 2021-05-03 | 36146 | 536 | |
7544 | 7544 | San Francisco | San Francisco | 75 | 2021-05-02 | 36125 | 536 | |
7605 | 7605 | San Francisco | San Francisco | 75 | 2021-05-01 | 36111 | 536 | |
7666 | 7666 | San Francisco | San Francisco | 75 | 2021-04-30 | 36074 | 534 | |
7727 | 7727 | San Francisco | San Francisco | 75 | 2021-04-29 | 36062 | 534 | |
7788 | 7788 | San Francisco | San Francisco | 75 | 2021-04-28 | 36044 | 531 | |
7849 | 7849 | San Francisco | San Francisco | 75 | 2021-04-27 | 36014 | 531 | |
7910 | 7910 | San Francisco | San Francisco | 75 | 2021-04-26 | 35978 | 531 | |
7971 | 7971 | San Francisco | San Francisco | 75 | 2021-04-25 | 35965 | 531 | |
8032 | 8032 | San Francisco | San Francisco | 75 | 2021-04-24 | 35931 | 531 | |
8093 | 8093 | San Francisco | San Francisco | 75 | 2021-04-23 | 35893 | 531 | |
8154 | 8154 | San Francisco | San Francisco | 75 | 2021-04-22 | 35881 | 528 | |
8215 | 8215 | San Francisco | San Francisco | 75 | 2021-04-21 | 35850 | 528 | |
8276 | 8276 | San Francisco | San Francisco | 75 | 2021-04-20 | 35816 | 528 | |
8337 | 8337 | San Francisco | San Francisco | 75 | 2021-04-19 | 35746 | 517 | |
8398 | 8398 | San Francisco | San Francisco | 75 | 2021-04-18 | 35694 | 517 | TRUE |
8459 | 8459 | San Francisco | San Francisco | 75 | 2021-04-17 | 35694 | 517 | |
8520 | 8520 | San Francisco | San Francisco | 75 | 2021-04-16 | 35653 | 517 | |
8581 | 8581 | San Francisco | San Francisco | 75 | 2021-04-15 | 35653 | 513 | |
8642 | 8642 | San Francisco | San Francisco | 75 | 2021-04-14 | 35634 | 507 | |
8703 | 8703 | San Francisco | San Francisco | 75 | 2021-04-13 | 35599 | 502 | |
8764 | 8764 | San Francisco | San Francisco | 75 | 2021-04-12 | 35576 | 502 | |
8825 | 8825 | San Francisco | San Francisco | 75 | 2021-04-11 | 35482 | 496 | TRUE |
8886 | 8886 | San Francisco | San Francisco | 75 | 2021-04-10 | 35482 | 496 | |
8947 | 8947 | San Francisco | San Francisco | 75 | 2021-04-09 | 35425 | 493 | |
9008 | 9008 | San Francisco | San Francisco | 75 | 2021-04-08 | 35405 | 487 | |
9069 | 9069 | San Francisco | San Francisco | 75 | 2021-04-07 | 35356 | 485 | |
9130 | 9130 | San Francisco | San Francisco | 75 | 2021-04-06 | 35329 | 482 | |
9191 | 9191 | San Francisco | San Francisco | 75 | 2021-04-05 | 35312 | 482 | |
9252 | 9252 | San Francisco | San Francisco | 75 | 2021-04-04 | 35220 | 476 | TRUE |
9313 | 9313 | San Francisco | San Francisco | 75 | 2021-04-03 | 35220 | 476 | |
9374 | 9374 | San Francisco | San Francisco | 75 | 2021-04-02 | 35170 | 474 | |
9435 | 9435 | San Francisco | San Francisco | 75 | 2021-04-01 | 35129 | 471 | |
9496 | 9496 | San Francisco | San Francisco | 75 | 2021-03-31 | 35083 | 463 | |
9557 | 9557 | San Francisco | San Francisco | 75 | 2021-03-30 | 35065 | 463 | |
9618 | 9618 | San Francisco | San Francisco | 75 | 2021-03-29 | 35029 | 463 | |
9679 | 9679 | San Francisco | San Francisco | 75 | 2021-03-28 | 34971 | 463 | TRUE |
9740 | 9740 | San Francisco | San Francisco | 75 | 2021-03-27 | 34971 | 463 | |
9801 | 9801 | San Francisco | San Francisco | 75 | 2021-03-26 | 34930 | 461 | |
9862 | 9862 | San Francisco | San Francisco | 75 | 2021-03-25 | 34889 | 455 | |
9923 | 9923 | San Francisco | San Francisco | 75 | 2021-03-24 | 34840 | 451 | |
9984 | 9984 | San Francisco | San Francisco | 75 | 2021-03-23 | 34805 | 451 | |
10045 | 10045 | San Francisco | San Francisco | 75 | 2021-03-22 | 34781 | 451 | |
10106 | 10106 | San Francisco | San Francisco | 75 | 2021-03-21 | 34710 | 451 | TRUE |
10167 | 10167 | San Francisco | San Francisco | 75 | 2021-03-20 | 34710 | 451 | |
10228 | 10228 | San Francisco | San Francisco | 75 | 2021-03-19 | 34677 | 451 | |
10289 | 10289 | San Francisco | San Francisco | 75 | 2021-03-18 | 34623 | 447 | |
10350 | 10350 | San Francisco | San Francisco | 75 | 2021-03-17 | 34589 | 447 | |
10411 | 10411 | San Francisco | San Francisco | 75 | 2021-03-16 | 34573 | 446 | TRUE |
10472 | 10472 | San Francisco | San Francisco | 75 | 2021-03-15 | 34573 | 446 | |
10533 | 10533 | San Francisco | San Francisco | 75 | 2021-03-14 | 34527 | 445 | TRUE |
10594 | 10594 | San Francisco | San Francisco | 75 | 2021-03-13 | 34527 | 445 | |
10655 | 10655 | San Francisco | San Francisco | 75 | 2021-03-12 | 34495 | 445 | |
10716 | 10716 | San Francisco | San Francisco | 75 | 2021-03-11 | 34463 | 440 | |
10777 | 10777 | San Francisco | San Francisco | 75 | 2021-03-10 | 34422 | 440 | |
10838 | 10838 | San Francisco | San Francisco | 75 | 2021-03-09 | 34400 | 436 | |
10899 | 10899 | San Francisco | San Francisco | 75 | 2021-03-08 | 34359 | 436 | |
10960 | 10960 | San Francisco | San Francisco | 75 | 2021-03-07 | 34286 | 432 | TRUE |
11021 | 11021 | San Francisco | San Francisco | 75 | 2021-03-06 | 34286 | 432 | |
11082 | 11082 | San Francisco | San Francisco | 75 | 2021-03-05 | 34245 | 426 | |
11143 | 11143 | San Francisco | San Francisco | 75 | 2021-03-04 | 34207 | 423 | |
11204 | 11204 | San Francisco | San Francisco | 75 | 2021-03-03 | 34153 | 422 | |
11265 | 11265 | San Francisco | San Francisco | 75 | 2021-03-02 | 34114 | 422 | |
11326 | 11326 | San Francisco | San Francisco | 75 | 2021-03-01 | 34070 | 422 | |
11387 | 11387 | San Francisco | San Francisco | 75 | 2021-02-28 | 34034 | 422 | |
11448 | 11448 | San Francisco | San Francisco | 75 | 2021-02-27 | 33970 | 412 | |
11509 | 11509 | San Francisco | San Francisco | 75 | 2021-02-26 | 33910 | 410 | |
11570 | 11570 | San Francisco | San Francisco | 75 | 2021-02-25 | 33779 | 398 | |
11631 | 11631 | San Francisco | San Francisco | 75 | 2021-02-24 | 33721 | 394 | |
11692 | 11692 | San Francisco | San Francisco | 75 | 2021-02-23 | 33663 | 394 | |
11753 | 11753 | San Francisco | San Francisco | 75 | 2021-02-22 | 33613 | 394 | |
11814 | 11814 | San Francisco | San Francisco | 75 | 2021-02-21 | 33559 | 394 | |
11875 | 11875 | San Francisco | San Francisco | 75 | 2021-02-20 | 33471 | 394 | |
11936 | 11936 | San Francisco | San Francisco | 75 | 2021-02-19 | 33397 | 387 | |
11997 | 11997 | San Francisco | San Francisco | 75 | 2021-02-18 | 33307 | 376 | |
12058 | 12058 | San Francisco | San Francisco | 75 | 2021-02-17 | 33211 | 376 | |
12119 | 12119 | San Francisco | San Francisco | 75 | 2021-02-16 | 33159 | 372 | |
12180 | 12180 | San Francisco | San Francisco | 75 | 2021-02-15 | 33099 | 366 |
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 );