Python SQLite3 How to extract specific tables only

I have a sqlite database that I want to extract specific tables from. The database has thousands of table names. I'm interested only in tables that startwith "contact_" However there are many that are contactOLD, contact#### you name it.

I then need to extract the row data from each "contact_########" table and create a CSV or spreadsheet type document. In total there are 1600 or so with unique names.

I had initially thought I could do this with a sqlite query but could not. I then tried to write a small script to do this but I could not figure out how to setup conditionals for the cursor.execute to only grab the data from the tables of interest to me.

Any ideas?