Listing all records

Displaying records 1801 through 1900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
544793 Cath Lab Bartlett TENNESSEE 8 Hour Days
544809 Cath Lab Lewiston MAINE Days
545305 Cath Lab Honolulu HAWAII Nights
544947 Cath Lab Johnson City TENNESSEE Days
547490 Pharmacist Abilene TEXAS 12 Hour Days
535732 Pharmacist New York NEW YORK 8 Hour Nights
543955 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543957 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543958 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
543959 Pharmacist Oklahoma City OKLAHOMA 8 Hour Days
546680 Pharmacist Tuba City ARIZONA 12 Hour Day/Night Rotate
521399 LPN/LVN Atlanta GEORGIA 8 Hour Days LVN
522373 LPN/LVN Bethel ALASKA Days
525077 LPN/LVN Mason City IOWA 12 Hour Days
525078 LPN/LVN Mason City IOWA 12 Hour Nights
545997 LPN/LVN King City CALIFORNIA 12 Hour Days
546986 LPN/LVN SAN ANDREAS CALIFORNIA 8 Hour Days
548328 LPN/LVN Oneonta NEW YORK 12 Hour Days LPN/Licensed Practical Nurse
535095 LPN/LVN Quincy CALIFORNIA Varied
548023 LPN/LVN Mullins SOUTH CAROLINA 12 Hour Nights
545280 LPN/LVN SANTA MARIA CALIFORNIA 8 Hour Days
547451 LPN/LVN Abilene TEXAS 8 Hour Day/Night Rotate
547966 LPN/LVN Spanaway WASHINGTON Days
548048 LPN/LVN Rancho Cordova CALIFORNIA 12 Hour Nights LVN
547461 Radiology Tech Auburn NEW YORK 12 Hour Days
547669 Home Health Springfield VERMONT 8 Hour Day/Night Rotate
548183 Home Health Anaheim CALIFORNIA 8 Hour Days RN/Registered Nurse
547985 Home Health Portland OREGON 8 Hour Days
546281 Home Health Hayward CALIFORNIA 8 Hour Days
530850 Home Health Hayward CALIFORNIA 8 Hour Days
534888 Home Health Lawton OKLAHOMA 8 Hour Days
548153 Home Health Pomona CALIFORNIA 8 Hour Days RN/Registered Nurse
538302 Home Health Plains MONTANA Varied
539712 Home Health Mason City IOWA 8 Hour Days
548254 Home Health Santa Rosa CALIFORNIA 8 Hour Days RN/Registered Nurse
546414 Home Health Hayward CALIFORNIA 8 Hour Days
545342 Home Health Rockford ILLINOIS 12 Hour Day/Night Rotate
542340 Home Health Santa Fe NEW MEXICO 8 Hour Days RN/Registered Nurse
547984 Home Health Portland OREGON 8 Hour Days
543454 Home Health Fargo NORTH DAKOTA 8 Hour Day/Night Rotate
547368 Home Health Sarasota FLORIDA 8 Hour Days
548154 Home Health Los Angeles Downey CALIFORNIA 8 Hour Days RN/Registered Nurse
544772 Home Health Lake Charles LOUISIANA 8 Hour Days
462914 Wound Care Los Alamitos CALIFORNIA 8 Hour Days
547766 Wound Care Pittsfield MASSACHUSETTS 8 Hour Days
547881 Wound Care State College PENNSYLVANIA 8 Hour Days
547009 Wound Care Anchorage ALASKA 8 Hour Days
545470 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
521294 Ultrasound Tech Bethel ALASKA Days
547408 Ultrasound Tech Cooperstown NEW YORK 10 Hour Days
532907 Ultrasound Tech Mason City IOWA 8 Hour Days
535919 Ultrasound Tech Lawton OKLAHOMA 8 Hour Days
545890 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
547852 Ultrasound Tech Fredericksburg VIRGINIA 8 Hour Days
539896 Ultrasound Tech York PENNSYLVANIA 12 Hour Day/Night Rotate
541107 Ultrasound Tech Sioux City IOWA 8 Hour Days
545700 Ultrasound Tech Gainesville FLORIDA 10 Hour Days
540041 Ultrasound Tech Farmington CONNECTICUT 12 Hour Days
546668 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
548086 Ultrasound Tech Cobleskill NEW YORK 8 Hour Days Tech/Technologist
545964 Ultrasound Tech Gainesville FLORIDA 12 Hour Days
545336 Ultrasound Tech Abingdon VIRGINIA 12 Hour Days
541108 Ultrasound Tech Sioux City IOWA 8 Hour Days
541613 Ultrasound Tech Portland OREGON 8 Hour Days
543152 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
542347 Ultrasound Tech Greenbrae CALIFORNIA 12 Hour Day/Night Rotate
545696 Ultrasound Tech Gainesville FLORIDA 8 Hour Days
543153 Ultrasound Tech Concord NEW HAMPSHIRE 8 Hour Days
543193 Ultrasound Tech Farmington CONNECTICUT 8 Hour Days
543330 Ultrasound Tech San Angelo TEXAS 12 Hour Nights
543510 Ultrasound Tech Phoenix ARIZONA 12 Hour Day/Night Rotate
544375 Ultrasound Tech Silver Spring MARYLAND 10 Hour Nights
547245 Ultrasound Tech Detroit MICHIGAN 8 Hour Days
544205 Ultrasound Tech Silver Spring MARYLAND 10 Hour Evenings
544303 Ultrasound Tech Portland OREGON 10 Hour Days
544377 Ultrasound Tech Silver Spring MARYLAND 8 Hour Evenings
544378 Ultrasound Tech Silver Spring MARYLAND 8 Hour Days
544493 Ultrasound Tech Prescott ARIZONA 10 Hour Evenings
548263 CNA Hampton IOWA 12 Hour Evenings CNA/Certified Nursing Assistant
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
547880 CNA Bangor MAINE 12 Hour Nights
548220 CNA Camarillo CALIFORNIA 12 Hour Days CNA/Certified Nursing Assistant
533362 CNA Kingsport TENNESSEE 12 Hour Nights
537444 CNA Brooklyn NEW YORK 8 Hour Nights
535536 CNA Cincinnati OHIO Days
548206 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
547899 CNA Lovell WYOMING 12 Hour Days
548205 CNA Oneonta NEW YORK 8 Hour Evenings CNA/Certified Nursing Assistant
546251 CNA TOWNSHEND VERMONT 12 Hour Days
539692 CNA Marion VIRGINIA 12 Hour Days
539693 CNA Marion VIRGINIA 12 Hour Nights
539939 CNA Philipsburg PENNSYLVANIA 8 Hour Evenings
545328 CNA Salem OREGON 12 Hour Nights
548210 CNA South Charleston WEST VIRGINIA 10 Hour Days CNA/Certified Nursing Assistant
547625 CNA Kula HAWAII 8 Hour Days
544897 CNA Breckenridge MINNESOTA 12 Hour Day/Night Rotate
544789 CNA Kealakekua HAWAII 12 Hour Day/Night Rotate
548230 CNA Sacramento CALIFORNIA 8 Hour Evenings CNA/Certified Nursing Assistant
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.7559 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 a.specialty desc limit 1800,100 in 1.728 seconds