Listing all records

Displaying records 1001 through 1100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540307 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540308 Case Manager Concord CALIFORNIA 8 Hour Evenings
540309 L&D Walnut Creek CALIFORNIA 12 Hour Days
540310 OR Walnut Creek CALIFORNIA 12 Hour Days
540311 ER Walnut Creek CALIFORNIA 12 Hour Nights
540312 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540313 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540314 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Days
540315 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540316 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540317 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540318 Med Surg Concord CALIFORNIA 12 Hour Days
540319 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540320 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540321 ICU Walnut Creek CALIFORNIA 12 Hour Days
540322 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540323 Telemetry Concord CALIFORNIA 12 Hour Nights
540324 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540325 PT Walnut Creek CALIFORNIA 10 Hour Days
540326 Pediatrics Walnut Creek CALIFORNIA 12 Hour Days
540327 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540328 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540329 ICU Walnut Creek CALIFORNIA 12 Hour Days
540330 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540331 ER Concord CALIFORNIA 12 Hour Nights
540332 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540333 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540334 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540335 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540336 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540337 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540338 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540339 PICU Walnut Creek CALIFORNIA 12 Hour Days
540340 ICU Walnut Creek CALIFORNIA 12 Hour Days
540341 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540342 Telemetry Concord CALIFORNIA 12 Hour Days
540343 ICU Walnut Creek CALIFORNIA 12 Hour Days
540344 PACU Concord CALIFORNIA 12 Hour Days
540345 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540346 ICU Walnut Creek CALIFORNIA 12 Hour Days
540347 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540348 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540349 Telemetry Concord CALIFORNIA 12 Hour Nights
540350 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540351 Cath Lab Waterloo IOWA 8 Hour Days
540423 Case Manager Oceanside CALIFORNIA 8 Hour Days
540425 CT Tech Oceanside CALIFORNIA 8 Hour Evenings
540446 Case Manager Napa CALIFORNIA 8 Hour Days
540451 Surgical Tech CVOR Pinehurst NORTH CAROLINA 10 Hour Days
540456 Med Surg Boise IDAHO 12 Hour Nights
540482 OR New York NEW YORK 12 Hour Nights
540488 SNF Staten Island NEW YORK 8 Hour Nights
540498 Pediatric ER New York NEW YORK 12 Hour Nights
540501 Supervisor New York NEW YORK 8 Hour Days
540516 RRT- Respiratory Chambersburg PENNSYLVANIA 12 Hour Day/Night Rotate
540523 L&D Lamar COLORADO 12 Hour Nights
540529 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
540565 Cath Lab Cape Girardeau MISSOURI Days
540569 Telemetry Farmington CONNECTICUT 12 Hour Nights
540582 Med Surg Des Moines IOWA 12 Hour Nights
540583 Orthopedics Des Moines IOWA 12 Hour Nights
540588 MLT Watertown NEW YORK Varied
540589 MLT Watertown NEW YORK Days
540599 Interventional Radiology Tech Pontiac MICHIGAN 8 Hour Days
540616 Cath Lab Inglewood CALIFORNIA 10 Hour Days
540619 L&D Lynwood CALIFORNIA 12 Hour Days
540624 Surgical Tech Columbus OHIO 12 Hour Days
540626 OR Mason City IOWA 8 Hour Days
540627 OR Mason City IOWA 8 Hour Days
540628 OR Mason City IOWA 8 Hour Days
540632 OR Maywood ILLINOIS 10 Hour Days
540637 PT Akron OHIO 8 Hour Days
540706 Cardiac ICU Rockford ILLINOIS 12 Hour Nights
540725 Step Down Oklahoma City OKLAHOMA 12 Hour Nights
540742 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540743 PCU Concord CALIFORNIA 12 Hour Days
540744 PCU Concord CALIFORNIA 12 Hour Days
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
540746 Med Surg Prescott ARIZONA 12 Hour Day/Night Rotate
540747 CT Tech SANTA CRUZ CALIFORNIA 8 Hour Day/Night Rotate
540748 Med Surg Tele Prescott ARIZONA 12 Hour Days
540749 Med Surg Tele Prescott ARIZONA 12 Hour Day/Night Rotate
540750 Med Surg Boise IDAHO 12 Hour Nights
540751 Med Surg Boise IDAHO 12 Hour Nights
540752 Med Surg Boise IDAHO 12 Hour Nights
540753 Med Surg Boise IDAHO 12 Hour Nights
540770 Telemetry Prescott ARIZONA 12 Hour Days
540788 Sonographer Falls Church VIRGINIA 8 Hour Days
540799 Med Surg Tele Euclid OHIO 12 Hour Nights
540802 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
540812 CT Tech Denville NEW JERSEY 8 Hour Days
540813 CT Tech Denville NEW JERSEY 12 Hour Nights
540814 NICU Lynwood CALIFORNIA 12 Hour Nights
540815 Respiratory Care Lynwood CALIFORNIA 12 Hour Nights
540821 Med Surg Tele Mayfield Heights OHIO 12 Hour Nights
540823 EEG Tech Walnut Creek CALIFORNIA 10 Hour Days
540824 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540852 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540854 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
540855 Med Surg Tele Springfield MASSACHUSETTS 8 Hour Nights
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.5051 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.id asc limit 1000,100 in 1.009 seconds