Listing all records

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

ID Job Specialty City State Shift Title
548398 ICU Columbus OHIO 12 Hour Days RN/Registered Nurse
546422 Surgical Tech Columbus OHIO Days
547797 RAD Tech Columbus OHIO 8 Hour Days
547798 RAD Tech Columbus OHIO 8 Hour Days
545311 ICU Colville WASHINGTON 12 Hour Nights
541647 Med Surg Colville WASHINGTON 12 Hour Nights
543703 RAD Tech Commerce Twp MICHIGAN 8 Hour Nights
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
544890 ER Concord CALIFORNIA 12 Hour Days
545035 PCU Concord NEW HAMPSHIRE 12 Hour Nights
545196 Social Worker Concord CALIFORNIA 8 Hour Days
545343 PCU Concord NEW HAMPSHIRE 12 Hour Nights
540070 CT Tech Concord CALIFORNIA 10 Hour Nights
540071 PACU Concord CALIFORNIA 12 Hour Days
540076 ER Concord CALIFORNIA 12 Hour Nights
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
540085 Psych Concord CALIFORNIA 8 Hour Evenings
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
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
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
540102 Med Surg Concord 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
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
540124 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540127 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540129 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540130 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540131 Cath Lab Concord CALIFORNIA 10 Hour Days
540132 Cath Lab Concord CALIFORNIA 10 Hour Days
540133 ER Concord CALIFORNIA 12 Hour Nights
540134 Cath Lab Concord CALIFORNIA 10 Hour Days
540135 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540137 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540141 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540142 Intermediate Care Concord CALIFORNIA 12 Hour Days
540144 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540146 ER Concord CALIFORNIA 12 Hour Nights
540147 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540149 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540150 Telemetry Concord CALIFORNIA 12 Hour Days
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
540152 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540153 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540154 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540156 ER Concord CALIFORNIA 12 Hour Days
540157 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540158 Peri-Operative Concord CALIFORNIA 8 Hour Days
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
540160 Med Surg Concord CALIFORNIA 12 Hour Days
540161 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540163 Surgical Tech Concord CALIFORNIA 8 Hour Evenings
540164 Med Surg Concord CALIFORNIA 12 Hour Nights
540167 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540173 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540174 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540177 Psych Concord CALIFORNIA 8 Hour Evenings
540178 Med Surg Concord CALIFORNIA 8 Hour Evenings
540179 Case Manager Concord CALIFORNIA 12 Hour Days
540181 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540182 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540183 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540187 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540189 Peri-Operative Concord CALIFORNIA 8 Hour Days
540192 OR Concord CALIFORNIA 12 Hour Days
540194 Case Manager Concord CALIFORNIA 8 Hour Days
540195 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540197 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540198 ER Concord CALIFORNIA 12 Hour Days
540201 ER Concord CALIFORNIA 12 Hour Nights
540202 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540205 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540206 PACU Concord CALIFORNIA 10 Hour Days
540207 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540208 ICU Concord CALIFORNIA 12 Hour Days
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540213 ER Concord CALIFORNIA 12 Hour Days
540214 Case Manager Concord CALIFORNIA 8 Hour Evenings
540218 ER Concord CALIFORNIA 12 Hour Nights
540220 Med Surg Tele 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.4945 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 z.city asc limit 700,100 in 1.5321 seconds