names

22 rows where place_id = 598715

✎ 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
3633735 1905362 1905362 plaintiff Lecheford Henry   598715 598715 Lecheford, Henry, of Cherlewode 0
3633737 1905363 1905363 plaintiff Lecheford Henry   598715 598715 Lecheford, Henry, of Cherlewode 0
4413578 2169139 2169139 defendant Rolf Simon   598715 598715 Rolf, Simon, of Cherlewode 1
4422261 2171831 2171831 defendant Whyte Walter le   598715 598715 Whyte, Walter le, of Cherlewode 0
4490521 2197727 2197727 plaintiff Walssh William   598715 598715 Walssh, William, of Cherlewode 0
4581859 2225771 2225771 defendant White Thomas   598715 598715 White, Thomas, of Cherlewode 2
4630005 2240306 2240306 defendant White Thomas   598715 598715 White, Thomas, of Cherlewode 0
4630007 2240306 2240306 defendant atte Hale Thomas   598715 598715 atte Hale, Thomas, of Cherlewode 2
4630008 2240306 2240306 defendant atte Wode Adam   598715 598715 atte Wode, Adam, of Cherlewode 3
4630009 2240306 2240306 defendant atte Wode Simon   598715 598715 atte Wode, Simon, of Cherlewode 4
4630013 2240306 2240306 defendant Baylly Richard   598715 598715 Baylly, Richard, of Cherlewode 8
4690773 2262653 2262653 defendant Jurdan Thomas yeoman 598715 598715 Jurdan, Thomas, of Cherlewode, yeoman 0
4690774 2262653 2262653 defendant atte Denne Walter parker 598715 598715 atte Denne, Walter, of Cherlewode, parker 1
4694668 2263830 2263830 defendant Welborne John   598715 598715 Welborne, John, of Cherlewode, vicar 0
4716562 2270498 2270498 defendant atte Denne Walter   598715 598715 atte Denne, Walter, of Cherlewode, park man 1
4825921 2304139 2304139 defendant atte Watere John shoemaker 598715 598715 atte Watere, John, of Cherlewode, shoemaker 0
4828943 2305096 2305096 defendant Man John husbandman 598715 598715 Man, John, of Cherlewode, husbandman 0
4828944 2305096 2305096 defendant Moton John husbandman 598715 598715 Moton, John, of Cherlewode, husbandman 1
4891810 2324180 2324180 defendant White Thomas husbandman 598715 598715 White, Thomas, of Cherlewode, husbandman 0
5153996 2402331 2402331 defendant Saunder John husbandman 598715 598715 Saunder, John, of Cherlewode, husbandman 0
5171386 2407356 2407356 defendant Saunder John husbandman 598715 598715 Saunder, John, of Cherlewode, husbandman 0
5568032 2525207 2525207 defendant Saunders John gent 598715 598715 Saunders, John, of Cherlewode, gent 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);