names

19 rows where case_id = 2455057

✎ 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
5333377 2455057 2455057 plaintiff Damme Simon     Damme, Simon 0
5333378 2455057 2455057 defendant Breton Roger   592185 592185 Breton, Roger, of Sheryngham, shepherd 0
5333379 2455057 2455057 defendant Bettys Robert butcher 586471 586471 Bettys, Robert, of Aylesham, butcher 1
5333380 2455057 2455057 defendant Lacy Robert husbandman 599095 599095 Lacy, Robert, of North Bernyngham, husbandman 2
5333381 2455057 2455057 defendant Halle William husandman 595115 595115 Halle, William, of Aylmerton, husandman 3
5333382 2455057 2455057 defendant Bryngyng John husbandman 591888 591888 Bryngyng, John, of Couteshale, husbandman 4
5333383 2455057 2455057 defendant Goneld John husbandman 592153 592153 Goneld, John, of Wroxham, husbandman 5
5333384 2455057 2455057 defendant Seyne or Seyve John clerk 587464 587464 Seyne or Seyve, John, of Bakton, clerk 6
5333385 2455057 2455057 defendant Skendylby Roger butcher 586523 586523 Skendylby, Roger, of Cley juxta Mare, butcher 7
5333386 2455057 2455057 defendant Marsham Andrew butcher 595014 595014 Marsham, Andrew, of South Reppys, butcher 8
5333387 2455057 2455057 defendant Halle Cecily spinster 624092 624092 Halle, Cecily, of Susted, spinster 9
5333388 2455057 2455057 defendant Halle Robert husbandman 614359 614359 Halle, Robert, of Honeton St Peter, husbandman 10
5333389 2455057 2455057 defendant Gravour Edmund engraver 586471 586471 Gravour, Edmund, of Aylesham, engraver 11
5333390 2455057 2455057 defendant Cade John laborer 586471 586471 Cade, John, of Aylesham, laborer 12
5333391 2455057 2455057 defendant Worme John husbandman 601716 601716 Worme, John, of Antyngham, husbandman 13
5333392 2455057 2455057 defendant Smyth John warrener 587414 587414 Smyth, John, of Thetford, warrener 14
5333393 2455057 2455057 defendant Tonson John yeoman 587182 587182 Tonson, John, of Blakeney, yeoman 15
5333394 2455057 2455057 defendant Burgh John husbandman 590846 590846 Burgh, John, of Shipdam, husbandman 16
5333395 2455057 2455057 defendant Canon JOhn husbandman 587672 587672 Canon, JOhn, of Horsted, husbandman 17

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