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-08-16 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 |
---|---|---|---|---|---|---|---|---|---|
1086910 | 1086910 | Auberry | Auberry | 2020-08-16 | Fresno | 19 | 9 | 3994 | |
1086911 | 1086911 | Biola | Biola | 2020-08-16 | Fresno | 19 | 48 | 949 | |
1086912 | 1086912 | Cantua Creek | Cantua Creek | 2020-08-16 | Fresno | 19 | 15 | 1125 | |
1086913 | 1086913 | Caruthers | Caruthers | 2020-08-16 | Fresno | 19 | 196 | 5887 | |
1086914 | 1086914 | Clovis | Clovis | 2020-08-16 | Fresno | 19 | 1039 | 122949 | |
1086915 | 1086915 | Coalinga | Coalinga | 2020-08-16 | Fresno | 19 | 251 | 19345 | |
1086916 | 1086916 | Del Rey | Del Rey | 2020-08-16 | Fresno | 19 | 84 | 2759 | |
1086917 | 1086917 | Dinuba | Dinuba | 2020-08-16 | Fresno | 19 | 0 | 0 | |
1086918 | 1086918 | Dos Palos | Dos Palos | 2020-08-16 | Fresno | 19 | 0 | ||
1086919 | 1086919 | Dunlap | Dunlap | 2020-08-16 | Fresno | 19 | 6 | ||
1086920 | 1086920 | Firebaugh | Firebaugh | 2020-08-16 | Fresno | 19 | 210 | 9965 | |
1086921 | 1086921 | Five Points | Five Points | 2020-08-16 | Fresno | 19 | 8 | 0 | |
1086922 | 1086922 | Fowler | Fowler | 2020-08-16 | Fresno | 19 | 172 | 7917 | |
1086923 | 1086923 | Fresno | Fresno | 2020-08-16 | Fresno | 19 | 10308 | 608579 | |
1086924 | 1086924 | Friant | Friant | 2020-08-16 | Fresno | 19 | 16 | 1930 | |
1086925 | 1086925 | Huron | Huron | 2020-08-16 | Fresno | 19 | 283 | 7579 | |
1086926 | 1086926 | Kerman | Kerman | 2020-08-16 | Fresno | 19 | 491 | 21009 | |
1086927 | 1086927 | Kingsburg | Kingsburg | 2020-08-16 | Fresno | 19 | 299 | 17086 | |
1086928 | 1086928 | Laton | Laton | 2020-08-16 | Fresno | 19 | 95 | 3513 | |
1086929 | 1086929 | Mendota | Mendota | 2020-08-16 | Fresno | 19 | 678 | 13576 | |
1086930 | 1086930 | Orange Cove | Orange Cove | 2020-08-16 | Fresno | 19 | 467 | 11320 | |
1086931 | 1086931 | Parlier | Parlier | 2020-08-16 | Fresno | 19 | 807 | 17097 | |
1086932 | 1086932 | Prather | Prather | 2020-08-16 | Fresno | 19 | 6 | 0 | |
1086933 | 1086933 | Raisin | Raisin | 2020-08-16 | Fresno | 19 | 0 | 380 | |
1086934 | 1086934 | Reedley | Reedley | 2020-08-16 | Fresno | 19 | 960 | 31129 | |
1086935 | 1086935 | Riverdale | Riverdale | 2020-08-16 | Fresno | 19 | 166 | 6459 | |
1086936 | 1086936 | San Joaquin | San Joaquin | 2020-08-16 | Fresno | 19 | 146 | 4633 | |
1086937 | 1086937 | Sanger | Sanger | 2020-08-16 | Fresno | 19 | 946 | 38252 | |
1086938 | 1086938 | Selma | Selma | 2020-08-16 | Fresno | 19 | 1098 | 31726 | |
1086939 | 1086939 | Squaw Valley | Squaw Valley | 2020-08-16 | Fresno | 19 | 9 | 3908 | |
1086940 | 1086940 | Tollhouse | Tollhouse | 2020-08-16 | Fresno | 19 | 11 | 2712 | |
1086941 | 1086941 | Tranquillity | Tranquillity | 2020-08-16 | Fresno | 19 | 25 | 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 );