names

29 rows where case_id = 2438113

✎ 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
5276193 2438113 2438113 plaintiff Uvedale Thomas knight   Uvedale, Thomas, knight 0
5276194 2438113 2438113 plaintiff Uvedale Elizabeth     Elizabeth, his wife 1
5276195 2438113 2438113 defendant Sydeney William gent 822178 822178 Sydeney, William, of Kyngesham, Sussex, gent 0
5276196 2438113 2438113 defendant Goutur Giles gent 598126 598126 Goutur, Giles, of Cranley, gent 1
5276197 2438113 2438113 defendant Sevenoke John clerk 867561 867561 Sevenoke, John, of Rugwyke, Sussex, clerk 2
5276198 2438113 2438113 defendant Courtmyll John yeoman 591742 591742 Courtmyll, John, of Petworth, Sussex, yeoman 3
5276199 2438113 2438113 defendant Sherloke Thomas   588918 588918 Sherloke, Thomas, of Petworth 4
5276200 2438113 2438113 defendant Mose John laborer 867562 867562 Mose, John, of Alfolde, Surr, laborer 5
5276201 2438113 2438113 defendant Sterre John sawyer 633048 633048 Sterre, John, of Alfolde, sawyer 6
5276202 2438113 2438113 defendant Meryweder John yeoman 655280 655280 Meryweder, John, of Reygate, Surr, yeoman 7
5276203 2438113 2438113 defendant Rokesby John sawyer 633048 633048 Rokesby, John, of Alfolde, sawyer 8
5276204 2438113 2438113 defendant Bleke William sawyer 633048 633048 Bleke, William, of Alfolde, sawyer 9
5276205 2438113 2438113 defendant Hikkys Thomas sawyer 633734 633734 Hikkys, Thomas, of Alfold, sawyer 10
5276206 2438113 2438113 defendant Trego Walter sawyer 633048 633048 Trego, Walter, of Alfolde, sawyer 11
5276207 2438113 2438113 defendant Merston William sawyer 633048 633048 Merston, William, of Alfolde, sawyer 12
5276208 2438113 2438113 defendant Pope John tanner 633048 633048 Pope, John, of Alfolde, tanner 13
5276209 2438113 2438113 defendant Sherloke Henry tailor 633048 633048 Sherloke, Henry, of Alfolde, tailor 14
5276210 2438113 2438113 defendant Derby Alan husbandman 633048 633048 Derby, Alan, of Alfolde, husbandman 15
5276211 2438113 2438113 defendant Yonge John glasier 633048 633048 Yonge, John, of Alfolde, glasier 16
5276212 2438113 2438113 defendant Page William   633048 633048 Page, William, of Alfolde, lathe maker 17
5276213 2438113 2438113 defendant Dedelfolde George husbandman 867564 867564 Dedelfolde, George, of Uhurst or Ewhurst, Surr, husbandman 18
5276214 2438113 2438113 defendant Cokke John husbandman 867565 867565 Cokke, John, of Uhurst, husbandman 19
5276215 2438113 2438113 defendant Dandy William husbandman 867565 867565 Dandy, William, of Uhurst, husbandman 20
5276216 2438113 2438113 defendant Dandy John laborer 867565 867565 Dandy, John, of Uhurst, laborer 21
5276217 2438113 2438113 defendant Eylone William husbandman 867565 867565 Eylone, William, of Uhurst, husbandman 22
5276218 2438113 2438113 defendant Pratte John laborer 867565 867565 Pratte, John, of Uhurst, laborer 23
5276219 2438113 2438113 defendant Chambyr George tailor 867565 867565 Chambyr, George, of Uhurst, tailor 24
5276220 2438113 2438113 defendant Lynne John cooper 867565 867565 Lynne, John, of Uhurst, cooper 25
5276221 2438113 2438113 defendant Boteler Walter husbandman 867565 867565 Boteler, Walter, of Uhurst, husbandman 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);