names

29 rows where place_id = 594515

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616420 1872770 1872770 defendant Melon Andrew smith 594515 594515 Melon, Andrew, of Stradeshull, smith 2
3616421 1872770 1872770 defendant Melon Nicholas smith 594515 594515 Melon, Nicholas, of Stradeshull, smith 3
3780682 1951688 1951688 defendant Colman Richard shoemaker 594515 594515 Colman, Richard, of Stradeshull, shoemaker 0
3797508 1957113 1957113 defendant Colman Richard shoemaker 594515 594515 Colman, Richard, of Stradeshull, shoemaker 0
4012890 2029338 2029338 defendant Alderton Robert yeoman 594515 594515 Alderton, Robert, of Stradeshull, yeoman 0
4760385 2283602 2283602 defendant at Havery Joan   594515 594515 at Havery, Joan, of Stradeshull 0
4914484 2331050 2331050 defendant Dobyn Stephen husbandman 594515 594515 Dobyn, Stephen, of Stradeshull, husbandman 0
4926497 2334706 2334706 defendant Stanfeld John chaplain 594515 594515 Stanfeld, John, of Stradeshull, chaplain 0
5028187 2365115 2365115 plaintiff Milde Gilberty chaplain 594515 594515 Milde, Gilberty, of Stradeshull, chaplain 0
5028188 2365115 2365115 defendant Seman John chaplain 594515 594515 Seman, John, of Stradeshull, chaplain 0
5028189 2365115 2365115 defendant Seman William yeoman 594515 594515 Seman, William, of Stradeshull, yeoman 1
5082227 2381177 2381177 defendant Trony or Trovy Robert husbandman 594515 594515 Trony or Trovy, Robert, of Stradeshull, husbandman 0
5093364 2384458 2384458 defendant Trony or Trovy Robert husbandman 594515 594515 Trony or Trovy, Robert, of Stradeshull, husbandman 0
5117774 2391632 2391632 defendant Barbour William clerk 594515 594515 Barbour, William, of Stradeshull, clerk 2
5127922 2394643 2394643 defendant Taillor John husbandman 594515 594515 Taillor, John, of Stradeshull, husbandman 1
5228846 2424046 2424046 defendant Parker Edmund yeoman 594515 594515 Parker, Edmund, of Stradeshull, yeoman 2
5228851 2424047 2424047 defendant Parker Edmund yeoman 594515 594515 Parker, Edmund, of Stradeshull, yeoman 2
5274676 2437670 2437670 defendant Blundell John yeoman 594515 594515 Blundell, John, of Stradeshull, yeoman 4
5305784 2446737 2446737 defendant Halle Simon clerk 594515 594515 Halle, Simon, of Stradeshull, clerk 2
5350758 2460347 2460347 defendant Bouley or Bonley alias Parker Edmund yeoman 594515 594515 Bouley or Bonley alias Parker, Edmund, of Stradeshull, yeoman 1
5406620 2476960 2476960 defendant Alfey John yeoman 594515 594515 Alfey, John, of Stradeshull, yeoman 1
5443142 2487861 2487861 plaintiff Brown John   594515 594515 Brown, John, of Stradeshull 0
5454376 2491219 2491219 defendant Smyth Stephen husbandman 594515 594515 Smyth, Stephen, of Stradeshull, husbandman 0
5454377 2491219 2491219 defendant Milon Andrew smith 594515 594515 Milon, Andrew, of Stradeshull, smith 1
5454378 2491219 2491219 defendant Gamelyn John husbandman 594515 594515 Gamelyn, John, of Stradeshull, husbandman 2
5466265 2494850 2494850 defendant Smyth Stephen husbandman 594515 594515 Smyth, Stephen, of Stradeshull, husbandman 0
5466266 2494850 2494850 defendant Melon Andrew smith 594515 594515 Melon, Andrew, of Stradeshull, smith 1
5466267 2494850 2494850 defendant Gamelyn John husbandman 594515 594515 Gamelyn, John, of Stradeshull, husbandman 2
5467700 2495272 2495272 plaintiff Brown John   594515 594515 Brown, John, of Stradeshull 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);