names

18 rows where place_id = 640203

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3853862 1974840 1974840 defendant Shanke John yeoman 640203 640203 Shanke, John, of Yatele, yeoman 0
4417810 2170447 2170447 defendant atte Halle William   640203 640203 atte Halle, William, of Yatele 0
4417811 2170447 2170447 defendant Giffard John   640203 640203 Giffard, John, of Yatele 1
4417812 2170447 2170447 defendant White John le   640203 640203 White, John le, of Yatele 2
4417816 2170447 2170447 defendant atte Churche Ralph   640203 640203 atte Churche, Ralph, of Yatele 6
4417817 2170447 2170447 defendant Bocher Henry   640203 640203 Bocher, Henry, of Yatele 7
4417819 2170447 2170447 defendant atte Moure Gilbert   640203 640203 atte Moure, Gilbert, of Yatele 9
4417821 2170447 2170447 defendant atte Fourde Philip   640203 640203 atte Fourde, Philip, of Yatele 11
4417822 2170447 2170447 defendant Kach John le   640203 640203 Kach, John le, of Yatele 12
4428495 2173727 2173727 defendant atte Halle William   640203 640203 atte Halle, William, of Yatele 0
4428496 2173727 2173727 defendant Giffard John   640203 640203 Giffard, John, of Yatele 1
4428497 2173727 2173727 defendant Whyte John le   640203 640203 Whyte, John le, of Yatele 2
4428501 2173727 2173727 defendant atte Churche Ralph   640203 640203 atte Churche, Ralph, of Yatele 6
4428504 2173727 2173727 defendant atte Moure William   640203 640203 atte Moure, William, of Yatele 9
4428506 2173727 2173727 defendant atte Fourde John   640203 640203 atte Fourde, John, of Yatele 11
4428507 2173727 2173727 defendant Kach John   640203 640203 Kach, John, of Yatele 12
4956535 2343913 2343913 defendant White William yeoman 640203 640203 White, William, of Yatele, yeoman 0
4956540 2343914 2343914 defendant White William yeoman 640203 640203 White, William, of Yatele, 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);