Listing all records

Displaying records 301 through 400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
525812 RAD Tech Amarillo TEXAS 8 Hour Evenings Radiology Techs/Technologists
538264 OR San Angelo TEXAS 8 Hour Day/Night Rotate
532052 PT Carrizo Springs TEXAS Days
527053 CVOR Houston TEXAS 8 Hour Days RN/Registered Nurse
528446 PTA Killeen TEXAS Days
547929 L&D San Antonio TEXAS 12 Hour Nights
547930 ER Brownsville TEXAS 12 Hour Nights
547931 Telemetry Brownsville TEXAS 12 Hour Days
547964 Mammo Tech San Angelo TEXAS 8 Hour Days
548021 PCU Abilene TEXAS 12 Hour Nights
548094 ER ODESSA TEXAS 12 Hour Nights RN/Registered Nurse
548097 Med Surg Tele Lufkin TEXAS 12 Hour Days RN/Registered Nurse
548140 Surgical Tech Nacogdoches TEXAS 8 Hour Days CST/Certified Surgical Technician
548158 Scrub Tech Abilene TEXAS 8 Hour Days CST/Certified Surgical Technician
548282 ICU Lufkin TEXAS 12 Hour Nights RN/Registered Nurse
548289 OR Brownwood TEXAS 8 Hour Days RN/Registered Nurse
548309 ER Abilene TEXAS 12 Hour Day/Night Rotate RN/Registered Nurse
548311 ER Dallas TEXAS 12 Hour Nights RN/Registered Nurse
547957 OR Mesquite TEXAS 8 Hour Days
547409 Postpartum ODESSA TEXAS 12 Hour Days
547442 Electrophysiology Tech San Antonio TEXAS 10 Hour Days
547445 PT Seguin TEXAS 8 Hour Days
547446 Rehab Seguin TEXAS 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
547451 LPN/LVN Abilene TEXAS 8 Hour Day/Night Rotate
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
547453 Surgical Tech CVOR Abilene TEXAS 8 Hour Days
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
546359 DOU El Paso TEXAS 12 Hour Nights
547455 PCU Abilene TEXAS 12 Hour Days
547456 Neuro Med Surg/Tele Abilene TEXAS 12 Hour Nights
547457 ICU Abilene TEXAS 12 Hour Nights
547458 Outpatient Clinic Abilene TEXAS 10 Hour Day/Night Rotate
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
547460 MRI Tech Abilene TEXAS 8 Hour Days
547114 Outpatient Clinic Wichita Falls TEXAS 8 Hour Days
547490 Pharmacist Abilene TEXAS 12 Hour Days
547519 Hospice Amarillo TEXAS Days
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
547780 CT Tech Sunnyvale TEXAS 12 Hour Nights
546688 L&D San Antonio TEXAS 12 Hour Nights
546395 CT Tech Wichita Falls TEXAS 8 Hour Evenings
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
542130 Echo Technologist San Angelo TEXAS Varied
542039 OR San Angelo TEXAS Varied
541606 Surgical Tech CVOR Lubbock TEXAS 10 Hour Days
545887 CT Tech Hereford TEXAS 8 Hour Days
545414 OT Rehab San Angelo TEXAS 8 Hour Day/Night Rotate
544768 OR ODESSA TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
545284 OR El Paso TEXAS 12 Hour Days
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
544678 Oncology Midland TEXAS Nights
544852 ER San Angelo TEXAS Varied
545526 Med Surg Memphis TENNESSEE 12 Hour Days
545292 CVICU Memphis TENNESSEE 12 Hour Nights
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
544947 Cath Lab Johnson City TENNESSEE Days
544944 PCU Johnson City TENNESSEE 12 Hour Days
544853 Med Surg Kingsport TENNESSEE 12 Hour Nights
544861 Dialysis Johnson City TENNESSEE 10 Hour Day/Night Rotate
546196 Med Surg Bristol TENNESSEE 12 Hour Nights
546198 Med Surg Bristol TENNESSEE 12 Hour Days
546201 Registered Nurse Bristol TENNESSEE 12 Hour Nights
547890 CT Tech Knoxville TENNESSEE 12 Hour Nights
547425 CVOR Kingsport TENNESSEE 8 Hour Days
547426 Scrub Tech Kingsport TENNESSEE 8 Hour Days
547882 ICU Johnson City TENNESSEE 12 Hour Nights
546393 OR Johnson City TENNESSEE Nights
547246 Postpartum Memphis TENNESSEE 12 Hour Nights
546464 Med Surg Bristol TENNESSEE 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
547069 Step Down Johnson City TENNESSEE 12 Hour Nights
547521 Med Surg Tele Bristol TENNESSEE 12 Hour Nights
546629 PCU Bristol TENNESSEE 12 Hour Days
547581 Pulmonary Johnson City TENNESSEE 12 Hour Days
419839 Med Surg Bristol TENNESSEE 12 Hour Nights
542786 Step Down Kingsport TENNESSEE 12 Hour Nights
543820 Oncology Bristol TENNESSEE 12 Hour Nights
539703 Long Term Care Kingsport TENNESSEE 12 Hour Nights
539660 Long Term Care Greeneville TENNESSEE 12 Hour Nights
539620 PCU Johnson City TENNESSEE 12 Hour Nights
539618 PCU Johnson City TENNESSEE 12 Hour Days
539617 Pulmonary Johnson City TENNESSEE 12 Hour Nights
539616 PCU Johnson City TENNESSEE 12 Hour Nights
539391 OR Bristol TENNESSEE 12 Hour Varied
533362 CNA Kingsport TENNESSEE 12 Hour Nights
543938 Med Surg Kingsport TENNESSEE 12 Hour Days
547977 ICU Memphis TENNESSEE 12 Hour Nights
548310 ER Memphis TENNESSEE 12 Hour Nights RN/Registered Nurse
543821 Med Surg Tele Bristol TENNESSEE 12 Hour Days
543696 Oncology Bristol TENNESSEE 12 Hour Days
543669 ICU Bristol TENNESSEE 12 Hour Nights
543668 ICU Bristol TENNESSEE 12 Hour Days
543461 Oncology Kingsport TENNESSEE 12 Hour Nights
543446 Acute Care Kingsport TENNESSEE 12 Hour Days
543225 PCU Johnson City TENNESSEE 12 Hour Nights
542790 PCU Kingsport TENNESSEE 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.7632 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 300,100 in 1.7705 seconds