names

71 rows where place_id = 587759

✎ 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
3592356 1865225 1865225 defendant Grave Thomas yeoman 587759 587759 Grave, Thomas, of Nedeham, yeoman 0
3641117 1907668 1907668 plaintiff Baly Robert   587759 587759 Baly, Robert, of Nedeham 1
3656737 1912361 1912361 defendant Studde Richard mercer 587759 587759 Studde, Richard, of Nedeham, mercer 0
3762998 1946057 1946057 defendant Moyse Anthony husbandman 587759 587759 Moyse, Anthony, of Nedeham, husbandman 2
3780506 1951633 1951633 defendant Lynge Thomas husbandman 587759 587759 Lynge, Thomas, of Nedeham, husbandman 3
3783361 1952545 1952545 defendant Brown Thomas husbandman 587759 587759 Brown, Thomas, of Nedeham, husbandman 1
3896245 1988952 1988952 defendant Chycheley John sherman 587759 587759 Chycheley, John, of Nedeham, sherman 1
3922131 1997721 1997721 defendant Harvy Nicholas   587759 587759 Harvy, Nicholas, of Nedeham, brick burner 0
3922137 1997722 1997722 defendant Harvy Nicholas   587759 587759 Harvy, Nicholas, of Nedeham, brick burner 0
3931447 2000816 2000816 defendant Dowesyng Robert   587759 587759 Dowesyng, Robert, of Nedeham, pedlar 0
3977584 2016730 2016730 plaintiff Losse Margaret   587759 587759 (Losse, Margaret, of Nedeham 1
3986524 2019921 2019921 defendant Uttyng Edward yeoman 587759 587759 Uttyng, Edward, of Nedeham, yeoman 2
3991559 2021741 2021741 defendant Cott or Cotes William clothier 587759 587759 Cott or Cotes, William, of Nedeham, clothier 1
3991560 2021741 2021741 defendant Cott or Cotes Thomas clothier 587759 587759 Cott or Cotes, Thomas, of Nedeham, clothier 2
4003203 2025906 2025906 defendant Baker John miller 587759 587759 Baker, John, of Nedeham, miller 0
4003597 2026050 2026050 defendant Losse William yeoman 587759 587759 Losse, William, of Nedeham, yeoman 0
4033040 2036467 2036467 defendant Gurney Stephen yeoman 587759 587759 Gurney, Stephen, of Nedeham, yeoman 0
4033042 2036468 2036468 defendant Gurney Stephen yeoman 587759 587759 Gurney, Stephen, of Nedeham, yeoman 0
4050509 2042609 2042609 defendant Cotes Thomas clothier 587759 587759 Cotes, Thomas, of Nedeham, clothier 0
4063745 2047319 2047319 defendant Fenn William husbandman 587759 587759 Fenn, William, of Nedeham, husbandman 1
4063751 2047320 2047320 defendant Taylour William husbandman 587759 587759 Taylour, William, of Nedeham, husbandman 2
4078902 2052751 2052751 defendant Freman William yeoman 587759 587759 Freman, William, of Nedeham, yeoman 1
4088053 2056025 2056025 defendant Cotes Robert, junior clothier 587759 587759 Cotes, Robert, junior, of Nedeham, clothier 0
4088055 2056026 2056026 defendant Cotes Simon clothier 587759 587759 Cotes, Simon, of Nedeham, clothier 0
4098637 2059844 2059844 defendant Bailie Robert yeoman 587759 587759 Bailie, Robert, of Nedeham, yeoman 0
4147578 2077295 2077295 defendant Carver Esdras tailor 587759 587759 Carver, Esdras, of Nedeham, tailor 0
4147584 2077296 2077296 defendant Barker Gregory husbandman 587759 587759 Barker, Gregory, of Nedeham, husbandman 1
4168574 2084493 2084493 defendant Gurney Stephen yeoman 587759 587759 Gurney, Stephen, of Nedeham, yeoman 0
4178854 2088081 2088081 defendant Mylles Thomas husbandman 587759 587759 Mylles, Thomas, of Nedeham, husbandman 0
4196148 2094200 2094200 defendant Gurney Stephen yeoman 587759 587759 Gurney, Stephen, of Nedeham, yeoman 0
4196704 2094394 2094394 defendant Gurney Stephen yeoman 587759 587759 Gurney, Stephen, of Nedeham, yeoman 3
4202474 2096407 2096407 defendant Ballye Robert yeoman 587759 587759 Ballye, Robert, of Nedeham, yeoman 0
4202475 2096407 2096407 defendant Folsard Francis   587759 587759 Folsard, Francis, of Nedeham, rope maker 1
4225336 2104328 2104328 defendant Turner William husbandman 587759 587759 Turner, William, of Nedeham, husbandman 0
4241709 2110214 2110214 defendant Barker Gregory laborer 587759 587759 Barker, Gregory, of Nedeham, laborer 0
4247558 2112171 2112171 defendant Grene John yeoman 587759 587759 Grene, John, of Nedeham, yeoman 0
4247559 2112171 2112171 defendant Salmon William yeoman 587759 587759 together with Salmon, William, of Nedeham, yeoman 1
4260117 2116348 2116348 defendant Browne Edmund tailor 587759 587759 Browne, Edmund, of Nedeham, tailor 1
4289354 2126253 2126253 defendant Pudding Roger husbandman 587759 587759 Pudding, Roger, of Nedeham, husbandman 2
4303161 2131229 2131229 defendant Harte Robert gent 587759 587759 (Harte, Robert, of Nedeham, gent 4
4305846 2132182 2132182 defendant Daynes Simon butcher 587759 587759 Daynes, Simon, of Nedeham, butcher 2
4348914 2146882 2146882 defendant Barker George husbandman 587759 587759 Barker, George, of Nedeham, husbandman 3
4383287 2159127 2159127 defendant Mortymer Richard weaver 587759 587759 Mortymer, Richard, of Nedeham, weaver 3
4394750 2162829 2162829 defendant Folkarde Francis husbandman 587759 587759 Folkarde, Francis, of Nedeham, husbandman 0
4395601 2163114 2163114 defendant Carver Esdra tailor 587759 587759 Carver, Esdra, of Nedeham, tailor 1
4407614 2167113 2167113 defendant Deynes Thomas clothier 587759 587759 Deynes, Thomas, of Nedeham, clothier 0
4716641 2270523 2270523 defendant Rygge Roger husbandman 587759 587759 Rygge, Roger, of Nedeham, husbandman 2
4888512 2323205 2323205 defendant Braban William husbandman 587759 587759 Braban, William, of Nedeham, husbandman 0
4906946 2328752 2328752 defendant Thorp John husbandman 587759 587759 Thorp, John, of Nedeham, husbandman 0
5019039 2362459 2362459 defendant Nedeham John yeoman 587759 587759 Nedeham, John, of Nedeham, yeoman 3
5157582 2403346 2403346 defendant Middilton Geoffrey yeoman 587759 587759 Middilton, Geoffrey, of Nedeham, yeoman 0
5173454 2407937 2407937 defendant Middelton Geoffrey yeoman 587759 587759 Middelton, Geoffrey, of Nedeham, yeoman 0
5191469 2413244 2413244 defendant Claye John   587759 587759 Claye, John, of Nedeham 0
5266328 2435220 2435220 defendant Drue Walter chaplain 587759 587759 Drue, Walter, of Nedeham, chaplain 0
5388409 2471735 2471735 defendant Wolston Robert yeoman 587759 587759 Wolston, Robert, of Nedeham, yeoman 1
5400985 2475348 2475348 defendant Wolston Robert yeoman 587759 587759 Wolston, Robert, of Nedeham, yeoman 1
5414024 2479132 2479132 defendant Walston Robert yeoman 587759 587759 Walston, Robert, of Nedeham, yeoman 1
5416002 2479718 2479718 plaintiff Manwell John husbandman 587759 587759 Manwell, John, of Nedeham, husbandman 0
5416003 2479718 2479718 defendant Loft John pedder 587759 587759 Loft, John, of Nedeham, pedder 0
5416004 2479718 2479718 defendant Wright Richard husbandman 587759 587759 Wright, Richard, of Nedeham, husbandman 1
5429577 2483784 2483784 defendant Walston Robert yeoman 587759 587759 together with Walston, Robert, of Nedeham, yeoman 1
5429583 2483785 2483785 defendant Walston Robert yeoman 587759 587759 Walston, Robert, of Nedeham, yeoman 0
5446540 2488853 2488853 defendant Walston Robert yeoman 587759 587759 together with Walston, Robert, of Nedeham, yeoman 1
5452129 2490514 2490514 defendant Flegge John clothmaker 587759 587759 Flegge, John, of Nedeham, clothmaker 2
5499924 2504931 2504931 defendant Ine or Ive William merchant 587759 587759 Ine or Ive, William, of Nedeham, merchant 6
5504305 2506261 2506261 defendant Gresham Edward yeoman 587759 587759 Gresham, Edward, of Nedeham, yeoman 2
5514507 2509384 2509384 defendant Ive or Ine William mercer 587759 587759 Ive or Ine, William, of Nedeham, mercer 3
5566539 2524805 2524805 defendant Emayn John husbandman 587759 587759 Emayn, John, of Nedeham, husbandman 1
5566696 2524855 2524855 defendant Wode Thomas butcher 587759 587759 Wode, Thomas, of Nedeham, butcher 0
5596732 2533896 2533896 defendant Cotrell John yeoman 587759 587759 Cotrell, John, of Nedeham, yeoman 0
5603822 2536063 2536063 defendant Fleg John yeoman 587759 587759 Fleg, John, of Nedeham, 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);