names

34 rows where place_id = 600125

✎ 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
3639802 1907260 1907260 plaintiff Woode William yeoman 600125 600125 Woode, William, of Palgrave, Suff, yeoman 0
3677760 1919091 1919091 defendant Prentyse John husbandman 600125 600125 Prentyse, John, of Palgrave, Suff, husbandman 3
3749939 1941897 1941897 defendant Smyth William clerk 600125 600125 Smyth, William, of Palgrave, Suff, clerk 0
3765172 1946769 1946769 defendant Smyth William clerk 600125 600125 Smyth, William, of Palgrave, Suff, clerk 0
3864015 1978145 1978145 defendant Prentyce John husbandman 600125 600125 Prentyce, John, of Palgrave, Suff, husbandman 3
3864264 1978241 1978241 defendant Lorde Robert husbandman 600125 600125 Lorde, Robert, of Palgrave, Suff, husbandman 0
3869515 1980047 1980047 defendant Lorde Robert husbandman 600125 600125 Lorde, Robert, of Palgrave, Suff, husbandman 0
3963746 2011923 2011923 defendant Leveryche Anthony shoemaker 600125 600125 Leveryche, Anthony, of Palgrave, Suff, shoemaker 0
4031161 2035816 2035816 defendant Pulleyn Nicholas clerk 600125 600125 Pulleyn, Nicholas, of Palgrave, Suff, clerk 1
4132061 2071778 2071778 defendant Bowde John yeoman 600125 600125 Bowde, John, of Palgrave, Suff, yeoman 2
4167877 2084249 2084249 defendant Bowde John tailor 600125 600125 Bowde, John, of Palgrave, Suff, tailor 1
4184240 2089985 2089985 defendant Skeete John   600125 600125 Skeete, John, of Palgrave, Suff, clerk, parson of Kylmyngton, Soms 0
4223575 2103734 2103734 defendant Earle John tailor 600125 600125 Earle, John, of Palgrave, Suff, tailor 1
4250187 2113044 2113044 defendant Hendrye Thomas butcher 600125 600125 Hendrye, Thomas, of Palgrave, Suff, butcher 0
4250189 2113045 2113045 defendant Hendrye Thomas butcher 600125 600125 Hendrye, Thomas, of Palgrave, Suff, butcher 0
4259603 2116189 2116189 defendant Sympson John weaver 600125 600125 Sympson, John, of Palgrave, Suff, weaver 0
4276794 2121815 2121815 defendant Allen Daniel carpenter 600125 600125 Allen, Daniel, of Palgrave, Suff, carpenter 3
4277674 2122116 2122116 defendant Rix Edward yeoman 600125 600125 Rix, Edward, of Palgrave, Suff, yeoman 0
4288153 2125814 2125814 defendant Allen Daniel carpenter 600125 600125 Allen, Daniel, of Palgrave, Suff, carpenter 0
4289360 2126254 2126254 defendant Alger Henry potter 600125 600125 Alger, Henry, of Palgrave, Suff, potter 2
4328513 2139852 2139852 defendant Artys William tailor 600125 600125 Artys, William, of Palgrave, Suff, tailor 0
4335090 2142008 2142008 defendant Maye Richard laborer 600125 600125 Maye, Richard, of Palgrave, Suff, laborer 3
4349682 2147155 2147155 defendant Hendrye Thomas butcher 600125 600125 Hendrye, Thomas, of Palgrave, Suff, butcher 1
4401912 2165236 2165236 defendant Hendrye Thomas butcher 600125 600125 Hendrye, Thomas, of Palgrave, Suff, butcher 1
4768037 2285971 2285971 defendant Fulchier Robert chandler 600125 600125 Fulchier, Robert, of Palgrave, Suff, chandler 0
4792204 2293650 2293650 defendant Fulcher Robert chandler 600125 600125 Fulcher, Robert, of Palgrave, Suff, chandler 0
4865332 2316127 2316127 defendant Palgrave alias Prentys Hugh husbandman or yeoman 600125 600125 Palgrave alias Prentys, Hugh, of Palgrave, Suff, husbandman or yeoman 2
4995365 2355456 2355456 defendant Shireve John yeoman 600125 600125 Shireve, John, of Palgrave, Suff, yeoman 2
5078171 2379957 2379957 defendant Sheref William yeoman 600125 600125 Sheref, William, of Palgrave, Suff, yeoman 2
5133163 2396178 2396178 defendant Rose John husbandman 600125 600125 Rose, John, of Palgrave, Suff, husbandman 0
5136262 2397123 2397123 defendant Fulcher Thomas husbandman 600125 600125 Fulcher, Thomas, of Palgrave, Suff, husbandman 1
5156608 2403087 2403087 defendant Fulcher Thomas husbandman 600125 600125 Fulcher, Thomas, of Palgrave, Suff, husbandman 1
5182415 2410613 2410613 defendant Shirreve John husbandman 600125 600125 Shirreve, John, of Palgrave, Suff, husbandman 0
5409984 2477956 2477956 defendant Fulcher Thomas husbandman 600125 600125 Fulcher, Thomas, of Palgrave, Suff, 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);