names

32 rows where place_id = 604406

✎ 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
3657902 1912721 1912721 defendant Barnard Peter yeoman 604406 604406 Barnard, Peter, of Gestyngthorp, yeoman 0
3751659 1942435 1942435 defendant Lavour Nicholas husbandman 604406 604406 Lavour, Nicholas, of Gestyngthorp, husbandman 0
3811821 1961600 1961600 plaintiff Clerke John, senior   604406 604406 Clerke, John, senior, of Gestyngthorp, 0
3824095 1965409 1965409 defendant Carter John husbandman 604406 604406 Carter, John, of Gestyngthorp, husbandman 0
3824096 1965409 1965409 defendant Walsche Robert husbandman 604406 604406 Walsche, Robert, of Gestyngthorp, husbandman 1
3842927 1971321 1971321 defendant Walsshe Robert husbandman 604406 604406 Walsshe, Robert, of Gestyngthorp, husbandman 0
3972904 2015096 2015096 defendant Hale Richard husbandman 604406 604406 Hale, Richard, of Gestyngthorp, husbandman 0
4658040 2248391 2248391 plaintiff Coo John   604406 604406 Coo, John, of Gestyngthorp 0
4660903 2249236 2249236 defendant Peyton James yeoman 604406 604406 Peyton, James, of Gestyngthorp, yeoman 0
4697737 2264786 2264786 plaintiff Coo John   604406 604406 Coo, John, of Gestyngthorp 0
4812759 2300106 2300106 plaintiff Hardekyn Thomas   604406 604406 Hardekyn, Thomas, of Gestyngthorp 0
4918670 2332357 2332357 plaintiff Hardekyn Thomas (legal representative) 604406 604406 Hardekyn, Thomas, of Gestyngthorp, executors of 0
4925558 2334427 2334427 defendant Skynnere William laborer 604406 604406 Skynnere, William, of Gestyngthorp, laborer 0
4944348 2340207 2340207 plaintiff Hardekyn Thomas (legal representative) 604406 604406 Hardekyn, Thomas, of Gestyngthorp, executors of 0
4959491 2344805 2344805 defendant Sturmyn John butcher 604406 604406 Sturmyn, John, of Gestyngthorp, butcher 0
5060589 2374747 2374747 defendant Hardekyn John gent 604406 604406 Hardekyn, John, of Gestyngthorp, gent 0
5063522 2375617 2375617 defendant Hardekyn John gent 604406 604406 Hardekyn, John, of Gestyngthorp, or of Castle Hedyngham, Essex, gent 0
5067769 2376861 2376861 defendant Hardekyn John gent 604406 604406 Hardekyn, John, of Gestyngthorp, gent 0
5084327 2381821 2381821 defendant Hardekyn John gent 604406 604406 Hardekyn, John, of Gestyngthorp, gent 0
5088165 2382913 2382913 defendant Smyth John husbandman 604406 604406 Smyth, John, of Gestyngthorp, husbandman 2
5374570 2467653 2467653 defendant Copyn John husbandman 604406 604406 Copyn, John, of Gestyngthorp, husbandman 0
5392616 2472956 2472956 plaintiff Sempson Thomas   604406 604406 Sempson, Thomas, of Gestyngthorp 0
5392618 2472956 2472956 plaintiff Reyner Richard   604406 604406 Reyner, Richard, of Gestyngthorp 2
5392619 2472956 2472956 plaintiff Parkes William, junior   604406 604406 Parkes, William, junior, of Gestyngthorp 3
5405413 2476627 2476627 plaintiff Park William   604406 604406 Park, William, of Gestyngthorp 3
5409236 2477727 2477727 defendant Hale William yeoman 604406 604406 Hale, William, of Gestyngthorp, yeoman 1
5415116 2479462 2479462 defendant Bedlowe Richard smith 604406 604406 Bedlowe, Richard, of Gestyngthorp, smith 0
5426148 2482774 2482774 defendant Copyn John yeoman 604406 604406 Copyn, John, of Gestyngthorp, yeoman 2
5444378 2488224 2488224 defendant Copyn John yeoman 604406 604406 Copyn, John, of Gestyngthorp, yeoman 2
5468933 2495636 2495636 defendant Coke John yeoman 604406 604406 Coke, John, of Gestyngthorp, yeoman 1
5474632 2497393 2497393 defendant Harvy William yeoman 604406 604406 Harvy, William, of Gestyngthorp, yeoman 0
5491604 2502378 2502378 defendant Sebbley John husbandman 604406 604406 Sebbley, John, of Gestyngthorp, 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);