Listing all records

Displaying records 2301 through 2400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
547385 Med Surg Missoula MONTANA 12 Hour Nights
531507 Therapy Rehab Modesto CALIFORNIA Days
535270 PTA Modesto CALIFORNIA Days
535271 PTA Modesto CALIFORNIA Days
548137 Med Surg Modesto CALIFORNIA 12 Hour Nights RN/Registered Nurse
548353 Behavioral Health Modesto CALIFORNIA 12 Hour Days RN/Registered Nurse
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548351 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548405 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
538440 COTA Monterey CALIFORNIA Days
544641 PT Monterey CALIFORNIA Days
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
547685 Electrophysiology Tech Monterey CALIFORNIA 8 Hour Days
542873 PT Monterey CALIFORNIA Days
519750 Med Surg Montgomery ALABAMA 12 Hour Days
545532 CT Tech Montrose COLORADO 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
539020 Step Down Morgantown WEST VIRGINIA 12 Hour Nights
547936 CT Tech Morgantown WEST VIRGINIA 8 Hour Evenings
548185 Surgical Tech CVOR Morgantown WEST VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
546996 Mammo Tech Morgantown WEST VIRGINIA 8 Hour Days
547776 ER Morton WASHINGTON Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
547744 CT Tech Moses Lake WASHINGTON 12 Hour Nights
546402 CT Tech Mount Airy NORTH CAROLINA 8 Hour Nights
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
546793 Endoscopy Mt. Vernon WASHINGTON 10 Hour Day/Night Rotate
546928 Med Surg Tele Mt. Vernon WASHINGTON 12 Hour Nights
547938 Acute Care Mt. Vernon WASHINGTON 12 Hour Nights
548023 LPN/LVN Mullins SOUTH CAROLINA 12 Hour Nights
547255 CT Tech Mullins SOUTH CAROLINA 12 Hour Nights
546392 Sterile Processing Tech Muskegon MICHIGAN Nights
546637 Sterile Processing Tech Muskegon MICHIGAN Nights
546711 OR Muskegon MICHIGAN 10 Hour Days
547061 Sterile Processing Tech Muskegon MICHIGAN Nights
547062 Sterile Processing Tech Muskegon MICHIGAN Nights
547276 Sterile Processing Tech Muskegon MICHIGAN Nights
547279 ER Muskegon MICHIGAN 12 Hour Nights
547280 ER Muskegon MICHIGAN 12 Hour Nights
547281 ICU Muskegon MICHIGAN 12 Hour Nights
547282 ICU Muskegon MICHIGAN 12 Hour Nights
547921 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
546142 Cardiology Muskegon MICHIGAN 12 Hour Days
546143 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
546144 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546145 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546146 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
546147 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
531502 Surgical Tech Muskegon MICHIGAN 12 Hour Nights
531702 OR Muskegon MICHIGAN 10 Hour Days
531824 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
547923 OR Muskegon MICHIGAN 10 Hour Days
548317 ST Muskegon MICHIGAN 12 Hour Days Tech/Technologist
548140 Surgical Tech Nacogdoches TEXAS 8 Hour Days CST/Certified Surgical Technician
547308 Telemetry Nampa IDAHO 12 Hour Nights
547319 Telemetry Nampa IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
540446 Case Manager Napa CALIFORNIA 8 Hour Days
543897 PT Naples FLORIDA Varied
543494 Med Surg Nashua NEW HAMPSHIRE 12 Hour Nights
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
532394 ICU Nashua NEW HAMPSHIRE 12 Hour Nights
547670 Psych Nashua NEW HAMPSHIRE 12 Hour Nights
541235 Med Surg National City CALIFORNIA 12 Hour Nights
543885 OR National City CALIFORNIA 8 Hour Days
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
543887 CT Tech National City CALIFORNIA 12 Hour Nights
543888 RAD Tech National City CALIFORNIA 12 Hour Days
543889 Cath Lab National City CALIFORNIA 8 Hour Days
543890 Psych National City CALIFORNIA 12 Hour Nights
543891 Psych National City CALIFORNIA 12 Hour Days
548354 Psych National City CALIFORNIA 12 Hour Nights RN/Registered Nurse
545191 Surgical Tech New Albany OHIO 12 Hour Days
548036 MLT New Bern NORTH CAROLINA 10 Hour Nights
546897 Cath Lab New Bern NORTH CAROLINA 8 Hour Days
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
548404 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
531994 Physician New Lisbon WISCONSIN Days
548191 ER New London NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
529430 PTA New Providence NEW JERSEY Days
507890 OR New York NEW YORK 12 Hour Days RN/Registered Nurse
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
525987 Supervisor New York NEW YORK 8 Hour Days
525988 Supervisor New York NEW YORK 8 Hour Days
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
534643 Med Surg New York NEW YORK 12 Hour Nights
535732 Pharmacist New York NEW YORK 8 Hour Nights
536589 OR New York NEW YORK 12 Hour Nights
536590 OR New York NEW YORK 12 Hour Nights
537741 Psych New York NEW YORK 12 Hour Days
538497 Laboratory New York NEW YORK 8 Hour Evenings
538622 ER New York NEW YORK 12 Hour Nights
538624 ER New York NEW YORK 12 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.6362 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 2300,100 in 1.6534 seconds