names

22 rows where case_id = 2311909

✎ 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
4851493 2311909 2311909 plaintiff Upton William     Upton, William 0
4851494 2311909 2311909 defendant Rydder Alice widow 597124 597124 Rydder, Alice, of Waynflete, widow 0
4851495 2311909 2311909 defendant Garnon Robert chapman 586286 586286 Garnon, Robert, of Boston, chapman 1
4851496 2311909 2311909 defendant Busshe Thomas husbandman 649599 649599 Busshe, Thomas, of Fryskenay, husbandman 2
4851497 2311909 2311909 defendant Godfray John husbandman 597124 597124 Godfray, John, of Waynflete, husbandman 3
4851498 2311909 2311909 defendant Busshe Richard husbandman 594426 594426 Busshe, Richard, of Benyngton, husbandman 4
4851499 2311909 2311909 defendant Sporiour Thomas   586286 586286 Sporiour, Thomas, of Boston, iron worker 5
4851500 2311909 2311909 defendant Sporiour Robert   586286 586286 Sporiour, Robert, of Boston, iron worker 6
4851501 2311909 2311909 defendant Belleson Thomas gent 812696 812696 Belleson, Thomas, of Skirbuk, gent 7
4851502 2311909 2311909 defendant Beregge Richard husbandman 586286 586286 Beregge, Richard, of Boston, husbandman 8
4851503 2311909 2311909 defendant Forset John husbandman 587058 587058 Forset, John, of Sutton, husbandman 9
4851504 2311909 2311909 defendant Athelsay Robert   586286 586286 Athelsay, Robert, of Boston 10
4851505 2311909 2311909 defendant German John husbandman 587643 587643 German, John, of Ingoldmels, husbandman 11
4851506 2311909 2311909 defendant Marabull John husbandman 758127 758127 Marabull, John, of Algarkirk, husbandman 12
4851507 2311909 2311909 defendant London Thomas husbandman 758127 758127 London, Thomas, of Algarkirk, husbandman 13
4851508 2311909 2311909 defendant Sparogh Thomas husbandman 589460 589460 Sparogh, Thomas, of Spaldyng, husbandman 14
4851509 2311909 2311909 defendant Serle Simon husbandman 589460 589460 Serle, Simon, of Spaldyng, husbandman 15
4851510 2311909 2311909 defendant Nicolyn John husbandman 588422 588422 Nicolyn, John, of Croyland, husbandman 16
4851511 2311909 2311909 defendant Wegle Thomas   588422 588422 Wegle, Thomas, of Croyland, boat man 17
4851512 2311909 2311909 defendant Wryght John husbandman 586286 586286 Wryght, John, of Boston, husbandman 18
4851513 2311909 2311909 defendant Slye Richard gent 627541 627541 Slye, Richard, of Fossedyk, gent 19
4851514 2311909 2311909 defendant Cokson William husbandman 623893 623893 Cokson, William, of Marom, husbandman 20

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