names

26 rows where place_id = 599195

✎ 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
3635684 1905960 1905960 defendant Weston Abraham husbandman 599195 599195 Weston, Abraham, of Asgardby, husbandman 0
3647254 1909528 1909528 plaintiff Laurence John   599195 599195 Laurence, John, of Asgardby 0
3647256 1909528 1909528 plaintiff Taylour William   599195 599195 Taylour, William, of Asgardby 2
3832246 1968000 1968000 defendant Rayle John husbandman 599195 599195 Rayle, John, of Asgardby, husbandman 0
4501766 2201146 2201146 defendant Bryse John   599195 599195 Bryse, John, of Asgardby 8
4518131 2206043 2206043 defendant del More John   599195 599195 del More, John, of Asgardby, son of Walter 0
4652856 2246828 2246828 defendant Terres Richard husbandman 599195 599195 Terres, Richard, of Asgardby, husbandman 2
4652857 2246828 2246828 defendant Terres William husbandman 599195 599195 Terres, William, of Asgardby, husbandman 3
4652858 2246828 2246828 defendant Terres Abraham husbandman 599195 599195 Terres, Abraham, of Asgardby, husbandman 4
4652859 2246828 2246828 defendant Watkynson John husbandman 599195 599195 Watkynson, John, of Asgardby, husbandman 5
4698057 2264879 2264879 defendant Caleys Robert husbandman 599195 599195 Caleys, Robert, of Asgardby, husbandman 0
4710134 2268521 2268521 defendant Baghton James husbandman 599195 599195 Baghton, James, of Asgardby, husbandman 2
5021690 2363243 2363243 defendant More Thomas husbandman 599195 599195 More, Thomas, of Asgardby, husbandman 0
5054449 2372904 2372904 defendant Potter John yeoman 599195 599195 Potter, John, of Asgardby, yeoman 0
5098961 2386126 2386126 defendant Potter John yeoman 599195 599195 Potter, John, of Asgardby, yeoman 0
5194788 2414217 2414217 defendant Fysche Richard clerk 599195 599195 Fysche, Richard, of Asgardby, clerk 1
5194789 2414217 2414217 defendant Hobson Richard husbandman 599195 599195 Hobson, Richard, of Asgardby, husbandman 2
5208934 2418341 2418341 defendant Fysche Richard clerk 599195 599195 Fysche, Richard, of Asgardby, clerk 1
5208935 2418341 2418341 defendant Hobson Richard husbandman 599195 599195 Hobson, Richard, of Asgardby, husbandman 2
5235542 2425977 2425977 defendant More Thomas husbandman 599195 599195 More, Thomas, of Asgardby, husbandman 0
5284503 2440480 2440480 defendant More Thomas husbandman 599195 599195 More, Thomas, of Asgardby, husbandman 0
5302529 2445729 2445729 plaintiff Fissh Richard   599195 599195 Fissh, Richard, of Asgardby 0
5302530 2445729 2445729 defendant _re Thomas husbandman 599195 599195 _re, Thomas, of Asgardby, husbandman 0
5419080 2480633 2480633 defendant Potter John husbandman 599195 599195 Potter, John, of Asgardby, husbandman 3
5419081 2480633 2480633 defendant Baker John husbandman 599195 599195 Baker, John, of Asgardby, husbandman 4
5614371 2548286 2548286 defendant atte More Walter   599195 599195 atte More, Walter, of Asgardby 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);