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 |
---|---|---|---|---|---|---|---|---|
5820 | 5820 | 2021-05-25 | Madera | 39 | 16420 | 244 | 6 | 1 |
5878 | 5878 | 2021-05-24 | Madera | 39 | 16414 | 243 | 14 | 0 |
5936 | 5936 | 2021-05-23 | Madera | 39 | 16400 | 243 | 0 | 0 |
5994 | 5994 | 2021-05-22 | Madera | 39 | 16400 | 243 | 0 | 0 |
6052 | 6052 | 2021-05-21 | Madera | 39 | 16400 | 243 | 2 | 0 |
6110 | 6110 | 2021-05-20 | Madera | 39 | 16398 | 243 | 4 | 0 |
6168 | 6168 | 2021-05-19 | Madera | 39 | 16394 | 243 | 4 | 0 |
6226 | 6226 | 2021-05-18 | Madera | 39 | 16390 | 243 | 3 | 1 |
6284 | 6284 | 2021-05-17 | Madera | 39 | 16387 | 242 | 12 | 0 |
6342 | 6342 | 2021-05-16 | Madera | 39 | 16375 | 242 | 0 | 0 |
6400 | 6400 | 2021-05-15 | Madera | 39 | 16375 | 242 | 0 | 0 |
6458 | 6458 | 2021-05-14 | Madera | 39 | 16375 | 242 | 11 | 0 |
6516 | 6516 | 2021-05-13 | Madera | 39 | 16364 | 242 | 4 | 0 |
6574 | 6574 | 2021-05-12 | Madera | 39 | 16360 | 242 | 3 | 0 |
6632 | 6632 | 2021-05-11 | Madera | 39 | 16357 | 242 | 9 | 0 |
6690 | 6690 | 2021-05-10 | Madera | 39 | 16348 | 242 | 11 | 0 |
6748 | 6748 | 2021-05-09 | Madera | 39 | 16337 | 242 | 0 | 0 |
6806 | 6806 | 2021-05-08 | Madera | 39 | 16337 | 242 | 0 | 0 |
6864 | 6864 | 2021-05-07 | Madera | 39 | 16337 | 242 | 10 | 0 |
6922 | 6922 | 2021-05-06 | Madera | 39 | 16327 | 242 | 8 | 0 |
6980 | 6980 | 2021-05-05 | Madera | 39 | 16319 | 242 | 4 | 0 |
7038 | 7038 | 2021-05-04 | Madera | 39 | 16315 | 242 | 4 | 2 |
7096 | 7096 | 2021-05-03 | Madera | 39 | 16311 | 240 | 20 | 0 |
7154 | 7154 | 2021-05-02 | Madera | 39 | 16291 | 240 | 0 | 0 |
7212 | 7212 | 2021-05-01 | Madera | 39 | 16291 | 240 | 0 | 0 |
7270 | 7270 | 2021-04-30 | Madera | 39 | 16291 | 240 | 13 | 0 |
7328 | 7328 | 2021-04-29 | Madera | 39 | 16278 | 240 | 7 | 0 |
7386 | 7386 | 2021-04-28 | Madera | 39 | 16271 | 240 | 3 | 0 |
7444 | 7444 | 2021-04-27 | Madera | 39 | 16268 | 240 | 13 | 0 |
7502 | 7502 | 2021-04-26 | Madera | 39 | 16255 | 240 | 27 | 0 |
7560 | 7560 | 2021-04-25 | Madera | 39 | 16228 | 240 | 0 | 0 |
7618 | 7618 | 2021-04-24 | Madera | 39 | 16228 | 240 | 0 | 0 |
7676 | 7676 | 2021-04-23 | Madera | 39 | 16228 | 240 | 10 | 0 |
7734 | 7734 | 2021-04-22 | Madera | 39 | 16218 | 240 | 8 | 0 |
7792 | 7792 | 2021-04-21 | Madera | 39 | 16210 | 240 | 5 | 0 |
7850 | 7850 | 2021-04-20 | Madera | 39 | 16205 | 240 | 15 | 1 |
7908 | 7908 | 2021-04-19 | Madera | 39 | 16190 | 239 | 34 | 0 |
7966 | 7966 | 2021-04-18 | Madera | 39 | 16156 | 239 | 0 | 0 |
8024 | 8024 | 2021-04-17 | Madera | 39 | 16156 | 239 | 0 | 0 |
8082 | 8082 | 2021-04-16 | Madera | 39 | 16156 | 239 | 20 | 0 |
8140 | 8140 | 2021-04-15 | Madera | 39 | 16136 | 239 | 14 | 0 |
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 |
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 );