names

27 rows where place_id = 761568

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4480040 2194427 2194427 defendant Richardson William   761568 761568 Richardson, William, of Scaleby 1
4480041 2194427 2194427 defendant Fleccher Robert   761568 761568 Fleccher, Robert, of Scaleby 2
4480042 2194427 2194427 defendant Thomson Richard   761568 761568 Thomson, Richard, of Scaleby 3
4480065 2194428 2194428 defendant Wilkynson William   761568 761568 Wilkynson, William, of Scaleby 7
4480076 2194428 2194428 defendant Jonesson William   761568 761568 Jonesson, William, of Scaleby 18
4506258 2202459 2202459 defendant Thomson John   761568 761568 Thomson, John, of Scaleby 2
4506528 2202535 2202535 defendant Story William   761568 761568 Story, William, of Scaleby 5
4631702 2240798 2240798 defendant Thomson Richard, sen   761568 761568 Thomson, Richard, sen, of Scaleby 1
4636681 2242294 2242294 defendant Robynson Richard   761568 761568 Robynson, Richard, of Scaleby 17
4636682 2242294 2242294 defendant Sourby Thomas de   761568 761568 Sourby, Thomas de, of Scaleby 18
4636683 2242294 2242294 defendant Saunderson John   761568 761568 Saunderson, John, of Scaleby 19
4688686 2262025 2262025 defendant Wode John yeoman 761568 761568 Wode, John, of Scaleby, yeoman 4
4702973 2266314 2266314 defendant Wode John yeoman 761568 761568 Wode, John, of Scaleby, yeoman 0
4702974 2266314 2266314 defendant Jonson Milner William yeoman 761568 761568 Jonson Milner, William, of Scaleby, yeoman 1
4729973 2274579 2274579 defendant Unthank William yeoman 761568 761568 Unthank, William, of Scaleby, yeoman 1
4824770 2303792 2303792 defendant Mulcastre Richard de gent 761568 761568 Mulcastre, Richard de, of Scaleby, gent 0
4833457 2306469 2306469 defendant Patonson John yeoman 761568 761568 Patonson, John, of Scaleby, yeoman 3
4848692 2311060 2311060 defendant Rayleton William yeoman 761568 761568 Rayleton, William, of Scaleby, yeoman 2
4848693 2311060 2311060 defendant Rayleton John yeoman 761568 761568 Rayleton, John, of Scaleby, yeoman 3
4850792 2311697 2311697 defendant Mulcastre Thomas de yeoman 761568 761568 Mulcastre, Thomas de, of Scaleby, yeoman 2
4869407 2317398 2317398 defendant Railton John yeoman 761568 761568 Railton, John, of Scaleby, yeoman 5
4980898 2351224 2351224 defendant Moncastre Thomas yeoman 761568 761568 Moncastre, Thomas, of Scaleby, yeoman 0
5095480 2385096 2385096 defendant Mulcastre Thomas yeoman 761568 761568 Mulcastre, Thomas, of Scaleby, yeoman 1
5158899 2403726 2403726 defendant Paton John yeoman 761568 761568 Paton, John, of Scaleby, yeoman 10
5158900 2403726 2403726 defendant ap Dale Robert yeoman 761568 761568 ap Dale, Robert, of Scaleby, yeoman 11
5626600 2552292 2552292 defendant Wilson John yeoman 761568 761568 Wilson, John, of Scaleby, yeoman 0
5632193 2554093 2554093 defendant Taillour John yeoman 761568 761568 Taillour, John, of Scaleby, yeoman 2

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);