names

31 rows where place_id = 590488

✎ 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
3601385 1868096 1868096 defendant Benson William fuller 590488 590488 Benson, William, of Northcave, fuller 0
3767897 1947598 1947598 defendant Andrewe John husbandman 590488 590488 Andrewe, John, of Northcave, husbandman 0
3767898 1947598 1947598 defendant Coke Thomas husbandman 590488 590488 Coke, Thomas, of Northcave, husbandman 1
3785606 1953288 1953288 defendant Coke Thomas husbandman 590488 590488 Coke, Thomas, of Northcave, husbandman 4
4125611 2069445 2069445 defendant Baylly or Baley John (legal representative) 590488 590488 Baylly or Baley, John, of Northcave, yeoman, executors of 0
4125613 2069445 2069445 defendant Bayly Robert yeoman 590488 590488 Bayly, Robert, of Northcave, yeoman 2
4172932 2085986 2085986 defendant Babthorpe Nicholas husbandman 590488 590488 Babthorpe, Nicholas, of Northcave, husbandman 2
4316425 2135862 2135862 defendant Elwick Marmaduke gent 590488 590488 Elwick, Marmaduke, of Northcave, gent 1
4463055 2189145 2189145 plaintiff Tothe John   590488 590488 Tothe, John, of Northcave, son of William 0
4463056 2189145 2189145 defendant Lychefold Robert de   590488 590488 Lychefold, Robert de, of Northcave 0
4486573 2196514 2196514 plaintiff Santon Richard de   590488 590488 Santon, Richard de, of Northcave 0
4522834 2207481 2207481 defendant Cook John   590488 590488 Cook, John, of Northcave 2
4742933 2278445 2278445 plaintiff Clerk John   590488 590488 Clerk, John, of Northcave 0
4784170 2291048 2291048 defendant Doubeney Robert yeoman 590488 590488 Doubeney, Robert, of Northcave, yeoman 3
4815040 2300814 2300814 defendant Welles John   590488 590488 Welles, John, of Northcave, wright 2
4815041 2300814 2300814 defendant Daweson Robert husbandman 590488 590488 Daweson, Robert, of Northcave, husbandman 3
4821832 2302903 2302903 defendant Smyth John laborer 590488 590488 Smyth, John, of Northcave, laborer 0
4875646 2319340 2319340 plaintiff Santon or Sauton Robert (legal representative) 590488 590488 Santon or Sauton, Robert, of Northcave, esq, executors of 0
4883940 2321885 2321885 defendant Comyn Thomas husbandman 590488 590488 Comyn, Thomas, of Northcave, husbandman 2
4895902 2325383 2325383 defendant Coke John husbandman 590488 590488 together with Coke, John, of Northcave, husbandman 2
4895903 2325383 2325383 defendant Barker William husbandman 590488 590488 Barker, William, of Northcave, husbandman 3
4904421 2327996 2327996 defendant Coke John husbandman 590488 590488 together with Coke, John, of Northcave, husbandman 2
4904422 2327996 2327996 defendant Barker William husbandman 590488 590488 Barker, William, of Northcave, husbandman 3
4911223 2330019 2330019 defendant Comyn John husbandman 590488 590488 Comyn, John, of Northcave, husbandman 2
4942018 2339486 2339486 defendant Warderop Robert yeoman 590488 590488 Warderop, Robert, of Northcave, yeoman 1
5094772 2384884 2384884 defendant Lyndesey Thomas chaplain 590488 590488 Lyndesey, Thomas, of Northcave, chaplain 0
5094793 2384890 2384890 defendant Lyndesey Thomas chaplain 590488 590488 Lyndesey, Thomas, of Northcave, chaplain 0
5227294 2423611 2423611 defendant Galliard John pedder 590488 590488 Galliard, John, of Northcave, pedder 3
5251335 2430517 2430517 defendant Watson John weaver 590488 590488 Watson, John, of Northcave, weaver 4
5327455 2453282 2453282 defendant Swyrell John weaver 590488 590488 Swyrell, John, of Northcave, weaver 4
5511073 2508304 2508304 defendant Wright Robert husbandman 590488 590488 Wright, Robert, of Northcave, husbandman 1

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);