names

30 rows where place_id = 609398

✎ 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
3678252 1919253 1919253 defendant Bentley John husbandman 609398 609398 Bentley, John, of Bassyngbourn, husbandman 0
3737756 1938030 1938030 defendant Cundall Alexander carpenter 609398 609398 Cundall, Alexander, of Bassyngbourn, carpenter 0
3761362 1945564 1945564 defendant Frankelyn alias Franke John husbandman 609398 609398 Frankelyn alias Franke, John, of Bassyngbourn, husbandman 0
3812854 1961918 1961918 defendant Byworth Richard laborer 609398 609398 Byworth, Richard, of Bassyngbourn, laborer 2
3908263 1993061 1993061 defendant Pynke Robert husbandman 609398 609398 Pynke, Robert, of Bassyngbourn, husbandman 0
3908264 1993061 1993061 defendant Pratte John carpenter 609398 609398 Pratte, John, of Bassyngbourn, carpenter 1
3908265 1993061 1993061 defendant Ayworthe alias Saunder John husbandman 609398 609398 Ayworthe alias Saunder, John, of Bassyngbourn, husbandman 2
4413228 2169008 2169008 defendant Toryngton John de   609398 609398 Toryngton, John de, of Bassyngbourn, vicar 1
4425520 2172808 2172808 plaintiff Martyn Warin   609398 609398 Martyn, Warin, of Bassyngbourn 0
4425526 2172809 2172809 plaintiff Martyn Warin   609398 609398 Martyn, Warin, of Bassyngbourn 0
4499334 2200443 2200443 plaintiff Hamond William   609398 609398 Hamond, William, of Bassyngbourn, son of Robert, on his own account 0
4499336 2200443 2200443 defendant Gossom Geoffrey   609398 609398 Gossom, Geoffrey, of Bassyngbourn 1
4559143 2218811 2218811 defendant Gamyn John   609398 609398 Gamyn, John, of Bassyngbourn 1
4649610 2245918 2245918 defendant Bate John   609398 609398 Bate, John, of Bassyngbourn 0
4651304 2246413 2246413 defendant Hale John husbandman 609398 609398 Hale, John, of Bassyngbourn, husbandman 2
4651305 2246413 2246413 defendant Clerk William husbandman 609398 609398 Clerk, William, of Bassyngbourn, husbandman 3
4728813 2274250 2274250 defendant Prentys William husbandman 609398 609398 Prentys, William, of Bassyngbourn, husbandman 2
4918576 2332326 2332326 defendant Molt Thomas husbandman 609398 609398 Molt, Thomas, of Bassyngbourn, husbandman 0
5106697 2388384 2388384 defendant Derlyng John husbandman 609398 609398 Derlyng, John, of Bassyngbourn, husbandman 4
5238841 2426949 2426949 defendant Drury William carpenter 609398 609398 Drury, William, of Bassyngbourn, carpenter 4
5323329 2452056 2452056 defendant Noreys John tailor 609398 609398 Noreys, John, of Bassyngbourn, tailor 0
5326478 2453004 2453004 defendant Rameryk John carpenter 609398 609398 Rameryk, John, of Bassyngbourn, carpenter 0
5362573 2463942 2463942 defendant Norreys Robert tailor 609398 609398 Norreys, Robert, of Bassyngbourn, tailor 0
5362574 2463942 2463942 defendant Norreys Anne widow 609398 609398 Norreys, Anne, of Bassyngbourn, widow 1
5362575 2463942 2463942 defendant Norreys Richard chapman 609398 609398 together with Norreys, Richard, of Bassyngbourn, chapman 2
5481848 2499505 2499505 plaintiff Gery Thomas   609398 609398 Gery, Thomas, of Bassyngbourn 0
5607627 2537282 2537282 defendant Frank John thatcher 609398 609398 (Frank, John, of Bassyngbourn, thatcher 1
5636341 2555322 2555322 defendant Hebbe John husbandman 609398 609398 Hebbe, John, of Bassyngbourn, husbandman 0
5636342 2555322 2555322 defendant Welle John husbandman 609398 609398 Welle, John, of Bassyngbourn, husbandman 1
5636343 2555322 2555322 defendant Valantyn Robert husbandman 609398 609398 Valantyn, Robert, of Bassyngbourn, husbandman 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);