Listing all records

Displaying records 2701 through 2800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546597 Med Surg Saratoga Springs NEW YORK 12 Hour Nights
546598 ER Saratoga Springs NEW YORK 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
547812 ICU Woonsocket RHODE ISLAND 12 Hour Nights
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
546621 ER Saratoga Springs NEW YORK 12 Hour Nights
546635 ER Des Moines IOWA 12 Hour Nights
547611 PICU Santa Clara CALIFORNIA 12 Hour Nights
548146 Med Surg Bakersfield CALIFORNIA 12 Hour Nights RN/Registered Nurse
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548400 ER Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
546683 PCU Birmingham ALABAMA 12 Hour Nights
546686 PCU San Luis Obispo CALIFORNIA 12 Hour Nights
546688 L&D San Antonio TEXAS 12 Hour Nights
546695 ER Oceanside CALIFORNIA 12 Hour Nights
546698 ICU East Norriton PENNSYLVANIA 12 Hour Nights
547088 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
546705 Med Surg Albany NEW YORK 12 Hour Nights
546706 Med Surg Albany NEW YORK 12 Hour Nights
546707 Med Surg Albany NEW YORK 12 Hour Nights
546708 ICU Albany NEW YORK 12 Hour Nights
546709 ER Albany NEW YORK 12 Hour Nights
546710 ER Albany NEW YORK 12 Hour Nights
546717 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546718 PCU Centralia WASHINGTON 12 Hour Nights
546720 Med Surg Tele Olympia WASHINGTON 12 Hour Nights
546722 Med Surg Olympia WASHINGTON 12 Hour Nights
546724 Oncology Everett WASHINGTON 12 Hour Nights
546725 Telemetry Everett WASHINGTON 12 Hour Nights
546727 Telemetry Everett WASHINGTON 12 Hour Nights
546728 Intermediate Care Everett WASHINGTON 12 Hour Nights
546729 Telemetry Everett WASHINGTON 12 Hour Nights
546730 Telemetry Everett WASHINGTON 12 Hour Nights
546731 Telemetry Everett WASHINGTON 12 Hour Nights
546732 Telemetry Everett WASHINGTON 12 Hour Nights
546733 Telemetry Everett WASHINGTON 12 Hour Nights
546735 Telemetry Santa Monica CALIFORNIA 12 Hour Nights
546737 Med Surg Tele Cleveland OHIO 12 Hour Nights
546739 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546740 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
546744 PCU Charleston WEST VIRGINIA 12 Hour Nights
546750 Med Surg Charlottesville VIRGINIA 12 Hour Nights
547846 Step Down Centralia WASHINGTON 12 Hour Nights
546760 ER Auburn NEW YORK 12 Hour Nights
546761 ER Auburn NEW YORK 12 Hour Nights
547848 CNA Portland OREGON 12 Hour Nights
547331 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546768 Med Surg IOWA CITY IOWA 12 Hour Nights
546781 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
547614 PICU Santa Clara CALIFORNIA 12 Hour Nights
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
546788 Long Term Care Westminster COLORADO 12 Hour Nights
547087 Med Surg Pendleton OREGON 12 Hour Nights
548180 Pediatric ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
546795 MLT Estes Park COLORADO 12 Hour Nights
546802 NICU Walnut Creek CALIFORNIA 12 Hour Nights
547077 CT Tech Farmington CONNECTICUT 12 Hour Nights
546812 Med Surg Harrison ARKANSAS 12 Hour Nights
546813 Clinic Cleveland OHIO 12 Hour Nights
546819 Med Surg Tele Canton OHIO 12 Hour Nights
546833 Med Surg Ogdensburg NEW YORK 12 Hour Nights
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
546845 Med Surg Peoria ILLINOIS 12 Hour Nights
547853 Med Surg Valdosta GEORGIA 12 Hour Nights
546859 Telemetry Everett WASHINGTON 12 Hour Nights
548190 Psych Lewiston MAINE 12 Hour Nights RN/Registered Nurse
547046 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
548189 Med Surg Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
548187 L&D Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
546874 Med Surg Tele Greensboro NORTH CAROLINA 12 Hour Nights
546880 Med Surg Show Low ARIZONA 12 Hour Nights RN/Registered Nurse
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546898 Telemetry Cleveland OHIO 12 Hour Nights
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
546902 Telemetry Cleveland OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour Nights
546904 Telemetry Cleveland OHIO 12 Hour Nights
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546908 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546915 Med Surg Hilo HAWAII 12 Hour Nights
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546919 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546920 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546923 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
546926 MICU San Dimas CALIFORNIA 12 Hour Nights
546928 Med Surg Tele Mt. Vernon WASHINGTON 12 Hour Nights
546934 RAD Tech Dubuque IOWA 12 Hour Nights
546937 ER Albany NEW YORK 12 Hour Nights
546938 ER Albany NEW YORK 12 Hour Nights
546939 ER Albany NEW YORK 12 Hour Nights
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546943 Med Surg Tele Cleveland OHIO 12 Hour Nights
546946 CT Tech Brattleboro VERMONT 12 Hour Nights
546951 Surgical Tech Long Beach CALIFORNIA 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.4852 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.shift asc limit 2700,100 in 1.4033 seconds