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

581 rows where fips = 69 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

  • 69 · 581 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
35 35 2021-09-02 San Benito 69 6767 65 37 0
93 93 2021-09-01 San Benito 69 6730 65 34 0
151 151 2021-08-31 San Benito 69 6696 65 0 0
209 209 2021-08-30 San Benito 69 6696 65 39 0
267 267 2021-08-29 San Benito 69 6657 65 0 0
325 325 2021-08-28 San Benito 69 6657 65 0 0
383 383 2021-08-27 San Benito 69 6657 65 21 0
441 441 2021-08-26 San Benito 69 6636 65 13 0
499 499 2021-08-25 San Benito 69 6623 65 13 0
557 557 2021-08-24 San Benito 69 6610 65 12 1
615 615 2021-08-23 San Benito 69 6598 64 34 0
673 673 2021-08-22 San Benito 69 6564 64 0 0
731 731 2021-08-21 San Benito 69 6564 64 41 0
789 789 2021-08-20 San Benito 69 6523 64 0 0
847 847 2021-08-19 San Benito 69 6523 64 11 0
905 905 2021-08-18 San Benito 69 6512 64 18 0
963 963 2021-08-17 San Benito 69 6494 64 19 0
1021 1021 2021-08-16 San Benito 69 6475 64 28 0
1079 1079 2021-08-15 San Benito 69 6447 64 0 0
1137 1137 2021-08-14 San Benito 69 6447 64 0 0
1195 1195 2021-08-13 San Benito 69 6447 64 15 0
1253 1253 2021-08-12 San Benito 69 6432 64 21 0
1311 1311 2021-08-11 San Benito 69 6411 64 14 0
1369 1369 2021-08-10 San Benito 69 6397 64 15 0
1427 1427 2021-08-09 San Benito 69 6382 64 40 0
1485 1485 2021-08-08 San Benito 69 6342 64 0 0
1543 1543 2021-08-07 San Benito 69 6342 64 0 0
1601 1601 2021-08-06 San Benito 69 6342 64 6 0
1659 1659 2021-08-05 San Benito 69 6336 64 10 0
1717 1717 2021-08-04 San Benito 69 6326 64 10 1
1775 1775 2021-08-03 San Benito 69 6316 63 13 0
1833 1833 2021-08-02 San Benito 69 6303 63 21 0
1891 1891 2021-08-01 San Benito 69 6282 63 0 0
1949 1949 2021-07-31 San Benito 69 6282 63 0 0
2007 2007 2021-07-30 San Benito 69 6282 63 8 0
2065 2065 2021-07-29 San Benito 69 6274 63 11 0
2123 2123 2021-07-28 San Benito 69 6263 63 9 0
2181 2181 2021-07-27 San Benito 69 6254 63 6 0
2239 2239 2021-07-26 San Benito 69 6248 63 19 0
2297 2297 2021-07-25 San Benito 69 6229 63 0 0
2355 2355 2021-07-24 San Benito 69 6229 63 0 0
2413 2413 2021-07-23 San Benito 69 6229 63 5 0
2471 2471 2021-07-22 San Benito 69 6224 63 5 0
2529 2529 2021-07-21 San Benito 69 6219 63 2 0
2587 2587 2021-07-20 San Benito 69 6217 63 0 0
2645 2645 2021-07-19 San Benito 69 6217 63 13 0
2703 2703 2021-07-18 San Benito 69 6204 63 0 0
2761 2761 2021-07-17 San Benito 69 6204 63 0 0
2819 2819 2021-07-16 San Benito 69 6204 63 4 0
2877 2877 2021-07-15 San Benito 69 6200 63 4 0
2935 2935 2021-07-14 San Benito 69 6196 63 4 0
2993 2993 2021-07-13 San Benito 69 6192 63 7 0
3051 3051 2021-07-12 San Benito 69 6185 63 12 0
3109 3109 2021-07-11 San Benito 69 6173 63 0 0
3167 3167 2021-07-10 San Benito 69 6173 63 0 0
3225 3225 2021-07-09 San Benito 69 6173 63 6 0
3283 3283 2021-07-08 San Benito 69 6167 63 11 0
3341 3341 2021-07-07 San Benito 69 6156 63 3 0
3399 3399 2021-07-06 San Benito 69 6153 63 18 0
3457 3457 2021-07-05 San Benito 69 6135 63 0 0
3515 3515 2021-07-04 San Benito 69 6135 63 0 0
3573 3573 2021-07-03 San Benito 69 6135 63 0 0
3631 3631 2021-07-02 San Benito 69 6135 63 5 0
3689 3689 2021-07-01 San Benito 69 6130 63 9 0
3747 3747 2021-06-30 San Benito 69 6121 63 5 0
3805 3805 2021-06-29 San Benito 69 6116 63 4 0
3863 3863 2021-06-28 San Benito 69 6112 63 1 0
3921 3921 2021-06-27 San Benito 69 6111 63 0 0
3979 3979 2021-06-26 San Benito 69 6111 63 0 0
4037 4037 2021-06-25 San Benito 69 6111 63 0 0
4095 4095 2021-06-24 San Benito 69 6111 63 0 0
4153 4153 2021-06-23 San Benito 69 6111 63 2 0
4211 4211 2021-06-22 San Benito 69 6109 63 0 0
4269 4269 2021-06-21 San Benito 69 6109 63 0 0
4327 4327 2021-06-20 San Benito 69 6109 63 0 0
4385 4385 2021-06-19 San Benito 69 6109 63 0 0
4443 4443 2021-06-18 San Benito 69 6109 63 0 0
4501 4501 2021-06-17 San Benito 69 6109 63 5 0
4559 4559 2021-06-16 San Benito 69 6104 63 2 0
4617 4617 2021-06-15 San Benito 69 6102 63 0 0
4675 4675 2021-06-14 San Benito 69 6102 63 7 0
4733 4733 2021-06-13 San Benito 69 6095 63 0 0
4791 4791 2021-06-12 San Benito 69 6095 63 0 0
4849 4849 2021-06-11 San Benito 69 6095 63 1 0
4907 4907 2021-06-10 San Benito 69 6094 63 0 0
4965 4965 2021-06-09 San Benito 69 6094 63 0 0
5023 5023 2021-06-08 San Benito 69 6094 63 4 0
5081 5081 2021-06-07 San Benito 69 6090 63 1 0
5139 5139 2021-06-06 San Benito 69 6089 63 0 0
5197 5197 2021-06-05 San Benito 69 6089 63 0 0
5255 5255 2021-06-04 San Benito 69 6089 63 1 0
5313 5313 2021-06-03 San Benito 69 6088 63 0 0
5371 5371 2021-06-02 San Benito 69 6088 63 0 0
5429 5429 2021-06-01 San Benito 69 6088 63 0 0
5487 5487 2021-05-31 San Benito 69 6088 63 0 0
5545 5545 2021-05-30 San Benito 69 6088 63 0 0
5603 5603 2021-05-29 San Benito 69 6088 63 0 0
5661 5661 2021-05-28 San Benito 69 6088 63 0 0
5719 5719 2021-05-27 San Benito 69 6088 63 0 0
5777 5777 2021-05-26 San Benito 69 6088 63 0 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
);