Listing all records

Displaying records 1001 through 1100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547051 RAD Tech Phoenix ARIZONA 12 Hour Days
547468 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
547758 PCU Phoenix ARIZONA 12 Hour Nights
547764 CT Tech Phoenix ARIZONA 10 Hour Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
548298 Neuro Intensive Care PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
548360 CVICU Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
531418 PCU Phoenix ARIZONA 12 Hour Nights
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
539939 CNA Philipsburg PENNSYLVANIA 8 Hour Evenings
539974 ER Philipsburg MONTANA 12 Hour Nights
547949 PT Philadelphia PENNSYLVANIA Varied
547745 SLP Philadelphia PENNSYLVANIA Days
547910 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547911 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547913 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Days
542040 Physician PHiladelphia PENNSYLVANIA 8 Hour Days
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543884 ICU Philadelphia PENNSYLVANIA 12 Hour Days
548334 CVICU Petoskey MICHIGAN 12 Hour Nights RN/Registered Nurse
541236 CT Tech Petoskey MICHIGAN 12 Hour Nights
539979 Case Manager Petoskey MICHIGAN 8 Hour Days
546757 OR Petoskey MICHIGAN 10 Hour Days
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
548132 ER Peterborough NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548227 First Assist Peterborough NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
548343 RNFA Peterborough NEW HAMPSHIRE 8 Hour Days RNFA/Registered Nurse First Assist
496817 Surgical Tech Peterborough NEW HAMPSHIRE 8 Hour Days
548242 Med Surg Peterborough NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
520029 PT Petaluma CALIFORNIA Varied
541591 RAD Tech Petaluma CALIFORNIA 8 Hour Days
547946 L&D Perryville MISSOURI 12 Hour Nights
547996 Med Surg Perryville MISSOURI 12 Hour Days
547997 Med Surg Perryville MISSOURI 12 Hour Days
548214 Psych Peoria ILLINOIS 12 Hour Evenings RN/Registered Nurse
548226 CST Peoria ILLINOIS 10 Hour Days CST/Certified Surgical Technician
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
546805 OR Peoria ILLINOIS Nights
546830 Clinic Peoria ILLINOIS 8 Hour Days
546845 Med Surg Peoria ILLINOIS 12 Hour Nights
547143 Neuro Med Surg/Tele Peoria ILLINOIS 12 Hour Nights
547273 Certified Surgical Tech Peoria ILLINOIS 8 Hour Days
544397 Med Surg Peoria ILLINOIS 12 Hour Days RN/Registered Nurse
545564 RAD Tech Peoria ILLINOIS 8 Hour Days
545597 Med Surg Peoria ILLINOIS 12 Hour Nights
545605 ER Peoria ILLINOIS 12 Hour Nights
546182 Med Surg Peoria ILLINOIS 12 Hour Nights
547084 ICU Pendleton OREGON 12 Hour Nights
547085 ICU Pendleton OREGON 12 Hour Nights
547086 Med Surg Pendleton OREGON 12 Hour Nights
547087 Med Surg Pendleton OREGON 12 Hour Nights
548042 ER Pendleton OREGON 12 Hour Varied RN/Registered Nurse
529591 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529597 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
543729 OR Pella IOWA 10 Hour Varied
547068 CT Tech Pella IOWA 12 Hour Nights
544217 Med Surg Pella IOWA 12 Hour Nights
546077 ER Paulding OHIO 12 Hour Nights
544222 ICU Passaic NEW JERSEY 12 Hour Nights
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
544553 Cath Lab Passaic NEW JERSEY 8 Hour Days
529209 Surgical Tech Passaic NEW JERSEY 12 Hour Days
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
535334 SLP Pasco WASHINGTON 12 Hour Day/Night Rotate
544918 Step Down Parma OHIO 12 Hour Nights
548372 Med Surg Tele Parma OHIO 12 Hour Nights RN/Registered Nurse
546825 Surgical Tech CVOR Parkersburg WEST VIRGINIA 10 Hour Days
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
547526 Med Surg Parkersburg WEST VIRGINIA 12 Hour Nights
545188 Certified Surgical Tech Paris ILLINOIS 8 Hour Varied
545194 OR Paris ILLINOIS 8 Hour Evenings
547773 Rehab PARAMOUNT CALIFORNIA 12 Hour Days
547774 Rehab PARAMOUNT CALIFORNIA 12 Hour Nights
530475 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
538592 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
548326 Pharmacy Tech Panorama City CALIFORNIA 8 Hour Days Tech/Technologist
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
543406 PT Palm Springs CALIFORNIA 8 Hour Days
543407 PT Palm Springs CALIFORNIA 8 Hour Days
544049 Med Surg Palm Springs CALIFORNIA 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544051 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
527324 PT Palm Springs CALIFORNIA Days
542458 Clinic Pahala HAWAII 12 Hour Day/Night Rotate
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
548035 Echo Pagosa Springs COLORADO 8 Hour Days
547894 Med Surg Oxford NORTH CAROLINA 12 Hour Nights
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
546127 Med Surg Oxford NORTH CAROLINA 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 1.5693 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 z.city desc limit 1000,100 in 1.4123 seconds