Science Olympiad 2019 Results

Results from the 2018-19 Science Olympiad season

@kaggle.smayya337_science_olympiad_2019_results

Table List

5 tables(139.16 KB)

N 2019 Mit Divc Results

N 2019 Nats Divb Results

N 2019 Nats Divc Results

N 2019 Va Divb Results

N 2019 Va Divc Results

N 2019 Nats Divc Results

@kaggle.smayya337_science_olympiad_2019_results.n_2019_nats_divc_results

29.42 KB
61 rows
29 columns

team Team	overall Overall	total Total	anatomy_and_physiology Anatomy And Physiology	astronomy Astronomy	boomilever Boomilever	chemistry_lab Chemistry Lab	circuit_lab Circuit Lab	codebusters Codebusters	designer_genes Designer Genes	disease_detectives Disease Detectives	dynamic_planet Dynamic Planet	experimental_design Experimental Design	fermi_questions Fermi Questions	forensics Forensics	fossils Fossils	geologic_mapping Geologic Mapping	herpetology Herpetology	mission_possible Mission Possible	mousetrap_vehicle Mousetrap Vehicle	protein_modeling Protein Modeling	sounds_of_music Sounds Of Music	thermodynamics Thermodynamics	water_quality Water Quality	wright_stuff Wright Stuff	write_it_do_it Write It Do It	detector_building Detector Building	environmental_chemistry Environmental Chemistry
Troy H.S. CA	1	231	3	8	12	9	6	11	2	1	8	3	3	7	3	6	18	8	2	32	10	9	3	37	30	8	62
Solon H.S. OH	2	276	9	28	10	17	14	18	35	15	7	7	11	10	1	1	5	3	1	25	1	7	28	10	13	30	35
Harriton H.S. PA	3	277	4	11	22	5	3	10	14	4	11	4	22	6	15	4	8	15	8	5	18	13	9	11	55	62	26
Mason H.S. OH	4	294	2	9	11	11	4	4	8	9	31	6	12	21	16	28	14	4	27	17	8	4	6	16	26	6	12
Pioneer H.S. (Ann Arbor) MI	5	309	12	25	3	22	5	6	22	3	20	22	29	1	2	14	4	16	13	15	16	16	34	6	3	22	6
Adlai E. Stevenson H.S. IL	6	320	15	17	1	6	12	22	13	21	4	9	20	11	28	11	31	10	22	6	9	8	21	18	5	14	17
Seven Lakes H.S. TX	7	322	8	19	9	26	11	24	4	17	19	20	7	28	8	8	17	23	30	2	7	20	4	9	2	4	23
New Trier H.S. IL	8	327	28	1	2	15	2	9	3	20	1	12	9	25	5	10	29	24	29	3	13	3	33	41	10	19	25
ABRHS MA	9	330	1	3	18	2	25	21	1	12	5	23	1	3	23	13	22	37	12	19	2	23	12	36	16	23	2
Northville H.S. MI	10	332	13	20	13	7	13	3	40	18	17	18	36	22	9	5	16	29	11	4	6	5	15	3	9	7	62


CREATE TABLE n_2019_nats_divc_results (
  "team" VARCHAR,
  "overall" BIGINT,
  "total" BIGINT,
  "anatomy_and_physiology" BIGINT,
  "astronomy" BIGINT,
  "boomilever" BIGINT,
  "chemistry_lab" BIGINT,
  "circuit_lab" BIGINT,
  "codebusters" BIGINT,
  "designer_genes" BIGINT,
  "disease_detectives" BIGINT,
  "dynamic_planet" BIGINT,
  "experimental_design" BIGINT,
  "fermi_questions" BIGINT,
  "forensics" BIGINT,
  "fossils" BIGINT,
  "geologic_mapping" BIGINT,
  "herpetology" BIGINT,
  "mission_possible" BIGINT,
  "mousetrap_vehicle" BIGINT,
  "protein_modeling" BIGINT,
  "sounds_of_music" BIGINT,
  "thermodynamics" BIGINT,
  "water_quality" BIGINT,
  "wright_stuff" BIGINT,
  "write_it_do_it" BIGINT,
  "detector_building" BIGINT,
  "environmental_chemistry" BIGINT,
  "team_penalties" BIGINT
);