names

25 rows where place_id = 688233

✎ 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
4074736 2051264 2051264 defendant Hodgeson Robert yeoman 688233 688233 Hodgeson, Robert, of Chery Burton, yeoman 0
4633947 2241469 2241469 defendant Chappeman Thomas chaplain 688233 688233 Chappeman, Thomas, of Chery Burton, chaplain 1
4633952 2241470 2241470 defendant Chappeman Thomas chaplain 688233 688233 Chappeman, Thomas, of Chery Burton, chaplain 1
4633956 2241471 2241471 defendant Chappeman Thomas   688233 688233 Chappeman, Thomas, of Chery Burton 1
4825820 2304111 2304111 defendant Routh William chaplain 688233 688233 Routh, William, of Chery Burton, chaplain 6
4832389 2306164 2306164 defendant Rogerson Ralph husbandman 688233 688233 Rogerson, Ralph, of Chery Burton, husbandman 2
4832780 2306275 2306275 defendant Stirton John husbandman 688233 688233 Stirton, John, of Chery Burton, husbandman 3
4859694 2314400 2314400 defendant Stirton John husbandman 688233 688233 Stirton, John, of Chery Burton, husbandman 15
4860693 2314705 2314705 defendant Rogerson Ralph husbandman 688233 688233 Rogerson, Ralph, of Chery Burton, husbandman 4
4862692 2315318 2315318 defendant Nicolson John husbandman 688233 688233 Nicolson, John, of Chery Burton, husbandman 1
4900486 2326794 2326794 defendant Bulkyn Thomas husbandman 688233 688233 Bulkyn, Thomas, of Chery Burton, husbandman 1
4904412 2327993 2327993 defendant Lyhalf Robert   688233 688233 together with Lyhalf, Robert, of Chery Burton, franklin 3
4920035 2332778 2332778 defendant Dryffeld William husbandman 688233 688233 Dryffeld, William, of Chery Burton, husbandman 0
4948759 2341593 2341593 defendant Santon John husbandman 688233 688233 Santon, John, of Chery Burton, husbandman 1
4969668 2347874 2347874 defendant Lyndale William gent 688233 688233 Lyndale, William, of Chery Burton, gent 0
5001216 2357237 2357237 defendant Bryg Stephen husbandman 688233 688233 Bryg, Stephen, of Chery Burton, husbandman 0
5191443 2413238 2413238 defendant Lyndale John gent 688233 688233 Lyndale, John, of Chery Burton, gent 0
5295017 2443531 2443531 defendant Lyolfe Richard   688233 688233 Lyolfe, Richard, of Chery Burton, franklin 3
5326991 2453150 2453150 defendant Santon or Sauton Thomas husbandman 688233 688233 Santon or Sauton, Thomas, of Chery Burton, husbandman 0
5327139 2453193 2453193 defendant Chatte Thomas husbandman 688233 688233 Chatte, Thomas, of Chery Burton, husbandman 0
5327141 2453193 2453193 defendant Justyce Richard husbandman 688233 688233 Justyce, Richard, of Chery Burton, husbandman 2
5327169 2453200 2453200 defendant Richardson Robert husbandman 688233 688233 Richardson, Robert, of Chery Burton, husbandman 0
5327170 2453200 2453200 defendant Santon John laborer 688233 688233 Santon, John, of Chery Burton, laborer 1
5327177 2453200 2453200 defendant Huswyffe Thomas husbandman 688233 688233 Huswyffe, Thomas, of Chery Burton, husbandman 8
5327178 2453200 2453200 defendant Willyamson John husbandman 688233 688233 Willyamson, John, of Chery Burton, husbandman 9

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);