names

25 rows where place_id = 592384

✎ 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
3607544 1870017 1870017 defendant Chambyr Reginald gent 592384 592384 Chambyr, Reginald, of Farham, gent 0
3615731 1872561 1872561 defendant Shorter Ralph yeoman 592384 592384 Shorter, Ralph, of Farham, yeoman 1
4448577 2184483 2184483 defendant Marlere John   592384 592384 Marlere, John, of Farham 0
4466821 2190294 2190294 defendant Vermye Peter de merchant 592384 592384 Vermye, Peter de, of Farham, merchant 0
4471547 2191763 2191763 plaintiff Chadde Thomas   592384 592384 Chadde, Thomas, of Farham 0
4572582 2222960 2222960 plaintiff atte Hoke John   592384 592384 atte Hoke, John, of Farham 0
4597176 2230357 2230357 defendant Oulake Nicholas   592384 592384 Oulake, Nicholas, of Farham 0
4615922 2235977 2235977 defendant Romyn Joan   592384 592384 Romyn, Joan, of Farham 2
4626964 2239384 2239384 plaintiff Rede Alice   592384 592384 Rede, Alice, of Farham 0
4664467 2250368 2250368 plaintiff Harecourt Stephen   592384 592384 Harecourt, Stephen, of Farham 0
4675290 2257882 2257882 defendant Cutte Robert husbandman 592384 592384 Cutte, Robert, of Farham, husbandman 0
4675291 2257882 2257882 defendant Dorsey John husbandman 592384 592384 Dorsey, John, of Farham, husbandman 1
4711058 2268811 2268811 defendant Rede John dyer 592384 592384 Rede, John, of Farham, dyer 1
4774256 2287931 2287931 defendant Mulward Robert   592384 592384 Mulward, Robert, of Farham, mill ward 0
4880725 2320881 2320881 defendant Carpenter alias Bocher Walter chapman 592384 592384 Carpenter alias Bocher, Walter, of Farham, chapman 0
4924737 2334172 2334172 defendant Coke Thomas chapman 592384 592384 Coke, Thomas, of Farham, chapman 1
4928273 2335269 2335269 defendant Grelyng John merchant 592384 592384 Grelyng, John, of Farham, merchant 1
5006670 2358848 2358848 plaintiff Dybold Roger   592384 592384 Dybold, Roger, of Farham 3
5053143 2372535 2372535 defendant Levet Walter yeoman 592384 592384 Levet, Walter, of Farham, yeoman 0
5107755 2388699 2388699 defendant Clerkyson alias Godyshyll William yeoman 592384 592384 Clerkyson alias Godyshyll, William, of Farham, yeoman 0
5129989 2395258 2395258 defendant Barber John barber 592384 592384 Barber, John, of Farham, barber 1
5130153 2395304 2395304 defendant Clerkyson William yeoman 592384 592384 Clerkyson, William, of Farham, yeoman 1
5132620 2396035 2396035 defendant Henlake Robert merchant 592384 592384 Henlake, Robert, of Farham, merchant 3
5329313 2453851 2453851 defendant Cutte John courtholder 592384 592384 Cutte, John, of Farham, courtholder 0
5367390 2465455 2465455 defendant Mondy Lewis tanner 592384 592384 Mondy, Lewis, of Farham, tanner 6

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