Dataset: Meteoritical Bulletin Data 2024/10

About this Dataset

Meteoritical Bulletin Data 2024/10

Description

This dataset provides data scraped from the Meteoritical Bulletin Database available in October 2024.
Raw csv data was further fixed and cleaned. Some additional attributes are added to improve usability.
Raw data has missing csv attributes and therefore is not ready to use. Use the cleaned data instead.

The Data

Row Data

CSV Headers:
Name: The name of the meteorite or impact crater.
Abbrev: The abbreviation used for the meteorite if any.
Status: Official, doubtful, pseudo etc.
Fall: Empty if the meteorite was found, Y, Yc if humans or instrumentation recorded the fall. Np if probable.
Year: The year of the finding or recorded fall, or the age of the impact crater.
Place: The place it was found. Some entries were found on Mars or on the Moon by rovers.
Type: The type of the meteorite.
Mass: The mass in mg, g, kg, or t.
MetBull: The Meteoritical Bulletin publication number where the entry can be found.
Antarctic: If the meteorite was found in Antarctica.
Lat-Long: Coordinates.
Notes: Notes left by curators if any.
Link: The link to the Meteoritical Bulletin information for that entry.

Cleaned Data

CSV Headers:
Name: The name of the entry. Cleaned from asterisks.
Abbrev: The abbreviation used for the meteorite if any.
Status: Official, doubtful, pseudo etc.
Fall: Fell or Found.
Year: The year of the finding or recorded fall, or the age of the impact crater.
Yea-Only: For records that have 2 years, only the first value was kept. Geological age of impact crater not used here.
Place: The place it was found. Some entries were found on Mars or on the Moon by rovers.
Type: The type of the meteorite. Cleaned from symbols.
Mass: The mass in kg.
MetBull: The Meteoritical Bulletin publication number where the entry can be found. Cleaned from symbols.
Antarctic: If the meteorite was found in Antarctica. Not all Antarctic meteorites have this attribute.
Lat-Long: Coordinates.
Latitude: The latitude value only.
Longitude: The longitude value only.
Notes: Notes left by curators if any.
Link: The joined link to the Meteoritical Bulletin information for that entry.

Tables

Meteoritical Bulletin Data Final

@kaggle.sweeteyesbirb_meteoritical_bulletin_dataset.meteoritical_bulletin_data_final

3.5 MB
83625 rows
16 columns


CREATE TABLE meteoritical_bulletin_data_final (
  "name" VARCHAR,
  "abbrev" VARCHAR,
  "status" VARCHAR,
  "fall" VARCHAR,
  "year" VARCHAR,
  "year_only" DOUBLE,
  "place" VARCHAR,
  "type" VARCHAR,
  "mass_kg" DOUBLE,
  "metbull" DOUBLE,
  "antarctic" VARCHAR,
  "lat_long" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "notes" VARCHAR,
  "link" VARCHAR
);

Raw Meteoritical Bulletin Data

@kaggle.sweeteyesbirb_meteoritical_bulletin_dataset.raw_meteoritical_bulletin_data

3.1 MB
83625 rows
13 columns


CREATE TABLE raw_meteoritical_bulletin_data (
  "name" VARCHAR,
  "abbrev" VARCHAR,
  "status" VARCHAR,
  "fall" VARCHAR,
  "year" VARCHAR,
  "place" VARCHAR,
  "type" VARCHAR,
  "mass" VARCHAR,
  "metbull" VARCHAR,
  "antarctic" VARCHAR,
  "lat_long" VARCHAR,
  "notes" VARCHAR,
  "link" VARCHAR
);