names

26 rows where place_id = 633334

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3812089 1961692 1961692 defendant Valantyne John husbandman 633334 633334 Valantyne, John, of Warlyngham, husbandman 0
3885393 1985368 1985368 defendant Comporte William yeoman 633334 633334 Comporte, William, of Warlyngham, yeoman 0
4366746 2153152 2153152 defendant Haywarde John husbandman 633334 633334 Haywarde, John, of Warlyngham, husbandman 1
4866439 2316470 2316470 defendant Cokeman or Coleman John husbandman 633334 633334 Cokeman or Coleman, John, of Warlyngham, husbandman 0
4866442 2316471 2316471 defendant Cokeman John husbandman 633334 633334 Cokeman, John, of Warlyngham, husbandman 0
4941036 2339216 2339216 defendant Wodden William husbandman 633334 633334 Wodden, William, of Warlyngham, husbandman 0
4995078 2355387 2355387 defendant Pleynesfeld John husbandman 633334 633334 Pleynesfeld, John, of Warlyngham, husbandman 1
5050916 2371889 2371889 defendant Volantyn John husbandman 633334 633334 Volantyn, John, of Warlyngham, husbandman 0
5095758 2385182 2385182 defendant Playnesfeld John husbandman 633334 633334 Playnesfeld, John, of Warlyngham, husbandman 1
5122832 2393109 2393109 defendant Cokeman John husbandman 633334 633334 Cokeman, John, of Warlyngham, husbandman 1
5191499 2413255 2413255 defendant Volantyne John, sen husbandman 633334 633334 Volantyne, John, sen, of Warlyngham, husbandman 0
5191500 2413255 2413255 defendant Reynkyn Robert clerk & vicar 633334 633334 Reynkyn, Robert, of Warlyngham, clerk & vicar 1
5191503 2413256 2413256 defendant Wodden William husbandman 633334 633334 Wodden, William, of Warlyngham, husbandman 0
5191504 2413256 2413256 defendant Playnesfeld John husbandman 633334 633334 Playnesfeld, John, of Warlyngham, husbandman 1
5191505 2413256 2413256 defendant Wodden Henry husbandman 633334 633334 Wodden, Henry, of Warlyngham, husbandman 2
5207375 2417898 2417898 defendant Volantyne John, sen husbandman 633334 633334 Volantyne, John, sen, of Warlyngham, husbandman 0
5207376 2417898 2417898 defendant Reynkyn Robert clerk & vicar 633334 633334 Reynkyn, Robert, of Warlyngham, clerk & vicar 1
5207379 2417899 2417899 defendant Wodden William husbandman 633334 633334 Wodden, William, of Warlyngham, husbandman 0
5207380 2417899 2417899 defendant Playnesfeld John husbandman 633334 633334 Playnesfeld, John, of Warlyngham, husbandman 1
5207381 2417899 2417899 defendant Wodden Henry husbandman 633334 633334 Wodden, Henry, of Warlyngham, husbandman 2
5268922 2436020 2436020 defendant Valentine John yeoman 633334 633334 Valentine, John, of Warlyngham, yeoman 2
5360948 2463447 2463447 defendant Wodell Henry husbandman 633334 633334 Wodell, Henry, of Warlyngham, husbandman 4
5403209 2476000 2476000 defendant Longe Richard husbandman 633334 633334 Longe, Richard, of Warlyngham, husbandman 2
5432948 2484823 2484823 defendant Longe Richard husbandman 633334 633334 Longe, Richard, of Warlyngham, husbandman 2
5432954 2484824 2484824 defendant L_ Richard husbandman 633334 633334 L_, Richard, of Warlyngham, husbandman 2
5549046 2519759 2519759 defendant Assheley John laborer 633334 633334 Assheley, John, of Warlyngham, laborer 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);