names

13 rows where case_id = 1909412

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646834 1909412 1909412 plaintiff Katherine Queen of England     Katherine, Queen of England 0
3646835 1909412 1909412 defendant Fynymore Richard gent 593968 593968 Fynymore, Richard, of Calne, gent 0
3646836 1909412 1909412 defendant Seman Thomas gent 593968 593968 Seman, Thomas, of Calne, gent 1
3646837 1909412 1909412 defendant Roberte Nicholas yeoman 601744 601744 Roberte, Nicholas, of Daunsey, yeoman 2
3646838 1909412 1909412 defendant Bircombe Richard weaver 601747 601747 Bircombe, Richard, of Kyngeswode, weaver 3
3646839 1909412 1909412 defendant Chamber Thomas ticker 601747 601747 Chamber, Thomas, of Kyngeswode, ticker 4
3646840 1909412 1909412 defendant Bele William husbandman 601750 601750 Bele, William, of Brynkworth, husbandman 5
3646841 1909412 1909412 defendant Daners Thomas gent 601744 601744 Daners, Thomas, of Daunsey, gent 6
3646842 1909412 1909412 defendant Aleyn homas husbandman 601744 601744 Aleyn, homas, of Daunsey, husbandman 7
3646843 1909412 1909412 defendant Horsman Richard yeoman 601744 601744 Horsman, Richard, of Daunsey, yeoman 8
3646844 1909412 1909412 defendant Reve Thomas yeoman 593968 593968 Reve, Thomas, of Calne, yeoman 9
3646845 1909412 1909412 defendant Maye Thomas husbandman 601746 601746 Maye, Thomas, of Bromhill, husbandman 10
3646846 1909412 1909412 defendant Wayte Walter husbandman 601746 601746 Wayte, Walter, of Bromhill, husbandman 11

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