Listing all records

Displaying records 801 through 900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547988 Intermediate Care Rumford MAINE 12 Hour Days
547989 Intermediate Care Rumford MAINE 12 Hour Days
547515 Medical Assistant Ruidoso NEW MEXICO 8 Hour Days
548079 PICU Roseville CALIFORNIA 12 Hour Nights RN/Registered Nurse
516937 SLP Roseburg OREGON Days
533177 CT Tech Roseburg OREGON 8 Hour Days
536752 CT Tech Roseburg OREGON 12 Hour Nights
539310 Speech Language Roseburg OREGON Days
545257 CT Tech Roseburg OREGON 10 Hour Nights
546063 Med Surg Roosevelt UTAH Nights
547870 Med Surg Tele Rome NEW YORK 10 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
547059 ER Rome NEW YORK 12 Hour Nights
543405 ICU Rome NEW YORK 12 Hour Nights
507079 PT Rockville MARYLAND Days
511666 PT Rockville MARYLAND Days
535037 Cath Lab Rockville MARYLAND 10 Hour Days
545411 RAD Tech Rockville MARYLAND 8 Hour Days
548224 ER Rockville MARYLAND 12 Hour Nights RN/Registered Nurse
547482 CT Tech Rockingham NORTH CAROLINA 12 Hour Nights
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
540706 Cardiac ICU Rockford ILLINOIS 12 Hour Nights
542451 ER Rockford ILLINOIS 12 Hour Nights
543903 Adult Care Rockaway Park NEW YORK 8 Hour Days
535651 COTA Rock Rapids IOWA Days
543252 Telemetry Rock Hill SOUTH CAROLINA 12 Hour Nights
546358 Cardiac ICU Rock Hill SOUTH CAROLINA 12 Hour Nights
545291 PCU Rock Hill SOUTH CAROLINA 12 Hour Nights
538527 Long Term Care Rochdale MASSACHUSETTS 12 Hour Days
546787 CT Tech Robinson ILLINOIS 8 Hour Evenings
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
544543 CT Tech Riverhead NEW YORK 10 Hour Nights
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
547556 CT Tech Ritzville WASHINGTON 8 Hour Days
547066 PCU Rio Rancho NEW MEXICO 12 Hour Nights
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
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
545915 RAD Tech Richland WASHINGTON 12 Hour Day/Night Rotate
530463 PT Republic WASHINGTON Days
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
543750 CLS Reno NEVADA 12 Hour Day/Night Rotate
546697 Surgical Tech Reno NEVADA 12 Hour Days
547119 RAD Tech REDWOOD CITY CALIFORNIA 8 Hour Days
545420 PT REDWOOD CITY CALIFORNIA 8 Hour Days
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
548172 PT Red Bluff CALIFORNIA 8 Hour Days RN/Registered Nurse
534504 PT Raritan NEW JERSEY Days
548196 ICU Ranson WEST VIRGINIA 12 Hour Nights RN/Registered Nurse
548048 LPN/LVN Rancho Cordova CALIFORNIA 12 Hour Nights LVN
548177 ICU Rancho Cordova CALIFORNIA 12 Hour Nights RN/Registered Nurse
524151 PTA Ramsey NEW JERSEY Days
531489 PT Ramsey NEW JERSEY Days
547323 Med Surg Tele Raeford NORTH CAROLINA 12 Hour Nights
547136 Pediatrics Quincy CALIFORNIA Nights
535095 LPN/LVN Quincy CALIFORNIA Varied
539294 Radiology Queens NEW YORK 8 Hour Days
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
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
548407 OR Queens NEW YORK 12 Hour Days RN/Registered Nurse
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
541769 Oncology Pueblo COLORADO 12 Hour Days
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
546958 Med Surg Tele Princeton WEST VIRGINIA 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.5453 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 desc limit 800,100 in 1.4994 seconds