names

23 rows where place_id = 651315

✎ 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
3917084 1996072 1996072 defendant Warde Robert tailor 651315 651315 Warde, Robert, of Medryngham, tailor 0
3923685 1998234 1998234 plaintiff Starkey John (legal representative) 651315 651315 Starkey, John, of Medryngham, executors of 0
5255436 2431820 2431820 defendant Smyth John   651315 651315 Smyth, John, of Medryngham, fen man 0
5309954 2448013 2448013 defendant Gyllyotte Henry laborer 651315 651315 Gyllyotte, Henry, of Medryngham, laborer 1
5338470 2456605 2456605 defendant Parker John husbandman 651315 651315 Parker, John, of Medryngham, husbandman 0
5338471 2456605 2456605 defendant Bavyn Robert husbandman 651315 651315 Bavyn, Robert, of Medryngham, husbandman 1
5338472 2456605 2456605 defendant Mason Thomas husbandman 651315 651315 Mason, Thomas, of Medryngham, husbandman 2
5338473 2456605 2456605 defendant Wenslade John husbandman 651315 651315 Wenslade, John, of Medryngham, husbandman 3
5338474 2456605 2456605 defendant Sayre Robert husbandman 651315 651315 Sayre, Robert, of Medryngham, husbandman 4
5338475 2456605 2456605 defendant Ridoute Henry husbandman 651315 651315 Ridoute, Henry, of Medryngham, husbandman 5
5338476 2456605 2456605 defendant Pallay Adam husbandman 651315 651315 Pallay, Adam, of Medryngham, husbandman 6
5338477 2456605 2456605 defendant York William husbandman 651315 651315 York, William, of Medryngham, husbandman 7
5338478 2456605 2456605 defendant Benton Robert husbandman 651315 651315 Benton, Robert, of Medryngham, husbandman 8
5338479 2456605 2456605 defendant Belcheforth Thomas husbandman 651315 651315 Belcheforth, Thomas, of Medryngham, husbandman 9
5338480 2456605 2456605 defendant Squyer Robert husbandman 651315 651315 Squyer, Robert, of Medryngham, husbandman 10
5338481 2456605 2456605 defendant Proctour William husbandman 651315 651315 Proctour, William, of Medryngham, husbandman 11
5338482 2456605 2456605 defendant Wryght Richard husbandman 651315 651315 Wryght, Richard, of Medryngham, husbandman 12
5338483 2456605 2456605 defendant Kyme John husbandman 651315 651315 Kyme, John, of Medryngham, husbandman 13
5359368 2462969 2462969 defendant Paulyn John husbandman 651315 651315 Paulyn, John, of Medryngham, husbandman 1
5359821 2463111 2463111 defendant Stabull alias Belchford John yeoman 651315 651315 Stabull alias Belchford, John, of Medryngham, yeoman 0
5369474 2466045 2466045 defendant Hochonson William or Walter husbandman 651315 651315 Hochonson, William or Walter, of Medryngham, husbandman 0
5625855 2552035 2552035 plaintiff Mason Nicholas   651315 651315 Mason, Nicholas, of Medryngham 0
5625856 2552035 2552035 defendant Clerk William   651315 651315 Clerk, William, of Medryngham, court holder 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);