Listing all records

Displaying records 301 through 400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
534238 Med Surg Tele Concord CALIFORNIA 8 Hour Days
541613 Ultrasound Tech Portland OREGON 8 Hour Days
538243 PT Lansing MICHIGAN 8 Hour Days
546668 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
542858 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
545887 CT Tech Hereford TEXAS 8 Hour Days
541750 PT Union City CALIFORNIA 8 Hour Days
541705 PT Eureka CALIFORNIA 8 Hour Days
543152 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
532921 SLP Edwardsville ILLINOIS 8 Hour Days
542084 RAD Tech Farmington CONNECTICUT 8 Hour Days
545696 Ultrasound Tech Gainesville FLORIDA 8 Hour Days
546283 PT Hayward CALIFORNIA 8 Hour Days
540976 Phlebotomist Farmington CONNECTICUT 8 Hour Days
542595 CMA Farmington CONNECTICUT 8 Hour Days
542340 Home Health Santa Fe NEW MEXICO 8 Hour Days RN/Registered Nurse
542380 PT SANTA ROSA CALIFORNIA 8 Hour Days
542401 Surgical Tech Leavenworth KANSAS 8 Hour Days
540016 Monitor Tech Farmington CONNECTICUT 8 Hour Days
542838 Case Manager Eureka CALIFORNIA 8 Hour Days
542601 Ambulatory Cleveland OHIO 8 Hour Days
546736 Outpatient Clinic Portland OREGON 8 Hour Days
536440 Infusion Oncology Maywood ILLINOIS 8 Hour Days
533986 CMA Farmington CONNECTICUT 8 Hour Days
544103 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540024 Phlebotomist Farmington CONNECTICUT 8 Hour Days
534655 CT Tech Syracuse NEW YORK 8 Hour Days
546987 Echo Osage Beach MISSOURI 8 Hour Days
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
540029 PCU Concord CALIFORNIA 8 Hour Days
540032 Surgical Tech CVOR Farmington CONNECTICUT 8 Hour Days
542856 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
545762 Histology Technician Gainesville FLORIDA 8 Hour Days
540035 PCU Concord CALIFORNIA 8 Hour Days
546489 OR Brooklyn NEW YORK 8 Hour Days
543096 Oncology Newark NEW JERSEY 8 Hour Days
530850 Home Health Hayward CALIFORNIA 8 Hour Days
543480 Therapy Rehab Athens GEORGIA 8 Hour Days
543406 PT Palm Springs CALIFORNIA 8 Hour Days
543133 Echo Charlottesville VIRGINIA 8 Hour Days
531037 Nuclear Medicine Oceanside CALIFORNIA 8 Hour Days
531151 RAD Tech Farmington CONNECTICUT 8 Hour Days Radiology Techs/Technologists
543153 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
546469 OR Louisville KENTUCKY 8 Hour Days
546651 Surgical Tech Louisville KENTUCKY 8 Hour Days
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
543126 Cath Lab Mason City IOWA 8 Hour Days
543355 Phlebotomist Farmington CONNECTICUT 8 Hour Days
543184 Surgical Tech Athens GEORGIA 8 Hour Days
546421 Sterile Processing Technician Westerville OHIO 8 Hour Days
547756 Outpatient Clinic Cooperstown NEW YORK 8 Hour Days
540083 RAD Tech Farmington CONNECTICUT 8 Hour Days
542497 PT Clovis NEW MEXICO 8 Hour Days
543783 RAD Tech Redding CALIFORNIA 8 Hour Days
546778 Ambulatory Syracuse NEW YORK 8 Hour Days RN/Registered Nurse
546877 MLT Pittsfield MASSACHUSETTS 8 Hour Days
545874 MRI Tech Gainesville FLORIDA 8 Hour Days
545770 MRI Tech Gainesville FLORIDA 8 Hour Days
543753 CLS Victorville CALIFORNIA 8 Hour Days
536753 PT NORTHRIDGE CALIFORNIA 8 Hour Days
546783 PT Salinas CALIFORNIA 8 Hour Days PT/Physical Therapist
545624 Surgical Tech CVOR Prescott ARIZONA 8 Hour Days
543781 OR Redding CALIFORNIA 8 Hour Days
543709 Laboratory Orange CALIFORNIA 8 Hour Days
543784 GI Lab Woonsocket RHODE ISLAND 8 Hour Days
543780 OR Woonsocket RHODE ISLAND 8 Hour Days
535178 Interventional Radiology Tech Columbus OHIO 8 Hour Days
543904 PT Crescent City CALIFORNIA 8 Hour Days
531958 Social Worker Falls Church VIRGINIA 8 Hour Days
535174 PT San Francisco CALIFORNIA 8 Hour Days
532201 RAD Tech Louisville KENTUCKY 8 Hour Days
538057 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
547056 PT Sacramento CALIFORNIA 8 Hour Days
535143 OT Rehab Devils Lake NORTH DAKOTA 8 Hour Days
547666 PT Bad Axe MICHIGAN 8 Hour Days
543779 OR Woonsocket RHODE ISLAND 8 Hour Days
543193 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
532202 RAD Tech Louisville KENTUCKY 8 Hour Days
538087 PT Honolulu HAWAII 8 Hour Days
543790 RAD Tech Oceanside CALIFORNIA 8 Hour Days
532355 Medical Assistant Beverly Hills CALIFORNIA 8 Hour Days
540255 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Days
546986 LPN/LVN SAN ANDREAS CALIFORNIA 8 Hour Days
546897 Cath Lab New Bern NORTH CAROLINA 8 Hour Days
543958 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
546143 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
546988 Radiation Therapy NORTHRIDGE CALIFORNIA 8 Hour Days
545275 First Assist San Luis Obispo CALIFORNIA 8 Hour Days
532660 CMA Farmington CONNECTICUT 8 Hour Days
546949 RAD Tech Hot Springs ARKANSAS 8 Hour Days
544202 RAD Tech Dubuque IOWA 8 Hour Days
544446 MLT Los Angeles CALIFORNIA 8 Hour Days
537446 CNA Brooklyn NEW YORK 8 Hour Days
544235 Sterile Processing Tech Denville NEW JERSEY 8 Hour Days
532907 Ultrasound Tech Mason City IOWA 8 Hour Days
543955 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543952 Cath Lab Louisville KENTUCKY 8 Hour Days
532997 SLP Everett WASHINGTON 8 Hour Days
533009 Cath Lab Mason City IOWA 8 Hour Days
533010 Cath Lab Mason City IOWA 8 Hour Days
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.6735 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.shift asc limit 300,100 in 1.3883 seconds