names

28 rows where case_id = 2502772

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5492827 2502772 2502772 plaintiff Danby James knight   Danby, James, knight 0
5492828 2502772 2502772 defendant Caldebek Robert chaplain 893044 893044 Caldebek, Robert, of Beeston, Ledys, chaplain 0
5492829 2502772 2502772 defendant Marshall John yeoman 893044 893044 Marshall, John, of Beeston, Ledys, yeoman 1
5492830 2502772 2502772 defendant Brathwayte John cooper 893044 893044 Brathwayte, John, of Beeston, Ledys, cooper 2
5492831 2502772 2502772 defendant Stabyll Nicholas carpenter 893044 893044 Stabyll, Nicholas, of Beeston, Ledys, carpenter 3
5492832 2502772 2502772 defendant Cooke Nicholas husbandman 893044 893044 Cooke, Nicholas, of Beeston, Ledys, husbandman 4
5492833 2502772 2502772 defendant Stabyll Robert husbandman 893044 893044 Stabyll, Robert, of Beeston, Ledys, husbandman 5
5492834 2502772 2502772 defendant Busse Robert husbandman 893044 893044 Busse, Robert, of Beeston, Ledys, husbandman 6
5492835 2502772 2502772 defendant Casson William husbandman 893044 893044 Casson, William, of Beeston, Ledys, husbandman 7
5492836 2502772 2502772 defendant Casson John husbandman 893044 893044 Casson, John, of Beeston, Ledys, husbandman 8
5492837 2502772 2502772 defendant Naler Thomas husbandman 893044 893044 Naler, Thomas, of Beeston, Ledys, husbandman 9
5492838 2502772 2502772 defendant Walker Stephen walker 893044 893044 Walker, Stephen, of Beeston, Ledys, walker 10
5492839 2502772 2502772 defendant Denton William weaver 609752 609752 Denton, William, of Beeston, weaver 11
5492840 2502772 2502772 defendant Hynderson John weaver 609752 609752 Hynderson, John, of Beeston, weaver 12
5492841 2502772 2502772 defendant Felde Robert laborer 609752 609752 Felde, Robert, of Beeston, laborer 13
5492842 2502772 2502772 defendant Hall Robert laborer 609752 609752 Hall, Robert, of Beeston, laborer 14
5492843 2502772 2502772 defendant Casson William   609752 609752 Casson, William, of Beeston, wheelwright 15
5492844 2502772 2502772 defendant bryan Robert tailor 609752 609752 bryan, Robert, of Beeston, tailor 16
5492845 2502772 2502772 defendant Casson Robert tailor 609752 609752 Casson, Robert, of Beeston, tailor 17
5492846 2502772 2502772 defendant Casson Richard tailor 609752 609752 Casson, Richard, of Beeston, tailor 18
5492847 2502772 2502772 defendant Ball Lawrence miller 609752 609752 Ball, Lawrence, of Beeston, miller 19
5492848 2502772 2502772 defendant Casson Richard collier 609752 609752 Casson, Richard, of Beeston, collier 20
5492849 2502772 2502772 defendant Casson Robert collier 609752 609752 Casson, Robert, of Beeston, collier 21
5492850 2502772 2502772 defendant Bonlyt Thomas collier 609752 609752 Bonlyt, Thomas, of Beeston, collier 22
5492851 2502772 2502772 defendant Harlyng John smith 609752 609752 Harlyng, John, of Beeston, smith 23
5492852 2502772 2502772 defendant Colier Richard smith 893045 893045 Colier, Richard, of Heperon, Halifax, smith 24
5492853 2502772 2502772 defendant Manxson John yeoman 893046 893046 Manxson, John, of Churlwell, Batley, yeoman 25
5492854 2502772 2502772 defendant Busse Robert yeoman 893047 893047 Busse, Robert, of Cotyngley, Ledes, yeoman 26

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);