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-01 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 |
---|---|---|---|---|---|---|---|---|---|
1067902 | 1067902 | Auberry | Auberry | 2020-09-01 | Fresno | 19 | 15 | 3994 | |
1067903 | 1067903 | Biola | Biola | 2020-09-01 | Fresno | 19 | 60 | 949 | |
1067904 | 1067904 | Cantua Creek | Cantua Creek | 2020-09-01 | Fresno | 19 | 32 | 1125 | |
1067905 | 1067905 | Caruthers | Caruthers | 2020-09-01 | Fresno | 19 | 236 | 5887 | |
1067906 | 1067906 | Clovis | Clovis | 2020-09-01 | Fresno | 19 | 1367 | 122949 | |
1067907 | 1067907 | Coalinga | Coalinga | 2020-09-01 | Fresno | 19 | 354 | 19345 | |
1067908 | 1067908 | Del Rey | Del Rey | 2020-09-01 | Fresno | 19 | 110 | 2759 | |
1067909 | 1067909 | Dinuba | Dinuba | 2020-09-01 | Fresno | 19 | 0 | 0 | |
1067910 | 1067910 | Dos Palos | Dos Palos | 2020-09-01 | Fresno | 19 | 0 | ||
1067911 | 1067911 | Dunlap | Dunlap | 2020-09-01 | Fresno | 19 | 5 | ||
1067912 | 1067912 | Firebaugh | Firebaugh | 2020-09-01 | Fresno | 19 | 302 | 9965 | |
1067913 | 1067913 | Five Points | Five Points | 2020-09-01 | Fresno | 19 | 12 | 0 | |
1067914 | 1067914 | Fowler | Fowler | 2020-09-01 | Fresno | 19 | 217 | 7917 | |
1067915 | 1067915 | Fresno | Fresno | 2020-09-01 | Fresno | 19 | 13442 | 608579 | |
1067916 | 1067916 | Friant | Friant | 2020-09-01 | Fresno | 19 | 20 | 1930 | |
1067917 | 1067917 | Huron | Huron | 2020-09-01 | Fresno | 19 | 358 | 7579 | |
1067918 | 1067918 | Kerman | Kerman | 2020-09-01 | Fresno | 19 | 704 | 21009 | |
1067919 | 1067919 | Kingsburg | Kingsburg | 2020-09-01 | Fresno | 19 | 380 | 17086 | |
1067920 | 1067920 | Laton | Laton | 2020-09-01 | Fresno | 19 | 119 | 3513 | |
1067921 | 1067921 | Mendota | Mendota | 2020-09-01 | Fresno | 19 | 874 | 13576 | |
1067922 | 1067922 | Orange Cove | Orange Cove | 2020-09-01 | Fresno | 19 | 606 | 11320 | |
1067923 | 1067923 | Parlier | Parlier | 2020-09-01 | Fresno | 19 | 1016 | 17097 | |
1067924 | 1067924 | Prather | Prather | 2020-09-01 | Fresno | 19 | 7 | 0 | |
1067925 | 1067925 | Raisin | Raisin | 2020-09-01 | Fresno | 19 | 0 | 380 | |
1067926 | 1067926 | Reedley | Reedley | 2020-09-01 | Fresno | 19 | 1250 | 31129 | |
1067927 | 1067927 | Riverdale | Riverdale | 2020-09-01 | Fresno | 19 | 218 | 6459 | |
1067928 | 1067928 | San Joaquin | San Joaquin | 2020-09-01 | Fresno | 19 | 187 | 4633 | |
1067929 | 1067929 | Sanger | Sanger | 2020-09-01 | Fresno | 19 | 1211 | 38252 | |
1067930 | 1067930 | Selma | Selma | 2020-09-01 | Fresno | 19 | 1375 | 31726 | |
1067931 | 1067931 | Squaw Valley | Squaw Valley | 2020-09-01 | Fresno | 19 | 15 | 3908 | |
1067932 | 1067932 | Tollhouse | Tollhouse | 2020-09-01 | Fresno | 19 | 12 | 2712 | |
1067933 | 1067933 | Tranquillity | Tranquillity | 2020-09-01 | Fresno | 19 | 30 | 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 );