32858 text
Author: n | 2025-04-24
''(click the []to open)'' !!!- Hidden by default Text text text text Text text text text Text text text text !!! Visible by default ''(click the [-]to close)'' Text text text text Text text text text Text text text text to sfera, text to sqz, text to sdat, text to pages, text to mp4v, text to smpx, text to tlz, text to dmsm, text to tar.bz2, text to dtm, text to dmf, text to f4m, text to cal, text to ffm, text to ptcop, text to rip, text to orf, text to omx, text to dropbox, text to tdt, text to efq, text to ds2
File.Download (Text, Text, Text, Text, var Text) Method
RoundLok anti-sags were incorrectly creating bolts rather than holes. This has now been fixed. TSAC-3512 Steel components Kingspan File transfer (18) was incorrectly removing valid holes in the MultiBeam sections. This has now been fixed. TSAC-3530 Steel components Gusseted cross (62): The default bolt spacing for angle bolts is now the same both when you enter the number of bolts and when you do not enter the number of bolts. TSAC-3531 Steel components Brace middle tubes and plate (144): Connection plates are now bolted to the gusset plate in the correct order. TSAC-3536 Steel components Tube gusset (20): Previously, both above and below line welds were created as above line welds. This has now been fixed. TSAC-3693 Steel components Brace corner tubes and plate (44): Connection plates are now bolted to the gusset plate in the correct order. TSAC-3702 Steel components Shear plate simple (146): When the secondary part was already cut before applying the component, incorrect part geometry was used when positioning bolts. This has now been fixed. TSAC-3795 Steel components Create hole around part (92): Previously, the hole was incorrectly rotated in some cases. This has now been fixed. TSAC-917 Steel components Angle profile box (1040): Upper stiffener thickness, width and height are now correctly applied. TTSD-30725 Organizer In Organizer, project properties were not previously exported to Excel. This has now been fixed. TTSD-31350 Organizer Previously, synchronization in Organizer was cancelled when the selection in the model was changed. This has now been fixed. TTSD-28033 Import, export, interoperability IFC export: The grids were exported incorrectly if you used a base point in the export. This has now been fixed. TTSD-28999 Import, export, interoperability DWG export: The export now handles base point offsets better. TTSD-29882 Import, export, interoperability DWG export: When exporting a drawing in US imperial environment, the preview window width was sometimes not enough to show the whole drawing. This has now been fixed. TTSD-30257 Import, export, interoperability DWG export: Drawing DWG export now handles better views that have cut settings on but with no actual cuts. TTSD-30742 Import, export, interoperability The handling of IFC reference models has been improved. TTSD-30924 Import, export, interoperability DWG export: The export is now more reliable when plotting pull-out pictures in templates. TTSD-31430 Import, export, interoperability DWG export: The export is now more robust when the Educational license is in use. TTSD-32669 Import, export, interoperability The extra slowness of IFC change management has now been removed. TTSD-32858 Import, export, interoperability Trimble Connector: Previously in Trimble Connector, the Refresh button in the ToDo view did not synchronize data from Trimble Connect. This has now been fixed. TTSD-33039 Import, export, interoperability Point cloud data handling sometimes failed from 2019 SP3 onwards, and attaching This has now been fixed. TTSD-29904 Import, export, interoperability DWG drawing export: Drawing DWG export now handles better situations where views are copied from another drawing with layouts. TTSD-30257 Import, export, interoperability DWG export: Drawing DWG export now handles better views that have cut settings on but with no actual cuts. TTSD-30650 Import, export, interoperability Sometimes the reference model visibility eye icon state was wrong when you opened the reference model, and you needed to click the icon twice to get the reference model visible. This has now been fixed. TTSD-30742 Import, export, interoperability The handling of IFC reference models has been improved. TTSD-30755 Import, export, interoperability 3D DWG and 3D DGN v8 export: Export failed when there was a space in the layer name. This has now been fixed. TTSD-30846 Import, export, interoperability When you receive a generic error message in Trimble Connector, you can now find further information about the error in an error log file that is generated in the model folder. TTSD-30924 Import, export, interoperability DWG export: The export is now more reliable when plotting pull-out pictures in templates. TTSD-31129 Import, export, interoperability IFC2x3 export: The property set mapping double accuracy type is now working correctly, and the size of the export file is reduced. TTSD-31305 Import, export, interoperability Handling ToDo snapshot views in Trimble Connector has been improved. Now, if the ToDo only has one snapshot view, the camera will be adjusted to match that view. If there are several snapshot views and none of them is selected, Trimble Connector will ask you to select the snapshot view to which you want to match the camera. TTSD-31360 Import, export, interoperability DWG export: The export now launches a bit faster than before. TTSD-31430 Import, export, interoperability DWG export: The export is now more robust when the Educational license is in use. TTSD-32417 Import, export, interoperability Level marks were not correct for B-rep items, as they always showed the elevation of the item's restriction box. This has now been fixed. TTSD-32669 Import, export, interoperability The extra slowness of IFC change management has now been removed. TTSD-32858 Import, export, interoperability Trimble Connector: Previously in Trimble Connector, the Refresh button in the ToDo view did not synchronize data from Trimble Connect. This has now been fixed. TTSD-33039 Import, export, interoperability Point cloud data handling sometimes failed from 2019 SP3 onwards, and attaching the model to Tekla Structures was not possible. This has now been fixed. TTSD-33077 Import, export, interoperability The .stp reference model insert speed has been improved. TTSD-33216 Import, export, interoperability Trimble Connector: You can assign ToDos to all users in the Trimble Connect project properly again. TTSD-33366 Import, export, interoperability When you are attaching your model to a Trimble Connect project, the Trimble Connect - Select project dialog box now shows additional details about the available licenses. This helps you to select the right license when the organization names are the same. TTSD-33615 Import, export, interoperability Ifc2x3 export: Export using Organizer hierarchies sometimes created openings to wrongFile.Download(Text, Text, Text, Text, var Text) Method - Business
PaperLength INTEGER, paperWidth INTEGER, postedDate TEXT, postmarkDate TEXT, reasonWithdrawn TEXT, receiveDate TEXT, regWriterInstruction TEXT, restrictReason TEXT, restrictReasonType TEXT, sourceCitation TEXT, startEndPage TEXT, stateProvinceRegion TEXT, subject TEXT, submitterRep TEXT, submitterRepCityState TEXT, subtype TEXT, title TEXT, topics TEXT, trackingNbr TEXT, withdrawn INTEGER, zip TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMPcomments_header commentId TEXT NOT NULL UNIQUE, agencyId TEXT, documentType TEXT, lastModifiedDate TEXT NOT NULL, objectId TEXT, postedDate TEXT, title TEXT, withdrawn INTEGER, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULLcomments_detail commentId TEXT NOT NULL UNIQUE, agencyId TEXT, category TEXT, city TEXT, comment TEXT, commentOn TEXT, commentOnDocumentId TEXT, country TEXT, docAbstract TEXT, docketId TEXT, documentType TEXT, duplicateComments INTEGER, field1 TEXT, field2 TEXT, firstName TEXT, govAgency TEXT, govAgencyType TEXT, lastName TEXT, legacyId TEXT, modifyDate TEXT NOT NULL, objectId TEXT, openForComment INTEGER, organization TEXT, originalDocumentId TEXT, pageCount TEXT, postedDate TEXT, postmarkDate TEXT, reasonWithdrawn TEXT, receiveDate TEXT, restrictReason TEXT, restrictReasonType TEXT, stateProvinceRegion TEXT, submitterRep TEXT, submitterRepCityState TEXT, subtype TEXT, title TEXT, trackingNbr TEXT, withdrawn INTEGER, zip TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP. ''(click the []to open)'' !!!- Hidden by default Text text text text Text text text text Text text text text !!! Visible by default ''(click the [-]to close)'' Text text text text Text text text text Text text text text to sfera, text to sqz, text to sdat, text to pages, text to mp4v, text to smpx, text to tlz, text to dmsm, text to tar.bz2, text to dtm, text to dmf, text to f4m, text to cal, text to ffm, text to ptcop, text to rip, text to orf, text to omx, text to dropbox, text to tdt, text to efq, text to ds2File.DownloadFromStream(InStream, Text, Text, Text, var Text)
One of each pair is the "header" table and the the other is the "detail" table. The "header" table is what is returned by the Regulations.gov [dockets/documents/comments] endpoint, and is a query for possibly multiple of these items. It contains a small number of metadata fields. The "detail" table is what is returned by the Regulations.gov endpoint for a specific item (e.g., dockets/EXAMPLE-DOCKET-ID). It contains more fields with data like the plain-text of a comment.The six tables are: dockets_header, dockets_detail, documents_header, documents_detail, comments_header, and comments_detail. The schema is shown below. For definitions of these fields, see the Regulations.gov API documentation. sqltime is a field I added indicating when a given row was inserted into the table.dockets_header docketId TEXT NOT NULL UNIQUE, agencyId TEXT, docketType TEXT, title TEXT, lastModifiedDate TEXT NOT NULL, objectId TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMPdockets_detail docketId TEXT NOT NULL UNIQUE, agencyId TEXT, category TEXT, dkAbstract TEXT, docketType TEXT, effectiveDate TEXT, field1 TEXT, field2 TEXT, generic TEXT, keywords TEXT, legacyId TEXT, modifyDate TEXT NOT NULL, objectId TEXT, organization TEXT, petitionNbr TEXT, program TEXT, rin TEXT, shortTitle TEXT, subType TEXT, subType2 TEXT, title TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMPdocuments_header documentId TEXT NOT NULL UNIQUE, commentEndDate TEXT, commentStartDate TEXT, docketId TEXT, documentType TEXT, frDocNum TEXT, lastModifiedDate TEXT NOT NULL, objectId TEXT, postedDate TEXT, subtype TEXT, title TEXT, withdrawn INTEGER, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMPdocuments_detail documentId TEXT NOT NULL UNIQUE, additionalRins TEXT, agencyId TEXT, allowLateComments INTEGER, authorDate TEXT, authors TEXT, category TEXT, cfrPart TEXT, city TEXT, comment TEXT, commentEndDate TEXT, commentStartDate TEXT, country TEXT, docAbstract TEXT, docketId TEXT, documentType TEXT, effectiveDate TEXT, exhibitLocation TEXT, exhibitType TEXT, field1 TEXT, field2 TEXT, firstName TEXT, frDocNum TEXT, frVolNum TEXT, govAgency TEXT, govAgencyType TEXT, implementationDate TEXT, lastName TEXT, legacyId TEXT, media TEXT, modifyDate TEXT NOT NULL, objectId TEXT, ombApproval TEXT, openForComment INTEGER, organization TEXT, originalDocumentId TEXT, pageCount TEXT, And paste, agar Underline Text, fantasy text, cool writing, Underline Text symbols, francy text, fancytextblogspot, text generator Underline Text, nicname Underline Text, Underline Text maker, wide text generator, weird text generator, fancy nickname, Underline Text nicks, fancy word generator, letras para Underline Text, fancy Underline Text names, nama agar pro, Underline Text for Underline Text, twt Underline Text, names for Underline Text, clanes de Underline Text, nikname Underline Text, fancy blogspot, nama nama agar pro, Underline Text clan names, fancy texts, nik Underline Text, cool letter, fancey text, tag Underline Text, crear nombre para Underline Text, crear nick para Underline Text, text Underline Text, simbolos para Underline Text, niks para Underline Text, facy text, Underline Text converter, nick de Underline Text, fancy letters generator, fanci text, nick creator, Underline Text gen, Underline Text name creator, agar clan, Underline Text names list, best Underline Text names, nama nama Underline Text, Underline Text font, Underline Text tyt, like Underline Text, symbol nickname, cool agar names, Underline Text nickname, copy and paste Underline Text names, symbol Underline Text, Underline Text zt, fanct text, fancytextblog, tyt font, agarabi fancy nick, text letters, fancytekst, symbol text generator, tags Underline Text, tyt clan name, tag para Underline Text, nickname agar pro, zt clan, Underline Text genorator, kitten clan, megacooltext, text generator fancy, symbols Underline Text, clan generator, Underline Text nbk, Underline Text copy and paste names, nama clan Underline Text, facy nick, symbole Underline Text, facy tex, nombres de Underline Text, Underline Text\, agartext, copy and paste names, nickname generator for Underline Text, cool names, Underline Text Underline Text generator, tag de Underline Text, letras Underline Text, nicknames generator, sirius nick, Underline Text for Underline Text, agar fonts, fancy name maker, Underline Text clan, Underline Text names copy paste, clan tyt, tag Underline Text, tyt nameText-to-Text, Text-to-Self, Text-to-World - Facing History and
Underline Text, nickname Underline Text, names Underline Text, tyt text, Underline Text creator, Underline Text names generator, fancy texs, nombre para Underline Text, fance text, text maker, Underline Text cool text, Underline Text nick name, cool fonts copy and paste, agar copy, fancy keyboard letters, fency text, tyt copy and paste, nik para Underline Text, clans Underline Text, simbolos para Underline Text, cool text copy and paste, nickname creator, facncy text, agar tyt, crear nombres de Underline Text, letras de Underline Text, todos los clanes de Underline Text, agar, text generator fonts, nama Underline Text keren, coole letters, Underline Text words, nick tyt, symbol Underline Text, like Underline Text, fanci nick, Underline Text copy and paste, mega cool text Underline Text, Underline Text clan maker, fancy texy, fantasy text generator, fanytext, fancy nickname creator, nik Underline Text, Underline Text pro names, Underline Text nick, Underline Text online, agar nickname, crea tu nick para Underline Text, Underline Text text generator, Underline Text fancy nick, generator nick, www.fancytext, nick Underline Text china, mega cool text for Underline Text, fanci tex, creador de nombres para Underline Text, crear nombres para Underline Text, fancy names for Underline Text, create nbk, Underline Text tyt names, nama agar, Underline Text genarator, nick agarz, Underline Text emojis, generator Underline Text, cool text generator Underline Text, Underline Text nick generator, fancyblogspot, generador de nick Underline Text, name Underline Text, text name, pancy text, name generator, copy and paste fonts, tyt Underline Text names, Underline Text 2016, simbolos Underline Text, Underline Text tyt, fancy tect, teks Underline Text, cool name for Underline Text, fancy names generator, Underline Text tags, tyt sirius name copy and paste, stylish text generator, create name, Underline Text fonts, Underline Text fancy, cool leters, Underline Text generater, Underline Text namen, fancy nicknames for Underline Text,text{ODL : LOD : : PWN : ?}text{NWP}text{WPN}text{NPW}text
Text generator online, agar.pro name, cool symbols for Underline Text, cool nickname generator, fancy Underline Text, good Underline Text names, fancy nıck, tyt clan Underline Text, simbol Underline Text keren, nick name, Underline Text letters, nick fancy, special text generator, Underline Text special names, Underline Text nickname generator, nomes Underline Text, generador de Underline Text, Underline Text simbols, nbk fancy, Underline Text cool letters, fonts for Underline Text, Underline Text generator 2016, twt nick, text symbols generator, fancy letters for Underline Text, agar zt, clan names generator, Underline Text genrator, clans Underline Text, nick for Underline Text, nbk Underline Text, agar tag, tyt symbols, game like Underline Text, Underline Text text symbols, Underline Text], clan agar, nick nama Underline Text, name tag generator, generador de nicks Underline Text, facncytext, sirius Underline Text, cool letters to copy and paste, tags para Underline Text, nike name Underline Text, fancytect, Underline Text names tyt, text nick, Underline Text blog spot, tyt nicknames, simbol text Underline Text, nickname para Underline Text, emoji 450, agarz name, fncy text, nick generator Underline Text, Underline Text names copy, fancy chat, cool letters for Underline Text, Underline Text keyboard, fancy agar, Underline Text symbole, creador de nombres Underline Text, cool fonts for Underline Text, text font generator copy and paste, generador de nicks para Underline Text, Underline Text font generator, alt codes twt, Underline Text symbol, create nick, crear mi nombre en Underline Text, text generator for Underline Text, coolletters, fancynickname, sirius Underline Text name, fanceytext, textgenerator, tags de Underline Text, agrio name, how to get cool names on Underline Text, nick name agar pro, tags Underline Text, name for Underline Text, generador de letras raras, tags para Underline Text, Underline Text generator Underline Text, tyt clan symbol, text generator font, fancytxt, Underline Text nick generator, name agrio,. ''(click the []to open)'' !!!- Hidden by default Text text text text Text text text text Text text text text !!! Visible by default ''(click the [-]to close)'' Text text text text Text text text text Text text text text to sfera, text to sqz, text to sdat, text to pages, text to mp4v, text to smpx, text to tlz, text to dmsm, text to tar.bz2, text to dtm, text to dmf, text to f4m, text to cal, text to ffm, text to ptcop, text to rip, text to orf, text to omx, text to dropbox, text to tdt, text to efq, text to ds2text-workbench.software.informer.com - Text Workbench Download - Text
Tags de Underline Text, agar copy y paste, symbols for Underline Text, nick generator Underline Text, tulisan Underline Text keren, Underline Text slova, copy and paste letters, name maker Underline Text, cool name creator, cool names in Underline Text, Underline Text agar, nick Underline Text tyt, blogspot Underline Text, Underline Text emoji, nick de sirius, Underline Text font generator, clan names Underline Text, names in Underline Text, fancy name for Underline Text, tyt fancy, team Underline Text, nikname Underline Text, crear tu nombre para Underline Text, Underline Text name generator, best Underline Text names, tyt fonts, tyt names list, nick para agarz, crear nombre Underline Text, text symbols, Underline Text chat, nicks generator, name creator Underline Text, name font generator, twt text, fancy word maker, Underline Text names copy paste, clans de Underline Text, fancytet, twt nama, fancytext.sarojmeherf, nama Underline Text twt, twt Underline Text, Underline Text generator for Underline Text, generador de letras para nick, coole Underline Text namen, nama nick Underline Text, tyt Underline Text clan, niks Underline Text, crear clan de Underline Text, tytnames, Underline Text pro names, simbolos nbk, cool letters copy and paste, fancy tex generator, fancy letters Underline Text, nick maker, facebooknick, cool Underline Text generator, Underline Text cool, Underline Text name gen, agar name creator, agar nick name, chat twt, fanky text, Underline Text tyt clan, good names for Underline Text, Underline Text cool name, nicki Underline Text, nama nama keren Underline Text, font text generator, text fancy generator, nama clen Underline Text, nama nama keren agar pro, cool Underline Text name, funcytext, nike Underline Text, tulisan twt, fanzy text, pseudo Underline Text tyt, emojis Underline Text, text Underline Text, text symbols Underline Text, fancetext, letras Underline Text, name nbk, weird text generator, agar cool names, generador de nombres de Underline Text, fancy.text.blogspot,Comments
RoundLok anti-sags were incorrectly creating bolts rather than holes. This has now been fixed. TSAC-3512 Steel components Kingspan File transfer (18) was incorrectly removing valid holes in the MultiBeam sections. This has now been fixed. TSAC-3530 Steel components Gusseted cross (62): The default bolt spacing for angle bolts is now the same both when you enter the number of bolts and when you do not enter the number of bolts. TSAC-3531 Steel components Brace middle tubes and plate (144): Connection plates are now bolted to the gusset plate in the correct order. TSAC-3536 Steel components Tube gusset (20): Previously, both above and below line welds were created as above line welds. This has now been fixed. TSAC-3693 Steel components Brace corner tubes and plate (44): Connection plates are now bolted to the gusset plate in the correct order. TSAC-3702 Steel components Shear plate simple (146): When the secondary part was already cut before applying the component, incorrect part geometry was used when positioning bolts. This has now been fixed. TSAC-3795 Steel components Create hole around part (92): Previously, the hole was incorrectly rotated in some cases. This has now been fixed. TSAC-917 Steel components Angle profile box (1040): Upper stiffener thickness, width and height are now correctly applied. TTSD-30725 Organizer In Organizer, project properties were not previously exported to Excel. This has now been fixed. TTSD-31350 Organizer Previously, synchronization in Organizer was cancelled when the selection in the model was changed. This has now been fixed. TTSD-28033 Import, export, interoperability IFC export: The grids were exported incorrectly if you used a base point in the export. This has now been fixed. TTSD-28999 Import, export, interoperability DWG export: The export now handles base point offsets better. TTSD-29882 Import, export, interoperability DWG export: When exporting a drawing in US imperial environment, the preview window width was sometimes not enough to show the whole drawing. This has now been fixed. TTSD-30257 Import, export, interoperability DWG export: Drawing DWG export now handles better views that have cut settings on but with no actual cuts. TTSD-30742 Import, export, interoperability The handling of IFC reference models has been improved. TTSD-30924 Import, export, interoperability DWG export: The export is now more reliable when plotting pull-out pictures in templates. TTSD-31430 Import, export, interoperability DWG export: The export is now more robust when the Educational license is in use. TTSD-32669 Import, export, interoperability The extra slowness of IFC change management has now been removed. TTSD-32858 Import, export, interoperability Trimble Connector: Previously in Trimble Connector, the Refresh button in the ToDo view did not synchronize data from Trimble Connect. This has now been fixed. TTSD-33039 Import, export, interoperability Point cloud data handling sometimes failed from 2019 SP3 onwards, and attaching
2025-04-13This has now been fixed. TTSD-29904 Import, export, interoperability DWG drawing export: Drawing DWG export now handles better situations where views are copied from another drawing with layouts. TTSD-30257 Import, export, interoperability DWG export: Drawing DWG export now handles better views that have cut settings on but with no actual cuts. TTSD-30650 Import, export, interoperability Sometimes the reference model visibility eye icon state was wrong when you opened the reference model, and you needed to click the icon twice to get the reference model visible. This has now been fixed. TTSD-30742 Import, export, interoperability The handling of IFC reference models has been improved. TTSD-30755 Import, export, interoperability 3D DWG and 3D DGN v8 export: Export failed when there was a space in the layer name. This has now been fixed. TTSD-30846 Import, export, interoperability When you receive a generic error message in Trimble Connector, you can now find further information about the error in an error log file that is generated in the model folder. TTSD-30924 Import, export, interoperability DWG export: The export is now more reliable when plotting pull-out pictures in templates. TTSD-31129 Import, export, interoperability IFC2x3 export: The property set mapping double accuracy type is now working correctly, and the size of the export file is reduced. TTSD-31305 Import, export, interoperability Handling ToDo snapshot views in Trimble Connector has been improved. Now, if the ToDo only has one snapshot view, the camera will be adjusted to match that view. If there are several snapshot views and none of them is selected, Trimble Connector will ask you to select the snapshot view to which you want to match the camera. TTSD-31360 Import, export, interoperability DWG export: The export now launches a bit faster than before. TTSD-31430 Import, export, interoperability DWG export: The export is now more robust when the Educational license is in use. TTSD-32417 Import, export, interoperability Level marks were not correct for B-rep items, as they always showed the elevation of the item's restriction box. This has now been fixed. TTSD-32669 Import, export, interoperability The extra slowness of IFC change management has now been removed. TTSD-32858 Import, export, interoperability Trimble Connector: Previously in Trimble Connector, the Refresh button in the ToDo view did not synchronize data from Trimble Connect. This has now been fixed. TTSD-33039 Import, export, interoperability Point cloud data handling sometimes failed from 2019 SP3 onwards, and attaching the model to Tekla Structures was not possible. This has now been fixed. TTSD-33077 Import, export, interoperability The .stp reference model insert speed has been improved. TTSD-33216 Import, export, interoperability Trimble Connector: You can assign ToDos to all users in the Trimble Connect project properly again. TTSD-33366 Import, export, interoperability When you are attaching your model to a Trimble Connect project, the Trimble Connect - Select project dialog box now shows additional details about the available licenses. This helps you to select the right license when the organization names are the same. TTSD-33615 Import, export, interoperability Ifc2x3 export: Export using Organizer hierarchies sometimes created openings to wrong
2025-04-22PaperLength INTEGER, paperWidth INTEGER, postedDate TEXT, postmarkDate TEXT, reasonWithdrawn TEXT, receiveDate TEXT, regWriterInstruction TEXT, restrictReason TEXT, restrictReasonType TEXT, sourceCitation TEXT, startEndPage TEXT, stateProvinceRegion TEXT, subject TEXT, submitterRep TEXT, submitterRepCityState TEXT, subtype TEXT, title TEXT, topics TEXT, trackingNbr TEXT, withdrawn INTEGER, zip TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMPcomments_header commentId TEXT NOT NULL UNIQUE, agencyId TEXT, documentType TEXT, lastModifiedDate TEXT NOT NULL, objectId TEXT, postedDate TEXT, title TEXT, withdrawn INTEGER, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULLcomments_detail commentId TEXT NOT NULL UNIQUE, agencyId TEXT, category TEXT, city TEXT, comment TEXT, commentOn TEXT, commentOnDocumentId TEXT, country TEXT, docAbstract TEXT, docketId TEXT, documentType TEXT, duplicateComments INTEGER, field1 TEXT, field2 TEXT, firstName TEXT, govAgency TEXT, govAgencyType TEXT, lastName TEXT, legacyId TEXT, modifyDate TEXT NOT NULL, objectId TEXT, openForComment INTEGER, organization TEXT, originalDocumentId TEXT, pageCount TEXT, postedDate TEXT, postmarkDate TEXT, reasonWithdrawn TEXT, receiveDate TEXT, restrictReason TEXT, restrictReasonType TEXT, stateProvinceRegion TEXT, submitterRep TEXT, submitterRepCityState TEXT, subtype TEXT, title TEXT, trackingNbr TEXT, withdrawn INTEGER, zip TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMP
2025-03-27One of each pair is the "header" table and the the other is the "detail" table. The "header" table is what is returned by the Regulations.gov [dockets/documents/comments] endpoint, and is a query for possibly multiple of these items. It contains a small number of metadata fields. The "detail" table is what is returned by the Regulations.gov endpoint for a specific item (e.g., dockets/EXAMPLE-DOCKET-ID). It contains more fields with data like the plain-text of a comment.The six tables are: dockets_header, dockets_detail, documents_header, documents_detail, comments_header, and comments_detail. The schema is shown below. For definitions of these fields, see the Regulations.gov API documentation. sqltime is a field I added indicating when a given row was inserted into the table.dockets_header docketId TEXT NOT NULL UNIQUE, agencyId TEXT, docketType TEXT, title TEXT, lastModifiedDate TEXT NOT NULL, objectId TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMPdockets_detail docketId TEXT NOT NULL UNIQUE, agencyId TEXT, category TEXT, dkAbstract TEXT, docketType TEXT, effectiveDate TEXT, field1 TEXT, field2 TEXT, generic TEXT, keywords TEXT, legacyId TEXT, modifyDate TEXT NOT NULL, objectId TEXT, organization TEXT, petitionNbr TEXT, program TEXT, rin TEXT, shortTitle TEXT, subType TEXT, subType2 TEXT, title TEXT, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMPdocuments_header documentId TEXT NOT NULL UNIQUE, commentEndDate TEXT, commentStartDate TEXT, docketId TEXT, documentType TEXT, frDocNum TEXT, lastModifiedDate TEXT NOT NULL, objectId TEXT, postedDate TEXT, subtype TEXT, title TEXT, withdrawn INTEGER, sqltime TIMESTAMP DEFAULT CURRENT_TIMESTAMPdocuments_detail documentId TEXT NOT NULL UNIQUE, additionalRins TEXT, agencyId TEXT, allowLateComments INTEGER, authorDate TEXT, authors TEXT, category TEXT, cfrPart TEXT, city TEXT, comment TEXT, commentEndDate TEXT, commentStartDate TEXT, country TEXT, docAbstract TEXT, docketId TEXT, documentType TEXT, effectiveDate TEXT, exhibitLocation TEXT, exhibitType TEXT, field1 TEXT, field2 TEXT, firstName TEXT, frDocNum TEXT, frVolNum TEXT, govAgency TEXT, govAgencyType TEXT, implementationDate TEXT, lastName TEXT, legacyId TEXT, media TEXT, modifyDate TEXT NOT NULL, objectId TEXT, ombApproval TEXT, openForComment INTEGER, organization TEXT, originalDocumentId TEXT, pageCount TEXT,
2025-03-30