Listing all records

Displaying records 2601 through 2700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
534169 Med Surg Oneonta NEW YORK 12 Hour Nights
547320 First Assist Opelika ALABAMA 8 Hour Days
543709 Laboratory Orange CALIFORNIA 8 Hour Days
526359 Step Down Orangeburg SOUTH CAROLINA 12 Hour Varied
546236 Dialysis Oregon OHIO 8 Hour Days
544562 OR Oregon City OREGON 10 Hour Day/Night Rotate
545091 Med Surg Oregon City OREGON 12 Hour Nights
538557 PT Orwigsburg PENNSYLVANIA Days
546987 Echo Osage Beach MISSOURI 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
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
548035 Echo Pagosa Springs COLORADO 8 Hour Days
542458 Clinic Pahala HAWAII 12 Hour Day/Night Rotate
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
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
527324 PT Palm Springs CALIFORNIA Days
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
547735 Neuro Intensive Care Palo Alto CALIFORNIA 12 Hour Day/Night Rotate
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
547773 Rehab PARAMOUNT CALIFORNIA 12 Hour Days
547774 Rehab PARAMOUNT CALIFORNIA 12 Hour Nights
545194 OR Paris ILLINOIS 8 Hour Evenings
545188 Certified Surgical Tech Paris ILLINOIS 8 Hour Varied
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
544918 Step Down Parma OHIO 12 Hour Nights
548372 Med Surg Tele Parma OHIO 12 Hour Nights RN/Registered Nurse
535334 SLP Pasco WASHINGTON 12 Hour Day/Night Rotate
529209 Surgical Tech Passaic NEW JERSEY 12 Hour Days
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
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
546077 ER Paulding OHIO 12 Hour Nights
544217 Med Surg Pella IOWA 12 Hour Nights
543729 OR Pella IOWA 10 Hour Varied
547068 CT Tech Pella IOWA 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
529591 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529597 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
548042 ER Pendleton OREGON 12 Hour Varied RN/Registered Nurse
548214 Psych Peoria ILLINOIS 12 Hour Evenings RN/Registered Nurse
548226 CST Peoria ILLINOIS 10 Hour Days CST/Certified Surgical Technician
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
546182 Med Surg Peoria ILLINOIS 12 Hour Nights
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
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
547946 L&D Perryville MISSOURI 12 Hour Nights
547996 Med Surg Perryville MISSOURI 12 Hour Days
547997 Med Surg Perryville MISSOURI 12 Hour Days
520029 PT Petaluma CALIFORNIA Varied
541591 RAD Tech Petaluma CALIFORNIA 8 Hour Days
496817 Surgical Tech Peterborough NEW HAMPSHIRE 8 Hour Days
548242 Med Surg Peterborough NEW HAMPSHIRE 12 Hour Nights 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
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
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
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
547949 PT Philadelphia PENNSYLVANIA Varied
539939 CNA Philipsburg PENNSYLVANIA 8 Hour Evenings
539974 ER Philipsburg MONTANA 12 Hour Nights
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
548166 Med Surg Phoenix ARIZONA 12 Hour Nights RN/Registered Nurse
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.7881 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 asc limit 2600,100 in 1.4696 seconds