search

LibraryOfCongress / api.congress.gov

congress.gov API
601 stars 38 forks source link

(daily-congressional-record): sort by `updateDate` #223

Open ryparker opened 3 months ago

ryparker commented 3 months ago

The daily-congressional-record list API currently returns items that are not in any particular order (that I recognize). It would be ideal if there was a sort option, but at the least it would be helpful for caching purposes if all list APIs sorted by updateDate.

e.g. Request first 60 records:

curl --location 'https://api.congress.gov/v3/daily-congressional-record?format=json&limit=60&api_key=<API_KEY>'

Response:

{
    "dailyCongressionalRecord": [
        {
            "congress": 118,
            "issueDate": "2024-03-26T04:00:00Z",
            "issueNumber": "52",
            "sessionNumber": 2,
            "updateDate": "2024-03-27T21:15:12Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/52?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-22T04:00:00Z",
            "issueNumber": "51",
            "sessionNumber": 2,
            "updateDate": "2024-03-23T18:45:11Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/51?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-21T04:00:00Z",
            "issueNumber": "50",
            "sessionNumber": 2,
            "updateDate": "2024-03-22T15:00:22Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/50?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-20T04:00:00Z",
            "issueNumber": "49",
            "sessionNumber": 2,
            "updateDate": "2024-03-21T12:45:13Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/49?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-19T04:00:00Z",
            "issueNumber": "48",
            "sessionNumber": 2,
            "updateDate": "2024-03-20T11:45:13Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/48?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-15T04:00:00Z",
            "issueNumber": "47",
            "sessionNumber": 2,
            "updateDate": "2024-03-16T09:00:20Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/47?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-14T04:00:00Z",
            "issueNumber": "46",
            "sessionNumber": 2,
            "updateDate": "2024-03-15T09:30:29Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/46?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-13T04:00:00Z",
            "issueNumber": "45",
            "sessionNumber": 2,
            "updateDate": "2024-03-14T09:15:16Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/45?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-12T04:00:00Z",
            "issueNumber": "44",
            "sessionNumber": 2,
            "updateDate": "2024-03-13T13:15:15Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/44?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-11T04:00:00Z",
            "issueNumber": "43",
            "sessionNumber": 2,
            "updateDate": "2024-03-12T13:00:25Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/43?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-08T05:00:00Z",
            "issueNumber": "42",
            "sessionNumber": 2,
            "updateDate": "2024-03-09T13:00:23Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/42?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-07T05:00:00Z",
            "issueNumber": "41",
            "sessionNumber": 2,
            "updateDate": "2024-03-08T13:15:13Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/41?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-06T05:00:00Z",
            "issueNumber": "40",
            "sessionNumber": 2,
            "updateDate": "2024-03-07T12:45:13Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/40?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-05T05:00:00Z",
            "issueNumber": "39",
            "sessionNumber": 2,
            "updateDate": "2024-03-06T20:00:22Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/39?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-03-01T05:00:00Z",
            "issueNumber": "38",
            "sessionNumber": 2,
            "updateDate": "2024-03-02T09:30:23Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/38?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-29T05:00:00Z",
            "issueNumber": "37",
            "sessionNumber": 2,
            "updateDate": "2024-03-01T13:30:22Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/37?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-28T05:00:00Z",
            "issueNumber": "36",
            "sessionNumber": 2,
            "updateDate": "2024-02-29T13:00:25Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/36?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-27T05:00:00Z",
            "issueNumber": "35",
            "sessionNumber": 2,
            "updateDate": "2024-02-28T10:00:24Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/35?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-26T05:00:00Z",
            "issueNumber": "34",
            "sessionNumber": 2,
            "updateDate": "2024-02-27T10:15:27Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/34?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-23T05:00:00Z",
            "issueNumber": "33",
            "sessionNumber": 2,
            "updateDate": "2024-02-24T09:15:17Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/33?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-20T05:00:00Z",
            "issueNumber": "32",
            "sessionNumber": 2,
            "updateDate": "2024-02-21T07:45:15Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/32?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-16T05:00:00Z",
            "issueNumber": "31",
            "sessionNumber": 2,
            "updateDate": "2024-02-17T07:15:16Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/31?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-15T05:00:00Z",
            "issueNumber": "30",
            "sessionNumber": 2,
            "updateDate": "2024-02-16T10:30:21Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/30?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-14T05:00:00Z",
            "issueNumber": "29",
            "sessionNumber": 2,
            "updateDate": "2024-02-15T11:30:22Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/29?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-13T05:00:00Z",
            "issueNumber": "28",
            "sessionNumber": 2,
            "updateDate": "2024-02-14T12:00:24Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/28?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-12T05:00:00Z",
            "issueNumber": "27",
            "sessionNumber": 2,
            "updateDate": "2024-02-14T09:00:29Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/27?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-11T05:00:00Z",
            "issueNumber": "26",
            "sessionNumber": 2,
            "updateDate": "2024-02-12T10:00:24Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/26?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-10T05:00:00Z",
            "issueNumber": "25",
            "sessionNumber": 2,
            "updateDate": "2024-02-11T08:45:15Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/25?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-09T05:00:00Z",
            "issueNumber": "24",
            "sessionNumber": 2,
            "updateDate": "2024-02-10T14:45:15Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/24?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-08T05:00:00Z",
            "issueNumber": "23",
            "sessionNumber": 2,
            "updateDate": "2024-02-09T12:15:16Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/23?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-07T05:00:00Z",
            "issueNumber": "22",
            "sessionNumber": 2,
            "updateDate": "2024-02-08T12:00:20Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/22?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-06T05:00:00Z",
            "issueNumber": "21",
            "sessionNumber": 2,
            "updateDate": "2024-02-07T14:15:16Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/21?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-05T05:00:00Z",
            "issueNumber": "20",
            "sessionNumber": 2,
            "updateDate": "2024-02-06T13:15:18Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/20?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-02-01T05:00:00Z",
            "issueNumber": "19",
            "sessionNumber": 2,
            "updateDate": "2024-02-02T11:00:21Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/19?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-31T05:00:00Z",
            "issueNumber": "18",
            "sessionNumber": 2,
            "updateDate": "2024-02-01T12:00:20Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/18?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-30T05:00:00Z",
            "issueNumber": "17",
            "sessionNumber": 2,
            "updateDate": "2024-01-31T10:45:12Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/17?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-29T05:00:00Z",
            "issueNumber": "16",
            "sessionNumber": 2,
            "updateDate": "2024-01-30T12:15:13Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/16?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-26T05:00:00Z",
            "issueNumber": "15",
            "sessionNumber": 2,
            "updateDate": "2024-01-27T07:30:17Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/15?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-25T05:00:00Z",
            "issueNumber": "14",
            "sessionNumber": 2,
            "updateDate": "2024-01-26T12:00:16Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/14?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-24T05:00:00Z",
            "issueNumber": "13",
            "sessionNumber": 2,
            "updateDate": "2024-01-25T10:45:11Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/13?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-23T05:00:00Z",
            "issueNumber": "12",
            "sessionNumber": 2,
            "updateDate": "2024-01-24T09:15:15Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/12?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-22T05:00:00Z",
            "issueNumber": "11",
            "sessionNumber": 2,
            "updateDate": "2024-01-23T10:15:13Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/11?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-18T05:00:00Z",
            "issueNumber": "10",
            "sessionNumber": 2,
            "updateDate": "2024-01-19T12:15:15Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/10?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-17T05:00:00Z",
            "issueNumber": "9",
            "sessionNumber": 2,
            "updateDate": "2024-01-18T12:30:17Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/9?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-16T05:00:00Z",
            "issueNumber": "8",
            "sessionNumber": 2,
            "updateDate": "2024-01-17T11:45:13Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/8?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-12T05:00:00Z",
            "issueNumber": "7",
            "sessionNumber": 2,
            "updateDate": "2024-01-13T11:30:19Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/7?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-11T05:00:00Z",
            "issueNumber": "6",
            "sessionNumber": 2,
            "updateDate": "2024-01-12T12:30:17Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/6?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-10T05:00:00Z",
            "issueNumber": "5",
            "sessionNumber": 2,
            "updateDate": "2024-01-11T12:45:14Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/5?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-09T05:00:00Z",
            "issueNumber": "4",
            "sessionNumber": 2,
            "updateDate": "2024-01-10T13:30:29Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/4?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-08T05:00:00Z",
            "issueNumber": "3",
            "sessionNumber": 2,
            "updateDate": "2024-01-09T10:00:18Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/3?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-05T05:00:00Z",
            "issueNumber": "2",
            "sessionNumber": 2,
            "updateDate": "2024-01-06T07:15:18Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/2?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-03T05:00:00Z",
            "issueNumber": "1",
            "sessionNumber": 2,
            "updateDate": "2024-02-07T14:45:37Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/1?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-03T05:00:00Z",
            "issueNumber": "215",
            "sessionNumber": 1,
            "updateDate": "2024-01-08T18:30:23Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/215?format=json",
            "volumeNumber": 169
        },
        {
            "congress": 118,
            "issueDate": "2024-01-02T05:00:00Z",
            "issueNumber": "214",
            "sessionNumber": 1,
            "updateDate": "2024-01-08T18:30:39Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/214?format=json",
            "volumeNumber": 169
        },
        {
            "congress": 118,
            "issueDate": "2023-12-29T05:00:00Z",
            "issueNumber": "213",
            "sessionNumber": 1,
            "updateDate": "2023-12-30T07:45:19Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/213?format=json",
            "volumeNumber": 169
        },
        {
            "congress": 118,
            "issueDate": "2023-12-26T05:00:00Z",
            "issueNumber": "212",
            "sessionNumber": 1,
            "updateDate": "2023-12-27T08:30:18Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/212?format=json",
            "volumeNumber": 169
        },
        {
            "congress": 118,
            "issueDate": "2023-12-22T05:00:00Z",
            "issueNumber": "211",
            "sessionNumber": 1,
            "updateDate": "2023-12-23T18:15:17Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/211?format=json",
            "volumeNumber": 169
        },
        {
            "congress": 118,
            "issueDate": "2023-12-20T05:00:00Z",
            "issueNumber": "210",
            "sessionNumber": 1,
            "updateDate": "2023-12-21T10:30:30Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/210?format=json",
            "volumeNumber": 169
        },
        {
            "congress": 118,
            "issueDate": "2023-12-19T05:00:00Z",
            "issueNumber": "209",
            "sessionNumber": 1,
            "updateDate": "2023-12-20T15:15:17Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/209?format=json",
            "volumeNumber": 169
        },
        {
            "congress": 118,
            "issueDate": "2023-12-18T05:00:00Z",
            "issueNumber": "208",
            "sessionNumber": 1,
            "updateDate": "2023-12-19T12:15:14Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/208?format=json",
            "volumeNumber": 169
        }
    ],
    "pagination": {
        "count": 5358,
        "next": "https://api.congress.gov/v3/daily-congressional-record?offset=60&limit=60&format=json"
    },
    "request": {
        "contentType": "application/json",
        "format": "json"
    }
}

Notice the breaking order here:

{
            "congress": 118,
            "issueDate": "2024-01-05T05:00:00Z",
            "issueNumber": "2",
            "sessionNumber": 2,
            "updateDate": "2024-01-06T07:15:18Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/2?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-03T05:00:00Z",
            "issueNumber": "1",
            "sessionNumber": 2,
            "updateDate": "2024-02-07T14:45:37Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/170/1?format=json",
            "volumeNumber": 170
        },
        {
            "congress": 118,
            "issueDate": "2024-01-03T05:00:00Z",
            "issueNumber": "215",
            "sessionNumber": 1,
            "updateDate": "2024-01-08T18:30:23Z",
            "url": "https://api.congress.gov/v3/daily-congressional-record/169/215?format=json",
            "volumeNumber": 169
        },

It seems like the current list is ordered by volumeNumber and issueNumber, however this makes it difficult to identify when updates are made to older records.