Listing all records

Displaying records 1701 through 1800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547658 PCU Omaha NEBRASKA 12 Hour Nights
548021 PCU Abilene TEXAS 12 Hour Nights
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
544034 PCU Spokane WASHINGTON 12 Hour Nights
547455 PCU Abilene TEXAS 12 Hour Days
547459 PCU Abilene TEXAS 12 Hour Day/Night Rotate
544518 PCU Fayetteville NORTH CAROLINA 12 Hour Nights
544536 PCU Hilo HAWAII Varied
544558 PCU Spokane WASHINGTON 12 Hour Nights
513169 Phlebotomist Hickory NORTH CAROLINA 12 Hour Nights
537460 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540020 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540024 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540976 Phlebotomist Farmington CONNECTICUT 8 Hour Days
541038 Phlebotomist Farmington CONNECTICUT 8 Hour Days
544103 Phlebotomist Farmington CONNECTICUT 8 Hour Days
543355 Phlebotomist Farmington CONNECTICUT 8 Hour Days
546045 EEG Tech Syracuse NEW YORK 8 Hour Days
547804 EEG Tech Hilo HAWAII 12 Hour Days
545640 EEG Tech Gainesville FLORIDA 10 Hour Days
546667 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540298 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540823 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
547402 Cath Lab Tech Fort Smith ARIZONA 8 Hour Day/Night Rotate
543831 Cath Lab Tech Salinas CALIFORNIA 8 Hour Days Tech/Technologist
547928 Cath Lab Lexington KENTUCKY 8 Hour Days
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
524484 Cath Lab Louisville KENTUCKY 12 Hour Nights
524678 Cath Lab Dubuque IOWA 10 Hour Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
547909 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
548031 Cath Lab Berwyn ILLINOIS 8 Hour Days
531388 Cath Lab Louisville KENTUCKY 12 Hour Nights
532657 Cath Lab Walnut Creek CALIFORNIA 10 Hour Days
535037 Cath Lab Rockville MARYLAND 10 Hour Days
533009 Cath Lab Mason City IOWA 8 Hour Days
533010 Cath Lab Mason City IOWA 8 Hour Days
547958 Cath Lab San Diego CALIFORNIA 8 Hour Days
535176 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Days
535177 Cath Lab Alameda Oakland CALIFORNIA 8 Hour Varied
535231 Cath Lab Sioux City IOWA 8 Hour Days
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
536850 Cath Lab Cleveland OHIO 8 Hour Days
544809 Cath Lab Lewiston MAINE Days
538181 Cath Lab San Diego CALIFORNIA 12 Hour Days
538182 Cath Lab San Diego CALIFORNIA 8 Hour Days
538542 Cath Lab Mason City IOWA 8 Hour Days
546342 Cath Lab Lexington KENTUCKY 10 Hour Days
543331 Cath Lab Dubuque IOWA 10 Hour Days
546897 Cath Lab New Bern NORTH CAROLINA 8 Hour Days
540079 Cath Lab Concord CALIFORNIA 10 Hour Days
545305 Cath Lab Honolulu HAWAII Nights
548133 Cath Lab Mesa ARIZONA 12 Hour Days RN/Registered Nurse
547392 Cath Lab Cleveland OHIO 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
547499 Cath Lab Pueblo COLORADO 10 Hour Varied
544947 Cath Lab Johnson City TENNESSEE Days
545083 Cath Lab Corvallis OREGON 8 Hour Day/Night Rotate
540351 Cath Lab Waterloo IOWA 8 Hour Days
540565 Cath Lab Cape Girardeau MISSOURI Days
540616 Cath Lab Inglewood CALIFORNIA 10 Hour Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
541447 Cath Lab Everett WASHINGTON 10 Hour Days
541536 Cath Lab Portland OREGON 10 Hour Days
541578 Cath Lab Tarzana CALIFORNIA 8 Hour Days
541642 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
541643 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
542642 Cath Lab Mason City IOWA 8 Hour Days
545960 Cath Lab Berwyn ILLINOIS 8 Hour Days
542856 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542858 Cath Lab Winston-Salem NORTH CAROLINA 8 Hour Days
542997 Cath Lab Concord CALIFORNIA 10 Hour Days
543095 Cath Lab Newark NEW JERSEY 12 Hour Nights
543124 Cath Lab Fresno CALIFORNIA 12 Hour Days
543126 Cath Lab Mason City IOWA 8 Hour Days
543380 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
545611 Cath Lab Mission Viejo CALIFORNIA 10 Hour Days
547908 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
543881 Cath Lab Philadelphia PENNSYLVANIA 10 Hour Days
543889 Cath Lab National City CALIFORNIA 8 Hour Days
543952 Cath Lab Louisville KENTUCKY 8 Hour Days
546924 Cath Lab Detroit MICHIGAN 8 Hour Days
544096 Cath Lab Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
544124 Cath Lab Fort Smith ARIZONA 8 Hour Day/Night Rotate
544142 Cath Lab Cleveland OHIO 10 Hour Days
544143 Cath Lab Cleveland OHIO 10 Hour Days
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
544316 Cath Lab Willoughby OHIO 10 Hour Days
544508 Cath Lab Edgewood KENTUCKY 10 Hour Days
544509 Cath Lab Edgewood KENTUCKY 10 Hour Days
544553 Cath Lab Passaic NEW JERSEY 8 Hour Days
544557 Cath Lab Burbank CALIFORNIA 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.5537 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 1700,100 in 1.4952 seconds