Listing all records

Displaying records 401 through 500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545772 RAD Tech Gainesville FLORIDA 10 Hour Days
546011 Surgical Tech CVOR Hays KANSAS 10 Hour Days
506863 Surgical Tech Durham NORTH CAROLINA 10 Hour Days
537715 OR Farmington CONNECTICUT 10 Hour Days
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
543127 Surgical Tech Fresno CALIFORNIA 10 Hour Days
517294 Surgical Tech Oceanside CALIFORNIA 10 Hour Days
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
517854 CT Tech Akron OHIO 10 Hour Days
540014 Surgical Tech Farmington CONNECTICUT 10 Hour Days
546473 Cath Lab Woonsocket RHODE ISLAND 10 Hour Days
546604 RAD Tech Lewiston MAINE 10 Hour Days
544617 Scrub Tech Rio Rancho NEW MEXICO 10 Hour Days
546345 CT Tech Goodyear ARIZONA 10 Hour Days
544595 Surgical Tech Anchorage ALASKA 10 Hour Days
540022 Interventional Radiology Farmington CONNECTICUT 10 Hour Days
540017 RAD Tech Farmington CONNECTICUT 10 Hour Days
542997 Cath Lab Concord CALIFORNIA 10 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
546825 Surgical Tech CVOR Parkersburg WEST VIRGINIA 10 Hour Days
546643 Cath Lab Cleveland OHIO 10 Hour Days
542262 CVOR Charlottesville VIRGINIA 10 Hour Days
545303 PACU Farmington CONNECTICUT 10 Hour Days
539111 OR Concord CALIFORNIA 10 Hour Days
523059 CVOR Tech Los Angeles CALIFORNIA 10 Hour Days CST/Certified Surgical Technician
543130 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543128 Surgical Tech Fresno CALIFORNIA 10 Hour Days
543592 PACU Nashua NEW HAMPSHIRE 10 Hour Days
543944 RAD Tech Walnut Creek CALIFORNIA 10 Hour Days
524678 Cath Lab Dubuque IOWA 10 Hour Days
538172 MRI Tech Germantown MARYLAND 10 Hour Days
524748 Surgical Tech Boise IDAHO 10 Hour Days
546032 PT San Jose CALIFORNIA 10 Hour Days
545700 Ultrasound Tech Gainesville FLORIDA 10 Hour Days
543945 RAD Tech Concord CALIFORNIA 10 Hour Days
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
544152 Surgical Tech Farmington CONNECTICUT 10 Hour Days
546213 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
525235 CT Tech Oceanside CALIFORNIA 10 Hour Days
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
525605 RAD Tech Boston MASSACHUSETTS 10 Hour Days Radiology Techs/Technologists
544294 OR Maywood ILLINOIS 10 Hour Days
544316 Cath Lab Willoughby OHIO 10 Hour Days
544347 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
525930 RAD Tech Los Angeles CALIFORNIA 10 Hour Days Radiology Techs/Technologists
544509 Cath Lab Edgewood KENTUCKY 10 Hour Days
544251 OR Farmington CONNECTICUT 10 Hour Days
540005 OR Farmington CONNECTICUT 10 Hour Days
546212 Outpatient Clinic Susanville CALIFORNIA 10 Hour Days
526713 CT Tech Silver Spring MARYLAND 10 Hour Days
539151 Surgical Tech Fresno CALIFORNIA 10 Hour Days
545213 RAD Tech New Lenox ILLINOIS 10 Hour Days
546342 Cath Lab Lexington KENTUCKY 10 Hour Days
543024 Interventional Radiology Des Moines IOWA 10 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
546704 CT Tech Des Moines IOWA 10 Hour Days
545277 Surgical Tech Templeton CALIFORNIA 10 Hour Days
542423 OR IOWA CITY IOWA 10 Hour Days
542846 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
531702 OR Muskegon MICHIGAN 10 Hour Days
543005 CT Tech Oceanside CALIFORNIA 10 Hour Days
547094 Surgical Tech CVOR Lewiston MAINE 10 Hour Days
532559 MRI Tech Louisville KENTUCKY 10 Hour Days
532657 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
545691 RAD Tech Gainesville FLORIDA 10 Hour Days
546942 Perfusionist Boston MASSACHUSETTS 10 Hour Days
535037 Cath Lab Rockville MARYLAND 10 Hour Days
545669 Case Manager Gainesville FLORIDA 10 Hour Days
543117 RN Columbus OHIO 10 Hour Days
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
543338 OR Farmington CONNECTICUT 10 Hour Days
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
533260 RAD Tech Des Moines IOWA 10 Hour Days
544303 Ultrasound Tech Portland OREGON 10 Hour Days
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
545640 EEG Tech Gainesville FLORIDA 10 Hour Days
543337 OR Farmington CONNECTICUT 10 Hour Days
545613 EP Tech Mission Viejo CALIFORNIA 10 Hour Days
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
544010 OR Oceanside CALIFORNIA 10 Hour Days
543991 OR Omaha NEBRASKA 10 Hour Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
544444 PT Santa Clara CALIFORNIA 10 Hour Days
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
536731 Surgical Tech Fresno CALIFORNIA 10 Hour Days
546340 Certified Surgical Tech Torrance CALIFORNIA 10 Hour Days
543336 CT Tech Westerville OHIO 10 Hour Days
546367 OR Maywood ILLINOIS 10 Hour Days
547295 Oncology Coos Bay OREGON 10 Hour Days
546667 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
546289 CT Tech Alexandria VIRGINIA 10 Hour Days
546609 EP Tech Pinehurst NORTH CAROLINA 10 Hour Days
543129 Surgical Tech Fresno CALIFORNIA 10 Hour Days
547369 Interventional Radiology Tech Clearwater FLORIDA 10 Hour Days
544508 Cath Lab Edgewood KENTUCKY 10 Hour Days
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
546682 RAD Tech Lexington KENTUCKY 10 Hour Days
546689 OR Templeton CALIFORNIA 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.4939 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 desc limit 400,100 in 1.3012 seconds