names

48 rows where place_id = 597480

✎ 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
3628755 1903872 1903872 defendant Miller John miller 597480 597480 Miller, John, of Bordesley, miller 2
3659105 1913107 1913107 defendant Fetherston Thomas cutler 597480 597480 Fetherston, Thomas, of Bordesley, cutler 0
3659106 1913107 1913107 defendant Porre John tanner 597480 597480 Porre, John, of Bordesley, tanner 1
3659108 1913108 1913108 defendant Fetherston Thomas cutler 597480 597480 Fetherston, Thomas, of Bordesley, cutler 0
3659109 1913108 1913108 defendant Porre John tanner 597480 597480 Porre, John, of Bordesley, tanner 1
3659112 1913109 1913109 defendant Perre Richard tanner 597480 597480 Perre, Richard, of Bordesley, tanner 1
3659115 1913110 1913110 defendant Perre Richard tanner 597480 597480 Perre, Richard, of Bordesley, tanner 1
3737748 1938028 1938028 defendant Cowdale William (legal representative) 597480 597480 Cowdale, William, of Bordesley, tanner, executor of 0
3752558 1942727 1942727 defendant Morton Daniel yeoman 597480 597480 Morton, Daniel, of Bordesley, yeoman 0
3752559 1942727 1942727 defendant Typper Thomas yeoman 597480 597480 Typper, Thomas, of Bordesley, yeoman 1
3813805 1962231 1962231 defendant Pryst John tanner 597480 597480 Pryst, John, of Bordesley, tanner 2
3863830 1978077 1978077 defendant Wygsted Thomas husbandman 597480 597480 Wygsted, Thomas, of Bordesley, husbandman 1
3895072 1988562 1988562 defendant Patchett Henry husbandman 597480 597480 Patchett, Henry, of Bordesley, husbandman 0
3895490 1988699 1988699 defendant Newey Richard smith 597480 597480 Newey, Richard, of Bordesley, smith 2
3898666 1989761 1989761 defendant Newey Richard smith 597480 597480 Newey, Richard, of Bordesley, smith 2
3907277 1992726 1992726 defendant Newhey Richard   597480 597480 Newhey, Richard, of Bordesley, scythe smith 0
3923100 1998029 1998029 defendant Cartwryght Henry yeoman 597480 597480 Cartwryght, Henry, of Bordesley, yeoman 1
3988587 2020663 2020663 defendant Ratton Ambrose tanner 597480 597480 Ratton, Ambrose, of Bordesley, tanner 0
3988588 2020663 2020663 defendant Parker William laborer 597480 597480 Parker, William, of Bordesley, laborer 1
3988599 2020666 2020666 defendant Ratton Ambrose tanner 597480 597480 Ratton, Ambrose, of Bordesley, tanner 0
3988600 2020666 2020666 defendant Parker William laborer 597480 597480 Parker, William, of Bordesley, laborer 1
4086860 2055593 2055593 defendant Nicoll alias Marshe Richard laborer 597480 597480 Nicoll alias Marshe, Richard, of Bordesley, laborer 0
4086861 2055593 2055593 defendant Nicoll alias Marshe Thomas   597480 597480 Nicoll alias Marshe, Thomas, of Bordesley, scythe smith 1
4086863 2055594 2055594 defendant Nicolls alias Marshe Richard laborer 597480 597480 Nicolls alias Marshe, Richard, of Bordesley, laborer 0
4086864 2055594 2055594 defendant Nicoll alias Marshe Thomas   597480 597480 Nicoll alias Marshe, Thomas, of Bordesley, scythe smith 1
4101188 2060735 2060735 defendant Newhey Richard   597480 597480 Newhey, Richard, of Bordesley, bellows maker 0
4101194 2060737 2060737 defendant Rotten Ambrose tanner 597480 597480 Rotten, Ambrose, of Bordesley, tanner 0
4101196 2060738 2060738 defendant Rotten Ambrose tanner 597480 597480 Rotten, Ambrose, of Bordesley, tanner 0
4112093 2064581 2064581 defendant Rotten Ambrose tanner 597480 597480 Rotten, Ambrose, of Bordesley, tanner 0
4112095 2064582 2064582 defendant Rotten Ambrose tanner 597480 597480 Rotten, Ambrose, of Bordesley, tanner 0
4281107 2123293 2123293 defendant Thacker William yeoman 597480 597480 Thacker, William, of Bordesley, yeoman 0
4292675 2127444 2127444 defendant Askrigg William gent 597480 597480 Askrigg, William, of Bordesley, gent 3
4340064 2143792 2143792 defendant More John yeoman 597480 597480 More, John, of Bordesley, yeoman 0
4360353 2150872 2150872 defendant Askericke William gent 597480 597480 Askericke, William, of Bordesley, gent 0
4665535 2250693 2250693 defendant Dene John husbandman 597480 597480 Dene, John, of Bordesley, husbandman 0
4709035 2268192 2268192 defendant atte Broke William tiler 597480 597480 atte Broke, William, of Bordesley, tiler 5
4810446 2299414 2299414 plaintiff Fekenham Richard   597480 597480 Fekenham, Richard, of Bordesley, abbot of St Mary's abbey 0
4810448 2299415 2299415 plaintiff Fekenham Richard   597480 597480 Fekenham, Richard, of Bordesley, abbot of the monastery 0
4822961 2303265 2303265 defendant Peny John yeoman 597480 597480 Peny, John, of Bordesley, yeoman 0
4822962 2303265 2303265 defendant Broke William husbandman 597480 597480 Broke, William, of Bordesley, husbandman 1
5243795 2428379 2428379 defendant Michell alias Chaumber John yeoman 597480 597480 Michell alias Chaumber, John, of Bordesley, yeoman 0
5290663 2442271 2442271 plaintiff Osbern John (legal representative) 597480 597480 Osbern, John, of Bordesley, barker, executors of 0
5348093 2459546 2459546 defendant Buggye William smith 597480 597480 Buggye, William, of Bordesley, smith 0
5396192 2473998 2473998 plaintiff Bidford William   597480 597480 Bidford, William, of Bordesley, abbot of the Monastery of BM 0
5396194 2473999 2473999 plaintiff Bidford William   597480 597480 Bidford, William, of Bordesley, abbot of the Monastery of BM 0
5396196 2474000 2474000 plaintiff Bidford William   597480 597480 Bidford, William, of Bordesley, abbot of the Monastery of BM 0
5396200 2474001 2474001 plaintiff Bidford William   597480 597480 Bidford, William, of Bordesley, abbot of the Monastery of BM 0
5396205 2474002 2474002 plaintiff Bidford William   597480 597480 Bidford, William, of Bordesley, abbot of the Monastery of BM 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);