home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for latimes_place_totals
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

7,632 rows where fips = 31 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 31 · 7,632 ✖

county 1

  • Kings 7,632
Link rowid id name date ▲ county fips confirmed_cases note population
199 199 Armona Armona 2022-08-19 Kings 31 1654   3795
200 200 Avenal Avenal 2022-08-19 Kings 31 7364   12923
201 201 Corcoran Corcoran 2022-08-19 Kings 31 11077   22301
202 202 Correctional facilities Prisons 2022-08-19 Kings 31 10040    
203 203 Hanford Hanford 2022-08-19 Kings 31 23983   55893
204 204 Kettleman City Kettleman City 2022-08-19 Kings 31 452   1395
205 205 Lemoore Lemoore 2022-08-19 Kings 31 11223   25791
206 206 Other Area Other 2022-08-19 Kings 31 487    
207 207 Stratford Stratford 2022-08-19 Kings 31 504   878
1422 1422 Armona Armona 2022-08-18 Kings 31 1654   3795
1423 1423 Avenal Avenal 2022-08-18 Kings 31 7364   12923
1424 1424 Corcoran Corcoran 2022-08-18 Kings 31 11077   22301
1425 1425 Correctional facilities Prisons 2022-08-18 Kings 31 10040    
1426 1426 Hanford Hanford 2022-08-18 Kings 31 23983   55893
1427 1427 Kettleman City Kettleman City 2022-08-18 Kings 31 452   1395
1428 1428 Lemoore Lemoore 2022-08-18 Kings 31 11223   25791
1429 1429 Other Area Other 2022-08-18 Kings 31 487    
1430 1430 Stratford Stratford 2022-08-18 Kings 31 504   878
2660 2660 Armona Armona 2022-08-17 Kings 31 1654   3795
2661 2661 Avenal Avenal 2022-08-17 Kings 31 7364   12923
2662 2662 Corcoran Corcoran 2022-08-17 Kings 31 11077   22301
2663 2663 Correctional facilities Prisons 2022-08-17 Kings 31 10040    
2664 2664 Hanford Hanford 2022-08-17 Kings 31 23983   55893
2665 2665 Kettleman City Kettleman City 2022-08-17 Kings 31 452   1395
2666 2666 Lemoore Lemoore 2022-08-17 Kings 31 11223   25791
2667 2667 Other Area Other 2022-08-17 Kings 31 487    
2668 2668 Stratford Stratford 2022-08-17 Kings 31 504   878
3898 3898 Armona Armona 2022-08-16 Kings 31 1654   3795
3899 3899 Avenal Avenal 2022-08-16 Kings 31 7364   12923
3900 3900 Corcoran Corcoran 2022-08-16 Kings 31 11077   22301
3901 3901 Correctional facilities Prisons 2022-08-16 Kings 31 10040    
3902 3902 Hanford Hanford 2022-08-16 Kings 31 23983   55893
3903 3903 Kettleman City Kettleman City 2022-08-16 Kings 31 452   1395
3904 3904 Lemoore Lemoore 2022-08-16 Kings 31 11223   25791
3905 3905 Other Area Other 2022-08-16 Kings 31 487    
3906 3906 Stratford Stratford 2022-08-16 Kings 31 504   878
5136 5136 Armona Armona 2022-08-15 Kings 31 1654   3795
5137 5137 Avenal Avenal 2022-08-15 Kings 31 7364   12923
5138 5138 Corcoran Corcoran 2022-08-15 Kings 31 11077   22301
5139 5139 Correctional facilities Prisons 2022-08-15 Kings 31 10040    
5140 5140 Hanford Hanford 2022-08-15 Kings 31 23983   55893
5141 5141 Kettleman City Kettleman City 2022-08-15 Kings 31 452   1395
5142 5142 Lemoore Lemoore 2022-08-15 Kings 31 11223   25791
5143 5143 Other Area Other 2022-08-15 Kings 31 487    
5144 5144 Stratford Stratford 2022-08-15 Kings 31 504   878
6406 6406 Armona Armona 2022-08-14 Kings 31 1654   3795
6407 6407 Avenal Avenal 2022-08-14 Kings 31 7364   12923
6408 6408 Corcoran Corcoran 2022-08-14 Kings 31 11077   22301
6409 6409 Correctional facilities Prisons 2022-08-14 Kings 31 10040    
6410 6410 Hanford Hanford 2022-08-14 Kings 31 23983   55893
6411 6411 Kettleman City Kettleman City 2022-08-14 Kings 31 452   1395
6412 6412 Lemoore Lemoore 2022-08-14 Kings 31 11223   25791
6413 6413 Other Area Other 2022-08-14 Kings 31 487    
6414 6414 Stratford Stratford 2022-08-14 Kings 31 504   878
7676 7676 Armona Armona 2022-08-13 Kings 31 1654   3795
7677 7677 Avenal Avenal 2022-08-13 Kings 31 7364   12923
7678 7678 Corcoran Corcoran 2022-08-13 Kings 31 11077   22301
7679 7679 Correctional facilities Prisons 2022-08-13 Kings 31 10040    
7680 7680 Hanford Hanford 2022-08-13 Kings 31 23983   55893
7681 7681 Kettleman City Kettleman City 2022-08-13 Kings 31 452   1395
7682 7682 Lemoore Lemoore 2022-08-13 Kings 31 11223   25791
7683 7683 Other Area Other 2022-08-13 Kings 31 487    
7684 7684 Stratford Stratford 2022-08-13 Kings 31 504   878
8946 8946 Armona Armona 2022-08-12 Kings 31 1654   3795
8947 8947 Avenal Avenal 2022-08-12 Kings 31 7364   12923
8948 8948 Corcoran Corcoran 2022-08-12 Kings 31 11077   22301
8949 8949 Correctional facilities Prisons 2022-08-12 Kings 31 10040    
8950 8950 Hanford Hanford 2022-08-12 Kings 31 23983   55893
8951 8951 Kettleman City Kettleman City 2022-08-12 Kings 31 452   1395
8952 8952 Lemoore Lemoore 2022-08-12 Kings 31 11223   25791
8953 8953 Other Area Other 2022-08-12 Kings 31 487    
8954 8954 Stratford Stratford 2022-08-12 Kings 31 504   878
10216 10216 Armona Armona 2022-08-11 Kings 31 1654   3795
10217 10217 Avenal Avenal 2022-08-11 Kings 31 7364   12923
10218 10218 Corcoran Corcoran 2022-08-11 Kings 31 11077   22301
10219 10219 Correctional facilities Prisons 2022-08-11 Kings 31 10040    
10220 10220 Hanford Hanford 2022-08-11 Kings 31 23983   55893
10221 10221 Kettleman City Kettleman City 2022-08-11 Kings 31 452   1395
10222 10222 Lemoore Lemoore 2022-08-11 Kings 31 11223   25791
10223 10223 Other Area Other 2022-08-11 Kings 31 487    
10224 10224 Stratford Stratford 2022-08-11 Kings 31 504   878
11486 11486 Armona Armona 2022-08-10 Kings 31 1654   3795
11487 11487 Avenal Avenal 2022-08-10 Kings 31 7364   12923
11488 11488 Corcoran Corcoran 2022-08-10 Kings 31 11077   22301
11489 11489 Correctional facilities Prisons 2022-08-10 Kings 31 10040    
11490 11490 Hanford Hanford 2022-08-10 Kings 31 23983   55893
11491 11491 Kettleman City Kettleman City 2022-08-10 Kings 31 452   1395
11492 11492 Lemoore Lemoore 2022-08-10 Kings 31 11223   25791
11493 11493 Other Area Other 2022-08-10 Kings 31 487    
11494 11494 Stratford Stratford 2022-08-10 Kings 31 504   878
12756 12756 Armona Armona 2022-08-09 Kings 31 1654   3795
12757 12757 Avenal Avenal 2022-08-09 Kings 31 7364   12923
12758 12758 Corcoran Corcoran 2022-08-09 Kings 31 11077   22301
12759 12759 Correctional facilities Prisons 2022-08-09 Kings 31 10040    
12760 12760 Hanford Hanford 2022-08-09 Kings 31 23983   55893
12761 12761 Kettleman City Kettleman City 2022-08-09 Kings 31 452   1395
12762 12762 Lemoore Lemoore 2022-08-09 Kings 31 11223   25791
12763 12763 Other Area Other 2022-08-09 Kings 31 487    
12764 12764 Stratford Stratford 2022-08-09 Kings 31 504   878
14026 14026 Armona Armona 2022-08-08 Kings 31 1632   3795

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);
Powered by Datasette · Queries took 1165.886ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals