cdph-hospital-patient-state-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date for which hospital data were reported in ISO 8601 format.
- positive_patients
- The current number confirmed coronavirus cases in hospitals on this date.
- suspected_patients
- The current number suspected coronavirus cases in hospitals on this date.
- icu_positive_patients
- The current number confirmed coronavirus cases in intensive-care units on this date.
- icu_suspected_patients
- The current number suspected coronavirus cases in intensive-care units on this date.
- icu_available_beds
- The current number open and avilable intensive-care beds on this date.
1,006 rows sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|
1006 | 1006 | 2020-03-29 | 1306 | 2739 | 544 | 474 | 2423 |
1005 | 1005 | 2020-03-30 | 1624 | 3528 | 662 | 594 | 2937 |
1004 | 1004 | 2020-03-31 | 1855 | 3773 | 774 | 642 | 2745 |
1003 | 1003 | 2020-04-01 | 1916 | 3478 | 810 | 617 | 2772 |
1002 | 1002 | 2020-04-02 | 2176 | 3408 | 896 | 582 | 2720 |
1001 | 1001 | 2020-04-03 | 2285 | 3227 | 1003 | 583 | 2910 |
1000 | 1000 | 2020-04-04 | 2383 | 3183 | 1035 | 559 | 2951 |
999 | 999 | 2020-04-05 | 2509 | 2967 | 1085 | 575 | 2054 |
998 | 998 | 2020-04-06 | 2611 | 2796 | 1108 | 522 | 2219 |
997 | 997 | 2020-04-07 | 2714 | 3078 | 1154 | 522 | 2110 |
996 | 996 | 2020-04-08 | 2825 | 2803 | 1132 | 530 | 2238 |
995 | 995 | 2020-04-09 | 2897 | 2339 | 1145 | 446 | 2135 |
994 | 994 | 2020-04-10 | 2846 | 2221 | 1145 | 420 | 2327 |
993 | 993 | 2020-04-11 | 2917 | 2317 | 1145 | 394 | 2309 |
992 | 992 | 2020-04-12 | 3015 | 2033 | 1178 | 374 | 2052 |
991 | 991 | 2020-04-13 | 3124 | 2039 | 1177 | 375 | 2182 |
990 | 990 | 2020-04-14 | 3171 | 1894 | 1175 | 368 | 2196 |
989 | 989 | 2020-04-15 | 3141 | 1890 | 1191 | 377 | 2068 |
988 | 988 | 2020-04-16 | 3180 | 1712 | 1174 | 310 | 2127 |
987 | 987 | 2020-04-17 | 3221 | 1715 | 1173 | 316 | 2103 |
986 | 986 | 2020-04-18 | 3196 | 1535 | 1163 | 294 | 2229 |
985 | 985 | 2020-04-19 | 3257 | 1417 | 1196 | 284 | 2212 |
984 | 984 | 2020-04-20 | 3365 | 1521 | 1241 | 261 | 2185 |
983 | 983 | 2020-04-21 | 3357 | 1627 | 1219 | 332 | 2778 |
982 | 982 | 2020-04-22 | 3343 | 1586 | 1204 | 327 | 3407 |
981 | 981 | 2020-04-23 | 3344 | 1536 | 1216 | 305 | 3625 |
980 | 980 | 2020-04-24 | 3343 | 1504 | 1198 | 260 | 4042 |
979 | 979 | 2020-04-25 | 3324 | 1604 | 1184 | 289 | 4527 |
978 | 978 | 2020-04-26 | 3372 | 1506 | 1185 | 314 | 4352 |
977 | 977 | 2020-04-27 | 3455 | 1528 | 1181 | 304 | 4271 |
976 | 976 | 2020-04-28 | 3495 | 1516 | 1186 | 326 | 4024 |
975 | 975 | 2020-04-29 | 3497 | 1484 | 1192 | 281 | 4010 |
974 | 974 | 2020-04-30 | 3428 | 1278 | 1192 | 242 | 4143 |
973 | 973 | 2020-05-01 | 3423 | 1299 | 1178 | 255 | 3941 |
972 | 972 | 2020-05-02 | 3318 | 1416 | 1169 | 299 | 3922 |
971 | 971 | 2020-05-03 | 3284 | 1332 | 1179 | 285 | 3969 |
970 | 970 | 2020-05-04 | 3369 | 1253 | 1157 | 231 | 4024 |
969 | 969 | 2020-05-05 | 3334 | 1347 | 1140 | 275 | 3893 |
968 | 968 | 2020-05-06 | 3319 | 1241 | 1125 | 249 | 3988 |
967 | 967 | 2020-05-07 | 3250 | 1264 | 1118 | 224 | 3741 |
966 | 966 | 2020-05-08 | 3282 | 1256 | 1115 | 234 | 3665 |
965 | 965 | 2020-05-09 | 3218 | 1337 | 1097 | 231 | 3717 |
964 | 964 | 2020-05-10 | 3248 | 1301 | 1093 | 236 | 3868 |
963 | 963 | 2020-05-11 | 3284 | 1260 | 1078 | 271 | 3899 |
962 | 962 | 2020-05-12 | 3301 | 1244 | 1075 | 239 | 3833 |
961 | 961 | 2020-05-13 | 3261 | 1394 | 1099 | 225 | 3840 |
960 | 960 | 2020-05-14 | 3157 | 1362 | 1067 | 257 | 3811 |
959 | 959 | 2020-05-15 | 3126 | 1298 | 1079 | 234 | 3710 |
958 | 958 | 2020-05-16 | 3025 | 1266 | 1069 | 224 | 3704 |
957 | 957 | 2020-05-17 | 3037 | 1354 | 1076 | 249 | 3846 |
956 | 956 | 2020-05-18 | 3073 | 1290 | 1076 | 231 | 3925 |
955 | 955 | 2020-05-19 | 3047 | 1634 | 1068 | 277 | 3805 |
954 | 954 | 2020-05-20 | 3048 | 1687 | 1051 | 259 | 3811 |
953 | 953 | 2020-05-21 | 3007 | 1755 | 1050 | 267 | 3710 |
952 | 952 | 2020-05-22 | 3024 | 1318 | 1079 | 233 | 3719 |
951 | 951 | 2020-05-23 | 2980 | 1320 | 1071 | 244 | 3767 |
950 | 950 | 2020-05-24 | 3015 | 1291 | 1062 | 239 | 3813 |
949 | 949 | 2020-05-25 | 3065 | 1339 | 1084 | 308 | 4232 |
948 | 948 | 2020-05-26 | 3114 | 1430 | 1095 | 312 | 4231 |
947 | 947 | 2020-05-27 | 3091 | 1438 | 1092 | 233 | 3865 |
946 | 946 | 2020-05-28 | 3016 | 1398 | 1078 | 250 | 3742 |
945 | 945 | 2020-05-29 | 2928 | 1287 | 1042 | 231 | 3696 |
944 | 944 | 2020-05-30 | 2940 | 1391 | 1067 | 257 | 3754 |
943 | 943 | 2020-05-31 | 2973 | 1285 | 1053 | 220 | 3860 |
942 | 942 | 2020-06-01 | 3038 | 1355 | 1054 | 242 | 4181 |
941 | 941 | 2020-06-02 | 3090 | 1368 | 1079 | 234 | 3676 |
940 | 940 | 2020-06-03 | 3109 | 1346 | 1058 | 221 | 3676 |
939 | 939 | 2020-06-04 | 3142 | 1483 | 1083 | 250 | 3686 |
938 | 938 | 2020-06-05 | 3181 | 1345 | 1077 | 238 | 3719 |
937 | 937 | 2020-06-06 | 3138 | 1387 | 1068 | 220 | 3752 |
936 | 936 | 2020-06-07 | 3184 | 1322 | 1079 | 222 | 3791 |
935 | 935 | 2020-06-08 | 3257 | 1326 | 1103 | 242 | 3926 |
934 | 934 | 2020-06-09 | 3240 | 1479 | 1090 | 236 | 3728 |
933 | 933 | 2020-06-10 | 3177 | 1357 | 1073 | 252 | 3741 |
932 | 932 | 2020-06-11 | 3222 | 1258 | 1101 | 209 | 3648 |
931 | 931 | 2020-06-12 | 3191 | 1220 | 1109 | 204 | 3689 |
930 | 930 | 2020-06-13 | 3092 | 1155 | 1076 | 204 | 3730 |
929 | 929 | 2020-06-14 | 3103 | 1220 | 1053 | 217 | 3780 |
928 | 928 | 2020-06-15 | 3335 | 1127 | 1069 | 203 | 3928 |
927 | 927 | 2020-06-16 | 3421 | 1101 | 1109 | 209 | 3770 |
926 | 926 | 2020-06-17 | 3439 | 1145 | 1119 | 179 | 3530 |
925 | 925 | 2020-06-18 | 3428 | 1159 | 1128 | 201 | 3879 |
924 | 924 | 2020-06-19 | 3494 | 1088 | 1145 | 187 | 3898 |
923 | 923 | 2020-06-20 | 3574 | 1105 | 1163 | 203 | 4045 |
922 | 922 | 2020-06-21 | 3702 | 1102 | 1199 | 213 | 4120 |
921 | 921 | 2020-06-22 | 3868 | 1197 | 1225 | 196 | 4178 |
920 | 920 | 2020-06-23 | 4095 | 1304 | 1268 | 219 | 4034 |
919 | 919 | 2020-06-24 | 4240 | 1282 | 1306 | 217 | 3790 |
918 | 918 | 2020-06-25 | 4380 | 1259 | 1364 | 206 | 3632 |
917 | 917 | 2020-06-26 | 4494 | 1296 | 1379 | 183 | 3684 |
916 | 916 | 2020-06-27 | 4577 | 1379 | 1385 | 217 | 3621 |
915 | 915 | 2020-06-28 | 4776 | 1403 | 1465 | 221 | 3717 |
914 | 914 | 2020-06-29 | 5077 | 1389 | 1528 | 223 | 3730 |
913 | 913 | 2020-06-30 | 5196 | 1416 | 1617 | 242 | 3580 |
912 | 912 | 2020-07-01 | 5355 | 1457 | 1676 | 258 | 3451 |
911 | 911 | 2020-07-02 | 5506 | 1518 | 1650 | 221 | 3497 |
910 | 910 | 2020-07-03 | 5595 | 1497 | 1682 | 206 | 3555 |
909 | 909 | 2020-07-04 | 5669 | 1480 | 1711 | 196 | 3871 |
908 | 908 | 2020-07-05 | 5790 | 1488 | 1706 | 231 | 3882 |
907 | 907 | 2020-07-06 | 5989 | 1510 | 1740 | 244 | 3925 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-hospital-patient-state-totals" ( [date] TEXT, [positive_patients] INTEGER, [suspected_patients] INTEGER, [icu_positive_patients] INTEGER, [icu_suspected_patients] INTEGER, [icu_available_beds] INTEGER );