names

37 rows where place_id = 640548

✎ 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
3855978 1975493 1975493 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3855980 1975494 1975494 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3855982 1975495 1975495 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3865267 1978593 1978593 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3865270 1978594 1978594 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3865273 1978595 1978595 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3865439 1978657 1978657 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3869665 1980097 1980097 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3869907 1980179 1980179 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3869909 1980180 1980180 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3869911 1980181 1980181 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3879331 1983338 1983338 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3883723 1984827 1984827 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3883725 1984828 1984828 defendant Palmer Thomas gent 640548 640548 Palmer, Thomas, of Frampton, Lincs, gent 0
3959591 2010446 2010446 defendant Newporte John gent 640548 640548 Newporte, John, of Frampton, Lincs, gent 0
3976707 2016419 2016419 defendant Carleton Robert yeoman 640548 640548 Carleton, Robert, of Frampton, Lincs, yeoman 3
3985183 2019456 2019456 defendant Manson Thomas husbandman 640548 640548 Manson, Thomas, of Frampton, Lincs, husbandman 0
4668876 2255967 2255967 defendant Dane Roger gent 640548 640548 (Dane, Roger, of Frampton, Lincs, gent 3
4668882 2255968 2255968 defendant Bate Roger gent 640548 640548 (Bate, Roger, of Frampton, Lincs, gent 3
4700804 2265651 2265651 plaintiff Flete John   640548 640548 Flete, John, of Frampton, Lincs 0
4714183 2269763 2269763 defendant Bate Roger gent 640548 640548 together with Bate, Roger, of Frampton, Lincs, gent 4
4720750 2271823 2271823 defendant Copuldyke John clerk 640548 640548 Copuldyke, John, of Frampton, Lincs, clerk 0
4752615 2281225 2281225 defendant Bate Roger gent 640548 640548 (Bate, Roger, of Frampton, Lincs, gent 1
4897249 2325797 2325797 defendant Pawelyn John gent 640548 640548 Pawelyn, John, of Frampton, Lincs, gent 0
4898584 2326202 2326202 defendant Paulyn John gent 640548 640548 Paulyn, John, of Frampton, Lincs, gent 0
4915755 2331427 2331427 defendant Paulyn John gent 640548 640548 Paulyn, John, of Frampton, Lincs, gent 1
4942458 2339627 2339627 defendant Walkelyn Richard husbandman 640548 640548 Walkelyn, Richard, of Frampton, Lincs, husbandman 1
4942461 2339628 2339628 defendant Walkelyn Richard husbandman 640548 640548 Walkelyn, Richard, of Frampton, Lincs, husbandman 1
4964926 2346423 2346423 defendant Wakelyn Richard yeoman 640548 640548 Wakelyn, Richard, of Frampton, Lincs, yeoman 5
4970218 2348044 2348044 defendant Grenedyk Clement husbandman 640548 640548 Grenedyk, Clement, of Frampton, Lincs, husbandman 2
5048612 2371225 2371225 defendant Pawlyn John gent 640548 640548 Pawlyn, John, of Frampton, Lincs, gent 0
5090503 2383603 2383603 defendant Paulyn John gent 640548 640548 (Paulyn, John, of Frampton, Lincs, gent 1
5149456 2400975 2400975 defendant Morlande John yeoman 640548 640548 Morlande, John, of Frampton, Lincs, yeoman 0
5149457 2400975 2400975 defendant Claymonde William yeoman 640548 640548 Claymonde, William, of Frampton, Lincs, yeoman 1
5294562 2443387 2443387 defendant Richardson Robert husbandman 640548 640548 (Richardson, Robert, of Frampton, Lincs, husbandman 1
5304167 2446255 2446255 defendant Claymond Roger gent 640548 640548 Claymond, Roger, of Frampton, Lincs, gent 0
5581425 2529258 2529258 defendant Astubbys William husbandman 640548 640548 Astubbys, William, of Frampton, Lincs, husbandman 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);