latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
4,475 rows where county = "Madera" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
42636 | 42636 | Reporting Area A | Reporting Area A | 2022-11-24 | Madera | 39 | 12014 | 40623 | |
42637 | 42637 | Reporting Area B | Reporting Area B | 2022-11-24 | Madera | 39 | 8629 | 25062 | |
42638 | 42638 | Reporting Area C | Reporting Area C | 2022-11-24 | Madera | 39 | 14085 | 49068 | |
42639 | 42639 | Reporting Area D1 | Reporting Area D1 | 2022-11-24 | Madera | 39 | 3258 | 11908 | |
42640 | 42640 | Reporting Area D2 | Reporting Area D2 | 2022-11-24 | Madera | 39 | 4128 | 28123 | |
43867 | 43867 | Reporting Area A | Reporting Area A | 2022-11-23 | Madera | 39 | 12014 | 40623 | |
43868 | 43868 | Reporting Area B | Reporting Area B | 2022-11-23 | Madera | 39 | 8629 | 25062 | |
43869 | 43869 | Reporting Area C | Reporting Area C | 2022-11-23 | Madera | 39 | 14085 | 49068 | |
43870 | 43870 | Reporting Area D1 | Reporting Area D1 | 2022-11-23 | Madera | 39 | 3258 | 11908 | |
43871 | 43871 | Reporting Area D2 | Reporting Area D2 | 2022-11-23 | Madera | 39 | 4128 | 28123 | |
45098 | 45098 | Reporting Area A | Reporting Area A | 2022-11-22 | Madera | 39 | 12014 | 40623 | |
45099 | 45099 | Reporting Area B | Reporting Area B | 2022-11-22 | Madera | 39 | 8629 | 25062 | |
45100 | 45100 | Reporting Area C | Reporting Area C | 2022-11-22 | Madera | 39 | 14085 | 49068 | |
45101 | 45101 | Reporting Area D1 | Reporting Area D1 | 2022-11-22 | Madera | 39 | 3258 | 11908 | |
45102 | 45102 | Reporting Area D2 | Reporting Area D2 | 2022-11-22 | Madera | 39 | 4128 | 28123 | |
46329 | 46329 | Reporting Area A | Reporting Area A | 2022-11-21 | Madera | 39 | 11989 | 40623 | |
46330 | 46330 | Reporting Area B | Reporting Area B | 2022-11-21 | Madera | 39 | 8603 | 25062 | |
46331 | 46331 | Reporting Area C | Reporting Area C | 2022-11-21 | Madera | 39 | 14054 | 49068 | |
46332 | 46332 | Reporting Area D1 | Reporting Area D1 | 2022-11-21 | Madera | 39 | 3250 | 11908 | |
46333 | 46333 | Reporting Area D2 | Reporting Area D2 | 2022-11-21 | Madera | 39 | 4110 | 28123 | |
47560 | 47560 | Reporting Area A | Reporting Area A | 2022-11-20 | Madera | 39 | 11989 | 40623 | |
47561 | 47561 | Reporting Area B | Reporting Area B | 2022-11-20 | Madera | 39 | 8603 | 25062 | |
47562 | 47562 | Reporting Area C | Reporting Area C | 2022-11-20 | Madera | 39 | 14054 | 49068 | |
47563 | 47563 | Reporting Area D1 | Reporting Area D1 | 2022-11-20 | Madera | 39 | 3250 | 11908 | |
47564 | 47564 | Reporting Area D2 | Reporting Area D2 | 2022-11-20 | Madera | 39 | 4110 | 28123 | |
48791 | 48791 | Reporting Area A | Reporting Area A | 2022-11-19 | Madera | 39 | 11989 | 40623 | |
48792 | 48792 | Reporting Area B | Reporting Area B | 2022-11-19 | Madera | 39 | 8603 | 25062 | |
48793 | 48793 | Reporting Area C | Reporting Area C | 2022-11-19 | Madera | 39 | 14054 | 49068 | |
48794 | 48794 | Reporting Area D1 | Reporting Area D1 | 2022-11-19 | Madera | 39 | 3250 | 11908 | |
48795 | 48795 | Reporting Area D2 | Reporting Area D2 | 2022-11-19 | Madera | 39 | 4110 | 28123 | |
50022 | 50022 | Reporting Area A | Reporting Area A | 2022-11-18 | Madera | 39 | 11989 | 40623 | |
50023 | 50023 | Reporting Area B | Reporting Area B | 2022-11-18 | Madera | 39 | 8603 | 25062 | |
50024 | 50024 | Reporting Area C | Reporting Area C | 2022-11-18 | Madera | 39 | 14054 | 49068 | |
50025 | 50025 | Reporting Area D1 | Reporting Area D1 | 2022-11-18 | Madera | 39 | 3250 | 11908 | |
50026 | 50026 | Reporting Area D2 | Reporting Area D2 | 2022-11-18 | Madera | 39 | 4110 | 28123 | |
51253 | 51253 | Reporting Area A | Reporting Area A | 2022-11-17 | Madera | 39 | 11989 | 40623 | |
51254 | 51254 | Reporting Area B | Reporting Area B | 2022-11-17 | Madera | 39 | 8603 | 25062 | |
51255 | 51255 | Reporting Area C | Reporting Area C | 2022-11-17 | Madera | 39 | 14054 | 49068 | |
51256 | 51256 | Reporting Area D1 | Reporting Area D1 | 2022-11-17 | Madera | 39 | 3250 | 11908 | |
51257 | 51257 | Reporting Area D2 | Reporting Area D2 | 2022-11-17 | Madera | 39 | 4110 | 28123 | |
52484 | 52484 | Reporting Area A | Reporting Area A | 2022-11-16 | Madera | 39 | 11989 | 40623 | |
52485 | 52485 | Reporting Area B | Reporting Area B | 2022-11-16 | Madera | 39 | 8603 | 25062 | |
52486 | 52486 | Reporting Area C | Reporting Area C | 2022-11-16 | Madera | 39 | 14054 | 49068 | |
52487 | 52487 | Reporting Area D1 | Reporting Area D1 | 2022-11-16 | Madera | 39 | 3250 | 11908 | |
52488 | 52488 | Reporting Area D2 | Reporting Area D2 | 2022-11-16 | Madera | 39 | 4110 | 28123 | |
53715 | 53715 | Reporting Area A | Reporting Area A | 2022-11-15 | Madera | 39 | 11989 | 40623 | |
53716 | 53716 | Reporting Area B | Reporting Area B | 2022-11-15 | Madera | 39 | 8603 | 25062 | |
53717 | 53717 | Reporting Area C | Reporting Area C | 2022-11-15 | Madera | 39 | 14054 | 49068 | |
53718 | 53718 | Reporting Area D1 | Reporting Area D1 | 2022-11-15 | Madera | 39 | 3250 | 11908 | |
53719 | 53719 | Reporting Area D2 | Reporting Area D2 | 2022-11-15 | Madera | 39 | 4110 | 28123 | |
54946 | 54946 | Reporting Area A | Reporting Area A | 2022-11-14 | Madera | 39 | 11973 | 40623 | |
54947 | 54947 | Reporting Area B | Reporting Area B | 2022-11-14 | Madera | 39 | 8593 | 25062 | |
54948 | 54948 | Reporting Area C | Reporting Area C | 2022-11-14 | Madera | 39 | 14043 | 49068 | |
54949 | 54949 | Reporting Area D1 | Reporting Area D1 | 2022-11-14 | Madera | 39 | 3239 | 11908 | |
54950 | 54950 | Reporting Area D2 | Reporting Area D2 | 2022-11-14 | Madera | 39 | 4090 | 28123 | |
56177 | 56177 | Reporting Area A | Reporting Area A | 2022-11-13 | Madera | 39 | 11973 | 40623 | |
56178 | 56178 | Reporting Area B | Reporting Area B | 2022-11-13 | Madera | 39 | 8593 | 25062 | |
56179 | 56179 | Reporting Area C | Reporting Area C | 2022-11-13 | Madera | 39 | 14043 | 49068 | |
56180 | 56180 | Reporting Area D1 | Reporting Area D1 | 2022-11-13 | Madera | 39 | 3239 | 11908 | |
56181 | 56181 | Reporting Area D2 | Reporting Area D2 | 2022-11-13 | Madera | 39 | 4090 | 28123 | |
57408 | 57408 | Reporting Area A | Reporting Area A | 2022-11-12 | Madera | 39 | 11973 | 40623 | |
57409 | 57409 | Reporting Area B | Reporting Area B | 2022-11-12 | Madera | 39 | 8593 | 25062 | |
57410 | 57410 | Reporting Area C | Reporting Area C | 2022-11-12 | Madera | 39 | 14043 | 49068 | |
57411 | 57411 | Reporting Area D1 | Reporting Area D1 | 2022-11-12 | Madera | 39 | 3239 | 11908 | |
57412 | 57412 | Reporting Area D2 | Reporting Area D2 | 2022-11-12 | Madera | 39 | 4090 | 28123 | |
58639 | 58639 | Reporting Area A | Reporting Area A | 2022-11-11 | Madera | 39 | 11973 | 40623 | |
58640 | 58640 | Reporting Area B | Reporting Area B | 2022-11-11 | Madera | 39 | 8593 | 25062 | |
58641 | 58641 | Reporting Area C | Reporting Area C | 2022-11-11 | Madera | 39 | 14043 | 49068 | |
58642 | 58642 | Reporting Area D1 | Reporting Area D1 | 2022-11-11 | Madera | 39 | 3239 | 11908 | |
58643 | 58643 | Reporting Area D2 | Reporting Area D2 | 2022-11-11 | Madera | 39 | 4090 | 28123 | |
59870 | 59870 | Reporting Area A | Reporting Area A | 2022-11-10 | Madera | 39 | 11973 | 40623 | |
59871 | 59871 | Reporting Area B | Reporting Area B | 2022-11-10 | Madera | 39 | 8593 | 25062 | |
59872 | 59872 | Reporting Area C | Reporting Area C | 2022-11-10 | Madera | 39 | 14043 | 49068 | |
59873 | 59873 | Reporting Area D1 | Reporting Area D1 | 2022-11-10 | Madera | 39 | 3239 | 11908 | |
59874 | 59874 | Reporting Area D2 | Reporting Area D2 | 2022-11-10 | Madera | 39 | 4090 | 28123 | |
61101 | 61101 | Reporting Area A | Reporting Area A | 2022-11-09 | Madera | 39 | 11973 | 40623 | |
61102 | 61102 | Reporting Area B | Reporting Area B | 2022-11-09 | Madera | 39 | 8593 | 25062 | |
61103 | 61103 | Reporting Area C | Reporting Area C | 2022-11-09 | Madera | 39 | 14043 | 49068 | |
61104 | 61104 | Reporting Area D1 | Reporting Area D1 | 2022-11-09 | Madera | 39 | 3239 | 11908 | |
61105 | 61105 | Reporting Area D2 | Reporting Area D2 | 2022-11-09 | Madera | 39 | 4090 | 28123 | |
62332 | 62332 | Reporting Area A | Reporting Area A | 2022-11-08 | Madera | 39 | 11973 | 40623 | |
62333 | 62333 | Reporting Area B | Reporting Area B | 2022-11-08 | Madera | 39 | 8593 | 25062 | |
62334 | 62334 | Reporting Area C | Reporting Area C | 2022-11-08 | Madera | 39 | 14043 | 49068 | |
62335 | 62335 | Reporting Area D1 | Reporting Area D1 | 2022-11-08 | Madera | 39 | 3239 | 11908 | |
62336 | 62336 | Reporting Area D2 | Reporting Area D2 | 2022-11-08 | Madera | 39 | 4090 | 28123 | |
63563 | 63563 | Reporting Area A | Reporting Area A | 2022-11-07 | Madera | 39 | 11964 | 40623 | |
63564 | 63564 | Reporting Area B | Reporting Area B | 2022-11-07 | Madera | 39 | 8584 | 25062 | |
63565 | 63565 | Reporting Area C | Reporting Area C | 2022-11-07 | Madera | 39 | 14029 | 49068 | |
63566 | 63566 | Reporting Area D1 | Reporting Area D1 | 2022-11-07 | Madera | 39 | 3235 | 11908 | |
63567 | 63567 | Reporting Area D2 | Reporting Area D2 | 2022-11-07 | Madera | 39 | 4075 | 28123 | |
64794 | 64794 | Reporting Area A | Reporting Area A | 2022-11-06 | Madera | 39 | 11964 | 40623 | |
64795 | 64795 | Reporting Area B | Reporting Area B | 2022-11-06 | Madera | 39 | 8584 | 25062 | |
64796 | 64796 | Reporting Area C | Reporting Area C | 2022-11-06 | Madera | 39 | 14029 | 49068 | |
64797 | 64797 | Reporting Area D1 | Reporting Area D1 | 2022-11-06 | Madera | 39 | 3235 | 11908 | |
64798 | 64798 | Reporting Area D2 | Reporting Area D2 | 2022-11-06 | Madera | 39 | 4075 | 28123 | |
66025 | 66025 | Reporting Area A | Reporting Area A | 2022-11-05 | Madera | 39 | 11964 | 40623 | |
66026 | 66026 | Reporting Area B | Reporting Area B | 2022-11-05 | Madera | 39 | 8584 | 25062 | |
66027 | 66027 | Reporting Area C | Reporting Area C | 2022-11-05 | Madera | 39 | 14029 | 49068 | |
66028 | 66028 | Reporting Area D1 | Reporting Area D1 | 2022-11-05 | Madera | 39 | 3235 | 11908 | |
66029 | 66029 | Reporting Area D2 | Reporting Area D2 | 2022-11-05 | Madera | 39 | 4075 | 28123 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );