carlplant / icasualties_all_loses_afghanistan

iCasualties all loses Afghanistan

Scrapes icasualties.org, google.com, and www.google.com

iCasualties: Operation Iraqi Freedom and Operation Enduring Freedom Casualties


Forked from ScraperWiki

Contributors carlplant

Last run failed with status code 1.

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Table probably already exists. Transfiguracion, Reymund Rarogal 8-12-2018 Traceback (most recent call last): File "scraper.py", line 39, in <module> scraperwiki.sqlite.save(unique_keys=[], data={"Name":Name, "Date":Date, "Rank" : Rank, "Age":Age, "Unit": Unit, "Branch": Branch, "State": State, "City": City, "Cause": Cause, "Place_of_Death": Place_of_Death, "Died_In": Died_In }, table_name='icasualities') File "/app/.heroku/src/scraperwiki/scraperwiki/sqlite.py", line 34, in save return dt.upsert(data, table_name = table_name) File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 301, in upsert self.insert(upsert=True, *args, **kwargs) File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 284, in insert self.execute(sql, values, commit=False) File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 136, in execute self.cursor.execute(sql, *args) sqlite3.DatabaseError: database disk image is malformed

Data

Downloaded 0 times

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (115 MB) Use the API

rows 0 / 0

id City Name Died_In Age Rank State Branch Date Place_of_Death Cause Unit
1
Plainwell
Schoonhoven, Mark H.
USA
38
Sergeant
Michigan
U. S. Army
1-20-2013
Brooke Army Medical Center, Fort Sam Houston, Texas
Hostile - hostile fire - IED attack
32nd Transportation Company, 43rd Sustainment Brigade, 4th Infantry Division
2
Hampton
Chambers, David J.
Afghanistan
25
Sergeant
Virginia
U.S. Army
1-16-2013
Panjwai District
Hostile - hostile fire - IED attack
1st Battalion, 38th Infantry Regiment, 4th Stryker Brigade Combat Team, 2nd Infantry Division, under control of the 7th Infantry Division
3
Chester
Wittman, Aaron X.
Afghanistan
28
Sergeant
Virginia
U. S. Army
1-10-2013
Khogyani District
Hostile - hostile fire - small arms fire
3rd Battalion, 69th Armor Regiment, 1st Brigade Combat Team, 3rd Infantry Division
4
Citra
Sims, Markie T.
Afghanistan
20
Private 1st Class
Florida
U. S. Army
12-29-2012
Panjwal
Hostile - hostile fire - IED attack
38th Engineer Company, 4th Stryker Brigade Combat Team, 2nd Infantry Division, 7th Infantry Division
5
The Colony
Mondragon, Enrique
Afghanistan
23
Sergeant
Texas
U. S. Army
12-24-2012
Baraki Barak
Hostile - hostile fire - small arms fire
Headquarters and Headquarters Detachment, 173rd Special Troops Battalion, 173rd Airborne Brigade Combat Team
6
Pottstown
Price, Job W.
Afghanistan
42
Comander
Pennsylvania
U. S. Navy
12-22-2012
Uruzgan
Non-hostile - suicide
Naval Special Warfare (SEAL)
7
Spring Lake
Robinson, Leonard
USA
29
Lieutenant
North Carolina
U. S. Navy
12-15-2012
Fayetteville, NC
Non-hostile
Naval Hospital Sigonella
8
Baldwin
Lipari, Kevin E.
Afghanistan
39
Sergeant 1st Class
New York
U. S. Army
12-14-2012
Logar
Hostile - hostile fire
HHC 173rd Airborne Brigade Combat Team
9
Pearl River
Guillory, Michael J.
Afghanistan
28
Sergent
Louisiana
U. S. Marine
12-14-2012
Helmand
Non-hostile
1st Marine Special Operations Battalion
10
Austin
Trent, Nelson D.
Afghanistan
37
Staff Sergent
Texas
U. S. Army National Guard
12-14-2012
Kandahar
Hostile - hostile fire - IED attack
56th Infantry Brigade Combat Team, 36th Infantry Division

Statistics

Average successful run time: 2 minutes

Total run time: 3 days

Total cpu time used: 32 minutes

Total disk space used: 115 MB

History

  • Auto ran revision 1a62db2f and failed .
    3 pages scraped
  • Auto ran revision 1a62db2f and failed .
    1 page scraped
  • Auto ran revision 1a62db2f and failed .
    4 pages scraped
  • Auto ran revision 1a62db2f and failed .
    17 pages scraped
  • Auto ran revision 1a62db2f and failed .
    1 page scraped
  • ...
  • Forked from ScraperWiki

Show complete history