latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
31,712 rows where 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 |
---|---|---|---|---|---|---|---|---|---|
592947 | 592947 | Auberry | Auberry | 2021-09-15 | Fresno | 19 | 142 | 3994 | |
592948 | 592948 | Biola | Biola | 2021-09-15 | Fresno | 19 | 179 | 949 | |
592949 | 592949 | Cantua Creek | Cantua Creek | 2021-09-15 | Fresno | 19 | 123 | 1125 | |
592950 | 592950 | Caruthers | Caruthers | 2021-09-15 | Fresno | 19 | 711 | 5887 | |
592951 | 592951 | Clovis | Clovis | 2021-09-15 | Fresno | 19 | 9078 | 122949 | |
592952 | 592952 | Coalinga | Coalinga | 2021-09-15 | Fresno | 19 | 4051 | 19345 | |
592953 | 592953 | Del Rey | Del Rey | 2021-09-15 | Fresno | 19 | 324 | 2759 | |
592954 | 592954 | Dinuba | Dinuba | 2021-09-15 | Fresno | 19 | 0 | 0 | |
592955 | 592955 | Dos Palos | Dos Palos | 2021-09-15 | Fresno | 19 | 0 | ||
592956 | 592956 | Dunlap | Dunlap | 2021-09-15 | Fresno | 19 | 6 | ||
592957 | 592957 | Firebaugh | Firebaugh | 2021-09-15 | Fresno | 19 | 1111 | 9965 | |
592958 | 592958 | Five Points | Five Points | 2021-09-15 | Fresno | 19 | 23 | 0 | |
592959 | 592959 | Fowler | Fowler | 2021-09-15 | Fresno | 19 | 1108 | 7917 | |
592960 | 592960 | Fresno | Fresno | 2021-09-15 | Fresno | 19 | 61638 | 608579 | |
592961 | 592961 | Friant | Friant | 2021-09-15 | Fresno | 19 | 88 | 1930 | |
592962 | 592962 | Huron | Huron | 2021-09-15 | Fresno | 19 | 919 | 7579 | |
592963 | 592963 | Kerman | Kerman | 2021-09-15 | Fresno | 19 | 2699 | 21009 | |
592964 | 592964 | Kingsburg | Kingsburg | 2021-09-15 | Fresno | 19 | 1442 | 17086 | |
592965 | 592965 | Laton | Laton | 2021-09-15 | Fresno | 19 | 344 | 3513 | |
592966 | 592966 | Mendota | Mendota | 2021-09-15 | Fresno | 19 | 1863 | 13576 | |
592967 | 592967 | Orange Cove | Orange Cove | 2021-09-15 | Fresno | 19 | 1599 | 11320 | |
592968 | 592968 | Parlier | Parlier | 2021-09-15 | Fresno | 19 | 2648 | 17097 | |
592969 | 592969 | Prather | Prather | 2021-09-15 | Fresno | 19 | 78 | 0 | |
592970 | 592970 | Raisin | Raisin | 2021-09-15 | Fresno | 19 | 0 | 380 | |
592971 | 592971 | Reedley | Reedley | 2021-09-15 | Fresno | 19 | 3755 | 31129 | |
592972 | 592972 | Riverdale | Riverdale | 2021-09-15 | Fresno | 19 | 782 | 6459 | |
592973 | 592973 | San Joaquin | San Joaquin | 2021-09-15 | Fresno | 19 | 511 | 4633 | |
592974 | 592974 | Sanger | Sanger | 2021-09-15 | Fresno | 19 | 4900 | 38252 | |
592975 | 592975 | Selma | Selma | 2021-09-15 | Fresno | 19 | 4531 | 31726 | |
592976 | 592976 | Squaw Valley | Squaw Valley | 2021-09-15 | Fresno | 19 | 114 | 3908 | |
592977 | 592977 | Tollhouse | Tollhouse | 2021-09-15 | Fresno | 19 | 106 | 2712 | |
592978 | 592978 | Tranquillity | Tranquillity | 2021-09-15 | Fresno | 19 | 120 | 1132 | |
594223 | 594223 | Auberry | Auberry | 2021-09-14 | Fresno | 19 | 142 | 3994 | |
594224 | 594224 | Biola | Biola | 2021-09-14 | Fresno | 19 | 179 | 949 | |
594225 | 594225 | Cantua Creek | Cantua Creek | 2021-09-14 | Fresno | 19 | 123 | 1125 | |
594226 | 594226 | Caruthers | Caruthers | 2021-09-14 | Fresno | 19 | 711 | 5887 | |
594227 | 594227 | Clovis | Clovis | 2021-09-14 | Fresno | 19 | 9078 | 122949 | |
594228 | 594228 | Coalinga | Coalinga | 2021-09-14 | Fresno | 19 | 4051 | 19345 | |
594229 | 594229 | Del Rey | Del Rey | 2021-09-14 | Fresno | 19 | 324 | 2759 | |
594230 | 594230 | Dinuba | Dinuba | 2021-09-14 | Fresno | 19 | 0 | 0 | |
594231 | 594231 | Dos Palos | Dos Palos | 2021-09-14 | Fresno | 19 | 0 | ||
594232 | 594232 | Dunlap | Dunlap | 2021-09-14 | Fresno | 19 | 6 | ||
594233 | 594233 | Firebaugh | Firebaugh | 2021-09-14 | Fresno | 19 | 1111 | 9965 | |
594234 | 594234 | Five Points | Five Points | 2021-09-14 | Fresno | 19 | 23 | 0 | |
594235 | 594235 | Fowler | Fowler | 2021-09-14 | Fresno | 19 | 1108 | 7917 | |
594236 | 594236 | Fresno | Fresno | 2021-09-14 | Fresno | 19 | 61638 | 608579 | |
594237 | 594237 | Friant | Friant | 2021-09-14 | Fresno | 19 | 88 | 1930 | |
594238 | 594238 | Huron | Huron | 2021-09-14 | Fresno | 19 | 919 | 7579 | |
594239 | 594239 | Kerman | Kerman | 2021-09-14 | Fresno | 19 | 2699 | 21009 | |
594240 | 594240 | Kingsburg | Kingsburg | 2021-09-14 | Fresno | 19 | 1442 | 17086 | |
594241 | 594241 | Laton | Laton | 2021-09-14 | Fresno | 19 | 344 | 3513 | |
594242 | 594242 | Mendota | Mendota | 2021-09-14 | Fresno | 19 | 1863 | 13576 | |
594243 | 594243 | Orange Cove | Orange Cove | 2021-09-14 | Fresno | 19 | 1599 | 11320 | |
594244 | 594244 | Parlier | Parlier | 2021-09-14 | Fresno | 19 | 2648 | 17097 | |
594245 | 594245 | Prather | Prather | 2021-09-14 | Fresno | 19 | 78 | 0 | |
594246 | 594246 | Raisin | Raisin | 2021-09-14 | Fresno | 19 | 0 | 380 | |
594247 | 594247 | Reedley | Reedley | 2021-09-14 | Fresno | 19 | 3755 | 31129 | |
594248 | 594248 | Riverdale | Riverdale | 2021-09-14 | Fresno | 19 | 782 | 6459 | |
594249 | 594249 | San Joaquin | San Joaquin | 2021-09-14 | Fresno | 19 | 511 | 4633 | |
594250 | 594250 | Sanger | Sanger | 2021-09-14 | Fresno | 19 | 4900 | 38252 | |
594251 | 594251 | Selma | Selma | 2021-09-14 | Fresno | 19 | 4531 | 31726 | |
594252 | 594252 | Squaw Valley | Squaw Valley | 2021-09-14 | Fresno | 19 | 114 | 3908 | |
594253 | 594253 | Tollhouse | Tollhouse | 2021-09-14 | Fresno | 19 | 106 | 2712 | |
594254 | 594254 | Tranquillity | Tranquillity | 2021-09-14 | Fresno | 19 | 120 | 1132 | |
595499 | 595499 | Auberry | Auberry | 2021-09-13 | Fresno | 19 | 142 | 3994 | |
595500 | 595500 | Biola | Biola | 2021-09-13 | Fresno | 19 | 179 | 949 | |
595501 | 595501 | Cantua Creek | Cantua Creek | 2021-09-13 | Fresno | 19 | 123 | 1125 | |
595502 | 595502 | Caruthers | Caruthers | 2021-09-13 | Fresno | 19 | 711 | 5887 | |
595503 | 595503 | Clovis | Clovis | 2021-09-13 | Fresno | 19 | 9078 | 122949 | |
595504 | 595504 | Coalinga | Coalinga | 2021-09-13 | Fresno | 19 | 4051 | 19345 | |
595505 | 595505 | Del Rey | Del Rey | 2021-09-13 | Fresno | 19 | 324 | 2759 | |
595506 | 595506 | Dinuba | Dinuba | 2021-09-13 | Fresno | 19 | 0 | 0 | |
595507 | 595507 | Dos Palos | Dos Palos | 2021-09-13 | Fresno | 19 | 0 | ||
595508 | 595508 | Dunlap | Dunlap | 2021-09-13 | Fresno | 19 | 6 | ||
595509 | 595509 | Firebaugh | Firebaugh | 2021-09-13 | Fresno | 19 | 1111 | 9965 | |
595510 | 595510 | Five Points | Five Points | 2021-09-13 | Fresno | 19 | 23 | 0 | |
595511 | 595511 | Fowler | Fowler | 2021-09-13 | Fresno | 19 | 1108 | 7917 | |
595512 | 595512 | Fresno | Fresno | 2021-09-13 | Fresno | 19 | 61638 | 608579 | |
595513 | 595513 | Friant | Friant | 2021-09-13 | Fresno | 19 | 88 | 1930 | |
595514 | 595514 | Huron | Huron | 2021-09-13 | Fresno | 19 | 919 | 7579 | |
595515 | 595515 | Kerman | Kerman | 2021-09-13 | Fresno | 19 | 2699 | 21009 | |
595516 | 595516 | Kingsburg | Kingsburg | 2021-09-13 | Fresno | 19 | 1442 | 17086 | |
595517 | 595517 | Laton | Laton | 2021-09-13 | Fresno | 19 | 344 | 3513 | |
595518 | 595518 | Mendota | Mendota | 2021-09-13 | Fresno | 19 | 1863 | 13576 | |
595519 | 595519 | Orange Cove | Orange Cove | 2021-09-13 | Fresno | 19 | 1599 | 11320 | |
595520 | 595520 | Parlier | Parlier | 2021-09-13 | Fresno | 19 | 2648 | 17097 | |
595521 | 595521 | Prather | Prather | 2021-09-13 | Fresno | 19 | 78 | 0 | |
595522 | 595522 | Raisin | Raisin | 2021-09-13 | Fresno | 19 | 0 | 380 | |
595523 | 595523 | Reedley | Reedley | 2021-09-13 | Fresno | 19 | 3755 | 31129 | |
595524 | 595524 | Riverdale | Riverdale | 2021-09-13 | Fresno | 19 | 782 | 6459 | |
595525 | 595525 | San Joaquin | San Joaquin | 2021-09-13 | Fresno | 19 | 511 | 4633 | |
595526 | 595526 | Sanger | Sanger | 2021-09-13 | Fresno | 19 | 4900 | 38252 | |
595527 | 595527 | Selma | Selma | 2021-09-13 | Fresno | 19 | 4531 | 31726 | |
595528 | 595528 | Squaw Valley | Squaw Valley | 2021-09-13 | Fresno | 19 | 114 | 3908 | |
595529 | 595529 | Tollhouse | Tollhouse | 2021-09-13 | Fresno | 19 | 106 | 2712 | |
595530 | 595530 | Tranquillity | Tranquillity | 2021-09-13 | Fresno | 19 | 120 | 1132 | |
596775 | 596775 | Auberry | Auberry | 2021-09-12 | Fresno | 19 | 142 | 3994 | |
596776 | 596776 | Biola | Biola | 2021-09-12 | Fresno | 19 | 179 | 949 | |
596777 | 596777 | Cantua Creek | Cantua Creek | 2021-09-12 | Fresno | 19 | 123 | 1125 | |
596778 | 596778 | Caruthers | Caruthers | 2021-09-12 | Fresno | 19 | 711 | 5887 |
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 );