latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
545 rows where county = "Madera" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
18994 | 18994 | Madera | Madera | 39 | 2020-10-26 | 5020 | 74 | |
19055 | 19055 | Madera | Madera | 39 | 2020-10-25 | 4981 | 74 | TRUE |
19116 | 19116 | Madera | Madera | 39 | 2020-10-24 | 4981 | 74 | TRUE |
19177 | 19177 | Madera | Madera | 39 | 2020-10-23 | 4981 | 74 | |
19238 | 19238 | Madera | Madera | 39 | 2020-10-22 | 4945 | 74 | |
19299 | 19299 | Madera | Madera | 39 | 2020-10-21 | 4928 | 73 | |
19360 | 19360 | Madera | Madera | 39 | 2020-10-20 | 4920 | 73 | |
19421 | 19421 | Madera | Madera | 39 | 2020-10-19 | 4886 | 73 | |
19482 | 19482 | Madera | Madera | 39 | 2020-10-18 | 4836 | 73 | TRUE |
19543 | 19543 | Madera | Madera | 39 | 2020-10-17 | 4836 | 73 | TRUE |
19604 | 19604 | Madera | Madera | 39 | 2020-10-16 | 4836 | 73 | |
19665 | 19665 | Madera | Madera | 39 | 2020-10-15 | 4822 | 73 | |
19726 | 19726 | Madera | Madera | 39 | 2020-10-14 | 4808 | 73 | |
19787 | 19787 | Madera | Madera | 39 | 2020-10-13 | 4796 | 71 | |
19848 | 19848 | Madera | Madera | 39 | 2020-10-12 | 4786 | 71 | |
19909 | 19909 | Madera | Madera | 39 | 2020-10-11 | 4748 | 71 | TRUE |
19970 | 19970 | Madera | Madera | 39 | 2020-10-10 | 4748 | 71 | TRUE |
20031 | 20031 | Madera | Madera | 39 | 2020-10-09 | 4748 | 71 | |
20092 | 20092 | Madera | Madera | 39 | 2020-10-08 | 4739 | 70 | |
20153 | 20153 | Madera | Madera | 39 | 2020-10-07 | 4720 | 70 | |
20214 | 20214 | Madera | Madera | 39 | 2020-10-06 | 4718 | 70 | |
20275 | 20275 | Madera | Madera | 39 | 2020-10-05 | 4706 | 70 | |
20336 | 20336 | Madera | Madera | 39 | 2020-10-04 | 4642 | 70 | TRUE |
20397 | 20397 | Madera | Madera | 39 | 2020-10-03 | 4642 | 70 | TRUE |
20458 | 20458 | Madera | Madera | 39 | 2020-10-02 | 4642 | 70 | |
20519 | 20519 | Madera | Madera | 39 | 2020-10-01 | 4614 | 68 | |
20580 | 20580 | Madera | Madera | 39 | 2020-09-30 | 4583 | 68 | |
20641 | 20641 | Madera | Madera | 39 | 2020-09-29 | 4557 | 65 | |
20702 | 20702 | Madera | Madera | 39 | 2020-09-28 | 4539 | 65 | |
20763 | 20763 | Madera | Madera | 39 | 2020-09-27 | 4481 | 65 | TRUE |
20824 | 20824 | Madera | Madera | 39 | 2020-09-26 | 4481 | 65 | TRUE |
20885 | 20885 | Madera | Madera | 39 | 2020-09-25 | 4481 | 65 | |
20946 | 20946 | Madera | Madera | 39 | 2020-09-24 | 4458 | 65 | |
21007 | 21007 | Madera | Madera | 39 | 2020-09-23 | 4424 | 65 | |
21068 | 21068 | Madera | Madera | 39 | 2020-09-22 | 4424 | 65 | |
21129 | 21129 | Madera | Madera | 39 | 2020-09-21 | 4391 | 62 | |
21190 | 21190 | Madera | Madera | 39 | 2020-09-20 | 4296 | 58 | TRUE |
21251 | 21251 | Madera | Madera | 39 | 2020-09-19 | 4296 | 58 | TRUE |
21312 | 21312 | Madera | Madera | 39 | 2020-09-18 | 4296 | 58 | |
21373 | 21373 | Madera | Madera | 39 | 2020-09-17 | 4270 | 58 | |
21434 | 21434 | Madera | Madera | 39 | 2020-09-16 | 4267 | 58 | |
21495 | 21495 | Madera | Madera | 39 | 2020-09-15 | 4230 | 58 | |
21556 | 21556 | Madera | Madera | 39 | 2020-09-14 | 4226 | 58 | |
21617 | 21617 | Madera | Madera | 39 | 2020-09-13 | 4150 | 58 | TRUE |
21678 | 21678 | Madera | Madera | 39 | 2020-09-12 | 4150 | 58 | TRUE |
21739 | 21739 | Madera | Madera | 39 | 2020-09-11 | 4150 | 58 | |
21800 | 21800 | Madera | Madera | 39 | 2020-09-10 | 4079 | 58 | |
21861 | 21861 | Madera | Madera | 39 | 2020-09-09 | 4064 | 58 | |
21922 | 21922 | Madera | Madera | 39 | 2020-09-08 | 4025 | 58 | |
21983 | 21983 | Madera | Madera | 39 | 2020-09-07 | 3953 | 58 | TRUE |
22044 | 22044 | Madera | Madera | 39 | 2020-09-06 | 3953 | 58 | TRUE |
22105 | 22105 | Madera | Madera | 39 | 2020-09-05 | 3953 | 58 | TRUE |
22166 | 22166 | Madera | Madera | 39 | 2020-09-04 | 3953 | 58 | |
22227 | 22227 | Madera | Madera | 39 | 2020-09-03 | 3889 | 57 | |
22288 | 22288 | Madera | Madera | 39 | 2020-09-02 | 3876 | 55 | |
22349 | 22349 | Madera | Madera | 39 | 2020-09-01 | 3836 | 55 | |
22410 | 22410 | Madera | Madera | 39 | 2020-08-31 | 3783 | 54 | |
22471 | 22471 | Madera | Madera | 39 | 2020-08-30 | 3674 | 54 | TRUE |
22532 | 22532 | Madera | Madera | 39 | 2020-08-29 | 3674 | 54 | TRUE |
22593 | 22593 | Madera | Madera | 39 | 2020-08-28 | 3674 | 54 | TRUE |
22654 | 22654 | Madera | Madera | 39 | 2020-08-27 | 3567 | 54 | |
22715 | 22715 | Madera | Madera | 39 | 2020-08-26 | 3551 | 53 | |
22776 | 22776 | Madera | Madera | 39 | 2020-08-25 | 3509 | 51 | |
22837 | 22837 | Madera | Madera | 39 | 2020-08-24 | 3484 | 50 | |
22898 | 22898 | Madera | Madera | 39 | 2020-08-23 | 3339 | 49 | TRUE |
22959 | 22959 | Madera | Madera | 39 | 2020-08-22 | 3339 | 49 | TRUE |
23020 | 23020 | Madera | Madera | 39 | 2020-08-21 | 3339 | 49 | |
23081 | 23081 | Madera | Madera | 39 | 2020-08-20 | 3278 | 49 | |
23142 | 23142 | Madera | Madera | 39 | 2020-08-19 | 3236 | 47 | |
23203 | 23203 | Madera | Madera | 39 | 2020-08-18 | 3196 | 47 | |
23264 | 23264 | Madera | Madera | 39 | 2020-08-17 | 3129 | 47 | |
23325 | 23325 | Madera | Madera | 39 | 2020-08-16 | 2924 | 47 | TRUE |
23386 | 23386 | Madera | Madera | 39 | 2020-08-15 | 2924 | 47 | TRUE |
23447 | 23447 | Madera | Madera | 39 | 2020-08-14 | 2924 | 47 | |
23508 | 23508 | Madera | Madera | 39 | 2020-08-13 | 2853 | 46 | |
23569 | 23569 | Madera | Madera | 39 | 2020-08-12 | 2759 | 44 | |
23630 | 23630 | Madera | Madera | 39 | 2020-08-11 | 2590 | 40 | |
23691 | 23691 | Madera | Madera | 39 | 2020-08-10 | 2463 | 39 | |
23752 | 23752 | Madera | Madera | 39 | 2020-08-09 | 2302 | 39 | TRUE |
23813 | 23813 | Madera | Madera | 39 | 2020-08-08 | 2302 | 39 | TRUE |
23874 | 23874 | Madera | Madera | 39 | 2020-08-07 | 2302 | 39 | |
23935 | 23935 | Madera | Madera | 39 | 2020-08-06 | 2267 | 36 | |
23996 | 23996 | Madera | Madera | 39 | 2020-08-05 | 2208 | 33 | |
24057 | 24057 | Madera | Madera | 39 | 2020-08-04 | 2114 | 32 | |
24118 | 24118 | Madera | Madera | 39 | 2020-08-03 | 2075 | 32 | |
24179 | 24179 | Madera | Madera | 39 | 2020-08-02 | 1943 | 30 | TRUE |
24240 | 24240 | Madera | Madera | 39 | 2020-08-01 | 1943 | 30 | TRUE |
24301 | 24301 | Madera | Madera | 39 | 2020-07-31 | 1943 | 30 | |
24362 | 24362 | Madera | Madera | 39 | 2020-07-30 | 1886 | 28 | |
24423 | 24423 | Madera | Madera | 39 | 2020-07-29 | 1850 | 28 | |
24484 | 24484 | Madera | Madera | 39 | 2020-07-28 | 1841 | 23 | |
24545 | 24545 | Madera | Madera | 39 | 2020-07-27 | 1723 | 21 | |
24606 | 24606 | Madera | Madera | 39 | 2020-07-26 | 1630 | 19 | TRUE |
24667 | 24667 | Madera | Madera | 39 | 2020-07-25 | 1630 | 19 | TRUE |
24728 | 24728 | Madera | Madera | 39 | 2020-07-24 | 1630 | 19 | |
24789 | 24789 | Madera | Madera | 39 | 2020-07-23 | 1599 | 18 | |
24850 | 24850 | Madera | Madera | 39 | 2020-07-22 | 1530 | 16 | |
24911 | 24911 | Madera | Madera | 39 | 2020-07-21 | 1439 | 13 | |
24972 | 24972 | Madera | Madera | 39 | 2020-07-20 | 1414 | 13 | |
25033 | 25033 | Madera | Madera | 39 | 2020-07-19 | 1368 | 11 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );