Listing all records

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

ID Job Specialty City State Shift Title
544884 CT Tech Nome ALASKA 12 Hour Day/Night Rotate
540864 CT Tech Pigeon MICHIGAN 12 Hour Nights
536752 CT Tech Roseburg OREGON 12 Hour Nights
546352 CT Tech Manteca CALIFORNIA 8 Hour Days
547007 CT Tech Maryville ILLINOIS 12 Hour Nights
535912 CT Tech Detroit MICHIGAN 12 Hour Nights
547390 CT Tech Cleveland OHIO 8 Hour Evenings
526713 CT Tech Silver Spring MARYLAND 10 Hour Days
526714 CT Tech Hartford CONNECTICUT 8 Hour Nights
526794 CT Tech Silver Spring MARYLAND 10 Hour Nights
546402 CT Tech Mount Airy NORTH CAROLINA 8 Hour Nights
547277 CT Tech Sioux City IOWA 10 Hour Nights
546704 CT Tech Des Moines IOWA 10 Hour Days
534655 CT Tech Syracuse NEW YORK 8 Hour Days
543887 CT Tech National City CALIFORNIA 12 Hour Nights
544243 CT Tech Reno NEVADA 12 Hour Nights
538498 CT Tech Riverhead NEW YORK 8 Hour Nights
546247 CT Tech Toledo OHIO 8 Hour Evenings
543801 CT Tech Long Prairie MINNESOTA 12 Hour Days
546289 CT Tech Alexandria VIRGINIA 10 Hour Days
543757 CT Tech Lynwood CALIFORNIA 12 Hour Days
546317 CT Tech ODESSA TEXAS 12 Hour Days
546782 CT Tech Salinas CALIFORNIA 12 Hour Nights CT/Computerized Tomography
542160 CT Tech Lynwood CALIFORNIA 12 Hour Day/Night Rotate
539629 CT Tech Cleveland OHIO 8 Hour Nights
546403 CT Tech Mount Airy NORTH CAROLINA 12 Hour Nights
538382 CT Tech Cleveland OHIO 8 Hour Evenings
536231 CT Tech Maywood ILLINOIS 8 Hour Evenings
538435 CT Tech Harvard ILLINOIS 8 Hour Evenings
545315 CT Tech Eureka CALIFORNIA 10 Hour Days
547076 CT Tech Farmington CONNECTICUT 12 Hour Nights
547890 CT Tech Knoxville TENNESSEE 12 Hour Nights
536440 Infusion Oncology Maywood ILLINOIS 8 Hour Days
544290 Infusion Oncology Sidney MONTANA Days
547834 Dialysis Tech Everett WASHINGTON 10 Hour Varied
540501 Supervisor New York NEW YORK 8 Hour Days
547039 Supervisor Oneonta NEW YORK 8 Hour Nights
539293 Supervisor Brooklyn NEW YORK 8 Hour Days
525987 Supervisor New York NEW YORK 8 Hour Days
525988 Supervisor New York NEW YORK 8 Hour Days
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
541359 Vascular Ultrasound Tech Kearney NEBRASKA 8 Hour Days
545082 Vascular Ultrasound Tech Artesia NEW MEXICO Days
525386 Vascular Ultrasound Tech Kealakekua HAWAII 12 Hour Day/Night Rotate
546869 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
545033 Echo Technologist Madison WISCONSIN 8 Hour Day/Night Rotate
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
538580 Echo Technologist Columbia MISSOURI Days
543913 Echo Technologist Lewiston MAINE 8 Hour Days
542130 Echo Technologist San Angelo TEXAS Varied
547564 Echo Technologist Cape Girardeau MISSOURI Days
547682 Echo Technologist Chambersburg PENNSYLVANIA Varied
545244 Echo Technologist Tulsa OKLAHOMA 12 Hour Day/Night Rotate
544634 APRN Stanley WISCONSIN Days
547877 APRN Portage WISCONSIN Days
545339 APRN Plymouth WISCONSIN Days
545606 Interventional Radiology Tech Mission Viejo CALIFORNIA 10 Hour Days
546973 Interventional Radiology Tech York PENNSYLVANIA 8 Hour Days
545539 Interventional Radiology Tech Columbia SOUTH CAROLINA 8 Hour Days
535178 Interventional Radiology Tech Columbus OHIO 8 Hour Days
546798 Interventional Radiology Tech IOWA CITY IOWA Days
542846 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
547369 Interventional Radiology Tech Clearwater FLORIDA 10 Hour Days
546694 Interventional Radiology Tech Oceanside CALIFORNIA 10 Hour Days
547118 Interventional Radiology Tech CHANDLER ARIZONA 8 Hour Days
544196 Interventional Radiology Tech Arlington VIRGINIA 10 Hour Days
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
540923 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
540599 Interventional Radiology Tech Pontiac MICHIGAN 8 Hour Days
542596 Interventional Radiology Tech Daytona Beach FLORIDA 8 Hour Days
548169 Interventional Radiology Tech Indianaplis INDIANA 10 Hour Nights Radiology Techs/Technologists
544502 Interventional Radiology Tech Fayetteville NORTH CAROLINA 10 Hour Days
546929 Interventional Radiology Tech Detroit MICHIGAN 10 Hour Days
547552 Interventional Radiology Tech Winston-Salem NORTH CAROLINA 8 Hour Days
526268 Interventional Radiology Tech Fresno CALIFORNIA 12 Hour Days
547722 Interventional Radiology Tech Sacramento CALIFORNIA 10 Hour Days
547822 Interventional Radiology Tech Farmington NEW MEXICO 8 Hour Days
544636 Interventional Radiology Tech PHOENIX ARIZONA 12 Hour Days
546762 Interventional Radiology Tech Gainesville FLORIDA 10 Hour Days
544905 Mammo Tech Port Jefferson NEW YORK 8 Hour Days
543834 Mammo Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
545069 Mammo Tech Port Jefferson NEW YORK 8 Hour Days
535216 Mammo Tech Juneau ARKANSAS Days
547964 Mammo Tech San Angelo TEXAS 8 Hour Days
546996 Mammo Tech Morgantown WEST VIRGINIA 8 Hour Days
547851 Nuclear Med Technician Liberal KANSAS 8 Hour Days
543575 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
547940 Nuclear Med Technician Mission Viejo CALIFORNIA 8 Hour Days
538434 Nuclear Med Technician Janesville WISCONSIN 8 Hour Days
544227 Nuclear Med Technician Denville NEW JERSEY 8 Hour Days
546448 Nuclear Med Technician Santa Monica CALIFORNIA 12 Hour Days
547647 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
546119 Nuclear Med Technician Whittier CALIFORNIA 8 Hour Days
547835 Nuclear Med Technician Hilo HAWAII 8 Hour Days
544964 Nuclear Med Technician Mishawaka INDIANA 8 Hour Days
547898 Nuclear Med Technician Seattle WASHINGTON 8 Hour Days
545666 Surgical Tech CVOR Gainesville FLORIDA 12 Hour Days
547708 Surgical Tech CVOR Zanesville OHIO Days
545624 Surgical Tech CVOR Prescott ARIZONA 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.6288 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.specialty desc limit 200,100 in 1.941 seconds