The new Download Manager that uses the Library and the places.sqlite database file treats downloads like other history items and adds an annotation (places table: moz_annos) to identify these items as downloads.

moz_anno_attributes defines those entries as:
xx: downloads/metaData
xx: downloads/destinationFileURI
xx: downloads/destinationFileName

You can use the SQLite Manager extension to generate a list.

• SQLite Manager: https://addons.mozilla.org/firefox/addon/sqlite-manager/

1. Open Profile Directory -> places.sqlite -> Go
2. Hit the "Execute SQL" tab
3. Use a SELECT like this:

SELECT content AS Filename, datetime(dateAdded/1000000,'unixepoch','localtime') AS dateAdded, url AS Location, moz_anno_attributes.name AS Type
FROM moz_places, moz_annos, moz_anno_attributes
WHERE (moz_places.id = moz_annos.place_id) AND (moz_annos.anno_attribute_id = moz_anno_attributes.id) AND (moz_anno_attributes.name LIKE 'downloads/destinationFileURI')
ORDER BY dateAdded DESC

You can use (moz_anno_attributes.name LIKE 'downloads/destinationFileName') to see only the file name or use an OR construction to have both. WHERE (moz_places.id = moz_annos.place_id) AND (moz_annos.anno_attribute_id = moz_anno_attributes.id) AND ((moz_anno_attributes.name LIKE 'downloads/destinationFileURI') OR (moz_anno_attributes.name LIKE 'downloads/destinationFileName'))

• http://www.sqlite.org/lang_select.html#fromclause
• http://www.sqlite.org/lang_select.html#whereclause
• http://www.sqlite.org/lang_expr.html#like
• http://www.sqlite.org/lang_expr.html#between

I got this far, but you confused me after that, I'm not at all familiar with SQLite or whatever. Can you explain what I should do from here? https://support.cdn.mozilla.net/media/uploads/images/2014-05-25-17-44-51-385e54.png

You can paste the above posted SQLite code in the "Enter SQL" text area and click the "Run SQL" button to generate the list.

You can click the Actions button to export the list as a CSV file.

It would be better to get the '18' value from the moz_anno_attributes table (you would need moz_anno_attributes.id and moz_anno_attributes.name = 'downloads/destinationFileURI'), but I don't know if and how this can be done as SQLite code. The download file size is available in moz_annos (anno_attribute_id = '17' (downloads/metaData) in JSON format.