Table structure and fields details for the worldFactbook database

world_factbook_lt table

fieldfield descriptiondata typeLT
countryCountry nametext (max. 48 characters)
categoryCategory nametext (max. 128 characters)
unitUnittext (max. 32 characters)
field_valueValue of the field/columntext (max. 65535 characters)
notesNotes and commentstext (max. 65535 characters)
value_dateValue datetext (max. 24 characters)
estimateEstimate
Set to 1 if the corresponding data is an estimate, instead of the final value.
integer (positive)

This information applies only to the data files available since the last update of the worldFactbook database. The content of older files might differ.