names

34 rows where place_id = 603642

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3655229 1911892 1911892 defendant Flegge Peter husbandman 603642 603642 Flegge, Peter, of North Barsham, husbandman 0
3826682 1966193 1966193 defendant Wryght Thomas laborer 603642 603642 Wryght, Thomas, of North Barsham, laborer 0
3904428 1991727 1991727 defendant Watson John husbandman 603642 603642 Watson, John, of North Barsham, husbandman 0
3904707 1991832 1991832 defendant Smyth William husbandman 603642 603642 Smyth, William, of North Barsham, husbandman 2
3931530 2000845 2000845 defendant Partrik Thomas husbandman 603642 603642 Partrik, Thomas, of North Barsham, husbandman 2
3936275 2002460 2002460 defendant Smyth William warrener 603642 603642 Smyth, William, of North Barsham, warrener 2
3936276 2002460 2002460 defendant Partrycke Thomas husbandman 603642 603642 Partrycke, Thomas, of North Barsham, husbandman 3
3944429 2005152 2005152 defendant Smyth William yeoman 603642 603642 Smyth, William, of North Barsham, yeoman 2
4060015 2045979 2045979 defendant Godfrey Robert gent 603642 603642 Godfrey, Robert, of North Barsham, gent 0
4326506 2139227 2139227 defendant Peray Edward gent 603642 603642 Peray, Edward, of North Barsham, gent 0
4385459 2159827 2159827 defendant Growte Edward yeoman 603642 603642 Growte, Edward, of North Barsham, yeoman 0
4385463 2159828 2159828 defendant Growte Edward yeoman 603642 603642 Growte, Edward, of North Barsham, yeoman 0
4391207 2161676 2161676 defendant Allyard Thomas husbandman 603642 603642 Allyard, Thomas, of North Barsham, husbandman 0
4467504 2190517 2190517 plaintiff Austyn Richard   603642 603642 Austyn, Richard, of North Barsham 3
4713864 2269661 2269661 defendant Smyth Richard smith 603642 603642 Smyth, Richard, of North Barsham, smith 0
4729823 2274531 2274531 plaintiff Lokere Edmund   603642 603642 Lokere, Edmund, of North Barsham 0
4732114 2275226 2275226 defendant Kent Peter   603642 603642 Kent, Peter, of North Barsham, the butcher 0
4761057 2283808 2283808 defendant Stanhale Nicholas yeoman 603642 603642 Stanhale, Nicholas, of North Barsham, yeoman 0
4761358 2283896 2283896 defendant atte Chirche Nicholas gent 603642 603642 atte Chirche, Nicholas, of North Barsham, gent 0
4790883 2293239 2293239 plaintiff atte Chirche Nicholas   603642 603642 atte Chirche, Nicholas, of North Barsham 1
4796937 2295197 2295197 defendant Sebyll Nicholas yeoman 603642 603642 Sebyll, Nicholas, of North Barsham, yeoman 2
4822625 2303153 2303153 defendant Bedon Robert husbandman 603642 603642 Bedon, Robert, of North Barsham, husbandman 0
4822626 2303153 2303153 defendant Gilberd John yeoman 603642 603642 Gilberd, John, of North Barsham, yeoman 1
4901244 2326997 2326997 defendant Boweman John   603642 603642 Boweman, John, of North Barsham, shepherd 1
4928296 2335276 2335276 defendant Kyrre William clerk 603642 603642 Kyrre, William, of North Barsham, clerk 0
5269442 2436160 2436160 defendant Coton John clerk & parson 603642 603642 Coton, John, of North Barsham, clerk & parson 0
5273116 2437208 2437208 defendant Cotton John   603642 603642 Cotton, John, of North Barsham, parson 1
5304427 2446322 2446322 defendant Cotton John clerk 603642 603642 Cotton, John, of North Barsham, clerk 1
5331846 2454605 2454605 defendant Denston Robert laborer 603642 603642 Denston, Robert, of North Barsham, laborer 0
5335283 2455621 2455621 defendant Caly William gent 603642 603642 Caly, William, of North Barsham, gent 0
5363744 2464312 2464312 defendant Caly William gent 603642 603642 Caly, William, of North Barsham, gent 6
5536605 2515935 2515935 defendant Heyward James husbandman 603642 603642 Heyward, James, of North Barsham, husbandman 2
5546446 2518961 2518961 plaintiff Tolle James (legal representative) 603642 603642 Tolle, James, of North Barsham, executrix of 0
5636387 2555339 2555339 defendant Cat Robert mercer 603642 603642 Cat, Robert, of North Barsham, mercer 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);