latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
586 rows where county = "Los Angeles" 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 |
---|---|---|---|---|---|---|---|---|
18057 | 18057 | 2020-10-26 | Los Angeles | 37 | 300662 | 7000 | 902 | 7 |
18115 | 18115 | 2020-10-25 | Los Angeles | 37 | 299760 | 6993 | 753 | 4 |
18173 | 18173 | 2020-10-24 | Los Angeles | 37 | 299007 | 6989 | 2077 | 15 |
18231 | 18231 | 2020-10-23 | Los Angeles | 37 | 296930 | 6974 | 2792 | 18 |
18289 | 18289 | 2020-10-22 | Los Angeles | 37 | 294138 | 6956 | 3580 | 12 |
18347 | 18347 | 2020-10-21 | Los Angeles | 37 | 290558 | 6944 | 451 | 32 |
18405 | 18405 | 2020-10-20 | Los Angeles | 37 | 290107 | 6912 | 686 | 35 |
18463 | 18463 | 2020-10-19 | Los Angeles | 37 | 289421 | 6877 | 969 | 1 |
18521 | 18521 | 2020-10-18 | Los Angeles | 37 | 288452 | 6876 | 271 | 13 |
18579 | 18579 | 2020-10-17 | Los Angeles | 37 | 288181 | 6863 | 923 | 7 |
18637 | 18637 | 2020-10-16 | Los Angeles | 37 | 287258 | 6856 | 1041 | 22 |
18695 | 18695 | 2020-10-15 | Los Angeles | 37 | 286217 | 6834 | 1201 | 22 |
18753 | 18753 | 2020-10-14 | Los Angeles | 37 | 285016 | 6812 | 1223 | 19 |
18811 | 18811 | 2020-10-13 | Los Angeles | 37 | 283793 | 6793 | 770 | 20 |
18869 | 18869 | 2020-10-12 | Los Angeles | 37 | 283023 | 6773 | 888 | 2 |
18927 | 18927 | 2020-10-11 | Los Angeles | 37 | 282135 | 6771 | 929 | 2 |
18985 | 18985 | 2020-10-10 | Los Angeles | 37 | 281206 | 6769 | 1217 | 28 |
19043 | 19043 | 2020-10-09 | Los Angeles | 37 | 279989 | 6741 | 1256 | 14 |
19101 | 19101 | 2020-10-08 | Los Angeles | 37 | 278733 | 6727 | 1246 | 18 |
19159 | 19159 | 2020-10-07 | Los Angeles | 37 | 277487 | 6709 | 1567 | 25 |
19217 | 19217 | 2020-10-06 | Los Angeles | 37 | 275920 | 6684 | 902 | 29 |
19275 | 19275 | 2020-10-05 | Los Angeles | 37 | 275018 | 6655 | 451 | 9 |
19333 | 19333 | 2020-10-04 | Los Angeles | 37 | 274567 | 6646 | 868 | 5 |
19391 | 19391 | 2020-10-03 | Los Angeles | 37 | 273699 | 6641 | 1040 | 16 |
19449 | 19449 | 2020-10-02 | Los Angeles | 37 | 272659 | 6625 | 1216 | 13 |
19507 | 19507 | 2020-10-01 | Los Angeles | 37 | 271443 | 6612 | 1082 | 35 |
19565 | 19565 | 2020-09-30 | Los Angeles | 37 | 270361 | 6577 | 1017 | 24 |
19623 | 19623 | 2020-09-29 | Los Angeles | 37 | 269344 | 6553 | 843 | 38 |
19681 | 19681 | 2020-09-28 | Los Angeles | 37 | 268501 | 6515 | 694 | 1 |
19739 | 19739 | 2020-09-27 | Los Angeles | 37 | 267807 | 6514 | 779 | 10 |
19797 | 19797 | 2020-09-26 | Los Angeles | 37 | 267028 | 6504 | 1214 | 14 |
19855 | 19855 | 2020-09-25 | Los Angeles | 37 | 265814 | 6490 | 1349 | 32 |
19913 | 19913 | 2020-09-24 | Los Angeles | 37 | 264465 | 6458 | 1057 | 33 |
19971 | 19971 | 2020-09-23 | Los Angeles | 37 | 263408 | 6425 | 1204 | 24 |
20029 | 20029 | 2020-09-22 | Los Angeles | 37 | 262204 | 6401 | 703 | 34 |
20087 | 20087 | 2020-09-21 | Los Angeles | 37 | 261501 | 6367 | 693 | 14 |
20145 | 20145 | 2020-09-20 | Los Angeles | 37 | 260808 | 6353 | 916 | 22 |
20203 | 20203 | 2020-09-19 | Los Angeles | 37 | 259892 | 6331 | 1305 | 1 |
20261 | 20261 | 2020-09-18 | Los Angeles | 37 | 258587 | 6330 | 1244 | 6 |
20319 | 20319 | 2020-09-17 | Los Angeles | 37 | 257343 | 6324 | 1149 | 19 |
20377 | 20377 | 2020-09-16 | Los Angeles | 37 | 256194 | 6305 | 1070 | 31 |
20435 | 20435 | 2020-09-15 | Los Angeles | 37 | 255124 | 6274 | 439 | 42 |
20493 | 20493 | 2020-09-14 | Los Angeles | 37 | 254685 | 6232 | 700 | 24 |
20551 | 20551 | 2020-09-13 | Los Angeles | 37 | 253985 | 6208 | 765 | 10 |
20609 | 20609 | 2020-09-12 | Los Angeles | 37 | 253220 | 6198 | 1095 | 21 |
20667 | 20667 | 2020-09-11 | Los Angeles | 37 | 252125 | 6177 | 1050 | 46 |
20725 | 20725 | 2020-09-10 | Los Angeles | 37 | 251075 | 6131 | 1124 | 41 |
20783 | 20783 | 2020-09-09 | Los Angeles | 37 | 249951 | 6090 | 677 | 54 |
20841 | 20841 | 2020-09-08 | Los Angeles | 37 | 249274 | 6036 | 452 | 6 |
20899 | 20899 | 2020-09-07 | Los Angeles | 37 | 248822 | 6030 | 483 | 25 |
20957 | 20957 | 2020-09-06 | Los Angeles | 37 | 248339 | 6005 | 712 | 5 |
21015 | 21015 | 2020-09-05 | Los Angeles | 37 | 247627 | 6000 | 1170 | 19 |
21073 | 21073 | 2020-09-04 | Los Angeles | 37 | 246457 | 5981 | 1362 | 47 |
21131 | 21131 | 2020-09-03 | Los Angeles | 37 | 245095 | 5934 | 1091 | 46 |
21189 | 21189 | 2020-09-02 | Los Angeles | 37 | 244004 | 5888 | 1322 | 58 |
21247 | 21247 | 2020-09-01 | Los Angeles | 37 | 242682 | 5830 | 874 | 46 |
21305 | 21305 | 2020-08-31 | Los Angeles | 37 | 241808 | 5784 | 1053 | 15 |
21363 | 21363 | 2020-08-30 | Los Angeles | 37 | 240755 | 5769 | 927 | 6 |
21421 | 21421 | 2020-08-29 | Los Angeles | 37 | 239828 | 5763 | 1277 | 28 |
21479 | 21479 | 2020-08-28 | Los Angeles | 37 | 238551 | 5735 | 1471 | 34 |
21537 | 21537 | 2020-08-27 | Los Angeles | 37 | 237080 | 5701 | 1650 | 37 |
21595 | 21595 | 2020-08-26 | Los Angeles | 37 | 235430 | 5664 | 1548 | 54 |
21653 | 21653 | 2020-08-25 | Los Angeles | 37 | 233882 | 5610 | 945 | 50 |
21711 | 21711 | 2020-08-24 | Los Angeles | 37 | 232937 | 5560 | 1234 | 15 |
21769 | 21769 | 2020-08-23 | Los Angeles | 37 | 231703 | 5545 | 931 | 8 |
21827 | 21827 | 2020-08-22 | Los Angeles | 37 | 230772 | 5537 | 1624 | 45 |
21885 | 21885 | 2020-08-21 | Los Angeles | 37 | 229148 | 5492 | 1744 | 45 |
21943 | 21943 | 2020-08-20 | Los Angeles | 37 | 227404 | 5447 | 1488 | 51 |
22001 | 22001 | 2020-08-19 | Los Angeles | 37 | 225916 | 5396 | 1811 | 56 |
22059 | 22059 | 2020-08-18 | Los Angeles | 37 | 224105 | 5340 | 872 | 67 |
22117 | 22117 | 2020-08-17 | Los Angeles | 37 | 223233 | 5273 | 1262 | 19 |
22175 | 22175 | 2020-08-16 | Los Angeles | 37 | 221971 | 5254 | 1104 | 8 |
22233 | 22233 | 2020-08-15 | Los Angeles | 37 | 220867 | 5246 | 2036 | 31 |
22291 | 22291 | 2020-08-14 | Los Angeles | 37 | 218831 | 5215 | 2518 | 43 |
22349 | 22349 | 2020-08-13 | Los Angeles | 37 | 216313 | 5172 | 2030 | 60 |
22407 | 22407 | 2020-08-12 | Los Angeles | 37 | 214283 | 5112 | 2138 | 54 |
22465 | 22465 | 2020-08-11 | Los Angeles | 37 | 212145 | 5058 | 1602 | 60 |
22523 | 22523 | 2020-08-10 | Los Angeles | 37 | 210543 | 4998 | 1980 | 21 |
22581 | 22581 | 2020-08-09 | Los Angeles | 37 | 208563 | 4977 | 1785 | 10 |
22639 | 22639 | 2020-08-08 | Los Angeles | 37 | 206778 | 4967 | 2520 | 48 |
22697 | 22697 | 2020-08-07 | Los Angeles | 37 | 204258 | 4919 | 3058 | 50 |
22755 | 22755 | 2020-08-06 | Los Angeles | 37 | 201200 | 4869 | 3023 | 41 |
22813 | 22813 | 2020-08-05 | Los Angeles | 37 | 198177 | 4828 | 2372 | 68 |
22871 | 22871 | 2020-08-04 | Los Angeles | 37 | 195805 | 4760 | 1928 | 58 |
22929 | 22929 | 2020-08-03 | Los Angeles | 37 | 193877 | 4702 | 1700 | 9 |
22987 | 22987 | 2020-08-02 | Los Angeles | 37 | 192177 | 4693 | 1320 | 24 |
23045 | 23045 | 2020-08-01 | Los Angeles | 37 | 190857 | 4669 | 2316 | 45 |
23103 | 23103 | 2020-07-31 | Los Angeles | 37 | 188541 | 4624 | 2505 | 65 |
23161 | 23161 | 2020-07-30 | Los Angeles | 37 | 186036 | 4559 | 2580 | 41 |
23219 | 23219 | 2020-07-29 | Los Angeles | 37 | 183456 | 4518 | 4793 | 91 |
23277 | 23277 | 2020-07-28 | Los Angeles | 37 | 178663 | 4427 | 2527 | 52 |
23335 | 23335 | 2020-07-27 | Los Angeles | 37 | 176136 | 4375 | 2119 | 15 |
23393 | 23393 | 2020-07-26 | Los Angeles | 37 | 174017 | 4360 | 1674 | 9 |
23451 | 23451 | 2020-07-25 | Los Angeles | 37 | 172343 | 4351 | 3408 | 51 |
23509 | 23509 | 2020-07-24 | Los Angeles | 37 | 168935 | 4300 | 1905 | 37 |
23567 | 23567 | 2020-07-23 | Los Angeles | 37 | 167030 | 4263 | 1896 | 48 |
23625 | 23625 | 2020-07-22 | Los Angeles | 37 | 165134 | 4215 | 3109 | 60 |
23683 | 23683 | 2020-07-21 | Los Angeles | 37 | 162025 | 4155 | 2903 | 50 |
23741 | 23741 | 2020-07-20 | Los Angeles | 37 | 159122 | 4105 | 3205 | 9 |
23799 | 23799 | 2020-07-19 | Los Angeles | 37 | 155917 | 4096 | 2738 | 12 |
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 );