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

559 rows where fips = 111 sorted by date descending

✎ View and edit SQL

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

Suggested facets: new_deaths, date (date)

fips 1

  • 111 · 559 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
56 56 2021-09-02 Ventura 111 90731 1084 0 3
114 114 2021-09-01 Ventura 111 90731 1081 154 5
172 172 2021-08-31 Ventura 111 90577 1076 242 2
230 230 2021-08-30 Ventura 111 90335 1074 469 2
288 288 2021-08-29 Ventura 111 89866 1072 0 0
346 346 2021-08-28 Ventura 111 89866 1072 0 0
404 404 2021-08-27 Ventura 111 89866 1072 183 4
462 462 2021-08-26 Ventura 111 89683 1068 248 4
520 520 2021-08-25 Ventura 111 89435 1064 196 3
578 578 2021-08-24 Ventura 111 89239 1061 259 2
636 636 2021-08-23 Ventura 111 88980 1059 701 4
694 694 2021-08-22 Ventura 111 88279 1055 0 0
752 752 2021-08-21 Ventura 111 88279 1055 0 0
810 810 2021-08-20 Ventura 111 88279 1055 598 3
868 868 2021-08-19 Ventura 111 87681 1052 224 1
926 926 2021-08-18 Ventura 111 87457 1051 255 1
984 984 2021-08-17 Ventura 111 87202 1050 225 2
1042 1042 2021-08-16 Ventura 111 86977 1048 537 2
1100 1100 2021-08-15 Ventura 111 86440 1046 0 0
1158 1158 2021-08-14 Ventura 111 86440 1046 0 0
1216 1216 2021-08-13 Ventura 111 86440 1046 289 0
1274 1274 2021-08-12 Ventura 111 86151 1046 166 1
1332 1332 2021-08-11 Ventura 111 85985 1045 127 1
1390 1390 2021-08-10 Ventura 111 85858 1044 186 0
1448 1448 2021-08-09 Ventura 111 85672 1044 598 5
1506 1506 2021-08-08 Ventura 111 85074 1039 0 0
1564 1564 2021-08-07 Ventura 111 85074 1039 0 0
1622 1622 2021-08-06 Ventura 111 85074 1039 485 0
1680 1680 2021-08-05 Ventura 111 84589 1039 0 0
1738 1738 2021-08-04 Ventura 111 84589 1039 269 0
1796 1796 2021-08-03 Ventura 111 84320 1039 0 0
1854 1854 2021-08-02 Ventura 111 84320 1039 451 3
1912 1912 2021-08-01 Ventura 111 83869 1036 0 0
1970 1970 2021-07-31 Ventura 111 83869 1036 0 0
2028 2028 2021-07-30 Ventura 111 83869 1036 346 0
2086 2086 2021-07-29 Ventura 111 83523 1036 0 0
2144 2144 2021-07-28 Ventura 111 83523 1036 268 1
2202 2202 2021-07-27 Ventura 111 83255 1035 0 0
2260 2260 2021-07-26 Ventura 111 83255 1035 280 2
2318 2318 2021-07-25 Ventura 111 82975 1033 0 0
2376 2376 2021-07-24 Ventura 111 82975 1033 0 0
2434 2434 2021-07-23 Ventura 111 82975 1033 241 0
2492 2492 2021-07-22 Ventura 111 82734 1033 0 0
2550 2550 2021-07-21 Ventura 111 82734 1033 150 0
2608 2608 2021-07-20 Ventura 111 82584 1033 0 0
2666 2666 2021-07-19 Ventura 111 82584 1033 242 1
2724 2724 2021-07-18 Ventura 111 82342 1032 0 0
2782 2782 2021-07-17 Ventura 111 82342 1032 0 0
2840 2840 2021-07-16 Ventura 111 82342 1032 182 0
2898 2898 2021-07-15 Ventura 111 82160 1032 0 0
2956 2956 2021-07-14 Ventura 111 82160 1032 80 0
3014 3014 2021-07-13 Ventura 111 82080 1032 0 0
3072 3072 2021-07-12 Ventura 111 82080 1032 108 0
3130 3130 2021-07-11 Ventura 111 81972 1032 0 0
3188 3188 2021-07-10 Ventura 111 81972 1032 0 0
3246 3246 2021-07-09 Ventura 111 81972 1032 0 0
3304 3304 2021-07-08 Ventura 111 81972 1032 0 0
3362 3362 2021-07-07 Ventura 111 81972 1032 25 4
3420 3420 2021-07-06 Ventura 111 81947 1028 0 0
3478 3478 2021-07-05 Ventura 111 81947 1028 0 0
3536 3536 2021-07-04 Ventura 111 81947 1028 0 0
3594 3594 2021-07-03 Ventura 111 81947 1028 0 0
3652 3652 2021-07-02 Ventura 111 81947 1028 63 0
3710 3710 2021-07-01 Ventura 111 81884 1028 0 0
3768 3768 2021-06-30 Ventura 111 81884 1028 108 0
3826 3826 2021-06-29 Ventura 111 81776 1028 0 0
3884 3884 2021-06-28 Ventura 111 81776 1028 26 1
3942 3942 2021-06-27 Ventura 111 81750 1027 0 0
4000 4000 2021-06-26 Ventura 111 81750 1027 0 0
4058 4058 2021-06-25 Ventura 111 81750 1027 23 0
4116 4116 2021-06-24 Ventura 111 81727 1027 0 0
4174 4174 2021-06-23 Ventura 111 81727 1027 66 0
4232 4232 2021-06-22 Ventura 111 81661 1027 0 0
4290 4290 2021-06-21 Ventura 111 81661 1027 23 2
4348 4348 2021-06-20 Ventura 111 81638 1025 0 0
4406 4406 2021-06-19 Ventura 111 81638 1025 0 0
4464 4464 2021-06-18 Ventura 111 81638 1025 29 0
4522 4522 2021-06-17 Ventura 111 81609 1025 0 0
4580 4580 2021-06-16 Ventura 111 81609 1025 37 0
4638 4638 2021-06-15 Ventura 111 81572 1025 0 0
4696 4696 2021-06-14 Ventura 111 81572 1025 18 0
4754 4754 2021-06-13 Ventura 111 81554 1025 0 0
4812 4812 2021-06-12 Ventura 111 81554 1025 0 0
4870 4870 2021-06-11 Ventura 111 81554 1025 8 2
4928 4928 2021-06-10 Ventura 111 81546 1023 18 1
4986 4986 2021-06-09 Ventura 111 81528 1022 17 0
5044 5044 2021-06-08 Ventura 111 81511 1022 4 0
5102 5102 2021-06-07 Ventura 111 81507 1022 50 0
5160 5160 2021-06-06 Ventura 111 81457 1022 0 0
5218 5218 2021-06-05 Ventura 111 81457 1022 0 0
5276 5276 2021-06-04 Ventura 111 81457 1022 36 1
5334 5334 2021-06-03 Ventura 111 81421 1021 25 0
5392 5392 2021-06-02 Ventura 111 81396 1021 14 3
5450 5450 2021-06-01 Ventura 111 81382 1018 38 0
5508 5508 2021-05-31 Ventura 111 81344 1018 0 0
5566 5566 2021-05-30 Ventura 111 81344 1018 0 0
5624 5624 2021-05-29 Ventura 111 81344 1018 0 0
5682 5682 2021-05-28 Ventura 111 81344 1018 16 0
5740 5740 2021-05-27 Ventura 111 81328 1018 33 0
5798 5798 2021-05-26 Ventura 111 81295 1018 15 0

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
);