Listing all records

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

ID Job Specialty City State Shift Title
546683 PCU Birmingham ALABAMA 12 Hour Nights
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
546167 Med Surg Tele Dothan ALABAMA 12 Hour Nights
547648 RAD Tech Dothan ALABAMA 8 Hour Days
547320 First Assist Opelika ALABAMA 8 Hour Days
547244 CT Tech Birmingham ALABAMA 10 Hour Nights
533767 PT Bessemer ALABAMA Varied
519750 Med Surg Montgomery ALABAMA 12 Hour Days
513720 PT Bessemer ALABAMA Varied
547933 Med Surg Anniston ALABAMA 12 Hour Nights
545393 Surgical Tech Anchorage ALASKA 10 Hour Nights
547009 Wound Care Anchorage ALASKA 8 Hour Days
521294 Ultrasound Tech Bethel ALASKA Days
522373 LPN/LVN Bethel ALASKA Days
524120 PICU Anchorage ALASKA 12 Hour Nights RN/Registered Nurse
522368 Clinic Bethel ALASKA Days
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
543808 Case Manager Anchorage ALASKA 8 Hour Days
547289 ER CORDOVA ALASKA 12 Hour Nights
542501 Long Term Care Sitka ALASKA 8 Hour Evenings
528504 SLP Juneau ALASKA Days
545392 CT Tech Anchorage ALASKA 12 Hour Days
544192 PT Wrangell ALASKA Varied
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
521297 ER Bethel ALASKA 12 Hour Day/Night Rotate
546884 Respiratory Therapist Sitka ALASKA 10 Hour Varied
529510 CT Tech Bethel ALASKA 12 Hour Day/Night Rotate
503607 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
543574 Case Manager Anchorage ALASKA 8 Hour Days
545120 Case Manager Anchorage ALASKA 8 Hour Days
544016 Social Worker Sitka ALASKA Varied
546276 Pediatrics Sitka ALASKA Varied
545251 Clinic Sitka ALASKA Varied
515962 Pediatrics Nome ALASKA 12 Hour Day/Night Rotate
532051 Long Term Care Nome ALASKA 12 Hour Day/Night Rotate
547775 Clinic Sitka ALASKA Varied
535783 PCU Tucson ARIZONA 12 Hour Nights
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
544493 Ultrasound Tech Prescott ARIZONA 10 Hour Evenings
546879 Med Surg Tele Prescott ARIZONA 12 Hour Days RN/Registered Nurse
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
546971 Radiology PHOENIX ARIZONA 12 Hour Nights
527971 RN Tuba City ARIZONA 12 Hour Day/Night Rotate
546346 PT Nogales ARIZONA 8 Hour Days
542618 PCU Sun City West ARIZONA 12 Hour Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
540748 Med Surg Tele Prescott ARIZONA 12 Hour Days
545622 Cardiovascular Prescott ARIZONA 12 Hour Day/Night Rotate
494609 PCU Casa Grande ARIZONA 12 Hour Nights
547725 Med Surg Mesa ARIZONA 12 Hour Days
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
548273 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
544796 Clinic Fort Defiance ARIZONA 8 Hour Days
544535 Psych Fort Defiance ARIZONA 12 Hour Varied
546005 PCU Mesa ARIZONA 12 Hour Days
547904 ICU Mesa ARIZONA 12 Hour Nights
548244 Surgical Tech GILBERT ARIZONA 12 Hour Nights Tech/Technologist
548245 Surgical Tech Gilbert ARIZONA 12 Hour Nights RN/Registered Nurse
545625 Telemetry Prescott Valley ARIZONA 12 Hour Nights
547700 CVOR Sun City ARIZONA 10 Hour Days
547699 OR Sun City ARIZONA 12 Hour Days
546217 PCU Sun City ARIZONA 12 Hour Nights
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
540770 Telemetry Prescott ARIZONA 12 Hour Days
547468 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
547561 Pediatrics Fort Defiance ARIZONA 12 Hour Day/Night Rotate
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
540746 Med Surg Prescott ARIZONA 12 Hour Day/Night Rotate
531418 PCU Phoenix ARIZONA 12 Hour Nights
536164 Med Surg Glendale ARIZONA 12 Hour Days
547759 Med Surg Sun City West ARIZONA 12 Hour Days
542986 RAD Tech Tuba City ARIZONA 12 Hour Day/Night Rotate
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
546799 Ambulatory Fort Defiance ARIZONA 8 Hour Days
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
547729 PCU Mesa ARIZONA 12 Hour Days
539674 Med Surg Mesa ARIZONA 12 Hour Nights
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
547728 PCU Mesa ARIZONA 12 Hour Nights
530245 Telemetry CHANDLER ARIZONA 12 Hour Nights
546886 PT Globe ARIZONA Days
546345 CT Tech Goodyear ARIZONA 10 Hour Days
542617 PCU Sun City West ARIZONA 12 Hour Nights
545626 Telemetry Prescott Valley ARIZONA 12 Hour Day/Night Rotate
545624 Surgical Tech CVOR Prescott ARIZONA 8 Hour Days
547761 CT Tech Glendale ARIZONA 8 Hour Days
540749 Med Surg Tele Prescott ARIZONA 12 Hour Day/Night Rotate
547118 Interventional Radiology Tech CHANDLER ARIZONA 8 Hour Days
547402 Cath Lab Tech Fort Smith ARIZONA 8 Hour Day/Night Rotate
546216 PCU Sun City ARIZONA 12 Hour Nights
547762 PCU Glendale ARIZONA 12 Hour Nights
547763 CT Tech Glendale ARIZONA 10 Hour Nights
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.0329 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 y.name asc limit 0,100 in 1.0564 seconds