Listing all records

Displaying records 1201 through 1300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
541058 OR Sherwood ARKANSAS 10 Hour Days
541068 Cath Lab PHOENIX ARIZONA 12 Hour Days
541071 Med Surg Tele Des Moines IOWA 12 Hour Nights
541072 Orthopedics Des Moines IOWA 12 Hour Nights
541076 Med Surg Des Moines IOWA 12 Hour Nights
541077 CT Tech Springfield MASSACHUSETTS 8 Hour Evenings
541078 Oncology Des Moines IOWA 12 Hour Nights
541096 Long Term Care New Lisbon WISCONSIN 8 Hour Days
541105 PT Estes Park COLORADO 12 Hour Day/Night Rotate
541108 Ultrasound Tech Sioux City IOWA 8 Hour Days
541109 MLT Syracuse NEW YORK 8 Hour Nights
546119 Nuclear Med Technician Whittier CALIFORNIA 8 Hour Days
541736 OR Louisville KENTUCKY 10 Hour Days
541117 Telemetry Farmington CONNECTICUT 12 Hour Nights
541844 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
541191 Echo Ann Arbor MICHIGAN 8 Hour Days
541207 ER Walnut Creek CALIFORNIA 12 Hour Nights
541235 Med Surg National City CALIFORNIA 12 Hour Nights
541257 OR Concord CALIFORNIA 10 Hour Evenings
541258 ICU Concord CALIFORNIA 12 Hour Days
541271 PCU Bismarck NORTH DAKOTA Nights
541283 Surgical Tech CVOR Bismarck NORTH DAKOTA 8 Hour Day/Night Rotate
541312 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
542442 Med Surg Oneonta NEW YORK 12 Hour Days
541323 Med Surg Tele Warrensville Heights OHIO 12 Hour Nights
541326 Certified Surgical Tech Albuquerque NEW MEXICO 12 Hour Nights
541332 PCU Albuquerque NEW MEXICO 12 Hour Nights
541359 Vascular Ultrasound Tech Kearney NEBRASKA 8 Hour Days
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
541384 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
541437 Echo Syracuse NEW YORK 8 Hour Days
541391 RAD Tech Bismarck NORTH DAKOTA 12 Hour Day/Night Rotate
542007 Med Surg Hot Springs ARKANSAS 12 Hour Nights
541392 OR East Norriton PENNSYLVANIA 8 Hour Days
541403 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
541443 COTA Towson MARYLAND Days
541447 Cath Lab Everett WASHINGTON 10 Hour Days
541473 CVOR Spokane WASHINGTON 10 Hour Days
541482 CVOR Spokane WASHINGTON 10 Hour Days
541483 CVOR Spokane WASHINGTON 10 Hour Days
541484 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541485 Surgical Tech CVOR Spokane WASHINGTON 10 Hour Days
541486 CVOR Spokane WASHINGTON 10 Hour Days
541489 Med Surg Spokane WASHINGTON 12 Hour Nights
541491 Interventional Radiology Spokane WASHINGTON 10 Hour Days
541492 Med Surg Spokane WASHINGTON 12 Hour Nights
541498 Med Surg Spokane WASHINGTON 12 Hour Nights
541499 Med Surg Spokane WASHINGTON 12 Hour Nights
541500 PCU Spokane WASHINGTON 12 Hour Nights
541501 PCU Spokane WASHINGTON 12 Hour Nights
541502 Med Surg Spokane WASHINGTON 12 Hour Nights
541503 PCU Spokane WASHINGTON 12 Hour Nights
541504 PCU Spokane WASHINGTON 12 Hour Nights
541505 PCU Spokane WASHINGTON 12 Hour Nights
541506 Med Surg Spokane WASHINGTON 12 Hour Nights
541508 Med Surg Spokane WASHINGTON 12 Hour Nights
541510 Med Surg Spokane WASHINGTON 12 Hour Nights
541511 Med Surg Spokane WASHINGTON 12 Hour Nights
541512 Med Surg Spokane WASHINGTON 12 Hour Nights
541513 Med Surg Spokane WASHINGTON 12 Hour Nights
541514 Med Surg Spokane WASHINGTON 12 Hour Nights
541518 PCU Spokane WASHINGTON 12 Hour Nights
541519 PCU Spokane WASHINGTON 12 Hour Nights
541521 PCU Spokane WASHINGTON 12 Hour Days
541522 PCU Spokane WASHINGTON 12 Hour Days
541524 PCU Spokane WASHINGTON 12 Hour Nights
541525 PCU Spokane WASHINGTON 12 Hour Days
541526 PCU Spokane WASHINGTON 12 Hour Days
541527 PCU Spokane WASHINGTON 12 Hour Days
541536 Cath Lab Portland OREGON 10 Hour Days
541543 Case Manager Portland OREGON 8 Hour Days
543047 PT thermopolis WYOMING Days
541551 PT Apple Valley CALIFORNIA 8 Hour Days
541578 Cath Lab Tarzana CALIFORNIA 8 Hour Days
541591 RAD Tech Petaluma CALIFORNIA 8 Hour Days
541606 Surgical Tech CVOR Lubbock TEXAS 10 Hour Days
541610 PT Hesperia CALIFORNIA 8 Hour Days
541613 Ultrasound Tech Portland OREGON 8 Hour Days
541620 Med Surg Spokane WASHINGTON 12 Hour Nights
541627 PT Butte MONTANA Days
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
541635 Case Manager Woonsocket RHODE ISLAND 8 Hour Days
541642 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
541643 Cath Lab Santa Monica CALIFORNIA 10 Hour Days
541647 Med Surg Colville WASHINGTON 12 Hour Nights
541649 Med Surg Chewelah WASHINGTON 12 Hour Nights
541650 CT Tech Chewelah WASHINGTON 12 Hour Day/Night Rotate
541652 PT SANTA ROSA CALIFORNIA 8 Hour Days
541654 Surgical Tech SANTA ROSA CALIFORNIA 8 Hour Days
541657 Med Surg Walla Walla WASHINGTON 12 Hour Nights
542958 PT San Jose CALIFORNIA 10 Hour Days
541700 L&D Eureka CALIFORNIA 12 Hour Nights
541705 PT Eureka CALIFORNIA 8 Hour Days
541730 First Assist Brooklyn NEW YORK 8 Hour Days
543078 Surgical Tech CVOR Ann Arbor MICHIGAN 12 Hour Days
542458 Clinic Pahala HAWAII 12 Hour Day/Night Rotate
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
541750 PT Union City CALIFORNIA 8 Hour Days
541984 Med Surg New York NEW YORK Days
542008 CVICU Little Rock ARKANSAS 12 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.6603 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.title asc limit 1200,100 in 1.753 seconds