names

38 rows where place_id = 589238

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596973 1866680 1866680 defendant Clerke John husbandman 589238 589238 Clerke, John, of Bulmer, husbandman 1
3597919 1866971 1866971 defendant Ricard John, senior husbandman 589238 589238 Ricard, John, senior, of Bulmer, husbandman 0
3677803 1919108 1919108 defendant Dekys John husbandman 589238 589238 Dekys, John, of Bulmer, husbandman 1
3677805 1919109 1919109 defendant Russhe Thomas husbandman 589238 589238 Russhe, Thomas, of Bulmer, husbandman 0
3690850 1923302 1923302 defendant Brag Nicholas yeoman 589238 589238 Brag, Nicholas, of Bulmer, yeoman 1
3690879 1923311 1923311 defendant Russhey John husbandman 589238 589238 Russhey, John, of Bulmer, husbandman 1
3750627 1942117 1942117 defendant Fryett Richard husbandman 589238 589238 Fryett, Richard, of Bulmer, husbandman 1
3763080 1946084 1946084 defendant Deke John husbandman 589238 589238 Deke, John, of Bulmer, husbandman 0
3764495 1946557 1946557 defendant Bragge Nicholas husbandman 589238 589238 Bragge, Nicholas, of Bulmer, husbandman 0
3764497 1946558 1946558 defendant Bragge Nicholas husbandman 589238 589238 Bragge, Nicholas, of Bulmer, husbandman 0
3776149 1950283 1950283 defendant Pery Robert husbandman 589238 589238 Pery, Robert, of Bulmer, husbandman 2
3780370 1951593 1951593 defendant Spencer John husbandman 589238 589238 Spencer, John, of Bulmer, husbandman 0
3846327 1972405 1972405 defendant Bragge John husbandman 589238 589238 Bragge, John, of Bulmer, husbandman 0
3876284 1982308 1982308 defendant Bragge John husbandman 589238 589238 Bragge, John, of Bulmer, husbandman 0
3880295 1983662 1983662 defendant Townne alias Clerk John laborer 589238 589238 Townne alias Clerk, John, of Bulmer, laborer 4
3972922 2015104 2015104 defendant Lawsell Robert husbandman 589238 589238 Lawsell, Robert, of Bulmer, husbandman 0
3996052 2023340 2023340 defendant Hall Leonard merchant 589238 589238 Hall, Leonard, of Bulmer, or of York, merchant 0
4040180 2038991 2038991 defendant Fyrmyn William yeoman 589238 589238 Fyrmyn, William, of Bulmer, yeoman 6
4040181 2038991 2038991 defendant Bragg Nicholas yeoman 589238 589238 Bragg, Nicholas, of Bulmer, yeoman 7
4040182 2038991 2038991 defendant Bragg William yeoman 589238 589238 Bragg, William, of Bulmer, yeoman 8
4040976 2039260 2039260 defendant Fyrmyn William yeoman 589238 589238 Fyrmyn, William, of Bulmer, yeoman 0
4345074 2145553 2145553 defendant Goldyngham Christopher gent 589238 589238 Goldyngham, Christopher, of Bulmer, gent 0
4380702 2158210 2158210 defendant Well Peter husbandman 589238 589238 Well, Peter, of Bulmer, husbandman 0
4381352 2158442 2158442 defendant Fayerfax Francis gent 589238 589238 Fayerfax, Francis, of Bulmer, gent 0
4398735 2164156 2164156 defendant Fawether Josiah gent 589238 589238 Fawether, Josiah, of Bulmer, gent 0
4487911 2196940 2196940 defendant Crane Thomas   589238 589238 Crane, Thomas, of Bulmer 0
4645470 2244744 2244744 defendant Dove Richard   589238 589238 Dove, Richard, of Bulmer 0
4739537 2277446 2277446 defendant Brig Richard yeoman 589238 589238 Brig, Richard, of Bulmer, yeoman 2
4822380 2303080 2303080 defendant Smyth John smith 589238 589238 Smyth, John, of Bulmer, smith 0
4953741 2343076 2343076 defendant Brige Richard yeoman 589238 589238 Brige, Richard, of Bulmer, yeoman 0
4967377 2347183 2347183 defendant Malton Robert yeoman 589238 589238 Malton, Robert, of Bulmer, yeoman 0
4993635 2354970 2354970 defendant (not given) Thomas rector of Downe 589238 589238 Downe, Thomas, of Bulmer, rector of the church 1
5042854 2369472 2369472 defendant Downe Thomas   589238 589238 Downe, Thomas, of Bulmer, rector 1
5177525 2409122 2409122 defendant Umfrey John husbandman 589238 589238 Umfrey, John, of Bulmer, husbandman 2
5177526 2409122 2409122 defendant Brygge John husbandman 589238 589238 Brygge, John, of Bulmer, husbandman 3
5340794 2457320 2457320 defendant Sclater John clerk 589238 589238 Sclater, John, of Bulmer, clerk 0
5537438 2516204 2516204 defendant Rweve Thomas husbandman 589238 589238 Rweve, Thomas, of Bulmer, husbandman 2
5585714 2530602 2530602 defendant Carter John husbandman 589238 589238 Carter, John, of Bulmer, husbandman 0

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