names

44 rows where place_id = 591711

✎ 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
3605325 1869331 1869331 defendant Tukker Robert clothman 591711 591711 Tukker, Robert, of Devises, Wilts, clothman 1
3642153 1907994 1907994 defendant Frere Henry clothman 591711 591711 Frere, Henry, of Devises, Wilts, clothman 0
3647920 1909746 1909746 defendant Wauncey John fisher 591711 591711 Wauncey, John, of Devises, Wilts, fisher 0
3652573 1911138 1911138 defendant Wauncey John fisher 591711 591711 Wauncey, John, of Devises, Wilts, fisher 0
3721955 1933132 1933132 plaintiff Lymbery Richard (legal representative) 591711 591711 Lymbery, Richard, of Devises, Wilts, clothmaker, executors of 0
3784618 1952975 1952975 defendant Drewe John (legal representative) 591711 591711 Drewe, John, of Devises, Wilts, weaver, executrix of 0
3784622 1952976 1952976 defendant Drewe John (legal representative) 591711 591711 Drewe, John, of Devises, Wilts, weaver, executrix of 0
3799219 1957668 1957668 defendant Knyght Robert clothier 591711 591711 Knyght, Robert, of Devises, Wilts, clothier 0
3801156 1958282 1958282 defendant Drewe John (legal representative) 591711 591711 Drewe, John, of Devises, Wilts, weaver, executrix of 0
3813199 1962038 1962038 defendant Lanyngton or Lavyngton John clothman 591711 591711 Lanyngton or Lavyngton, John, of Devises, Wilts, clothman 2
3854461 1975034 1975034 defendant Knyght Robert clothier 591711 591711 Knyght, Robert, of Devises, Wilts, clothier 2
3854465 1975035 1975035 defendant Knyght Robert clothier 591711 591711 Knyght, Robert, of Devises, Wilts, clothier 2
3923445 1998147 1998147 plaintiff Smythe John   591711 591711 Smythe, John, of Devises, Wilts 0
3987552 2020298 2020298 defendant Eden Edward weaver 591711 591711 Eden, Edward, of Devises, Wilts, weaver 0
4012033 2029033 2029033 defendant Claye Anthony chapman 591711 591711 Claye, Anthony, of Devises, Wilts, chapman 1
4025270 2033699 2033699 defendant Ferr Roger yeoman 591711 591711 Ferr, Roger, of Devises, Wilts, yeoman 3
4025294 2033706 2033706 defendant Ferr Roger yeoman 591711 591711 Ferr, Roger, of Devises, Wilts, yeoman 3
4032912 2036420 2036420 defendant Beratt William vintner or wine drawer 591711 591711 Beratt, William, of Devises, Wilts, vintner or wine drawer 2
4089001 2056364 2056364 defendant Knapton Richard yeoman 591711 591711 Knapton, Richard, of Devises, Wilts, yeoman 0
4200434 2095710 2095710 defendant Byrde John chapman 591711 591711 Byrde, John, of Devises, Wilts, chapman 1
4250861 2113267 2113267 defendant Hodnett John yeoman 591711 591711 Hodnett, John, of Devises, Wilts, yeoman 0
4269202 2119293 2119293 defendant Herod William clothier 591711 591711 Herod, William, of Devises, Wilts, clothier 0
4300646 2130328 2130328 defendant Corderey Robert chapman 591711 591711 Corderey, Robert, of Devises, Wilts, chapman 1
4304127 2131576 2131576 defendant Sherwood Richard chapman 591711 591711 Sherwood, Richard, of Devises, Wilts, chapman 1
4660121 2249011 2249011 defendant Clerk Thomas yeoman 591711 591711 Clerk, Thomas, of Devises, Wilts, yeoman 0
5012802 2360576 2360576 defendant Bowyer Roger chapman 591711 591711 Bowyer, Roger, of Devises, Wilts, chapman 0
5291628 2442556 2442556 defendant Shete John clothman 591711 591711 Shete, John, of Devises, Wilts, clothman 0
5339638 2456971 2456971 defendant Noreys Thomas gent 591711 591711 Noreys, Thomas, of Devises, Wilts, gent 0
5348961 2459809 2459809 defendant Rede John weaver 591711 591711 Rede, John, of Devises, Wilts, weaver 0
5348964 2459810 2459810 defendant Rede John weaver 591711 591711 Rede, John, of Devises, Wilts, weaver 0
5375328 2467873 2467873 defendant Strong John clothman 591711 591711 Strong, John, of Devises, Wilts, clothman 0
5392846 2473027 2473027 defendant Hocheon Hugh clothman 591711 591711 Hocheon, Hugh, of Devises, Wilts, clothman 2
5419679 2480803 2480803 plaintiff Stronge John clothier 591711 591711 Stronge, John, of Devises, Wilts, clothier 0
5453643 2490982 2490982 defendant Slye Thomas hostler 591711 591711 Slye, Thomas, of Devises, Wilts, hostler 1
5531162 2514261 2514261 defendant Broun George clothier 591711 591711 Broun, George, of Devises, Wilts, clothier 2
5531167 2514262 2514262 defendant Broun George clothier 591711 591711 Broun, George, of Devises, Wilts, clothier 2
5535743 2515689 2515689 defendant Broun George chapman 591711 591711 Broun, George, of Devises, Wilts, chapman 1
5560141 2522928 2522928 defendant Frere Henry clothmaker 591711 591711 Frere, Henry, of Devises, Wilts, clothmaker 0
5560177 2522940 2522940 defendant Frere Henry clothmaker 591711 591711 Frere, Henry, of Devises, Wilts, clothmaker 0
5563200 2523835 2523835 defendant Glyston John dyer 591711 591711 Glyston, John, of Devises, Wilts, dyer 0
5565464 2524492 2524492 defendant Coffe William clothman 591711 591711 Coffe, William, of Devises, Wilts, clothman 2
5570378 2525906 2525906 defendant Hawkyns Thomas clothier 591711 591711 Hawkyns, Thomas, of Devises, Wilts, clothier 1
5574996 2527263 2527263 defendant Cuff William clothier 591711 591711 Cuff, William, of Devises, Wilts, clothier 0
5575002 2527264 2527264 defendant Cuffe William clothier 591711 591711 Cuffe, William, of Devises, Wilts, clothier 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);