======================== unified (from filesystem) ========================
                                         'bitrate'  '320.0'
                                        'duration'  '224'
                                          'artist'  'Deer Tick'
                                     'text_people'  ''
                                         'release'  'Born on Flag Day'
                                           'title'  'Houston, TX'
                                           'quals'  ("['Q-HAP-2', 'Q-LOCALNESS-2', 'Q-JZFKS-1', 'Q-UNU-1', 'Q-OLDST-3', "
 "'Q-HHRNBTT-1', 'q-syn-2', 'q-bass-4', 'q-busy-3', 'q-grit-2', 'q-play-2', "
 "'q-chart-3', 'q-drums-3', 'q-other-3', 'q-piano-1', 'q-vocals-3', "
 "'q-mixbeat-2']")
                                      'lastfmtags'  "['indie', 'alt country', 'americana', 'folk', 'singer songwriter']"
                             'musicbrainz_albumid'  ''
                       'musicbrainz_albumartistid'  ''
                            'musicbrainz_artistid'  ''
                             'musicbrainz_trackid'  ''
                                     'tracknumber'  '5'
                                      'tracktotal'  '10'
                                            'date'  '2009'
                                        'comments'  ''
                                           'genre'  'ifs-songwriter-rock'
                                             'bpm'  '87'
                                             'key'  '11B'
                                        'acoustid'  '88c16bc5-8751-450f-93f7-b3cf01096450'
rest: ''

======================== rawer (from filesystem) ========================

'APIC:'                                             type PictureType.COVER_FRONT (Cover (front)) b''
                                     
'COMM:ID3v1 Comment:XXX'                            '10+DC8D0BCDEED7DDF9B28A32A82'
'COMM:iTunNORM:eng'                                 (' 000009F9 00000B99 00005ED5 00008846 0002AAA7 0001C4F5 0000861A 00008A14 '
 '0000E8A7 00002868')
'COMM:iTunPGAP:eng'                                 '0'
'COMM:iTunSMPB:eng'                                 (' 00000000 00000210 000007BC 00000000009702B4 00000000 0088E0D1 00000000 '
 '00000000 00000000 00000000 00000000 00000000')
'COMM:iTunes_CDDB_IDs:eng'                          '10+DC8D0BCDEED7DDF9B28A32A82FC2C14E+12801271'
'TALB' (Album/Movie/Show title)                     'Born on Flag Day'
'TBPM' (BPM (beats per minute))                     '87'
'TCON' (Content type, a.k.a. Genre)                 'ifs-songwriter-rock'
'TDOR' (Original release time)                      '2009'
'TDRC' (Recording time)                             '2009-06-23'
'TENC' (Encoded by)                                 'iTunes 8.1.1'
'TIT2' (Title/songname/content description)         'Houston, TX'
'TKEY' (Initial key)                                '11B'
'TMED' (Media type)                                 'CD'
'TPE1' (Lead performer(s)/Soloist(s))               'Deer Tick'
'TPE2' (Band/orchestra/accompaniment)               'Deer Tick'
'TPOS' (Part of a set)                              '1/1'
'TPUB' (Publisher)                                  'Partisan Records'
'TRCK' (Track number/Position in set)               '5/10'
'TSO2'                                              'Deer Tick'
'TSOP' (Performer sort order)                       'Deer Tick'
'TXXX:ASIN'                                         'B002736YLC'
'TXXX:Acoustid Id'                                  '88c16bc5-8751-450f-93f7-b3cf01096450'
'TXXX:Artists'                                      'Deer Tick'
'TXXX:BARCODE'                                      '723721420253'
'TXXX:CATALOGNUMBER'                                'PTSN005'
'TXXX:MusicBrainz Album Artist Id'                  'c8c64bcc-48c6-47c9-8411-f5c4fd5a97bb'
'TXXX:MusicBrainz Album Id'                         '3be5ca9f-4d9a-4a5d-a8c4-95223f555f74'
'TXXX:MusicBrainz Album Release Country'            'US'
'TXXX:MusicBrainz Album Status'                     'official'
'TXXX:MusicBrainz Album Type'                       'album'
'TXXX:MusicBrainz Artist Id'                        'c8c64bcc-48c6-47c9-8411-f5c4fd5a97bb'
'TXXX:MusicBrainz Release Group Id'                 '81a5fe24-1d0d-4202-9892-8c277ffbc449'
'TXXX:MusicBrainz Release Track Id'                 '88c5fad1-50e8-3d37-a2e7-ba5d22fad1ba'
'TXXX:Q-HAP'                                        '2'
'TXXX:Q-HHRNBTT'                                    '1'
'TXXX:Q-JZFKS'                                      '1'
'TXXX:Q-LOCALNESS'                                  '2'
'TXXX:Q-OLDST'                                      '3'
'TXXX:Q-UNU'                                        '1'
'TXXX:SCRIPT'                                       'Latn'
'TXXX:lastfmtags'                                   ['indie', 'alt country', 'americana', 'folk', 'singer songwriter']
'TXXX:mood'                                         'Not aggressive/Not acoustic/Not happy/Relaxed/Not party/Sad/Not electronic'
'TXXX:originalyear'                                 '2009'
'TXXX:q-bass'                                       '4'
'TXXX:q-busy'                                       '3'
'TXXX:q-chart'                                      '3'
'TXXX:q-drums'                                      '3'
'TXXX:q-grit'                                       '2'
'TXXX:q-mixbeat'                                    '2'
'TXXX:q-other'                                      '3'
'TXXX:q-piano'                                      '1'
'TXXX:q-play'                                       '2'
'TXXX:q-syn'                                        '2'
'TXXX:q-vocals'                                     '3'
'TXXX:replaygain_track_gain'                        '-0.38 dB'
'TXXX:replaygain_track_peak'                        '0.453179'
'UFID:http://musicbrainz.org'                       UFID(owner='http://musicbrainz.org', data=b'95cb50ad-7421-47fc-beef-3c3087a6f7e5')

========================== row from database ==========================
                                              'id'  1267082
                                            'path'  /data/Music/Bulk/00singer-songwriter-eos/Deer Tick/Born On Flag Day/05 houston, tx.mp3
                                         'working'  None
                                         'bitrate'  320
                                    'duration_sec'  224
                                           'genre'  ifs-songwriter-rock
                                        'filesize'  9083941
                                           'mtime'  1642256520
                                   'redo_metaread'  0
                                        'rest_str'   00singer songwriter eos On 05 houston, tx ifs songwriter rock
                                      'tag_artist'  Deer Tick
                                     'tag_release'  Born on Flag Day
                                       'tag_title'  Houston, TX
                                             'bpm'  87.0
                                    'search_title'  'houston':1,2 'tx':3
                                   'search_artist'  'deer':1 'tick':2
                                  'search_release'  'born':1 'day':4 'flag':3 'on':2
                                     'search_rest'  '00singer':1 'eos':3 'houston':5,6 'ifs':8 'on':4 'rock':9 'songwriter':2 'tx':7
                                    'search_combo'  '00singer':10 'born':6C 'day':9C 'deer':4B 'eos':12 'flag':8C 'houston':1A,2A,14,15 'ifs':17 'on':7C,13 'rock':18 'songwriter':11 'tick':5B 'tx':3A,16
                                    'tag_tracknum'  5
                                      'num_images'  1
                                             'key'  11B
                                           'quals'  ['Q-HAP-2', 'Q-LOCALNESS-2', 'Q-JZFKS-1', 'Q-UNU-1', 'Q-OLDST-3', 'Q-HHRNBTT-1', 'q-syn-2', 'q-bass-4', 'q-busy-3', 'q-grit-2', 'q-play-2', 'q-chart-3', 'q-drums-3', 'q-other-3', 'q-piano-1', 'q-vocals-3', 'q-mixbeat-2']
                                      'lastfmtags'  ['indie', 'alt country', 'americana', 'folk', 'singer songwriter']
                                        'tag_date'  2009
                                     'discogstags'  []

============================== file details ==============================
                                           'mtime'  1642256519.8913612  (2022-01-15 15:21:59)
                             'size'  9083941