U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Internet
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 10-03-2015, 09:26 AM
 
Location: Texas Hill Country
10,538 posts, read 5,797,828 times
Reputation: 8778

Advertisements

In another thread in another forum, a contributor put out the question of how many school shootings have there been where the shooter was over 30?

Oh, that would be great if I could ask that question to the system here and now. A report in seconds of age and incidents.

But......are we still back in the time of Ted Bundy where only dedicated agencies with dedicated data bases can do things like that? Where for the rest of us, we have to spend hours searching PDFs to find someone who produced that answer, perhaps years ago?

Is there a way now in our fantastic information era?
Reply With Quote Quick reply to this message

 
Old 10-03-2015, 10:14 AM
 
10,077 posts, read 4,954,386 times
Reputation: 15414
you havent heard of google? :O

you could try microfilms if the pdfs dont work out for you
Reply With Quote Quick reply to this message
 
Old 10-03-2015, 10:45 AM
 
11,780 posts, read 8,756,742 times
Reputation: 3435
What you would do is query a database. The large agencies you speak of have the database in place already, so to get the information you desire requires submitting a request via the Freedom of Information Act to the proper agency at which point they will typically provide the data they have.

For your example, over 30 and school shooter or involved in school shooting, you could either search for the compiled (raw) list of school shootings - it's out there - or request a list of school shooting with the shooter's age from the FBI and then query from that list. You can also manually sort with excel if that is your cup of tea.

Some of what I described is also known as data mining.
Reply With Quote Quick reply to this message
 
Old 10-03-2015, 11:15 PM
 
Location: League City
3,475 posts, read 6,748,010 times
Reputation: 4187
Yes there are ways to do this, but it is not straightforward.

You may be able to get some useful tables by searching for a query like "list of all school shootings." Hopefully you find an article with the tabular data you want.

If the data in an article is structured and uniformly formatted into fields (like a table), you could conceivably select the table, cut and paste into excel, or if you like HTML you could edit the file and pull it out that way. Clean the data in Excel (apply more formatting if needed), then import Excel into MS Access to run queries against it. And even then you may have to jump through a few hoops to get exactly what you want.

There are also more complex ways to scrape data from a web page, but those are even more convoluted and not at all fun.

I would also try Cortana or whatever the iphone thing is called. Those can support some sophisticated queries.
Reply With Quote Quick reply to this message
 
Old 10-04-2015, 06:23 PM
 
11,780 posts, read 8,756,742 times
Reputation: 3435
There is an online article that has a published list of Shooters and their ages in a sortable format, but it is only for a select timeframe (like since Newtown). There is also another one published in pdf format, but that only has 3 years of data.

Here's one such article based on the pdf I mentioned, but it only covers 3 years and since school shootings (and homicides) are trending down this would not present the correct answer to the query in the OP unless you add the qualifier "since 2012".

https://www.washingtonpost.com/blogs...-new-analysis/
Reply With Quote Quick reply to this message
 
Old 10-04-2015, 06:47 PM
 
40,169 posts, read 41,775,319 times
Reputation: 16740
Quote:
Originally Posted by lycos679 View Post
What you would do is query a database. The large agencies you speak of have the database in place already, so to get the information you desire requires submitting a request via the Freedom of Information Act to the proper agency at which point they will typically provide the data they have.

For your example, over 30 and school shooter or involved in school shooting, you could either search for the compiled (raw) list of school shootings - it's out there - or request a list of school shooting with the shooter's age from the FBI and then query from that list. You can also manually sort with excel if that is your cup of tea.

Some of what I described is also known as data mining.
The government offers a lot of resources without having to get involved with requesting it. You just have to look for it and know how to manage it afterward.

CSV export of crime statistics:

Uniform Crime Reporting Statistics
Reply With Quote Quick reply to this message
 
Old 10-04-2015, 07:58 PM
 
11,780 posts, read 8,756,742 times
Reputation: 3435
Quote:
Originally Posted by thecoalman View Post
The government offers a lot of resources without having to get involved with requesting it. You just have to look for it and know how to manage it afterward.

CSV export of crime statistics:

Uniform Crime Reporting Statistics
The problem with that is much of the data is already aggregated and doesn't, for example, show the type of murder/homicide/shooting with no deaths based on location (school shooting) (and provides limited detail on type of shooting) or details about the homicide/victims/shooter. But yes, if the CSV file is available with the needed information you could build a database and query from that.
Reply With Quote Quick reply to this message
 
Old 10-05-2015, 03:03 AM
 
40,169 posts, read 41,775,319 times
Reputation: 16740
Quote:
Originally Posted by lycos679 View Post
The problem with that is much of the data is already aggregated and doesn't, for example, show the type of murder/homicide/shooting with no deaths based on location (school shooting) (and provides limited detail on type of shooting) or details about the homicide/victims/shooter. But yes, if the CSV file is available with the needed information you could build a database and query from that.
Looking a little deeper....

Bureau of Justice Statistics (BJS) - All Data Collections
Reply With Quote Quick reply to this message
 
Old 10-05-2015, 08:14 AM
 
11,780 posts, read 8,756,742 times
Reputation: 3435
Quote:
Originally Posted by thecoalman View Post
On mobile I cannot spend hours searching for a link. I did see that page, and upon closer inspection still do not see whatever it is that I am supposed to see. Can you just post the direct link or tell me which link you are trying to direct me to?
Reply With Quote Quick reply to this message
 
Old 10-05-2015, 05:09 PM
 
40,169 posts, read 41,775,319 times
Reputation: 16740
There is nothing specific on there you supposed to be looking for, the point is there is a plethora of data sets. Whether it's going to specifically address your examples I don't know.
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Internet
Follow City-Data.com founder on our Forum or

All times are GMT -6. The time now is 11:45 PM.

© 2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top