names

19 rows where place_id = 625783

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3766314 1947117 1947117 defendant Coppyng John husbandman 625783 625783 Coppyng, John, of Wodeton, husbandman 0
3853715 1974792 1974792 defendant Draper Thomas clerk 625783 625783 Draper, Thomas, of Wodeton, clerk 0
3857194 1975882 1975882 defendant Bolt John husbandman 625783 625783 Bolt, John, of Wodeton, husbandman 0
3983745 2018960 2018960 defendant Benedycke George yeoman 625783 625783 Benedycke, George, of Wodeton, yeoman 0
4436860 2176270 2176270 defendant Rokenham John de   625783 625783 Rokenham, John de, of Wodeton, son of Thomas 0
4436864 2176271 2176271 defendant Rokenham John de   625783 625783 Rokenham, John de, of Wodeton, son of Thomas 0
4523739 2207752 2207752 defendant Colbrok John   625783 625783 Colbrok, John, of Wodeton 2
4562819 2219929 2219929 defendant Hayne John   625783 625783 Hayne, John, of Wodeton 0
4601781 2231777 2231777 defendant White John   625783 625783 White, John, of Wodeton 2
4717319 2270749 2270749 defendant Edrych William yeoman 625783 625783 Edrych, William, of Wodeton, yeoman 0
4745119 2279079 2279079 defendant Larke Richard yeoman 625783 625783 Larke, Richard, of Wodeton, yeoman 1
4809535 2299150 2299150 defendant Edriche Thomas yeoman 625783 625783 Edriche, Thomas, of Wodeton, yeoman 1
4815350 2300909 2300909 defendant Edryche William yeoman 625783 625783 Edryche, William, of Wodeton, yeoman 0
5255930 2431978 2431978 defendant Spencer Robert clerk 625783 625783 Spencer, Robert, of Wodeton, clerk 0
5258309 2432716 2432716 defendant Spencer Robert clerk 625783 625783 Spencer, Robert, of Wodeton, clerk 5
5326988 2453149 2453149 defendant Bakon Robert husbandman 625783 625783 Bakon, Robert, of Wodeton, husbandman 0
5492693 2502729 2502729 defendant Otteley John husbandman 625783 625783 Otteley, John, of Wodeton, husbandman 3
5526301 2512804 2512804 defendant Mantolerk or Mautclerk John yeoman 625783 625783 Mantolerk or Mautclerk, John, of Wodeton, yeoman 2
5530229 2513962 2513962 defendant Manclerk or Mauclerk John husbandman 625783 625783 Manclerk or Mauclerk, John, of Wodeton, husbandman 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);