Listing all records

Displaying records 1101 through 1200 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540112 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
544705 ER Des Moines IOWA 12 Hour Nights
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
540121 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540123 Postpartum Walnut Creek CALIFORNIA 12 Hour Nights
540124 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
544751 Med Surg Tele Everett WASHINGTON 12 Hour Nights
540126 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540127 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540129 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540133 ER Concord CALIFORNIA 12 Hour Nights
540135 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540136 Surgical Tech Walnut Creek CALIFORNIA 12 Hour Nights
540137 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
544819 ER Schenectady NEW YORK 12 Hour Nights
544853 Med Surg Kingsport TENNESSEE 12 Hour Nights
540146 ER Concord CALIFORNIA 12 Hour Nights
544870 ICU Oxford NORTH CAROLINA 12 Hour Nights
544871 ICU Oxford NORTH CAROLINA 12 Hour Nights
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
544877 Med Surg Tele Portland OREGON 12 Hour Nights
540154 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540155 ER Walnut Creek CALIFORNIA 12 Hour Nights
540157 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
542685 Postpartum Kealakekua HAWAII 12 Hour Nights
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
544894 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
544804 ER Lumberton NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
540164 Med Surg Concord CALIFORNIA 12 Hour Nights
540165 PICU Walnut Creek CALIFORNIA 12 Hour Nights
544908 ER Oceanside CALIFORNIA 12 Hour Nights
540167 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540168 Pediatrics Walnut Creek CALIFORNIA 12 Hour Nights
540170 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540171 PACU Walnut Creek CALIFORNIA 12 Hour Nights
540172 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540173 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540174 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540175 ICU Walnut Creek CALIFORNIA 12 Hour Nights
544937 Med Surg Detroit MICHIGAN 12 Hour Nights
543092 MICU San Dimas CALIFORNIA 12 Hour Nights
543090 MICU San Dimas CALIFORNIA 12 Hour Nights
544952 Med Surg Boise IDAHO 12 Hour Nights
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
544995 PCU Omaha NEBRASKA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
542615 Telemetry Terre Haute INDIANA 12 Hour Nights
545003 PCU Palm Springs CALIFORNIA 12 Hour Nights
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
540197 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540199 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540200 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540201 ER Concord CALIFORNIA 12 Hour Nights
540202 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540203 ICU Walnut Creek CALIFORNIA 12 Hour Nights
548322 PICU Bronx NEW YORK 12 Hour Nights RN/Registered Nurse
545071 RRT- Respiratory Cleveland OHIO 12 Hour Nights
545080 ER Pueblo COLORADO 12 Hour Nights
545092 ER Portland OREGON 12 Hour Nights
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 12 Hour Nights
545096 ER Burbank CALIFORNIA 12 Hour Nights
543097 Respiratory Therapist Newark NEW JERSEY 12 Hour Nights
540215 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540216 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540218 ER Concord CALIFORNIA 12 Hour Nights
540219 NICU Walnut Creek CALIFORNIA 12 Hour Nights
540220 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545128 Med Surg Albuquerque NEW MEXICO 12 Hour Nights
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
545136 Med Surg Tele Garfield Heights OHIO 12 Hour Nights
545133 Med Surg Pinehurst NORTH CAROLINA 12 Hour Nights
545154 RAD Tech Lebanon NEW HAMPSHIRE 12 Hour Nights
545165 Telemetry Cleveland OHIO 12 Hour Nights
545192 Acute Care Bronx NEW YORK 12 Hour Nights
540234 ICU Concord CALIFORNIA 12 Hour Nights
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
545207 ER Des Moines IOWA 12 Hour Nights
545206 Orthopedics Des Moines IOWA 12 Hour Nights
545227 Telemetry Cleveland OHIO 12 Hour Nights
540242 ICU Concord CALIFORNIA 12 Hour Nights
540243 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545226 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545232 Step Down Cleveland OHIO 12 Hour Nights
540250 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
540251 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540252 NICU Walnut Creek 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.5098 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 desc limit 1100,100 in 1.3324 seconds