Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
548154 Home Health Los Angeles Downey CALIFORNIA 8 Hour Days RN/Registered Nurse
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548125 Med Surg Tele Cooperstown NEW YORK 12 Hour Varied RN/Registered Nurse
548171 Speech Language Redding CALIFORNIA 10 Hour Days RN/Registered Nurse
548159 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548176 Med Surg Tele Syracuse NEW YORK 12 Hour Days RN/Registered Nurse
548181 ICU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548179 Case Manager Falls Church VIRGINIA 8 Hour Days RN/Registered Nurse
548174 Psych Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548187 L&D Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
548186 Oncology SACRAMENTO CALIFORNIA 12 Hour Nights RN/Registered Nurse
548183 Home Health Anaheim CALIFORNIA 8 Hour Days RN/Registered Nurse
548189 Med Surg Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
548193 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548192 Case Manager BAKERSFIELD CALIFORNIA 8 Hour Days RN/Registered Nurse
548188 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
548157 Psych Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548124 Med Surg Tele Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548208 CVICU Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548202 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548197 Med Surg Tele Vacaville CALIFORNIA 12 Hour Days RN/Registered Nurse
548215 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548213 ICU Arlington WASHINGTON 12 Hour Days RN/Registered Nurse
548217 Telemetry New York NEW YORK 12 Hour Days RN/Registered Nurse
548219 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548218 Med Surg Tele Travelers Rest SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
548216 Med Surg Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548227 First Assist Peterborough NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
548229 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548237 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548236 Psych New York NEW YORK 12 Hour Nights RN/Registered Nurse
548232 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548274 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
548276 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548275 MICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548238 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548231 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548288 OR Victorville CALIFORNIA 8 Hour Days RN/Registered Nurse
548290 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548289 OR Brownwood TEXAS 8 Hour Days RN/Registered Nurse
548287 Med Surg Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
548282 ICU Lufkin TEXAS 12 Hour Nights RN/Registered Nurse
548299 OR Arlington VIRGINIA 10 Hour Days RN/Registered Nurse
548297 Neuro Med Surg/Tele Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548292 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548301 ER Oneonta NEW YORK 12 Hour Days RN/Registered Nurse
548307 OR Greenbrae CALIFORNIA 12 Hour Days RN/Registered Nurse
548304 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548300 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548291 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548281 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548313 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548310 ER Memphis TENNESSEE 12 Hour Nights RN/Registered Nurse
548316 OR Jefferson City MISSOURI 10 Hour Days RN/Registered Nurse
548309 ER Abilene TEXAS 12 Hour Day/Night Rotate RN/Registered Nurse
548308 ER Deridder LOUISIANA 12 Hour Nights RN/Registered Nurse
548279 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548194 OR Norman OKLAHOMA 12 Hour Days RN/Registered Nurse
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
535911 Telemetry Lubbock TEXAS 12 Hour Days RN/Registered Nurse
462914 Wound Care Los Alamitos CALIFORNIA 8 Hour Days
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
547961 Psych Brattleboro VERMONT 12 Hour Nights
547526 Med Surg Parkersburg WEST VIRGINIA 12 Hour Nights
496817 Surgical Tech Peterborough NEW HAMPSHIRE 8 Hour Days
504074 Case Manager San Francisco CALIFORNIA 8 Hour Days
547776 ER Morton WASHINGTON Nights
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547917 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
516790 PACU Everett WASHINGTON 12 Hour Days
517294 Surgical Tech Oceanside CALIFORNIA 10 Hour Days
518108 Case Manager Burbank CALIFORNIA 8 Hour Days
542491 Med Surg Brooklyn NEW YORK 12 Hour Nights
547511 Certified Surgical Tech Pittsfield MASSACHUSETTS 8 Hour Days
547700 CVOR Sun City ARIZONA 10 Hour Days
548017 PACU Chico CALIFORNIA 10 Hour Days
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
525929 Nurse Practicioner Brooklyn NEW YORK 8 Hour Days
525987 Supervisor New York NEW YORK 8 Hour Days
525988 Supervisor New York NEW YORK 8 Hour Days
526359 Step Down Orangeburg SOUTH CAROLINA 12 Hour Varied
526713 CT Tech Silver Spring MARYLAND 10 Hour Days
547549 Med Surg Tele Manchester CONNECTICUT 12 Hour Nights
547623 ER Albany OREGON 12 Hour Day/Night Rotate
547717 L&D Bronx NEW YORK 12 Hour Days
547711 ER New York NEW YORK 12 Hour Days
547795 OR Tuba City ARIZONA 10 Hour Days
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
547993 LTAC Torrance CALIFORNIA 8 Hour Evenings
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
547880 CNA Bangor MAINE 12 Hour Nights
531958 Social Worker Falls Church VIRGINIA 8 Hour Days
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
534713 PT Redding CALIFORNIA 8 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.4448 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 a.title desc limit 400,100 in 1.4724 seconds