Listing all records

Displaying records 901 through 1000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545797 Med Surg Gainesville FLORIDA 12 Hour Days
545814 Med Surg Gainesville FLORIDA 12 Hour Days
545818 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545817 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545829 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540109 OR Walnut Creek CALIFORNIA 12 Hour Days
545822 Med Surg Gainesville FLORIDA 12 Hour Days
540111 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545843 ICU Gainesville FLORIDA 12 Hour Days
545844 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540114 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545841 Med Surg Gainesville FLORIDA 12 Hour Days
545852 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545855 Med Surg Gainesville FLORIDA 12 Hour Days
545854 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545850 Med Surg Gainesville FLORIDA 12 Hour Days
540120 ICU Walnut Creek CALIFORNIA 12 Hour Days
545863 Med Surg Gainesville FLORIDA 12 Hour Days
540122 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545856 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545870 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540125 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
545868 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545865 Med Surg Gainesville FLORIDA 12 Hour Days
540128 ICU Walnut Creek CALIFORNIA 12 Hour Days
540130 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545878 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545873 Med Surg Gainesville FLORIDA 12 Hour Days
545882 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
545884 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540138 NICU Walnut Creek CALIFORNIA 12 Hour Days
540140 L&D Walnut Creek CALIFORNIA 12 Hour Days
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
540145 L&D Walnut Creek CALIFORNIA 12 Hour Days
545898 Med Surg Gainesville FLORIDA 12 Hour Days
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
545902 ICU Gainesville FLORIDA 12 Hour Days
540153 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545919 Med Surg Gainesville FLORIDA 12 Hour Days
545918 Med Surg Gainesville FLORIDA 12 Hour Days
540156 ER Concord CALIFORNIA 12 Hour Days
545920 Med Surg Gainesville FLORIDA 12 Hour Days
545921 Med Surg Gainesville FLORIDA 12 Hour Days
540160 Med Surg Concord CALIFORNIA 12 Hour Days
540161 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540162 PACU Walnut Creek CALIFORNIA 12 Hour Days
545929 Med Surg Gainesville FLORIDA 12 Hour Days
545925 Med Surg Gainesville FLORIDA 12 Hour Days
540166 NICU Walnut Creek CALIFORNIA 12 Hour Days
545924 Med Surg Gainesville FLORIDA 12 Hour Days
540169 L&D Walnut Creek CALIFORNIA 12 Hour Days
545940 Med Surg Gainesville FLORIDA 12 Hour Days
545933 Med Surg Gainesville FLORIDA 12 Hour Days
545945 Med Surg Gainesville FLORIDA 12 Hour Days
545962 ICU Gainesville FLORIDA 12 Hour Days
545961 Med Surg Gainesville FLORIDA 12 Hour Days
545944 ICU Issaquah WASHINGTON 12 Hour Days
540176 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540179 Case Manager Concord CALIFORNIA 12 Hour Days
540180 Surgical Tech Walnut Creek 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
545976 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540185 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Days
545971 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540187 Med Surg Tele Concord CALIFORNIA 12 Hour Days
545978 RRT- Respiratory Gainesville FLORIDA 12 Hour Days
540190 L&D Walnut Creek CALIFORNIA 12 Hour Days
545988 Long Term Care King City CALIFORNIA 12 Hour Days
540192 OR Concord CALIFORNIA 12 Hour Days
540195 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540198 ER Concord CALIFORNIA 12 Hour Days
540205 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540207 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540208 ICU Concord CALIFORNIA 12 Hour Days
540209 NICU Walnut Creek CALIFORNIA 12 Hour Days
546072 Surgical Tech Commerce Twp MICHIGAN 12 Hour Days
546069 PCU Glendale ARIZONA 12 Hour Days RN/Registered Nurse
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540213 ER Concord CALIFORNIA 12 Hour Days
546096 ICU Hilo HAWAII 12 Hour Days
540217 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
546128 Certified Surgical Tech Florence SOUTH CAROLINA 12 Hour Days
546127 Med Surg Oxford NORTH CAROLINA 12 Hour Days
540221 PICU Walnut Creek CALIFORNIA 12 Hour Days
540222 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540223 ER Concord CALIFORNIA 12 Hour Days
540226 Telemetry Concord CALIFORNIA 12 Hour Days
540227 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540228 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540229 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540230 ICU Walnut Creek CALIFORNIA 12 Hour Days
540231 Med Surg Tele Concord CALIFORNIA 12 Hour Days
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
546198 Med Surg Bristol TENNESSEE 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.5385 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.shift asc limit 900,100 in 1.7311 seconds