Listing all records

Displaying records 2801 through 2900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548381 Med Surg Tele Prescott ARIZONA 12 Hour Nights RN/Registered Nurse
545625 Telemetry Prescott Valley ARIZONA 12 Hour Nights
545626 Telemetry Prescott Valley ARIZONA 12 Hour Day/Night Rotate
543122 ER Primghar IOWA 12 Hour Nights
543123 ER Primghar IOWA 12 Hour Nights
546010 Med Surg Prince Frederick MARYLAND 12 Hour Nights
547471 Med Surg Prince Frederick MARYLAND 12 Hour Nights
548160 Med Surg Prince Frederick MARYLAND 12 Hour Nights RN/Registered Nurse
548126 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
546958 Med Surg Tele Princeton WEST VIRGINIA 12 Hour Nights
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
547431 L&D Pueblo COLORADO 12 Hour Nights
547499 Cath Lab Pueblo COLORADO 10 Hour Varied
547792 Scrub Tech Pueblo COLORADO 12 Hour Day/Night Rotate
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
545080 ER Pueblo COLORADO 12 Hour Nights
541769 Oncology Pueblo COLORADO 12 Hour Days
539294 Radiology Queens NEW YORK 8 Hour Days
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
546619 Acute Care Queens NEW YORK 8 Hour Days
547713 Med Surg Queens NEW YORK 12 Hour Nights
547714 Med Surg Queens NEW YORK 12 Hour Nights
547719 Med Surg Queens NEW YORK 12 Hour Days
547754 Med Surg Queens NEW YORK 12 Hour Days
548407 OR Queens NEW YORK 12 Hour Days RN/Registered Nurse
535095 LPN/LVN Quincy CALIFORNIA Varied
547136 Pediatrics Quincy CALIFORNIA Nights
547323 Med Surg Tele Raeford NORTH CAROLINA 12 Hour Nights
524151 PTA Ramsey NEW JERSEY Days
531489 PT Ramsey NEW JERSEY Days
548048 LPN/LVN Rancho Cordova CALIFORNIA 12 Hour Nights LVN
548177 ICU Rancho Cordova CALIFORNIA 12 Hour Nights RN/Registered Nurse
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
534504 PT Raritan NEW JERSEY Days
548172 PT Red Bluff CALIFORNIA 8 Hour Days RN/Registered Nurse
548101 PCU Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548110 Med Surg Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
548171 Speech Language Redding CALIFORNIA 10 Hour Days RN/Registered Nurse
548178 Speech Language Redding CALIFORNIA 10 Hour Days SLP/Speech Language Pathologist
548181 ICU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548212 CCU Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548284 CVOR Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
548297 Neuro Med Surg/Tele Redding CALIFORNIA 12 Hour Nights RN/Registered Nurse
534713 PT Redding CALIFORNIA 8 Hour Days
543781 OR Redding CALIFORNIA 8 Hour Days
543783 RAD Tech Redding CALIFORNIA 8 Hour Days
543785 Scrub Tech Redding CALIFORNIA 12 Hour Day/Night Rotate
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
547119 RAD Tech REDWOOD CITY CALIFORNIA 8 Hour Days
546697 Surgical Tech Reno NEVADA 12 Hour Days
543750 CLS Reno NEVADA 12 Hour Day/Night Rotate
544240 RAD Tech Reno NEVADA 12 Hour Days
544241 RAD Tech Reno NEVADA 12 Hour Days
544242 CT Tech Reno NEVADA 12 Hour Nights
544243 CT Tech Reno NEVADA 12 Hour Nights
544245 CVOR Reno NEVADA 12 Hour Day/Night Rotate
545237 Surgical Tech CVOR Reno NEVADA 10 Hour Days
530463 PT Republic WASHINGTON Days
545915 RAD Tech Richland WASHINGTON 12 Hour Day/Night Rotate
545569 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545570 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545571 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545572 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
545591 RAD Tech Richmond VIRGINIA 8 Hour Days
545592 RAD Tech Richmond VIRGINIA 8 Hour Days
545599 RAD Tech Richmond VIRGINIA 8 Hour Days
545600 RAD Tech Richmond VIRGINIA 8 Hour Day/Night Rotate
525604 RAD Tech Richmond VIRGINIA 12 Hour Days Radiology Techs/Technologists
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
547066 PCU Rio Rancho NEW MEXICO 12 Hour Nights
547556 CT Tech Ritzville WASHINGTON 8 Hour Days
544543 CT Tech Riverhead NEW YORK 10 Hour Nights
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
546787 CT Tech Robinson ILLINOIS 8 Hour Evenings
538527 Long Term Care Rochdale MASSACHUSETTS 12 Hour Days
546358 Cardiac ICU Rock Hill SOUTH CAROLINA 12 Hour Nights
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
543252 Telemetry Rock Hill SOUTH CAROLINA 12 Hour Nights
535651 COTA Rock Rapids IOWA Days
543903 Adult Care Rockaway Park NEW YORK 8 Hour Days
540706 Cardiac ICU Rockford ILLINOIS 12 Hour Nights
542451 ER Rockford ILLINOIS 12 Hour Nights
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
545411 RAD Tech Rockville MARYLAND 8 Hour Days
548224 ER Rockville MARYLAND 12 Hour Nights RN/Registered Nurse
507079 PT Rockville MARYLAND Days
511666 PT Rockville MARYLAND Days
535037 Cath Lab Rockville MARYLAND 10 Hour Days
543405 ICU Rome NEW YORK 12 Hour Nights
548112 ER Rome NEW YORK 12 Hour Nights RN/Registered Nurse
546596 Med Surg Tele Rome NEW YORK 12 Hour Nights
547023 Med Surg Tele Rome NEW YORK 12 Hour Nights
547024 Med Surg Tele Rome NEW YORK 12 Hour Nights
547771 Med Surg Tele Rome NEW YORK 12 Hour Nights
547870 Med Surg Tele Rome NEW YORK 10 Hour Nights
547059 ER Rome NEW YORK 12 Hour Nights
546063 Med Surg Roosevelt UTAH 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 3.1942 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 z.city asc limit 2800,100 in 1.8895 seconds