Listing all records

Displaying records 1001 through 1100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
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
544208 Med Surg Grove City OHIO 12 Hour Nights
540110 PICU Walnut Creek CALIFORNIA 12 Hour Nights
544198 Med Surg Tele Euclid OHIO 12 Hour Nights
540112 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540113 Telemetry Concord CALIFORNIA 12 Hour Nights
547027 Long Term Care Claremont NEW HAMPSHIRE 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
544222 ICU Passaic NEW JERSEY 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
544217 Med Surg Pella IOWA 12 Hour Nights
540126 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
540127 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
544230 ER Denville NEW JERSEY 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
544243 CT Tech Reno NEVADA 12 Hour Nights
544242 CT Tech Reno NEVADA 12 Hour Nights
544265 Respiratory Therapist Mishawaka INDIANA 12 Hour Nights
540146 ER Concord CALIFORNIA 12 Hour Nights
548321 Oncology Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
542103 Medical Assistant Portland OREGON 12 Hour Nights
544269 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
544270 Med Surg Tele Syracuse NEW YORK 12 Hour Nights
540151 Telemetry Concord CALIFORNIA 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
541503 PCU Spokane WASHINGTON 12 Hour Nights
540159 Telemetry Concord CALIFORNIA 12 Hour Nights
540164 Med Surg Concord CALIFORNIA 12 Hour Nights
540165 PICU Walnut Creek 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
544344 L&D Ketchum IDAHO 12 Hour Nights
544359 NICU Queens NEW YORK 12 Hour Nights RN/Registered Nurse
544354 Med Surg Meridian IDAHO 12 Hour Nights
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
544405 ER Walnut Creek CALIFORNIA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
544411 CT Tech New London NEW HAMPSHIRE 12 Hour Nights
540191 Med Surg Walnut Creek CALIFORNIA 12 Hour Nights
544436 ER IOWA CITY IOWA 12 Hour Nights
544435 ER IOWA CITY IOWA 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
542137 Med Surg Brooklyn NEW YORK 12 Hour Nights
544450 Med Surg Tele Des Moines IOWA 12 Hour Nights
544481 Lab Tech Syracuse NEW YORK 12 Hour Nights
544499 Med Surg Tele Wailuku HAWAII 12 Hour Nights
540210 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540211 ICU Concord CALIFORNIA 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
544524 Med Surg Tele Wailuku HAWAII 12 Hour Nights
544525 Telemetry Wailuku HAWAII 12 Hour Nights
544518 PCU Fayetteville NORTH CAROLINA 12 Hour Nights
540225 ICU Walnut Creek CALIFORNIA 12 Hour Nights
544531 ER Des Moines IOWA 12 Hour Nights
544529 Med Surg Kula HAWAII 12 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
544558 PCU Spokane WASHINGTON 12 Hour Nights
540234 ICU Concord CALIFORNIA 12 Hour Nights
544572 Step Down Willoughby OHIO 12 Hour Nights
540236 ICU Walnut Creek CALIFORNIA 12 Hour Nights
540237 ER Walnut Creek CALIFORNIA 12 Hour Nights
544570 ICU Burbank CALIFORNIA 12 Hour Nights
544566 Med Surg Portland OREGON 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
540242 ICU Concord CALIFORNIA 12 Hour Nights
540243 Med Surg Tele Concord CALIFORNIA 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 2.0433 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 1000,100 in 2.1215 seconds