Listing all records

Displaying records 801 through 900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
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
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
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
540106 ER Concord CALIFORNIA 12 Hour Nights
540107 Telemetry Concord CALIFORNIA 12 Hour Nights
540108 ER Concord CALIFORNIA 12 Hour Nights
540109 OR Walnut Creek CALIFORNIA 12 Hour Days
540110 PICU Walnut Creek CALIFORNIA 12 Hour Nights
540111 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540112 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
540114 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540115 ER Walnut Creek CALIFORNIA 12 Hour Nights
540116 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540117 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540118 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540119 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540120 ICU Walnut Creek CALIFORNIA 12 Hour Days
540121 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540122 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540123 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540124 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540126 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540127 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
540129 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540130 Med Surg Tele Concord CALIFORNIA 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 3.3892 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 desc limit 800,100 in 2.0157 seconds