Listing all records

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

ID Job Specialty City State Shift Title
548029 PT Goldendale WASHINGTON Days
546345 CT Tech Goodyear ARIZONA 10 Hour Days
547781 CT Tech Goodyear ARIZONA 10 Hour Nights
547065 Med Surg Grand Forks NORTH DAKOTA Days
547448 Med Surg Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547816 Angiography Grand Forks NORTH DAKOTA Days
547817 Respiratory Therapist Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
541782 ICU Grand Forks NORTH DAKOTA 12 Hour Day/Night Rotate
538460 PCU Grand Island NEBRASKA 12 Hour Nights
529926 SLP Grand Junction COLORADO Days
547424 Long Term Care GRAND MARAIS MINNESOTA 8 Hour Nights
547271 PT GRAND MARAIS MINNESOTA Varied
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings RN/Registered Nurse
542131 Echo Great Falls MONTANA 8 Hour Days
547760 Med Surg Greeley COLORADO 12 Hour Nights
547905 ICU Greeley COLORADO 12 Hour Nights
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
542347 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
548307 OR Greenbrae CALIFORNIA 12 Hour Days RN/Registered Nurse
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
539660 Long Term Care Greeneville TENNESSEE 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
546874 Med Surg Tele Greensboro NORTH CAROLINA 12 Hour Nights
548221 Social Worker Greensboro NORTH CAROLINA 8 Hour Days Social Worker
548235 ER Greensboro NORTH CAROLINA 12 Hour Nights RN/Registered Nurse
546389 RAD Tech Greenville SOUTH CAROLINA 8 Hour Days
525081 MRI Tech Grove City OHIO 12 Hour Days
539708 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
540956 Interventional Therapy Grove City OHIO 8 Hour Days
544208 Med Surg Grove City OHIO 12 Hour Nights
544209 Med Surg Grove City OHIO 12 Hour Nights
544835 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
545240 ER Grove City OHIO 12 Hour Nights
546287 PT Hamilton NEW JERSEY 8 Hour Days
548263 CNA Hampton IOWA 12 Hour Evenings CNA/Certified Nursing Assistant
515247 PT Hanford CALIFORNIA Days
532598 PTA Hanford CALIFORNIA Days
543911 COTA Hanford CALIFORNIA Days
547650 Telemetry Hannibal MISSOURI 12 Hour Days
546811 CT Tech Harrison ARKANSAS 10 Hour Evenings
546812 Med Surg Harrison ARKANSAS 12 Hour Nights
540883 ER Hartford CONNECTICUT 12 Hour Nights
526714 CT Tech Hartford CONNECTICUT 8 Hour Nights
528005 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
529660 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
530655 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
531334 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
531188 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
531706 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
532981 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534043 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534044 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534045 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534046 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534047 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534048 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534049 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534052 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534053 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534054 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534055 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534056 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534057 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534058 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534059 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534060 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534061 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
534062 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
534063 Med Surg Tele Hartford CONNECTICUT 12 Hour Days
536708 Surgical Tech Hartford CONNECTICUT 12 Hour Days
548081 ICU Hartford CONNECTICUT 12 Hour Nights RN/Registered Nurse
548203 Technician Hartford CONNECTICUT 8 Hour Days Tech/Technologist
538435 CT Tech Harvard ILLINOIS 8 Hour Evenings
529353 PTA Harwich MASSACHUSETTS Days
547470 CT Tech Hays KANSAS 8 Hour Nights
546011 Surgical Tech CVOR Hays KANSAS 10 Hour Days
546012 PCU Hays KANSAS 12 Hour Nights
546423 PT Hayward CALIFORNIA 8 Hour Days
546281 Home Health Hayward CALIFORNIA 8 Hour Days
546282 PT Hayward CALIFORNIA 8 Hour Days
546283 PT Hayward CALIFORNIA 8 Hour Days
546286 PT Hayward CALIFORNIA 8 Hour Days
546414 Home Health Hayward CALIFORNIA 8 Hour Days
542734 PT Hayward CALIFORNIA 8 Hour Days
527223 PTA Hayward CALIFORNIA Days
530850 Home Health Hayward CALIFORNIA 8 Hour Days
533910 PT Hayward CALIFORNIA 8 Hour Days
545300 Med Surg Helena MONTANA 12 Hour Nights
547580 Therapy Rehab Helena MONTANA Days
545887 CT Tech Hereford TEXAS 8 Hour Days
541610 PT Hesperia CALIFORNIA 8 Hour Days
545149 Med Surg Hettinger NORTH DAKOTA 12 Hour Day/Night Rotate
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
512894 MLT Hickory NORTH CAROLINA 12 Hour Days
513169 Phlebotomist Hickory NORTH CAROLINA 12 Hour Nights
513688 Certified Surgical Tech Hickory NORTH CAROLINA 8 Hour Days
515218 Sterile Processing Technician Hickory NORTH CAROLINA 12 Hour Nights
547339 Patient Care Coordinator Hillsboro OREGON 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.4331 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 asc limit 1700,100 in 1.4317 seconds