names

32 rows where place_id = 763861

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4501096 2200947 2200947 defendant Smyth Henry   763861 763861 Smyth, Henry, of Stepil Mordon 0
4507650 2202855 2202855 defendant Prentys John carpenter 763861 763861 Prentys, John, of Stepil Mordon, carpenter 0
4573367 2223201 2223201 defendant Banbery Thomas   763861 763861 Banbery, Thomas, of Stepil Mordon 0
4585153 2226777 2226777 defendant Canell or Cavell John   763861 763861 Canell or Cavell, John, of Stepil Mordon 1
4588829 2227881 2227881 defendant Scot John   763861 763861 Scot, John, of Stepil Mordon 0
4641838 2243714 2243714 defendant Andrewe John   763861 763861 Andrewe, John, of Stepil Mordon 2
4658055 2248397 2248397 plaintiff Cook John   763861 763861 Cook, John, of Stepil Mordon 0
4658056 2248397 2248397 defendant Beeston William husbandman 763861 763861 Beeston, William, of Stepil Mordon, husbandman 0
4671517 2256737 2256737 defendant Saly Henry butcher 763861 763861 Saly, Henry, of Stepil Mordon, butcher 0
4675271 2257876 2257876 defendant Othom Reginald   763861 763861 Othom, Reginald, of Stepil Mordon, wright 0
4679604 2259238 2259238 defendant Bannebury Thomas husbandman 763861 763861 Bannebury, Thomas, of Stepil Mordon, husbandman 2
4690519 2262591 2262591 defendant Hikke William husbandman 763861 763861 Hikke, William, of Stepil Mordon, husbandman 2
4718386 2271090 2271090 defendant Sandrych John husbandman 763861 763861 Sandrych, John, of Stepil Mordon, husbandman 1
4728811 2274250 2274250 defendant Beeston William husbandman 763861 763861 Beeston, William, of Stepil Mordon, husbandman 0
4728812 2274250 2274250 defendant Apelond William husbandman 763861 763861 Apelond, William, of Stepil Mordon, husbandman 1
4728814 2274250 2274250 defendant Hike William husbandman 763861 763861 Hike, William, of Stepil Mordon, husbandman 3
4732208 2275253 2275253 defendant Sandrych John husbandman 763861 763861 Sandrych, John, of Stepil Mordon, husbandman 0
4734702 2276009 2276009 defendant Spark Thomas husbandman 763861 763861 Spark, Thomas, of Stepil Mordon, husbandman 0
4734703 2276009 2276009 defendant Beston William husbandman 763861 763861 Beston, William, of Stepil Mordon, husbandman 1
4790289 2293048 2293048 defendant Beston William husbandman 763861 763861 Beston, William, of Stepil Mordon, husbandman 1
4790290 2293048 2293048 defendant Apelond William husbandman 763861 763861 Apelond, William, of Stepil Mordon, husbandman 2
4790291 2293048 2293048 defendant Hikke William husbandman 763861 763861 Hikke, William, of Stepil Mordon, husbandman 3
4790292 2293048 2293048 defendant Cook John husbandman 763861 763861 Cook, John, of Stepil Mordon, husbandman 4
5227268 2423604 2423604 defendant Harnes or Harves Richard clerk 763861 763861 Harnes or Harves, Richard, of Stepil Mordon, clerk 0
5227270 2423605 2423605 defendant Harnes or Harves Richard clerk 763861 763861 Harnes or Harves, Richard, of Stepil Mordon, clerk 0
5237933 2426681 2426681 defendant Malvern Thomas husbandman 763861 763861 Malvern, Thomas, of Stepil Mordon, husbandman 0
5272408 2436998 2436998 defendant Hyde Thomas   763861 763861 Hyde, Thomas, of Stepil Mordon 1
5370912 2466490 2466490 defendant Totalle John husbandman 763861 763861 Totalle, John, of Stepil Mordon, husbandman 0
5370913 2466490 2466490 defendant Totall Henry husbandman 763861 763861 Totall, Henry, of Stepil Mordon, husbandman 1
5388744 2471838 2471838 defendant Totall John husbandman 763861 763861 Totall, John, of Stepil Mordon, husbandman 0
5388745 2471838 2471838 defendant Totall Henry husbandman 763861 763861 Totall, Henry, of Stepil Mordon, husbandman 1
5406131 2476829 2476829 defendant Cristemasse Richard yeoman 763861 763861 Cristemasse, Richard, of Stepil Mordon, 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);