names

16 rows where case_id = 2173964

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4429267 2173964 2173964 plaintiff Umframvill Gilbert de Earl of Anegos   Umframvill, Gilbert de, Earl of Anegos 0
4429268 2173964 2173964 defendant Wederyngton Roger de     Wederyngton, Roger de 0
4429269 2173964 2173964 defendant Swynburn William de     Swynburn, William de 1
4429270 2173964 2173964 defendant Heron William     Heron, William 2
4429271 2173964 2173964 defendant Shafthowe Thomas de     Shafthowe, Thomas de 3
4429272 2173964 2173964 defendant Clerk Richard le   660810 660810 Clerk, Richard le, of Colwell 4
4429273 2173964 2173964 defendant Waldesson John   755565 755565 Waldesson, John, of Eryngton 5
4429274 2173964 2173964 defendant (not given) Ralph his brother   Ralph, his brother 6
4429275 2173964 2173964 defendant Permanleye Thomas de     Permanleye, Thomas de 7
4429276 2173964 2173964 defendant Foner Randolf le   642667 642667 Foner, Randolf le, of Walle 8
4429277 2173964 2173964 defendant Silvertoppe Robert     Silvertoppe, Robert 9
4429278 2173964 2173964 defendant (not given) Nicholas vicar of Tollerton   Tollerton, Nicholas, vicar of 10
4429279 2173964 2173964 defendant Allertwayt John de   755566 755566 Allertwayt, John de, of Swyneburn 11
4429280 2173964 2173964 defendant Lamberd Adam   755567 755567 Lamberd, Adam, of Brytleye 12
4429281 2173964 2173964 defendant Hirdmanston William de     Hirdmanston, William de 13
4429282 2173964 2173964 defendant Silvertoppe Roger     Silvertoppe, Roger 14

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