latimes_county_totals
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
8198 | 8198 | 2021-04-14 | Madera | 39 | 16122 | 239 | 12 | 0 |
8256 | 8256 | 2021-04-13 | Madera | 39 | 16110 | 239 | 33 | 3 |
8314 | 8314 | 2021-04-12 | Madera | 39 | 16077 | 236 | 48 | 0 |
8372 | 8372 | 2021-04-11 | Madera | 39 | 16029 | 236 | 0 | 0 |
8430 | 8430 | 2021-04-10 | Madera | 39 | 16029 | 236 | 0 | 0 |
8488 | 8488 | 2021-04-09 | Madera | 39 | 16029 | 236 | 14 | 0 |
8546 | 8546 | 2021-04-08 | Madera | 39 | 16015 | 236 | 13 | 0 |
8604 | 8604 | 2021-04-07 | Madera | 39 | 16002 | 236 | 7 | 0 |
8662 | 8662 | 2021-04-06 | Madera | 39 | 15995 | 236 | 19 | 2 |
8720 | 8720 | 2021-04-05 | Madera | 39 | 15976 | 234 | 32 | 0 |
8778 | 8778 | 2021-04-04 | Madera | 39 | 15944 | 234 | 0 | 0 |
8836 | 8836 | 2021-04-03 | Madera | 39 | 15944 | 234 | 0 | 0 |
8894 | 8894 | 2021-04-02 | Madera | 39 | 15944 | 234 | 12 | 0 |
8952 | 8952 | 2021-04-01 | Madera | 39 | 15932 | 234 | 8 | 0 |
9010 | 9010 | 2021-03-31 | Madera | 39 | 15924 | 234 | 6 | 0 |
9068 | 9068 | 2021-03-30 | Madera | 39 | 15918 | 234 | 15 | 3 |
9126 | 9126 | 2021-03-29 | Madera | 39 | 15903 | 231 | 41 | 0 |
9184 | 9184 | 2021-03-28 | Madera | 39 | 15862 | 231 | 0 | 0 |
9242 | 9242 | 2021-03-27 | Madera | 39 | 15862 | 231 | 0 | 0 |
9300 | 9300 | 2021-03-26 | Madera | 39 | 15862 | 231 | 12 | 0 |
9358 | 9358 | 2021-03-25 | Madera | 39 | 15850 | 231 | 19 | 0 |
9416 | 9416 | 2021-03-24 | Madera | 39 | 15831 | 231 | 10 | 0 |
9474 | 9474 | 2021-03-23 | Madera | 39 | 15821 | 231 | 7 | 5 |
9532 | 9532 | 2021-03-22 | Madera | 39 | 15814 | 226 | 26 | 0 |
9590 | 9590 | 2021-03-21 | Madera | 39 | 15788 | 226 | 0 | 0 |
9648 | 9648 | 2021-03-20 | Madera | 39 | 15788 | 226 | 0 | 0 |
9706 | 9706 | 2021-03-19 | Madera | 39 | 15788 | 226 | 15 | 0 |
9764 | 9764 | 2021-03-18 | Madera | 39 | 15773 | 226 | 32 | 0 |
9822 | 9822 | 2021-03-17 | Madera | 39 | 15741 | 226 | 4 | 0 |
9880 | 9880 | 2021-03-16 | Madera | 39 | 15737 | 226 | 15 | 4 |
9938 | 9938 | 2021-03-15 | Madera | 39 | 15722 | 222 | 55 | 0 |
9996 | 9996 | 2021-03-14 | Madera | 39 | 15667 | 222 | 0 | 0 |
10054 | 10054 | 2021-03-13 | Madera | 39 | 15667 | 222 | 0 | 0 |
10112 | 10112 | 2021-03-12 | Madera | 39 | 15667 | 222 | 19 | 0 |
10170 | 10170 | 2021-03-11 | Madera | 39 | 15648 | 222 | 12 | 0 |
10228 | 10228 | 2021-03-10 | Madera | 39 | 15636 | 222 | 4 | 0 |
10286 | 10286 | 2021-03-09 | Madera | 39 | 15632 | 222 | 18 | 8 |
10344 | 10344 | 2021-03-08 | Madera | 39 | 15614 | 214 | 74 | 0 |
10402 | 10402 | 2021-03-07 | Madera | 39 | 15540 | 214 | 0 | 0 |
10460 | 10460 | 2021-03-06 | Madera | 39 | 15540 | 214 | 0 | 0 |
10518 | 10518 | 2021-03-05 | Madera | 39 | 15540 | 214 | 32 | 0 |
10576 | 10576 | 2021-03-04 | Madera | 39 | 15508 | 214 | 36 | 0 |
10634 | 10634 | 2021-03-03 | Madera | 39 | 15472 | 214 | 20 | 0 |
10692 | 10692 | 2021-03-02 | Madera | 39 | 15452 | 214 | 23 | 0 |
10750 | 10750 | 2021-03-01 | Madera | 39 | 15429 | 214 | 73 | 5 |
10808 | 10808 | 2021-02-28 | Madera | 39 | 15356 | 209 | 0 | 0 |
10866 | 10866 | 2021-02-27 | Madera | 39 | 15356 | 209 | 0 | 0 |
10924 | 10924 | 2021-02-26 | Madera | 39 | 15356 | 209 | 17 | 0 |
10982 | 10982 | 2021-02-25 | Madera | 39 | 15339 | 209 | 37 | 0 |
11040 | 11040 | 2021-02-24 | Madera | 39 | 15302 | 209 | 23 | 8 |
11098 | 11098 | 2021-02-23 | Madera | 39 | 15279 | 201 | 33 | 0 |
11156 | 11156 | 2021-02-22 | Madera | 39 | 15246 | 201 | 93 | 0 |
11214 | 11214 | 2021-02-21 | Madera | 39 | 15153 | 201 | 0 | 0 |
11272 | 11272 | 2021-02-20 | Madera | 39 | 15153 | 201 | 0 | 0 |
11330 | 11330 | 2021-02-19 | Madera | 39 | 15153 | 201 | 35 | 0 |
11388 | 11388 | 2021-02-18 | Madera | 39 | 15118 | 201 | 45 | 0 |
11446 | 11446 | 2021-02-17 | Madera | 39 | 15073 | 201 | 9 | 0 |
11504 | 11504 | 2021-02-16 | Madera | 39 | 15064 | 201 | 98 | 12 |
11562 | 11562 | 2021-02-15 | Madera | 39 | 14966 | 189 | 0 | 0 |
11620 | 11620 | 2021-02-14 | Madera | 39 | 14966 | 189 | 0 | 0 |
11678 | 11678 | 2021-02-13 | Madera | 39 | 14966 | 189 | 0 | 0 |
11736 | 11736 | 2021-02-12 | Madera | 39 | 14966 | 189 | 43 | 0 |
11794 | 11794 | 2021-02-11 | Madera | 39 | 14923 | 189 | 49 | 0 |
11852 | 11852 | 2021-02-10 | Madera | 39 | 14874 | 189 | 17 | 0 |
11910 | 11910 | 2021-02-09 | Madera | 39 | 14857 | 189 | 25 | 5 |
11968 | 11968 | 2021-02-08 | Madera | 39 | 14832 | 184 | 194 | 0 |
12026 | 12026 | 2021-02-07 | Madera | 39 | 14638 | 184 | 0 | 0 |
12084 | 12084 | 2021-02-06 | Madera | 39 | 14638 | 184 | 0 | 0 |
12142 | 12142 | 2021-02-05 | Madera | 39 | 14638 | 184 | 51 | 0 |
12200 | 12200 | 2021-02-04 | Madera | 39 | 14587 | 184 | 78 | 0 |
12258 | 12258 | 2021-02-03 | Madera | 39 | 14509 | 184 | 14 | 0 |
12316 | 12316 | 2021-02-02 | Madera | 39 | 14495 | 184 | 43 | 9 |
12374 | 12374 | 2021-02-01 | Madera | 39 | 14452 | 175 | 202 | 0 |
12432 | 12432 | 2021-01-31 | Madera | 39 | 14250 | 175 | 0 | 0 |
12490 | 12490 | 2021-01-30 | Madera | 39 | 14250 | 175 | 0 | 0 |
12548 | 12548 | 2021-01-29 | Madera | 39 | 14250 | 175 | 85 | 0 |
12606 | 12606 | 2021-01-28 | Madera | 39 | 14165 | 175 | 85 | 0 |
12664 | 12664 | 2021-01-27 | Madera | 39 | 14080 | 175 | 76 | 0 |
12722 | 12722 | 2021-01-26 | Madera | 39 | 14004 | 175 | 61 | 24 |
12780 | 12780 | 2021-01-25 | Madera | 39 | 13943 | 151 | 360 | 0 |
12838 | 12838 | 2021-01-24 | Madera | 39 | 13583 | 151 | 0 | 0 |
12896 | 12896 | 2021-01-23 | Madera | 39 | 13583 | 151 | 0 | 0 |
12954 | 12954 | 2021-01-22 | Madera | 39 | 13583 | 151 | 85 | 0 |
13012 | 13012 | 2021-01-21 | Madera | 39 | 13498 | 151 | 107 | 0 |
13070 | 13070 | 2021-01-20 | Madera | 39 | 13391 | 151 | 68 | 0 |
13128 | 13128 | 2021-01-19 | Madera | 39 | 13323 | 151 | 545 | 21 |
13186 | 13186 | 2021-01-18 | Madera | 39 | 12778 | 130 | 0 | 0 |
13244 | 13244 | 2021-01-17 | Madera | 39 | 12778 | 130 | 0 | 0 |
13302 | 13302 | 2021-01-16 | Madera | 39 | 12778 | 130 | 0 | 0 |
13360 | 13360 | 2021-01-15 | Madera | 39 | 12778 | 130 | 229 | 0 |
13418 | 13418 | 2021-01-14 | Madera | 39 | 12549 | 130 | 78 | 0 |
13476 | 13476 | 2021-01-13 | Madera | 39 | 12471 | 130 | 82 | 0 |
13534 | 13534 | 2021-01-12 | Madera | 39 | 12389 | 130 | 119 | 4 |
13592 | 13592 | 2021-01-11 | Madera | 39 | 12270 | 126 | 625 | 0 |
13650 | 13650 | 2021-01-10 | Madera | 39 | 11645 | 126 | 0 | 0 |
13708 | 13708 | 2021-01-09 | Madera | 39 | 11645 | 126 | 0 | 0 |
13766 | 13766 | 2021-01-08 | Madera | 39 | 11645 | 126 | 113 | 0 |
13824 | 13824 | 2021-01-07 | Madera | 39 | 11532 | 126 | 198 | 0 |
13882 | 13882 | 2021-01-06 | Madera | 39 | 11334 | 126 | 54 | 0 |
13940 | 13940 | 2021-01-05 | Madera | 39 | 11280 | 126 | 152 | 9 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );