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-24 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 |
---|---|---|---|---|---|---|---|---|---|
1040494 | 1040494 | Auberry | Auberry | 2020-09-24 | Fresno | 19 | 19 | 3994 | |
1040495 | 1040495 | Biola | Biola | 2020-09-24 | Fresno | 19 | 62 | 949 | |
1040496 | 1040496 | Cantua Creek | Cantua Creek | 2020-09-24 | Fresno | 19 | 37 | 1125 | |
1040497 | 1040497 | Caruthers | Caruthers | 2020-09-24 | Fresno | 19 | 249 | 5887 | |
1040498 | 1040498 | Clovis | Clovis | 2020-09-24 | Fresno | 19 | 1590 | 122949 | |
1040499 | 1040499 | Coalinga | Coalinga | 2020-09-24 | Fresno | 19 | 441 | 19345 | |
1040500 | 1040500 | Del Rey | Del Rey | 2020-09-24 | Fresno | 19 | 117 | 2759 | |
1040501 | 1040501 | Dinuba | Dinuba | 2020-09-24 | Fresno | 19 | 0 | 0 | |
1040502 | 1040502 | Dos Palos | Dos Palos | 2020-09-24 | Fresno | 19 | 0 | ||
1040503 | 1040503 | Dunlap | Dunlap | 2020-09-24 | Fresno | 19 | 5 | ||
1040504 | 1040504 | Firebaugh | Firebaugh | 2020-09-24 | Fresno | 19 | 340 | 9965 | |
1040505 | 1040505 | Five Points | Five Points | 2020-09-24 | Fresno | 19 | 13 | 0 | |
1040506 | 1040506 | Fowler | Fowler | 2020-09-24 | Fresno | 19 | 231 | 7917 | |
1040507 | 1040507 | Fresno | Fresno | 2020-09-24 | Fresno | 19 | 14960 | 608579 | |
1040508 | 1040508 | Friant | Friant | 2020-09-24 | Fresno | 19 | 20 | 1930 | |
1040509 | 1040509 | Huron | Huron | 2020-09-24 | Fresno | 19 | 402 | 7579 | |
1040510 | 1040510 | Kerman | Kerman | 2020-09-24 | Fresno | 19 | 804 | 21009 | |
1040511 | 1040511 | Kingsburg | Kingsburg | 2020-09-24 | Fresno | 19 | 411 | 17086 | |
1040512 | 1040512 | Laton | Laton | 2020-09-24 | Fresno | 19 | 126 | 3513 | |
1040513 | 1040513 | Mendota | Mendota | 2020-09-24 | Fresno | 19 | 960 | 13576 | |
1040514 | 1040514 | Orange Cove | Orange Cove | 2020-09-24 | Fresno | 19 | 645 | 11320 | |
1040515 | 1040515 | Parlier | Parlier | 2020-09-24 | Fresno | 19 | 1071 | 17097 | |
1040516 | 1040516 | Prather | Prather | 2020-09-24 | Fresno | 19 | 8 | 0 | |
1040517 | 1040517 | Raisin | Raisin | 2020-09-24 | Fresno | 19 | 0 | 380 | |
1040518 | 1040518 | Reedley | Reedley | 2020-09-24 | Fresno | 19 | 1351 | 31129 | |
1040519 | 1040519 | Riverdale | Riverdale | 2020-09-24 | Fresno | 19 | 248 | 6459 | |
1040520 | 1040520 | San Joaquin | San Joaquin | 2020-09-24 | Fresno | 19 | 201 | 4633 | |
1040521 | 1040521 | Sanger | Sanger | 2020-09-24 | Fresno | 19 | 1317 | 38252 | |
1040522 | 1040522 | Selma | Selma | 2020-09-24 | Fresno | 19 | 1460 | 31726 | |
1040523 | 1040523 | Squaw Valley | Squaw Valley | 2020-09-24 | Fresno | 19 | 17 | 3908 | |
1040524 | 1040524 | Tollhouse | Tollhouse | 2020-09-24 | Fresno | 19 | 13 | 2712 | |
1040525 | 1040525 | Tranquillity | Tranquillity | 2020-09-24 | Fresno | 19 | 35 | 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 );