names

29 rows where place_id = 611876

✎ 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
3690484 1923190 1923190 defendant Bodeman John husbandman 611876 611876 Bodeman, John, of Rowde, husbandman 1
3690487 1923191 1923191 defendant Bodeman John husbandman 611876 611876 Bodeman, John, of Rowde, husbandman 1
3753835 1943143 1943143 defendant Bodman John tucker 611876 611876 Bodman, John, of Rowde, tucker 0
3798243 1957348 1957348 defendant Scott Henry husbandman 611876 611876 Scott, Henry, of Rowde, husbandman 0
3815613 1962799 1962799 defendant Scott Henry husbandman 611876 611876 Scott, Henry, of Rowde, husbandman 1
3867969 1979521 1979521 defendant Northethorne John wheeler 611876 611876 Northethorne, John, of Rowde, wheeler 0
3867971 1979521 1979521 defendant Colyn Richard husbandman 611876 611876 Colyn, Richard, of Rowde, husbandman 2
3867972 1979521 1979521 defendant Hobbys Henry husbandman 611876 611876 Hobbys, Henry, of Rowde, husbandman 3
3947410 2006169 2006169 plaintiff Cockshedd Peter weaver 611876 611876 Cockshedd, Peter, of Rowde, weaver 0
3947412 2006170 2006170 plaintiff Cockshedd Peter weaver 611876 611876 Cockshedd, Peter, of Rowde, weaver 0
3978282 2016986 2016986 plaintiff Maundrell Richard servingman 611876 611876 Maundrell, Richard, of Rowde, servingman 0
3978283 2016986 2016986 defendant Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
3978286 2016988 2016988 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
3978288 2016989 2016989 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
3978290 2016990 2016990 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
3978293 2016991 2016991 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
3978295 2016992 2016992 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
4007969 2027611 2027611 plaintiff Maundrell Robert (legal representative) 611876 611876 Maundrell, Robert, of Rowde, yeoman, executor of 0
4007972 2027612 2027612 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
4007974 2027613 2027613 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
4007976 2027614 2027614 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
4007978 2027615 2027615 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
4007979 2027615 2027615 defendant Flower Robert yeoman or gent 611876 611876 Flower, Robert, of Rowde, yeoman or gent 0
4029064 2035038 2035038 defendant Ashman William   611876 611876 Ashman, William, of Rowde gent 0
4040052 2038942 2038942 plaintiff Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, yeoman 0
4070634 2049793 2049793 plaintiff Maundrell William gent 611876 611876 Maundrell, William, of Rowde, gent 0
4235590 2108017 2108017 defendant Hancocke Robert yeoman 611876 611876 Hancocke, Robert, of Rowde, yeoman 0
4247548 2112168 2112168 defendant Hancocke Robert yeoman 611876 611876 Hancocke, Robert, of Rowde, yeoman 0
4275014 2121214 2121214 defendant Maundrell William yeoman 611876 611876 Maundrell, William, of Rowde, 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);