latimes_agency_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_agency_totals

559 rows where agency = "Ventura" and county = "Ventura" sorted by date descending

✎ View and edit SQL

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

Suggested facets: did_not_update, date (date)

fips 1

county 1

  • Ventura · 559 ✖

agency 1

  • Ventura · 559 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
59 59 Ventura Ventura 111 2021-09-02 90731 1084  
120 120 Ventura Ventura 111 2021-09-01 90731 1081  
181 181 Ventura Ventura 111 2021-08-31 90577 1076  
242 242 Ventura Ventura 111 2021-08-30 90335 1074  
303 303 Ventura Ventura 111 2021-08-29 89866 1072 TRUE
364 364 Ventura Ventura 111 2021-08-28 89866 1072 TRUE
425 425 Ventura Ventura 111 2021-08-27 89866 1072  
486 486 Ventura Ventura 111 2021-08-26 89683 1068  
547 547 Ventura Ventura 111 2021-08-25 89435 1064  
608 608 Ventura Ventura 111 2021-08-24 89239 1061  
669 669 Ventura Ventura 111 2021-08-23 88980 1059  
730 730 Ventura Ventura 111 2021-08-22 88279 1055 TRUE
791 791 Ventura Ventura 111 2021-08-21 88279 1055 TRUE
852 852 Ventura Ventura 111 2021-08-20 88279 1055  
913 913 Ventura Ventura 111 2021-08-19 87681 1052  
974 974 Ventura Ventura 111 2021-08-18 87457 1051  
1035 1035 Ventura Ventura 111 2021-08-17 87202 1050  
1096 1096 Ventura Ventura 111 2021-08-16 86977 1048  
1157 1157 Ventura Ventura 111 2021-08-15 86440 1046 TRUE
1218 1218 Ventura Ventura 111 2021-08-14 86440 1046 TRUE
1279 1279 Ventura Ventura 111 2021-08-13 86440 1046  
1340 1340 Ventura Ventura 111 2021-08-12 86151 1046  
1401 1401 Ventura Ventura 111 2021-08-11 85985 1045  
1462 1462 Ventura Ventura 111 2021-08-10 85858 1044  
1523 1523 Ventura Ventura 111 2021-08-09 85672 1044  
1584 1584 Ventura Ventura 111 2021-08-08 85074 1039 TRUE
1645 1645 Ventura Ventura 111 2021-08-07 85074 1039 TRUE
1706 1706 Ventura Ventura 111 2021-08-06 85074 1039  
1767 1767 Ventura Ventura 111 2021-08-05 84589 1039 TRUE
1828 1828 Ventura Ventura 111 2021-08-04 84589 1039  
1889 1889 Ventura Ventura 111 2021-08-03 84320 1039  
1950 1950 Ventura Ventura 111 2021-08-02 84320 1039  
2011 2011 Ventura Ventura 111 2021-08-01 83869 1036 TRUE
2072 2072 Ventura Ventura 111 2021-07-31 83869 1036 TRUE
2133 2133 Ventura Ventura 111 2021-07-30 83869 1036  
2194 2194 Ventura Ventura 111 2021-07-29 83523 1036 TRUE
2255 2255 Ventura Ventura 111 2021-07-28 83523 1036  
2316 2316 Ventura Ventura 111 2021-07-27 83255 1035 TRUE
2377 2377 Ventura Ventura 111 2021-07-26 83255 1035  
2438 2438 Ventura Ventura 111 2021-07-25 82975 1033 TRUE
2499 2499 Ventura Ventura 111 2021-07-24 82975 1033 TRUE
2560 2560 Ventura Ventura 111 2021-07-23 82975 1033  
2621 2621 Ventura Ventura 111 2021-07-22 82734 1033  
2682 2682 Ventura Ventura 111 2021-07-21 82734 1033  
2743 2743 Ventura Ventura 111 2021-07-20 82584 1033 TRUE
2804 2804 Ventura Ventura 111 2021-07-19 82584 1033  
2865 2865 Ventura Ventura 111 2021-07-18 82342 1032 TRUE
2926 2926 Ventura Ventura 111 2021-07-17 82342 1032 TRUE
2987 2987 Ventura Ventura 111 2021-07-16 82342 1032  
3048 3048 Ventura Ventura 111 2021-07-15 82160 1032 TRUE
3109 3109 Ventura Ventura 111 2021-07-14 82160 1032  
3170 3170 Ventura Ventura 111 2021-07-13 82080 1032 TRUE
3231 3231 Ventura Ventura 111 2021-07-12 82080 1032  
3292 3292 Ventura Ventura 111 2021-07-11 81972 1032 TRUE
3353 3353 Ventura Ventura 111 2021-07-10 81972 1032 TRUE
3414 3414 Ventura Ventura 111 2021-07-09 81972 1032  
3475 3475 Ventura Ventura 111 2021-07-08 81972 1032 TRUE
3536 3536 Ventura Ventura 111 2021-07-07 81972 1032  
3597 3597 Ventura Ventura 111 2021-07-06 81947 1028  
3658 3658 Ventura Ventura 111 2021-07-05 81947 1028  
3719 3719 Ventura Ventura 111 2021-07-04 81947 1028 TRUE
3780 3780 Ventura Ventura 111 2021-07-03 81947 1028 TRUE
3841 3841 Ventura Ventura 111 2021-07-02 81947 1028  
3902 3902 Ventura Ventura 111 2021-07-01 81884 1028  
3963 3963 Ventura Ventura 111 2021-06-30 81884 1028  
4024 4024 Ventura Ventura 111 2021-06-29 81776 1028  
4085 4085 Ventura Ventura 111 2021-06-28 81776 1028  
4146 4146 Ventura Ventura 111 2021-06-27 81750 1027 TRUE
4207 4207 Ventura Ventura 111 2021-06-26 81750 1027 TRUE
4268 4268 Ventura Ventura 111 2021-06-25 81750 1027  
4329 4329 Ventura Ventura 111 2021-06-24 81727 1027 TRUE
4390 4390 Ventura Ventura 111 2021-06-23 81727 1027  
4451 4451 Ventura Ventura 111 2021-06-22 81661 1027 TRUE
4512 4512 Ventura Ventura 111 2021-06-21 81661 1027  
4573 4573 Ventura Ventura 111 2021-06-20 81638 1025 TRUE
4634 4634 Ventura Ventura 111 2021-06-19 81638 1025 TRUE
4695 4695 Ventura Ventura 111 2021-06-18 81638 1025  
4756 4756 Ventura Ventura 111 2021-06-17 81609 1025 TRUE
4817 4817 Ventura Ventura 111 2021-06-16 81609 1025  
4878 4878 Ventura Ventura 111 2021-06-15 81572 1025  
4939 4939 Ventura Ventura 111 2021-06-14 81572 1025  
5000 5000 Ventura Ventura 111 2021-06-13 81554 1025  
5061 5061 Ventura Ventura 111 2021-06-12 81554 1025 TRUE
5122 5122 Ventura Ventura 111 2021-06-11 81554 1025  
5183 5183 Ventura Ventura 111 2021-06-10 81546 1023  
5244 5244 Ventura Ventura 111 2021-06-09 81528 1022  
5305 5305 Ventura Ventura 111 2021-06-08 81511 1022  
5366 5366 Ventura Ventura 111 2021-06-07 81507 1022  
5427 5427 Ventura Ventura 111 2021-06-06 81457 1022  
5488 5488 Ventura Ventura 111 2021-06-05 81457 1022  
5549 5549 Ventura Ventura 111 2021-06-04 81457 1022  
5610 5610 Ventura Ventura 111 2021-06-03 81421 1021  
5671 5671 Ventura Ventura 111 2021-06-02 81396 1021  
5732 5732 Ventura Ventura 111 2021-06-01 81382 1018  
5793 5793 Ventura Ventura 111 2021-05-31 81344 1018 TRUE
5854 5854 Ventura Ventura 111 2021-05-30 81344 1018  
5915 5915 Ventura Ventura 111 2021-05-29 81344 1018  
5976 5976 Ventura Ventura 111 2021-05-28 81344 1018  
6037 6037 Ventura Ventura 111 2021-05-27 81328 1018  
6098 6098 Ventura Ventura 111 2021-05-26 81295 1018  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);