names

44 rows where place_id = 587164

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590638 1864714 1864714 defendant Gay John yeoman 587164 587164 Gay, John, of Magna Modbury, yeoman 2
3590639 1864714 1864714 defendant Hunt John yeoman 587164 587164 Hunt, John, of Magna Modbury, yeoman 3
3594934 1866043 1866043 defendant Forde Thomas   587164 587164 Forde, Thomas, of Magna Modbury, franklin 0
3599838 1867598 1867598 defendant Forde John yeoman 587164 587164 Forde, John, of Magna Modbury, yeoman 0
3599839 1867598 1867598 defendant Forde Robert yeoman 587164 587164 Forde, Robert, of Magna Modbury, yeoman 1
3599840 1867598 1867598 defendant Cheseman John yeoman 587164 587164 Cheseman, John, of Magna Modbury, yeoman 2
3599842 1867599 1867599 defendant Forde Thomas yeoman 587164 587164 Forde, Thomas, of Magna Modbury, yeoman 0
3611751 1871339 1871339 defendant Ryche William yeoman 587164 587164 Ryche, William, of Magna Modbury, yeoman 0
3611752 1871339 1871339 defendant Roper Peter laborer 587164 587164 Roper, Peter, of Magna Modbury, laborer 1
3752859 1942817 1942817 defendant Ford Thomas carver 587164 587164 Ford, Thomas, of Magna Modbury, carver 0
3821525 1964628 1964628 defendant Hert John husbandman 587164 587164 Hert, John, of Magna Modbury, husbandman 0
4944615 2340299 2340299 defendant Stevyn William husbandman 587164 587164 Stevyn, William, of Magna Modbury, husbandman 0
4953063 2342884 2342884 defendant Dobbe Thomas husbandman 587164 587164 Dobbe, Thomas, of Magna Modbury, husbandman 0
4962915 2345823 2345823 defendant Stenelake John brewer 587164 587164 Stenelake, John, of Magna Modbury, brewer 0
4965191 2346516 2346516 defendant Sturte William tailor 587164 587164 Sturte, William, of Magna Modbury, tailor 1
4965193 2346516 2346516 defendant Sturte John husbandman 587164 587164 Sturte, John, of Magna Modbury, husbandman 3
4971126 2348304 2348304 defendant Shuter John yeoman 587164 587164 Shuter, John, of Magna Modbury, yeoman 4
4974012 2349189 2349189 defendant Trumpyngdon John gent 587164 587164 Trumpyngdon, John, of Magna Modbury, gent 1
5016204 2361624 2361624 defendant Baker Thomas clerk 587164 587164 Baker, Thomas, of Magna Modbury, clerk 0
5016205 2361624 2361624 defendant Reynell or Reyvell William husbandman 587164 587164 Reynell or Reyvell, William, of Magna Modbury, husbandman 1
5056668 2373566 2373566 defendant Rous John   587164 587164 Rous, John, of Magna Modbury, franklin 0
5060450 2374703 2374703 defendant Hayward Hugh chaplain 587164 587164 Hayward, Hugh, of Magna Modbury, chaplain 3
5068801 2377165 2377165 defendant Stephyn William husbandman 587164 587164 Stephyn, William, of Magna Modbury, husbandman 0
5074132 2378750 2378750 defendant Coyte John carpenter 587164 587164 Coyte, John, of Magna Modbury, carpenter 1
5079845 2380448 2380448 defendant Attrewyn William   587164 587164 Attrewyn, William, of Magna Modbury, franklin 0
5215915 2420384 2420384 defendant Ryvell or Rynell William husbandman 587164 587164 Ryvell or Rynell, William, of Magna Modbury, husbandman 0
5225783 2423212 2423212 defendant Moryng John, junior husbandman 587164 587164 Moryng, John, junior, of Magna Modbury, husbandman 0
5226532 2423424 2423424 defendant Champernon Hugh gent 587164 587164 Champernon, Hugh, of Magna Modbury, gent 0
5229102 2424119 2424119 defendant Webber John husbandman 587164 587164 Webber, John, of Magna Modbury, husbandman 0
5233398 2425358 2425358 defendant Mewy John tailor 587164 587164 Mewy, John, of Magna Modbury, tailor 4
5260109 2433284 2433284 defendant Scoos John husbandman 587164 587164 Scoos, John, of Magna Modbury, husbandman 2
5283024 2440095 2440095 defendant Lineger Thomas merchant 587164 587164 Lineger, Thomas, of Magna Modbury, merchant 0
5324062 2452284 2452284 defendant Yeme John yeoman 587164 587164 Yeme, John, of Magna Modbury, yeoman 1
5327216 2453212 2453212 defendant Coke alias Panter John yeoman 587164 587164 Coke alias Panter, John, of Magna Modbury, yeoman 0
5327217 2453212 2453212 defendant Hervy Thomas yeoman 587164 587164 Hervy, Thomas, of Magna Modbury, yeoman 1
5348411 2459647 2459647 defendant Tolke Robert husbandman 587164 587164 Tolke, Robert, of Magna Modbury, husbandman 2
5480704 2499191 2499191 defendant Coyte Hugh husbandman 587164 587164 Coyte, Hugh, of Magna Modbury, husbandman 0
5509173 2507727 2507727 defendant Veysy Thomas husbandman 587164 587164 Veysy, Thomas, of Magna Modbury, husbandman 2
5513642 2509115 2509115 defendant Dert Hugh husbandman 587164 587164 Dert, Hugh, of Magna Modbury, husbandman 0
5544879 2518504 2518504 defendant Andrewe William husbandman 587164 587164 Andrewe, William, of Magna Modbury, husbandman 1
5565761 2524579 2524579 defendant Hawell John yeoman 587164 587164 Hawell, John, of Magna Modbury, yeoman 3
5583254 2529837 2529837 defendant Dener or Dever John butcher 587164 587164 Dener or Dever, John, of Magna Modbury, butcher 0
5583255 2529837 2529837 defendant Dener or Dever Henry butcher 587164 587164 Dener or Dever, Henry, of Magna Modbury, butcher 1
5592177 2532548 2532548 defendant Howell John yeoman 587164 587164 Howell, John, of Magna Modbury, yeoman 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);