names

52 rows where place_id = 596851

✎ 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
3626393 1903112 1903112 defendant Tyler William laborer 596851 596851 Tyler, William, of Falley, laborer 1
3654262 1911593 1911593 defendant Berde William, senior husbandman 596851 596851 Berde, William, senior, of Falley, husbandman 0
3654263 1911593 1911593 defendant Berde William, junior husbandman 596851 596851 Berde, William, junior, of Falley, husbandman 1
3655697 1912043 1912043 defendant Est Henry husbandman 596851 596851 Est, Henry, of Falley, husbandman 1
3697696 1925502 1925502 defendant Berd William turner 596851 596851 Berd, William, of Falley, turner 0
3715138 1931030 1931030 defendant Berde Matilda widow 596851 596851 Berde, Matilda, of Falley, widow 0
3715139 1931030 1931030 defendant Berde John husbandman 596851 596851 Berde, John, of Falley, husbandman 1
3718952 1932207 1932207 defendant Est John husbandman 596851 596851 Est, John, of Falley, husbandman 0
3765842 1946982 1946982 defendant Berd Matilda widow 596851 596851 Berd, Matilda, of Falley, widow 1
3800514 1958084 1958084 defendant Rede Nicholas husbandman 596851 596851 Rede, Nicholas, of Falley, husbandman 0
3819562 1963995 1963995 defendant Grenelane alias Tanner John husbandman 596851 596851 Grenelane alias Tanner, John, of Falley, husbandman 0
4552792 2216821 2216821 plaintiff Foulmere Robert   596851 596851 Foulmere, Robert, of Falley, Winchester diocese, parson & canon of the King's free chapel of St Stephen 4
4609558 2234089 2234089 defendant Forster Richard   596851 596851 Forster, Richard, of Falley 1
4653378 2246993 2246993 defendant Bakere Richard baker 596851 596851 Bakere, Richard, of Falley, baker 0
4726031 2273428 2273428 defendant Bakun William ploughman 596851 596851 Bakun, William, of Falley, ploughman 0
4748248 2279996 2279996 defendant Haper Philip   596851 596851 Haper, Philip, of Falley, parson 1
4767159 2285713 2285713 defendant Haper Philip   596851 596851 Haper, Philip, of Falley, parson 0
4775748 2288411 2288411 defendant Sakevyle Thomas   596851 596851 Sakevyle, Thomas, of Falley, knight 0
4825521 2304026 2304026 defendant atte Slade John husbandman 596851 596851 atte Slade, John, of Falley, husbandman 0
4902388 2327362 2327362 defendant Crokehorn Thomas husbandman 596851 596851 Crokehorn, Thomas, of Falley, husbandman 0
4902389 2327362 2327362 defendant Broun John husbandman 596851 596851 Broun, John, of Falley, husbandman 1
4961548 2345418 2345418 defendant Hammes John husbandman 596851 596851 Hammes, John, of Falley, husbandman 0
5034656 2366994 2366994 defendant Briton Nicholas husbandman 596851 596851 Briton, Nicholas, of Falley, husbandman 0
5070901 2377792 2377792 defendant Gouller John husbandman 596851 596851 Gouller, John, of Falley, husbandman 0
5096801 2385494 2385494 defendant Erlesman John gent 596851 596851 Erlesman, John, of Falley, gent 0
5120903 2392544 2392544 defendant Style John, senior husbandman 596851 596851 Style, John, senior, of Falley, husbandman 0
5120904 2392544 2392544 defendant Style Robert husbandman 596851 596851 Style, Robert, of Falley, husbandman 1
5120905 2392544 2392544 defendant Style Henry husbandman 596851 596851 Style, Henry, of Falley, husbandman 2
5120915 2392547 2392547 plaintiff Studye John   596851 596851 Studye, John, of Falley 0
5140320 2398275 2398275 defendant Style John   596851 596851 Style, John, of Falley 0
5150589 2401316 2401316 defendant Rede Peter butcher 596851 596851 Rede, Peter, of Falley, butcher 0
5169046 2406679 2406679 defendant Rede Peter butcher 596851 596851 Rede, Peter, of Falley, butcher 0
5175837 2408616 2408616 defendant Style John husbandman 596851 596851 Style, John, of Falley, husbandman 0
5185484 2411503 2411503 defendant Rede Peter butcher 596851 596851 Rede, Peter, of Falley, butcher 0
5199355 2415561 2415561 defendant Scote Bartholomew smith 596851 596851 Scote, Bartholomew, of Falley, smith 1
5211098 2418973 2418973 defendant Scote Bartholomew smith 596851 596851 Scote, Bartholomew, of Falley, smith 1
5222972 2422436 2422436 defendant Ryman Henry yeoman 596851 596851 Ryman, Henry, of Falley, yeoman 0
5243917 2428412 2428412 defendant Moulder Richard husbandman 596851 596851 Moulder, Richard, of Falley, husbandman 0
5244926 2428689 2428689 plaintiff Pratt Joan   596851 596851 Pratt, Joan, of Falley, widow of Pratt, John, of Falley 0
5244929 2428690 2428690 plaintiff Pratt Joan   596851 596851 Pratt, Joan, of Falley, widow of Pratt, John, of Falley 0
5354513 2461486 2461486 defendant Cokkys John, junior yeoman 596851 596851 Cokkys, John, junior, of Falley, yeoman 0
5376300 2468182 2468182 defendant Wylte Richard husbandman 596851 596851 Wylte, Richard, of Falley, husbandman 1
5540814 2517258 2517258 defendant Rokes Thomas, senior gent 596851 596851 Rokes, Thomas, senior, of Falley, gent 0
5540817 2517259 2517259 defendant Rokes Thomas, senior gent 596851 596851 Rokes, Thomas, senior, of Falley, gent 0
5545740 2518744 2518744 defendant Rede Robert husbandman 596851 596851 (Rede, Robert, of Falley, husbandman 1
5562108 2523515 2523515 defendant Rokes Thomas gent 596851 596851 Rokes, Thomas, of Falley, gent 0
5565941 2524641 2524641 defendant Mowne John boatman 596851 596851 Mowne, John, of Falley, boatman 2
5565945 2524642 2524642 defendant Mowne John boatman 596851 596851 Mowne, John, of Falley, boatman 2
5607417 2537214 2537214 defendant A Dene Thomas husbandman 596851 596851 A Dene, Thomas, of Falley, husbandman 0
5607418 2537214 2537214 defendant Bannester Ralph yeoman 596851 596851 Bannester, Ralph, of Falley, yeoman 1
5607419 2537214 2537214 defendant Rokes Thomas esq 596851 596851 Rokes, Thomas, of Falley, esq 2
5609446 2537850 2537850 defendant Wyllams Richard hubandman 596851 596851 Wyllams, Richard, of Falley, hubandman 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);