latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
564 rows where county = "Sacramento" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths ▼ | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
30861 | 30861 | 2020-03-09 | Sacramento | 67 | 10 | 0 | 7 | 0 |
30886 | 30886 | 2020-03-08 | Sacramento | 67 | 3 | 0 | 0 | 0 |
30911 | 30911 | 2020-03-07 | Sacramento | 67 | 3 | 0 | 0 | 0 |
30935 | 30935 | 2020-03-06 | Sacramento | 67 | 3 | 0 | 0 | 0 |
30959 | 30959 | 2020-03-05 | Sacramento | 67 | 3 | 0 | 2 | 0 |
30983 | 30983 | 2020-03-04 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31007 | 31007 | 2020-03-03 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31031 | 31031 | 2020-03-02 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31055 | 31055 | 2020-03-01 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31079 | 31079 | 2020-02-29 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31102 | 31102 | 2020-02-28 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31119 | 31119 | 2020-02-27 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31133 | 31133 | 2020-02-26 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31149 | 31149 | 2020-02-25 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31155 | 31155 | 2020-02-24 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31161 | 31161 | 2020-02-23 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31167 | 31167 | 2020-02-22 | Sacramento | 67 | 1 | 0 | 0 | 0 |
31179 | 31179 | 2020-02-21 | Sacramento | 67 | 1 | 0 | 1 | 0 |
31201 | 31201 | 2020-02-20 | Sacramento | 67 | 0 | 0 | 0 | 0 |
31291 | 31291 | 2020-02-02 | Sacramento | 67 | 0 | 0 | 0 | 0 |
31316 | 31316 | 2020-01-31 | Sacramento | 67 | 0 | 0 | 0 | 0 |
31350 | 31350 | 2020-01-26 | Sacramento | 67 | 0 | 0 | ||
30696 | 30696 | 2020-03-15 | Sacramento | 67 | 32 | 1 | 3 | 0 |
30727 | 30727 | 2020-03-14 | Sacramento | 67 | 29 | 1 | 12 | 0 |
30756 | 30756 | 2020-03-13 | Sacramento | 67 | 17 | 1 | 0 | 0 |
30783 | 30783 | 2020-03-12 | Sacramento | 67 | 17 | 1 | 7 | 0 |
30810 | 30810 | 2020-03-11 | Sacramento | 67 | 10 | 1 | 0 | 0 |
30836 | 30836 | 2020-03-10 | Sacramento | 67 | 10 | 1 | 0 | 1 |
30599 | 30599 | 2020-03-18 | Sacramento | 67 | 40 | 2 | 0 | 0 |
30633 | 30633 | 2020-03-17 | Sacramento | 67 | 40 | 2 | 7 | 0 |
30665 | 30665 | 2020-03-16 | Sacramento | 67 | 33 | 2 | 1 | 1 |
30451 | 30451 | 2020-03-22 | Sacramento | 67 | 53 | 3 | 0 | 0 |
30491 | 30491 | 2020-03-21 | Sacramento | 67 | 53 | 3 | 0 | 0 |
30529 | 30529 | 2020-03-20 | Sacramento | 67 | 53 | 3 | 8 | 0 |
30564 | 30564 | 2020-03-19 | Sacramento | 67 | 45 | 3 | 5 | 1 |
30367 | 30367 | 2020-03-24 | Sacramento | 67 | 88 | 4 | 0 | 0 |
30409 | 30409 | 2020-03-23 | Sacramento | 67 | 88 | 4 | 35 | 1 |
30280 | 30280 | 2020-03-26 | Sacramento | 67 | 113 | 5 | 0 | 0 |
30324 | 30324 | 2020-03-25 | Sacramento | 67 | 113 | 5 | 25 | 1 |
30142 | 30142 | 2020-03-29 | Sacramento | 67 | 164 | 6 | 0 | 0 |
30189 | 30189 | 2020-03-28 | Sacramento | 67 | 164 | 6 | 0 | 0 |
30236 | 30236 | 2020-03-27 | Sacramento | 67 | 164 | 6 | 51 | 1 |
30045 | 30045 | 2020-03-31 | Sacramento | 67 | 224 | 7 | 0 | 0 |
30094 | 30094 | 2020-03-30 | Sacramento | 67 | 224 | 7 | 60 | 1 |
29943 | 29943 | 2020-04-02 | Sacramento | 67 | 341 | 9 | 27 | 0 |
29994 | 29994 | 2020-04-01 | Sacramento | 67 | 314 | 9 | 90 | 2 |
29839 | 29839 | 2020-04-04 | Sacramento | 67 | 390 | 10 | 0 | 0 |
29891 | 29891 | 2020-04-03 | Sacramento | 67 | 390 | 10 | 49 | 1 |
29787 | 29787 | 2020-04-05 | Sacramento | 67 | 442 | 16 | 52 | 6 |
29734 | 29734 | 2020-04-06 | Sacramento | 67 | 462 | 18 | 20 | 2 |
29681 | 29681 | 2020-04-07 | Sacramento | 67 | 525 | 21 | 63 | 3 |
29575 | 29575 | 2020-04-09 | Sacramento | 67 | 613 | 22 | 33 | 0 |
29628 | 29628 | 2020-04-08 | Sacramento | 67 | 580 | 22 | 55 | 1 |
29522 | 29522 | 2020-04-10 | Sacramento | 67 | 653 | 24 | 40 | 2 |
29416 | 29416 | 2020-04-12 | Sacramento | 67 | 707 | 26 | 8 | 0 |
29469 | 29469 | 2020-04-11 | Sacramento | 67 | 699 | 26 | 46 | 2 |
29363 | 29363 | 2020-04-13 | Sacramento | 67 | 739 | 27 | 32 | 1 |
29310 | 29310 | 2020-04-14 | Sacramento | 67 | 816 | 28 | 77 | 1 |
29151 | 29151 | 2020-04-17 | Sacramento | 67 | 896 | 32 | 17 | 0 |
29204 | 29204 | 2020-04-16 | Sacramento | 67 | 879 | 32 | 26 | 0 |
29257 | 29257 | 2020-04-15 | Sacramento | 67 | 853 | 32 | 37 | 4 |
29098 | 29098 | 2020-04-18 | Sacramento | 67 | 914 | 33 | 18 | 1 |
28992 | 28992 | 2020-04-20 | Sacramento | 67 | 940 | 34 | 15 | 0 |
29045 | 29045 | 2020-04-19 | Sacramento | 67 | 925 | 34 | 11 | 1 |
28939 | 28939 | 2020-04-21 | Sacramento | 67 | 954 | 35 | 14 | 1 |
28886 | 28886 | 2020-04-22 | Sacramento | 67 | 971 | 36 | 17 | 1 |
28568 | 28568 | 2020-04-28 | Sacramento | 67 | 1053 | 41 | 8 | 0 |
28621 | 28621 | 2020-04-27 | Sacramento | 67 | 1045 | 41 | 8 | 0 |
28674 | 28674 | 2020-04-26 | Sacramento | 67 | 1037 | 41 | 12 | 0 |
28727 | 28727 | 2020-04-25 | Sacramento | 67 | 1025 | 41 | 6 | 0 |
28780 | 28780 | 2020-04-24 | Sacramento | 67 | 1019 | 41 | 32 | 0 |
28833 | 28833 | 2020-04-23 | Sacramento | 67 | 987 | 41 | 16 | 5 |
28280 | 28280 | 2020-05-03 | Sacramento | 67 | 1117 | 42 | 10 | 0 |
28338 | 28338 | 2020-05-02 | Sacramento | 67 | 1107 | 42 | 17 | 0 |
28396 | 28396 | 2020-05-01 | Sacramento | 67 | 1090 | 42 | 13 | 0 |
28454 | 28454 | 2020-04-30 | Sacramento | 67 | 1077 | 42 | 9 | 0 |
28512 | 28512 | 2020-04-29 | Sacramento | 67 | 1068 | 42 | 15 | 1 |
28106 | 28106 | 2020-05-06 | Sacramento | 67 | 1142 | 47 | 9 | 0 |
28164 | 28164 | 2020-05-05 | Sacramento | 67 | 1133 | 47 | 6 | 0 |
28222 | 28222 | 2020-05-04 | Sacramento | 67 | 1127 | 47 | 10 | 5 |
28048 | 28048 | 2020-05-07 | Sacramento | 67 | 1153 | 49 | 11 | 2 |
27758 | 27758 | 2020-05-12 | Sacramento | 67 | 1181 | 50 | 8 | 0 |
27816 | 27816 | 2020-05-11 | Sacramento | 67 | 1173 | 50 | 6 | 0 |
27874 | 27874 | 2020-05-10 | Sacramento | 67 | 1167 | 50 | 2 | 0 |
27932 | 27932 | 2020-05-09 | Sacramento | 67 | 1165 | 50 | 5 | 0 |
27990 | 27990 | 2020-05-08 | Sacramento | 67 | 1160 | 50 | 7 | 1 |
27700 | 27700 | 2020-05-13 | Sacramento | 67 | 1183 | 51 | 2 | 1 |
27526 | 27526 | 2020-05-16 | Sacramento | 67 | 1222 | 54 | 11 | 0 |
27584 | 27584 | 2020-05-15 | Sacramento | 67 | 1211 | 54 | 17 | 0 |
27642 | 27642 | 2020-05-14 | Sacramento | 67 | 1194 | 54 | 11 | 3 |
27468 | 27468 | 2020-05-17 | Sacramento | 67 | 1237 | 55 | 15 | 1 |
26656 | 26656 | 2020-05-31 | Sacramento | 67 | 1400 | 56 | 0 | 0 |
26714 | 26714 | 2020-05-30 | Sacramento | 67 | 1400 | 56 | 27 | 0 |
26772 | 26772 | 2020-05-29 | Sacramento | 67 | 1373 | 56 | 24 | 0 |
26830 | 26830 | 2020-05-28 | Sacramento | 67 | 1349 | 56 | 30 | 0 |
26888 | 26888 | 2020-05-27 | Sacramento | 67 | 1319 | 56 | 9 | 0 |
26946 | 26946 | 2020-05-26 | Sacramento | 67 | 1310 | 56 | 8 | 0 |
27004 | 27004 | 2020-05-25 | Sacramento | 67 | 1302 | 56 | 9 | 0 |
27062 | 27062 | 2020-05-24 | Sacramento | 67 | 1293 | 56 | 4 | 0 |
27120 | 27120 | 2020-05-23 | Sacramento | 67 | 1289 | 56 | 17 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );