names

41 rows where place_id = 608612

✎ 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
3674482 1918068 1918068 defendant Bedyngfeld Philip gent 608612 608612 Bedyngfeld, Philip, of Yaxlee, gent 0
3684197 1921194 1921194 defendant Yaxlee Richard gent 608612 608612 Yaxlee, Richard, of Yaxlee, gent 0
3695483 1924810 1924810 defendant Kene Thomas yeoman 608612 608612 Kene, Thomas, of Yaxlee, yeoman 0
3695485 1924811 1924811 defendant Kene Thomas yeoman 608612 608612 Kene, Thomas, of Yaxlee, yeoman 0
3699366 1926021 1926021 defendant Yaxlee Richard gent 608612 608612 Yaxlee, Richard, of Yaxlee, gent 0
3700737 1926483 1926483 defendant Wrenne Margaret widow 608612 608612 Wrenne, Margaret, of Yaxlee, widow 0
3700738 1926483 1926483 defendant Wrenne Katherine spinster 608612 608612 Wrenne, Katherine, of Yaxlee, spinster 1
3704923 1927831 1927831 defendant Bedyngfeld Philip gent 608612 608612 Bedyngfeld, Philip, of Yaxlee, gent 0
3710445 1929585 1929585 defendant Wrenne Margaret widow 608612 608612 Wrenne, Margaret, of Yaxlee, widow 0
3725068 1934127 1934127 defendant Wrenne Margaret widow 608612 608612 Wrenne, Margaret, of Yaxlee, widow 0
3753422 1943009 1943009 defendant Denny John husbandman 608612 608612 Denny, John, of Yaxlee, husbandman 2
3758508 1944658 1944658 defendant Wrenne Thomas husbandman 608612 608612 Wrenne, Thomas, of Yaxlee, husbandman 0
3772666 1949143 1949143 defendant Bedyngfeld Philip gent 608612 608612 Bedyngfeld, Philip, of Yaxlee, gent 0
3804332 1959291 1959291 defendant Wrenne Margarett widow 608612 608612 Wrenne, Margarett, of Yaxlee, widow 0
3824154 1965431 1965431 defendant Bedyngfeld Philip gent 608612 608612 Bedyngfeld, Philip, of Yaxlee, gent 0
3854606 1975085 1975085 plaintiff Sherman Thomas   608612 608612 Sherman, Thomas, of Yaxlee 1
3867702 1979434 1979434 defendant Felgate John gent 608612 608612 Felgate, John, of Yaxlee, gent 0
3867704 1979435 1979435 defendant Felgate John gent 608612 608612 Felgate, John, of Yaxlee, gent 0
3867705 1979436 1979436 plaintiff Sherman Thomas   608612 608612 Sherman, Thomas, of Yaxlee 0
3883797 1984848 1984848 defendant Crowe John yeoman 608612 608612 Crowe, John, of Yaxlee, yeoman 1
3888708 1986480 1986480 defendant Felgate John (legal representative) 608612 608612 Felgate, John, of Yaxlee, gent, executors of 0
3893909 1988186 1988186 defendant Yaxlee Richard gent 608612 608612 Yaxlee, Richard, of Yaxlee, gent 0
3901418 1990698 1990698 defendant Warde Geffrey yeoman 608612 608612 Warde, Geffrey, of Yaxlee, yeoman 0
3920703 1997272 1997272 defendant Newport John yeoman 608612 608612 Newport, John, of Yaxlee, yeoman 0
3920705 1997273 1997273 defendant Newport John yeoman 608612 608612 Newport, John, of Yaxlee, yeoman 0
3920706 1997273 1997273 defendant Newport William yeoman 608612 608612 Newport, William, of Yaxlee, yeoman 1
3959376 2010361 2010361 plaintiff Sherman Thomas   608612 608612 Sherman, Thomas, of Yaxlee 1
4277824 2122169 2122169 defendant Norman John yeoman 608612 608612 Norman, John, of Yaxlee, yeoman 2
5147445 2400400 2400400 plaintiff Clerlems Richard   608612 608612 Clerlems, Richard, of Yaxlee 0
5345906 2458852 2458852 plaintiff Blowegate Richard   608612 608612 Blowegate, Richard, of Yaxlee 1
5388883 2471884 2471884 plaintiff Herberd Thomas (legal representative) 608612 608612 Herberd, Thomas, of Yaxlee, executors of 0
5388885 2471884 2471884 defendant Dade (illegible) yeoman 608612 608612 Dade, _, of Yaxlee, yeoman 0
5388886 2471885 2471885 plaintiff Herberd Thomas (legal representative) 608612 608612 Herberd, Thomas, of Yaxlee, executors of 0
5388889 2471885 2471885 defendant Dade Robert yeoman 608612 608612 Dade, Robert, of Yaxlee, yeoman 0
5401541 2475511 2475511 plaintiff Herberd Thomas (legal representative) 608612 608612 Herberd, Thomas, of Yaxlee, executors of 0
5401543 2475511 2475511 defendant Dade Robert yeoman 608612 608612 Dade, Robert, of Yaxlee, yeoman 0
5401544 2475512 2475512 plaintiff Herberd Thomas (legal representative) 608612 608612 Herberd, Thomas, of Yaxlee, executors of 0
5401547 2475512 2475512 defendant Dade Robert yeoman 608612 608612 Dade, Robert, of Yaxlee, yeoman 0
5514765 2509459 2509459 defendant Reyner Robert yeoman 608612 608612 Reyner, Robert, of Yaxlee, yeoman 0
5599584 2534760 2534760 defendant Hanorth or Havorth John husbandman 608612 608612 Hanorth or Havorth, John, of Yaxlee, husbandman 3
5599586 2534760 2534760 defendant Catton William laborer 608612 608612 Catton, William, of Yaxlee, laborer 5

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