names

59 rows where place_id = 589232

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596962 1866678 1866678 defendant Merkam Edmund husbandman 589232 589232 Merkam, Edmund, of Bamburgh, husbandman 3
3698021 1925606 1925606 defendant Cooke John, senior husbandman 589232 589232 Cooke, John, senior, of Bamburgh, husbandman 0
3740612 1938924 1938924 defendant Bonayr John husbandman 589232 589232 Bonayr, John, of Bamburgh, husbandman 0
3846740 1972535 1972535 defendant Jurdon John husbandman 589232 589232 Jurdon, John, of Bamburgh, husbandman 5
3901219 1990634 1990634 defendant Bonar Elizabeth widow 589232 589232 Bonar, Elizabeth, of Bamburgh, widow 1
3901223 1990635 1990635 defendant Boner Elizabeth widow 589232 589232 Boner, Elizabeth, of Bamburgh, widow 1
3908344 1993088 1993088 defendant Bonar William husbandman 589232 589232 Bonar, William, of Bamburgh, husbandman 0
3908345 1993088 1993088 defendant Bonar Margaret widow 589232 589232 Bonar, Margaret, of Bamburgh, widow 1
4125507 2069404 2069404 defendant Chamberlayne Agnes widow 589232 589232 Chamberlayne, Agnes, of Bamburgh, widow 2
4453656 2186156 2186156 defendant Gramme Alan chaplain 589232 589232 Gramme, Alan, of Bamburgh, chaplain 2
4453658 2186157 2186157 defendant Redesdale Nicholas   589232 589232 Redesdale, Nicholas, of Bamburgh 0
4453662 2186158 2186158 defendant Gramine Alan chaplain 589232 589232 Gramine, Alan, of Bamburgh, chaplain 2
4453666 2186159 2186159 defendant Gramine Alan chaplain 589232 589232 Gramine, Alan, of Bamburgh, chaplain 2
4453670 2186160 2186160 defendant Granmus Alan chaplain 589232 589232 Granmus, Alan, of Bamburgh, chaplain 2
4453674 2186162 2186162 defendant Redesdale Nicholas   589232 589232 Redesdale, Nicholas, of Bamburgh 0
4453676 2186163 2186163 defendant Redesdale Nicholas chaplain 589232 589232 Redesdale, Nicholas, of Bamburgh, chaplain 0
4660771 2249193 2249193 plaintiff Dikson William   589232 589232 Dikson, William, of Bamburgh 0
4683074 2260323 2260323 defendant Grene Roger laborer 589232 589232 Grene, Roger, of Bamburgh, laborer 0
4683075 2260323 2260323 defendant Taillour John shipman 589232 589232 Taillour, John, of Bamburgh, shipman 1
4731995 2275184 2275184 defendant Fox Stephen husbandman 589232 589232 Fox, Stephen, of Bamburgh, husbandman 2
4732204 2275251 2275251 defendant Badby Nicholas yeoman 589232 589232 Badby, Nicholas, of Bamburgh, yeoman 0
4827537 2304659 2304659 defendant Webster Thomas husbandman 589232 589232 Webster, Thomas, of Bamburgh, husbandman 2
4894360 2324916 2324916 defendant Grene Roger gent 589232 589232 Grene, Roger, of Bamburgh, gent 0
4894361 2324916 2324916 defendant Maltby Thomas   589232 589232 Maltby, Thomas, of Bamburgh, bailiff 1
4918315 2332247 2332247 defendant Red Alan yeoman 589232 589232 Red, Alan, of Bamburgh, yeoman 0
4918317 2332247 2332247 defendant Taylour John yeoman 589232 589232 Taylour, John, of Bamburgh, yeoman 2
4967139 2347104 2347104 defendant Blakwode Thomas yeoman 589232 589232 Blakwode, Thomas, of Bamburgh, yeoman 0
4967140 2347104 2347104 defendant Maltby Thomas yeoman 589232 589232 Maltby, Thomas, of Bamburgh, yeoman 1
4967151 2347107 2347107 defendant Gibson Walter yeoman 589232 589232 Gibson, Walter, of Bamburgh, yeoman 0
5055404 2373199 2373199 defendant Colt Thomas yeoman 589232 589232 Colt, Thomas, of Bamburgh, yeoman 2
5061306 2374967 2374967 defendant Brigham William gent 589232 589232 Brigham, William, of Bamburgh, gent 0
5061307 2374967 2374967 defendant Colt Thomas yeoman 589232 589232 Colt, Thomas, of Bamburgh, yeoman 1
5061308 2374967 2374967 defendant Eme John yeoman 589232 589232 Eme, John, of Bamburgh, yeoman 2
5061309 2374967 2374967 defendant Manne John yeoman 589232 589232 Manne, John, of Bamburgh, yeoman 3
5061310 2374967 2374967 defendant Heddon Thomas yeoman 589232 589232 Heddon, Thomas, of Bamburgh, yeoman 4
5061311 2374967 2374967 defendant Mawe Thomas yeoman 589232 589232 Mawe, Thomas, of Bamburgh, yeoman 5
5061312 2374967 2374967 defendant Temple Alan yeoman 589232 589232 Temple, Alan, of Bamburgh, yeoman 6
5061313 2374967 2374967 defendant Mawe John yeoman 589232 589232 Mawe, John, of Bamburgh, yeoman 7
5061314 2374967 2374967 defendant Ragge Thomas yeoman 589232 589232 Ragge, Thomas, of Bamburgh, yeoman 8
5061315 2374967 2374967 defendant Roger Simon yeoman 589232 589232 Roger, Simon, of Bamburgh, yeoman 9
5061316 2374967 2374967 defendant Snawe Thomas yeoman 589232 589232 Snawe, Thomas, of Bamburgh, yeoman 10
5061317 2374967 2374967 defendant Colt George yeoman 589232 589232 Colt, George, of Bamburgh, yeoman 11
5129409 2395089 2395089 defendant Alkokk William husbandman 589232 589232 Alkokk, William, of Bamburgh, husbandman 3
5142162 2398829 2398829 defendant Colt Thomas merchant 589232 589232 Colt, Thomas, of Bamburgh, merchant 1
5163332 2405010 2405010 defendant Colt Thomas merchant 589232 589232 Colt, Thomas, of Bamburgh, merchant 1
5163335 2405011 2405011 defendant Colt Thomas merchant 589232 589232 Colt, Thomas, of Bamburgh, merchant 1
5174940 2408366 2408366 defendant Colt Thomas yeoman 589232 589232 Colt, Thomas, of Bamburgh, yeoman 4
5176998 2408964 2408964 defendant Colt Thomas merchant 589232 589232 Colt, Thomas, of Bamburgh, merchant 1
5177022 2408973 2408973 defendant Colt Thomas merchant 589232 589232 Colt, Thomas, of Bamburgh, merchant 1
5182735 2410705 2410705 defendant Fenkyll Edward yeoman 589232 589232 Fenkyll, Edward, of Bamburgh, yeoman 1
5182742 2410706 2410706 defendant Lylburne Robert gent 589232 589232 Lylburne, Robert, of Bamburgh, gent 0
5182745 2410706 2410706 defendant Man John   589232 589232 Man, John, of Bamburgh 3
5182746 2410706 2410706 defendant Hela Thomas   589232 589232 Hela, Thomas, of Bamburgh 4
5182747 2410706 2410706 defendant Mowe Thomas   589232 589232 Mowe, Thomas, of Bamburgh 5
5182748 2410706 2410706 defendant Temple Alan   589232 589232 Temple, Alan, of Bamburgh 6
5182758 2410708 2410708 defendant Fenkyll Edward yeoman 589232 589232 Fenkyll, Edward, of Bamburgh, yeoman 1
5184964 2411348 2411348 defendant Colt Thomas yeoman 589232 589232 Colt, Thomas, of Bamburgh, yeoman 0
5184966 2411348 2411348 defendant Colt William yeoman 589232 589232 Colt, William, of Bamburgh, yeoman 2
5560131 2522925 2522925 defendant Bamburgh John husbandman 589232 589232 Bamburgh, John, of Bamburgh, husbandman 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);