names

31 rows where place_id = 635952

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3828068 1966646 1966646 defendant Wheteley Richard clerk 635952 635952 Wheteley, Richard, of Erlham, clerk 0
3874694 1981753 1981753 defendant Downyng Robert husbandman 635952 635952 Downyng, Robert, of Erlham, husbandman 2
4580253 2225310 2225310 defendant Garkere Walter   635952 635952 Garkere, Walter, of Erlham, vicar 1
4619012 2236939 2236939 defendant Large John   635952 635952 Large, John, of Erlham 7
4624708 2238711 2238711 defendant Hadlee John   635952 635952 Hadlee, John, of Erlham 0
4666900 2255378 2255378 defendant Middelton Thomas yeoman 635952 635952 Middelton, Thomas, of Erlham, yeoman 0
4666901 2255378 2255378 defendant Syngere William yeoman 635952 635952 Syngere, William, of Erlham, yeoman 1
4699431 2265280 2265280 defendant man Robert   635952 635952 man, Robert, of Erlham yeoman 3
4717503 2270811 2270811 plaintiff Aleyn Robert, sen   635952 635952 Aleyn, Robert, sen, of Erlham 0
4760715 2283693 2283693 defendant Aleyn Robert   635952 635952 Aleyn, Robert, of Erlham, franklin 2
4802311 2296912 2296912 plaintiff Aleyn Robert, senior   635952 635952 Aleyn, Robert, senior, of Erlham 0
4805076 2297789 2297789 defendant Haynes John husbandman 635952 635952 Haynes, John, of Erlham, husbandman 2
4928878 2335451 2335451 defendant Walkot Thomas   635952 635952 Walkot, Thomas, of Erlham, vicar 2
5029186 2365414 2365414 defendant Aleyn Robert gent 635952 635952 Aleyn, Robert, of Erlham, gent 1
5041530 2369069 2369069 defendant Aleyn Robert gent 635952 635952 Aleyn, Robert, of Erlham, gent 0
5115266 2390891 2390891 defendant Kempe Robert husbandman 635952 635952 Kempe, Robert, of Erlham, husbandman 1
5211878 2419214 2419214 plaintiff Aleyn Robert, senior   635952 635952 (Aleyn, Robert, senior, of Erlham 1
5231026 2424674 2424674 defendant Aleyn John gent 635952 635952 Aleyn, John, of Erlham, gent 1
5241791 2427801 2427801 defendant Wynchecombe William clerk 635952 635952 Wynchecombe, William, of Erlham, clerk 2
5251719 2430642 2430642 plaintiff Aleyn John gent 635952 635952 Aleyn, John, of Erlham, doctor of law, gent 0
5257143 2432368 2432368 defendant Aleyn John   635952 635952 Aleyn, John, of Erlham, gent, doctor of law 0
5258443 2432756 2432756 defendant Aleyn John gent 635952 635952 Aleyn, John, of Erlham, gent 0
5267980 2435749 2435749 defendant Aleyn John gent 635952 635952 Aleyn, John, of Erlham, gent 0
5267982 2435749 2435749 defendant Neuton William yeoman 635952 635952 Neuton, William, of Erlham, yeoman 2
5277182 2438413 2438413 defendant Monyment John laborer 635952 635952 Monyment, John, of Erlham, laborer 1
5286879 2441164 2441164 defendant Sawer Thomas husbandman 635952 635952 Sawer, Thomas, of Erlham, husbandman 1
5305968 2446773 2446773 plaintiff Alkyn John   635952 635952 (Alkyn, John, of Erlham, doctor 1
5311886 2448581 2448581 plaintiff Aleyn John gent 635952 635952 Aleyn, John, of Erlham, gent 0
5357947 2462551 2462551 defendant Aleyn John (legal representative) 635952 635952 Aleyn, John, of Erlham, doctor of law, gent, executrix of 1
5357948 2462551 2462551 defendant Aleyn Joan gentlewoman 635952 635952 Aleyn, Joan, of Erlham, gentlewoman 2
5482099 2499583 2499583 defendant Blake Thomas gent 635952 635952 Blake, Thomas, of Erlham, gent 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);