Ogólny opis źródłowego zbioru danych. Nazwy kolumn.
Źródło: “Thyroid 2020 to 2022.xlsx”
Liczba kolumn: 394
Organizacja danych: 1 wiersz = 1 operacja
Liczba wierszy: 32008
Liczba unikalnych ID pacjentów: 31703
ID kraju, ID ośrodka oraz ID pacjenta są zakodowane w następujący sposób: Within the anonymous patient ID: L( plus number) stands for country and C ( and number) means the actual clinic in this particular country ( P is the actual patient number).
Nazwy kolumn posiadają dodatkowe oznaczenia:
names(data_import)[str_detect(names(data_import),"^((?!\\.).)*$")][1] "Name" "Module Revision"
[3] "Create Date" "Operation Anonymous Id"
[5] "Patient Anonymous Id" "Sex"
[7] "Age" names(data_import)[str_detect(names(data_import),"\\.PRE$")] [1] "Main indication for surgery.PRE"
[2] "Thyreotoxicosis.PRE"
[3] "Intrathoracic Goitre.PRE"
[4] "Other.PRE"
[5] "S-calcium Total(mmol/L).PRE"
[6] "S-calcium Total(mg/dl).PRE"
[7] "S-calcium Ionized(mmol/L).PRE"
[8] "S-calcium Ionized(mg/dl).PRE"
[9] "Cytology.PRE"
[10] "FNA performed under guidance of ultrasonography.PRE"
[11] "Biopsy.PRE"
[12] "Ultrasound of Thyroid gland.PRE"
[13] "EUTIRADS.PRE"
[14] "Biopsy performed under guidance of ultrasonography.PRE"
[15] "Ultrasound of Regional lymph nodes.PRE"
[16] "Previous Thyroid operation.PRE"
[17] "Indirect or direct laryngoscopy.PRE" names(data_import)[str_detect(names(data_import),"\\.OP$")] [1] "Operation date.OP"
[2] "Operation time, skin to skin (minutes).OP"
[3] "Thyroid operation.OP"
[4] "Surgical approach.OP"
[5] "Neck incision.OP"
[6] "Extra cervical incision.OP"
[7] "Parathyroid operation (excl. Re-implantation of parathyroid gland).OP"
[8] "Reimplantation / transplantation of parathyroid gland (BBA70).OP"
[9] "Frozen section.OP"
[10] "Lymph Node operation.OP"
[11] "Reason for lymph node dissection.OP"
[12] "Sternotomy (GAB20).OP"
[13] "Other operation.OP"
[14] "Noted damage on recurrent laryngeal nerve peroperatively.OP"
[15] "Intraoperative nerve monitoring.OP"
[16] "Type of Intraoperative nerve monitoring.OP"
[17] "Type of damage on the right recurrent laryngeal nerve.OP"
[18] "Type of damage on the left recurrent laryngeal nerve.OP"
[19] "Intentional damage or resection of the recurrent laryngeal nerve.OP"
[20] "Identification of parathyroid glands (number).OP"
[21] "Change of surgical strategy - total thyroidectomy to hemithyroidectomy.OP"
[22] "Auto fluorescens technique used for parathyroid identification.OP" names(data_import)[str_detect(names(data_import),"\\.POST$")] [1] ".POST"
[2] "S-calcium Total(mmol/L).POST"
[3] "S-calcium Total(mg/dl).POST"
[4] "S-calcium Ionized(mmol/L).POST"
[5] "S-calcium Ionized(mg/dl).POST"
[6] "Hypocalcemia which has required treatment with oral calcium.POST"
[7] "Hypocalcemia which has required treatment with iv calcium.POST"
[8] "Indirect or direct laryngoscopy.POST"
[9] "Not performed Indirect or direct laryngoscopy.POST"
[10] "Reason for postoperative laryngoscopy.POST"
[11] "PTH measured.POST"
[12] "Oral calcium therapy at discharge for parathyroid insufficiency (fixed dose).POST"
[13] "Vitamine D at discharge for parathyroid insufficiency.POST"
[14] "Re-bleeding with operation (T81.0).POST"
[15] "If applicable, other serious complication (ICD Code).POST"
[16] "Date of discharge.POST"
[17] "If deceased, date of death.POST" names(data_import)[str_detect(names(data_import),"\\.F1(\\.{3}\\d+)?$")] [1] "Histological main diagnosis.F1"
[2] "Hereditary Desease.F1...67"
[3] "Type of Papillary Cancer.F1...68"
[4] "Type of Papillary Cancer free text.F1...69"
[5] "Type of Follicular Cancer.F1...70"
[6] "Number of tumours.F1...71"
[7] "Largest tumour size reported (mm).F1...72"
[8] "Total number of lymph nodes on histology.F1...73"
[9] "Total number of metastatic lymph nodes.F1...74"
[10] "Histological secondary diagnosis 1.F1"
[11] "Hereditary Desease.F1...76"
[12] "Type of Papillary Cancer.F1...77"
[13] "Type of Papillary Cancer free text.F1...78"
[14] "Type of Follicular Cancer.F1...79"
[15] "Number of tumours.F1...80"
[16] "Largest tumour size reported (mm).F1...81"
[17] "Total number of lymph nodes on histology.F1...82"
[18] "Total number of metastatic lymph nodes.F1...83"
[19] "Date of Follow-up.F1"
[20] "Histological secondary diagnosis 2.F1"
[21] "Hereditary Desease.F1...86"
[22] "Type of Papillary Cancer.F1...87"
[23] "Type of Papillary Cancer free text.F1...88"
[24] "Type of Follicular Cancer.F1...89"
[25] "Number of tumours.F1...90"
[26] "Largest tumour size reported (mm).F1...91"
[27] "Total number of lymph nodes on histology.F1...92"
[28] "Total number of metastatic lymph nodes.F1...93"
[29] "Histological secondary diagnosis 3.F1"
[30] "Hereditary Desease.F1...95"
[31] "Type of Papillary Cancer.F1...96"
[32] "Type of Papillary Cancer free text.F1...97"
[33] "Type of Follicular Cancer.F1...98"
[34] "Number of tumours.F1...99"
[35] "Largest tumour size reported (mm).F1...100"
[36] "Total number of lymph nodes on histology.F1...101"
[37] "Total number of metastatic lymph nodes.F1...102"
[38] "Parathyroid gland on the thyroid specimen.F1"
[39] "T-TNM 7 (thyroid).F1"
[40] "N-TNM 7 (thyroid).F1"
[41] "M-TNM 7 (thyroid).F1"
[42] "T-TNM 8 (thyroid).F1"
[43] "N-TNM 8 (thyroid).F1"
[44] "M-TNM 8 (thyroid).F1"
[45] "Total excised thyroid gland weight (gram).F1"
[46] "Voice recording post op.F1"
[47] "Signs of superior laryngeal nerve damage.F1"
[48] "Indirect or direct laryngoscopy.F1"
[49] "Not performed laryngoscopy.F1"
[50] "Reason for postoperative laryngoscopy.F1"
[51] "PTH measured.F1"
[52] "Wound infection (T81.4).F1"
[53] "Oral calcium therapy for parathyroid insufficiency (fixed dose).F1"
[54] "Vitamine D for parathyroid insufficiency.F1"
[55] "S-calcium Total(mmol/L).F1"
[56] "S-calcium Total(mg/dl).F1"
[57] "S-calcium Ionized(mmol/L).F1"
[58] "S-calcium Ionized(mg/dl).F1"
[59] "Thyroid function.F1"
[60] "If deceased, date of death.F1" names(data_import)[str_detect(names(data_import),"\\.F2$")] [1] "Date of Follow-up.F2"
[2] "If deceased, date of death.F2"
[3] "If deceased, cause of death.F2"
[4] "Indirect or direct laryngoscopy.F2"
[5] "Oral calcium therapy (fixed dose) due to hypocalcemia.F2"
[6] "Vitamine D for parathyroid insufficiency.F2"
[7] "PTH measured.F2"
[8] "S-calcium Total(mmol/L).F2"
[9] "S-calcium Total(mg/dl).F2"
[10] "S-calcium Ionized(mmol/L).F2"
[11] "S-calcium Ionized(mg/dl).F2"
[12] "If applicable, oncologic treatment (ongoing).F2"
[13] "Life status.F2"
[14] "Therapy status.F2"
[15] "Tumour status.F2"
[16] "Follow-up status.F2"
[17] "Basal calcitonin.F2"
[18] "CEA.F2"
[19] "Stimulated calcitonin.F2" names(data_import)[str_detect(names(data_import),"\\.F13$")] [1] "Date of Follow-up.F13"
[2] "If deceased, date of death.F13"
[3] "If deceased, cause of death.F13"
[4] "Indirect or direct laryngoscopy.F13"
[5] "Oral calcium therapy (fixed dose) due to hypocalcemia.F13"
[6] "Vitamine D for parathyroid insufficiency.F13"
[7] "PTH measured.F13"
[8] "S-calcium Total(mmol/L).F13"
[9] "S-calcium Total(mg/dl).F13"
[10] "S-calcium Ionized(mmol/L).F13"
[11] "S-calcium Ionized(mg/dl).F13"
[12] "If applicable, oncologic treatment (ongoing).F13"
[13] "Life status.F13"
[14] "Therapy status.F13"
[15] "Tumour status.F13"
[16] "Follow-up status.F13" names(data_import)[str_detect(names(data_import),"^AC\\.")] [1] "AC.Symptoms"
[2] "AC.SymptomsOther"
[3] "AC.DurationOfSymptoms"
[4] "AC.ImagingEndoscopy"
[5] "AC.ImagingStaging"
[6] "AC.DiscussedMDT"
[7] "AC.PreoperativeOncologyTreatment"
[8] "AC.PreoperativeOncologyTreatmentOther"
[9] "AC.TypeOfSurgery"
[10] "AC.ExtentOfResection"
[11] "AC.ExtentOfResectionExtended"
[12] "AC.Tracheostomy"
[13] "AC.LaryngealNervePreserved"
[14] "AC.MorbidityDindoClavien"
[15] "AC.RResection"
[16] "AC.CapsularInvasion"
[17] "AC.VascularInvasion"
[18] "AC.SoftTissueInvasion"
[19] "AC.VitalOrganInvasion"
[20] "AC.OnkologyTreatment"
[21] "AC.OnkologyTreatmentOther" names(data_import)[str_detect(names(data_import),"^MC\\.")] [1] "MC.HereditaryDisease"
[2] "MC.HereditaryDiseaseExtendNumber"
[3] "MC.HereditaryDiseaseExtendText"
[4] "MC.BasalCalcitonin"
[5] "MC.CEA"
[6] "MC.Imaging"
[7] "MC.StagingOnImaging"
[8] "MC.ProphylacticOperation"
[9] "MC.RResection"
[10] "MC.Ki67"
[11] "MC.PercentPositive"
[12] "MC.BasalCalcitonin_F1"
[13] "MC.CEA_F1"
[14] "MC.OnkologyTreatment_F1"
[15] "MC.OnkologyTreatmentExtendText_F1"
[16] "MC.LocoregionalDisease"
[17] "MC.DateForReoperation"
[18] "MC.CEA_F2"
[19] "MC.StimulatedCalcitonin"
[20] "MC.CalcitoninLevelPgMol"
[21] "MC.CalcitoninLevelPmolL"
[22] "MC.TumourStatus"
[23] "MC.OnkologyTreatment_F2"