names

35 rows where place_id = 621486

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3741728 1939276 1939276 defendant Graunge William miller 621486 621486 Graunge, William, of Walkeryngham, miller 2
3741729 1939276 1939276 defendant Davyson John husbandman 621486 621486 Davyson, John, of Walkeryngham, husbandman 3
3741732 1939276 1939276 defendant Wanley Edward husbandman 621486 621486 Wanley, Edward, of Walkeryngham, husbandman 6
3851001 1973903 1973903 defendant Horbury Giles husbandman 621486 621486 Horbury, Giles, of Walkeryngham, husbandman 3
3882596 1984444 1984444 plaintiff Thonehill alias Thornell Hugh (legal representative) 621486 621486 Thonehill alias Thornell, Hugh, of Walkeryngham, yeoman, executors of 0
4614466 2235534 2235534 plaintiff Dunstall Godfrey de   621486 621486 Dunstall, Godfrey de, of Walkeryngham 0
4614479 2235534 2235534 defendant Buchere William   621486 621486 Buchere, William, of Walkeryngham 12
4640478 2243327 2243327 defendant Ardern Thomas   621486 621486 Ardern, Thomas, of Walkeryngham 0
4645530 2244760 2244760 defendant Clerk Thomas   621486 621486 Clerk, Thomas, of Walkeryngham 0
4645535 2244762 2244762 defendant Dunstall Godfrey de   621486 621486 Dunstall, Godfrey de, of Walkeryngham 0
4653001 2246870 2246870 defendant Smyth Robert yeoman 621486 621486 Smyth, Robert, of Walkeryngham, yeoman 0
4660354 2249068 2249068 defendant Smyth Robert husbandman 621486 621486 Smyth, Robert, of Walkeryngham, husbandman 3
4661011 2249268 2249268 defendant Arderne Thomas husbandman 621486 621486 Arderne, Thomas, of Walkeryngham, husbandman 0
4669185 2256068 2256068 defendant Clerk Thomas husbandman 621486 621486 Clerk, Thomas, of Walkeryngham, husbandman 0
4669187 2256068 2256068 defendant Mower Thomas husbandman 621486 621486 Mower, Thomas, of Walkeryngham, husbandman 2
4669189 2256068 2256068 defendant Joynour William husbandman 621486 621486 Joynour, William, of Walkeryngham, husbandman 4
4707945 2267855 2267855 defendant Smyth Robert yeoman 621486 621486 Smyth, Robert, of Walkeryngham, yeoman 0
4712266 2269152 2269152 defendant Colyer John yeoman 621486 621486 Colyer, John, of Walkeryngham, yeoman 0
4837543 2307677 2307677 defendant Clerk Thomas husbandman 621486 621486 Clerk, Thomas, of Walkeryngham, husbandman 3
4837553 2307680 2307680 defendant Clerk Thomas husbandman 621486 621486 Clerk, Thomas, of Walkeryngham, husbandman 3
4852676 2312258 2312258 defendant Hoggeson John yeoman 621486 621486 Hoggeson, John, of Walkeryngham, yeoman 0
4852677 2312258 2312258 defendant Clerk Thomas miller 621486 621486 Clerk, Thomas, of Walkeryngham, miller 1
4871340 2318004 2318004 defendant Leyburn Thomas laborer 621486 621486 Leyburn, Thomas, of Walkeryngham, laborer 0
4872250 2318280 2318280 defendant Clerk Thomas miller 621486 621486 Clerk, Thomas, of Walkeryngham, miller 0
4949807 2341930 2341930 defendant Drayton Thomas husbandman 621486 621486 Drayton, Thomas, of Walkeryngham, husbandman 0
4949808 2341930 2341930 defendant Gonseby of Gouseby William husbandman 621486 621486 Gonseby of Gouseby, William, of Walkeryngham, husbandman 1
5081509 2380969 2380969 defendant Browet William husbandman 621486 621486 Browet, William, of Walkeryngham, husbandman 0
5223116 2422472 2422472 defendant Kyrkeby Lawrence yeoman 621486 621486 Kyrkeby, Lawrence, of Walkeryngham, yeoman 0
5239494 2427136 2427136 plaintiff Hocheson William   621486 621486 Hocheson, William, of Walkeryngham 0
5239495 2427136 2427136 defendant Drayton Elias butcher 621486 621486 Drayton, Elias, of Walkeryngham, butcher 0
5239496 2427136 2427136 defendant Robynson Robert husbandman 621486 621486 Robynson, Robert, of Walkeryngham, husbandman 1
5239536 2427147 2427147 plaintiff Hoggeson John   621486 621486 Hoggeson, John, of Walkeryngham 0
5239537 2427147 2427147 defendant Metham John miller 621486 621486 Metham, John, of Walkeryngham, miller 0
5336396 2455954 2455954 defendant Drayton Elias husbandman 621486 621486 Drayton, Elias, of Walkeryngham, husbandman 0
5628341 2552821 2552821 defendant Felysson Thomas husbandman 621486 621486 Felysson, Thomas, of Walkeryngham, 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);