names

40 rows where place_id = 587094

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590446 1864657 1864657 plaintiff Cottusmore John esq 587094 587094 Cottusmore, John, of Bryghtwell, esq 0
3590448 1864658 1864658 plaintiff Cottusmore John esq 587094 587094 Cottusmore, John, of Bryghtwell, esq 0
3597231 1866758 1866758 defendant Dolfyn Richard yeoman 587094 587094 Dolfyn, Richard, of Bryghtwell, yeoman 1
3624822 1875299 1875299 defendant Wulf Thomas husbandman 587094 587094 Wulf, Thomas, of Bryghtwell, husbandman 2
3641890 1907917 1907917 defendant Brownyng John husbandman 587094 587094 Brownyng, John, of Bryghtwell, husbandman 0
3642566 1908117 1908117 defendant Gawen John weaver 587094 587094 Gawen, John, of Bryghtwell, weaver 1
3668218 1916007 1916007 defendant Gryffyn William clerk 587094 587094 Gryffyn, William, of Bryghtwell, clerk 0
3668220 1916007 1916007 defendant Tusshe Richard yeoman 587094 587094 Tusshe, Richard, of Bryghtwell, yeoman 2
3668221 1916007 1916007 defendant Sywhat William husbandman 587094 587094 Sywhat, William, of Bryghtwell, husbandman 3
3668223 1916007 1916007 defendant Furston Simon husbandman 587094 587094 Furston, Simon, of Bryghtwell, husbandman 5
3703719 1927444 1927444 plaintiff Draper Richard yeoman 587094 587094 Draper, Richard, of Bryghtwell, yeoman 0
3703721 1927445 1927445 plaintiff Draper Richard yeoman 587094 587094 Draper, Richard, of Bryghtwell, yeoman 0
3718175 1931969 1931969 defendant Cottysmore William (legal representative) 587094 587094 Cottysmore, William, of Bryghtwell, gent, executors of 0
3867885 1979492 1979492 defendant Nevyle Thomas esq 587094 587094 Nevyle, Thomas, of Bryghtwell, esq 0
3886076 1985593 1985593 defendant Seywyn William husbandman 587094 587094 Seywyn, William, of Bryghtwell, husbandman 5
3887888 1986197 1986197 defendant Batell Robert fuller 587094 587094 Batell, Robert, of Bryghtwell, fuller 3
3975290 2015927 2015927 defendant Jermy Francis esq 587094 587094 Jermy, Francis, of Bryghtwell, esq 0
3975291 2015927 2015927 defendant Jermy John gent 587094 587094 Jermy, John, of Bryghtwell, gent 1
4029284 2035117 2035117 defendant Heade Roger husbandman 587094 587094 Heade, Roger, of Bryghtwell, husbandman 1
4603915 2232402 2232402 defendant Arnold Thomas   587094 587094 Arnold, Thomas, of Bryghtwell 0
4653488 2247023 2247023 defendant Mothirby William gent 587094 587094 Mothirby, William, of Bryghtwell, gent 0
4804940 2297749 2297749 defendant Smale John laborer 587094 587094 Smale, John, of Bryghtwell, laborer 0
4912090 2330284 2330284 defendant Lampet Margaret widow & formerly wife of William Lampet 587094 587094 Lampet, Margaret, of Bryghtwell, widow & formerly wife of William Lampet 0
4937641 2338148 2338148 defendant Lampet Margaret   587094 587094 Lampet, Margaret, of Bryghtwell, widow of Lampet, William 0
5148445 2400676 2400676 plaintiff Crosseby John   587094 587094 Crosseby, John, of Bryghtwell, parson 0
5148451 2400676 2400676 defendant Somer William (legal representative) 587094 587094 Somer, William, of Bryghtwell, executrix of 5
5167724 2406278 2406278 plaintiff Crosseby John   587094 587094 Crosseby, John, of Bryghtwell, parson 0
5167726 2406278 2406278 defendant Smyth William husbandman 587094 587094 Smyth, William, of Bryghtwell, husbandman 1
5167727 2406278 2406278 defendant Drewe John husbandman 587094 587094 Drewe, John, of Bryghtwell, husbandman 2
5167728 2406278 2406278 defendant Alnot Henry husbandman 587094 587094 Alnot, Henry, of Bryghtwell, husbandman 3
5167732 2406278 2406278 defendant Rose Edmund husbandman 587094 587094 (Rose, Edmund, of Bryghtwell, husbandman 7
5485609 2500600 2500600 defendant Trusse Geoffrey husbandman 587094 587094 Trusse, Geoffrey, of Bryghtwell, husbandman 0
5485610 2500600 2500600 defendant Wulff Thomas husbandman 587094 587094 Wulff, Thomas, of Bryghtwell, husbandman 1
5539434 2516822 2516822 defendant Draper Simon husbandman 587094 587094 Draper, Simon, of Bryghtwell, husbandman 0
5543945 2518217 2518217 defendant Jacob Edmund husbandman 587094 587094 Jacob, Edmund, of Bryghtwell, husbandman 0
5543946 2518217 2518217 defendant Rose Edmund husbandman 587094 587094 Rose, Edmund, of Bryghtwell, husbandman 1
5560411 2523004 2523004 defendant Broke Thomas gent 587094 587094 Broke, Thomas, of Bryghtwell, gent 0
5626457 2552246 2552246 defendant Arnold Thomas husbandman 587094 587094 Arnold, Thomas, of Bryghtwell, husbandman 0
5626458 2552246 2552246 defendant Chilbury Thomas   587094 587094 Chilbury, Thomas, of Bryghtwell, parish clerk 1
5626459 2552246 2552246 defendant Co- John thresher 587094 587094 Co-, John, of Bryghtwell, thresher 2

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