names

33 rows where place_id = 593144

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610683 1871008 1871008 defendant Lyderlond Lawrence husbandman 593144 593144 Lyderlond, Lawrence, of Raunston, husbandman 0
3611396 1871240 1871240 defendant Neweman Nicholas husbandman 593144 593144 Neweman, Nicholas, of Raunston, husbandman 0
3611397 1871240 1871240 defendant Sputnell William husbandman 593144 593144 Sputnell, William, of raunston, husbandman 1
3645466 1908987 1908987 defendant Tottenall Robert yeoman 593144 593144 Tottenall, Robert, of Raunston, yeoman 2
3682650 1920681 1920681 defendant Floid David yeoman 593144 593144 Floid, David, of Raunston, yeoman 0
3700604 1926435 1926435 defendant Hyde Thomas mercer 593144 593144 Hyde, Thomas, of Raunston, mercer 0
4023513 2033118 2033118 defendant Nuttyng William yeoman 593144 593144 Nuttyng, William, of Raunston, yeoman 0
4224990 2104209 2104209 defendant Farmer William yeoman 593144 593144 Farmer, William, of Raunston, yeoman 0
4231356 2106468 2106468 defendant Digbye John gent 593144 593144 Digbye, John, of Raunston, gent 1
4622834 2238121 2238121 plaintiff Man John   593144 593144 Man, John, of Raunston, prior 0
4656430 2247905 2247905 plaintiff Taillour John   593144 593144 Taillour, John, of Raunston 1
4699574 2265316 2265316 defendant Smyth John smith 593144 593144 Smyth, John, of Raunston, smith 0
4699575 2265316 2265316 defendant Man Robert husbandman 593144 593144 Man, Robert, of Raunston, husbandman 1
4699576 2265316 2265316 defendant Lovell John husbandman 593144 593144 Lovell, John, of Raunston, husbandman 2
4699577 2265316 2265316 defendant Helyer Thomas haulier 593144 593144 Helyer, Thomas, of Raunston, haulier 3
4699578 2265316 2265316 defendant Broy John husbandman 593144 593144 Broy, John, of Raunston, husbandman 4
4732495 2275335 2275335 defendant Stanwygge John   593144 593144 Stanwygge, John, of Raunston, prior 0
4877912 2320045 2320045 defendant Helyer Thomas helyer or roofer 593144 593144 Helyer, Thomas, of Raunston, helyer or roofer 0
4944264 2340181 2340181 defendant Watford William gent 593144 593144 Watford, William, of Raunston, gent 0
4955390 2343572 2343572 defendant Salesbury William husbandman 593144 593144 Salesbury, William, of Raunston, husbandman 0
4995228 2355420 2355420 defendant Lawrens John yeoman 593144 593144 Lawrens, John, of Raunston, yeoman 0
5000681 2357073 2357073 defendant Harcy William husbandman 593144 593144 Harcy, William, of Raunston, husbandman 0
5153160 2402070 2402070 defendant Watford Henry yeoman 593144 593144 Watford, Henry, of Raunston, yeoman 0
5230574 2424556 2424556 defendant Chircheman Henry husbandman 593144 593144 Chircheman, Henry, of Raunston, husbandman 0
5272524 2437038 2437038 defendant Cristyan John   593144 593144 Cristyan, John, of Raunston 0
5286622 2441098 2441098 defendant Newale Thomas yeoman 593144 593144 Newale, Thomas, of Raunston, yeoman 0
5286623 2441098 2441098 defendant Newale John tailor 593144 593144 Newale, John, of Raunston, tailor 1
5286624 2441098 2441098 defendant Mason Thomas   593144 593144 Mason, Thomas, of Raunston, mason 2
5365079 2464750 2464750 plaintiff (not given) Eustace prior of Barnard 593144 593144 Barnard, Eustace, of Raunston, prior of St Mary's House & church 0
5380188 2469381 2469381 plaintiff (not given) Eustace prior of Bernard 593144 593144 Bernard, Eustace, of Raunston, prior of the monastery of the BM 0
5420588 2481080 2481080 defendant Howes (illegible) yeoman 593144 593144 Howes, _, of Raunston, yeoman 2
5439403 2486719 2486719 defendant Howes William yeoman 593144 593144 Howes, William, of Raunston, yeoman 2
5548821 2519700 2519700 defendant Charnelles William gent 593144 593144 Charnelles, William, of Raunston, gent 0

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);