Listing all records

Displaying records 201 through 300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
527092 PT Boardman OHIO Days
527125 Therapy Rehab Shelby MISSISSIPPI Days
527179 RAD Tech Boise IDAHO 12 Hour Days
527184 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
527222 PT Freemont CALIFORNIA Days
527223 PTA Hayward CALIFORNIA Days
527226 ER Everett WASHINGTON 12 Hour Nights
527231 PT North Kingstown RHODE ISLAND Days
527324 PT Palm Springs CALIFORNIA Days
527338 RAD Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
527487 PTA North Providence RHODE ISLAND Days
527493 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
527559 RAD Tech San Diego CALIFORNIA 12 Hour Nights
527570 Med Surg Tele Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
527593 PT Pinehurst NORTH CAROLINA 8 Hour Days
527624 Scrub Tech Oceanside CALIFORNIA 10 Hour Days
527625 Sterile Processing Technician Oceanside CALIFORNIA 10 Hour Nights
527684 PICU New York NEW YORK 12 Hour Days RN/Registered Nurse
527789 RAD Tech Oceanside CALIFORNIA 8 Hour Days
527927 PT Mandan NORTH DAKOTA 8 Hour Day/Night Rotate
527935 OR Per Diem/Local Contract Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
527971 RN Tuba City ARIZONA 12 Hour Day/Night Rotate
527987 Case Manager Albuquerque NEW MEXICO 10 Hour Days
527995 Oncology Albany NEW YORK 12 Hour Nights
528005 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
528026 Med Surg Mason City IOWA 12 Hour Nights
528028 Med Surg Mason City IOWA 12 Hour Nights
528069 PCU Flagstaff ARIZONA 12 Hour Nights RN/Registered Nurse
528182 Outpatient Clinic Per Diem San Diego CALIFORNIA 8 Hour Days RN/Registered Nurse
528270 Surgical Tech Louisville KENTUCKY 12 Hour Days
528446 PTA Killeen TEXAS Days
528477 Respiratory Therapist Mason City IOWA 12 Hour Days
528482 SLP Fresno CALIFORNIA Days
528504 SLP Juneau ALASKA Days
528573 Pediatrics Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
528610 OR Oceanside CALIFORNIA 10 Hour Days
528615 SLP Salisbury NORTH CAROLINA Days
528766 PT Sparks NEVADA Days
529033 PT San Ramon CALIFORNIA Days
529162 Physician Assistant Syracuse NEW YORK 8 Hour Varied
529165 Surgical Tech CVOR Cincinnati OHIO 10 Hour Days
529209 Surgical Tech Passaic NEW JERSEY 12 Hour Days
529353 PTA Harwich MASSACHUSETTS Days
529430 PTA New Providence NEW JERSEY Days
529510 CT Tech Bethel ALASKA 12 Hour Day/Night Rotate
529591 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529597 RAD Tech Pendleton OREGON 8 Hour Day/Night Rotate
529609 PT Low Moor VIRGINIA Days
529616 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
529660 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
529699 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
529926 SLP Grand Junction COLORADO Days
529965 ICU Boise IDAHO 12 Hour Nights
529983 CCU Newark NEW JERSEY 12 Hour Nights
529991 Therapy Rehab Los Angeles CALIFORNIA Days
530071 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530228 CVOR Sioux City IOWA 10 Hour Days
530245 Telemetry CHANDLER ARIZONA 12 Hour Nights
530323 ICU - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530342 ICU Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530378 Med Surg Boise IDAHO Nights
530379 Med Surg Boise IDAHO Nights
530433 Surgical Tech Oceanside CALIFORNIA Varied
530439 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
530463 PT Republic WASHINGTON Days
530475 Telemetry Panorama City CALIFORNIA 12 Hour Days RN/Registered Nurse
530562 CT Tech Camp Hill PENNSYLVANIA 10 Hour Nights
530585 PTA Yeadon PENNSYLVANIA Days
530655 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
530725 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530739 Med Surg Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530740 Med Surg Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
530741 Med Surg Van Nuys CALIFORNIA 12 Hour Nights RN/Registered Nurse
530820 CT Tech Hudson NEW YORK 12 Hour Nights
530850 Home Health Hayward CALIFORNIA 8 Hour Days
530873 Med Surg Tele Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
530909 SLP Chesnee SOUTH CAROLINA Days
530911 Pediatric ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531037 Nuclear Medicine Oceanside CALIFORNIA 8 Hour Days
531138 ICU Ogdensburg NEW YORK 12 Hour Nights
531151 RAD Tech Farmington CONNECTICUT 8 Hour Days Radiology Techs/Technologists
531152 Med Surg Tele Farmington CONNECTICUT 12 Hour Nights RN/Registered Nurse
531188 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
531204 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531219 PT Williamstown NEW JERSEY Days
531244 ICU   CALIFORNIA 12 Hour Days RN/Registered Nurse
531334 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
531354 ER - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531355 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
531388 Cath Lab Louisville KENTUCKY 12 Hour Nights
531394 Pediatrics Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
531418 PCU Phoenix ARIZONA 12 Hour Nights
531433 Long Term Care Marion VIRGINIA Nights
531489 PT Ramsey NEW JERSEY Days
531496 CCU Newark NEW JERSEY 12 Hour Days
531502 Surgical Tech Muskegon MICHIGAN 12 Hour Nights
531507 Therapy Rehab Modesto CALIFORNIA Days
531580 ICU Dubuque IOWA 12 Hour Days
531609 CT Tech Jackson MISSISSIPPI 8 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.3146 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.id asc limit 200,100 in 1.0403 seconds