Listing all records

Displaying records 301 through 400 out of a total 3,709 records. Prev Next

ID Job Specialty City State Shift Title
541058 OR Sherwood ARKANSAS 10 Hour Days
543780 OR Woonsocket RHODE ISLAND 8 Hour Days
541736 OR Louisville KENTUCKY 10 Hour Days
538546 OR Falls Church VIRGINIA 12 Hour Nights
540053 OR Walnut Creek CALIFORNIA 12 Hour Nights
540061 OR Farmington CONNECTICUT 10 Hour Days
540062 OR Farmington CONNECTICUT 10 Hour Days
548408 OR Cleveland OHIO 12 Hour Days RN/Registered Nurse
546103 OR Springfield MASSACHUSETTS 8 Hour Days
548155 OR Coos Bay OREGON 10 Hour Days RN/Registered Nurse
540010 OR Walnut Creek CALIFORNIA 12 Hour Days
548142 OR Bakersfield CALIFORNIA 8 Hour Day/Night Rotate RN/Registered Nurse
537715 OR Farmington CONNECTICUT 10 Hour Days
548045 OR NORTHRIDGE CALIFORNIA 12 Hour Nights RN/Registered Nurse
545194 OR Paris ILLINOIS 8 Hour Evenings
543230 OR Brooklyn NEW YORK 12 Hour Days RN/Registered Nurse
545030 OR Gardner MASSACHUSETTS 10 Hour Days
548162 OR Centerville IOWA 8 Hour Days RN/Registered Nurse
544201 OR Germantown MARYLAND 8 Hour Evenings
542039 OR San Angelo TEXAS Varied
547820 OR Laurinburg NORTH CAROLINA 8 Hour Days
547720 OR Concord CALIFORNIA 8 Hour Days
548299 OR Arlington VIRGINIA 10 Hour Days RN/Registered Nurse
540628 OR Mason City IOWA 8 Hour Days
547895 OR Coos Bay OREGON 10 Hour Days
547957 OR Mesquite TEXAS 8 Hour Days
528610 OR Oceanside CALIFORNIA 10 Hour Days
544647 OR Silver Spring MARYLAND 12 Hour Days
548039 OR Petersburg WEST VIRGINIA 8 Hour Days RN/Registered Nurse
540626 OR Mason City IOWA 8 Hour Days
547923 OR Muskegon MICHIGAN 10 Hour Days
547152 OR Brooklyn NEW YORK 8 Hour Days
536589 OR New York NEW YORK 12 Hour Nights
544649 OR Silver Spring MARYLAND Nights
548105 OR Cleveland OHIO 10 Hour Days RN/Registered Nurse
536590 OR New York NEW YORK 12 Hour Nights
543729 OR Pella IOWA 10 Hour Varied
544818 OR Maywood ILLINOIS 10 Hour Days
548043 OR Bakersfield CALIFORNIA 8 Hour Days RN/Registered Nurse
544482 OR Germantown MARYLAND 8 Hour Days
547795 OR Tuba City ARIZONA 10 Hour Days
545021 OR Clarkston WASHINGTON 10 Hour Varied
544896 OR Santa Monica CALIFORNIA 12 Hour Nights
544645 OR Silver Spring MARYLAND 12 Hour Days
544644 OR Silver Spring MARYLAND 12 Hour Days
545285 OR El Paso TEXAS 12 Hour Days
540025 OR Concord CALIFORNIA 10 Hour Evenings
547183 OR Brooklyn NEW YORK 12 Hour Nights
542364 OR Spokane WASHINGTON 12 Hour Days
540305 OR Walnut Creek CALIFORNIA 12 Hour Nights
545310 OR SANTA ROSA CALIFORNIA 12 Hour Nights
531702 OR Muskegon MICHIGAN 10 Hour Days
548294 OR Madison WISCONSIN 12 Hour Days RN/Registered Nurse
547699 OR Sun City ARIZONA 12 Hour Days
544817 OR Albany NEW YORK 12 Hour Day/Night Rotate
546679 OR Waterloo IOWA 12 Hour Days
543337 OR Farmington CONNECTICUT 10 Hour Days
540005 OR Farmington CONNECTICUT 10 Hour Days
544646 OR Silver Spring MARYLAND 12 Hour Days
548394 OR Abingdon VIRGINIA 8 Hour Day/Night Rotate RN/Registered Nurse
540026 OR Concord CALIFORNIA 8 Hour Days
544293 OR Maywood ILLINOIS 10 Hour Days
540027 OR Concord CALIFORNIA 12 Hour Days
543781 OR Redding CALIFORNIA 8 Hour Days
546689 OR Templeton CALIFORNIA 10 Hour Days
540028 OR Concord CALIFORNIA 10 Hour Days
546264 ER Robbinsdale MINNESOTA 12 Hour Nights
546800 ER Walnut Creek CALIFORNIA 12 Hour Nights
538622 ER New York NEW YORK 12 Hour Nights
540001 ER Walnut Creek CALIFORNIA 12 Hour Days
547059 ER Rome NEW YORK 12 Hour Nights
543824 ER Lansing MICHIGAN 12 Hour Nights
540213 ER Concord CALIFORNIA 12 Hour Days
540198 ER Concord CALIFORNIA 12 Hour Days
541207 ER Walnut Creek CALIFORNIA 12 Hour Nights
542944 ER Concord CALIFORNIA 12 Hour Nights
538624 ER New York NEW YORK 12 Hour Nights
538590 ER Des Moines IOWA 12 Hour Nights
546165 ER Portland OREGON 12 Hour Nights
546104 ER Stafford Springs CONNECTICUT 12 Hour Nights
540072 ER Walnut Creek CALIFORNIA 12 Hour Nights
540218 ER Concord CALIFORNIA 12 Hour Nights
541312 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
540277 ER Concord CALIFORNIA 12 Hour Nights
543196 ER Newark NEW JERSEY 12 Hour Days
546265 ER Cincinnati OHIO Nights
542451 ER Rockford ILLINOIS 12 Hour Nights
543882 ER Philadelphia PENNSYLVANIA 12 Hour Nights
546308 ER Watertown NEW YORK 12 Hour Day/Night Rotate
540104 ER Concord CALIFORNIA 12 Hour Day/Night Rotate
546077 ER Paulding OHIO 12 Hour Nights
543766 ER Bristol PENNSYLVANIA 12 Hour Nights
546635 ER Des Moines IOWA 12 Hour Nights
538394 ER Avalon CALIFORNIA 12 Hour Day/Night Rotate
546307 ER Watertown NEW YORK 12 Hour Day/Night Rotate
546105 ER Stafford Springs CONNECTICUT 12 Hour Nights
542572 ER Honolulu HAWAII 12 Hour Days RN/Registered Nurse
540108 ER Concord CALIFORNIA 12 Hour Nights
546695 ER Oceanside CALIFORNIA 12 Hour Nights
548401 ER Schenectady NEW YORK 12 Hour Days RN/Registered Nurse
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.6255 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 300,100 in 1.4776 seconds