PATSTAT autumn 2016 checksums

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Rachie
Posts: 14
Joined: Mon Nov 16, 2015 2:13 am

PATSTAT autumn 2016 checksums

Post by Rachie » Sat Nov 26, 2016 4:37 am

Given how some users have had trouble with corrupt data when copying over the USB drive, it's extremely important to include checksums on the data. These are not listed anywhere I can find, so I created my own. There's no way for me to know if my files are completely valid, but it should at least illuminate any errors.

Patstat authors, please include checksums in all future releases.

I generated the checksum file with this command:

Code: Select all

sha256sum *.zip > checksums.txt
The files can be checked with this command:

Code: Select all

sha256sum -c checksums.txt
Here is my list of checksums for the 2016 autumn dataset:

Code: Select all

1ebb01899f5683b3e679a1f461f709970d4073118388fdd5f8d30bbb4ec09c22  tls201_part01.zip
8f1aa588175d2892887177ce6b69c84736e87656bcfca1c9cf1f55c09480c881  tls201_part02.zip
339d6de2041255511f0cedb31be7de245ea137ac014de080763f700828109970  tls201_part03.zip
92018f3329ae2de671c20757b5e5b572b4166b05cde7c8f2978404ed09252a15  tls201_part04.zip
8e67451dc84474101a8d79b3023ac024f0011a0687587aa42970647a8e281842  tls201_part05.zip
56190af2a9e5fcae2614f3a8043ff1a5a2ed6090651e0208979c87fa2b6c35aa  tls201_part06.zip
ef049b7d1af4abe88c7cf3e1a9893ba3283d921f01a0d0b81f49c3fe18dcf23b  tls201_part07.zip
25416a696b524d5b3706dfc4357f0104319dd525e616b3a502868d11aa51ca3b  tls201_part08.zip
0626284ec70bc3da8de6830ed2d50fbb6aa770b87d84ed0523f01271e3d0ddfd  tls201_part09.zip
347877116f6909c19ece0e3c957ff9cae8f4980cab458c0aecf6fe5e90e56cd1  tls202_part01.zip
1b1cbb665c8cd827238c9a76f97a0a29cc46f00500479cd3f3e9f1e1739067d2  tls202_part02.zip
0106e85051aa50d32b0c0da8756713da9ce2632154030af274afa47b96d605e1  tls202_part03.zip
28a0876ffb0ae71fbbdaf71ef46907a8077a0ec11f281241413cc10166622f81  tls203_part01.zip
6350443ac75742cefcd9f5c35381e6e1f9e8b18c1a57d22c96848777f66b901e  tls203_part02.zip
d88bf16c2455ab2b5b888b7c03bb4cf907c2fbb13dc9ffb5dd86b1c74e5f5142  tls203_part03.zip
f369bfa842da35a29064114a0c0ccb96e3506f83f438aa7568d14ec2e23cd6e9  tls203_part04.zip
0e67755125dafb62c6b12f7890e19c922fe36a83d43b74b183557503cc8645b0  tls203_part05.zip
340b0195ce5d9865992e93d124766c8102d572d1ffbb69e1368c4e24f7676c00  tls203_part06.zip
b49553371934a104fd8bbf0e21758793c99ee9d438f8766f4162603d0f6016f4  tls203_part07.zip
1bda251c0a845abdc3d2b9f000b259c1d5a715e3874b58b52d603ca4f0c5facc  tls203_part08.zip
991172d8e531c1c55e8fa63890204ffdd97578b3e6807e12b4f480c57d3592cc  tls203_part09.zip
0f46600cbbf06fe6ece856df1f8d504bb7dcd1159b059b7e732cdfed3aa9ce56  tls203_part10.zip
52fe8fd8458cdeb66d6503dbd08bcc315f195ffcfe38ee21814818cfcaae5517  tls203_part11.zip
d68321ee8e04421fed8aa5b1c077f14c3b8876fb80ab979a6151441c2c5b67d5  tls203_part12.zip
8410b6ea06ea2ac3b289f728691ea615ac43d5808a2830304653f93fdf04f3d8  tls203_part13.zip
808daa010ee3c805bc6bd7c5a60a2898a151aff455dfb7a7b1c7b53f6e854bff  tls203_part14.zip
4ffb70e8d911d58732ba122c2271d5728af071f1e5fe8f68f0a18d635a75a67c  tls203_part15.zip
796412ad6b6c23afd5c8bb36b38dda19b7d324f49ff51ff293317e2e3610f3b7  tls203_part16.zip
ae9cb75ce040630965eda04b53aef030ff42bb72bf648f9f6067c6da0ef3b283  tls203_part17.zip
e1ea679589ccc93932da8a573cb8346ae647baeb6f1c1c5d59ddb4862f6b2bb7  tls203_part18.zip
509ec9006206a3ab3a83e82d47715c90f5ab2810c9bffe6553aa4239969289a2  tls203_part19.zip
ed5434da377274f99abae387a277b72d287c9ccbb4594cb6960e2d1bddf38578  tls203_part20.zip
292d0269a0a4a0610c0547876122ddc748545018394c66dc1a0bb239742d6271  tls203_part21.zip
42f30566db2d2a40ae65a3fd4a4ebf511d14ad15f74c29588f64eb9b560cd1fb  tls203_part22.zip
4952d7892fd0b774194a393cf27c1f5b2dc931ecf0ab74c5e19ae1f256086fcd  tls203_part23.zip
e4d890dac2646b3514f0dc46655b1d2bdcb55bff391c7b8d8a02c38003278f7f  tls203_part24.zip
26ecd19d0ba7f7f30f33de74dbe9a2aa0e9d5fa859eb1e05f8f85c4a2e2d26b4  tls203_part25.zip
88a480b0a225e504aa6a369388d8fbc4d89cebc4dfdcff4fa28aa8d9b844636d  tls203_part26.zip
a0672a9fbae1496bc2a0b91217a7f5f6c6ccc4d77ae90619c4365524eec35f34  tls203_part27.zip
1e10f21951abd7a0931397c474ee404800c6e654292eadbf1879a24c29a58a77  tls203_part28.zip
dfb467ff08c2f86216f35dc8262e95a1a7448a639554a402c5b6cf4cc4db1db7  tls203_part29.zip
29bb867276afe350111412e6136088f6d232fc2b4a5834d0fe8aab6b918d43c7  tls203_part30.zip
9822d39e60fee368534dc8a73fd15cfba078dc25b0aff6ee03f12e058969b360  tls204_part01.zip
0d1721cd359233062e2abdac7ce81a9facee2244ccbe46c3ce101232e6cd15d7  tls205_part01.zip
2985ceb8dba7b601be81bf43d4ade861a727ac28b70c7a79ccf25d4db5376f21  tls206_part01.zip
88adde306da0ba4dfc056242ff9d3dc028ab78302755da3675bd192cd6635e76  tls206_part02.zip
91d0e12a4686b869bf06059c1ffc5dbce40861a1b5b3b0d8e51bf5c120019615  tls206_part03.zip
236963414a8e97f2b8c950c70ace1bc029267eb145b3da6fd9f947d7258eb599  tls206_part04.zip
3e6cb979694625017d68be9254bcce1508f16bc8aad831ba2d4df6ce446b7855  tls206_part05.zip
b23707459ba585afad3bcf8f9795497983647b429e2089b3ab0c2e985ae7b768  tls206_part06.zip
96dcb0b7e36762ef6d5806aa82d815e5bec0512440a5eff3d8797a2ebead516e  tls207_part01.zip
bb75b320414f71cd03e2c383ce3e63566e3d139fd0faff862774c1cc92879bba  tls207_part02.zip
02882e3095ab097a8a854e2a4d6f5db995115b99370c2f95bcbbda26c4a23e56  tls207_part03.zip
a49d577435f5ad383faff5a82a10dd91f72c82d5fcc179cd095c6df3b36f4179  tls209_part01.zip
cc7d3f66058561c00101279d3bcbcdf8147faafe3b9dd2587c12961bef6349b0  tls209_part02.zip
faa81db4b05daa1e2644e03c66f3851f09e342744b9905adaabe9942558d35d4  tls209_part03.zip
5c6d67117d5b93c75d5242def73ea1c20224a2fcb879ccf86989d13db253da63  tls209_part04.zip
2d482446788b267631150e7ee29ecfba0ecf28dec62451077db2327b0386c495  tls209_part05.zip
092bb519a796f13daf38afc5ed85160ffc9cd9ce6f662c8fc7639ef834e529f0  tls209_part06.zip
a701df9b90e153e6eb290590e09baa5807d719d5dc009a8e9145f0ff534a601f  tls209_part07.zip
267ed6bc79607fc9e0a5ee27eab8f1eed4c4cedb6f2bb57462ee0b22477e6dbf  tls210_part01.zip
7a7749f6349db614021aa86e25a1bbb576a5e37ba959e1011d994fa25be6ff6b  tls211_part01.zip
7c91e423c805d0d893197f22bd4440c7e636a53f2ce45b92374277c094d9b2b6  tls211_part02.zip
9e4e15fe9c41ba770c6c488d21055c83822dc9e1937b94514200b56ea57e7ddf  tls211_part03.zip
8a4ce2a9ccad264a2477ab6b9ab6ba709048d80a78d076cdf6ba9f49f9c853f8  tls211_part04.zip
28aab039d33ffa2def3f9714427493bb1a17f30c351383a3eeae1d4b61d2c8dc  tls211_part05.zip
7729370d74b5ef2cb40f4bf801b197f2a39b97fe66e59aff73cb7f6b09b34e2c  tls212_part01.zip
18658048bc6982e95a29dac03fc5e3c69c8a7d9f60bd888f4956d6c69aadb53e  tls212_part02.zip
b3ea85986470656396d50b3fdf437152bd017285a329750ad381b3e375049d74  tls212_part03.zip
a361c193fd9c33a8474ddaa0654456c828bbeac376131e75bdc1f87754e5ec6c  tls212_part04.zip
c5531b78df396d68769cd42e0f127e8e20c578e09e4b7b7c572f14978673aea9  tls212_part05.zip
db5114fd5c43bd822082171f920f65daf58bf81cd7544d50a01a51d967f979e6  tls212_part06.zip
04d0d0c160232e897c6ac6369142e9b674e827f51c34b966bcd15b48d7a9bd34  tls212_part07.zip
c8b8dc1e1bc8cbe917e81fe2bee640fd7693a2e2f5e5652aceeea49e59c876c0  tls212_part08.zip
e5514a0a50bdb11cf8285d3c08adb761222a5661f7d528ca2c26023f7cbc7d70  tls212_part09.zip
8c591d2a091d2e4613027f21c267ef722a712e49028edc61afaa9ed309c88bf5  tls212_part10.zip
e801c1e5652feddff88e51f9b5804df6a08e3eb71b5fcd29eeb33c5f364e100d  tls214_part01.zip
b439d3516ddc9f43251caf0fc59cc3ff6762dbf19373e63a9e29641248ca08b2  tls214_part02.zip
015bb8f09724153f383c4ac0ba34dba15d083456cd443df4065cfe638e606e1a  tls214_part03.zip
59a098227e945591852593c3d790f9c236a278c292e5754f7bf997244aedc8e7  tls215_part01.zip
2d5b6531dafe92a8bdbc65fcfaf726cd72a710f2c7c2166e45336417ce95c30c  tls216_part01.zip
7d5b5b37719e0bb48310b85353d531b9faad1223742e20c883e871ca6eb8d053  tls221_part01.zip
19cda5d7cf0e8caeeb3125028480aa7f90f2a55315161441c1186ba7e6beb8f6  tls221_part02.zip
51a16a2a348f9fde2714160f6b6f8bda058f8f9a9df151f53038a645ba5fa9f9  tls221_part03.zip
f4a9703c97e991f06bd1a5b6e9d1920a0dd20a7c215086f31492dae055d9b931  tls221_part04.zip
674a45434269bd1d205f93ae3e4ea3ee1a0a1bf1246132eeb204fceafea1a8f0  tls221_part05.zip
97b0d41b79ce758151391cb0676782012a30c67ddfa919c07d922a172c7e0af4  tls221_part06.zip
70da1e381443fd6d2dcddf570d72984dd34d0b93da3ff06fd844f1037f2e9844  tls221_part07.zip
9644c0482dc4888d465caf699c07d2583f507d259c381bf209fbb37ea57924e2  tls221_part08.zip
b5d9c4e9f16fc0ae8b66a2545004d8b294306f9fd97bacef0391917e270b0b5a  tls221_part09.zip
0e70a8f41428dd787ce12ff3108d2d2b182796bbede406c188ba49fb6d977695  tls221_part10.zip
a4ff498e667064dd987fbf70c6e4b81ba3a7a2b0ea5155e0364e3a41b1f235f1  tls221_part11.zip
44f21a87ae491c2809e570bddde2e8a07801bf5d538d4d8019d54ed7d8b9703a  tls221_part12.zip
0d18eaf08d30c4105c22d6e4a95598b6bad4bffe072c2879b11991d453d9eded  tls221_part13.zip
812eb5086639b233bb4da27ae465fddaee6a45986db44544c4a290aaca888050  tls221_part14.zip
fde3463b06005ee84e11558f0a8311160cc78636cdf9e960367f0c4e225fd7d9  tls221_part15.zip
05055d12a2ac3acc6fb79f1bd4d5d37dc5c44e59a48088bc67cba0122c992a5f  tls221_part16.zip
5a328319864ab03c5d92f27db0a5562ded5abb69c24aa0e68729c1b874de7e46  tls221_part17.zip
7205c5cab6efa54c383701ade50e2b955d4e6ddf13a87496b4199e1675f533d0  tls221_part18.zip
45f72674effe40d802728120b01ff2e8cd86093f5a10664e439bcb811d668ceb  tls221_part19.zip
532aab799fe0ca6f60d97a0cd666278ec6d41f1f80462429fef06a28779e28c5  tls221_part20.zip
7ef9ba2eaf46350267a876b9d4f6f72a72977c4e1718719dcdc90a2e60c2871f  tls221_part21.zip
378b8ec338970aab9ee93a5c5355764ccbdee5162b6d0e6936425130efb0896b  tls221_part22.zip
58c84d09e779b1a842fa329f2d405760443cafcb795a547ca69c1ba5fa45bf6b  tls221_part23.zip
1c3d710b82be8321035dd5b44ee72f3fb51cf7723d1d9bbf7185110ab55599f9  tls221_part24.zip
93e533d8aa052b0805d17909d4a978dfb7d258ba70062c0b77adefb755a83ddc  tls221_part25.zip
f84d4f1b11dc90f0036121a01b71dc650f3b961d04a2e47d98da55e672b20768  tls221_part26.zip
e2b67d899a1454e9fae72a1f12c9698d39b655e384aee24c5e216434b7133dc9  tls221_part27.zip
ccf1c98d1df12d713b84a3d6749d44cb1ba0855ad92075035773a5a2dd0f105e  tls221_part28.zip
0ce116101089f96c0b62f76c650ec223071e705d7b6db1d1825c5c7378d95266  tls221_part29.zip
e3d2915fff93a9e2a732371105d086e5b2dd0646605c90dc7e496cf34564fb66  tls221_part30.zip
58d21d9c348d2de218d6b214925097710cc20d2eabc37b8729ce48d9db954c3e  tls221_part31.zip
47e8ee2592a5350af8b9ff56ffa09cedb3325db3f22aabab81973067ac183799  tls221_part32.zip
7537711ca7fd147c3ec1f8b8f55f6fb0a89559ed1bbbd8977a78412b98f6459a  tls221_part33.zip
d274f1746fac17c1fad6133bdec843a0996ab53d5a4da2339a01184fb4a5db16  tls221_part34.zip
e03dff603cc872ece358fd3a1330908325915450fa53a787961642988ccfbd6d  tls221_part35.zip
f9d7487b1160d63b42ffee0f84304543e42477179731b5f409a1d55d7cc0e645  tls221_part36.zip
4dd251a7003dedb7001042b35a21229ef46d0540656a422409b8d190943288c8  tls221_part37.zip
7bf7c4b2ffa43b484f0b9dde2331c3754663669b78040bb98dd6bd9107f107a2  tls221_part38.zip
56e5aaac2b54eeb180b0956f366c9bcb17dc376c7a3baab7e0d72145fd870275  tls221_part39.zip
7a62d3bf4ad909efd849d4f29459f2d7a774df5d2084d22affd29f0c18e09c27  tls221_part40.zip
4a087e028f4577ea552daf1565d8f9a821bb69d568955a6c1e747295633a8401  tls221_part41.zip
96131e4e123d5effcdd0d4f35481b5f59563a64a7f3c0281d0cfb78c6f122654  tls221_part42.zip
b30bf9d3129b38b120445db0fd1710c73e990c075f0c2ce05d31eb96f1588f0c  tls222_part01.zip
83f3a6ea0802d93f7fd98658114b99eed5a16ae2b1c918440b2818d0768972c6  tls222_part02.zip
39736f053a1161e134d9e80cec1305778ae8bf5db939429c1755e4b5905d21cc  tls222_part03.zip
e146fa3093ad34bfab86166802f2cbbd6a92030f82833f1fd52cb4739655ca3a  tls222_part04.zip
a057813809b7552187f470a67e8d58e3e0b6856a91860cd58f2b30f4b8e48a1e  tls222_part05.zip
22f84c39910a6274736add8893a24a7fe0f9e07bfbf6c413cc4c7e7354d10aed  tls222_part06.zip
5423f19555760daa4815e36a647bcb1a3258cab70e2f2f5b5a4bf0aaa272a361  tls222_part07.zip
2805569a01cceadeb25c504d0b3dcf813bf0a111784c0d744547b7780c7f5bd8  tls223_part01.zip
7ea60d8f457834de0a3871c27f92b8d33999e7120f155f28a2c19008aa281ed6  tls224_part01.zip
deaabf1a2fe34af1a3944c722d9fd7299d1e3f37bf7b3f6bfe757cb2ecd71c25  tls224_part02.zip
9ae40c3b597bf2f5d386ec5cda650007fcd71eef9389c4f9051dca217b7402eb  tls224_part03.zip
8dbeaa46819a6ffc24724758a08f515677d1133328fbf5366d9ac04448fead95  tls224_part04.zip
aa535c2abd385dcd853fdffc0e424ec90302729797ccdae6abfa3cfc151cfa10  tls224_part05.zip
b59a837c2810a763a5e151b3d52eb074bab3a1a58c626c39d93714b7c211f797  tls224_part06.zip
af08ed411b92b592daf1c82de7add4beef9466ab3bd99369342b19c3d453a558  tls224_part07.zip
d720ee6035c39da5c74e72c2ea088501c7accaef3142b17d47bcc55af2edfa7c  tls226_part01.zip
f60d223509ce0a64e4ca34c0bb253e70df8b0ad135a88a7fd107b925f8648c20  tls226_part02.zip
88b8bb07657e6a543de5c66d9c96d7db7878e6e0003d52c799999e01eb98d215  tls226_part03.zip
d4829016a351452d1813b732fc4774bef5dd894e2ecf6d735c876ee9291070bc  tls226_part04.zip
d426d3adf5411de3306582abec940747630bcb3e060aab9d761d4199686149e9  tls226_part05.zip
d574b3fc3593ecfa2f506a56269d97bf32a4f340c25d936e7f24f52d760da0e0  tls227_part01.zip
3cb7993f0c24daa2267fd3701d8386cf15436d1e54aebc37ebe4d55d0b3afadf  tls227_part02.zip
873189484b052617bdaada4918468df5bdcbd0b7a3aae1f7252a38e100a5b1b3  tls227_part03.zip
aefea2215706d95a55c29626929e986ce58cb3bd25643b5c2ac6a7aba0eab74f  tls228_part01.zip
6297cdb6f883c30b3c71475175575d9d62358befca24eee16267dbcb5fd566db  tls228_part02.zip
97ca0d447adf1e41af61083af50efe38aca78f7916e8485766a7ad0ce82a7816  tls229_part01.zip
63a9c23930f805c7cb060b0947623df2864a196daa61900f55fcf26aefb56731  tls229_part02.zip
7159bed65065beaf926270222eed766e5befef106f091cafb995909323d47a70  tls229_part03.zip
ed5e698ab2a9252a954761e2a4dd3534bc8c64b8ccfecec70e669b363c1b20da  tls229_part04.zip
fdf2a4f13f689c3d11ffa146f2bab7ce6b2e04f9afee902b421656135f92331c  tls230_part01.zip
3c577f273cedd40d3e64a7846ef17eff45cdbae2187801904dbb1fbc1c9fce5c  tls230_part02.zip
ca85a4fb1dde90c71dc52a86cdcd90d1a444b5a6a087281b16d55fc75cfb6987  tls230_part03.zip
d797ee93e54845411f223ad25a57654909e9f733656fdf1b3e0077e39dd18587  tls230_part04.zip
78c4f91aedf7d97ab77565403d6a8210c9118c896c835cd620989a5201569eea  tls801_part01.zip
8e8e9f957fc71d72d8c809e6f6f1fe1c683c24aac86ce23558d703bcf979603d  tls802_part01.zip
4a79d2181a9d977544c36acc74888ffa16c5f89996769aca294d9b0bf8091fe1  tls901_part01.zip
3edbcb8ec3bd935f424408bd17771a0f160b127a45861e98c0b9ec2784e945b7  tls902_part01.zip
daed9f25c071d68de6226a299c85fe4e9ff6b630a21aad9a9131f4ef95ee8c08  tls904_part01.zip
f7cce0bc61211e3184ba76d568a321378bace15b8e9d7c8d3d69470233b5903d  tls906_part01.zip
622c859b647a5170a333bc881f8906bb67d6ae577b3ab8823aeb742eb37b01cd  tls906_part02.zip
889178a5f4fe871188fd14340739c54b121d2a79dff9fc4616e27e60dacd5794  tls906_part03.zip
41dad54b27419d92a237147806cff162581c1808bf24bd87aa8a6e1ec26df854  tls906_part04.zip
f0348b51ef64d08eb923027662ee87da24dd10455a14867cc7b510acd4635942  tls906_part05.zip
5b474dab3806abb8abff77d94bb4ee5f8a2c0d02ed440db8e1ec65d63be6fb57  tls906_part06.zip
Last edited by Rachie on Sat Dec 24, 2016 7:59 am, edited 1 time in total.


mkracker
Posts: 120
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: PATSTAT autumn 2016 checksums

Post by mkracker » Wed Nov 30, 2016 4:57 pm

Dear Rachie,

The problems with the files delivered on USB memory sticks which affected some users were due to the file system used (NTFS). Consequently we will change the file system to FAT32 for future deliveries.

For the download from our Raw Data Platform we already provide a checksum. And as you proposed: Starting with the 2017 Spring Edition we will also add a SHA512 checksum with the USB memory delivery.

Best regards,
Martin
EPO / PATSTAT
-------------------------------------------
Martin Kracker / EPO


Post Reply