db_dump.sql

-- MySQL dump 10.13  Distrib 8.0.21, for Win64 (x86_64)
--
-- Host: localhost    Database: ratemate
-- ------------------------------------------------------
-- Server version	8.0.21

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `course`
--

DROP TABLE IF EXISTS `course`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `course` (
  `subject` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `number` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(600) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `credit` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `attributes` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `schedule_info` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`subject`,`number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `course`
--

LOCK TABLES `course` WRITE;
/*!40000 ALTER TABLE `course` DISABLE KEYS */;
INSERT INTO `course` VALUES ('CS',100,'Freshman Orientation','Introduction to Computer Science as a field and career for computer science majors. Overview of the field and specific examples of problem areas and methods of solution.','1 hours.','','',''),('CS',101,'Intro Computing: Engrg & Sci','Fundamental principles, concepts, and methods of computing, with emphasis on applications in the physical sciences and engineering. Basic problem solving and programming techniques; fundamental algorithms and data structures; use of computers in solving engineering and scientific problems. Intended for engineering and science majors. Prerequisite: MATH 220 or MATH 221.','3 hours.','Prerequisite: MATH 220 or MATH 221.','Quantitative Reasoning II course.','Students must register for one lab-discussion and one lecture section. Engineering students must obtain a deans approval to drop this course after the second week of instruction.'),('CS',102,'Little Bits to Big Ideas','Same as INFO 102. See INFO 102.','4 hours.','','',''),('CS',105,'Intro Computing: Non-Tech','Computing as an essential tool of academic and professional activities. Functions and interrelationships of computer system components: hardware, systems and applications software, and networks. Widely used application packages such as spreadsheets and databases. Concepts and practice of programming for the solution of simple problems in different application areas. Intended for non-science and non-engineering majors. Prerequisite: MATH 112.','3 hours.','Prerequisite: MATH 112.','Quantitative Reasoning I course.','Students must register for one lab-discussion and one lecture section.'),('CS',107,'Data Science Discovery','Same as IS 107 and STAT 107. See STAT 107.','4 hours.','Same as IS 107 and STAT 107. See STAT 107.','Quantitative Reasoning I course.',''),('CS',125,'Intro to Computer Science','Basic concepts in computing and fundamental techniques for solving computational problems. Intended as a first course for computer science majors and others with a deep interest in computing. Prerequisite: Three years of high school mathematics or MATH 112.','4 hours.','Prerequisite: Three years of high school mathematics or MATH 112.','Quantitative Reasoning I course.','Students must register for one lab-discussion and one lecture section. Engineering students must obtain a deans approval to drop this course after the second week of instruction.'),('CS',126,'Software Design Studio','Fundamental principles and techniques of software development. Design, documentation, testing, and debugging software, with a significant emphasis on code review. Credit is not given for both CS 242 and CS 126. Prerequisite: CS 125. For majors only.','3 hours.','Credit is not given for both CS 242 and CS 126. Prerequisite: CS 125. For majors only.','',''),('CS',173,'Discrete Structures','Discrete mathematical structures frequently encountered in the study of Computer Science. Sets, propositions, Boolean algebra, induction, recursion, relations, functions, and graphs. Credit is not given for both CS 173 and MATH 213. Prerequisite: One of CS 125, ECE 220; one of MATH 220, MATH 221.','3 hours.','Credit is not given for both CS 173 and MATH 213. Prerequisite: One of CS 125, ECE 220; one of MATH 220, MATH 221.','','Students must register for a lecture and discussion section.'),('CS',196,'Freshman Honors','Offered for honors credit in conjunction with other 100-level computer science courses taken concurrently. A special examination may be required for admission to this course. May be repeated. Prerequisite: Concurrent registration in another 100-level computer science course (see Schedule).','1 hours.','May be repeated. Prerequisite: Concurrent registration in another 100-level computer science course (see Schedule).','',''),('CS',199,'Undergraduate Open Seminar in Computer Science','Topics vary. Approved for Letter and S/U grading. May be repeated.','0 TO 5 hours.','Approved for Letter and S/U grading. May be repeated.','',''),('CS',210,'Ethical & Professional Issues','Ethics for the computing profession. Ethical decision-making; licensing; intellectual property, freedom of information, and privacy. Credit is not given for both CS 210 and ECE 316. Prerequisite: CS 225. Junior standing required.','2 hours.','Credit is not given for both CS 210 and ECE 316. Prerequisite: CS 225. Junior standing required.','',''),('CS',225,'Data Structures','Data abstractions: elementary data structures (lists, stacks, queues, and trees) and their implementation using an object-oriented programming language. Solutions to a variety of computational problems such as search on graphs and trees. Elementary analysis of algorithms. Prerequisite: CS 125 or ECE 220; CS 173 or MATH 213.','4 hours.','Prerequisite: CS 125 or ECE 220; CS 173 or MATH 213.','Quantitative Reasoning II course.','Students must register for one lecture-discussion and one lecture section.'),('CS',233,'Computer Architecture','Fundamentals of computer architecture: digital logic design, working up from the logic gate level to understand the function of a simple computer; machine-level programming to understand implementation of high-level languages; performance models of modern computer architectures to enable performance optimization of software; hardware primitives for parallelism and security. Prerequisite: CS 125 and CS 173; credit or concurrent enrollment in CS 225.','4 hours.','Prerequisite: CS 125 and CS 173; credit or concurrent enrollment in CS 225.','',''),('CS',240,'Introduction to Computer Systems','Basics of computer systems. Number representations, assembly/machine language, abstract models of processors (fetch/execute, memory hierarchy), processes/process control, simple memory management, file I/O and directories, network programming, usage of cloud services. Prerequisite: CS 225 or both CS 205 and CS 110C++.','3 hours.','','',''),('CS',241,'System Programming','Basics of system programming, including POSIX processes, process control, inter-process communication, synchronization, signals, simple memory management, file I/O and directories, shell programming, socket network programming, RPC programming in distributed systems, basic security mechanisms, and standard tools for systems programming such as debugging tools. Credit is not given for both CS 241 and ECE 391. Prerequisite: CS 225 and CS 233.','4 hours.','Credit is not given for both CS 241 and ECE 391. Prerequisite: CS 225 and CS 233.','','Students must register for one lecture and one discussion section.'),('CS',242,'Programming Studio','Intensive programming lab intended to strengthen skills in programming. Prerequisite: CS 241.','3 hours.','Prerequisite: CS 241.','',''),('CS',296,'Honors Course','Group projects for honors credit in computer science. Sections of this course are offered in conjunction with other 200-level computer science courses taken concurrently. A special examination may be required for admission to this course. May be repeated. Prerequisite: Concurrent registration in another 200-level computer science course (see Schedule).','1 hours.','May be repeated. Prerequisite: Concurrent registration in another 200-level computer science course (see Schedule).','',''),('CS',357,'Numerical Methods I','Fundamentals of numerical methods for students in science and engineering; floating-point computation, systems of linear equations, approximation of functions and integrals, the single nonlinear equation, and the numerical solution of ordinary differential equations; various applications','3 hours.','Same as MATH 357. Credit is not given for CS 357 if credit for CS 450 has been earned. (Counts for advanced hours in LAS). Prerequisite: One of CS 101, CS 105 or CS 125; MATH 241; one of MATH 225, MATH 415, MATH 416 or ASRM 406.','',''),('CS',361,'Probability & Statistics for Computer Science','Introduction to probability theory and statistics with applications to computer science. Markov inequality, Chebyshev inequality, law of large numbers, Markov chains, simulation, the PageRank algorithm, populations and sampling, sample mean, standard error, maximum likelihood estimation, Bayes estimation, hypothesis testing, confidence intervals, linear regression, principal component analysis, classification, and decision trees.','3 hours.','Same as STAT 361. Prerequisite: MATH 220 or MATH 221; credit or concurrent registration in MATH 415. For majors only.','',''),('CS',374,'Introduction to Algorithms & Models of Computation','Analysis of algorithms, major paradigms of algorithm design including recursive algorithms, divide-and-conquer algorithms, dynamic programming, greedy algorithms, and graph algorithms. Formal models of computation including finite automata and Turing machines. Limitations of computation arising from fundamental notions of algorithm and from complexity-theoretic constraints. Reductions, undecidability and NP-completeness. Same as ECE 374. Prerequisite: CS 225.','4 hours.','Same as ECE 374. Prerequisite: CS 225.','',''),('CS',397,'Individual Study','May be repeated. Prerequisite: Consent of instructor.','1 TO 3 hours.','May be repeated. Prerequisite: Consent of instructor.','',''),('CS',398,'Special Topics','Subject offerings of new and developing areas of knowledge in computer science intended to augment the existing curriculum. See Class Schedule or departmental course information for topics and prerequisites. May be repeated in the same or separate terms if topics vary.','1 to 4 hours.','','',''),('CS',410,'Text Information Systems','Theory, design, and implementation of text-based information systems. Text analysis, retrieval models (e.g., Boolean, vector space, probabilistic), text categorization, text filtering, clustering, retrieval system design and implementation, and applications to web information management. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','',''),('CS',411,'Database Systems','Examination of the logical organization of databases: the entity-relationship model; the hierarchical, network, and relational data models and their languages. Functional dependencies and normal forms. Design, implementation, and optimization of query languages; security and integrity; concurrency control, and distributed database systems. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','',''),('CS',412,'Introduction to Data Mining','Concepts, techniques, and systems of data warehousing and data mining. Design and implementation of data warehouse and on-line analytical processing (OLAP) systems; data mining concepts, methods, systems, implementations, and applications. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','',''),('CS',413,'Intro to Combinatorics','Same as MATH 413. See MATH 413.','3 OR 4 hours.','Same as MATH 413. See MATH 413.','',''),('CS',414,'Multimedia Systems','Organization and structure of modern multimedia systems; audio and video encoding; quality of service concepts; scheduling algorithms for multimedia within OS and networks multimedia protocols over high-speed networks; synchronization schemes, user-interface design; multimedia teleservices. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241 or ECE 391.','3 OR 4 hours.','','',''),('CS',418,'Interactive Computer Graphics','Basic mathematical tools and computational techniques for modeling, rendering, and animating 3-D scenes. Same as CSE 427. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225; MATH 225 or MATH 415; MATH 241.','0 TO 4 hours.','Same as CSE 427. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225; MATH 225 or MATH 415; MATH 241.','','Students will register for a lecture and a discussion section.'),('CS',419,'Production Computer Graphics','Advanced methods for representing, displaying, and rendering two-, three-, and four-dimensional scenes. General algebraic curves and surfaces, splines, Gaussian and bump-function representation, fractals, particle systems, constructive solid geometry methods, lighting models, radiosity, advanced ray-tracing methods, surface texturing animation techniques, data visualization methods. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 418.','3 OR 4 hours.','','',''),('CS',420,'Parallel Progrmg: Sci & Engrg','Fundamental issues in design and development of parallel programs for various types of parallel computers. Various programming models according to both machine type and application area. Cost models, debugging, and performance evaluation of parallel programs with actual application examples. Same as CSE 402 and ECE 492. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','3 OR 4 hours.','Same as CSE 402 and ECE 492. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','',''),('CS',421,'Programming Languages & Compilers','Structure of programming languages and their implementation. Basic language design principles; abstract data types; functional languages; type systems; object-oriented languages. Basics of lexing, parsing, syntax-directed translation, semantic analysis, and code generation. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 233 or CS 240; CS 374.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 233 or CS 240; CS 374.','',''),('CS',422,'Programming Language Design','Exploration of major language design paradigms using imperative and functional programming as unifying themes. Tools include both practical language processor construction and theoretical models. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 421.','3 OR 4 hours.','','',''),('CS',423,'Operating Systems Design','Organization and structure of modern operating systems and concurrent programming concepts. Deadlock, virtual memory, processor scheduling, and disk systems. Performance, security, and protection. Same as CSE 423. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241 or ECE 391.','3 OR 4 hours.','','',''),('CS',424,'Real-Time Systems','Supervisory control aspects of Cyber Physical Systems (CPS): fundamentals of reliability analysis, real-time scheduling, simple feedback control, software fault tolerance architecture, wireless networking and energy saving, principles of safety critical system engineering. Student groups design and demonstrate supervisory control architecture for a robot. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241.','',''),('CS',425,'Distributed Systems','Protocols, specification techniques, global states and their determination, reliable broadcast, transactions and commitment, security, and real-time systems. Same as ECE 428. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241 or ECE 391.','3 OR 4 hours.','Same as ECE 428. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241 or ECE 391.','',''),('CS',426,'Compiler Construction','Compiler structure, syntax analysis, syntax-directed translation, automatically constructed recognizers, semantic analysis, code generation, intermediate language, optimization techniques. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 421.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 421.','',''),('CS',427,'Software Engineering I','Software process, analysis and design. Software development paradigms, system engineering, function-based analysis and design, and object-oriented analysis and design. Course will use team-projects for hands-on exercises. Same as CSE 426. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225 and CS 373.','3 OR 4 hours.','Same as CSE 426. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225 and CS 373.','',''),('CS',428,'Software Engineering II','Continuation of CS 427. Software development, management, and maintenance. Project and configuration management, collaborative development models, software quality assurance, interoperability domain engineering and software reuse, and software re-engineering. Same as CSE 429. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 427.','3 OR 4 hours.','','',''),('CS',429,'Software Engineering II, ACP','Continuation of CS 427. Identical to CS 428 except for the additional writing component. See CS 428. 3 undergraduate hours. 3 graduate hours. Prerequisite: CS 427.','3 hours.','','Advanced Composition course.',''),('CS',431,'Embedded Systems','A survey of sampled data systems and embedded architecture; key concepts in common embedded system applications; signal processing and control; embedded microprocessor and device interface; time-critical I/O handling; data communications; real-time operating systems and techniques for the development and analysis of embedded real-time software; hands-on laboratory projects. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241 or ECE 391.','3 or 4 hours.','','',''),('CS',433,'Computer System Organization','Computer hardware design and analysis and interface with software. Advanced processor design, including superscalar, out-of-order issue, branch prediction, and speculation. Memory hierarchy design, including advanced cache optimizations, main memory, and virtual memory. Principles of multiprocessor design, including shared-memory, cache coherence, synchronization, and consistency. Other advanced topics depending on time; e.g., GPUs and accelerators, warehouse computers and data centers, security. Same as CSE 422. 3 undergraduate hours. 4 graduate hours. Prerequisite: CS 233.','3 OR 4 hours.','Same as CSE 422. 3 undergraduate hours. 4 graduate hours. Prerequisite: CS 233.','',''),('CS',436,'Computer Networking Laboratory','Same as ECE 435. See ECE 435.','3 OR 4 hours.','','',''),('CS',438,'Communication Networks','Layered architectures and the OSI Reference Model; design issues and protocols in the transport, network, and data link layers; architectures and control algorithms of local-area, point-to-point, and satellite networks; standards in networks access protocols; models of network interconnection; overview of networking and communication software. Same as ECE 438. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241 or ECE 391; one of ECE 313, MATH 461, MATH 463.','3 OR 4 hours.','Same as ECE 438. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 241 or ECE 391; one of ECE 313, MATH 461, MATH 463.','',''),('CS',439,'Wireless Networks','Same as ECE 439. See ECE 439.','3 OR 4 hours.','','',''),('CS',440,'Artificial Intelligence','Major topics in and directions of research in artificial intelligence: AI languages (LISP and PROLOG), basic problem solving techniques, knowledge representation and computer inference, machine learning, natural language understanding, computer vision, robotics, and societal impacts. Same as ECE 448. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225 or ECE 391.','3 OR 4 hours.','Same as ECE 448. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225 or ECE 391.','',''),('CS',445,'Computational Photography','Computer vision techniques to enhance, manipulate, and create media from photo collections, such as panoramic stitching, face morphing, texture synthesis, blending, and 3D reconstruction. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225, MATH 225, and MATH 231.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225, MATH 225, and MATH 231.','',''),('CS',446,'Machine Learning','Theory and basic techniques in machine learning. Major theoretical paradigms and key concepts developed in machine learning in the context of applications such as natural language and text processing, computer vision, data mining, adaptive computer systems and others. Review of several supervised and unsupervised learning approaches: methods for learning linear representations; on-line learning, Bayesian methods; decision-trees; features and kernels; clustering and dimensionality reduction. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 373 and CS 440.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 373 and CS 440.','',''),('CS',447,'Natural Language Processing','Part-of-speech tagging, parsing, semantic analysis and machine translation. Relevant linguistics concepts from morphology (word formation) and lexical semantics (the meaning of words) to syntax (sentence structure) and compositional semantics (the meaning of sentences). 3 undergraduate hours. 3 or 4 graduate hours. Credit is not given for both CS 447 and LING 406. Prerequisite: CS 374.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Credit is not given for both CS 447 and LING 406. Prerequisite: CS 374.','',''),('CS',450,'Numerical Analysis','Linear system solvers, optimization techniques, interpolation and approximation of functions, solving systems of nonlinear equations, eigenvalue problems, least squares, and quadrature; numerical handling of ordinary and partial differential equations. Same as CSE 401, ECE 491, and MATH 450. 3 undergraduate hours. 3 or 4 graduate hours. Credit is not given for both CS 450 and CS 457. Prerequisite: CS 101 or CS 125; CS 357 or MATH 415; MATH 285.','0 TO 4 hours.','Same as CSE 401, ECE 491, and MATH 450. 3 undergraduate hours. 3 or 4 graduate hours. Credit is not given for both CS 450 and CS 457. Prerequisite: CS 101 or CS 125; CS 357 or MATH 415; MATH 285.','',''),('CS',457,'Numerical Methods II','Continuation of CS 357. Orthogonalization methods for least squares, Krylov subspace methods, non-linear equations and optimization in multiple dimensions, initial and boundary value problems for ordinary and partial differential equations. 3 undergraduate hours. No graduate credit. Credit is not given for both CS 457 and CS 450. Prerequisite: CS 357.','3 hours.','','',''),('CS',460,'Security Laboratory','Operating systems security: access control, least privilege mechanism and malware techniques. Network security: firewalls, sniffing, tunnels, intrusion detection, AAA and worm structure. System security: forensics security architectures, and attack/defend exercises. Complements CS 461 via hands-on project. Same as ECE 419. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 461.','3 or 4 hours.','','',''),('CS',463,'Computer Security II','Program security, trusted base, privacy, anonymity, non-interference, information flow, confinement, advanced auditing, forensics, intrusion detection, key management and distribution, policy composition and analysis, formal approaches to specification and verification of secure systems and protocols, and topics in applied cryptography. Same as ECE 424. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 461. Recommended: CS 475.','3 OR 4 hours.','','',''),('CS',466,'Introduction to Bioinformatics','Algorithmic approaches in bioinformatics: (i) biological problems that can be solved computationally (e.g., discovering genes, and interactions among different genes and proteins); (ii) algorithmic techniques with wide applicability in solving these problems (e.g., dynamic programming and probabilistic methods); (iii) practical issues in translating the basic algorithmic ideas into accurate and efficient tools that biologists may use. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','3 OR 4 hours.','3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','',''),('CS',467,'Social Visualization','Visualizing social interaction in networked spaces: investigation of patterns in networked communications systems such as messaging (email, instant messaging), social networking sites and collaborative sites; social network theory and visualizations; exploration of how to move beyond existing visualization techniques; visualizing the network identity over compilations of online data. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225.','3 OR 4 hours.','','',''),('CS',468,'Tech and Advertising Campaigns','Same as ADV 492. See ADV 492.','3 hours.','','',''),('CS',473,'Algorithms','Design and analysis techniques, approximation algorithms, randomized algorithms and amortized analysis, and advanced topics such as network flow, linear programming, and dynamic data structures, among others. Same as CSE 414 and MATH 473. 4 undergraduate hours. 4 graduate hours. Prerequisite: CS 374, and one of CS 361, MATH 461, or STAT 400.','4 hours.','Same as CSE 414 and MATH 473. 4 undergraduate hours. 4 graduate hours. Prerequisite: CS 374, and one of CS 361, MATH 461, or STAT 400.','',''),('CS',475,'Formal Models of Computation','Finite automata and regular languages; pushdown automata and context-free languages; Turing machines and recursively enumerable sets; linear-bounded automata and context-sensitive languages; computability and the halting problem; undecidable problems; recursive functions; Chomsky hierarchy; computational complexity. Same as MATH 475. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 374.','3 OR 4 hours.','','',''),('CS',476,'Program Verification','Formal methods for demonstrating correctness and other properties of programs. Invariant assertions; Hoare axiomatics; well-founded orderings for proving termination; structural induction; computational induction; data structures; parallel programs; overview of predicate calculus. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225; CS 374 or MATH 414.','3 OR 4 hours.','','',''),('CS',477,'Formal Software Devel Methods','Mathematical models, languages, and methods for software specification, development, and verification. Same as ECE 478. 3 undergraduate hours. 3 or 4 graduate hours. Prerequisite: CS 225; CS 373 or MATH 414.','3 OR 4 hours.','','',''),('CS',481,'Advanced Topics in Stochastic Processes & Applications','Same as IE 410. See IE 410.','3 OR 4 hours.','Same as IE 410. See IE 410.','',''),('CS',482,'Simulation','Same as IE 413. See IE 413.','3 or 4 hours.','','',''),('CS',483,'Applied Parallel Programming','Same as CSE 408 and ECE 408. See ECE 408.','4 hours.','Same as CSE 408 and ECE 408. See ECE 408.','',''),('CS',492,'Senior Project I','First part of a project course in computer science. Students work in teams to solve typical commercial or industrial problems. Work involves planning, design, and implementation. Extensive oral and written work is required both on-campus and possibly off-campus at sponsors locations. CS 492 must be taken as a sequence with either CS 493 or CS 494. 3 undergraduate hours. No graduate credit. Credit is not given for both CS 492 and a project course in another engineering department for the same project. Prerequisite: For Computer Science majors with senior standing.','3 hours.','','',''),('CS',493,'Senior Project II, ACP','Continuation of CS 492. Identical to CS 494 except for an additional writing component. See CS 494. 3 undergraduate hours. No graduate credit. Credit is not given for both CS 493 and a project course in another engineering department for the same project. Prerequisite: CS 492.','3 hours.','3 undergraduate hours. No graduate credit. Credit is not given for both CS 493 and a project course in another engineering department for the same project. Prerequisite: CS 492.','Advanced Composition course.',''),('CS',494,'Senior Project II','Continuation of CS 492. 3 undergraduate hours. No graduate credit. Credit is not given for both CS 494 and a project course in another engineering department for the same project. Prerequisite: CS 492.','3 hours.','3 undergraduate hours. No graduate credit. Credit is not given for both CS 494 and a project course in another engineering department for the same project. Prerequisite: CS 492.','',''),('CS',497,'CS Team Project','Student teams work with CS faculty to complete a significant project requiring advanced knowledge of CS principles. Project topics vary. 1 to 3 undergraduate hours. No graduate credit. May be repeated in the same term up to 6 hours, if topics vary; may be repeated in separate terms. Prerequisite: For majors only; junior or senior standing required.','1 TO 3 hours.','1 to 3 undergraduate hours. No graduate credit. May be repeated in the same term up to 6 hours, if topics vary; may be repeated in separate terms. Prerequisite: For majors only; junior or senior standing required.','',''),('CS',498,'Special Topics','Subject offerings of new and developing areas of knowledge in computer science intended to augment the existing curriculum. See Class Schedule or departmental course information for topics and prerequisites. 1 to 4 undergraduate hours. 1 to 4 graduate hours. May be repeated in the same or separate terms if topics vary.','0 TO 4 hours.','1 to 4 undergraduate hours. 1 to 4 graduate hours. May be repeated in the same or separate terms if topics vary.','',''),('CS',499,'Senior Thesis','Research and thesis development experience in computer science underguidance of a faculty member. Literature search, oral presentation, analysis and implementation, paper preparation, and completion of a written thesis. 3 undergraduate hours. No graduate credit. May be repeated to a maximum of 6 hours. Prerequisite: Consent of instructor.','3 hours.','3 undergraduate hours. No graduate credit. May be repeated to a maximum of 6 hours. Prerequisite: Consent of instructor.','Advanced Composition course.',''),('CS',508,'Manycore Parallel Algorithms','Same as ECE 508. See ECE 508.','4 hours.','','',''),('CS',510,'Advanced Information Retrieval','Advanced concepts, models, and algorithms in information retrieval and major recent developments in the field, including historical milestones in information retrieval research, evaluation methodology, vector space retrieval model, probabilistic retrieval models, learning to rank algorithms, probabilistic topic models, information retrieval systems, text analytics, and topics of research frontiers in information retrieval. 4 graduate hours. No professional credit. Prerequisite: One of CS 410, CS 412, CS 446 or LING 406.','4 hours.','4 graduate hours. No professional credit. Prerequisite: One of CS 410, CS 412, CS 446 or LING 406.','',''),('CS',511,'Advanced Data Management','Advanced concepts in data management and information system design and implementation, and recent developments in the field. 1) Relational roots, objects and extensibility, query languages, data indexing, query processing, transaction processing, benchmarks, and 2) semi-structured data and unstructured data, information extraction, information integration, web search and mining, and other emerging directions in the field. Prerequisite: CS 411.','4 hours.','','',''),('CS',512,'Data Mining Principles','An advanced course on principles and algorithms of data mining. Data cleaning and integration; descriptive and predictive mining; mining frequent, sequential, and structured patterns; clustering, outlier analysis and fraud detection; stream data, web, text, and biomedical data mining; security and privacy in data mining; research frontiers. Prerequisite: CS 412.','4 hours.','','',''),('CS',513,'Theory & Practice of Data Cleaning','Same as IS 532. See IS 532.','4 hours.','Same as IS 532. See IS 532.','',''),('CS',519,'Scientific Visualization','Visualization techniques useful in analysis of engineering and scientific data. Physical models; methods of computational science; two- and three-dimensional data types; visual representation schemes for scalar, vector, and tensor data; isosurface and volume visualization methods; visual monitoring; interactive steering. Same as CSE 527. Prerequisite: CS 418.','4 hours.','','',''),('CS',522,'Programming Language Semantics','Theory of programming languages including functional programming, meta-circular interpreters, typed, untyped and polymorphic lambda-calculi, and denotational semantics. Prerequisite: CS 422 and CS 426.','4 hours.','','',''),('CS',523,'Advanced Operating Systems','Advanced concepts in operating system design and coverage of recent research directions. Resource management for parallel and distributed systems. Interaction between operating system design and computer architectures. Process management, virtual memory, interprocess communication, context switching, parallel and distributed file system designs, persistent objects, process and data migration, load balancing, security, protection. Term projects. Prerequisite: CS 423, CS 425, and CS 433.','4 hours.','Prerequisite: CS 423, CS 425, and CS 433.','',''),('CS',524,'Concurrent Progrmg Languages','Theory of concurrency and concurrent programming languages. Formal models of concurrent computation such as process algebras, nets, and actors; high level concurrent programming languages and their operational semantics; methods for reasoning about correctness and complexity of concurrent programs. Prerequisite: CS 422; CS 475 or CS 476.','4 hours.','','',''),('CS',525,'Advanced Distributed Systems','Peer-to-peer systems, sensor networks, and fundamental theoretical distributed computing. Review of classical work in each area, and application of design methodologies to explore overlaps across them. Emphasis on protocol design, systems issues, and theory. Reading selections are roughly two-third classical to one-third contemporary. Students write critiques, make presentations, and create a conference paper in a systematic manner. Prerequisite: One of CS 423, CS 425, CS 438.','4 hours.','','',''),('CS',526,'Advanced Compiler Construction','Incremental and interactive compiling, error correction, code optimization, models of code generators. Prerequisite: CS 426.','4 hours.','','',''),('CS',527,'Topics in Software Engineering','Fault-tolerant software, software architecture, software patterns, multi-media software, and knowledge-based approaches to software engineering. Case studies. Prerequisite: CS 428 or CS 429.','4 hours.','','',''),('CS',528,'Obj-Oriented Progrmg & Design','Principles of object-oriented design; design patterns; use and design of frameworks; reflection, refractoring, use of unit tests as specifications. Prerequisite: CS 427.','4 hours.','','',''),('CS',533,'Parallel Computer Architecture','Theoretical aspects of parallel and pipeline computation; time and processor bounds on classes of computations; data alignment network speed and cost bounds; conflict-free access memories; overall computer system ideas. Same as CSE 522. Prerequisite: CS 433.','4 hours.','','',''),('CS',536,'Fault-Tolerant Dig Syst Design','Same as ECE 542. See ECE 542.','4 hours.','Same as ECE 542. See ECE 542.','',''),('CS',538,'Advanced Computer Networks','Advanced concepts in computer networks, including congestion control, quality of service, naming, routing, wireless networks, Internet architecture, measurement, network security, and selected recent research directions. Prerequisite: CS 438.','4 hours.','','',''),('CS',539,'Distributed Algorithms','Same as ECE 526. See ECE 526.','4 hours.','','',''),('CS',541,'Computer Systems Analysis','Same as ECE 541. See ECE 541.','4 hours.','Same as ECE 541. See ECE 541.','',''),('CS',543,'Computer Vision','Same as ECE 549. See ECE 549.','4 hours.','Same as ECE 549. See ECE 549.','',''),('CS',546,'Machine Learning in NLP','Central learning frameworks and techniques that have emerged in the field of natural language processing and found applications in several areas in text and speech processing: from information retrieval and extraction, through speech recognition to syntax, semantics and language understanding related tasks. Examination of the theoretical paradigms -- learning theoretic, probabilistic, and information theoretic -- and the relations among them, as well as the main algorithmic techniques developed within each paradigm and in key natural language applications. Prerequisite: CS 446 and CS 473.','4 hours.','','',''),('CS',547,'Deep Learning','Same as IE 534. See IE 534.','4 hours.','','',''),('CS',549,'Seminar in Cognitive Science','Same as PSYC 514, ANTH 514, EPSY 551, LING 570, and PHIL 514. See PSYC 514.','2 OR 4 hours.','','',''),('CS',554,'Parallel Numerical Algorithms','Numerical algorithms for parallel computers: parallel algorithms in numerical linear algebra (dense and sparse solvers for linear systems and the algebraic eigenvalue problem), numerical handling of ordinary and partial differential equations, and numerical optimization techniques. Same as CSE 512. Prerequisite: One of CS 450, CS 457, CS 555.','4 hours.','Same as CSE 512. Prerequisite: One of CS 450, CS 457, CS 555.','',''),('CS',555,'Numerical Methods for PDEs','Numerical techniques for initial and boundary value problems in partial differential equations. Finite difference and finite element discretization techniques, direct and iterative solution methods for discrete problems, and programming techniques and usage of software packages. Same as CSE 510. Prerequisite: CS 450 or CS 457.','4 hours.','','',''),('CS',556,'Iterative & Multigrid Methods','Comprehensive treatment of algebraic and multigrid iterative methods to solve systems of equations, primarily linear equations arising from discretization of partial differential equations. Same as CSE 511.','4 hours.','','',''),('CS',558,'Topics in Numerical Analysis','Advanced topics in numerical analysis selected from areas of current research. Same as CSE 513. May be repeated. Prerequisite: As specified for each topic offering, see Schedule or departmental course description.','4 hours.','','',''),('CS',563,'Advanced Computer Security','Current research trends in computer and network security. Privacy, tamper-resistance, unwanted traffic, monitoring and surveillance, and critical infrastructure protection. Subtopics will vary depending upon current research trends. Students work in teams in close coordination with the course instructor to develop one of the topics in depth by carrying out background research and an exploratory project. Same as ECE 524. Prerequisite: CS 461 or CS 463.','4 hours.','Same as ECE 524. Prerequisite: CS 461 or CS 463.','',''),('CS',565,'Human-Computer Interaction','In-depth coverage of advanced topics in human-computer interaction (HCI). Applied models of human performance and attention, design tools for creative design tasks, interruptions and peripheral displays, gestures, and bimanual input, and usability evaluation techniques. Students complete a research-oriented term project of their choosing. Prerequisite: CS 465.','4 hours.','','',''),('CS',571,'Combinatorial Mathematics','Same as MATH 580. See MATH 580.','4 hours.','Same as MATH 580. See MATH 580.','',''),('CS',572,'Extremal Graph Theory','Same as MATH 581. See MATH 581.','4 hours.','','',''),('CS',573,'Algorithms','NP-completeness, design and analysis techniques, approximation algorithms, randomized algorithms, combinatorial optimization, linear programming. Intended for graduate students in Computer Science. Same as CSE 515. 4 graduate hours. No professional credit.','4 hours.','','',''),('CS',574,'Randomized Algorithms','Basic and advanced concepts in the design and analysis of randomized algorithms. Sampling; concentration inequalities such as Chernoff-Hoeffding bounds; probabilistic method; random walks, dimension reduction; entropy; martingales and Azumas inequality; derandomization. Randomized algorithms for sorting and searching; graphs; geometric problems. Basics of pseudorandomness and randomized complexity classes. Prerequisite: CS 473; MATH 461 or STAT 400.','4 hours.','','',''),('CS',575,'Methods of Combinatorics','Same as MATH 584. See MATH 584.','4 hours.','','',''),('CS',576,'Topics in Automated Deduction','Advanced topics in computer-aided methods for formal deduction, selected from areas of current research, such as: resolution theorem proving strategies, special relations, equational reasoning, unification theory, rewrite systems, mathematical induction, program derivation, hybrid inference systems, and programming with logic. May be repeated in separate terms. Prerequisite: As specified for each topic offering, see Schedule or departmental course description.','2 TO 4 hours.','May be repeated in separate terms. Prerequisite: As specified for each topic offering, see Schedule or departmental course description.','',''),('CS',579,'Computational Complexity','Turing machines; determinism and non-determinism; time and space hierarchy theorems; speed-up and tape compression; Blum axioms; structure of complexity classes NP, P, NL, L, and PSPACE; complete problems; randomness and complexity classes RP, RL, and BPP; alternation, polynomial-time hierarchy; circuit complexity, parallel complexity, NC, and RNC; relativized computational complexity; time-space trade-offs. Same as ECE 579. Prerequisite: CS 473 or CS 475.','4 hours.','','',''),('CS',581,'Algorithmic Genomic Biology','Same as BIOE 540. See BIOE 540.','4 hours.','Same as BIOE 540. See BIOE 540.','',''),('CS',583,'Approximation Algorithms','Approximation algorithms for NP-hard problems. Basic and advanced techniques in approximation algorithm design: combinatorial algorithms; mathematical programming methods including linear and semi-definite programming, local search methods, and others. Algorithms for graphs and networks, constraint satisfaction, packing and scheduling. Prerequisite: CS 573 or consent of instructor.','4 hours.','','',''),('CS',584,'Embedded System Verification','Same as ECE 584. See ECE 584.','4 hours.','','',''),('CS',585,'Hardware Verification','Same as ECE 519. See ECE 519.','4 hours.','','',''),('CS',586,'Combinatorial Optimization','Same as IE 519. See IE 519.','4 hours.','','',''),('CS',591,'Advanced Seminar','Seminar on topics of current interest as announced in the Class Schedule. Approved for S/U grading only. May be repeated in the same or separate terms if topics vary. Prerequisite: As specified for each topic offering, see Class Schedule or departmental course description.','0 TO 4 hours.','Approved for S/U grading only. May be repeated in the same or separate terms if topics vary. Prerequisite: As specified for each topic offering, see Class Schedule or departmental course description.','',''),('CS',597,'Individual Study','Individual study or reading in a subject not covered in normal course offerings. May be repeated. Prerequisite: Consent of instructor.','2 TO 16 hours.','May be repeated. Prerequisite: Consent of instructor.','',''),('CS',598,'Special Topics','Subject offerings of new and developing areas of knowledge in computer science intended to augment the existing curriculum. See Class Schedule or departmental course information for topics and prerequisites. May be repeated in the same or separate terms if topics vary.','2 TO 4 hours.','May be repeated in the same or separate terms if topics vary.','',''),('CS',599,'Thesis Research','Approved for S/U grading only. May be repeated.','0 TO 16 hours.','Approved for S/U grading only. May be repeated.','','');
/*!40000 ALTER TABLE `course` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary view structure for view `course_rtgs`
--

DROP TABLE IF EXISTS `course_rtgs`;
/*!50001 DROP VIEW IF EXISTS `course_rtgs`*/;
SET @saved_cs_client     = @@character_set_client;
/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `course_rtgs` AS SELECT 
 1 AS `subject`,
 1 AS `number`,
 1 AS `name`,
 1 AS `avg_gpa`,
 1 AS `lastname`,
 1 AS `avg_rating`*/;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `enrollments`
--

DROP TABLE IF EXISTS `enrollments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `enrollments` (
  `netid` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `CRN` int NOT NULL,
  PRIMARY KEY (`netid`,`CRN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `enrollments`
--

LOCK TABLES `enrollments` WRITE;
/*!40000 ALTER TABLE `enrollments` DISABLE KEYS */;
INSERT INTO `enrollments` VALUES ('dy6',31518);
/*!40000 ALTER TABLE `enrollments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `professor`
--

DROP TABLE IF EXISTS `professor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `professor` (
  `firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lastname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `avg_rating` decimal(2,1) DEFAULT NULL,
  PRIMARY KEY (`firstname`,`lastname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `professor`
--

LOCK TABLES `professor` WRITE;
/*!40000 ALTER TABLE `professor` DISABLE KEYS */;
INSERT INTO `professor` VALUES ('A.','Endres',5.0),('A.','Hildebrand',4.0),('A.','Rayburn',3.8),('Aaron','Benjamin',4.0),('Aaron','Harper',5.0),('Aaron','Hill',3.0),('Abdelaadim','Bidaoui',3.5),('Abdussalam A','Alawini',5.0),('Abel','Ramirez',4.7),('Adam','Bowen',3.5),('Adam','Brandt',2.0),('Adam','Irish',2.7),('Adam','Myers',4.0),('Adam','Poetzel',5.0),('Adam M','Bates',2.0),('Adel','Ibrahim',3.0),('Adele','Pacquette',4.3),('Aditi','Das',5.0),('Adrian','Bruhns',5.0),('Adrian','Burgos',5.0),('Adriana','Molina',4.0),('Adrienne','Lo',4.0),('Adva','Waranyuwat',5.0),('Aida','El-Khadra',5.0),('Aimo','Hinkkanen',4.3),('Alan','Cobb',3.7),('Alan','Hansen',3.5),('Alan','Mette',4.0),('Albert','Man',5.0),('Albert F','Harris',3.4),('Aldo','Manfroi',4.7),('Alejandro','Lleras',4.5),('Alejandro','Lugo',1.3),('Alex','Kirlik',1.0),('Alexander','Duda',3.5),('Alexander','Lo',4.6),('Alexander','Smith',5.0),('Alexander','Tumanov',1.9),('Alexandra','Cavallaro',2.5),('Alexandra','Mobley',1.0),('Alexey','Stepanov',4.3),('Alexis','Dyschkant',5.0),('Alexis','Tate',1.0),('Alfred','Hubler',5.0),('Alfred','Roca',4.0),('Ali','Abbas',5.0),('Ali','Bazzi',5.0),('Ali','Tafti',2.0),('Ali','Toossi',3.5),('Alice','McCormack',3.5),('Alice','Novak',3.6),('Alicia','Kozma',5.0),('Alisha','Lewis',5.0),('Alison','Anders',3.5),('Alison','Colgrove',1.0),('Alison','Lanski',4.2),('Alison','Reddy',3.8),('Allison','Earl',4.8),('Allison','Scott',5.0),('Alok','Tiwari',4.0),('Alonzo','Ward',2.5),('Alyssa','Madsen',5.0),('Alyssa','Martoccio',3.0),('Amalia','Pursell',5.0),('Amanda','Szabo',4.0),('Amanda','Wisdom',4.0),('Amanda','Zink',4.0),('Amandeep','Gargi',5.0),('Amelia','Herb',3.0),('Amita','Sinha',2.5),('Amy','Ando',3.3),('Amy','Fischer-Brown',2.8),('Amy','Johnson',2.0),('Amy','Nicely',2.7),('Amy','Norgard',5.0),('Amy','Wagoner',3.0),('Andrea','Golato',5.0),('Andrea','Olinger',4.0),('Andreas','Cangellaris',5.0),('Andreas','Polycarpou',4.5),('Andrei','Kuzminov',1.0),('Andrew','Alleyne',4.0),('Andrew','Arana',4.5),('Andrew','Bauer',5.0),('Andrew','Chung',5.0),('Andrew','Cuthbertson',4.0),('Andrew','Greenlee',4.0),('Andrew','Hall',4.7),('Andrew','Hunte',5.0),('Andrew','Kerins',3.0),('Andrew','Leakey',3.8),('Andrew','Merrill',1.0),('Andrew','Meyer',5.0),('Andrew','Millard',4.0),('Andrew','Moss',3.5),('Andrew','Parrish',3.7),('Andrew','Pilny',4.5),('Andrew','Schultz',3.7),('Andrew','Singer',4.4),('Andrew','Suarez',4.7),('Andrew E','Miller',3.8),('Andrzej','Wieckowski',4.0),('Angela','Green',2.5),('Angela','Hurt',4.0),('Angela','Slates',1.0),('Angelia','Nedich',3.8),('Angharad','Valdivia',2.0),('Angus','Rockett',2.0),('Anil','Hirani',3.0),('Anja','Bankovic',1.0),('Ankit','Saharan',5.0),('Ann','Long',3.7),('Ann','Reisner',3.0),('Anna','Dilger',5.0),('Anna','Escobar',3.8),('Anna','Rinaldi-Miles',2.3),('Anna','Verbuk',5.0),('Anna-Maria','Marshall',5.0),('Anne','Baranger',2.0),('Anne','Barger',2.0),('Anne','Burkus-Chasson',3.7),('Anne','Owens',3.0),('Annie','Abbott',4.7),('Annie','Kelvie',2.0),('Anshul','Kogar',5.0),('Anthony','Coats',5.0),('Anthony','Yannarell',3.7),('Antoinette','Burton',3.0),('Anton','Malkin',1.0),('Antonio','Nunez',4.0),('Antonios','Augoustakis',5.0),('Anupam','Agrawal',5.0),('Anupama','Varadharajan',4.7),('Anustup','Basu',4.0),('Ao','Chen',3.0),('Ari','Pence',5.0),('Ariana','Traill',4.2),('Aric','Rindfleisch',4.0),('Arif','Masud',3.0),('Arindam','Roy',4.0),('Armin','Straub',5.0),('Armstrong','nan',4.7),('Arne','Pearlstein',1.8),('Artan','Sheshmani',3.0),('Arthur','Melnick',3.8),('Arthur','Schmidt',4.7),('Asef','Bayat',5.0),('Ashleigh','Jones',4.0),('Ashley','Hetrick',4.8),('Ashley','Holland',4.0),('Ashley','Stinespring',4.0),('Ashwini','Chhatre',3.0),('Astrid','Runggaldier',4.0),('Athol','Kemball',4.7),('Atul','Dixit',3.5),('Augusto','Espiritu',4.0),('Austin','Basye',5.0),('Austin','Lee-Richerson',5.0),('Avani','Patel',5.0),('Aya','Shigeto',5.0),('B.','Spencer',4.2),('Barbara','Minsker',1.4),('Barry','Ackerson',5.0),('Barry','Mink',4.1),('Barry','Pittendrigh',3.0),('Bartlomiej','Siudeja',3.5),('Bassem','Andrawes',2.5),('Bavwidinsi','Bawawana',3.0),('Behice','Ilhan',5.0),('Benjamin','Bascom',4.0),('Benjamin','Clegg',5.0),('Benjamin','Gailey',4.2),('Benjamin','Goodney',3.0),('Benjamin','Hidalgo',3.0),('Benjamin','Kern',1.0),('Benjamin','Slade',2.0),('Benjamin','Warlick',4.0),('Bertrand','Guillou',3.8),('Beth','Morgan',3.3),('Bethany','Cooper',5.0),('Bethany','Cutts',5.0),('Bettina','Francis',3.0),('Beverly','Stewart',2.0),('Billy','Vermillion',3.5),('Bjorn','Malekin',4.5),('Blake','Johnson',3.0),('Bo','Li',3.5),('Bobby','Belote',4.0),('Braden','Brinkman',5.0),('Bradley','Cosentino',4.0),('Bradley','Mehrtens',4.3),('Brendan','Harley',4.5),('Brenden','Carollo',4.0),('Brent','Hart',3.2),('Brent','McBride',3.2),('Brent','Roberts',3.9),('Brent','Young',4.2),('Brett','Loman',5.0),('Brian','Benson',4.0),('Brian','Deal',4.0),('Brian','Demarco',1.5),('Brian','Dolber',4.0),('Brian','Enders',5.0),('Brian','Gonsalves',3.0),('Brian','Jamison',2.5),('Brian','Lilly',4.5),('Brian','Manor',5.0),('Brian','Phelan',4.0),('Brian','Quick',4.5),('Brian','Ross',4.2),('Brian','Rosten',3.0),('Brian','Walters',4.0),('Brian P','Bailey',4.1),('Britni','Townsend',5.0),('Bruce','Carpenter',3.8),('Bruce','Conway',5.0),('Bruce','Flachsbart',4.0),('Bruce','Fouke',5.0),('Bruce','Hajek',4.0),('Bruce','Levine',4.0),('Bruce','Reznick',5.0),('Bruce','Smith',4.0),('Brunet','nan',4.5),('Bryan','Dunne',4.5),('Bryan','Mount',3.0),('Bryce','Dietrich',4.0),('C.','Gunsalus',2.6),('C.','Henson',5.0),('Caetano-Anolles','nan',4.5),('Cagdas','Agirdas',3.8),('Caitlin','Clarke',4.8),('Cale','Magnuson',4.3),('Carie','Steele',1.0),('Carl','Gunter',5.0),('Carl','Malmgren',2.5),('Carla','Caceres',3.0),('Carla','Costa',4.0),('Carla','Hunter',3.0),('Carla','Rosell',1.0),('Carlie','Fieseler',1.0),('Carol','Ash',1.0),('Carol','Augspurger',3.1),('Carol','Leff',4.0),('Carol','Symes',3.6),('Caroline','Tancredy',4.0),('Caroline','Yang',3.6),('Carrie','Mulvaney',5.0),('Cascajar-Montero','nan',4.5),('Cassandra','Meinert',4.0),('Cassandra','Rosado',5.0),('Catherine','Blake',1.0),('Catherine','Lundy',4.0),('Catherine','Murphy',3.0),('Catherine','Wiesener',5.0),('Ceridwen','Hall',3.0),('Chad','Rienstra',4.0),('Chae','Yoon',4.0),('Chaitanya','Date',2.0),('Chang','Ham',1.0),('Charissa','Lansing',5.0),('Charles','Byrne',5.0),('Charles','Fogelman',4.0),('Charles','Gammie',3.0),('Charles','Lawarre',3.3),('Charles','Miller',2.5),('Charles','Rezk',3.0),('Charles','Roseman',4.0),('Charles','Schroeder',4.5),('Charles','Voigt',4.5),('Charles','Werth',5.0),('Charles','Whitfield',1.5),('Charlevoix-Romine','nan',4.0),('Chayapa','Darayon',4.2),('Chen','Yao',3.0),('Chengxiang','Zhai',5.0),('Chera','LaForge',5.0),('Cheryl','Cole',3.5),('Cheryl','Light',2.3),('Cheryl','Shriner',3.0),('Chester','Alwes',3.3),('Chester','Brown',3.8),('Chia','Chang',5.0),('Chia-Fon','Lee',2.0),('Chih','Liu',4.0),('Christian','Ray',4.3),('Christina','Schultz',4.0),('Christine','DeLisle',4.0),('Christine','Deloff',5.0),('Christine','Yerkes',3.2),('Christopher','Duff',2.5),('Christopher','Fennell',4.5),('Christopher','Freeburg',4.0),('Christopher','Salnave',4.0),('Christopher','Schmitz',5.0),('Chryle','Elieff',4.0),('Chu-Yung','Chen',4.2),('Chumachenko','nan',5.0),('Cinda','Heeren',4.8),('Claire','Brady',4.0),('Clare','Crowston',3.6),('Clifford','Singer',2.0),('Clifton','Brown',3.5),('Colin','Flint',3.0),('Colin','Thorn',4.0),('Colin','Wraight',2.0),('Colleen','Schultz',3.3),('Constancio','Arnaldo',4.0),('Corey','Flournoy',5.0),('Corina','Lacatus',5.0),('Corinne','Crane',3.5),('Cornelia','Otnes',3.8),('Courtney','Flint',4.0),('Craig','Gundersen',4.0),('Craig','Koslofsky',2.1),('Craig','Zilles',4.7),('Crespo','Del',5.0),('Cristina','Zapata',3.7),('Crystal','Thomas',4.0),('Curtis','Jacobs',3.7),('Curtis','Perry',4.5),('Curtis','Shoaf',4.7),('Cynthia','Fisher',3.3),('Cynthia','Johnson',3.0),('Cynthia','Turner',2.0),('Cynthia','Wachter',3.8),('Dale','Bauer',3.0),('Dale','Harlingen',5.0),('Dalia','Chowdhury',5.0),('Dallas','Trinkle',4.0),('Damarys','Canache',3.5),('Dan','Lior',4.0),('Dan','Roth',5.0),('Dan','Shao',3.0),('Dana','Dlott',3.0),('Dana','Kiku',1.8),('Dana','Rabin',3.3),('Dana','Shalash',5.0),('Daniel','Abrams',3.7),('Daniel','Bodony',3.5),('Daniel','Bradley',5.0),('Daniel','Colson',1.0),('Daniel','Estrada',3.0),('Daniel','Holder',5.0),('Daniel','Jumper',5.0),('Daniel','Kelly',3.0),('Daniel','Pack',2.8),('Daniel','Petrella',4.0),('Daniel','Schneider',4.3),('Daniel','Schultz',1.0),('Daniel','Sholem',5.0),('Daniel','Simons',4.5),('Daniel','Steward',3.8),('Daniel','Tortorelli',3.3),('Daniel','Walsh',4.0),('Daniel','Wasserman',3.0),('Daniel','Wong',4.3),('Daniel','Work',4.0),('Danielle','Thomas',4.0),('Darin','Eastburn',3.5),('Darrel','Kesler',5.0),('Darrell','Kuykendall',4.0),('Dave','Grych',3.0),('David','Bullock',2.5),('David','Cahill',2.5),('David','Chih',5.0),('David','Clark',2.4),('David','Dalpiaz',3.8),('David','Daum',5.0),('David','Forsyth',4.0),('David','Goodman',3.2),('David','Gooler',2.9),('David','Kesler',4.0),('David','Lange',4.0),('David','Lyon',4.0),('David','Mertens',5.0),('David','Meyer',4.0),('David','Michael',5.0),('David','Miller',3.0),('David','Morris',5.0),('David','Nicol',3.0),('David','OBrien',4.0),('David','Porter',4.0),('David','Remmert',4.3),('David','Rivier',3.7),('David','Roediger',2.0),('David','Rosch',5.0),('David','Ruzic',5.0),('David','Saintillan',4.3),('David','Sansone',2.7),('David','Sinow',3.3),('David','Strauser',1.0),('David','Sussman',5.0),('David','Tewksbury',4.5),('David','Varodayan',5.0),('David','Wright',5.0),('David','Yang',4.0),('David','Zola',5.0),('David A','Padua',1.6),('Dawn','Bohn',3.7),('Dean','Riechers',3.0),('Deana','McDonagh',2.8),('Debojoy','Chanda',5.0),('Debra','Hagstrom',5.0),('Debra','Reid',2.2),('Deepthi','Nandakumar',1.0),('Delmar','Rhodes',2.0),('Denise','Cummins',4.0),('Deniz','Ay',4.0),('Denka','Kutzarova-Ford',3.0),('Dennis','Beard',5.0),('Dennis','Dullea',4.0),('Dennis','ODea',3.0),('Dennis','Readey',3.8),('Derek W','Hoiem',4.4),('Deschenes','Pradet',5.0),('Dexter','Arnold',1.0),('Diana','Grigsby',2.0),('Diana','Ranoa',4.7),('Diane','Koenker',5.0),('Dianne','Noland',4.2),('Diloa','Bailey',5.0),('Dimitrios','Kyritsis',5.0),('Ditlev','Monrad',2.5),('Dominguez-Garcia','nan',3.3),('Donald','Briskin',5.0),('Donald','Bullock',3.8),('Donald','Davis',3.9),('Donald','Decoste',4.5),('Donald','Hardin',2.8),('Donald','McFarland',4.0),('Donald','Stenzel',5.0),('Donghun','Joo',5.0),('Dongwoo','Kim',1.0),('Donna','Brown',3.6),('Donna','Buchanan',3.2),('Dora','Valkanova',3.0),('Dorine','Brand',2.5),('Dorothee','Schneider',2.7),('Dorothy','Espelage',5.0),('Doug','Owens',2.0),('Douglas','Beck',3.0),('Douglas','Elrick',4.0),('Douglas','Jones',4.0),('Douglas','Miller',4.0),('Douglas','Mitchell',1.0),('Douglas','Olenik',2.0),('Douglas','Parrett',4.9),('Douglas','Simpson',3.0),('Dov','Weiss',3.0),('Duane','Watson',3.0),('Duncan','Keenan-Jones',1.0),('Dunja','Jelesijevic',5.0),('Dustin','Allred',2.0),('Dustin','Lange',4.8),('Dusty','Grundmeier',4.0),('E.','Love',4.2),('Edgar V','Solomonik',4.5),('Edmund','Sutton',3.5),('Eduard-Wilhelm','Kirr',1.0),('Edward','Hertenstein',3.0),('Edward','Ofori',5.0),('Edward','Robinson',3.0),('Edward','Sellers',5.0),('Edwin','Carrington',4.0),('Eileen','Herrstrom',3.3),('Eileen','Lagman',5.0),('Elaina','Osterbur',5.0),('Elaine','Wood',5.0),('Elena','Boiarskaia',1.0),('Elizabeth','Altiero',5.0),('Elizabeth','Crosby',4.0),('Elizabeth','Glogowski',4.0),('Elizabeth','Good',2.5),('Elizabeth','LeMay',4.0),('Elizabeth','Reutter',5.0),('Elizabeth','Sweet',1.0),('Elizabeth','Tyler',2.0),('Ellen','Evans',2.0),('Ellen','Fireman',4.8),('Ellen','Moodie',3.0),('Elsa','Gunter',2.7),('Ely','Kerman',2.7),('Elyse','Vigiletti',5.0),('Emanuel','Rota',4.0),('Emilie','Bagby',4.0),('Emily','Ewers',2.0),('Emily','Mailey',3.8),('Emily','Parrott',3.3),('Emily','Shaw',5.0),('Engelbrecht-Wiggans','nan',3.0),('Ercan','Balci',5.0),('Erhan','Kudeki',4.8),('Eric','Drollette',2.0),('Eric','Hostetter',3.0),('Eric','Johnson',5.0),('Eric','Meyer',1.0),('Eric','Oldfield',4.0),('Eric','Peterson',4.0),('Eric','Shaffer',4.3),('Eric','Snodgrass',5.0),('Eric','Tanyavutti',3.0),('Eric','Vimr',5.0),('Erica','Britt',4.0),('Ericka','Beckman',1.0),('Erik','Hemingway',5.0),('Erik','McDuffie',2.5),('Erin','Castro',3.0),('Erin','Chandler',3.0),('Erin','McQuiston',3.0),('Erin','Whitteck',2.9),('Esmail','Meisami',3.9),('Esther','Dettmar',3.0),('Esther','Heinz',5.0),('Esther','Lee',5.0),('Eugene','Avrutin',3.5),('Eugene','Lerman',4.0),('Eun','Lim',2.0),('Eurydice','Bauer',1.0),('Evan','Melhado',2.0),('Eyal','Amir',2.0),('Eyamba','Bokamba',3.0),('F.','Simmons',4.5),('Fabio','Manda',5.0),('Faith','Stein',3.0),('Fang-Kai','Jao',4.5),('Faranak','Miraftab',3.0),('Farhad','Malekafzali',2.2),('Farzan','Kazemifar',4.0),('Fay','Hodza',5.0),('Fedja','Buric',1.0),('Fei','Wang',3.0),('Feisal','Mohamed',4.5),('Felipe','Cardoso',5.0),('Felipe','Olivarez',1.0),('Feng','Liang',3.5),('Ferrando','Valero',4.2),('Fiona','Ngo',4.5),('Flavia','Andrade',4.0),('Florencia','Henshaw',4.2),('Florin','Boca',1.6),('Floyd','McKeith',5.0),('Francis','Boyle',3.5),('Francis','Machungo',4.0),('Francisco','Gallart',3.8),('Franklin','Ridgway',5.0),('Fred','Gottheil',2.6),('Fred','Stoltzfus',4.0),('Ga-Young','Choi',3.0),('Gabriel','Solis',4.0),('Gail','Hapke',4.0),('Gaines','Hall',3.0),('Gang','Liu',1.7),('Gary','Crull',4.0),('Gary','Dell',3.8),('Gary','Gladding',3.5),('Gary','Olsen',4.5),('Gary','Parker',3.0),('Gary','Wszalek',5.0),('Gary','Xu',4.5),('Gaston','Philipps',4.0),('Gavin','Horn',4.0),('Geoffrey L','Herman',4.2),('Geoffrey W','Challen',3.2),('George','Bell',4.0),('George','Boone',4.0),('George','Krueger',4.0),('Georgepierre','Lebron',3.2),('Georgia','Garcia',1.0),('Gerald','Dejong',2.5),('Gerald','Walter',5.0),('Geralyn','Holley',5.0),('German','Bollero',4.8),('Ghamari-Tabrizi','nan',2.9),('Ghazi','Kalahroudi',3.0),('Gholamreza','Mesri',5.0),('Gilberto','Rosas',2.6),('Girish','Krishnan',3.0),('Gisela','Sin',5.0),('Glaucio','Paulino',4.0),('Glenda','Kao',1.0),('Glenn','Roisman',4.5),('Glennys','Mensing',5.0),('Gokhan','Atinc',1.0),('Grace','Giorgio',3.5),('Graham C','Evans',2.6),('Grant','Lewis',4.0),('Grant','Shoffstall',5.0),('Greg','Burton',4.0),('Greg','McFarquhar',4.3),('Gregg','Strauss',4.0),('Gregory','Kelsey',3.0),('Gregory','MacDougall',2.0),('Gregory','Meyer',5.0),('Gregory','Webb',5.0),('Gretchen','Adams',4.8),('Grigore','Rosu',3.0),('Gunji-Ballsrud','nan',1.0),('Gurumurthi','nan',2.0),('Gustavo','Gioia',4.4),('Gwendolen','Rudy',3.5),('H.','Gaskins',5.0),('H.','Murdoch',3.0),('Hae','Chung',5.0),('Hailan','Zhou',4.0),('Haitham','Al-Hassanieh',3.0),('Haiyan','Lin',5.0),('Hamood','Arham',5.0),('Han-Jui','Chen',5.0),('Hannah','Chan',3.0),('Hao','Feng',5.0),('Hari','Sundaram',3.7),('Harley','Johnson',3.4),('Harrison','Kim',3.0),('Harry','Dankowicz',5.0),('Harry','Liebersohn',4.0),('Harry','Wildblood',3.0),('Hasan','Ozer',5.0),('Hasegawa-Johnson','nan',5.0),('Hassan','Arvin-Rad',2.7),('Hatun','Zengin',4.5),('Haymon-Coleman','nan',4.0),('Hayri','Onal',5.0),('Heather','Blain',4.0),('Heather','Minor',4.0),('Heather','Zike',2.0),('Hee','Chung',4.0),('Heejeong','Jeong',1.0),('Helaine','Silverman',4.0),('Helga','Varden',4.0),('Hendricksen','nan',3.3),('Hendrik','Schulze',4.0),('Henrique','Reis',2.5),('Henry','Schenck',4.2),('Heydari','Barardehi',3.0),('Hongye','Liu',3.0),('Howard','Schein',5.0),('Huang-Wen','Lai',5.0),('Hugh','Robertson',4.7),('Huseyin','Sehitoglu',3.0),('Hyun','Kang',4.0),('Hyun','Kim',2.3),('Hyun','Kong',3.4),('Ian','Robertson',3.5),('Ibrahim','Odeh',2.5),('Ida','Salusky',3.0),('Igor','Cunha',5.0),('Igor','Nikolaev',3.3),('Igor','Petrik',4.0),('Iker','Plazaola',3.0),('Ilana','Akresh',2.0),('Ilia','Kapovitch',4.0),('Imelda','Moise',4.0),('In-Koo','Cho',1.0),('Indranil','Gupta',5.0),('Inger','Stole',1.0),('Ioannis','Chasiotis',4.0),('Irene','Small',4.5),('Irene','Zavarsky',5.0),('Iryce','Baron',5.0),('Iryna','Sharaievska',3.5),('Isaac','DiIanni',2.5),('Isaac','Tubb',3.9),('Isabel','Wulf',5.0),('Israel','E.',4.0),('Itxaso','Rodriguez',5.0),('Ivanhoe','Favila',1.0),('Ivy','Glennon',2.8),('Iwan','Duursma',2.5),('Izaskun','Indacoechea',5.0),('J.','Beckett',4.5),('J.','Dutton',4.8),('J.','Eheart',2.0),('J.','Giertz',3.0),('J.','Litchfield',3.3),('Jacalyn','Wittmer',5.0),('Jack','Ikeda',2.7),('Jacob','Hall',2.0),('Jacqueline','McDowell',1.0),('Jae','Yong',4.0),('Jaehyuk','Kwack',4.0),('Jaewon','Choi',5.0),('Jaimi','Goodfriend',2.0),('James','Barkley',5.0),('James','Barrett',4.0),('James','Beauchamp',1.0),('James','Best',5.0),('James','Brennan',4.5),('James','Bunch',3.0),('James','Eden',5.0),('James','Imlay',5.0),('James','Jackson',2.0),('James','Lafave',4.0),('James','Lansing',3.0),('James','Leake',3.0),('James','Lisy',3.0),('James','Miller',2.3),('James','Morrissey',3.0),('James','Phillips',3.2),('James','Salvo',5.0),('James','Slauch',4.7),('James','Sowa',2.0),('James','Stubbins',4.2),('James','Wallace',4.0),('Jamie','OConnor',5.0),('Jamil','Johnson',5.0),('Jan','Brooks',5.0),('Jan','Erkert',5.0),('Jane','Marshall',3.5),('Janeen','Johnson',4.0),('Janet','Gaffney',1.0),('Janet','Reis',4.0),('Jang-Mei','Wu',3.3),('Janice','Juraska',2.4),('Janice','Sherbert',4.0),('Jared','Bronski',4.1),('Jasmina','Savic',5.0),('Jason','Chambers',3.7),('Jason','McCarley',4.0),('Jason','Morrissette',4.9),('Jason','Sneed',3.0),('Jason','Vredenburg',4.6),('Javid','Dizgam',5.0),('Jay','Luckritz',5.0),('Jayme','Liggett',5.0),('Jean','Lee',3.0),('Jean-Pierre','Leburton',2.9),('Jeanne','Connell',3.2),('Jeehyeon','Seo',3.0),('Jeff','Erickson',3.5),('Jeffrey','Carlson',4.5),('Jeffrey','Castle',5.0),('Jeffrey','Davis',4.0),('Jeffrey','Dawson',4.0),('Jeffrey','Douglas',5.0),('Jeffrey','Frame',3.8),('Jeffrey','Kansler',3.5),('Jeffrey','Ledebuhr',5.0),('Jeffrey','Loewenstein',5.0),('Jeffrey','Magee',4.3),('Jeffrey','Moore',2.3),('Jeffrey','Spencer',4.5),('Jeffrey','Thibert',4.0),('Jeffrey','Trask',3.9),('Jennifer','Bernhard',5.0),('Jennifer','Burns',5.0),('Jennifer','Cravens',4.0),('Jennifer','Follis',3.2),('Jennifer','Fraterrigo',4.0),('Jennifer','Kotowski',4.0),('Jennifer','McNeilly',4.0),('Jennifer','Nelson',4.0),('Jennifer','Oshen',5.0),('Jennifer','Pahre',4.0),('Jennifer','Pollack',5.0),('Jennifer','Romine',4.0),('Jennifer','Scott',5.0),('Jennifer','Shoaff',1.9),('Jennifer','Smist',5.0),('Jennifer','Weber',1.0),('Jenny','Singleton',5.0),('Jensen','Beach',5.0),('Jerald','Pataky',3.0),('Jerald','Shelato',4.0),('Jeremiah','Bohr',4.0),('Jeremy','Rouse',5.0),('Jeremy','Wear',5.0),('Jerome','Juska',5.0),('Jerome','Packard',4.5),('Jerrod','Henderson',5.0),('Jesse','Beder',4.0),('Jesse','Jones',4.3),('Jesse','Miller',2.0),('Jesse','Rhoades',4.0),('Jessica','Chubiz',5.0),('Jessica','Greenberg',3.0),('Jessica','Jacobson',4.0),('Jessica','Wong',3.0),('Jessie','Johnson',5.0),('Jian','Shang',3.8),('Jianan','Xu',4.7),('Jianhua','Zhang',3.5),('Jiawei','Han',4.5),('Jibo','He',3.0),('Jie','Yang',1.0),('Jill','Clements',4.0),('Jill','Craft',5.0),('Jill','Fitzgerald',4.0),('Jill','Tschopp',5.0),('Jimmy','Wong',4.0),('Jingyu','Huang',4.0),('Jinming','Zhang',3.0),('Jinwon','Choi',5.0),('Jiri','Lebl',4.5),('Joan','Huber',2.0),('Joanna','Austin',3.8),('Joanna','Osterhout',1.0),('Joanne','Manaster',5.0),('Jodi','Flaws',5.0),('Joe','Bradley',5.0),('Joe','Harper',4.3),('Joel','Versypt',4.0),('Johann','Thiel',4.0),('John','Abelson',4.0),('John','Alsterda',5.0),('John','Braden',3.7),('John','Caughlin',3.7),('John','Colombo',5.0),('John','DAngelo',2.5),('John','Dayger',4.0),('John','Edgington',5.0),('John','Georgiadis',3.0),('John','Hough',4.2),('John','Hummel',1.0),('John','Jones',4.0),('John','Kindt',3.7),('John','Lambros',4.5),('John','Lenz',1.0),('John','Low',5.0),('John','Mackay',3.5),('John','Marsh',5.0),('John','Moore',2.5),('John','Murphy',3.7),('John','Musser',4.7),('John','Polk',2.0),('John','Popovics',4.0),('John','Ramsbottom',3.5),('John','Rubins',5.0),('John','Senseney',3.5),('John','Taft',4.0),('John','Trach',2.8),('John','Vasquez',3.2),('John','Walsh',4.7),('John','Weaver',2.0),('Johnell','Bentz',4.6),('Jon','Solomon',4.7),('Jon','Thaler',3.0),('Jonathan','Beever',3.5),('Jonathan','Ebel',2.9),('Jonathan','Freund',2.5),('Jonathan','Greenberg',4.0),('Jonathan','Hamilton',3.0),('Jonathan','Hollis',5.0),('Jonathan','Jarrell',5.0),('Jonathan','Krohn',1.0),('Jonathan','Livengood',4.5),('Jonathan','Makela',4.5),('Jonathan','Marcot',3.7),('Jonathan','Tomkin',4.5),('Jonathan','Tullis',5.0),('Jonathan','Waskan',4.5),('Jont','Allen',4.0),('Jordan','Levey',5.0),('Jorge','Marquez',4.0),('Jose','Alejandro',2.0),('Jose','Cheibub',3.3),('Jose','Hualde',2.0),('Jose','Mestre',3.5),('Jose','Peralta',4.0),('Jose','Schutt-Aine',3.0),('Jose','Vazquez',4.0),('Joseph','Barich',5.0),('Joseph','Beverly',2.3),('Joseph','Cheng',1.0),('Joseph','Diamond',3.0),('Joseph','Finnerty',2.3),('Joseph','Grohens',4.0),('Joseph','Hinchliffe',1.5),('Joseph','Hutto',5.0),('Joseph','Mahoney',5.0),('Joseph','Manfredo',5.0),('Joseph','Miles',4.5),('Joseph','Miller',4.5),('Joseph','Petry',4.0),('Joseph','Robinson',4.0),('Joseph','Rosenblatt',2.4),('Joseph','Squier',5.0),('Joseph','Swenson',4.0),('Joshua','Brown',3.0),('Joshua','Gulley',4.7),('Joshua','Lynch',1.0),('Joshua T','Asplund',4.2),('Joyce','Allen-Smith',1.0),('Juan','Andrade',5.0),('Juan','Fung',5.0),('Juan','Loor',3.8),('Jude','Hays',4.0),('Judith','King',1.5),('Jugo','Martinez',4.0),('Jui','Namjoshi',5.0),('Julia','Hockenmaier',3.0),('Julia','Saville',3.2),('Julia','Shapland',3.6),('Julia','Smith',3.0),('Julian','Parrott',5.0),('Julie','Bobitt',4.5),('Julie','Cidell',5.0),('Julie','Dowling',4.0),('Julie','Hengst',4.0),('Julie','Larsen',2.6),('Julie','Patterson',5.0),('Julie','Price',5.0),('Julie','Son',5.0),('Julius','Riles',5.0),('Jun','Hong',1.0),('June','Huh',5.0),('Jung','Hyun',4.0),('Jung','Lee',4.0),('Jung','Pyo',5.0),('Junho','Song',4.5),('Justin','Davidson',4.5),('Justin','Hanson',2.0),('Justin','Rhodes',3.0),('Justine','Karduck',4.0),('K.','Hsia',5.0),('Kai-Wing','Chow',2.0),('Kaitlin','Marks-Dubbs',4.0),('Kara','Federmeier',3.7),('Karen','Mortensen',4.0),('Karen','Quisenberry',5.0),('Karen','Roybal',5.0),('Karen','Rudolph',5.0),('Karla','Palma',2.8),('Kate','Grim-Feinberg',1.0),('Katherine','Baylis',4.0),('Katherine','Graham',5.0),('Katherine','Tryon',5.0),('Katherine','Wahl',5.0),('Kathleen','Smith',3.0),('Kathryn','Clancy',3.5),('Kathryn','Oberdeck',2.5),('Katrina','Olson',2.4),('Katzenellenbogen','nan',3.3),('Kelly','Bost',5.0),('Kelly','Innes',5.0),('Kelly','Marville',3.2),('Kelly','Tappenden',5.0),('Ken','Salo',1.0),('Kenneth','Berg',1.0),('Kenneth','Chapman',3.4),('Kenneth','Cuno',4.0),('Kenneth','Olson',2.0),('Kenneth','Stolarsky',2.7),('Kenneth','Suslick',4.7),('Kent','Ono',4.0),('Kerianne','Quick',5.0),('Kevin','Chang',4.5),('Kevin','Erickson',4.0),('Kevin','Ford',3.7),('Kevin','Hamilton',4.0),('Kevin','Jackson',5.0),('Kevin','Kline',4.6),('Kevin','OLeary',5.0),('Kevin','Raschen',5.0),('Kevin','Reeder',4.6),('Kevin','Teng',3.0),('Kevin','Waspi',2.8),('Khaled','El-Rayes',5.0),('Ki','Lee',3.8),('Kiel','Christianson',5.0),('Kil','Kim',3.0),('Kiley','Reed',5.0),('Kim','Whittlesey',4.1),('Kimani','Toussaint',5.0),('Kimberly','Fonzo',5.0),('Kimberly','Koch',5.0),('Kimberly','Shinew',2.6),('Kimiko','Gunji',4.0),('Kindratenko','nan',3.8),('Kirk','Stodola',1.0),('Kirsten','Hope',4.5),('Kirsten','Letofsky',2.0),('Kirstie','Simson',5.0),('Kit','Mak',1.0),('Kitwiwattanachai','nan',1.0),('Koloutsou-Vakakis','nan',4.0),('Konstantinos','Travlos',3.3),('Kostyantyn','Slutskyy',3.5),('Kourtikakis','nan',5.0),('Kristen','Davis',4.0),('Kristin','Drogos',5.0),('Kristin','Hoganson',3.0),('Kristin','Walters',5.0),('Kristina','Miler',3.0),('Kristina','Rennekamp',5.0),('Kristina','Riedel',1.0),('Kristine','Cochran',1.0),('Kuang-Chien','Hsieh',4.0),('Kun','Kim',2.0),('Kurt','Bauer',2.0),('Kurt','Kwast',4.0),('Kyekyoon','Kim',3.3),('Kyle','Williams',4.3),('Laird','Thompson',4.4),('Lance','Schideman',1.0),('Landrum-Brown','nan',2.0),('Lane','Martin',3.5),('Lanqing','Hua',1.0),('Lara','Waldrop',4.0),('Larry','Di',5.0),('Larry','Fahnestock',4.0),('Latrelle','Bright',3.0),('Laura','Brown',4.6),('Laura','Chinchilla',5.0),('Laura','Galicia',5.0),('Laura','Greene',4.5),('Laura','Hastings',4.0),('Laura','Hill',4.5),('Laura','Hollis',4.2),('Laura','McCloskey',2.0),('Laura','Reynolds',4.0),('Laura','Shackelford',4.0),('Lauren','Collins',5.0),('Lauren','Denofrio',4.0),('Lauren','Hansen',3.0),('Lauren','Hetrovicz',4.0),('Lauren','VanNatta',3.0),('Lauren','Weiner',5.0),('Laurence','Mall',5.0),('Laurie','Johnson',5.0),('Lawrence','Angrave',4.9),('Lawrence','Hamlin',3.8),('Laxmikant','Kale',3.0),('Lee','Waldrep',3.8),('Leigh','Mingle',4.0),('Leininger','nan',4.8),('Lena','Hann',4.0),('Leon','Frizzell',3.2),('Leonard','Pitt',3.8),('Leslie','Gasser',4.0),('Leslie','Looney',4.8),('Leslie','Reagan',1.6),('Li','Li',4.2),('Li','Tan',4.0),('Liang','Liu',5.0),('Lila','Vodkin',4.0),('Liliana','Gonzalez',5.0),('Lilya','Kaganovsky',4.0),('Lina','Deng',5.0),('Linda','Garrow',3.3),('Linda','Larsen',3.5),('Linda','Lehovec',4.0),('Linda','Smith',5.0),('Lindsay','Sperling',3.6),('Lindsey','Drager',4.0),('Ling','Ren',2.7),('Lippold','Haken',4.2),('Lisa','Burgoon',5.0),('Lisa','Cacho',4.5),('Lisa','Crane',4.5),('Lisa','Dixon',1.0),('Lisa','Gundersen',3.1),('Lisa','Lucero',3.0),('Lisa','Monda-Amaya',3.0),('Lisa','Oliverio',5.0),('Lisa','Travis',2.8),('Lori','Coulter',5.0),('Lori','Kendall',3.0),('Lori','Paden',5.0),('Lu','Gan',3.0),('Lu','Xu',3.2),('LuAnn','Hansen',4.0),('Lucas','Anderson',4.5),('Luis','Herrera',5.0),('Luis','Rodriguez',3.0),('Lujun','Guo',3.0),('Luke','Batten',5.0),('Luke','Godwin-Jones',4.5),('Luke','Olson',4.3),('Lusha','Zhu',5.0),('Luthey-Schulten','nan',2.5),('Lynette','Barnes',2.5),('Lynford','Goddard',3.4),('Lynn','Herrmann',1.0),('Lynn','Morris',1.0),('Lynn','Sikma',5.0),('Lynnell','Lacy',4.7),('M.','Brewster',2.3),('M.','Spies',2.6),('Maarten','Bergvelt',3.4),('Madeline','Weikert',4.5),('Magdi','Ragheb',4.2),('Maggie','Kainulainen',3.7),('Mahdi','Rastad',3.0),('Mahesh','Viswanathan',4.5),('Mahir','Saul',3.0),('Maksym','Bobrovskyy',5.0),('Malay','Dey',1.0),('Mandy','Troger',5.0),('Marc','Perry',2.0),('Marcelo','Bucheli',1.0),('Marco','Caccamo',3.0),('Marco','Rocha',3.0),('Margaret','Fleck',3.2),('Margaret','Flinn',4.0),('Margaret','Kelley',5.0),('Margaret','McCurdy',3.0),('Margaret','Njeru',4.3),('Margaret','Stanny',5.0),('Margareth','Etienne',2.0),('Maria','Anderson',3.0),('Maria','Garzaran',2.2),('Maria','Muyot',3.0),('Maria','Rubio-Campos',3.0),('Maria','Spies',3.0),('Maria','Stasevicius',4.8),('Maria','Todorova',4.7),('Marian','Stone',5.0),('Mariana','Sohn',5.0),('Mariana T','Silva',4.0),('Marilyn','Holguin',4.5),('Marina','Miletic',3.0),('Mario','Perez',4.0),('Mariselle','Melendez',4.0),('Marius','Junge',5.0),('Mark','Berchman',4.0),('Mark','David',4.1),('Mark','Fletcher',5.0),('Mark','Leff',3.5),('Mark','Micale',4.4),('Mark','Moore',3.0),('Mark','Nelson',4.0),('Mark','Rood',3.5),('Mark','Roszkowski',3.2),('Mark','Schaedel',4.0),('Mark','Shannon',5.0),('Mark','Taylor',2.5),('Marni','Boppart',4.0),('Marsha','Woodbury',4.0),('Martin','Burke',2.5),('Martin','Gruebele',4.7),('Martin','Manalansan',4.5),('Martin','Starzewski',1.5),('Martin','Wu',2.0),('Martinez-Quiroga','nan',5.0),('Mary','Carlton',4.3),('Mary','Cottingham',4.0),('Mary','Eamon',3.0),('Mary','Edwards',4.8),('Mary','Hays',3.5),('Mary','Kraft',3.0),('Mary','Paquette-Abt',4.5),('Mary','Ramey',4.3),('Masab','Garada',5.0),('Maseeh','Moradi',5.0),('Masooda','Bashir',1.0),('Mathrumandiram','Sivada...',5.0),('Mats','Selen',4.5),('Matthew','Ando',4.0),('Matthew','Brenner',5.0),('Matthew','Brown',4.7),('Matthew','DeSieno',1.0),('Matthew','Dye',3.8),('Matthew','Gilbert',3.3),('Matthew','Kamps',5.0),('Matthew','Marcinkowski',3.1),('Matthew','Minicucci',5.0),('Matthew','Niermann',4.3),('Matthew','Nohren',5.0),('Matthew','OBrien',3.0),('Matthew','Pontifex',3.5),('Matthew','Rispoli',3.5),('Matthew','Rukgaber',4.7),('Matthew','Sabin',4.0),('Matthew','Sherburne',3.3),('Matthew','West',3.5),('Matthew','Wheeler',3.0),('Matthew','Winters',2.0),('Matthew C','Caesar',4.6),('Mattias','Polborn',3.0),('Matus J','Telgarsky',4.5),('Maurice','Meilleur',1.0),('Max','Somers',4.0),('May','Berenbaum',5.0),('Mayukh','Khan',3.0),('Mee','Im',4.0),('Megan','Bolander',5.0),('Megan','Condis',3.0),('Megan','Haselschwerdt',5.0),('Megan','Kosovski',5.0),('Meghan','OMeara',1.5),('Mehdi','Shadmehr',3.0),('Melanie','Tannenbaum',5.0),('Melanie','Waters',2.9),('Melissa','Bowles',4.6),('Melissa','Larabee',5.0),('Melissa','Orlie',3.4),('Melissa','Reedy',3.7),('Melissa','Weber',4.0),('Mendiola-Sanchez','nan',5.0),('Meng','Li',3.0),('Merton','Lee',3.0),('Micah','Riecker',5.0),('Michael','Andrejasich',1.0),('Michael','Bilton',4.0),('Michael','Burns',5.0),('Michael','Dyer',2.7),('Michael','Evans',4.0),('Michael','Frazier',2.0),('Michael','Giardina',4.5),('Michael','Gioia',5.0),('Michael','Haney',5.0),('Michael','Hirschi',4.0),('Michael','Koerner',4.6),('Michael','Kral',5.0),('Michael','Krassa',3.0),('Michael','Leblanc',3.0),('Michael','Lim',1.0),('Michael','Loui',3.5),('Michael','Madonick',5.0),('Michael','Miles',3.0),('Michael','Miller',4.7),('Michael','Myers',2.5),('Michael','Odom',4.3),('Michael','Oelze',4.0),('Michael','Philpott',4.2),('Michael','Preis',2.6),('Michael','Raycraft',4.7),('Michael','Sacco',5.0),('Michael','Sandretto',5.0),('Michael','Schlesinger',2.6),('Michael','Scoville',2.0),('Michael','Stewart',4.4),('Michael','Stone',2.5),('Michael','Ward',4.0),('Michael','Williams',2.0),('Michael','Woodley',5.0),('Michael A','Forbes',2.1),('Michel','Bellini',4.4),('Michele','Koven',5.0),('Michelle','Nelson',5.0),('Michelle','Perry',5.0),('Michelle','Wander',4.7),('Miho','Young',5.0),('Mike','Amezcua',3.0),('Mikhail','Lyubansky',4.0),('Milan','Bagchi',4.0),('Milan','Svolik',4.5),('Miles','Efron',4.0),('Milton','Feng',3.7),('Mimi','Nguyen',3.5),('Min-Feng','Yu',4.3),('Mindy','Mallory',3.0),('Ming','Tan',5.0),('Minh','Do',5.0),('Minh-Quang','Sakya',5.0),('Minkyung','Koo',4.2),('Minseok','Jang',1.0),('Mirona','Chirienco',5.0),('Mithilesh','Mishra',5.0),('Mohamed','Aboukhatwa',4.0),('Mohamed','Boubekri',3.3),('Mohammad','Babadoost',4.0),('Mohammad','Khalil',5.0),('Mohammed','El-Kebir',4.8),('Monica','Majumdar',2.0),('Monica','McDermott',4.0),('Monicka','Wielgos',5.0),('Moon-Kie','Jung',4.0),('Moonsub','Shim',4.0),('Mor','Gueye',5.0),('Morten','Lundsgaard',1.0),('Mouschovias','nan',3.0),('Muhammad','Al-Faruque',5.0),('Murugesu','Sivapalan',2.2),('N.','Namachchivaya',4.1),('Naira','Hovakimyan',1.0),('Nan','Jiang',3.5),('Nancy','Benson',2.5),('Nancy','Blake',4.7),('Nancy','Hertzog',1.0),('Nancy','Joseph',2.0),('Nancy','Sottos',5.0),('Naomi','Makins',4.8),('Naomi','Rothman',5.0),('Napieralski','nan',5.0),('Narayana','Aluru',3.0),('Narendra','Ahuja',3.0),('Narjes','Tavoosi',5.0),('Natalie','Havlin',3.0),('Natalya','Khokholova',5.0),('Natasha','Shrikant',4.0),('Nathan','Dunfield',4.4),('Nathan','Raybeck',3.0),('Nathaniel','Chio',4.0),('Nathaniel','Hirtz',4.0),('Navin','Fogla',5.0),('Neal','Cohen',5.0),('Neal E','Davis',4.1),('Negar','Kiyavash',4.5),('Neil','Kelleher',2.0),('Nicholas','DeSanto',5.0),('Nicholas','Kirchner',2.5),('Nicholas','Lenczycki',3.0),('Nicholas','Llewellyn',3.6),('Nicholas','Paulson',4.8),('Nicholas','Petruzzi',5.0),('Nicholas','Watanabe',4.5),('Nick','Glumac',3.7),('Nicki','Engeseth',5.0),('Nicole','Allen',1.0),('Nikita','Borisov',1.6),('Nikolaos','Vergis',5.0),('Nina','Tarr',5.0),('Nitin','Vaidya',3.0),('Noah','Bindman',3.0),('Noah','Isserman',5.0),('Noel','Chang',4.5),('Noel','Zavala',4.0),('Noha','Elsakka',4.3),('Nora','Csima',2.6),('Norah','Dick',5.0),('Noreen','Sugrue',4.0),('Norman','Whitten',4.0),('Numa','Markee',1.0),('Oleksandra','Wallo',2.0),('Oleksii','Aksimentiev',1.0),('Olgica','Milenkovic',4.0),('Oluwasanmi O','Koyejo',3.7),('Orrin','Sherwood',5.0),('Oscar','Lopez-Pamies',2.1),('Ott-Monsivais','nan',4.0),('Ottlik','nan',3.0),('Ozge','Sensoy',5.0),('Ozlem','Arikan',2.0),('P.','Kumar',5.0),('Pablo','Reyes',5.0),('Pamela','Glosson',5.0),('Pamela','Hadley',4.3),('Pamela','Shuler',5.0),('Panki','Kim',1.8),('Paolo','Gardoni',1.5),('Paramita','Mondal',2.0),('Paris','Smaragdis',5.0),('Parthasarathy','nan',5.0),('Parthiban','Muniandy',5.0),('Patricia','Gill',3.8),('Patricia','Knowles',5.0),('Patricia','Loughran',3.0),('Patricia','Morey',2.0),('Patricia','Shapley',1.8),('Patricia','Stoller',3.7),('Patricia','Watts',4.0),('Patrick','Brown',3.0),('Patrick','Keenan',5.0),('Patrick','Maher',2.0),('Patrick','McGrath',5.0),('Patrick','McSorley',5.0),('Patrick','Sullivan',5.0),('Patryk','Szuta',4.0),('Paul','Braun',4.0),('Paul','Diehl',4.0),('Paul','Duncum',5.0),('Paul','Gold',5.0),('Paul','Hergenrother',3.3),('Paul','Johnson',5.0),('Paul','Kenis',3.8),('Paul','Kornbluh',5.0),('Paul','Kwiat',3.9),('Paul','Magelli',5.0),('Paul','Peterson',3.0),('Paul','Pollack',5.0),('Paul','Reed',5.0),('Paul','Ricker',3.7),('Paul','Stoddard',4.9),('Paula','Poh',4.0),('Perzavia','Praylow',3.0),('Peter','Beak',3.3),('Peter','Davis',5.0),('Peter','Fritzsche',4.0),('Peter','Garrett',5.0),('Peter','Goldsmith',3.8),('Peter','Griffin',5.0),('Peter','Lasersohn',5.0),('Peter','Loeb',1.5),('Peter','Maggs',5.0),('Peter','Orlean',3.0),('Peter','Sheldon',5.0),('Peter','Silhan',2.1),('Peter','Wellington',5.0),('Petros','Voulgaris',2.0),('Philip','Hillmer',4.4),('Philip','Miller',5.0),('Philip','Rodkin',4.5),('Philipp','Hieronymi',4.0),('Philippe','Geubelle',3.0),('Phillip','OConnor',5.0),('Pierre','Albin',2.0),('Piper','Hodson',5.0),('Polanco','Encarnacion',3.0),('Polly','Middleton',5.0),('Poshek','Fu',3.5),('Pramod','Viswanath',5.0),('Prasanta','Kalita',5.0),('Prashant','Mehta',3.5),('Pratik','Randeria',5.0),('Praveen','Kumar',3.6),('Pritesh','Pandya',2.5),('Priyam','Tripathy',4.4),('Qing','Wang',1.5),('R.','Baber',3.0),('R.','Pandharipande',3.0),('Rachel','Harris',3.0),('Rachel','Kimnach',5.0),('Rachel','Mitchell',2.7),('Rachel','Rizzo',3.0),('Rachel','Schwartz',5.0),('Rachel','Shafer',4.5),('Rachel','Whitaker',2.0),('Radhakrishnan','nan',5.0),('Raffi','Budakian',3.5),('Rajagopal','Echambadi',5.0),('Rajendra','Jain',3.0),('Rakesh','Bhatt',4.0),('Rakesh','Kumar',2.2),('Ralph','Husby',5.0),('Ralph','Johnson',5.0),('Ralph','Mathisen',1.5),('Ramanath','Subramanyam',4.0),('Randall','Dills',3.0),('Randy','McCarthy',2.8),('Raquel','Goebel',5.0),('Rashid','Bashir',5.0),('Raul','Mora',4.0),('Raul','Santos',3.5),('Ray','Ming',3.0),('Ray','Muhammad',4.3),('Raymond','Zielinski',3.0),('Rayvon','Fouche',4.3),('Rebecca','Deltoro',4.2),('Rebecca','Foote',4.5),('Rebecca','Roach',3.1),('Rebecca','Sandefur',3.5),('Rebecca','Stumpf',5.0),('Rebecca','Weber',4.0),('Rebekah','Arana',5.0),('Rebekah','Gilbert',2.6),('Reginald','Alston',5.0),('Renata','Fuchs',5.0),('Renee','Baillargeon',3.7),('Reshmi','Mukherjee',3.0),('Reynolds-Tylus','nan',4.0),('Rhanor','Gillette',5.0),('Rhiannon','Clifton',4.0),('Richard','Akresh',2.0),('Richard','Anderson',5.0),('Richard','Arnould',5.0),('Richard','Brazee',3.5),('Richard','Esbenshade',2.0),('Richard','Gates',3.3),('Richard','Keane',2.7),('Richard','Laugesen',4.6),('Richard','Layton',4.1),('Richard','Mintel',3.4),('Richard','Mohr',5.0),('Richard','Mulvaney',3.2),('Richard','Sowers',4.0),('Richard','Weinzierl',4.2),('Richelle','Bernazzoli',3.0),('Rinat','Kedem',2.8),('Rini','Mehta',4.0),('Ripan','Malhi',5.0),('Robert','Aherin',4.0),('Robert','Averback',2.2),('Robert','Bauer',2.7),('Robert','Boyer',5.0),('Robert','Brunner',3.0),('Robert','Darmody',4.4),('Robert','DeVille',5.0),('Robert','Dodds',4.5),('Robert','Dole',4.3),('Robert','Gennis',3.4),('Robert','Haber',3.0),('Robert','Hornbaker',4.0),('Robert','Hughes',4.0),('Robert','Jenkins',5.0),('Robert','McChesney',2.2),('Robert','McGrew',4.0),('Robert','McKim',3.3),('Robert','Motl',5.0),('Robert','Muncaster',2.3),('Robert','Murphy',4.1),('Robert','Pahre',3.0),('Robert','Rauber',4.2),('Robert','Rushing',4.6),('Robert','Siebrecht',5.0),('Robert','Skirvin',4.7),('Robert','Tierney',4.0),('Robert','Wengert',4.8),('Robert','Wickesberg',5.0),('Roberto','Galvez',5.0),('Robin','Douglas',4.0),('Robin','Estabrook',4.0),('Robin','Kravets',1.8),('Rohini','Singh',4.5),('Rolando','Romero',2.0),('Roma','Rofes',4.0),('Roman','Boulatov',1.5),('Ron','Laschever',2.0),('Ronald','Kovatch',4.0),('Ronald','Toby',2.2),('Ross','Putman',5.0),('Roy','Axford',5.0),('Roya','Khatiblou',5.0),('Ruby','Mendenhall',2.0),('Rui','Zhao',2.5),('Ruopeng','An',5.0),('Russell','Giannetta',1.0),('Russell','Korte',1.0),('Ruth','Brown',2.0),('Ryan','Bailey',4.0),('Ryan','Bean',2.0),('Ryan','Galis',5.0),('Ryan','Gower',4.6),('Ryan','Greene',4.5),('Ryan','Jones',3.0),('Ryan','Loh',5.0),('Ryan','Tomasiewicz',4.0),('S.','Cooper',5.0),('Sadra','Amiri',5.0),('Salim','Rashid',4.0),('Salome','Tvalodze',5.0),('Salvador','Victor',4.2),('Samantha','Barrick',4.0),('Samantha','Hack-Ritzo',5.0),('Samuel','Gleason',4.0),('Samuel','Kamin',2.0),('Samuel','Pera',4.0),('Sandra','Camargo',1.0),('Sandra','Kopels',5.0),('Sandra','Lee',5.0),('Sandra','Lucas',5.0),('Sandra','Rodriguez-Zas',4.0),('Sang','Oh',1.0),('Sangsook','Lee-Chung',5.0),('Sanja','Koric',5.0),('Sanjay','Patel',4.4),('Sankar','Dutta',2.5),('Santanu','Chakraborty',2.0),('Sara','Bordowitz',2.0),('Sara','Luttfring',5.0),('Sara','McLafferty',4.5),('Sara','McWhorter',2.0),('Sara','Shrader',2.0),('Sarah','Albert',4.0),('Sarah','Brown-Schmidt',4.0),('Sarah','Haas',5.0),('Sarah','Hennebohl',4.0),('Sarah','Projansky',4.5),('Sarah','Rasmusson',2.5),('Sarah','Sullivan',4.8),('Sarita','Adve',4.5),('Sasha','Cuerda',4.0),('Saurabh','Sinha',1.0),('Sayan','Mitra',4.1),('Scott','Ahlgren',3.6),('Scott','Althaus',3.0),('Scott','Carney',4.0),('Scott','Irwin',4.0),('Scott','Morris',4.7),('Scott','Olson',3.3),('Scott','Perkins',4.5),('Scott','Scharfenberg',5.0),('Scott','Tichenor',2.8),('Scott','Walter',4.0),('Scott','White',3.0),('Scott','Willenbrock',4.7),('Scott','Wyatt',5.0),('Sean','Curtin',4.0),('Sean','Karns',4.0),('Sean','Meyn',1.0),('Sean','Mullen',4.0),('Seda','Durguner',5.0),('Sena','Durguner',3.0),('Seonhee','Jeong',4.0),('Serge','Minin',3.8),('Sergei','Ivanov',3.0),('Sergio','Yona',5.0),('Sergiy','Merenkov',3.0),('Serife','Genis',3.0),('Sha','Chen',5.0),('Shalaurey','Jones',5.0),('Shannan','Stewart',4.4),('Sharon','Donovan',3.0),('Sharon','Morrisette',4.0),('Shawn','Ballard',1.0),('Shawn','Gilmore',2.0),('Shawna','Naidu',5.0),('Sheila','Dean',3.0),('Sheldon','Jacobson',4.5),('Shelley','Smithson',2.0),('Shelley','Weinberg',3.0),('Shelly','Schmidt',4.0),('Shen','Dillon',2.7),('Sherrie','Hildreth',4.0),('Shichang','Song',3.5),('Shirley','Faughn',3.5),('Shobha','Vasudevan',1.8),('Shywon','Berry',1.0),('Silvia','Kunitz',2.0),('Simona','Buetti',2.0),('Sizhu','You',4.0),('Somnath','Roy',1.0),('Song','Cho',5.0),('Sonya','Irving',5.0),('Soo','Kwon',3.7),('Soo-Yeun','Lee',4.0),('Soondo','Baek',5.0),('Sorin','Bangu',3.6),('Spencer','Snow',3.0),('Srinivasa','Salapaka',4.5),('Stacey','Korson',1.0),('Stanley','Ambrose',4.3),('Stefan','Freise',5.0),('Stefan','Krasa',5.0),('Stefan','Mueller',3.0),('Stephanie','Clark',2.0),('Stephanie','Foote',4.4),('Stephanie','Wall',4.0),('Stephen','Altaner',4.2),('Stephen','Cartwright',5.0),('Stephen','Davenport',5.0),('Stephen','Downie',5.0),('Stephen','Downing',4.0),('Stephen','Farrand',2.7),('Stephen','Levinson',3.0),('Stephen','Notaro',4.6),('Stephen','Peters',4.3),('Stephen','Platt',4.0),('Stephen','Runkle',4.5),('Steve','Granick',2.0),('Steve','Kostell',4.3),('Steven','Anderson',3.0),('Steven','Ashby',3.5),('Steven','Bradlow',3.2),('Steven','Culpepper',2.0),('Steven','Hall',4.5),('Steven','Hill',3.5),('Steven','Lauterburg',2.6),('Steven','Luke',5.0),('Steven','Lumetta',4.8),('Steven','Michael',5.0),('Steven','Petruzzello',4.5),('Steven','Smith',5.0),('Steven','Wagner',3.0),('Steven','Wilson',1.3),('Steven','Zimmerman',4.4),('Steven','Zusman',5.0),('Stewart','Berlocher',2.5),('Stewart','Hicks',2.5),('Stuart','Shapiro',5.0),('Suhail','Barot',5.0),('Sujith','Vijay',3.0),('Summer','Carnett',5.0),('Sundiata','Cha-Jua',2.5),('Sung','Shin',1.0),('Surangi','Punyasena',3.2),('Surya','Vanka',4.0),('Susan','Ahmed',3.0),('Susan','Curtis',2.7),('Susan','Farner',4.4),('Susan','Koshy',3.0),('Susan','Larson',3.0),('Susan','Martinis',5.0),('Susan','Thomas',5.0),('Susan','Weiss',3.0),('Suzanne','Lee',3.0),('Sydney','Slobodnik',3.2),('Sylvia','Enyart',3.0),('Sylvia','Ogilvie',3.0),('Sylvia','Puente',4.5),('Synthia','Sydnor',3.7),('Tabe','Bergman',3.0),('Taekjip','Ha',3.5),('Taghaboni-Dutta','nan',5.0),('Takeharu','Sogo',3.7),('Tami','Bond',3.0),('Tamilia','Reed',4.0),('Tammie','Rubin',3.0),('Tangul','Basar',3.8),('Tania','Coambs',5.0),('Tania','Ionin',4.5),('Tania','Lown-Hecht',5.0),('Tanya','Kozlowski',5.0),('Tao','Mei',4.5),('Tara','Larrison',3.5),('Tarek','Abdelzaher',3.6),('Teran-Garcia','nan',5.0),('Teresa','Finis',4.7),('Terri','Cummings',5.0),('Terri','Weissman',2.2),('Terry','Von',5.0),('Thanh','Nguyen',4.0),('Thomas','Bassett',3.4),('Thomas','Carty',2.6),('Thomas','Costello',4.5),('Thomas','Finnegan',4.0),('Thomas','Gambill',3.6),('Thomas','Hummel',3.7),('Thomas','Jacobs',3.0),('Thomas','Mahle',1.0),('Thomas','Mitchell',5.0),('Thomas','Nevins',3.7),('Thomas','OGorman',4.0),('Thomas','Overbye',5.0),('Thomas','Rudolph',4.0),('Thomas','Srull',3.7),('Thomas','Turino',3.3),('Thomas','Vance',4.0),('Tianyin','Xu',3.7),('Timothy','Bowers',4.0),('Timothy','Ellsworth',4.7),('Timothy','Green',4.0),('Timothy','Johnson',5.0),('Timothy','Laar',4.0),('Timothy','Marty',3.7),('Timothy','McCarthy',4.0),('Timothy','Pauketat',4.0),('Timothy','Peck',5.0),('Timothy','Stark',5.0),('Timothy','Stelzer',4.7),('Timothy','Trick',3.4),('Timur','Oikhberg',1.5),('Tina','Huang',3.2),('Ting','Lu',2.3),('Todd','Allee',3.3),('Todd','Cole',4.2),('Todd','Coleman',3.0),('Todd','Doehring',5.0),('Tolga','Tezcan',3.0),('Tom','Boynton',4.0),('Tongfei','Wang',5.0),('Tony','Grift',3.0),('Tony','Liss',4.0),('Tony','Wong',3.0),('Tracey','Hickox',4.0),('Tracy','Sulkin',3.9),('Trina','Wright',3.0),('Troy','Cooper',4.5),('Tyler','Fagan',5.0),('Tyran','Russell',2.7),('Udatta','Palekar',4.0),('Urvi','Neelakantan',5.0),('Vadim','Zharnitsky',2.2),('Vaibhav','Gadre',1.0),('Valeria','Sobol',3.0),('Valerie','OBrien',5.0),('Valerie','Rogalla',2.0),('Verity','Winship',3.2),('Vernon','Jones',4.0),('Veronika','Sanogo',2.0),('Vidisha','Vachharajani',3.0),('Vikram S','Adve',4.3),('Vinayak','Shanbhag',4.0),('Vincent','Ip',5.0),('Viraj','Kumar',4.9),('Virginia','France',2.0),('Vishal','Sachdev',3.0),('Vyacheslav','Fos',3.0),('Vyron','Vellis',3.0),('Wade','Fagen',2.5),('Wail','Hassan',4.0),('Walter','Harrington',3.0),('Wanju','Huang',5.0),('Wei','Li',3.5),('Wei','Zhu',4.0),('Weidenbenner','nan',3.7),('Weimo','Zhu',5.0),('Weixin','Tang',2.0),('Wen-Hao','Huang',5.0),('Wen-Tso','Liu',1.5),('Wendy','Truran',4.0),('Wenxuan','Zhong',1.5),('Werner','Baer',3.7),('Wesley','Cho',2.0),('Wilfred','Donk',4.0),('William','Bernhard',4.5),('William','Berry',4.0),('William','Bullock',3.0),('William','Buttlar',5.0),('William','Griswold',5.0),('William','Hammack',4.5),('William','Hechler',3.7),('William','Hope',5.0),('William','King',2.0),('William','Kinnersley',5.0),('William','Morgan',4.0),('William','Noble',3.0),('William','Sullivan',5.0),('Witat','Fakcharoenphol',2.5),('Woo','Cho',5.0),('Xavier','Stacey',5.0),('Xiaohui','Chen',4.4),('Xiaoling','Chen',4.0),('Xiaoting','Li',4.0),('Xin','Chen',3.0),('Xinlei','Wang',4.0),('Xinxin','Feng',3.0),('Xinyuan','Dai',5.0),('Xuming','He',5.0),('Yael','Massen',3.0),('Yanfeng','Ouyang',5.0),('Yang','Liu',1.0),('Yang','Wang',4.0),('Yann','Chemla',4.3),('Yannick','Lionel',3.0),('Yevgeniya','Funk',3.5),('Yewon','Gim',4.0),('Yi','Lu',3.5),('Yi-Shuan','Chen',5.0),('Yih-Chun','Hu',3.2),('Ying','Li',4.7),('Yinghong','Pan',4.0),('Yinxiao','Huang',2.8),('Yiqun','Wang',3.0),('Yoon','Pak',3.0),('Yoram','Bresler',4.5),('Youfu','Zhao',4.0),('Youngsoo','Kim',2.7),('Youssef','Hashash',3.1),('Yuan','Fu',2.0),('Yue','Li',3.5),('Yueh-Mei','Lin',4.0),('Yuguo','Chen',3.0),('Yuju','Tu',4.5),('Yung-Jui','Yang',4.0),('Yunjin','Kim',5.0),('Yvonne','Carey',5.0),('Zachary','Carrettin',5.0),('Zack','Browning',3.5),('Zackary','Ross',3.0),('Zaruhi','Sahakyan',2.5),('Zhuowei','Huang',5.0),('Zijing','He',4.0),('Zsuzsa','Gille',5.0);
/*!40000 ALTER TABLE `professor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `section`
--

DROP TABLE IF EXISTS `section`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `section` (
  `subject` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `number` int DEFAULT NULL,
  `CRN` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `sched_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `Ap` int DEFAULT NULL,
  `A` int DEFAULT NULL,
  `Am` int DEFAULT NULL,
  `Bp` int DEFAULT NULL,
  `B` int DEFAULT NULL,
  `Bm` int DEFAULT NULL,
  `Cp` int DEFAULT NULL,
  `C` int DEFAULT NULL,
  `Cm` int DEFAULT NULL,
  `Dp` int DEFAULT NULL,
  `D` int DEFAULT NULL,
  `Dm` int DEFAULT NULL,
  `F` int DEFAULT NULL,
  `W` int DEFAULT NULL,
  `avg_gpa` decimal(3,2) DEFAULT NULL,
  `professor_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`CRN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `section`
--

LOCK TABLES `section` WRITE;
/*!40000 ALTER TABLE `section` DISABLE KEYS */;
INSERT INTO `section` VALUES ('CS',100,30094,'Freshman Orientation','LEC',0,214,22,1,37,4,29,12,10,4,2,2,4,0,3.46,'Gunter, Elsa'),('CS',411,30109,'Database Systems','LCD',43,88,24,20,8,8,1,1,0,1,0,0,0,0,3.77,'Alawini, Abdussalam A'),('CS',421,30128,'Progrmg Languages & Compilers','LCD',87,47,23,13,8,6,9,8,3,0,3,3,7,1,3.47,'Gunter, Elsa'),('CS',196,31508,'Freshman Honors','LCD',22,74,12,3,6,0,0,0,0,0,0,0,0,1,3.90,'Challen, Geoffrey W'),('CS',199,31514,'Python for Data','LCD',5,23,2,3,1,0,0,0,0,0,0,0,1,0,3.78,'Silva, Mariana T'),('CS',210,31516,'Ethical & Professional Issues','LCD',0,61,48,16,11,4,1,0,0,1,1,0,1,0,3.62,'Asplund, Joshua T'),('CS',296,31518,'Honors Course','LCD',3,52,1,1,3,0,3,6,0,0,0,0,1,1,3.64,'Evans, Graham C'),('CS',105,35823,'Intro Computing: Non-Tech','LEC',86,134,87,67,72,32,26,37,14,12,10,10,14,4,3.19,'Harris, Albert F'),('CS',125,35876,'Intro to Computer Science','LEC',150,357,45,26,18,15,7,11,6,0,13,0,23,3,3.63,'Challen, Geoffrey W'),('CS',101,35879,'Intro Computing: Engrg & Sci','LEC',282,135,62,47,28,16,7,6,3,4,3,5,12,0,3.65,'Davis, Neal E'),('CS',225,35919,'Data Structures','LEC',9,236,29,18,18,7,12,10,7,4,6,5,12,0,3.47,'Evans, Graham C'),('CS',598,36011,'Mach Lrng for Signal Processng','LCD',14,33,20,5,3,0,0,1,0,0,0,0,0,1,3.80,'Smaragdis, Paris'),('CS',450,36016,'Numerical Analysis','LCD',0,25,17,14,18,9,14,8,5,3,4,4,1,2,2.92,'Olson, Luke'),('CS',438,36061,'Communication Networks','LCD',7,26,22,18,11,15,2,1,0,0,0,0,0,0,3.47,'Al-Hassanieh, Haitham'),('CS',433,36069,'Computer System Organization','LCD',3,5,11,9,4,2,1,0,0,0,0,0,0,0,3.49,'Adve, Sarita V'),('CS',425,36091,'Distributed Systems','LCD',9,25,75,49,27,7,0,4,0,0,0,0,0,0,3.49,'Gupta, Indranil'),('CS',427,36104,'Software Engineering I','LCD',7,9,15,17,24,4,4,3,2,0,0,0,1,0,3.23,'Rosu, Grigore'),('CS',418,36119,'Interactive Computer Graphics','LEC',27,25,9,12,17,10,6,5,2,1,7,0,0,0,3.26,'Shaffer, Eric G'),('CS',173,40083,'Discrete Structures','LEC',70,77,47,38,38,40,14,14,17,3,8,1,1,1,3.29,'Viswanathan, Mahesh'),('CS',498,40091,'Virtual Reality','LCD',3,47,31,22,23,16,4,3,0,1,0,0,1,0,3.41,'Shaffer, Eric G'),('CS',523,41596,'Advanced Operating Systems','LCD',3,8,16,8,1,0,0,0,0,0,0,0,0,0,3.68,'Xu, Tianyin'),('CS',426,43355,'Compiler Construction','LCD',1,10,8,6,2,2,0,1,0,0,0,0,0,1,3.58,'Adve, Vikram S'),('CS',412,43357,'Introduction to Data Mining','LCD',13,50,19,32,28,3,12,3,0,0,2,3,2,0,3.35,'Han, Jiawei'),('CS',465,43389,'User Interface Design','LCD',2,25,25,23,35,5,2,0,0,0,1,0,2,0,3.34,'Bailey, Brian P'),('CS',498,43753,'Cyber Dystopia','LEC',10,14,2,2,0,2,0,0,0,0,0,0,0,0,3.84,'Gunter, Carl'),('CS',241,45300,'System Programming','LEC',8,12,11,3,6,1,8,10,5,3,6,6,2,1,2.62,'Angrave, Lawrence C'),('CS',242,45325,'Programming Studio','LEC',16,19,13,8,8,4,2,1,0,1,2,1,2,0,3.37,'Woodley, Michael J'),('CS',446,46792,'Machine Learning','LEC',20,28,34,11,8,4,4,3,0,0,0,1,7,2,3.40,'Koyejo, Oluwasanmi O'),('CS',425,48734,'Distributed Systems','LCD',3,0,10,5,7,0,0,1,0,0,0,0,0,0,3.42,'Gupta, Indranil'),('CS',461,49547,'Computer Security I','LEC',5,9,28,8,18,30,0,18,11,0,11,0,8,0,2.64,'Bates, Adam M'),('CS',466,51764,'Introduction to Bioinformatics','LCD',2,17,9,6,3,4,0,3,0,0,1,0,0,0,3.49,'El-Kebir, Mohammed'),('CS',424,51775,'Real-Time Systems','LCD',11,10,4,8,0,2,0,0,0,0,0,0,0,0,3.74,'Abdelzaher, Tarek'),('CS',420,53685,'Parallel Progrmg: Sci & Engrg','LCD',4,10,0,7,9,0,0,1,0,0,0,0,0,0,3.51,'Padua, David A'),('CS',554,57701,'Parallel Numerical Algorithms','LCD',7,10,3,3,0,0,1,0,0,0,0,0,0,0,3.81,'Solomonik, Edgar V'),('CS',447,63292,'Natural Language Processing','LEC',17,37,13,6,7,0,0,1,1,0,0,0,1,0,3.72,'Hockenmaier, Julia C'),('CS',357,63536,'Numerical Methods I','LCD',5,93,21,21,10,9,4,8,5,2,2,0,4,0,3.43,'Silva, Mariana T'),('CS',233,64513,'Computer Architecture','LEC',14,103,5,8,31,4,4,10,0,0,4,0,5,0,3.46,'Herman, Geoffrey L'),('CS',445,65086,'Computational Photography','LCD',18,56,12,8,9,4,4,1,0,1,5,2,2,0,3.48,'Hoiem, Derek W'),('CS',361,66298,'Prob & Stat for Computer Sci','LEC',19,29,15,19,29,7,7,6,2,3,3,1,7,0,3.10,'Liu, Hongye'),('CS',126,66322,'Software Design Studio','LCD',9,56,37,15,9,4,3,3,1,3,0,2,3,2,3.47,'Woodley, Michael J'),('CS',498,66333,'Computational Advertising','LCD',6,30,14,7,7,5,0,0,0,0,0,0,0,0,3.67,'Sundaram, Hari'),('CS',374,66445,'Intro to Algs & Models of Comp','LEC',14,22,31,30,40,29,33,37,20,22,16,16,11,3,2.48,'Erickson, Jeff G'),('CS',440,67003,'Artificial Intelligence','LCD',52,64,43,18,37,18,15,15,8,1,4,5,10,1,3.22,'Fleck, Margaret M'),('CS',410,67393,'Text Information Systems','ONL',242,34,15,16,5,0,0,1,0,0,1,0,0,0,3.92,'Zhai, Chengxiang'),('CS',510,67827,'Advanced Information Retrieval','LEC',7,52,20,1,1,0,0,0,0,0,0,0,0,1,3.90,'Zhai, Chengxiang'),('CS',498,68911,'Applied Cryptography','LEC',8,5,4,1,1,1,1,1,0,0,1,0,1,1,3.40,'Miller, Andrew E'),('CS',473,70159,'Algorithms','LCD',7,13,13,9,14,5,7,5,5,2,1,1,0,1,3.07,'Forbes, Michael A'),('CS',598,70203,'Adversarial Machine Learning','LCD',0,19,5,1,0,0,0,0,0,0,0,0,0,0,3.91,'Li, Bo'),('CS',374,70641,'Intro to Algs & Models of Comp','LEC',9,6,8,13,22,15,16,19,5,5,6,5,3,0,2.56,'Borisov, Nikita'),('CS',498,71965,'Reinforcement Learning','LCD',5,24,8,5,2,2,0,0,1,0,1,0,0,0,3.69,'Jiang, Nan'),('CS',598,72098,'Deep Learning Theory','LCD',2,13,9,0,3,0,0,0,0,0,0,0,0,0,3.78,'Telgarsky, Matus J'),('CS',598,72122,'Consensus Algorithms','LCD',9,6,4,8,0,0,0,0,0,0,0,0,0,0,3.75,'Ren, Ling'),('CS',498,72154,'Internet of Things','LCD',13,36,11,1,1,0,0,0,0,0,0,0,0,0,3.92,'Caesar, Matthew C');
/*!40000 ALTER TABLE `section` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `netid` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `standing` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `department` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`netid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES ('dy6','Danielle','Junior','CS');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Final view structure for view `course_rtgs`
--

/*!50001 DROP VIEW IF EXISTS `course_rtgs`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = cp850 */;
/*!50001 SET character_set_results     = cp850 */;
/*!50001 SET collation_connection      = cp850_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `course_rtgs` AS select `c`.`subject` AS `subject`,`c`.`number` AS `number`,`c`.`name` AS `name`,`s`.`avg_gpa` AS `avg_gpa`,`p`.`lastname` AS `lastname`,`p`.`avg_rating` AS `avg_rating` from ((`course` `c` join `section` `s` on(((`c`.`subject` = `s`.`subject`) and (`c`.`number` = `s`.`number`)))) join `professor` `p`) where (`s`.`professor_name` like concat(`p`.`lastname`,', ',`p`.`firstname`,'%')) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-08-04 12:31:40