Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
521294 Ultrasound Tech Bethel ALASKA Days
521297 ER Bethel ALASKA 12 Hour Day/Night Rotate
522368 Clinic Bethel ALASKA Days
522373 LPN/LVN Bethel ALASKA Days
529510 CT Tech Bethel ALASKA 12 Hour Day/Night Rotate
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
532355 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
546440 Ophthalmic Tech Beverly Hills CALIFORNIA 8 Hour Days
546753 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
545943 Medical Assistant Beverly Hills CALIFORNIA 8 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
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
546683 PCU Birmingham ALABAMA 12 Hour Nights
547244 CT Tech Birmingham ALABAMA 10 Hour Nights
547518 CT Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
546050 Pediatrics Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
546049 RAD Tech Bismarck NORTH DAKOTA 8 Hour Nights
545955 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
545954 Interventional Radiology Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
542636 Oncology Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
541391 RAD Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
541283 Surgical Tech CVOR Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
541271 PCU Bismarck NORTH DAKOTA Nights
547444 Med Surg Bloomington INDIANA 12 Hour Nights
537193 Med Surg Bloomington INDIANA 12 Hour Nights
546234 PT Blountstown FLORIDA Days
535909 PT Blue Hill NEBRASKA Days
527092 PT Boardman OHIO Days
539819 Med Surg Boise IDAHO 12 Hour Nights
539751 Telemetry Boise IDAHO 12 Hour Nights
538936 Psych 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
534904 Telemetry Boise IDAHO 12 Hour Nights
534903 Telemetry Boise IDAHO 12 Hour Nights
534902 Telemetry Boise IDAHO 12 Hour Nights
534901 Telemetry Boise IDAHO 12 Hour Nights
525646 Med Surg Boise IDAHO 12 Hour Nights
526356 Telemetry Boise IDAHO 12 Hour Nights
527179 RAD Tech Boise IDAHO 12 Hour Days
530379 Med Surg Boise IDAHO Nights
530378 Med Surg Boise IDAHO Nights
529965 ICU Boise IDAHO 12 Hour Nights
542826 Surgical Tech Boise IDAHO Days
542782 ICU Boise IDAHO 12 Hour Nights
542781 ICU Boise IDAHO 12 Hour Nights
542321 CT Tech Boise IDAHO 10 Hour Days
542177 ICU Boise IDAHO 12 Hour Nights
542176 ICU Boise IDAHO 12 Hour Nights
542946 Surgical Tech Boise IDAHO Days
543990 CT Tech Boise IDAHO 10 Hour Evenings
540753 Med Surg Boise IDAHO 12 Hour Nights
540752 Med Surg Boise IDAHO 12 Hour Nights
540751 Med Surg Boise IDAHO 12 Hour Nights
540750 Med Surg Boise IDAHO 12 Hour Nights
540456 Med Surg Boise IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
545502 Telemetry Boise IDAHO 12 Hour Nights
544343 CT Tech Boise IDAHO 10 Hour Nights
544952 Med Surg Boise IDAHO 12 Hour Nights
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
547606 Surgical Tech Boise IDAHO 10 Hour Days
547316 Med Surg Boise IDAHO 12 Hour Nights
547314 Certified Surgical Tech Boise IDAHO 8 Hour Days
547730 PT Bolivar MISSOURI 8 Hour Days
546014 PT Bolivar MISSOURI 8 Hour Days
548253 Neuro Intensive Care Boston MASSACHUSETTS 12 Hour Days RN/Registered Nurse
546942 Perfusionist Boston MASSACHUSETTS 10 Hour Days
525605 RAD Tech Boston MASSACHUSETTS 10 Hour Days Radiology Techs/Technologists
526998 Cardiac ICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
548080 CVICU Boston MASSACHUSETTS 12 Hour Day/Night Rotate RN/Registered Nurse
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
547793 ICU Bozeman MONTANA 12 Hour Day/Night Rotate
547680 Long Term Care Brantwood NORTH CAROLINA 12 Hour Nights
546946 CT Tech Brattleboro VERMONT 12 Hour Nights
547961 Psych Brattleboro VERMONT 12 Hour Nights
548115 Telemetry Brattleboro VERMONT 12 Hour Nights RN/Registered Nurse
544897 CNA Breckenridge MINNESOTA 12 Hour Day/Night Rotate
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
546196 Med Surg Bristol TENNESSEE 12 Hour Nights
546464 Med Surg Bristol TENNESSEE 12 Hour Nights
546198 Med Surg Bristol TENNESSEE 12 Hour Days
546201 Registered Nurse Bristol TENNESSEE 12 Hour Nights
547521 Med Surg Tele Bristol TENNESSEE 12 Hour Nights
546629 PCU Bristol TENNESSEE 12 Hour Days
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
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.4247 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 200,100 in 1.7157 seconds