Cumulative production is not available per se.  However, there is a query in the download database that totals the monthly production.  If a prorated well started producing after 1982, a cumulative can be found by running that query.  If a well is not prorated but started producing since 1997 a cumulative can be calculated similarly.  There is another query that gives yearly totals. 

   PRUs  Production in Michigan is kept by PRUs or PRoduction Units.  A PRU may have only one well, in which case the production for that PRU is the well production.  A lot of PRUs have more than one well, especially in the Antrim formation.  There is no way to break out production by individual well in these cases.  To find out what wells are in a PRU, check the PRU Wells table.
   Because of electronic filing of production, we have been able to change some of our PRUs with lots of wells in them to individual well PRUs.  This may result in some confusion since PRU numbers have changed for various permit numbers.  We believe that most people would rather have the individual well production when we can provide it.  Electronic filing has helped us do this.  Most of these changes took place near the end of 2004.  Consult the PRU Wells table to find the Permit Number - PRU relationships.

   Well Locations: There is a download for well locations.  By comparing the API#s or Permit#s in the tables, the locations for the wells here can be found.

    The Production Download
The following download is in a zipped file of a Microsoft Access 2000 database.  If you do not have Microsoft Access, use the Online Oil and Gas Database.
Gas is in mcf (thousand cubic feet) at 14.73 psi
Liquids (oil, water, ngls, condensate) are in (42 gallon) bbls.
Oil is crude oil.  Water is also called brine.
ngls (Natural Gas Liquids) and condensate are both a very light hydrocarbon that drops out of gas during processing.

All production  -approx 7-8 MB, updated 6/1/2009.  This is a zipped (compressed) file.  Before it can be opened with Microsoft Access it must be unzipped.

Because it is difficult if not impossible to load a file bigger than 5MB on the DEQ server, this file is being made available for two weeks on a faster ftp server in the Oil&GasProduction folder. ( In Internet Explorer, if you don't see this folder, try clicking on Folders, and go to deq-outgoing )
to log in:
Username= deq-public-ftp
password= Jumbl355#

After two weeks, the file is deleted automatically.

(Important:  Copy the file to your own computer before trying to open it.  It will not open from the ftp server.)

This page will be updated monthly near the 1st of the month. 

If you have questions about the production data, contact our production analyst,
John McTiernan  mctiernanj@michigan.gov               517-241-1507

If there are any questions or problems with this page, contact the web author:
Roger Nelson  nelsonr3@michigan.gov       517-241-1502