search

LibraryOfCongress / api.congress.gov

congress.gov API
605 stars 38 forks source link

(bill actions): duplicate actions in unusual order #211

Closed ryparker closed 2 weeks ago

ryparker commented 3 months ago

As of 3/20 I've noticed duplicate actions (sometimes with minor text changes) on many legislation in the 118th congress. They seem to not only be duplicated but the duplicates are often ordered so that they are not siblings of their duplicate.

i.e.

action A
action B
action A (duplicate)

This is also present in the GPO API (https://github.com/usgpo/bill-status/issues/235). Is this a GPO or LOC issue?

e.g.

curl --location 'https://api.congress.gov/v3/bill/118/sjres/9/actions?format=json&limit=100&api_key=<API_KEY>'

Response:

{
    "actions": [
        {
            "actionDate": "2023-09-28",
            "recordedVotes": [
                {
                    "chamber": "Senate",
                    "congress": 118,
                    "date": "2023-09-28T19:22:43Z",
                    "rollNumber": 242,
                    "sessionNumber": 1,
                    "url": "https://www.senate.gov/legislative/LIS/roll_call_votes/vote1181/vote_118_1_00242.xml"
                }
            ],
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Failed of passage in Senate over veto by Yea-Nay Vote. 47 - 46. Record Vote Number: 242.",
            "type": "Veto"
        },
        {
            "actionCode": "35000",
            "actionDate": "2023-09-28",
            "recordedVotes": [
                {
                    "chamber": "Senate",
                    "congress": 118,
                    "date": "2023-09-28T19:22:43Z",
                    "rollNumber": 242,
                    "sessionNumber": 1,
                    "url": "https://www.senate.gov/legislative/LIS/roll_call_votes/vote1181/vote_118_1_00242.xml"
                }
            ],
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Failed of passage in Senate over veto: Failed of passage in Senate over veto by Yea-Nay Vote. 47 - 46. Record Vote Number: 242.",
            "type": "Veto"
        },
        {
            "actionDate": "2023-09-28",
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Veto Message considered in Senate. (consideration: CR S4739-4740)",
            "type": "Veto"
        },
        {
            "actionCode": "E30000",
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Vetoed by President.",
            "type": "President"
        },
        {
            "actionCode": "31000",
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Vetoed by President.",
            "type": "President"
        },
        {
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Veto message received in Senate. Ordered held at the desk.",
            "type": "Veto"
        },
        {
            "actionCode": "E30000",
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Vetoed by President.",
            "type": "President"
        },
        {
            "actionCode": "31000",
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Vetoed by President.",
            "type": "President"
        },
        {
            "actionCode": "E20000",
            "actionDate": "2023-09-14",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Presented to President.",
            "type": "Floor"
        },
        {
            "actionCode": "E20000",
            "actionDate": "2023-09-14",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Presented to President.",
            "type": "Floor"
        },
        {
            "actionCode": "28000",
            "actionDate": "2023-09-14",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Presented to President.",
            "type": "President"
        },
        {
            "actionCode": "28000",
            "actionDate": "2023-09-14",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Presented to President.",
            "type": "President"
        },
        {
            "actionCode": "H38310",
            "actionDate": "2023-07-27",
            "actionTime": "14:13:35",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Motion to reconsider laid on the table Agreed to without objection.",
            "type": "Floor"
        },
        {
            "actionCode": "H37100",
            "actionDate": "2023-07-27",
            "actionTime": "14:13:33",
            "recordedVotes": [
                {
                    "chamber": "House",
                    "congress": 118,
                    "date": "2023-07-27T18:13:33Z",
                    "rollNumber": 381,
                    "sessionNumber": 1,
                    "url": "https://clerk.house.gov/evs/2023/roll381.xml"
                }
            ],
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "On passage Passed by the Yeas and Nays: 221 - 206 (Roll no. 381).",
            "type": "Floor"
        },
        {
            "actionCode": "8000",
            "actionDate": "2023-07-27",
            "actionTime": "14:13:33",
            "recordedVotes": [
                {
                    "chamber": "House",
                    "congress": 118,
                    "date": "2023-07-27T18:13:33Z",
                    "rollNumber": 381,
                    "sessionNumber": 1,
                    "url": "https://clerk.house.gov/evs/2023/roll381.xml"
                }
            ],
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Passed/agreed to in House On passage Passed by the Yeas and Nays: 221 - 206 (Roll no. 381). (text: CR H4044)",
            "type": "Floor"
        },
        {
            "actionCode": "H30000",
            "actionDate": "2023-07-27",
            "actionTime": "14:06:40",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Considered as unfinished business.",
            "type": "Floor"
        },
        {
            "actionCode": "H8D000",
            "actionDate": "2023-07-27",
            "actionTime": "13:00:57",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "POSTPONED PROCEEDINGS - At the conclusion of debate on S. J. Res. 9, the Chair put the question on passage of the joint resolution and by voice vote, announced the ayes had prevailed. Mr. Grijalva demanded the yeas and nays and the Chair postponed further proceedings until a time to be announced.",
            "type": "Floor"
        },
        {
            "actionCode": "H35000",
            "actionDate": "2023-07-27",
            "actionTime": "13:00:09",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "The previous question was ordered pursuant to the rule.",
            "type": "Floor"
        },
        {
            "actionCode": "H8D000",
            "actionDate": "2023-07-27",
            "actionTime": "12:18:14",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "DEBATE - The House proceeded with one hour of debate on S.J. Res. 9.",
            "type": "Floor"
        },
        {
            "actionCode": "H8D000",
            "actionDate": "2023-07-27",
            "actionTime": "12:17:18",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Rule provides for consideration of H.R. 4366, S.J. Res. 9 and S.J. Res. 24. The resolution provides for consideration of H.R. 4366, under a structured rule with one hour of general debate and a motion to recommit. The resolution provides for consideration of S.J. Res. 9 and S.J. Res. 24, under a closed rule with one hour of general debate for both joint resolutions and one motion to commit for both joint resolutions.",
            "type": "Floor"
        },
        {
            "actionCode": "H30000",
            "actionDate": "2023-07-27",
            "actionTime": "12:17:13",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Considered under the provisions of rule H. Res. 614.",
            "type": "Floor"
        },
        {
            "actionCode": "H1L210",
            "actionDate": "2023-07-26",
            "actionTime": "09:32:08",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Rules Committee Resolution H. Res. 614 Reported to House. Rule provides for consideration of H.R. 4366, S.J. Res. 9 and S.J. Res. 24. The resolution provides for consideration of H.R. 4366, under a structured rule with one hour of general debate and a motion to recommit. The resolution provides for consideration of S.J. Res. 9 and S.J. Res. 24, under a closed rule with one hour of general debate for both joint resolutions and one motion to commit for both joint resolutions.",
            "type": "Floor"
        },
        {
            "actionCode": "H15000",
            "actionDate": "2023-05-05",
            "actionTime": "11:12:16",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Held at the desk.",
            "type": "Floor"
        },
        {
            "actionCode": "H14000",
            "actionDate": "2023-05-05",
            "actionTime": "11:03:14",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Received in the House.",
            "type": "Floor"
        },
        {
            "actionDate": "2023-05-04",
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Message on Senate action sent to the House.",
            "type": "Floor"
        },
        {
            "actionDate": "2023-05-03",
            "recordedVotes": [
                {
                    "chamber": "Senate",
                    "congress": 118,
                    "date": "2023-05-03T23:19:48Z",
                    "rollNumber": 110,
                    "sessionNumber": 1,
                    "url": "https://www.senate.gov/legislative/LIS/roll_call_votes/vote1181/vote_118_1_00110.xml"
                }
            ],
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Passed Senate without amendment by Yea-Nay Vote. 50 - 48. Record Vote Number: 110. (text: CR S1500)",
            "type": "Floor"
        },
        {
            "actionCode": "17000",
            "actionDate": "2023-05-03",
            "recordedVotes": [
                {
                    "chamber": "Senate",
                    "congress": 118,
                    "date": "2023-05-03T23:19:48Z",
                    "rollNumber": 110,
                    "sessionNumber": 1,
                    "url": "https://www.senate.gov/legislative/LIS/roll_call_votes/vote1181/vote_118_1_00110.xml"
                }
            ],
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Passed/agreed to in Senate: Passed Senate without amendment by Yea-Nay Vote. 50 - 48. Record Vote Number: 110.(text: CR S1500)",
            "type": "Floor"
        },
        {
            "actionDate": "2023-05-03",
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Measure laid before Senate by unanimous consent. (consideration: CR S1478-1500)",
            "type": "Floor"
        },
        {
            "actionDate": "2023-05-03",
            "committees": [
                {
                    "name": "Environment and Public Works Committee",
                    "systemCode": "ssev00",
                    "url": "https://api.congress.gov/v3/committee/senate/ssev00?format=json"
                }
            ],
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Senate Committee on Environment and Public Works discharged by Unanimous Consent.",
            "type": "Discharge"
        },
        {
            "actionCode": "14500",
            "actionDate": "2023-05-03",
            "committees": [
                {
                    "name": "Environment and Public Works Committee",
                    "systemCode": "ssev00",
                    "url": "https://api.congress.gov/v3/committee/senate/ssev00?format=json"
                }
            ],
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Senate Committee on Environment and Public Works discharged by Unanimous Consent.",
            "type": "Committee"
        },
        {
            "actionDate": "2023-02-07",
            "committees": [
                {
                    "name": "Environment and Public Works Committee",
                    "systemCode": "ssev00",
                    "url": "https://api.congress.gov/v3/committee/senate/ssev00?format=json"
                }
            ],
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Read twice and referred to the Committee on Environment and Public Works.",
            "type": "IntroReferral"
        },
        {
            "actionCode": "10000",
            "actionDate": "2023-02-07",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Introduced in Senate",
            "type": "IntroReferral"
        }
    ],
    "pagination": {
        "count": 32
    },
    "request": {
        "billNumber": "9",
        "billType": "sjres",
        "billUrl": "https://api.congress.gov/v3/bill/118/sjres/9?format=json",
        "congress": "118",
        "contentType": "application/json",
        "format": "json"
    }
}

Notice the following actions where the legislation was "Vetoed by President" twice.

Also the "senate received the message…" actions have two different texts: 1.) "Veto message received in Senate. Ordered held at the desk." 2.) "Veto Message considered in Senate. (consideration: CR S4739-4740)"

{
            "actionDate": "2023-09-28",
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Veto Message considered in Senate. (consideration: CR S4739-4740)",
            "type": "Veto"
        },
        {
            "actionCode": "E30000",
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Vetoed by President.",
            "type": "President"
        },
        {
            "actionCode": "31000",
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Vetoed by President.",
            "type": "President"
        },
        {
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "name": "Senate"
            },
            "text": "Veto message received in Senate. Ordered held at the desk.",
            "type": "Veto"
        },
        {
            "actionCode": "E30000",
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Vetoed by President.",
            "type": "President"
        },
        {
            "actionCode": "31000",
            "actionDate": "2023-09-26",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Vetoed by President.",
            "type": "President"
        },

Also notice how the following actions have been duplicated:

{
            "actionCode": "E20000",
            "actionDate": "2023-09-14",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Presented to President.",
            "type": "Floor"
        },
        {
            "actionCode": "E20000",
            "actionDate": "2023-09-14",
            "sourceSystem": {
                "code": 2,
                "name": "House floor actions"
            },
            "text": "Presented to President.",
            "type": "Floor"
        },
        {
            "actionCode": "28000",
            "actionDate": "2023-09-14",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Presented to President.",
            "type": "President"
        },
        {
            "actionCode": "28000",
            "actionDate": "2023-09-14",
            "sourceSystem": {
                "code": 9,
                "name": "Library of Congress"
            },
            "text": "Presented to President.",
            "type": "President"
        },

Another example HR4366:

{
      "actionDate": "2024-03-06",
      "actionTime": "16:20:33",
      "text": "Conference report agreed to in House Pursuant to the provisions of H. Res. 1061, the House agreed to the Senate amendment with an amendment.",
      "type": "ResolvingDifferences",
      "actionCode": 21000,
      "sourceSystem": {
        "code": 9,
        "name": "Library of Congress"
      }
    },
    {
      "actionDate": "2024-03-06",
      "text": "Resolving differences -- House actions Pursuant to the provisions of H. Res. 1061, the House agreed to the Senate amendment with an amendment.",
      "type": "NotUsed",
      "actionCode": 19500,
      "sourceSystem": {
        "code": 9,
        "name": "Library of Congress"
      }
    },
    {
      "actionDate": "2024-03-06",
      "actionTime": "16:20:33",
      "text": "Conference report agreed to in House Pursuant to the provisions of H. Res. 1061, the House agreed to the Senate amendment with an amendment.",
      "type": "ResolvingDifferences",
      "actionCode": 21000,
      "sourceSystem": {
        "code": 9,
        "name": "Library of Congress"
      }
    },

Here are the legislation i've encountered this issue with:

118th congress

rbram commented 3 months ago

Hello. We aware of these duplicate actions and we are working to have these fixed soon. We will let you know when the work is complete.

ryparker commented 3 months ago

Any updates or info on the scope of this bug? Does it only effect 118th congress legislation?

apreiter18 commented 3 months ago

Hi @ryparker - We are still working on this and will let you know when work is complete. This issue is only impacting the 118th Congress. Hopefully, I will have more updates soon!

apreiter18 commented 3 weeks ago

Hi @ryparker - work has been completed on this. Can you confirm things look good on your end and, if so, close this issue? Thanks a bunch!

ryparker commented 2 weeks ago

I've verified that the duplicated actions have been fixed on the congress.gov API. Although the GovInfo API still has this issue.