names

39 rows where place_id = 600850

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642832 1908206 1908206 defendant Reder John yeoman 600850 600850 Reder, John, of Petersfeld, yeoman 1
3642833 1908206 1908206 defendant Randolf John yeoman 600850 600850 Randolf, John, of Petersfeld, yeoman 2
3651123 1910718 1910718 defendant Grove Robert butcher 600850 600850 Grove, Robert, of Petersfeld, butcher 1
3651124 1910718 1910718 defendant Nutley John husbandman 600850 600850 Nutley, John, of Petersfeld, husbandman 2
3651125 1910718 1910718 defendant Stampe Edmund tailor 600850 600850 Stampe, Edmund, of Petersfeld, tailor 3
3651126 1910718 1910718 defendant Barowe Henry innholder 600850 600850 Barowe, Henry, of Petersfeld, innholder 4
3651127 1910718 1910718 defendant Selwode Thomas dyer 600850 600850 Selwode, Thomas, of Petersfeld, dyer 5
3651128 1910718 1910718 defendant Fry John butcher 600850 600850 Fry, John, of Petersfeld, butcher 6
3651132 1910719 1910719 defendant Grove Robert butcher 600850 600850 Grove, Robert, of Petersfeld, butcher 1
3651133 1910719 1910719 defendant Nutley John husbandman 600850 600850 Nutley, John, of Petersfeld, husbandman 2
3651134 1910719 1910719 defendant Stampe Edmund tailor 600850 600850 Stampe, Edmund, of Petersfeld, tailor 3
3651135 1910719 1910719 defendant Barowe Henry inngolder 600850 600850 Barowe, Henry, of Petersfeld, inngolder 4
3651136 1910719 1910719 defendant Selwode Thomas dyer 600850 600850 Selwode, Thomas, of Petersfeld, dyer 5
3651137 1910719 1910719 defendant Frye John butcher 600850 600850 Frye, John, of Petersfeld, butcher 6
3736647 1937713 1937713 defendant Fletcher John fletcher 600850 600850 Fletcher, John, of Petersfeld, fletcher 3
3752805 1942801 1942801 defendant Fylder William yeoman 600850 600850 Fylder, William, of Petersfeld, yeoman 0
3794287 1956087 1956087 defendant Selwood John husbandman 600850 600850 Selwood, John, of Petersfeld, husbandman 0
3794288 1956087 1956087 defendant att Wode Richard husbandman 600850 600850 att Wode, Richard, of Petersfeld, husbandman 1
3801055 1958244 1958244 defendant Randall Richard yeoman 600850 600850 Randall, Richard, of Petersfeld, yeoman 3
3802755 1958758 1958758 defendant Selwode John yeoman 600850 600850 Selwode, John, of Petersfeld, yeoman 0
3803474 1958990 1958990 defendant Grove Thomas weaver 600850 600850 Grove, Thomas, of Petersfeld, weaver 0
3811297 1961429 1961429 defendant At Woode Richard husbandman 600850 600850 At Woode, Richard, of Petersfeld, husbandman 1
3913667 1994911 1994911 defendant Gobbe Alice widow 600850 600850 Gobbe, Alice, of Petersfeld, widow 1
3929420 2000183 2000183 defendant Bensted Andrew clothier 600850 600850 Bensted, Andrew, of Petersfeld, clothier 4
3956780 2009439 2009439 plaintiff Pakelsham John clothier 600850 600850 Pakelsham, John, of Petersfeld, clothier 0
3986880 2020050 2020050 plaintiff Wolger Richard   600850 600850 Wolger, Richard, of Petersfeld 0
3990816 2021475 2021475 plaintiff Bold Elizabeth   600850 600850 Bold, Elizabeth, of Petersfeld 0
3990820 2021476 2021476 defendant Westbroke Rpbert tailor 600850 600850 Westbroke, Rpbert, of Petersfeld, tailor 0
4024613 2033482 2033482 plaintiff Bold William yeoman 600850 600850 Bold, William, of Petersfeld, yeoman 0
4165459 2083421 2083421 defendant Trigg or trigges Gregory weaver 600850 600850 Trigg or trigges, Gregory, of Petersfeld, weaver 0
4171832 2085608 2085608 defendant Champion Richard husbandman 600850 600850 Champion, Richard, of Petersfeld, husbandman 0
4172661 2085897 2085897 defendant Paglesham John clothier 600850 600850 Paglesham, John, of Petersfeld, clothier 2
4174928 2086696 2086696 defendant Bolde Thomas sherman 600850 600850 Bolde, Thomas, of Petersfeld, sherman 2
4198227 2094926 2094926 defendant Fylder John   600850 600850 Fylder, John, of Petersfeld, or of Medhurst, Sussex clothier 0
4465881 2189995 2189995 defendant Gonde William   600850 600850 Gonde, William, of Petersfeld 0
5287340 2441320 2441320 defendant Fry Henry laborer 600850 600850 Fry, Henry, of Petersfeld, laborer 0
5408792 2477589 2477589 defendant Frenssh John weaver 600850 600850 Frenssh, John, of Petersfeld, weaver 0
5528090 2513350 2513350 defendant Grove William husbandman 600850 600850 Grove, William, of Petersfeld, husbandman 0
5528091 2513350 2513350 defendant Felder William husbandman 600850 600850 Felder, William, of Petersfeld, husbandman 1

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