Listing all records

Displaying records 701 through 800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540006 PCU Walnut Creek CALIFORNIA 12 Hour Nights
540007 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540008 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540009 MLT Farmington CONNECTICUT 8 Hour Evenings
540010 OR Walnut Creek CALIFORNIA 12 Hour Days
540011 Telemetry Farmington CONNECTICUT 12 Hour Nights
540012 RAD Tech Farmington CONNECTICUT 10 Hour Evenings
540013 Monitor Tech Farmington CONNECTICUT 8 Hour Evenings
540014 Surgical Tech Farmington CONNECTICUT 10 Hour Days
540015 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540016 Monitor Tech Farmington CONNECTICUT 8 Hour Days
540017 RAD Tech Farmington CONNECTICUT 10 Hour Days
540018 Surgical Tech Farmington CONNECTICUT 8 Hour Days
540019 OR Farmington CONNECTICUT 12 Hour Days
540020 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540021 L&D Walnut Creek CALIFORNIA 12 Hour Days
540022 Interventional Radiology Farmington CONNECTICUT 10 Hour Days
540023 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540024 Phlebotomist Farmington CONNECTICUT 8 Hour Days
540025 OR Concord CALIFORNIA 10 Hour Evenings
540026 OR Concord CALIFORNIA 8 Hour Days
540027 OR Concord CALIFORNIA 12 Hour Days
540028 OR Concord CALIFORNIA 10 Hour Days
540029 PCU Concord CALIFORNIA 8 Hour Days
540030 L&D Walnut Creek CALIFORNIA 12 Hour Days
540031 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540032 Surgical Tech CVOR Farmington CONNECTICUT 8 Hour Days
540033 Med Surg Tele Concord CALIFORNIA 8 Hour Days
540034 PCU Concord CALIFORNIA 8 Hour Nights
540035 PCU Concord CALIFORNIA 8 Hour Days
540036 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540037 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540038 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540039 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540040 Telemetry Farmington CONNECTICUT 12 Hour Days
540041 Ultrasound Tech Farmington CONNECTICUT 12 Hour Days
540042 ICU Concord CALIFORNIA 12 Hour Days
540043 CMA Farmington CONNECTICUT 8 Hour Days
540044 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540045 OR Farmington CONNECTICUT 10 Hour Days
540046 Peri-Operative Walnut Creek CALIFORNIA 10 Hour Days
540047 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540048 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540049 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Nights
540050 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540051 Psych Concord CALIFORNIA 8 Hour Evenings
540052 Psych Concord CALIFORNIA 8 Hour Evenings
540053 OR Walnut Creek CALIFORNIA 12 Hour Nights
540054 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540055 ICU Farmington CONNECTICUT 12 Hour Nights
540056 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540057 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540058 OR Walnut Creek CALIFORNIA 12 Hour Days
540059 PACU Concord CALIFORNIA 10 Hour Days
540060 CT Tech Farmington CONNECTICUT 10 Hour Days
540061 OR Farmington CONNECTICUT 10 Hour Days
540062 OR Farmington CONNECTICUT 10 Hour Days
540063 Telemetry Farmington CONNECTICUT 12 Hour Nights
540064 Sterile Processing Technician Walnut Creek CALIFORNIA 8 Hour Evenings
540065 Telemetry Farmington CONNECTICUT 12 Hour Days
540066 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540067 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540068 NICU Walnut Creek CALIFORNIA 12 Hour Days
540069 NICU Walnut Creek CALIFORNIA 12 Hour Days
540070 CT Tech Concord CALIFORNIA 10 Hour Nights
540071 PACU Concord CALIFORNIA 12 Hour Days
540072 ER Walnut Creek CALIFORNIA 12 Hour Nights
540073 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540074 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540075 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540076 ER Concord CALIFORNIA 12 Hour Nights
540077 OR Walnut Creek CALIFORNIA 12 Hour Days
540078 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540079 Cath Lab Concord CALIFORNIA 10 Hour Days
540080 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540081 Case Manager Concord CALIFORNIA 8 Hour Days
540082 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540083 RAD Tech Farmington CONNECTICUT 8 Hour Days
540084 OR Walnut Creek CALIFORNIA 12 Hour Days
540085 Psych Concord CALIFORNIA 8 Hour Evenings
540086 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540087 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540088 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540089 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540090 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540091 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540092 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540093 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540094 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
540095 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540096 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540097 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540098 Case Manager Concord CALIFORNIA 8 Hour Evenings
540099 ER Concord CALIFORNIA 12 Hour Nights
540100 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540101 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540102 Med Surg Concord CALIFORNIA 12 Hour Nights
540103 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540105 ICU Concord CALIFORNIA 12 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.6969 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 700,100 in 1.0698 seconds