names

24 rows where place_id = 769135

✎ 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
4555593 2217678 2217678 defendant Catte Robert   769135 769135 Catte, Robert, of Kirtlyngton 0
4555594 2217678 2217678 defendant Grayne Robert   769135 769135 Grayne, Robert, of Kirtlyngton 1
4617477 2236478 2236478 plaintiff Graunger Thomas, sen   769135 769135 Graunger, Thomas, sen, of Kirtlyngton 0
4629959 2240290 2240290 defendant Tipswayn Richard   769135 769135 Tipswayn, Richard, of Kirtlyngton 0
4649866 2245978 2245978 defendant Catte Robert   769135 769135 Catte, Robert, of Kirtlyngton 7
4692863 2263275 2263275 defendant Heryng Thomas husbandman 769135 769135 Heryng, Thomas, of Kirtlyngton, husbandman 0
4692864 2263275 2263275 defendant Fox John husbandman 769135 769135 Fox, John, of Kirtlyngton, husbandman 1
4733673 2275710 2275710 plaintiff Robertson Wilkynson Thomas   769135 769135 Robertson Wilkynson, Thomas, of Kirtlyngton 0
4748326 2280016 2280016 defendant Lane John husbandman 769135 769135 Lane, John, of Kirtlyngton, husbandman 3
4748336 2280018 2280018 defendant Canne Richard yeoman 769135 769135 Canne, Richard, of Kirtlyngton, yeoman 1
4748337 2280018 2280018 defendant Trewe John husbandman 769135 769135 Trewe, John, of Kirtlyngton, husbandman 2
4770526 2286760 2286760 defendant Plungar William   769135 769135 Plungar, William, of Kirtlyngton, parson 0
4783847 2290966 2290966 defendant le Zouch John   769135 769135 le Zouch, John, of Kirtlyngton, knight 0
4793107 2293937 2293937 defendant le Zouch John   769135 769135 le Zouch, John, of Kirtlyngton, knight 0
4968078 2347398 2347398 defendant Howegreve Robert husbandman 769135 769135 Howegreve, Robert, of Kirtlyngton, husbandman 0
4994731 2355281 2355281 defendant Hustwayt Thomas yeoman 769135 769135 Hustwayt, Thomas, of Kirtlyngton, yeoman 0
5021308 2363137 2363137 defendant Robynson John husbandman 769135 769135 Robynson, John, of Kirtlyngton, husbandman 0
5128025 2394673 2394673 defendant Roper Hugh husbandman 769135 769135 Roper, Hugh, of Kirtlyngton, husbandman 2
5173320 2407908 2407908 defendant Bond William husbandman 769135 769135 Bond, William, of Kirtlyngton, husbandman 2
5301659 2445449 2445449 plaintiff Dentt Richard   769135 769135 Dentt, Richard, of Kirtlyngton 0
5633214 2554392 2554392 defendant Eston John gent 769135 769135 Eston, John, of Kirtlyngton, gent 0
5633216 2554392 2554392 defendant de Whitton Walter yeoman 769135 769135 de Whitton, Walter, of Kirtlyngton, yeoman 2
5634415 2554759 2554759 defendant Eston John gent 769135 769135 Eston, John, of Kirtlyngton, gent 0
5634416 2554759 2554759 defendant Calton John chaplain 769135 769135 Calton, John, of Kirtlyngton, chaplain 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);