names

18 rows where place_id = 614998

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3706595 1928348 1928348 defendant Sparowe William husbandman 614998 614998 Sparowe, William, of West Fyrle, husbandman 0
3706596 1928348 1928348 defendant Sparowe John laborer 614998 614998 Sparowe, John, of West Fyrle, laborer 1
3732100 1936273 1936273 defendant Olyver William husbandman 614998 614998 Olyver, William, of West Fyrle, husbandman 1
3804010 1959172 1959172 defendant Barandyne Adam husbandman 614998 614998 Barandyne, Adam, of West Fyrle, husbandman 1
4713868 2269662 2269662 defendant Benjamyn Richard gent 614998 614998 together with Benjamyn, Richard, of West Fyrle, gent 2
4770070 2286610 2286610 defendant Megge Thomas   614998 614998 Megge, Thomas, of West Fyrle 1
4789962 2292935 2292935 defendant atte Wode Peter laborer 614998 614998 atte Wode, Peter, of West Fyrle, laborer 0
4861018 2314804 2314804 defendant Wythyer Richard cordwainer 614998 614998 Wythyer, Richard, of West Fyrle, cordwainer 1
4894123 2324857 2324857 defendant atte Frythe John laborer 614998 614998 atte Frythe, John, of West Fyrle, laborer 1
4903539 2327718 2327718 defendant Stopham William laborer 614998 614998 Stopham, William, of West Fyrle, laborer 4
4963847 2346099 2346099 defendant Bysshe John husbandman 614998 614998 Bysshe, John, of West Fyrle, husbandman 0
5082650 2381316 2381316 defendant Colyn William husbandman 614998 614998 Colyn, William, of West Fyrle, husbandman 0
5219950 2421546 2421546 defendant Thondere Richard fuller 614998 614998 Thondere, Richard, of West Fyrle, fuller 0
5233965 2425524 2425524 defendant Geffray Richard husbandman 614998 614998 Geffray, Richard, of West Fyrle, husbandman 0
5479719 2498943 2498943 defendant Brykkendon John husbandman 614998 614998 Brykkendon, John, of West Fyrle, husbandman 0
5479720 2498943 2498943 defendant Man Roger husbandman 614998 614998 Man, Roger, of West Fyrle, husbandman 1
5574499 2527107 2527107 defendant Colyn Thomas yeoman 614998 614998 Colyn, Thomas, of West Fyrle, yeoman 0
5576684 2527754 2527754 defendant Jenour John yeoman 614998 614998 Jenour, John, of West Fyrle, 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);