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 = 97 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 |
---|---|---|---|---|---|---|---|---|
8227 | 8227 | 2021-04-14 | Sonoma | 97 | 29573 | 311 | 0 | 0 |
8285 | 8285 | 2021-04-13 | Sonoma | 97 | 29573 | 311 | 37 | 2 |
8343 | 8343 | 2021-04-12 | Sonoma | 97 | 29536 | 309 | 35 | 0 |
8401 | 8401 | 2021-04-11 | Sonoma | 97 | 29501 | 309 | 53 | 0 |
8459 | 8459 | 2021-04-10 | Sonoma | 97 | 29448 | 309 | 0 | 0 |
8517 | 8517 | 2021-04-09 | Sonoma | 97 | 29448 | 309 | 17 | 0 |
8575 | 8575 | 2021-04-08 | Sonoma | 97 | 29431 | 309 | 8 | 0 |
8633 | 8633 | 2021-04-07 | Sonoma | 97 | 29423 | 309 | 21 | 0 |
8691 | 8691 | 2021-04-06 | Sonoma | 97 | 29402 | 309 | 30 | 0 |
8749 | 8749 | 2021-04-05 | Sonoma | 97 | 29372 | 309 | 23 | 0 |
8807 | 8807 | 2021-04-04 | Sonoma | 97 | 29349 | 309 | 39 | 0 |
8865 | 8865 | 2021-04-03 | Sonoma | 97 | 29310 | 309 | 53 | 0 |
8923 | 8923 | 2021-04-02 | Sonoma | 97 | 29257 | 309 | 2 | 1 |
8981 | 8981 | 2021-04-01 | Sonoma | 97 | 29255 | 308 | 20 | 0 |
9039 | 9039 | 2021-03-31 | Sonoma | 97 | 29235 | 308 | 0 | 0 |
9097 | 9097 | 2021-03-30 | Sonoma | 97 | 29235 | 308 | 16 | 0 |
9155 | 9155 | 2021-03-29 | Sonoma | 97 | 29219 | 308 | 50 | 0 |
9213 | 9213 | 2021-03-28 | Sonoma | 97 | 29169 | 308 | 47 | 0 |
9271 | 9271 | 2021-03-27 | Sonoma | 97 | 29122 | 308 | 32 | 0 |
9329 | 9329 | 2021-03-26 | Sonoma | 97 | 29090 | 308 | 31 | 0 |
9387 | 9387 | 2021-03-25 | Sonoma | 97 | 29059 | 308 | 14 | 0 |
9445 | 9445 | 2021-03-24 | Sonoma | 97 | 29045 | 308 | 0 | 0 |
9503 | 9503 | 2021-03-23 | Sonoma | 97 | 29045 | 308 | 39 | 0 |
9561 | 9561 | 2021-03-22 | Sonoma | 97 | 29006 | 308 | 25 | 0 |
9619 | 9619 | 2021-03-21 | Sonoma | 97 | 28981 | 308 | 67 | 0 |
9677 | 9677 | 2021-03-20 | Sonoma | 97 | 28914 | 308 | 32 | 0 |
9735 | 9735 | 2021-03-19 | Sonoma | 97 | 28882 | 308 | 0 | 0 |
9793 | 9793 | 2021-03-18 | Sonoma | 97 | 28882 | 308 | 62 | 0 |
9851 | 9851 | 2021-03-17 | Sonoma | 97 | 28820 | 308 | 0 | 0 |
9909 | 9909 | 2021-03-16 | Sonoma | 97 | 28820 | 308 | 67 | 0 |
9967 | 9967 | 2021-03-15 | Sonoma | 97 | 28753 | 308 | 0 | 0 |
10025 | 10025 | 2021-03-14 | Sonoma | 97 | 28753 | 308 | 87 | 2 |
10083 | 10083 | 2021-03-13 | Sonoma | 97 | 28666 | 306 | 44 | 0 |
10141 | 10141 | 2021-03-12 | Sonoma | 97 | 28622 | 306 | 57 | 0 |
10199 | 10199 | 2021-03-11 | Sonoma | 97 | 28565 | 306 | 27 | 0 |
10257 | 10257 | 2021-03-10 | Sonoma | 97 | 28538 | 306 | 0 | 0 |
10315 | 10315 | 2021-03-09 | Sonoma | 97 | 28538 | 306 | 90 | 3 |
10373 | 10373 | 2021-03-08 | Sonoma | 97 | 28448 | 303 | 0 | 0 |
10431 | 10431 | 2021-03-07 | Sonoma | 97 | 28448 | 303 | 122 | 0 |
10489 | 10489 | 2021-03-06 | Sonoma | 97 | 28326 | 303 | 45 | 2 |
10547 | 10547 | 2021-03-05 | Sonoma | 97 | 28281 | 301 | 68 | 0 |
10605 | 10605 | 2021-03-04 | Sonoma | 97 | 28213 | 301 | 28 | 0 |
10663 | 10663 | 2021-03-03 | Sonoma | 97 | 28185 | 301 | 51 | 3 |
10721 | 10721 | 2021-03-02 | Sonoma | 97 | 28134 | 298 | 0 | 0 |
10779 | 10779 | 2021-03-01 | Sonoma | 97 | 28134 | 298 | 42 | 0 |
10837 | 10837 | 2021-02-28 | Sonoma | 97 | 28092 | 298 | 39 | 0 |
10895 | 10895 | 2021-02-27 | Sonoma | 97 | 28053 | 298 | 128 | 0 |
10953 | 10953 | 2021-02-26 | Sonoma | 97 | 27925 | 298 | 0 | 0 |
11011 | 11011 | 2021-02-25 | Sonoma | 97 | 27925 | 298 | 122 | 3 |
11069 | 11069 | 2021-02-24 | Sonoma | 97 | 27803 | 295 | 0 | 0 |
11127 | 11127 | 2021-02-23 | Sonoma | 97 | 27803 | 295 | 59 | 0 |
11185 | 11185 | 2021-02-22 | Sonoma | 97 | 27744 | 295 | 68 | 0 |
11243 | 11243 | 2021-02-21 | Sonoma | 97 | 27676 | 295 | 70 | 4 |
11301 | 11301 | 2021-02-20 | Sonoma | 97 | 27606 | 291 | 133 | 0 |
11359 | 11359 | 2021-02-19 | Sonoma | 97 | 27473 | 291 | 59 | 0 |
11417 | 11417 | 2021-02-18 | Sonoma | 97 | 27414 | 291 | 53 | 0 |
11475 | 11475 | 2021-02-17 | Sonoma | 97 | 27361 | 291 | 0 | 0 |
11533 | 11533 | 2021-02-16 | Sonoma | 97 | 27361 | 291 | 0 | 4 |
11591 | 11591 | 2021-02-15 | Sonoma | 97 | 27361 | 287 | 112 | 0 |
11649 | 11649 | 2021-02-14 | Sonoma | 97 | 27249 | 287 | 106 | 0 |
11707 | 11707 | 2021-02-13 | Sonoma | 97 | 27143 | 287 | 87 | 4 |
11765 | 11765 | 2021-02-12 | Sonoma | 97 | 27056 | 283 | 0 | 0 |
11823 | 11823 | 2021-02-11 | Sonoma | 97 | 27056 | 283 | 85 | 0 |
11881 | 11881 | 2021-02-10 | Sonoma | 97 | 26971 | 283 | 32 | 3 |
11939 | 11939 | 2021-02-09 | Sonoma | 97 | 26939 | 280 | 30 | 3 |
11997 | 11997 | 2021-02-08 | Sonoma | 97 | 26909 | 277 | 73 | 0 |
12055 | 12055 | 2021-02-07 | Sonoma | 97 | 26836 | 277 | 162 | 2 |
12113 | 12113 | 2021-02-06 | Sonoma | 97 | 26674 | 275 | 79 | 0 |
12171 | 12171 | 2021-02-05 | Sonoma | 97 | 26595 | 275 | 165 | 5 |
12229 | 12229 | 2021-02-04 | Sonoma | 97 | 26430 | 270 | 124 | 3 |
12287 | 12287 | 2021-02-03 | Sonoma | 97 | 26306 | 267 | 56 | 0 |
12345 | 12345 | 2021-02-02 | Sonoma | 97 | 26250 | 267 | 61 | 2 |
12403 | 12403 | 2021-02-01 | Sonoma | 97 | 26189 | 265 | 81 | 5 |
12461 | 12461 | 2021-01-31 | Sonoma | 97 | 26108 | 260 | 116 | 0 |
12519 | 12519 | 2021-01-30 | Sonoma | 97 | 25992 | 260 | 167 | 0 |
12577 | 12577 | 2021-01-29 | Sonoma | 97 | 25825 | 260 | 147 | 0 |
12635 | 12635 | 2021-01-28 | Sonoma | 97 | 25678 | 260 | 142 | 6 |
12693 | 12693 | 2021-01-27 | Sonoma | 97 | 25536 | 254 | 159 | 0 |
12751 | 12751 | 2021-01-26 | Sonoma | 97 | 25377 | 254 | 236 | 3 |
12809 | 12809 | 2021-01-25 | Sonoma | 97 | 25141 | 251 | 206 | 4 |
12867 | 12867 | 2021-01-24 | Sonoma | 97 | 24935 | 247 | 174 | 0 |
12925 | 12925 | 2021-01-23 | Sonoma | 97 | 24761 | 247 | 190 | 2 |
12983 | 12983 | 2021-01-22 | Sonoma | 97 | 24571 | 245 | 102 | 0 |
13041 | 13041 | 2021-01-21 | Sonoma | 97 | 24469 | 245 | 285 | 3 |
13099 | 13099 | 2021-01-20 | Sonoma | 97 | 24184 | 242 | 207 | 0 |
13157 | 13157 | 2021-01-19 | Sonoma | 97 | 23977 | 242 | 261 | 2 |
13215 | 13215 | 2021-01-18 | Sonoma | 97 | 23716 | 240 | 455 | 6 |
13273 | 13273 | 2021-01-17 | Sonoma | 97 | 23261 | 234 | 0 | 0 |
13331 | 13331 | 2021-01-16 | Sonoma | 97 | 23261 | 234 | 172 | 0 |
13389 | 13389 | 2021-01-15 | Sonoma | 97 | 23089 | 234 | 558 | 7 |
13447 | 13447 | 2021-01-14 | Sonoma | 97 | 22531 | 227 | 488 | 8 |
13505 | 13505 | 2021-01-13 | Sonoma | 97 | 22043 | 219 | 416 | 0 |
13563 | 13563 | 2021-01-12 | Sonoma | 97 | 21627 | 219 | 164 | 1 |
13621 | 13621 | 2021-01-11 | Sonoma | 97 | 21463 | 218 | 0 | 0 |
13679 | 13679 | 2021-01-10 | Sonoma | 97 | 21463 | 218 | 199 | 0 |
13737 | 13737 | 2021-01-09 | Sonoma | 97 | 21264 | 218 | 197 | 0 |
13795 | 13795 | 2021-01-08 | Sonoma | 97 | 21067 | 218 | 315 | 4 |
13853 | 13853 | 2021-01-07 | Sonoma | 97 | 20752 | 214 | 251 | 1 |
13911 | 13911 | 2021-01-06 | Sonoma | 97 | 20501 | 213 | 354 | 9 |
13969 | 13969 | 2021-01-05 | Sonoma | 97 | 20147 | 204 | 132 | 8 |
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 );