names

28 rows where place_id = 605369

✎ 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
3661395 1913838 1913838 defendant Stannowe John yeoman 605369 605369 Stannowe, John, of Bedyngham, Norf, yeoman 0
3661396 1913838 1913838 defendant Baker John yeoman 605369 605369 Baker, John, of Bedyngham, Norf, yeoman 1
3740788 1938976 1938976 plaintiff Andrewes William butcher 605369 605369 Andrewes, William, of Bedyngham, Norf, butcher 1
3762346 1945865 1945865 defendant Stanhowe John yeoman 605369 605369 Stanhowe, John, of Bedyngham, Norf, yeoman 3
3771132 1948662 1948662 plaintiff Stanhowe John yeoman 605369 605369 Stanhowe, John, of Bedyngham, Norf, yeoman 3
3996130 2023370 2023370 defendant Stanehawe Nicholas yeoman 605369 605369 Stanehawe, Nicholas, of Bedyngham, Norf, yeoman 0
3999028 2024411 2024411 defendant Lancaster Robert yeoman 605369 605369 Lancaster, Robert, of Bedyngham, Norf, yeoman 1
4010346 2028465 2028465 defendant Lancaster Robert yeoman 605369 605369 Lancaster, Robert, of Bedyngham, Norf, yeoman 0
4114111 2065328 2065328 defendant Warde Stephen joiner 605369 605369 Warde, Stephen, of Bedyngham, Norf, joiner 0
4765233 2285109 2285109 defendant Norton John yeoman 605369 605369 Norton, John, of Bedyngham, Norf, yeoman 2
4913206 2330628 2330628 defendant Cok Richard pedder 605369 605369 Cok, Richard, of Bedyngham, Norf, pedder 0
5107323 2388569 2388569 defendant Richemond Robert yeoman 605369 605369 Richemond, Robert, of Bedyngham, Norf, yeoman 2
5127534 2394532 2394532 defendant Rychemond Robert yeoman 605369 605369 Rychemond, Robert, of Bedyngham, Norf, yeoman 0
5127536 2394533 2394533 defendant Rychmond Robert yeoman 605369 605369 Rychmond, Robert, of Bedyngham, Norf, yeoman 0
5181467 2410318 2410318 defendant Richemond Robert yeoman 605369 605369 Richemond, Robert, of Bedyngham, Norf, yeoman 0
5234388 2425647 2425647 defendant Rychemond Robert yeoman 605369 605369 Rychemond, Robert, of Bedyngham, Norf, yeoman 2
5255804 2431938 2431938 defendant Rychemond Robert husbandman 605369 605369 together with Rychemond, Robert, of Bedyngham, Norf, husbandman 2
5280439 2439352 2439352 defendant Rychemond Robert yeoman 605369 605369 Rychemond, Robert, of Bedyngham, Norf, yeoman 4
5308561 2447594 2447594 defendant Stanhowe John gent 605369 605369 Stanhowe, John, of Bedyngham, Norf, gent 6
5319456 2450911 2450911 defendant Coppyng William husbandman 605369 605369 Coppyng, William, of Bedyngham, Norf, husbandman 0
5408093 2477392 2477392 defendant Castell Leonard   605369 605369 Castell, Leonard, of Bedyngham, Norf, esq & son & heir of Humphrey, Castell 0
5421275 2481294 2481294 defendant Castell Leonard   605369 605369 Castell, Leonard, of Bedyngham, Norf, esq, son & heir of Humphrey Castell & Margaret, his wife 0
5440525 2487070 2487070 defendant Castell Leonard   605369 605369 Castell, Leonard, of Bedyngham, Norf, esq, son & heir of Humphrey Castell & Margaret, his wife 0
5440527 2487071 2487071 defendant Castell Leonard   605369 605369 Castell, Leonard, of Bedyngham, Norf, esq, son & heir of Humphrey Castell & Margaret, his wife 0
5465739 2494669 2494669 defendant Castell Leonard   605369 605369 Castell, Leonard, of Bedyngham, Norf, esq, son & heir of Humphrey & Margaret, his wife 0
5488643 2501485 2501485 defendant Castell Leonard   605369 605369 Castell, Leonard, of Bedyngham, Norf, esq, son of Castell, Humphrey, and Margaret his wife 0
5488645 2501486 2501486 defendant Castell Leonard   605369 605369 Castell, Leonard, of Bedyngham, Norf, esq, son of Castell, Humphrey, and Margaret his wife 0
5488647 2501487 2501487 defendant Castell Leonard   605369 605369 Castell, Leonard, of Bedyngham, Norf, esq, son of Castell, Humphrey, and Margaret his wife 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);