Listing all records

Displaying records 301 through 400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
539758 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544499 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544524 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544525 Telemetry Wailuku HAWAII 12 Hour Nights
544526 Step Down Wailuku HAWAII 12 Hour Days
544527 Med Surg Tele Wailuku HAWAII 12 Hour Days
546335 Psych Wailuku HAWAII 12 Hour Nights
548118 ER Wailuku HAWAII 12 Hour Days RN/Registered Nurse
546931 SLP Visalia CALIFORNIA 8 Hour Days
537738 PT Vidalia GEORGIA 12 Hour Days
548288 OR Victorville CALIFORNIA 8 Hour Days RN/Registered Nurse
543753 CLS Victorville CALIFORNIA 8 Hour Days
543752 PACU Victorville CALIFORNIA 8 Hour Days
543751 OR Victorville CALIFORNIA 8 Hour Days
547825 Interventional Radiology Vero Beach FLORIDA 10 Hour Days
547941 Med Surg Tele Vernon Rockville CONNECTICUT 12 Hour Nights
544514 CT Tech Vernon Rockville CONNECTICUT 8 Hour Nights
517691 SLP Vernon CONNECTICUT Days
530741 Med Surg Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
530740 Med Surg Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530323 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
529616 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547570 Med Surg Per Diem/Local Contract Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
546368 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548085 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548290 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548291 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548337 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548356 ER - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547794 Pediatrics Valley City NORTH DAKOTA Nights
547854 Med Surg Valdosta GEORGIA 12 Hour Days
547853 Med Surg Valdosta GEORGIA 12 Hour Nights
547539 Case Manager Vail COLORADO Days
548197 Med Surg Tele Vacaville CALIFORNIA 12 Hour Days RN/Registered Nurse
541750 PT Union City CALIFORNIA 8 Hour Days
547485 PT Union City CALIFORNIA 8 Hour Days
543087 PTA Ukiah CALIFORNIA 8 Hour Days
543618 Social Worker Twin Falls IDAHO 8 Hour Nights
543617 Social Worker Twin Falls IDAHO 8 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543598 Rehab Twin Falls IDAHO 12 Hour Nights
547939 Radiation Therapy Twin Falls IDAHO 12 Hour Days
544955 Telemetry Twin Falls IDAHO 12 Hour Days
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
547891 Therapy Rehab Twin Falls IDAHO 10 Hour Days
547892 SLP Twin Falls IDAHO 10 Hour Days
547311 Telemetry Twin Falls IDAHO 12 Hour Days
546327 Social Worker Twin Falls IDAHO 8 Hour Days
546353 RAD Tech Turlock CALIFORNIA 8 Hour Days
547536 RAD Tech Tulsa OKLAHOMA 12 Hour Days
547537 Med Surg Tele Tulsa OKLAHOMA 12 Hour Days
547562 Med Surg Tele Tulsa OKLAHOMA 12 Hour Nights
545244 Echo Technologist Tulsa OKLAHOMA 12 Hour Day/Night Rotate
548087 PCU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548088 ER Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
548089 NICU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
535783 PCU Tucson ARIZONA 12 Hour Nights
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
548273 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
527971 RN Tuba City ARIZONA 12 Hour Day/Night Rotate
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
542986 RAD Tech Tuba City ARIZONA 12 Hour Day/Night Rotate
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
547795 OR Tuba City ARIZONA 10 Hour Days
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
546994 Med Surg Troy NEW YORK 12 Hour Nights
546993 Med Surg Troy NEW YORK 12 Hour Nights
539178 Med Surg Troy NEW YORK 12 Hour Nights
548218 Med Surg Tele Travelers Rest SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
541443 COTA Towson MARYLAND Days
546251 CNA TOWNSHEND VERMONT 12 Hour Days
547974 CT Tech TOWNSHEND VERMONT Varied
547990 Cardiology Torrance CALIFORNIA 12 Hour Days
547991 Cardiology Torrance CALIFORNIA 12 Hour Days
547992 Case Manager Torrance CALIFORNIA 8 Hour Days
547993 LTAC Torrance CALIFORNIA 8 Hour Evenings
548164 LTAC Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548044 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548078 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
548082 PCU Torrance CALIFORNIA 12 Hour Days RN/Registered Nurse
518547 NICU Per Diem/Local Contract Torrance CALIFORNIA 12 Hour Nights RN/Registered Nurse
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
543060 RAD Tech Toppenish WASHINGTON 8 Hour Days
546247 CT Tech Toledo OHIO 8 Hour Evenings
544626 Echo Toledo OHIO 8 Hour Days
480893 PT Toledo IOWA Days
547633 CT Tech Titusville FLORIDA 12 Hour Nights
544929 CT Tech Titusville FLORIDA 10 Hour Nights
545440 OT Rehab thermopolis WYOMING Days
534923 PT thermopolis WYOMING Days
534924 PT thermopolis WYOMING Days
543047 PT thermopolis WYOMING Days
543901 Med Surg Tele The Dalles OREGON Days
537514 CT Tech The Dalles OREGON 12 Hour Day/Night Rotate
541785 CNA The Dalles OREGON Nights
541786 ICU The Dalles OREGON 12 Hour Day/Night Rotate
545243 Scrub Tech The Dalles OREGON 12 Hour Day/Night Rotate
548321 Oncology Terre Haute INDIANA 12 Hour Nights 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.5856 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 z.city desc limit 300,100 in 1.7359 seconds