names

22 rows where place_id = 594753

✎ 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
3617467 1873083 1873083 defendant Cambray John husbandman 594753 594753 Cambray, John, of Alderley, husbandman 0
3682413 1920601 1920601 defendant Holwey Joan widow 594753 594753 Holwey, Joan, of Alderley, widow 0
3692461 1923823 1923823 defendant Penryce William weaver 594753 594753 Penryce, William, of Alderley, weaver 1
3780124 1951508 1951508 defendant Webbe James tucker 594753 594753 Webbe, James, of Alderley, tucker 2
3780125 1951508 1951508 defendant Webbe Thomas clothier 594753 594753 Webbe, Thomas, of Alderley, clothier 3
3788054 1954055 1954055 defendant Webbe John tucker 594753 594753 Webbe, John, of Alderley, tucker 0
3833787 1968499 1968499 defendant Cowley Thomas yeoman 594753 594753 Cowley, Thomas, of Alderley, yeoman 0
3840703 1970657 1970657 defendant Cowley Hugh chapman 594753 594753 Cowley, Hugh, of Alderley, chapman 0
3844149 1971718 1971718 defendant Wylkys Thomas husbandman 594753 594753 Wylkys, Thomas, of Alderley, husbandman 1
3844461 1971814 1971814 defendant Cowley Thomas yeoman 594753 594753 Cowley, Thomas, of Alderley, yeoman 0
3844465 1971815 1971815 defendant Cowley Thomas yeoman 594753 594753 Cowley, Thomas, of Alderley, yeoman 0
3857822 1976085 1976085 defendant Cowley Thomas drover 594753 594753 Cowley, Thomas, of Alderley, drover 0
3860355 1976962 1976962 defendant Cowley Thomas yeoman 594753 594753 Cowley, Thomas, of Alderley, yeoman 0
3860359 1976963 1976963 defendant Cowley Thomas yeoman 594753 594753 Cowley, Thomas, of Alderley, yeoman 0
3862011 1977479 1977479 defendant Cowley Thomas drover 594753 594753 Cowley, Thomas, of Alderley, drover 0
3871170 1980611 1980611 defendant Cowley Hugh yeoman 594753 594753 Cowley, Hugh, of Alderley, yeoman 0
4091758 2057343 2057343 defendant Bentley Randolph husbandman 594753 594753 Bentley, Randolph, of Alderley, husbandman 1
4402665 2165477 2165477 defendant Laprey John blacksmith 594753 594753 Laprey, John, of Alderley, blacksmith 2
4705620 2267130 2267130 defendant atte Wode William yeoman 594753 594753 atte Wode, William, of Alderley, yeoman 0
5073951 2378694 2378694 defendant Golde William clothman 594753 594753 Golde, William, of Alderley, clothman 0
5585069 2530401 2530401 defendant Packer Nicholas clothier 594753 594753 Packer, Nicholas, of Alderley, clothier 0
5594628 2533295 2533295 defendant Bedyll Richard tucker 594753 594753 Bedyll, Richard, of Alderley, tucker 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);