Listing all records

Displaying records 3201 through 3300 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
547846 Step Down Centralia WASHINGTON 12 Hour Nights
547847 PCU Tarzana CALIFORNIA 12 Hour Nights
547848 CNA Portland OREGON 12 Hour Nights
547850 Med Surg Tele Cleveland OHIO 12 Hour Day/Night Rotate
547851 Nuclear Med Technician Liberal KANSAS 8 Hour Days
547852 Ultrasound Tech Fredericksburg VIRGINIA 8 Hour Days
547853 Med Surg Valdosta GEORGIA 12 Hour Nights
547854 Med Surg Valdosta GEORGIA 12 Hour Days
547858 RAD Tech Winter Haven FLORIDA 8 Hour Days
547860 Oncology Charlottesville VIRGINIA 10 Hour Days
547861 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547862 Radiation Therapy Charlottesville VIRGINIA 8 Hour Days
547863 Med Surg Tele Charlottesville VIRGINIA 12 Hour Nights
547865 Certified Surgical Tech Columbia SOUTH CAROLINA 12 Hour Days
547866 RRT- Respiratory Exeter NEW HAMPSHIRE 12 Hour Nights
547867 PT Winter Park FLORIDA Days
547869 PT Savannah GEORGIA Days
547870 Med Surg Tele Rome NEW YORK 10 Hour Nights
547871 L&D Cincinnati OHIO Nights
547872 Med Surg Columbia MISSOURI 12 Hour Nights
547873 Endoscopy Columbia MISSOURI 8 Hour Varied
547875 Urgent Care Saratoga Springs NEW YORK 12 Hour Days
547876 RAD Tech Pontiac MICHIGAN 8 Hour Evenings
547877 APRN Portage WISCONSIN Days
547878 Echo Technologist Abilene TEXAS 12 Hour Day/Night Rotate
547879 Med Surg Kealakekua HAWAII 12 Hour Day/Night Rotate
547880 CNA Bangor MAINE 12 Hour Nights
547881 Wound Care State College PENNSYLVANIA 8 Hour Days
547882 ICU Johnson City TENNESSEE 12 Hour Nights
547883 PTA Daly City CALIFORNIA Days
547884 Clinic State College PENNSYLVANIA Days
547886 CT Tech McCall IDAHO 12 Hour Nights
547887 CT Tech McCall IDAHO Days
547888 Cath Lab Danville KENTUCKY 10 Hour Days
547889 RRT- Respiratory Meridian IDAHO 12 Hour Nights
547890 CT Tech Knoxville TENNESSEE 12 Hour Nights
547891 Therapy Rehab Twin Falls IDAHO 10 Hour Days
547892 SLP Twin Falls IDAHO 10 Hour Days
547893 Certified Surgical Tech Lake Charles LOUISIANA 8 Hour Days
547894 Med Surg Oxford NORTH CAROLINA 12 Hour Nights
547895 OR Coos Bay OREGON 10 Hour Days
547898 Nuclear Med Technician Seattle WASHINGTON 8 Hour Days
547899 CNA Lovell WYOMING 12 Hour Days
547900 Infection Prevention Specialist Seattle WASHINGTON 12 Hour Day/Night Rotate
547902 SLP Madison WISCONSIN 8 Hour Days
547903 Surgical Tech Grand Forks NORTH DAKOTA Evenings
547904 ICU Mesa ARIZONA 12 Hour Nights
547905 ICU Greeley COLORADO 12 Hour Nights
547906 ICU Sun City ARIZONA 12 Hour Nights
547907 Med Surg New York NEW YORK Nights
547908 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
547909 Cath Lab Lawton OKLAHOMA 8 Hour Day/Night Rotate
547910 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547911 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Nights
547913 Registered Nurse Philadelphia PENNSYLVANIA 8 Hour Days
547914 ER Estes Park COLORADO 12 Hour Nights
547916 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547917 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547918 ER Des Moines IOWA 12 Hour Nights
547919 ER Des Moines IOWA 12 Hour Days
547920 ER Des Moines IOWA 12 Hour Days
547921 Surgical Tech CVOR Muskegon MICHIGAN 8 Hour Days
547922 CT Tech Ann Arbor MICHIGAN 12 Hour Nights
547923 OR Muskegon MICHIGAN 10 Hour Days
547924 ICU Boise IDAHO 12 Hour Nights
547925 ICU Boise IDAHO 12 Hour Nights
547926 Med Surg Boise IDAHO 12 Hour Nights
547927 Med Surg Boise IDAHO 12 Hour Nights
547928 Cath Lab Lexington KENTUCKY 8 Hour Days
547929 L&D San Antonio TEXAS 12 Hour Nights
547930 ER Brownsville TEXAS 12 Hour Nights
547931 Telemetry Brownsville TEXAS 12 Hour Days
547932 Telemetry - Per Diem Oceanside CALIFORNIA 12 Hour Nights
547933 Med Surg Anniston ALABAMA 12 Hour Nights
547936 CT Tech Morgantown WEST VIRGINIA 8 Hour Evenings
547938 Acute Care Mt. Vernon WASHINGTON 12 Hour Nights
547939 Radiation Therapy Twin Falls IDAHO 12 Hour Days
547940 Nuclear Med Technician Mission Viejo CALIFORNIA 8 Hour Days
547941 Med Surg Tele Vernon Rockville CONNECTICUT 12 Hour Nights
547942 PACU Sterling ILLINOIS 8 Hour Days
547945 Cardiac Telemetry Farmington NEW MEXICO 12 Hour Nights
547946 L&D Perryville MISSOURI 12 Hour Nights
547947 Echo Minneapolis MINNESOTA 8 Hour Days
547948 MLT Wolf Point MONTANA 8 Hour Days
547949 PT Philadelphia PENNSYLVANIA Varied
547950 PT Staples MINNESOTA 8 Hour Days
547951 PT Staples MINNESOTA 8 Hour Days
547952 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547953 Med Surg Madison WISCONSIN 12 Hour Day/Night Rotate
547954 L&D Cincinnati OHIO Days
547955 OR Madison WISCONSIN 10 Hour Day/Night Rotate
547956 Surgical Tech Glens Falls NEW YORK 10 Hour Days
547957 OR Mesquite TEXAS 8 Hour Days
547958 Cath Lab San Diego CALIFORNIA 8 Hour Days
547959 Surgical Tech Glens Falls NEW YORK 10 Hour Evenings
547961 Psych Brattleboro VERMONT 12 Hour Nights
547962 PICU Madison WISCONSIN 12 Hour Day/Night Rotate
547963 Med Surg Scottsbluff NEBRASKA 12 Hour Day/Night Rotate
547964 Mammo Tech San Angelo TEXAS 8 Hour Days
547965 SLP Spanaway WASHINGTON 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.5232 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.id asc limit 3200,100 in 1.1082 seconds