| Name |
cdph-skilled-nursing-facilities-covid-19 |
|---|
| Updated |
2025-07-01 |
|---|
| Current |
False |
|---|
| Tables |
| covid_19_state_level_testing_and_baseline_aggregate_data | |
date - varchar(10)
current_hospitalized_covid_confirmed_patients - varchar(45)
confirmedcasesincrease - varchar(22)
new_snf_cases - varchar(13)
new_snf_deaths - varchar(14)
facilities_with_positive_test_results - varchar(37)
facilities_with_no_positive_test_results - varchar(40)
number_of_residents_positive_facilities - varchar(39)
number_of_residents_negative_facilities - varchar(39)
number_of_residents_tested_positive_facilities - varchar(46)
number_of_residents_tested_negative_facilities - varchar(46)
number_of_residents_positive - varchar(28)
number_of_residents_scheduled_test_positive_facilities - varchar(54)
number_of_residents_scheduled_test_negative_facilities - varchar(54)
number_of_health_care_workers_positive_facilities - varchar(49)
number_of_health_care_workers_negative_facilities - varchar(49)
number_of_health_care_workers_tested_positive_facilities - varchar(56)
number_of_health_care_workers_tested_negative_facilities - varchar(56)
number_of_health_care_workers_positive - varchar(38)
number_of_health_care_workers_scheduled_test_positive_facilities - varchar(64)
number_of_health_care_workers_scheduled_test_negative_facilities - varchar(64)
note - varchar(32)
|
| skilled_nursing_facilities_covid_19 | |
county - varchar(15)
facility_id - varchar(11)
facility_name - varchar(75)
as_of_date - varchar(10)
total_resident_cases - varchar(20)
new_resident_cases - varchar(18)
total_resident_deaths - varchar(21)
total_health_care_worker_cases - varchar(30)
new_health_care_worker_cases - varchar(28)
total_health_care_workers_deaths - varchar(32)
note - varchar(12)
|
|
|---|
| Sources |
covid-19-snf-data-dictionary.csv --> None
covid-19-state-level-testing-and-baseline-aggregate-data.csv --> covid_19_state_level_testing_and_baseline_aggregate_data
skilled-nursing-facilities-covid-19.csv --> skilled_nursing_facilities_covid_19
|
|---|
| Updates |
| 2025-06-28 13:41:48 |
|
0 |
| 2025-06-25 12:46:35 |
|
0 |
| 2025-06-15 14:52:44 |
|
0 |
| 2025-06-14 15:15:37 |
|
0 |
| 2025-06-11 11:00:44 |
|
0 |
| 2025-06-09 12:08:29 |
|
0 |
| 2025-06-06 11:26:17 |
|
0 |
| 2025-04-20 18:47:23 |
|
0 |
| 2025-04-16 09:30:16 |
|
0 |
| 2025-04-14 08:49:55 |
|
0 |
| 2025-04-11 11:20:27 |
|
0 |
| 2025-04-04 19:40:31 |
|
0 |
| 2025-04-03 11:36:00 |
|
0 |
| 2025-03-31 09:58:16 |
|
0 |
| 2025-03-28 19:19:02 |
|
0 |
| 2025-03-25 10:39:35 |
|
0 |
| 2025-03-24 10:35:54 |
|
0 |
| 2025-03-21 14:06:00 |
|
0 |
| 2025-03-19 09:15:23 |
|
0 |
| 2025-03-18 12:15:30 |
|
0 |
| 2025-03-16 15:36:55 |
|
0 |
| 2025-03-15 10:08:58 |
|
0 |
| 2025-03-12 18:56:07 |
|
0 |
| 2025-03-10 09:51:18 |
|
0 |
| 2025-03-07 08:38:03 |
|
0 |
| 2025-03-05 10:03:54 |
|
0 |
| 2025-03-04 10:39:27 |
|
0 |
| 2025-03-03 09:57:01 |
|
0 |
| 2025-02-28 09:56:42 |
|
0 |
| 2025-02-25 09:03:28 |
|
0 |
| 2025-02-22 13:29:35 |
|
0 |
| 2025-02-21 11:27:48 |
|
0 |
| 2025-02-19 11:11:51 |
|
0 |
| 2025-02-17 09:26:09 |
|
0 |
| 2025-02-16 16:56:28 |
|
0 |
| 2025-02-14 11:00:52 |
|
0 |
| 2025-02-13 11:10:52 |
|
0 |
| 2025-02-11 09:49:43 |
|
0 |
| 2025-02-10 10:42:45 |
|
0 |
| 2025-02-09 14:43:19 |
|
0 |
| 2025-02-08 14:09:12 |
|
0 |
| 2025-02-07 19:06:31 |
|
0 |
| 2025-02-06 15:45:57 |
|
0 |
| 2025-02-06 14:43:41 |
|
0 |
| 2025-02-05 11:54:02 |
|
0 |
| 2025-02-04 17:33:45 |
|
0 |
| 2025-02-03 09:52:56 |
|
0 |
| 2025-02-02 17:26:47 |
|
0 |
| 2025-02-02 14:53:36 |
|
0 |
| 2025-01-31 09:50:47 |
|
0 |
| 2025-01-29 11:00:00 |
|
0 |
| 2025-01-25 10:06:52 |
|
0 |
| 2025-01-24 10:30:28 |
|
0 |
| 2025-01-23 19:54:29 |
|
0 |
| 2025-01-19 12:55:38 |
|
0 |
| 2025-01-18 11:34:59 |
|
0 |
| 2025-01-17 22:10:51 |
|
0 |
| 2025-01-16 17:51:49 |
|
0 |
| 2025-01-14 11:54:45 |
|
0 |
| 2025-01-10 11:09:38 |
|
0 |
| 2025-01-03 14:24:27 |
|
0 |
| 2025-01-01 13:49:50 |
|
0 |
| 2025-01-01 13:45:49 |
|
143 |
| 2024-12-30 15:11:23 |
|
0 |
| 2024-12-27 18:11:02 |
|
0 |
| 2024-12-12 11:05:37 |
|
None |
| 2024-12-09 13:59:03 |
|
None |
| 2024-12-06 22:04:21 |
|
None |
| 2024-12-04 16:17:23 |
|
None |
| 2024-09-18 10:57:05 |
|
None |
| 2024-09-18 08:57:14 |
|
None |
| 2024-09-17 20:08:42 |
|
None |
|
|---|