names

27 rows where place_id = 629722

✎ 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
3790038 1954706 1954706 plaintiff Villers William gent 629722 629722 Villers, William, of Brokesby, gent 1
3806182 1959862 1959862 plaintiff Villers William gent 629722 629722 Villers, William, of Brokesby, gent 1
3806201 1959863 1959863 plaintiff Villers William gent 629722 629722 Villers, William, of Brokesby, gent 1
3858726 1976401 1976401 defendant Vyllers John   629722 629722 Vyllers, John, of Brokesby, knight 0
4622925 2238149 2238149 defendant Shepherd John   629722 629722 Shepherd, John, of Brokesby 0
4832123 2306077 2306077 defendant Boteler William husbandman 629722 629722 Boteler, William, of Brokesby, husbandman 0
4846969 2310558 2310558 defendant Marchall John husbandman 629722 629722 Marchall, John, of Brokesby, husbandman 1
4879739 2320582 2320582 defendant Vyllers William gent 629722 629722 Vyllers, William, of Brokesby, gent 0
4892335 2324338 2324338 defendant Clare John chaplain 629722 629722 Clare, John, of Brokesby, chaplain 0
5019211 2362509 2362509 defendant West Robert husbandman 629722 629722 West, Robert, of Brokesby, husbandman 1
5036389 2367498 2367498 defendant Jay John miller 629722 629722 Jay, John, of Brokesby, miller 0
5051735 2372131 2372131 defendant Vylers William esq 629722 629722 Vylers, William, of Brokesby, esq 0
5051736 2372131 2372131 defendant Milner John yeoman 629722 629722 Milner, John, of Brokesby, yeoman 1
5051737 2372131 2372131 defendant Chamberleyn Roger husbandman 629722 629722 Chamberleyn, Roger, of Brokesby, husbandman 2
5051738 2372131 2372131 defendant Chapeleyn William   629722 629722 Chapeleyn, William, of Brokesby, parson 3
5093318 2384442 2384442 defendant Wright John husbandman 629722 629722 Wright, John, of Brokesby, or of Wodehous juxta Beaumanar, husbandman 0
5093321 2384443 2384443 defendant Wright John husbandman 629722 629722 Wright, John, of Brokesby, or of Wodehouse, husbandman 0
5099838 2386391 2386391 defendant Vyllers William esq 629722 629722 Vyllers, William, of Brokesby, esq 0
5099839 2386391 2386391 defendant Vyllers Bartholomew gent 629722 629722 Vyllers, Bartholomew, of Brokesby, gent 1
5099840 2386391 2386391 defendant Wodford Ralph   629722 629722 Wodford, Ralph, of Brokesby, gent, son of Wodford, Thomas 2
5141582 2398650 2398650 plaintiff Vyllers William   629722 629722 Vyllers, William, of Brokesby 0
5162663 2404800 2404800 plaintiff Villers William esq 629722 629722 Villers, William, of Brokesby, esq 0
5164154 2405256 2405256 plaintiff Wyllers William esq 629722 629722 Wyllers, William, of Brokesby, esq 0
5198895 2415429 2415429 plaintiff Vyllers William esq 629722 629722 Vyllers, William, of Brokesby, esq 0
5310376 2448138 2448138 plaintiff Vyllers William esq 629722 629722 Vyllers, William, of Brokesby, esq 0
5542908 2517900 2517900 defendant Villers John esq 629722 629722 Villers, John, of Brokesby, esq 0
5634586 2554815 2554815 defendant Swayne William husbandman 629722 629722 Swayne, William, of Brokesby, 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);