names

22 rows where place_id = 589225

✎ 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
3596949 1866677 1866677 defendant Pell Thomas yeoman 589225 589225 Pell, Thomas, of Kelby, yeoman 4
3600172 1867706 1867706 defendant Lambe William yeoman 589225 589225 Lambe, William, of Kelby, yeoman 0
3603053 1868622 1868622 defendant Lambe William yeoman 589225 589225 Lambe, William, of Kelby, yeoman 1
3624313 1875138 1875138 defendant Lamme William yeoman 589225 589225 Lamme, William, of Kelby, yeoman 0
3624314 1875138 1875138 defendant Yngoldesby Thomas gent 589225 589225 Yngoldesby, Thomas, of Kelby, gent 1
3640572 1907491 1907491 defendant Richardson Thomas husbandman 589225 589225 Richardson, Thomas, of Kelby, husbandman 0
3687090 1922133 1922133 defendant Tymberland Richard (legal representative) 589225 589225 Tymberland, Richard, of Kelby, husbandman, executors of 0
4043086 2039995 2039995 plaintiff Petche William yeoman 589225 589225 Petche, William, of Kelby, yeoman 0
4043088 2039996 2039996 plaintiff Petche William yeoman 589225 589225 Petche, William, of Kelby, yeoman 0
4450895 2185247 2185247 defendant Bumbol Nicholas   589225 589225 Bumbol, Nicholas, of Kelby 1
4501763 2201146 2201146 defendant atte Well William   589225 589225 atte Well, William, of Kelby 5
4715875 2270279 2270279 defendant Biddes Richard husbandman 589225 589225 Biddes, Richard, of Kelby, husbandman 1
4715876 2270279 2270279 defendant Potyvante John husbandman 589225 589225 Potyvante, John, of Kelby, husbandman 2
4904930 2328145 2328145 defendant Ferrour or Smith Thomas   589225 589225 Ferrour or Smith, Thomas, of Kelby 0
5133543 2396302 2396302 defendant Warner Thomas husbandman 589225 589225 Warner, Thomas, of Kelby, husbandman 0
5133544 2396302 2396302 defendant Bate Alexander husbandman 589225 589225 Bate, Alexander, of Kelby, husbandman 1
5153345 2402131 2402131 defendant Warner Thomas husbandman 589225 589225 Warner, Thomas, of Kelby, husbandman 0
5153346 2402131 2402131 defendant Bate Alexander husbandman 589225 589225 Bate, Alexander, of Kelby, husbandman 1
5240211 2427342 2427342 defendant Jankynson Robert husbandman 589225 589225 Jankynson, Robert, of Kelby, husbandman 3
5339153 2456823 2456823 defendant Inbgoldesby Robert gent 589225 589225 Inbgoldesby, Robert, of Kelby, gent 2
5578432 2528325 2528325 defendant Lamme William yeoman 589225 589225 Lamme, William, of Kelby, yeoman 0
5578433 2528325 2528325 defendant Hareth William husbandman 589225 589225 Hareth, William, of Kelby, husbandman 1

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