names

31 rows where place_id = 669174

✎ 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
3992095 2021936 2021936 plaintiff Bucke Thomas, senior gent 669174 669174 Bucke, Thomas, senior, of Aylberton, gent 0
4057165 2044947 2044947 defendant Balle John tanner 669174 669174 Balle, John, of Aylberton, tanner 1
4087316 2055754 2055754 defendant Ball John tanner 669174 669174 Ball, John, of Aylberton, tanner 0
4482106 2195114 2195114 defendant Swon Richard   669174 669174 Swon, Richard, of Aylberton 2
4493447 2198655 2198655 defendant Foxley Richard   669174 669174 Foxley, Richard, of Aylberton 4
4525159 2208210 2208210 defendant Hille Reginald   669174 669174 Hille, Reginald, of Aylberton, vicar 0
4525160 2208210 2208210 defendant Swon Richard   669174 669174 Swon, Richard, of Aylberton 1
4525161 2208210 2208210 defendant Shepherd William   669174 669174 Shepherd, William, of Aylberton 2
4525163 2208210 2208210 defendant Crook John   669174 669174 Crook, John, of Aylberton 4
4536545 2211706 2211706 defendant Chaumpeneys John, sen   669174 669174 Chaumpeneys, John, sen, of Aylberton 0
4570688 2222399 2222399 defendant Champeneys John   669174 669174 Champeneys, John, of Aylberton 1
4626299 2239183 2239183 defendant Champeneys John, sen   669174 669174 Champeneys, John, sen, of Aylberton 0
4722880 2272471 2272471 defendant Bucke Michael husbandman 669174 669174 Bucke, Michael, of Aylberton, husbandman 0
4749931 2280453 2280453 defendant Aleyn Richard tanner 669174 669174 Aleyn, Richard, of Aylberton, tanner 0
4749932 2280453 2280453 defendant Carpenter Henry smith 669174 669174 Carpenter, Henry, of Aylberton, smith 1
4787093 2292025 2292025 defendant Coke William carpenter 669174 669174 Coke, William, of Aylberton, carpenter 1
4787094 2292025 2292025 defendant Osseborn William husbandman 669174 669174 Osseborn, William, of Aylberton, husbandman 2
4787095 2292025 2292025 defendant Reve Nicholas husbandman 669174 669174 Reve, Nicholas, of Aylberton, husbandman 3
4812390 2299986 2299986 defendant Aleyn Agnes widow & formerly wife of Testator 669174 669174 Aleyn, Agnes, of Aylberton, widow & formerly wife of Testator 4
4836648 2307435 2307435 defendant Mores John husbandman 669174 669174 Mores, John, of Aylberton, husbandman 0
4916209 2331573 2331573 defendant Grafton Thomas husbandman 669174 669174 Grafton, Thomas, of Aylberton, husbandman 0
4944061 2340111 2340111 defendant Aleyn Richard (legal representative) 669174 669174 Aleyn, Richard, of Aylberton, tanner, executrix of 3
4944062 2340111 2340111 defendant Aleyn Agnes widow 669174 669174 Aleyn, Agnes, of Aylberton, widow 4
4959999 2344954 2344954 defendant Stanburne John husbandman 669174 669174 Stanburne, John, of Aylberton, husbandman 3
4995056 2355377 2355377 defendant Stanburn John husbandman 669174 669174 Stanburn, John, of Aylberton, husbandman 0
5125947 2394073 2394073 defendant Champneys William   669174 669174 Champneys, William, of Aylberton, franklin 0
5233906 2425504 2425504 defendant Stanburn Richard, junior husbandman 669174 669174 Stanburn, Richard, junior, of Aylberton, husbandman 0
5239898 2427247 2427247 defendant Smyth John husbandman 669174 669174 Smyth, John, of Aylberton, husbandman 2
5347534 2459386 2459386 defendant Levy or Leny John laborer 669174 669174 Levy or Leny, John, of Aylberton, laborer 9
5347538 2459386 2459386 defendant More John laborer 669174 669174 More, John, of Aylberton, laborer 13
5525932 2512702 2512702 defendant Buke Thomas yeoman 669174 669174 Buke, Thomas, of Aylberton, yeoman 3

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