names

22 rows where place_id = 600590

✎ 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
3641663 1907850 1907850 defendant West Simon husbandman 600590 600590 West, Simon, of Hangyng Houghton, husbandman 0
3648874 1910038 1910038 plaintiff Palmer William   600590 600590 Palmer, William, of Hangyng Houghton 0
3648875 1910038 1910038 defendant Wellys Humphrey gent 600590 600590 Wellys, Humphrey, of Hangyng Houghton, gent 0
3652870 1911223 1911223 defendant Palmer William husbandman 600590 600590 Palmer, William, of Hangyng Houghton, husbandman 0
4841903 2309002 2309002 defendant Heuke or Henke Simon husbandman 600590 600590 Heuke or Henke, Simon, of Hangyng Houghton, husbandman 1
4841906 2309003 2309003 defendant Heuke or Henke Simon husbandman 600590 600590 Heuke or Henke, Simon, of Hangyng Houghton, husbandman 1
4893117 2324564 2324564 defendant Mordys John husbandman 600590 600590 Mordys, John, of Hangyng Houghton, husbandman 1
4987486 2353213 2353213 defendant Mountagu Richard yeoman 600590 600590 Mountagu, Richard, of Hangyng Houghton, yeoman 0
4987487 2353213 2353213 defendant Mountagu John husbandman 600590 600590 Mountagu, John, of Hangyng Houghton, husbandman 1
5021270 2363121 2363121 defendant Mountagu Richard yeoman 600590 600590 Mountagu, Richard, of Hangyng Houghton, yeoman 0
5030474 2365784 2365784 defendant Mountagu Richard yeoman 600590 600590 Mountagu, Richard, of Hangyng Houghton, yeoman 1
5030492 2365788 2365788 defendant Montagu Richard yeoman 600590 600590 Montagu, Richard, of Hangyng Houghton, yeoman 1
5045374 2370245 2370245 defendant Ladde alias Montagu Richard yeoman 600590 600590 Ladde alias Montagu, Richard, of Hangyng Houghton, yeoman 0
5083596 2381597 2381597 defendant Hynke Thomas yeoman 600590 600590 Hynke, Thomas, of Hangyng Houghton, yeoman 2
5163135 2404948 2404948 defendant Mountagu alias Ladde Richard yeoman 600590 600590 Mountagu alias Ladde, Richard, of Hangyng Houghton, yeoman 0
5163136 2404948 2404948 defendant Gyllam Simon husbandman 600590 600590 Gyllam, Simon, of Hangyng Houghton, husbandman 1
5199551 2415614 2415614 defendant Mountagu Richard yeoman 600590 600590 Mountagu, Richard, of Hangyng Houghton, yeoman 0
5199552 2415614 2415614 defendant Gyllam Simon   600590 600590 Gyllam, Simon, of Hangyng Houghton 1
5211142 2418986 2418986 defendant Mountagu Richard yeoman 600590 600590 Mountagu, Richard, of Hangyng Houghton, yeoman 0
5211143 2418986 2418986 defendant Gyllam Simon husbandman 600590 600590 Gyllam, Simon, of Hangyng Houghton, husbandman 1
5373947 2467447 2467447 defendant Kyng John   600590 600590 Kyng, John, of Hangyng Houghton 0
5513240 2508991 2508991 defendant Randell Richard husbandman 600590 600590 Randell, Richard, of Hangyng Houghton, husbandman 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);