names

46 rows where place_id = 593430

✎ 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
3611790 1871355 1871355 defendant Percy Leo esq 593430 593430 Percy, Leo, of Flyxburgh, esq 0
3611791 1871355 1871355 defendant Kyrkham John husbandman 593430 593430 Kyrkham, John, of Flyxburgh, husbandman 1
3611792 1871355 1871355 defendant Bagshawe John yeoman 593430 593430 Bagshawe, John, of Flyxburgh, yeoman 2
3611793 1871355 1871355 defendant Davy John husbandman 593430 593430 Davy, John, of Flyxburgh, husbandman 3
3611794 1871355 1871355 defendant Wryght Thomas husbandman 593430 593430 Wryght, Thomas, of Flyxburgh, husbandman 4
3611795 1871355 1871355 defendant Hobden Thomas yeoman 593430 593430 Hobden, Thomas, of Flyxburgh, yeoman 5
3611796 1871355 1871355 defendant Rawelyn William husbandman 593430 593430 Rawelyn, William, of Flyxburgh, husbandman 6
3611797 1871355 1871355 defendant Graunger Reginald husbandman 593430 593430 Graunger, Reginald, of Flyxburgh, husbandman 7
3611798 1871355 1871355 defendant Ryplyngham Christopher laborer 593430 593430 Ryplyngham, Christopher, of Flyxburgh, laborer 8
3611799 1871355 1871355 defendant Smyth Roger laborer 593430 593430 Smyth, Roger, of Flyxburgh, laborer 9
3611800 1871355 1871355 defendant Hynghowe George laborer 593430 593430 Hynghowe, George, of Flyxburgh, laborer 10
3611801 1871355 1871355 defendant Crosse William laborer 593430 593430 Crosse, William, of Flyxburgh, laborer 11
3611802 1871355 1871355 defendant Rawelyn Thomas laborer 593430 593430 Rawelyn, Thomas, of Flyxburgh, laborer 12
3611803 1871355 1871355 defendant Marchaunt Thomas laborer 593430 593430 Marchaunt, Thomas, of Flyxburgh, laborer 13
3611804 1871355 1871355 defendant Rypley John husbandman 593430 593430 Rypley, John, of Flyxburgh, husbandman 14
3623435 1874863 1874863 defendant Kyrkham John husbandman 593430 593430 Kyrkham, John, of Flyxburgh, husbandman 0
3623438 1874864 1874864 defendant Kyrkham John husbandman 593430 593430 Kyrkham, John, of Flyxburgh, husbandman 0
4536998 2211839 2211839 defendant Darcy Richard   593430 593430 (Darcy, Richard, of Flyxburgh 5
5376798 2468338 2468338 plaintiff Smyth Christopher yeoman 593430 593430 Smyth, Christopher, of flyxburgh, yeoman 0
5376802 2468339 2468339 plaintiff Smyth Christopher yeoman 593430 593430 Smyth, Christopher, of Flyxburgh, yeoman 0
5376806 2468340 2468340 plaintiff Smyth Christopher yeoman 593430 593430 Smyth, Christopher, of Flyxburgh, yeoman 0
5436879 2485960 2485960 defendant Wright Thomas husbandman 593430 593430 Wright, Thomas, of Flyxburgh, husbandman 0
5436880 2485960 2485960 defendant Ripley John laborer 593430 593430 Ripley, John, of Flyxburgh, laborer 1
5436881 2485960 2485960 defendant Marchand John husbandman 593430 593430 Marchand, John, of Flyxburgh, husbandman 2
5436882 2485960 2485960 defendant Davy John husbandman 593430 593430 Davy, John, of Flyxburgh, husbandman 3
5436883 2485960 2485960 defendant Kyrkeham John fisher 593430 593430 Kyrkeham, John, of Flyxburgh, fisher 4
5436884 2485960 2485960 defendant Dubbyng William fisher 593430 593430 Dubbyng, William, of Flyxburgh, fisher 5
5451478 2490315 2490315 defendant Wryght Thomas husbandman 593430 593430 Wryght, Thomas, of Flyxburgh, husbandman 0
5451479 2490315 2490315 defendant Rypley John laborer 593430 593430 Rypley, John, of Flyxburgh, laborer 1
5451480 2490315 2490315 defendant Richard John husbandman 593430 593430 Richard, John, of Flyxburgh, husbandman 2
5451481 2490315 2490315 defendant Davy John husbandman 593430 593430 Davy, John, of Flyxburgh, husbandman 3
5451482 2490315 2490315 defendant Kyrkham John fisher 593430 593430 Kyrkham, John, of Flyxburgh, fisher 4
5451483 2490315 2490315 defendant Dubbyng William   593430 593430 Dubbyng, William, of Flyxburgh 5
5526863 2512970 2512970 defendant Percy Leo esq 593430 593430 Percy, Leo, of Flyxburgh, esq 0
5558434 2522415 2522415 plaintiff Percy Walter   593430 593430 Percy, Walter, of Flyxburgh 0
5558435 2522415 2522415 plaintiff Hodome George gent 593430 593430 Hodome, George, of Flyxburgh, gent 1
5558440 2522416 2522416 plaintiff Percy William gent 593430 593430 Percy, William, of Flyxburgh, gent 0
5558441 2522416 2522416 plaintiff Hodome George gent 593430 593430 Hodome, George, of Flyxburgh, gent 1
5558447 2522417 2522417 plaintiff Percy William gent 593430 593430 Percy, William, of Flyxburgh, gent 0
5558448 2522417 2522417 plaintiff Hodome George gent 593430 593430 Hodome, George, of Flyxburgh, gent 1
5584256 2530143 2530143 defendant Percy Leonard esq 593430 593430 Percy, Leonard, of Flyxburgh, esq 0
5584257 2530143 2530143 defendant Percy Walter gent 593430 593430 Percy, Walter, of Flyxburgh, gent 1
5594250 2533178 2533178 defendant Percy Leo esq 593430 593430 Percy, Leo, of Flyxburgh, esq 0
5594252 2533179 2533179 defendant Percy Leo esq 593430 593430 Percy, Leo, of Flyxburgh, esq 0
5606844 2537029 2537029 defendant Dubbyng William yeoman 593430 593430 Dubbyng, William, of Flyxburgh, yeoman 0
5606845 2537029 2537029 defendant Dubbyng Robert yeoman 593430 593430 Dubbyng, Robert, of Flyxburgh, 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);