names

27 rows where place_id = 646233

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3889723 1986799 1986799 defendant Brekeston Richard butcher 646233 646233 Brekeston, Richard, of Clatford, butcher 0
3963543 2011856 2011856 defendant Stanmer John, junior husbandman 646233 646233 Stanmer, John, junior, of Clatford, husbandman 1
3963544 2011856 2011856 defendant Stanmer John, senior husbandman 646233 646233 together with Stanmer, John, senior, of Clatford, husbandman 2
3968816 2013720 2013720 defendant Yonge John gent 646233 646233 Yonge, John, of Clatford, gent 0
3968817 2013720 2013720 defendant Yonge Thomas gent 646233 646233 Yonge, Thomas, of Clatford, gent 1
4132038 2071772 2071772 defendant Yonge Thomas yeoman 646233 646233 Yonge, Thomas, of Clatford, yeoman 0
4238819 2109199 2109199 defendant Symes Anselm yeoman 646233 646233 Symes, Anselm, of Clatford, yeoman 1
4464920 2189702 2189702 defendant atte Mille John   646233 646233 atte Mille, John, of Clatford 0
4763044 2284426 2284426 defendant Arney William husbandman 646233 646233 Arney, William, of Clatford, husbandman 0
4808734 2298898 2298898 defendant Gregory Nicholas husbandman 646233 646233 Gregory, Nicholas, of Clatford, husbandman 3
4838240 2307880 2307880 defendant Gregory Nicholas husbandman 646233 646233 Gregory, Nicholas, of Clatford, husbandman 0
5134917 2396716 2396716 defendant Nayle Richard husbandman 646233 646233 Nayle, Richard, of Clatford Norman, husbandman 0
5134918 2396716 2396716 defendant Harnam William husbandman 646233 646233 Harnam, William, of Clatford Norman, husbandman 1
5134919 2396716 2396716 defendant Maysay William husbandman 646233 646233 Maysay, William, of Clatford Norman, husbandman 2
5134920 2396716 2396716 defendant Maysay Thomas husbandman 646233 646233 Maysay, Thomas, of Clatford Norman, husbandman 3
5134926 2396716 2396716 defendant Skele William laborer 646233 646233 Skele, William, of Clatford, laborer 9
5158646 2403650 2403650 defendant Trotte Henry yeoman 646233 646233 Trotte, Henry, of Clatford, yeoman 0
5241963 2427846 2427846 defendant Topias John husbandman 646233 646233 Topias, John, of Clatford, husbandman 3
5359584 2463033 2463033 defendant Somerset Thomas husbandman 646233 646233 Somerset, Thomas, of Clatford, husbandman 0
5359587 2463033 2463033 defendant Carpenter Maurice (legal representative) 646233 646233 Carpenter, Maurice, of Clatford, husbandman, executors of 3
5387640 2471531 2471531 defendant Myller William   646233 646233 Myller, William, of Clatford 4
5387903 2471598 2471598 defendant Myller William   646233 646233 Myller, William, of Clatford 4
5394462 2473478 2473478 defendant Myller William   646233 646233 Myller, William, of Clatford 4
5413249 2478888 2478888 defendant Miller William   646233 646233 Miller, William, of Clatford 4
5413538 2478973 2478973 defendant Miller William   646233 646233 Miller, William, of Clatford 4
5420704 2481117 2481117 defendant Miller William   646233 646233 Miller, William, of Clatford 4
5523024 2512028 2512028 defendant Franke John yeoman 646233 646233 Franke, John, of Clatford, 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);