names

17 rows where place_id = 771289

✎ 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
4576645 2224206 2224206 plaintiff Bullok Gilbert   771289 771289 Bullok, Gilbert, of Alkebarowe 0
4601028 2231551 2231551 plaintiff (not given) William vicar of Tydde 771289 771289 Tydde, William, of Alkebarowe, vicar of the church 0
4601030 2231551 2231551 defendant Scot John   771289 771289 Scot, John, of Alkebarowe 0
4644998 2244610 2244610 defendant atte Halle Thomas   771289 771289 atte Halle, Thomas, of Alkebarowe 1
4644999 2244610 2244610 defendant Pydde William   771289 771289 Pydde, William, of Alkebarowe 2
4809728 2299206 2299206 plaintiff Garlot William chapman 771289 771289 Garlot, William, of Alkebarowe, chapman 1
4855165 2312966 2312966 defendant Magson Richard husbandman 771289 771289 Magson, Richard, of Alkebarowe, husbandman 1
4869202 2317341 2317341 defendant Gybonson John yeoman 771289 771289 Gybonson, John, of Alkebarowe, yeoman 7
4937504 2338105 2338105 plaintiff Burnette Henry   771289 771289 Burnette, Henry, of Alkebarowe 0
4940264 2338981 2338981 defendant Bateman John husbandman 771289 771289 Bateman, John, of Alkebarowe, husbandman 2
4966798 2346994 2346994 defendant Raper Thomas husbandman 771289 771289 Raper, Thomas, of Alkebarowe, husbandman 10
5222962 2422432 2422432 defendant Mote William husbandman 771289 771289 Mote, William, of Alkebarowe, husbandman 0
5222963 2422432 2422432 defendant Burnet Henry yeoman 771289 771289 Burnet, Henry, of Alkebarowe, yeoman 1
5626927 2552396 2552396 defendant Flesshewer Thomas butcher 771289 771289 Flesshewer, Thomas, of Alkebarowe, butcher 2
5631707 2553929 2553929 defendant atte Halle Thomas laborer 771289 771289 atte Halle, Thomas, of Alkebarowe, laborer 0
5631709 2553930 2553930 defendant atte Halle Thomas laborer 771289 771289 atte Halle, Thomas, of Alkebarowe, laborer 0
5631715 2553933 2553933 defendant Robynson Richard laborer 771289 771289 Robynson, Richard, of Alkebarowe, laborer 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);