names

26 rows where place_id = 757365

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4445179 2183464 2183464 plaintiff Courcy William   757365 757365 Courcy, William, of Dudeley 0
4935607 2337529 2337529 defendant Clerk William smith 757365 757365 Clerk, William, of Dudeley, smith 1
4935608 2337529 2337529 defendant Fraunces Richard yeoman 757365 757365 Fraunces, Richard, of Dudeley, yeoman 2
4935609 2337529 2337529 defendant Maddok Nicholas yeoman 757365 757365 Maddok, Nicholas, of Dudeley, yeoman 3
4935610 2337529 2337529 defendant Fyssher William fisher 757365 757365 Fyssher, William, of Dudeley, fisher 4
4935611 2337529 2337529 defendant Patyncham Elias smith 757365 757365 together with Patyncham, Elias, of Dudeley, smith 5
4935612 2337529 2337529 defendant Jones John yeoman 757365 757365 Jones, John, of Dudeley, yeoman 6
4935613 2337529 2337529 defendant Merihurst William cordwainer 757365 757365 Merihurst, William, of Dudeley, cordwainer 7
4935614 2337529 2337529 defendant Birchore William husbandman 757365 757365 Birchore, William, of Dudeley, husbandman 8
4935615 2337529 2337529 defendant Meweford William husbandman 757365 757365 Meweford, William, of Dudeley, husbandman 9
4935616 2337529 2337529 defendant Mokkelowe Thomas smith 757365 757365 Mokkelowe, Thomas, of Dudeley, smith 10
4935617 2337529 2337529 defendant Brooke Roger husbandman 757365 757365 Brooke, Roger, of Dudeley, husbandman 11
4935624 2337532 2337532 defendant Patyncham Elias smith 757365 757365 Patyncham, Elias, of Dudeley, smith 0
4935625 2337532 2337532 defendant Jones John yeoman 757365 757365 Jones, John, of Dudeley, yeoman 1
4935626 2337532 2337532 defendant Meryhurst William cordwainer 757365 757365 Meryhurst, William, of Dudeley, cordwainer 2
4935627 2337532 2337532 defendant Birchore William husbandman 757365 757365 Birchore, William, of Dudeley, husbandman 3
4935628 2337532 2337532 defendant Meweford William husbandman 757365 757365 Meweford, William, of Dudeley, husbandman 4
4935629 2337532 2337532 defendant Mukkelowe Thomas smith 757365 757365 Mukkelowe, Thomas, of Dudeley, smith 5
4935630 2337532 2337532 defendant Brooke Roger smith 757365 757365 Brooke, Roger, of Dudeley, smith 6
4935631 2337532 2337532 defendant Fraunces Richard yeoman 757365 757365 Fraunces, Richard, of Dudeley, yeoman 7
4935632 2337532 2337532 defendant Maddok Nicholas yeoman 757365 757365 Maddok, Nicholas, of Dudeley, yeoman 8
4935633 2337532 2337532 defendant Fyssher William fisher 757365 757365 Fyssher, William, of Dudeley, fisher 9
5297128 2444156 2444156 defendant Smyth John cordwainer 757365 757365 Smyth, John, of Dudeley, cordwainer 1
5401448 2475480 2475480 defendant Moryse Reginal smith 757365 757365 Moryse, Reginal, of Dudeley, smith 1
5414433 2479254 2479254 defendant Moryce Reginald smith 757365 757365 Moryce, Reginald, of Dudeley, smith 1
5414434 2479254 2479254 defendant (illegible) John carrier 757365 757365 _, John, of Dudeley, carrier 2

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