names

47 rows where place_id = 599772

✎ 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
3638211 1906770 1906770 defendant Milward Richard husbandman 599772 599772 Milward, Richard, of Yapton, husbandman 0
3706435 1928299 1928299 defendant Styent John husbandman 599772 599772 Styent, John, of Yapton, husbandman 1
3706439 1928300 1928300 defendant Styent John husbandman 599772 599772 Styent, John, of Yapton, husbandman 1
3731151 1935968 1935968 defendant Styant John husbandman 599772 599772 Styant, John, of Yapton, husbandman 0
3731153 1935969 1935969 defendant Styant John husbandman 599772 599772 Styant, John, of Yapton, husbandman 0
3736627 1937706 1937706 defendant Styant John husbandman 599772 599772 Styant, John, of Yapton, husbandman 0
3744229 1940091 1940091 defendant Styantt John husbandman 599772 599772 Styantt, John, of Yapton, husbandman 4
3850143 1973635 1973635 defendant Napper Thomas husbandman 599772 599772 Napper, Thomas, of Yapton, husbandman 2
3919649 1996907 1996907 defendant Cutfold Henry husbandman 599772 599772 Cutfold, Henry, of Yapton, husbandman 0
4008580 2027834 2027834 plaintiff Moorye Thomas   599772 599772 Moorye, Thomas, of Yapton 0
4225503 2104384 2104384 defendant Harteley Thomas husbandman 599772 599772 Harteley, Thomas, of Yapton, husbandman 1
4229064 2105648 2105648 defendant Boby John husbandman 599772 599772 Boby, John, of Yapton, husbandman 3
4321819 2137718 2137718 defendant Benskyn John husbandman 599772 599772 Benskyn, John, of Yapton, husbandman 1
4480572 2194591 2194591 defendant Bassyngham Thomas de   599772 599772 Bassyngham, Thomas de, of Yapton, vicar 0
4631875 2240853 2240853 defendant Shephurde Richard   599772 599772 Shephurde, Richard, of Yapton 1
4631879 2240854 2240854 defendant Shephurde Richard   599772 599772 Shephurde, Richard, of Yapton 1
4669733 2256236 2256236 defendant Shepherd Richard husbandman 599772 599772 Shepherd, Richard, of Yapton, husbandman 0
4744617 2278946 2278946 defendant Bedull John husbandman 599772 599772 Bedull, John, of Yapton, husbandman 0
4782583 2290566 2290566 defendant Jenever John husbandman 599772 599772 Jenever, John, of Yapton, husbandman 0
4815577 2300979 2300979 defendant Janyver John husbandman 599772 599772 Janyver, John, of Yapton, husbandman 0
4825041 2303872 2303872 defendant Goffe Richard husbandman 599772 599772 Goffe, Richard, of Yapton, husbandman 0
4831174 2305782 2305782 defendant Stygaunt Richard husbandman 599772 599772 Stygaunt, Richard, of Yapton, husbandman 0
4853731 2312581 2312581 plaintiff Exton Henry   599772 599772 Exton, Henry, of Yapton 1
4853732 2312581 2312581 defendant Jenenere John husbandman 599772 599772 Jenenere, John, of Yapton, husbandman 0
4872663 2318400 2318400 defendant Walter Richard husbandman 599772 599772 Walter, Richard, of Yapton, husbandman 0
4884164 2321955 2321955 defendant Exton Henry yeoman 599772 599772 Exton, Henry, of Yapton, yeoman 1
4967454 2347208 2347208 defendant Halle John husbandman 599772 599772 Halle, John, of Yapton, husbandman 0
4967455 2347208 2347208 defendant Montegeue John husbandman 599772 599772 Montegeue, John, of Yapton, husbandman 1
4989392 2353762 2353762 defendant Knyght John husbandman 599772 599772 Knyght, John, of Yapton, husbandman 0
4991536 2354352 2354352 defendant Knyght John husbandman 599772 599772 Knyght, John, of Yapton, husbandman 5
4994372 2355191 2355191 defendant Mille William husbandman 599772 599772 Mille, William, of Yapton, husbandman 0
4994373 2355191 2355191 defendant Lende Richard husbandman 599772 599772 Lende, Richard, of Yapton, husbandman 1
5003931 2358039 2358039 defendant Lucas William tanner 599772 599772 Lucas, William, of Yapton, tanner 1
5013968 2360941 2360941 defendant Boley John   599772 599772 Boley, John, of Yapton, millward 2
5018577 2362318 2362318 defendant Nyton William husbandman 599772 599772 Nyton, William, of Yapton, husbandman 0
5026940 2364747 2364747 defendant Nyton William husbandman 599772 599772 Nyton, William, of Yapton, husbandman 0
5043026 2369532 2369532 defendant Cotefell Henry husbandman 599772 599772 Cotefell, Henry, of Yapton, husbandman 0
5089152 2383201 2383201 defendant Pyccham Simon husbandman 599772 599772 Pyccham, Simon, of Yapton, husbandman 0
5089153 2383201 2383201 defendant Pyccham William husbandman 599772 599772 Pyccham, William, of Yapton, husbandman 1
5108343 2388875 2388875 defendant Mountegrewe John husbandman 599772 599772 Mountegrewe, John, of Yapton, husbandman 3
5108344 2388875 2388875 defendant Knyght John husbandman 599772 599772 Knyght, John, of Yapton, husbandman 4
5191858 2413353 2413353 defendant Stygant Henry husbandman 599772 599772 Stygant, Henry, of Yapton, husbandman 0
5199040 2415470 2415470 defendant Welet John laborer 599772 599772 Welet, John, of Yapton, laborer 1
5207518 2417941 2417941 defendant Stygant Henry husbandman 599772 599772 Stygant, Henry, of Yapton, husbandman 0
5210910 2418923 2418923 defendant Welot John laborer 599772 599772 Welot, John, of Yapton, laborer 1
5345213 2458673 2458673 defendant Nyton Thomas husbandman 599772 599772 Nyton, Thomas, of Yapton, husbandman 1
5371695 2466737 2466737 defendant Frape Richard husbandman 599772 599772 Frape, Richard, of Yapton, 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);