Listing all records

Displaying records 3301 through 3400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
541578 Cath Lab Tarzana CALIFORNIA 8 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
546689 OR Templeton CALIFORNIA 10 Hour Days
546690 Surgical Tech Templeton CALIFORNIA 10 Hour Days
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546908 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
542615 Telemetry Terre Haute INDIANA 12 Hour Nights
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
545243 Scrub 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
537514 CT Tech The Dalles OREGON 12 Hour Day/Night Rotate
543901 Med Surg Tele The Dalles OREGON Days
543047 PT thermopolis WYOMING Days
545440 OT Rehab thermopolis WYOMING Days
534923 PT thermopolis WYOMING Days
534924 PT thermopolis WYOMING Days
547633 CT Tech Titusville FLORIDA 12 Hour Nights
544929 CT Tech Titusville FLORIDA 10 Hour Nights
544626 Echo Toledo OHIO 8 Hour Days
480893 PT Toledo IOWA Days
546247 CT Tech Toledo OHIO 8 Hour Evenings
543060 RAD Tech Toppenish WASHINGTON 8 Hour Days
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
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
546251 CNA TOWNSHEND VERMONT 12 Hour Days
547974 CT Tech TOWNSHEND VERMONT Varied
541443 COTA Towson MARYLAND Days
548218 Med Surg Tele Travelers Rest SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
539178 Med Surg Troy NEW YORK 12 Hour Nights
546993 Med Surg Troy NEW YORK 12 Hour Nights
546994 Med Surg Troy NEW YORK 12 Hour Nights
548138 ER Truth or Consequences NEW MEXICO 12 Hour Days RN/Registered Nurse
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
547795 OR Tuba City ARIZONA 10 Hour Days
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
542986 RAD Tech Tuba City ARIZONA 12 Hour Day/Night Rotate
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
535783 PCU Tucson ARIZONA 12 Hour Nights
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
545244 Echo Technologist Tulsa OKLAHOMA 12 Hour Day/Night Rotate
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
546353 RAD Tech Turlock CALIFORNIA 8 Hour Days
546327 Social Worker Twin Falls IDAHO 8 Hour Days
547311 Telemetry Twin Falls IDAHO 12 Hour Days
547891 Therapy Rehab Twin Falls IDAHO 10 Hour Days
547892 SLP Twin Falls IDAHO 10 Hour Days
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
544955 Telemetry Twin Falls IDAHO 12 Hour Days
547939 Radiation Therapy Twin Falls IDAHO 12 Hour Days
543598 Rehab Twin Falls IDAHO 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543617 Social Worker Twin Falls IDAHO 8 Hour Nights
543618 Social Worker Twin Falls IDAHO 8 Hour Nights
543087 PTA Ukiah CALIFORNIA 8 Hour Days
541750 PT Union City CALIFORNIA 8 Hour Days
547485 PT Union City CALIFORNIA 8 Hour Days
548197 Med Surg Tele Vacaville CALIFORNIA 12 Hour Days RN/Registered Nurse
547539 Case Manager Vail COLORADO Days
547853 Med Surg Valdosta GEORGIA 12 Hour Nights
547854 Med Surg Valdosta GEORGIA 12 Hour Days
547794 Pediatrics Valley City NORTH DAKOTA Nights
546368 Med Surg Tele Per Diem 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
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
529616 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530323 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530740 Med Surg Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530741 Med Surg Van Nuys CALIFORNIA 12 Hour Nights 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
517691 SLP Vernon CONNECTICUT Days
544514 CT Tech Vernon Rockville CONNECTICUT 8 Hour Nights
547941 Med Surg Tele Vernon Rockville CONNECTICUT 12 Hour Nights
547825 Interventional Radiology Vero Beach FLORIDA 10 Hour Days
548288 OR Victorville CALIFORNIA 8 Hour Days RN/Registered Nurse
543751 OR Victorville CALIFORNIA 8 Hour Days
543752 PACU Victorville CALIFORNIA 8 Hour Days
543753 CLS Victorville CALIFORNIA 8 Hour Days
537738 PT Vidalia GEORGIA 12 Hour Days
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 2.9151 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 asc limit 3300,100 in 2.7026 seconds