Listing all records

Displaying records 1901 through 2000 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
546870 Vascular Ultrasound Tech Hilo HAWAII 12 Hour Day/Night Rotate
546915 Med Surg Hilo HAWAII 12 Hour Nights
547497 Pediatrics Hilo HAWAII 12 Hour Nights
547804 EEG Tech Hilo HAWAII 12 Hour Days
547835 Nuclear Med Technician Hilo HAWAII 8 Hour Days
542655 Long Term Care Hilo HAWAII 12 Hour Day/Night Rotate
538917 Med Surg Hilo HAWAII 12 Hour Day/Night Rotate
539718 Angiography Hilo HAWAII 12 Hour Day/Night Rotate
547339 Patient Care Coordinator Hillsboro OREGON 12 Hour Days
547340 Patient Care Coordinator Hillsboro OREGON 12 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
545463 Vascular Ultrasound Tech Hettinger NORTH DAKOTA 8 Hour Days
545149 Med Surg Hettinger NORTH DAKOTA 12 Hour Day/Night Rotate
541610 PT Hesperia CALIFORNIA 8 Hour Days
545887 CT Tech Hereford TEXAS 8 Hour Days
545300 Med Surg Helena MONTANA 12 Hour Nights
547580 Therapy Rehab Helena MONTANA 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
546423 PT Hayward CALIFORNIA 8 Hour Days
546281 Home Health Hayward CALIFORNIA 8 Hour Days
546011 Surgical Tech CVOR Hays KANSAS 10 Hour Days
546012 PCU Hays KANSAS 12 Hour Nights
547470 CT Tech Hays KANSAS 8 Hour Nights
529353 PTA Harwich MASSACHUSETTS Days
538435 CT Tech Harvard ILLINOIS 8 Hour Evenings
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
540883 ER Hartford CONNECTICUT 12 Hour Nights
548081 ICU Hartford CONNECTICUT 12 Hour Nights RN/Registered Nurse
548203 Technician Hartford CONNECTICUT 8 Hour Days Tech/Technologist
546811 CT Tech Harrison ARKANSAS 10 Hour Evenings
546812 Med Surg Harrison ARKANSAS 12 Hour Nights
547650 Telemetry Hannibal MISSOURI 12 Hour Days
543911 COTA Hanford CALIFORNIA Days
515247 PT Hanford CALIFORNIA Days
532598 PTA Hanford CALIFORNIA Days
548263 CNA Hampton IOWA 12 Hour Evenings CNA/Certified Nursing Assistant
546287 PT Hamilton NEW JERSEY 8 Hour Days
525081 MRI Tech Grove City OHIO 12 Hour Days
539708 Sterile Processing Technician Grove City OHIO 8 Hour Evenings
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
540956 Interventional Therapy Grove City OHIO 8 Hour Days
546389 RAD Tech Greenville SOUTH CAROLINA 8 Hour Days
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
539660 Long Term Care Greeneville TENNESSEE 12 Hour Nights
546466 Med Surg Greeneville TENNESSEE 12 Hour Nights
545553 Outpatient Clinic Greencastle INDIANA 10 Hour Days
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
548307 OR Greenbrae CALIFORNIA 12 Hour Days RN/Registered Nurse
541634 NICU Greenbrae CALIFORNIA 12 Hour Days
542347 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
547760 Med Surg Greeley COLORADO 12 Hour Nights
547905 ICU Greeley COLORADO 12 Hour Nights
542131 Echo Great Falls MONTANA 8 Hour Days
543201 Psych Grand Rapids MICHIGAN 8 Hour Evenings RN/Registered Nurse
547424 Long Term Care GRAND MARAIS MINNESOTA 8 Hour Nights
547271 PT GRAND MARAIS MINNESOTA Varied
529926 SLP Grand Junction COLORADO Days
538460 PCU Grand Island NEBRASKA 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.7144 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 1900,100 in 1.3814 seconds