names

38 rows where place_id = 613296

✎ 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
3697610 1925476 1925476 defendant Welssheman John husbandman 613296 613296 Welssheman, John, of Colwall, husbandman 1
3726299 1934495 1934495 defendant Jouldewyn John chaplain 613296 613296 Jouldewyn, John, of Colwall, chaplain 0
3798556 1957453 1957453 defendant Hope Richard husbandman 613296 613296 Hope, Richard, of Colwall, husbandman 1
4017511 2030966 2030966 defendant Wryght Thomas cooper 613296 613296 Wryght, Thomas, of Colwall, cooper 1
4050995 2042797 2042797 defendant Canock William husbandman 613296 613296 Canock, William, of Colwall, husbandman 0
4061912 2046659 2046659 plaintiff Threlkeld Edward gent 613296 613296 (Threlkeld, Edward, of Colwall, doctor of law, gent 1
4075873 2051673 2051673 defendant Rydgewey James yeoman 613296 613296 Rydgewey, James, of Colwall, yeoman 0
4077763 2052340 2052340 defendant Ockley John yeoman 613296 613296 Ockley, John, of Colwall, yeoman 0
4077764 2052340 2052340 defendant Ockley Thomas yeoman 613296 613296 Ockley, Thomas, of Colwall, yeoman 1
4101228 2060747 2060747 defendant Hunte Edmund husbandman 613296 613296 Hunte, Edmund, of Colwall, husbandman 2
4108704 2063367 2063367 defendant Pytt Richard yeoman 613296 613296 Pytt, Richard, of Colwall, yeoman 0
4281839 2123553 2123553 defendant Gyldinge Richard yeoman 613296 613296 Gyldinge, Richard, of Colwall, yeoman 1
4295983 2128662 2128662 defendant Hartland Richard yeoman 613296 613296 Hartland, Richard, of Colwall, yeoman 0
4298509 2129568 2129568 defendant Trovell Charles gent 613296 613296 Trovell, Charles, of Colwall, gent 0
4311190 2134061 2134061 defendant Hartland Richard husbandman 613296 613296 Hartland, Richard, of Colwall, husbandman 0
4311436 2134143 2134143 defendant Saword Thomas husbandman 613296 613296 Saword, Thomas, of Colwall, husbandman 0
4315061 2135382 2135382 defendant Byrd William husbandman 613296 613296 Byrd, William, of Colwall, husbandman 1
4513080 2204527 2204527 defendant Yong John   613296 613296 Yong, John, of Colwall 1
4572977 2223086 2223086 defendant Lawe Walter   613296 613296 Lawe, Walter, of Colwall 2
4625808 2239024 2239024 defendant Nasshe James   613296 613296 Nasshe, James, of Colwall 2
4625809 2239024 2239024 defendant Warde Thomas   613296 613296 Warde, Thomas, of Colwall 3
4774624 2288052 2288052 defendant Holder William husbandman 613296 613296 Holder, William, of Colwall, husbandman 0
5019670 2362636 2362636 defendant Warde William yeoman 613296 613296 Warde, William, of Colwall, yeoman 1
5019671 2362636 2362636 defendant Barette John yeoman 613296 613296 Barette, John, of Colwall, yeoman 2
5019672 2362636 2362636 defendant Pache John yeoman 613296 613296 Pache, John, of Colwall, yeoman 3
5019673 2362636 2362636 defendant Harrys Thomas yeoman 613296 613296 Harrys, Thomas, of Colwall, yeoman 4
5019674 2362636 2362636 defendant Farley Hugh yeoman 613296 613296 Farley, Hugh, of Colwall, yeoman 5
5019675 2362636 2362636 defendant Lenehale or Levehale Henry yeoman 613296 613296 Lenehale or Levehale, Henry, of Colwall, yeoman 6
5173471 2407942 2407942 defendant Paty John husbandman 613296 613296 Paty, John, of Colwall, husbandman 3
5173477 2407943 2407943 defendant Paty John husbandman 613296 613296 Paty, John, of Colwall, husbandman 3
5223923 2422679 2422679 defendant Paty John husbandman 613296 613296 Paty, John, of Colwall, husbandman 3
5350446 2460262 2460262 defendant Golthill Richard husbandman 613296 613296 Golthill, Richard, of Colwall, husbandman 0
5444204 2488174 2488174 defendant Golgehyll William   613296 613296 Golgehyll, William, of Colwall. Husbandman 1
5470980 2496257 2496257 plaintiff Halle Thomas clerk & rector 613296 613296 Halle, Thomas, of Colwall, clerk & rector 0
5482238 2499630 2499630 defendant Berewe William husbandman 613296 613296 Berewe, William, of Colwall, husbandman 0
5495247 2503473 2503473 defendant Vuet or Unet Richard gent 613296 613296 Vuet or Unet, Richard, of Colwall, gent 0
5546385 2518944 2518944 defendant Regge William carpenter 613296 613296 Regge, William, of Colwall, carpenter 0
5586291 2530753 2530753 defendant Mothowe John husbandman 613296 613296 Mothowe, John, of Colwall, husbandman 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);