names

25 rows where place_id = 768759

✎ 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
4435682 2175910 2175910 defendant Symme John   768759 768759 Symme John, of Renham 10
4435702 2175911 2175911 defendant Symme John   768759 768759 Symme John, of Renham 10
4514756 2205032 2205032 plaintiff Cartere Joan   768759 768759 (Cartere, Joan, of Renham, formerly wife of Hamon 1
4551826 2216517 2216517 defendant Joce John   768759 768759 Joce, John, of Renham 0
4551827 2216517 2216517 defendant Wornesell Lawrence   768759 768759 Wornesell, Lawrence, of Renham 1
4566954 2221227 2221227 defendant atte Welle alias Pulter Giles   768759 768759 atte Welle alias Pulter, Giles, of Renham 0
4574815 2223648 2223648 defendant Parker Giles   768759 768759 Parker, Giles, of Renham 1
4581005 2225538 2225538 plaintiff Donet James   768759 768759 Donet, James, of Renham 0
4581006 2225538 2225538 defendant Pope John   768759 768759 Pope, John, of Renham 0
4628410 2239809 2239809 defendant Bakere Hamon   768759 768759 Bakere, Hamon, of Renham 1
4628411 2239809 2239809 defendant Nicole Bartholomew   768759 768759 Nicole, Bartholomew, of Renham 2
4648580 2245638 2245638 defendant Walewere John   768759 768759 Walewere, John, of Renham 0
4718889 2271250 2271250 defendant Whitlok Thomas husbandman 768759 768759 Whitlok, Thomas, of Renham, husbandman 1
4719581 2271465 2271465 defendant Bloware Hamon laborer 768759 768759 Bloware, Hamon, of Renham, laborer 0
4760227 2283550 2283550 defendant Bromfeld Thomas husbandman 768759 768759 Bromfeld, Thomas, of Renham, husbandman 0
4773372 2287648 2287648 defendant Hethe Silvester husbandman 768759 768759 Hethe, Silvester, of Renham, husbandman 1
4786699 2291894 2291894 defendant Cosyn Thomas husbandman 768759 768759 Cosyn, Thomas, of Renham, husbandman 0
4818151 2301751 2301751 defendant Thomas Walter laborer 768759 768759 Thomas, Walter, of Renham, laborer 3
4818155 2301752 2301752 defendant Philyp Roger   768759 768759 Philyp, Roger, of Renham, bailiff 1
4879598 2320544 2320544 defendant Mace John laborer 768759 768759 Mace, John, of Renham, laborer 2
4879602 2320545 2320545 defendant Dyllay John husbandman 768759 768759 Dyllay, John, of Renham, husbandman 0
4999678 2356781 2356781 defendant Greffray Adam husbandman 768759 768759 Greffray, Adam, of Renham, husbandman 0
5105340 2388006 2388006 plaintiff Reme Thomas gent 768759 768759 Reme, Thomas, of Renham, gent 1
5105341 2388006 2388006 defendant atte Hethe Silvester yeoman 768759 768759 atte Hethe, Silvester, of Renham, yeoman 0
5209631 2418555 2418555 defendant Stoke Thomas   768759 768759 Stoke, Thomas, of Renham, vicar 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);