names

24 rows where place_id = 622649

✎ 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
3748182 1941361 1941361 defendant Goddyng Thomas yeoman 622649 622649 Goddyng, Thomas, of South Walsham, Norf, yeoman 0
3752619 1942749 1942749 defendant Sharpe Robert husbandman 622649 622649 Sharpe, Robert, of South Walsham, Norf, husbandman 2
3752624 1942750 1942750 defendant Sharpe Robert husbandman 622649 622649 Sharpe, Robert, of South Walsham, Norf, husbandman 3
3762343 1945865 1945865 defendant Steyne Christopher yeoman 622649 622649 Steyne, Christopher, of South Walsham, Norf, yeoman 0
3771129 1948662 1948662 plaintiff Steyne Christopher yeoman 622649 622649 Steyne, Christopher, of South Walsham, Norf, yeoman 0
3780471 1951624 1951624 defendant Goddyng Thomas yeoman 622649 622649 Goddyng, Thomas, of South Walsham, Norf, yeoman 0
3858618 1976368 1976368 defendant Sharpe Robert husbandman 622649 622649 Sharpe, Robert, of South Walsham, Norf, husbandman 0
3871565 1980731 1980731 defendant Bruer Richard clerk 622649 622649 Bruer, Richard, of South Walsham, Norf, clerk 0
4154623 2079713 2079713 defendant Bate Anthony   622649 622649 Bate, Anthony, of South Walsham, Norf, yeoman, bachelor 0
4301871 2130778 2130778 defendant Carr Richard blacksmith 622649 622649 Carr, Richard, of South Walsham, Norf, blacksmith 1
4337873 2142989 2142989 defendant Davis John yeoman 622649 622649 Davis, John, of South Walsham, Norf, yeoman 3
4358035 2150052 2150052 defendant Rownce James yeoman 622649 622649 Rownce, James, of South Walsham, Norf, yeoman 2
4382433 2158825 2158825 defendant Rownce James yeoman 622649 622649 Rownce, James, of South Walsham, Norf, yeoman 2
4932519 2336565 2336565 defendant Corsour Henry husbandman 622649 622649 Corsour, Henry, of South Walsham, Norf, husbandman 0
4963054 2345858 2345858 defendant Pekhare William yeoman 622649 622649 Pekhare, William, of South Walsham, Norf, yeoman 0
5088938 2383140 2383140 defendant Fuller John husbandman 622649 622649 Fuller, John, of South Walsham, Norf, husbandman 0
5096836 2385506 2385506 defendant Moundford John reeder 622649 622649 Moundford, John, of South Walsham, Norf, reeder 1
5096840 2385507 2385507 defendant Moundford John reeder or reader 622649 622649 Moundford, John, of South Walsham, Norf, reeder or reader 1
5380225 2469392 2469392 defendant Fuller Nicholas husbandman 622649 622649 Fuller, Nicholas, of South Walsham, Norf, husbandman 1
5380226 2469392 2469392 defendant Hoke John husbandman 622649 622649 Hoke, John, of South Walsham, Norf, husbandman 2
5443823 2488070 2488070 defendant Eccles William husbandman 622649 622649 Eccles, William, of South Walsham, Norf, husbandman 3
5456558 2491886 2491886 defendant Gales William husbandman 622649 622649 Gales, William, of South Walsham, Norf, husbandman 2
5468410 2495492 2495492 defendant Eccles William husbandman 622649 622649 Eccles, William, of South Walsham, Norf, husbandman 2
5541901 2517584 2517584 defendant Ecclys William husbandman 622649 622649 Ecclys, William, of South Walsham, Norf, husbandman 1

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