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

8,829 rows where county = "Kings" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 1

  • 31 8,829

county 1

  • Kings · 8,829 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
149 149 Armona Armona 2022-12-30 Kings 31 1743   3795
150 150 Avenal Avenal 2022-12-30 Kings 31 7743   12923
151 151 Corcoran Corcoran 2022-12-30 Kings 31 11674   22301
152 152 Correctional facilities Prisons 2022-12-30 Kings 31 10587    
153 153 Hanford Hanford 2022-12-30 Kings 31 26001   55893
154 154 Kettleman City Kettleman City 2022-12-30 Kings 31 484   1395
155 155 Lemoore Lemoore 2022-12-30 Kings 31 12067   25791
156 156 Other Area Other 2022-12-30 Kings 31 1430    
157 157 Stratford Stratford 2022-12-30 Kings 31 550   878
977 977 Armona Armona 2022-12-29 Kings 31 1743   3795
978 978 Avenal Avenal 2022-12-29 Kings 31 7743   12923
979 979 Corcoran Corcoran 2022-12-29 Kings 31 11674   22301
980 980 Correctional facilities Prisons 2022-12-29 Kings 31 10587    
981 981 Hanford Hanford 2022-12-29 Kings 31 26001   55893
982 982 Kettleman City Kettleman City 2022-12-29 Kings 31 484   1395
983 983 Lemoore Lemoore 2022-12-29 Kings 31 12067   25791
984 984 Other Area Other 2022-12-29 Kings 31 1430    
985 985 Stratford Stratford 2022-12-29 Kings 31 550   878
1805 1805 Armona Armona 2022-12-28 Kings 31 1733   3795
1806 1806 Avenal Avenal 2022-12-28 Kings 31 7743   12923
1807 1807 Corcoran Corcoran 2022-12-28 Kings 31 11647   22301
1808 1808 Correctional facilities Prisons 2022-12-28 Kings 31 10575    
1809 1809 Hanford Hanford 2022-12-28 Kings 31 25856   55893
1810 1810 Kettleman City Kettleman City 2022-12-28 Kings 31 484   1395
1811 1811 Lemoore Lemoore 2022-12-28 Kings 31 12021   25791
1812 1812 Other Area Other 2022-12-28 Kings 31 1428    
1813 1813 Stratford Stratford 2022-12-28 Kings 31 549   878
2986 2986 Armona Armona 2022-12-27 Kings 31 1733   3795
2987 2987 Avenal Avenal 2022-12-27 Kings 31 7743   12923
2988 2988 Corcoran Corcoran 2022-12-27 Kings 31 11647   22301
2989 2989 Correctional facilities Prisons 2022-12-27 Kings 31 10575    
2990 2990 Hanford Hanford 2022-12-27 Kings 31 25856   55893
2991 2991 Kettleman City Kettleman City 2022-12-27 Kings 31 484   1395
2992 2992 Lemoore Lemoore 2022-12-27 Kings 31 12021   25791
2993 2993 Other Area Other 2022-12-27 Kings 31 1428    
2994 2994 Stratford Stratford 2022-12-27 Kings 31 549   878
4167 4167 Armona Armona 2022-12-26 Kings 31 1733   3795
4168 4168 Avenal Avenal 2022-12-26 Kings 31 7743   12923
4169 4169 Corcoran Corcoran 2022-12-26 Kings 31 11647   22301
4170 4170 Correctional facilities Prisons 2022-12-26 Kings 31 10575    
4171 4171 Hanford Hanford 2022-12-26 Kings 31 25856   55893
4172 4172 Kettleman City Kettleman City 2022-12-26 Kings 31 484   1395
4173 4173 Lemoore Lemoore 2022-12-26 Kings 31 12021   25791
4174 4174 Other Area Other 2022-12-26 Kings 31 1428    
4175 4175 Stratford Stratford 2022-12-26 Kings 31 549   878
5348 5348 Armona Armona 2022-12-25 Kings 31 1733   3795
5349 5349 Avenal Avenal 2022-12-25 Kings 31 7743   12923
5350 5350 Corcoran Corcoran 2022-12-25 Kings 31 11647   22301
5351 5351 Correctional facilities Prisons 2022-12-25 Kings 31 10575    
5352 5352 Hanford Hanford 2022-12-25 Kings 31 25856   55893
5353 5353 Kettleman City Kettleman City 2022-12-25 Kings 31 484   1395
5354 5354 Lemoore Lemoore 2022-12-25 Kings 31 12021   25791
5355 5355 Other Area Other 2022-12-25 Kings 31 1428    
5356 5356 Stratford Stratford 2022-12-25 Kings 31 549   878
6529 6529 Armona Armona 2022-12-24 Kings 31 1733   3795
6530 6530 Avenal Avenal 2022-12-24 Kings 31 7743   12923
6531 6531 Corcoran Corcoran 2022-12-24 Kings 31 11647   22301
6532 6532 Correctional facilities Prisons 2022-12-24 Kings 31 10575    
6533 6533 Hanford Hanford 2022-12-24 Kings 31 25856   55893
6534 6534 Kettleman City Kettleman City 2022-12-24 Kings 31 484   1395
6535 6535 Lemoore Lemoore 2022-12-24 Kings 31 12021   25791
6536 6536 Other Area Other 2022-12-24 Kings 31 1428    
6537 6537 Stratford Stratford 2022-12-24 Kings 31 549   878
7710 7710 Armona Armona 2022-12-23 Kings 31 1733   3795
7711 7711 Avenal Avenal 2022-12-23 Kings 31 7743   12923
7712 7712 Corcoran Corcoran 2022-12-23 Kings 31 11647   22301
7713 7713 Correctional facilities Prisons 2022-12-23 Kings 31 10575    
7714 7714 Hanford Hanford 2022-12-23 Kings 31 25856   55893
7715 7715 Kettleman City Kettleman City 2022-12-23 Kings 31 484   1395
7716 7716 Lemoore Lemoore 2022-12-23 Kings 31 12021   25791
7717 7717 Other Area Other 2022-12-23 Kings 31 1428    
7718 7718 Stratford Stratford 2022-12-23 Kings 31 549   878
8891 8891 Armona Armona 2022-12-22 Kings 31 1733   3795
8892 8892 Avenal Avenal 2022-12-22 Kings 31 7743   12923
8893 8893 Corcoran Corcoran 2022-12-22 Kings 31 11647   22301
8894 8894 Correctional facilities Prisons 2022-12-22 Kings 31 10575    
8895 8895 Hanford Hanford 2022-12-22 Kings 31 25856   55893
8896 8896 Kettleman City Kettleman City 2022-12-22 Kings 31 484   1395
8897 8897 Lemoore Lemoore 2022-12-22 Kings 31 12021   25791
8898 8898 Other Area Other 2022-12-22 Kings 31 1428    
8899 8899 Stratford Stratford 2022-12-22 Kings 31 549   878
10072 10072 Armona Armona 2022-12-21 Kings 31 1730   3795
10073 10073 Avenal Avenal 2022-12-21 Kings 31 7729   12923
10074 10074 Corcoran Corcoran 2022-12-21 Kings 31 11629   22301
10075 10075 Correctional facilities Prisons 2022-12-21 Kings 31 10563    
10076 10076 Hanford Hanford 2022-12-21 Kings 31 25720   55893
10077 10077 Kettleman City Kettleman City 2022-12-21 Kings 31 484   1395
10078 10078 Lemoore Lemoore 2022-12-21 Kings 31 11991   25791
10079 10079 Other Area Other 2022-12-21 Kings 31 1425    
10080 10080 Stratford Stratford 2022-12-21 Kings 31 546   878
11253 11253 Armona Armona 2022-12-20 Kings 31 1730   3795
11254 11254 Avenal Avenal 2022-12-20 Kings 31 7729   12923
11255 11255 Corcoran Corcoran 2022-12-20 Kings 31 11629   22301
11256 11256 Correctional facilities Prisons 2022-12-20 Kings 31 10563    
11257 11257 Hanford Hanford 2022-12-20 Kings 31 25720   55893
11258 11258 Kettleman City Kettleman City 2022-12-20 Kings 31 484   1395
11259 11259 Lemoore Lemoore 2022-12-20 Kings 31 11991   25791
11260 11260 Other Area Other 2022-12-20 Kings 31 1425    
11261 11261 Stratford Stratford 2022-12-20 Kings 31 546   878
12434 12434 Armona Armona 2022-12-19 Kings 31 1730   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 1452.052ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals