names

89 rows where place_id = 587858

✎ 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
3592634 1865309 1865309 defendant Wace William husbandman 587858 587858 Wace, William, of Yaxley, husbandman 0
3592635 1865309 1865309 defendant Sherman John husbandman 587858 587858 Sherman, John, of Yaxley, husbandman 1
3643073 1908275 1908275 defendant Dowve Richard butcher 587858 587858 Dowve, Richard, of Yaxley, butcher 0
3643074 1908275 1908275 defendant Clopwell John husbandman 587858 587858 Clopwell, John, of Yaxley, husbandman 1
3643075 1908275 1908275 defendant Clopwell Thomas husbandman 587858 587858 Clopwell, Thomas, of Yaxley, husbandman 2
3643076 1908275 1908275 defendant Bitregge Richard husbandman 587858 587858 Bitregge, Richard, of Yaxley, husbandman 3
3643078 1908276 1908276 defendant Northfolke Thomas fisher 587858 587858 Northfolke, Thomas, of Yaxley, fisher 0
3647956 1909759 1909759 defendant Abery William baker 587858 587858 Abery, William, of Yaxley, baker 1
3663256 1914433 1914433 defendant Fryston John yeoman 587858 587858 Fryston, John, of Yaxley, yeoman 0
3680266 1919900 1919900 defendant Freston John husbandman 587858 587858 Freston, John, of Yaxley, husbandman 2
3682631 1920676 1920676 defendant Cornwell Robert husbandman 587858 587858 Cornwell, Robert, of Yaxley, husbandman 0
3710449 1929586 1929586 defendant Wrenne Margaret widow 587858 587858 Wrenne, Margaret, of Yaxley, widow 0
3710450 1929586 1929586 defendant Wrenne Katherine spinster 587858 587858 Wrenne, Katherine, of Yaxley, spinster 1
3716980 1931598 1931598 defendant Cony William yeoman 587858 587858 Cony, William, of Yaxley, yeoman 0
3716981 1931598 1931598 defendant Skeggys Robert yeoman 587858 587858 Skeggys, Robert, of Yaxley, yeoman 1
3716982 1931598 1931598 defendant Peerson Nicholas, senior yeoman 587858 587858 Peerson, Nicholas, senior, of Yaxley, yeoman 2
3716983 1931598 1931598 defendant Freston John fisher 587858 587858 Freston, John, of Yaxley, fisher 3
3716984 1931598 1931598 defendant Peerson Nicholas, junior fisher 587858 587858 Peerson, Nicholas, junior, of Yaxley, fisher 4
3716985 1931598 1931598 defendant Freston Thomas fisher 587858 587858 Freston, Thomas, of Yaxley, fisher 5
3716986 1931598 1931598 defendant Carter Thomas fisher 587858 587858 Carter, Thomas, of Yaxley, fisher 6
3716987 1931598 1931598 defendant Norffolk Thomas fisher 587858 587858 Norffolk, Thomas, of Yaxley, fisher 7
3716988 1931598 1931598 defendant Bysshop Thomas fisher 587858 587858 Bysshop, Thomas, of Yaxley, fisher 8
3716989 1931598 1931598 defendant Pylton John fisher 587858 587858 Pylton, John, of Yaxley, fisher 9
3732192 1936304 1936304 defendant Fryston William haberdasher 587858 587858 Fryston, William, of Yaxley, haberdasher 0
3744744 1940252 1940252 defendant Mannyng Richard husbandman 587858 587858 Mannyng, Richard, of Yaxley, husbandman 0
3744746 1940253 1940253 defendant Mannyng Richard husbandman 587858 587858 Mannyng, Richard, of Yaxley, husbandman 0
3744748 1940254 1940254 defendant Warde Geoffrey husbandman 587858 587858 Warde, Geoffrey, of Yaxley, husbandman 0
3744750 1940255 1940255 defendant Warde Geoffrey husbandman 587858 587858 Warde, Geoffrey, of Yaxley, husbandman 0
3761853 1945716 1945716 plaintiff Foster Adam   587858 587858 Foster, Adam, of Yaxley 0
3765693 1946935 1946935 defendant Bytham Alice spinster 587858 587858 Bytham, Alice, of Yaxley, spinster 0
3770337 1948395 1948395 defendant Wrenne Thomas husbandman 587858 587858 Wrenne, Thomas, of Yaxley, husbandman 0
3770338 1948395 1948395 defendant Wrenne Margaret widow 587858 587858 Wrenne, Margaret, of Yaxley, widow 1
3772065 1948954 1948954 plaintiff Trype John husbandman 587858 587858 Trype, John, of Yaxley, husbandman 0
3783724 1952673 1952673 defendant Bytham Alice singlewoman 587858 587858 Bytham, Alice, of Yaxley, singlewoman 0
3787208 1953791 1953791 defendant Tryppe John, junior husbandman 587858 587858 Tryppe, John, junior, of Yaxley, husbandman 0
3794883 1956267 1956267 defendant Cony William yeoman 587858 587858 Cony, William, of Yaxley, yeoman 1
3798166 1957322 1957322 defendant Gullyn John shoemaker 587858 587858 Gullyn, John, of Yaxley, shoemaker 0
3803503 1959001 1959001 defendant Tryppe John, junior husbandman 587858 587858 Tryppe, John, junior, of Yaxley, husbandman 0
3803505 1959002 1959002 defendant Tryppe John, junior husbandman 587858 587858 Tryppe, John, junior, of Yaxley, husbandman 0
3832194 1967981 1967981 defendant Gyssyng John butcher 587858 587858 Gyssyng, John, of Yaxley, butcher 0
3832195 1967981 1967981 defendant Tryppe John husbandman 587858 587858 Tryppe, John, of Yaxley, husbandman 1
3832196 1967981 1967981 defendant Wrooe Robert husbandman 587858 587858 Wrooe, Robert, of Yaxley, husbandman 2
3867909 1979499 1979499 defendant Chowyne Robert laborer 587858 587858 Chowyne, Robert, of Yaxley, laborer 0
3867910 1979499 1979499 defendant Thryston Thomas fisher 587858 587858 Thryston, Thomas, of Yaxley, fisher 1
3887376 1986042 1986042 defendant Cornewell Robert yeoman 587858 587858 Cornewell, Robert, of Yaxley, yeoman 0
3887441 1986064 1986064 plaintiff Cornewell Robert yeoman 587858 587858 Cornewell, Robert, of Yaxley, yeoman 0
3902756 1991152 1991152 defendant Felgate John (legal representative) 587858 587858 Felgate, John, of Yaxley, gent, executors of 0
3903748 1991487 1991487 defendant Sherman Thomas gent 587858 587858 Sherman, Thomas, of Yaxley, gent 0
3903750 1991488 1991488 defendant Sherman Thomas gent 587858 587858 Sherman, Thomas, of Yaxley, gent 0
3909295 1993403 1993403 defendant Felgate John (legal representative) 587858 587858 Felgate, John, of Yaxley, gent, executors of 0
3930439 2000527 2000527 defendant Praty Robert laborer 587858 587858 Praty, Robert, of Yaxley, laborer 1
3930442 2000528 2000528 defendant Praty Robert laborer 587858 587858 Praty, Robert, of Yaxley, laborer 1
3947754 2006279 2006279 plaintiff Cony William gent 587858 587858 Cony, William, of Yaxley, gent 0
3947769 2006284 2006284 plaintiff Caryer Richard yeoman 587858 587858 Caryer, Richard, of Yaxley, yeoman 1
3947776 2006287 2006287 plaintiff Conye William   587858 587858 Conye, William, of Yaxley 0
3947777 2006287 2006287 defendant Stoddarde Thomas gent 587858 587858 Stoddarde, Thomas, of Yaxley, gent 0
4010361 2028472 2028472 defendant Farmer Richard husbandman 587858 587858 Farmer, Richard, of Yaxley, husbandman 0
4026525 2034138 2034138 defendant Howlet Henry yeoman 587858 587858 Howlet, Henry, of Yaxley, yeoman 0
4044870 2040617 2040617 plaintiff Rogers Christian widow 587858 587858 Rogers, Christian, of Yaxley, widow 0
4044872 2040618 2040618 plaintiff Rogers Christian widow 587858 587858 Rogers, Christian, of Yaxley, widow 0
4046149 2041061 2041061 defendant Annable William husbandman 587858 587858 Annable, William, of Yaxley, husbandman 0
4111131 2064236 2064236 defendant Ulfe Edmund yeoman 587858 587858 Ulfe, Edmund, of Yaxley, yeoman 0
4133807 2072426 2072426 defendant Polley Giles clerk 587858 587858 Polley, Giles, of Yaxley, clerk 0
4181721 2089088 2089088 defendant Poley Giles clerk 587858 587858 Poley, Giles, of Yaxley, clerk 0
4198567 2095054 2095054 defendant Poley Giles clerk 587858 587858 Poley, Giles, of Yaxley, clerk 0
4198568 2095054 2095054 defendant George Walter husbandman 587858 587858 George, Walter, of Yaxley, husbandman 1
4207487 2098174 2098174 defendant Poley Giles clerk 587858 587858 Poley, Giles, of Yaxley, clerk 0
4211404 2099542 2099542 defendant Colborn John husbandman 587858 587858 Colborn, John, of Yaxley, husbandman 3
4240897 2109941 2109941 defendant Knype Richard cooper 587858 587858 Knype, Richard, of Yaxley, cooper 3
4240901 2109943 2109943 defendant Cuttinge William yeoman 587858 587858 Cuttinge, William, of Yaxley, yeoman 0
4240905 2109944 2109944 defendant Cuttinge William yeoman 587858 587858 Cuttinge, William, of Yaxley, yeoman 1
4264033 2117625 2117625 defendant Knype Richard cooper 587858 587858 Knype, Richard, of Yaxley, cooper 3
4302856 2131122 2131122 defendant Cuttinge William gent 587858 587858 Cuttinge, William, of Yaxley, gent 0
4328189 2139744 2139744 defendant Felgate Robert gent 587858 587858 Felgate, Robert, of Yaxley, gent 0
4342297 2144584 2144584 defendant Kempe James carpenter 587858 587858 Kempe, James, of Yaxley, carpenter 2
4355595 2149181 2149181 defendant Rushe George husbandman 587858 587858 Rushe, George, of Yaxley, husbandman 0
4387248 2160382 2160382 defendant Lucas John cordainer 587858 587858 Lucas, John, of Yaxley, cordainer 2
4409381 2167733 2167733 defendant Rushe George husbandman 587858 587858 Rushe, George, of Yaxley, husbandman 0
4701790 2265959 2265959 defendant Peek John yeoman 587858 587858 Peek, John, of Yaxley, yeoman 0
5048057 2371042 2371042 defendant Clement William yeoman 587858 587858 Clement, William, of Yaxley, yeoman 1
5152403 2401835 2401835 plaintiff Herberd Richard   587858 587858 Herberd, Richard, of Yaxley 0
5492638 2502711 2502711 defendant Broun Thomas husbandman 587858 587858 Broun, Thomas, of Yaxley, husbandman 2
5500287 2505035 2505035 defendant Wace William yeoman 587858 587858 Wace, William, of Yaxley, yeoman 0
5507287 2507176 2507176 defendant Wace William husbandman 587858 587858 Wace, William, of Yaxley, husbandman 0
5510946 2508262 2508262 defendant Wace William yeoman 587858 587858 Wace, William, of Yaxley, yeoman 3
5589383 2531679 2531679 defendant Wrenne Robert (legal representative) 587858 587858 Wrenne, Robert, of Yaxley, yeoman, executors of 0
5597140 2534012 2534012 defendant Norfolk Thomas yeoman 587858 587858 Norfolk, Thomas, of Yaxley, yeoman 0
5597142 2534013 2534013 defendant Norfolk Thomas yeoman 587858 587858 Norfolk, Thomas, of Yaxley, yeoman 0
5597144 2534014 2534014 defendant Norfolk Thomas yeoman 587858 587858 Norfolk, Thomas, of Yaxley, yeoman 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);