names

18 rows where place_id = 615002

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3706613 1928352 1928352 defendant Burton John yeoman 615002 615002 Burton, John, of Halughton, yeoman 0
4415960 2169878 2169878 defendant Sutton Hugh de   615002 615002 Sutton, Hugh de, of Halughton, son of Geoffrey 0
4422960 2172037 2172037 defendant Fraunceys Thomas   615002 615002 Fraunceys, Thomas, of Halughton 0
4430913 2174430 2174430 plaintiff Aunnorey Robert   615002 615002 Aunnorey, Robert, of Halughton, parson of half the church 0
4436521 2176160 2176160 plaintiff Bay William   615002 615002 Bay, William, of Halughton 2
4487921 2196944 2196944 defendant Northfolk William   615002 615002 Northfolk, William, of Halughton 1
4640443 2243316 2243316 defendant Lympnour Henry   615002 615002 Lympnour, Henry, of Halughton 1
4643461 2244186 2244186 defendant Webbe Nicholas   615002 615002 Webbe, Nicholas, of Halughton 6
4643676 2244250 2244250 defendant Webbe Nicholas   615002 615002 Webbe, Nicholas, of Halughton 5
4648386 2245573 2245573 defendant Webbe Nicholas   615002 615002 Webbe, Nicholas, of Halughton 6
4649874 2245979 2245979 defendant Webbe Nicholas   615002 615002 Webbe, Nicholas, of Halughton 6
4650776 2246247 2246247 defendant Webbe Nicholas   615002 615002 Webbe, Nicholas, of Halughton 6
4681811 2259922 2259922 defendant Sprotte William husbandman 615002 615002 Sprotte, William, of Halughton, husbandman 0
4733931 2275797 2275797 defendant Wylde John   615002 615002 Wylde, John, of Halughton, parson 0
4740405 2277708 2277708 defendant Dygby John yeoman 615002 615002 Dygby, John, of Halughton, yeoman 1
5270798 2436558 2436558 defendant Fuller John, senior yeoman 615002 615002 Fuller, John, senior, of Halughton, yeoman 0
5343216 2458071 2458071 defendant Crissall John husbandman 615002 615002 Crissall, John, of Halughton, husbandman 0
5610548 2547021 2547021 plaintiff Barbour Nicholas   615002 615002 Barbour, Nicholas, of Halughton, parson 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);