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" and fips = 37 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 |
---|---|---|---|---|---|---|---|---|
5819 | 5819 | 2021-05-25 | Los Angeles | 37 | 1239127 | 24186 | 195 | 11 |
5877 | 5877 | 2021-05-24 | Los Angeles | 37 | 1238932 | 24175 | 151 | 4 |
5935 | 5935 | 2021-05-23 | Los Angeles | 37 | 1238781 | 24171 | 174 | 5 |
5993 | 5993 | 2021-05-22 | Los Angeles | 37 | 1238607 | 24166 | 225 | 13 |
6051 | 6051 | 2021-05-21 | Los Angeles | 37 | 1238382 | 24153 | 235 | 12 |
6109 | 6109 | 2021-05-20 | Los Angeles | 37 | 1238147 | 24141 | 237 | 24 |
6167 | 6167 | 2021-05-19 | Los Angeles | 37 | 1237910 | 24117 | 210 | 11 |
6225 | 6225 | 2021-05-18 | Los Angeles | 37 | 1237700 | 24106 | 134 | 9 |
6283 | 6283 | 2021-05-17 | Los Angeles | 37 | 1237566 | 24097 | 155 | 3 |
6341 | 6341 | 2021-05-16 | Los Angeles | 37 | 1237411 | 24094 | 138 | 5 |
6399 | 6399 | 2021-05-15 | Los Angeles | 37 | 1237273 | 24089 | 252 | 15 |
6457 | 6457 | 2021-05-14 | Los Angeles | 37 | 1237021 | 24074 | 552 | 17 |
6515 | 6515 | 2021-05-13 | Los Angeles | 37 | 1236469 | 24057 | 213 | 16 |
6573 | 6573 | 2021-05-12 | Los Angeles | 37 | 1236256 | 24041 | 257 | 20 |
6631 | 6631 | 2021-05-11 | Los Angeles | 37 | 1235999 | 24021 | 171 | 18 |
6689 | 6689 | 2021-05-10 | Los Angeles | 37 | 1235828 | 24003 | 177 | 4 |
6747 | 6747 | 2021-05-09 | Los Angeles | 37 | 1235651 | 23999 | 229 | 4 |
6805 | 6805 | 2021-05-08 | Los Angeles | 37 | 1235422 | 23995 | 272 | 14 |
6863 | 6863 | 2021-05-07 | Los Angeles | 37 | 1235150 | 23981 | 368 | 17 |
6921 | 6921 | 2021-05-06 | Los Angeles | 37 | 1234782 | 23964 | 377 | 16 |
6979 | 6979 | 2021-05-05 | Los Angeles | 37 | 1234405 | 23948 | 163 | 18 |
7037 | 7037 | 2021-05-04 | Los Angeles | 37 | 1234242 | 23930 | 244 | 16 |
7095 | 7095 | 2021-05-03 | Los Angeles | 37 | 1233998 | 23914 | 226 | 0 |
7153 | 7153 | 2021-05-02 | Los Angeles | 37 | 1233772 | 23914 | 267 | -1 |
7211 | 7211 | 2021-05-01 | Los Angeles | 37 | 1233505 | 23915 | 414 | 23 |
7269 | 7269 | 2021-04-30 | Los Angeles | 37 | 1233091 | 23892 | 340 | 20 |
7327 | 7327 | 2021-04-29 | Los Angeles | 37 | 1232751 | 23872 | 360 | 39 |
7385 | 7385 | 2021-04-28 | Los Angeles | 37 | 1232391 | 23833 | 260 | 29 |
7443 | 7443 | 2021-04-27 | Los Angeles | 37 | 1232131 | 23804 | 293 | 26 |
7501 | 7501 | 2021-04-26 | Los Angeles | 37 | 1231838 | 23778 | 306 | 5 |
7559 | 7559 | 2021-04-25 | Los Angeles | 37 | 1231532 | 23773 | 346 | 0 |
7617 | 7617 | 2021-04-24 | Los Angeles | 37 | 1231186 | 23773 | 371 | 14 |
7675 | 7675 | 2021-04-23 | Los Angeles | 37 | 1230815 | 23759 | 417 | 23 |
7733 | 7733 | 2021-04-22 | Los Angeles | 37 | 1230398 | 23736 | 381 | 34 |
7791 | 7791 | 2021-04-21 | Los Angeles | 37 | 1230017 | 23702 | 657 | 61 |
7849 | 7849 | 2021-04-20 | Los Angeles | 37 | 1229360 | 23641 | 32 | 0 |
7907 | 7907 | 2021-04-19 | Los Angeles | 37 | 1229328 | 23641 | 331 | 18 |
7965 | 7965 | 2021-04-18 | Los Angeles | 37 | 1228997 | 23623 | 356 | 0 |
8023 | 8023 | 2021-04-17 | Los Angeles | 37 | 1228641 | 23623 | 523 | 22 |
8081 | 8081 | 2021-04-16 | Los Angeles | 37 | 1228118 | 23601 | 581 | 28 |
8139 | 8139 | 2021-04-15 | Los Angeles | 37 | 1227537 | 23573 | 535 | 19 |
8197 | 8197 | 2021-04-14 | Los Angeles | 37 | 1227002 | 23554 | 375 | 54 |
8255 | 8255 | 2021-04-13 | Los Angeles | 37 | 1226627 | 23500 | 408 | 21 |
8313 | 8313 | 2021-04-12 | Los Angeles | 37 | 1226219 | 23479 | 423 | 2 |
8371 | 8371 | 2021-04-11 | Los Angeles | 37 | 1225796 | 23477 | 497 | 10 |
8429 | 8429 | 2021-04-10 | Los Angeles | 37 | 1225299 | 23467 | 752 | 36 |
8487 | 8487 | 2021-04-09 | Los Angeles | 37 | 1224547 | 23431 | 726 | 41 |
8545 | 8545 | 2021-04-08 | Los Angeles | 37 | 1223821 | 23390 | 616 | 46 |
8603 | 8603 | 2021-04-07 | Los Angeles | 37 | 1223205 | 23344 | 403 | 48 |
8661 | 8661 | 2021-04-06 | Los Angeles | 37 | 1222802 | 23296 | 323 | 20 |
8719 | 8719 | 2021-04-05 | Los Angeles | 37 | 1222479 | 23276 | 365 | 1 |
8777 | 8777 | 2021-04-04 | Los Angeles | 37 | 1222114 | 23275 | 822 | 1 |
8835 | 8835 | 2021-04-03 | Los Angeles | 37 | 1221292 | 23274 | 399 | 38 |
8893 | 8893 | 2021-04-02 | Los Angeles | 37 | 1220893 | 23236 | 637 | 45 |
8951 | 8951 | 2021-04-01 | Los Angeles | 37 | 1220256 | 23191 | 642 | 47 |
9009 | 9009 | 2021-03-31 | Los Angeles | 37 | 1219614 | 23144 | 585 | 33 |
9067 | 9067 | 2021-03-30 | Los Angeles | 37 | 1219029 | 23111 | 386 | 27 |
9125 | 9125 | 2021-03-29 | Los Angeles | 37 | 1218643 | 23084 | 414 | 7 |
9183 | 9183 | 2021-03-28 | Los Angeles | 37 | 1218229 | 23077 | 454 | 0 |
9241 | 9241 | 2021-03-27 | Los Angeles | 37 | 1217775 | 23077 | 659 | 21 |
9299 | 9299 | 2021-03-26 | Los Angeles | 37 | 1217116 | 23056 | 797 | 34 |
9357 | 9357 | 2021-03-25 | Los Angeles | 37 | 1216319 | 23022 | 547 | 57 |
9415 | 9415 | 2021-03-24 | Los Angeles | 37 | 1215772 | 22965 | 593 | 86 |
9473 | 9473 | 2021-03-23 | Los Angeles | 37 | 1215179 | 22879 | 425 | 64 |
9531 | 9531 | 2021-03-22 | Los Angeles | 37 | 1214754 | 22815 | 576 | 19 |
9589 | 9589 | 2021-03-21 | Los Angeles | 37 | 1214178 | 22796 | 386 | 19 |
9647 | 9647 | 2021-03-20 | Los Angeles | 37 | 1213792 | 22777 | 511 | 56 |
9705 | 9705 | 2021-03-19 | Los Angeles | 37 | 1213281 | 22721 | 651 | 55 |
9763 | 9763 | 2021-03-18 | Los Angeles | 37 | 1212630 | 22666 | 891 | 85 |
9821 | 9821 | 2021-03-17 | Los Angeles | 37 | 1211739 | 22581 | 778 | 60 |
9879 | 9879 | 2021-03-16 | Los Angeles | 37 | 1210961 | 22521 | 304 | 46 |
9937 | 9937 | 2021-03-15 | Los Angeles | 37 | 1210657 | 22475 | 387 | 1 |
9995 | 9995 | 2021-03-14 | Los Angeles | 37 | 1210270 | 22474 | 609 | 25 |
10053 | 10053 | 2021-03-13 | Los Angeles | 37 | 1209661 | 22449 | 712 | 42 |
10111 | 10111 | 2021-03-12 | Los Angeles | 37 | 1208949 | 22407 | 930 | 88 |
10169 | 10169 | 2021-03-11 | Los Angeles | 37 | 1208019 | 22319 | 1279 | 103 |
10227 | 10227 | 2021-03-10 | Los Angeles | 37 | 1206740 | 22216 | 1413 | 112 |
10285 | 10285 | 2021-03-09 | Los Angeles | 37 | 1205327 | 22104 | 1258 | 63 |
10343 | 10343 | 2021-03-08 | Los Angeles | 37 | 1204069 | 22041 | 917 | 12 |
10401 | 10401 | 2021-03-07 | Los Angeles | 37 | 1203152 | 22029 | 1284 | 14 |
10459 | 10459 | 2021-03-06 | Los Angeles | 37 | 1201868 | 22015 | 1752 | 105 |
10517 | 10517 | 2021-03-05 | Los Angeles | 37 | 1200116 | 21910 | 1938 | 130 |
10575 | 10575 | 2021-03-04 | Los Angeles | 37 | 1198178 | 21780 | 2161 | 104 |
10633 | 10633 | 2021-03-03 | Los Angeles | 37 | 1196017 | 21676 | 1684 | 107 |
10691 | 10691 | 2021-03-02 | Los Angeles | 37 | 1194333 | 21569 | 1379 | 102 |
10749 | 10749 | 2021-03-01 | Los Angeles | 37 | 1192954 | 21467 | 1027 | 32 |
10807 | 10807 | 2021-02-28 | Los Angeles | 37 | 1191927 | 21435 | 987 | 102 |
10865 | 10865 | 2021-02-27 | Los Angeles | 37 | 1190940 | 21333 | 1577 | 87 |
10923 | 10923 | 2021-02-26 | Los Angeles | 37 | 1189363 | 21246 | 1821 | 140 |
10981 | 10981 | 2021-02-25 | Los Angeles | 37 | 1187542 | 21106 | 1983 | 109 |
11039 | 11039 | 2021-02-24 | Los Angeles | 37 | 1185559 | 20997 | 2063 | 928 |
11097 | 11097 | 2021-02-23 | Los Angeles | 37 | 1183496 | 20069 | 2027 | 163 |
11155 | 11155 | 2021-02-22 | Los Angeles | 37 | 1181469 | 19906 | 964 | 21 |
11213 | 11213 | 2021-02-21 | Los Angeles | 37 | 1180505 | 19885 | 1356 | 84 |
11271 | 11271 | 2021-02-20 | Los Angeles | 37 | 1179149 | 19801 | 2306 | 131 |
11329 | 11329 | 2021-02-19 | Los Angeles | 37 | 1176843 | 19670 | 2398 | 145 |
11387 | 11387 | 2021-02-18 | Los Angeles | 37 | 1174445 | 19525 | 2580 | 144 |
11445 | 11445 | 2021-02-17 | Los Angeles | 37 | 1171865 | 19381 | 2177 | 165 |
11503 | 11503 | 2021-02-16 | Los Angeles | 37 | 1169688 | 19216 | 1316 | 121 |
11561 | 11561 | 2021-02-15 | Los Angeles | 37 | 1168372 | 19095 | 1820 | 27 |
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 );