Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548134 Med Surg Tele Burien WASHINGTON 12 Hour Nights RN/Registered Nurse
521322 ICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521323 Step Down Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521324 CVICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521325 Oncology Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521326 PICU Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521327 Step Down Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521337 Med Surg Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521340 Med Surg Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
521341 Oncology Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
548130 ER New York NEW YORK 12 Hour Nights RN/Registered Nurse
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
548399 PCU Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548137 Med Surg Modesto CALIFORNIA 12 Hour Nights RN/Registered Nurse
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
548133 Cath Lab Mesa ARIZONA 12 Hour Days RN/Registered Nurse
548125 Med Surg Tele Cooperstown NEW YORK 12 Hour Varied RN/Registered Nurse
548110 Med Surg Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
523478 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
546882 Step Down South Charleston WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
547331 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
548150 NICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
524038 ICU - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
524120 PICU Anchorage ALASKA 12 Hour Nights RN/Registered Nurse
547469 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548146 Med Surg Bakersfield CALIFORNIA 12 Hour Nights RN/Registered Nurse
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
524588 ICU - Per Diem Oceanside CALIFORNIA 12 Hour Days RN/Registered Nurse
548154 Home Health Los Angeles Downey CALIFORNIA 8 Hour Days RN/Registered Nurse
547560 Dialysis Per Diem Brooklyn NEW YORK 10 Hour Evenings RN/Registered Nurse
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548172 PT Red Bluff CALIFORNIA 8 Hour Days RN/Registered Nurse
547723 Med Surg Georgetown SOUTH CAROLINA 12 Hour Days RN/Registered Nurse
548156 Med Surg Weirton WEST VIRGINIA 12 Hour Days RN/Registered Nurse
548149 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548249 Med Surg Pontiac MICHIGAN 12 Hour Days RN/Registered Nurse
548176 Med Surg Tele Syracuse NEW YORK 12 Hour Days RN/Registered Nurse
548159 Med Surg Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548252 ICU - Per Diem Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548170 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548151 L&D Silverdale WASHINGTON 12 Hour Days RN/Registered Nurse
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
525187 CVICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548181 ICU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548182 CCU Pittsfield MASSACHUSETTS 12 Hour Days RN/Registered Nurse
527493 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
548041 PCU Middletown NEW YORK 12 Hour Nights RN/Registered Nurse
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
548186 Oncology SACRAMENTO CALIFORNIA 12 Hour Nights RN/Registered Nurse
526053 RAD Tech Clearwater FLORIDA 8 Hour Days RN/Registered Nurse
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
548191 ER New London NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548189 Med Surg Saratoga Springs NEW YORK 12 Hour Nights RN/Registered Nurse
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days RN/Registered Nurse
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
548141 L&D Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
531765 L&D Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
535911 Telemetry Lubbock TEXAS 12 Hour Days RN/Registered Nurse
548062 L&D Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
548079 PICU Roseville CALIFORNIA 12 Hour Nights RN/Registered Nurse
548072 ER Lansing MICHIGAN 12 Hour Days RN/Registered Nurse
527570 Med Surg Tele Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
538592 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
548082 PCU Torrance CALIFORNIA 12 Hour Days RN/Registered Nurse
548084 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548078 Case Manager Torrance CALIFORNIA 8 Hour Days RN/Registered Nurse
536346 CVOR Lumberton NORTH CAROLINA 8 Hour Days RN/Registered Nurse
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548073 PCU Palm Springs CALIFORNIA 12 Hour Days RN/Registered Nurse
548074 ICU - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548081 ICU Hartford CONNECTICUT 12 Hour Nights RN/Registered Nurse
530725 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
548099 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
543965 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548085 Med Surg Tele Per Diem Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
548104 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548101 PCU Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings RN/Registered Nurse
548103 L&D New York NEW YORK 12 Hour Days 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.3672 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 200,100 in 1.4769 seconds