Periods of care with procedures, average length

Periods Of Care With Procedures Average LengthTSV
The indicator gives the average duration of periods of inpatient care with surgical procedures, calculated by dividing the number of care days with the number of period of care.Using the codes according to the classification of procedures (Toimenpideluokitus Ohjeita ja luokituksia 2004:2), the data concerns all procedures with letters A to Q in the first code position, excluding procedures where the third character in the code is a number. The data cover all hospitals that perform procedures. Does not include the service area of day surgery or surgical procedures on outpatient visits.

Column	Type	Comment
year	int	Observation year. Column year has 24324 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2000 and maximum value is 2016.
region	int	Sotkanet region code (Municipality, sub-region, region, area for the regional state administrative agency, major region, Mainland Finland/Åland, hospital district, university hospital special responsibility area, whole country). Column region has 24324 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 955.
gender	string	male, female, combined. Column gender has 24324 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is female and maximum string is total.
value_ka	float	Average. Column value_ka has 24324 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1.00 and maximum value is 124.90.
absolute_value	string	Absolute value. Column is empty.
orig_extractdate	string	The date when the data was originally fetched from the source.

Last Updated	April 12, 2019
Created	March 8, 2019