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-07-31 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 |
---|---|---|---|---|---|---|---|---|---|
1105918 | 1105918 | Auberry | Auberry | 2020-07-31 | Fresno | 19 | 7 | 3994 | |
1105919 | 1105919 | Biola | Biola | 2020-07-31 | Fresno | 19 | 43 | 949 | |
1105920 | 1105920 | Cantua Creek | Cantua Creek | 2020-07-31 | Fresno | 19 | 11 | 1125 | |
1105921 | 1105921 | Caruthers | Caruthers | 2020-07-31 | Fresno | 19 | 157 | 5887 | |
1105922 | 1105922 | Clovis | Clovis | 2020-07-31 | Fresno | 19 | 791 | 122949 | |
1105923 | 1105923 | Coalinga | Coalinga | 2020-07-31 | Fresno | 19 | 176 | 19345 | |
1105924 | 1105924 | Del Rey | Del Rey | 2020-07-31 | Fresno | 19 | 62 | 2759 | |
1105925 | 1105925 | Dinuba | Dinuba | 2020-07-31 | Fresno | 19 | 0 | 0 | |
1105926 | 1105926 | Dos Palos | Dos Palos | 2020-07-31 | Fresno | 19 | 0 | ||
1105927 | 1105927 | Dunlap | Dunlap | 2020-07-31 | Fresno | 19 | 6 | ||
1105928 | 1105928 | Firebaugh | Firebaugh | 2020-07-31 | Fresno | 19 | 149 | 9965 | |
1105929 | 1105929 | Five Points | Five Points | 2020-07-31 | Fresno | 19 | 5 | 0 | |
1105930 | 1105930 | Fowler | Fowler | 2020-07-31 | Fresno | 19 | 121 | 7917 | |
1105931 | 1105931 | Fresno | Fresno | 2020-07-31 | Fresno | 19 | 7928 | 608579 | |
1105932 | 1105932 | Friant | Friant | 2020-07-31 | Fresno | 19 | 10 | 1930 | |
1105933 | 1105933 | Huron | Huron | 2020-07-31 | Fresno | 19 | 197 | 7579 | |
1105934 | 1105934 | Kerman | Kerman | 2020-07-31 | Fresno | 19 | 361 | 21009 | |
1105935 | 1105935 | Kingsburg | Kingsburg | 2020-07-31 | Fresno | 19 | 232 | 17086 | |
1105936 | 1105936 | Laton | Laton | 2020-07-31 | Fresno | 19 | 73 | 3513 | |
1105937 | 1105937 | Mendota | Mendota | 2020-07-31 | Fresno | 19 | 562 | 13576 | |
1105938 | 1105938 | Orange Cove | Orange Cove | 2020-07-31 | Fresno | 19 | 327 | 11320 | |
1105939 | 1105939 | Parlier | Parlier | 2020-07-31 | Fresno | 19 | 579 | 17097 | |
1105940 | 1105940 | Prather | Prather | 2020-07-31 | Fresno | 19 | 0 | 0 | |
1105941 | 1105941 | Raisin | Raisin | 2020-07-31 | Fresno | 19 | 0 | 380 | |
1105942 | 1105942 | Reedley | Reedley | 2020-07-31 | Fresno | 19 | 695 | 31129 | |
1105943 | 1105943 | Riverdale | Riverdale | 2020-07-31 | Fresno | 19 | 125 | 6459 | |
1105944 | 1105944 | San Joaquin | San Joaquin | 2020-07-31 | Fresno | 19 | 122 | 4633 | |
1105945 | 1105945 | Sanger | Sanger | 2020-07-31 | Fresno | 19 | 711 | 38252 | |
1105946 | 1105946 | Selma | Selma | 2020-07-31 | Fresno | 19 | 849 | 31726 | |
1105947 | 1105947 | Squaw Valley | Squaw Valley | 2020-07-31 | Fresno | 19 | 6 | 3908 | |
1105948 | 1105948 | Tollhouse | Tollhouse | 2020-07-31 | Fresno | 19 | 10 | 2712 | |
1105949 | 1105949 | Tranquillity | Tranquillity | 2020-07-31 | Fresno | 19 | 24 | 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 );