names

21 rows where place_id = 731728

✎ 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
4295767 2128576 2128576 defendant Steple William   731728 731728 Steple, William, of Wolferton 0
4314731 2135265 2135265 defendant Steple William husbandman 731728 731728 Steple, William, of Wolferton, husbandman 1
4424877 2172617 2172617 defendant atte Chirche Thomas   731728 731728 atte Chirche, Thomas, of Wolferton, son of Alexander 0
4440758 2182026 2182026 defendant Julyan John   731728 731728 Julyan, John, of Wolferton 1
4467772 2190598 2190598 plaintiff Baldwyn Henry   731728 731728 Baldwyn, Henry, of Wolferton 0
4467775 2190598 2190598 defendant Berege John   731728 731728 Berege, John, of Wolferton 2
4484381 2195810 2195810 defendant Hunte William   731728 731728 Hunte, William, of Wolferton 4
4579002 2224913 2224913 defendant Andrewe Thomas   731728 731728 Andrewe, Thomas, of Wolferton 3
4593886 2229364 2229364 defendant Pyik Thomas   731728 731728 Pyik, Thomas, of Wolferton 1
4605144 2232774 2232774 plaintiff Andrewe Thomas   731728 731728 Andrewe, Thomas, of Wolferton 0
4643586 2244226 2244226 defendant Deye Geoffrey   731728 731728 Deye, Geoffrey, of Wolferton 0
4666820 2255349 2255349 defendant Robynes John husbandman 731728 731728 Robynes, John, of Wolferton, husbandman 1
4733417 2275628 2275628 defendant Dene John husbandman 731728 731728 Dene, John, of Wolferton, husbandman 4
4788199 2292381 2292381 defendant Galyon William clerk 731728 731728 Galyon, William, of Wolferton, clerk 0
4810107 2299312 2299312 defendant Scoule or Sconley Richard shipman 731728 731728 Scoule or Sconley, Richard, of Wolferton, shipman 1
4812846 2300135 2300135 defendant Gybbes William, junior husbandman 731728 731728 Gybbes, William, junior, of Wolferton, husbandman 0
4812847 2300135 2300135 defendant Twety Richard husbandman 731728 731728 Twety, Richard, of Wolferton, husbandman 1
4834570 2306820 2306820 defendant Baa John husbandman 731728 731728 Baa, John, of Wolferton, husbandman 0
4985198 2352504 2352504 defendant Hoghryon William husbandman 731728 731728 Hoghryon, William, of Wolferton, husbandman 0
5019261 2362524 2362524 defendant Godard William   731728 731728 Godard, William, of Wolferton, wright 8
5036262 2367457 2367457 defendant Godard William   731728 731728 Godard, William, of Wolferton, wright 5

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