Duplicate entries in database, Table III C

[MostlyHarmless420]

I was experiencing anomalies querying the publicly available treasury.io SQL database. I discovered they originate because there are duplicate entries in the database in Table III C on these 5 dates.

The dates are:
2014-3-31
2014-5-30
2014-7-30
2016-2-08
2016-2-29

I do not know if other dates or tables were afffected

[cezary4]

Thanks Shaun. Can you give us an example? Is it individual line items or
all entries for any given day?

Cezary

On Tue, Jun 21, 2016 at 11:50 AM, ShaunBristol [email protected]
wrote:

I was experiencing anomalies querying the publicly available treasury.io
SQL database. I discovered they originate because there are duplicate
entries in the database in Table III C on these 5 dates.

The dates are:
2014-3-31
2014-5-30
2014-7-30
2016-2-08
2016-2-29

I do not know if other dates or tables were afffected

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#202, or mute
the thread
https://github.com/notifications/unsubscribe/AC28VaAJFIVcWvvrkN3ZuPdufCsCpMD9ks5qOAgtgaJpZM4I644y
.

Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com

[MostlyHarmless420]

It seems to be all entries on those dates in the table. I verified using the treasury.io query builder and I get two identical rows for each item (There is usually only one for other dates).

Using the SQL command:
SELECT *
FROM
t3c
WHERE ("date" == '2016-02-08') AND "item" == "Intragovernmental Holdings"

returns 2 rows when I expected 1

[cezary4]

That'a strange. There must be some new wrinkle that appeared in the text
files that day which the parser did not pick up. I will investigate. Thanks
for flagging and let us know if you spot the issue for other days as well.

Cezary

On Tuesday, June 21, 2016, ShaunBristol [email protected] wrote:

It seems to be all entries on those dates in the table. I verified using
the treasury.io query builder and I get two identical entries for each
item (There is usually only one for other dates).

E.g.
SELECT *
FROM
t3c
WHERE ("date" == '2016-02-08') AND "item" == "Intragovernmental Holdings"

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#202 (comment),
or mute the thread
https://github.com/notifications/unsubscribe/AC28VdBL1FLtKms1O455hNfGPmVRbmJRks5qOBDngaJpZM4I644y
.

Cezary Podkul | @cezary
Mobile: (708) 228 1319
Web: cezarypodkul.com