Listing all records

Displaying records 1601 through 1700 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546343 Med Surg Tele Lubbock TEXAS 12 Hour Days
541606 Surgical Tech CVOR Lubbock TEXAS 10 Hour Days
535911 Telemetry Lubbock TEXAS 12 Hour Days RN/Registered Nurse
548264 CNA Lowville NEW YORK 8 Hour Nights CNA/Certified Nursing Assistant
522473 CNA Lowville NEW YORK 8 Hour Evenings
522479 CNA Lowville NEW YORK 8 Hour Evenings
543032 Long Term Care Lowville NEW YORK 12 Hour Nights
547676 ICU Lowville NEW YORK 12 Hour Nights
547677 Med Surg Lowville NEW YORK 12 Hour Days
547678 Med Surg Lowville NEW YORK 12 Hour Days
547818 Long Term Care Lowville NEW YORK 12 Hour Days
547819 Long Term Care Lowville NEW YORK 12 Hour Days
548040 PCU Lowell MASSACHUSETTS 12 Hour Nights RN/Registered Nurse
529609 PT Low Moor VIRGINIA Days
541860 PT Lovington NEW MEXICO 8 Hour Days
547899 CNA Lovell WYOMING 12 Hour Days
546469 OR Louisville KENTUCKY 8 Hour Days
546651 Surgical Tech Louisville KENTUCKY 8 Hour Days
547585 RRT- Respiratory Louisville KENTUCKY 12 Hour Days
515845 MLT Louisville KENTUCKY Nights
521665 Surgical Tech Louisville KENTUCKY 12 Hour Day/Night Rotate
524484 Cath Lab Louisville KENTUCKY 12 Hour Nights
525673 Cardiology Louisville KENTUCKY 8 Hour Days
527553 Cath Lab Louisville KENTUCKY 8 Hour Days
528270 Surgical Tech Louisville KENTUCKY 12 Hour Days
531388 Cath Lab Louisville KENTUCKY 12 Hour Nights
532201 RAD Tech Louisville KENTUCKY 8 Hour Days
532202 RAD Tech Louisville KENTUCKY 8 Hour Days
532559 MRI Tech Louisville KENTUCKY 10 Hour Days
532661 MLT Louisville KENTUCKY 8 Hour Evenings
534553 Surgical Tech Louisville KENTUCKY 8 Hour Days
535030 Surgical Tech Louisville KENTUCKY 12 Hour Days
539378 RAD Tech Louisville KENTUCKY 12 Hour Nights
539930 Surgical Tech Louisville KENTUCKY 8 Hour Days
542573 Surgical Tech Louisville KENTUCKY 12 Hour Days
541736 OR Louisville KENTUCKY 10 Hour Days
543952 Cath Lab Louisville KENTUCKY 8 Hour Days
470815 PT Los Gatos CALIFORNIA Varied
548154 Home Health Los Angeles Downey CALIFORNIA 8 Hour Days RN/Registered Nurse
548051 CNA - Per Diem Los Angeles CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
548061 PACU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548084 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548279 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548319 ICU Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548333 ICU Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548387 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
516920 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548256 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548259 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548261 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
523059 CVOR Tech Los Angeles CALIFORNIA 10 Hour Days CST/Certified Surgical Technician
527493 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
525930 RAD Tech Los Angeles CALIFORNIA 10 Hour Days Radiology Techs/Technologists
526101 ICU Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
527570 Med Surg Tele Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530725 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
529699 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
529991 Therapy Rehab Los Angeles CALIFORNIA Days
530739 Med Surg Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
530071 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
531204 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
531848 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
532090 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
532091 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
536828 Radiation Therapy Los Angeles CALIFORNIA 8 Hour Days
538137 ER - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
539941 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546301 Med Surg Tele Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
546640 NICU Los Angeles CALIFORNIA 12 Hour Days
547331 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547384 Registered Dietician Los Angeles CALIFORNIA 8 Hour Days
547636 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
547647 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
547796 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
540529 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
542523 Surgical Tech CVOR Los Angeles CALIFORNIA 12 Hour Days
543575 Nuclear Med Technician Los Angeles CALIFORNIA 8 Hour Days
544446 MLT Los Angeles CALIFORNIA 8 Hour Days
544670 RAD Tech Los Angeles CALIFORNIA 8 Hour Days
462914 Wound Care Los Alamitos CALIFORNIA 8 Hour Days
548201 Medical Assistant Longview WASHINGTON 8 Hour Days Medical Assistant
543801 CT Tech Long Prairie MINNESOTA 12 Hour Days
546951 Surgical Tech Long Beach CALIFORNIA 12 Hour Nights
548107 Case Manager Littleton NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
542008 CVICU Little Rock ARKANSAS 12 Hour Days
545299 CVICU Little Rock ARKANSAS 12 Hour Nights
519153 CVICU Little Rock ARKANSAS 12 Hour Nights
538454 CVICU Little Rock ARKANSAS 12 Hour Nights
499331 SLP Little Egg Harbor Township NEW JERSEY Days
547582 SLP Lincoln City OREGON 8 Hour Days
547851 Nuclear Med Technician Liberal KANSAS 8 Hour Days
546682 RAD Tech Lexington KENTUCKY 10 Hour Days
547928 Cath Lab Lexington KENTUCKY 8 Hour Days
536463 ICU Lexington KENTUCKY 12 Hour Nights
537910 PCU Lexington KENTUCKY 12 Hour Nights
538869 MRI Tech Lexington KENTUCKY 8 Hour Nights
546342 Cath Lab Lexington KENTUCKY 10 Hour Days
545380 L&D Lewistown MONTANA Nights
544347 Certified Surgical Tech Lewiston IDAHO 10 Hour Days
544809 Cath Lab Lewiston MAINE 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.3713 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 1600,100 in 1.3266 seconds