names

61 rows where place_id = 588614

✎ 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
3595057 1866087 1866087 defendant Alysaunder Robert   588614 588614 Alysaunder, Robert, of Coston 0
3603350 1868720 1868720 defendant Payne John husbandman 588614 588614 Payne, John, of Coston, husbandman 3
3610977 1871110 1871110 defendant Parre Peter husbandman 588614 588614 Parre, Peter, of Coston, husbandman 0
3678206 1919237 1919237 defendant Garlond Thomas husbandman 588614 588614 Garlond, Thomas, of Coston, husbandman 0
3717376 1931719 1931719 defendant Dey Thomas husbandman 588614 588614 Dey, Thomas, of Coston, husbandman 0
3721394 1933001 1933001 plaintiff Leycetour William esq 588614 588614 Leycetour, William, of Coston, esq 0
3726924 1934686 1934686 defendant Dey Thomas husbandman 588614 588614 Dey, Thomas, of Coston, husbandman 0
3782311 1952220 1952220 plaintiff Horssyngton John husbandman 588614 588614 Horssyngton, John, of Coston, husbandman 0
3782313 1952221 1952221 plaintiff Horssyngton John husbandman 588614 588614 Horssyngton, John, of Coston, husbandman 0
3782315 1952222 1952222 plaintiff Horsyngton John husbandman 588614 588614 Horsyngton, John, of Coston, husbandman 0
3790576 1954875 1954875 defendant Wright William butcher 588614 588614 Wright, William, of Coston, butcher 0
3833229 1968324 1968324 defendant Horsyngton John husbandman 588614 588614 Horsyngton, John, of Coston, husbandman 0
3833230 1968324 1968324 defendant Horsyngton Giles husbandman 588614 588614 Horsyngton, Giles, of Coston, husbandman 1
3864554 1978343 1978343 defendant Ford John husbandman 588614 588614 Ford, John, of Coston, husbandman 1
3870405 1980345 1980345 defendant Horsyngton Agnes widow 588614 588614 (Horsyngton, Agnes, of Coston, widow 1
3870406 1980345 1980345 defendant Horsyngton Giles husbandman 588614 588614 Horsyngton, Giles, of Coston, husbandman 2
3870407 1980345 1980345 defendant Horsyngton Richard husbandman 588614 588614 Horsyngton, Richard, of Coston, husbandman 3
3890534 1987094 1987094 plaintiff Hosyngton Thomas   588614 588614 Hosyngton, Thomas, of Coston 0
4037503 2038076 2038076 defendant Neave William yeoman 588614 588614 Neave, William, of Coston, yeoman 0
4041412 2039420 2039420 plaintiff Neve William tanner 588614 588614 Neve, William, of Coston, tanner 0
4105393 2062210 2062210 defendant Coston Thomas gent 588614 588614 Coston, Thomas, of Coston, gent 0
4215653 2100974 2100974 defendant Smythe John husbandman 588614 588614 Smythe, John, of Coston, husbandman 0
4215654 2100974 2100974 defendant Rowse Robert husbandman 588614 588614 Rowse Robert, of Coston, husbandman 1
4215655 2100974 2100974 defendant Heane John senior husbandman 588614 588614 Heane, John senior, of Coston, husbandman 2
4215656 2100974 2100974 defendant Robert Adam husbandman 588614 588614 Robert, Adam, of Coston, husbandman 3
4241474 2110132 2110132 defendant Croche Edmund yeoman 588614 588614 Croche, Edmund, of Coston, yeoman 2
4403409 2165707 2165707 defendant Baies George yeoman 588614 588614 Baies, George, of Coston, yeoman 1
4613906 2235364 2235364 plaintiff Dey Henry   588614 588614 Dey, Henry, of Coston 0
4636889 2242352 2242352 defendant Goweteby Roger de   588614 588614 Goweteby, Roger de, of Coston, parson 4
4636895 2242353 2242353 defendant Goweteby Roger de   588614 588614 Goweteby, Roger de, of Coston, parson 4
4653466 2247015 2247015 defendant Harper Hugh laborer 588614 588614 Harper, Hugh, of Coston, laborer 0
4657801 2248327 2248327 defendant Harper Hugh laborer 588614 588614 Harper, Hugh, of Coston, laborer 0
4661634 2249475 2249475 plaintiff Erthy John   588614 588614 Erthy, John, of Coston 0
4664520 2250384 2250384 defendant Beek William husbandman 588614 588614 Beek, William, of Coston, husbandman 0
4664521 2250384 2250384 defendant Drover Hugh   588614 588614 Drover, Hugh, of Coston, sow gelder 1
4683046 2260312 2260312 defendant Hodyngton Richard gent 588614 588614 Hodyngton, Richard, of Coston, gent 0
4746854 2279582 2279582 defendant Beby John   588614 588614 Beby, John, of Coston, parson 0
4746857 2279583 2279583 defendant Kyme William yeoman 588614 588614 Kyme, William, of Coston, yeoman 0
4746858 2279583 2279583 defendant Fraunser John yeoman 588614 588614 Fraunser, John, of Coston, yeoman 1
4760110 2283506 2283506 defendant Beek William husbandman 588614 588614 Beek, William, of Coston, husbandman 1
4849258 2311244 2311244 defendant Bawedewyn Thomas husbandman 588614 588614 Bawedewyn, Thomas, of Coston, husbandman 1
4876911 2319747 2319747 defendant Kyme William butcher 588614 588614 Kyme, William, of Coston, butcher 0
4876912 2319747 2319747 defendant Baudewyn Thomas husbandman 588614 588614 Baudewyn, Thomas, of Coston, husbandman 1
4892500 2324393 2324393 defendant Bele Thomas husbandman 588614 588614 Bele, Thomas, of Coston, husbandman 0
4892501 2324393 2324393 defendant Bele William husbandman 588614 588614 Bele, William, of Coston, husbandman 1
4976658 2349976 2349976 defendant Beell Thomas husbandman 588614 588614 Beell, Thomas, of Coston, husbandman 1
4976660 2349976 2349976 defendant Gervas John husbandman 588614 588614 Gervas, John, of Coston, husbandman 3
4976663 2349977 2349977 defendant Bell Thomas husbandman 588614 588614 Bell, Thomas, of Coston, husbandman 1
4976665 2349977 2349977 defendant Gervas John husbandman 588614 588614 Gervas, John, of Coston, husbandman 3
4978130 2350424 2350424 plaintiff Reve Thomas   588614 588614 Reve, Thomas, of Coston 0
5065134 2376105 2376105 defendant Blome John   588614 588614 Blome, John, of Coston, administrators of 0
5260935 2433542 2433542 defendant Alysaunder Robert yeoman 588614 588614 Alysaunder, Robert, of Coston, yeoman 0
5260937 2433543 2433543 defendant Alysaunder Robert yeoman 588614 588614 Alysaunder, Robert, of Coston, yeoman 0
5445427 2488530 2488530 defendant Clynton John husbandman 588614 588614 Clynton, John, of Coston, husbandman 3
5588264 2531332 2531332 defendant Aglande John yeoman 588614 588614 Aglande, John, of Coston, yeoman 1
5597923 2534254 2534254 defendant Horsyngton John husbandman 588614 588614 Horsyngton, John, of Coston, husbandman 0
5597939 2534259 2534259 defendant Horsyngton John husbandman 588614 588614 Horsyngton, John, of Coston, husbandman 0
5597949 2534260 2534260 defendant Horsyngton John husbandman 588614 588614 Horsyngton, John, of Coston, husbandman 4
5598045 2534286 2534286 defendant Horsyngton John husbandman 588614 588614 Horsyngton, John, of Coston, husbandman 4
5625684 2551975 2551975 defendant Beek William ploughman 588614 588614 Beek, William, of Coston, ploughman 2
5625685 2551975 2551975 defendant Drover John yeoman 588614 588614 Drover, John, of Coston, yeoman 3

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