names

21 rows where place_id = 644007

✎ 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
3877096 1982581 1982581 defendant Forman Thomas husbandman 644007 644007 Forman, Thomas, of Ryseley, husbandman 0
3967470 2013258 2013258 defendant Bolno alias Myller Thomas husbandman 644007 644007 Bolno alias Myller, Thomas, of Ryseley, husbandman 0
3967471 2013258 2013258 defendant Foxe Henry smith 644007 644007 Foxe, Henry, of Ryseley, smith 1
4109517 2063666 2063666 defendant Smarte Christopher tailor 644007 644007 Smarte, Christopher, of Ryseley, tailor 1
4651442 2246456 2246456 defendant Bailly John ploughman 644007 644007 Bailly, John, of Ryseley, ploughman 0
4730202 2274646 2274646 defendant Tounesende William   644007 644007 Tounesende, William, of Ryseley 0
4876280 2319542 2319542 defendant Randes Simon husbandman 644007 644007 Randes, Simon, of Ryseley, husbandman 0
4876281 2319542 2319542 defendant Beale William husbandman 644007 644007 Beale, William, of Ryseley, husbandman 1
4916669 2331724 2331724 defendant Symkynson William husbandman 644007 644007 Symkynson, William, of Ryseley, husbandman 2
4916672 2331725 2331725 defendant Symkynson William husbandman 644007 644007 Symkynson, William, of Ryseley, husbandman 1
4950871 2342242 2342242 defendant Stukeley John husbandman 644007 644007 Stukeley, John, of Ryseley, husbandman 0
4966469 2346906 2346906 defendant Stucley John   644007 644007 Stucley, John, of Ryseley, tile maker 0
4986563 2352909 2352909 defendant Zouche William husbandman 644007 644007 Zouche, William, of Ryseley, husbandman 2
4986564 2352909 2352909 defendant Skyrmar John fuller 644007 644007 Skyrmar, John, of Ryseley, fuller 3
4986565 2352909 2352909 defendant Odde John husbandman 644007 644007 Odde, John, of Ryseley, husbandman 4
5007383 2359052 2359052 defendant Ryseley William husbandman 644007 644007 Ryseley, William, of Ryseley, husbandman 3
5276350 2438153 2438153 defendant Lombe William husbandman 644007 644007 Lombe, William, of Ryseley, husbandman 3
5299318 2444773 2444773 defendant Wrotham John potter 644007 644007 Wrotham, John, of Ryseley, potter 2
5514986 2509527 2509527 defendant Byworth Thomas husbandman 644007 644007 Byworth, Thomas, of Ryseley, husbandman 0
5582755 2529677 2529677 defendant Latyn John, junior weaver 644007 644007 Latyn, John, junior, of Ryseley, weaver 0
5582756 2529677 2529677 defendant Bankys Thomas husbandman 644007 644007 Bankys, Thomas, of Ryseley, 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);