names

52 rows where place_id = 598016

✎ 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
3630757 1904444 1904444 defendant Southowson Valentine husbandman 598016 598016 Southowson, Valentine, of Sellyng, husbandman 1
3641681 1907855 1907855 defendant Bealde Peter husbandman 598016 598016 Bealde, Peter, of Sellyng, husbandman 0
3641682 1907855 1907855 defendant Bealde Thomas husbandman 598016 598016 Bealde, Thomas, of Sellyng, husbandman 1
3665585 1915186 1915186 defendant Bardham Thomas yeoman 598016 598016 Bardham, Thomas, of Sellyng, yeoman 2
3665586 1915186 1915186 defendant Gate Thomas yeoman 598016 598016 Gate, Thomas, of Sellyng, yeoman 3
3665668 1915211 1915211 defendant Bredham Thomas gent 598016 598016 Bredham, Thomas, of Sellyng, gent 2
3665669 1915211 1915211 defendant Gate Thomas yeoman 598016 598016 Gate, Thomas, of Sellyng, yeoman 3
3669729 1916477 1916477 defendant Smyth Thomas baker 598016 598016 Smyth, Thomas, of Sellyng, baker 0
3754759 1943445 1943445 defendant Johns Thomas husbandman 598016 598016 Johns, Thomas, of Sellyng, husbandman 0
3766577 1947208 1947208 defendant at Lee John husbandman 598016 598016 at Lee, John, of Sellyng, husbandman 1
3768308 1947730 1947730 plaintiff Patch Peter   598016 598016 Patch, Peter, of Sellyng 0
3799759 1957845 1957845 defendant Hert William yeoman 598016 598016 Hert, William, of Sellyng, yeoman 0
3799762 1957845 1957845 defendant Burges Henry husbandman 598016 598016 Burges, Henry, of Sellyng, husbandman 3
3814241 1962361 1962361 defendant Alee John husbandman 598016 598016 Alee, John, of Sellyng, husbandman 2
3817198 1963294 1963294 defendant Hert William yeoman 598016 598016 Hert, William, of Sellyng, yeoman 0
3817201 1963294 1963294 defendant Burges Henry husbandman 598016 598016 Burges, Henry, of Sellyng, husbandman 3
3862093 1977508 1977508 defendant Carter Richard husbandman 598016 598016 Carter, Richard, of Sellyng, husbandman 2
3875025 1981874 1981874 defendant Hert John yeoman 598016 598016 Hert, John, of Sellyng, yeoman 0
3878105 1982925 1982925 plaintiff Knechebull Richard (legal representative) 598016 598016 Knechebull, Richard, of Sellyng, executor of 0
3878106 1982925 1982925 plaintiff Wolnett Roger   598016 598016 Wolnett, Roger, of Sellyng 1
3894887 1988497 1988497 defendant Drewry Richard husbandman 598016 598016 Drewry, Richard, of Sellyng, husbandman 1
4138267 2074053 2074053 defendant Wrathe John husbandman 598016 598016 (Wrathe, John, of Sellyng, husbandman 1
4574427 2223531 2223531 defendant Proude John   598016 598016 Proude, John, of Sellyng 0
4582169 2225861 2225861 defendant Edyn John laborer 598016 598016 Edyn, John, of Sellyng, laborer 0
4670118 2256355 2256355 defendant Tenham Thomas husbandman 598016 598016 Tenham, Thomas, of Sellyng, husbandman 0
4683941 2260589 2260589 defendant Danyell Henry husbandman 598016 598016 Danyell, Henry, of Sellyng, husbandman 0
4683943 2260590 2260590 defendant Danyell Henry husbandman 598016 598016 Danyell, Henry, of Sellyng, husbandman 0
4685689 2261114 2261114 defendant Ovene or Oneve John husbandman 598016 598016 Ovene or Oneve, John, of Sellyng, husbandman 0
4704913 2266914 2266914 defendant Smyth William butcher 598016 598016 Smyth, William, of Sellyng, butcher 1
4708980 2268178 2268178 defendant Whetakere Thomas sheerman 598016 598016 Whetakere, Thomas, of Sellyng, sheerman 1
4727805 2273940 2273940 defendant Knyght Richard husbandman 598016 598016 Knyght, Richard, of Sellyng, husbandman 0
4779422 2289546 2289546 defendant Danyel Henry   598016 598016 Danyel, Henry, of Sellyng, franklin 0
4787874 2292274 2292274 defendant atte Melle John husbandman 598016 598016 atte Melle, John, of Sellyng, husbandman 0
4787875 2292274 2292274 defendant Abraham John husbandman 598016 598016 Abraham, John, of Sellyng, husbandman 1
4787876 2292274 2292274 defendant atte Meede Richard husbandman 598016 598016 atte Meede, Richard, of Sellyng, husbandman 2
4917353 2331940 2331940 plaintiff Galnot Thomas   598016 598016 Galnot, Thomas, of Sellyng 0
4948112 2341382 2341382 defendant Caldam Stephen laborer 598016 598016 Caldam, Stephen, of Sellyng, laborer 0
4963922 2346120 2346120 defendant Wyssenden John husbandman 598016 598016 Wyssenden, John, of Sellyng, husbandman 0
5007812 2359178 2359178 defendant Ovene John husbandman 598016 598016 Ovene, John, of Sellyng, husbandman 1
5061224 2374940 2374940 defendant Gylnot Thomas husbandman 598016 598016 Gylnot, Thomas, of Sellyng, husbandman 2
5235922 2426084 2426084 plaintiff Gylnot Thomas   598016 598016 (Gylnot, Thomas, of Sellyng 1
5237959 2426691 2426691 defendant Wyssynden John husbandman 598016 598016 Wyssynden, John, of Sellyng, husbandman 1
5333045 2454952 2454952 defendant Marchant Paul yeoman 598016 598016 Marchant, Paul, of Sellyng, yeoman 0
5346681 2459116 2459116 defendant Breddam William husbandman 598016 598016 Breddam, William, of Sellyng, husbandman 1
5346685 2459117 2459117 defendant Bredham William husbandman 598016 598016 Bredham, William, of Sellyng, husbandman 1
5383730 2470431 2470431 defendant Joynour Alexander butcher 598016 598016 Joynour, Alexander, of Sellyng, butcher 1
5401385 2475462 2475462 defendant Hert John yeoman 598016 598016 Hert, John, of Sellyng, yeoman 0
5430188 2483967 2483967 defendant Hert John yeoman 598016 598016 Hert, John, of Sellyng, yeoman 0
5523535 2512189 2512189 defendant Clerk alias Paynter John painter 598016 598016 Clerk alias Paynter, John, of Sellyng, painter 3
5533573 2515050 2515050 defendant Hamond John yeoman 598016 598016 Hamond, John, of Sellyng, yeoman 0
5557577 2522171 2522171 defendant Hamond John yeoman 598016 598016 Hamond, John, of Sellyng, yeoman 0
5570110 2525833 2525833 plaintiff Hobnette Regianld husbandman 598016 598016 Hobnette, Regianld, of Sellyng, husbandman 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);