Listing all records

Displaying records 3601 through 3700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545760 ICU Gainesville FLORIDA 12 Hour Nights
545764 ICU Gainesville FLORIDA 12 Hour Nights
545781 ICU Gainesville FLORIDA 12 Hour Nights
545786 ICU Gainesville FLORIDA 12 Hour Days
545793 ICU Gainesville FLORIDA 12 Hour Nights
545812 ICU Gainesville FLORIDA 12 Hour Nights
545831 ICU Gainesville FLORIDA 12 Hour Days
545832 ICU Gainesville FLORIDA 12 Hour Nights
545836 ICU Gainesville FLORIDA 12 Hour Nights
545842 ICU Gainesville FLORIDA 12 Hour Nights
545843 ICU Gainesville FLORIDA 12 Hour Days
545851 ICU Gainesville FLORIDA 12 Hour Nights
545864 ICU Gainesville FLORIDA 12 Hour Nights
545886 ICU Gainesville FLORIDA 12 Hour Days
545894 ICU Gainesville FLORIDA 12 Hour Nights
545895 ICU Gainesville FLORIDA 12 Hour Nights
545896 ICU Gainesville FLORIDA 12 Hour Days
545902 ICU Gainesville FLORIDA 12 Hour Days
545909 ICU Gainesville FLORIDA 12 Hour Nights
545910 ICU Gainesville FLORIDA 12 Hour Nights
545911 ICU Gainesville FLORIDA 12 Hour Nights
545912 ICU Gainesville FLORIDA 12 Hour Nights
545913 ICU Gainesville FLORIDA 12 Hour Nights
545934 ICU Gainesville FLORIDA 12 Hour Nights
545944 ICU Issaquah WASHINGTON 12 Hour Days
545962 ICU Gainesville FLORIDA 12 Hour Days
545975 ICU Gainesville FLORIDA 12 Hour Nights
545982 ICU Gainesville FLORIDA 12 Hour Nights
545984 ICU Gainesville FLORIDA 12 Hour Nights
546096 ICU Hilo HAWAII 12 Hour Days
546223 ICU Ann Arbor MICHIGAN 12 Hour Nights
546410 ICU Ogdensburg NEW YORK 12 Hour Nights
546411 ICU Ogdensburg NEW YORK 12 Hour Nights
546470 ICU East Norriton PENNSYLVANIA 12 Hour Days
546566 ICU Brooklyn NEW YORK 12 Hour Days
546567 ICU Brooklyn NEW YORK 12 Hour Days
546570 ICU Brooklyn NEW YORK 12 Hour Nights
546577 ICU Brooklyn NEW YORK 12 Hour Nights
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
546698 ICU East Norriton PENNSYLVANIA 12 Hour Nights
546708 ICU Albany NEW YORK 12 Hour Nights
547026 ICU Santa Fe NEW MEXICO 12 Hour Day/Night Rotate
547084 ICU Pendleton OREGON 12 Hour Nights
547085 ICU Pendleton OREGON 12 Hour Nights
547258 ICU Portland OREGON 12 Hour Nights
547259 ICU Portland OREGON 12 Hour Nights
547260 ICU Portland OREGON 12 Hour Nights
547281 ICU Muskegon MICHIGAN 12 Hour Nights
547282 ICU Muskegon MICHIGAN 12 Hour Nights
547318 ICU Meridian IDAHO 12 Hour Nights
547427 ICU York MAINE 12 Hour Nights
547454 ICU Abilene TEXAS 12 Hour Day/Night Rotate
547457 ICU Abilene TEXAS 12 Hour Nights
547575 ICU Lewiston MAINE 12 Hour Days
547593 ICU Newton IOWA 12 Hour Nights
547603 ICU Issaquah WASHINGTON 12 Hour Days
547664 ICU Oceanside CALIFORNIA 12 Hour Nights
547668 ICU Laconia NEW HAMPSHIRE Nights
547676 ICU Lowville NEW YORK 12 Hour Nights
547707 ICU North Platte NEBRASKA Nights
547793 ICU Bozeman MONTANA 12 Hour Day/Night Rotate
547812 ICU Woonsocket RHODE ISLAND 12 Hour Nights
547882 ICU Johnson City TENNESSEE 12 Hour Nights
548251 ICU Seattle WASHINGTON 12 Hour Days RN/Registered Nurse
547905 ICU Greeley COLORADO 12 Hour Nights
547906 ICU Sun City ARIZONA 12 Hour Nights
547924 ICU Boise IDAHO 12 Hour Nights
547925 ICU Boise IDAHO 12 Hour Nights
547977 ICU Memphis TENNESSEE 12 Hour Nights
548165 ICU San Jose CALIFORNIA 12 Hour Nights RN/Registered Nurse
548002 ICU Gillette WYOMING 12 Hour Day/Night Rotate
548025 ICU Portland OREGON 12 Hour Nights
548034 ICU Newton IOWA 12 Hour Nights
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
548066 ICU Bellefontaine OHIO 12 Hour Nights RN/Registered Nurse
548081 ICU Hartford CONNECTICUT 12 Hour Nights RN/Registered Nurse
548116 ICU Plymouth NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
548127 ICU Glens Falls NEW YORK 12 Hour Days RN/Registered Nurse
548136 ICU Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
548152 ICU Newark NEW JERSEY 12 Hour Days RN/Registered Nurse
548177 ICU Rancho Cordova CALIFORNIA 12 Hour Nights RN/Registered Nurse
548181 ICU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548213 ICU Arlington WASHINGTON 12 Hour Days RN/Registered Nurse
548229 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548231 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548237 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548281 ICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
548282 ICU Lufkin TEXAS 12 Hour Nights RN/Registered Nurse
548300 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548319 ICU Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548324 ICU Amsterdam NEW YORK 12 Hour Nights RN/Registered Nurse
548327 ICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548331 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
548333 ICU Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548338 ICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
548366 ICU Anaheim CALIFORNIA 12 Hour Days RN/Registered Nurse
548368 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
548375 ICU Chicago ILLINOIS 12 Hour Nights RN/Registered Nurse
548391 ICU Merced CALIFORNIA 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.6284 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.specialty desc limit 3600,100 in 1.5316 seconds