names

33 rows where place_id = 618637

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3725680 1934318 1934318 defendant Wyghtyng John yeoman 618637 618637 Wyghtyng, John, of Brantham, Suff, yeoman 0
3725682 1934319 1934319 defendant Wyghtyng John yeoman 618637 618637 Wyghtyng, John, of Brantham, Suff, yeoman 0
3805000 1959508 1959508 defendant Whytyng John yeoman 618637 618637 Whytyng, John, of Brantham, Suff, yeoman 0
3813097 1962005 1962005 plaintiff Derhawgh Robert gent 618637 618637 Derhawgh, Robert, of Brantham, Suff, gent 0
3825296 1965767 1965767 defendant Wyngfeld Humphrey esq 618637 618637 Wyngfeld, Humphrey, of Brantham, Suff, esq 0
3862119 1977517 1977517 defendant Whytyng John yeoman 618637 618637 Whytyng, John, of Brantham, Suff, yeoman 0
3862122 1977518 1977518 defendant Whytyng John yeoman 618637 618637 Whytyng, John, of Brantham, Suff, yeoman 0
3868217 1979604 1979604 defendant Whytyng John yeoman 618637 618637 Whytyng, John, of Brantham, Suff, yeoman 0
3938935 2003355 2003355 defendant Smyth Robert husbandman 618637 618637 Smyth, Robert, of Brantham, Suff, husbandman 2
3951641 2007628 2007628 defendant Beryf William gent 618637 618637 Beryf, William, of Brantham, Suff, or of Colchester, gent 0
3954925 2008787 2008787 defendant Wyngfeld Humphrey gent 618637 618637 Wyngfeld, Humphrey, of Brantham, Suff, gent 1
3959603 2010452 2010452 defendant Wyngfeld Humphrey gent 618637 618637 Wyngfeld, Humphrey, of Brantham, Suff, gent 0
3959605 2010453 2010453 defendant Wyngfyld Humphrey gent 618637 618637 Wyngfyld, Humphrey, of Brantham, Suff, gent 0
4006901 2027243 2027243 defendant Wyngfild Humphrey gent 618637 618637 Wyngfild, Humphrey, of Brantham, Suff, gent 5
4021481 2032409 2032409 plaintiff Wyngefeld Humphrey esq 618637 618637 Wyngefeld, Humphrey, of Brantham, Suff, esq 0
4055261 2044280 2044280 defendant Winckefeld Humphrey gent 618637 618637 Winckefeld, Humphrey, of Brantham, Suff, gent 1
4117928 2066701 2066701 defendant Clerk John, junior clothier 618637 618637 Clerk, John, junior, of Brantham, Suff, clothier 3
4360545 2150940 2150940 defendant Phillipps Richard yeoman 618637 618637 Phillipps, Richard, of Brantham, Suff, yeoman 0
4405988 2166568 2166568 defendant Brett Thomas joiner 618637 618637 Brett, Thomas, of Brantham, Suff, joiner 0
4405991 2166569 2166569 defendant Brett Thomas joiner 618637 618637 Brett, Thomas, of Brantham, Suff, joiner 0
4660695 2249167 2249167 defendant Mopetyt William gent 618637 618637 Mopetyt, William, of Brantham, Suff, gent 1
4968465 2347536 2347536 defendant Pynot John weaver 618637 618637 Pynot, John, of Brantham, Suff, weaver 0
5033360 2366636 2366636 defendant Wade Richard husbandman 618637 618637 Wade, Richard, of Brantham, Suff, husbandman 0
5044303 2369927 2369927 defendant Cranefen William weaver 618637 618637 Cranefen, William, of Brantham, Suff, weaver 3
5086022 2382303 2382303 defendant Cranefen William weaver 618637 618637 Cranefen, William, of Brantham, Suff, weaver 3
5386777 2471284 2471284 defendant Wodward William husbandman 618637 618637 Wodward, William, of Brantham, Suff, husbandman 3
5399200 2474840 2474840 defendant Wodward William husbandman 618637 618637 Wodward, William, of Brantham, Suff, husbandman 3
5468797 2495596 2495596 plaintiff Colman John miller 618637 618637 Colman, John, of Brantham, Suff, miller 0
5479843 2498983 2498983 plaintiff Colman John miller 618637 618637 Colman, John, of Brantham, Suff, miller 0
5479847 2498984 2498984 plaintiff Colman John miller 618637 618637 Colman, John, of Brantham, Suff, miller 0
5583883 2530039 2530039 defendant Wyngefeld Humphrey esq 618637 618637 Wyngefeld, Humphrey, of Brantham, Suff, esq 2
5583890 2530040 2530040 defendant Wyngefeld Humphrey esq 618637 618637 Wyngefeld, Humphrey, of Brantham, Suff, esq 2
5585600 2530566 2530566 defendant Wyngefeld Humphrey esq 618637 618637 Wyngefeld, Humphrey, of Brantham, Suff, esq 3

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