names

32 rows where place_id = 623441

✎ 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
3752445 1942687 1942687 defendant Lawe Hugh chaplain 623441 623441 Lawe, Hugh, of Letcombe Regis, chaplain 0
3752446 1942687 1942687 defendant Goodlake William yeoman 623441 623441 Goodlake, William, of Letcombe Regis, yeoman 1
3764628 1946598 1946598 defendant Lawe Hugh clerk 623441 623441 Lawe, Hugh, of Letcombe Regis, clerk 0
4303575 2131376 2131376 defendant Symes John yeoman 623441 623441 Symes, John, of Letcombe Regis, yeoman 0
4313721 2134905 2134905 defendant Symes John yeoman 623441 623441 Symes, John, of Letcombe Regis, yeoman 0
4820984 2302650 2302650 defendant Benham John husbandman 623441 623441 Benham, John, of Letcombe Regis, husbandman 0
4847071 2310586 2310586 defendant Kynge William husbandman 623441 623441 Kynge, William, of Letcombe Regis, husbandman 2
4847072 2310586 2310586 defendant Buntefe John tailor 623441 623441 Buntefe, John, of Letcombe Regis, tailor 3
4893861 2324779 2324779 defendant Kynge William husbandman 623441 623441 Kynge, William, of Letcombe Regis, husbandman 0
4954162 2343215 2343215 defendant atte Welle Ralph laborer 623441 623441 atte Welle, Ralph, of Letcombe Regis, laborer 0
4995223 2355418 2355418 defendant Garston John husbandman 623441 623441 Garston, John, of Letcombe Regis, husbandman 0
4995810 2355592 2355592 defendant Graunger john clerk 623441 623441 Graunger, john, of Letcombe Regis, clerk 3
5033631 2366720 2366720 defendant Vycary William husbandman 623441 623441 Vycary, William, of Letcombe Regis, husbandman 0
5033632 2366720 2366720 defendant White John husbandman 623441 623441 White, John, of Letcombe Regis, husbandman 1
5033633 2366720 2366720 defendant Godelake William husbandman 623441 623441 Godelake, William, of Letcombe Regis, husbandman 2
5033634 2366720 2366720 defendant Tatyn John husbandman 623441 623441 Tatyn, John, of Letcombe Regis, husbandman 3
5033635 2366720 2366720 defendant West John husbandman 623441 623441 West, John, of Letcombe Regis, husbandman 4
5033636 2366720 2366720 defendant Kyng William husbandman 623441 623441 Kyng, William, of Letcombe Regis, husbandman 5
5033637 2366720 2366720 defendant Kyng John husbandman 623441 623441 Kyng, John, of Letcombe Regis, husbandman 6
5033638 2366720 2366720 defendant Chols Robert husbandman 623441 623441 Chols, Robert, of Letcombe Regis, husbandman 7
5033639 2366720 2366720 defendant Geffreys John husbandman 623441 623441 Geffreys, John, of Letcombe Regis, husbandman 8
5033640 2366720 2366720 defendant Broune John husbandman 623441 623441 Broune, John, of Letcombe Regis, husbandman 9
5033641 2366720 2366720 defendant Stybbe John husbandman 623441 623441 Stybbe, John, of Letcombe Regis, husbandman 10
5115040 2390817 2390817 defendant Estbury John esq 623441 623441 Estbury, John, of Letcombe Regis, esq 0
5135477 2396889 2396889 defendant West John, junior husbandman 623441 623441 West, John, junior, of Letcombe Regis, husbandman 0
5135478 2396889 2396889 defendant Kyng William husbandman 623441 623441 Kyng, William, of Letcombe Regis, husbandman 1
5135479 2396889 2396889 defendant Kyng John husbandman 623441 623441 Kyng, John, of Letcombe Regis, husbandman 2
5389443 2472028 2472028 plaintiff Isbury John esq 623441 623441 Isbury, John, of Letcombe Regis, esq 0
5402158 2475685 2475685 plaintiff Isbury John esq 623441 623441 Isbury, John, of Letcombe Regis, esq 0
5405428 2476632 2476632 defendant Isbury John   623441 623441 Isbury, John, of Letcombe Regis 0
5415070 2479445 2479445 plaintiff Isbury John esq 623441 623441 Isbury, John, of Letcombe Regis, esq 0
5418492 2480457 2480457 defendant Isbury John esq 623441 623441 Isbury, John, of Letcombe Regis, esq 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);