Dataset: Michigan Timber Auctions

About this Dataset

Michigan Timber Auctions

I obtained this data from the Michigan Department of Natural Resource (MDoNR) website which is freely available and posted to an https server. This state agency is in charge of the management of state forests in Michigan. The MDoNR provides very detailed information concerning the timber, such as the various species in the lot, the volumes of each species, the percentage of saw timber and the minimum acceptable bid (the public reserve price).

Bids: Amount of the bids placed
Winbid: Amount of the winning bid
Reserve: Minimum acceptable bid or the public reserve price
Acre: Bidding lot size in acres
Actual: Total number of bidders that submit a bid for a particular timber sale auction
Potential: Total number of bidders that submit an actual bid for any timber sale auction held by the same office the same month
Payment: Maximum number of payments the winner is allowed to pay off the bid
Years: Number of harvest years the winner is allowed from the date of sale

For information on the datasets and analysis, see the corresponding github repository.
https://github.com/ericschulman/michigan_timber

Tables

Mich Bids

@kaggle.erichschulman_michigan_timber_auctions.mich_bids

1.86 MB
146212 rows
16 columns


CREATE TABLE mich_bids (
  "unnamed_0" BIGINT,
  "appraised_value_per_unit" DOUBLE,
  "bid_open_date" TIMESTAMP,
  "bid_open_location" VARCHAR,
  "bid_open_time" VARCHAR,
  "bid_per_unit" DOUBLE,
  "bid_non_bid_species" VARCHAR,
  "bidder_name" VARCHAR,
  "estimated_volume" DOUBLE,
  "highest" VARCHAR,
  "no_bid_sale" VARCHAR,
  "product" VARCHAR,
  "sale" VARCHAR,
  "sale_name" VARCHAR,
  "species" VARCHAR,
  "units" VARCHAR
);

Mich Sales

@kaggle.erichschulman_michigan_timber_auctions.mich_sales

3.39 MB
149014 rows
14 columns


CREATE TABLE mich_sales (
  "unnamed_0" BIGINT,
  "acres" DOUBLE,
  "date" TIMESTAMP,
  "date_1" TIMESTAMP,
  "date_2" TIMESTAMP,
  "expiration" BIGINT,
  "length_days" BIGINT,
  "purchaser_name" VARCHAR,
  "received" DOUBLE,
  "sale_name" VARCHAR,
  "sale_number" BIGINT,
  "seq" BIGINT,
  "value" DOUBLE,
  "volume" DOUBLE
);