names

34 rows where place_id = 592200

✎ 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
3606909 1869825 1869825 defendant Wryght Robert husbandman 592200 592200 Wryght, Robert, of Aslakton, husbandman 1
3639749 1907241 1907241 defendant Carnemere John gent 592200 592200 Carnemere, John, of Aslakton, gent 0
3709270 1929198 1929198 defendant Wright John husbandman 592200 592200 Wright, John, of Aslakton, husbandman 0
3802669 1958730 1958730 defendant Jekkys John (legal representative) 592200 592200 Jekkys, John, of Aslakton, yeoman, executor of 0
3802670 1958730 1958730 defendant Jekkys Nicholas husbandman 592200 592200 Jekkys, Nicholas, of Aslakton, husbandman 1
3898224 1989614 1989614 defendant Wryght Thomas yeoman 592200 592200 Wryght, Thomas, of Aslakton, yeoman 0
3908588 1993170 1993170 defendant Turnour Thomas glover 592200 592200 Turnour, Thomas, of Aslakton, glover 1
4456100 2186932 2186932 defendant Birton Robert de   592200 592200 Birton, Robert de, of Aslakton 0
4456608 2187089 2187089 plaintiff Nycoll John   592200 592200 Nycoll, John, of Aslakton 0
4456610 2187089 2187089 defendant Buirton Robert de   592200 592200 Buirton, Robert de, of Aslakton 0
4603668 2232334 2232334 defendant Hernyng William   592200 592200 Hernyng, William, of Aslakton 0
4733439 2275634 2275634 defendant Ropere Robert chaplain 592200 592200 Ropere, Robert, of Aslakton, chaplain 0
4800682 2296395 2296395 defendant Barune William husbandman 592200 592200 Barune, William, of Aslakton, husbandman 0
4830590 2305589 2305589 defendant White John husbandman 592200 592200 White, John, of Aslakton, husbandman 0
4871189 2317966 2317966 defendant Heed John husbandman 592200 592200 Heed, John, of Aslakton, husbandman 0
5102400 2387106 2387106 defendant Bolytout John yeoman 592200 592200 Bolytout, John, of Aslakton, yeoman 0
5115766 2391039 2391039 defendant Bolytonte John yeoman 592200 592200 Bolytonte, John,of Aslakton, yeoman 5
5115768 2391039 2391039 defendant Clopton William husbandman 592200 592200 Clopton, William, of Aslakton, husbandman 7
5213374 2419641 2419641 plaintiff Bole John   592200 592200 Bole, John, of Aslakton 0
5226710 2423478 2423478 defendant Bole Alice widow 592200 592200 Bole, Alice, of Aslakton, widow 0
5248248 2429621 2429621 defendant Taylour Walter husbandman 592200 592200 Taylour, Walter, of Aslakton, husbandman 4
5266462 2435258 2435258 defendant Bolytout John husbandman 592200 592200 Bolytout, John, of Aslakton, husbandman 0
5268602 2435937 2435937 plaintiff Bolytowe John   592200 592200 Bolytowe, John, of Aslakton 0
5268606 2435937 2435937 defendant Colman Walter husbandman 592200 592200 Colman, Walter, of Aslakton, husbandman 3
5278914 2438946 2438946 plaintiff Bolytowte John   592200 592200 Bolytowte, John, of Aslakton 0
5278917 2438946 2438946 defendant Colman Walter husbandman 592200 592200 Colman, Walter, of Aslakton, husbandman 2
5279241 2439028 2439028 defendant Bolytout or Bolytont William yeoman 592200 592200 Bolytout or Bolytont, William, of Aslakton, yeoman 1
5283121 2440124 2440124 defendant Flawner John husbandman 592200 592200 Flawner, John, of Aslakton, husbandman 0
5347001 2459220 2459220 defendant Randolf John husbandman 592200 592200 Randolf, John, of Aslakton, husbandman 0
5413324 2478917 2478917 defendant Bolytout Walter husbandman 592200 592200 Bolytout, Walter, of Aslakton, husbandman 1
5428526 2483459 2483459 defendant Bolitout Walter husbandman 592200 592200 Bolitout, Walter, of Aslakton, husbandman 1
5428563 2483467 2483467 defendant Bolitout Walter husbandman 592200 592200 Bolitout, Walter, of Aslakton, husbandman 1
5514293 2509321 2509321 defendant Randolf John yeoman 592200 592200 Randolf, John, of Aslakton, yeoman 0
5600734 2535116 2535116 defendant Crane John yeoman 592200 592200 Crane, John, of Aslakton, yeoman 0

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);