names

22 rows where place_id = 757831

✎ 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
4448953 2184613 2184613 plaintiff Gaspy Walter   757831 757831 Gaspy, Walter, of Kirk Smeton 0
4448954 2184613 2184613 defendant del Wodhous John   757831 757831 del Wodhous, John, of Kirk Smeton 0
4722957 2272495 2272495 defendant Hertford Robert clerk 757831 757831 Hertford, Robert, of Kirk Smeton, clerk 0
5119108 2392024 2392024 defendant Rasby Brian husbandman 757831 757831 Rasby, Brian, of Kirk Smeton, husbandman 0
5119109 2392024 2392024 defendant Partryk John husbandman 757831 757831 Partryk, John, of Kirk Smeton, husbandman 1
5119110 2392024 2392024 defendant Hepdonstall John husbandman 757831 757831 Hepdonstall, John, of Kirk Smeton, husbandman 2
5119112 2392025 2392025 defendant Rasby Brian husbandman 757831 757831 Rasby, Brian, of Kirk Smeton, husbandman 0
5119113 2392025 2392025 defendant Partryk John husbandman 757831 757831 Partryk, John, of Kirk Smeton, husbandman 1
5119114 2392025 2392025 defendant Hepdonstall John husbandman 757831 757831 Hepdonstall, John, of Kirk Smeton, husbandman 2
5175143 2408423 2408423 defendant Hesill John yeoman 757831 757831 Hesill, John, of Kirk Smeton, yeoman 0
5270270 2436405 2436405 defendant Hogekynson Thomas husbandman 757831 757831 Hogekynson, Thomas, of Kirk Smeton, husbandman 5
5426361 2482841 2482841 defendant Wodhous Thomas husbandman 757831 757831 Wodhous, Thomas, of Kirk Smeton, husbandman 0
5426362 2482841 2482841 defendant Wodhouse John husbandman 757831 757831 Wodhouse, John, of Kirk Smeton, husbandman 1
5426363 2482841 2482841 defendant Carter Richard husbandman 757831 757831 Carter, Richard, of Kirk Smeton, husbandman 2
5444483 2488259 2488259 defendant Carter Richard husbandman 757831 757831 Carter, Richard, of Kirk Smeton, husbandman 0
5444488 2488259 2488259 defendant Wodehous John husbandman 757831 757831 Wodehous, John, of Kirk Smeton, husbandman 5
5444490 2488260 2488260 defendant Wodhouse Thomas husbandman 757831 757831 Wodhouse, Thomas, of Kirk Smeton, husbandman 0
5444491 2488260 2488260 defendant Wodhous John husbandman 757831 757831 Wodhous, John, of Kirk Smeton, husbandman 1
5444492 2488260 2488260 defendant Carter Richard husbandman 757831 757831 Carter, Richard, of Kirk Smeton, husbandman 2
5447178 2489046 2489046 plaintiff Hesill John   757831 757831 Hesill, John, of Kirk Smeton, administrators of 0
5572286 2526447 2526447 defendant Whitley William husbandman 757831 757831 Whitley, William, of Kirk Smeton, husbandman 0
5572288 2526448 2526448 defendant Whitley William husbandman 757831 757831 Whitley, William, of Kirk Smeton, husbandman 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);