names

77 rows where place_id = 590946

✎ 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
3602796 1868543 1868543 defendant Collys Robert clothmaker 590946 590946 Collys, Robert, of Wantage, clothmaker 0
3604132 1868958 1868958 defendant Colles Robert yeoman 590946 590946 Colles, Robert, of Wantage, yeoman 1
3604322 1869015 1869015 defendant Tyler John clothier 590946 590946 Tyler, John, of Wantage, clothier 1
3617612 1873130 1873130 defendant Collys Robert husbandman 590946 590946 Collys, Robert, of Wantage, husbandman 0
3621506 1874267 1874267 defendant Glover Richard glover 590946 590946 Glover, Richard, of Wantage, glover 3
3621507 1874267 1874267 defendant Byrymyll Thomas clothmaker 590946 590946 Byrymyll, Thomas, of Wantage, clothmaker 4
3659027 1913086 1913086 defendant Braston William chandler 590946 590946 Braston, William, of Wantage, chandler 0
3684858 1921400 1921400 defendant Leche Thomas butcher 590946 590946 Leche, Thomas, of Wantage, butcher 0
3685245 1921539 1921539 defendant Leche Thomas butcher 590946 590946 Leche, Thomas, of Wantage, butcher 0
3692039 1923679 1923679 defendant Leche Thomas butcher 590946 590946 Leche, Thomas, of Wantage, butcher 0
3692041 1923680 1923680 defendant Leche Thomas butcher 590946 590946 Leche, Thomas, of Wantage, butcher 0
3692511 1923842 1923842 defendant Pye John tanner 590946 590946 Pye, John, of Wantage, tanner 0
3694674 1924537 1924537 defendant Radisshe Nicholas   590946 590946 Radisshe, Nicholas, of Wantage, yeoman, serving man, St George Chapel, Wyndesore Castle 0
3709415 1929244 1929244 defendant Barret William miller 590946 590946 Barret, William, of Wantage, miller 0
3769155 1948008 1948008 defendant Estmond William husbandman 590946 590946 Estmond, William, of Wantage, husbandman 0
3815126 1962650 1962650 defendant Radysshe Nicholas yeoman 590946 590946 Radysshe, Nicholas, of Wantage, yeoman 0
3817609 1963411 1963411 defendant Rychardes Robert husbandman 590946 590946 Rychardes, Robert, of Wantage, husbandman 4
3849135 1973327 1973327 defendant Rychardys Robert husbandman 590946 590946 Rychardys, Robert, of Wantage, husbandman 2
3858461 1976306 1976306 defendant Alen Arthur gent 590946 590946 Alen, Arthur, of Wantage, gent 0
3866693 1979094 1979094 defendant Rudde John yeoman 590946 590946 Rudde, John, of Wantage, yeoman 0
3875539 1982054 1982054 defendant Styleman William   590946 590946 Styleman, William, of Wantage, parish clerk 0
3877459 1982697 1982697 defendant Pryde Thomas glover 590946 590946 Pryde, Thomas, of Wantage, glover 1
3877464 1982698 1982698 defendant Pryde Thomas glover 590946 590946 Pryde, Thomas, of Wantage, glover 1
3895688 1988761 1988761 defendant Trowloke John husbandman 590946 590946 Trowloke, John, of Wantage, husbandman 0
3906045 1992311 1992311 defendant Trewlock William husbandman 590946 590946 Trewlock, William, of Wantage, husbandman 0
3909925 1993627 1993627 defendant Trewloke John husbandman 590946 590946 Trewloke, John, of Wantage, husbandman 0
3986728 2019993 2019993 defendant Blake Richard mercer 590946 590946 Blake, Richard, of Wantage, mercer 0
4107566 2062994 2062994 defendant Knappe William yeoman 590946 590946 Knappe, William, of Wantage, yeoman 0
4107575 2062994 2062994 defendant Swayte William laborer 590946 590946 Swayte, William, of Wantage, laborer 9
4159148 2081270 2081270 defendant Knape William yeoman 590946 590946 Knape, William, of Wantage, yeoman 0
4159152 2081270 2081270 defendant Dennys Thomas blacksmith 590946 590946 Dennys, Thomas, of Wantage, blacksmith 4
4159156 2081270 2081270 defendant Swayte William tailor 590946 590946 Swayte, William, of Wantage, tailor 8
4182919 2089509 2089509 defendant Knappe William yeoman 590946 590946 Knappe, William, of Wantage, yeoman 1
4304829 2131823 2131823 defendant Strowde Richard husbandman 590946 590946 Strowde, Richard, of Wantage, husbandman 0
4304830 2131823 2131823 defendant Ludlowe Thomas husbandman 590946 590946 Ludlowe, Thomas, of Wantage, husbandman 1
4305273 2131984 2131984 defendant Hyne Bartholomew butcher 590946 590946 Hyne, Bartholomew, of Wantage, butcher 0
4305341 2132008 2132008 defendant Hyne Bartholomew butcher 590946 590946 Hyne, Bartholomew, of Wantage, butcher 0
4700602 2265597 2265597 defendant Giger Roger husbandman 590946 590946 Giger, Roger, of Wantage, husbandman 0
4703811 2266569 2266569 defendant Wydeford Richard gent 590946 590946 Wydeford, Richard, of Wantage, gent 2
4703816 2266570 2266570 defendant Wydeford Richard gent 590946 590946 Wydeford, Richard, of Wantage, gent 2
4704535 2266793 2266793 defendant Pleystowe John yeoman 590946 590946 Pleystowe, John, of Wantage, yeoman 1
4716710 2270546 2270546 defendant Pleystowe John yeoman 590946 590946 Pleystowe, John, of Wantage, yeoman 2
4722526 2272360 2272360 defendant Hardyng William husbandman 590946 590946 Hardyng, William, of Wantage, husbandman 0
4755486 2282095 2282095 defendant Folyot William husbandman 590946 590946 Folyot, William, of Wantage, husbandman 0
4836738 2307456 2307456 defendant Heler John   590946 590946 Heler, John, of Wantage, holy water clerk 0
4841005 2308721 2308721 defendant Hykkes Robert husbandman 590946 590946 Hykkes, Robert, of Wantage, husbandman 0
4847069 2310586 2310586 defendant Burymyll Roger weaver 590946 590946 Burymyll, Roger, of Wantage, weaver 0
4853687 2312569 2312569 defendant Whyte John baker 590946 590946 together with Whyte, John, of Wantage, baker 1
4853691 2312570 2312570 defendant _byn Edmund husbandman 590946 590946 _byn, Edmund, of Wantage, husbandman 1
4853692 2312570 2312570 defendant Barbour Thomas barber 590946 590946 Barbour, Thomas, of Wantage, barber 2
4994335 2355180 2355180 defendant Clenche John draper 590946 590946 Clenche, John, of Wantage, draper 0
4996611 2355842 2355842 defendant Hikkys Roger husbandman 590946 590946 Hikkys, Roger, of Wantage, husbandman 0
4997753 2356184 2356184 defendant Hopton Hugh mercer 590946 590946 Hopton, Hugh, of Wantage, mercer 0
5001353 2357278 2357278 defendant Busshop William barber 590946 590946 Busshop, William, of Wantage, barber 0
5147337 2400365 2400365 defendant Skynnere Richard   590946 590946 Skynnere, Richard, of Wantage, parchment maker 0
5154640 2402511 2402511 plaintiff Baldewyn Richard   590946 590946 Baldewyn, Richard, of Wantage 1
5167085 2406105 2406105 defendant Skynnere Richard   590946 590946 Skynnere, Richard, of Wantage, parchement maker 0
5167086 2406105 2406105 defendant Wyot John (legal representative) 590946 590946 Wyot, John, of Wantage, executrix of 1
5182334 2410589 2410589 defendant Skynnere Richard   590946 590946 Skynnere, Richard, of Wantage, parchment maker 0
5182336 2410589 2410589 defendant Wyot Alice   590946 590946 Wyot, Alice, of Wantage, widow, formerly wife of John Wyot 2
5182799 2410721 2410721 plaintiff Colyns John   590946 590946 Colyns, John, of Wantage 0
5182800 2410721 2410721 plaintiff Bedford Robert   590946 590946 Bedford, Robert, of Wantage 1
5203591 2416804 2416804 plaintiff Colyns John   590946 590946 Colyns, John, of Wantage 0
5203592 2416804 2416804 plaintiff Bedford Robert   590946 590946 Bedford, Robert, of Wantage 1
5298116 2444463 2444463 defendant Peke Thomas chapman 590946 590946 Peke, Thomas, of Wantage, chapman 1
5300834 2445209 2445209 plaintiff Colyns John   590946 590946 Colyns, John, of Wantage 0
5521511 2511544 2511544 defendant Collys Robert clothier 590946 590946 Collys, Robert, of Wantage, clothier 0
5521512 2511544 2511544 defendant Estmond Robert yeoman 590946 590946 Estmond, Robert, of Wantage, yeoman 1
5530934 2514192 2514192 defendant Collys Robert clothier 590946 590946 Collys, Robert, of Wantage, clothier 0
5546956 2519111 2519111 defendant Walter Robert yeoman 590946 590946 Walter, Robert, of Wantage, yeoman 0
5546958 2519112 2519112 defendant Walter Robert yeoman 590946 590946 Walter, Robert, of Wantage, yeoman 0
5548863 2519711 2519711 defendant Norres William chapman 590946 590946 Norres, William, of Wantage, chapman 0
5552005 2520627 2520627 defendant Tyler John (legal representative) 590946 590946 Tyler, John, of Wantage, executors of 0
5552049 2520640 2520640 defendant Tylar John (legal representative) 590946 590946 Tylar, John, of Wantage, executors of 0
5559706 2522797 2522797 defendant Lake John   590946 590946 Lake, John, of Wantage, "hoseer" 1
5559709 2522798 2522798 defendant Lake alias Hoseer John hosier 590946 590946 Lake alias Hoseer, John, of Wantage, hosier 1
5599192 2534627 2534627 defendant Leche Thomas butcher 590946 590946 Leche, Thomas, of Wantage, butcher 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);