names

29 rows where place_id = 586082

✎ 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
3587885 1863861 1863861 defendant Cobham Edmund husbandman 586082 586082 Cobham, Edmund, of Ever, husbandman 0
3593407 1865572 1865572 defendant London John husbandman 586082 586082 London, John, of Ever, husbandman 0
3598477 1867153 1867153 defendant ap Thomas Roger clerk 586082 586082 ap Thomas, Roger, of Ever, clerk 0
3624012 1875044 1875044 defendant ap Thomas Roger clerk 586082 586082 ap Thomas, Roger, of Ever, clerk 0
3700281 1926325 1926325 defendant Canon Richard yeoman 586082 586082 Canon, Richard, of Ever, yeoman 0
3725507 1934266 1934266 defendant Canon Thomas husbandman 586082 586082 Canon, Thomas, of Ever, husbandman 0
3725508 1934266 1934266 defendant Mathewe Robert husbandman 586082 586082 Mathewe, Robert, of Ever, husbandman 1
3725510 1934267 1934267 defendant Park William miller 586082 586082 Park, William, of Ever, miller 0
3845006 1971988 1971988 defendant Durdaunt Nicholas yeoman 586082 586082 Durdaunt, Nicholas, of Ever, yeoman 0
3883936 1984897 1984897 defendant Kydney John husbandman 586082 586082 Kydney, John, of Ever, husbandman 0
3883937 1984897 1984897 defendant Newe Nicholas husbandman 586082 586082 Newe, Nicholas, of Ever, husbandman 1
4994595 2355244 2355244 defendant Cler William   586082 586082 Cler, William, of Ever, servant 1
4994596 2355244 2355244 defendant Martyn Richard   586082 586082 Martyn, Richard, of Ever, servant 2
4994597 2355244 2355244 defendant Gape Robert   586082 586082 Gape, Robert, of Ever or Iver, servant 3
4994600 2355245 2355245 defendant Cler William   586082 586082 Cler, William, of Ever, servant 1
4994601 2355245 2355245 defendant Martyn Richard   586082 586082 Martyn, Richard, of Ever, servant 2
4994602 2355245 2355245 defendant Gape Robert   586082 586082 Gape, Robert, of Ever or Iver, servant 3
5024334 2364036 2364036 defendant Martyn John husbandman 586082 586082 Martyn, John, of Ever, husbandman 0
5024335 2364036 2364036 defendant Cornewell John husbandman 586082 586082 Cornewell, John, of Ever, husbandman 1
5024336 2364036 2364036 defendant Dene William butcher 586082 586082 Dene, William, of Ever, butcher 2
5045121 2370171 2370171 plaintiff Jemes Katherine (legal representative) 586082 586082 Jemes, Katherine, of Ever or Iver, executor of 0
5090654 2383650 2383650 defendant Cornewaill William husbandman 586082 586082 Cornewaill, William, of Ever, husbandman 0
5294042 2443230 2443230 defendant Evan Thomas husbandman 586082 586082 Evan, Thomas, of Ever, husbandman 3
5301442 2445383 2445383 defendant Danyell John husbandman 586082 586082 Danyell, John, of Ever Whataker, husbandman 2
5304703 2446402 2446402 defendant Smart William yeoman 586082 586082 Smart, William, of Ever, yeoman 2
5331385 2454466 2454466 defendant Dey John miller 586082 586082 Dey, John, of Ever, miller 1
5331386 2454466 2454466 defendant Cobbam Edmund husbandman 586082 586082 Cobbam, Edmund, of Ever, husbandman 2
5522303 2511794 2511794 defendant Deye John miller 586082 586082 Deye, John, of Ever, miller 0
5563455 2523912 2523912 defendant Canon Thomas husbandman 586082 586082 Canon, Thomas, of Ever, 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);