Listing all records

Displaying records 1601 through 1700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544789 CNA Kealakekua HAWAII 12 Hour Day/Night Rotate
546335 Psych Wailuku HAWAII 12 Hour Nights
545305 Cath Lab Honolulu HAWAII Nights
546037 Pediatrics Hilo HAWAII 12 Hour Varied
546039 Pediatrics Hilo HAWAII 12 Hour Nights
546041 Med Surg Hilo HAWAII 12 Hour Nights
546053 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
546054 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
546096 ICU Hilo HAWAII 12 Hour Days
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
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
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
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
546187 CT Tech Emmett IDAHO 8 Hour Days
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
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
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
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 2.1381 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 asc limit 1600,100 in 1.9511 seconds