names

58 rows where place_id = 587203

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590742 1864744 1864744 defendant Dowenyng John miller 587203 587203 Dowenyng, John, of Wychyngham, miller 0
3606218 1869614 1869614 defendant Arblaster James, junior gent 587203 587203 Arblaster, James, junior, of Wychyngham, gent 0
3639259 1907089 1907089 defendant Hamond Thomas yeoman 587203 587203 Hamond, Thomas, of Wychyngham, yeoman 0
3655582 1912008 1912008 defendant Reynes John husbandman 587203 587203 Reynes, John, of Wychyngham, husbandman 1
3679753 1919735 1919735 defendant Bevys Richard husbandman 587203 587203 Bevys, Richard, of Wychyngham, husbandman 3
3679760 1919736 1919736 defendant Bevys Richard husbandman 587203 587203 Bevys, Richard, of Wychyngham, husbandman 0
3746521 1940823 1940823 defendant Brome Robert smith 587203 587203 Brome, Robert, of Wychyngham, smith 1
3758831 1944749 1944749 defendant Frary Richard   587203 587203 Frary, Richard, of Wychyngham, ploughwright 0
3766446 1947163 1947163 defendant Popyll Richard miller 587203 587203 Popyll, Richard, of Wychyngham, miller 2
3766447 1947163 1947163 defendant Becham John husbandman 587203 587203 Becham, John, of Wychyngham, husbandman 3
3773113 1949293 1949293 defendant Frary William   587203 587203 Frary, William, of Wychyngham, worsted weaver 0
3779200 1951215 1951215 defendant Wright John husbandman 587203 587203 Wright, John, of Wychyngham, husbandman 1
3783306 1952530 1952530 defendant Barney Robert gent 587203 587203 Barney, Robert, of Wychyngham, gent 1
3810283 1961105 1961105 defendant Morleye William   587203 587203 Morleye, William, of Wychyngham, worsted weaver 3
3899062 1989896 1989896 plaintiff Barney Robert esq 587203 587203 Barney, Robert, of Wychyngham, esq 0
3903318 1991333 1991333 defendant Sander George   587203 587203 Sander, George, of Wychyngham, coverlet maker 2
3953499 2008295 2008295 plaintiff Jacobbe William yeoman 587203 587203 Jacobbe, William, of Wychyngham, yeoman 0
3953501 2008296 2008296 plaintiff Jacobbe William yeoman 587203 587203 Jacobbe, William, of Wychyngham, yeoman 0
3953504 2008297 2008297 plaintiff Jacobbe William yeoman 587203 587203 Jacobbe, William, of Wychyngham, yeoman 0
3956202 2009241 2009241 defendant Symond Robert husbandman 587203 587203 Symond, Robert, of Wychyngham, husbandman 1
3977890 2016840 2016840 defendant Davye Robert husbandman 587203 587203 Davye, Robert, of Wychyngham, husbandman 1
3988811 2020744 2020744 defendant Parker Richard yeoman 587203 587203 Parker, Richard, of Wychyngham, or of Old Buckenham, yeoman 0
4016311 2030529 2030529 defendant Vardyngton Nicholas husbandman 587203 587203 Vardyngton, Nicholas, of Wychyngham, husbandman 3
4066408 2048280 2048280 defendant Hull Thomas miller 587203 587203 Hull, Thomas, of Wychyngham, miller 0
4081977 2053854 2053854 defendant Braye Thomas (legal representative) 587203 587203 Braye, Thomas, of Wychyngham, yeoman, executrix of 2
4081978 2053854 2053854 defendant Braye Joan widow 587203 587203 Braye, Joan, of Wychyngham, widow 3
4414197 2169348 2169348 defendant Bacheler Edmund   587203 587203 Bacheler, Edmund, of Wychyngham 1
4420190 2171217 2171217 plaintiff Bretoun William le   587203 587203 Bretoun, William le, of Wychyngham 0
4423597 2172226 2172226 plaintiff Halle Giles de   587203 587203 Halle, Giles de, of Wychyngham 0
4431199 2174517 2174517 defendant Cote John, senior   587203 587203 Cote, John, senior, of Wychyngham 1
4454078 2186293 2186293 defendant Soutere Ralph   587203 587203 Soutere, Ralph, of Wychyngham 0
4671614 2256769 2256769 defendant Leveron John yeoman 587203 587203 Leveron, John, of Wychyngham, yeoman 0
4716821 2270588 2270588 defendant Cokefeld William miller 587203 587203 Cokefeld, William, of Wychyngham, miller 1
4751975 2281072 2281072 defendant Midilton William yeoman 587203 587203 Midilton, William, of Wychyngham, yeoman 0
4752051 2281088 2281088 defendant Feltwell Thomas yeoman 587203 587203 Feltwell, Thomas, of Wychyngham, yeoman 2
4756650 2282446 2282446 plaintiff Berney John esq 587203 587203 (Berney, John, of Wychyngham, esq 1
4758344 2282983 2282983 defendant Feltewell John yeoman 587203 587203 Feltewell, John, of Wychyngham, yeoman 0
4831214 2305793 2305793 defendant Feltwell Thomas yeoman 587203 587203 Feltwell, Thomas, of Wychyngham, yeoman 4
4860986 2314795 2314795 defendant Dounyng Thomas miller 587203 587203 Dounyng, Thomas, of Wychyngham, miller 2
4885045 2322217 2322217 defendant Smyth Ralph smith 587203 587203 Smyth, Ralph, of Wychyngham, smith 3
4888085 2323078 2323078 defendant Bylawe Peter laborer 587203 587203 Bylawe, Peter, of Wychyngham, laborer 0
4892238 2324313 2324313 defendant Berney John gent 587203 587203 Berney, John, of Wychyngham, gent 4
4918914 2332430 2332430 defendant Dalham Thomas husbandman 587203 587203 Dalham, Thomas, of Wychyngham, husbandman 2
4943929 2340067 2340067 defendant Torell Thomas husbandman 587203 587203 Torell, Thomas, of Wychyngham, husbandman 0
4975575 2349649 2349649 plaintiff Newe Peter   587203 587203 Newe, Peter, of Wychyngham 1
5156140 2402955 2402955 defendant Bilyot John yeoman 587203 587203 Bilyot, John, of Wychyngham, yeoman 3
5253058 2431061 2431061 defendant Belyet John yeoman 587203 587203 Belyet, John, of Wychyngham, yeoman 1
5527242 2513099 2513099 defendant Marston John   587203 587203 Marston, John, of Wychyngham, brick burner 0
5553755 2521134 2521134 defendant Brese John husbandman 587203 587203 Brese, John, of Wychyngham, husbandman 1
5594099 2533132 2533132 defendant Bakon Richard husbandman 587203 587203 Bakon, Richard, of Wychyngham, husbandman 0
5625945 2552071 2552071 defendant Middelton William   587203 587203 Middelton, William, of Wychyngham, franklin 0
5626444 2552243 2552243 defendant Dowenyngge Richard yeoman 587203 587203 Dowenyngge, Richard, of Wychyngham, yeoman 1
5630802 2553640 2553640 defendant Wyght William husbandman 587203 587203 Wyght, William, of Wychyngham, husbandman 0
5630803 2553640 2553640 defendant Byrcher John chaplain 587203 587203 Byrcher, John, of Wychyngham, chaplain 1
5630804 2553640 2553640 defendant Huberd Alice widow of Thomas Huberd 587203 587203 Huberd, Alice, of Wychyngham, widow of Thomas Huberd 2
5634641 2554832 2554832 defendant Pykerell John yeoman 587203 587203 Pykerell, John, of Wychyngham, yeoman 0
5636260 2555300 2555300 defendant Leem Andrew miller 587203 587203 Leem, Andrew, of Wychyngham, miller 0
5636448 2555353 2555353 defendant Feltwell Thomas yeoman 587203 587203 Feltwell, Thomas, of Wychyngham, yeoman 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);