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-23 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 |
---|---|---|---|---|---|---|---|---|---|
1078594 | 1078594 | Auberry | Auberry | 2020-08-23 | Fresno | 19 | 12 | 3994 | |
1078595 | 1078595 | Biola | Biola | 2020-08-23 | Fresno | 19 | 50 | 949 | |
1078596 | 1078596 | Cantua Creek | Cantua Creek | 2020-08-23 | Fresno | 19 | 25 | 1125 | |
1078597 | 1078597 | Caruthers | Caruthers | 2020-08-23 | Fresno | 19 | 218 | 5887 | |
1078598 | 1078598 | Clovis | Clovis | 2020-08-23 | Fresno | 19 | 1191 | 122949 | |
1078599 | 1078599 | Coalinga | Coalinga | 2020-08-23 | Fresno | 19 | 307 | 19345 | |
1078600 | 1078600 | Del Rey | Del Rey | 2020-08-23 | Fresno | 19 | 100 | 2759 | |
1078601 | 1078601 | Dinuba | Dinuba | 2020-08-23 | Fresno | 19 | 0 | 0 | |
1078602 | 1078602 | Dos Palos | Dos Palos | 2020-08-23 | Fresno | 19 | 0 | ||
1078603 | 1078603 | Dunlap | Dunlap | 2020-08-23 | Fresno | 19 | 5 | ||
1078604 | 1078604 | Firebaugh | Firebaugh | 2020-08-23 | Fresno | 19 | 257 | 9965 | |
1078605 | 1078605 | Five Points | Five Points | 2020-08-23 | Fresno | 19 | 12 | 0 | |
1078606 | 1078606 | Fowler | Fowler | 2020-08-23 | Fresno | 19 | 201 | 7917 | |
1078607 | 1078607 | Fresno | Fresno | 2020-08-23 | Fresno | 19 | 11841 | 608579 | |
1078608 | 1078608 | Friant | Friant | 2020-08-23 | Fresno | 19 | 19 | 1930 | |
1078609 | 1078609 | Huron | Huron | 2020-08-23 | Fresno | 19 | 332 | 7579 | |
1078610 | 1078610 | Kerman | Kerman | 2020-08-23 | Fresno | 19 | 623 | 21009 | |
1078611 | 1078611 | Kingsburg | Kingsburg | 2020-08-23 | Fresno | 19 | 334 | 17086 | |
1078612 | 1078612 | Laton | Laton | 2020-08-23 | Fresno | 19 | 114 | 3513 | |
1078613 | 1078613 | Mendota | Mendota | 2020-08-23 | Fresno | 19 | 815 | 13576 | |
1078614 | 1078614 | Orange Cove | Orange Cove | 2020-08-23 | Fresno | 19 | 554 | 11320 | |
1078615 | 1078615 | Parlier | Parlier | 2020-08-23 | Fresno | 19 | 933 | 17097 | |
1078616 | 1078616 | Prather | Prather | 2020-08-23 | Fresno | 19 | 6 | 0 | |
1078617 | 1078617 | Raisin | Raisin | 2020-08-23 | Fresno | 19 | 0 | 380 | |
1078618 | 1078618 | Reedley | Reedley | 2020-08-23 | Fresno | 19 | 1138 | 31129 | |
1078619 | 1078619 | Riverdale | Riverdale | 2020-08-23 | Fresno | 19 | 188 | 6459 | |
1078620 | 1078620 | San Joaquin | San Joaquin | 2020-08-23 | Fresno | 19 | 174 | 4633 | |
1078621 | 1078621 | Sanger | Sanger | 2020-08-23 | Fresno | 19 | 1080 | 38252 | |
1078622 | 1078622 | Selma | Selma | 2020-08-23 | Fresno | 19 | 1253 | 31726 | |
1078623 | 1078623 | Squaw Valley | Squaw Valley | 2020-08-23 | Fresno | 19 | 13 | 3908 | |
1078624 | 1078624 | Tollhouse | Tollhouse | 2020-08-23 | Fresno | 19 | 11 | 2712 | |
1078625 | 1078625 | Tranquillity | Tranquillity | 2020-08-23 | Fresno | 19 | 27 | 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 );