latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
50 rows where "date" is on date 2020-07-17 and fips = 29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1122586 | 1122586 | 93238 | 93238: Kernville | 2020-07-17 | Kern | 29 | 1 | 1408 | |
1122587 | 1122587 | 93240 | 93240: Lake Isabella | 2020-07-17 | Kern | 29 | 4 | 6960 | |
1122588 | 1122588 | 93241 | 93241: Lamont | 2020-07-17 | Kern | 29 | 263 | 16969 | |
1122589 | 1122589 | 93243 | 93243: Lebec | 2020-07-17 | Kern | 29 | 2 | 1709 | |
1122590 | 1122590 | 93249 | 93249: Lost Hills | 2020-07-17 | Kern | 29 | 29 | 2264 | |
1122591 | 1122591 | 93250 | 93250: Mc Farland | 2020-07-17 | Kern | 29 | 135 | 15523 | |
1122592 | 1122592 | 93251 | 93251: Mc Kittrick | 2020-07-17 | Kern | 29 | 0 | 243 | |
1122593 | 1122593 | 93252 | 93252: Maricopa | 2020-07-17 | Kern | 29 | 5 | 3188 | |
1122594 | 1122594 | 93255 | 93255: Onyx | 2020-07-17 | Kern | 29 | 0 | 707 | |
1122595 | 1122595 | 93263 | 93263: Shafter | 2020-07-17 | Kern | 29 | 251 | 20710 | |
1122596 | 1122596 | 93268 | 93268: Taft | 2020-07-17 | Kern | 29 | 90 | 17620 | |
1122597 | 1122597 | 93276 | 93276: Tupman | 2020-07-17 | Kern | 29 | 1 | 159 | |
1122598 | 1122598 | 93280 | 93280: Wasco | 2020-07-17 | Kern | 29 | 260 | 27552 | |
1122599 | 1122599 | 93283 | 93283: Weldon | 2020-07-17 | Kern | 29 | 1 | 2086 | |
1122600 | 1122600 | 93285 | 93285: Wofford Heights | 2020-07-17 | Kern | 29 | 4 | 1723 | |
1122601 | 1122601 | 93287 | 93287: Woody | 2020-07-17 | Kern | 29 | 0 | 74 | |
1122602 | 1122602 | 93301 | 93301: Bakersfield | 2020-07-17 | Kern | 29 | 126 | 12345 | |
1122603 | 1122603 | 93304 | 93304: Bakersfield | 2020-07-17 | Kern | 29 | 526 | 50787 | |
1122604 | 1122604 | 93305 | 93305: Bakersfield | 2020-07-17 | Kern | 29 | 429 | 39114 | |
1122605 | 1122605 | 93306 | 93306: Bakersfield | 2020-07-17 | Kern | 29 | 816 | 70208 | |
1122606 | 1122606 | 93307 | 93307: Bakersfield | 2020-07-17 | Kern | 29 | 1144 | 84948 | |
1122607 | 1122607 | 93308 | 93308: Bakersfield | 2020-07-17 | Kern | 29 | 289 | 54042 | |
1122608 | 1122608 | 93309 | 93309: Bakersfield | 2020-07-17 | Kern | 29 | 572 | 60893 | |
1122609 | 1122609 | 93311 | 93311: Bakersfield | 2020-07-17 | Kern | 29 | 316 | 44862 | |
1122610 | 1122610 | 93312 | 93312: Bakersfield | 2020-07-17 | Kern | 29 | 330 | 59359 | |
1122611 | 1122611 | 93313 | 93313: Bakersfield | 2020-07-17 | Kern | 29 | 555 | 51245 | |
1122612 | 1122612 | 93314 | 93314: Bakersfield | 2020-07-17 | Kern | 29 | 181 | 26992 | |
1122613 | 1122613 | 93501 | 93501: Mojave | 2020-07-17 | Kern | 29 | 19 | 5063 | |
1122614 | 1122614 | 93505 | 93505: California City | 2020-07-17 | Kern | 29 | 27 | 13445 | |
1122615 | 1122615 | 93516 | 93516: Boron | 2020-07-17 | Kern | 29 | 2 | 2425 | |
1122616 | 1122616 | 93518 | 93518: Caliente | 2020-07-17 | Kern | 29 | 0 | 995 | |
1122617 | 1122617 | 93519 | 93519: Cantil | 2020-07-17 | Kern | 29 | 0 | 28 | |
1122618 | 1122618 | 93523 | 93523: Edwards | 2020-07-17 | Kern | 29 | 3 | 3312 | |
1122619 | 1122619 | 93524 | 93524: Edwards | 2020-07-17 | Kern | 29 | 0 | 168 | |
1122620 | 1122620 | 93527 | 93527: Inyokern | 2020-07-17 | Kern | 29 | 3 | 1852 | |
1122621 | 1122621 | 93203 | 93203: Arvin | 2020-07-17 | Kern | 29 | 249 | 22471 | |
1122622 | 1122622 | 93205 | 93205: Bodfish | 2020-07-17 | Kern | 29 | 1 | 1593 | |
1122623 | 1122623 | 93206 | 93206: Buttonwillow | 2020-07-17 | Kern | 29 | 22 | 2044 | |
1122624 | 1122624 | 93215 | 93215: Delano | 2020-07-17 | Kern | 29 | 318 | 55845 | |
1122625 | 1122625 | 93220 | 93220: Edison | 2020-07-17 | Kern | 29 | 1 | 313 | |
1122626 | 1122626 | 93222 | 93222: Pine Mountain Club | 2020-07-17 | Kern | 29 | 3 | 1420 | |
1122627 | 1122627 | 93224 | 93224: Fellows | 2020-07-17 | Kern | 29 | 1 | 402 | |
1122628 | 1122628 | 93225 | 93225: Frazier Park | 2020-07-17 | Kern | 29 | 10 | 5319 | |
1122629 | 1122629 | 93226 | 93226: Glennville | 2020-07-17 | Kern | 29 | 1 | 195 | |
1122630 | 1122630 | 93528 | 93528: Johannesburg | 2020-07-17 | Kern | 29 | 0 | 124 | |
1122631 | 1122631 | 93531 | 93531: Keene | 2020-07-17 | Kern | 29 | 0 | 422 | |
1122632 | 1122632 | 93554 | 93554: Randsburg | 2020-07-17 | Kern | 29 | 0 | 143 | |
1122633 | 1122633 | 93555 | 93555: Ridgecrest | 2020-07-17 | Kern | 29 | 22 | 34075 | |
1122634 | 1122634 | 93560 | 93560: Rosamond | 2020-07-17 | Kern | 29 | 70 | 20797 | |
1122635 | 1122635 | 93561 | 93561: Tehachapi | 2020-07-17 | Kern | 29 | 152 | 34271 |
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 );