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

545 rows where county = "Madera" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

county 1

  • Madera · 545 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
20 20 2021-09-02 Madera 39 18670 250 0 0
78 78 2021-09-01 Madera 39 18670 250 0 0
136 136 2021-08-31 Madera 39 18670 250 541 0
194 194 2021-08-30 Madera 39 18129 250 0 0
252 252 2021-08-29 Madera 39 18129 250 0 0
310 310 2021-08-28 Madera 39 18129 250 0 0
368 368 2021-08-27 Madera 39 18129 250 0 0
426 426 2021-08-26 Madera 39 18129 250 0 0
484 484 2021-08-25 Madera 39 18129 250 0 0
542 542 2021-08-24 Madera 39 18129 250 411 1
600 600 2021-08-23 Madera 39 17718 249 0 0
658 658 2021-08-22 Madera 39 17718 249 0 0
716 716 2021-08-21 Madera 39 17718 249 0 0
774 774 2021-08-20 Madera 39 17718 249 0 0
832 832 2021-08-19 Madera 39 17718 249 0 0
890 890 2021-08-18 Madera 39 17718 249 0 0
948 948 2021-08-17 Madera 39 17718 249 337 0
1006 1006 2021-08-16 Madera 39 17381 249 0 0
1064 1064 2021-08-15 Madera 39 17381 249 0 0
1122 1122 2021-08-14 Madera 39 17381 249 0 0
1180 1180 2021-08-13 Madera 39 17381 249 0 0
1238 1238 2021-08-12 Madera 39 17381 249 0 0
1296 1296 2021-08-11 Madera 39 17381 249 0 0
1354 1354 2021-08-10 Madera 39 17381 249 261 0
1412 1412 2021-08-09 Madera 39 17120 249 0 0
1470 1470 2021-08-08 Madera 39 17120 249 0 0
1528 1528 2021-08-07 Madera 39 17120 249 0 0
1586 1586 2021-08-06 Madera 39 17120 249 0 0
1644 1644 2021-08-05 Madera 39 17120 249 0 0
1702 1702 2021-08-04 Madera 39 17120 249 0 0
1760 1760 2021-08-03 Madera 39 17120 249 209 0
1818 1818 2021-08-02 Madera 39 16911 249 0 0
1876 1876 2021-08-01 Madera 39 16911 249 0 0
1934 1934 2021-07-31 Madera 39 16911 249 0 0
1992 1992 2021-07-30 Madera 39 16911 249 0 0
2050 2050 2021-07-29 Madera 39 16911 249 0 0
2108 2108 2021-07-28 Madera 39 16911 249 0 0
2166 2166 2021-07-27 Madera 39 16911 249 146 0
2224 2224 2021-07-26 Madera 39 16765 249 0 0
2282 2282 2021-07-25 Madera 39 16765 249 0 0
2340 2340 2021-07-24 Madera 39 16765 249 0 0
2398 2398 2021-07-23 Madera 39 16765 249 0 0
2456 2456 2021-07-22 Madera 39 16765 249 0 0
2514 2514 2021-07-21 Madera 39 16765 249 0 0
2572 2572 2021-07-20 Madera 39 16765 249 79 1
2630 2630 2021-07-19 Madera 39 16686 248 0 0
2688 2688 2021-07-18 Madera 39 16686 248 0 0
2746 2746 2021-07-17 Madera 39 16686 248 0 0
2804 2804 2021-07-16 Madera 39 16686 248 0 0
2862 2862 2021-07-15 Madera 39 16686 248 0 0
2920 2920 2021-07-14 Madera 39 16686 248 0 0
2978 2978 2021-07-13 Madera 39 16686 248 64 2
3036 3036 2021-07-12 Madera 39 16622 246 0 0
3094 3094 2021-07-11 Madera 39 16622 246 0 0
3152 3152 2021-07-10 Madera 39 16622 246 0 0
3210 3210 2021-07-09 Madera 39 16622 246 0 0
3268 3268 2021-07-08 Madera 39 16622 246 0 0
3326 3326 2021-07-07 Madera 39 16622 246 0 0
3384 3384 2021-07-06 Madera 39 16622 246 39 1
3442 3442 2021-07-05 Madera 39 16583 245 0 0
3500 3500 2021-07-04 Madera 39 16583 245 0 0
3558 3558 2021-07-03 Madera 39 16583 245 0 0
3616 3616 2021-07-02 Madera 39 16583 245 0 0
3674 3674 2021-07-01 Madera 39 16583 245 0 0
3732 3732 2021-06-30 Madera 39 16583 245 0 0
3790 3790 2021-06-29 Madera 39 16583 245 39 0
3848 3848 2021-06-28 Madera 39 16544 245 0 0
3906 3906 2021-06-27 Madera 39 16544 245 0 0
3964 3964 2021-06-26 Madera 39 16544 245 0 0
4022 4022 2021-06-25 Madera 39 16544 245 0 0
4080 4080 2021-06-24 Madera 39 16544 245 0 0
4138 4138 2021-06-23 Madera 39 16544 245 0 0
4196 4196 2021-06-22 Madera 39 16544 245 51 0
4254 4254 2021-06-21 Madera 39 16493 245 0 0
4312 4312 2021-06-20 Madera 39 16493 245 0 0
4370 4370 2021-06-19 Madera 39 16493 245 0 0
4428 4428 2021-06-18 Madera 39 16493 245 0 0
4486 4486 2021-06-17 Madera 39 16493 245 0 0
4544 4544 2021-06-16 Madera 39 16493 245 0 0
4602 4602 2021-06-15 Madera 39 16493 245 3 0
4660 4660 2021-06-14 Madera 39 16490 245 14 0
4718 4718 2021-06-13 Madera 39 16476 245 0 0
4776 4776 2021-06-12 Madera 39 16476 245 0 0
4834 4834 2021-06-11 Madera 39 16476 245 3 0
4892 4892 2021-06-10 Madera 39 16473 245 0 0
4950 4950 2021-06-09 Madera 39 16473 245 2 0
5008 5008 2021-06-08 Madera 39 16471 245 6 0
5066 5066 2021-06-07 Madera 39 16465 245 12 0
5124 5124 2021-06-06 Madera 39 16453 245 0 0
5182 5182 2021-06-05 Madera 39 16453 245 0 0
5240 5240 2021-06-04 Madera 39 16453 245 2 0
5298 5298 2021-06-03 Madera 39 16451 245 3 0
5356 5356 2021-06-02 Madera 39 16448 245 0 0
5414 5414 2021-06-01 Madera 39 16448 245 18 1
5472 5472 2021-05-31 Madera 39 16430 244 0 0
5530 5530 2021-05-30 Madera 39 16430 244 0 0
5588 5588 2021-05-29 Madera 39 16430 244 0 0
5646 5646 2021-05-28 Madera 39 16430 244 3 0
5704 5704 2021-05-27 Madera 39 16427 244 5 0
5762 5762 2021-05-26 Madera 39 16422 244 2 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
);