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 fips = 39 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▼ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1120635 | 1120635 | Reporting Area A | Reporting Area A | 2020-07-19 | Madera | 39 | 341 | 40623 | |
1120636 | 1120636 | Reporting Area B | Reporting Area B | 2020-07-19 | Madera | 39 | 73 | 25062 | |
1120637 | 1120637 | Reporting Area C | Reporting Area C | 2020-07-19 | Madera | 39 | 556 | 49068 | |
1120638 | 1120638 | Reporting Area D1 | Reporting Area D1 | 2020-07-19 | Madera | 39 | 0 | 11908 | |
1120639 | 1120639 | Reporting Area D2 | Reporting Area D2 | 2020-07-19 | Madera | 39 | 0 | 28123 | |
1119447 | 1119447 | Reporting Area A | Reporting Area A | 2020-07-20 | Madera | 39 | 418 | 40623 | |
1119448 | 1119448 | Reporting Area B | Reporting Area B | 2020-07-20 | Madera | 39 | 125 | 25062 | |
1119449 | 1119449 | Reporting Area C | Reporting Area C | 2020-07-20 | Madera | 39 | 697 | 49068 | |
1119450 | 1119450 | Reporting Area D1 | Reporting Area D1 | 2020-07-20 | Madera | 39 | 0 | 11908 | |
1119451 | 1119451 | Reporting Area D2 | Reporting Area D2 | 2020-07-20 | Madera | 39 | 0 | 28123 | |
1118259 | 1118259 | Reporting Area A | Reporting Area A | 2020-07-21 | Madera | 39 | 424 | 40623 | |
1118260 | 1118260 | Reporting Area B | Reporting Area B | 2020-07-21 | Madera | 39 | 89 | 25062 | |
1118261 | 1118261 | Reporting Area C | Reporting Area C | 2020-07-21 | Madera | 39 | 707 | 49068 | |
1118262 | 1118262 | Reporting Area D1 | Reporting Area D1 | 2020-07-21 | Madera | 39 | 0 | 11908 | |
1118263 | 1118263 | Reporting Area D2 | Reporting Area D2 | 2020-07-21 | Madera | 39 | 0 | 28123 | |
1117071 | 1117071 | Reporting Area A | Reporting Area A | 2020-07-22 | Madera | 39 | 441 | 40623 | |
1117072 | 1117072 | Reporting Area B | Reporting Area B | 2020-07-22 | Madera | 39 | 94 | 25062 | |
1117073 | 1117073 | Reporting Area C | Reporting Area C | 2020-07-22 | Madera | 39 | 749 | 49068 | |
1117074 | 1117074 | Reporting Area D1 | Reporting Area D1 | 2020-07-22 | Madera | 39 | 0 | 11908 | |
1117075 | 1117075 | Reporting Area D2 | Reporting Area D2 | 2020-07-22 | Madera | 39 | 0 | 28123 | |
1115883 | 1115883 | Reporting Area A | Reporting Area A | 2020-07-23 | Madera | 39 | 442 | 40623 | |
1115884 | 1115884 | Reporting Area B | Reporting Area B | 2020-07-23 | Madera | 39 | 93 | 25062 | |
1115885 | 1115885 | Reporting Area C | Reporting Area C | 2020-07-23 | Madera | 39 | 753 | 49068 | |
1115886 | 1115886 | Reporting Area D1 | Reporting Area D1 | 2020-07-23 | Madera | 39 | 0 | 11908 | |
1115887 | 1115887 | Reporting Area D2 | Reporting Area D2 | 2020-07-23 | Madera | 39 | 0 | 28123 | |
1114695 | 1114695 | Reporting Area A | Reporting Area A | 2020-07-24 | Madera | 39 | 466 | 40623 | |
1114696 | 1114696 | Reporting Area B | Reporting Area B | 2020-07-24 | Madera | 39 | 98 | 25062 | |
1114697 | 1114697 | Reporting Area C | Reporting Area C | 2020-07-24 | Madera | 39 | 808 | 49068 | |
1114698 | 1114698 | Reporting Area D1 | Reporting Area D1 | 2020-07-24 | Madera | 39 | 0 | 11908 | |
1114699 | 1114699 | Reporting Area D2 | Reporting Area D2 | 2020-07-24 | Madera | 39 | 0 | 28123 | |
1113507 | 1113507 | Reporting Area A | Reporting Area A | 2020-07-25 | Madera | 39 | 466 | 40623 | |
1113508 | 1113508 | Reporting Area B | Reporting Area B | 2020-07-25 | Madera | 39 | 98 | 25062 | |
1113509 | 1113509 | Reporting Area C | Reporting Area C | 2020-07-25 | Madera | 39 | 808 | 49068 | |
1113510 | 1113510 | Reporting Area D1 | Reporting Area D1 | 2020-07-25 | Madera | 39 | 0 | 11908 | |
1113511 | 1113511 | Reporting Area D2 | Reporting Area D2 | 2020-07-25 | Madera | 39 | 0 | 28123 | |
1112319 | 1112319 | Reporting Area A | Reporting Area A | 2020-07-26 | Madera | 39 | 466 | 40623 | |
1112320 | 1112320 | Reporting Area B | Reporting Area B | 2020-07-26 | Madera | 39 | 98 | 25062 | |
1112321 | 1112321 | Reporting Area C | Reporting Area C | 2020-07-26 | Madera | 39 | 808 | 49068 | |
1112322 | 1112322 | Reporting Area D1 | Reporting Area D1 | 2020-07-26 | Madera | 39 | 0 | 11908 | |
1112323 | 1112323 | Reporting Area D2 | Reporting Area D2 | 2020-07-26 | Madera | 39 | 0 | 28123 | |
1111131 | 1111131 | Reporting Area A | Reporting Area A | 2020-07-27 | Madera | 39 | 466 | 40623 | |
1111132 | 1111132 | Reporting Area B | Reporting Area B | 2020-07-27 | Madera | 39 | 98 | 25062 | |
1111133 | 1111133 | Reporting Area C | Reporting Area C | 2020-07-27 | Madera | 39 | 808 | 49068 | |
1111134 | 1111134 | Reporting Area D1 | Reporting Area D1 | 2020-07-27 | Madera | 39 | 0 | 11908 | |
1111135 | 1111135 | Reporting Area D2 | Reporting Area D2 | 2020-07-27 | Madera | 39 | 0 | 28123 | |
1109943 | 1109943 | Reporting Area A | Reporting Area A | 2020-07-28 | Madera | 39 | 489 | 40623 | |
1109944 | 1109944 | Reporting Area B | Reporting Area B | 2020-07-28 | Madera | 39 | 100 | 25062 | |
1109945 | 1109945 | Reporting Area C | Reporting Area C | 2020-07-28 | Madera | 39 | 861 | 49068 | |
1109946 | 1109946 | Reporting Area D1 | Reporting Area D1 | 2020-07-28 | Madera | 39 | 0 | 11908 | |
1109947 | 1109947 | Reporting Area D2 | Reporting Area D2 | 2020-07-28 | Madera | 39 | 0 | 28123 | |
1108755 | 1108755 | Reporting Area A | Reporting Area A | 2020-07-29 | Madera | 39 | 522 | 40623 | |
1108756 | 1108756 | Reporting Area B | Reporting Area B | 2020-07-29 | Madera | 39 | 115 | 25062 | |
1108757 | 1108757 | Reporting Area C | Reporting Area C | 2020-07-29 | Madera | 39 | 903 | 49068 | |
1108758 | 1108758 | Reporting Area D1 | Reporting Area D1 | 2020-07-29 | Madera | 39 | 0 | 11908 | |
1108759 | 1108759 | Reporting Area D2 | Reporting Area D2 | 2020-07-29 | Madera | 39 | 0 | 28123 | |
1107567 | 1107567 | Reporting Area A | Reporting Area A | 2020-07-30 | Madera | 39 | 529 | 40623 | |
1107568 | 1107568 | Reporting Area B | Reporting Area B | 2020-07-30 | Madera | 39 | 118 | 25062 | |
1107569 | 1107569 | Reporting Area C | Reporting Area C | 2020-07-30 | Madera | 39 | 922 | 49068 | |
1107570 | 1107570 | Reporting Area D1 | Reporting Area D1 | 2020-07-30 | Madera | 39 | 0 | 11908 | |
1107571 | 1107571 | Reporting Area D2 | Reporting Area D2 | 2020-07-30 | Madera | 39 | 0 | 28123 | |
1106379 | 1106379 | Reporting Area A | Reporting Area A | 2020-07-31 | Madera | 39 | 536 | 40623 | |
1106380 | 1106380 | Reporting Area B | Reporting Area B | 2020-07-31 | Madera | 39 | 138 | 25062 | |
1106381 | 1106381 | Reporting Area C | Reporting Area C | 2020-07-31 | Madera | 39 | 947 | 49068 | |
1106382 | 1106382 | Reporting Area D1 | Reporting Area D1 | 2020-07-31 | Madera | 39 | 0 | 11908 | |
1106383 | 1106383 | Reporting Area D2 | Reporting Area D2 | 2020-07-31 | Madera | 39 | 0 | 28123 | |
1105191 | 1105191 | Reporting Area A | Reporting Area A | 2020-08-01 | Madera | 39 | 536 | 40623 | |
1105192 | 1105192 | Reporting Area B | Reporting Area B | 2020-08-01 | Madera | 39 | 138 | 25062 | |
1105193 | 1105193 | Reporting Area C | Reporting Area C | 2020-08-01 | Madera | 39 | 947 | 49068 | |
1105194 | 1105194 | Reporting Area D1 | Reporting Area D1 | 2020-08-01 | Madera | 39 | 0 | 11908 | |
1105195 | 1105195 | Reporting Area D2 | Reporting Area D2 | 2020-08-01 | Madera | 39 | 0 | 28123 | |
1104003 | 1104003 | Reporting Area A | Reporting Area A | 2020-08-02 | Madera | 39 | 536 | 40623 | |
1104004 | 1104004 | Reporting Area B | Reporting Area B | 2020-08-02 | Madera | 39 | 138 | 25062 | |
1104005 | 1104005 | Reporting Area C | Reporting Area C | 2020-08-02 | Madera | 39 | 947 | 49068 | |
1104006 | 1104006 | Reporting Area D1 | Reporting Area D1 | 2020-08-02 | Madera | 39 | 0 | 11908 | |
1104007 | 1104007 | Reporting Area D2 | Reporting Area D2 | 2020-08-02 | Madera | 39 | 0 | 28123 | |
1102815 | 1102815 | Reporting Area A | Reporting Area A | 2020-08-03 | Madera | 39 | 565 | 40623 | |
1102816 | 1102816 | Reporting Area B | Reporting Area B | 2020-08-03 | Madera | 39 | 151 | 25062 | |
1102817 | 1102817 | Reporting Area C | Reporting Area C | 2020-08-03 | Madera | 39 | 1013 | 49068 | |
1102818 | 1102818 | Reporting Area D1 | Reporting Area D1 | 2020-08-03 | Madera | 39 | 0 | 11908 | |
1102819 | 1102819 | Reporting Area D2 | Reporting Area D2 | 2020-08-03 | Madera | 39 | 0 | 28123 | |
1101627 | 1101627 | Reporting Area A | Reporting Area A | 2020-08-04 | Madera | 39 | 574 | 40623 | |
1101628 | 1101628 | Reporting Area B | Reporting Area B | 2020-08-04 | Madera | 39 | 152 | 25062 | |
1101629 | 1101629 | Reporting Area C | Reporting Area C | 2020-08-04 | Madera | 39 | 1000 | 49068 | |
1101630 | 1101630 | Reporting Area D1 | Reporting Area D1 | 2020-08-04 | Madera | 39 | 0 | 11908 | |
1101631 | 1101631 | Reporting Area D2 | Reporting Area D2 | 2020-08-04 | Madera | 39 | 0 | 28123 | |
1100439 | 1100439 | Reporting Area A | Reporting Area A | 2020-08-05 | Madera | 39 | 574 | 40623 | |
1100440 | 1100440 | Reporting Area B | Reporting Area B | 2020-08-05 | Madera | 39 | 152 | 25062 | |
1100441 | 1100441 | Reporting Area C | Reporting Area C | 2020-08-05 | Madera | 39 | 1033 | 49068 | |
1100442 | 1100442 | Reporting Area D1 | Reporting Area D1 | 2020-08-05 | Madera | 39 | 0 | 11908 | |
1100443 | 1100443 | Reporting Area D2 | Reporting Area D2 | 2020-08-05 | Madera | 39 | 0 | 28123 | |
1099251 | 1099251 | Reporting Area A | Reporting Area A | 2020-08-06 | Madera | 39 | 632 | 40623 | |
1099252 | 1099252 | Reporting Area B | Reporting Area B | 2020-08-06 | Madera | 39 | 157 | 25062 | |
1099253 | 1099253 | Reporting Area C | Reporting Area C | 2020-08-06 | Madera | 39 | 1108 | 49068 | |
1099254 | 1099254 | Reporting Area D1 | Reporting Area D1 | 2020-08-06 | Madera | 39 | 0 | 11908 | |
1099255 | 1099255 | Reporting Area D2 | Reporting Area D2 | 2020-08-06 | Madera | 39 | 0 | 28123 | |
1098063 | 1098063 | Reporting Area A | Reporting Area A | 2020-08-07 | Madera | 39 | 644 | 40623 | |
1098064 | 1098064 | Reporting Area B | Reporting Area B | 2020-08-07 | Madera | 39 | 158 | 25062 | |
1098065 | 1098065 | Reporting Area C | Reporting Area C | 2020-08-07 | Madera | 39 | 1127 | 49068 | |
1098066 | 1098066 | Reporting Area D1 | Reporting Area D1 | 2020-08-07 | Madera | 39 | 0 | 11908 | |
1098067 | 1098067 | Reporting Area D2 | Reporting Area D2 | 2020-08-07 | Madera | 39 | 0 | 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 );