names

45 rows where place_id = 666929

✎ 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
3983004 2018697 2018697 defendant Norwood Roger yeoman 666929 666929 Norwood, Roger, of Torrington Magna, yeoman 1
3987968 2020444 2020444 plaintiff Allen Jerome husbandman 666929 666929 Allen, Jerome, of Torrington Magna, husbandman 0
3987969 2020444 2020444 defendant Hutchyn Thomas fuller 666929 666929 Hutchyn, Thomas, of Torrington Magna, fuller 0
3987970 2020445 2020445 plaintiff Allen Jerome husbandman 666929 666929 Allen, Jerome, of Torrington Magna, husbandman 0
3987971 2020445 2020445 defendant Vysycke Richard merchant 666929 666929 Vysycke, Richard, of Torrington Magna, merchant 0
3995134 2023008 2023008 plaintiff Cornell William merchant 666929 666929 Cornell, William, of Torrington Magna, merchant 0
4006521 2027112 2027112 plaintiff Leye William merchant 666929 666929 Leye, William, of Torrington Magna, merchant 0
4019434 2031683 2031683 defendant Norwood Roger yeoman 666929 666929 Norwood, Roger, of Torrington Magna, yeoman 0
4020613 2032101 2032101 defendant Cantell William husbandman 666929 666929 Cantell, William, of Torrington Magna, husbandman 1
4020614 2032101 2032101 defendant Cantell Richard   666929 666929 Cantell, Richard, of Torrington Magna, groom 2
4026876 2034263 2034263 defendant Norwood Roger husbandman 666929 666929 Norwood, Roger, of Torrington Magna, husbandman 0
4026877 2034263 2034263 defendant Pender Stucleus or Stucley clerk 666929 666929 Pender, Stucleus or Stucley, of Torrington Magna, clerk 1
4028461 2034830 2034830 defendant Furse Joan widow 666929 666929 Furse, Joan, of Torrington Magna, widow 1
4028551 2034863 2034863 plaintiff Cornell William merchant 666929 666929 Cornell, William, of Torrington Magna, merchant 0
4041924 2039599 2039599 defendant Powle John merchant 666929 666929 Powle, John, of Torrington Magna, merchant 0
4045564 2040864 2040864 defendant Wescott Anthony weaver 666929 666929 Wescott, Anthony, of Torrington Magna, weaver 0
4082499 2054047 2054047 defendant Rusten John   666929 666929 Rusten, John, of Torrington Magna, groom 1
4162837 2082542 2082542 defendant Champneis William Devon, gent 666929 666929 Champneis William, of Torrington Magna, Devon, gent 23
4164966 2083254 2083254 defendant Reynsbery Nicholas haberdasher 666929 666929 Reynsbery, Nicholas, of Torrington Magna, haberdasher 0
4164967 2083254 2083254 defendant Dobyn Edmund husbandman 666929 666929 Dobyn, Edmund, of Torrington Magna, husbandman 1
4173397 2086153 2086153 defendant Venner Peter hatter 666929 666929 Venner, Peter, of Torrington Magna, hatter 1
4173398 2086153 2086153 defendant Tuddye Allan hatter 666929 666929 Tuddye, Allan, of Torrington Magna, hatter 2
4175734 2086986 2086986 defendant Honywell John smith 666929 666929 Honywell, John, of Torrington Magna, smith 0
4175735 2086986 2086986 defendant Honywell Thomas   666929 666929 Honywell, Thomas, of Torrington Magna, groom, his son 1
4179686 2088368 2088368 defendant Androwe Henry haberdasher 666929 666929 Androwe, Henry, of Torrington Magna, haberdasher 2
4181045 2088845 2088845 defendant Palmer William victualer 666929 666929 Palmer, William, of Torrington Magna, butcher, victualer 0
4185602 2090470 2090470 defendant Milles Thomas yeoman 666929 666929 Milles, Thomas, of Torrington Magna, yeoman 1
4191871 2092714 2092714 defendant Frayne John yeoman 666929 666929 Frayne, John, of Torrington Magna, yeoman 1
4191884 2092720 2092720 defendant Hutchins Thomas husbandman 666929 666929 Hutchins, Thomas, of Torrington Magna, husbandman 0
4202010 2096247 2096247 defendant Jenneberre Maurice weaver 666929 666929 Jenneberre, Maurice, of Torrington Magna, weaver 0
4219269 2102234 2102234 defendant Cantell John joiner 666929 666929 Cantell, John, of Torrington Magna, joiner 0
4220899 2102804 2102804 defendant Browne Roger merchant 666929 666929 Browne, Roger, of Torrington Magna, merchant 0
4222942 2103514 2103514 defendant Risdon Philip gent 666929 666929 Risdon, Philip, of Torrington Magna, gent 0
4224031 2103890 2103890 defendant Rolle Alexander gent 666929 666929 Rolle, Alexander, of Torrington Magna, gent 0
4260445 2116461 2116461 defendant Hewett John potter 666929 666929 Hewett, John, of Torrington Magna, potter 1
4262632 2117171 2117171 defendant Risdon Philip gent 666929 666929 Risdon, Philip, of Torrington Magna, gent 0
4286718 2125302 2125302 defendant Gyles Thomas yeoman 666929 666929 Gyles, Thomas, of Torrington Magna, yeoman 0
4290107 2126527 2126527 defendant Taylder John weaver 666929 666929 Taylder, John, of Torrington Magna, weaver 2
4309261 2133391 2133391 defendant Honywell Thomas yeoman 666929 666929 Honywell, Thomas, of Torrington Magna, yeoman 0
4312920 2134643 2134643 defendant Grene John   666929 666929 Grene, John, of Torrington Magna, groom 3
4390702 2161500 2161500 defendant Rattenbery Richard husbandman 666929 666929 Rattenbery, Richard, of Torrington Magna, husbandman 1
4405492 2166414 2166414 defendant Huddle John husbandman 666929 666929 Huddle, John, of Torrington Magna, or of Moretowne, Devon, husbandman 0
4405495 2166414 2166414 defendant Pudner John, senior weaver 666929 666929 Pudner, John, senior, of Torrington Magna, weaver 3
4405498 2166415 2166415 defendant Popham Walter weaver 666929 666929 Popham, Walter, of Torrington Magna, weaver 1
4405499 2166415 2166415 defendant Beste John merchant 666929 666929 Beste, John, of Torrington Magna, merchant 2

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