Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543647 ER Walnut Creek CALIFORNIA 12 Hour Nights
540146 ER Concord CALIFORNIA 12 Hour Nights
546593 ER Brooklyn NEW YORK 12 Hour Nights
547919 ER Des Moines IOWA 12 Hour Days
546366 ER Waterloo IOWA 12 Hour Nights
546105 ER Stafford Springs CONNECTICUT 12 Hour Nights
541312 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
546309 ER Santa Rosa NEW MEXICO 12 Hour Nights
544680 ER Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
546598 ER Saratoga Springs NEW YORK 12 Hour Nights
521297 ER Bethel ALASKA 12 Hour Day/Night Rotate
546620 ER Saratoga Springs NEW YORK 12 Hour Nights
546265 ER Cincinnati OHIO Nights
540311 ER Walnut Creek CALIFORNIA 12 Hour Nights
546165 ER Portland OREGON 12 Hour Nights
546599 ER Saratoga Springs NEW YORK 12 Hour Nights
543122 ER Primghar IOWA 12 Hour Nights
546625 ER Saratoga Springs NEW YORK 12 Hour Days
545239 ER Columbus OHIO Nights
544852 ER San Angelo TEXAS Varied
546695 ER Oceanside CALIFORNIA 12 Hour Nights
540213 ER Concord CALIFORNIA 12 Hour Days
540857 ER Springfield MASSACHUSETTS 12 Hour Days
546937 ER Albany NEW YORK 12 Hour Nights
546927 ER Kaunakakai HAWAII 12 Hour Day/Night Rotate
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
547623 ER Albany OREGON 12 Hour Day/Night Rotate
540277 ER Concord CALIFORNIA 12 Hour Nights
544632 ER Machias MAINE 12 Hour Nights
547550 ER Manchester CONNECTICUT 12 Hour Nights
547059 ER Rome NEW YORK 12 Hour Nights
536558 ER Syracuse NEW YORK 12 Hour Nights RN/Registered Nurse
543649 ER Walnut Creek CALIFORNIA 12 Hour Nights
546761 ER Auburn NEW YORK 12 Hour Nights
544474 ER Hilo HAWAII 12 Hour Nights
543765 ER Bristol PENNSYLVANIA 12 Hour Nights
544908 ER Oceanside CALIFORNIA 12 Hour Nights
546912 ER Goldendale WASHINGTON 12 Hour Days
548167 ER Falls Church VIRGINIA 12 Hour Nights RN/Registered Nurse
547290 ER Norton VIRGINIA 12 Hour Days
546760 ER Auburn NEW YORK 12 Hour Nights
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
546913 ER Des Moines IOWA 12 Hour Days
546868 ER MERCED CALIFORNIA 12 Hour Days
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
543824 ER Lansing MICHIGAN 12 Hour Nights
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546578 ER Brooklyn NEW YORK 12 Hour Nights
546310 ER Santa Rosa NEW MEXICO 12 Hour Nights
546939 ER Albany NEW YORK 12 Hour Nights
546462 ER Des Moines IOWA 12 Hour Days
548003 ER Pittsfield MASSACHUSETTS 12 Hour Nights
546104 ER Stafford Springs CONNECTICUT 12 Hour Nights
546077 ER Paulding OHIO 12 Hour Nights
546709 ER Albany NEW YORK 12 Hour Nights
540198 ER Concord CALIFORNIA 12 Hour Days
545092 ER Portland OREGON 12 Hour Nights
546561 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546461 ER Des Moines IOWA 12 Hour Days
542811 ER Bronx NEW YORK 12 Hour Days
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
539974 ER Philipsburg MONTANA 12 Hour Nights
540201 ER Concord CALIFORNIA 12 Hour Nights
544819 ER Schenectady NEW YORK 12 Hour Nights
546623 ER Saratoga Springs NEW YORK 12 Hour Days
543196 ER Newark NEW JERSEY 12 Hour Days
538394 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
532671 ER Bronx NEW YORK 12 Hour Days
545238 ER Des Moines IOWA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
546925 ER East Norriton PENNSYLVANIA 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
540295 ER Walnut Creek CALIFORNIA 12 Hour Days
540297 ER Concord CALIFORNIA 12 Hour Days
547138 ER Arlington WASHINGTON 12 Hour Nights
540133 ER Concord CALIFORNIA 12 Hour Nights
547930 ER Brownsville TEXAS 12 Hour Nights
547918 ER Des Moines IOWA 12 Hour Nights
547967 ER Madison WISCONSIN 12 Hour Day/Night Rotate
544552 ER Newark NEW JERSEY 12 Hour Nights
546881 ER MERCED CALIFORNIA 12 Hour Nights RN/Registered Nurse
546710 ER Albany NEW YORK 12 Hour Nights
547126 ER Des Moines IOWA 12 Hour Days
547576 ER Watertown NEW YORK 12 Hour Day/Night Rotate
548088 ER Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
547279 ER Muskegon MICHIGAN 12 Hour Nights
540331 ER Concord CALIFORNIA 12 Hour Nights
545240 ER Grove City OHIO 12 Hour Nights
540218 ER Concord CALIFORNIA 12 Hour Nights
544231 ER Denville NEW JERSEY 12 Hour Days
544232 ER Denville NEW JERSEY 12 Hour Day/Night Rotate
547280 ER Muskegon MICHIGAN 12 Hour Nights
547480 ER Manchester CONNECTICUT 12 Hour Nights
546624 ER Saratoga Springs NEW YORK 12 Hour Days
543645 ER Walnut Creek CALIFORNIA 12 Hour Nights
540223 ER Concord CALIFORNIA 12 Hour Days
540859 ER Springfield MASSACHUSETTS 8 Hour Nights
548055 ER Glens Falls NEW YORK 12 Hour Nights RN/Registered Nurse
540883 ER Hartford CONNECTICUT 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.5639 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 400,100 in 1.6529 seconds