latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "San Diego" 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 |
---|---|---|---|---|---|---|---|---|
5837 | 5837 | 2021-05-25 | San Diego | 73 | 279785 | 3753 | 71 | 4 |
5895 | 5895 | 2021-05-24 | San Diego | 73 | 279714 | 3749 | 25 | 2 |
5953 | 5953 | 2021-05-23 | San Diego | 73 | 279689 | 3747 | 76 | 0 |
6011 | 6011 | 2021-05-22 | San Diego | 73 | 279613 | 3747 | 60 | -1 |
6069 | 6069 | 2021-05-21 | San Diego | 73 | 279553 | 3748 | 64 | 0 |
6127 | 6127 | 2021-05-20 | San Diego | 73 | 279489 | 3748 | 145 | 2 |
6185 | 6185 | 2021-05-19 | San Diego | 73 | 279344 | 3746 | 91 | 4 |
6243 | 6243 | 2021-05-18 | San Diego | 73 | 279253 | 3742 | 108 | 0 |
6301 | 6301 | 2021-05-17 | San Diego | 73 | 279145 | 3742 | 47 | 0 |
6359 | 6359 | 2021-05-16 | San Diego | 73 | 279098 | 3742 | 108 | 5 |
6417 | 6417 | 2021-05-15 | San Diego | 73 | 278990 | 3737 | 138 | 5 |
6475 | 6475 | 2021-05-14 | San Diego | 73 | 278852 | 3732 | 261 | 3 |
6533 | 6533 | 2021-05-13 | San Diego | 73 | 278591 | 3729 | 190 | 0 |
6591 | 6591 | 2021-05-12 | San Diego | 73 | 278401 | 3729 | 94 | 4 |
6649 | 6649 | 2021-05-11 | San Diego | 73 | 278307 | 3725 | 125 | 0 |
6707 | 6707 | 2021-05-10 | San Diego | 73 | 278182 | 3725 | 233 | 0 |
6765 | 6765 | 2021-05-09 | San Diego | 73 | 277949 | 3725 | 190 | 0 |
6823 | 6823 | 2021-05-08 | San Diego | 73 | 277759 | 3725 | 226 | 7 |
6881 | 6881 | 2021-05-07 | San Diego | 73 | 277533 | 3718 | 210 | 2 |
6939 | 6939 | 2021-05-06 | San Diego | 73 | 277323 | 3716 | 226 | 0 |
6997 | 6997 | 2021-05-05 | San Diego | 73 | 277097 | 3716 | 219 | 3 |
7055 | 7055 | 2021-05-04 | San Diego | 73 | 276878 | 3713 | 186 | 1 |
7113 | 7113 | 2021-05-03 | San Diego | 73 | 276692 | 3712 | 172 | 0 |
7171 | 7171 | 2021-05-02 | San Diego | 73 | 276520 | 3712 | 154 | 6 |
7229 | 7229 | 2021-05-01 | San Diego | 73 | 276366 | 3706 | 210 | 4 |
7287 | 7287 | 2021-04-30 | San Diego | 73 | 276156 | 3702 | 196 | 2 |
7345 | 7345 | 2021-04-29 | San Diego | 73 | 275960 | 3700 | 140 | 2 |
7403 | 7403 | 2021-04-28 | San Diego | 73 | 275820 | 3698 | 136 | 6 |
7461 | 7461 | 2021-04-27 | San Diego | 73 | 275684 | 3692 | 144 | 0 |
7519 | 7519 | 2021-04-26 | San Diego | 73 | 275540 | 3692 | 129 | 0 |
7577 | 7577 | 2021-04-25 | San Diego | 73 | 275411 | 3692 | 160 | 4 |
7635 | 7635 | 2021-04-24 | San Diego | 73 | 275251 | 3688 | 0 | 4 |
7693 | 7693 | 2021-04-23 | San Diego | 73 | 275251 | 3684 | 0 | 0 |
7751 | 7751 | 2021-04-22 | San Diego | 73 | 275251 | 3684 | 0 | 3 |
7809 | 7809 | 2021-04-21 | San Diego | 73 | 275251 | 3681 | 0 | 7 |
7867 | 7867 | 2021-04-20 | San Diego | 73 | 275251 | 3674 | 139 | 0 |
7925 | 7925 | 2021-04-19 | San Diego | 73 | 275112 | 3674 | 152 | 0 |
7983 | 7983 | 2021-04-18 | San Diego | 73 | 274960 | 3674 | 149 | 0 |
8041 | 8041 | 2021-04-17 | San Diego | 73 | 274811 | 3674 | 245 | 12 |
8099 | 8099 | 2021-04-16 | San Diego | 73 | 274566 | 3662 | 317 | 9 |
8157 | 8157 | 2021-04-15 | San Diego | 73 | 274249 | 3653 | 281 | 5 |
8215 | 8215 | 2021-04-14 | San Diego | 73 | 273968 | 3648 | 260 | 25 |
8273 | 8273 | 2021-04-13 | San Diego | 73 | 273708 | 3623 | 278 | 2 |
8331 | 8331 | 2021-04-12 | San Diego | 73 | 273430 | 3621 | 144 | 0 |
8389 | 8389 | 2021-04-11 | San Diego | 73 | 273286 | 3621 | 229 | 8 |
8447 | 8447 | 2021-04-10 | San Diego | 73 | 273057 | 3613 | 361 | 13 |
8505 | 8505 | 2021-04-09 | San Diego | 73 | 272696 | 3600 | 202 | 8 |
8563 | 8563 | 2021-04-08 | San Diego | 73 | 272494 | 3592 | 300 | 4 |
8621 | 8621 | 2021-04-07 | San Diego | 73 | 272194 | 3588 | 328 | 3 |
8679 | 8679 | 2021-04-06 | San Diego | 73 | 271866 | 3585 | 212 | 2 |
8737 | 8737 | 2021-04-05 | San Diego | 73 | 271654 | 3583 | 127 | 0 |
8795 | 8795 | 2021-04-04 | San Diego | 73 | 271527 | 3583 | 193 | 12 |
8853 | 8853 | 2021-04-03 | San Diego | 73 | 271334 | 3571 | 299 | 3 |
8911 | 8911 | 2021-04-02 | San Diego | 73 | 271035 | 3568 | 496 | 13 |
8969 | 8969 | 2021-04-01 | San Diego | 73 | 270539 | 3555 | 252 | 0 |
9027 | 9027 | 2021-03-31 | San Diego | 73 | 270287 | 3555 | 290 | 0 |
9085 | 9085 | 2021-03-30 | San Diego | 73 | 269997 | 3555 | 227 | 8 |
9143 | 9143 | 2021-03-29 | San Diego | 73 | 269770 | 3547 | 290 | 0 |
9201 | 9201 | 2021-03-28 | San Diego | 73 | 269480 | 3547 | 205 | 7 |
9259 | 9259 | 2021-03-27 | San Diego | 73 | 269275 | 3540 | 226 | 15 |
9317 | 9317 | 2021-03-26 | San Diego | 73 | 269049 | 3525 | 422 | 5 |
9375 | 9375 | 2021-03-25 | San Diego | 73 | 268627 | 3520 | 210 | 11 |
9433 | 9433 | 2021-03-24 | San Diego | 73 | 268417 | 3509 | 257 | 11 |
9491 | 9491 | 2021-03-23 | San Diego | 73 | 268160 | 3498 | 243 | 4 |
9549 | 9549 | 2021-03-22 | San Diego | 73 | 267917 | 3494 | 189 | 0 |
9607 | 9607 | 2021-03-21 | San Diego | 73 | 267728 | 3494 | 192 | 3 |
9665 | 9665 | 2021-03-20 | San Diego | 73 | 267536 | 3491 | 359 | 0 |
9723 | 9723 | 2021-03-19 | San Diego | 73 | 267177 | 3491 | 421 | 13 |
9781 | 9781 | 2021-03-18 | San Diego | 73 | 266756 | 3478 | 439 | 8 |
9839 | 9839 | 2021-03-17 | San Diego | 73 | 266317 | 3470 | 411 | 8 |
9897 | 9897 | 2021-03-16 | San Diego | 73 | 265906 | 3462 | 257 | 10 |
9955 | 9955 | 2021-03-15 | San Diego | 73 | 265649 | 3452 | 178 | 0 |
10013 | 10013 | 2021-03-14 | San Diego | 73 | 265471 | 3452 | 198 | 8 |
10071 | 10071 | 2021-03-13 | San Diego | 73 | 265273 | 3444 | 746 | 22 |
10129 | 10129 | 2021-03-12 | San Diego | 73 | 264527 | 3422 | 0 | 0 |
10187 | 10187 | 2021-03-11 | San Diego | 73 | 264527 | 3422 | 430 | 9 |
10245 | 10245 | 2021-03-10 | San Diego | 73 | 264097 | 3413 | 349 | 8 |
10303 | 10303 | 2021-03-09 | San Diego | 73 | 263748 | 3405 | 473 | 15 |
10361 | 10361 | 2021-03-08 | San Diego | 73 | 263275 | 3390 | 307 | 0 |
10419 | 10419 | 2021-03-07 | San Diego | 73 | 262968 | 3390 | 187 | 5 |
10477 | 10477 | 2021-03-06 | San Diego | 73 | 262781 | 3385 | 421 | 14 |
10535 | 10535 | 2021-03-05 | San Diego | 73 | 262360 | 3371 | 499 | 12 |
10593 | 10593 | 2021-03-04 | San Diego | 73 | 261861 | 3359 | 508 | 17 |
10651 | 10651 | 2021-03-03 | San Diego | 73 | 261353 | 3342 | 352 | 25 |
10709 | 10709 | 2021-03-02 | San Diego | 73 | 261001 | 3317 | 376 | 14 |
10767 | 10767 | 2021-03-01 | San Diego | 73 | 260625 | 3303 | 269 | 0 |
10825 | 10825 | 2021-02-28 | San Diego | 73 | 260356 | 3303 | 262 | 19 |
10883 | 10883 | 2021-02-27 | San Diego | 73 | 260094 | 3284 | 450 | 13 |
10941 | 10941 | 2021-02-26 | San Diego | 73 | 259644 | 3271 | 662 | 11 |
10999 | 10999 | 2021-02-25 | San Diego | 73 | 258982 | 3260 | 519 | 30 |
11057 | 11057 | 2021-02-24 | San Diego | 73 | 258463 | 3230 | 658 | 12 |
11115 | 11115 | 2021-02-23 | San Diego | 73 | 257805 | 3218 | 454 | 29 |
11173 | 11173 | 2021-02-22 | San Diego | 73 | 257351 | 3189 | 321 | 0 |
11231 | 11231 | 2021-02-21 | San Diego | 73 | 257030 | 3189 | 517 | 1 |
11289 | 11289 | 2021-02-20 | San Diego | 73 | 256513 | 3188 | 711 | 19 |
11347 | 11347 | 2021-02-19 | San Diego | 73 | 255802 | 3169 | 812 | 34 |
11405 | 11405 | 2021-02-18 | San Diego | 73 | 254990 | 3135 | 810 | 36 |
11463 | 11463 | 2021-02-17 | San Diego | 73 | 254180 | 3099 | 539 | 57 |
11521 | 11521 | 2021-02-16 | San Diego | 73 | 253641 | 3042 | 698 | 5 |
11579 | 11579 | 2021-02-15 | San Diego | 73 | 252943 | 3037 | 693 | 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 );