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 Mit Divc Results

@kaggle.smayya337_science_olympiad_2019_results.n_2019_mit_divc_results

31.83 KB
74 rows
30 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	biophysics Biophysics	picture_this Picture This	what_the_function What The Function
ABRHS A	1	223	13	11	8	4	7	10	6	18	14	11	6	5	5	4	24	5	15	3	2	5	7	31	9	9	75	75
Boca Raton Community H.S. A	2	241	7	8	2	12	9	6	18	30	4	16	12	2	9	11	1	1	11	2	3	23	3	35	16	22	7	36
ABRHS B	3	250	2	15	15	7	2	12	4	6	16	22	1	7	34	1	5	2	3	21	1	15	28	30	1	75	75	75
Columbia H.S.	4	256	10	7	20	11	3	13	7	17	21	9	2	6	16	10	3	7	24	1	10	7	15	7	30	28	21	33
Enloe Magnet H.S.	5	270	5	1	27	6	12	8	20	8	23	36	9	4	6	28	7	4	16	19	17	3	4	3	4	75	6	6
LASA H.S.	6	281	20	14	9	2	5	18	8	13	28	2	10	24	1	3	18	20	1	9	33	1	18	13	11	75	75	75
William P. Clements H.S.	7	302	6	18	22	3	1	5	1	19	1	5	8	12	3	5	25	56	18	20	5	2	5	4	58	1	10	4
Ward Melville H.S. A	8	351	8	9	21	27	8	30	17	2	29	4	15	11	4	23	14	6	8	16	6	13	17	19	44	75	24	5
Ed W. Clark H.S. A	9	378	1	10	26	18	23	24	14	10	17	3	7	41	19	18	4	31	19	10	15	24	1	1	42	5	4	75
WW-P H.S. North A	10	388	4	6	18	28	13	27	19	9	5	14	11	8	7	13	12	15	2	32	37	48	12	11	37	3	14	1


CREATE TABLE n_2019_mit_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,
  "biophysics" BIGINT,
  "picture_this" BIGINT,
  "what_the_function" BIGINT,
  "team_penalties" BIGINT
);