Interesting Metrics on AFG

[BC79er_OLDDELETE]

Being the nerd that I am, and being used to mining data on a daily basis, I thought I'd play a little with the AFG Awards lists from 2001-present.

With everything announced so far, there have been 29,274 awards including AFG, FP, & SAFER.

Within that, there are 24,824 distinct Organization names. Actually, much less than that as some people spelled their names differently on each app, making it a different record ( Community VFD isn't Community Vol. FD, etc, etc). I would venture to guess that number is closer to 22,000 since I was finding at least 4 departments per page that had spelled their name differently, so across 522 pages, about 2,500 repeats.

So to mess with the data more, I found that there are 15,258 cities represented. And that number is probably higher since some people left that particular piece of data blank in their app. Now that doesn't mean 15,828 departments represented, that number is higher because there are numerous departments in one city mailing address. The top bunch is:

City State # Of Awards
Pittsburgh PA 49
San Juan PR 38
CA 29
TN 26
Cincinnati OH 26
AL 25
Johnstown PA 21
TX 21
Houston TX 19
Rochester NY 19
Butte MT 18
OH 17
Bellingham WA 17
Indianapolis IN 17
PA 16
Birmingham AL 16
GA 16
lucedale MS 16
Greenville SC 16
New Iberia LA 16
Santa Rosa CA 16
Lawton OK 15
Danville VA 15
San Antonio TX 15
MA 14

That still leaves approximately 12,000 departments in the country that haven't even applied once.

The message is, the number of repeat winners is lower than people seem to think. To the best of my ability with no-so-accurate Organization name data to play with, there are at least 20,000 different departments that have been awarded in the 5 years so far.

In other words, the money is being spread out pretty decently in my opinion, and the priorities of the program are being met since departments are handling their high priority problems, and then not being awarded for ones that are relatively lower than other departments' needs as we move forward. Perfect system with everyone's needs being met? Nope, no such thing as a perfect anything down here. But, I'd have to say the whole thing is pretty dang successful and objectively meeting the needs of the fire service. but it needs more money, and according to the elevator's information screen, today is Write Congress Day. So write Congress and let's get us more money in the program.

In addition to that pile of semi-uninteresting data, now you know what I do on lunch breaks.

- Brian

[onebugle]

Well, pretty soon lunchtime will be used for something else. Sleep after the new one arrives.

[BC79er_OLDDELETE]

Sleep is over-rated, I don't get any noZZZZZZZZZZZZZZZZZZZZ

[Tonyg26]

mighty impressive .....from one data miner to another......

a couple things I noticed just from the numbers you provided...

- even on the repeats - no one dept. was repeated an obscene number of times
- geographically spread out
- demographics spread out also - big and small cities, high vs low populated states, industrial vs agricultural

don't know if this means anything - just another way of presenting info when telling those that matter in DC - keep the process going

[dixiechicknc]

Brian, what GREAT info this is! Especially for everyone who says how one sided the grant is. I love it when you kick into "high nerd", we all benefit.
I can hardly wait until you start being up ALL night. Wow...

I also thought to see NC high up on the list for ALOT of awards...LOL.

[ktb9780]

BC79er, you can tell when all your grants are filed can't we.... you start doing things to keep you occupied. Let's see if that therory holds true in about 60 days.LOL! Way to go Brian, great information.

[BC79er_OLDDELETE]

Man I wish I was done filing. Not that I'm complaining but for every 1 I finish 3 more show up. Luckily about a dozen in the bag already, so things are getting done. I'm in the zone.

Plus with the nerd brain stuff like this doesn't take me long. Including this little list which should make Alana happy about NC's count.

AK 140 $14,821,649.00
AL 1047 $84,722,335.84
AR 694 $40,576,914.00
AS 2 $448,786.00
AZ 269 $30,176,094.00
CA 964 $108,855,019.23
CO 333 $22,709,733.40
CT 339 $34,643,720.75
DC 2 $673,840.00
DE 38 $4,517,523.00
FL 586 $63,262,983.30
GA 499 $43,827,263.00
GU 1 $16,764.00
HI 13 $4,200,368.00
IA 864 $53,868,717.00
ID 218 $19,175,466.68
IL 1234 $96,881,513.50
IN 766 $66,112,353.60
KS 552 $34,918,139.10
KY 714 $60,259,094.60
LA 636 $48,274,545.00
MA 488 $53,626,254.00
MD 263 $30,518,195.00
ME 433 $31,797,280.77
MI 974 $64,695,941.00
MN 833 $61,460,316.14
MO 879 $64,721,067.00
MP 3 $590,000.00
MS 689 $45,452,036.00
MT 407 $27,198,941.00
NC 909 $76,492,029.00
ND 243 $14,292,236.00
NE 357 $22,941,452.00
NH 245 $17,452,683.00
NJ 671 $59,805,234.04
NM 227 $15,664,571.00
NV 76 $8,394,668.00
NY 1622 $123,509,081.75
OH 1106 $100,164,075.40
OK 646 $36,162,462.40
OR 377 $35,342,241.00
PA 1858 $151,468,292.00
PR 88 $4,823,040.00
RI 84 $7,966,332.00
SC 495 $43,073,438.00
SD 330 $17,757,859.10
TN 853 $66,571,067.00
TX 1211 $102,156,365.70
UT 231 $14,332,217.00
VA 540 $57,925,088.41
VI 4 $1,285,748.55
VT 216 $14,404,641.00
WA 572 $63,278,407.71
WI 910 $65,089,649.53
WV 403 $34,157,822.46
WY 120 $9,747,725.00

PR - Puerto Rico, VI - Virgin Islands, GU - Guam, etc, etc. For those that counted more than 51.

[dixiechicknc]

Brian,

You are TOO cool...thanks! I'll consider this my own New Year's gift. Wow - 909 huh....have to figure how many were mine. LOL...See, you're a little more organized and 'nerdly' than me. Am too busy to count and keep track of things like totals, and all. I should. I really, really am glad you're around! You sure make all our lives a little easier and better!


PS: I see you're doing your share over in Texas...

[onebugle]

Brian has done a great job with coming up with figures on the program. Since I have some time before the radio test, I came up with the average per award per state (rounded up). I'm pretty mean with a calculator.

AK $105,869
AL $80,919
AR $58,468
AS $224,393
AZ $112,179
CA $112,920
CO $68,197
CT $102,194
DC $336,920
DE $118,882
FL $107,957
GA $87,830
GU $16,764
HI $323,105
IA $62,348
ID $87,961
IL $78,510
IN $86,309
KS $63,257
KY $84,396
LA $75,903
MA $109,890
MD $116,039
ME $73,435
MI $66,423
MN $73,782
MO $73,630
MP $196,667
MS $65,968
MT $66,828
NC $84,150
ND $58,816
NE $64,262
NH $71,235
NJ $89,129
NM $69,007
NV $110,456
NY $76,146
OH $90,564
OK $55,979
OR $93,746
PA $81,522
PR $54,807
RI $94,837
SC $87,017
SD $53,812
TN $78,043
TX $84,357
UT $62,044
VA $107,269
VI $321,437
VT $66,688
WA $110,627
WI $71,527
WV $84,759
WY $81,231

As for the 3 grant guru's Kurt's state is first, then Brian and Dixie. Considering NC is not that big, they held their own, only a couple 100 dollars behind Texas.

[ktb9780]

Wow, did I win something for this????? Oh, darn! Funny thing though onebugle, my home state is where I have the least amount of clients. My biggest states, by clients, were in MO, NC, PA, OH in that order. The pattern is interesting to note though, if you compare the economic status of the state vs. the dollar value of their awards. It also seems to correspond to their population base as well. Good to see the program awarding based upon that, as it does tend to make sure that the money goes where the most people are concentrated... and before all you small guys start bashing me about population not being a governing factor lets be realistic here. More money will be spent where there are more people. Not my rule but, in trying to make sure that things are on a level playing field I like seeing that done this way.

[BC79er_OLDDELETE]

A lot of the large quantity states are down, like PA, Ill, TX, and NY. Lots of smaller departments with little money to match a good sized project.

And it's not just TX, I'm an equal opportunity money finder. I've gotten money for 32 states so far, hoping to stretch that out a bit. Kinda like my dad wanting to play at least 1 round of golf in every state, I'm going to try to help with at least 1 award in every state.

I doubt I'll make all 51 + the protectorates, only 5 departments in Hawaii, 1 in DC. And I'm pretty sure DC can handle their own. Just a hunch.

[ktb9780]

bc79er you have created a monster here!!!! Now you have me checking stats. I just looked and discovered I have grants funded in 36 states now. I also am in contact with several US Territories and HI so maybe I can add them to the list this year.