names

19 rows where place_id = 801428

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4780409 2289871 2289871 plaintiff Burgh Geoffrey dyer 801428 801428 Burgh, Geoffrey, of Clyve juxta Lewes, dyer 0
4781163 2290119 2290119 defendant Monkelonod William laborer 801428 801428 Monkelonod, William, of Clyve juxta Lewes, laborer 1
4781166 2290119 2290119 defendant Bette John skinner 801428 801428 Bette, John, of Clyve juxta Lewes, skinner 4
4791515 2293442 2293442 defendant Marys John dyer 801428 801428 Marys, John, of Clyve juxta Lewes, dyer 0
4801450 2296635 2296635 defendant Cadewell John chandler 801428 801428 Cadewell, John, of Clyve juxta Lewes, chandler 0
4867843 2316914 2316914 defendant Bust Thomas husbandman 801428 801428 Bust, Thomas, of Clyve juxta Lewes, husbandman 1
4869059 2317294 2317294 defendant Kyrkeby Robert dyer 801428 801428 Kyrkeby, Robert, of Clyve juxta Lewes, dyer 0
4869061 2317295 2317295 defendant Nycoll John dyer 801428 801428 Nycoll, John, of Clyve juxta Lewes, dyer 0
4943558 2339956 2339956 defendant Sevenoke William baker 801428 801428 Sevenoke, William, of Clyve juxta Lewes, baker 1
5018462 2362283 2362283 plaintiff Coole Richard   801428 801428 Coole, Richard, of Clyve juxta Lewes 0
5078537 2380075 2380075 defendant Lardener John husbandman 801428 801428 Lardener, John, of Clyve juxta Lewes, husbandman 0
5093514 2384502 2384502 defendant Laurence John   801428 801428 Laurence, John, of Clyve juxta Lewes, groom 0
5123868 2393438 2393438 plaintiff Wryther Amice   801428 801428 Wryther, Amice, of Clyve juxta Lewes, widow, administrators of 0
5224077 2422723 2422723 defendant Wodesyll Robert chapman 801428 801428 Wodesyll, Robert, of Clyve juxta Lewes, chapman 5
5624259 2551535 2551535 plaintiff Lardener William mercer 801428 801428 Lardener, William, of Clyve juxta Lewes, mercer 0
5624260 2551535 2551535 defendant Stykkere John husbandman 801428 801428 Stykkere, John, of Clyve juxta Lewes, husbandman 0
5636802 2555451 2555451 defendant Milot Richard yeoman 801428 801428 Milot, Richard, of Clyve juxta Lewes, yeoman 2
5636856 2555469 2555469 defendant Stikkere John husbandman 801428 801428 Stikkere, John, of Clyve juxta Lewes, husbandman 0
5636867 2555472 2555472 defendant Milet Richard yeoman 801428 801428 Milet, Richard, of Clyve juxta Lewes, yeoman 2

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