names

21 rows where case_id = 2537465

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5608191 2537465 2537465 plaintiff Yonge Joan widow   Yonge, Joan, widow 0
5608192 2537465 2537465 defendant Yonge Richard gent 905440 905440 Yonge, Richard, of Skardyngwell, gent 0
5608193 2537465 2537465 defendant Carter Richard barker 905441 905441 Carter, Richard, of Dewisbere, barker 1
5608194 2537465 2537465 defendant Staunton Robert husbandman 726539 726539 Staunton, Robert, of Towton, husbandman 2
5608195 2537465 2537465 defendant Hunt John husbandman 726539 726539 Hunt, John, of Towton, husbandman 3
5608196 2537465 2537465 defendant Wode Thomas husbandman 726539 726539 Wode, Thomas, of Towton, husbandman 4
5608197 2537465 2537465 defendant Turpyn Robert husbandman 726539 726539 Turpyn, Robert, of Towton, husbandman 5
5608198 2537465 2537465 defendant Cowke John husbandman 726539 726539 Cowke, John, of Towton, husbandman 6
5608199 2537465 2537465 defendant Adam Thomas husbandman 598130 598130 Adam, Thomas, of Saxton, husbandman 7
5608200 2537465 2537465 defendant Lofte or Loste Thomas husbandman 598130 598130 Lofte or Loste, Thomas, of Saxton, husbandman 8
5608201 2537465 2537465 defendant Pare Robert husbandman 598130 598130 Pare, Robert, of Saxton, husbandman 9
5608202 2537465 2537465 defendant Skelton Robert husbandman 598130 598130 Skelton, Robert, of Saxton, husbandman 10
5608203 2537465 2537465 defendant taytt Robert husbandman 598130 598130 taytt, Robert, of Saxton, husbandman 11
5608204 2537465 2537465 defendant Yoyll Robert husbandman 598130 598130 Yoyll, Robert, of Saxton, husbandman 12
5608205 2537465 2537465 defendant Andrew John husbandman 905442 905442 Andrew, John, of Scarthyngton, husbandman 13
5608206 2537465 2537465 defendant Andrewe Stephen husbandman 905443 905443 Andrewe, Stephen, of Slarthyngwell, husbandman 14
5608207 2537465 2537465 defendant Long Thomas husbandman 586497 586497 Long, Thomas, of Barston, husbandman 15
5608208 2537465 2537465 defendant Powell John husbandman 586497 586497 Powell, John, of Barston, husbandman 16
5608209 2537465 2537465 defendant Powll Thomas husbandman 586497 586497 Powll, Thomas, of Barston, husbandman 17
5608210 2537465 2537465 defendant Wryght Thomas husbandman 586497 586497 Wryght, Thomas, of Barston, husbandman 18
5608211 2537465 2537465 defendant Wytakers William husbandman 586497 586497 Wytakers, William, of Barston, husbandman 19

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