latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
545 rows where agency = "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 |
---|---|---|---|---|---|---|---|---|
6123 | 6123 | Madera | Madera | 39 | 2021-05-25 | 16420 | 244 | |
6184 | 6184 | Madera | Madera | 39 | 2021-05-24 | 16414 | 243 | |
6245 | 6245 | Madera | Madera | 39 | 2021-05-23 | 16400 | 243 | TRUE |
6306 | 6306 | Madera | Madera | 39 | 2021-05-22 | 16400 | 243 | TRUE |
6367 | 6367 | Madera | Madera | 39 | 2021-05-21 | 16400 | 243 | |
6428 | 6428 | Madera | Madera | 39 | 2021-05-20 | 16398 | 243 | |
6489 | 6489 | Madera | Madera | 39 | 2021-05-19 | 16394 | 243 | |
6550 | 6550 | Madera | Madera | 39 | 2021-05-18 | 16390 | 243 | |
6611 | 6611 | Madera | Madera | 39 | 2021-05-17 | 16387 | 242 | |
6672 | 6672 | Madera | Madera | 39 | 2021-05-16 | 16375 | 242 | TRUE |
6733 | 6733 | Madera | Madera | 39 | 2021-05-15 | 16375 | 242 | TRUE |
6794 | 6794 | Madera | Madera | 39 | 2021-05-14 | 16375 | 242 | |
6855 | 6855 | Madera | Madera | 39 | 2021-05-13 | 16364 | 242 | |
6916 | 6916 | Madera | Madera | 39 | 2021-05-12 | 16360 | 242 | |
6977 | 6977 | Madera | Madera | 39 | 2021-05-11 | 16357 | 242 | |
7038 | 7038 | Madera | Madera | 39 | 2021-05-10 | 16348 | 242 | |
7099 | 7099 | Madera | Madera | 39 | 2021-05-09 | 16337 | 242 | |
7160 | 7160 | Madera | Madera | 39 | 2021-05-08 | 16337 | 242 | |
7221 | 7221 | Madera | Madera | 39 | 2021-05-07 | 16337 | 242 | |
7282 | 7282 | Madera | Madera | 39 | 2021-05-06 | 16327 | 242 | |
7343 | 7343 | Madera | Madera | 39 | 2021-05-05 | 16319 | 242 | |
7404 | 7404 | Madera | Madera | 39 | 2021-05-04 | 16315 | 242 | |
7465 | 7465 | Madera | Madera | 39 | 2021-05-03 | 16311 | 240 | |
7526 | 7526 | Madera | Madera | 39 | 2021-05-02 | 16291 | 240 | TRUE |
7587 | 7587 | Madera | Madera | 39 | 2021-05-01 | 16291 | 240 | TRUE |
7648 | 7648 | Madera | Madera | 39 | 2021-04-30 | 16291 | 240 | |
7709 | 7709 | Madera | Madera | 39 | 2021-04-29 | 16278 | 240 | |
7770 | 7770 | Madera | Madera | 39 | 2021-04-28 | 16271 | 240 | |
7831 | 7831 | Madera | Madera | 39 | 2021-04-27 | 16268 | 240 | |
7892 | 7892 | Madera | Madera | 39 | 2021-04-26 | 16255 | 240 | |
7953 | 7953 | Madera | Madera | 39 | 2021-04-25 | 16228 | 240 | TRUE |
8014 | 8014 | Madera | Madera | 39 | 2021-04-24 | 16228 | 240 | TRUE |
8075 | 8075 | Madera | Madera | 39 | 2021-04-23 | 16228 | 240 | |
8136 | 8136 | Madera | Madera | 39 | 2021-04-22 | 16218 | 240 | |
8197 | 8197 | Madera | Madera | 39 | 2021-04-21 | 16210 | 240 | |
8258 | 8258 | Madera | Madera | 39 | 2021-04-20 | 16205 | 240 | |
8319 | 8319 | Madera | Madera | 39 | 2021-04-19 | 16190 | 239 | |
8380 | 8380 | Madera | Madera | 39 | 2021-04-18 | 16156 | 239 | TRUE |
8441 | 8441 | Madera | Madera | 39 | 2021-04-17 | 16156 | 239 | TRUE |
8502 | 8502 | Madera | Madera | 39 | 2021-04-16 | 16156 | 239 | |
8563 | 8563 | Madera | Madera | 39 | 2021-04-15 | 16136 | 239 | |
8624 | 8624 | Madera | Madera | 39 | 2021-04-14 | 16122 | 239 | |
8685 | 8685 | Madera | Madera | 39 | 2021-04-13 | 16110 | 239 | |
8746 | 8746 | Madera | Madera | 39 | 2021-04-12 | 16077 | 236 | |
8807 | 8807 | Madera | Madera | 39 | 2021-04-11 | 16029 | 236 | TRUE |
8868 | 8868 | Madera | Madera | 39 | 2021-04-10 | 16029 | 236 | TRUE |
8929 | 8929 | Madera | Madera | 39 | 2021-04-09 | 16029 | 236 | |
8990 | 8990 | Madera | Madera | 39 | 2021-04-08 | 16015 | 236 | |
9051 | 9051 | Madera | Madera | 39 | 2021-04-07 | 16002 | 236 | |
9112 | 9112 | Madera | Madera | 39 | 2021-04-06 | 15995 | 236 | |
9173 | 9173 | Madera | Madera | 39 | 2021-04-05 | 15976 | 234 | |
9234 | 9234 | Madera | Madera | 39 | 2021-04-04 | 15944 | 234 | TRUE |
9295 | 9295 | Madera | Madera | 39 | 2021-04-03 | 15944 | 234 | TRUE |
9356 | 9356 | Madera | Madera | 39 | 2021-04-02 | 15944 | 234 | |
9417 | 9417 | Madera | Madera | 39 | 2021-04-01 | 15932 | 234 | |
9478 | 9478 | Madera | Madera | 39 | 2021-03-31 | 15924 | 234 | |
9539 | 9539 | Madera | Madera | 39 | 2021-03-30 | 15918 | 234 | |
9600 | 9600 | Madera | Madera | 39 | 2021-03-29 | 15903 | 231 | |
9661 | 9661 | Madera | Madera | 39 | 2021-03-28 | 15862 | 231 | TRUE |
9722 | 9722 | Madera | Madera | 39 | 2021-03-27 | 15862 | 231 | TRUE |
9783 | 9783 | Madera | Madera | 39 | 2021-03-26 | 15862 | 231 | |
9844 | 9844 | Madera | Madera | 39 | 2021-03-25 | 15850 | 231 | |
9905 | 9905 | Madera | Madera | 39 | 2021-03-24 | 15831 | 231 | |
9966 | 9966 | Madera | Madera | 39 | 2021-03-23 | 15821 | 231 | |
10027 | 10027 | Madera | Madera | 39 | 2021-03-22 | 15814 | 226 | |
10088 | 10088 | Madera | Madera | 39 | 2021-03-21 | 15788 | 226 | TRUE |
10149 | 10149 | Madera | Madera | 39 | 2021-03-20 | 15788 | 226 | TRUE |
10210 | 10210 | Madera | Madera | 39 | 2021-03-19 | 15788 | 226 | |
10271 | 10271 | Madera | Madera | 39 | 2021-03-18 | 15773 | 226 | |
10332 | 10332 | Madera | Madera | 39 | 2021-03-17 | 15741 | 226 | |
10393 | 10393 | Madera | Madera | 39 | 2021-03-16 | 15737 | 226 | |
10454 | 10454 | Madera | Madera | 39 | 2021-03-15 | 15722 | 222 | |
10515 | 10515 | Madera | Madera | 39 | 2021-03-14 | 15667 | 222 | TRUE |
10576 | 10576 | Madera | Madera | 39 | 2021-03-13 | 15667 | 222 | TRUE |
10637 | 10637 | Madera | Madera | 39 | 2021-03-12 | 15667 | 222 | |
10698 | 10698 | Madera | Madera | 39 | 2021-03-11 | 15648 | 222 | |
10759 | 10759 | Madera | Madera | 39 | 2021-03-10 | 15636 | 222 | |
10820 | 10820 | Madera | Madera | 39 | 2021-03-09 | 15632 | 222 | |
10881 | 10881 | Madera | Madera | 39 | 2021-03-08 | 15614 | 214 | |
10942 | 10942 | Madera | Madera | 39 | 2021-03-07 | 15540 | 214 | TRUE |
11003 | 11003 | Madera | Madera | 39 | 2021-03-06 | 15540 | 214 | |
11064 | 11064 | Madera | Madera | 39 | 2021-03-05 | 15540 | 214 | TRUE |
11125 | 11125 | Madera | Madera | 39 | 2021-03-04 | 15508 | 214 | |
11186 | 11186 | Madera | Madera | 39 | 2021-03-03 | 15472 | 214 | |
11247 | 11247 | Madera | Madera | 39 | 2021-03-02 | 15452 | 214 | |
11308 | 11308 | Madera | Madera | 39 | 2021-03-01 | 15429 | 214 | |
11369 | 11369 | Madera | Madera | 39 | 2021-02-28 | 15356 | 209 | TRUE |
11430 | 11430 | Madera | Madera | 39 | 2021-02-27 | 15356 | 209 | TRUE |
11491 | 11491 | Madera | Madera | 39 | 2021-02-26 | 15356 | 209 | |
11552 | 11552 | Madera | Madera | 39 | 2021-02-25 | 15339 | 209 | |
11613 | 11613 | Madera | Madera | 39 | 2021-02-24 | 15302 | 209 | |
11674 | 11674 | Madera | Madera | 39 | 2021-02-23 | 15279 | 201 | |
11735 | 11735 | Madera | Madera | 39 | 2021-02-22 | 15246 | 201 | |
11796 | 11796 | Madera | Madera | 39 | 2021-02-21 | 15153 | 201 | TRUE |
11857 | 11857 | Madera | Madera | 39 | 2021-02-20 | 15153 | 201 | TRUE |
11918 | 11918 | Madera | Madera | 39 | 2021-02-19 | 15153 | 201 | |
11979 | 11979 | Madera | Madera | 39 | 2021-02-18 | 15118 | 201 | |
12040 | 12040 | Madera | Madera | 39 | 2021-02-17 | 15073 | 201 | |
12101 | 12101 | Madera | Madera | 39 | 2021-02-16 | 15064 | 201 | |
12162 | 12162 | Madera | Madera | 39 | 2021-02-15 | 14966 | 189 | 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 );