Information in the uploads database of CPAN Testers

uploads.txt

mysql> select * from uploads limit 10;
+----------+------+---------+---------------------+---------+------------------------------+------------+
| uploadid | type | author  | dist                | version | filename                     | released   |
+----------+------+---------+---------------------+---------+------------------------------+------------+
|        1 | cpan | LREEVES | DBI-ResultPager     | 0.9.0   | DBI-ResultPager-0.9.0.tar.gz | 1131570943 |
|        2 | cpan | LREEVES | DBI-ResultPager     | 0.9.1   | DBI-ResultPager-0.9.1.tar.gz | 1132078122 |
|        3 | cpan | LROCHER | Win32-GUI-Scintilla | 1.7     | Win32-GUI-Scintilla-1.7.zip  | 1077985028 |
|        4 | cpan | LROCHER | Win32-GUI-AxWindow  | 0.07    | Win32-GUI-AxWindow-0.07.zip  | 1078429322 |
|        5 | cpan | LROCHER | Win32-GUI-AxWindow  | 0.06    | Win32-GUI-AxWindow-0.06.zip  | 1069510585 |
|        6 | cpan | LROCHER | Win32-GUI-DIBitmap  | 0.13    | Win32-GUI-DIBitmap-0.13.zip  | 1070995846 |
|        7 | cpan | LROCHER | Win32-GUI           | 1.0     | Win32-GUI-1.0.zip            | 1100277300 |
|        8 | cpan | LROCHER | Win32-GUI-DIBitmap  | 0.14    | Win32-GUI-DIBitmap-0.14.zip  | 1077984704 |
|        9 | cpan | LROCHER | Win32-GUI-Grid      | 0.06    | Win32-GUI-Grid-0.06.zip      | 1077984916 |
|       10 | cpan | LROCHER | Win32-GUI-Scintilla | 1.6     | Win32-GUI-Scintilla-1.6.zip  | 1070200125 |
+----------+------+---------+---------------------+---------+------------------------------+------------+
10 rows in set (0.00 sec)

mysql> select * from uploads where type != "cpan" limit 10;
+----------+---------+---------+-----------------------+---------+-----------------------------------+------------+
| uploadid | type    | author  | dist                  | version | filename                          | released   |
+----------+---------+---------+-----------------------+---------+-----------------------------------+------------+
|       11 | backpan | LROCHER | Win32-GUI-AxWindow    | 0.6     | Win32-GUI-AxWindow-0.6.zip        | 1069509145 |
|       20 | backpan | LLAP    | Text-vCard            | 1.7     | Text-vCard-1.7.tar.gz             | 1097698046 |
|       21 | backpan | LLAP    | Text-vCard            | 1.99    | Text-vCard-1.99.tar.gz            | 1156935176 |
|       22 | backpan | LLAP    | Text-vCard            | 0.9     | Text-vCard-0.9.tar.gz             | 1057595716 |
|       23 | backpan | LLAP    | Text-vCard            | 1.96    | Text-vCard-1.96.tar.gz            | 1120416057 |
|       24 | backpan | LLAP    | SOAP-XML-Client       | 1.9     | SOAP-XML-Client-1.9.tar.gz        | 1148904285 |
|       25 | backpan | LLAP    | SOAP-Lite-Simple      | 1.4     | SOAP-Lite-Simple-1.4.tar.gz       | 1130338583 |
|       26 | backpan | LLAP    | SVG-TT-Graph          | 0.08    | SVG-TT-Graph-0.08.tar.gz          | 1108112947 |
|       27 | backpan | LLAP    | Text-vCard            | 2.00    | Text-vCard-2.00.tar.gz            | 1161419367 |
|       28 | backpan | LLAP    | Apache-AuthCookieNTLM | 0.04    | Apache-AuthCookieNTLM-0.04.tar.gz | 1068213163 |
+----------+---------+---------+-----------------------+---------+-----------------------------------+------------+