names

32 rows where place_id = 621392

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3741130 1939088 1939088 defendant Fychet John husbandman 621392 621392 Fychet, John, of Desford, husbandman 0
3808076 1960416 1960416 defendant Pykeryng Christopher yeoman 621392 621392 Pykeryng, Christopher, of Desford, yeoman 2
3962961 2011643 2011643 defendant Attorton Harrold husbandman 621392 621392 Attorton, Harrold, of Desford, husbandman 1
4147338 2077208 2077208 defendant Dixson William yeoman 621392 621392 Dixson, William, of Desford, yeoman 0
4369930 2154298 2154298 defendant Stone John yeoman 621392 621392 Stone, John, of Desford, or of Lynnarydge, yeoman 1
4372730 2155324 2155324 defendant Thorneton alias Tyson Richard husbandman 621392 621392 Thorneton alias Tyson, Richard, of Desford, husbandman 2
4454894 2186543 2186543 plaintiff Mason Richard   621392 621392 Mason, Richard, of Desford 0
4464366 2189524 2189524 defendant Wodhale Thomas   621392 621392 Wodhale, Thomas, of Desford, parson 0
4593282 2229193 2229193 defendant Hethelym William   621392 621392 Hethelym, William, of Desford 4
4593283 2229193 2229193 defendant Webster John   621392 621392 Webster, John, of Desford 5
4593284 2229193 2229193 defendant Rerebache William   621392 621392 Rerebache, William, of Desford 6
4593285 2229193 2229193 defendant Percevale Thomas   621392 621392 Percevale, Thomas, of Desford 7
4593286 2229193 2229193 defendant Goderiche Robert   621392 621392 Goderiche, Robert, of Desford 8
4593287 2229193 2229193 defendant Odam Thomas   621392 621392 Odam, Thomas, of Desford 9
4593288 2229193 2229193 defendant Smyth William   621392 621392 Smyth, William, of Desford 10
4593289 2229193 2229193 defendant Goterde Hugh   621392 621392 Goterde, Hugh, of Desford 11
4593290 2229193 2229193 defendant Hewet John   621392 621392 Hewet, John, of Desford 12
4593291 2229193 2229193 defendant Bret William   621392 621392 Bret, William, of Desford 13
4593292 2229193 2229193 defendant Porter Robert   621392 621392 Porter, Robert, of Desford 14
4662247 2249665 2249665 defendant Frankeleyn Richard husbandman 621392 621392 Frankeleyn, Richard, of Desford, husbandman 1
4699089 2265183 2265183 defendant atte Hegge John husbandman 621392 621392 atte Hegge, John, of Desford, husbandman 0
4728485 2274143 2274143 defendant Egge John chapman 621392 621392 Egge, John, of Desford, chapman 0
4748871 2280159 2280159 defendant Egge John yeoman 621392 621392 Egge, John, of Desford, yeoman 0
4773507 2287684 2287684 defendant Rerbage William husbandman 621392 621392 Rerbage, William, of Desford, husbandman 0
4798789 2295800 2295800 defendant Rerbage William husbandman 621392 621392 Rerbage, William, of Desford, husbandman 0
4853799 2312600 2312600 defendant Balle John husbandman 621392 621392 Balle, John, of Desford, husbandman 0
5012100 2360388 2360388 defendant Kyrkeby William husbandman 621392 621392 Kyrkeby, William, of Desford, husbandman 0
5023294 2363717 2363717 defendant Desford Robert yeoman 621392 621392 Desford, Robert, of Desford, yeoman 1
5027419 2364899 2364899 defendant Nothewe alias Desford Robert yeoman 621392 621392 Nothewe alias Desford, Robert, of Desford, yeoman 0
5110171 2389384 2389384 defendant Wylkyns Thomas clerk 621392 621392 Wylkyns, Thomas, of Desford, clerk 4
5294642 2443415 2443415 plaintiff Syde Richard   621392 621392 Syde, Richard, of Desford 0
5623736 2551361 2551361 defendant Stokton John husbandman 621392 621392 Stokton, John, of Desford, 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);