Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547376 PCU Charlottesville VIRGINIA 12 Hour Nights
547634 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
547860 Oncology Charlottesville VIRGINIA 10 Hour Days
547861 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547862 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547863 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
542242 Oncology Charlottesville VIRGINIA 12 Hour Nights
542243 Oncology Charlottesville VIRGINIA 12 Hour Nights
542262 CVOR Charlottesville VIRGINIA 10 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
543133 Echo Charlottesville VIRGINIA 8 Hour Days
541026 RAD Tech Charleston SOUTH CAROLINA 12 Hour Nights
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
546739 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546740 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
546743 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
546744 PCU Charleston WEST VIRGINIA 12 Hour Nights
546918 Med Surg Tele Charleston WEST VIRGINIA 12 Hour Nights
546919 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546920 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
547394 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
544310 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
544311 Cath Lab Charleston WEST VIRGINIA 12 Hour Days
544753 Interventional Radiology Tech Charleston WEST VIRGINIA 10 Hour Days
546168 Cath Lab Charleston WEST VIRGINIA 10 Hour Days
541829 RAD Tech CHANDLER ARIZONA 12 Hour Day/Night Rotate
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
530245 Telemetry CHANDLER ARIZONA 12 Hour Nights
548098 Med Surg Tele Chandler ARIZONA 12 Hour Day/Night Rotate RN/Registered Nurse
548332 Clinic Chandler ARIZONA 8 Hour Days LPN/Licensed Practical Nurse
548370 ER Chandler ARIZONA 12 Hour Nights RN/Registered Nurse
547118 Interventional Radiology Tech CHANDLER ARIZONA 8 Hour Days
547682 Echo Technologist Chambersburg PENNSYLVANIA Varied
540516 RRT- Respiratory Chambersburg PENNSYLVANIA 12 Hour Day/Night Rotate
548234 Psych Centreville ILLINOIS 12 Hour Nights RN/Registered Nurse
548049 RAD Tech Centralia WASHINGTON 8 Hour Days Tech/Technologist
546718 PCU Centralia WASHINGTON 12 Hour Nights
547846 Step Down Centralia WASHINGTON 12 Hour Nights
546331 ER Centerville IOWA 12 Hour Days
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
478398 PT Centerville IOWA Days
534167 Surgical Tech Centerville IOWA 8 Hour Days
526396 Therapy Rehab Cedar Falls IOWA Days
548057 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548060 ICU Casper WYOMING 12 Hour Days RN/Registered Nurse
548147 PCU Casper WYOMING 12 Hour Days RN/Registered Nurse
548198 ER Casa Grande ARIZONA 12 Hour Nights RN/Registered Nurse
494609 PCU Casa Grande ARIZONA 12 Hour Nights
532052 PT Carrizo Springs TEXAS Days
548246 Med Surg Tele CARMICHAEL CALIFORNIA 12 Hour Nights RN/Registered Nurse
534941 Med Surg Cape Girardeau MISSOURI Nights
534942 Med Surg Cape Girardeau MISSOURI Nights
535638 Rehab Cape Girardeau MISSOURI Nights
547564 Echo Technologist Cape Girardeau MISSOURI Days
540565 Cath Lab Cape Girardeau MISSOURI Days
543455 OR Cape Girardeau MISSOURI Days
538581 Long Term Care Canton NEW YORK 12 Hour Varied
547595 First Assist Canton OHIO 12 Hour Days
546819 Med Surg Tele Canton OHIO 12 Hour Nights
546903 Med Surg Tele Canton OHIO 12 Hour Nights
547824 Med Surg Tele Canton OHIO 12 Hour Nights
530562 CT Tech Camp Hill PENNSYLVANIA 10 Hour Nights
548220 CNA Camarillo CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
541627 PT Butte MONTANA Days
548134 Med Surg Tele Burien WASHINGTON 12 Hour Nights RN/Registered Nurse
548076 Case Manager Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
548287 Med Surg Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
516546 ER Burbank CALIFORNIA 8 Hour Days RN/Registered Nurse
517382 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
518108 Case Manager Burbank CALIFORNIA 8 Hour Days
523775 ICU Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
524038 ICU - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
527184 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
544557 Cath Lab Burbank CALIFORNIA 8 Hour Days
544570 ICU Burbank CALIFORNIA 12 Hour Nights
545096 ER Burbank CALIFORNIA 12 Hour Nights
546035 PT Burbank CALIFORNIA 8 Hour Days
546036 PT Burbank CALIFORNIA 8 Hour Days
544990 PT Buckeye WEST VIRGINIA 8 Hour Days
548289 OR Brownwood TEXAS 8 Hour Days RN/Registered Nurse
547930 ER Brownsville TEXAS 12 Hour Nights
547931 Telemetry Brownsville TEXAS 12 Hour Days
548058 Dialysis Brooklyn NEW YORK 10 Hour Days RN/Registered Nurse
548069 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548074 ICU - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548099 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548104 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548122 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548188 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548193 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548202 ER - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548215 ER Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548216 Med Surg Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
548223 Psych Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548229 ICU Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548238 Neuro Intensive Care Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548292 Med Surg Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548304 Psych Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
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.4579 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 z.city desc limit 3200,100 in 1.7166 seconds