Listing all records

Displaying records 2801 through 2900 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
548099 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Nights RN/Registered Nurse
548256 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548259 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548261 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
526099 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Nights RN/Registered Nurse
527184 Telemetry - Per Diem Burbank CALIFORNIA 12 Hour Days RN/Registered Nurse
539477 Telemetry - Per Diem Mission Viejo CALIFORNIA 12 Hour Days RN/Registered Nurse
548291 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
548279 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
548290 Telemetry - Per Diem Van Nuys CALIFORNIA 12 Hour Days RN/Registered Nurse
547331 Telemetry - Per Diem Los Angeles CALIFORNIA 12 Hour Nights RN/Registered Nurse
548104 Telemetry - Per Diem Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
547394 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
540142 Intermediate Care Concord CALIFORNIA 12 Hour Days
540212 Intermediate Care Concord CALIFORNIA 12 Hour Days
540292 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Days
540294 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540312 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
540316 Intermediate Care Walnut Creek CALIFORNIA 12 Hour Nights
546061 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
545674 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545679 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545694 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545717 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545750 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545771 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545773 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545794 Intermediate Care Gainesville FLORIDA 12 Hour Days
545808 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545820 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545834 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545840 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545847 Intermediate Care Gainesville FLORIDA 12 Hour Nights
545892 Intermediate Care Gainesville FLORIDA 12 Hour Nights
547988 Intermediate Care Rumford MAINE 12 Hour Days
545939 Intermediate Care Gainesville FLORIDA 12 Hour Nights
546054 Intermediate Care Hilo HAWAII 12 Hour Day/Night Rotate
547989 Intermediate Care Rumford MAINE 12 Hour Days
546728 Intermediate Care Everett WASHINGTON 12 Hour Nights
546740 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546919 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
546920 Intermediate Care Charleston WEST VIRGINIA 12 Hour Nights
548353 Behavioral Health Modesto CALIFORNIA 12 Hour Days RN/Registered Nurse
547519 Hospice Amarillo TEXAS Days
544312 BMT Cleveland OHIO 12 Hour Day/Night Rotate
547320 First Assist Opelika ALABAMA 8 Hour Days
541730 First Assist Brooklyn NEW YORK 8 Hour Days
544403 First Assist Lancaster OHIO Days
547595 First Assist Canton OHIO 12 Hour Days
548227 First Assist Peterborough NEW HAMPSHIRE 8 Hour Days RN/Registered Nurse
545275 First Assist San Luis Obispo CALIFORNIA 8 Hour Days
545278 First Assist Templeton CALIFORNIA 10 Hour Days
505886 MRI Tech Federal Way WASHINGTON 10 Hour Days
512505 MRI Tech Lawton OKLAHOMA 8 Hour Days
525081 MRI Tech Grove City OHIO 12 Hour Days
534798 MRI Tech Langhorne PENNSYLVANIA 8 Hour Evenings
532546 MRI Tech Mason City IOWA 12 Hour Days
532559 MRI Tech Louisville KENTUCKY 10 Hour Days
536307 MRI Tech Janesville WISCONSIN 8 Hour Days
537453 MRI Tech Falls Church VIRGINIA 12 Hour Days
537958 MRI Tech Staten Island NEW YORK 8 Hour Evenings
538172 MRI Tech Germantown MARYLAND 10 Hour Days
547460 MRI Tech Abilene TEXAS 8 Hour Days
538869 MRI Tech Lexington KENTUCKY 8 Hour Nights
540002 MRI Tech Farmington CONNECTICUT 12 Hour Nights
542500 MRI Tech Clarkston WASHINGTON Varied
548020 MRI Tech Glenwood Springs COLORADO 12 Hour Varied
543519 MRI Tech Beachwood OHIO 8 Hour Nights
545332 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
545489 MRI Tech Farmington CONNECTICUT 8 Hour Evenings
545736 MRI Tech Gainesville FLORIDA 10 Hour Nights
545739 MRI Tech Gainesville FLORIDA 8 Hour Evenings
545744 MRI Tech Gainesville FLORIDA 8 Hour Evenings
545770 MRI Tech Gainesville FLORIDA 8 Hour Days
545790 MRI Tech Gainesville FLORIDA 8 Hour Evenings
545874 MRI Tech Gainesville FLORIDA 8 Hour Days
546303 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
546304 MRI Tech Concord NEW HAMPSHIRE 12 Hour Nights
547486 MRI Tech Pierce Tacoma WASHINGTON 10 Hour Evenings
547022 MRI Tech Columbia SOUTH CAROLINA 12 Hour Days
534799 Sonographer Mason City IOWA 12 Hour Days
540788 Sonographer Falls Church VIRGINIA 8 Hour Days
546360 Sonographer Forest Hills NEW YORK 8 Hour Days
521068 Echo Columbia SOUTH CAROLINA 8 Hour Days
548035 Echo Pagosa Springs COLORADO 8 Hour Days
547652 Echo Columbia SOUTH CAROLINA 8 Hour Days
534108 Echo Oceanside CALIFORNIA 10 Hour Days
538136 Echo Mason City IOWA 12 Hour Days
538849 Echo Honolulu HAWAII 8 Hour Days
539710 Echo Sioux City IOWA 8 Hour Days
541191 Echo Ann Arbor MICHIGAN 8 Hour Days
541437 Echo Syracuse NEW YORK 8 Hour Days
542131 Echo Great Falls MONTANA 8 Hour Days
543133 Echo Charlottesville VIRGINIA 8 Hour Days
543486 Echo Waimea HAWAII 12 Hour Day/Night Rotate
544626 Echo Toledo OHIO 8 Hour Days
547947 Echo Minneapolis MINNESOTA 8 Hour Days
546948 Echo Lufkin TEXAS 8 Hour Day/Night Rotate
546987 Echo Osage Beach MISSOURI 8 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.6189 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 asc limit 2800,100 in 1.5159 seconds