names

34 rows where place_id = 608348

✎ 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
3673282 1917659 1917659 defendant Barrett Henry husbandman 608348 608348 Barrett, Henry, of Marche, Cams, husbandman 1
3677797 1919106 1919106 defendant Wylkylworth John yeoman 608348 608348 Wylkylworth, John, of Marche, Cams, yeoman 0
3789583 1954569 1954569 defendant Stone Richard husbandman 608348 608348 Stone, Richard, of Marche, Cams, husbandman 3
3790171 1954745 1954745 defendant Walbot William, junior yeoman 608348 608348 Walbot, William, junior, of Marche, Cams, yeoman 0
3804475 1959340 1959340 defendant Sheppard William yeoman 608348 608348 Sheppard, William, of Marche, Cams, yeoman 0
3804479 1959341 1959341 defendant Shepperd William yeoman 608348 608348 Shepperd, William, of Marche, Cams, yeoman 0
3804483 1959342 1959342 defendant Walbot William, junior yeoman 608348 608348 Walbot, William, junior, of Marche, Cams, yeoman 0
3821941 1964755 1964755 defendant Walbott William, junior yeoman 608348 608348 Walbott, William, junior, of Marche, Cams, yeoman 0
3835807 1969122 1969122 defendant Hansart Anthony esq 608348 608348 Hansart, Anthony, of Marche, Cams, esq 0
3871380 1980677 1980677 defendant Smartethwayte Thomas yeoman 608348 608348 Smartethwayte, Thomas, of Marche, Cams, yeoman 2
3987706 2020352 2020352 defendant Hasell George gent 608348 608348 Hasell, George, of Marche, Cams, gent 0
3997126 2023740 2023740 defendant Hasyll George gent 608348 608348 Hasyll, George, of Marche, Cams, or of Witton, Hunts, gent 1
4005608 2026782 2026782 defendant Fage John yeoman 608348 608348 Fage, John, of Marche, Cams, yeoman 1
4037079 2037925 2037925 defendant Haysill George gent 608348 608348 Haysill, George, of Marche, Cams, gent 2
4037095 2037930 2037930 defendant Haysyll George gent 608348 608348 Haysyll, George, of Marche, Cams, gent 2
4061261 2046434 2046434 defendant Fadye or Fadge William yeoman 608348 608348 Fadye or Fadge, William, of Marche, Cams, yeoman 0
4203980 2096944 2096944 defendant Damport William beer brewer 608348 608348 Damport, William, of Marche, Cams, beer brewer 0
4783017 2290707 2290707 defendant Thetford William yeoman 608348 608348 Thetford, William, of Marche, Cams, yeoman 0
4953350 2342966 2342966 defendant Bonyng Simon butcher 608348 608348 Bonyng, Simon, of Marche, Cams, butcher 1
4979444 2350808 2350808 defendant Payn William yeoman 608348 608348 Payn, William, of Marche, Cams, yeoman 0
5099184 2386185 2386185 defendant Mathue William husbandman 608348 608348 Mathue, William, of Marche, Cams, husbandman 1
5238407 2426821 2426821 defendant Bonyng Simon husbandman 608348 608348 Bonyng, Simon, of Marche, Cams, husbandman 0
5262589 2434043 2434043 defendant Mathewe William, senior (legal representative) 608348 608348 Mathewe, William, senior, of Marche, Cams, executors of 0
5281296 2439603 2439603 plaintiff Colvyle John esq 608348 608348 Colvyle, John, of Marche, Cams, esq 1
5350631 2460311 2460311 defendant Baret John   608348 608348 Baret, John, of Marche, Cams, pike monger or husbandman 0
5483658 2500064 2500064 defendant Walbot William brewer 608348 608348 Walbot, William, of Marche, Cams, brewer 0
5483660 2500065 2500065 defendant Walbot William brewer 608348 608348 Walbot, William, of Marche, Cams, brewer 0
5483662 2500066 2500066 defendant Walbot William brewer 608348 608348 Walbot, William, of Marche, Cams, brewer 0
5497098 2504070 2504070 defendant Walbot William brewer 608348 608348 Walbot, William, of Marche, Cams, brewer 0
5512266 2508697 2508697 defendant Baret John husbandman 608348 608348 Baret, John, of Marche, Cams, husbandman 4
5516341 2509944 2509944 defendant Walbot William mercer 608348 608348 Walbot, William, of Marche, Cams, mercer 4
5560239 2522957 2522957 defendant Walbot William gent 608348 608348 Walbot, William, of Marche, Cams, gent 3
5567159 2524974 2524974 defendant Coward John laborer 608348 608348 Coward, John, of Marche, Cams, laborer 2
5570157 2525845 2525845 defendant Walbot William, senior brewer 608348 608348 Walbot, William, senior, of Marche, Cams, brewer 1

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