Listing all records

Displaying records 1301 through 1400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
538686 Laboratory New York NEW YORK 8 Hour Days
539450 Med Surg New York NEW YORK 8 Hour Evenings
539559 Laboratory New York NEW YORK 8 Hour Evenings
546641 Acute Care New York NEW YORK 8 Hour Days
547907 Med Surg New York NEW YORK Nights
547420 Radiology New York NEW YORK Nights
547423 Ambulatory New York NEW YORK 8 Hour Days
547692 Ambulatory New York NEW YORK 8 Hour Days
547711 ER New York NEW YORK 12 Hour Days
547715 Med Surg New York NEW YORK 12 Hour Nights
547716 Med Surg New York NEW YORK 8 Hour Days
547718 Rehab New York NEW YORK Nights
547746 Ambulatory New York NEW YORK 8 Hour Days
547747 Ambulatory New York NEW YORK 8 Hour Days
547748 Med Surg New York NEW YORK 8 Hour Nights
547749 Med Surg New York NEW YORK 8 Hour Nights
529430 PTA New Providence NEW JERSEY Days
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
548191 ER New London NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
531994 Physician New Lisbon WISCONSIN Days
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
548404 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
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
545191 Surgical Tech New Albany OHIO 12 Hour Days
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
543494 Med Surg Nashua NEW HAMPSHIRE 12 Hour Nights
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
547670 Psych Nashua NEW HAMPSHIRE 12 Hour Nights
532394 ICU Nashua NEW HAMPSHIRE 12 Hour Nights
543897 PT Naples FLORIDA Varied
540446 Case Manager Napa CALIFORNIA 8 Hour Days
543607 Telemetry Nampa IDAHO 12 Hour Nights
547308 Telemetry Nampa IDAHO 12 Hour Nights
547319 Telemetry Nampa IDAHO 12 Hour Nights
548140 Surgical Tech Nacogdoches TEXAS 8 Hour Days CST/Certified Surgical Technician
547923 OR Muskegon MICHIGAN 10 Hour Days
548317 ST Muskegon MICHIGAN 12 Hour Days Tech/Technologist
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
531502 Surgical Tech Muskegon MICHIGAN 12 Hour Nights
531702 OR Muskegon MICHIGAN 10 Hour Days
531824 Med Surg Tele Muskegon MICHIGAN 12 Hour Nights
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
543291 Surgical Tech Muskegon MICHIGAN 12 Hour Days
548023 LPN/LVN Mullins SOUTH CAROLINA 12 Hour Nights
547255 CT Tech Mullins SOUTH 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
546402 CT Tech Mount Airy NORTH CAROLINA 8 Hour Nights
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
547744 CT Tech Moses Lake WASHINGTON 12 Hour Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
547776 ER Morton WASHINGTON Nights
546996 Mammo Tech Morgantown WEST VIRGINIA 8 Hour Days
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
539020 Step Down Morgantown WEST VIRGINIA 12 Hour Nights
545532 CT Tech Montrose COLORADO 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
519750 Med Surg Montgomery ALABAMA 12 Hour Days
538440 COTA Monterey CALIFORNIA Days
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
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
547685 Electrophysiology Tech Monterey CALIFORNIA 8 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 1.7023 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 1300,100 in 1.6525 seconds