How to tell which repositories provide which packages?

[Ralf Mardorf]

On Wed, 6 Jan 2021 08:17:48 +0100, Ralf Mardorf wrote:
>Another idea, only listing the package names and nothing else, assuming
>the Ubuntu flavour installs are x86_64 only nowadays.
>
>One package per line...
>
>[weremouse at moonstudio ~]$ dpkg -l $(awk '$1 == "Package:" { print $2
>}' /var/lib/apt/lists/*webupd8*amd64_Packages) 2>/dev/null | grep ii |
>awk '{print $2}' | sed 's/:amd64//g' audacious audacious-plugins
>audacious-plugins-data
>libampache-browser
>libaudcore5
>libaudgui5
>libaudqt2
>libaudtag3
>python-twodict
>youtube-dlg
>
>...or all packages by one line
>
>[weremouse at moonstudio ~]$ echo $(dpkg -l $(awk '$1 == "Package:" {
>print $2 }' /var/lib/apt/lists/*webupd8*amd64_Packages) 2>/dev/null |
>grep ii | awk '{print $2}' | sed 's/:amd64//g') audacious
>audacious-plugins audacious-plugins-data libampache-browser
>libaudcore5 libaudgui5 libaudqt2 libaudtag3 python-twodict youtube-dlg

"grep ii" is fishy, since a package tagged with "un" could include "ii"
in it's name:

[weremouse at moonstudio ~]$ dpkg -l $(awk '$1 == "Package:" { print $2 }' /var/lib/apt/lists/*webupd8*amd64_Packages) 2>/dev/null
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                                      Version                   Architecture              Description
+++-=========================================-=========================-=========================-========================================================================================
ii  audacious                                 3.10-1~webupd8~xenial0    amd64                     small and fast audio player which supports lots of formats
ii  audacious-plugins:amd64                   3.10-1~webupd8~xenial0    amd64                     Base plugins for audacious
ii  audacious-plugins-data                    3.10-1~webupd8~xenial0    all                       Data files for Audacious plugins
ii  libampache-browser:amd64                  0~git20160805-1~webupd8~x amd64                     Ampache desktop client library
un  libaudcore3                               <none>                    <none>                    (no description available)
un  libaudcore4                               <none>                    <none>                    (no description available)
ii  libaudcore5:amd64                         3.10-1~webupd8~xenial0    amd64                     audacious core engine library
un  libaudgui3                                <none>                    <none>                    (no description available)
un  libaudgui4                                <none>                    <none>                    (no description available)
ii  libaudgui5:amd64                          3.10-1~webupd8~xenial0    amd64                     audacious media player (libaudgui shared library)
un  libaudqt0                                 <none>                    <none>                    (no description available)
un  libaudqt1                                 <none>                    <none>                    (no description available)
ii  libaudqt2:amd64                           3.10-1~webupd8~xenial0    amd64                     audacious media player (libaudqt shared library)
un  libaudtag2                                <none>                    <none>                    (no description available)
ii  libaudtag3:amd64                          3.10-1~webupd8~xenial0    amd64                     audacious media player (libaudtag shared library)
un  libvdpau-va-gl1                           <none>                    <none>                    (no description available)
ii  python-twodict                            1.2-1~webupd8~xenial0     all                       Simple two way ordered dictionary for Python
ii  youtube-dlg                               0.4-1~webupd8~xenial4     all                       youtube-dl gu

So far the best solution still is

apt-cache policy $(awk '$1 == "Package:" { print $2 }' /var/lib/apt/lists/*webupd8*amd64_Packages) | grep -v "Installed: (none)" | grep "Installed: " -B1