names

26 rows where place_id = 594916

✎ 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
3618127 1873294 1873294 defendant Cattens Thomas carpenter 594916 594916 Cattens, Thomas, of Kynges Langley, carpenter 0
3768590 1947823 1947823 defendant Dyer Thomas chapman 594916 594916 Dyer, Thomas, of Kynges Langley, chapman 1
3851311 1974009 1974009 defendant Knevett Robert yeoman 594916 594916 Knevett, Robert, of Kynges Langley, yeoman 3
3851313 1974009 1974009 defendant Carter Richard yeoman 594916 594916 Carter, Richard, of Kynges Langley, yeoman 5
4543613 2213896 2213896 defendant Webbe Thomas   594916 594916 Webbe, Thomas, of Kynges Langley 1
4618484 2236790 2236790 defendant Karter John   594916 594916 Karter, John, of Kynges Langley 1
4618485 2236790 2236790 defendant Karter Richard   594916 594916 Karter, Richard, of Kynges Langley 2
4681829 2259929 2259929 defendant Arnmrerm Thomas in the Chilterne, yeoman 594916 594916 Arnmrerm Thomas, of Kynges Langley, in the Chilterne, yeoman 0
4711563 2268942 2268942 defendant Waleys Adam husbandman 594916 594916 Waleys, Adam, of Kynges Langley, husbandman 0
4746922 2279600 2279600 defendant Rogger John husbandman 594916 594916 Rogger, John, of Kynges Langley, husbandman 0
4746923 2279600 2279600 defendant Robert Nicholas husbandman 594916 594916 Robert, Nicholas, of Kynges Langley, husbandman 1
5067860 2376887 2376887 plaintiff Parker William gent 594916 594916 Parker, William, of Kynges Langley, gent 0
5092476 2384178 2384178 plaintiff Parker William gent 594916 594916 Parker, William, of Kynges Langley, gent 0
5092480 2384178 2384178 defendant Clerk Henry smith 594916 594916 Clerk, Henry, of Kynges Langley, smith 3
5097159 2385604 2385604 defendant Basse Peer wheeler 594916 594916 Basse, Peer, of Kynges Langley, wheeler 4
5223758 2422634 2422634 plaintiff Parker William gent 594916 594916 Parker, William, of Kynges Langley, gent 0
5223759 2422634 2422634 defendant Basse Peter wheeler 594916 594916 Basse, Peter, of Kynges Langley, wheeler 0
5223761 2422634 2422634 defendant Yonge William husbandman 594916 594916 Yonge, William, of Kynges Langley, husbandman 2
5223764 2422635 2422635 plaintiff Parker William gent 594916 594916 Parker, William, of Kynges Langley, gent 0
5223767 2422636 2422636 plaintiff Parker William gent 594916 594916 Parker, William, of Kynges Langley, gent 0
5267300 2435536 2435536 defendant Basse Peter wheeler 594916 594916 Basse, Peter, of Kynges Langley, wheeler 0
5352009 2460731 2460731 defendant Basse Margaret widow 594916 594916 Basse, Margaret, of Kynges Langley, widow 1
5375754 2468010 2468010 defendant Rolff John husbandman 594916 594916 Rolff, John, of Kynges Langley, husbandman 2
5527301 2513117 2513117 plaintiff Lessy Richard (legal representative) 594916 594916 Lessy, Richard, of Kynges Langley, clerk, administrator of 0
5527304 2513118 2513118 plaintiff Lessy Richard   594916 594916 Lessy, Richard, of Kynges Langley, clerk, administrators of 0
5545291 2518622 2518622 defendant Carter John husbandman 594916 594916 Carter, John, of Kynges Langley, husbandman 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);