names

29 rows where place_id = 593895

✎ 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
3613779 1871964 1871964 defendant Nebbe Thomas laborer 593895 593895 Nebbe, Thomas, of Pepyngbery, laborer 1
3633517 1905295 1905295 defendant Wynter William husbandman 593895 593895 Wynter, William, of Pepyngbery, husbandman 0
3769883 1948235 1948235 defendant Audeley William husbandman 593895 593895 Audeley, William, of Pepyngbery, husbandman 2
3982348 2018461 2018461 defendant Coyffe George   593895 593895 Coyffe, George, of Pepyngbery, "clovebordhewer" 0
4577332 2224426 2224426 defendant Marchaunt Thomas   593895 593895 Marchaunt, Thomas, of Pepyngbery 2
4672697 2257103 2257103 defendant R-- Thomas laborer 593895 593895 R--, Thomas, of Pepyngbery, laborer 1
4678250 2258805 2258805 defendant Roon Thomas turner 593895 593895 Roon, Thomas, of Pepyngbery, turner 0
4824481 2303705 2303705 defendant atte Broke John laborer 593895 593895 atte Broke, John, of Pepyngbery, laborer 0
4824482 2303705 2303705 defendant atte Broke Nicholas laborer 593895 593895 atte Broke, Nicholas, of Pepyngbery, laborer 1
4866716 2316552 2316552 defendant atte Broke Nicholas laborer 593895 593895 atte Broke, Nicholas, of Pepyngbery, laborer 0
4912036 2330267 2330267 defendant Benge William husbandman 593895 593895 Benge, William, of Pepyngbery, husbandman 2
4937509 2338106 2338106 defendant Benge William husbandman 593895 593895 Benge, William, of Pepyngbery, husbandman 1
5010931 2360053 2360053 defendant Wyse John   593895 593895 Wyse, John, of Pepyngbery, servant 2
5015423 2361392 2361392 defendant Benge William husbandman 593895 593895 Benge, William, of Pepyngbery, husbandman 1
5055909 2373335 2373335 defendant Benge William husbandman 593895 593895 Benge, William, of Pepyngbery, husbandman 0
5130156 2395305 2395305 plaintiff Dwale John   593895 593895 Dwale, John, of Pepyngbery 0
5294520 2443373 2443373 defendant Lorkyn Richard, senior husbandman 593895 593895 Lorkyn, Richard, senior, of Pepyngbery, husbandman 2
5294521 2443373 2443373 defendant Burdon George husbandman 593895 593895 Burdon, George, of Pepyngbery, husbandman 3
5344576 2458471 2458471 defendant at Rede John husbandman 593895 593895 at Rede, John, of Pepyngbery, husbandman 0
5355650 2461842 2461842 defendant Kempe John tailor 593895 593895 Kempe, John, of Pepyngbery, tailor 2
5387701 2471546 2471546 defendant Gold Richard shoemaker 593895 593895 Gold, Richard, of Pepyngbery, shoemaker 0
5387702 2471546 2471546 defendant Alen Thomas yeoman 593895 593895 Alen, Thomas, of Pepyngbery, yeoman 1
5400292 2475158 2475158 defendant Alen Thomas yeoman 593895 593895 Alen, Thomas, of Pepyngbery, yeoman 0
5400294 2475159 2475159 defendant Gold Richard   593895 593895 Gold, Richard, of Pepyngbery, shoe maker 0
5400295 2475159 2475159 defendant Alen Thomas yeoman 593895 593895 Alen, Thomas, of Pepyngbery, yeoman 1
5413294 2478904 2478904 defendant Gold Richard shoemaker 593895 593895 Gold, Richard, of Pepyngbery, shoemaker 0
5452901 2490746 2490746 defendant Aleyn Thomas husbandman 593895 593895 Aleyn, Thomas, of Pepyngbery, husbandman 3
5589779 2531795 2531795 defendant Lorkyn William husbandman 593895 593895 Lorkyn, William, of Pepyngbery, husbandman 1
5608761 2537640 2537640 defendant Alkn Thomas   593895 593895 Alkn, Thomas, of Pepyngbery 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);