names

60 rows where place_id = 761303

✎ 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
3666717 1915535 1915535 defendant Wode Thomas   761303 761303 Wode, Thomas, of Bergham yeoman 0
4477839 2193736 2193736 defendant Jurden John   761303 761303 Jurden, John, of Bergham 0
4495569 2199296 2199296 defendant Chese John   761303 761303 Chese, John, of Bergham 4
4523014 2207528 2207528 defendant Jurdan John   761303 761303 Jurdan, John, of Bergham 1
4525776 2208365 2208365 defendant Chese John   761303 761303 Chese, John, of Bergham 3
4525781 2208366 2208366 defendant Chese John   761303 761303 Chese, John, of Bergham 3
4544692 2214252 2214252 defendant Fritheby William chaplain 761303 761303 Fritheby, William, of Bergham, chaplain 0
4550630 2216140 2216140 defendant Bette John fuller 761303 761303 Bette, John, of Bergham, fuller 1
4595733 2229919 2229919 defendant Bergham John de   761303 761303 Bergham, John de, of Bergham 0
4611012 2234514 2234514 plaintiff Chesse John   761303 761303 Chesse, John, of Bergham 0
4611014 2234515 2234515 plaintiff Chesse John   761303 761303 Chesse, John, of Bergham 0
4627628 2239572 2239572 defendant Lucas William   761303 761303 Lucas, William, of Bergham 1
4627637 2239575 2239575 defendant Lucas William   761303 761303 Lucas, William, of Bergham 1
4647996 2245481 2245481 defendant Chacer John   761303 761303 Chacer, John, of Bergham, parson 0
4648677 2245667 2245667 defendant del Wode John, sen   761303 761303 del Wode, John, sen, of Bergham 0
4660789 2249197 2249197 defendant Bettys Agnes spinner 761303 761303 Bettys, Agnes, of Bergham, spinner 4
4668861 2255964 2255964 defendant Levessone John yeoman 761303 761303 Levessone, John, of Bergham, yeoman 2
4668867 2255965 2255965 defendant Leversone John yeoman 761303 761303 Leversone, John, of Bergham, yeoman 2
4720937 2271880 2271880 defendant Barkere John yeoman 761303 761303 Barkere, John, of Bergham, yeoman 2
4731885 2275155 2275155 defendant Wodeward Thomas, sen yeoman 761303 761303 Wodeward, Thomas, sen, of Bergham, yeoman 0
4731887 2275155 2275155 defendant Tapir John carpenter 761303 761303 (Tapir, John, of Bergham, carpenter 2
4731889 2275155 2275155 defendant Clerk Edmund yeoman 761303 761303 Clerk, Edmund, of Bergham, yeoman 4
4741875 2278122 2278122 defendant Barkere William yeoman 761303 761303 Barkere, William, of Bergham, yeoman 0
4741876 2278122 2278122 defendant Andymer Walter yeoman 761303 761303 Andymer, Walter, of Bergham, yeoman 1
4741877 2278122 2278122 defendant Jurdon John husbandman 761303 761303 Jurdon, John, of Bergham, husbandman 2
4741878 2278122 2278122 defendant Woode John husbandman 761303 761303 Woode, John, of Bergham, husbandman 3
4741879 2278122 2278122 defendant Wodeward Thomas yeoman 761303 761303 Wodeward, Thomas, of Bergham, yeoman 4
4750263 2280554 2280554 defendant Barkkere William yeoman 761303 761303 Barkkere, William, of Bergham, yeoman 0
4755735 2282177 2282177 defendant Ver Richard butcher 761303 761303 Ver, Richard, of Bergham, butcher 1
4755737 2282177 2282177 defendant Portman John   761303 761303 Portman, John, of Bergham, wright 3
4758342 2282982 2282982 defendant Barker John yeoman 761303 761303 Barker, John, of Bergham, yeoman 3
4764972 2285020 2285020 defendant Barkere William husbandman 761303 761303 Barkere, William, of Bergham, husbandman 3
4776611 2288677 2288677 defendant Whithod John butcher 761303 761303 Whithod, John, of Bergham, butcher 0
4777725 2289026 2289026 defendant Portman John   761303 761303 Portman, John, of Bergham, wright 1
4810510 2299432 2299432 defendant Prat John yeoman 761303 761303 Prat, John, of Bergham, yeoman 1
4912119 2330291 2330291 defendant Bothe Richard gent 761303 761303 Bothe, Richard, of Bergham, gent 2
4937405 2338070 2338070 defendant Jeuet or Jenet Adam husbandman 761303 761303 Jeuet or Jenet, Adam, of Bergham, husbandman 0
4966379 2346875 2346875 defendant Wodeward William husbandman 761303 761303 Wodeward, William, of Bergham, husbandman 1
4966380 2346875 2346875 defendant Ferre John husbandman 761303 761303 Ferre, John, of Bergham, husbandman 2
4985674 2352629 2352629 defendant Bothe Richard esq 761303 761303 Bothe, Richard, of Bergham, esq 3
4993682 2354984 2354984 defendant Smyth Edmund yeoman 761303 761303 Smyth, Edmund, of Bergham, yeoman 0
5008675 2359430 2359430 defendant Hill Geoffrey yeoman 761303 761303 Hill, Geoffrey, of Bergham, yeoman 0
5039821 2368553 2368553 plaintiff Bothe Richard   761303 761303 Bothe, Richard, of Bergham 0
5059488 2374406 2374406 defendant Dexter John chaplain 761303 761303 Dexter, John, of Bergham, chaplain 0
5061591 2375054 2375054 defendant Fuller William clerk 761303 761303 Fuller, William, of Bergham, clerk 0
5098326 2385940 2385940 defendant Feer John husbandman 761303 761303 Feer, John, of Bergham, husbandman 1
5098327 2385940 2385940 defendant Skolys Edmund   761303 761303 Skolys, Edmund, of Bergham, servant 2
5167157 2406129 2406129 plaintiff Cleye Thomas yeoman 761303 761303 Cleye, Thomas, of Bergham, yeoman 0
5214057 2419842 2419842 defendant Westoncroft Henry husbandman 761303 761303 Westoncroft, Henry, of Bergham, husbandman 1
5228937 2424067 2424067 defendant Drynkewater Geoffrey husbandman 761303 761303 Drynkewater, Geoffrey, of Bergham, husbandman 1
5255174 2431733 2431733 defendant Farnham John laborer 761303 761303 Farnham, John, of Bergham, laborer 0
5316438 2449997 2449997 defendant Middelton John yeoman 761303 761303 Middelton, John, of Bergham, yeoman 0
5348086 2459543 2459543 defendant Pratte Richard husbandman 761303 761303 Pratte, Richard, of Bergham, husbandman 1
5548454 2519584 2519584 defendant Grene Alexander yeoman 761303 761303 Grene, Alexander, of Bergham, yeoman 0
5548455 2519584 2519584 defendant Benet John yeoman 761303 761303 Benet, John, of Bergham, yeoman 1
5548458 2519585 2519585 defendant Bothe Philip esq 761303 761303 Bothe, Philip, of Bergham, esq 0
5562449 2523619 2523619 defendant Pykard John husbandman 761303 761303 Pykard, John, of Bergham, husbandman 0
5562450 2523619 2523619 defendant Maunger John husbandman 761303 761303 Maunger, John, of Bergham, husbandman 1
5562850 2523724 2523724 defendant Maungeour John yeoman 761303 761303 Maungeour, John, of Bergham, yeoman 0
5615006 2548486 2548486 defendant Honyes William   761303 761303 Honyes, William, of Bergham 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);