names

31 rows where place_id = 614892

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3706128 1928210 1928210 defendant Vassell Thomas, senior laborer 614892 614892 Vassell, Thomas, senior, of Gosbertowne, laborer 0
3714716 1930902 1930902 defendant Fraunces John   614892 614892 Fraunces, John, of Gosbertowne, salt weller 2
3720423 1932668 1932668 defendant Hogeson William yeoman 614892 614892 Hogeson, William, of Gosbertowne, yeoman 0
3802117 1958556 1958556 defendant Tyrryngton Thomas husbandman 614892 614892 Tyrryngton, Thomas, of Gosbertowne, husbandman 0
3802118 1958556 1958556 defendant Humpe Robert laborer 614892 614892 Humpe, Robert, of Gosbertowne, laborer 1
3850955 1973889 1973889 defendant Kendall William smith 614892 614892 Kendall, William, of Gosbertowne, smith 3
3931712 2000907 2000907 defendant Surflet John yeoman 614892 614892 Surflet, John, of Gosbertowne, yeoman 0
4034353 2036959 2036959 plaintiff Harebrowne Thomas gent 614892 614892 Harebrowne, Thomas, of Gosbertowne, gent 0
4034355 2036960 2036960 plaintiff Harebrowne Thomas gent 614892 614892 Harebrowne, Thomas, of Gosbertowne, gent 0
4058081 2045271 2045271 defendant Deathe John yeoman 614892 614892 Deathe, John, of Gosbertowne, yeoman 0
4121348 2067931 2067931 defendant Deathe Roger gent 614892 614892 Deathe, Roger, of Gosbertowne, gent 1
4139417 2074459 2074459 defendant Yong Thomas husbandman 614892 614892 Yong, Thomas, of Gosbertowne, husbandman 1
4171837 2085609 2085609 defendant Brigges Thomas thatcher 614892 614892 Brigges, Thomas, of Gosbertowne, thatcher 0
4187368 2091083 2091083 defendant Yonge Thomas husbandman 614892 614892 Yonge, Thomas, of Gosbertowne, husbandman 0
4231684 2106581 2106581 defendant Jacklyng Richard yeoman 614892 614892 Jacklyng, Richard, of Gosbertowne, yeoman 3
4234965 2107780 2107780 defendant Orton Marmaduke yeoman 614892 614892 Orton, Marmaduke, of Gosbertowne, yeoman 1
4236089 2108192 2108192 defendant Dobledaye Mathew husbandman 614892 614892 Dobledaye, Mathew, of Gosbertowne, husbandman 0
4236090 2108192 2108192 defendant Reade Lawrence husbandman 614892 614892 Reade, Lawrence, of Gosbertowne, husbandman 1
4236998 2108521 2108521 defendant Parkyns Robert yeoman 614892 614892 Parkyns, Robert, of Gosbertowne, yeoman 0
4260424 2116452 2116452 defendant Death Roger gent 614892 614892 Death, Roger, of Gosbertowne, gent 0
4275555 2121391 2121391 defendant Death Roger gent 614892 614892 Death, Roger, of Gosbertowne, gent 0
4275556 2121391 2121391 defendant Fowler Robert husbandman 614892 614892 Fowler, Robert, of Gosbertowne, husbandman 1
4275557 2121391 2121391 defendant Dawson Richard husbandman 614892 614892 Dawson, Richard, of Gosbertowne, husbandman 2
4350240 2147345 2147345 defendant Parkyn Robert yeoman 614892 614892 Parkyn, Robert, of Gosbertowne, yeoman 0
4362400 2151603 2151603 defendant Cawood Edward gent 614892 614892 Cawood, Edward, of Gosbertowne, gent 3
4378248 2157287 2157287 defendant Deathe Roger gent 614892 614892 Deathe, Roger, of Gosbertowne, gent 0
5594527 2533269 2533269 defendant Honyngham John, junior yeoman 614892 614892 Honyngham, John, junior, of Gosbertowne, yeoman 2
5594528 2533269 2533269 defendant Lenman Richard husbandman 614892 614892 Lenman, Richard, of Gosbertowne, husbandman 3
5594529 2533269 2533269 defendant Haltoft Robert laborer 614892 614892 Haltoft, Robert, of Gosbertowne, laborer 4
5594530 2533269 2533269 defendant Danyell John weaver 614892 614892 Danyell, John, of Gosbertowne, weaver 5
5594531 2533269 2533269 defendant Cotes George weaver 614892 614892 Cotes, George, of Gosbertowne, weaver 6

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