names

30 rows where case_id = 2213731

✎ 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
4543104 2213731 2213731 plaintiff Armeston William     Armeston, William 0
4543105 2213731 2213731 defendant Prestwyche Edmund     Prestwyche, Edmund 0
4543106 2213731 2213731 defendant Herdemon John son of Robert   Herdemon, John, son of Robert 1
4543107 2213731 2213731 defendant Densnape John     Densnape, John 2
4543108 2213731 2213731 defendant Dykenfeld Robert     Dykenfeld, Robert 3
4543109 2213731 2213731 defendant Matley Thomas     Matley, Thomas 4
4543110 2213731 2213731 defendant Garlek John     Garlek, John 5
4543111 2213731 2213731 defendant Hotursley Robert de     Hotursley, Robert de 6
4543112 2213731 2213731 defendant Blakbourn John de     Blakbourn, John de 7
4543113 2213731 2213731 defendant Arderne John son of Hugh   Arderne, John, son of Hugh 8
4543114 2213731 2213731 defendant Moseley Richard de     Moseley, Richard de 9
4543115 2213731 2213731 defendant Sylvester Richard     Sylvester, Richard 10
4543116 2213731 2213731 defendant More William de     More, William de 11
4543117 2213731 2213731 defendant Capeles Nicholas     Capeles, Nicholas 12
4543118 2213731 2213731 defendant Relegh Hugh de   612968 612968 Relegh, Hugh de, of Yorkshire 13
4543119 2213731 2213731 defendant Fylcok Thomas   612968 612968 Fylcok, Thomas, of Yorkshire 14
4543120 2213731 2213731 defendant Caryngton Arthur de     Caryngton, Arthur de 15
4543121 2213731 2213731 defendant Byrche William   669048 669048 Byrche, William, of Lancashire 16
4543122 2213731 2213731 defendant Barlowe John     Barlowe, John 17
4543123 2213731 2213731 defendant Rughford Ellis the chamberleyn, of the abbot, of   together with Rughford, Ellis, the chamberleyn, of the abbot, of 18
4543124 2213731 2213731 defendant Birkes William     Birkes, William 19
4543125 2213731 2213731 defendant Tetlowe Alexander     Tetlowe, Alexander 20
4543126 2213731 2213731 defendant Werberton Thomas de     Werberton, Thomas de 21
4543127 2213731 2213731 defendant Raulynson William     Raulynson, William 22
4543128 2213731 2213731 defendant Clementson John son of Richard   Clementson, John, son of Richard 23
4543129 2213731 2213731 defendant Benetson William son of William   Benetson, William, son of William 24
4543130 2213731 2213731 defendant Radyche Thomas son of William   Radyche, Thomas, son of William 25
4543131 2213731 2213731 defendant Hyde Nicholas     Hyde, Nicholas 26
4543132 2213731 2213731 defendant Sergeant Robert     Sergeant, Robert 27
4543133 2213731 2213731 defendant Bodworth William     Bodworth, William 28

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