names

35 rows where place_id = 611914

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3690670 1923246 1923246 defendant Maplede Thomas yeoman 611914 611914 Maplede, Thomas, of Sprowston, yeoman 0
3690674 1923247 1923247 defendant Maplod Thomas yeoman 611914 611914 Maplod, Thomas, of Sprowston, yeoman 0
3702501 1927048 1927048 defendant Mapled Thomas yeoman 611914 611914 Mapled, Thomas, of Sprowston, yeoman 0
3812305 1961743 1961743 defendant Tayllour Andrew yeoman 611914 611914 Tayllour, Andrew, of Sprowston, yeoman 1
3812322 1961747 1961747 defendant Taillour Andrew yeoman 611914 611914 Taillour, Andrew, of Sprowston, yeoman 0
3814473 1962441 1962441 defendant Jermy John esq 611914 611914 Jermy, John, of Sprowston, esq 0
3842965 1971336 1971336 defendant Jermy John   611914 611914 Jermy, John, of Sprowston, knight 0
3870544 1980387 1980387 defendant Corbet alias Corbowe John, senior gent 611914 611914 Corbet alias Corbowe, John, senior, of Sprowston, gent 0
3899407 1990017 1990017 defendant Skott John, senior   611914 611914 Skott, John, senior, of Sprowston, worsted weaver 0
3903439 1991377 1991377 defendant Heynes John smith 611914 611914 Heynes, John, of Sprowston, smith 0
3910734 1993908 1993908 defendant Skotte Robert   611914 611914 Skotte, Robert, of Sprowston, wool chapman 0
3955989 2009165 2009165 defendant Golslyn Nicholas husbandman 611914 611914 Golslyn, Nicholas, of Sprowston, husbandman 1
3995278 2023050 2023050 defendant Newman Robert   611914 611914 Newman, Robert, of Sprowston, shepherd 2
4007350 2027410 2027410 plaintiff Mannyng Maud (legal representative) 611914 611914 Mannyng, Maud, of Sprowston, widow, executor of 0
4007358 2027412 2027412 plaintiff Mannyng Robert husbandman 611914 611914 Mannyng, Robert, of Sprowston, husbandman 0
4031765 2036021 2036021 plaintiff Fox Henry   611914 611914 Fox, Henry, of Sprowston 0
4048517 2041921 2041921 defendant Walgrave Kenelm thatcher 611914 611914 Walgrave, Kenelm, of Sprowston, thatcher 3
4115021 2065662 2065662 defendant Adams Thomas husbandman 611914 611914 Adams, Thomas, of Sprowston, husbandman 0
4115026 2065663 2065663 defendant Adams Thomas husbandman 611914 611914 Adams, Thomas, of Sprowston, husbandman 1
4139581 2074518 2074518 defendant Mannyng Robert yeoman 611914 611914 Mannyng, Robert, of Sprowston, yeoman 0
4177160 2087484 2087484 defendant Sander Philip husbandman 611914 611914 Sander, Philip, of Sprowston, husbandman 2
4187529 2091137 2091137 defendant Saunders Philip yeoman 611914 611914 Saunders, Philip, of Sprowston, yeoman 3
4200317 2095665 2095665 defendant Sander Phhilip husbandman 611914 611914 Sander, Phhilip, of Sprowston, husbandman 2
4221778 2103114 2103114 defendant Funnell Richard husbandman 611914 611914 Funnell, Richard, of Sprowston, husbandman 0
4260900 2116610 2116610 defendant Funell Richard husbandman 611914 611914 Funell, Richard, of Sprowston, husbandman 3
4345872 2145820 2145820 defendant Bacon Thomas blacksmith 611914 611914 Bacon, Thomas, of Sprowston, blacksmith 0
4345873 2145820 2145820 defendant Stere William husbandman 611914 611914 Stere, William, of Sprowston, husbandman 1
4345874 2145820 2145820 defendant Clarke William carpenter 611914 611914 Clarke, William, of Sprowston, carpenter 2
5141903 2398752 2398752 plaintiff Waryns William   611914 611914 Waryns, William, of Sprowston 0
5162972 2404899 2404899 plaintiff Waryns William   611914 611914 Waryns, William, of Sprowston 0
5541799 2517548 2517548 defendant Warnes William, senior husbandman 611914 611914 Warnes, William, senior, of Sprowston, husbandman 1
5565254 2524424 2524424 plaintiff Bryde Hugh husbandman 611914 611914 Bryde, Hugh, of Sprowston, husbandman 0
5565255 2524424 2524424 plaintiff Chopyng John husbandman 611914 611914 Chopyng, John, of Sprowston, husbandman 1
5565583 2524526 2524526 plaintiff Byrde   husbandman 611914 611914 Byrde, , of Sprowston, husbandman 0
5565584 2524526 2524526 plaintiff Chopyng John husbandman 611914 611914 Chopyng, John, of Sprowston, husbandman 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);