Listing all records

Displaying records 1001 through 1100 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548347 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548351 NICU Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548353 Behavioral Health Modesto CALIFORNIA 12 Hour Days RN/Registered Nurse
548354 Psych National City CALIFORNIA 12 Hour Nights RN/Registered Nurse
548356 ER - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548359 ER Oceanside CALIFORNIA 12 Hour Nights RN/Registered Nurse
548361 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
548362 Telemetry Antioch CALIFORNIA 12 Hour Nights RN/Registered Nurse
548364 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548365 Med Surg BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548366 ICU Anaheim CALIFORNIA 12 Hour Days RN/Registered Nurse
548367 ER FOLSOM CALIFORNIA 12 Hour Nights RN/Registered Nurse
548368 ICU Anaheim CALIFORNIA 12 Hour Nights RN/Registered Nurse
548377 Telemetry Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548379 Postpartum Fresno CALIFORNIA 12 Hour Nights RN/Registered Nurse
548383 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
548384 Telemetry Concord CALIFORNIA 12 Hour Days RN/Registered Nurse
548385 Telemetry Antioch CALIFORNIA 12 Hour Days RN/Registered Nurse
548386 CVICU Santa Clara CALIFORNIA 12 Hour Nights RN/Registered Nurse
548387 ICU - Per Diem Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
548391 ICU Merced CALIFORNIA 12 Hour Nights RN/Registered Nurse
548393 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
548396 CVICU SANTA CRUZ CALIFORNIA 12 Hour Nights RN/Registered Nurse
548397 ICU SAN ANDREAS CALIFORNIA 12 Hour Nights RN/Registered Nurse
548405 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548410 Respiratory Therapist Lynwood CALIFORNIA 12 Hour Nights Respiratory Therapist
548020 MRI Tech Glenwood Springs COLORADO 12 Hour Varied
548035 Echo Pagosa Springs COLORADO 8 Hour Days
548095 ER Sterling COLORADO 12 Hour Nights RN/Registered Nurse
540523 L&D Lamar COLORADO 12 Hour Nights
541105 PT Estes Park COLORADO 12 Hour Day/Night Rotate
543977 Sterile Processing Tech Lamar COLORADO Days
543978 Scrub Tech Lamar COLORADO 8 Hour Day/Night Rotate
546660 OR Pueblo COLORADO 12 Hour Day/Night Rotate
546703 CT Tech Kremmling COLORADO 12 Hour Days
546788 Long Term Care Westminster COLORADO 12 Hour Nights
546795 MLT Estes Park COLORADO 12 Hour Nights
548028 CT Tech Pagosa Springs COLORADO 12 Hour Day/Night Rotate
547365 RAD Tech Aspen COLORADO 8 Hour Days
547431 L&D Pueblo COLORADO 12 Hour Nights
547499 Cath Lab Pueblo COLORADO 10 Hour Varied
547539 Case Manager Vail COLORADO Days
547760 Med Surg Greeley COLORADO 12 Hour Nights
547792 Scrub Tech Pueblo COLORADO 12 Hour Day/Night Rotate
547815 Scrub Tech Yuma COLORADO 12 Hour Nights
547905 ICU Greeley COLORADO 12 Hour Nights
547914 ER Estes Park COLORADO 12 Hour Nights
544144 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544145 Med Surg Tele Glenwood Springs COLORADO 12 Hour Day/Night Rotate
544215 Med Surg Tele Pueblo COLORADO 12 Hour Nights
544652 Med Surg Alamosa COLORADO 12 Hour Nights
544886 OR Aspen COLORADO 10 Hour Days
545079 ER Pueblo COLORADO 12 Hour Day/Night Rotate
545080 ER Pueblo COLORADO 12 Hour Nights
545532 CT Tech Montrose COLORADO 12 Hour Varied
545533 CT Tech Montrose COLORADO 12 Hour Varied
541769 Oncology Pueblo COLORADO 12 Hour Days
529926 SLP Grand Junction COLORADO Days
511950 Med Surg Manchester CONNECTICUT 12 Hour Nights
513409 ER Manchester CONNECTICUT 12 Hour Nights
514124 ER Manchester CONNECTICUT 12 Hour Nights
517691 SLP Vernon CONNECTICUT Days
541891 Telemetry Farmington CONNECTICUT 12 Hour Nights
541779 Telemetry Farmington CONNECTICUT 12 Hour Days
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
531151 RAD Tech Farmington CONNECTICUT 8 Hour Days Radiology Techs/Technologists
531152 Med Surg Tele Farmington CONNECTICUT 12 Hour Nights RN/Registered Nurse
531188 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
531706 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
532660 CMA Farmington CONNECTICUT 8 Hour Days
532981 Med Surg Tele Hartford CONNECTICUT 12 Hour Nights
533986 CMA Farmington CONNECTICUT 8 Hour Days
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
537460 Phlebotomist Farmington CONNECTICUT 8 Hour Days
537493 Med Surg Tele Waterbury CONNECTICUT 12 Hour Nights
537494 Med Surg Tele Waterbury CONNECTICUT 12 Hour Nights
537715 OR Farmington CONNECTICUT 10 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.6415 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 asc limit 1000,100 in 1.6755 seconds