Listing all records

Displaying records 601 through 700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
538714 Respiratory Therapist Mason City IOWA 12 Hour Nights
538717 Surgical Tech Columbus OHIO Days
538720 RN Columbus OHIO 12 Hour Days
538741 ICU Cleveland OHIO 12 Hour Day/Night Rotate
538824 Medical Assistant Madison WISCONSIN 8 Hour Evenings
538849 Echo Honolulu HAWAII 8 Hour Days
538869 MRI Tech Lexington KENTUCKY 8 Hour Nights
538892 Med Surg Janesville WISCONSIN 12 Hour Nights
538911 CT Tech Alturas CALIFORNIA 8 Hour Varied
538917 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
538936 Psych Boise IDAHO 12 Hour Nights
538951 Med Surg Tele Cleveland OHIO 12 Hour Nights
538956 Med Surg Tele Cleveland OHIO 12 Hour Nights
539009 Med Surg Tele Cleveland OHIO 12 Hour Nights
539020 Step Down Morgantown WEST VIRGINIA 12 Hour Nights
539068 ER Avalon CALIFORNIA Nights
539078 MLT Des Moines IOWA 8 Hour Days
539087 Oncology Duluth MINNESOTA 12 Hour Day/Night Rotate
539089 PT Fort Dodge IOWA 8 Hour Days
539093 MLT Des Moines IOWA 12 Hour Days
539095 MLT Des Moines IOWA 8 Hour Days
539105 Telemetry San Diego CALIFORNIA 12 Hour Days
539106 Telemetry San Diego CALIFORNIA 12 Hour Nights
539107 ICU San Diego CALIFORNIA 12 Hour Nights
539110 PCU Concord CALIFORNIA 12 Hour Nights
539111 OR Concord CALIFORNIA 10 Hour Days
539112 Social Worker Concord CALIFORNIA 8 Hour Days
539151 Surgical Tech Fresno CALIFORNIA 10 Hour Days
539176 ICU Albany NEW YORK 12 Hour Days
539177 Cardiology Albany NEW YORK 12 Hour Nights
539178 Med Surg Troy NEW YORK 12 Hour Nights
539199 Med Surg Dyersville IOWA 12 Hour Nights
539200 Med Surg Dubuque IOWA 12 Hour Days
539277 Med Surg Tele Cleveland OHIO 12 Hour Nights
539278 Med Surg Tele Cleveland OHIO 12 Hour Nights
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
539294 Radiology Queens NEW YORK 8 Hour Days
539306 PT Sunnyvale CALIFORNIA Days
539310 Speech Language Roseburg OREGON Days
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
539378 RAD Tech Louisville KENTUCKY 12 Hour Nights
539384 Scrub Tech Newark NEW JERSEY 12 Hour Days
539391 OR Bristol TENNESSEE 12 Hour Varied
539450 Med Surg New York NEW YORK 8 Hour Evenings
539455 PT Athens GEORGIA 8 Hour Days
539477 Telemetry - Per Diem Mission Viejo CALIFORNIA 12 Hour Days RN/Registered Nurse
539559 Laboratory New York NEW YORK 8 Hour Evenings
539616 PCU Johnson City TENNESSEE 12 Hour Nights
539617 Pulmonary Johnson City TENNESSEE 12 Hour Nights
539618 PCU Johnson City TENNESSEE 12 Hour Days
539620 PCU Johnson City TENNESSEE 12 Hour Nights
539629 CT Tech Cleveland OHIO 8 Hour Nights
539652 Med Surg Abingdon VIRGINIA 12 Hour Days
539656 Med Surg Abingdon VIRGINIA 12 Hour Nights
539658 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate
539660 Long Term Care Greeneville TENNESSEE 12 Hour Nights
539670 Med Surg Tele Des Moines IOWA 12 Hour Nights
539674 Med Surg Mesa ARIZONA 12 Hour Nights
539689 Med Surg Norton VIRGINIA 12 Hour Nights
539692 CNA Marion VIRGINIA 12 Hour Days
539693 CNA Marion VIRGINIA 12 Hour Nights
539703 Long Term Care Kingsport TENNESSEE 12 Hour Nights
539708 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
539710 Echo Sioux City IOWA 8 Hour Days
539711 CT Tech Clinton IOWA 12 Hour Days
539712 Home Health Mason City IOWA 8 Hour Days
539713 Oncology Des Moines IOWA 12 Hour Nights
539714 Oncology Des Moines IOWA 12 Hour Nights
539715 Respiratory Therapist Mishawaka INDIANA 12 Hour Days
539718 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
539734 PTA Avoca IOWA Days
539742 Laboratory Falls Church VIRGINIA 8 Hour Evenings
539751 Telemetry Boise IDAHO 12 Hour Nights
539754 L&D Wailuku HAWAII 8 Hour Nights
539755 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539756 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539757 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539758 Med Surg Tele Wailuku HAWAII 12 Hour Nights
539819 Med Surg Boise IDAHO 12 Hour Nights
539836 RAD Tech Seattle WASHINGTON 8 Hour Days
539856 Med Surg Tele Cleveland OHIO 12 Hour Nights
539857 Med Surg Tele Cleveland OHIO 12 Hour Nights
539873 Therapy Rehab Crescent City CALIFORNIA 8 Hour Days
539875 Therapy Rehab Athens GEORGIA 8 Hour Days
539896 Ultrasound Tech York PENNSYLVANIA 12 Hour Day/Night Rotate
539898 Cardiovascular York PENNSYLVANIA Nights
539903 MLT Tuba City ARIZONA 12 Hour Day/Night Rotate
539926 Med Surg Schenectady NEW YORK 12 Hour Days
539930 Surgical Tech Louisville KENTUCKY 8 Hour Days
539939 CNA Philipsburg PENNSYLVANIA 8 Hour Evenings
539941 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
539948 Social Worker Fresno CALIFORNIA Days
539974 ER Philipsburg MONTANA 12 Hour Nights
539979 Case Manager Petoskey MICHIGAN 8 Hour Days
540000 ER Walnut Creek CALIFORNIA 12 Hour Nights
540001 ER Walnut Creek CALIFORNIA 12 Hour Days
540002 MRI Tech Farmington CONNECTICUT 12 Hour Nights
540003 Telemetry Farmington CONNECTICUT 12 Hour Days
540004 PACU Walnut Creek CALIFORNIA 12 Hour Days
540005 OR Farmington CONNECTICUT 10 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.3856 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 a.id asc limit 600,100 in 1.0538 seconds