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 2022-06-30 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 |
---|---|---|---|---|---|---|---|---|---|
227049 | 227049 | Auberry | Auberry | 2022-06-30 | Fresno | 19 | 345 | 3994 | |
227050 | 227050 | Biola | Biola | 2022-06-30 | Fresno | 19 | 401 | 949 | |
227051 | 227051 | Cantua Creek | Cantua Creek | 2022-06-30 | Fresno | 19 | 286 | 1125 | |
227052 | 227052 | Caruthers | Caruthers | 2022-06-30 | Fresno | 19 | 1415 | 5887 | |
227053 | 227053 | Clovis | Clovis | 2022-06-30 | Fresno | 19 | 24232 | 122949 | |
227054 | 227054 | Coalinga | Coalinga | 2022-06-30 | Fresno | 19 | 6796 | 19345 | |
227055 | 227055 | Del Rey | Del Rey | 2022-06-30 | Fresno | 19 | 662 | 2759 | |
227056 | 227056 | Dinuba | Dinuba | 2022-06-30 | Fresno | 19 | 97 | 0 | |
227057 | 227057 | Dos Palos | Dos Palos | 2022-06-30 | Fresno | 19 | 94 | ||
227058 | 227058 | Dunlap | Dunlap | 2022-06-30 | Fresno | 19 | 6 | ||
227059 | 227059 | Firebaugh | Firebaugh | 2022-06-30 | Fresno | 19 | 2297 | 9965 | |
227060 | 227060 | Five Points | Five Points | 2022-06-30 | Fresno | 19 | 137 | 0 | |
227061 | 227061 | Fowler | Fowler | 2022-06-30 | Fresno | 19 | 2350 | 7917 | |
227062 | 227062 | Fresno | Fresno | 2022-06-30 | Fresno | 19 | 147703 | 608579 | |
227063 | 227063 | Friant | Friant | 2022-06-30 | Fresno | 19 | 271 | 1930 | |
227064 | 227064 | Huron | Huron | 2022-06-30 | Fresno | 19 | 1584 | 7579 | |
227065 | 227065 | Kerman | Kerman | 2022-06-30 | Fresno | 19 | 5258 | 21009 | |
227066 | 227066 | Kingsburg | Kingsburg | 2022-06-30 | Fresno | 19 | 3128 | 17086 | |
227067 | 227067 | Laton | Laton | 2022-06-30 | Fresno | 19 | 753 | 3513 | |
227068 | 227068 | Mendota | Mendota | 2022-06-30 | Fresno | 19 | 3265 | 13576 | |
227069 | 227069 | Orange Cove | Orange Cove | 2022-06-30 | Fresno | 19 | 3091 | 11320 | |
227070 | 227070 | Parlier | Parlier | 2022-06-30 | Fresno | 19 | 5039 | 17097 | |
227071 | 227071 | Prather | Prather | 2022-06-30 | Fresno | 19 | 166 | 0 | |
227072 | 227072 | Raisin | Raisin | 2022-06-30 | Fresno | 19 | 131 | 380 | |
227073 | 227073 | Reedley | Reedley | 2022-06-30 | Fresno | 19 | 7578 | 31129 | |
227074 | 227074 | Riverdale | Riverdale | 2022-06-30 | Fresno | 19 | 1602 | 6459 | |
227075 | 227075 | San Joaquin | San Joaquin | 2022-06-30 | Fresno | 19 | 1110 | 4633 | |
227076 | 227076 | Sanger | Sanger | 2022-06-30 | Fresno | 19 | 10507 | 38252 | |
227077 | 227077 | Selma | Selma | 2022-06-30 | Fresno | 19 | 9314 | 31726 | |
227078 | 227078 | Squaw Valley | Squaw Valley | 2022-06-30 | Fresno | 19 | 342 | 3908 | |
227079 | 227079 | Tollhouse | Tollhouse | 2022-06-30 | Fresno | 19 | 261 | 2712 | |
227080 | 227080 | Tranquillity | Tranquillity | 2022-06-30 | Fresno | 19 | 245 | 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 );