Listing all records

Displaying records 1101 through 1200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
543461 Oncology Kingsport TENNESSEE 12 Hour Nights
542636 Oncology Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
546270 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
547295 Oncology Coos Bay OREGON 10 Hour Days
541078 Oncology Des Moines IOWA 12 Hour Nights
542670 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
543820 Oncology Bristol TENNESSEE 12 Hour Nights
541769 Oncology Pueblo COLORADO 12 Hour Days
521325 Oncology Oklahoma City OKLAHOMA 12 Hour Days RN/Registered Nurse
521341 Oncology Oklahoma City OKLAHOMA 12 Hour Nights RN/Registered Nurse
543696 Oncology Bristol TENNESSEE 12 Hour Days
544678 Oncology Midland TEXAS Nights
543041 Oncology Janesville WISCONSIN Varied
527995 Oncology Albany NEW YORK 12 Hour Nights
546260 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546271 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
548186 Oncology SACRAMENTO CALIFORNIA 12 Hour Nights RN/Registered Nurse
543096 Oncology Newark NEW JERSEY 8 Hour Days
532920 Oncology San Angelo TEXAS Days
546415 Oncology York PENNSYLVANIA Varied
547860 Oncology Charlottesville VIRGINIA 10 Hour Days
547810 Oncology Milford MASSACHUSETTS 12 Hour Nights
534249 Oncology Cleveland OHIO 12 Hour Days
534250 Oncology Cleveland OHIO 12 Hour Nights
535045 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
548313 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548330 Oncology Newark NEW JERSEY 8 Hour Days RN/Registered Nurse
548329 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
546380 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
539087 Oncology Duluth MINNESOTA 12 Hour Day/Night Rotate
539320 Oncology York PENNSYLVANIA 12 Hour Day/Night Rotate
539713 Oncology Des Moines IOWA 12 Hour Nights
539714 Oncology Des Moines IOWA 12 Hour Nights
542669 Oncology Madison WISCONSIN 12 Hour Day/Night Rotate
544788 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
546763 Oncology Oklahoma City OKLAHOMA 12 Hour Days
546908 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
546781 Oncology Oklahoma City OKLAHOMA 12 Hour Nights
548314 Oncology Falls Church VIRGINIA 12 Hour Varied RN/Registered Nurse
548312 Oncology Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
546724 Oncology Everett WASHINGTON 12 Hour Nights
547008 Oncology Everett WASHINGTON 12 Hour Nights
548335 Oncology Albany NEW YORK 12 Hour Nights RN/Registered Nurse
544219 Oncology Newark NEW JERSEY 12 Hour Days
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
543044 Oncology Cleveland OHIO 12 Hour Day/Night Rotate
546259 Oncology Oklahoma City OKLAHOMA 12 Hour Days
509928 NICU Brooklyn NEW YORK 12 Hour Nights
548150 NICU Bronx NEW YORK 12 Hour Days RN/Registered Nurse
543308 NICU Walnut Creek CALIFORNIA 12 Hour Days
541845 NICU Walnut Creek CALIFORNIA 12 Hour Nights
547235 NICU Brooklyn NEW YORK 12 Hour Days
547569 NICU Lynwood CALIFORNIA 12 Hour Nights
547467 NICU Walnut Creek CALIFORNIA 12 Hour Days
547750 NICU Brooklyn NEW YORK 12 Hour Nights
547751 NICU Brooklyn NEW YORK 12 Hour Nights
547072 NICU Walnut Creek CALIFORNIA 12 Hour Days
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
546565 NICU Brooklyn NEW YORK 12 Hour Nights
547466 NICU Des Moines IOWA 12 Hour Nights
546568 NICU Brooklyn NEW YORK 12 Hour Days
543872 NICU Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546575 NICU Brooklyn NEW YORK 12 Hour Nights
547073 NICU Walnut Creek CALIFORNIA 12 Hour Days
547329 NICU Mission Hills CALIFORNIA 12 Hour Nights
547414 NICU Bronx NEW YORK 8 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
546802 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540008 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540031 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540066 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540067 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540068 NICU Walnut Creek CALIFORNIA 12 Hour Days
540069 NICU Walnut Creek CALIFORNIA 12 Hour Days
540074 NICU Walnut Creek CALIFORNIA 12 Hour Nights
544706 NICU Des Moines IOWA 12 Hour Days
540138 NICU Walnut Creek CALIFORNIA 12 Hour Days
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
548053 NICU New York NEW YORK 12 Hour Days RN/Registered Nurse
540209 NICU Walnut Creek CALIFORNIA 12 Hour Days
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540252 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540254 NICU Walnut Creek CALIFORNIA 12 Hour Days
540257 NICU Walnut Creek CALIFORNIA 12 Hour Days
540269 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540284 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540290 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540296 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540303 NICU Walnut Creek CALIFORNIA 12 Hour Nights
548056 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548351 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548089 NICU Tucson ARIZONA 12 Hour Nights RN/Registered Nurse
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
540814 NICU Lynwood CALIFORNIA 12 Hour Nights
545427 NICU Mishawaka INDIANA 12 Hour Nights
543755 NICU Lynwood CALIFORNIA 12 Hour Nights
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
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.5666 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 1100,100 in 1.5062 seconds