names

32 rows where place_id = 590789

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602320 1868389 1868389 defendant Wreke John husbandman 590789 590789 Wreke, John, of Halstowe, husbandman 1
3602321 1868389 1868389 defendant Swyfte John husbandman 590789 590789 Swyfte, John, of Halstowe, husbandman 2
3602322 1868389 1868389 defendant Yonge William husbandman 590789 590789 Yonge, William, of Halstowe, husbandman 3
3602323 1868389 1868389 defendant Baldry Richard husbandman 590789 590789 Baldry, Richard, of Halstowe, husbandman 4
3641588 1907829 1907829 defendant Love John husbandman 590789 590789 Love, John, of Halstowe, husbandman 1
3693127 1924060 1924060 defendant Austed Leonard husbandman 590789 590789 Austed, Leonard, of Halstowe, husbandman 0
3695333 1924765 1924765 defendant Lorett alias Witherley Ralph miller 590789 590789 Lorett alias Witherley, Ralph, of Halstowe, miller 0
3707411 1928610 1928610 defendant Ansty or Austy Lionel gent 590789 590789 Ansty or Austy, Lionel, of Halstowe, gent 0
3737918 1938078 1938078 defendant Love John weaver 590789 590789 Love, John, of Halstowe, weaver 3
3839785 1970372 1970372 defendant Leve alias Love John (legal representative) 590789 590789 Leve alias Love, John, of Halstowe, yeoman, executors of 0
3839786 1970372 1970372 defendant Leve Joan widow 590789 590789 (Leve, Joan, of Halstowe, widow 1
3839787 1970372 1970372 defendant Cobham William gent 590789 590789 Cobham, William, of Halstowe, gent 2
3839788 1970372 1970372 defendant Sumer Thomas yeoman 590789 590789 Sumer, Thomas, of Halstowe, yeoman 3
4006116 2026959 2026959 defendant Byles Thomas yeoman 590789 590789 Byles, Thomas, of Halstowe, yeoman 0
4090029 2056716 2056716 defendant Austen Stephen laborer 590789 590789 Austen, Stephen, of Halstowe, laborer 2
4314033 2135017 2135017 defendant Date William (legal representative) 590789 590789 Date, William, of Halstowe, miller, administratrix of 2
4314034 2135017 2135017 defendant Date Anne widow 590789 590789 Date, Anne, of Halstowe, widow 3
4376368 2156618 2156618 defendant Walsingham Robert yeoman 590789 590789 Walsingham, Robert, of Halstowe, yeoman 1
4402242 2165336 2165336 defendant Butler Philip miller 590789 590789 Butler, Philip, of Halstowe, miller 1
4713225 2269461 2269461 defendant Charles Margaret widow 590789 590789 Charles, Margaret, of Halstowe, widow 0
4713227 2269462 2269462 defendant Waryn Robert laborer 590789 590789 Waryn, Robert, of Halstowe, laborer 0
4758005 2282879 2282879 defendant Pycharde John yeoman 590789 590789 Pycharde, John, of Halstowe, yeoman 1
5094825 2384899 2384899 defendant Rolf John husbandman 590789 590789 Rolf, John, of Halstowe, husbandman 0
5138761 2397834 2397834 defendant Hyllynge Richard   590789 590789 Hyllynge, Richard, of Halstowe, vicar & chaplain 0
5249947 2430095 2430095 defendant Shernewell John butcher 590789 590789 Shernewell, John, of Halstowe, butcher 4
5269840 2436285 2436285 defendant Neweman John husbandman 590789 590789 Neweman, John, of Halstowe, husbandman 4
5507893 2507368 2507368 defendant Benet John husbandman 590789 590789 Benet, John, of Halstowe, husbandman 0
5507894 2507368 2507368 defendant Blossom Thurstan laborer 590789 590789 Blossom, Thurstan, of Halstowe, laborer 1
5517871 2510431 2510431 defendant Shernwell John carpenter 590789 590789 Shernwell, John, of Halstowe, carpenter 0
5585085 2530405 2530405 defendant A Dake Robert husbandman 590789 590789 A Dake, Robert, of Halstowe, husbandman 2
5606897 2537045 2537045 defendant Hurton Thomas husbandman 590789 590789 Hurton, Thomas, of Halstowe, husbandman 1
5609361 2537826 2537826 defendant Rolff John husbandman 590789 590789 Rolff, John, of Halstowe, husbandman 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);