latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
32 rows where county = "Fresno", "date" is on date 2020-09-18 and fips = 19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1047646 | 1047646 | Auberry | Auberry | 2020-09-18 | Fresno | 19 | 17 | 3994 | |
1047647 | 1047647 | Biola | Biola | 2020-09-18 | Fresno | 19 | 62 | 949 | |
1047648 | 1047648 | Cantua Creek | Cantua Creek | 2020-09-18 | Fresno | 19 | 36 | 1125 | |
1047649 | 1047649 | Caruthers | Caruthers | 2020-09-18 | Fresno | 19 | 246 | 5887 | |
1047650 | 1047650 | Clovis | Clovis | 2020-09-18 | Fresno | 19 | 1569 | 122949 | |
1047651 | 1047651 | Coalinga | Coalinga | 2020-09-18 | Fresno | 19 | 429 | 19345 | |
1047652 | 1047652 | Del Rey | Del Rey | 2020-09-18 | Fresno | 19 | 117 | 2759 | |
1047653 | 1047653 | Dinuba | Dinuba | 2020-09-18 | Fresno | 19 | 0 | 0 | |
1047654 | 1047654 | Dos Palos | Dos Palos | 2020-09-18 | Fresno | 19 | 0 | ||
1047655 | 1047655 | Dunlap | Dunlap | 2020-09-18 | Fresno | 19 | 5 | ||
1047656 | 1047656 | Firebaugh | Firebaugh | 2020-09-18 | Fresno | 19 | 333 | 9965 | |
1047657 | 1047657 | Five Points | Five Points | 2020-09-18 | Fresno | 19 | 12 | 0 | |
1047658 | 1047658 | Fowler | Fowler | 2020-09-18 | Fresno | 19 | 231 | 7917 | |
1047659 | 1047659 | Fresno | Fresno | 2020-09-18 | Fresno | 19 | 14753 | 608579 | |
1047660 | 1047660 | Friant | Friant | 2020-09-18 | Fresno | 19 | 20 | 1930 | |
1047661 | 1047661 | Huron | Huron | 2020-09-18 | Fresno | 19 | 399 | 7579 | |
1047662 | 1047662 | Kerman | Kerman | 2020-09-18 | Fresno | 19 | 778 | 21009 | |
1047663 | 1047663 | Kingsburg | Kingsburg | 2020-09-18 | Fresno | 19 | 409 | 17086 | |
1047664 | 1047664 | Laton | Laton | 2020-09-18 | Fresno | 19 | 124 | 3513 | |
1047665 | 1047665 | Mendota | Mendota | 2020-09-18 | Fresno | 19 | 935 | 13576 | |
1047666 | 1047666 | Orange Cove | Orange Cove | 2020-09-18 | Fresno | 19 | 637 | 11320 | |
1047667 | 1047667 | Parlier | Parlier | 2020-09-18 | Fresno | 19 | 1067 | 17097 | |
1047668 | 1047668 | Prather | Prather | 2020-09-18 | Fresno | 19 | 8 | 0 | |
1047669 | 1047669 | Raisin | Raisin | 2020-09-18 | Fresno | 19 | 0 | 380 | |
1047670 | 1047670 | Reedley | Reedley | 2020-09-18 | Fresno | 19 | 1337 | 31129 | |
1047671 | 1047671 | Riverdale | Riverdale | 2020-09-18 | Fresno | 19 | 242 | 6459 | |
1047672 | 1047672 | San Joaquin | San Joaquin | 2020-09-18 | Fresno | 19 | 196 | 4633 | |
1047673 | 1047673 | Sanger | Sanger | 2020-09-18 | Fresno | 19 | 1305 | 38252 | |
1047674 | 1047674 | Selma | Selma | 2020-09-18 | Fresno | 19 | 1441 | 31726 | |
1047675 | 1047675 | Squaw Valley | Squaw Valley | 2020-09-18 | Fresno | 19 | 17 | 3908 | |
1047676 | 1047676 | Tollhouse | Tollhouse | 2020-09-18 | Fresno | 19 | 13 | 2712 | |
1047677 | 1047677 | Tranquillity | Tranquillity | 2020-09-18 | Fresno | 19 | 33 | 1132 |
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 );