names

24 rows where place_id = 696100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4112772 2064830 2064830 defendant Sacheverell Henry gent 696100 696100 Sacheverell, Henry, of Reresby, gent 0
4418561 2170684 2170684 defendant Neville William de   696100 696100 Neville, William de, of Reresby 2
4422911 2172020 2172020 plaintiff Folvill Robert de   696100 696100 Folvill, Robert de, of Reresby, parson 0
4429447 2174013 2174013 defendant Clerk John le   696100 696100 Clerk, John le, of Reresby 10
4506006 2202391 2202391 defendant Campyon John   696100 696100 Campyon, John, of Reresby 0
4506413 2202505 2202505 defendant Nevill Thomas   696100 696100 Nevill, Thomas, of Reresby 0
4552637 2216777 2216777 defendant Smyth John   696100 696100 Smyth, John, of Reresby 3
4560671 2219284 2219284 defendant Broun John   696100 696100 Broun, John, of Reresby 1
4643179 2244115 2244115 defendant atte Brygge John   696100 696100 atte Brygge, John, of Reresby 1
4728384 2274114 2274114 defendant Newyll Thomas gent 696100 696100 Newyll, Thomas, of Reresby, gent 0
4864477 2315863 2315863 plaintiff Folvyle John esq 696100 696100 Folvyle, John, of Reresby, esq 0
4869126 2317317 2317317 defendant Humburston William husbandman 696100 696100 Humburston, William, of Reresby, husbandman 0
4869318 2317371 2317371 defendant Humberston William laborer 696100 696100 Humberston, William, of Reresby, laborer 0
4920772 2333011 2333011 plaintiff Kebbell Walter esq 696100 696100 Kebbell, Walter, of Reresby, esq 0
4920795 2333018 2333018 plaintiff Kebyll Walter esq 696100 696100 Kebyll, Walter, of Reresby, esq 0
4946350 2340848 2340848 plaintiff Kelyet Walter   696100 696100 Kelyet, Walter, of Reresby 0
4972148 2348613 2348613 defendant Payn William husbandman 696100 696100 Payn, William, of Reresby, husbandman 0
5013891 2360913 2360913 defendant Clerke Thomas husbandman 696100 696100 Clerke, Thomas, of Reresby, husbandman 0
5039030 2368319 2368319 defendant Clerk Thomas husbandman 696100 696100 Clerk, Thomas, of Reresby, husbandman 4
5063788 2375700 2375700 plaintiff Kebell Walter esq 696100 696100 Kebell, Walter, of Reresby, esq 0
5112863 2390160 2390160 plaintiff Kebeell Walter esq 696100 696100 Kebeell, Walter, of Reresby, esq 0
5112872 2390161 2390161 plaintiff Kebeell Walter esq 696100 696100 Kebeell, Walter, of Reresby, esq 0
5112883 2390163 2390163 plaintiff Kebell Walter esq 696100 696100 Kebell, Walter, of Reresby, esq 0
5298963 2444677 2444677 defendant Wyl_ William laborer 696100 696100 Wyl_, William, of Reresby, laborer 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);