Here is another quick update to let you know that I have made available all of the finalists data from 2009-2011, in JavaScript Object Notation (JSON) format. If you ask nicely and want it, I can offer it in other formats as well.
The data can be retrieved here: http://pmfellow.kodingen.com/scripts/getjson.php
Available fields and descriptions are as follows:
- label: Either an MD5 hashed version of the original finalist name, or, because I didn't have the names available when I imported the data, something like "applicantX" where X is an incremental number.
- type: Currently only finalists are available, but when I get to it, other valid values, for which there are available rows, will be "semifinalists" and "nominees."
- year: The PMF class year. Not every record type is available for every year.
- rank: This is just the database unique record identifier; you don't really need it for anything.
- school: The corrected name of the school the individual PMF attended. By corrected, I mean the standardization I undertook as part of the record cleanup.
- field: Individual's academic field. No effort to standardize or clean these up occurred.
- latlng: The latitude and longitude of the school, as determined by a separate geocoding script. I expect some percentage of error to have occurred here, but see below for error reporting.
Also, feel free to use the data however you see fit. If you have anything you're trying to put together, I would be happy to link to it. Similarly, I would be happy to help if you want data that's not currently there (assuming I have it).
Yes please, other formats...
ReplyDeleteI don't believe you :P
ReplyDeleteIf you want other formats, it might help to let me know exactly WHAT formats.
Can it be converted into csv or Excel?
ReplyDeleteYes, Excel could be great. I cannot open the data you posted.
ReplyDeleteI should have prefaced the blog post with an indication of the general usefulness of the data in this format for non programmers. Which is to say, it's not. I will update this post with new formats as I make them available.
ReplyDeleteoh my, this just looks like a jumbled bunch of letters to me. I can't even read it. Other formats please! =)
ReplyDeleteDo you have stats on how many finalists actually found fellowships?
ReplyDeleteThe data is now available as CSV for anyone who wants to see it in Excel (see the top of the post). I should note that there is an extra field in this one, and it denotes whether the finalist was a veteran or not. It is either Yes or blank. You'll see it if you look for it.
ReplyDeleteThanks for th CSV/Excel formats.
ReplyDeleteHi PMFellow,
ReplyDeleteThanks for the great blog...it's been a tremendous resource. I'm a 2011 PMF Finalist, and I have a very specialized question based on these datasets...I want to contact you about it, but I can't find a way to contact you on your blog. Could you email me at filipinoidol@gmail.com to discuss? Thanks again.