names

26 rows where place_id = 598205

✎ 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
3631551 1904684 1904684 defendant Pakker John laborer 598205 598205 Pakker, John, of Chykwell, laborer 0
3631552 1904684 1904684 defendant Martyn Richard husbandman 598205 598205 Martyn, Richard, of Chykwell, husbandman 1
3652025 1910985 1910985 defendant Wyberd Lawrence husbandman 598205 598205 Wyberd, Lawrence, of Chykwell, husbandman 1
3657036 1912463 1912463 plaintiff Cooke William gent 598205 598205 Cooke, William, of Chykwell, gent 0
3813529 1962149 1962149 defendant Broun Andrew glover 598205 598205 Broun, Andrew, of Chykwell, glover 0
3813531 1962150 1962150 defendant Fuller Thomas husbandman 598205 598205 Fuller, Thomas, of Chykwell, husbandman 0
4643986 2244340 2244340 defendant Bovantur John, sen   598205 598205 Bovantur, John, sen, of Chykwell 2
4844911 2309927 2309927 defendant Sayller John husbandman 598205 598205 Sayller, John, of Chykwell, husbandman 0
4855019 2312924 2312924 defendant Champeney William farmer 598205 598205 Champeney, William, of Chykwell, farmer 0
4869866 2317546 2317546 defendant Chambyrleyn Thomas husbandman 598205 598205 Chambyrleyn, Thomas, of Chykwell, husbandman 1
4869868 2317546 2317546 defendant Browenyng John, senior husbandman 598205 598205 Browenyng, John, senior, of Chykwell, husbandman 3
4893521 2324675 2324675 defendant Writtill Robert (legal representative) 598205 598205 Writtill, Robert, of Chykwell, gent, executors of 0
4904284 2327955 2327955 defendant Sayler John husbandman 598205 598205 Sayler, John, of Chykwell, husbandman 0
4958578 2344531 2344531 defendant Taillour William husbandman 598205 598205 Taillour, William, of Chykwell, husbandman 0
4958579 2344531 2344531 defendant Grene Thomas husbandman 598205 598205 Grene, Thomas, of Chykwell, husbandman 1
5161305 2404401 2404401 defendant Turnour John husbandman 598205 598205 Turnour, John, of Chykwell, husbandman 0
5176601 2408841 2408841 defendant Rote William husbandman 598205 598205 Rote, William, of Chykwell, husbandman 0
5308035 2447425 2447425 defendant Hayward Richard husbandman 598205 598205 Hayward, Richard, of Chykwell, husbandman 1
5337629 2456323 2456323 plaintiff Hyll John, senior   598205 598205 Hyll, John, senior, of Chykwell 0
5364967 2464714 2464714 defendant Hill Robert husbandman 598205 598205 Hill, Robert, of Chykwell, husbandman 1
5378362 2468813 2468813 defendant Lee Hugh brewer 598205 598205 Lee, Hugh, of Chykwell, brewer 0
5392105 2472826 2472826 defendant Craye Robert tailor 598205 598205 Craye, Robert, of Chykwell, tailor 0
5407044 2477075 2477075 defendant Broke John husbandman 598205 598205 Broke, John, of Chykwell, husbandman 0
5420225 2480970 2480970 defendant Broke John husbandman 598205 598205 Broke, John, of Chykwell, husbandman 0
5484803 2500377 2500377 defendant Hakthorne John husbandman 598205 598205 Hakthorne, John, of Chykwell, husbandman 0
5506685 2507006 2507006 defendant Jenyn John yeoman 598205 598205 Jenyn, John, of Chykwell, yeoman 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);