Listing all records

Displaying records 1901 through 2000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
543955 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543957 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543958 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543959 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
547958 Cath Lab San Diego CALIFORNIA 8 Hour Days
541964 Cath Lab Whittier CALIFORNIA 8 Hour Days
524484 Cath Lab Louisville KENTUCKY 12 Hour Nights
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
524678 Cath Lab Dubuque IOWA 10 Hour Days
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
546924 Cath Lab Detroit MICHIGAN 8 Hour Days
545960 Cath Lab Berwyn ILLINOIS 8 Hour Days
547499 Cath Lab Pueblo COLORADO 10 Hour Varied
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
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
535674 Cath Lab Passaic NEW JERSEY 8 Hour Days
536437 Cath Lab York PENNSYLVANIA 12 Hour Days
536850 Cath Lab Cleveland OHIO 8 Hour 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
540079 Cath Lab Concord CALIFORNIA 10 Hour Days
547908 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
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
547888 Cath Lab Danville KENTUCKY 10 Hour Days
545611 Cath Lab Mission Viejo CALIFORNIA 10 Hour Days
547909 Cath Lab Lawton OKLAHOMA 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
547392 Cath Lab Cleveland OHIO Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
546473 Cath Lab Woonsocket RHODE ISLAND 10 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
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
548031 Cath Lab Berwyn ILLINOIS 8 Hour Days
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
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
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
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
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
544809 Cath Lab Lewiston MAINE Days
546897 Cath Lab New Bern NORTH CAROLINA 8 Hour Days
545305 Cath Lab Honolulu HAWAII Nights
544947 Cath Lab Johnson City TENNESSEE Days
545083 Cath Lab Corvallis OREGON 8 Hour Day/Night Rotate
547928 Cath Lab Lexington KENTUCKY 8 Hour Days
548133 Cath Lab Mesa ARIZONA 12 Hour Days RN/Registered Nurse
547045 Cath Lab New Bern NORTH CAROLINA 10 Hour Days
546643 Cath Lab Cleveland OHIO 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
546045 EEG Tech Syracuse NEW YORK 8 Hour Days
546667 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
545640 EEG Tech Gainesville FLORIDA 10 Hour Days
547804 EEG Tech Hilo HAWAII 12 Hour Days
540298 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540823 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
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
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.607 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 asc limit 1900,100 in 1.6289 seconds