Listing all records

Displaying records 3101 through 3200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547768 Long Term Care New Lisbon WISCONSIN 8 Hour Day/Night Rotate
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
548272 Surgical Tech Tuba City ARIZONA 10 Hour Days Tech/Technologist
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
548222 Certified Surgical Tech Sun City ARIZONA 10 Hour Days CST/Certified Surgical Technician
517294 Surgical Tech Oceanside CALIFORNIA 10 Hour Days
548083 Surgical Tech Seattle WASHINGTON 10 Hour Days Tech/Technologist
517854 CT Tech Akron OHIO 10 Hour Days
523059 CVOR Tech Los Angeles CALIFORNIA 10 Hour Days CST/Certified Surgical Technician
524678 Cath Lab Dubuque IOWA 10 Hour Days
524748 Surgical Tech Boise IDAHO 10 Hour Days
525235 CT Tech Oceanside CALIFORNIA 10 Hour Days
525605 RAD Tech Boston MASSACHUSETTS 10 Hour Days Radiology Techs/Technologists
525930 RAD Tech Los Angeles CALIFORNIA 10 Hour Days Radiology Techs/Technologists
526713 CT Tech Silver Spring MARYLAND 10 Hour Days
532559 MRI Tech Louisville KENTUCKY 10 Hour Days
532657 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
535037 Cath Lab Rockville MARYLAND 10 Hour Days
533260 RAD Tech Des Moines IOWA 10 Hour Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
540005 OR Farmington CONNECTICUT 10 Hour Days
540014 Surgical Tech Farmington CONNECTICUT 10 Hour Days
540017 RAD Tech Farmington CONNECTICUT 10 Hour Days
540022 Interventional Radiology Farmington CONNECTICUT 10 Hour Days
547895 OR Coos Bay OREGON 10 Hour Days
540028 OR Concord CALIFORNIA 10 Hour Days
540045 OR Farmington CONNECTICUT 10 Hour Days
540046 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
540059 PACU Concord CALIFORNIA 10 Hour Days
540060 CT Tech Farmington CONNECTICUT 10 Hour Days
540061 OR Farmington CONNECTICUT 10 Hour Days
540062 OR Farmington CONNECTICUT 10 Hour Days
540079 Cath Lab Concord CALIFORNIA 10 Hour Days
540131 Cath Lab Concord CALIFORNIA 10 Hour Days
540132 Cath Lab Concord CALIFORNIA 10 Hour Days
540134 Cath Lab Concord CALIFORNIA 10 Hour Days
540143 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
540206 PACU Concord CALIFORNIA 10 Hour Days
540224 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
543337 OR Farmington CONNECTICUT 10 Hour Days
543338 OR Farmington CONNECTICUT 10 Hour Days
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
547795 OR Tuba City ARIZONA 10 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
543944 RAD Tech Walnut Creek CALIFORNIA 10 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
548067 CST Lebanon NEW HAMPSHIRE 10 Hour Days CST/Certified Surgical Technician
543991 OR Omaha NEBRASKA 10 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
544251 OR Farmington CONNECTICUT 10 Hour Days
544293 OR Maywood ILLINOIS 10 Hour Days
544294 OR Maywood ILLINOIS 10 Hour Days
544303 Ultrasound Tech Portland OREGON 10 Hour Days
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544316 Cath Lab Willoughby OHIO 10 Hour Days
544347 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544444 PT Santa Clara CALIFORNIA 10 Hour Days
544502 Interventional Radiology Tech Fayetteville NORTH CAROLINA 10 Hour Days
544508 Cath Lab Edgewood KENTUCKY 10 Hour Days
544509 Cath Lab Edgewood KENTUCKY 10 Hour Days
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
544812 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544818 OR Maywood ILLINOIS 10 Hour Days
544846 OR Espanola NEW MEXICO 10 Hour Days
544886 OR Aspen COLORADO 10 Hour Days
544911 PT Apple Valley CALIFORNIA 10 Hour Days
544912 PT Apple Valley CALIFORNIA 10 Hour Days
545030 OR Gardner MASSACHUSETTS 10 Hour Days
545103 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545104 Certified Surgical Tech Cleveland OHIO 10 Hour Days
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
545237 Surgical Tech CVOR Reno NEVADA 10 Hour Days
546704 CT Tech Des Moines IOWA 10 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
545303 PACU Farmington CONNECTICUT 10 Hour Days
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
548209 OB South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
548210 CNA South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
546643 Cath Lab Cleveland OHIO 10 Hour Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
547440 Electrophysiology Tech Birmingham ALABAMA 10 Hour Days
547442 Electrophysiology Tech San Antonio TEXAS 10 Hour Days
547479 CT Tech Arlington VIRGINIA 10 Hour Days
547606 Surgical Tech Boise IDAHO 10 Hour Days
547637 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
547681 Radiation Therapy Flint MICHIGAN 10 Hour Days
547700 CVOR Sun City ARIZONA 10 Hour Days
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
547764 CT Tech Phoenix ARIZONA 10 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.746 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 3100,100 in 1.5558 seconds