Listing all records

Displaying records 2001 through 2100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546326 Social Worker Ketchum IDAHO 8 Hour Days
546327 Social Worker Twin Falls IDAHO 8 Hour Days
547308 Telemetry Nampa IDAHO 12 Hour Nights
547311 Telemetry Twin Falls IDAHO 12 Hour Days
547314 Certified Surgical Tech Boise IDAHO 8 Hour Days
547316 Med Surg Boise IDAHO 12 Hour Nights
547318 ICU Meridian IDAHO 12 Hour Nights
547319 Telemetry Nampa IDAHO 12 Hour Nights
547606 Surgical Tech Boise IDAHO 10 Hour Days
547886 CT Tech McCall IDAHO 12 Hour Nights
547887 CT Tech McCall IDAHO Days
547889 RRT- Respiratory Meridian IDAHO 12 Hour Nights
547891 Therapy Rehab Twin Falls IDAHO 10 Hour Days
547892 SLP Twin Falls IDAHO 10 Hour Days
544149 Long Term Care Moscow IDAHO 12 Hour Nights
544343 CT Tech Boise IDAHO 10 Hour Nights
544344 L&D Ketchum IDAHO 12 Hour Nights
544345 Surgical Tech Ketchum IDAHO 12 Hour Days
544347 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544354 Med Surg Meridian IDAHO 12 Hour Nights
544811 Radiation Therapy Lewiston IDAHO 8 Hour Days
544812 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544952 Med Surg Boise IDAHO 12 Hour Nights
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
544955 Telemetry Twin Falls IDAHO 12 Hour Days
545502 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
545888 Therapy Rehab JEROME IDAHO 8 Hour Days
475928 PT Lewiston IDAHO Days
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
526586 PT Lewiston IDAHO Days
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
534700 Therapy Rehab Lewiston IDAHO Days
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
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
543598 Rehab Twin Falls IDAHO 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
543617 Social Worker Twin Falls IDAHO 8 Hour Nights
543618 Social Worker Twin Falls IDAHO 8 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
547939 Radiation Therapy Twin Falls IDAHO 12 Hour Days
548009 RAD Tech Honolulu HAWAII 8 Hour Day/Night Rotate
548118 ER Wailuku HAWAII 12 Hour Days RN/Registered Nurse
548120 Med Surg Tele Honolulu HAWAII 12 Hour Days RN/Registered Nurse
548121 Med Surg Kula HAWAII 12 Hour Nights RN/Registered Nurse
504432 PT Honolulu HAWAII Days
513832 Med Surg Tele Wailuku HAWAII 12 Hour Days
517267 PT Kapaau HAWAII Days
517269 PT Kapaau HAWAII Days
517902 Med Surg Tele Wailuku HAWAII 8 Hour Nights
517904 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
517913 Med Surg Tele Maui Wailuku HAWAII 12 Hour Nights
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
519045 Med Surg Kula HAWAII 8 Hour Nights
519146 Med Surg Kula HAWAII 8 Hour Days
523400 Med Surg Kula HAWAII 8 Hour Nights
523403 Med Surg Kula HAWAII 8 Hour Nights
525386 Vascular Ultrasound Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
527338 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
534971 Administration Kealakekua HAWAII Days
534972 CT Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
536159 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
538087 PT Honolulu HAWAII 8 Hour Days
538391 Med Surg Tele Wailuku HAWAII 8 Hour Days
538410 Med Surg Tele Wailuku HAWAII 12 Hour Nights
538849 Echo Honolulu HAWAII 8 Hour Days
538917 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
539718 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
539754 L&D Wailuku HAWAII 8 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.5187 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 y.name desc limit 2000,100 in 1.6252 seconds