cdcr-prison-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were collected in ISO 8601 format.
- code
- The unique identifier of the prison institution.
- name
- The name of the prison institution.
- city
- The city where the prison institution is located.
- county
- The county where the prison institution is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- zipcode
- The ZIP Code where the agency is located.
- x
- The longitude of the area's centroid.
- y
- The latitude of the area's centroid.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- deaths
- The cumulative number of deaths at that time.
- new_deaths
- The net change in deaths over the previous date.
1,026 rows where name = "California State Prison, Sacramento" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | code | name | city | county | fips | zipcode | x | y | confirmed_cases | new_confirmed_cases | deaths | new_deaths |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14264 | 14264 | 2022-09-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14263 | 14263 | 2022-09-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14262 | 14262 | 2022-09-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14261 | 14261 | 2022-09-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14260 | 14260 | 2022-09-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14259 | 14259 | 2022-09-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14258 | 14258 | 2022-09-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 0 | 2 | 0 |
14257 | 14257 | 2022-09-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 932 | 1 | 2 | 0 |
14256 | 14256 | 2022-09-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 931 | 2 | 2 | 0 |
14255 | 14255 | 2022-09-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 929 | 0 | 2 | 0 |
14254 | 14254 | 2022-09-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 929 | 0 | 2 | 0 |
14253 | 14253 | 2022-09-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 929 | 0 | 2 | 0 |
14252 | 14252 | 2022-09-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 929 | 0 | 2 | 0 |
14251 | 14251 | 2022-09-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 929 | 0 | 2 | 0 |
14250 | 14250 | 2022-09-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 929 | 0 | 2 | 0 |
14249 | 14249 | 2022-09-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 929 | 3 | 2 | 0 |
14248 | 14248 | 2022-09-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 926 | 1 | 2 | 0 |
14247 | 14247 | 2022-09-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 925 | 0 | 2 | 0 |
14246 | 14246 | 2022-09-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 925 | 1 | 2 | 0 |
14245 | 14245 | 2022-09-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 924 | 1 | 2 | 0 |
14244 | 14244 | 2022-09-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 923 | 6 | 2 | 0 |
14243 | 14243 | 2022-08-31 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 917 | 0 | 2 | 0 |
14242 | 14242 | 2022-08-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 917 | 4 | 2 | 0 |
14241 | 14241 | 2022-08-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 913 | 0 | 2 | 0 |
14240 | 14240 | 2022-08-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 913 | 4 | 2 | 0 |
14239 | 14239 | 2022-08-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 909 | 0 | 2 | 0 |
14238 | 14238 | 2022-08-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 909 | 6 | 2 | 0 |
14237 | 14237 | 2022-08-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 903 | 2 | 2 | 0 |
14236 | 14236 | 2022-08-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 901 | 2 | 2 | 0 |
14235 | 14235 | 2022-08-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 899 | 3 | 2 | 0 |
14234 | 14234 | 2022-08-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 896 | 10 | 2 | 0 |
14233 | 14233 | 2022-08-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 886 | 0 | 2 | 0 |
14232 | 14232 | 2022-08-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 886 | 0 | 2 | 0 |
14231 | 14231 | 2022-08-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 886 | 1 | 2 | 0 |
14230 | 14230 | 2022-08-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 885 | 1 | 2 | 0 |
14229 | 14229 | 2022-08-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 884 | 4 | 2 | 0 |
14228 | 14228 | 2022-08-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 880 | 13 | 2 | 0 |
14227 | 14227 | 2022-08-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 867 | 10 | 2 | 0 |
14226 | 14226 | 2022-08-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 857 | 1 | 2 | 0 |
14225 | 14225 | 2022-08-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 856 | 0 | 2 | 0 |
14224 | 14224 | 2022-08-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 856 | 1 | 2 | 0 |
14223 | 14223 | 2022-08-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 855 | 3 | 2 | 0 |
14222 | 14222 | 2022-08-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 852 | 1 | 2 | 0 |
14221 | 14221 | 2022-08-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 851 | 1 | 2 | 0 |
14220 | 14220 | 2022-08-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 850 | 1 | 2 | 0 |
14219 | 14219 | 2022-08-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 849 | 0 | 2 | 0 |
14218 | 14218 | 2022-08-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 849 | 0 | 2 | 0 |
14217 | 14217 | 2022-08-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 849 | 0 | 2 | 0 |
14216 | 14216 | 2022-08-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 849 | 0 | 2 | 0 |
14215 | 14215 | 2022-08-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 849 | 0 | 2 | 0 |
14214 | 14214 | 2022-08-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 849 | 2 | 2 | 0 |
14213 | 14213 | 2022-08-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 847 | 0 | 2 | 0 |
14212 | 14212 | 2022-07-31 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 847 | 0 | 2 | 0 |
14211 | 14211 | 2022-07-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 847 | 0 | 2 | 0 |
14210 | 14210 | 2022-07-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 847 | 0 | 2 | 0 |
14209 | 14209 | 2022-07-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 847 | 0 | 2 | 0 |
14208 | 14208 | 2022-07-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 847 | 1 | 2 | 0 |
14207 | 14207 | 2022-07-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 846 | 1 | 2 | 0 |
14206 | 14206 | 2022-07-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 845 | 0 | 2 | 0 |
14205 | 14205 | 2022-07-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 845 | 0 | 2 | 0 |
14204 | 14204 | 2022-07-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 845 | 0 | 2 | 0 |
14203 | 14203 | 2022-07-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 845 | 1 | 2 | 0 |
14202 | 14202 | 2022-07-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 844 | 1 | 2 | 0 |
14201 | 14201 | 2022-07-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 843 | 4 | 2 | 0 |
14200 | 14200 | 2022-07-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 839 | 1 | 2 | 0 |
14199 | 14199 | 2022-07-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 838 | 0 | 2 | 0 |
14198 | 14198 | 2022-07-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 838 | 0 | 2 | 0 |
14197 | 14197 | 2022-07-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 838 | 0 | 2 | 0 |
14196 | 14196 | 2022-07-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 838 | 1 | 2 | 0 |
14195 | 14195 | 2022-07-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 837 | 1 | 2 | 0 |
14194 | 14194 | 2022-07-13 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 836 | 1 | 2 | 0 |
14193 | 14193 | 2022-07-12 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 835 | 8 | 2 | 0 |
14192 | 14192 | 2022-07-11 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 827 | 2 | 2 | 0 |
14191 | 14191 | 2022-07-10 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 825 | 0 | 2 | 0 |
14190 | 14190 | 2022-07-09 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 825 | 1 | 2 | 0 |
14189 | 14189 | 2022-07-08 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 824 | 0 | 2 | 0 |
14188 | 14188 | 2022-07-07 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 824 | 6 | 2 | 0 |
14187 | 14187 | 2022-07-06 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 818 | 1 | 2 | 0 |
14186 | 14186 | 2022-07-05 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 817 | 7 | 2 | 0 |
14185 | 14185 | 2022-07-04 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 810 | 0 | 2 | 0 |
14184 | 14184 | 2022-07-03 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 810 | 0 | 2 | 0 |
14183 | 14183 | 2022-07-02 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 810 | 2 | 2 | 0 |
14182 | 14182 | 2022-07-01 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 808 | 0 | 2 | 0 |
14181 | 14181 | 2022-06-30 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 808 | 0 | 2 | 0 |
14180 | 14180 | 2022-06-29 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 808 | 2 | 2 | 0 |
14179 | 14179 | 2022-06-28 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 806 | 7 | 2 | 0 |
14178 | 14178 | 2022-06-27 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 799 | 2 | 2 | 0 |
14177 | 14177 | 2022-06-26 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 797 | 0 | 2 | 0 |
14176 | 14176 | 2022-06-25 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 797 | 3 | 2 | 0 |
14175 | 14175 | 2022-06-24 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 794 | 1 | 2 | 0 |
14174 | 14174 | 2022-06-23 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 793 | 3 | 2 | 0 |
14173 | 14173 | 2022-06-22 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 790 | 3 | 2 | 0 |
14172 | 14172 | 2022-06-21 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 787 | 4 | 2 | 0 |
14171 | 14171 | 2022-06-20 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 783 | 3 | 2 | 0 |
14170 | 14170 | 2022-06-19 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 780 | 0 | 2 | 0 |
14169 | 14169 | 2022-06-18 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 780 | 1 | 2 | 0 |
14168 | 14168 | 2022-06-17 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 779 | 0 | 2 | 0 |
14167 | 14167 | 2022-06-16 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 779 | 3 | 2 | 0 |
14166 | 14166 | 2022-06-15 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 776 | 4 | 2 | 0 |
14165 | 14165 | 2022-06-14 | SAC | California State Prison, Sacramento | Represa | Sacramento | 67 | 95671 | -121.159923 | 38.6875176 | 772 | 1 | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdcr-prison-totals" ( [date] TEXT, [code] TEXT, [name] TEXT, [city] TEXT, [county] TEXT, [fips] INTEGER, [zipcode] INTEGER, [x] FLOAT, [y] FLOAT, [confirmed_cases] INTEGER, [new_confirmed_cases] INTEGER, [deaths] INTEGER, [new_deaths] INTEGER );