names

38 rows where place_id = 600833

✎ 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
3642755 1908182 1908182 defendant Berege Hugh husbandman 600833 600833 Berege, Hugh, of Elston, husbandman 1
3658259 1912838 1912838 defendant Fader Richard husbandman 600833 600833 Fader, Richard, of Elston, husbandman 0
3658261 1912839 1912839 defendant Fader Richard husbandman 600833 600833 Fader, Richard, of Elston, husbandman 0
3893541 1988065 1988065 defendant Fage Roger husbandman 600833 600833 Fage, Roger, of Elston, husbandman 3
3916524 1995902 1995902 defendant Moterham Richard laborer 600833 600833 Moterham, Richard, of Elston, laborer 1
3916525 1995902 1995902 defendant Lyddysdale William laborer 600833 600833 Lyddysdale, William, of Elston, laborer 2
3926823 1999306 1999306 defendant Butler Thomas gent 600833 600833 Butler, Thomas, of Elston, gent 0
3933637 2001538 2001538 plaintiff Gyll Richard yeoman 600833 600833 Gyll, Richard, of Elston, yeoman 0
4073524 2050816 2050816 defendant Jackson Robert laborer 600833 600833 Jackson, Robert, of Elston, laborer 0
4109438 2063637 2063637 defendant Bossewell William husbandman 600833 600833 Bossewell, William, of Elston, husbandman 0
4109439 2063637 2063637 defendant Gamble William husbandman 600833 600833 Gamble, William, of Elston, husbandman 1
4175168 2086776 2086776 defendant Colman Makeleus yeoman 600833 600833 Colman, Makeleus, of Elston, yeoman 0
4199070 2095230 2095230 defendant Gregson William husbandman 600833 600833 Gregson, William, of Elston, husbandman 1
4210514 2099232 2099232 defendant Swyfte Avered or Avery yeoman 600833 600833 Swyfte, Avered or Avery, of Elston, yeoman 0
4471552 2191763 2191763 defendant Pope John   600833 600833 Pope, John, of Elston 4
4507415 2202784 2202784 defendant Decon Thomas   600833 600833 Decon, Thomas, of Elston 1
4507416 2202784 2202784 defendant Bakster Simon   600833 600833 Bakster, Simon, of Elston 2
4507417 2202784 2202784 defendant Potter Hugh   600833 600833 Potter, Hugh, of Elston 3
4677146 2258468 2258468 defendant Chapman William husbandman 600833 600833 Chapman, William, of Elston, husbandman 2
4881397 2321080 2321080 defendant Ossyngton William husbandman 600833 600833 Ossyngton, William, of Elston, husbandman 1
4990550 2354080 2354080 defendant Boner John husbandman 600833 600833 Boner, John, of Elston, husbandman 2
4999514 2356729 2356729 defendant Daddesley John yeoman 600833 600833 Daddesley, John, of Elston, yeoman 0
5014882 2361231 2361231 defendant Chamberleyn Thomas yeoman 600833 600833 Chamberleyn, Thomas, of Elston, yeoman 3
5119087 2392021 2392021 defendant Compton John esq 600833 600833 Compton, John, of Elston, esq 4
5119088 2392021 2392021 defendant Thorpp David yeoman 600833 600833 Thorpp, David, of Elston, yeoman 5
5240416 2427409 2427409 defendant Thorp David yeoman 600833 600833 Thorp, David, of Elston, yeoman 0
5257600 2432496 2432496 defendant Burges Nicholas husbandman 600833 600833 Burges, Nicholas, of Elston, husbandman 0
5257603 2432497 2432497 defendant Burges Nicholas husbandman 600833 600833 Burges, Nicholas, of Elston, husbandman 0
5272250 2436957 2436957 defendant Hylborn Eleanor widow 600833 600833 Hylborn, Eleanor, of Elston, widow 3
5302607 2445752 2445752 defendant Donnes Arnold yeoman 600833 600833 together with Donnes, Arnold, of Elston, yeoman 1
5317622 2450357 2450357 defendant Dounes Arnold yeoman 600833 600833 together with Dounes, Arnold, of Elston, yeoman 1
5339630 2456968 2456968 defendant Heydon Richard laborer 600833 600833 Heydon, Richard, of Elston, laborer 0
5339631 2456968 2456968 defendant Heydon Nicholas laborer 600833 600833 Heydon, Nicholas, of Elston, laborer 1
5446323 2488794 2488794 defendant Julian John   600833 600833 Julian, John, of Elston 1
5458961 2492575 2492575 defendant Julian Robert husbandman 600833 600833 Julian, Robert, of Elston, husbandman 0
5458962 2492575 2492575 defendant Julian John husbandman 600833 600833 Julian, John, of Elston, husbandman 1
5458965 2492576 2492576 defendant Julian Robert husbandman 600833 600833 Julian, Robert, of Elston, husbandman 0
5573561 2526832 2526832 defendant Alen Richard husbandman 600833 600833 Alen, Richard, of Elston, husbandman 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);