names

24 rows where place_id = 753627

✎ 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
4414792 2169531 2169531 defendant Filcokson Richard   753627 753627 Filcokson, Richard, of Castelford 0
4440292 2181876 2181876 defendant Byset Thomas   753627 753627 Byset, Thomas, of Castelford 0
4442907 2182741 2182741 plaintiff Byset Richard   753627 753627 Byset, Richard, of Castelford 0
4442908 2182741 2182741 defendant Byset Wiliam   753627 753627 Byset, Wiliam, of Castelford 0
4442909 2182742 2182742 plaintiff Byset Thomas   753627 753627 Byset, Thomas, of Castelford 0
4442910 2182742 2182742 defendant Byset Wiliam   753627 753627 Byset, Wiliam, of Castelford 0
4476641 2193356 2193356 defendant Otir Thomas   753627 753627 Otir, Thomas, of Castelford 0
4521451 2207052 2207052 defendant Oter Thomas   753627 753627 Oter, Thomas, of Castelford 0
4530388 2209793 2209793 defendant Oter Thomas   753627 753627 Oter, Thomas, of Castelford 0
4539474 2212602 2212602 defendant Otur Thomas   753627 753627 Otur, Thomas, of Castelford 0
4553322 2216974 2216974 defendant Oter Thomas   753627 753627 Oter, Thomas, of Castelford 0
4599623 2231096 2231096 defendant Smyth William   753627 753627 Smyth, William, of Castelford 3
4600680 2231441 2231441 defendant Otour Thomas   753627 753627 Otour, Thomas, of Castelford 0
4604637 2232613 2232613 defendant Butler John   753627 753627 Butler, John, of Castelford, parson 8
4622578 2238040 2238040 defendant Walker Roger   753627 753627 Walker, Roger, of Castelford 2
4656166 2247812 2247812 plaintiff Byset William   753627 753627 Byset, William, of Castelford 0
4656167 2247812 2247812 defendant del Loft Thomas   753627 753627 del Loft, Thomas, of Castelford 0
4665830 2250788 2250788 defendant Morley William husbandman 753627 753627 Morley, William, of Castelford, husbandman 1
4787200 2292062 2292062 defendant Fox John smith 753627 753627 Fox, John, of Castelford, smith 0
4787201 2292062 2292062 defendant Kelyngbek John laborer 753627 753627 Kelyngbek, John, of Castelford, laborer 1
5072487 2378257 2378257 defendant Carleton John husbandman 753627 753627 Carleton, John, of Castelford, husbandman 0
5550054 2520053 2520053 defendant Thornton Christopher yeoman 753627 753627 Thornton, Christopher, of Castelford, yeoman 0
5552376 2520746 2520746 defendant Rawson James gent 753627 753627 Rawson, James, of Castelford, gent 0
5586904 2530938 2530938 defendant Raweson James yeoman 753627 753627 Raweson, James, of Castelford, yeoman 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);