About this Dataset

WW1 Veterans' Questionnaire

This database contains a collection of questionnaires filled out by Connecticut soldiers (or their families) who served in World War I. The first page of the questionnaire itself states: “Compiled by the Department of Historical Records of the Connecticut State Council of Defense, State Library, Harford, where it will be filed, as a permanent memorial of the deeds of Connecticut soldiers and sailors in the service of the federal, state and allied governments during the American participation in the World War.

These questionnaires have been digitized by Ancestry.com
Organization: State of Connecticut
Last updated: 2025-03-29T15:41:52.808266
Tags: connecticut-state-library, csl, ct-state-library, veterans, world-war-i

Tables

Table 1

@usgov.state_of_connecticut_ww1_veterans_questionnaire.table_1

153.28 kB
12,977 rows
8 columns

CREATE TABLE table_1 (
  "lastname" VARCHAR,
  "firstname" VARCHAR,
  "middlename" VARCHAR,
  "photo_s" DOUBLE  -- Photo(s),
  "residence" VARCHAR,
  "foreignservice" BOOLEAN,
  "box" BIGINT  -- Box #,
  "notes" VARCHAR
);