latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
564 rows where agency = "Sacramento" sorted by confirmed_cases
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 |
---|---|---|---|---|---|---|---|---|
32854 | 32854 | Sacramento | Sacramento | 67 | 2020-02-20 | 0 | 0 | |
32946 | 32946 | Sacramento | Sacramento | 67 | 2020-02-02 | 0 | 0 | |
32973 | 32973 | Sacramento | Sacramento | 67 | 2020-01-31 | 0 | 0 | |
33009 | 33009 | Sacramento | Sacramento | 67 | 2020-01-26 | 0 | 0 | |
32620 | 32620 | Sacramento | Sacramento | 67 | 2020-03-04 | 1 | 0 | |
32646 | 32646 | Sacramento | Sacramento | 67 | 2020-03-03 | 1 | 0 | |
32672 | 32672 | Sacramento | Sacramento | 67 | 2020-03-02 | 1 | 0 | |
32698 | 32698 | Sacramento | Sacramento | 67 | 2020-03-01 | 1 | 0 | |
32724 | 32724 | Sacramento | Sacramento | 67 | 2020-02-29 | 1 | 0 | |
32749 | 32749 | Sacramento | Sacramento | 67 | 2020-02-28 | 1 | 0 | |
32766 | 32766 | Sacramento | Sacramento | 67 | 2020-02-27 | 1 | 0 | |
32782 | 32782 | Sacramento | Sacramento | 67 | 2020-02-26 | 1 | 0 | |
32798 | 32798 | Sacramento | Sacramento | 67 | 2020-02-25 | 1 | 0 | |
32804 | 32804 | Sacramento | Sacramento | 67 | 2020-02-24 | 1 | 0 | |
32810 | 32810 | Sacramento | Sacramento | 67 | 2020-02-23 | 1 | 0 | |
32816 | 32816 | Sacramento | Sacramento | 67 | 2020-02-22 | 1 | 0 | |
32830 | 32830 | Sacramento | Sacramento | 67 | 2020-02-21 | 1 | 0 | |
32515 | 32515 | Sacramento | Sacramento | 67 | 2020-03-08 | 3 | 0 | |
32542 | 32542 | Sacramento | Sacramento | 67 | 2020-03-07 | 3 | 0 | |
32568 | 32568 | Sacramento | Sacramento | 67 | 2020-03-06 | 3 | 0 | |
32594 | 32594 | Sacramento | Sacramento | 67 | 2020-03-05 | 3 | 0 | |
32433 | 32433 | Sacramento | Sacramento | 67 | 2020-03-11 | 10 | 1 | TRUE |
32461 | 32461 | Sacramento | Sacramento | 67 | 2020-03-10 | 10 | 1 | TRUE |
32488 | 32488 | Sacramento | Sacramento | 67 | 2020-03-09 | 10 | 0 | |
32373 | 32373 | Sacramento | Sacramento | 67 | 2020-03-13 | 17 | 1 | TRUE |
32403 | 32403 | Sacramento | Sacramento | 67 | 2020-03-12 | 17 | 1 | |
32341 | 32341 | Sacramento | Sacramento | 67 | 2020-03-14 | 29 | 1 | |
32307 | 32307 | Sacramento | Sacramento | 67 | 2020-03-15 | 32 | 1 | |
32273 | 32273 | Sacramento | Sacramento | 67 | 2020-03-16 | 33 | 2 | |
32201 | 32201 | Sacramento | Sacramento | 67 | 2020-03-18 | 40 | 2 | TRUE |
32238 | 32238 | Sacramento | Sacramento | 67 | 2020-03-17 | 40 | 2 | |
32163 | 32163 | Sacramento | Sacramento | 67 | 2020-03-19 | 45 | 3 | |
32041 | 32041 | Sacramento | Sacramento | 67 | 2020-03-22 | 53 | 3 | TRUE |
32084 | 32084 | Sacramento | Sacramento | 67 | 2020-03-21 | 53 | 3 | TRUE |
32125 | 32125 | Sacramento | Sacramento | 67 | 2020-03-20 | 53 | 3 | |
31951 | 31951 | Sacramento | Sacramento | 67 | 2020-03-24 | 88 | 4 | TRUE |
31996 | 31996 | Sacramento | Sacramento | 67 | 2020-03-23 | 88 | 4 | |
31858 | 31858 | Sacramento | Sacramento | 67 | 2020-03-26 | 113 | 5 | TRUE |
31905 | 31905 | Sacramento | Sacramento | 67 | 2020-03-25 | 113 | 5 | |
31711 | 31711 | Sacramento | Sacramento | 67 | 2020-03-29 | 164 | 6 | TRUE |
31761 | 31761 | Sacramento | Sacramento | 67 | 2020-03-28 | 164 | 6 | TRUE |
31811 | 31811 | Sacramento | Sacramento | 67 | 2020-03-27 | 164 | 6 | |
31608 | 31608 | Sacramento | Sacramento | 67 | 2020-03-31 | 224 | 7 | TRUE |
31660 | 31660 | Sacramento | Sacramento | 67 | 2020-03-30 | 224 | 7 | |
31554 | 31554 | Sacramento | Sacramento | 67 | 2020-04-01 | 314 | 9 | |
31500 | 31500 | Sacramento | Sacramento | 67 | 2020-04-02 | 341 | 9 | |
31390 | 31390 | Sacramento | Sacramento | 67 | 2020-04-04 | 390 | 10 | TRUE |
31445 | 31445 | Sacramento | Sacramento | 67 | 2020-04-03 | 390 | 10 | |
31335 | 31335 | Sacramento | Sacramento | 67 | 2020-04-05 | 442 | 16 | |
31279 | 31279 | Sacramento | Sacramento | 67 | 2020-04-06 | 462 | 18 | |
31223 | 31223 | Sacramento | Sacramento | 67 | 2020-04-07 | 525 | 21 | |
31167 | 31167 | Sacramento | Sacramento | 67 | 2020-04-08 | 580 | 22 | |
31111 | 31111 | Sacramento | Sacramento | 67 | 2020-04-09 | 613 | 22 | |
31055 | 31055 | Sacramento | Sacramento | 67 | 2020-04-10 | 653 | 24 | |
30999 | 30999 | Sacramento | Sacramento | 67 | 2020-04-11 | 699 | 26 | |
30943 | 30943 | Sacramento | Sacramento | 67 | 2020-04-12 | 707 | 26 | |
30887 | 30887 | Sacramento | Sacramento | 67 | 2020-04-13 | 739 | 27 | |
30831 | 30831 | Sacramento | Sacramento | 67 | 2020-04-14 | 816 | 28 | |
30775 | 30775 | Sacramento | Sacramento | 67 | 2020-04-15 | 853 | 32 | |
30719 | 30719 | Sacramento | Sacramento | 67 | 2020-04-16 | 879 | 32 | |
30663 | 30663 | Sacramento | Sacramento | 67 | 2020-04-17 | 896 | 32 | |
30607 | 30607 | Sacramento | Sacramento | 67 | 2020-04-18 | 914 | 33 | |
30551 | 30551 | Sacramento | Sacramento | 67 | 2020-04-19 | 925 | 34 | |
30495 | 30495 | Sacramento | Sacramento | 67 | 2020-04-20 | 940 | 34 | |
30439 | 30439 | Sacramento | Sacramento | 67 | 2020-04-21 | 954 | 35 | |
30383 | 30383 | Sacramento | Sacramento | 67 | 2020-04-22 | 971 | 36 | |
30327 | 30327 | Sacramento | Sacramento | 67 | 2020-04-23 | 987 | 41 | |
30271 | 30271 | Sacramento | Sacramento | 67 | 2020-04-24 | 1019 | 41 | |
30215 | 30215 | Sacramento | Sacramento | 67 | 2020-04-25 | 1025 | 41 | |
30159 | 30159 | Sacramento | Sacramento | 67 | 2020-04-26 | 1037 | 41 | |
30103 | 30103 | Sacramento | Sacramento | 67 | 2020-04-27 | 1045 | 41 | |
30047 | 30047 | Sacramento | Sacramento | 67 | 2020-04-28 | 1053 | 41 | |
29988 | 29988 | Sacramento | Sacramento | 67 | 2020-04-29 | 1068 | 42 | |
29927 | 29927 | Sacramento | Sacramento | 67 | 2020-04-30 | 1077 | 42 | |
29866 | 29866 | Sacramento | Sacramento | 67 | 2020-05-01 | 1090 | 42 | |
29805 | 29805 | Sacramento | Sacramento | 67 | 2020-05-02 | 1107 | 42 | |
29744 | 29744 | Sacramento | Sacramento | 67 | 2020-05-03 | 1117 | 42 | |
29683 | 29683 | Sacramento | Sacramento | 67 | 2020-05-04 | 1127 | 47 | |
29622 | 29622 | Sacramento | Sacramento | 67 | 2020-05-05 | 1133 | 47 | |
29561 | 29561 | Sacramento | Sacramento | 67 | 2020-05-06 | 1142 | 47 | |
29500 | 29500 | Sacramento | Sacramento | 67 | 2020-05-07 | 1153 | 49 | |
29439 | 29439 | Sacramento | Sacramento | 67 | 2020-05-08 | 1160 | 50 | |
29378 | 29378 | Sacramento | Sacramento | 67 | 2020-05-09 | 1165 | 50 | |
29317 | 29317 | Sacramento | Sacramento | 67 | 2020-05-10 | 1167 | 50 | |
29256 | 29256 | Sacramento | Sacramento | 67 | 2020-05-11 | 1173 | 50 | |
29195 | 29195 | Sacramento | Sacramento | 67 | 2020-05-12 | 1181 | 50 | |
29134 | 29134 | Sacramento | Sacramento | 67 | 2020-05-13 | 1183 | 51 | |
29073 | 29073 | Sacramento | Sacramento | 67 | 2020-05-14 | 1194 | 54 | |
29012 | 29012 | Sacramento | Sacramento | 67 | 2020-05-15 | 1211 | 54 | |
28951 | 28951 | Sacramento | Sacramento | 67 | 2020-05-16 | 1222 | 54 | |
28890 | 28890 | Sacramento | Sacramento | 67 | 2020-05-17 | 1237 | 55 | |
28829 | 28829 | Sacramento | Sacramento | 67 | 2020-05-18 | 1245 | 56 | |
28768 | 28768 | Sacramento | Sacramento | 67 | 2020-05-19 | 1250 | 56 | |
28707 | 28707 | Sacramento | Sacramento | 67 | 2020-05-20 | 1255 | 56 | |
28646 | 28646 | Sacramento | Sacramento | 67 | 2020-05-21 | 1266 | 56 | |
28585 | 28585 | Sacramento | Sacramento | 67 | 2020-05-22 | 1272 | 56 | |
28524 | 28524 | Sacramento | Sacramento | 67 | 2020-05-23 | 1289 | 56 | |
28463 | 28463 | Sacramento | Sacramento | 67 | 2020-05-24 | 1293 | 56 | |
28402 | 28402 | Sacramento | Sacramento | 67 | 2020-05-25 | 1302 | 56 | |
28341 | 28341 | Sacramento | Sacramento | 67 | 2020-05-26 | 1310 | 56 |
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 );