walinchus / Chapter_31_Date_Conversions
UK hospital data
Contributors
Last run completed successfully
.
Console output of last run
Injecting configuration and compiling...
Injecting scraper and running...
NOTE *** Ignoring non-worksheet data named u'Macro1' (type 0x01 = Macro sheet)
nsheets result: 13
scraping sheet 0
Title: Daily Hospital Situation Report - A&E Closures
sheet.name A&E closures
[None, u'SHA', u'Code', u'Name', datetime.date(2012, 11, 6), datetime.date(2012, 11, 7), datetime.date(2012, 11, 8), u'9 Nov 12 to 11 Nov 12']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
--- {'SHA': u'Q39', '9 Nov 12 to 11 Nov 12': 0.0, 'id': 1, '2012-11-07': 0.0, '2012-11-06': 0.0, 'title': u'Daily Hospital Situation Report - A&E Closures', 'Name': u'NORTH BRISTOL NHS TRUST', 'Code': u'RVJ', '2012-11-08': 0.0}
scraping sheet 1
Title: Daily Hospital Situation Report - A&E Diverts
sheet.name A&E diverts
[None, u'SHA', u'Code', u'Name', datetime.date(2012, 11, 6), datetime.date(2012, 11, 7), datetime.date(2012, 11, 8), u'9 Nov 12 to 11 Nov 12']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
--- {'SHA': u'Q39', '9 Nov 12 to 11 Nov 12': 0.0, 'id': 2, '2012-11-07': 0.0, '2012-11-06': 0.0, 'title': u'Daily Hospital Situation Report - A&E Diverts', 'Name': u'NORTH BRISTOL NHS TRUST', 'Code': u'RVJ', '2012-11-08': 0.0}
scraping sheet 2
Title: Daily Hospital Situation Report
- Trolley-waits of Over 12 Hours
sheet.name Trolley-waits over 12 hours
[None, u'SHA', u'Code', u'Name', datetime.date(2012, 11, 6), datetime.date(2012, 11, 7), datetime.date(2012, 11, 8), u'9 Nov 12 to 11 Nov 12']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
--- {'SHA': u'Q39', '9 Nov 12 to 11 Nov 12': 0.0, 'id': 3, '2012-11-07': 0.0, '2012-11-06': 0.0, 'title': u'Daily Hospital Situation Report \n - Trolley-waits of Over 12 Hours', 'Name': u'NORTH BRISTOL NHS TRUST', 'Code': u'RVJ', '2012-11-08': 0.0}
scraping sheet 3
Title: Daily Hospital Situation Report
- Cancelled Operations
sheet.name Cancelled operations
[None, u'SHA', u'Code', u'Name', u"Urg ops canc'd 2 or more times", u"Urg ops canc'd in last 24hrs", u"Elective ops canc'd in last 24hrs", u"Urg ops canc'd 2 or more times", u"Urg ops canc'd in last 24hrs", u"Elective ops canc'd in last 24hrs", u"Urg ops canc'd 2 or more times", u"Urg ops canc'd in last 24hrs", u"Elective ops canc'd in last 24hrs", u"Urg ops canc'd 2 or more times", u"Urg ops canc'd in last 24hrs", u"Elective ops canc'd in last 24hrs"]
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
--- {'SHA': u'3. Number of elective operations cancelled in the previous 24 hours', 'id': 4, "Elective ops canc'd in last 24hrs": '', "Urg ops canc'd in last 24hrs": '', "Urg ops canc'd 2 or more times": '', 'title': u'Daily Hospital Situation Report\n - Cancelled Operations', 'Name': '', 'Code': ''}
scraping sheet 4
Title: Daily Hospital Situation Report
- Non-clinical Critical Care Transfers
sheet.name Critical care transfers
[None, u'SHA', u'Code', u'Name', u'Crit care trans out ', u'Crit care trans within', u'Crit care trans out ', u'Crit care trans within', u'Crit care trans out ', u'Crit care trans within', u'Crit care trans out ', u'Crit care trans within']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
--- {'SHA': u'2. Non-clinical critical care transfers within approved critical care transfer group', 'Crit care trans within': '', 'id': 5, 'Crit care trans out ': '', 'Name': '', 'Code': '', 'title': u'Daily Hospital Situation Report\n - Non-clinical Critical Care Transfers'}
scraping sheet 5
Title: Daily Hospital Situation Report
- Number of Ambulances Queuing
sheet.name Ambulances queuing
[None, u'SHA', u'Code', u'Name', datetime.date(2012, 11, 6), datetime.date(2012, 11, 7), datetime.date(2012, 11, 8), u'9 Nov 12 to 11 Nov 12']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
--- {'SHA': u'Q39', '9 Nov 12 to 11 Nov 12': 14.0, 'id': 6, '2012-11-07': 13.0, '2012-11-06': 2.0, 'title': u'Daily Hospital Situation Report \n - Number of Ambulances Queuing', 'Name': u'NORTH BRISTOL NHS TRUST', 'Code': u'RVJ', '2012-11-08': 2.0}
scraping sheet 6
Title: Daily Hospital Situation Report
- General and Acute Beds
sheet.name G&A beds
[None, u'SHA', u'Code', u'Name', u'Core beds avail', u'Escalation beds avail', u'Total beds avail', u"Total beds occ'd", u'Core beds avail', u'Escalation beds avail', u'Total beds avail', u"Total beds occ'd", u'Core beds avail', u'Escalation beds avail', u'Total beds avail', u"Total beds occ'd", u'Core beds avail', u'Escalation beds avail', u'Total beds avail', u"Total beds occ'd"]
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
--- {'SHA': u'4. Of total G&A beds available, number occupied', 'id': 7, 'Escalation beds avail': '', 'title': u'Daily Hospital Situation Report\n - General and Acute Beds', 'Name': '', 'Code': '', 'Core beds avail': '', "Total beds occ'd": '', 'Total beds avail': ''}
scraping sheet 7
Title: Daily Hospital Situation Report - Number of beds unavailable due to D&V/norovirus like symptoms
sheet.name D&V, Norovirus
[None, u'SHA', u'Code', u'Name', u'Beds closed norovirus', u'Beds closed unocc', u'Beds closed norovirus', u'Beds closed unocc', u'Beds closed norovirus', u'Beds closed unocc', u'Beds closed norovirus', u'Beds closed unocc']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
--- {'SHA': u'2. Of these beds closed, number unoccupied', 'id': 8, 'Beds closed unocc': '', 'title': u'Daily Hospital Situation Report - Number of beds unavailable due to D&V/norovirus like symptoms', 'Name': '', 'Code': '', 'Beds closed norovirus': ''}
scraping sheet 8
Title: Daily Hospital Situation Report - Number of beds unavailable due to delayed transfers of care
sheet.name Delayed transfers of care
[None, u'SHA', u'Code', u'Name', datetime.date(2012, 11, 6), datetime.date(2012, 11, 7), datetime.date(2012, 11, 8), u'9 Nov 12 to 11 Nov 12']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
--- {'SHA': u'Q39', '9 Nov 12 to 11 Nov 12': 40.0, 'id': 9, '2012-11-07': 36.0, '2012-11-06': 34.0, 'title': u'Daily Hospital Situation Report - Number of beds unavailable due to delayed transfers of care', 'Name': u'NORTH BRISTOL NHS TRUST', 'Code': u'RVJ', '2012-11-08': 36.0}
scraping sheet 9
Title: Daily Hospital Situation Report
- Adult Critical Care
sheet.name Adult critical care
[None, u'SHA', u'Code', u'Name', u'CC Adult avail', u'CC Adult Occ', u'CC Adult avail', u'CC Adult Occ', u'CC Adult avail', u'CC Adult Occ', u'CC Adult avail', u'CC Adult Occ']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
--- {'SHA': u'2. Adult critical care beds occupied', 'id': 10, 'Name': '', 'title': u'Daily Hospital Situation Report\n - Adult Critical Care', 'CC Adult Occ': '', 'Code': '', 'CC Adult avail': ''}
scraping sheet 10
Title: Daily Hospital Situation Report
- Paediatric Intensive Care
sheet.name Paediatric intensive care
[None, u'SHA', u'Code', u'Name', u'Paed Int Care Avail', u'Paed Int Care Occ', u'Paed Int Care Avail', u'Paed Int Care Occ', u'Paed Int Care Avail', u'Paed Int Care Occ', u'Paed Int Care Avail', u'Paed Int Care Occ']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
--- {'SHA': u'2. Paediatric intensive care beds occupied', 'id': 11, 'Paed Int Care Occ': '', 'Paed Int Care Avail': '', 'title': u'Daily Hospital Situation Report\n - Paediatric Intensive Care', 'Name': '', 'Code': ''}
scraping sheet 11
Title: Daily Hospital Situation Report
- Neonatal Intensive Care
sheet.name Neonatal intensive care
[None, u'SHA', u'Code', u'Name', u'Neo Int Care Avail', u'Neo Int Care Occ', u'Neo Int Care Avail', u'Neo Int Care Occ', u'Neo Int Care Avail', u'Neo Int Care Occ', u'Neo Int Care Avail', u'Neo Int Care Occ']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
--- {'SHA': u'2. Neonatal intensive care cots occupied', 'id': 12, 'Neo Int Care Avail': '', 'Name': '', 'Code': '', 'Neo Int Care Occ': '', 'title': u'Daily Hospital Situation Report\n - Neonatal Intensive Care '}
scraping sheet 12
Title: Daily Hospital Situation Report - Trusts with Ops problems
sheet.name Trusts with Ops problems
[None, u'SHA', u'Code', u'Name', datetime.date(2012, 11, 6), datetime.date(2012, 11, 7), datetime.date(2012, 11, 8), u'9 Nov 12 to 11 Nov 12']
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
--- {'SHA': u'Q39', '9 Nov 12 to 11 Nov 12': u'0', 'id': 13, '2012-11-07': u'0', '2012-11-06': u'0', 'title': u'Daily Hospital Situation Report - Trusts with Ops problems', 'Name': u'NORTH BRISTOL NHS TRUST', 'Code': u'RVJ', '2012-11-08': u'0'}
Data
Downloaded
1 time
by
To download data sign in with GitHub
rows 10 / 13
| 2012-11-08 | id | SHA | 2012-11-07 | title | 9 Nov 12 to 11 Nov 12 | Name | 2012-11-06 | Code | Elective ops canc'd in last 24hrs | Urg ops canc'd in last 24hrs | Urg ops canc'd 2 or more times | Crit care trans within | Crit care trans out | Escalation beds avail | Core beds avail | Total beds occ'd | Total beds avail | Beds closed unocc | Beds closed norovirus | CC Adult Occ | CC Adult avail | Paed Int Care Occ | Paed Int Care Avail | Neo Int Care Avail | Neo Int Care Occ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.0
|
1
|
Q39
|
0.0
|
Daily Hospital Situation Report - A&E Closures
|
0.0
|
NORTH BRISTOL NHS TRUST
|
0.0
|
RVJ
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0.0
|
2
|
Q39
|
0.0
|
Daily Hospital Situation Report - A&E Diverts
|
0.0
|
NORTH BRISTOL NHS TRUST
|
0.0
|
RVJ
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0.0
|
3
|
Q39
|
0.0
|
Daily Hospital Situation Report
- Trolley-waits of Over 12 Hours
|
0.0
|
NORTH BRISTOL NHS TRUST
|
0.0
|
RVJ
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4
|
3. Number of elective operations cancelled in the previous 24 hours
|
|
Daily Hospital Situation Report
- Cancelled Operations
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5
|
2. Non-clinical critical care transfers within approved critical care transfer group
|
|
Daily Hospital Situation Report
- Non-clinical Critical Care Transfers
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2.0
|
6
|
Q39
|
13.0
|
Daily Hospital Situation Report
- Number of Ambulances Queuing
|
14.0
|
NORTH BRISTOL NHS TRUST
|
2.0
|
RVJ
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7
|
4. Of total G&A beds available, number occupied
|
|
Daily Hospital Situation Report
- General and Acute Beds
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8
|
2. Of these beds closed, number unoccupied
|
|
Daily Hospital Situation Report - Number of beds unavailable due to D&V/norovirus like symptoms
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
36.0
|
9
|
Q39
|
36.0
|
Daily Hospital Situation Report - Number of beds unavailable due to delayed transfers of care
|
40.0
|
NORTH BRISTOL NHS TRUST
|
34.0
|
RVJ
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10
|
2. Adult critical care beds occupied
|
|
Daily Hospital Situation Report
- Adult Critical Care
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Statistics
Average successful run time: 1 minute
Total run time: 5 minutes
Total cpu time used: less than 5 seconds
Total disk space used: 31.2 KB
History
-
Manually
ran
revision
b9b6705a
and
completed successfully
.
13 records added, 1 record removed in the database
-
Manually
ran
revision
eb5223de
and
completed successfully
.
1 record added, 1 record removed in the database
-
Manually
ran
revision
10153530
and
completed successfully
.
1 record added in the database
-
Manually
ran
revision
081a736e
and
failed
.
nothing changed in the database
-
Manually
ran
revision
9fc153a6
and
failed
.
nothing changed in the database
- ...
- Created on morph.io