Listing all records

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

ID Job Specialty City State Shift Title
533521 PTA Belton TEXAS Days
547135 PT Lufkin TEXAS 8 Hour Days
534999 PT Kerrville TEXAS Days
535908 SLP Plano TEXAS Days
535911 Telemetry Lubbock TEXAS 12 Hour Days RN/Registered Nurse
538264 OR San Angelo TEXAS 8 Hour Day/Night Rotate
544768 OR ODESSA TEXAS 12 Hour Days
544678 Oncology Midland TEXAS Nights
544852 ER San Angelo TEXAS Varied
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
545284 OR El Paso TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
545414 OT Rehab San Angelo TEXAS 8 Hour Day/Night Rotate
545887 CT Tech Hereford TEXAS 8 Hour Days
541606 Surgical Tech CVOR Lubbock TEXAS 10 Hour Days
542039 OR San Angelo TEXAS Varied
542130 Echo Technologist San Angelo TEXAS Varied
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
546395 CT Tech Wichita Falls TEXAS 8 Hour Evenings
532338 PT Ogden UTAH Days
546063 Med Surg Roosevelt UTAH Nights
544409 CT Tech Springfield VERMONT 8 Hour Nights
547961 Psych Brattleboro VERMONT 12 Hour Nights
547974 CT Tech TOWNSHEND VERMONT Varied
548115 Telemetry Brattleboro VERMONT 12 Hour Nights RN/Registered Nurse
546251 CNA TOWNSHEND VERMONT 12 Hour Days
546285 Rehab Windsor VERMONT 12 Hour Nights
546412 Med Surg Springfield VERMONT 12 Hour Days
546946 CT Tech Brattleboro VERMONT 12 Hour Nights
547669 Home Health Springfield VERMONT 8 Hour Day/Night Rotate
532855 PT St Johnsbury VERMONT Varied
516484 PT Hot Springs VIRGINIA Days
525604 RAD Tech Richmond VIRGINIA 12 Hour Days Radiology Techs/Technologists
529609 PT Low Moor VIRGINIA Days
531433 Long Term Care Marion VIRGINIA Nights
531958 Social Worker Falls Church VIRGINIA 8 Hour Days
537453 MRI Tech Falls Church VIRGINIA 12 Hour Days
538546 OR Falls Church VIRGINIA 12 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
539689 Med Surg Norton VIRGINIA 12 Hour Nights
539692 CNA Marion VIRGINIA 12 Hour Days
539693 CNA Marion VIRGINIA 12 Hour Nights
539742 Laboratory Falls Church VIRGINIA 8 Hour Evenings
548167 ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548064 Respiratory Therapist Falls Church VIRGINIA 12 Hour Nights Respiratory Therapist
548179 Case Manager Falls Church VIRGINIA 8 Hour Days RN/Registered Nurse
548180 Pediatric ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548299 OR Arlington VIRGINIA 10 Hour Days RN/Registered Nurse
548313 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548314 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548350 CVOR Falls Church VIRGINIA 12 Hour Day/Night Rotate RN/Registered Nurse
548352 Surgical Tech Falls Church VIRGINIA 12 Hour Day/Night Rotate CST/Certified Surgical Technician
548357 Perfusionist Falls Church VIRGINIA 12 Hour Days Perfusionist
548394 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate RN/Registered Nurse
545336 Ultrasound Tech Abingdon VIRGINIA 12 Hour Days
540788 Sonographer Falls Church VIRGINIA 8 Hour Days
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
542262 CVOR Charlottesville VIRGINIA 10 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
543133 Echo Charlottesville VIRGINIA 8 Hour Days
543243 CVOR Falls Church VIRGINIA 12 Hour Days RN/Registered Nurse
543484 Certified Surgical Tech Abingdon VIRGINIA 8 Hour Day/Night Rotate
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
545569 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545570 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545571 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545572 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545591 RAD Tech Richmond VIRGINIA 8 Hour Days
545592 RAD Tech Richmond VIRGINIA 8 Hour Days
545599 RAD Tech Richmond VIRGINIA 8 Hour Days
545600 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
546067 ICU Norton VIRGINIA 12 Hour Nights
546289 CT Tech Alexandria VIRGINIA 10 Hour Days
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
546750 Med Surg Charlottesville VIRGINIA 12 Hour Nights
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
547036 Surgical Tech Falls Church VIRGINIA 8 Hour Day/Night Rotate
547290 ER Norton VIRGINIA 12 Hour Days
547376 PCU Charlottesville VIRGINIA 12 Hour Nights
547479 CT Tech Arlington VIRGINIA 10 Hour Days
547634 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547673 CVOR Falls Church VIRGINIA 12 Hour Days
547674 CVOR Falls Church VIRGINIA 12 Hour Days
547852 Ultrasound Tech Fredericksburg VIRGINIA 8 Hour Days
547860 Oncology Charlottesville VIRGINIA 10 Hour Days
547861 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547862 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547863 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
546245 Neuro Intensive Care Seattle WASHINGTON 12 Hour Nights
546608 Med Surg Spokane WASHINGTON 12 Hour Days
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
546699 Med Surg Spokane WASHINGTON 12 Hour Days
546717 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546718 PCU Centralia WASHINGTON 12 Hour Nights
546720 Med Surg Tele Olympia WASHINGTON 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 2.1732 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 3400,100 in 1.8439 seconds