names

29 rows where place_id = 768076

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4545833 2214628 2214628 defendant Stace John   768076 768076 Stace, John, of Seasalter 0
4549104 2215655 2215655 defendant Brymesham John   768076 768076 Brymesham, John, of Seasalter 4
4552284 2216668 2216668 defendant Grymsham John   768076 768076 Grymsham, John, of Seasalter 1
4554465 2217329 2217329 defendant atte Mersshe Robert   768076 768076 atte Mersshe, Robert, of Seasalter 0
4557805 2218372 2218372 defendant Osebarn John, sen   768076 768076 Osebarn, John, sen, of Seasalter 0
4557808 2218372 2218372 defendant Hanyn William   768076 768076 Hanyn, William, of Seasalter 3
4566756 2221174 2221174 defendant Aleyn William   768076 768076 Aleyn, William, of Seasalter 4
4607312 2233397 2233397 defendant Shepwasshe John   768076 768076 Shepwasshe, John, of Seasalter 0
4607313 2233397 2233397 defendant atte Haghe John   768076 768076 atte Haghe, John, of Seasalter 1
4607314 2233397 2233397 defendant Marchaunt John   768076 768076 Marchaunt, John, of Seasalter 2
4615544 2235862 2235862 defendant Potyn John   768076 768076 Potyn, John, of Seasalter 0
4644348 2244438 2244438 defendant Taillour John   768076 768076 Taillour, John, of Seasalter 0
4712196 2269126 2269126 defendant Taillour John, sen waterman 768076 768076 Taillour, John, sen, of Seasalter, waterman 1
4716653 2270528 2270528 defendant Bolle John laborer 768076 768076 Bolle, John, of Seasalter, laborer 0
4807540 2298550 2298550 defendant Marchaunt John shipman 768076 768076 Marchaunt, John, of Seasalter, shipman 5
4832408 2306171 2306171 defendant Pawelyn Robert husbandman 768076 768076 Pawelyn, Robert, of Seasalter, husbandman 0
4832409 2306171 2306171 defendant Trent John laborer 768076 768076 Trent, John, of Seasalter, laborer 1
4832411 2306171 2306171 defendant Gylmyn Richard shipman 768076 768076 Gylmyn, Richard, of Seasalter, shipman 3
4832530 2306201 2306201 defendant Smelt John husbandman 768076 768076 Smelt, John, of Seasalter, husbandman 0
4832531 2306201 2306201 defendant Rufyn Nicholas laborer 768076 768076 Rufyn, Nicholas, of Seasalter, laborer 1
4832532 2306201 2306201 defendant Ballard William laborer 768076 768076 Ballard, William, of Seasalter, laborer 2
4832533 2306201 2306201 defendant Shipwayssh Nicholas husbandman 768076 768076 Shipwayssh, Nicholas, of Seasalter, husbandman 3
5309304 2447823 2447823 defendant Stace Adam laborer 768076 768076 Stace, Adam, of Seasalter, laborer 1
5309305 2447823 2447823 defendant Colyn Richard laborer 768076 768076 Colyn, Richard, of Seasalter, laborer 2
5364391 2464525 2464525 defendant Shipwesh Richard fisher 768076 768076 Shipwesh, Richard, of Seasalter, fisher 0
5364392 2464525 2464525 defendant Inge Robert brewer 768076 768076 Inge, Robert, of Seasalter, brewer 1
5388066 2471646 2471646 defendant Thornyng Thomas smith 768076 768076 Thornyng, Thomas, of Seasalter, smith 2
5421752 2481442 2481442 defendant Thornyng Thomas smith 768076 768076 Thornyng, Thomas, of Seasalter, smith 3
5466424 2494895 2494895 defendant Thornyng Thomas smith 768076 768076 Thornyng, Thomas, of Seasalter, smith 3

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