About the Data
Michigan started issuing permits for wells in 1927. There were some wells drilled before then, and a few of them are still producing. Computerized tracking of oil and gas production began in Michigan in 1982, but oil production for the Albion-Scipio field goes back to 1969 (gas production is missing). Prior information is only available from microfilm.
At first, only prorated wells (wells that had production regulated) were tracked. These were wells in the Salina, Niagaran, and deeper formations.
In 1997, rules were changed to track production on all wells in Michigan. The production information you download is not all the production in the State, but does include everything our database at the time it was made.
Companies have 45 days from the end of the month to report production to us, and it does take us some time to enter the data into the computer. Assuming the the company reports everything to us on time, which is often not the case, it is not uncommon that the database is two months behind in information.
Cumulative production is not available. If a prorated well started producing after 1982, a cumulative can be found by running a query that totals the monthly production. If a well is not prorated but started producing since 1997 a cumulative can be calculated similarly.
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 another 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 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 MB, updated 8/1/2008. This is a zipped (compressed) file. Before it can be opened with Microsoft Access it must be unzipped.)
This page will be updated monthly near the 1st of the month.
If there are any questions or problems with this page, contact Roger Nelson at 517-241-1502;
email: nelsonr3@michigan.gov