names

33 rows where place_id = 599640

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3637573 1906562 1906562 defendant Keysey John husbandman 599640 599640 Keysey, John, of Wood Norton, husbandman 3
3693713 1924227 1924227 defendant Lowth John husbandman 599640 599640 Lowth, John, of Wood Norton, husbandman 0
3693715 1924227 1924227 defendant Holley Andrew husbandman 599640 599640 Holley, Andrew, of Wood Norton, husbandman 2
3699325 1926005 1926005 defendant Nicholl Thomas butcher 599640 599640 Nicholl, Thomas, of Wood Norton, butcher 1
3850139 1973634 1973634 defendant Holley Andrew, senior husbandman 599640 599640 Holley, Andrew, senior, of Wood Norton, husbandman 0
3938228 2003124 2003124 plaintiff Potter John   599640 599640 Potter, John, of Wood Norton 0
3946326 2005789 2005789 defendant Barsham William yeoman 599640 599640 Barsham, William, of Wood Norton, yeoman 0
3949039 2006730 2006730 defendant Sheryngham Christopher yeoman 599640 599640 Sheryngham, Christopher, of Wood Norton, yeoman 0
3980892 2017928 2017928 plaintiff Potter John (legal representative) 599640 599640 Potter, John, of Wood Norton, gent, executors of 0
3988143 2020504 2020504 defendant Robert Richard husbandman 599640 599640 Robert, Richard, of Wood Norton, husbandman 0
4032165 2036174 2036174 plaintiff Fytte Thomas glover 599640 599640 Fytte, Thomas, of Wood Norton, glover 0
4043494 2040132 2040132 defendant Robert John husbandman 599640 599640 Robert, John, of Wood Norton, husbandman 0
4043495 2040132 2040132 defendant Robert Robert husbandman 599640 599640 Robert, Robert, of Wood Norton, husbandman 1
4043555 2040155 2040155 plaintiff Potter John (legal representative) 599640 599640 Potter, John, of Wood Norton, gent, administrator of 0
4056613 2044754 2044754 defendant Johnson George gent 599640 599640 Johnson, George, of Wood Norton, gent 0
4079266 2052887 2052887 plaintiff Trace Christopher yeoman 599640 599640 Trace Christopher, of Wood Norton, yeoman 0
4112857 2064866 2064866 defendant Brown Edmund butcher 599640 599640 Brown, Edmund, of Wood Norton, butcher 0
4128815 2070599 2070599 defendant Browne Edmund butcher 599640 599640 Browne, Edmund, of Wood Norton, or of Wymondham, butcher 0
4390670 2161493 2161493 defendant Tyler Peter gent 599640 599640 Tyler, Peter, of Wood Norton, gent 1
4551474 2216401 2216401 defendant Marche John   599640 599640 Marche, John, of Wood Norton 0
4699511 2265300 2265300 defendant Marche John husbandman 599640 599640 Marche, John, of Wood Norton, husbandman 0
4702073 2266057 2266057 defendant Cosyn Thomas yeoman 599640 599640 Cosyn, Thomas, of Wood Norton, yeoman 0
4702074 2266057 2266057 defendant Bulman William   599640 599640 Bulman, William, of Wood Norton 1
4702077 2266057 2266057 defendant Bekeswell Peter laborer 599640 599640 Bekeswell, Peter, of Wood Norton, laborer 4
4714405 2269834 2269834 defendant Crane John gent 599640 599640 Crane, John, of Wood Norton, gent 0
4720919 2271876 2271876 defendant Bulman William yeoman 599640 599640 Bulman, William, of Wood Norton, yeoman 1
4776094 2288519 2288519 defendant Stowyl Robert yeoman 599640 599640 Stowyl, Robert, of Wood Norton, yeoman 0
4833907 2306613 2306613 defendant Skenle Thomas yeoman 599640 599640 Skenle, Thomas, of Wood Norton, yeoman 2
5188140 2412246 2412246 defendant Gebons William yeoman 599640 599640 Gebons, William, of Wood Norton, yeoman 0
5299309 2444770 2444770 defendant Hoke Richard husbandman 599640 599640 Hoke, Richard, of Wood Norton, husbandman 0
5389014 2471911 2471911 defendant Holle William yeoman 599640 599640 Holle, William, of Wood Norton, , yeoman 4
5394315 2473440 2473440 defendant Shymmyng John clerk 599640 599640 Shymmyng, John, of Wood Norton, clerk 2
5420746 2481130 2481130 defendant Shymmyng John clerk 599640 599640 Shymmyng, John, of Wood Norton, clerk 2

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