latimes_county_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 37 · 586 ✖

county 1

  • Los Angeles · 586 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
19 19 2021-09-02 Los Angeles 37 1412379 25366 2695 40
77 77 2021-09-01 Los Angeles 37 1409684 25326 3895 73
135 135 2021-08-31 Los Angeles 37 1405789 25253 2594 6
193 193 2021-08-30 Los Angeles 37 1403195 25247 142 2
251 251 2021-08-29 Los Angeles 37 1403053 25245 2216 5
309 309 2021-08-28 Los Angeles 37 1400837 25240 3357 26
367 367 2021-08-27 Los Angeles 37 1397480 25214 2848 32
425 425 2021-08-26 Los Angeles 37 1394632 25182 3119 30
483 483 2021-08-25 Los Angeles 37 1391513 25152 2841 35
541 541 2021-08-24 Los Angeles 37 1388672 25117 2888 36
599 599 2021-08-23 Los Angeles 37 1385784 25081 2598 10
657 657 2021-08-22 Los Angeles 37 1383186 25071 2771 10
715 715 2021-08-21 Los Angeles 37 1380415 25061 3737 28
773 773 2021-08-20 Los Angeles 37 1376678 25033 13673 30
831 831 2021-08-19 Los Angeles 37 1363005 25003 3108 36
889 889 2021-08-18 Los Angeles 37 1359897 24967 3648 32
947 947 2021-08-17 Los Angeles 37 1356249 24935 3178 29
1005 1005 2021-08-16 Los Angeles 37 1353071 24906 2701 6
1063 1063 2021-08-15 Los Angeles 37 1350370 24900 3347 8
1121 1121 2021-08-14 Los Angeles 37 1347023 24892 3937 19
1179 1179 2021-08-13 Los Angeles 37 1343086 24873 3790 17
1237 1237 2021-08-12 Los Angeles 37 1339296 24856 3746 22
1295 1295 2021-08-11 Los Angeles 37 1335550 24834 3261 28
1353 1353 2021-08-10 Los Angeles 37 1332289 24806 2752 23
1411 1411 2021-08-09 Los Angeles 37 1329537 24783 3176 6
1469 1469 2021-08-08 Los Angeles 37 1326361 24777 3016 8
1527 1527 2021-08-07 Los Angeles 37 1323345 24769 3853 13
1585 1585 2021-08-06 Los Angeles 37 1319492 24756 3815 16
1643 1643 2021-08-05 Los Angeles 37 1315677 24740 3914 17
1701 1701 2021-08-04 Los Angeles 37 1311763 24723 3793 19
1759 1759 2021-08-03 Los Angeles 37 1307970 24704 1891 14
1817 1817 2021-08-02 Los Angeles 37 1306079 24690 2736 5
1875 1875 2021-08-01 Los Angeles 37 1303343 24685 3030 3
1933 1933 2021-07-31 Los Angeles 37 1300313 24682 3226 6
1991 1991 2021-07-30 Los Angeles 37 1297087 24676 3504 0
2049 2049 2021-07-29 Los Angeles 37 1293583 24676 3188 18
2107 2107 2021-07-28 Los Angeles 37 1290395 24658 2305 15
2165 2165 2021-07-27 Los Angeles 37 1288090 24643 2127 11
2223 2223 2021-07-26 Los Angeles 37 1285963 24632 2119 4
2281 2281 2021-07-25 Los Angeles 37 1283844 24628 2084 4
2339 2339 2021-07-24 Los Angeles 37 1281760 24624 2461 9
2397 2397 2021-07-23 Los Angeles 37 1279299 24615 3045 7
2455 2455 2021-07-22 Los Angeles 37 1276254 24608 2703 14
2513 2513 2021-07-21 Los Angeles 37 1273551 24594 2372 6
2571 2571 2021-07-20 Los Angeles 37 1271179 24588 1962 3
2629 2629 2021-07-19 Los Angeles 37 1269217 24585 1357 2
2687 2687 2021-07-18 Los Angeles 37 1267860 24583 1633 4
2745 2745 2021-07-17 Los Angeles 37 1266227 24579 1669 11
2803 2803 2021-07-16 Los Angeles 37 1264558 24568 1887 1
2861 2861 2021-07-15 Los Angeles 37 1262671 24567 1507 4
2919 2919 2021-07-14 Los Angeles 37 1261164 24563 1172 9
2977 2977 2021-07-13 Los Angeles 37 1259992 24554 1307 11
3035 3035 2021-07-12 Los Angeles 37 1258685 24543 1057 1
3093 3093 2021-07-11 Los Angeles 37 1257628 24542 1113 4
3151 3151 2021-07-10 Los Angeles 37 1256515 24538 1069 8
3209 3209 2021-07-09 Los Angeles 37 1255446 24530 1044 3
3267 3267 2021-07-08 Los Angeles 37 1254402 24527 780 13
3325 3325 2021-07-07 Los Angeles 37 1253622 24514 516 6
3383 3383 2021-07-06 Los Angeles 37 1253106 24508 790 6
3441 3441 2021-07-05 Los Angeles 37 1252316 24502 460 4
3499 3499 2021-07-04 Los Angeles 37 1251856 24498 593 6
3557 3557 2021-07-03 Los Angeles 37 1251263 24492 4 0
3615 3615 2021-07-02 Los Angeles 37 1251259 24492 512 3
3673 3673 2021-07-01 Los Angeles 37 1250747 24489 497 6
3731 3731 2021-06-30 Los Angeles 37 1250250 24483 375 1
3789 3789 2021-06-29 Los Angeles 37 1249875 24482 303 2
3847 3847 2021-06-28 Los Angeles 37 1249572 24480 268 3
3905 3905 2021-06-27 Los Angeles 37 1249304 24477 239 3
3963 3963 2021-06-26 Los Angeles 37 1249065 24474 301 6
4021 4021 2021-06-25 Los Angeles 37 1248764 24468 602 11
4079 4079 2021-06-24 Los Angeles 37 1248162 24457 1 0
4137 4137 2021-06-23 Los Angeles 37 1248161 24457 252 12
4195 4195 2021-06-22 Los Angeles 37 1247909 24445 165 1
4253 4253 2021-06-21 Los Angeles 37 1247744 24444 126 3
4311 4311 2021-06-20 Los Angeles 37 1247618 24441 258 2
4369 4369 2021-06-19 Los Angeles 37 1247360 24439 144 4
4427 4427 2021-06-18 Los Angeles 37 1247216 24435 183 7
4485 4485 2021-06-17 Los Angeles 37 1247033 24428 201 6
4543 4543 2021-06-16 Los Angeles 37 1246832 24422 192 5
4601 4601 2021-06-15 Los Angeles 37 1246640 24417 204 2
4659 4659 2021-06-14 Los Angeles 37 1246436 24415 129 1
4717 4717 2021-06-13 Los Angeles 37 1246307 24414 184 0
4775 4775 2021-06-12 Los Angeles 37 1246123 24414 177 0
4833 4833 2021-06-11 Los Angeles 37 1245946 24414 160 0
4891 4891 2021-06-10 Los Angeles 37 1245786 24414 183 5
4949 4949 2021-06-09 Los Angeles 37 1245603 24409 174 5
5007 5007 2021-06-08 Los Angeles 37 1245429 24404 162 12
5065 5065 2021-06-07 Los Angeles 37 1245267 24392 147 3
5123 5123 2021-06-06 Los Angeles 37 1245120 24389 203 0
5181 5181 2021-06-05 Los Angeles 37 1244917 24389 233 10
5239 5239 2021-06-04 Los Angeles 37 1244684 24379 211 12
5297 5297 2021-06-03 Los Angeles 37 1244473 24367 198 13
5355 5355 2021-06-02 Los Angeles 37 1244275 24354 105 8
5413 5413 2021-06-01 Los Angeles 37 1244170 24346 116 3
5471 5471 2021-05-31 Los Angeles 37 1244054 24343 172 4
5529 5529 2021-05-30 Los Angeles 37 1243882 24339 170 1
5587 5587 2021-05-29 Los Angeles 37 1243712 24338 181 5
5645 5645 2021-05-28 Los Angeles 37 1243531 24333 193 10
5703 5703 2021-05-27 Los Angeles 37 1243338 24323 4032 128
5761 5761 2021-05-26 Los Angeles 37 1239306 24195 179 9

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);