Listing all records

Displaying records 3401 through 3500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545192 Acute Care Bronx NEW YORK 12 Hour Nights
547414 NICU Bronx NEW YORK 8 Hour Days
547415 Ambulatory Bronx NEW YORK 8 Hour Days
547422 Med Surg Bronx NEW YORK Days
547717 L&D Bronx NEW YORK 12 Hour Days
546196 Med Surg Bristol TENNESSEE 12 Hour Nights
546198 Med Surg Bristol TENNESSEE 12 Hour Days
546201 Registered Nurse Bristol TENNESSEE 12 Hour Nights
546464 Med Surg Bristol TENNESSEE 12 Hour Nights
546629 PCU Bristol TENNESSEE 12 Hour Days
547521 Med Surg Tele Bristol TENNESSEE 12 Hour Nights
419839 Med Surg Bristol TENNESSEE 12 Hour Nights
543820 Oncology Bristol TENNESSEE 12 Hour Nights
539391 OR Bristol TENNESSEE 12 Hour Varied
542779 PCU Bristol TENNESSEE 12 Hour Nights
543668 ICU Bristol TENNESSEE 12 Hour Days
543669 ICU Bristol TENNESSEE 12 Hour Nights
543696 Oncology Bristol TENNESSEE 12 Hour Days
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
543821 Med Surg Tele Bristol TENNESSEE 12 Hour Days
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
544897 CNA Breckenridge MINNESOTA 12 Hour Day/Night Rotate
547961 Psych Brattleboro VERMONT 12 Hour Nights
548115 Telemetry Brattleboro VERMONT 12 Hour Nights RN/Registered Nurse
546946 CT Tech Brattleboro VERMONT 12 Hour Nights
547680 Long Term Care Brantwood NORTH CAROLINA 12 Hour Nights
547793 ICU Bozeman MONTANA 12 Hour Day/Night Rotate
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
525605 RAD Tech Boston MASSACHUSETTS 10 Hour Days Radiology Techs/Technologists
526998 Cardiac ICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
546942 Perfusionist Boston MASSACHUSETTS 10 Hour Days
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
547730 PT Bolivar MISSOURI 8 Hour Days
546014 PT Bolivar MISSOURI 8 Hour Days
544343 CT Tech Boise IDAHO 10 Hour Nights
544952 Med Surg Boise IDAHO 12 Hour Nights
545502 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
547314 Certified Surgical Tech Boise IDAHO 8 Hour Days
547316 Med Surg Boise IDAHO 12 Hour Nights
547606 Surgical Tech Boise IDAHO 10 Hour Days
540456 Med Surg Boise IDAHO 12 Hour Nights
540750 Med Surg Boise IDAHO 12 Hour Nights
540751 Med Surg Boise IDAHO 12 Hour Nights
540752 Med Surg Boise IDAHO 12 Hour Nights
540753 Med Surg Boise IDAHO 12 Hour Nights
542176 ICU Boise IDAHO 12 Hour Nights
542177 ICU Boise IDAHO 12 Hour Nights
542321 CT Tech Boise IDAHO 10 Hour Days
542781 ICU Boise IDAHO 12 Hour Nights
542782 ICU Boise IDAHO 12 Hour Nights
542826 Surgical Tech Boise IDAHO Days
542946 Surgical Tech Boise IDAHO Days
543613 Telemetry Boise IDAHO 12 Hour Nights
543990 CT Tech Boise IDAHO 10 Hour Evenings
547924 ICU Boise IDAHO 12 Hour Nights
547925 ICU Boise IDAHO 12 Hour Nights
547926 Med Surg Boise IDAHO 12 Hour Nights
547927 Med Surg Boise IDAHO 12 Hour Nights
541949 Med Surg Boise IDAHO 12 Hour Nights
524748 Surgical Tech Boise IDAHO 10 Hour Days
524992 Med Surg Boise IDAHO Nights
525646 Med Surg Boise IDAHO 12 Hour Nights
526356 Telemetry Boise IDAHO 12 Hour Nights
527179 RAD Tech Boise IDAHO 12 Hour Days
529965 ICU Boise IDAHO 12 Hour Nights
530378 Med Surg Boise IDAHO Nights
530379 Med Surg Boise IDAHO Nights
534901 Telemetry Boise IDAHO 12 Hour Nights
534902 Telemetry Boise IDAHO 12 Hour Nights
534903 Telemetry Boise IDAHO 12 Hour Nights
534904 Telemetry Boise IDAHO 12 Hour Nights
538936 Psych Boise IDAHO 12 Hour Nights
539751 Telemetry Boise IDAHO 12 Hour Nights
539819 Med Surg Boise IDAHO 12 Hour Nights
527092 PT Boardman OHIO Days
535909 PT Blue Hill NEBRASKA Days
546234 PT Blountstown FLORIDA Days
547444 Med Surg Bloomington INDIANA 12 Hour Nights
537193 Med Surg Bloomington INDIANA 12 Hour Nights
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
545954 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545955 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
546049 RAD Tech Bismarck NORTH DAKOTA 8 Hour Nights
546050 Pediatrics Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
541271 PCU Bismarck NORTH DAKOTA Nights
541283 Surgical Tech CVOR Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
541391 RAD Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
542636 Oncology Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
546683 PCU Birmingham ALABAMA 12 Hour Nights
547244 CT Tech Birmingham ALABAMA 10 Hour Nights
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
519983 PT Big Stone City SOUTH DAKOTA 8 Hour Days
519986 PTA Big Stone City SOUTH DAKOTA Varied
519987 Therapy Rehab Big Stone City SOUTH DAKOTA 8 Hour Days
532355 Medical Assistant Beverly Hills 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.7386 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 3400,100 in 1.5478 seconds