names

30 rows where place_id = 610336

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3683073 1920821 1920821 defendant Corne John, senior husbandman 610336 610336 Corne, John, senior, of Mordon, husbandman 0
3683074 1920821 1920821 defendant Taperet John laborer 610336 610336 Taperet, John, of Mordon, laborer 1
3683075 1920821 1920821 defendant Corne John, junior husbandman 610336 610336 Corne, John, junior, of Mordon, husbandman 2
4094440 2058351 2058351 defendant Sloo alias Slece John husbandman 610336 610336 Sloo alias Slece, John, of Mordon, husbandman 0
4106831 2062736 2062736 defendant Addams Richard husbandman 610336 610336 Addams, Richard, of Mordon, husbandman 0
4150419 2078276 2078276 defendant Kneppe Robert yeoman 610336 610336 Kneppe, Robert, of Mordon, yeoman 0
4150421 2078277 2078277 defendant Everest Thomas yeoman 610336 610336 Everest, Thomas, of Mordon, yeoman 0
4150424 2078278 2078278 defendant Everest Thomas yeoman 610336 610336 Everest, Thomas, of Mordon, yeoman 1
4183433 2089685 2089685 defendant Golde John yeoman 610336 610336 Golde, John, of Mordon, yeoman 1
4184170 2089958 2089958 defendant Baker Richard husbandman 610336 610336 Baker, Richard, of Mordon, husbandman 2
4253880 2114295 2114295 defendant Anstye or Austye Richard yeoman 610336 610336 Anstye or Austye, Richard, of Mordon, yeoman 2
4445819 2183637 2183637 defendant Strate Hugh   610336 610336 Strate, Hugh, of Mordon 2
4491352 2197981 2197981 defendant Prentys John   610336 610336 Prentys, John, of Mordon 0
4590462 2228375 2228375 defendant Taillour William   610336 610336 Taillour, William, of Mordon 0
4702358 2266147 2266147 defendant Deynhouse William husbandman 610336 610336 Deynhouse, William, of Mordon, husbandman 1
4713153 2269439 2269439 defendant White John clerk 610336 610336 White, John, of Mordon, clerk 0
4713162 2269442 2269442 defendant White John clerk 610336 610336 White, John, of Mordon, clerk 0
4760417 2283609 2283609 defendant Syward John laborer 610336 610336 Syward, John, of Mordon, laborer 3
4760418 2283609 2283609 defendant Lange Thomas husbandman 610336 610336 Lange, Thomas, of Mordon, husbandman 4
4889258 2323426 2323426 defendant Baker Robert husbandman 610336 610336 Baker, Robert, of Mordon, husbandman 0
4901992 2327226 2327226 defendant Baker Nicholas, senior husbandman 610336 610336 Baker, Nicholas, senior, of Mordon, husbandman 0
4901993 2327226 2327226 defendant Baker Nicholas, junior husbandman 610336 610336 Baker, Nicholas, junior, of Mordon, husbandman 1
4916949 2331803 2331803 defendant Marshall Richard gent 610336 610336 Marshall, Richard, of Mordon, gent 0
4926061 2334579 2334579 defendant Frankelyne John   610336 610336 Frankelyne, John, of Mordon, frary clerk or fraternity clerk 2
4991422 2354318 2354318 defendant Patche John husbandman 610336 610336 Patche, John, of Mordon, husbandman 9
5033561 2366699 2366699 defendant Burword John husbandman 610336 610336 Burword, John, of Mordon, husbandman 3
5255445 2431823 2431823 defendant Gylle John husbandman 610336 610336 Gylle, John, of Mordon, husbandman 3
5464898 2494415 2494415 defendant Godfrey John yeoman 610336 610336 Godfrey, John, of Mordon, yeoman 0
5476407 2497946 2497946 defendant Godfrey John yeoman 610336 610336 Godfrey, John, of Mordon, yeoman 0
5487914 2501276 2501276 defendant Godfrey John yeoman 610336 610336 Godfrey, John, of Mordon, yeoman 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);