names

41 rows where place_id = 633421

✎ 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
3812637 1961841 1961841 defendant Yong John butcher 633421 633421 Yong, John, of Marten, butcher 1
3870127 1980253 1980253 defendant Brynneston William yeoman 633421 633421 Brynneston, William, of Marten, yeoman 0
3870509 1980375 1980375 defendant Brynneston William yeoman 633421 633421 Brynneston, William, of Marten, yeoman 0
3870510 1980375 1980375 defendant Poore Walter husbandman 633421 633421 Poore, Walter, of Marten, husbandman 1
3870511 1980375 1980375 defendant Sweteapple John husbandman 633421 633421 Sweteapple, John, of Marten, husbandman 2
3870512 1980375 1980375 defendant Thorne alias Bocher Richard husbandman 633421 633421 Thorne alias Bocher, Richard, of Marten, husbandman 3
3870513 1980375 1980375 defendant Laneham William yeoman 633421 633421 Laneham, William, of Marten, yeoman 4
3870514 1980375 1980375 defendant Brynneston Nicholas yeoman 633421 633421 Brynneston, Nicholas, of Marten, yeoman 5
3877474 1982702 1982702 plaintiff Horsey John esq 633421 633421 Horsey, John, of Marten, esq 0
3890512 1987086 1987086 plaintiff Horsey John esq 633421 633421 Horsey, John, of Marten, esq 0
3895673 1988755 1988755 defendant Hodwall Philip husbandman 633421 633421 Hodwall, Philip, of Marten, husbandman 1
3899766 1990136 1990136 defendant Howse John laborer 633421 633421 Howse, John, of Marten, laborer 4
3899775 1990138 1990138 defendant Appowell Robert laborer 633421 633421 Appowell, Robert, of Marten, laborer 1
3899777 1990138 1990138 defendant Clayden John laborer 633421 633421 Clayden, John, of Marten, laborer 3
3899778 1990138 1990138 defendant More John laborer 633421 633421 More, John, of Marten, laborer 4
3899779 1990138 1990138 defendant Bremson William laborer 633421 633421 Bremson, William, of Marten, laborer 5
3958953 2010213 2010213 defendant Horsey William esq 633421 633421 Horsey, William, of Marten, esq 0
4019750 2031795 2031795 defendant Parnacote or Parvacote Walter husbandman 633421 633421 Parnacote or Parvacote, Walter, of Marten, husbandman 1
4024597 2033475 2033475 defendant Smoerset John yeoman 633421 633421 Smoerset, John, of Marten, yeoman 0
4024599 2033476 2033476 defendant Somersett John yeoman 633421 633421 Somersett, John, of Marten, yeoman 0
4027320 2034420 2034420 defendant Gouldup Nicholas   633421 633421 Gouldup, Nicholas, of Marten, shepherd 1
4052868 2043461 2043461 defendant Manfild John husbandman 633421 633421 Manfild, John, of Marten, husbandman 0
4063304 2047167 2047167 defendant George John husbandman 633421 633421 George, John, of Marten, husbandman 0
4063503 2047234 2047234 defendant Coker henry yeoman 633421 633421 Coker, henry, of Marten, yeoman 0
4078395 2052567 2052567 defendant Gyttyns Edmund gent 633421 633421 Gyttyns, Edmund, of Marten, gent 0
4143377 2075847 2075847 defendant Gilbert John gent 633421 633421 Gilbert, John, of Marten, gent 1
4146323 2076862 2076862 defendant Goldoppe Nicholas   633421 633421 Goldoppe, Nicholas, of Marten, shepherd 0
4174513 2086553 2086553 defendant Gylbert Bartholomew gent 633421 633421 Gylbert, Bartholomew, of Marten, or of Rockborne, Hants, gent 1
4212886 2100038 2100038 defendant Kympson William yeoman 633421 633421 Kympson, William, of Marten, yeoman 1
4217718 2101686 2101686 defendant Bastard Robert innholder 633421 633421 Bastard, Robert, of Marten, innholder 2
4231958 2106677 2106677 defendant Prince Thomas husbandman 633421 633421 Prince, Thomas, of Marten, husbandman 0
4260303 2116411 2116411 defendant Canham Robert husbandman 633421 633421 Canham, Robert, of Marten, husbandman 0
4282634 2123829 2123829 defendant Morton Anthony esq 633421 633421 Morton, Anthony, of Marten, esq 0
4299288 2129842 2129842 defendant Rossyter John gent 633421 633421 Rossyter, John, of Marten, gent 0
4314513 2135186 2135186 defendant Gibson Isaac gent 633421 633421 Gibson, Isaac, of Marten, gent 2
4319100 2136798 2136798 defendant Harrys John husbandman 633421 633421 Harrys, John, of Marten, husbandman 0
4319101 2136798 2136798 defendant Storke John, senior   633421 633421 Storke, John, senior, of Marten yeoman 1
4362631 2151693 2151693 defendant Evoread or Evored Aaron tailor 633421 633421 Evoread or Evored, Aaron, of Marten, tailor 0
4362632 2151693 2151693 defendant Harris John yeoman 633421 633421 Harris, John, of Marten, yeoman 1
5529171 2513636 2513636 defendant Galewey William smith 633421 633421 Galewey, William, of Marten, smith 0
5555865 2521709 2521709 defendant Bellers Christopher yeoman 633421 633421 Bellers, Christopher, of Marten, 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);