latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
535 rows where agency = "Kern" and fips = 29 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 |
---|---|---|---|---|---|---|---|---|
16 | 16 | Kern | Kern | 29 | 2021-09-02 | 126250 | 1478 | |
77 | 77 | Kern | Kern | 29 | 2021-09-01 | 125636 | 1473 | |
138 | 138 | Kern | Kern | 29 | 2021-08-31 | 124943 | 1465 | |
199 | 199 | Kern | Kern | 29 | 2021-08-30 | 124432 | 1462 | |
260 | 260 | Kern | Kern | 29 | 2021-08-29 | 122950 | 1458 | TRUE |
321 | 321 | Kern | Kern | 29 | 2021-08-28 | 122950 | 1458 | TRUE |
382 | 382 | Kern | Kern | 29 | 2021-08-27 | 122950 | 1458 | |
443 | 443 | Kern | Kern | 29 | 2021-08-26 | 122336 | 1453 | |
504 | 504 | Kern | Kern | 29 | 2021-08-25 | 121898 | 1452 | |
565 | 565 | Kern | Kern | 29 | 2021-08-24 | 121299 | 1448 | |
626 | 626 | Kern | Kern | 29 | 2021-08-23 | 120857 | 1448 | |
687 | 687 | Kern | Kern | 29 | 2021-08-22 | 119708 | 1445 | TRUE |
748 | 748 | Kern | Kern | 29 | 2021-08-21 | 119708 | 1445 | TRUE |
809 | 809 | Kern | Kern | 29 | 2021-08-20 | 119708 | 1445 | |
870 | 870 | Kern | Kern | 29 | 2021-08-19 | 119277 | 1443 | |
931 | 931 | Kern | Kern | 29 | 2021-08-18 | 118794 | 1441 | |
992 | 992 | Kern | Kern | 29 | 2021-08-17 | 118360 | 1436 | |
1053 | 1053 | Kern | Kern | 29 | 2021-08-16 | 118025 | 1436 | |
1114 | 1114 | Kern | Kern | 29 | 2021-08-15 | 117101 | 1434 | TRUE |
1175 | 1175 | Kern | Kern | 29 | 2021-08-14 | 117101 | 1434 | TRUE |
1236 | 1236 | Kern | Kern | 29 | 2021-08-13 | 117101 | 1434 | |
1297 | 1297 | Kern | Kern | 29 | 2021-08-12 | 116731 | 1434 | |
1358 | 1358 | Kern | Kern | 29 | 2021-08-11 | 116475 | 1433 | |
1419 | 1419 | Kern | Kern | 29 | 2021-08-10 | 116120 | 1429 | |
1480 | 1480 | Kern | Kern | 29 | 2021-08-09 | 115910 | 1429 | |
1541 | 1541 | Kern | Kern | 29 | 2021-08-08 | 115007 | 1429 | TRUE |
1602 | 1602 | Kern | Kern | 29 | 2021-08-07 | 115007 | 1429 | TRUE |
1663 | 1663 | Kern | Kern | 29 | 2021-08-06 | 115007 | 1429 | |
1724 | 1724 | Kern | Kern | 29 | 2021-08-05 | 114699 | 1428 | |
1785 | 1785 | Kern | Kern | 29 | 2021-08-04 | 114342 | 1428 | |
1846 | 1846 | Kern | Kern | 29 | 2021-08-03 | 114079 | 1427 | |
1907 | 1907 | Kern | Kern | 29 | 2021-08-02 | 113810 | 1426 | |
1968 | 1968 | Kern | Kern | 29 | 2021-08-01 | 113216 | 1425 | TRUE |
2029 | 2029 | Kern | Kern | 29 | 2021-07-31 | 113216 | 1425 | TRUE |
2090 | 2090 | Kern | Kern | 29 | 2021-07-30 | 113216 | 1425 | |
2151 | 2151 | Kern | Kern | 29 | 2021-07-29 | 113071 | 1425 | |
2212 | 2212 | Kern | Kern | 29 | 2021-07-28 | 112933 | 1420 | |
2273 | 2273 | Kern | Kern | 29 | 2021-07-27 | 112798 | 1420 | |
2334 | 2334 | Kern | Kern | 29 | 2021-07-26 | 112623 | 1419 | |
2395 | 2395 | Kern | Kern | 29 | 2021-07-25 | 112318 | 1417 | TRUE |
2456 | 2456 | Kern | Kern | 29 | 2021-07-24 | 112318 | 1417 | TRUE |
2517 | 2517 | Kern | Kern | 29 | 2021-07-23 | 112318 | 1417 | |
2578 | 2578 | Kern | Kern | 29 | 2021-07-22 | 112063 | 1416 | |
2639 | 2639 | Kern | Kern | 29 | 2021-07-21 | 112063 | 1416 | |
2700 | 2700 | Kern | Kern | 29 | 2021-07-20 | 111894 | 1416 | TRUE |
2761 | 2761 | Kern | Kern | 29 | 2021-07-19 | 111894 | 1416 | |
2822 | 2822 | Kern | Kern | 29 | 2021-07-18 | 111687 | 1414 | TRUE |
2883 | 2883 | Kern | Kern | 29 | 2021-07-17 | 111687 | 1414 | TRUE |
2944 | 2944 | Kern | Kern | 29 | 2021-07-16 | 111687 | 1414 | |
3005 | 3005 | Kern | Kern | 29 | 2021-07-15 | 111571 | 1413 | TRUE |
3066 | 3066 | Kern | Kern | 29 | 2021-07-14 | 111571 | 1413 | |
3127 | 3127 | Kern | Kern | 29 | 2021-07-13 | 111437 | 1412 | TRUE |
3188 | 3188 | Kern | Kern | 29 | 2021-07-12 | 111437 | 1412 | |
3249 | 3249 | Kern | Kern | 29 | 2021-07-11 | 111341 | 1409 | TRUE |
3310 | 3310 | Kern | Kern | 29 | 2021-07-10 | 111341 | 1409 | TRUE |
3371 | 3371 | Kern | Kern | 29 | 2021-07-09 | 111341 | 1409 | |
3432 | 3432 | Kern | Kern | 29 | 2021-07-08 | 111273 | 1409 | TRUE |
3493 | 3493 | Kern | Kern | 29 | 2021-07-07 | 111273 | 1409 | |
3554 | 3554 | Kern | Kern | 29 | 2021-07-06 | 111111 | 1408 | TRUE |
3615 | 3615 | Kern | Kern | 29 | 2021-07-05 | 111111 | 1408 | TRUE |
3676 | 3676 | Kern | Kern | 29 | 2021-07-04 | 111111 | 1408 | TRUE |
3737 | 3737 | Kern | Kern | 29 | 2021-07-03 | 111111 | 1408 | |
3798 | 3798 | Kern | Kern | 29 | 2021-07-02 | 111111 | 1408 | |
3859 | 3859 | Kern | Kern | 29 | 2021-07-01 | 111060 | 1407 | TRUE |
3920 | 3920 | Kern | Kern | 29 | 2021-06-30 | 111060 | 1407 | |
3981 | 3981 | Kern | Kern | 29 | 2021-06-29 | 111049 | 1406 | TRUE |
4042 | 4042 | Kern | Kern | 29 | 2021-06-28 | 111049 | 1406 | |
4103 | 4103 | Kern | Kern | 29 | 2021-06-27 | 110948 | 1405 | TRUE |
4164 | 4164 | Kern | Kern | 29 | 2021-06-26 | 110948 | 1405 | TRUE |
4225 | 4225 | Kern | Kern | 29 | 2021-06-25 | 110948 | 1405 | |
4286 | 4286 | Kern | Kern | 29 | 2021-06-24 | 110847 | 1405 | TRUE |
4347 | 4347 | Kern | Kern | 29 | 2021-06-23 | 110847 | 1405 | |
4408 | 4408 | Kern | Kern | 29 | 2021-06-22 | 110799 | 1404 | TRUE |
4469 | 4469 | Kern | Kern | 29 | 2021-06-21 | 110799 | 1404 | |
4530 | 4530 | Kern | Kern | 29 | 2021-06-20 | 110782 | 1404 | |
4591 | 4591 | Kern | Kern | 29 | 2021-06-19 | 110762 | 1404 | |
4652 | 4652 | Kern | Kern | 29 | 2021-06-18 | 110734 | 1402 | |
4713 | 4713 | Kern | Kern | 29 | 2021-06-17 | 110710 | 1401 | |
4774 | 4774 | Kern | Kern | 29 | 2021-06-16 | 110687 | 1401 | |
4835 | 4835 | Kern | Kern | 29 | 2021-06-15 | 110673 | 1401 | |
4896 | 4896 | Kern | Kern | 29 | 2021-06-14 | 110617 | 1400 | |
4957 | 4957 | Kern | Kern | 29 | 2021-06-13 | 110604 | 1400 | |
5018 | 5018 | Kern | Kern | 29 | 2021-06-12 | 110593 | 1400 | |
5079 | 5079 | Kern | Kern | 29 | 2021-06-11 | 110559 | 1400 | |
5140 | 5140 | Kern | Kern | 29 | 2021-06-10 | 110546 | 1400 | |
5201 | 5201 | Kern | Kern | 29 | 2021-06-09 | 110522 | 1400 | |
5262 | 5262 | Kern | Kern | 29 | 2021-06-08 | 110458 | 1399 | |
5323 | 5323 | Kern | Kern | 29 | 2021-06-07 | 110395 | 1398 | |
5384 | 5384 | Kern | Kern | 29 | 2021-06-06 | 110372 | 1398 | |
5445 | 5445 | Kern | Kern | 29 | 2021-06-05 | 110350 | 1398 | |
5506 | 5506 | Kern | Kern | 29 | 2021-06-04 | 110302 | 1396 | |
5567 | 5567 | Kern | Kern | 29 | 2021-06-03 | 110252 | 1394 | |
5628 | 5628 | Kern | Kern | 29 | 2021-06-02 | 110188 | 1394 | |
5689 | 5689 | Kern | Kern | 29 | 2021-06-01 | 110147 | 1389 | |
5750 | 5750 | Kern | Kern | 29 | 2021-05-31 | 110131 | 1389 | |
5811 | 5811 | Kern | Kern | 29 | 2021-05-30 | 110111 | 1389 | |
5872 | 5872 | Kern | Kern | 29 | 2021-05-29 | 110089 | 1389 | |
5933 | 5933 | Kern | Kern | 29 | 2021-05-28 | 109999 | 1388 | |
5994 | 5994 | Kern | Kern | 29 | 2021-05-27 | 109904 | 1386 | |
6055 | 6055 | Kern | Kern | 29 | 2021-05-26 | 109830 | 1385 |
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 );