latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
50 rows where county = "Kern", "date" is on date 2020-06-30 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 |
---|---|---|---|---|---|---|---|---|---|
1142561 | 1142561 | 93238 | 93238: Kernville | 2020-06-30 | Kern | 29 | 1 | 1408 | |
1142562 | 1142562 | 93240 | 93240: Lake Isabella | 2020-06-30 | Kern | 29 | 3 | 6960 | |
1142563 | 1142563 | 93241 | 93241: Lamont | 2020-06-30 | Kern | 29 | 183 | 16969 | |
1142564 | 1142564 | 93243 | 93243: Lebec | 2020-06-30 | Kern | 29 | 2 | 1709 | |
1142565 | 1142565 | 93249 | 93249: Lost Hills | 2020-06-30 | Kern | 29 | 19 | 2264 | |
1142566 | 1142566 | 93250 | 93250: Mc Farland | 2020-06-30 | Kern | 29 | 69 | 15523 | |
1142567 | 1142567 | 93251 | 93251: Mc Kittrick | 2020-06-30 | Kern | 29 | 0 | 243 | |
1142568 | 1142568 | 93252 | 93252: Maricopa | 2020-06-30 | Kern | 29 | 3 | 3188 | |
1142569 | 1142569 | 93255 | 93255: Onyx | 2020-06-30 | Kern | 29 | 0 | 707 | |
1142570 | 1142570 | 93263 | 93263: Shafter | 2020-06-30 | Kern | 29 | 127 | 20710 | |
1142571 | 1142571 | 93268 | 93268: Taft | 2020-06-30 | Kern | 29 | 58 | 17620 | |
1142572 | 1142572 | 93276 | 93276: Tupman | 2020-06-30 | Kern | 29 | 1 | 159 | |
1142573 | 1142573 | 93280 | 93280: Wasco | 2020-06-30 | Kern | 29 | 128 | 27552 | |
1142574 | 1142574 | 93283 | 93283: Weldon | 2020-06-30 | Kern | 29 | 0 | 2086 | |
1142575 | 1142575 | 93285 | 93285: Wofford Heights | 2020-06-30 | Kern | 29 | 3 | 1723 | |
1142576 | 1142576 | 93287 | 93287: Woody | 2020-06-30 | Kern | 29 | 0 | 74 | |
1142577 | 1142577 | 93301 | 93301: Bakersfield | 2020-06-30 | Kern | 29 | 79 | 12345 | |
1142578 | 1142578 | 93304 | 93304: Bakersfield | 2020-06-30 | Kern | 29 | 384 | 50787 | |
1142579 | 1142579 | 93305 | 93305: Bakersfield | 2020-06-30 | Kern | 29 | 293 | 39114 | |
1142580 | 1142580 | 93306 | 93306: Bakersfield | 2020-06-30 | Kern | 29 | 470 | 70208 | |
1142581 | 1142581 | 93307 | 93307: Bakersfield | 2020-06-30 | Kern | 29 | 804 | 84948 | |
1142582 | 1142582 | 93308 | 93308: Bakersfield | 2020-06-30 | Kern | 29 | 180 | 54042 | |
1142583 | 1142583 | 93309 | 93309: Bakersfield | 2020-06-30 | Kern | 29 | 393 | 60893 | |
1142584 | 1142584 | 93311 | 93311: Bakersfield | 2020-06-30 | Kern | 29 | 204 | 44862 | |
1142585 | 1142585 | 93312 | 93312: Bakersfield | 2020-06-30 | Kern | 29 | 172 | 59359 | |
1142586 | 1142586 | 93313 | 93313: Bakersfield | 2020-06-30 | Kern | 29 | 313 | 51245 | |
1142587 | 1142587 | 93314 | 93314: Bakersfield | 2020-06-30 | Kern | 29 | 101 | 26992 | |
1142588 | 1142588 | 93501 | 93501: Mojave | 2020-06-30 | Kern | 29 | 18 | 5063 | |
1142589 | 1142589 | 93505 | 93505: California City | 2020-06-30 | Kern | 29 | 23 | 13445 | |
1142590 | 1142590 | 93516 | 93516: Boron | 2020-06-30 | Kern | 29 | 2 | 2425 | |
1142591 | 1142591 | 93518 | 93518: Caliente | 2020-06-30 | Kern | 29 | 0 | 995 | |
1142592 | 1142592 | 93519 | 93519: Cantil | 2020-06-30 | Kern | 29 | 0 | 28 | |
1142593 | 1142593 | 93523 | 93523: Edwards | 2020-06-30 | Kern | 29 | 3 | 3312 | |
1142594 | 1142594 | 93524 | 93524: Edwards | 2020-06-30 | Kern | 29 | 0 | 168 | |
1142595 | 1142595 | 93527 | 93527: Inyokern | 2020-06-30 | Kern | 29 | 2 | 1852 | |
1142596 | 1142596 | 93203 | 93203: Arvin | 2020-06-30 | Kern | 29 | 181 | 22471 | |
1142597 | 1142597 | 93205 | 93205: Bodfish | 2020-06-30 | Kern | 29 | 0 | 1593 | |
1142598 | 1142598 | 93206 | 93206: Buttonwillow | 2020-06-30 | Kern | 29 | 15 | 2044 | |
1142599 | 1142599 | 93215 | 93215: Delano | 2020-06-30 | Kern | 29 | 200 | 55845 | |
1142600 | 1142600 | 93220 | 93220: Edison | 2020-06-30 | Kern | 29 | 1 | 313 | |
1142601 | 1142601 | 93222 | 93222: Pine Mountain Club | 2020-06-30 | Kern | 29 | 3 | 1420 | |
1142602 | 1142602 | 93224 | 93224: Fellows | 2020-06-30 | Kern | 29 | 1 | 402 | |
1142603 | 1142603 | 93225 | 93225: Frazier Park | 2020-06-30 | Kern | 29 | 6 | 5319 | |
1142604 | 1142604 | 93226 | 93226: Glennville | 2020-06-30 | Kern | 29 | 1 | 195 | |
1142605 | 1142605 | 93528 | 93528: Johannesburg | 2020-06-30 | Kern | 29 | 0 | 124 | |
1142606 | 1142606 | 93531 | 93531: Keene | 2020-06-30 | Kern | 29 | 0 | 422 | |
1142607 | 1142607 | 93554 | 93554: Randsburg | 2020-06-30 | Kern | 29 | 0 | 143 | |
1142608 | 1142608 | 93555 | 93555: Ridgecrest | 2020-06-30 | Kern | 29 | 11 | 34075 | |
1142609 | 1142609 | 93560 | 93560: Rosamond | 2020-06-30 | Kern | 29 | 55 | 20797 | |
1142610 | 1142610 | 93561 | 93561: Tehachapi | 2020-06-30 | Kern | 29 | 37 | 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 );