names

41 rows where place_id = 592125

✎ 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
3606660 1869757 1869757 defendant Alberton Thomas gent 592125 592125 (Alberton, Thomas, of Colbroke, Bucks, gent 1
3612504 1871542 1871542 defendant Albon William cordwainer 592125 592125 Albon, William, of Colbroke, Bucks, cordwainer 7
3635786 1905993 1905993 defendant Wilson William beer brewer 592125 592125 Wilson, William, of Colbroke, Bucks, beer brewer 1
3645615 1909025 1909025 defendant Penrice Mathew innholder 592125 592125 Penrice, Mathew, of Colbroke, Bucks, innholder 0
3645617 1909026 1909026 defendant Penrice Mathew innholder 592125 592125 Penrice, Mathew, of Colbroke, Bucks, innholder 0
3648959 1910061 1910061 defendant Brusche John clothmaker 592125 592125 Brusche, John, of Colbroke, Bucks, clothmaker 3
3652333 1911066 1911066 defendant Lirth Thomas laborer 592125 592125 Lirth, Thomas, of Colbroke, Bucks, laborer 14
3730321 1935714 1935714 defendant Bromelowe David innholder 592125 592125 Bromelowe, David, of Colbroke, Bucks, innholder 2
3792904 1955633 1955633 defendant Barraker John husbandman 592125 592125 Barraker, John, of Colbroke, Bucks, husbandman 3
3792915 1955637 1955637 defendant Barraker John husbandman 592125 592125 Barraker, John, of Colbroke, Bucks, husbandman 0
3798781 1957533 1957533 defendant Barrycar John husbandman 592125 592125 Barrycar, John, of Colbroke, Bucks, husbandman 2
3889131 1986600 1986600 defendant Baylye William fishmonger 592125 592125 Baylye, William, of Colbroke, Bucks, fishmonger 0
3960561 2010797 2010797 defendant Estwey George butcher 592125 592125 Estwey, George, of Colbroke, Bucks, butcher 0
4002180 2025566 2025566 plaintiff Hayles John gent 592125 592125 Hayles, John, of Colbroke, Bucks, gent 0
4021270 2032332 2032332 defendant Bowsar Thomas (legal representative) 592125 592125 Bowsar, Thomas, of Colbroke, Bucks, gennt, executor of 0
4268283 2119002 2119002 defendant Litchfeild Mathew yeoman 592125 592125 Litchfeild, Mathew, of Colbroke, Bucks, yeoman 1
4792901 2293867 2293867 defendant Trumplyn John chaplain 592125 592125 Trumplyn, John, of Colbroke, Bucks, chaplain 0
4836702 2307447 2307447 defendant Bagot Richard   592125 592125 Bagot, Richard, of Colbroke, Bucks 2
4836707 2307448 2307448 defendant Bagot Richard yeoman 592125 592125 Bagot, Richard, of Colbroke, Bucks, yeoman 2
4983368 2351931 2351931 defendant Roger Clement yeoman 592125 592125 Roger, Clement, of Colbroke, Bucks, yeoman 2
5049359 2371440 2371440 defendant Bowyer William fletcher 592125 592125 Bowyer, William, of Colbroke, Bucks, fletcher 3
5078137 2379948 2379948 defendant Wodeward William gent 592125 592125 Wodeward, William, of Colbroke, Bucks, gent 0
5211533 2419110 2419110 defendant Reve William yeoman 592125 592125 Reve, William, of Colbroke, Bucks, yeoman 0
5212110 2419281 2419281 defendant Langeley alias Smyth William gent 592125 592125 Langeley alias Smyth, William, of Colbroke, Bucks, gent 2
5215292 2420200 2420200 defendant Padyngton William butcher 592125 592125 Padyngton, William, of Colbroke, Bucks, butcher 2
5233699 2425443 2425443 defendant Padyngton William butcher 592125 592125 Padyngton, William, of Colbroke, Bucks, butcher 1
5249382 2429934 2429934 defendant Trolly John miller 592125 592125 Trolly, John, of Colbroke, Bucks, miller 3
5254375 2431497 2431497 defendant Godale Adam esq 592125 592125 Godale, Adam, of Colbroke, Bucks, esq 0
5264335 2434601 2434601 defendant Pakyngton William butcher 592125 592125 Pakyngton, William, of Colbroke, Bucks, butcher 0
5267545 2435610 2435610 defendant Langley William ostler 592125 592125 Langley, William, of Colbroke, Bucks, ostler 0
5276844 2438311 2438311 defendant Barton Thomas yeoman 592125 592125 Barton, Thomas, of Colbroke, Bucks, yeoman 0
5281259 2439595 2439595 defendant Goodale Adam yeoman of the crown 592125 592125 Goodale, Adam, of Colbroke, Bucks, gent, yeoman of the crown for Henry VI 1
5329069 2453774 2453774 defendant Langley William gent 592125 592125 Langley, William, of Colbroke, Bucks, gent 3
5372535 2467008 2467008 defendant Trotte George butcher 592125 592125 Trotte, George, of Colbroke, Bucks, butcher 3
5372536 2467008 2467008 defendant Pakyngton William butcher 592125 592125 Pakyngton, William, of Colbroke, Bucks, butcher 4
5501546 2505416 2505416 defendant Bereaker Henry husbandman 592125 592125 Bereaker, Henry, of Colbroke, Bucks, husbandman 2
5501552 2505417 2505417 defendant Bereaker Henry husbandman 592125 592125 Bereaker, Henry, of Colbroke, Bucks, husbandman 2
5522704 2511929 2511929 defendant Holwey William yeoman 592125 592125 Holwey, William, of Colbroke, Bucks, yeoman 1
5522709 2511930 2511930 defendant Holwey Arkenwald yeoman 592125 592125 Holwey, Arkenwald, of Colbroke, Bucks, yeoman 1
5553352 2521020 2521020 defendant Barraker Henry yeoman 592125 592125 Barraker, Henry, of Colbroke, Bucks, yeoman 0
5636898 2555484 2555484 defendant Medgate John miller 592125 592125 Medgate, John, of Colbroke, Bucks, miller 1

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