Listing all records

Displaying records 501 through 600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547776 ER Morton WASHINGTON Nights
543096 Oncology Newark NEW JERSEY 8 Hour Days
542615 Telemetry Terre Haute INDIANA 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
540423 Case Manager Oceanside CALIFORNIA 8 Hour Days
544234 Surgical Tech Denville NEW JERSEY 12 Hour Days
544552 ER Newark NEW JERSEY 12 Hour Nights
544225 Med Surg Dover NEW JERSEY 12 Hour Nights
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
540179 Case Manager Concord CALIFORNIA 12 Hour Days
545468 ICU Tuba City ARIZONA 12 Hour Day/Night Rotate
546621 ER Saratoga Springs NEW YORK 12 Hour Nights
546591 MICU Brooklyn NEW YORK 12 Hour Days
547297 Med Surg Tele Denison IOWA 12 Hour Nights
547060 L&D Pittsfield MASSACHUSETTS 12 Hour Days
546096 ICU Hilo HAWAII 12 Hour Days
540001 ER Walnut Creek CALIFORNIA 12 Hour Days
527987 Case Manager Albuquerque NEW MEXICO 10 Hour Days
527995 Oncology Albany NEW YORK 12 Hour Nights
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547961 Psych Brattleboro VERMONT 12 Hour Nights
547917 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547880 CNA Bangor MAINE 12 Hour Nights
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
547711 ER New York NEW YORK 12 Hour Days
547623 ER Albany OREGON 12 Hour Day/Night Rotate
540498 Pediatric ER New York NEW YORK 12 Hour Nights
529983 CCU Newark NEW JERSEY 12 Hour Nights
531958 Social Worker Falls Church VIRGINIA 8 Hour Days
541550 PT Apple Valley CALIFORNIA 8 Hour Days
534713 PT Redding CALIFORNIA 8 Hour Days
535099 Radiology Bronx NEW YORK 12 Hour Days
540824 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540482 OR New York NEW YORK 12 Hour Nights
542137 Med Surg Brooklyn NEW YORK 12 Hour Nights
542838 Case Manager Eureka CALIFORNIA 8 Hour Days
541734 Med Surg Brooklyn NEW YORK 12 Hour Evenings
543370 Surgical Tech Silver Spring MARYLAND Nights
544223 Surgical Tech Passaic NEW JERSEY 12 Hour Days
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
545020 OR Clarkston WASHINGTON 10 Hour Varied
544735 Surgical Tech MERCED CALIFORNIA 12 Hour Days
544145 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
538625 Med Surg Brooklyn NEW YORK 12 Hour Days
545328 CNA Salem OREGON 12 Hour Nights
546326 Social Worker Ketchum IDAHO 8 Hour Days
545288 Step Down South Charleston WEST VIRGINIA 12 Hour Nights
546639 Cardiac ICU Falls Church VIRGINIA 12 Hour Day/Night Rotate
546411 ICU Ogdensburg NEW YORK 12 Hour Nights
536589 OR New York NEW YORK 12 Hour Nights
536590 OR New York NEW YORK 12 Hour Nights
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
546692 Med Surg Oceanside CALIFORNIA 12 Hour Days
547383 L&D Seattle WASHINGTON 12 Hour Nights
536775 RAD Tech San Francisco CALIFORNIA 8 Hour Day/Night Rotate
547035 Med Surg Tele Auburn NEW YORK 12 Hour Nights
547526 Med Surg Parkersburg WEST VIRGINIA 12 Hour Nights
547511 Certified Surgical Tech Pittsfield MASSACHUSETTS 8 Hour Days
547415 Ambulatory Bronx NEW YORK 8 Hour Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
538624 ER New York NEW YORK 12 Hour Nights
547729 PCU Mesa ARIZONA 12 Hour Days
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547993 LTAC Torrance CALIFORNIA 8 Hour Evenings
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
537445 CNA Brooklyn NEW YORK 8 Hour Nights
537446 CNA Brooklyn NEW YORK 8 Hour Days
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
548017 PACU Chico CALIFORNIA 10 Hour Days
537741 Psych New York NEW YORK 12 Hour Days
547549 Med Surg Tele Manchester CONNECTICUT 12 Hour Nights
538546 OR Falls Church VIRGINIA 12 Hour Nights
505339 PTA San Jose CALIFORNIA Days
505340 PT San Jose CALIFORNIA Days
541929 Management Corvallis OREGON 12 Hour Day/Night Rotate
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
526144 Therapy Rehab Baltimore MARYLAND Days
526268 Interventional Radiology Tech Fresno CALIFORNIA 12 Hour Days
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
526356 Telemetry Boise IDAHO 12 Hour Nights
526368 COTA Colfax WISCONSIN Days
535231 Cath Lab Sioux City IOWA 8 Hour Days
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
535268 COTA San Andreas CALIFORNIA Days
535269 COTA San Andreas CALIFORNIA Days
535270 PTA Modesto CALIFORNIA Days
535271 PTA Modesto CALIFORNIA Days
535302 MLT Pittsfield MASSACHUSETTS 8 Hour Days
535334 SLP Pasco WASHINGTON 12 Hour Day/Night Rotate
535387 Rehab Clive IOWA 12 Hour Nights
535418 Respiratory Therapist Mason City IOWA 12 Hour Days
535463 ICU Sioux City IOWA 12 Hour Nights
535465 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
535536 CNA Cincinnati OHIO 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.5548 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 500,100 in 1.5733 seconds