latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
525 rows where agency = "Kings" and fips = 31 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
17 | 17 | Kings | Kings | 31 | 2021-09-02 | 26715 | 266 | |
78 | 78 | Kings | Kings | 31 | 2021-09-01 | 26521 | 266 | |
139 | 139 | Kings | Kings | 31 | 2021-08-31 | 26483 | 265 | |
200 | 200 | Kings | Kings | 31 | 2021-08-30 | 26314 | 264 | |
261 | 261 | Kings | Kings | 31 | 2021-08-29 | 26195 | 264 | |
322 | 322 | Kings | Kings | 31 | 2021-08-28 | 26031 | 262 | TRUE |
383 | 383 | Kings | Kings | 31 | 2021-08-27 | 26031 | 262 | |
444 | 444 | Kings | Kings | 31 | 2021-08-26 | 25914 | 262 | |
505 | 505 | Kings | Kings | 31 | 2021-08-25 | 25753 | 259 | |
566 | 566 | Kings | Kings | 31 | 2021-08-24 | 25705 | 259 | |
627 | 627 | Kings | Kings | 31 | 2021-08-23 | 25541 | 258 | |
688 | 688 | Kings | Kings | 31 | 2021-08-22 | 25466 | 258 | |
749 | 749 | Kings | Kings | 31 | 2021-08-21 | 25388 | 258 | |
810 | 810 | Kings | Kings | 31 | 2021-08-20 | 25314 | 258 | |
871 | 871 | Kings | Kings | 31 | 2021-08-19 | 25198 | 258 | |
932 | 932 | Kings | Kings | 31 | 2021-08-18 | 25056 | 258 | |
993 | 993 | Kings | Kings | 31 | 2021-08-17 | 25003 | 256 | |
1054 | 1054 | Kings | Kings | 31 | 2021-08-16 | 24884 | 256 | |
1115 | 1115 | Kings | Kings | 31 | 2021-08-15 | 24803 | 256 | |
1176 | 1176 | Kings | Kings | 31 | 2021-08-14 | 24716 | 256 | |
1237 | 1237 | Kings | Kings | 31 | 2021-08-13 | 24598 | 255 | |
1298 | 1298 | Kings | Kings | 31 | 2021-08-12 | 24490 | 254 | |
1359 | 1359 | Kings | Kings | 31 | 2021-08-11 | 24370 | 253 | |
1420 | 1420 | Kings | Kings | 31 | 2021-08-10 | 24318 | 253 | |
1481 | 1481 | Kings | Kings | 31 | 2021-08-09 | 24222 | 252 | |
1542 | 1542 | Kings | Kings | 31 | 2021-08-08 | 24161 | 252 | |
1603 | 1603 | Kings | Kings | 31 | 2021-08-07 | 24114 | 252 | |
1664 | 1664 | Kings | Kings | 31 | 2021-08-06 | 24039 | 252 | |
1725 | 1725 | Kings | Kings | 31 | 2021-08-05 | 23972 | 252 | |
1786 | 1786 | Kings | Kings | 31 | 2021-08-04 | 23906 | 252 | |
1847 | 1847 | Kings | Kings | 31 | 2021-08-03 | 23790 | 251 | |
1908 | 1908 | Kings | Kings | 31 | 2021-08-02 | 23788 | 251 | |
1969 | 1969 | Kings | Kings | 31 | 2021-08-01 | 23765 | 251 | |
2030 | 2030 | Kings | Kings | 31 | 2021-07-31 | 23720 | 251 | |
2091 | 2091 | Kings | Kings | 31 | 2021-07-30 | 23668 | 251 | |
2152 | 2152 | Kings | Kings | 31 | 2021-07-29 | 23611 | 250 | |
2213 | 2213 | Kings | Kings | 31 | 2021-07-28 | 23566 | 250 | |
2274 | 2274 | Kings | Kings | 31 | 2021-07-27 | 23525 | 250 | |
2335 | 2335 | Kings | Kings | 31 | 2021-07-26 | 23489 | 249 | |
2396 | 2396 | Kings | Kings | 31 | 2021-07-25 | 23458 | 248 | |
2457 | 2457 | Kings | Kings | 31 | 2021-07-24 | 23434 | 248 | |
2518 | 2518 | Kings | Kings | 31 | 2021-07-23 | 23399 | 248 | |
2579 | 2579 | Kings | Kings | 31 | 2021-07-22 | 23366 | 248 | |
2640 | 2640 | Kings | Kings | 31 | 2021-07-21 | 23285 | 248 | TRUE |
2701 | 2701 | Kings | Kings | 31 | 2021-07-20 | 23285 | 248 | TRUE |
2762 | 2762 | Kings | Kings | 31 | 2021-07-19 | 23285 | 248 | |
2823 | 2823 | Kings | Kings | 31 | 2021-07-18 | 23267 | 248 | |
2884 | 2884 | Kings | Kings | 31 | 2021-07-17 | 23255 | 248 | |
2945 | 2945 | Kings | Kings | 31 | 2021-07-16 | 23240 | 248 | |
3006 | 3006 | Kings | Kings | 31 | 2021-07-15 | 23224 | 248 | |
3067 | 3067 | Kings | Kings | 31 | 2021-07-14 | 23146 | 248 | TRUE |
3128 | 3128 | Kings | Kings | 31 | 2021-07-13 | 23146 | 248 | TRUE |
3189 | 3189 | Kings | Kings | 31 | 2021-07-12 | 23146 | 248 | TRUE |
3250 | 3250 | Kings | Kings | 31 | 2021-07-11 | 23146 | 248 | TRUE |
3311 | 3311 | Kings | Kings | 31 | 2021-07-10 | 23146 | 248 | TRUE |
3372 | 3372 | Kings | Kings | 31 | 2021-07-09 | 23146 | 248 | |
3433 | 3433 | Kings | Kings | 31 | 2021-07-08 | 23146 | 248 | |
3494 | 3494 | Kings | Kings | 31 | 2021-07-07 | 23134 | 247 | TRUE |
3555 | 3555 | Kings | Kings | 31 | 2021-07-06 | 23134 | 247 | |
3616 | 3616 | Kings | Kings | 31 | 2021-07-05 | 23121 | 247 | |
3677 | 3677 | Kings | Kings | 31 | 2021-07-04 | 23119 | 247 | |
3738 | 3738 | Kings | Kings | 31 | 2021-07-03 | 23117 | 247 | |
3799 | 3799 | Kings | Kings | 31 | 2021-07-02 | 23115 | 247 | |
3860 | 3860 | Kings | Kings | 31 | 2021-07-01 | 23107 | 247 | |
3921 | 3921 | Kings | Kings | 31 | 2021-06-30 | 23096 | 247 | |
3982 | 3982 | Kings | Kings | 31 | 2021-06-29 | 23093 | 247 | |
4043 | 4043 | Kings | Kings | 31 | 2021-06-28 | 23093 | 247 | |
4104 | 4104 | Kings | Kings | 31 | 2021-06-27 | 23093 | 247 | |
4165 | 4165 | Kings | Kings | 31 | 2021-06-26 | 23093 | 247 | |
4226 | 4226 | Kings | Kings | 31 | 2021-06-25 | 23093 | 247 | |
4287 | 4287 | Kings | Kings | 31 | 2021-06-24 | 23093 | 247 | |
4348 | 4348 | Kings | Kings | 31 | 2021-06-23 | 23093 | 247 | |
4409 | 4409 | Kings | Kings | 31 | 2021-06-22 | 23093 | 247 | |
4470 | 4470 | Kings | Kings | 31 | 2021-06-21 | 23093 | 247 | |
4531 | 4531 | Kings | Kings | 31 | 2021-06-20 | 23093 | 247 | |
4592 | 4592 | Kings | Kings | 31 | 2021-06-19 | 23093 | 247 | |
4653 | 4653 | Kings | Kings | 31 | 2021-06-18 | 23093 | 247 | |
4714 | 4714 | Kings | Kings | 31 | 2021-06-17 | 23093 | 247 | |
4775 | 4775 | Kings | Kings | 31 | 2021-06-16 | 23093 | 247 | |
4836 | 4836 | Kings | Kings | 31 | 2021-06-15 | 23093 | 247 | |
4897 | 4897 | Kings | Kings | 31 | 2021-06-14 | 23093 | 247 | |
4958 | 4958 | Kings | Kings | 31 | 2021-06-13 | 23093 | 247 | |
5019 | 5019 | Kings | Kings | 31 | 2021-06-12 | 23093 | 247 | |
5080 | 5080 | Kings | Kings | 31 | 2021-06-11 | 23093 | 247 | |
5141 | 5141 | Kings | Kings | 31 | 2021-06-10 | 23093 | 247 | |
5202 | 5202 | Kings | Kings | 31 | 2021-06-09 | 23093 | 247 | |
5263 | 5263 | Kings | Kings | 31 | 2021-06-08 | 23093 | 247 | |
5324 | 5324 | Kings | Kings | 31 | 2021-06-07 | 23093 | 247 | |
5385 | 5385 | Kings | Kings | 31 | 2021-06-06 | 23093 | 247 | |
5446 | 5446 | Kings | Kings | 31 | 2021-06-05 | 23093 | 247 | |
5507 | 5507 | Kings | Kings | 31 | 2021-06-04 | 23093 | 247 | |
5568 | 5568 | Kings | Kings | 31 | 2021-06-03 | 23081 | 247 | |
5629 | 5629 | Kings | Kings | 31 | 2021-06-02 | 23076 | 247 | TRUE |
5690 | 5690 | Kings | Kings | 31 | 2021-06-01 | 23076 | 247 | |
5751 | 5751 | Kings | Kings | 31 | 2021-05-31 | 23076 | 247 | |
5812 | 5812 | Kings | Kings | 31 | 2021-05-30 | 23072 | 247 | |
5873 | 5873 | Kings | Kings | 31 | 2021-05-29 | 23067 | 247 | |
5934 | 5934 | Kings | Kings | 31 | 2021-05-28 | 23059 | 247 | |
5995 | 5995 | Kings | Kings | 31 | 2021-05-27 | 23050 | 247 | |
6056 | 6056 | Kings | Kings | 31 | 2021-05-26 | 23047 | 247 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );