Name: Science Olympiad 2019 Results
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Science Olympiad 2019 Results

Context

I'm a huge Science Olympiad nerd, so Science Olympiad data seemed like the natural choice for my first dataset.

Content

Each file contains the results from a specific tournament (e.g. the 2019 National Tournament) and division (e.g. Division C, which is high school). You can expect to find every team, their overall placing, their total score, their per-event placings, and how many penalties they racked up.

Acknowledgements

I'm thankful to Unosmium for aggregating all this data so that I could easily grab it and convert it into CSVs.

Tables

N 2019 Mit Divc Results

@kaggle.smayya337_science_olympiad_2019_results.n_2019_mit_divc_results

32.59 kB
74 rows
30 columns

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
);

N 2019 Nats Divb Results

@kaggle.smayya337_science_olympiad_2019_results.n_2019_nats_divb_results

30.11 kB
60 rows
29 columns

CREATE TABLE n_2019_nats_divb_results (
  "team" VARCHAR,
  "overall" BIGINT,
  "total" BIGINT,
  "anatomy_and_physiology" BIGINT,
  "battery_buggy" BIGINT,
  "boomilever" BIGINT,
  "circuit_lab" BIGINT,
  "crime_busters" BIGINT,
  "density_lab" BIGINT,
  "disease_detectives" BIGINT,
  "dynamic_planet" BIGINT,
  "elastic_launched_glider" BIGINT,
  "experimental_design" BIGINT,
  "fossils" BIGINT,
  "game_on" BIGINT,
  "heredity" BIGINT,
  "herpetology" BIGINT,
  "meteorology" BIGINT,
  "mystery_architecture" BIGINT,
  "potions_and_poisons" BIGINT,
  "road_scholar" BIGINT,
  "roller_coaster" BIGINT,
  "solar_system" BIGINT,
  "thermodynamics" BIGINT,
  "water_quality" BIGINT,
  "write_it_do_it" BIGINT,
  "parasitology" BIGINT,
  "science_quizbowl" BIGINT,
  "team_penalties" BIGINT
);

N 2019 Nats Divc Results

@kaggle.smayya337_science_olympiad_2019_results.n_2019_nats_divc_results

30.12 kB
61 rows
29 columns

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
);

N 2019 Va Divb Results

@kaggle.smayya337_science_olympiad_2019_results.n_2019_va_divb_results

25.09 kB
26 rows
29 columns

CREATE TABLE n_2019_va_divb_results (
  "team" VARCHAR,
  "overall" BIGINT,
  "total" BIGINT,
  "anatomy_and_physiology" BIGINT,
  "battery_buggy" BIGINT,
  "boomilever" BIGINT,
  "circuit_lab" BIGINT,
  "codebusters" BIGINT,
  "crime_busters" BIGINT,
  "density_lab" BIGINT,
  "disease_detectives" BIGINT,
  "dynamic_planet" BIGINT,
  "elastic_launched_glider" BIGINT,
  "experimental_design" BIGINT,
  "fossils" BIGINT,
  "heredity" BIGINT,
  "herpetology" BIGINT,
  "meteorology" BIGINT,
  "mystery_architecture" BIGINT,
  "potions_and_poisons" BIGINT,
  "road_scholar" BIGINT,
  "roller_coaster" BIGINT,
  "solar_system" BIGINT,
  "thermodynamics" BIGINT,
  "water_quality" BIGINT,
  "write_it_do_it" BIGINT,
  "amazing_mechatronics" BIGINT,
  "picture_this" BIGINT,
  "team_penalties" BIGINT
);

N 2019 Va Divc Results

@kaggle.smayya337_science_olympiad_2019_results.n_2019_va_divc_results

24.59 kB
24 rows
29 columns

CREATE TABLE n_2019_va_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,
  "amazing_mechatronics" BIGINT,
  "science_caching" BIGINT,
  "team_penalties" BIGINT
);