names

33 rows where place_id = 589093

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596513 1866542 1866542 defendant Butler William clerk 589093 589093 Butler, William, of Attylburgh, Norf, clerk 0
3633433 1905269 1905269 defendant Broun John clerk or yeoman 589093 589093 Broun, John, of Attylburgh, Norf, clerk or yeoman 0
3774910 1949883 1949883 defendant Drage Thomas husbandman 589093 589093 Drage, Thomas, of Attylburgh, Norf, husbandman 0
5002289 2357575 2357575 defendant Symond John chapman 589093 589093 Symond, John, of Attylburgh, Norf, chapman 0
5002586 2357668 2357668 defendant Symond John chapman 589093 589093 Symond, John, of Attylburgh, Norf, chapman 0
5023654 2363826 2363826 defendant Brampton Thomas esq 589093 589093 Brampton, Thomas, of Attylburgh, Norf, esq 0
5023659 2363827 2363827 defendant Brampton Thomas esq 589093 589093 Brampton, Thomas, of Attylburgh, Norf, esq 0
5033596 2366712 2366712 defendant Waryn Thomas pedder 589093 589093 Waryn, Thomas, of Attylburgh, Norf, pedder 0
5044426 2369962 2369962 defendant Brampton Thomas esq 589093 589093 Brampton, Thomas, of Attylburgh, Norf, esq 0
5062224 2375261 2375261 defendant Brampton Thomas esq 589093 589093 Brampton, Thomas, of Attylburgh, Norf, esq 0
5256774 2432241 2432241 defendant Hille Robert husbandman or single man 589093 589093 Hille, Robert, of Attylburgh, Norf, husbandman or single man 0
5283573 2440248 2440248 defendant Radclyf Roger (legal representative) 589093 589093 Radclyf, Roger, of Attylburgh, Norf, executors of 0
5310880 2448287 2448287 defendant Dernford John yeoman 589093 589093 Dernford, John, of Attylburgh, Norf, yeoman 1
5348230 2459593 2459593 plaintiff Brampton John (legal representative) 589093 589093 Brampton, John, of Attylburgh, Norf, gent, administrator of 0
5351099 2460450 2460450 defendant Brampton Thomas gent 589093 589093 Brampton, Thomas, of Attylburgh, Norf, gent 0
5359727 2463081 2463081 defendant Radclyffe James gent 589093 589093 Radclyffe, James, of Attylburgh, Norf, gent 1
5373872 2467425 2467425 defendant Stratton Richard yeoman 589093 589093 Stratton, Richard, of Attylburgh, Norf, yeoman 0
5373874 2467426 2467426 defendant Stratton Richard yeoman 589093 589093 Stratton, Richard, of Attylburgh, Norf, yeoman 0
5384512 2470653 2470653 defendant Thurkell Richard   589093 589093 Thurkell, Richard, of Attylburgh, Norf, pedlar 2
5395564 2473810 2473810 defendant Warner John gent 589093 589093 Warner, John, of Attylburgh, Norf, gent 3
5396357 2474050 2474050 defendant Turkell William   589093 589093 Turkell, William, of Attylburgh, Norf, pedlar 2
5409662 2477861 2477861 defendant Thurton William   589093 589093 Thurton, William, of Attylburgh, Norf, pedlar 2
5423253 2481919 2481919 defendant Thurton William   589093 589093 Thurton, William, of Attylburgh, Norf, pedlar 2
5444726 2488320 2488320 defendant S_ Richard yeoman 589093 589093 S_, Richard, of Attylburgh, Norf, yeoman 1
5446868 2488958 2488958 defendant Caune or Caime Bartholomew yeoman 589093 589093 Caune or Caime, Bartholomew, of Attylburgh, Norf, yeoman 0
5463779 2494083 2494083 defendant Stracton Richard yeoman 589093 589093 Stracton, Richard, of Attylburgh, Norf, yeoman 1
5463786 2494084 2494084 defendant Stratton Richard yeoman 589093 589093 Stratton, Richard, of Attylburgh, Norf, yeoman 1
5482307 2499652 2499652 defendant Canne Bartholmew butcher 589093 589093 Canne, Bartholmew, of Attylburgh, Norf, butcher 0
5482311 2499653 2499653 defendant Canne Bartholomew yeoman 589093 589093 Canne, Bartholomew, of Attylburgh, Norf, yeoman 0
5482317 2499654 2499654 defendant Canne Bartholomew yeoman 589093 589093 Canne, Bartholomew, of Attylburgh, Norf, yeoman 1
5482325 2499655 2499655 defendant Canne Bartholomew yeoman 589093 589093 Canne, Bartholomew, of Attylburgh, Norf, yeoman 1
5486918 2500984 2500984 defendant Stratton Richard yeoman 589093 589093 Stratton, Richard, of Attylburgh, Norf, yeoman 1
5595639 2533559 2533559 defendant Ratclyff Robert   589093 589093 Ratclyff, Robert, of Attylburgh, Norf, Lord FytzWater, knight 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);