names

22 rows where place_id = 599537

✎ 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
3637187 1906431 1906431 defendant Bolymer John husbandman 599537 599537 Bolymer, John, of Foulden, husbandman 0
4168949 2084634 2084634 defendant Mowle Henry husbandman 599537 599537 Mowle, Henry, of Foulden, husbandman 0
4168951 2084635 2084635 defendant Sewell John husbandman 599537 599537 Sewell, John, of Foulden, husbandman 0
4224372 2104010 2104010 defendant Tayler John clerk 599537 599537 Tayler, John, of Foulden, clerk 0
4243032 2110661 2110661 defendant Middleton William yeoman 599537 599537 Middleton, William, of Foulden, yeoman 0
4249545 2112833 2112833 defendant Wrighte Robert husbandman 599537 599537 Wrighte, Robert, of Foulden, husbandman 2
4249546 2112833 2112833 defendant Carr John husbandman 599537 599537 Carr, John, of Foulden, husbandman 3
4669173 2256064 2256064 defendant Lyntforth Richard   599537 599537 Lyntforth, Richard, of Foulden, shepherd 0
4808285 2298769 2298769 defendant atte Herne Henry yeoman 599537 599537 atte Herne, Henry, of Foulden, yeoman 0
4809495 2299143 2299143 defendant Chaundler Richard yeoman 599537 599537 Chaundler, Richard, of Foulden, yeoman 1
4922863 2333566 2333566 defendant Godewyn John yeoman 599537 599537 Godewyn, John, of Foulden, yeoman 0
5238209 2426760 2426760 defendant Este Richard   599537 599537 Este, Richard, of Foulden, shepherd 1
5238210 2426760 2426760 defendant Ladell John   599537 599537 Ladell, John, of Foulden, servant 2
5265683 2435020 2435020 defendant Mandolle Robert shoemaker 599537 599537 Mandolle, Robert, of Foulden, shoemaker 2
5391524 2472648 2472648 defendant Goodwyn Robert husbandman 599537 599537 Goodwyn, Robert, of Foulden, husbandman 3
5536598 2515934 2515934 defendant Ryghtwys William clerk 599537 599537 Ryghtwys, William, of Foulden, clerk 0
5585866 2530633 2530633 plaintiff Kenton John (legal representative) 599537 599537 Kenton, John, of Foulden, weaver, executor of Kenton, Samson, of Foulden, executors of 0
5585869 2530633 2530633 defendant Akyrs Richard husbandman 599537 599537 Akyrs, Richard, of Foulden, husbandman 0
5585870 2530634 2530634 plaintiff Kenton Seman (legal representative) 599537 599537 Kenton, Seman, of Foulden, executors of 0
5585872 2530634 2530634 plaintiff Kenton John weaver 599537 599537 Kenton, John, of Foulden, weaver 2
5585873 2530634 2530634 defendant Kenton Robert (legal representative) 599537 599537 Kenton, Robert, of Foulden, singleman, executors of 0
5585874 2530634 2530634 defendant Akyrs Richard husbandman 599537 599537 (Akyrs, Richard, of Foulden, 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);