Listing all records

Displaying records 2201 through 2300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
545838 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545839 ICU Gainesville FLORIDA 12 Hour Nights
545840 Intermediate Care Gainesville FLORIDA 12 Hour Nights
547640 Med Surg Seattle WASHINGTON 12 Hour Nights
545842 ICU Gainesville FLORIDA 12 Hour Nights
547643 Med Surg Olympia WASHINGTON 12 Hour Nights
545845 Med Surg Gainesville FLORIDA 12 Hour Nights
545846 Med Surg Gainesville FLORIDA 12 Hour Nights
545847 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545848 RRT- Respiratory Gainesville FLORIDA 12 Hour Nights
545849 Med Surg Gainesville FLORIDA 12 Hour Nights
547651 Med Surg Tele Spartanburg SOUTH CAROLINA 12 Hour Nights
545851 ICU Gainesville FLORIDA 12 Hour Nights
547658 PCU Omaha NEBRASKA 12 Hour Nights
547655 Med Surg Kearney NEBRASKA 12 Hour Nights
547665 Oncology Oceanside CALIFORNIA 12 Hour Nights
547654 PCU Kearney NEBRASKA 12 Hour Nights
548214 Psych Peoria ILLINOIS 12 Hour Evenings RN/Registered Nurse
548263 CNA Hampton IOWA 12 Hour Evenings CNA/Certified Nursing Assistant
548207 ER Mission Hills CALIFORNIA 12 Hour Evenings RN/Registered Nurse
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
545967 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
541734 Med Surg Brooklyn NEW YORK 12 Hour Evenings
545774 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
545780 Pediatric ER Gainesville FLORIDA 12 Hour Evenings
444999 PACU Bangor MAINE 12 Hour Days
545014 Medical Assistant Claremont NEW HAMPSHIRE 12 Hour Days
541886 Rehab Chesterfield MONTANA 12 Hour Days
541846 PCU Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
546608 Med Surg Spokane WASHINGTON 12 Hour Days
546629 PCU Bristol TENNESSEE 12 Hour Days
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
526102 ICU New York NEW YORK 12 Hour Days RN/Registered Nurse
526268 Interventional Radiology Tech Fresno CALIFORNIA 12 Hour Days
546624 ER Saratoga Springs NEW YORK 12 Hour Days
535099 Radiology Bronx NEW YORK 12 Hour Days
546623 ER Saratoga Springs NEW YORK 12 Hour Days
546843 Telemetry Farmington CONNECTICUT 12 Hour Days
535179 CT Tech Columbus OHIO 12 Hour Days
546679 OR Waterloo IOWA 12 Hour Days
546625 ER Saratoga Springs NEW YORK 12 Hour Days
535418 Respiratory Therapist Mason City IOWA 12 Hour Days
548402 ICU New Lenox ILLINOIS 12 Hour Days RN/Registered Nurse
546622 ER Saratoga Springs NEW YORK 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
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540213 ER Concord CALIFORNIA 12 Hour Days
540217 Med Surg Walnut Creek CALIFORNIA 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
546985 Med Surg Tele Syracuse NEW YORK 12 Hour Days
540233 PICU Walnut Creek CALIFORNIA 12 Hour Days
540235 ICU Concord CALIFORNIA 12 Hour Days
540238 ICU Walnut Creek CALIFORNIA 12 Hour Days
540239 OR Walnut Creek CALIFORNIA 12 Hour Days
540240 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540241 ICU Concord CALIFORNIA 12 Hour Days
540244 ICU Concord CALIFORNIA 12 Hour Days
540246 ICU Walnut Creek CALIFORNIA 12 Hour Days
540247 L&D Walnut Creek CALIFORNIA 12 Hour Days
540248 Med Surg Walnut Creek CALIFORNIA 12 Hour Days
540249 Med Surg Tele Walnut Creek CALIFORNIA 12 Hour Days
540254 NICU Walnut Creek CALIFORNIA 12 Hour Days
540256 ER Concord CALIFORNIA 12 Hour Days
546801 PICU Walnut Creek CALIFORNIA 12 Hour Days
545169 Acute Care Bronx NEW YORK 12 Hour Days
545173 Med Surg Brooklyn NEW YORK 12 Hour Days
545179 Med Surg Brooklyn NEW YORK 12 Hour Days
545191 Surgical Tech New Albany OHIO 12 Hour Days
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
545279 Cardiovascular Dubuque IOWA 12 Hour Days
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
545284 OR El Paso TEXAS 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545392 CT Tech Anchorage ALASKA 12 Hour Days
545405 Surgical Tech CVOR Weston FLORIDA 12 Hour Days
545413 MLT Ely NEVADA 12 Hour Days
545423 Med Surg Waterbury CONNECTICUT 12 Hour Days
545424 Med Surg Waterbury CONNECTICUT 12 Hour Days
545425 L&D Mishawaka INDIANA 12 Hour Days
545426 NICU Mishawaka INDIANA 12 Hour Days
545498 Respiratory Therapist Des Moines IOWA 12 Hour Days
545499 Respiratory Therapist Des Moines IOWA 12 Hour Days
545500 Med Surg Tele Des Moines IOWA 12 Hour Days
545501 Med Surg Tele Des Moines IOWA 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.3452 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 2200,100 in 1.6761 seconds