names

47 rows where place_id = 588540

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594872 1866026 1866026 defendant Bradenham John husbandman 588540 588540 Bradenham, John, of Parva Dunham, husbandman 1
3625700 1875576 1875576 defendant Cok John laborer 588540 588540 Cok, John, of Parva Dunham, laborer 0
3646611 1909345 1909345 defendant Frost Adam carpenter 588540 588540 Frost, Adam, of Parva Dunham, carpenter 2
3694949 1924630 1924630 defendant Frost Adam carpenter 588540 588540 Frost, Adam, of Parva Dunham, carpenter 2
3703903 1927501 1927501 defendant Hawke Giles husbandman 588540 588540 Hawke, Giles, of Parva Dunham, husbandman 0
3711061 1929771 1929771 defendant Broun John weaver 588540 588540 Broun, John, of Parva Dunham, weaver 0
3711062 1929771 1929771 defendant Smyth William husbandman 588540 588540 Smyth, William, of Parva Dunham, husbandman 1
3773893 1949546 1949546 defendant Wodcok Thomas husbandman 588540 588540 Wodcok, Thomas, of Parva Dunham, husbandman 0
3785812 1953349 1953349 defendant Wurre John   588540 588540 Wurre, John, of Parva Dunham 3
3809442 1960835 1960835 defendant Blomfeld George yeoman 588540 588540 Blomfeld, George, of Parva Dunham, yeoman 1
3840348 1970549 1970549 defendant Bradenham John   588540 588540 Bradenham, John, of Parva Dunham, wheel wright 0
3840349 1970549 1970549 defendant Bradenham William husbandman 588540 588540 Bradenham, William, of Parva Dunham, husbandman 1
3840350 1970549 1970549 defendant Burton Thomas husbandman 588540 588540 Burton, Thomas, of Parva Dunham, husbandman 2
3840351 1970549 1970549 defendant Mendham Henry husbandman 588540 588540 Mendham, Henry, of Parva Dunham, husbandman 3
3840352 1970549 1970549 defendant Ives William tailor 588540 588540 Ives, William, of Parva Dunham, tailor 4
3840355 1970550 1970550 defendant Bradenham John   588540 588540 Bradenham, John, of Parva Dunham, wheelwright 0
3840356 1970550 1970550 defendant Mendham Henry husbandman 588540 588540 Mendham, Henry, of Parva Dunham, husbandman 1
3840357 1970550 1970550 defendant Bradenham William husbandman 588540 588540 Bradenham, William, of Parva Dunham, husbandman 2
3840358 1970550 1970550 defendant Ives William tailor 588540 588540 Ives, William, of Parva Dunham, tailor 3
3840359 1970550 1970550 defendant Burton Thomas husbandman 588540 588540 Burton, Thomas, of Parva Dunham, husbandman 4
3843004 1971342 1971342 defendant Alpe Thomas yeoman 588540 588540 Alpe, Thomas, of Parva Dunham, yeoman 0
3845626 1972173 1972173 defendant Blomefeld George yeoman 588540 588540 Blomefeld, George, of Parva Dunham, yeoman 0
3862734 1977728 1977728 defendant Blomfeld George yeoman 588540 588540 Blomfeld, George, of Parva Dunham, yeoman 0
3864487 1978322 1978322 defendant Blomfyld George yeoman 588540 588540 Blomfyld, George, of Parva Dunham, yeoman 1
3890360 1987026 1987026 defendant Mendam Henry husbandman 588540 588540 Mendam, Henry, of Parva Dunham, husbandman 1
3890385 1987037 1987037 defendant Blomefeld George yeoman 588540 588540 Blomefeld, George, of Parva Dunham, yeoman 0
3893320 1987998 1987998 defendant Blomfeld George yeoman 588540 588540 Blomfeld, George, of Parva Dunham, yeoman 0
3893322 1987999 1987999 defendant Blomfeld George yeoman 588540 588540 Blomfeld, George, of Parva Dunham, yeoman 0
3898261 1989627 1989627 defendant Fyckes Thomas husbandman 588540 588540 Fyckes, Thomas, of Parva Dunham, husbandman 1
3904019 1991585 1991585 defendant Alpe Thomas gent 588540 588540 Alpe, Thomas, of Parva Dunham, gent 0
3913231 1994755 1994755 defendant Mendam Henry husbandman 588540 588540 Mendam, Henry, of Parva Dunham, husbandman 3
4182263 2089273 2089273 defendant Blomefeld William yeoman 588540 588540 Blomefeld, William, of Parva Dunham, yeoman 2
4182267 2089274 2089274 defendant Blomefeild William yeoman 588540 588540 Blomefeild, William, of Parva Dunham, yeoman 2
4192577 2092966 2092966 defendant Alpe William husbandman 588540 588540 Alpe, William, of Parva Dunham, husbandman 0
4297994 2129386 2129386 defendant Mawood Edmund laborer 588540 588540 Mawood, Edmund, of Parva Dunham, laborer 1
4297995 2129386 2129386 defendant Somer Gregory laborer 588540 588540 Somer, Gregory, of Parva Dunham, laborer 2
5061227 2374941 2374941 defendant Greswell John clerk 588540 588540 Greswell, John, of Parva Dunham, clerk 1
5061235 2374942 2374942 defendant Greswell John clerk 588540 588540 Greswell, John, of Parva Dunham, clerk 3
5085013 2382029 2382029 defendant Greswes John clerk 588540 588540 Greswes, John, of Parva Dunham, clerk 1
5085021 2382030 2382030 defendant Greswell John clerk 588540 588540 Greswell, John, of Parva Dunham, clerk 3
5264871 2434772 2434772 defendant Rokehawe John husbandman 588540 588540 Rokehawe, John, of Parva Dunham, husbandman 1
5545442 2518656 2518656 defendant Norman William yeoman 588540 588540 Norman, William, of Parva Dunham, yeoman 1
5557662 2522198 2522198 defendant Wynne Christopher clerk 588540 588540 Wynne, Christopher, of Parva Dunham, clerk 2
5557747 2522214 2522214 defendant Wynne Christopher clerk 588540 588540 Wynne, Christopher, of Parva Dunham, clerk 1
5559997 2522879 2522879 defendant Gogney Robert husbandman 588540 588540 Gogney, Robert, of Parva Dunham, husbandman 2
5603743 2536041 2536041 defendant Gogney Robert husbandman 588540 588540 Gogney, Robert, of Parva Dunham, husbandman 0
5604769 2536354 2536354 defendant Frost Adam carpenter 588540 588540 Frost, Adam, of Parva Dunham, carpenter 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);