Use ArcPy for finding value throughout all fields and export to new layer

Question

I need to find a way to find a specific value in the attribute table and then export all rows with said value to a new feature class.

Below is the code that I have managed to come up with (using other answers on this site). It gives the FID of the rows with the value searched but I can't find a way to select and export those records to a new file.

import arcpy
arcpy.env.overwriteOutput = True

# Set the environment
workspace = r"\\C:\\GIS\\"
arcpy.env.workspace = workspace
fc = "species.shp"

# Get fields in the attribute table
field_names = [f.name for f in arcpy.ListFields(fc, field_type='String')]
print(field_names)

# Loop through fields
for field in field_names:
    # Create a search cursor through rows in the feature class that looks for "In Danger" values and prints the record's FID number
    search = arcpy.da.SearchCursor(fc, "*")
    for row in search:
        if "In Danger" in row:
            print("In Danger value for FID {0}".format(row[0]))
            arcpy.Select_analysis(fc, 'new_fc', '{} like \'%{}%\''.format(field, 'In Danger'))

Answer 1

I usually list OIDs of the rows meeting some condition then select using these:

import arcpy

fc = r'C:\GIS\species.shp'

field_names = [f.name for f in arcpy.ListFields(fc) if f.type=='String']

oids_to_select = []
with arcpy.da.SearchCursor(fc,['OID@']+field_names) as cursor:
    for row in cursor:
        if 'In Danger' in row: #If in any of the listed field, append OID to list
        #If 'In Danger' can be a substring, for example 'ABC In Danger CDE' then try: if any(['In Danger' in substring for substring in row])
            oids_to_select.append(row[0])

sql = "{0} IN{1}".format(arcpy.AddFieldDelimiters(fc,arcpy.Describe(fc).OIDFieldName),tuple(oids_to_select))
arcpy.Select_analysis(fc,r'C:\GIS\species_selection.shp',sql)

Answer 2

I'd skip selection by using insert cursor, e.g.

import arcpy
from arcpy import env
env.overwriteOutput = True
infc=r'...gdb\node_s'
outfc=r'....gdb\node_extract'
arcpy.CopyFeatures_management(infc, outfc)
arcpy.DeleteFeatures_management(outfc)
curT=arcpy.da.InsertCursor(outfc,"*")
with arcpy.da.SearchCursor(infc,"*") as cursor:
    for row in cursor:
        if "In Danger" not in row:continue
        curT.insertRow(row)