Name: Groundhog Predictions
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Groundhog Predictions

Overview

Happy Groundhog Day! In this dataset, we're exploring Groundhog Day Predictions from groundhog-day.com!
See if you can find a better way to present the annual data than their table of predictions by year!
For anyone not familiar with the Groundhog Day tradition, if the groundhog sees its shadow and goes back into its burrow, that is a prediction of six more weeks of winter.
Otherwise, spring will come early.

Data Dictionary

`groundhogs.csv`

variable	class	description
id	integer	A numeric id for this groundhog.
slug	character	The name of the groundhog, in simplified kebab case.
shortname	character	A short version of the name of the groundhog or groundhog substitute.
name	character	The full name of the groundhog or groundhog substitute.
city	character	The city in which the prediction takes place.
region	character	The state or province of the prediction.
country	character	The country of the prediction (USA or Canada).
latitude	double	The latitude of the city.
longitude	double	The longitude of the city.
source	character	A url with information about this groundhog.
current_prediction	character	A url with information about the most recent prediction.
is_groundhog	logical	A logical value indicating whether this predictor is a living groundhog.
type	character	A short description of the type of animal or other thing that is said to make the prediction.
active	logical	A logical value indicating whether this predictor is active (as of 2023).
description	character	A free-text description of the predictor.
image	character	A URL with an image of the predictor.
predictions_count	integer	The number of predictions available for this predictor.

`predictions.csv`

variable	class	description
id	integer	A numeric id for this groundhog.
year	integer	The year of the prediction.
shadow	logical	Whether the groundhog saw its shadow, and thus predicts 6 more weeks of winter.
details	character	Free text with more information about this prediction.

Tables

Groundhogs

@kaggle.joebeachcapital_groundhog_predictions.groundhogs

48.62 KB
75 rows
17 columns


CREATE TABLE groundhogs (
  "id" BIGINT,
  "slug" VARCHAR,
  "shortname" VARCHAR,
  "name" VARCHAR,
  "city" VARCHAR,
  "region" VARCHAR,
  "country" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "source" VARCHAR,
  "current_prediction" VARCHAR,
  "is_groundhog" BOOLEAN,
  "type" VARCHAR,
  "active" BOOLEAN,
  "description" VARCHAR,
  "image" VARCHAR,
  "predictions_count" BIGINT
);

Predictions

@kaggle.joebeachcapital_groundhog_predictions.predictions

9.96 KB
1462 rows
4 columns


CREATE TABLE predictions (
  "id" BIGINT,
  "year" BIGINT,
  "shadow" VARCHAR,
  "details" VARCHAR
);