Specialists

specialist_idspecialtyhospital_nameyears_of_experiencesalary
1RadiologistWestern Medical Center780000.0
2RadiologistSt. Luke's Hospital690000.0
3Ultrasound TechnicianWestern Medical Center560000.0
4Ultrasound TechnicianMemorial Hospital455000.0

Hospitals

hospital_idnamelocationnumber_of_bedsannual_revenue
1Western Medical CenterCalifornia250200000000.0
2St. Luke's HospitalNew York300150000000.0
3Memorial HospitalFlorida150100000000.0

Departments

department_idnamedescriptionbudget
1Medical Imaging DepartmentThis department provides diagnostic imaging services using X-ray machines, ultrasounds, MRI scanners etc.100000.0
2Surgery DepartmentA team of surgeons perform various operations including open surgery and minimally invasive procedures.200000.0

Jobs

job_idtitledescriptionrequired_skillsstarting_salaryposted_date
1RadiologistA radiologist interprets x-rays, CT scans, MRIs, and other medical images to diagnose disease.Knowledge of anatomy, strong problem-solving skills, excellent communication skills.80000.02024-03-07 21:24:38
2Ultrasound TechnicianAn ultrasonographer operates ultrasound equipment to visualize internal organs and tissues, guide biopsies and other needle procedures.Strong technical skills, physical stamina, good bedside manner.60000.02024-03-07 21:24:38

Applications

application_idapplicant_nameemailphone_numberresumecover_letterapplied_on
1John Doejohndoe@gmail.com555-123-4567resume.pdfcover_letter.txt2021-01-01 00:00:00
2Jane Smithjanesmith@yahoo.com555-987-6543resumeworker.docxcov_let.odt2021-01-10 00:00:00