names

54 rows where place_id = 587714

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592199 1865177 1865177 defendant Parker James   587714 587714 Parker, James, of Assheberton, groom 3
3592200 1865177 1865177 defendant Arkysworthy Walter husbandman 587714 587714 Arkysworthy, Walter, of Assheberton, husbandman 4
3601467 1868113 1868113 defendant Cole William, senior husbandman 587714 587714 Cole, William, senior, of Assheberton, husbandman 0
3607001 1869854 1869854 defendant Benyshyll or Bevyshyll John (legal representative) 587714 587714 Benyshyll or Bevyshyll, John, of Assheberton, baker, executor of 0
3607002 1869854 1869854 defendant Benyshyll Richard baker 587714 587714 Benyshyll, Richard, of Assheberton, baker 1
3673769 1917824 1917824 plaintiff Ford John   587714 587714 Ford, John, of Assheberton 0
3673770 1917824 1917824 defendant Brendon William   587714 587714 Brendon, William, of Assheberton, tanner, son of Brendon, William 0
3682150 1920524 1920524 defendant Southe William tanner 587714 587714 Southe, William, of Assheberton, tanner 1
3689809 1922969 1922969 defendant Nowcombe Richard husbandman 587714 587714 Nowcombe, Richard, of Assheberton, husbandman 0
3689810 1922969 1922969 defendant Devyll Richard husbandman 587714 587714 Devyll, Richard, of Assheberton, husbandman 1
3718286 1932003 1932003 defendant Southe William tanner 587714 587714 Southe, William, of Assheberton, tanner 2
3723823 1933728 1933728 defendant Predyaux John tanner 587714 587714 Predyaux, John, of Assheberton, tanner 0
3731451 1936063 1936063 defendant Predyaux John tanner 587714 587714 Predyaux, John, of Assheberton, tanner 0
3733250 1936633 1936633 defendant Farre Thomas husbandman 587714 587714 Farre, Thomas, of Assheberton, husbandman 0
3733714 1936792 1936792 defendant Brygge John smith 587714 587714 Brygge, John, of Assheberton, smith 0
3733951 1936867 1936867 defendant Pykett John merchant 587714 587714 Pykett, John, of Assheberton, merchant 0
3733955 1936868 1936868 defendant Southe William tanner 587714 587714 Southe, William, of Assheberton, tanner 2
3733960 1936869 1936869 defendant Debyll Richard butcher 587714 587714 Debyll, Richard, of Assheberton, butcher 3
3733969 1936872 1936872 defendant Hartbery William tanner 587714 587714 Hartbery, William, of Assheberton, tanner 0
3736268 1937583 1937583 defendant Pykett John merchant 587714 587714 Pykett, John, of Assheberton, merchant 2
3736873 1937786 1937786 defendant Mathewe or Marthewe William tanner 587714 587714 Mathewe or Marthewe, William, of Assheberton, tanner 0
3742260 1939450 1939450 defendant Predyaux John husbandman 587714 587714 Predyaux, John, of Assheberton, husbandman 0
3880524 1983743 1983743 defendant Bylford Alexander lathemaker 587714 587714 Bylford, Alexander, of Assheberton, lathemaker 0
3885951 1985556 1985556 defendant Waren Christopher husbandman 587714 587714 Waren, Christopher, of Assheberton, husbandman 0
3885952 1985556 1985556 defendant Geffrey William butcher 587714 587714 Geffrey, William, of Assheberton, butcher 1
3885953 1985556 1985556 defendant Nicoll William fletcher 587714 587714 Nicoll, William, of Assheberton, fletcher 2
3902906 1991204 1991204 plaintiff Forde John (legal representative) 587714 587714 Forde, John, of Assheberton, esq, executors of 0
3902911 1991205 1991205 plaintiff Forde John (legal representative) 587714 587714 Forde, John, of Assheberton, esq, executors of 0
3902916 1991206 1991206 plaintiff Forde John (legal representative) 587714 587714 Forde, John, of Assheberton, esq, executors of 0
3902920 1991207 1991207 plaintiff Forde John (legal representative) 587714 587714 Forde, John, of Assheberton, gent, executors of 0
4972829 2348812 2348812 defendant Hlagwell William husbandman 587714 587714 Hlagwell, William, of Assheberton, husbandman 0
4972830 2348812 2348812 defendant Pette Henry weaver 587714 587714 Pette, Henry, of Assheberton, weaver 1
4972831 2348812 2348812 defendant Trelosek Thomas smith 587714 587714 Trelosek, Thomas, of Assheberton, smith 2
4972832 2348812 2348812 defendant Brounynge William hosier 587714 587714 Brounynge, William, of Assheberton, hosier 3
4972833 2348812 2348812 defendant Heyward John tanner 587714 587714 Heyward, John, of Assheberton, tanner 4
4972834 2348812 2348812 defendant Tancrete Thomas painter 587714 587714 Tancrete, Thomas, of Assheberton, painter 5
5198358 2415270 2415270 defendant Marshewyll John yeoman 587714 587714 Marshewyll, John, of Assheberton, yeoman 0
5249527 2429977 2429977 defendant Ferrer John osteler 587714 587714 Ferrer, John, of Assheberton, osteler 0
5249528 2429977 2429977 defendant Betty John dyer 587714 587714 Betty, John, of Assheberton, dyer, Jenyn, John, of Shirborn, Dorset, dyer 1
5257763 2432549 2432549 defendant Bette John dyer 587714 587714 Bette, John, of Assheberton, dyer 0
5289862 2442044 2442044 defendant Issell Roger hooper 587714 587714 Issell, Roger, of Assheberton, hooper 0
5334982 2455531 2455531 defendant Colpleston or Copleston John husbandman 587714 587714 Colpleston or Copleston, John, of Assheberton, husbandman 0
5356607 2462137 2462137 defendant Leche William, junior yeoman 587714 587714 Leche, William, junior, of Assheberton, yeoman 0
5362540 2463933 2463933 defendant South John btrasier 587714 587714 South, John, of Assheberton, btrasier 2
5389718 2472123 2472123 defendant Carpenter Walter butcher 587714 587714 Carpenter, Walter, of Assheberton, butcher 0
5458508 2492438 2492438 defendant Carpenter Walter husbandman 587714 587714 Carpenter, Walter, of Assheberton, husbandman 0
5490512 2502055 2502055 defendant Keys Alvered merchant 587714 587714 Keys, Alvered, of Assheberton, merchant 0
5491920 2502493 2502493 defendant Carpenter Richard yeoman 587714 587714 Carpenter, Richard, of Assheberton, yeoman 0
5525898 2512691 2512691 defendant Dybbell John butcher 587714 587714 Dybbell, John, of Assheberton, butcher 0
5525899 2512691 2512691 defendant Carpynter Thomas butcher 587714 587714 Carpynter, Thomas, of Assheberton, butcher 1
5568446 2525320 2525320 defendant Whyte William weaver 587714 587714 Whyte, William, of Assheberton, weaver 1
5568453 2525321 2525321 defendant Whyte William weaver 587714 587714 Whyte, William, of Assheberton, weaver 1
5590079 2531880 2531880 defendant Farre Thomas yeoman 587714 587714 Farre, Thomas, of Assheberton, yeoman 0
5595192 2533459 2533459 defendant Emet Richard smith 587714 587714 Emet, Richard, of Assheberton, smith 6

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