Listing all records

Displaying records 1701 through 1800 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
542905 Med Surg Lewiston MAINE 12 Hour Days
543822 Certified Surgical Tech York MAINE 8 Hour Days
543913 Echo Technologist Lewiston MAINE 8 Hour Days
544632 ER Machias MAINE 12 Hour Nights
544809 Cath Lab Lewiston MAINE Days
545217 CT Tech York MAINE Days
547980 Med Surg Tele Lewiston MAINE 12 Hour Nights
547981 Med Surg Tele Lewiston MAINE 12 Hour Nights
547988 Intermediate Care Rumford MAINE 12 Hour Days
547989 Intermediate Care Rumford MAINE 12 Hour Days
548190 Psych Lewiston MAINE 12 Hour Nights RN/Registered Nurse
444999 PACU Bangor MAINE 12 Hour Days
533322 Long Term Care Lewiston MAINE 12 Hour Nights
538553 Long Term Care Lewiston MAINE 12 Hour Days
544772 Home Health Lake Charles LOUISIANA 8 Hour Days
547893 Certified Surgical Tech Lake Charles LOUISIANA 8 Hour Days
548308 ER Deridder LOUISIANA 12 Hour Nights RN/Registered Nurse
548325 SLP Shreveport LOUISIANA 8 Hour Days SLP/Speech Language Pathologist
547928 Cath Lab Lexington KENTUCKY 8 Hour Days
544508 Cath Lab Edgewood KENTUCKY 10 Hour Days
544509 Cath Lab Edgewood KENTUCKY 10 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
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
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
543419 SICU Bowling Green KENTUCKY 12 Hour Nights
543952 Cath Lab Louisville KENTUCKY 8 Hour Days
546469 OR Louisville KENTUCKY 8 Hour Days
546651 Surgical Tech Louisville KENTUCKY 8 Hour Days
546682 RAD Tech Lexington KENTUCKY 10 Hour Days
547585 RRT- Respiratory Louisville KENTUCKY 12 Hour Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
547332 SLP Garden City KANSAS Varied
547470 CT Tech Hays KANSAS 8 Hour Nights
547609 OT Garden City KANSAS 8 Hour Days
547851 Nuclear Med Technician Liberal KANSAS 8 Hour Days
544167 PT Garden City KANSAS 12 Hour Day/Night Rotate
544972 PT Garden City KANSAS Varied
546011 Surgical Tech CVOR Hays KANSAS 10 Hour Days
546012 PCU Hays KANSAS 12 Hour Nights
542401 Surgical Tech Leavenworth KANSAS 8 Hour Days
542402 Sterile Processing Tech Leavenworth KANSAS 8 Hour Days
542697 Therapy Rehab Garden City KANSAS 8 Hour Days
540351 Cath Lab Waterloo IOWA 8 Hour Days
540582 Med Surg Des Moines IOWA 12 Hour Nights
540583 Orthopedics Des Moines IOWA 12 Hour Nights
540626 OR Mason City IOWA 8 Hour Days
540627 OR Mason City IOWA 8 Hour Days
540628 OR Mason City IOWA 8 Hour Days
540972 MLT Des Moines IOWA 10 Hour Nights
541071 Med Surg Tele Des Moines IOWA 12 Hour Nights
541072 Orthopedics Des Moines IOWA 12 Hour Nights
541076 Med Surg Des Moines IOWA 12 Hour Nights
541078 Oncology Des Moines IOWA 12 Hour Nights
541108 Ultrasound Tech Sioux City IOWA 8 Hour Days
543024 Interventional Radiology Des Moines IOWA 10 Hour Days
542387 Med Surg Des Moines IOWA 12 Hour Days
542423 OR IOWA CITY IOWA 10 Hour Days
542424 PT Norwalk IOWA Days
542466 Neurology Des Moines IOWA 12 Hour Nights
542642 Cath Lab Mason City IOWA 8 Hour Days
544434 Telemetry IOWA CITY IOWA 12 Hour Nights
543122 ER Primghar IOWA 12 Hour Nights
543123 ER Primghar IOWA 12 Hour Nights
543126 Cath Lab Mason City IOWA 8 Hour Days
543729 OR Pella IOWA 10 Hour Varied
544530 Med Surg Waterloo IOWA 12 Hour Nights
546331 ER Centerville IOWA 12 Hour Days
546366 ER Waterloo IOWA 12 Hour Nights
546461 ER Des Moines IOWA 12 Hour Days
546462 ER Des Moines IOWA 12 Hour Days
546635 ER Des Moines IOWA 12 Hour Nights
546679 OR Waterloo IOWA 12 Hour Days
546768 Med Surg IOWA CITY IOWA 12 Hour Nights
546770 Surgical Tech IOWA CITY IOWA Days
546785 Med Surg IOWA CITY IOWA 12 Hour Day/Night Rotate
546798 Interventional Radiology Tech IOWA CITY IOWA Days
546913 ER Des Moines IOWA 12 Hour Days
546934 RAD Tech Dubuque IOWA 12 Hour Nights
546999 Rehab Sioux City IOWA 12 Hour Nights
547000 Med Surg Dubuque IOWA 12 Hour Days
547002 Med Surg Dubuque IOWA 12 Hour Days
547068 CT Tech Pella IOWA 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.9325 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 y.name desc limit 1700,100 in 1.4201 seconds