Listing all records

Displaying records 1501 through 1600 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544525 Telemetry Wailuku HAWAII 12 Hour Nights
543974 ER Newark NEW JERSEY 12 Hour Nights
518547 NICU Per Diem/Local Contract Torrance CALIFORNIA 12 Hour Nights RN/Registered Nurse
541958 CVICU Spokane WASHINGTON 12 Hour Nights
541949 Med Surg Boise IDAHO 12 Hour Nights
542491 Med Surg Brooklyn NEW YORK 12 Hour Nights
546875 Telemetry PHOENIX ARIZONA 12 Hour Nights RN/Registered Nurse
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
545338 Med Surg Tele Glens Falls NEW YORK 12 Hour Nights
545728 Med Surg Gainesville FLORIDA 12 Hour Nights
545369 Step Down Mayfield Heights OHIO 12 Hour Nights
525646 Med Surg Boise IDAHO 12 Hour Nights
525811 CT Tech Amarillo TEXAS 12 Hour Nights Tech/Technologist
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
526356 Telemetry Boise IDAHO 12 Hour Nights
544632 ER Machias MAINE 12 Hour Nights
544627 Med Surg Tele Akron OHIO 12 Hour Nights
526545 ICU - Per Diem Woodland Hills CALIFORNIA 12 Hour Nights RN/Registered Nurse
547698 ICU Saratoga Springs NEW YORK 12 Hour Nights
534242 Med Surg Tele Des Moines IOWA 12 Hour Nights
534250 Oncology Cleveland OHIO 12 Hour Nights
534331 Neuro Med Surg/Tele PHOENIX ARIZONA 12 Hour Nights
545730 ICU Gainesville FLORIDA 12 Hour Nights
545738 ICU Gainesville FLORIDA 12 Hour Nights
544547 Med Surg Tele Fayetteville NORTH CAROLINA 12 Hour Nights
545733 Med Surg Gainesville FLORIDA 12 Hour Nights
544552 ER Newark NEW JERSEY 12 Hour Nights
534901 Telemetry Boise IDAHO 12 Hour Nights
534902 Telemetry Boise IDAHO 12 Hour Nights
534903 Telemetry Boise IDAHO 12 Hour Nights
534904 Telemetry Boise IDAHO 12 Hour Nights
544572 Step Down Willoughby OHIO 12 Hour Nights
545731 ICU Gainesville FLORIDA 12 Hour Nights
545737 ICU Gainesville FLORIDA 12 Hour Nights
545740 Med Surg Gainesville FLORIDA 12 Hour Nights
545421 RN Columbus OHIO 12 Hour Nights
535227 Orthopedics Des Moines IOWA 12 Hour Nights
535266 Med Surg Ogdensburg NEW YORK 12 Hour Nights
535387 Rehab Clive IOWA 12 Hour Nights
535463 ICU Sioux City IOWA 12 Hour Nights
535604 Med Surg Tele Maywood ILLINOIS 12 Hour Nights
543886 RAD Tech National City CALIFORNIA 12 Hour Nights
544036 Step Down Lansing MICHIGAN 12 Hour Nights
540121 Neuro Intensive Care Walnut Creek CALIFORNIA 12 Hour Nights
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
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
540129 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
545729 Med Surg Gainesville FLORIDA 12 Hour Nights
540133 ER Concord CALIFORNIA 12 Hour Nights
545343 PCU Concord NEW HAMPSHIRE 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
545610 Med Surg HOBBS NEW MEXICO 12 Hour Nights
545742 Med Surg Gainesville FLORIDA 12 Hour Nights
540146 ER Concord CALIFORNIA 12 Hour Nights
540151 Telemetry Concord CALIFORNIA 12 Hour Nights
545732 ICU Gainesville FLORIDA 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
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
540184 Med Surg Tele Concord CALIFORNIA 12 Hour Nights
540186 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540188 L&D Walnut Creek CALIFORNIA 12 Hour Nights
540191 Med Surg Walnut Creek CALIFORNIA 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
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
540225 ICU Walnut Creek CALIFORNIA 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
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 1.485 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 1500,100 in 1.4894 seconds