Listing all records

Displaying records 2401 through 2500 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
540226 Telemetry Concord CALIFORNIA 12 Hour Days
548403 Telemetry Monterey CALIFORNIA 12 Hour Nights RN/Registered Nurse
548384 Telemetry Concord CALIFORNIA 12 Hour Days RN/Registered Nurse
548385 Telemetry Antioch CALIFORNIA 12 Hour Days RN/Registered Nurse
547308 Telemetry Nampa IDAHO 12 Hour Nights
540261 Telemetry Concord CALIFORNIA 12 Hour Nights
547311 Telemetry Twin Falls IDAHO 12 Hour Days
546907 Telemetry Terre Haute INDIANA 12 Hour Nights RN/Registered Nurse
547324 Telemetry Portland OREGON 12 Hour Nights
547319 Telemetry Nampa IDAHO 12 Hour Nights
540323 Telemetry Concord CALIFORNIA 12 Hour Nights
540342 Telemetry Concord CALIFORNIA 12 Hour Days
540349 Telemetry Concord CALIFORNIA 12 Hour Nights
540529 Telemetry Los Angeles CALIFORNIA 12 Hour Days RN/Registered Nurse
540569 Telemetry Farmington CONNECTICUT 12 Hour Nights
546693 Telemetry Oceanside CALIFORNIA 12 Hour Evenings
540745 Telemetry Prescott ARIZONA 12 Hour Day/Night Rotate
540770 Telemetry Prescott ARIZONA 12 Hour Days
541117 Telemetry Farmington CONNECTICUT 12 Hour Nights
546976 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
541381 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
546732 Telemetry Everett WASHINGTON 12 Hour Nights
542211 Telemetry CHANDLER ARIZONA 12 Hour Nights
546727 Telemetry Everett WASHINGTON 12 Hour Nights
546729 Telemetry Everett WASHINGTON 12 Hour Nights
542615 Telemetry Terre Haute INDIANA 12 Hour Nights
542653 Telemetry Charleston SOUTH CAROLINA 12 Hour Nights
547931 Telemetry Brownsville TEXAS 12 Hour Days
544434 Telemetry IOWA CITY IOWA 12 Hour Nights
543038 Telemetry San Diego CALIFORNIA 12 Hour Day/Night Rotate
543214 Telemetry Cleveland OHIO 12 Hour Nights
543215 Telemetry Cleveland OHIO 12 Hour Nights
546742 Telemetry Charleston WEST VIRGINIA 12 Hour Nights
543252 Telemetry Rock Hill SOUTH CAROLINA 12 Hour Nights
543309 Telemetry Farmington CONNECTICUT 12 Hour Nights
543465 Telemetry Wailuku HAWAII 12 Hour Nights
543599 Telemetry Twin Falls IDAHO 12 Hour Nights
543607 Telemetry Nampa IDAHO 12 Hour Nights
543613 Telemetry Boise IDAHO 12 Hour Nights
544031 Telemetry Portland OREGON 12 Hour Nights
544050 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544051 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544052 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
544116 Telemetry Cleveland OHIO 12 Hour Nights
548038 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights
548361 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Nights RN/Registered Nurse
544313 Telemetry Cleveland OHIO 12 Hour Day/Night Rotate
544525 Telemetry Wailuku HAWAII 12 Hour Nights
546844 Telemetry Farmington CONNECTICUT 12 Hour Days
548362 Telemetry Antioch CALIFORNIA 12 Hour Nights RN/Registered Nurse
546859 Telemetry Everett WASHINGTON 12 Hour Nights
544954 Telemetry Twin Falls IDAHO 12 Hour Nights
544955 Telemetry Twin Falls IDAHO 12 Hour Days
548115 Telemetry Brattleboro VERMONT 12 Hour Nights RN/Registered Nurse
545165 Telemetry Cleveland OHIO 12 Hour Nights
548145 Telemetry Seattle WASHINGTON 12 Hour Nights RN/Registered Nurse
545227 Telemetry Cleveland OHIO 12 Hour Nights
545228 Telemetry Cleveland OHIO 12 Hour Nights
545229 Telemetry Cleveland OHIO 12 Hour Nights
545230 Telemetry Cleveland OHIO 12 Hour Nights
545231 Telemetry Cleveland OHIO 12 Hour Nights
548377 Telemetry Santa Clara CALIFORNIA 12 Hour Days RN/Registered Nurse
548383 Telemetry BAKERSFIELD CALIFORNIA 12 Hour Days RN/Registered Nurse
545502 Telemetry Boise IDAHO 12 Hour Nights
545503 Telemetry Boise IDAHO 12 Hour Nights
548342 Telemetry Spokane WASHINGTON 12 Hour Days RN/Registered Nurse
546898 Telemetry Cleveland OHIO 12 Hour Nights
546902 Telemetry Cleveland OHIO 12 Hour Nights
546899 Telemetry Spokane WASHINGTON 12 Hour Nights
545625 Telemetry Prescott Valley ARIZONA 12 Hour Nights
545626 Telemetry Prescott Valley ARIZONA 12 Hour Day/Night Rotate
547650 Telemetry Hannibal MISSOURI 12 Hour Days
546977 Telemetry Palm Springs CALIFORNIA 12 Hour Nights
541765 CVOR Oceanside CALIFORNIA 8 Hour Nights
524675 CVOR Mishawaka INDIANA 12 Hour Days
530228 CVOR Sioux City IOWA 10 Hour Days
548285 CVOR Sacramento CALIFORNIA 8 Hour Days RN/Registered Nurse
548350 CVOR Falls Church VIRGINIA 12 Hour Day/Night Rotate RN/Registered Nurse
548054 CVOR STOCKTON CALIFORNIA 12 Hour Days RN/Registered Nurse
547674 CVOR Falls Church VIRGINIA 12 Hour Days
547326 CVOR Ann Arbor MICHIGAN 10 Hour Days
541473 CVOR Spokane WASHINGTON 10 Hour Days
541482 CVOR Spokane WASHINGTON 10 Hour Days
541483 CVOR Spokane WASHINGTON 10 Hour Days
541486 CVOR Spokane WASHINGTON 10 Hour Days
542262 CVOR Charlottesville VIRGINIA 10 Hour Days
542263 CVOR Charlottesville VIRGINIA 10 Hour Days
547006 CVOR Charlottesville VIRGINIA 10 Hour Days
543006 CVOR Oceanside CALIFORNIA 8 Hour Days
543243 CVOR Falls Church VIRGINIA 12 Hour Days RN/Registered Nurse
548344 CVOR Fresno CALIFORNIA 12 Hour Days RN/Registered Nurse
544218 CVOR Newark NEW JERSEY 12 Hour Days
544245 CVOR Reno NEVADA 12 Hour Day/Night Rotate
546827 CVOR Parkersburg WEST VIRGINIA 12 Hour Days
548284 CVOR Redding CALIFORNIA 12 Hour Days RN/Registered Nurse
546858 CVOR Annapolis MARYLAND 12 Hour Days
545185 CVOR Houston TEXAS 12 Hour Day/Night Rotate
547673 CVOR Falls Church VIRGINIA 12 Hour Days
547672 CVOR Falls Church VIRGINIA 12 Hour Days
547786 CVOR North Kansas City 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.3304 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 2400,100 in 1.719 seconds