names

53 rows where place_id = 594741

✎ 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
3617395 1873059 1873059 defendant Gedney William husbandman 594741 594741 Gedney, William, of West Barsham, husbandman 0
3656633 1912328 1912328 defendant Gurney Anthony gent 594741 594741 Gurney, Anthony, of West Barsham, gent 0
3698424 1925726 1925726 defendant Higham Robert husbandman 594741 594741 Higham, Robert, of West Barsham, husbandman 4
3702682 1927109 1927109 defendant Geffrey Nicholas laborer 594741 594741 Geffrey, Nicholas, of West Barsham, laborer 0
3706835 1928423 1928423 defendant Mabbys Geoffrey yeoman 594741 594741 Mabbys, Geoffrey, of West Barsham, yeoman 0
3712554 1930240 1930240 defendant Mabbys Geoffrey yeoman 594741 594741 Mabbys, Geoffrey, of West Barsham, yeoman 0
3748598 1941493 1941493 defendant Purbek Robert husbandman 594741 594741 Purbek, Robert, of West Barsham, husbandman 0
3789594 1954573 1954573 defendant Moone Clement warrener 594741 594741 Moone, Clement, of West Barsham, warrener 0
3805725 1959736 1959736 defendant Moone Clement warrener 594741 594741 Moone, Clement, of West Barsham, warrener 0
3864321 1978261 1978261 defendant Hypham Henry husbandman 594741 594741 Hypham, Henry, of West Barsham, husbandman 2
3868944 1979855 1979855 defendant Laundye Adam yeoman 594741 594741 Laundye, Adam, of West Barsham, yeoman 1
3890986 1987247 1987247 defendant Perne Alice widow 594741 594741 Perne, Alice, of West Barsham, widow 1
3890990 1987248 1987248 defendant Perne Alice widow 594741 594741 Perne, Alice, of West Barsham, widow 1
3904429 1991727 1991727 defendant Hogens alias Shropford Robert husbandman 594741 594741 Hogens alias Shropford, Robert, of West Barsham, husbandman 1
3904593 1991787 1991787 plaintiff Hogens alias Shropshyre Robert   594741 594741 Hogens alias Shropshyre, Robert, of West Barsham 0
3913186 1994743 1994743 defendant Froste Giles warrener 594741 594741 Froste, Giles, of West Barsham, warrener 1
3927783 1999630 1999630 defendant Harwarde Thomas gent 594741 594741 Harwarde, Thomas, of West Barsham, gent 2
3935733 2002259 2002259 defendant Frost Giles yeoman 594741 594741 Frost, Giles, of West Barsham, yeoman 2
3937963 2003031 2003031 plaintiff Perne Anne widow 594741 594741 Perne, Anne, of West Barsham, widow 0
3943241 2004759 2004759 defendant Frost Thomas husbandman 594741 594741 Frost, Thomas, of West Barsham, husbandman 0
3950242 2007171 2007171 defendant Froste Thomas yeoman 594741 594741 Froste, Thomas, of West Barsham, yeoman 0
3952425 2007917 2007917 defendant Froste Thomas yeoman 594741 594741 Froste, Thomas, of West Barsham, yeoman 2
3952426 2007917 2007917 defendant Oldman John husbandman 594741 594741 Oldman, John, of West Barsham, husbandman 3
3952466 2007930 2007930 defendant Frost Thomas husbandman 594741 594741 Frost, Thomas, of West Barsham, husbandman 4
3956133 2009217 2009217 defendant Frost Thomas yeoman 594741 594741 Frost, Thomas, of West Barsham, yeoman 0
3968024 2013446 2013446 plaintiff Carpenter Edward (legal representative) 594741 594741 Carpenter, Edward, of West Barsham, executrix of 0
4227500 2105100 2105100 defendant Doddington Leonard gent 594741 594741 Doddington, Leonard, of West Barsham, gent 0
4289891 2126445 2126445 defendant Doddington Leonard gent 594741 594741 Doddington, Leonard, of West Barsham, gent 0
4346250 2145942 2145942 defendant Brett Richard shepherd 594741 594741 Brett Richard, of West Barsham, shepherd 1
4758870 2283124 2283124 defendant Assheby Thomas yeoman 594741 594741 Assheby, Thomas, of West Barsham, yeoman 0
4840469 2308557 2308557 defendant Teyser John yeoman 594741 594741 Teyser, John, of West Barsham, yeoman 4
4943939 2340069 2340069 defendant Galowe Thomas husbandman 594741 594741 Galowe, Thomas, of West Barsham, husbandman 2
4995638 2355534 2355534 defendant Gurney Thomas esq 594741 594741 Gurney, Thomas, of West Barsham, esq 1
4996169 2355710 2355710 plaintiff Gurnay Thomas esq 594741 594741 Gurnay, Thomas, of West Barsham, esq 0
5095860 2385216 2385216 defendant Vyel John husbandman 594741 594741 Vyel, John, of West Barsham, husbandman 1
5107934 2388760 2388760 defendant Vyel John yeoman 594741 594741 Vyel, John, of West Barsham, yeoman 0
5107965 2388769 2388769 defendant Harald Robert husbandman 594741 594741 Harald, Robert, of West Barsham, husbandman 0
5107966 2388769 2388769 defendant Denston Robert laborer 594741 594741 Denston, Robert, of West Barsham, laborer 1
5107967 2388769 2388769 defendant Vyell John husbandman 594741 594741 Vyell, John, of West Barsham, husbandman 2
5249634 2430012 2430012 defendant Harold Robert yeoman 594741 594741 Harold, Robert, of West Barsham, yeoman 0
5249635 2430012 2430012 defendant Walter John husbandman 594741 594741 Walter, John, of West Barsham, husbandman 1
5264148 2434547 2434547 defendant Fox Robert laborer 594741 594741 Fox, Robert, of West Barsham, laborer 0
5264149 2434547 2434547 defendant Fox William laborer 594741 594741 Fox, William, of West Barsham, laborer 1
5302049 2445568 2445568 defendant Lysse John husbandman 594741 594741 Lysse, John, of West Barsham, husbandman 0
5494965 2503390 2503390 defendant Ocle Stephen warrener 594741 594741 Ocle, Stephen, of West Barsham, warrener 8
5495116 2503437 2503437 defendant Quykke John clerk 594741 594741 Quykke, John, of West Barsham, clerk 0
5538688 2516581 2516581 defendant Grene Reginald husbandman 594741 594741 Grene, Reginald, of West Barsham, husbandman 1
5538691 2516582 2516582 defendant Grene Reginald husbandman 594741 594741 Grene, Reginald, of West Barsham, husbandman 1
5553616 2521092 2521092 defendant Godfrey Robert husbandman 594741 594741 Godfrey, Robert, of West Barsham, husbandman 0
5553619 2521093 2521093 defendant Godfrey Robert husbandman 594741 594741 Godfrey, Robert, of West Barsham, husbandman 0
5568296 2525272 2525272 defendant Grene Reginald husbandman 594741 594741 Grene, Reginald, of West Barsham, husbandman 1
5574934 2527241 2527241 defendant Grene Reginald husbandman 594741 594741 Grene, Reginald, of West Barsham, husbandman 1
5614638 2548375 2548375 defendant Pesemey John   594741 594741 Pesemey, John, of West Barsham 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);