Listing all records

Displaying records 2101 through 2200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547709 Pediatrics Alturas CALIFORNIA 12 Hour Day/Night Rotate
546276 Pediatrics Sitka ALASKA Varied
540326 Pediatrics Walnut Creek CALIFORNIA 12 Hour Days
547794 Pediatrics Valley City NORTH DAKOTA Nights
547561 Pediatrics Fort Defiance ARIZONA 12 Hour Day/Night Rotate
546784 Pediatrics Gardner MASSACHUSETTS 12 Hour Nights
545966 Pediatrics Gainesville FLORIDA 12 Hour Nights
547497 Pediatrics Hilo HAWAII 12 Hour Nights
548004 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
547136 Pediatrics Quincy CALIFORNIA Nights
546228 Pediatrics Concord NEW HAMPSHIRE 12 Hour Nights
545992 Pediatrics King City CALIFORNIA 12 Hour Nights
547088 Pediatrics Pittsfield MASSACHUSETTS 12 Hour Nights
541847 Psych Peoria ILLINOIS 8 Hour Days RN/Registered Nurse
535905 Psych Concord CALIFORNIA 8 Hour Nights
548190 Psych Lewiston MAINE 12 Hour Nights RN/Registered Nurse
534694 Psych Woodsville NEW HAMPSHIRE 12 Hour Day/Night Rotate
548214 Psych Peoria ILLINOIS 12 Hour Evenings RN/Registered Nurse
537741 Psych New York NEW YORK 12 Hour Days
548354 Psych National City CALIFORNIA 12 Hour Nights RN/Registered Nurse
538936 Psych Boise IDAHO 12 Hour Nights
548323 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548369 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
540051 Psych Concord CALIFORNIA 8 Hour Evenings
540052 Psych Concord CALIFORNIA 8 Hour Evenings
540085 Psych Concord CALIFORNIA 8 Hour Evenings
548170 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
540177 Psych Concord CALIFORNIA 8 Hour Evenings
548174 Psych Bronx NEW YORK 12 Hour Days RN/Registered Nurse
540232 Psych Concord CALIFORNIA 8 Hour Nights
541039 Psych Concord CALIFORNIA 8 Hour Nights
548339 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548234 Psych Centreville ILLINOIS 12 Hour Nights RN/Registered Nurse
548236 Psych New York NEW YORK 12 Hour Nights RN/Registered Nurse
548304 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings RN/Registered Nurse
547961 Psych Brattleboro VERMONT 12 Hour Nights
543890 Psych National City CALIFORNIA 12 Hour Nights
543891 Psych National City CALIFORNIA 12 Hour Days
546940 Psych Kealakekua HAWAII 12 Hour Day/Night Rotate
548063 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
548069 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
544535 Psych Fort Defiance ARIZONA 12 Hour Varied
544628 Psych Cleveland OHIO 12 Hour Nights
548157 Psych Cooperstown NEW YORK 12 Hour Nights RN/Registered Nurse
546335 Psych Wailuku HAWAII 12 Hour Nights
548184 Psych Salem MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
548223 Psych Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
547670 Psych Nashua NEW HAMPSHIRE 12 Hour Nights
548219 Psych New York NEW YORK 12 Hour Days RN/Registered Nurse
543784 GI Lab Woonsocket RHODE ISLAND 8 Hour Days
545252 GI Lab Mason City IOWA 8 Hour Days
518165 Endoscopy IOWA CITY IOWA Days
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
546793 Endoscopy Mt. Vernon WASHINGTON 10 Hour Day/Night Rotate
546860 Endoscopy Jefferson City MISSOURI 8 Hour Days
465120 Long Term Care Conrad MONTANA 8 Hour Evenings
487151 Long Term Care Conrad MONTANA 12 Hour Day/Night Rotate
490405 Long Term Care Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
492265 Long Term Care Scottsbluff NEBRASKA Nights
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
546205 Long Term Care Watertown NEW YORK 12 Hour Day/Night Rotate
546233 Long Term Care Watertown NEW YORK 8 Hour Evenings
531433 Long Term Care Marion VIRGINIA Nights
532051 Long Term Care Nome ALASKA 12 Hour Day/Night Rotate
533310 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
533322 Long Term Care Lewiston MAINE 12 Hour Nights
536159 Long Term Care Honakaa HAWAII 8 Hour Day/Night Rotate
547818 Long Term Care Lowville NEW YORK 12 Hour Days
538064 Long Term Care Alturas CALIFORNIA 12 Hour Day/Night Rotate
538527 Long Term Care Rochdale MASSACHUSETTS 12 Hour Days
538553 Long Term Care Lewiston MAINE 12 Hour Days
538581 Long Term Care Canton NEW YORK 12 Hour Varied
539660 Long Term Care Greeneville TENNESSEE 12 Hour Nights
539703 Long Term Care Kingsport TENNESSEE 12 Hour Nights
547465 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Evenings
547462 Long Term Care Claremont NEW HAMPSHIRE 8 Hour Days
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
540802 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
547819 Long Term Care Lowville NEW YORK 12 Hour Days
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
542501 Long Term Care Sitka ALASKA 8 Hour Evenings
547680 Long Term Care Brantwood NORTH CAROLINA 12 Hour Nights
543032 Long Term Care Lowville NEW YORK 12 Hour Nights
546788 Long Term Care Westminster COLORADO 12 Hour Nights
548014 Long Term Care Kane PENNSYLVANIA 12 Hour Nights
544149 Long Term Care Moscow IDAHO 12 Hour Nights
547027 Long Term Care Claremont NEW HAMPSHIRE 12 Hour Nights
545098 Long Term Care Portland OREGON 12 Hour Days
545985 Long Term Care Oneonta NEW YORK 8 Hour Nights
545989 Long Term Care King City CALIFORNIA 12 Hour Nights
545988 Long Term Care King City CALIFORNIA 12 Hour Days
547424 Long Term Care GRAND MARAIS MINNESOTA 8 Hour Nights
541886 Rehab Chesterfield MONTANA 12 Hour Days
547656 Rehab Omaha NEBRASKA 12 Hour Days
535387 Rehab Clive IOWA 12 Hour Nights
535638 Rehab Cape Girardeau MISSOURI Nights
547446 Rehab Seguin TEXAS 12 Hour Days
547452 Rehab Abilene TEXAS 12 Hour Day/Night Rotate
543598 Rehab Twin Falls IDAHO 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.6986 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 asc limit 2100,100 in 1.5389 seconds