Listing all records

Displaying records 1 through 100 out of a total 3,709 records. Next

ID Job Specialty City State Shift Title
548201 Medical Assistant Longview WASHINGTON 8 Hour Days Medical Assistant
548048 LPN/LVN Rancho Cordova CALIFORNIA 12 Hour Nights LVN
521399 LPN/LVN Atlanta GEORGIA 8 Hour Days LVN
548343 RNFA Peterborough NEW HAMPSHIRE 8 Hour Days RNFA/Registered Nurse First Assist
548221 Social Worker Greensboro NORTH CAROLINA 8 Hour Days Social Worker
548283 Nurse Practicioner Syracuse NEW YORK 8 Hour Days NP/Nurse Practitioner
548220 CNA Camarillo CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
548206 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548210 CNA South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
548230 CNA Sacramento CALIFORNIA 8 Hour Evenings CNA/Certified Nursing Assistant
548263 CNA Hampton IOWA 12 Hour Evenings CNA/Certified Nursing Assistant
548264 CNA Lowville NEW YORK 8 Hour Nights CNA/Certified Nursing Assistant
548209 OB South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
548205 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
548051 CNA - Per Diem Los Angeles CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
548211 RRT- Respiratory Claremont NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
548064 Respiratory Therapist Falls Church VIRGINIA 12 Hour Nights Respiratory Therapist
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548347 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548131 Respiratory Therapist Keene NEW HAMPSHIRE 12 Hour Nights Respiratory Therapist
548200 Respiratory Therapist Mesa ARIZONA 12 Hour Days Respiratory Therapist
548050 Respiratory Therapist Stony Brook NEW YORK 12 Hour Nights Respiratory Therapist
548111 Respiratory Therapist Indianapolis INDIANA 12 Hour Nights Respiratory Therapist
548047 Respiratory Therapist Schenectady NEW YORK 12 Hour Nights Respiratory Therapist
548357 Perfusionist Falls Church VIRGINIA 12 Hour Days Perfusionist
543834 Mammo Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
525811 CT Tech Amarillo TEXAS 12 Hour Nights Tech/Technologist
548086 Ultrasound Tech Cobleskill NEW YORK 8 Hour Days Tech/Technologist
548317 ST Muskegon MICHIGAN 12 Hour Days Tech/Technologist
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
548273 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
548318 Surgical Tech Bad Axe MICHIGAN 8 Hour Days Tech/Technologist
548244 Surgical Tech GILBERT ARIZONA 12 Hour Nights Tech/Technologist
543831 Cath Lab Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
548059 Surgical Tech SAN FRANCISCO CALIFORNIA 8 Hour Days Tech/Technologist
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
548049 RAD Tech Centralia WASHINGTON 8 Hour Days Tech/Technologist
548203 Technician Hartford CONNECTICUT 8 Hour Days Tech/Technologist
548326 Pharmacy Tech Panorama City CALIFORNIA 8 Hour Days Tech/Technologist
548315 Surgical Tech Detroit MICHIGAN 8 Hour Days Tech/Technologist
548158 Scrub Tech Abilene TEXAS 8 Hour Days CST/Certified Surgical Technician
548195 Surgical Tech CVOR York PENNSYLVANIA 12 Hour Days CST/Certified Surgical Technician
548067 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548225 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
548250 CST Pontiac MICHIGAN 8 Hour Days CST/Certified Surgical Technician
548185 Surgical Tech CVOR Morgantown WEST VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
548140 Surgical Tech Nacogdoches TEXAS 8 Hour Days CST/Certified Surgical Technician
548226 CST Peoria ILLINOIS 10 Hour Days CST/Certified Surgical Technician
523059 CVOR Tech Los Angeles CALIFORNIA 10 Hour Days CST/Certified Surgical Technician
548352 Surgical Tech Falls Church VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
548243 Surgical Tech Wenatchee WASHINGTON 12 Hour Days ORT/Operating Room Technician
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
526054 RAD Tech Cleveland OHIO 8 Hour Days Radiology Techs/Technologists
531151 RAD Tech Farmington CONNECTICUT 8 Hour Days Radiology Techs/Technologists
525930 RAD Tech Los Angeles CALIFORNIA 10 Hour Days Radiology Techs/Technologists
525606 RAD Tech Columbus OHIO 8 Hour Evenings Radiology Techs/Technologists
548169 Interventional Radiology Tech Indianaplis INDIANA 10 Hour Nights Radiology Techs/Technologists
525839 RAD Tech Wilmington NORTH CAROLINA 12 Hour Days Radiology Techs/Technologists
525812 RAD Tech Amarillo TEXAS 8 Hour Evenings Radiology Techs/Technologists
525605 RAD Tech Boston MASSACHUSETTS 10 Hour Days Radiology Techs/Technologists
525604 RAD Tech Richmond VIRGINIA 12 Hour Days Radiology Techs/Technologists
548389 Cardiac Cath Lab Clackamas OREGON 12 Hour Days Advanced Practice
548228 EP Tech Evanston ILLINOIS 8 Hour Days Advanced Practice
548390 Cardiac Cath Lab Clackamas OREGON 10 Hour Days Advanced Practice
548178 Speech Language Redding CALIFORNIA 10 Hour Days SLP/Speech Language Pathologist
548325 SLP Shreveport LOUISIANA 8 Hour Days SLP/Speech Language Pathologist
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
525843 PT Elizabeth WEST VIRGINIA 8 Hour Days PT/Physical Therapist
548328 LPN/LVN Oneonta NEW YORK 12 Hour Days LPN/Licensed Practical Nurse
548332 Clinic Chandler ARIZONA 8 Hour Days LPN/Licensed Practical Nurse
531355 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
526998 Cardiac ICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530725 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
531354 ER - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
548248 ER Keene NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548265 ICU Columbus OHIO 12 Hour Nights RN/Registered Nurse
548266 ICU BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548239 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
527570 Med Surg Tele Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
529616 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
527184 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
531152 Med Surg Tele Farmington CONNECTICUT 12 Hour Nights RN/Registered Nurse
530873 Med Surg Tele Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
516920 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531204 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
Slow: select count(*) from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 in 1.8925 seconds
Slow: select a.id,a.id,b.name as specialty,c.name as shift,d.name as title,z.city,y.name as state from joborders a left join specialties b on a.specialty=b.id left join shifts c on a.shift=c.id left join job_titles d on a.title=d.id left join hospital z on z.id=a.hospital_id left join states y on y.id=z.state where closed=0 order by a.title desc limit 0,100 in 1.5591 seconds