Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548235 ER Greensboro NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
548274 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
543824 ER Lansing MICHIGAN 12 Hour Nights
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
548094 ER ODESSA TEXAS 12 Hour Nights RN/Registered Nurse
548072 ER Lansing MICHIGAN 12 Hour Days RN/Registered Nurse
544230 ER Denville NEW JERSEY 12 Hour Nights
544231 ER Denville NEW JERSEY 12 Hour Days
544232 ER Denville NEW JERSEY 12 Hour Day/Night Rotate
548311 ER Dallas TEXAS 12 Hour Nights RN/Registered Nurse
548310 ER Memphis TENNESSEE 12 Hour Nights RN/Registered Nurse
548308 ER Deridder LOUISIANA 12 Hour Nights RN/Registered Nurse
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
544435 ER IOWA CITY IOWA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
544437 ER IOWA CITY IOWA 12 Hour Days
544474 ER Hilo HAWAII 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
548106 ER Cobleskill NEW YORK 12 Hour Nights RN/Registered Nurse
544632 ER Machias MAINE 12 Hour Nights
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
544705 ER Des Moines IOWA 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
544819 ER Schenectady NEW YORK 12 Hour Nights
544852 ER San Angelo TEXAS Varied
544890 ER Concord CALIFORNIA 12 Hour Days
544908 ER Oceanside CALIFORNIA 12 Hour Nights
548341 ER BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548340 ER Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
545058 ER Dickinson NORTH DAKOTA 12 Hour Day/Night Rotate
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
545080 ER Pueblo COLORADO 12 Hour Nights
545092 ER Portland OREGON 12 Hour Nights
545096 ER Burbank CALIFORNIA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
545238 ER Des Moines IOWA 12 Hour Nights
545239 ER Columbus OHIO Nights
545240 ER Grove City OHIO 12 Hour Nights
548112 ER Rome NEW YORK 12 Hour Nights RN/Registered Nurse
545422 ER Springfield MASSACHUSETTS 8 Hour Nights
545452 ER Bristol PENNSYLVANIA 12 Hour Nights
545453 ER Lynwood CALIFORNIA 12 Hour Nights
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546309 ER Santa Rosa NEW MEXICO 12 Hour Nights
546331 ER Centerville IOWA 12 Hour Days
546366 ER Waterloo IOWA 12 Hour Nights
546461 ER Des Moines IOWA 12 Hour Days
546462 ER Des Moines IOWA 12 Hour Days
546561 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546578 ER Brooklyn NEW YORK 12 Hour Nights
546593 ER Brooklyn NEW YORK 12 Hour Nights
546598 ER Saratoga Springs NEW YORK 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
546621 ER Saratoga Springs NEW YORK 12 Hour Nights
546622 ER Saratoga Springs NEW YORK 12 Hour Days
546623 ER Saratoga Springs NEW YORK 12 Hour Days
546624 ER Saratoga Springs NEW YORK 12 Hour Days
546625 ER Saratoga Springs NEW YORK 12 Hour Days
546635 ER Des Moines IOWA 12 Hour Nights
548400 ER Albany NEW YORK 12 Hour Nights RN/Registered Nurse
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
546695 ER Oceanside CALIFORNIA 12 Hour Nights
546709 ER Albany NEW YORK 12 Hour Nights
546710 ER Albany NEW YORK 12 Hour Nights
548191 ER New London NEW HAMPSHIRE 12 Hour Nights RN/Registered Nurse
546760 ER Auburn NEW YORK 12 Hour Nights
546761 ER Auburn NEW YORK 12 Hour Nights
546868 ER MERCED CALIFORNIA 12 Hour Days
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
546912 ER Goldendale WASHINGTON 12 Hour Days
546913 ER Des Moines IOWA 12 Hour Days
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
546937 ER Albany NEW YORK 12 Hour Nights
546938 ER Albany NEW YORK 12 Hour Nights
546939 ER Albany NEW YORK 12 Hour Nights
547126 ER Des Moines IOWA 12 Hour Days
547138 ER Arlington WASHINGTON 12 Hour Nights
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
548055 ER Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
547279 ER Muskegon MICHIGAN 12 Hour Nights
547280 ER Muskegon MICHIGAN 12 Hour Nights
547289 ER CORDOVA ALASKA 12 Hour Nights
547290 ER Norton VIRGINIA 12 Hour Days
547480 ER Manchester CONNECTICUT 12 Hour Nights
547481 ER Manchester CONNECTICUT 12 Hour Nights
547550 ER Manchester CONNECTICUT 12 Hour Nights
547566 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
547623 ER Albany OREGON 12 Hour Day/Night Rotate
547711 ER New York NEW YORK 12 Hour Days
547776 ER Morton WASHINGTON Nights
547805 ER Cleveland OHIO 12 Hour Day/Night Rotate
547914 ER Estes Park COLORADO 12 Hour Nights
547918 ER Des Moines IOWA 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.7185 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 3200,100 in 1.5649 seconds