names

58 rows where place_id = 592213

✎ 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
3606941 1869835 1869835 defendant Garlyng William husbandman 592213 592213 Garlyng, William, of Wyllyngham, husbandman 1
3633526 1905297 1905297 defendant Bullyngbroke Thomas husbandman 592213 592213 Bullyngbroke, Thomas, of Wyllyngham, husbandman 0
3636297 1906143 1906143 defendant Bycare Robert husbandman 592213 592213 Bycare, Robert, of Wyllyngham, husbandman 2
3675985 1918525 1918525 defendant Greve John yeoman 592213 592213 Greve, John, of Wyllyngham, yeoman 0
3709573 1929302 1929302 defendant Maddy John butcher 592213 592213 Maddy, John, of Wyllyngham, butcher 0
3789942 1954680 1954680 defendant Humfrey Richard husbandman 592213 592213 Humfrey, Richard, of Wyllyngham, husbandman 0
3849705 1973493 1973493 defendant Graves John husbandman 592213 592213 Graves, John, of Wyllyngham, husbandman 0
3867162 1979255 1979255 defendant Talworth William husbandman 592213 592213 Talworth, William, of Wyllyngham, husbandman 1
3907073 1992652 1992652 defendant Hubbard William yeoman 592213 592213 Hubbard, William, of Wyllyngham, yeoman 3
4542030 2213398 2213398 defendant Bolle William   592213 592213 Bolle, William, of Wyllyngham 1
4593830 2229346 2229346 defendant Grantham Robert   592213 592213 Grantham, Robert, of Wyllyngham 0
4628447 2239818 2239818 defendant Bolle William   592213 592213 Bolle, William, of Wyllyngham 0
4756763 2282480 2282480 defendant Bolle John husbandman 592213 592213 Bolle, John, of Wyllyngham, husbandman 0
4814898 2300768 2300768 defendant Bolle John yeoman 592213 592213 Bolle, John, of Wyllyngham, yeoman 0
4833565 2306504 2306504 defendant Tayllour Philip husbandman 592213 592213 Tayllour, Philip, of Wyllyngham, husbandman 1
4842454 2309175 2309175 defendant Taillour Philip husbandman 592213 592213 Taillour, Philip, of Wyllyngham, husbandman 0
4842708 2309257 2309257 defendant Benyngworth John husbandman 592213 592213 Benyngworth, John, of Wyllyngham, husbandman 2
4860545 2314654 2314654 defendant Tayllour Philip husbandman 592213 592213 Tayllour, Philip, of Wyllyngham, husbandman 1
4870114 2317620 2317620 defendant Penell or Pevell William husbandman 592213 592213 Penell or Pevell, William, of Wyllyngham, husbandman 2
4870117 2317620 2317620 defendant Benyngworth John husbandman 592213 592213 Benyngworth, John, of Wyllyngham, husbandman 5
4892094 2324269 2324269 defendant Potell William husbandman 592213 592213 Potell, William, of Wyllyngham, husbandman 0
4893332 2324621 2324621 defendant Cheyne Henry husbandman 592213 592213 Cheyne, Henry, of Wyllyngham, husbandman 1
4938988 2338586 2338586 defendant Pynell William husbandman 592213 592213 Pynell, William, of Wyllyngham, husbandman 1
4939678 2338795 2338795 defendant Veek Peter husbandman 592213 592213 Veek, Peter, of Wyllyngham, husbandman 0
4939680 2338795 2338795 defendant Roger Roger husbandman 592213 592213 Roger, Roger, of Wyllyngham, husbandman 2
4947691 2341264 2341264 defendant Pynnell William husbandman 592213 592213 Pynnell, William, of Wyllyngham, husbandman 0
4969364 2347795 2347795 defendant Squyer Simon husbandman 592213 592213 Squyer, Simon, of Wyllyngham, husbandman 1
4981607 2351414 2351414 defendant Ely John husbandman 592213 592213 Ely, John, of Wyllyngham, husbandman 0
4992128 2354537 2354537 defendant fitz Piers John husbandman 592213 592213 fitz Piers, John, of Wyllyngham, husbandman 0
5086634 2382482 2382482 defendant Boteler John husbandman 592213 592213 Boteler, John, of Wyllyngham, husbandman 0
5187866 2412166 2412166 plaintiff Heynes Thomas (legal representative) 592213 592213 Heynes, Thomas, of Wyllyngham, executors of 0
5233898 2425501 2425501 defendant Elyot William husbandman 592213 592213 Elyot, William, of Wyllyngham, husbandman 0
5233900 2425502 2425502 defendant Elyot William husbandman 592213 592213 Elyot, William, of Wyllyngham, husbandman 0
5263209 2434238 2434238 defendant Byg William husbandman 592213 592213 Byg, William, of Wyllyngham, husbandman 1
5277110 2438394 2438394 defendant Adam William husbandman 592213 592213 Adam, William, of Wyllyngham, husbandman 0
5277112 2438394 2438394 defendant Hervy John husbandman 592213 592213 Hervy, John, of Wyllyngham, husbandman 2
5281720 2439724 2439724 defendant Brundale William husbandman 592213 592213 Brundale, William, of Wyllyngham, husbandman 0
5281722 2439725 2439725 defendant Brundale William husbandman 592213 592213 Brundale, William, of Wyllyngham, husbandman 0
5299646 2444867 2444867 defendant Burne John esq 592213 592213 Burne, John, of Wyllyngham, esq 1
5299657 2444869 2444869 defendant Burne John esq 592213 592213 Burne, John, of Wyllyngham, esq 3
5315143 2449585 2449585 defendant Hervy William pulter 592213 592213 Hervy, William, of Wyllyngham, pulter 3
5329328 2453856 2453856 defendant Bumpsted Robert gent 592213 592213 Bumpsted, Robert, of Wyllyngham, gent 0
5329329 2453856 2453856 defendant Bumpsted Robert clerk 592213 592213 Bumpsted, Robert, of Wyllyngham, clerk 1
5335546 2455704 2455704 defendant Brindale William husbandman 592213 592213 Brindale, William, of Wyllyngham, husbandman 0
5404144 2476264 2476264 defendant Herny William skinner 592213 592213 Herny, William, of Wyllyngham, skinner 1
5409199 2477719 2477719 defendant Hervy William   592213 592213 Hervy, William, of Wyllyngham 1
5417290 2480090 2480090 defendant Hervy William skinner 592213 592213 Hervy, William, of Wyllyngham, skinner 1
5417430 2480132 2480132 defendant Harvy William husbandman 592213 592213 Harvy, William, of Wyllyngham, husbandman 0
5434533 2485271 2485271 defendant Hervy William skinner 592213 592213 Hervy, William, of Wyllyngham, skinner 1
5434797 2485344 2485344 defendant Hervy William husbandman 592213 592213 Hervy, William, of Wyllyngham, husbandman 0
5536252 2515830 2515830 plaintiff Bydale John husbandman 592213 592213 Bydale, John, of Wyllyngham, husbandman 0
5536253 2515830 2515830 plaintiff Baryngham William husbandman 592213 592213 Baryngham, William, of Wyllyngham, husbandman 1
5540875 2517273 2517273 defendant Blande Thomas yeoman 592213 592213 Blande, Thomas, of Wyllyngham, yeoman 8
5571637 2526260 2526260 defendant Hervy John husbandman 592213 592213 (Hervy, John, of Wyllyngham, husbandman 2
5572549 2526515 2526515 defendant Wryght John husbandman 592213 592213 Wryght, John, of Wyllyngham, husbandman 0
5572550 2526515 2526515 defendant Wryght Thomas husbandman 592213 592213 Wryght, Thomas, of Wyllyngham, husbandman 1
5572551 2526515 2526515 defendant Wryght Robert, junior husbandman 592213 592213 Wryght, Robert, junior, of Wyllyngham, husbandman 2
5625710 2551983 2551983 defendant Ryby John weaver 592213 592213 Ryby, John, of Wyllyngham, weaver 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);