<p>You should start with NOAA services. They have a <a href="https://www.ncdc.noaa.gov/stormevents/" rel="nofollow noreferrer">Storm Events Database</a> going back to 1950, where you can do queries for states/counties of interest. If you are more interested in lightning data, they also have <a href="https://www.ncdc.noaa.gov/data-access/severe-weather/lightning-products-and-services" rel="nofollow noreferrer">some products</a>, including raw data from a private company (you'll need access for this) and freely available derived products.</p>

CC BY-SA 4.0
2020-01-03T10:10:31.830Z
2020-01-03T10:10:31.830Z
Jean-Marie Prival
<p>I too don't know any direct sources.  So you will likely have to do a bit of legwork.</p>

<ul>
<li>Was going to offer that you could work a climatology together from
monthly FP6 reports using the desired NWS site (click the office on
<a href="https://sercc.com/nowdata.html" rel="nofollow noreferrer">https://sercc.com/nowdata.html</a>, then switch to observed weather, then
select CF6 and choose the site and then indicate the month report you
want... on those reports any date with a 3 in the WX column had
thunder... then you could sum them over many reports to make a
climatology... time consuming, but I've done similar.  It would be
feasible to do a few sites, but brutal to do for many without
automating the process)</li>
<li><p>But it looks like Iowa State's IEM ADP comes through with something a
bit more robust and more reasonable in the amount of work it takes to
finish together...   Using option <a href="https://mesonet.agron.iastate.edu/plotting/auto/?q=87" rel="nofollow noreferrer">ADP #87 here</a>, select the 
state/country of interest, then city you want data on (you may wish to further
look into what the official observing site is for the city you want)... make
sure you have thunder as the code choice, and select group by day of
the years.  Choose your years {you may want to skip the first and
current year for better hopes of about equal data sets for each day
of the year... you also may want to avoid going back too far in time,
as it looks like records may have been less complete back towards the
1950s and earlier}, then make the plot with options.   It'll produce
a nice graphic which you may find useful.  If you want precise
numbers, you can reasonably make the true climatology by clicking
download as Excel below the plot.  </p>

<p>(If anyone reading happens to be a little unfamiliar with Excel {Open Office likely would work fairly similar?}... I can try to run you through the remaining process I used for this graphic:<br>
<a href="https://excel.officetuts.net/en/examples/select-multiple-columns-in-excel" rel="nofollow noreferrer">select the day and year columns together</a>,<br>
then <a href="https://stackoverflow.com/questions/30501104/removing-duplicates-in-excel">filter out duplicates</a>,<br>
then <a href="https://support.office.com/en-us/article/count-how-often-a-value-occurs-aa1f3067-05c9-44e4-b141-f75bb9bb89bd" rel="nofollow noreferrer">make a Pivot Table</a> in a new sheet with doy as Row Label
and count of year as Σ values.</p>

<p><a href="https://i.sstatic.net/pnlRh.png" rel="nofollow noreferrer">After one mistake in reading</a>, I realized you wanted monthly data... from here there may be <a href="https://support.office.com/en-us/article/group-or-ungroup-data-in-a-pivottable-c9d1ddd0-6580-47d1-82bc-c84a5a340725" rel="nofollow noreferrer">easier ways to do the rest</a>, but using my old Office 2007 and somewhat limited skill, I pushed through to get all dates summed by writing the formula </p>

<blockquote>
  <p>=ROW()-3  </p>
</blockquote>

<p>in cell D4 and</p>

<blockquote>
  <p>=IFERROR(GETPIVOTDATA("year",\$A$3,"doy",ROW()-3),0)  </p>
</blockquote>

<p>in cell E4.</p>

<p>Then expanded those cell formulas downward to row 369 (so 366 days were covered).</p>

<p>Then I typed the month names in F4-F15 and the formulas</p>

<blockquote>
  <p>=SUM(E4:E34)/50<br>
  =SUM(E35:E63)/50<br>
  =SUM(E64:E94)/50<br>
  =SUM(E95:E124)/50<br>
  =SUM(E125:E155)/50<br>
  =SUM(E156:E185)/50<br>
  =SUM(E186:E216)/50<br>
  =SUM(E217:E247)/50<br>
  =SUM(E248:E277)/50<br>
  =SUM(E278:E308)/50<br>
  =SUM(E309:E338)/50<br>
  =SUM(E339:E369)/50  </p>
</blockquote>

<p>in G4-G15.</p>

<p>Select the F and G columns, add a bar graph from that, add a title, and I had:</p></li>
</ul>

<p><a href="https://i.sstatic.net/K6QbC.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/K6QbC.png" alt="enter image description here"></a></p>

<p>It's certainly not readymade :-(<br>
But it does at least seem a way you could possibly produce enough climatologies in reasonable time to get a rough idea of the country (or other parts of the world?)?<br>
Hope you/others can find something that is already completed, but if not, hopefully this offers something a bit useful.  </p>

<p>(Those looking to go all-out nuts and make a full dataset could download full ASOS data from <a href="https://mesonet.agron.iastate.edu/request/download.phtml" rel="nofollow noreferrer">Iowa State</a> or <a href="https://www.ncdc.noaa.gov/data-access/land-based-station-data/land-based-datasets/automated-surface-observing-system-asos" rel="nofollow noreferrer">NCDC</a> and put together a detailed script to pull out the pieces needed.  Feel free to share the data here if you do!)</p>

CC BY-SA 4.0
2020-02-06T09:34:56.273Z
2020-02-06T09:34:56.273Z
JeopardyTempest
<p>How can I find the average number of days with thunderstorms for each month for different cities in the United States? I’m doing a researching project for this and I need to find some links that will show me the average number of days with thunderstorms for each month for different cities in the United States.</p>

CC BY-SA 4.0
2020-01-03T10:13:14.260Z
you might take a look here https://w2.weather.gov/jetstream/tstorms_intro it does not answer your question but it is a start.
trond hansen
<open-data><thunderstorm>
Average thunderstorm days for each month
Ryan Amalfitano
# Average thunderstorm days for each month

(Asked by: username_0 on 2020-01-03)

How can I find the average number of days with thunderstorms for each month for different cities in the United States? I’m doing a researching project for this and I need to find some links that will show me the average number of days with thunderstorms for each month for different cities in the United States.

**Tags:** open-data, thunderstorm

> **Comments:**
> **username_1**: you might take a look here https://w2.weather.gov/jetstream/tstorms_intro it does not answer your question but it is a start.  

---

## 2 answers

### Answer by username_2 on 2020-01-03. Score: 2

You should start with NOAA services. They have a [Storm Events Database](https://www.ncdc.noaa.gov/stormevents/) going back to 1950, where you can do queries for states/counties of interest. If you are more interested in lightning data, they also have [some products](https://www.ncdc.noaa.gov/data-access/severe-weather/lightning-products-and-services), including raw data from a private company (you'll need access for this) and freely available derived products.


---

### Answer by username_3 on 2020-02-06. Score: 1

I too don't know any direct sources. So you will likely have to do a bit of legwork.

* Was going to offer that you could work a climatology together from
  monthly FP6 reports using the desired NWS site (click the office on
  <https://sercc.com/nowdata.html>, then switch to observed weather, then
  select CF6 and choose the site and then indicate the month report you
  want... on those reports any date with a 3 in the WX column had
  thunder... then you could sum them over many reports to make a
  climatology... time consuming, but I've done similar. It would be
  feasible to do a few sites, but brutal to do for many without
  automating the process)
* But it looks like Iowa State's IEM ADP comes through with something a
  bit more robust and more reasonable in the amount of work it takes to
  finish together... Using option [ADP #87 here](https://mesonet.agron.iastate.edu/plotting/auto/?q=87), select the
  state/country of interest, then city you want data on (you may wish to further
  look into what the official observing site is for the city you want)... make
  sure you have thunder as the code choice, and select group by day of
  the years. Choose your years {you may want to skip the first and
  current year for better hopes of about equal data sets for each day
  of the year... you also may want to avoid going back too far in time,
  as it looks like records may have been less complete back towards the
  1950s and earlier}, then make the plot with options. It'll produce
  a nice graphic which you may find useful. If you want precise
  numbers, you can reasonably make the true climatology by clicking
  download as Excel below the plot.

  (If anyone reading happens to be a little unfamiliar with Excel {Open Office likely would work fairly similar?}... I can try to run you through the remaining process I used for this graphic:  
  [select the day and year columns together](https://excel.officetuts.net/en/examples/select-multiple-columns-in-excel),  
  then [filter out duplicates](https://stackoverflow.com/questions/30501104/removing-duplicates-in-excel),  
  then [make a Pivot Table](https://support.office.com/en-us/article/count-how-often-a-value-occurs-aa1f3067-05c9-44e4-b141-f75bb9bb89bd) in a new sheet with doy as Row Label
  and count of year as Σ values.

  [After one mistake in reading](https://i.sstatic.net/pnlRh.png), I realized you wanted monthly data... from here there may be [easier ways to do the rest](https://support.office.com/en-us/article/group-or-ungroup-data-in-a-pivottable-c9d1ddd0-6580-47d1-82bc-c84a5a340725), but using my old Office 2007 and somewhat limited skill, I pushed through to get all dates summed by writing the formula

  > =ROW()-3

  in cell D4 and

  > =IFERROR(GETPIVOTDATA("year",\$A$3,"doy",ROW()-3),0)

  in cell E4.

  Then expanded those cell formulas downward to row 369 (so 366 days were covered).

  Then I typed the month names in F4-F15 and the formulas

  > =SUM(E4:E34)/50  
  > =SUM(E35:E63)/50  
  > =SUM(E64:E94)/50  
  > =SUM(E95:E124)/50  
  > =SUM(E125:E155)/50  
  > =SUM(E156:E185)/50  
  > =SUM(E186:E216)/50  
  > =SUM(E217:E247)/50  
  > =SUM(E248:E277)/50  
  > =SUM(E278:E308)/50  
  > =SUM(E309:E338)/50  
  > =SUM(E339:E369)/50

  in G4-G15.

  Select the F and G columns, add a bar graph from that, add a title, and I had:

[![enter image description here](https://i.sstatic.net/K6QbC.png)](https://i.sstatic.net/K6QbC.png)

It's certainly not readymade :-(  
But it does at least seem a way you could possibly produce enough climatologies in reasonable time to get a rough idea of the country (or other parts of the world?)?  
Hope you/others can find something that is already completed, but if not, hopefully this offers something a bit useful.

(Those looking to go all-out nuts and make a full dataset could download full ASOS data from [Iowa State](https://mesonet.agron.iastate.edu/request/download.phtml) or [NCDC](https://www.ncdc.noaa.gov/data-access/land-based-station-data/land-based-datasets/automated-surface-observing-system-asos) and put together a detailed script to pull out the pieces needed. Feel free to share the data here if you do!)


---

