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 · 418 ✖
county 1
- San Francisco 418
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
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 |
11638 | 11638 | 2021-02-14 | San Francisco | 75 | 33030 | 366 | 131 | 0 |
11696 | 11696 | 2021-02-13 | San Francisco | 75 | 32899 | 366 | 90 | 7 |
11754 | 11754 | 2021-02-12 | San Francisco | 75 | 32809 | 359 | 114 | 8 |
11812 | 11812 | 2021-02-11 | San Francisco | 75 | 32695 | 351 | 170 | 0 |
11870 | 11870 | 2021-02-10 | San Francisco | 75 | 32525 | 351 | 105 | 5 |
11928 | 11928 | 2021-02-09 | San Francisco | 75 | 32420 | 346 | 65 | 0 |
11986 | 11986 | 2021-02-08 | San Francisco | 75 | 32355 | 346 | 199 | 0 |
12044 | 12044 | 2021-02-07 | San Francisco | 75 | 32156 | 346 | 197 | 1 |
12102 | 12102 | 2021-02-06 | San Francisco | 75 | 31959 | 345 | 102 | 0 |
12160 | 12160 | 2021-02-05 | San Francisco | 75 | 31857 | 345 | 313 | 17 |
12218 | 12218 | 2021-02-04 | San Francisco | 75 | 31544 | 328 | 0 | 0 |
12276 | 12276 | 2021-02-03 | San Francisco | 75 | 31544 | 328 | 167 | 4 |
12334 | 12334 | 2021-02-02 | San Francisco | 75 | 31377 | 324 | 118 | 0 |
12392 | 12392 | 2021-02-01 | San Francisco | 75 | 31259 | 324 | 148 | 0 |
12450 | 12450 | 2021-01-31 | San Francisco | 75 | 31111 | 324 | 168 | 1 |
12508 | 12508 | 2021-01-30 | San Francisco | 75 | 30943 | 323 | 129 | 6 |
12566 | 12566 | 2021-01-29 | San Francisco | 75 | 30814 | 317 | 140 | 9 |
12624 | 12624 | 2021-01-28 | San Francisco | 75 | 30674 | 308 | 196 | 11 |
12682 | 12682 | 2021-01-27 | San Francisco | 75 | 30478 | 297 | 238 | 4 |
12740 | 12740 | 2021-01-26 | San Francisco | 75 | 30240 | 293 | 249 | 0 |
12798 | 12798 | 2021-01-25 | San Francisco | 75 | 29991 | 293 | 107 | 0 |
12856 | 12856 | 2021-01-24 | San Francisco | 75 | 29884 | 293 | 283 | 15 |
12914 | 12914 | 2021-01-23 | San Francisco | 75 | 29601 | 278 | 111 | 3 |
12972 | 12972 | 2021-01-22 | San Francisco | 75 | 29490 | 275 | 128 | 1 |
13030 | 13030 | 2021-01-21 | San Francisco | 75 | 29362 | 274 | 182 | 8 |
13088 | 13088 | 2021-01-20 | San Francisco | 75 | 29180 | 266 | 162 | 4 |
13146 | 13146 | 2021-01-19 | San Francisco | 75 | 29018 | 262 | 251 | 0 |
13204 | 13204 | 2021-01-18 | San Francisco | 75 | 28767 | 262 | 546 | 8 |
13262 | 13262 | 2021-01-17 | San Francisco | 75 | 28221 | 254 | 0 | 0 |
13320 | 13320 | 2021-01-16 | San Francisco | 75 | 28221 | 254 | 343 | 13 |
13378 | 13378 | 2021-01-15 | San Francisco | 75 | 27878 | 241 | 343 | 4 |
13436 | 13436 | 2021-01-14 | San Francisco | 75 | 27535 | 237 | 280 | 2 |
13494 | 13494 | 2021-01-13 | San Francisco | 75 | 27255 | 235 | 255 | 0 |
13552 | 13552 | 2021-01-12 | San Francisco | 75 | 27000 | 235 | 244 | 1 |
13610 | 13610 | 2021-01-11 | San Francisco | 75 | 26756 | 234 | 474 | 1 |
13668 | 13668 | 2021-01-10 | San Francisco | 75 | 26282 | 233 | 309 | 0 |
13726 | 13726 | 2021-01-09 | San Francisco | 75 | 25973 | 233 | 451 | 15 |
13784 | 13784 | 2021-01-08 | San Francisco | 75 | 25522 | 218 | 387 | 13 |
13842 | 13842 | 2021-01-07 | San Francisco | 75 | 25135 | 205 | 361 | 2 |
13900 | 13900 | 2021-01-06 | San Francisco | 75 | 24774 | 203 | 210 | 5 |
13958 | 13958 | 2021-01-05 | San Francisco | 75 | 24564 | 198 | 156 | 4 |
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 );