names

26 rows where place_id = 638514

✎ 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
3843119 1971372 1971372 defendant Lyttell Stephen husbandman 638514 638514 Lyttell, Stephen, of Upton St Leonard, husbandman 0
4023299 2033041 2033041 plaintiff Barnard Jerome gent 638514 638514 Barnard, Jerome, of Upton St Leonard, gent 0
4110359 2063964 2063964 defendant Bernarde Jerome gent 638514 638514 Bernarde, Jerome, of Upton St Leonard, gent 2
4164238 2083016 2083016 defendant Lewes Nicholas husbandman 638514 638514 Lewes, Nicholas, of Upton St Leonard, husbandman 2
4177022 2087436 2087436 defendant Gransham William husbandman 638514 638514 Gransham, William, of Upton St Leonard, husbandman 2
4223852 2103828 2103828 defendant Bodnam John husbandman 638514 638514 Bodnam, John, of Upton St Leonard, husbandman 0
4280497 2123087 2123087 defendant Wodcock Thomas husbandman 638514 638514 Wodcock, Thomas, of Upton St Leonard, husbandman 0
4280498 2123087 2123087 defendant Davies James husbandman 638514 638514 Davies, James, of Upton St Leonard, husbandman 1
4289533 2126320 2126320 defendant Wodcock Thomas husbandman 638514 638514 Wodcock, Thomas, of Upton St Leonard, husbandman 0
4294149 2127983 2127983 defendant Band or Baud John yeoman 638514 638514 Band or Baud, John, of Upton St Leonard, yeoman 1
4298741 2129650 2129650 defendant Barnard Thomas gent 638514 638514 Barnard, Thomas, of Upton St Leonard, gent 0
4302140 2130871 2130871 defendant Parker Thomas gent 638514 638514 Parker, Thomas, of Upton St Leonard, gent 0
4302141 2130871 2130871 defendant Parker Sybil widow 638514 638514 Sybil his wife, formerly Sybill Barnard, of Upton St Leonard, widow 1
4316877 2136019 2136019 defendant Nurse John husbandman 638514 638514 Nurse, John, of Upton St Leonard, husbandman 1
4316878 2136019 2136019 defendant Lye Richard husbandman 638514 638514 Lye, Richard, of Upton St Leonard, husbandman 2
4485427 2196147 2196147 defendant Wyther John   638514 638514 Wyther, John, of Upton St Leonard by Gloucester 1
4606911 2233269 2233269 defendant Wyther John   638514 638514 Wyther, John, of Upton St Leonard 4
4983502 2351980 2351980 defendant Smert Robert husbandman 638514 638514 together with Smert, Robert, of Upton St Leonard, husbandman 1
5077566 2379787 2379787 defendant Webley Thomas husbandman 638514 638514 Webley, Thomas, of Upton St Leonard, husbandman 4
5286234 2440984 2440984 defendant Carpenter Robert husbandman 638514 638514 Carpenter, Robert, of Upton St Leonard, husbandman 1
5298449 2444523 2444523 defendant Nelme John   638514 638514 Nelme, John, of Upton St Leonard, millward 0
5298451 2444523 2444523 defendant Edwardus Thomas husbandman 638514 638514 Edwardus, Thomas, of Upton St Leonard, husbandman 2
5313180 2448974 2448974 defendant Monmouth William yeoman 638514 638514 Monmouth, William, of Upton St Leonard, yeoman 1
5317262 2450243 2450243 defendant Alford Thomas husbandman 638514 638514 Alford, Thomas, of Upton St Leonard, husbandman 2
5454523 2491268 2491268 defendant Sparke John husbandman 638514 638514 Sparke, John, of Upton St Leonard, husbandman 0
5590342 2531951 2531951 defendant Edwardys Thomas husbandman 638514 638514 Edwardys, Thomas, of Upton St Leonard, 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);